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.

[g-bougard]

You didn't answer to this:

Also what GLPI version are you using ?

I get it imported and see it in a GLPI 10.0.18 test instance:

[delboy1966]

Sorry, I was just signing off for the day and missed that one.
We are running the same version

GLPI 10.0.18 ( => /var/www/glpi)
Installation mode: TARBALL
Current language:en_GB

very strange that its working for you and not for us. Is there something we haven't enabled?

[delboy1966]

I'm going to fire up a new box this afternoon, and put a fresh install of GLPI 10.0.18 on it and then the only thing I'm going to try and do is replicate adding that one asset and the assets databases to it.
I assume a default install will allow adding the databases instances without having install or configure anything special in GLPI?

If that works then I can start migrating stuff from our current GLPI server and move to the new one.
Then it will be a case of how to make the glpi-agent update the databases for an asset every time it runs. And if it can do that when sending its data to a proxy agent and not directly at the GLPI server.

[delboy1966]

Well that worked ok,
Running glpi-agent with the MySQL creds imported the database instances to the asset.
I've no idea why it didn't work on the original GLPI server.
But, then again that was a POC, and we had played about with a lot of stuff.

So, we now proceeding with using the new GLPI server as our server going forward, as it seems to be working fine now.

If you have time to answer a couple of questions please?

Can we use the same command line for servers that have mongo databases on them? Or is there a different format for the creds.

And do we have to include the creds somewhere in the config for it to import the database instances? Or does it have to be included in the crontab file so it does it every time it runs.

Thanks again for your assistance.

[g-bougard]

Yes, this is the same credentials format for MongoDB inventory.

There's no config parameter dedicated to credentials. But I advise you to use the databaseinventory plugin I told you about in my first answer. This way you won't have to store credentials on the targeted computer. It will be stored more safely in GLPI and will be transmitted to glpi-agent when required.

As you're still in the POC state, try it.

[delboy1966]

Tried DB inventory on the new GLPI server over the weekend. And it worked, where it didn't on the old POC GLPI server.
So, obviously something wrong on the old server. So we will continue our POC on the new one.

When I tried the DB Inventory plugin, the MySQL server was sending its data via a GLPI proxy server, and it didn't propogate the DB Intances. Until I pointed the MySQL server directly at the GLPI server. Is this normal, any server we have configures in DB Inventory has to send its data directly to the GLPI server?

[g-bougard]

Database inventory should work even when sent via a proxy.

[delboy1966]

Again, you are correct.
I've now got it working over the GLPI Proxy.

I've also noticed that some MSSQL servers and some MySQL servers Database Instances are being populated even though we have not set anything up in the Database Inventory plugin, or run glpi-agent on the Assets with any creds.