I can not get this to work. I've deleted it a dozen times, left it overnight before trying to login, and I get different error messages all the time even with new install dir's.
Most recent one: DB Error 2002: No such file or directory
Or the "observium" username and password don't work.
Log keeps spamming
Starting MariaDB...
200828 07:31:48 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:48 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:31:49 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:49 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:31:51 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:51 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:31:52 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:52 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Here is a new install:
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|[0;36m
Observium Community Edition 19.8.10000
http://www.observium.org[0m
[0m
CMD[[0;33m/opt/observium/scripts/distro[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0153s[0m][0m
STDOUT[
Linux|4.19.107-Unraid|amd64|Ubuntu|18.04|vmware|docker
][0m
CMD[[0;33m/usr/bin/env python --version 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0016s[0m][0m
STDOUT[
Python 2.7.17
][0m
SQL[[0;33mSELECT version();[0m][0m
SQL RUNTIME[[0;32m0.00018501s[0m][0m
CMD[[0;33m/usr/bin/snmpget --version 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0018s[0m][0m
STDOUT[
NET-SNMP version: 5.7.3
][0m
CMD[[0;33m/usr/bin/rrdtool --version | head -n1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0068s[0m][0m
STDOUT[
RRDtool 1.7.0 Copyright by Tobias Oetiker <
[email protected]>
][0m
CMD[[0;33m/usr/bin/fping -v 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0015s[0m][0m
STDOUT[
/usr/bin/fping: Version 4.0
/usr/bin/fping: comments to
[email protected]
][0m
CMD[[0;33m/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0414s[0m][0m
STDOUT[
Apache/2.4.29
][0m
CMD[[0;33mdate "+%:z"[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0009s[0m][0m
CMD EXITDELAY[[0;31m10ms[0m][0m
STDOUT[
-07:00
][0m
SQL[[0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);[0m][0m
SQL RUNTIME[[0;32m0.00020695s[0m][0m
SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m
SQL RUNTIME[[0;32m0.00009990s[0m][0m
SQL[[0;33mSHOW VARIABLES LIKE 'character_set_connection'[0m][0m
SQL RUNTIME[[0;32m0.00091219s[0m][0m
[0;36m##### [1;37mSoftware versions[0;36m #####[0m
[0m
[0;36m o [1;37mOS [0m Linux 4.19.107-Unraid [amd64] (Ubuntu 18.04)
[0;36m o [1;37mApache [0m 2.4.29
[0;36m o [1;37mPHP [0m 7.2.24-0ubuntu0.18.04.6 (OPcache: DISABLED)
[0;36m o [1;37mPython [0m 2.7.17
[0;36m o [1;37mMySQL [0m 10.5.4-MariaDB-1:10.5.4+maria~bionic (extension: mysqli 5.0.12-dev)
[0;36m o [1;37mSNMP [0m NET-SNMP 5.7.3
[0;36m o [1;37mRRDtool [0m 1.7.0
[0;36m o [1;37mFping [0m 4.0 (IPv4 and IPv6)
[0;35m##### [1;37mMemory Limit[0;35m #####[0m
[0m
[0;35m o [1;37mPHP [0m Unlimited
[0;35m##### [1;37mMySQL mode[0;35m #####[0m
[0m
[0;35m o [1;37mMySQL [0m ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[0;35m##### [1;37mCharset info[0;35m #####[0m
[0m
[0;35m o [1;37mPHP [0m UTF-8
[0;35m o [1;37mMySQL [0m utf8
[0;35m##### [1;37mTimezones info[0;35m #####[0m
[0m
[0;35m o [1;37mDate [0m Friday, 28-Aug-20 07:36:54 PDT
[0;35m o [1;37mPHP [0m -07:00
[0;35m o [1;37mMySQL [0m -07:00
SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m
SQL RUNTIME[[0;32m0.00015116s[0m][0m
SQL[[0;33mSELECT `version` FROM `dbSchema` ORDER BY `version` DESC LIMIT 1[0m][0m
SQL RUNTIME[[0;32m0.00010705s[0m][0m
SQL[[0;33mSELECT 1 FROM `devices` LIMIT 1;[0m][0m
SQL RUNTIME[[0;32m0.00011396s[0m]
SQL ERROR[[0;31mError in query: (Table 'observium.devices' doesn't exist) 1146[0m][0m
Install initial database schema ...
CMD[[0;33m/usr/bin/mysql -u'observium' -p'bjccHfoupBCWBTWPODmOFa16nN8DYF7X' -h'localhost' -D 'observium' < '/opt/observium/update/db_schema_mysql.sql'[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;31m115.721s[0m][0m
STDOUT[
][0m
SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m
SQL RUNTIME[[0;32m0.00043917s[0m][0m
done.
SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '-1'[0m][0m
SQL RUNTIME[[0;32m0.00041986s[0m][0m
SQL[[0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('225','discovery.php','36','0','php ./discovery.php -d -u','1598625529','-1')[0m][0m
SQL RUNTIME[[0;32m0.02732396s[0m][0m
-- Database is up to date.
SQL[[0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '225' AND `process_name` = 'discovery.php' AND `device_id` = '-1'[0m][0m
SQL RUNTIME[[0;32m0.02290606s[0m][0m
SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';[0m][0m
SQL RUNTIME[[0;32m0.00021791s[0m][0m
REQUEST[[0;33mhttp://www.observium.org/versions.php[0m]
REQUEST STATUS[[0;32mTRUE[0m]
REQUEST RUNTIME[[0;32m1.3866s[0m]
RESPONSE CODE[200 OK][0m
SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver')[0m][0m
SQL RUNTIME[[0;32m0.00026703s[0m][0m
SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('latest_ver','19.8')[0m][0m
SQL RUNTIME[[0;32m0.01941109s[0m][0m
SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev')[0m][0m
SQL RUNTIME[[0;32m0.00016999s[0m][0m
SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('latest_rev','10000')[0m][0m
SQL RUNTIME[[0;32m0.01637483s[0m][0m
SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date')[0m][0m
SQL RUNTIME[[0;32m0.00024509s[0m][0m
SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('latest_rev_date','2019-08-24')[0m][0m
SQL RUNTIME[[0;32m0.04439902s[0m][0m
SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck')[0m][0m
SQL RUNTIME[[0;32m0.00021100s[0m][0m
SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('last_versioncheck','1598625531')[0m][0m
SQL RUNTIME[[0;32m0.04074883s[0m][0m
SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';[0m][0m
SQL RUNTIME[[0;32m0.00024605s[0m][0m
Adding the 'observium' user to the app.
[0;32mObservium CE 19.8.10000
[1;37mAdd User[0m
[0m
User observium added successfully.
Shutting down.
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] /usr/sbin/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] Event Scheduler: Purging the queue. 0 events
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: FTS optimize thread exiting.
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Starting shutdown...
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Restricted to 2013 pages due to innodb_buf_pool_dump_pct=25
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 200828 7:38:51
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Shutdown completed; log sequence number 5767295; transaction id 5202
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Aug 28 07:38:53 9ac22bf8d797 mysqld:
Aug 28 07:38:53 9ac22bf8d797 mysqld_safe: mysqld from pid file /run/mysqld/mysqld.pid ended
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Shutdown completed; log sequence number 5767295; transaction id 5202
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Aug 28 07:38:53 9ac22bf8d797 mysqld:
Aug 28 07:38:53 9ac22bf8d797 mysqld_safe: mysqld from pid file /run/mysqld/mysqld.pid ended
chown time
Initialization complete.
Starting MariaDB...
200828 07:38:57 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:57 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:38:58 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:58 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:38:59 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:38:59 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:00 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:00 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:01 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:01 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Aug 28 07:39:02 9ac22bf8d797 CRON[906]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Aug 28 07:39:02 9ac22bf8d797 CRON[906]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Database exists.
Starting MariaDB...
200828 07:39:03 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:03 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:04 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:04 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:04 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:04 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:05 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:05 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:06 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:06 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:06 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:06 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:08 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:08 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
Any ideas?