PHP + MYSQL + DW

[tholmes]

Hi Folks:

I am trying to connect to the database and keep getting a 500 internal server error. here is the setup

Database server -- mysql 4.1 (linux) on a gentoo linux server -- IP 192.168.0.10 -- srvdb-01
Webserver - Apache2 + PHP 5 on Gentoo Linux server 192.168.0.29 - srvweb-03

I have all the connections ready to go, dav is moving files etc, but when i try to create a database connection, i keep getting the following error


> PROPFIND /_mmServerScripts HTTP/1.1
> Authorization: Basic dGhvbG1lczp0eXBob29u
> User-Agent: Contribute/3.0
> Host: inventory.mcaschool.net
> Pragma: no-cache
> Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*
> MIME-Version: 1.0
> Content-Type: text/xml
> Content-Length: 134
> Depth: 0
> Connection: Keep-Alive
< HTTP/1.1 500 Internal Server Error
< Date: Tue, 25 Apr 2006 21:09:54 GMT
< Server: Apache
< Content-Length: 607
< Connection: close
< Content-Type: text/html; charset=iso-8859-1

(copied from the DW8 FTP LOG)

I am really baffled by this problem -- can someone please point me in the direction of a solution?

thanks


Tim Holmes

IT MANAGER - Medina Christian Academy

[Newsgroup_User]

localhost in MySQL server connection??

[tholmes]

No, because the mysql server is not on the local host -- its on a separate server having address 192.168.0.10

TIM

[Newsgroup_User]

just to be sure, if MySQL is on same server as webserver, try localhost.
if MySQL on separate server than webserver- I have never gotten it to
work, but I know some people have.

tholmes@mcaschool.net wrote:
> No, because the mysql server is not on the local host -- its on a separate server having address 192.168.0.10
>
> TIM

[Newsgroup_User]

Use the IP address....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================


"New Guy" <Newguy@hotmail.com> wrote in message
news:e2qql0$d9d$1@forums.macromedia.com...
> just to be sure, if MySQL is on same server as webserver, try localhost.
> if MySQL on separate server than webserver- I have never gotten it to
> work, but I know some people have.
>
> tholmes@mcaschool.net wrote:
>> No, because the mysql server is not on the local host -- its on a
>> separate server having address 192.168.0.10
>>
>> TIM

[tholmes]

Hi murry -- thanks for your response -- i currently am using the IP of the MySQL server in the setup box. it still does not work

TIM