mysql error at Stage 4 in Debian 3.1

[drbista]

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

[till]

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/

[drbista]

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!

[falko]

Originally Posted by drbista

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)

You can put only one hostname into /etc/hostname!

[drbista]

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!

[falko]

Please run

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

netstat -tap

?

[drbista]

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

[drbista]

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 -

[falko]

Does the directory /var/run/mysqld exist? Please post the output of

ls -la /var/run/

Please add localhost.localdomain to /etc/hosts, like this:

127.0.0.1 localhost localhost.localdomain

# 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

[drbista]

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.