Database Inventory With GLPI Agent Not Working As Expected

[delboy1966]

Documentation & bug reporting acknowledgment

Not applicable

Describe your problem

I'm trying to get GLPI to inventory Databases on a server, I've started with a MySQL server.
I have the latest version of glpi-agent on the server and run it with the --credentials arguement

glpi-agent --credentials='type:mysql,login:<username>,password:<password>,port:1485' --debug --debug

But that didn't seem to produce any valid debug.

Bur when I use

glpi-agent --credentials='type:login_password,login:<username>,password:<password>,port:1485' --debug --debug

i get the following debug output. But never get any population on the Database Instances tab on the Asset in GLPI.

[debug2] Trying login_password credential type id 0
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SHOW VARIABLES LIKE 'version'"
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT DATE_SUB(now(), INTERVAL variable_value SECOND) from ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT DATE_SUB(now(), INTERVAL variable_value SECOND) from ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SHOW DATABASES"
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT sum(data_length+index_length) FROM ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MIN(create_time) FROM information_schema.TABLES WHERE ...
[debug2] executing mysql --defaults-extra-file=my-7OaeNt.cnf -q -sN -e "SELECT MAX(update_time) FROM information_schema.TABLES WHERE ...

[g-bougard]

Hi @delboy1966

you should probably better use databaseinventory plugin to setup databases credentials.

Can you share the result of the following command ?

glpi-inventory --partial=database --credentials='type:login_password,login:<username>,password:<password>,port:1485' --debug --debug

At least the "content"->"databases_services" node.

[delboy1966]

Hi

I tried as you suggested and also tried it with glpi-agent and get the same info, it does find the databases but it never updates the Database Instances for the server on glpi.

"databases_services": [
         {
            "databases": [
               {
                  "creation_date": "2025-01-17 13:35:05",
                  "is_active": true,
                  "name": "Connectors",
                  "size": 1,
                  "update_date": "2025-06-10 07:12:40"
               },
               {
                  "creation_date": "2022-08-30 08:55:08",
                  "is_active": true,
                  "name": "Reports",
                  "size": 1,
                  "update_date": "2025-06-10 01:30:10"
               },
               {
                  "creation_date": "2025-05-21 14:29:44",
                  "is_active": true,
                  "name": "Microservices",
                  "size": 0,
                  "update_date": "2025-06-10 09:15:36"
               },
               {
                  "creation_date": "2024-05-17 11:02:22",
                  "is_active": true,
                  "name": "ServiceNow",
                  "size": 0
               },
               {
                  "creation_date": "2022-08-30 08:55:22",
                  "is_active": true,
                  "name": "Thresholds",
                  "size": 0
               },
               {
                  "creation_date": "2022-08-30 08:42:36",
                  "is_active": true,
                  "name": "information_schema",
                  "size": 0
               },
               {
                  "creation_date": "2022-08-30 07:42:27",
                  "is_active": true,
                  "name": "mysql",
                  "size": 2,
                  "update_date": "2025-06-10 09:15:43"
               },
               {
                  "creation_date": "2024-11-13 06:52:33",
                  "is_active": true,
                  "name": "performance_schema",
                  "size": 0
               },
               {
                  "creation_date": "2022-08-30 08:42:42",
                  "is_active": true,
                  "name": "sys",
                  "size": 0
               }
            ],

[g-bougard]

When running glpi-agent, you should also use these options: --debug --debug --force --full --logger=stderr

[delboy1966]

I've tried as you suggested, and even though the output I get back lists all the databases on that server, they still don't get added to the list of Database Instances for that asset in GLPI.

[delboy1966]

Any idea why this data isn't going into GLPI even though running glpi-agent with the creds brings back the databases?
Is there a way to force it into GLPI?

[g-bougard]

Can you try to redirect the output of the following command (using your credentials of course) to a file ?

glpi-inventory --partial=database --credentials='type:login_password,login:<username>,password:<password>,port:1485' >databases.json

Then try to inject it with the following command:

glpi-injector --debug -f database.json -u <your-server-url>

Check if you see databases this time on the expected asset and share any error reported by glpi-injector:

[delboy1966]

Thanks for the prompt reply.

I outputted the data to a json file as you suggested and then run the glpi-injector line.
Initially I did it to the proxy agent that the server sends all its data to, but that failed, so pointed it directly at the GLPI main server.
The databases still didn't appear, even though the last update of the asset was correct.

The only output i got from the glpi-injector command was

Loading ./databases.json...[CE8FE841] [agentid:02c4334f-e13a-4702-80bb-3212a316aa7e] DEBUG: Uncompressing received content
OK
DEBUG: {"expiration":"1","status":"ok"}

Is there anywhere in GLPI that I can look at to see why they didn't get added?

[g-bougard]

First check you effectively have a databases_services node in the json. Then check you're checking the right asset.

Check if you have some errors in files/_log/php-errors.log.log at the same time you try to import the file.

[delboy1966]

In answer to your suggestions.

Yes there was a databases_services in the json.
And the device id matches what the asset is called in GLPI. Which is proven when I do the inject as thats the only asset that is updated at the same time.

And I'm getting nothing out of the php-errors.log file whilst I'm doing the import and tailing the log file.

[g-bougard]

Do you have any other server with databases in your GLPI for which databases inventory works ?

Can you share the fulle "databases_services" node from the json ? 2 weeks ago, you only shared the node with the "databases" list, some data was missing. I want to test your inventory on a test instance.

Also what GLPI version are you using ?

[delboy1966]

Hello

Yes we have other MySQL servers in GLPI.
I have done the same on that server, running glpi-inventory with the creds and outputing to a file.
Then running glpi-injector for that file to our GLPI server.
Again nothing appears in GLPI against that asset for databases.

The databases.json file is attached.

databases.json

Thanks for your help.