Unable to connect to mysql server Can't connect to local MySQL server through socket

Discussion in 'Installation/Configuration' started by c7p, Jul 6, 2009.

  1. c7p

    c7p New Member

    Hello. I'm trying to install ispconfig 3 on fedora 11. And i face a problem during installation.


    [root@localhost install]# php -q install.php


    --------------------------------------------------------------------------------
    _____ ___________ _____ __ _
    |_ _/ ___| ___ \ / __ \ / _(_)
    | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _
    | | `--. \ __/ | | / _ \| '_ \| _| |/ _` |
    _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| |
    \___/\____/\_| \____/\___/|_| |_|_| |_|\__, |
    __/ |
    |___/
    --------------------------------------------------------------------------------


    >> Initial configuration

    Operating System: Redhat or compatible, unknown version.

    Following will be a few questions for primary configuration so be careful.
    Default values are in [brackets] and can be accepted with <ENTER>.
    Tap in "quit" (without the quotes) to stop the installer.


    Select language (en,de) [en]:

    Installation mode (standard,expert) [standard]:

    Full qualified hostname (FQDN) of the server, eg server1.domain.tld [localhost.localdomain]:

    MySQL server hostname [localhost]:

    MySQL root username [root]:

    MySQL root password []: pass

    MySQL database to create [dbispconfig]:

    MySQL charset [utf8]:

    Unable to connect to mysql server Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    ------

    Also i think that the following is interesting

    --

    [root@localhost /]# mysql -u root -p

    mysql> SHOW GLOBAL VARIABLES LIKE 'socket';
    +---------------+-----------------+
    | Variable_name | Value |
    +---------------+-----------------+
    | socket | /tmp/mysql.sock |
    +---------------+-----------------+
    1 row in set (0.10 sec)

    ---
    Thank you
     
  2. dzudzu

    dzudzu New Member

  3. falko

    falko Super Moderator Howtoforge Staff

    You can try to create a symlink from /var/lib/mysql/mysql.sock to /tmp/mysql.sock, or you change the location of the MySQL socket in your my.cnf.
     
  4. c7p

    c7p New Member

    Thank you both guys :D No im getting the following message

    ERROR: Stopped: Database already contains some tables.

    Also i want to mention that i need ispconfig to control my webserver (lamp) , mainly apache's virtual hosts , at least for now.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    This means that the database that you use already exists and contains database tables. make sure that the database name that you specify in the ispconfig installer does not exist.
     
  6. c7p

    c7p New Member

    I deleted the database and i managed to install ispconfig

    here is the output
    --
    [c7p@localhost ~]$ su
    Password:
    [root@localhost c7p]# cd /home/c7p/Download/server/ispconfig3_install/install/
    [root@localhost install]# php -q install.php

    --------------------------------------------------------------------------------
    _____ ___________ _____ __ _
    |_ _/ ___| ___ \ / __ \ / _(_)
    | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _
    | | `--. \ __/ | | / _ \| '_ \| _| |/ _` |
    _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| |
    \___/\____/\_| \____/\___/|_| |_|_| |_|\__, |
    __/ |
    |___/
    --------------------------------------------------------------------------------


    >> Initial configuration

    Operating System: Redhat or compatible, unknown version.

    Following will be a few questions for primary configuration so be careful.
    Default values are in [brackets] and can be accepted with <ENTER>.
    Tap in "quit" (without the quotes) to stop the installer.


    Select language (en,de) [en]:

    Installation mode (standard,expert) [standard]:

    Full qualified hostname (FQDN) of the server, eg server1.domain.tld [localhost.localdomain]:

    MySQL server hostname [localhost]:

    MySQL root username [root]:

    MySQL root password []: tl4ntbdnd123

    MySQL database to create [dbispconfig]:

    MySQL charset [utf8]:

    Generating a 2048 bit RSA private key
    ..............................+++
    ...........+++
    writing new private key to 'smtpd.key'
    -----
    You are about to be asked to enter information that will be incorporated
    into your certificate request.
    What you are about to enter is what is called a Distinguished Name or a DN.
    There are quite a few fields but you can leave some blank
    For some fields there will be a default value,
    If you enter '.', the field will be left blank.
    -----
    Country Name (2 letter code) [GB]:GB
    State or Province Name (full name) [Berkshire]:
    Locality Name (eg, city) [Newbury]:
    Organization Name (eg, company) [My Company Ltd]:
    Organizational Unit Name (eg, section) []:
    Common Name (eg, your name or your server's hostname) []:
    Email Address []:[email protected]
    Configuring Jailkit
    Configuring SASL
    Configuring PAM
    Configuring Courier
    chmod: cannot access `/etc/authlib/authmysqlrc~': No such file or directory
    PHP Warning: fopen(/etc/authlib/authdaemonrc): failed to open stream: No such file or directory in /home/c7p/Download/server/ispconfig3_install/install/lib/install.lib.php on line 244
    PHP Warning: filesize(): stat failed for /etc/authlib/authdaemonrc in /home/c7p/Download/server/ispconfig3_install/install/lib/install.lib.php on line 247
    Configuring Spamassassin
    Configuring Amavisd
    Configuring Getmail
    Configuring Pureftpd
    Configuring MyDNS
    Configuring Apache
    Configuring Firewall
    Installing ISPConfig
    ISPConfig Port [8080]:

    Configuring DBServer
    Installing Crontab
    no crontab for root
    no crontab for getmail
    Restarting services ...
    Stopping MySQL: [ OK ]
    Starting MySQL: [ OK ]
    Shutting down postfix: [FAILED]
    Starting postfix: [ OK ]
    Stopping saslauthd: [FAILED]
    Starting saslauthd: [ OK ]
    Stopping httpd: [ OK ]
    [Wed Jul 08 23:41:30 2009] [warn] NameVirtualHost *:443 has no VirtualHosts
    [Wed Jul 08 23:41:30 2009] [warn] NameVirtualHost *:80 has no VirtualHosts
    Starting httpd: [FAILED]
    [root@localhost install]#


    ---
    Sth went wrong... Any idea ?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Your server enviroment has not all required software installed, Please configure your server exactly as descibed in the perfect setup guide before you install ISPConfig.

    Which Linux distribution do you use?
     
  8. c7p

    c7p New Member

    I use fedora 11 (kernel linux 2.6.29.4-167.fc11.i585), not the server edition. That's why i didn't followed the guide word by word.
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Fedora 11 is not supported by iSPConfig as not all required software like courier can be compiled on fedora 11 as the fordora project has changed their glib to an incompatible version were many projects will not compile on without modifications of the source code.
     
  10. c7p

    c7p New Member

    Thank you. So i should forget ispconfig ...?
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    The problem is in fedora 11 and not in ISPConfig. ISPConfig itself works perfectly on any fedora version, but as long as system requirements like courier /which is a very widely used imap server) can not be compiled on fedora 11, you can not install ISPConfig.

    Fedora 11 is not a good choice for a server as it tends to break setups from time to time as they try to use only bleeding edge software which is a bad strategy for a server. To run a server, better use e.g. centos which is a clone of rhel and which is made to run servers.
     
  12. c7p

    c7p New Member

    I know CentOS . I tried it first as server but i faced a lot of problems :( , now im ok with fedora :cool:, everything works great !!!

    Thank you till
     

Share This Page