Ooops something went wrong on GUI

Help
1

Hi, Guys.

Can anyone please shed some light on this issue?

I’m seeing the following error when trying to browse to libre:

image

I’ve run ./validate.php which shows the following error:

===========================================

Component Version
LibreNMS 24.5.0-7-gdf6a42f2a (2024-05-22T17:18:42+00:00)
DB Schema Not Connected (0)
PHP 8.1.2-1ubuntu2.17
Python 3.10.12
Database Not Connected
RRDTool 1.7.2
SNMP 5.9.1
===========================================

[OK] Composer Version: 2.7.6
[OK] Dependencies up-to-date.
Could not connect to database, check logs/librenms.log.

Seems the database is disconnected but how do i reconnect it?

Libre logs show the following:

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1040] Too many connections (Connection: mysql, SQL: select * from config where (config_name = rrdtool) limit 1) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
Stack trace:
#0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback()
#1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(431): Illuminate\Database\Connection->run()
#2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2798): Illuminate\Database\Connection->select()
#3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2786): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3340): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2787): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(738): Illuminate\Database\Query\Builder->get()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\Database\Eloquent\Builder->getModels()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(333): Illuminate\Database\Eloquent\Builder->get()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(567): Illuminate\Database\Eloquent\Builder->first()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(599): Illuminate\Database\Eloquent\Builder->firstOrCreate()
#11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2334): Illuminate\Database\Eloquent\Model->forwardCallTo()
#13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2346): Illuminate\Database\Eloquent\Model->__call()
#14 /opt/librenms/LibreNMS/Config.php(262): Illuminate\Database\Eloquent\Model::__callStatic()
#15 /opt/librenms/LibreNMS/Config.php(466): LibreNMS\Config::persist()
#16 /opt/librenms/LibreNMS/Config.php(61): LibreNMS\Config::processConfig()
#17 /opt/librenms/app/Providers/ConfigServiceProvider.php(27): LibreNMS\Config::load()
#18 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\ConfigServiceProvider->boot()
#19 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#20 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#21 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#22 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#23 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1030): Illuminate\Container\Container->call()
#24 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1011): Illuminate\Foundation\Application->bootProvider()
#25 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation{closure}()
#26 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1012): array_walk()
#27 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#28 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(263): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
#29 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(447): Illuminate\Foundation\Application->bootstrapWith()
#30 /opt/librenms/LibreNMS/Util/Laravel.php(44): Illuminate\Foundation\Console\Kernel->bootstrap()
#31 /opt/librenms/includes/init.php(90): LibreNMS\Util\Laravel::bootCli()
#32 /opt/librenms/syslog.php(12): require(‘…’)
#33 {main}
PDOException: SQLSTATE[HY000] [1040] Too many connections in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:65
Stack trace:
#0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(65): PDO->__construct()
#1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(45): Illuminate\Database\Connectors\Connector->createPdoConnection()
#2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1339): call_user_func()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1375): Illuminate\Database\Connection->getPdo()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(528): Illuminate\Database\Connection->getReadPdo()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(423): Illuminate\Database\Connection->getPdoForSelect()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\Database\Connection->Illuminate\Database{closure}()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback()
#11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(431): Illuminate\Database\Connection->run()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2798): Illuminate\Database\Connection->select()
#13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2786): Illuminate\Database\Query\Builder->runSelect()
#14 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3340): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#15 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2787): Illuminate\Database\Query\Builder->onceWithColumns()
#16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(738): Illuminate\Database\Query\Builder->get()
#17 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\Database\Eloquent\Builder->getModels()
#18 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(333): Illuminate\Database\Eloquent\Builder->get()
#19 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(567): Illuminate\Database\Eloquent\Builder->first()
#20 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(599): Illuminate\Database\Eloquent\Builder->firstOrCreate()
#21 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate()
#22 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2334): Illuminate\Database\Eloquent\Model->forwardCallTo()
#23 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2346): Illuminate\Database\Eloquent\Model->__call()
#24 /opt/librenms/LibreNMS/Config.php(262): Illuminate\Database\Eloquent\Model::__callStatic()
#25 /opt/librenms/LibreNMS/Config.php(466): LibreNMS\Config::persist()
#26 /opt/librenms/LibreNMS/Config.php(61): LibreNMS\Config::processConfig()
#27 /opt/librenms/app/Providers/ConfigServiceProvider.php(27): LibreNMS\Config::load()
#28 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\ConfigServiceProvider->boot()
#29 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#30 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#31 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#32 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#33 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1030): Illuminate\Container\Container->call()
#34 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1011): Illuminate\Foundation\Application->bootProvider()
#35 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation{closure}()
#36 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1012): array_walk()
#37 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#38 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(263): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
#39 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(447): Illuminate\Foundation\Application->bootstrapWith()
#40 /opt/librenms/LibreNMS/Util/Laravel.php(44): Illuminate\Foundation\Console\Kernel->bootstrap()
#41 /opt/librenms/includes/init.php(90): LibreNMS\Util\Laravel::bootCli()
#42 /opt/librenms/syslog.php(12): require(‘…’)
#43 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1040] Too many connections (Connection: mysql, SQL: select * from config where (config_name = traceroute) limit 1) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
Stack trace:
#0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback()
#1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(431): Illuminate\Database\Connection->run()
#2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2798): Illuminate\Database\Connection->select()
#3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2786): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3340): Illuminate\Database\Query\Builder->Illuminate\Database\Query{closure}()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2787): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(738): Illuminate\Database\Query\Builder->get()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(722): Illuminate\Database\Eloquent\Builder->getModels()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(333): Illuminate\Database\Eloquent\Builder->get()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(567): Illuminate\Database\Eloquent\Builder->first()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(599): Illuminate\Database\Eloquent\Builder->firstOrCreate()
#11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2334): Illuminate\Database\Eloquent\Model->forwardCallTo()
#13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2346): Illuminate\Database\Eloquent\Model->__call()
#14 /opt/librenms/LibreNMS/Config.php(262): Illuminate\Database\Eloquent\Model::__callStatic()
#15 /opt/librenms/LibreNMS/Config.php(466): LibreNMS\Config::persist()
#16 /opt/librenms/LibreNMS/Config.php(61): LibreNMS\Config::processConfig()
#17 /opt/librenms/app/Providers/ConfigServiceProvider.php(27): LibreNMS\Config::load()
#18 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\ConfigServiceProvider->boot()
#19 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#20 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#21 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#22 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#23 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1030): Illuminate\Container\Container->call()
#24 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1011): Illuminate\Foundation\Application->bootProvider()
#25 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation{closure}()
#26 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1012): array_walk()
#27 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\App^C

