Posts Tagged ‘netstat’

Mar
05
2010

Ubuntu: Configuring Virtual Hosts to listen on different ports

Files to check
- /etc/apache2/ports.conf
- /etc/apache2/apache2.conf

Consider the ServerName to be “myserver”. Check /etc/hosts for an entry

127.0.0.1 localhost
192.168.1.100 myserver.com myserver

(more…)

  • Share/Save/Bookmark
Feb
05
2010

MySQL: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’

Reason why this error might occur:

i) Incomplete MySQL implementation
ii) MySQL setting mis-configuration

Solution:

root@myserver:/# vi /etc/mysql/my.cnf

Comment out the below line in my.cnf file to make MySQL listen on ALL interfaces
#bind-address = 127.0.0.1

root@myserver:/# netstat -tap | grep mysql
tcp 0 0 *:mysql *:* LISTEN 17785/mysqld

Note that above line which indicates MySQL listening on all interfaces.

  • Share/Save/Bookmark