topic Re: Fatal Error on MySql in Operating System - Linux

Fatal Error on MySql

Ng King Wang — Wed, 18 Jun 2003 13:24:06 GMT

Hi all,

I use RedHat 8.0 as web server with PHP and MySql as below:
php-4.2.2-8.0.5
mysql-server-3.23.52-3

My colleague uploaded a lot of PHP files to the web server recently. When we tried to access our default web page, an error message is displayed as below:

Fatal error: Call to undefined function: mysql_connect() in /home/surathin/public_html/includes/functions/database.php on line 19

My colleague and I have no idea on this error. Any idea or solution on this error?

Thanks in advance.

Re: Fatal Error on MySql

Steven E. Protter — Wed, 18 Jun 2003 13:57:50 GMT

Restore the dtabase.php file from backup.

Be more careful in the future.

If not an option, get the php file from another server.

Post the php file if its not to big. What's on line 18 or 19?

SEP

Re: Fatal Error on MySql

Jerome Henry — Wed, 18 Jun 2003 14:03:32 GMT

Did you install php-mysql package, linking php to mysql ?
Get it here :
http://rpmseek.com/rpm-pl/php-mysql.html?hl=com&cs=php-mysql:PN:0:0:0

Check also that both are started, with service mysqld restart, service httpd restart.

J

Re: Fatal Error on MySql

Ng King Wang — Thu, 19 Jun 2003 01:05:52 GMT

Steven and Jerome, thank you for all your replies.

I tried to install "php-mysql-4.2.2-8.0.5.i386.rpm" as follows:

[root@es1 dng]# rpm -ivh php-mysql-4.2.2-8.0.5.i386.rpm
warning: php-mysql-4.2.2-8.0.5.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60
e
Preparing... ########################################### [100%]
1:php-mysql ########################################### [100%]
[root@es1 dng]#

After rebooting the web server, i checked the module as below:

[root@es1 dng]# rpm -qa "php-mysql*"
php-mysql-4.2.2-8.0.5
[root@es1 dng]#

Then, I tried to access the default web page, the error message I posted before is disappeared. 2 new warning messages are displayed as below:

Warning: Access denied for user: 'surathin@localhost' (Using password: YES) in /home/surathin/public_html/includes/functions/database.php on line 19

Warning: MySQL Connection Failed: Access denied for user: 'surathin@localhost' (Using password: YES) in /home/surathin/public_html/includes/functions/database.php on line 19
Unable to connect to database server!

Attached file is "database.php". Any idea or solution? Please help.

Re: Fatal Error on MySql

Ng King Wang — Thu, 19 Jun 2003 01:06:38 GMT

Re: Fatal Error on MySql

Stuart Browne — Thu, 19 Jun 2003 01:55:58 GMT

It sounds as if the 'user' and 'db' tables in your 'mysql' database are a bit off.

Check the username/password that are listed in 'database.php', then check the tokens that are in the mysql table, and see if they match.

("select password('yourpaswd'), password from user where user = 'yourusername';, and make sure that the two match).

Re: Fatal Error on MySql

Jerome Henry — Thu, 19 Jun 2003 11:29:06 GMT

And do not forget that passwords are encrypted in mysql Linux, so adding a new user would be '... values ('localhost', 'username', 'password(yourpass)', 'Y',...)
check this password(yourpassword) way of precising the password.
J

Re: Fatal Error on MySql

Ng King Wang — Fri, 20 Jun 2003 00:52:11 GMT

My colleague told me that he can run the PHP files and MySql on another server successfully.

My colleague and I believe that all problems are from our server. Once we solve all problems, I will let you all know the good news.

Re: Fatal Error on MySql

Balaji N — Fri, 20 Jun 2003 10:01:44 GMT

hi
is the database instance up and running and do u have correct access permissions.

-balaji

Re: Fatal Error on MySql

Ng King Wang — Thu, 26 Jun 2003 05:59:10 GMT

Hello all,

My colleague adjusted the user permission on MySql database. Warning message disappeared.

Thanks all.

Re: Fatal Error on MySql

Jerome Henry — Fri, 27 Jun 2003 11:49:43 GMT

Glad it worked !!
:]]

J