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.
--
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)
Copyright (c) 2000, 2011, Oracle and/or its affiliates.
All rights reserved.
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
__________ Information from ESET Smart Security, version of virus signature
database 7125 (20120510) __________
The message was checked by ESET Smart Security.
http://www.eset.com
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
__________ Information from ESET Smart Security, version of virus signature
database 7126 (20120510) __________
The message was checked by ESET Smart Security.
http://www.eset.com