[résolu] problem with mysql

Support Debian
#41

Qu’y a-t-il dans /var/log/mysql.log et /var/log/mysql.err ?

#42

toujours rien … le neant absolu

#43

Bon,peux tu donner les résultats de

$ cat /etc/mysql/my.cnf | grep -v “^#” | grep -v “^$”

$ ping hostname

et le contenu de /etc/hosts

C’est quand même curieux cette histoire.

Il n’y a rien dans /var/log/daemon.log ou dans syslog?

#44

localhost:/home/jle# cat /etc/mysql/my.cnf | grep -v "^#" | grep -v "^$" [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/ 

localhost:/home/jle# ping 'hostname'
ping: unknown host hostname[/code]


[code]127.0.0.1 localhost
192.168.1.2 localhost
192.168.1.2 bolgrot.ath.cx[/code]


le daemon.log

[code]ov  4 02:57:45 localhost NetworkManager: <debug info>^I[1194141465.197974] nm_print_open_socks (): Open Sockets List Done.
Nov  4 11:22:43 localhost mysqld_safe[2339]: started
Nov  4 11:22:44 localhost mysqld[2342]: 071104 11:22:44  InnoDB: Started; log sequence number 0 43655
Nov  4 11:22:44 localhost mysqld[2342]: 071104 11:22:44 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov  4 11:22:44 localhost mysqld[2342]: 071104 11:22:44 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov  4 11:22:44 localhost mysqld[2342]: 071104 11:22:44 [ERROR] Aborting
Nov  4 11:22:44 localhost mysqld[2342]:
Nov  4 11:22:45 localhost mysqld[2342]: 071104 11:22:45  InnoDB: Starting shutdown...
Nov  4 11:22:47 localhost mysqld[2342]: 071104 11:22:47  InnoDB: Shutdown completed; log sequence number 0 43655
Nov  4 11:22:47 localhost mysqld[2342]: 071104 11:22:47 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  4 11:22:47 localhost mysqld[2342]:
Nov  4 11:22:47 localhost mysqld_safe[2393]: ended
Nov  4 11:22:58 localhost /etc/init.d/mysql[2535]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  4 11:22:58 localhost /etc/init.d/mysql[2535]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  4 11:22:58 localhost /etc/init.d/mysql[2535]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  4 11:22:58 localhost /etc/init.d/mysql[2535]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  4 11:22:58 localhost /etc/init.d/mysql[2535]:
Nov  4 11:23:08 localhost NetworkManager: <information>^Istarting...
Nov  4 11:24:57 localhost nfsd[2743]: nfssvc: Input/output error
Nov  4 11:25:02 localhost rpc.statd[3134]: Version 1.0.10 Starting
Nov  4 11:28:02 localhost rpc.statd[3134]: unable to register (statd, 1, udp).
Nov  4 11:33:40 localhost NetworkManager: <information>^IUpdating allowed wireless network lists.
Nov  4 11:33:41 localhost NetworkManager: <WARNING>^I nm_dbus_get_networks_cb (): error received: org.freedesktop.NetworkManagerInfo.NoNetworks - There are no wireless networks stored..
#45

Bon, fais

ifup lo

ou éventuellement

ifconfig lo 127.0.0.1 up

puis recommence.

Ton loopback ne marche pas.

Donne le contenu de /etc/network/interfaces

PS: C’était ping hostname et non ping ‘hostname’ mais ça n’est pas grave, il n’y en a plus besoin…

#46

[code]# Used by ifup(8) and ifdown(8). See the interfaces(5) manpage or

/usr/share/doc/ifupdown/examples for more information.

auto eth0
iface eth0 inet static
address 192.168.1.2
netmask 255.255.255.0
network 192.168.1.0
broadcast 192.168.1.255
gateway 192.168.1.1
dns-nameservers 80.10.246.2 80.10.246.132
wireless_channel 10
wireless_rate auto
wireless_essid Wanadoo_f20c[/code]

donc ca marche que quand que fais un ifconfig lo 127.0.0.1 up

donc la apparament j’ai apache en local et mysql qui fonctionne il me dit juste checking for corrupt mais e crois que c’est juste pour dire qu’il recupere les degats

mais il faudrait quand même quetu me dise coment faire peut etre pour réparer la chose voir pour faire ca en auto … mais je comprend pas trop pourquoi il y a eu ce problème …

#47

dans ton fichier interfaces ajoutes juste:

# The loopback network interface auto lo iface lo inet loopback address 127.0.0.1 netmask 255.0.0.0 et ça ira mieux.

#48

c’est bisare le mien etait completement vide à la base j’ai du le remplir manuellement quand j’ai installé ma carte wifi … il ni a pas eu de configuration ou de parametrage particuier a l’installation …

en tout cas merci :smt002

#49

oui, c’est assez bizarre. Il doit bien y en avoir dans netbase.

#50

Le checking for corrupt est systématique à chaque démarrage de mysql…