Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Zimbra database and phpMyAdmin

  1. #1
    Join Date
    Jun 2006
    Posts
    12
    Rep Power
    9

    Default Zimbra database and phpMyAdmin

    I've succesfully installed Zimbra and it works great, but I would like to have a propper look at details in the zimbra database using phpMyAdmin.
    Could anyone here please provide advice on how to do this?

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

    Default

    Welcome to the forums.

    Have a search through the forums for details on how to find the password for the MySQL database - that's all you need to get to them.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Join Date
    Jun 2006
    Posts
    12
    Rep Power
    9

    Default

    Hi Bill

    Thanks for your reply. Let me explain my situation a bit better. I currently have Zimbra runing on SUSE 9.3 and phpMyAdmin on a Windows XP machine. Both of these machines are connected to our business network. I have full/root access to both these machines. I have configured Samba on the Linux machine and can access it from any computer on our network (to view files and access the zimbra application).
    My knowledge of Linux and Tomcat is quite poor (Started learning the hard way a week or so ago), but I am reasonably experienced in apache, mysql and php.
    I have tried to connect to the Zimbra mySQL database from my Windows machine using the password/username specified in the opt\zimbra\conf\localconfig.xml file without much success - I get 'server not responding' when I use the ip address of the zimbra box as host name and 'Access denied for user: 'root@dsl-142-242-12.telkomadsl.co.za' (Using password: YES) ' when I use 'http:\\zimbra' (Which is the URL I use to access Zimbra from the windows machine).
    I have also tried running phpMyAdmin from the Tomcat Webapps dir and the httpd-2.0.54\htdocs dir, again without much success.

    I cant access mysql from the terminal either (ERROR 2002 (HY000): Cant connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2))

    Is there any way I can make this work? If not, is there any other way I can view the database structure/contents () ?

    Thanx for the time and effort spent on this post. I really do appreciate your help

    Leslie

  4. #4
    Join Date
    Mar 2006
    Location
    Beaucaire, France
    Posts
    2,322
    Rep Power
    13

    Default

    I'm not sure the mysql daemon running on the Zimbra server listens to network connections. Even if it does, I doubt the mysql root users is allowed to log in from the network.

    Have you tried command line mysql access from the Zimbra server ?

  5. #5
    Join Date
    Jun 2006
    Posts
    12
    Rep Power
    9

    Default

    I have tried to connect from the command line and get the following error: ERROR 2002 (HY000): Cant connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)).
    I think it might be trying to connect me to the default mySQL service which installs with Linux, because the path specified in the 'my.cnf' file in '/opt/zimbra/conf' differs from the path above.

  6. #6
    Join Date
    Jun 2006
    Posts
    12
    Rep Power
    9

    Talking

    I forgot to invoke the zimbra control ('su - zimbra') before calling mysql(stupid me).
    I can now succesfully access the database via the command prompt! Would still be nice if I could somehow make work with phpMyAdmin...
    Thanx guys!

    Leslie

  7. #7
    Join Date
    May 2008
    Posts
    17
    Rep Power
    7

    Default Have you tried SQLyog?

    I have been using SQLyog to connect and view the database tables.
    'zmlocalconfig -s' can get you all the information you need to connect (port, password,...)
    I first run PuTTY and create a tunnel:
    Under Connection-->SSH-->Tunnels select 'Local ports accept connections from other hosts'. Set your source port to whatever local port you want to use. I use 3308. Then set your destination to 127.0.0.1:7306 (assuming that the value for mysql_port when you run 'zmlocalconfig -s | grep mysql_port' is 7306).
    Of course, your Session Host Name points to your Zimbra server. Your Connection-->Data Auto-login username should be set to a username that has rights to connect to your Zimbra server. The 'root' user will work, but for security reasons, it is probably better to use something different.

    Once you open your tunnel, you can run SQLyog to connect.
    Set your MySQL host address to 127.0.0.1.
    Your port will be your local port you set above (3308). You can get your username and password from the zmlocalconfig output.

  8. #8
    Join Date
    Mar 2009
    Posts
    10
    Rep Power
    6

    Default

    To connect Zimbra database in PhpMyAdmin you should change php5 settings. Set mysql.default_socket =/opt/zimbra/db/mysql.sock in php.ini
    mysql.default_host = localhost:7306
    I think thats all. If you'll have another questions write to my e-mail. mr(dot)muldashev(at)gmail(dot)com

  9. #9
    Join Date
    Oct 2009
    Posts
    17
    Rep Power
    6

    Default

    i'm still having this problem:
    #1045 - Access denied for user 'root'@'localhost'

  10. #10
    Join Date
    Mar 2009
    Posts
    10
    Rep Power
    6

    Default

    Could you show log?

Similar Threads

  1. phpMyAdmin
    By Oswald-Kolle in forum Installation
    Replies: 2
    Last Post: 08-31-2006, 01:30 PM

Posting Permissions

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