Por supuesto que no tengo otro mysql corriendo: root@debariel:/home/ariel# /etc/init.d/mysql status MySQL is stopped..
Creo que el problema tiene que ver con la configuración de red, cuando doy ping 127.0.0.1 el sistema me responde esto: root@debariel:/home/ariel# ping 127.0.0.1 PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data. Pero no responde mas nada, se queda ahí colgado. Como hago para que responda correctamente ? Saludos, Gracias de antemano. Ariel 2011/7/13 Ariel <[email protected]> > Pues esto es lo que dice: > > Jul 13 09:51:23 debariel mysqld_safe[27993]: Please report any problems > with the /usr/scripts/mysqlbug script! > Jul 13 09:51:23 debariel mysqld_safe[27993]: > Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713 9:51:23 [Note] Plugin > 'FEDERATED' is disabled. > Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713 9:51:23 InnoDB: > Initializing buffer pool, size = 8.0M > Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713 9:51:23 InnoDB: > Completed initialization of buffer pool > Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713 9:51:23 InnoDB: > Started; log sequence number 0 44233 > Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713 9:51:23 InnoDB: > Starting shutdown... > Jul 13 09:51:28 debariel mysqld_safe[28038]: 110713 9:51:28 InnoDB: > Shutdown completed; log sequence number 0 44233 > Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713 9:51:28 [Note] Plugin > 'FEDERATED' is disabled. > Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713 9:51:28 InnoDB: > Initializing buffer pool, size = 8.0M > Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713 9:51:28 InnoDB: > Completed initialization of buffer pool > Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713 9:51:28 InnoDB: > Started; log sequence number 0 44233 > Jul 13 09:51:28 debariel mysqld_safe[28087]: ERROR: 1064 You have an error > in your SQL syntax; check the manual that corresponds to your MySQL server > version for the right syntax to use near 'ALTER TABLE user ADD column > Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1 > Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713 9:51:28 [ERROR] > Aborting > Jul 13 09:51:28 debariel mysqld_safe[28087]: > Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713 9:51:28 InnoDB: > Starting shutdown... > Jul 13 09:51:33 debariel mysqld_safe[28087]: 110713 9:51:33 InnoDB: > Shutdown completed; log sequence number 0 44233 > Jul 13 09:51:33 debariel mysqld_safe[28087]: 110713 9:51:33 [Note] > /usr/sbin/mysqld: Shutdown complete > Jul 13 09:51:33 debariel mysqld_safe[28087]: > Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713 9:51:33 [Note] Plugin > 'FEDERATED' is disabled. > Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713 9:51:33 InnoDB: > Initializing buffer pool, size = 8.0M > Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713 9:51:33 InnoDB: > Completed initialization of buffer pool > Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713 9:51:33 InnoDB: > Started; log sequence number 0 44233 > Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713 9:51:33 InnoDB: > Starting shutdown... > Jul 13 09:51:38 debariel mysqld_safe[28132]: 110713 9:51:38 InnoDB: > Shutdown completed; log sequence number 0 44233 > Jul 13 09:51:38 debariel mysqld_safe[28180]: 110713 9:51:38 [Note] Plugin > 'FEDERATED' is disabled. > Jul 13 09:51:38 debariel mysqld_safe[28180]: 110713 9:51:38 InnoDB: > Initializing buffer pool, size = 8.0M > Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713 9:51:39 InnoDB: > Completed initialization of buffer pool > Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713 9:51:39 InnoDB: > Started; log sequence number 0 44233 > Jul 13 09:51:39 debariel mysqld_safe[28180]: ERROR: 1050 Table 'plugin' > already exists > Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713 9:51:39 [ERROR] > Aborting > Jul 13 09:51:39 debariel mysqld_safe[28180]: > Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713 9:51:39 InnoDB: > Starting shutdown... > Jul 13 09:51:44 debariel mysqld_safe[28180]: 110713 9:51:44 InnoDB: > Shutdown completed; log sequence number 0 44233 > Jul 13 09:51:44 debariel mysqld_safe[28180]: 110713 9:51:44 [Note] > /usr/sbin/mysqld: Shutdown complete > Jul 13 09:51:44 debariel mysqld_safe[28180]: > Jul 13 09:51:44 debariel mysqld_safe: Starting mysqld daemon with databases > from /var/lib/mysql > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 [Note] Plugin 'FEDERATED' > is disabled. > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 InnoDB: Initializing > buffer pool, size = 8.0M > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 InnoDB: Completed > initialization of buffer pool > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 InnoDB: Started; log > sequence number 0 44233 > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 [ERROR] Can't start > server: Bind on TCP/IP port: Cannot assign requested address > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 [ERROR] Do you already > have another mysqld server running on port: 3306 ? > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 [ERROR] Aborting > Jul 13 09:51:44 debariel mysqld: > Jul 13 09:51:44 debariel mysqld: 110713 9:51:44 InnoDB: Starting > shutdown... > Jul 13 09:51:49 debariel mysqld: 110713 9:51:49 InnoDB: Shutdown > completed; log sequence number 0 44233 > Jul 13 09:51:49 debariel mysqld: 110713 9:51:49 [Note] /usr/sbin/mysqld: > Shutdown complete > Jul 13 09:51:49 debariel mysqld: > Jul 13 09:51:49 debariel mysqld_safe: mysqld from pid file > /var/run/mysqld/mysqld.pid ended > Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: 0 processes alive and > '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in > Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: #007/usr/bin/mysqladmin: > connect to server at 'localhost' failed > Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: error: 'Can't connect to > local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' > Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: Check that mysqld is > running and that the socket: '/var/run/mysqld/mysqld.sock' exists! > Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: > Jul 13 10:58:05 debariel named[1698]: built with '--prefix=/usr' > '--mandir=/usr/share/man' '--infodir=/usr/share/info' > '--sysconfdir=/etc/bind' '--localstatedir=/var' '--enable-threads' > '--enable-largefile' '--with-libtool' '--enable-shared' '--enable-static' > '--with-openssl=/usr' '--with-gssapi=/usr' '--with-gnu-ld' > '--with-dlz-postgres=no' '--with-dlz-mysql=no' '--with-dlz-bdb=yes' > '--with-dlz-filesystem=yes' '--with-dlz-ldap=yes' '--with-dlz-stub=yes' > '--with-geoip=/usr' '--enable-ipv6' 'CFLAGS=-fno-strict-aliasing > -DDIG_SIGCHASE -O2' 'LDFLAGS=' 'CPPFLAGS=' > Jul 13 10:58:11 debariel mysqld_safe: Starting mysqld daemon with databases > from /var/lib/mysql > Jul 13 10:58:11 debariel mysqld: 110713 10:58:11 [Note] Plugin 'FEDERATED' > is disabled. > Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 InnoDB: Initializing > buffer pool, size = 8.0M > Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 InnoDB: Completed > initialization of buffer pool > Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 InnoDB: Started; log > sequence number 0 44233 > Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 [ERROR] Can't start > server: Bind on TCP/IP port: Cannot assign requested address > Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 [ERROR] Do you already > have another mysqld server running on port: 3306 ? > Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 [ERROR] Aborting > Jul 13 10:58:12 debariel mysqld: > Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 InnoDB: Starting > shutdown... > Jul 13 10:58:19 debariel mysqld: 110713 10:58:19 InnoDB: Shutdown > completed; log sequence number 0 44233 > Jul 13 10:58:19 debariel mysqld: 110713 10:58:19 [Note] /usr/sbin/mysqld: > Shutdown complete > Jul 13 10:58:19 debariel mysqld: > Jul 13 10:58:20 debariel mysqld_safe: mysqld from pid file > /var/run/mysqld/mysqld.pid ended > Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: 0 processes alive and > '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in > Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: #007/usr/bin/mysqladmin: > connect to server at 'localhost' failed > Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: error: 'Can't connect to > local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' > Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: Check that mysqld is > running and that the socket: '/var/run/mysqld/mysqld.sock' exists! > Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: > > > Saludos > > 2011/7/13 Manolo Díaz <[email protected]> > >> El miércoles, 13 de julio de 2011 a las 09:49:02 -0400 horas, >> Ariel escribió: >> >> > Los logs de mysql que están en /var/log no dicen nada. >> >> Mira a ver si hay algo en los logs de sistema. >> >> grep mysql /var/log/syslog >> >> Saludos. >> -- >> Manolo Díaz >> >> >> -- >> To UNSUBSCRIBE, email to [email protected] >> with a subject of "unsubscribe". Trouble? Contact >> [email protected] >> Archive: http://lists.debian.org/[email protected] >> >> >
