Results 1 to 3 of 3

Thread: mysql port closed

  1. #1
    Join Date
    Aug 2006
    Posts
    40
    Rep Power
    9

    Unhappy zimbra mysql port closed (backup)

    Hi I want to make a mysqldump in differente host for a zimbra backup, but the port is closed for external connections:

    Code:
     /opt/zimbra/mysql/bin/mysqldump -h 192.168.0.34 -u zimbra --all-databases --socket=/opt/zimbra/db/mysql.sock --password=asfasdfasdfasdf > zimbra.sql
    Code:
    nmap 192.168.0.34 -p 7306
    
    PORT     STATE  SERVICE
    7306/tcp closed unknown

    I looked for config files like my.conf, but nothing talks about external hosts (like pg_hba.conf of a postgres)

    Any ideas? thanks
    Last edited by koby; 09-25-2006 at 04:29 AM.

  2. #2
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    mysqld is bound to localhost by default see /opt/zimbra/my.cnf

    Once you change it to bind to an ip address you needed to update the privilege tables. Here's a reference to the MySQL GRANT command.
    http://dev.mysql.com/doc/refman/4.1/en/grant.html

  3. #3
    dijichi2 is offline OpenSource Builder & Moderator
    Join Date
    Oct 2005
    Posts
    1,176
    Rep Power
    12

    Default

    might be easier and more secure to do the dump through ssh?

Similar Threads

  1. initializing ldap...FAILED(256)ERROR
    By manjunath in forum Installation
    Replies: 39
    Last Post: 06-07-2013, 11:27 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  3. Can't start Zimbra!
    By zibra in forum Administrators
    Replies: 5
    Last Post: 03-22-2007, 12:34 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 07:59 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
  •