Forum GLPI-Project

toroque

Member

Registered: 2019-07-03

Posts: 29

Metabase auto generated database issue

I have this issue with GLPI 9.4.5: when set connection to Metabase, all is fine, but when click on Create GLPI database in local Metabase, I get "No auto-generated GLPI database found".
I have to manual create database in Metabase and then select database in GLPI.

Edit:
in Metabase log I found this:
03-23 12:23:10 ←[1mDEBUG middleware.log←[0m :: POST /api/database 400 16.2 ms (0
DB calls)
{:valid false,
:dbname
"No matching clause: Could not connect to address=(host=localhost)(port=3306)(t
ype=master) : Access denied for user 'user'@'localhost' (using password: YES)\nC
urrent charset is windows-1250. If password has been set using other charset, co
nsider using option 'passwordCharacterEncoding'",
:message
"No matching clause: Could not connect to address=(host=localhost)(port=3306)(t
ype=master) : Access denied for user 'user'@'localhost' (using password: YES)\nC
urrent charset is windows-1250. If password has been set using other charset, co
nsider using option 'passwordCharacterEncoding'"}

But metabase plugin does not allow set user credentials/settings for MariaDB connection.

Last edited by toroque (2020-03-23 13:26:38)

mecmav

Member

From: Brasil

Registered: 2019-03-22

Posts: 330

Re: Metabase auto generated database issue

wrong config in mysql permissions

GGGGRoman

Member

Registered: 2021-05-21

Posts: 16

Re: Metabase auto generated database issue

Can you solve this problem? I have a similar issue.

mecmav

Member

From: Brasil

Registered: 2019-03-22

Posts: 330

Re: Metabase auto generated database issue

Can you solve this problem? I have a similar issue.

you need analyse the response result.

Check your config between metabase database and glpi database.

GGGGRoman

Member

Registered: 2021-05-21

Posts: 16

Re: Metabase auto generated database issue

Can you solve this problem? I have a similar issue.

you need analyse the response result.

Check your config between metabase database and glpi database.

This is the message:  0    =>    No auto-generated GLPI database found
I generated the GLPI database by me without problems.

Ragnarok

Member

Registered: 2019-10-28

Posts: 44

Re: Metabase auto generated database issue

I have same issue, from metabase i can add the connection to glpi database, create querys and get results whitout issues.
Then, from glpi  dashboards wont load at the central page (i see the dashboard at the profile permissions settings)

livier

Member

Registered: 2016-11-15

Posts: 172

Re: Metabase auto generated database issue

Hi,

I have same issue.
Can someone tell me what to do to solve this problem ?
@mecmav : could you be more specific please ?

AlexandraAlisDD

Member

Registered: 2022-02-25

Posts: 3

Re: Metabase auto generated database issue

i am facing the issue, kindly do the needful for the same.

lexcyr

Member

Registered: 2022-12-02

Posts: 8

Re: Metabase auto generated database issue

I have same issue, from metabase i can add the connection to glpi database, create querys and get results whitout issues.
Then, from glpi  dashboards wont load at the central page (i see the dashboard at the profile permissions settings)

I have the same issue.

@Ragnarok have you found a solution ?

Thanks

goaguiar99

Member

Registered: 2022-11-17

Posts: 14

Re: Metabase auto generated database issue

Having the same problem here... Someone can help?

Last edited by goaguiar99 (2024-03-13 20:50:42)

mecmav

Member

From: Brasil

Registered: 2019-03-22

Posts: 330

Re: Metabase auto generated database issue

metabase database was created successfully?
if yes and metabase started and working properly, you need verify your config in metabase.
dashboards and questions need to be checked to be active and visible to glpi application.
after that, you need assign the dashboard to an user profile in glpi.
you will need to see these questions and dashboards in the desired profile, selecting it or not to being visible.