Access denied for user 'root'@'localhost' (using password: NO)
Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database.
root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)
Have done this regularly, but it seems it lost its config on root permisions on the DB
I have different passwords on my root and root for MySQL
I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root.
Any clues?
Is there a scipt for roolback?
Best regards Einar
Hi.
By first, pls show your versions: ./discovery.php -VV
Second show your config options (hide pass from output): cat config.php | grep db
Also check permissions to files. ls -l /opt/observium/config.php
On 08.06.15 12:58, Einar Storeng wrote:
Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database.
root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)
Have done this regularly, but it seems it lost its config on root permisions on the DB
I have different passwords on my root and root for MySQL
I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root.
Any clues?
Is there a scipt for roolback?
Best regards Einar
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Thank you for you answer. I can't give you this information because it seems my config is lost. Somehow the config files is missing, probably to a fault somewhere.
I tried the upgrade twice due to a "to quick" decision so the backup is lost also. My fault, my regret.
Than you for you help anyways.
Best regards Einar
On Mon, Jun 8, 2015 at 12:13 PM, Mike Stupalov mike@observium.org wrote:
Hi.
By first, pls show your versions: ./discovery.php -VV
Second show your config options (hide pass from output): cat config.php | grep db
Also check permissions to files. ls -l /opt/observium/config.php
On 08.06.15 12:58, Einar Storeng wrote:
Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database.
root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)
Have done this regularly, but it seems it lost its config on root permisions on the DB
I have different passwords on my root and root for MySQL
I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root.
Any clues?
Is there a scipt for roolback?
Best regards Einar
observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalovhttp://observium.org
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Yes, this error message happens if you don't have the mysql stuff configured. Which you didn't as apparently you lost your config.php...
Tom
On 06/08/2015 12:43 PM, Einar Storeng wrote:
Thank you for you answer. I can't give you this information because it seems my config is lost. Somehow the config files is missing, probably to a fault somewhere.
I tried the upgrade twice due to a "to quick" decision so the backup is lost also. My fault, my regret.
Than you for you help anyways.
Best regards Einar
On Mon, Jun 8, 2015 at 12:13 PM, Mike Stupalov <mike@observium.org mailto:mike@observium.org> wrote:
Hi. By first, pls show your versions: ./discovery.php -VV Second show your config options (hide pass from output): cat config.php | grep db Also check permissions to files. ls -l /opt/observium/config.php On 08.06.15 12:58, Einar Storeng wrote:Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database. root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO) Have done this regularly, but it seems it lost its config on root permisions on the DB I have different passwords on my root and root for MySQL I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root. Any clues? Is there a scipt for roolback? Best regards Einar _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium-- Mike Stupalov http://observium.org _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Phew... Lucky me found an older backup of the /opt/observium folder. Back in business, and will dig into mysql stuff. I have not changed mysql settings since it was fresh installed, so something went wrong. Does not mater now, i have to sort it in some other way.
Thank you all.
Best regards
On Mon, Jun 8, 2015 at 12:54 PM, Tom Laermans tom.laermans@powersource.cx wrote:
Yes, this error message happens if you don't have the mysql stuff configured. Which you didn't as apparently you lost your config.php...
Tom
On 06/08/2015 12:43 PM, Einar Storeng wrote:
Thank you for you answer. I can't give you this information because it seems my config is lost. Somehow the config files is missing, probably to a fault somewhere.
I tried the upgrade twice due to a "to quick" decision so the backup is lost also. My fault, my regret.
Than you for you help anyways.
Best regards Einar
On Mon, Jun 8, 2015 at 12:13 PM, Mike Stupalov mike@observium.org wrote:
Hi.
By first, pls show your versions: ./discovery.php -VV
Second show your config options (hide pass from output): cat config.php | grep db
Also check permissions to files. ls -l /opt/observium/config.php
On 08.06.15 12:58, Einar Storeng wrote:
Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database.
root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)
Have done this regularly, but it seems it lost its config on root permisions on the DB
I have different passwords on my root and root for MySQL
I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root.
Any clues?
Is there a scipt for roolback?
Best regards Einar
observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalovhttp://observium.org
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi All, we have the same problem after upgrade to the new ver. i run this command : root@observium /opt/observium# ./discovery.php -VV MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)
root@observium /opt/observium# cat config.php.default | grep db $config['db_host'] = 'localhost'; $config['db_user'] = 'USERNAME'; $config['db_pass'] = 'PASSWORD'; $config['db_name'] = 'observium'
root@observium /opt/observium# ls -l /opt/observium/config.php.default -rw-rw-r-- 1 1000 certssl 1031 Nov 4 2014 /opt/observium/config.php.default
thanks for your help br hayim
On Mon, Jun 8, 2015 at 1:43 PM Einar Storeng einar.storeng@gmail.com wrote:
Thank you for you answer. I can't give you this information because it seems my config is lost. Somehow the config files is missing, probably to a fault somewhere.
I tried the upgrade twice due to a "to quick" decision so the backup is lost also. My fault, my regret.
Than you for you help anyways.
Best regards Einar
On Mon, Jun 8, 2015 at 12:13 PM, Mike Stupalov mike@observium.org wrote:
Hi.
By first, pls show your versions: ./discovery.php -VV
Second show your config options (hide pass from output): cat config.php | grep db
Also check permissions to files. ls -l /opt/observium/config.php
On 08.06.15 12:58, Einar Storeng wrote:
Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database.
root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)
Have done this regularly, but it seems it lost its config on root permisions on the DB
I have different passwords on my root and root for MySQL
I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root.
Any clues?
Is there a scipt for roolback?
Best regards Einar
observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalovhttp://observium.org
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
config.php.default is not used, you need to use config.php.
If you actually upgraded, and you followed the upgrade instructions, everything would just work, as your old config.php is copied from the previous version...
Tom
On 06/08/2015 12:56 PM, hayim siloni wrote:
Hi All, we have the same problem after upgrade to the new ver. i run this command : root@observium /opt/observium# ./discovery.php -VV MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)
root@observium /opt/observium# cat config.php.default | grep db $config['db_host'] = 'localhost'; $config['db_user'] = 'USERNAME'; $config['db_pass'] = 'PASSWORD'; $config['db_name'] = 'observium'
root@observium /opt/observium# ls -l /opt/observium/config.php.default -rw-rw-r-- 1 1000 certssl 1031 Nov 4 2014 /opt/observium/config.php.default
thanks for your help br hayim
On Mon, Jun 8, 2015 at 1:43 PM Einar Storeng <einar.storeng@gmail.com mailto:einar.storeng@gmail.com> wrote:
Thank you for you answer. I can't give you this information because it seems my config is lost. Somehow the config files is missing, probably to a fault somewhere. I tried the upgrade twice due to a "to quick" decision so the backup is lost also. My fault, my regret. Than you for you help anyways. Best regards Einar On Mon, Jun 8, 2015 at 12:13 PM, Mike Stupalov <mike@observium.org <mailto:mike@observium.org>> wrote: Hi. By first, pls show your versions: ./discovery.php -VV Second show your config options (hide pass from output): cat config.php | grep db Also check permissions to files. ls -l /opt/observium/config.php On 08.06.15 12:58, Einar Storeng wrote:Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database. root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO) Have done this regularly, but it seems it lost its config on root permisions on the DB I have different passwords on my root and root for MySQL I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root. Any clues? Is there a scipt for roolback? Best regards Einar _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium-- Mike Stupalov http://observium.org _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Huh..
Correct upgrade procedure, see here: http://www.observium.org/wiki/Upgrading#Upgrade_to_latest_Major_release
cd /opt mv observium observium_old wget http://www.observium.org/observium-community-latest.tar.gz tar zxvf observium-community-latest.tar.gz mv /opt/observium_old/rrd observium/ mv /opt/observium_old/*log* observium/ *mv /opt/observium_old/config.php observium/*
On 08.06.15 13:43, Einar Storeng wrote:
Thank you for you answer. I can't give you this information because it seems my config is lost. Somehow the config files is missing, probably to a fault somewhere.
I tried the upgrade twice due to a "to quick" decision so the backup is lost also. My fault, my regret.
Than you for you help anyways.
Best regards Einar
On Mon, Jun 8, 2015 at 12:13 PM, Mike Stupalov <mike@observium.org mailto:mike@observium.org> wrote:
Hi. By first, pls show your versions: ./discovery.php -VV Second show your config options (hide pass from output): cat config.php | grep db Also check permissions to files. ls -l /opt/observium/config.php On 08.06.15 12:58, Einar Storeng wrote:Hi. After trying to upgrade to Community Edition version 0.15.6 i cant update the database. root@observium /# /opt/observium/discovery.php -h all MySQL Error: Access denied for user 'root'@'localhost' (using password: NO) Have done this regularly, but it seems it lost its config on root permisions on the DB I have different passwords on my root and root for MySQL I have no problem logging in to the web admin for PHPMyAdmin with my Mysql password for root. Any clues? Is there a scipt for roolback? Best regards Einar _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium-- Mike Stupalov http://observium.org _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
On Mon, 08 Jun 2015 or thereabouts, Mike Stupalov came forth with:
Huh..
Correct upgrade procedure, see here: http://www.observium.org/wiki/Upgrading#Upgrade_to_latest_Major_release
.....and having followed this in the weekend I can confirm the upgrade works without issue....
-- Regards,
Roland
PGP Key 0xDA39319B = BCF0 1214 BAE9 5A3D 46FC 21A6 360D 9398 DA39 319B
One thing I will add based on my experience:
Before you update, check your /opt to be sure you don't already have an observium_old directory or any tar files from previous updates. If you have an existing observium_old your backup will probably go into observium_old/observium. Then you just have to go into another directory to retrieve your config.php, etc.
If you have old tar files, the new one that downloads may have a ".1" appended on the end of it, so when you do the update you'll just be extracting the old one and won't get updated.
So see if you can find your lost config.php at /opt/observium_old/observium/config.php.
On Tue, Jun 9, 2015 at 4:04 AM, Roland Hill roland.lists@hillnet.co.nz wrote:
On Mon, 08 Jun 2015 or thereabouts, Mike Stupalov came forth with:
Huh..
Correct upgrade procedure, see here: http://www.observium.org/wiki/Upgrading#Upgrade_to_latest_Major_release
.....and having followed this in the weekend I can confirm the upgrade works without issue....
-- Regards,
Roland
PGP Key 0xDA39319B = BCF0 1214 BAE9 5A3D 46FC 21A6 360D 9398 DA39 319B
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (6)
-
Einar Storeng -
hayim siloni -
Jason Vanlandingham -
Mike Stupalov -
Roland Hill -
Tom Laermans