You are not logged in.
Pages: 1
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,
Offline
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
Offline
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,
Offline
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
Offline
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)
Offline
and this....
[root@c6-glpi-l1 log]# setsebool -P httpd_can_network_connect 1
Offline
Pages: 1