Results 1 to 10 of 10

Thread: Connect to Zimbra's MySQL via ODBC?

  1. #1
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default Connect to Zimbra's MySQL via ODBC?

    Hello!

    I was wondering if it was possible to connect to Zimbra's database using ODBC?

    - jesse

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    As long as it is bound to a IP address, outside of 127.0.0.1, then there should be no reason why you cannot connect it you have the user name and password.

  3. #3
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default

    Hi all.

    I was hoping for some guidance. I'm trying to access the MySQL database on my Zimbra server using an ODBC connection from a Windows XP system. I got the necessary information such as username and password and database name, but it's not letting me connect.

    I fear I might be doing something on the higher level, such as needing samba running or something.

    Has anyone set up an ODBC connection in this manner? If so, can you post your suggestions?

    Much appreciated. I'll post back here as I discover it.

    - Jesse

  4. #4
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default

    I seem to be running into a snag. The problem seems to have something to do with being unable to view/run MySQL commands unless you're in the Zimbra user account.

    For example, I cannot log in to the MySQL shell unless I'm running it as the Zimbra user (not even root works).

    su zimbra
    mysql -p

    Then I can log in.

    So only the Zimbra user can view the database and run database commands. In the Synaptic package manager (I'm using Ubuntu 8.04) I noticed that MySQL server was not installed so I installed it - and it promptly broke the Zimbra installation, although I could then log in and view the databases as root.

    I'm currently reinstalling the system - it's a test system for this purpose alone.

    Seems to be that the system doesn't recognize the database since it's not the standard installation - so the system looks to where MySQL is supposed to be and finds nothing.

    Does anyone know how I can tell the system where to look for the database files and socket files and such?

    Thanks!

    - Jesse

  5. #5
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,587
    Rep Power
    58

    Default

    Quote Originally Posted by jreinhart View Post
    I noticed that MySQL server was not installed so I installed it - and it promptly broke the Zimbra installation, although I could then log in and view the databases as root.
    It's highly improbable that installing the o/s MySQL did that, Zimbra uses non-standard ports for MySQL. Many users run a separate instance of MySQL on their Zimbra server without problems.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default

    OK. I'm not really concerned about running multiple databases on the Zimbra box, only with accessing the data in Zimbra's MySQL instance.

    Do you have any advice or insight? I can't believe this hasn't been done or can't be done, but I lack the know how on it.

    Thanks very much for your time and input.

    - Jesse

  7. #7
    Join Date
    Oct 2008
    Location
    Bhutan
    Posts
    59
    Rep Power
    7

    Wink

    Quote Originally Posted by jreinhart View Post
    Hi all.

    I was hoping for some guidance. I'm trying to access the MySQL database on my Zimbra server using an ODBC connection from a Windows XP system. I got the necessary information such as username and password and database name, but it's not letting me connect.

    I fear I might be doing something on the higher level, such as needing samba running or something.

    Has anyone set up an ODBC connection in this manner? If so, can you post your suggestions?

    Much appreciated. I'll post back here as I discover it.

    - Jesse
    could you give me some info on which mysql user and password to use in the ODBC connection and also the database name info

  8. #8
    Join Date
    Nov 2005
    Location
    Beloit, Wisconsin
    Posts
    71
    Rep Power
    9

    Default

    I didn't look but I am guessing mysql is setup to only listen to localhost and that is why you can't login from your XP box.

  9. #9
    Join Date
    Jul 2008
    Location
    Los Angeles, CA
    Posts
    51
    Rep Power
    7

    Default

    I don't remember the actual command, but there's a ZM command you can run to get the connection info for your ODBC connection, including the username and password.

    However, I still was unable to get a connection to the database to pull information out.

    Sorry I can't be of better use!

    - Jesse

  10. #10
    Join Date
    Oct 2008
    Location
    Bhutan
    Posts
    59
    Rep Power
    7

    Thumbs up

    well jesse thanks for the info.....

Similar Threads

  1. zmclamdctl is not running after upgrade
    By Darren in forum Installation
    Replies: 24
    Last Post: 10-10-2008, 09:10 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  4. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  5. Can't send or receive mails from Zimbra
    By ppurama in forum Administrators
    Replies: 4
    Last Post: 11-14-2005, 09:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •