Jump to content
uberchuckie

[Support] uberchuckie - observium

65 posts in this topic Last Reply

Recommended Posts

I've gotten Observium CE 19.8.1 working. I've also upgraded the image to MariaDB 10.4.8.

 

I ran into a possible unRAID bug with it but moving from 6.7.2 to 6.7.3-rc4 appears to have fixed it. I'll push a beta image for people to try and I'll write up instructions on the upgrade process.

Share this post


Link to post

Thanks uberchuckie - I'll wait for a stable version of 6.7.3 to be released and then will hopefully be able to upgrade to the new version of Observium 

Share this post


Link to post

I get the following error in Chrome when I try to connect to an a new docker installation.

 

DB Error 2002: Permission denied

 

Have tried to remove the folders in the appdata folder but it doesn't help.

 

 

Share this post


Link to post
On 7/15/2019 at 12:01 AM, vb543 said:

Having the same problem unfortunately. Ever find a fix?

Have you ever got it fixed ? i tried loads of stuff and the graphs are still an hour off sadly.

Share this post


Link to post
On 12/3/2019 at 1:55 PM, tylerism said:

I get the following error in Chrome when I try to connect to an a new docker installation.

 

DB Error 2002: Permission denied

 

Have tried to remove the folders in the appdata folder but it doesn't help.

 

 

Can you post the log file?

Share this post


Link to post
5 hours ago, Silvan-0172 said:

Have you ever got it fixed ? i tried loads of stuff and the graphs are still an hour off sadly.

Looks like the app is not respecting the timezone set in the environment. I'll see if I have time to take a look.

Edited by uberchuckie

Share this post


Link to post
On 9/22/2019 at 10:00 AM, ultimz said:

Thanks uberchuckie - I'll wait for a stable version of 6.7.3 to be released and then will hopefully be able to upgrade to the new version of Observium 

I tried both unRAID 6.8.0-rc9 and 6.8.0. The latest image works fine so I've push the beta tag to be the latest tag as well. I've been using the image since September and had not run into any issues.

Share this post


Link to post
6 hours ago, Silvan-0172 said:

Have you ever got it fixed ? i tried loads of stuff and the graphs are still an hour off sadly.

I took a look at this...

 

I ran /opt/observium/poller.php -d and saw this:

#####  Timezones info  #####

 o Date                 Tuesday, 10-Dec-19 21:08:21 EST
 o PHP                  -05:00
 o MySQL                -05:00

 

This looks like it's correct and PHP and MySQL have matching time offset.

root@c3b53bf2ea0d:/opt/observium# mysql -u observium -p observium
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
Server version: 10.4.8-MariaDB-1:10.4.8+maria~bionic-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [observium]> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-12-10 21:11:56 |
+---------------------+
1 row in set (0.000 sec)

MariaDB [observium]>

 

This is also showing the correct time.

 

I even tried adding "default-time-zone='-05:00'" to "/etc/mysql/my.cnf" and restarting the database and that didn't make any difference. The graphs are still in UTC.

 

I'm not sure what's the problem at this point.

Edited by uberchuckie

Share this post


Link to post
4 hours ago, uberchuckie said:

I took a look at this...

 

I ran /opt/observium/poller.php -d and saw this:


#####  Timezones info  #####

 o Date                 Tuesday, 10-Dec-19 21:08:21 EST
 o PHP                  -05:00
 o MySQL                -05:00

 

This looks like it's correct and PHP and MySQL have matching time offset.


root@c3b53bf2ea0d:/opt/observium# mysql -u observium -p observium
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
Server version: 10.4.8-MariaDB-1:10.4.8+maria~bionic-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [observium]> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-12-10 21:11:56 |
+---------------------+
1 row in set (0.000 sec)

MariaDB [observium]>

 

This is also showing the correct time.

 

I even tried adding "default-time-zone='-05:00'" to "/etc/mysql/my.cnf" and restarting the database and that didn't make any difference. The graphs are still in UTC.

 

I'm not sure what's the problem at this point.

Thank you for checking. Im using the beta image and have also set my timezone via the TZ variable but to no avail.

When i run /opt/observium/poller.php -d i can see the correct timezone is set, yes the graphs are still 1 hour off.

Share this post


Link to post
On 12/11/2019 at 2:27 AM, uberchuckie said:

Can you post the log file?

Here is the content of the beginning of the log file. The docker was updated yesterday with the new version.

 

** Running /etc/my_init.d/10_syslog-ng.init...
Dec 11 02:35:38 99818e7bd47a syslog-ng[12]: syslog-ng starting up; version='3.13.2'
*** Running /etc/my_init.d/firstrun.sh...
Using existing PHP database config file.
warning: commands will be executed using /bin/sh
job 1 at Wed Dec 11 02:36:00 2019
Timezone not specified by environment variable
*** Booting runit daemon...
*** Runit started as PID 35
Database exists.
Starting MariaDB...
Dec 11 02:37:42 99818e7bd47a cron[41]: (CRON) INFO (pidfile fd = 3)
Dec 11 02:37:42 99818e7bd47a cron[41]: (CRON) INFO (Running @reboot jobs)
191211 02:37:42 mysqld_safe Logging to '/config/databases/99818e7bd47a.err'.
191211 02:37:42 mysqld_safe Starting mysqld daemon with databases from /config/databases
Dec 11 02:39:01 99818e7bd47a CRON[304]: (root) CMD (  [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Dec 11 02:40:01 99818e7bd47a CRON[351]: (root) CMD (   /opt/observium/poller-wrapper.py 2 >> /dev/null 2>&1)
Dec 11 02:40:01 99818e7bd47a CRON[352]: (root) CMD (   /opt/observium/discovery.php -h new >> /dev/null 2>&1)

Share this post


Link to post
17 hours ago, tylerism said:

Here is the content of the beginning of the log file. The docker was updated yesterday with the new version.

 

Try deleting your observium directory under the appdata volume mount and start the container again. Let the database initialization script run to its completion.

Share this post


Link to post
On 12/14/2019 at 3:33 PM, uberchuckie said:

 

Try deleting your observium directory under the appdata volume mount and start the container again. Let the database initialization script run to its completion.

Tried to delete the folder but I get the same error. 

 

This is the content from the db.log if it could help in finding the problem.

 

[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.dbSchema' doesn't exist), Query: SELECT `version` FROM `dbSchema` ORDER BY `version` DESC LIMIT 1
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_version';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.eventlog' doesn't exist), Query: INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`)  VALUES ('0',NULL,'global',NOW(),'5','Observium updated:  -> 19.8.10000')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'current_rev')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: INSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`)  VALUES ('current_rev','10000')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'current_version')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: INSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`)  VALUES ('current_version','19.8.10000')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.config' doesn't exist), Query: SELECT * FROM `config`
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.dbSchema' doesn't exist), Query: SELECT `version` FROM `dbSchema` ORDER BY `version` DESC LIMIT 1
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.devices' doesn't exist), Query: SELECT 1 FROM `devices` LIMIT 1;

Share this post


Link to post
1 minute ago, tylerism said:

Tried to delete the folder but I get the same error. 

 

This is the content from the db.log if it could help in finding the problem.

 

[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.dbSchema' doesn't exist), Query: SELECT `version` FROM `dbSchema` ORDER BY `version` DESC LIMIT 1
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_version';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.eventlog' doesn't exist), Query: INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`)  VALUES ('0',NULL,'global',NOW(),'5','Observium updated:  -> 19.8.10000')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'current_rev')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: INSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`)  VALUES ('current_rev','10000')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'current_version')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: INSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`)  VALUES ('current_version','19.8.10000')
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.config' doesn't exist), Query: SELECT * FROM `config`
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.dbSchema' doesn't exist), Query: SELECT `version` FROM `dbSchema` ORDER BY `version` DESC LIMIT 1
[2019/12/15 08:26:46 +0100] discovery.php(371): Failed dbQuery (#1146 - Table 'observium.devices' doesn't exist), Query: SELECT 1 FROM `devices` LIMIT 1;

The database hasn't been created yet. Did you stop the container before deleting the appdata volume for observium?

Share this post


Link to post
On 12/16/2019 at 6:30 PM, uberchuckie said:

The database hasn't been created yet. Did you stop the container before deleting the appdata volume for observium?

Yes, the container was stopped. 

 

My disk is almost full. How much space is needed to create the database?

 

 

Share this post


Link to post
20 hours ago, tylerism said:

My disk is almost full. How much space is needed to create the database?

 

Mine is 438MB with around 4 years of data from one device.

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.