View Single Post
  #6  
Old 26th March 2013, 16: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