[Observium] Access denied for user 'root'@'localhost' (using password: NO)

[Einar Storeng]

Hi.
After trying to upgrade to Community Edition version 0.15.6 i cant update
the database.

***@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

[Einar Storeng]

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

Hi.
./discovery.php -VV
cat config.php | grep db
Also check permissions to files.
ls -l /opt/observium/config.php
Hi.
After trying to upgrade to Community Edition version 0.15.6 i cant update
the database.
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
_______________________________________________
--
Mike Stupalovhttp://observium.org
_______________________________________________
observium mailing list
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

[Tom Laermans]

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

Post by Einar Storeng
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
Hi.
./discovery.php -VV
cat config.php | grep db
Also check permissions to files.
ls -l /opt/observium/config.php

Post by Einar Storeng
Hi.
After trying to upgrade to Community Edition version 0.15.6 i
cant update the database.
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
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

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

[Einar Storeng]

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

Post by Tom Laermans
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
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

Hi.
./discovery.php -VV
cat config.php | grep db
Also check permissions to files.
ls -l /opt/observium/config.php
Hi.
After trying to upgrade to Community Edition version 0.15.6 i cant
update the database.
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
_______________________________________________
--
Mike Stupalovhttp://observium.org
_______________________________________________
observium mailing list
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

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

[hayim siloni]

Hi All,
we have the same problem after upgrade to the new ver.
i run this command :
***@observium /opt/observium# ./discovery.php -VV
MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)

***@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'

***@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

Post by Einar Storeng
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

Hi.
./discovery.php -VV
cat config.php | grep db
Also check permissions to files.
ls -l /opt/observium/config.php
Hi.
After trying to upgrade to Community Edition version 0.15.6 i cant
update the database.
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
_______________________________________________
--
Mike Stupalovhttp://observium.org
_______________________________________________
observium mailing list
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

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

[Tom Laermans]

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

Post by hayim siloni
Hi All,
we have the same problem after upgrade to the new ver.
password: NO)
$config['db_host'] = 'localhost';
$config['db_user'] = 'USERNAME';
$config['db_pass'] = 'PASSWORD';
$config['db_name'] = 'observium'
-rw-rw-r-- 1 1000 certssl 1031 Nov 4 2014
/opt/observium/config.php.default
thanks for your help
br
hayim
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
Hi.
./discovery.php -VV
cat config.php | grep db
Also check permissions to files.
ls -l /opt/observium/config.php

Post by Einar Storeng
Hi.
After trying to upgrade to Community Edition version 0.15.6 i
cant update the database.
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
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

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

[Roland Hill]

Huh..
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

[Jason Vanlandingham]

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.

Post by Roland Hill

Huh..
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
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium