Can't connect to SQL server

[BlackxRyan]

Hi tomolino.

I'm now trying to work on the society domain with two separate virtual machines :

172.17.255.2 : pm.1fogenie.fr 172.17.255.138 : glpitest.1fogenie.fr

These two domain names are registered in the DNS server.

The processmaker setup is ok :

But I can't connect to the SQL server and I'm sure the logins are the correct ones.

The database is named wf_workflow :

And my user has all privileges :

[tomolimo]

Hello @BlackxRyan

Where is the mysql server? On the GLPI machine or on the PM machine?

Regards, Tomolimo

[BlackxRyan]

The one with "wf_workflow" ? On PM machine.

[tomolimo]

the one which hosts PM DB. and the 'SQL server' must contains the server name of the server hosting the PM DB

[BlackxRyan]

It's the PM machine.

[tomolimo]

then don't use localhost, but pm.1fogenie.fr

[tomolimo]

but beware that the 'SQL user' account must have the remote access privilege.

[BlackxRyan]

Where can I check that ?

[tomolimo]

in PHPmyadmin

[tomolimo]

Seems like your root user has only the localhost access, and not the remote '%'

[tomolimo]

or any host that is valid. In your case, you may use glpitest.1fogenie.fr

[BlackxRyan]

Here are the users :

[tomolimo]

then you may use the root as it has the % and also the glpitest.1fognie.fr in its client field. Note: that only one of both is necessary.

[tomolimo]

ah, sorry I didn't see the Grant: 'non' for 'glpitest....' so anyway the root has the client % so there is no restriction to use it from glpi server.

[BlackxRyan]

It just updated

So what do I put in the SQL server field ?

[tomolimo]

pm.1fogenie.fr wf_workflow root root password

[BlackxRyan]

Still not works

And it takes a while to load.

[tomolimo]

try with IP address instead of pm.1fogenie.fr

[BlackxRyan]

Doesn't work too.

[tomolimo]

Could it be possible that something prevents network traffic from glpitest.1fogenie.fr to pm.1fogenie.fr?

[BlackxRyan]

Each machine can ping the other, and the PM configuration worked...

Is it using a particular port ?

[tomolimo]

Default mysql port is 3306. By the way did you activate network interface in mysql configuration?

[tomolimo]

I think the network interface of mysql is not active. Due to the fact that by default it is using pipes for localhost communications

[BlackxRyan]

Solved, I used what was told here : https://stackoverflow.com/a/14779244/9590095

I used the IP address for MySQL configuration (and created a user pm too).

It works correctly now.

Thanks for your help

[tomolimo]

you're welcome