Happiness, it works now on both Ubuntu 10.04 and 12.04 J. I will be sticking with version 12.04 from now on just to remain compatible with later developments in the code. Thanks Adam.
brucem@ubuntu:/opt/observium$ sudo php includes/sql-schema/update.php
-- Updating database schema
000 -> 001 ... done.
001 -> 002 ... done.
002 -> 003 ... done.
003 -> 004 ... done.
004 -> 005 ... done.
005 -> 006 ... done (0 errors).
006 -> 007 ... done (1 errors).
007 -> 008 ... done (0 errors).
008 -> 009 ... done (0 errors).
009 -> 010 ... done (0 errors).
010 -> 011 ... done (0 errors).
011 -> 012 ... done (0 errors).
012 -> 013 ... done (0 errors).
013 -> 014 ... done (0 errors).
014 -> 015 ... done (0 errors).
015 -> 016 ... done (0 errors).
016 -> 017 ... done (0 errors).
017 -> 018 ... done (0 errors).
018 -> 019 ... done (0 errors).
019 -> 020 ... done (0 errors).
-- Done
From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: 10 May 2012 04:40 PM To: Observium Network Observation System Subject: Re: [Observium] Issues installing Observium on Ubuntu 10.04.4
Ok, SVN up and try again.
It would have worked via discovery.php -h new, but if you call the sql-schema file directly it wouldn't.
adam.
On 2012-05-10 15:00, Bruce-Young Majola wrote:
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.