HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Unable to connect to mysql server Can't connect to local MySQL server through socket (http://www.howtoforge.com/forums/showthread.php?t=37243)

c7p 6th July 2009 20:06

Unable to connect to mysql server Can't connect to local MySQL server through socket
 
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 7th July 2009 00:24

check out

this link

falko 7th July 2009 14:41

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 7th July 2009 22:02

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 8th July 2009 00:32

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 8th July 2009 19:49

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 8th July 2009 22:15

Quote:

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 19th July 2009 10:59

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 19th July 2009 13:10

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 20th July 2009 11:36

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


All times are GMT +2. The time now is 20:37.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.