Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    OCS Database connection failed

    Scheduled Pinned Locked Moved Operating
    3 Posts 2 Posters 2.5k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S Offline
      sebastian.henke
      last edited by

      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 🙂

      1 Reply Last reply Reply Quote 0
      • U Offline
        Ufi
        last edited by

        Hi,

        I got the same error on multiple installations and couldn't figure out the problems causing it.

        Greetings,
        Ufi

        1 Reply Last reply Reply Quote 0
        • S Offline
          sebastian.henke
          last edited by

          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.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post