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

[c7p]

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

[dzudzu]

check out

this link (http://www.tech-recipes.com/rx/762/solve-cant-connect-to-local-mysql-server-through-socket-tmpmysqlsock/)

[falko]

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.

[c7p]

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.

[till]

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.

[c7p]

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 []:mymail@my.com
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 ?

[till]

Sth went wrong... Any idea ?

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?

[c7p]

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.

[till]

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.

[c7p]

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

[till]

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.

[c7p]

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