Thanks in advanced,
James

2

Further investigation in ./daily.sh shows the following:

librenms@localhost:~$ ./daily.sh
Could not connect to database, check logs/librenms.log.
Updating SQL-Schema FAIL

In Connection.php line 829:

SQLSTATE[HY000] [1698] Access denied for user ‘librenms’@‘localhost’ (Connection: mysql, SQL: update cache_locks set owner = gkwdHsExW7uqpFlm, expiration = 1
716547067 where key = laravel_cache_framework/command-migrate and (owner = gkwdHsExW7uqpFlm or expiration <= 1716543467))

In Connector.php line 65:

SQLSTATE[HY000] [1698] Access denied for user ‘librenms’@‘localhost’

Cleaning up DB OK
Could not connect to database, check logs/librenms.log.

Possibly a permission issue, how do i fix this? Sorry quite new to linux / ubuntu.

Thanks in advanced,
James

3

Ok seems I have resolved this by changing the DB_USERNAME in .env file.

The only thing i did was change it to something else and change it back to original which sorted it.

No idea how or why but its working now.

Thanks,
James

4

You temporarily exceeded your max connection setting for your mysql server. I suggest you increase that. Any other changes you made had no affect.

5

Hi, Murrant.

How do i increase max connections?

Thank you,
James Stoner

6

https://www.google.com/search?q=mysqld+increase+max+connections

7

Hi, Murrant

Thanks. I will give this a go.

Appreciate the support from all.

Thank you,
James

8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.