OCS Database connection failed
-
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
-
Hi,
I got the same error on multiple installations and couldn't figure out the problems causing it.
Greetings,
Ufi -
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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login