Forum GLPI-Project

Josef

Member

Registered: 2009-01-20

Posts: 10

OCSNG - Can't connect to MySQL server

Hi everyone!
Can anyone please help me out. I'm a newbie setting this one up I encountered following error when configuring the import module: (debug mode)

PHP ERROR: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '172.34.0.108' (10060) in C:\xampp\htdocs\glpi\inc\dbmysql.class.php at line 74

PHP ERROR: mysql_close(): supplied argument is not a valid MySQL-Link resource in C:\xampp\htdocs\glpi\inc\dbmysql.class.php at line 296

I'm running a standard OCS 1.01 windows install on a windows xp sp3 machine.
GLPI is last stable 0.71.3 running xampp 1.6.8 on a win2003 server.
I triple checked the user/password and even created a new one.

Thanks a lot!

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Re: OCSNG - Can't connect to MySQL server

It's probably the rights on MySQL DB

Josef

Member

Registered: 2009-01-20

Posts: 10

Re: OCSNG - Can't connect to MySQL server

It's probably the rights on MySQL DB

Wow, thanks for the fast reply!

This is what phpmyadmin says about privileges (is it ok?):

  Users having access to "ocsweb" 
User      Host      Type      Privileges      Grant      Action
glpi     %     global     ALL PRIVILEGES     Yes     Edit Privilegesleges

Thanks again

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Re: OCSNG - Can't connect to MySQL server

it's like it, this user must be defined in OCS database configuration in GLPI.
For most security, change the host % by IP of the GLPI server

Josef

Member

Registered: 2009-01-20

Posts: 10

Re: OCSNG - Can't connect to MySQL server

Thanks for your help ddurieux, you pointed in the right direction:
The xp firewall was blocking glpi!

I had no problem submitting information from other computers to ocs, but glpi was beeing blocked.
o_O