Unfortunately when I copy the Database from the OCS Server to the local Database on the i-doit installation it works like a charm. But thats not a practicable solution.
Furthermore I can't figure out how to specify the connection OCS-Object<-> i-doit Object in the GUI. Some Information isn't passed at all like the User in OCS.
Greetings everybody
I've just installed a fresh I-DOIT 1.48 on Ubuntu 14.04 LTS and ran into some problems connecting to our OCS 2.1 RC1. Running on a seperate server, the OCS has been in use for some years now without any trouble. To connect the i-doit I created a user in MySQL on the OCS server and allowed external access. This configuration seems to be allright, because I can login and obtain data when I connect from the I-Doit Server Command Line:
hr]
root@xxxx:/var/www/html# mysql -u idoit -p -D ocsweb -h 192.168.0.5
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 102
Server version: 5.0.22-Debian_0ubuntu6.06.15-log
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| ocsweb |
+--------------------+
2 rows in set (0.00 sec)
But when I configure these settings into i-doit GUI I get an error: "Could not connect to OCS database"
Is there a detailed log file to figure out the reason causing this error? Are any special rights need for the MySQL connection?
Thanks in advance - any help is much appreciated 
Hallo
auf meiner neu installierten I-DOIT 1.48 funktioniert die Koppelung zur vorhandenen OCS 2.1RC1 nicht.
Das OCS befindet sich auf einem anderen Server auf dem bereits ein MySQL User erstellt wurde, welcher die Anfragen von I-DOIT ausführen soll. Verbindungen von außen sind zugelassen und die der Aufruf von der Shell der I-DOIT Installation funktioniert auch:
root@xxxx:/var/www/html# mysql -u idoit -p -D ocsweb -h 192.168.0.5
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 102
Server version: 5.0.22-Debian_0ubuntu6.06.15-log
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| ocsweb |
+--------------------+
2 rows in set (0.00 sec)
Die Eingabe derselben Daten in der i-doit GUI führt aber zu einem Fehler: "Could not connect to OCS database"
Gibt es eine Log Datei mit genaueren Informationen warum der Login nicht funktioniert? Welche Rechte braucht der MySQL Benutzer auf der OCS Seite?
Danke für eure Hilfe