MySql-Server Installation Problem

Discussion in 'Installation/Configuration' started by coyote, Aug 31, 2007.

  1. coyote

    coyote New Member

    I have a VirtualServer with Debian Etch an i prepared it with "The Perfect Setup - Debian Etch"-Tutorial. Everything goes fine except of Bind9. Bind9 is not able to run on my vserver, but I think that don't need it.

    Now my problem:

    When I run the Setup of ispconfig I got no errors. At the end of the installation I got the question: Please enter your MySQL server:
    I wrote "localhost", but that doesn't works...

    But what is the name of my MySQL-Server?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post the output of:

    netstat -tap
     
  3. coyote

    coyote New Member

    tcp 0 0 xxxxx.vserver4fr:mysql localhost:45904 ESTABLISHED1 0779/mysqld
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    This can not be the complete output. Is this the only line that contains mysql?
     
  5. coyote

    coyote New Member

    sorry, i forgot 2 lines. but thats all!
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Your mysql daemon listens on xxxxxx.vserver4fr and not localhost, this is most likely a misconfiguration of your hosts file. Please post the content of the file /etc/hosts
     
  7. coyote

    coyote New Member

    /etc/hosts:

     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, it looks like they did configure mysql a bit different in their vserver setup. Instead of reconfiguring everything, please try to use as mysql server in the ISPConfig setup:

    XXXXXX.vserver4free.de
     
  9. coyote

    coyote New Member

    Ok, I tried this.

    In the "Perfect Setup"-Tutorial I have to write this command:

    Here I got the first error:

    When I type 'XXXXXX.vs3325.vserver4fre.de' in the setup of ispconfig I get the error:
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Please edit the file:

    /etc/mysql/my.cnf

    and comment out the bind-address line, so that it looks like this:

    #bind-address = 127.0.0.1

    and restart mysql.
     
  11. coyote

    coyote New Member

    Same problem. :(

    Here is my configuration in summary:
    netstat -tap
    /etc/mysql/my.cnf
    Output during the Installation of ISPConfig
    Am I the only vserver-user who has such problem?? I hope for help...
     
  12. falko

    falko Super Moderator Howtoforge Staff

    What's the output of
    Code:
    ifconfig
    ? Also, please replace
    Code:
    127.0.0.1 localhost
    with
    Code:
    127.0.0.1 localhost.localdomain localhost
    in your /etc/hosts.
     
  13. coyote

    coyote New Member

    ifconfig:
    /etc/hosts
    Changes at /etc/hosts have no effect! Same error! ("Der angegebene MySQL-Server kann nicht erreicht werden!")
     
  14. falko

    falko Super Moderator Howtoforge Staff

    Does
    Code:
    mysql -h 127.0.0.1 -u root -p
    work?
     
  15. coyote

    coyote New Member

    Yes, this works fine.
     
  16. falko

    falko Super Moderator Howtoforge Staff

    And what about
    Code:
    mysql -h localhost -u root -p
    ?
     
  17. coyote

    coyote New Member

    this works, too!!!
     
  18. falko

    falko Super Moderator Howtoforge Staff

    It should work then. Are you sure you entered localhost without any spaces during the ISPConfig installation?
     
  19. coyote

    coyote New Member

    Yes, I wrote "localhost" without any mistake and I did the installation several times with always the same result: It doesn't work!!
     
  20. falko

    falko Super Moderator Howtoforge Staff

    Then I have no idea what's wrong with your system... :(
     

Share This Page