You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2020-03-23 13:10:48

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)

Offline

#2 2020-03-25 15:20:14

mecmav
Member
From: Brasil
Registered: 2019-03-22
Posts: 326

Re: Metabase auto generated database issue

wrong config in mysql permissions

Offline

#3 2021-07-16 08:31:41

GGGGRoman
Member
Registered: 2021-05-21
Posts: 16

Re: Metabase auto generated database issue

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

Offline

#4 2021-07-16 17:55:50

mecmav
Member
From: Brasil
Registered: 2019-03-22
Posts: 326

Re: Metabase auto generated database issue

GGGGRoman wrote:

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.

Offline

#5 2021-07-19 08:56:41

GGGGRoman
Member
Registered: 2021-05-21
Posts: 16

Re: Metabase auto generated database issue

mecmav wrote:
GGGGRoman wrote:

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.

Offline

#6 2021-08-20 05:31:00

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)

Offline

#7 2022-01-05 06:26:40

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 ?

Offline

#8 2022-02-26 11:43:49

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.

Offline

#9 2023-05-12 20:15:38

lexcyr
Member
Registered: 2022-12-02
Posts: 8

Re: Metabase auto generated database issue

Ragnarok wrote:

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

Offline

#10 2024-03-13 20:50:14

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)

Offline

#11 2024-03-14 13:53:21

mecmav
Member
From: Brasil
Registered: 2019-03-22
Posts: 326

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.

Offline

Board footer

Powered by FluxBB