Error when setting up database

[jslegers73]

Hi,

When I want to setup the database with command docker exec LibreNMS setup_database. I get the following error.

docker exec LibreNMS setup_database Could not open input file: /opt/librenms/includes/sql-schema/update.php

When I check in the container the directory isn't there also :

root@librenms:/usr/local/bin# ./setup_database Could not open input file: /opt/librenms/includes/sql-schema/update.php

root@librenms:/usr/local/bin# cd /opt/librenms/includes/

root@librenms:/opt/librenms/includes# ls caches discovery init.php services.inc.php systemd-shared.inc.php common.php functions.php polling snmp.inc.php datastore.inc.php helpers.php port-descr-parser.inc.php snmptrap.inc.php dbFacile.php html rewrites.php static-config.php definitions include-dir.inc.php services syslog.php

root@librenms:/opt/librenms/includes#

Is this a know issue or am I doing something wrong?

This is my docker-compose file :

mariadb: image: mariadb container_name: MariaDB restart: always hostname: mariadb environment:

• TZ=${TZ}

• MYSQL_ROOT_PASSWORD=${MDBRP} volumes:

  • ./mariadb:/var/lib/mysql
  • ./mariadb.cnf:/etc/mysql/conf.d/custom.cnf

  librenms: image: jarischaefer/docker-librenms:latest-arm64v8 container_name: LibreNMS restart: always hostname: librenms ports:

• 8668:80 volumes:
• ./librenms/logs:/opt/librenms/logs
• ./librenms/rrd:/opt/librenms/rrd
• ./librenms/custom.config.php:/opt/librenms/conf.d/custom.config.php:ro environment:
• APP_KEY=base64:J1VABAqbGIZAMZA40ogtOJwTWfI91xr4KB53Vlxbsl4=
• DB_HOST=mariadb
• DB_NAME=librenms
• DB_USER=librenms
• DB_PASS='V#aCitVKB!YzSC3G1x'
• BASE_URL=http://librenms.thuisjsl.local:8668
• DISABLE_IPV6=true depends_on:
• mariadb links:
• mariadb:librenms

[jarischaefer]

@jslegers73 Thank you for the report. A new version (23.10) containing a fix will be released shortly. In the meantime, you may call the proper command directly: docker exec LibreNMS /sbin/setuser librenms /opt/librenms/lnms migrate --no-interaction --force --isolated --seed

[jslegers73]

@jslegers73 Thank you for the report. A new version (23.10) containing a fix will be released shortly. In the meantime, you may call the proper command directly: docker exec LibreNMS /sbin/setuser librenms /opt/librenms/lnms migrate --no-interaction --force --isolated --seed

@jarischaefer I will try the new version tonight.

[jslegers73]

@jarischaefer I get another error now. I have deleted the data directory form MariaDB.

pi@rpi-test:~/docker-data $ docker exec LibreNMS setup_database

In Connection.php line 795:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'librenms.cache_l ocks' doesn't exist (Connection: mysql, SQL: update cache_locks set owne r = DBPXPM6OufjArW5m, expiration = 1699289604 where key = laravel_cach e_framework/command-migrate and (owner = DBPXPM6OufjArW5m or expiration <= 1699286004))

In Connection.php line 601:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'librenms.cache_l ocks' doesn't exist

pi@rpi-test:~/docker-data $

Tried it also on a fresh installation same issue unfortunately.

[jarischaefer]

Tried it also on a fresh installation same issue unfortunately.

I believe that some state is still present, otherwise database migrations would have created fresh tables prior to using the cache. Did you really fully remove both the container and its directories (docker rm)?

I will create a new helper script for setting up a fresh database in such scenarios. In the meantime, use the following command: /sbin/setuser librenms /opt/librenms/artisan migrate:fresh

[jarischaefer]

@jslegers73 Try docker pull jarischaefer/docker-librenms. The latest build should contain the new setup_fresh_database script. This new script drops and re-creates all tables.

[jslegers73]

@jarischaefer Hi sorry for my late reply. Sorry to say but I have tried it again but again same error on fresh installed 64 Bit RPI 4

pi@rpi-test:~/docker-data $ docker exec LibreNMS setup_database

In Connection.php line 795:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'librenms.cache_l ocks' doesn't exist (Connection: mysql, SQL: update cache_locks set owne r = O5UJPdrChD42eTFp, expiration = 1702035163 where key = laravel_cach e_framework/command-migrate and (owner = O5UJPdrChD42eTFp or expiration <= 1702031563))

In Connection.php line 601:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'librenms.cache_l ocks' doesn't exist

pi@rpi-test:~/docker-data $

I use the mariadb docker container. docker pull mariadb

This is how I have setup the database: CREATE DATABASE librenms CHARACTER SET utf8 COLLATE utf8_unicode_ci; CREATE USER 'librenms'@'%' IDENTIFIED BY 'Password'; CREATE USER 'librenms'@'localhost' IDENTIFIED BY 'Password'; GRANT ALL PRIVILEGES ON librenms.* TO 'librenms'@'%'; FLUSH PRIVILEGES; exit

This should work with the original MariaDB right?

When I try your work around looks like it is working:

And when I want to create an Admin I get the following error: pi@rpi-test:~/docker-data $ docker exec LibreNMS create_admin The selected role.0 is invalid.

Sorry for this. I hope you can fix it.

[jslegers73]

I did some testing. Found out that image version 23.8.2 works ok. I have to create the database with option : /sbin/setuser librenms /opt/librenms/artisan migrate:fresh. If I use the docker exec LibreNMS setup_database command I get the following error.

pi@rpi-test:~/docker-data $ docker exec LibreNMS setup_database
Could not open input file: /opt/librenms/includes/sql-schema/update.php
pi@rpi-test:~/docker-data $

But I can create the admin account and login. So that works.

23.9 and 23.10 I can't get to work. Also not on an AMD64 machine. Hopefully this will help you.

[jarischaefer]

@jslegers73 Sorry for the delay, please try version 24.1.0, or use -e DAILY_ON_STARTUP=true for the initial setup.

[jslegers73]

@jslegers73 Sorry for the delay, please try version 24.1.0, or use -e DAILY_ON_STARTUP=true for the initial setup.

Hi was on holiday. I have tested it and it works thank you.