Re: [Observium] Issues installing Observium on Ubuntu 10.04.4

10 May 2012

      This is indeed very weird, I have again tried to install Observium on the new Ubuntu 12.04 server thinking that perhaps there were issues with Ubuntu 10.04 but I am getting exactly the same errors L. I am really baffled as I followed the installation instructions to the letter.
019 -> 020 ...PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/sql-schema/update.php on line 102
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/sql-schema/update.php on line 102
done (6 errors).
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/dbFacile.php on line 370
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/dbFacile.php on line 370
PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/dbFacile.php on line 346
PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /opt/observium/includes/dbFacile.php on line 346
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/dbFacile.php on line 33
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/dbFacile.php on line 33
PHP Warning:  QDB - Insert failed. in /opt/observium/includes/dbFacile.php on line 77
PHP Warning:  mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /opt/observium/includes/dbFacile.php on line 378
PHP Warning:  mysql_query(): A link to the server could not be established in /opt/observium/includes/dbFacile.php on line 378
PHP Notice:  Undefined index: insert_sec in /opt/observium/includes/dbFacile.php on line 86
PHP Notice:  Undefined index: insert in /opt/observium/includes/dbFacile.php on line 87
PHP Notice:  Undefined variable: id in /opt/observium/includes/dbFacile.php on line 89
-- Done
Ubuntu 12.04 is running as virtual machine on VMWare Workstation v8 as was version 10.04. Could that have anything to do with it?
From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong
Sent: 10 May 2012 12:14 PM
To: Observium Network Observation System
Subject: Re: [Observium] Issues installing Observium on Ubuntu 10.04.4
It seems to be not getting any configuration from configuration.php, hence it trying to connect as root without a password.
You've done something weird, but I can't tell what.
Btw, 10.04 is old. Soon we will require rrdtool 1.4, which is not in 10.04.
Adam.
-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.

Bruce-Young Majola brucem@muzotech.co.za wrote:

Hi,

I am baffled about exactly the same thing; why is it using something not configured. I do not know about config.php.inc, below are the credentials configured on the config.php file including what I have configured on the database itself.

### Database config

$config['db_host'] = "localhost";

$config['db_user'] = "observium";

$config['db_pass'] = "xxxxxx";

$config['db_name'] = "observium";

GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY 'xxxxxx';

I can also connect to the database using the configured credentials;

brucem@ubuntu:/opt/observium$ mysql -u observium -pxxxxxx

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 35

Server version: 5.1.62-0ubuntu0.10.04.1 (Ubuntu)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

I have changed the password for security reasons 

From: Yucong Sun (???) sunyucong@gmail.com

To: Observium Network Observation System observium@observium.org

Subject: Re: [Observium] Issues installing Observium on Ubuntu 10.04.4

      server

Message-ID:

      CAJygYd1kANps+y3BPpBwUDxO6Pt21403St2zpS2NhoR8g4S2XA@mail.gmail.com

Content-Type: text/plain; charset=UTF-8

are you sure you configured the DB params in config.php.inc  ? it seems you are trying to access using root and empty password.

Regards,

Bruce-Young Majola

__________ Information from ESET Smart Security, version of virus signature database 7124 (20120509) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 7125 (20120510) __________

The message was checked by ESET Smart Security.

http://www.eset.com