Hi Tom,

This problem is happened to me with special character on snmp community string too.

after I  put  single quote to the commumity string while I am adding new host and is working fine and I can addhost normally.

That why I am sure with  this ./adduser.php problem.

Best Regards.

From: Tom Laermans [mailto:tom.laermans@powersource.cx]
Sent: Sunday, April 14, 2013 1:55 PM
To: tang@movaci.com; Observium Network Observation System
Subject: Re: [Observium] adduser.php giving mysql error

On 14/04/2013 8:52, Kamoltorn Theppunya (Tang) wrote:

It’s caused of special character in your mysql’s password.

There have 2 solutions that I have solved.

1. Change you mysql password not to use character like &%*)%  

2. If you don’t want to change password try to use single quote in password term like this

./adduser.php user ‘yourpa$$word’ 1

I'm having a hard time connecting solution 1 to solution 2 to the actual cause.

- Using a different password for your Observium user makes no difference for the MySQL connection.
- Special characters in your MySQL password should be no problem.

The real reason:

// Database config
$config['db_host'] = "localhost";
$config['db_user'] = "USERNAME";
$config['db_pass'] = "PASSWORD";
$config['db_name'] = "observium";

You did not configure the database credentials correctly. (and will not have a database import through the sql schema updater, as it could not have connected to MySQL as well)

Tom

Best Regards.

From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Ben .T.George
Sent: Sunday, April 14, 2013 1:35 PM
To: observium@observium.org
Subject: [Observium] adduser.php giving mysql error

HI Mailing List

i followed http://www.observium.org/wiki/RHEL_SVN_Installation this tutorial.

when i run ./adduser.php <username> <password> 1

i am getting mysql error like below

<h2> observer MySQL Error</h2> Access denied for user 'USERNAME'@'localhosr ' (using password: YES)

for me the below mysql table creation and access giving was successful. I used below command

 mysql -u root -p
  <mysql root password>
  mysql> CREATE DATABASE observium;
  mysql> GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost'
   -> IDENTIFIED BY '<observium db password>';

Thanks & Regards,
Ben

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium