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@observium.org
Hi,
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
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
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
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 [mailto:observium-bounces@observium.org] On Behalf Of Ben .T.George Sent: Sunday, April 14, 2013 1:35 PM To: observium@observium.org mailto: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 mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Ben .T.George -
Kamoltorn Theppunya (Tang) -
Tom Laermans