Re: [Observium] adduser.php giving mysql error

HI

Thanks for the replay. i solved the issue by rerunning the DB table setup script

Thanks & Regards, Ben

On Sun, Apr 14, 2013 at 1:34 PM, Tom Laermans tom.laermans@powersource.cxwrote:

You don't have the database tables set up.

On 14/04/2013 11:35, Ben .T.George wrote:

HI

Thanks for the reply..i changed database variables on config.php file and the above error got solved.

now i am getting some other error.

# ./adduser.php ben redhat 1

User ben creation failed !

please help me to solve this issue.

Thanks & Regards, Ben

On Sun, Apr 14, 2013 at 9:55 AM, Tom Laermans < tom.laermans@powersource.cx> wrote:

...

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 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 listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium

---

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

---

observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium