Forum GLPI-Project

reneouellette

Member

Registered: 2007-07-17

Posts: 4

Link between OCS and GLPI

Hi All

I am testing OCS NG and GLPI.  Both are great pieces of software.

I am trying to get the synchonization to work, but I am running into a road block.

Both system are running on Fedora Core 5.  I am running the latest versions of both applications.

When I try to get GLPI to connect to the OCS NG database, I get database connect failed.

I am able to connect to the OCS NG database from the GLPI server using the MYSQL command line tool, and I can show databases; and show tables; with no problem.  It seems like the system never tries to make the connection to the remote server.  I set MYSQL logging on the OCS NG computer, but don't see a failed login attempt when using the webpage to setup the GLPI-OCS NG information.

Let me know if you need more info.

Thanks,

Rene

reneouellette

Member

Registered: 2007-07-17

Posts: 4

Re: Link between OCS and GLPI

Hi All

I will try this again, as I received no responses.

I think that the database connection to the OCS mysql database is not being made.   Is there some sort of user permission required on the GLPI server to allow this?  Does it use a straight PHP connection, maybe something needs changing in php.ini?  Each server seems to work fine, they just don't want to talk to each other.

When I click post.  I am seeing an error message.

denied {name connect} for pid=xxxx comm=httpd dest=3306

There is more if the entire message is required.

Thanks for any direction you can give,

Rene

slfichtner

Member

Registered: 2007-08-13

Posts: 8

Re: Link between OCS and GLPI

Rene,

I have the same setup as yourself but I am running CentOS 5.  But I've never had a problem.

I have these connection settings:

OCS NG -> GLPI import module configuration

OCSweb host: localhost
Name of the OCS database: ocsweb
User of the OCSweb database: ocs
Password of the OCSweb user: ***

This probably doesn't help but worth a try.

Steve

chacawaca

Member

From: Québec

Registered: 2005-07-11

Posts: 513

Re: Link between OCS and GLPI

OCS NG and GLPI run on the same server or not ?

reneouellette

Member

Registered: 2007-07-17

Posts: 4

Re: Link between OCS and GLPI

The 2 pieces of software are on different servers.

chacawaca

Member

From: Québec

Registered: 2005-07-11

Posts: 513

Re: Link between OCS and GLPI

you have to change a config in mysql to accept connection from the glpi server.

reneouellette

Member

Registered: 2007-07-17

Posts: 4

Re: Link between OCS and GLPI

Hi

I can make Mysql connections to the OCS server from the GLPI server manually, change database, and do table lookups.  It just doesn't seem like the GLPI server is sending the information externally when you make the change through the admin interface.

Thanks,

Rene

ccsmart

Member

Registered: 2007-01-18

Posts: 8

Re: Link between OCS and GLPI

Have the exact same problem.
Any advice ?

7echno7im

Member

Registered: 2007-09-07

Posts: 26

Website

Re: Link between OCS and GLPI

can some one point me to where I can find docs on how to integhrate the 2?

---

www.techtronic.us

ccsmart

Member

Registered: 2007-01-18

Posts: 8

Re: Link between OCS and GLPI

To be more precise:

I configured in http://glpi/glpi/front/setup.config.php?next=ocsng as OCSweb host a remote server by IP and watched what happens with tcpdump. I see no taffic. I do a ping, and i see the ping traffic.

Result:

Connection to the OCS NG database failed

Version is GLPI 0.68.3

Last edited by ccsmart (2007-09-07 19:33:58)