Forum GLPI-Project

-DemiGodz-

Member

Registered: 2012-11-16

Posts: 2

OCS importing to GLPI server

Hi,

I just want to ask if possible to connect my other OCS DB to my main GLPI server.
I have my main OCS DB (10.10.1.100) and i have another OCS DB (10.10.1.101) and my main GLPI server is (10.10.1.100). Is it possible to connect my other OCS DB (10.10.1.101) to my main GLPI server.

Here's my GLPI configuration

Name : localhost
Host for the OCSNG database : localhost
Name of the OCSNG database : ocsweb
OCSNG database user : ocs
OCSNG user password : ********

I tried to add another OCS DB but it say's "Connection to the OCSNG database failed"

Name : localhost
Host for the OCSNG database : 10.10.1.101  <--- (do I need to put hostname or IP )
Name of the OCSNG database : ocsweb
OCSNG database user : ocs
OCSNG user password : ********

Thanks..

Regards,

shashank.kattige101

Member

Registered: 2012-11-19

Posts: 2

Re: OCS importing to GLPI server

go to your new ocsng database server (10.10.1.101) and edit the file my.cnf which is located in /etc/mysql/

comment the line bind-address = 127.0.0.1 and write a new line bind-address = 10.10.1.101

And then in glpi try this :

Name : localhost --------------[I used glpi while installing glpi]
Host for the OCSNG database : 10.10.1.101
Name of the OCSNG database : ocsweb
OCSNG database user : ocs---------------[here i used the "root" user and password which i created on mysql]
OCSNG user password : ********

It should work, worked for me let me know.

Last edited by shashank.kattige101 (2012-11-19 09:08:53)

---

Shashank

-DemiGodz-

Member

Registered: 2012-11-16

Posts: 2

Re: OCS importing to GLPI server

go to your new ocsng database server (10.10.1.101) and edit the file my.cnf which is located in /etc/mysql/

comment the line bind-address = 127.0.0.1 and write a new line bind-address = 10.10.1.101

And then in glpi try this :

Name : localhost --------------[I used glpi while installing glpi]
Host for the OCSNG database : 10.10.1.101
Name of the OCSNG database : ocsweb
OCSNG database user : ocs---------------[here i used the "root" user and password which i created on mysql]
OCSNG user password : ********

It should work, worked for me let me know.

Thanks for the reply... but its not working with me.. Do I to use only the "root" username and not the ocs as a default SQL username for ocs... Because i can't use the "root" as username because only our unix admin know that.. Is there other way? Thanks..

Regards,

shashank.kattige101

Member

Registered: 2012-11-19

Posts: 2

Re: OCS importing to GLPI server

I dont think there is any other way.Even i used "ocs" many time but it didnt work.As soon as i changed it to root user it worked.
Let me know if you find any other way.

---

Shashank

zibi

Member

Registered: 2013-02-08

Posts: 2

Re: OCS importing to GLPI server

Guys

In my case the issue was because GLPI server was blocking Apache outbound connection. The following commands helped to fix this:

[root@c6-glpi-l1 log]# setsebool httpd_can_network_connect_db 1

Last edited by zibi (2013-02-08 11:42:48)

zibi

Member

Registered: 2013-02-08

Posts: 2

Re: OCS importing to GLPI server

and this....

[root@c6-glpi-l1 log]# setsebool -P httpd_can_network_connect 1