Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th March 2013, 00:34
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help Installing Ispconfig please

Hello all,

I am folling this tutorial..http://www.howtoforge.com/perfect-se...ot-ispconfig-3 and I ge to the part that says:.

Code:
php -q install.php
I get to the bottom to

Code:
MySQL charset [utf8]: <-- ENTER
and I get

Code:
Unable to connect to the specified MySQL server Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I've done a bit of research before posting here, and it says to mess with the .cnf file and change the part about client. but that didnt work either. so any help that I can get would be appreciated becuase I need ISPConfig up and running soon.

thanks
Reply With Quote
Sponsored Links
  #2  
Old 26th March 2013, 08:31
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is mysql running?

What is the output of
Code:
ps aux | grep mysql | grep -v grep
Did you set your mysql root password before you started install?
If not, you need to do so.
Reply With Quote
  #3  
Old 26th March 2013, 13:41
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply,

when I put in the code you gave me, nothing happens.

I did put in a root password.

I honestly dont know if MYSQL is installed. still new to the Linix world of OS. Anyway to check to see if its installed?

thanks
Reply With Quote
  #4  
Old 26th March 2013, 15:13
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the update.
OK, we have 2 possibilities, MySQL is installed but not running, or it was not installed.

If you have followed step 12 as specified in the article, and did not see any errors, then it could be installed but not running.
In this case, run the following.

Code:
/etc/init.d/mysqld start
You should see something like.

mysql start/running, process xxxx

You can change/specify root password by issuing the following:

Quote:
sudo dpkg-reconfigure mysql-server-5.5
The service would be stopped and you will be prompted to enter an new root password.


If you get an error, file not found, ..etc when running /etc/init.d/mysqld start then we have to assume that MySQL was not installed, or was removed.

In that case, do the following.

Quote:
apt-get install postfix-mysql mysql-client mysql-server dovecot-mysql sudo
When asked to enter root password, choose and enter one.

Now you can use that root password when you install ISP Config.

If you see other issues, please post the output as you see it in your ssh window.
Reply With Quote
  #5  
Old 26th March 2013, 15:29
roe74979 roe74979 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thank you for your response,

I had to follow cod 2, because I did not do step 12 of the instructions because I just wanted ISPconfig, and not the rest.

so I installed MYSQL as instructed via your code. now I get to the same step

Code:
MySQL charset [utf8]: <-- ENTER
and i'm now getting this error:

Code:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2)
ERROR: Unable to load SQL-Dump into database table.
Edit: Could this have anything to do with the fact that i'm doing this remotely from school to my home PC?

thanks

Last edited by roe74979; 26th March 2013 at 15:30. Reason: question
Reply With Quote
  #6  
Old 26th March 2013, 15:44
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by roe74979 View Post
thank you for your response,

I had to follow cod 2, because I did not do step 12 of the instructions because I just wanted ISPconfig, and not the rest.

so I installed MYSQL as instructed via your code. now I get to the same step

Code:
MySQL charset [utf8]: <-- ENTER
and i'm now getting this error:

Code:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2)
ERROR: Unable to load SQL-Dump into database table.
Edit: Could this have anything to do with the fact that i'm doing this remotely from school to my home PC?

thanks
It should not have anything to do with your connection, once you are connected successfully via ssh, your commands are running on the server you are connected to.

ISP Config configuration from that link needs mysql installed and running.
At this point it is either not running or needs to listen on all IPS.
Edit your /etc/mysql/my.cnf and comment out the following line.
bind-address = 127.0.0.1

Something like

Code:
nano /etc/mysql/my.cnf
And then make sure
Code:
#bind-address           = 127.0.0.1
Use Ctrl + O and then Enter to save, Ctrl + x to exit.

Restart mysql

Code:
/etc/init.d/mysql restart
Check if it is running/listening.

Code:
netstat -tap | grep mysql
Then
Code:
ps aux | grep mysql | grep -v grep
Both should not return empty responses. If they did, then mysql is not running and we need to find out why.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Relay access denied when using SMTP to external recipients Kamran Shah Installation/Configuration 111 14th May 2014 18:10
Version 1.3 of the ISPConfig 3 Manual is finally available! falko General 44 2nd December 2011 12:04
PHP warnings after upgrade to ISP config 3.03 stevegjacobs Installation/Configuration 5 30th October 2010 14:31
Error installing ISPConfig on debian omniware Installation/Configuration 3 10th September 2008 15:36
Can I avoid installing the clamav etc. coming with ISPConfig bolero Installation/Configuration 1 28th April 2008 15:23


All times are GMT +2. The time now is 19:29.


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