Forum GLPI-Project

xaviglpi

Member

Registered: 2023-07-17

Posts: 1

Can't access GLPI 9.5 database for export

Hello,

I know GLPI 9.5.5 is not longer on Support, but here i'm trying to migrate it to newer version, beforehand i would like to migrate it to a newer server/OS (currently running in ubuntu 14.04). So i need a database export, but i can't connect to the database with the config_db.php credentials.

This is my config/config_db.php file
<?php
class DB extends DBmysql {

var $dbhost = 'localhost';

var $dbuser    = 'root';

var $dbpassword= 'my%password'; // obviously changed, just to you to note that i have  the "%" character in my password

var $dbdefault = 'glpi';

}
?>

I try to:
mysql -uroot -pmy%password -D glpi
mysql -uroot -pmy%password
mysql -uroot -p'my%password' -D glpi
mysql -uroot -p'my%password'
mysql -uroot -p

I get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

The GLPI instance is working without issues, but i can't use the Administration-> Maintenance export. This hangs the CPU at 100% for a ton of time (i've waited more than 20 minutes without success)

I'm sorry to write about an unsupported version but this is so i can migrated it to a newer version.

I've checked my ports, mysqld is listening on 3306.  php 5.5 is not using sockets in the php.ini file, neither there is any apache module changing the mysql entrypoint.

PS: The server hasn't rebooted in years... Probably the mysql daemon is just crazy blocking root login and GLPI is using an already opened session. I can't* reboot the server neither the service.

I mean i could, but would you reboot a business production machine that hasnt rebooted in years and assume any risk from it?

EDIT:
It's possible that this is running an insecure mysql server installation according to:
stackoverflow.com/questions/1412339/cannot-log-in-with-created-user-in-mysql

But eitherway, if the anonymous entry is causing this, how can GLPI access the database?

EDIT2:
Have found /etc/mysql/debian.cnf which cointais an maintenance user, i just log in with that user and done my exportation.

Last edited by xaviglpi (2023-07-17 14:29:47)