CMS Made Simple Forums

We are getting the following intermittent error messages on lots of sites hosted on the same server but with different domain names.

I have no idea what they mean:

Warning: mysql_real_escape_string(): Access denied for user
'nobody'@'localhost' (using password: NO) in
/home/aiaaa/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc
on line 174

Warning: mysql_real_escape_string(): A link to the server could not be
established in
/home/aiaaa/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc
on line 174

Warning: mysql_real_escape_string(): Access denied for user
'nobody'@'localhost' (using password: NO) in
/home/aiaaa/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc
on line 174

Warning: mysql_real_escape_string(): A link to the server could not be
established in
/home/aiaaa/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc
on line 174

Warning: mysql_real_escape_string(): Access denied for user
'nobody'@'localhost' (using password: NO) in
/home/aiaaa/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc
on line 174

etc etc etc

Any ideas?

I've gotten those too, but only after I've cleared the cache, which leads me to think there's some things in there that are necessary for database updates.

-K

"Access denied for user 'nobody'@'localhost' (using password: NO)"

is the key, basically mysql server says this user "nobody" without a password has no rights to the database. check your config.php

That's what I thought. But this is an account that's been set up for a while with users and passwords, and the user who got this message has a valid acount.

own server or some hosting?

if it is a hosting server I would bet they wont allow logins to mysql without a password and most probably username should be something like "customername_db".

take the username and password from config.php and from shell say something like "mysql -uUSERNAMEFROMCONFIG.PHP -p DATABASENAME" it asks for a password again supply the one from config.php.

if it works then there is something interesting happening, if it doesnt double check those usernames and passwords.

if its own dedicated server I would strongly suggest on creating users for mysql (and setting passwords for them)

Hi,

We have a dedicated server.

I sent the same query to the server's tech guys and this is what they said,

*********************

This error basically means that the user nobody has not been permitted to
access a
database without using a password:

> Warning: mysql_real_escape_string(): Access denied for user
> 'nobody'@'localhost' (using password: NO) in
> /home/aiaaa/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc
> on line 174

Who provided this PHP code in adodb_lite? I found what looks like the config
(config.functions.php) and it shows these details:

      #Database connection information
      $config["dbms"] = "mysql";
      $config["db_hostname"] = "localhost";
      $config["db_username"] = "cms";
      $config["db_password"] = "cms";
      $config["db_name"] = "cms";

********************************

I installed the cms (version 0.12) but simply uploaded all the files - I didn't fiddle with anything as I'm php-impaired!!!

Is there any fix for this? What should I delete/add?