Same error here…after a VM freeze and reset from Vbox gui, cannot connect to database:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2 “No such file or directory”)
The result for grep config.php:
$config[‘db_host’] = ‘127.0.0.1’;
$config[‘db_user’] = ‘librenms’;
$config[‘db_pass’] = ‘xxxxxxxx’;
$config[‘db_name’] = ‘librenms’;
Validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.50.1 |
| DB Schema | Not Connected (0) |
| PHP | 7.2.15-0ubuntu0.18.04.2 |
| MySQL | ? |
| RRDTool | 1.7.0 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
Could not connect to database, check logs/librenms.log.
librenms.log
[2019-04-26 08:05:45] production.ERROR: SQLSTATE[HY000] [2002] No such file or or directory (SQL: select user_id from users where (auth_type = mysql or auth_type is null or auth_type = ) and username = 2ws limit 1) {“exception”:"[object] (Illuminate\Database\QueryException(code: 2002 ): SQLSTATE[HY000] [2002] No such file or directory (SQL: select user_id from users where (auth_type = mysql or auth_type is null or auth_type = ) and username = 2ws limit 1) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\DBAL\Driver\PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31, PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27)
[stacktrace]
any suggestions???