Ahhhhhhhhh! Can I get some help with PHP+MySQL please?

[Entity]

Ok, guys, I've been working forever on this project, and am this close (gesturing with fingers) to getting everything to properly work. Unfortunately, I still have those last few steps to go. Here's what has happened so far...

On my University of Washington student account, I've compiled php and installed mysql. This is running AIX. PHP appears to be running just fine, and mysql works for everything that I need to do from the commandline. Essentially, I know that PHP and MySQL are working independently. I compiled PHP support in MySQL, and have edited my php.ini file to reflect the location of my mysql.sock socket. I know that PHP+MySQL can work, but I just haven't been able to get that last step. Here's an example of a student's website that has it working (I emailed him, but haven't got a response from him yet).

Working Example

My phpinfo()

This is the error I get when I try to run anything that uses MySQL+PHP:

Warning: Can't connect to local MySQL server through socket '/da26/d29/robcole/mysql.sock'

I have the socket in the /da26/d29/robcole directory. Like I said, mysql works fine from the commandline with the socket=/da26/d29/robcole/mysql.sock entry in .my.cnf.

Can anyone help?

thanks,
Rob

 

[777php]

you need to make sure that the mysql server is running.....put it in the init.d folder so that it starts as soon as you boot. Perhaps you need to write protect the mysql.sock file if it is located in your tmp folder?

 

[Entity]

It is running.

I'm not root on this box, so there is no putting in of the init.d folder; the box stays up all the time, and allows server daemons.

Rob

 

[kt]

Did you compiled PHP with mySQL support?

 

[mundania]

check your php.ini file

your socket doesn't sound like the default socket... so you need to specify that where it says:

mysql.default_socket =

If you set it up with default configurations... that above line will appear just like that.

so in your case:

mysql.default_socket = /da26/d29/robcole/mysql.sock

try that...

 

[Entity]

<< Did you compiled PHP with mySQL support? >>


Yeah, I did...


<< mysql.default_socket = /da26/d29/robcole/mysql.sock >>


Yeah, that is where the socket is located...its my home directory on the students server.

Rob