I tried to follow the http://howtoforge.com/perfect_setup_debian_sarge_p4 and I got stuck at this: # apt-get install mysql-server mysql-client libmysqlclient12-dev Reading Package Lists... Done Building Dependency Tree... Done Suggested packages: mysql-doc The following NEW packages will be installed: libmysqlclient12-dev mysql-client mysql-server 0 upgraded, 3 newly installed, 0 to remove and 2 not upgraded. 1 not fully installed or removed. Need to get 0B/6981kB of archives. After unpacking 18.3MB of additional disk space will be used. Preconfiguring packages ... dpkg: `ldconfig' not found on PATH. dpkg: `start-stop-daemon' not found on PATH. dpkg: `install-info' not found on PATH. dpkg: `update-rc.d' not found on PATH. dpkg: 4 expected program(s) not found on PATH. NB: root's PATH should usually contain /usr/local/sbin, /usr/sbin and /sbin. E: Sub-process /usr/bin/dpkg returned an error code (2) root@ns2:~# export PATH=${PATH}:/sbin:/usr/sbin root@ns2:~# apt-get install mysql-server mysql-client libmysqlclient12-dev Reading Package Lists... Done Building Dependency Tree... Done Suggested packages: mysql-doc The following NEW packages will be installed: libmysqlclient12-dev mysql-client mysql-server 0 upgraded, 3 newly installed, 0 to remove and 2 not upgraded. 1 not fully installed or removed. Need to get 0B/6981kB of archives. After unpacking 18.3MB of additional disk space will be used. Preconfiguring packages ... Selecting previously deselected package mysql-client. (Reading database ... 31895 files and directories currently installed.) Unpacking mysql-client (from .../mysql-client_4.0.24-10_i386.deb) ... Selecting previously deselected package mysql-server. Unpacking mysql-server (from .../mysql-server_4.0.24-10_i386.deb) ... Selecting previously deselected package libmysqlclient12-dev. Unpacking libmysqlclient12-dev (from .../libmysqlclient12-dev_4.0.24-10_i386.deb) ... Setting up ipopd (2002edebian1-11) ... WARNING: Port "pop2" unselected in debconf but possibly handled locally. Creating generic self-signed certificate: /etc/ssl/certs/ipop3d.pem (replace with hand-crafted or authorized one if needed). hostname: Unknown host dpkg: error processing ipopd (--configure): subprocess post-installation script returned error exit status 1 Setting up mysql-client (4.0.24-10) ... Setting up mysql-server (4.0.24-10) ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Setting up libmysqlclient12-dev (4.0.24-10) ... Errors were encountered while processing: ipopd E: Sub-process /usr/bin/dpkg returned an error code (1) And also it is important that how to place /usr/sbin into root path permanently (I am logged to the remote server as root through ssh). I amd executing "export PATH=${PATH}:/sbin:/usr/sbin" each time I need to install something using apt-get. Thank you! Dr.Sichnendra Bista eParliament.org
What is the output of the command: tail /etc/hostname and /bin/hostname Did you get any errors in your masql logfile in /var/log/mysql/
The output Thanks Till: 1) The output initially was: ns2.freeregistrat.net (which is incorrect) 2) So I changed that to ns1.freeregistrar.net ns2.freeregistrar.net in /etc/hostname 3) now the output is as in 2) 4) I tried to reinstall again the mysql-server, it said, # apt-get install mysql-server mysql-client libmysqlclient12-dev Reading Package Lists... Done Building Dependency Tree... Done mysql-server is already the newest version. mysql-client is already the newest version. libmysqlclient12-dev is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded. 1 not fully installed or removed. Need to get 0B of archives. After unpacking 0B of additional disk space will be used. Setting up ipopd (2002edebian1-11) ... WARNING: Port "pop2" unselected in debconf but possibly handled locally. Creating generic self-signed certificate: /etc/ssl/certs/ipop3d.pem (replace with hand-crafted or authorized one if needed). hostname: Unknown host dpkg: error processing ipopd (--configure): subprocess post-installation script returned error exit status 1 Errors were encountered while processing: ipopd E: Sub-process /usr/bin/dpkg returned an error code (1) Thanks again!
Only one hostname, the problem persists! I put only one hostname now and the problem persists and when I try to see the stauts of mysql it says it is stopped and when I try to start with /etc/init.d/mysql start, it says: # /etc/init.d/mysql start Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Help solicited!
Please run Code: updatedb locate mysql and look if you can find a mysqld.sock or mysql.sock in the results. Can you post your /etc/mysql/my.cnf here? Also, what's in /etc/hosts? And what's the output of Code: netstat -tap ?
Update to your queries 1 Dear Falko: 1) There is no file called mysqld.sock and mysql.sock 2) The /etc/mysql/my.cnf reads as follows: # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. #bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K # # * Query Cache Configuration # query_cache_limit = 1048576 query_cache_size = 16777216 query_cache_type = 1 # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. #log = /var/log/mysql.log #log = /var/log/mysql/mysql.log # # Error logging goes to syslog. This is a Debian improvement # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication. #server-id = 1 log-bin = /var/log/mysql/mysql-bin.log # See /etc/mysql/debian-log-rotate.conf for the number of files kept. max_binlog_size = 104857600 #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # * BerkeleyDB # # The use of BerkeleyDB is now discouraged and support for it will probably # cease in the next versions. skip-bdb # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # # * Security Feature # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # If you want to enable SSL support (recommended) read the manual or my # HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M
Updates to your query 2 3) The contents of /etc/hosts 127.0.0.1 localhost # The following lines are desirable for IPv6 capable hosts # (added automatically by netbase upgrade) ::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts 217.64.201.66 ns1.freeregistrar.net ns1 217.64.202.17 ns2.freeregistrar.net ns2 4) the netstat -tap output: Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:imaps *:* LISTEN 27825/inetd tcp 0 0 *op3s *:* LISTEN 27825/inetd tcp 0 0 *:xmpp-client *:* LISTEN 27480/jabberd tcp 0 0 *op2 *:* LISTEN 27825/inetd tcp 0 0 *op3 *:* LISTEN 27825/inetd tcp 0 0 *:imap2 *:* LISTEN 27825/inetd tcp 0 0 *:xmpp-server *:* LISTEN 27480/jabberd tcp 0 0 *:ssh *:* LISTEN 565/sshd tcp 0 0 *:smtp *:* LISTEN 16265/master tcp 0 0 *:imap3 *:* LISTEN 27825/inetd tcp 1 0 ns2.freeregistrar.:smtp 219.134.31.88:3610 CLOSE_WAIT - tcp 0 0 ns2.freeregistrar.:smtp pd95b6e2d.dip0.t-i:4675 ESTABLISHED- tcp 1 0 ns2.freeregistrar.:smtp 219.133.247.43:3075 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.247.81:4538 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.178.128:3650 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 61.141.233.143:4637 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 61.141.185.62:2706 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.73.239:4048 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 218-169-53-242.dyn:2782 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.31.102:3488 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 218.18.41.144:3930 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 221.140.55.55:1729 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.178.86:4705 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.246.75:4649 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 221.140.55.55:1949 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp VG-4-38.dialup.acc:2303 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.178.159:4229 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp TC222-156-6-136.ad:4476 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 61.141.233.143:3284 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.31.88:3585 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp TC222-156-6-136.ad:4266 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 60.180.183.72:3676 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.178.128:4060 CLOSE_WAIT - tcp 0 0 ns1.freeregistrar.:smtp VG-4-38.dialup.acc:3176 ESTABLISHED- tcp 1 0 ns2.freeregistrar.:smtp 219.134.178.86:4726 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 218.18.41.198:2969 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 218-169-53-242.dyn:4107 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 218-168-74-192.dyn:4036 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.73.111:4201 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.247.168:4330 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.73.239:3664 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.72.87:1156 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 218-168-74-192.dyn:4881 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.72.206:4979 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 218.18.41.144:4502 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 221.139.50.32:1048 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.133.174.9:4467 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 61.141.233.143:3028 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 218.18.41.198:3538 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.175.237:3839 CLOSE_WAIT - tcp 0 0 ns1.freeregistrar.:smtp 219.134.178.52:3990 ESTABLISHED- tcp 1 0 ns2.freeregistrar.:smtp 218.18.251.44:3587 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.178.171:4022 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.31.103:3114 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.247.22:4573 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.73.111:4169 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.246.251:3150 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 221.139.50.32:4400 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 61-217-111-18.dyna:3788 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.133.247.22:3596 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.31.103:3137 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 218-169-53-242.dyn:2990 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 61.141.185.224:3717 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.133.247.168:4299 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 61-217-111-18.dyna:4312 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.72.70:3940 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp webmail.jbase.com:44566 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 210.105.172.210:2379 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.133.246.75:4635 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.72.221:4750 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 218.17.76.5:4090 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp webmail.jbase.com:44360 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.175.237:3848 CLOSE_WAIT - tcp 3 0 ns2.freeregistrar.:smtp 173.Red-195-55-251:4329 CLOSE_WAIT - tcp 0 0 ns2.freeregistrar.:smtp 219.134.178.52:4023 ESTABLISHED- tcp 1 0 ns1.freeregistrar.:smtp 219.133.247.43:4287 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp VG-1-05.dialup.acc:2267 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.133.175.237:3806 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 61.141.185.62spfapi CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.72.70:3965 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.178.159:3440 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 61.141.185.62:3646 CLOSE_WAIT - tcp 0 0 ns1.freeregistrar.:smtp pd95b6e2d.dip0.t-i:4668 ESTABLISHED- tcp 1 0 ns2.freeregistrar.:smtp 218.18.41.198:3433 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.174.9:4488 CLOSE_WAIT - tcp 3 0 ns1.freeregistrar.:smtp 173.Red-195-55-251:1572 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 218.17.231.15:4688 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 61-217-111-18.dyna:4108 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 61.141.185.224:3972 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 218-169-53-242.dyn:4158 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.178.171:4045 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.31.102:3459 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 60.180.183.72:2743 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 210.105.172.210:1163 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 210.105.172.205:4228 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp VG-1-05.dialup.acc:1566 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 61-217-111-168.dyn:4099 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 218-175-181-85.dyn:4013 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 61-217-111-18.dyna:3094 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.72.206:4942 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.175.97:1898 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 61-217-111-168.dyn:3537 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.133.247.134:4204 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 210.105.172.205:4624 CLOSE_WAIT - tcp 0 3848 ns1.freeregistrar.n:ssh 1-1-7-48a.gka.gbg.:1398 ESTABLISHED20609/sshd: root@tt tcp 1 0 ns1.freeregistrar.:smtp 219.133.247.81:3222 CLOSE_WAIT - tcp 1 0 ns2.freeregistrar.:smtp 219.134.178.171:3844 CLOSE_WAIT - tcp 1 0 ns1.freeregistrar.:smtp 219.134.72.221:4696 CLOSE_WAIT -
Does the directory /var/run/mysqld exist? Please post the output of Code: ls -la /var/run/ Please add localhost.localdomain to /etc/hosts, like this: Code: 127.0.0.1 localhost [B]localhost.localdomain[/B] # The following lines are desirable for IPv6 capable hosts # (added automatically by netbase upgrade) ::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts 217.64.201.66 ns1.freeregistrar.net ns1 217.64.202.17 ns2.freeregistrar.net ns2
Output 1) the output of the ls -la /var/run is ~# ls -la /var/run total 92 drwxr-xr-x 15 root root 4096 Nov 10 11:43 . drwxr-xr-x 19 root root 4096 Sep 3 21:43 .. drwxr-xr-x 3 root root 4096 Sep 3 21:26 bind drwxr-xr-x 3 daemon daemon 4096 Sep 3 18:55 courier -rw-r--r-- 1 root root 6 Nov 3 21:35 crond.pid ---------- 1 root root 0 Sep 1 11:34 crond.reboot drwxr-xr-x 2 mail mail 4096 Sep 16 2004 exim drwxr-x--- 2 Debian-exim Debian-exim 4096 Nov 3 20:28 exim4 drwx------ 2 fetchmail nogroup 4096 Nov 3 18:22 fetchmail drwxr-xr-x 2 identd nogroup 4096 Sep 1 00:05 identd -rw-r--r-- 1 root root 6 Nov 3 21:35 inetd.pid drwxrwxr-x 2 jabber adm 4096 Nov 3 21:35 jabber -rw-r--r-- 1 root root 4 Nov 3 21:37 klogd.pid drwxr-xr-x 2 mysql root 4096 Nov 10 13:47 mysqld drwxr-xr-x 2 root root 4096 Nov 3 20:16 proftpd lrwxrwxrwx 1 root root 34 Nov 3 19:49 pwcheck -> /var/spool/postfix/var/run/pwcheck -rw-r--r-- 1 root root 6 Nov 3 19:56 pwcheck.pid drwx--x--- 2 root sasl 4096 Aug 31 22:06 saslauthd drwxr-sr-x 5 root smmta 4096 Aug 31 21:52 sendmail drwxr-xr-x 2 root root 4096 Nov 28 2004 sshd -rw-r--r-- 1 root root 4 Sep 1 11:34 sshd.pid -rw-r--r-- 1 root root 5 Nov 3 21:58 syslogd.pid -rw-rw-r-- 1 root utmp 5376 Nov 10 17:06 utmp drwxrwxr-x 2 webcp cp 4096 Nov 3 18:21 webcp 2) the localhost.localdomain added to /etc/hosts.
nothing except. ~# ls -la /var/run/mysqld total 8 drwxr-xr-x 2 mysql root 4096 Nov 10 13:47 . drwxr-xr-x 15 root root 4096 Nov 10 11:43 ..
Can you again try to start MySQL: Code: /etc/init.d/mysql start and at the same time have a look at the logs in /var/log? Is MySQL running in some kind of chroot environment?
error messages It gives an error like follows and /var/log/mysql.log does not contain anything: # /etc/init.d/mysql start Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Don't know how to know?
