Are these errors server problems or cms problems?

[sioux]

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?

[Kayin]

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

[tsw]

"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

[sioux]

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.

[tsw]

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)

[sioux]

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?