>[оверквотинг удален]
>>on TCP/IP port: Cannot assign requested address
>>Sep 16 10:52:57 hispindia mysqld[2849]: 080916 10:52:57 [ERROR] Do you already have
>>another mysqld server running on port: 3306 ?
>
>После чего покажите что выдает netstat -apn |grep 3306
>Любопытно что у вас еще с одной программой подобная ошибка:
>>Sep 16 10:52:55 hispindia hpiod: unable to bind socket 2208: Cannot assign
>>requested address
>>Sep 16 10:52:56 hispindia python: hpssd[2752] error: Server exited with error: Unable
>>to bind to socket Эй ты! Че ты такой умный чтоли? Тут тебе не 1-ый класс. И не надо тут тыкать на словарик.
Так вот я даже отключил из сервиса bind. Проблема также.
Вот лог.
Sep 16 19:46:19 hispindia kernel: NET: Registered protocol family 10
Sep 16 19:46:19 hispindia kernel: lo: Disabled Privacy Extensions
Sep 16 19:46:19 hispindia kernel: IPv6 over IPv4 tunneling driver
Sep 16 19:46:19 hispindia hpiod: unable to bind socket 2208: Cannot assign requested address
Sep 16 19:46:21 hispindia python: hpssd[2839] error: Server exited with error: Unable to bind to socket
Sep 16 19:46:21 hispindia mysqld_safe[2933]: started
Sep 16 19:46:22 hispindia mysqld[2936]: 080916 19:46:22 InnoDB: Started; log sequence number 0 5408876
Sep 16 19:46:22 hispindia mysqld[2936]: 080916 19:46:22 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Sep 16 19:46:22 hispindia mysqld[2936]: 080916 19:46:22 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Sep 16 19:46:22 hispindia mysqld[2936]: 080916 19:46:22 [ERROR] Aborting
Sep 16 19:46:22 hispindia mysqld[2936]:
Sep 16 19:46:22 hispindia mysqld[2936]: 080916 19:46:22 InnoDB: Starting shutdown...
Sep 16 19:46:24 hispindia mysqld[2936]: 080916 19:46:24 InnoDB: Shutdown completed; log sequence number 0 5408876
Sep 16 19:46:24 hispindia mysqld[2936]: 080916 19:46:24 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 16 19:46:24 hispindia mysqld[2936]:
Sep 16 19:46:24 hispindia mysqld_safe[2982]: ended
Sep 16 19:46:27 hispindia kernel: eth0: no IPv6 routers present
Sep 16 19:46:35 hispindia /etc/init.d/mysql[3165]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 16 19:46:35 hispindia /etc/init.d/mysql[3165]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 16 19:46:35 hispindia /etc/init.d/mysql[3165]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 16 19:46:35 hispindia /etc/init.d/mysql[3165]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 16 19:46:35 hispindia /etc/init.d/mysql[3165]:
Вот мой файл /etc/mysql/my.conf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
bind-address = 127.0.0.1
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 1M
query_cache_size = 16M
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
skip-bdb
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
Вариант для распечатки
OpenNET: Виртуальная конференция (Public)
(ok) on 27-Сен-08, 09:31 
