mysql_connect() error message

[Anon]

I'm trying to connect to a mysql database using:

// create connection
$connection = mysql_connect("localhost","root","champsyd01") or die ("Couldn't connect to server.");

and getting the error:

"Fatal error: Call to unsupported or undefined function mysql_connect() in /home/httpd/html/jon/createtable2/step3.php3 on line 25"

I can suppress it, but the script still burps. Is php not installed or configured correctly. Is mysql stuff not available due to a problem with its install or config?

the admin and I are both novice at admin issues and the install of both php and mysql has been a chore.

a phpinfo() dump can be found at: http://danmccomb.com/jon/info/phpinfo.php

[[deleted]]

Manuals are your friend. Read them.

The error should be a hint that this PHP was not compiled "with mysql" 🙂

read the install section of the manual again and try configuring PHP again.
The manual clearly states: "--with-mysql=DIR"
But the default MySQL stuff is included in the PHP source, so try

"--with-mysql"

instead of

"--with-mysql=shared"

[Anon]

I changed the code to:
$connection = mysql_connect("localhost","root","champsyd01") or die (mysql_error()); );

note the mysql_error() function

and got:
Parse error: parse error in /home/httpd/html/jon/createtable2/step3.php3 on line 27

[Anon]

Surely it's a snap for you vincent, but if it was a snap for me, I wouldn't be asking.

Please understand that I am not doing the install. I am trying to help the admin out. Second, I am not an admin at ALL, so I don't follow some of the clues here. Are you saying to recompile? If not, what file am I going to?

[yelvington]

Vincent is right; the problem is that the current installation of PHP on that machine does not support PHP directly. Instead, it has been compiled with "shared" mysql support, and it's not finding a shared library.

It looks like you're running some version of RedHat on a MacPPC.

Personally, here's how I'd fix this:

1. Make sure you have the apache-dev RPM installed. This supplies the "apxs" utility.

2. Get the current PHP sources. You're running an old version anyway. Unpack them.

3. Read the INSTALL file and follow the directions.

You don't have to recompile Apache or anything; you just need to recompile PHP and install it as an Apache dynamic module.

All of this sounds a lot harder and more time-consuming than it really is. Once you've untarred the sources, it only takes about five minutes to do the PHP upgrade.

[Anon]

It's Yellow Dog!

Thanks for the tip's! Much appreaciated. I'll pass it on.

[Anon]

Change your code:

$connection = mysql_connect("localhost","root","champsyd01") or die (mysql_error()); );

to this

$connection = mysql_connect("localhost","root","champsyd01") or die (mysql_error());

You had an extra );

Bruce

[Anon]

The site admin has recompiled the php modual and may or maynot have followed these last directions, but the error message has now changed:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/httpd/html/jon/createtable2/step3.php3 on line 27

Help appreciated!

[Anon]

hi all,

i am newbie in php and mysql and have such errors as Jon:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/mywww/do_sql.php on line 13

help my please,

e-mail: [e-mail]
icq: 38685640

[[deleted]]

Is your MySQL running?

[Anon]

yes. I am connected via telnet to mysql.

[Anon]

I try coonect as root (in my php script). maybe I must connect as another user?

p.s. sorry for my english

[Anon]

I believe so. My partner in crime is the actual admin on site and has commented that their where several instances of it running.

[brandonschnell]

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/mywww/do_sql.php on line 13

1) check to be sure that the file /var/lib/mysql/mysql.sock is there,

2)check the permissions to the directory and also on the mysql.sock file. i had this error till i gave full access to the mysql.sock file and read access to the var, lib, & mysql dir, give everything else in the mysql directory full access only to the user that mysql is running as and remove all other permissions.

chmod +rx /var
chmod +rx /var/lib
chmod -R 700 /var/lib/mysql
chmod +rx /var/lib/mysql
chmod 766 /var/lib/mysql/mysql.sock

this may not be the best way to do this and i'd be interested if there are any potential security issues by doing this.

[Anon]

thanks, its realy helps!