Hello
I have a problem with the OCS integration at the level of the connection with the OCS database.
I have set up a user with a password on the OCS database. I gave him the rights of remote connection.
I can launch a mysql on the OCS database from the ITOP server which is not the same server.
I have filled in these parameters in the params.distrib.xml file but when I launch the php it tells me that it is not possible to connect as root
[2022-02-09 07:53:24][Debug] Available PDO drivers: mysql [2022-02-09 07:53:24][Debug][OCSBrandCollector] Connection string: 'mysql:dbname=ocsweb;charset=UTF8;host=localhost' [2022-02-09 07:53:24][Error][OCSBrandCollector] Database connection failed: SQLSTATE[HY000][1698] Access denied for user 'root'@'localhost' [2022-02-09 07:53:24][Error] OCSBrandCollector::Prepare() returned false
We have created a replacement for OCS-NG to iTop CMDB Integration,
We created it to be better, efficient in inventorying process which is more crucial in a helpdesk. We have tested it rigorously so that you can get started with it.
Hello
I have a problem with the OCS integration at the level of the connection with the OCS database.
I have set up a user with a password on the OCS database. I gave him the rights of remote connection.
I can launch a mysql on the OCS database from the ITOP server which is not the same server.
I have filled in these parameters in the params.distrib.xml file but when I launch the php it tells me that it is not possible to connect as root
[2022-02-09 07:53:24] [Debug] Available PDO drivers: mysql
[2022-02-09 07:53:24] [Debug] [OCSBrandCollector] Connection string: 'mysql:dbname=ocsweb;charset=UTF8;host=localhost'
[2022-02-09 07:53:24] [Error] [OCSBrandCollector] Database connection failed: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
[2022-02-09 07:53:24] [Error] OCSBrandCollector::Prepare() returned false
my params.distib.xml file
<sql_host>192.168.0.2</sql_host>
<sql_database>ocsweb;charset=UTF8</sql_database>
<sql_login>user</sql_login>
<sql_password>XXXX</sql_password>
I don't understand why it doesn't attack the ip address 192.168.0.2
thanks in advance
Frédéric BOER
Service Informatique
0321615559
frederic.boer@sivom-bethunois.fr
www.sivom-bethunois.fr [ https://www.facebook.com/sivom.bethunois/ ]
Hello,
Seems like you are you talking about the Data collector for OCS Inventory, right ?
Your configuration file should be named conf/params.local.xml. See Install the Data collector for OCS Inventory
Dear Frederic,
We have created a replacement for OCS-NG to iTop CMDB Integration,
We created it to be better, efficient in inventorying process which is more crucial in a helpdesk. We have tested it rigorously so that you can get started with it.
Feel free to try it out and let us know https://github.com/cdmx1/itop_data_collector_fleetdm
Regards
Team CodeMax