mysql error at Stage 4 in Debian 3.1

Discussion in 'Installation/Configuration' started by drbista, Nov 10, 2005.

  1. drbista

    drbista New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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/
     
  3. drbista

    drbista New Member

    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!
     
  4. falko

    falko Super Moderator Howtoforge Staff

    You can put only one hostname into /etc/hostname!
     
  5. drbista

    drbista New Member

    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!
     
  6. falko

    falko Super Moderator Howtoforge Staff

    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
    ?
     
  7. drbista

    drbista New Member

    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
     
  8. drbista

    drbista New Member

    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 *:pop3s *:* LISTEN 27825/inetd
    tcp 0 0 *:xmpp-client *:* LISTEN 27480/jabberd
    tcp 0 0 *:pop2 *:* LISTEN 27825/inetd
    tcp 0 0 *:pop3 *:* 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.62:eek:spfapi 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 -
     
  9. falko

    falko Super Moderator Howtoforge Staff

    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
     
  10. drbista

    drbista New Member

    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.
     
  11. falko

    falko Super Moderator Howtoforge Staff

    And what's the output of
    Code:
    ls -la /var/run/mysqld
    ?
     
  12. Pelle

    Pelle New Member

    My Problem is solved! allmost!

    (deleted)
    (Sorry wrong thread)
     
    Last edited: Nov 10, 2005
  13. drbista

    drbista New Member

    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 ..
     
  14. falko

    falko Super Moderator Howtoforge Staff

    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?
     
  15. drbista

    drbista New Member

    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?
     

Share This Page