Spam chinois qq.com

Support Debian
#41

var voir les logs de MYSQL et le Syslog quand tu fais le start

tu devais avoir un mysql_error.log tu fais le “tail” sur mysql log et le syslog puis tu essaye de starter le serveur.
Tu as de l’espace disque au moins ?

#42

Il me reste 2,3 Go.

#43

regarde les logs dans ce cas

#44

Quand je tape :
tail /var/log/mysql.err

ça n’affiche rien.

Idem pour :
tail /var/log/mysql/mysql.log

J’essaye désespérément de relancer mysql, mais rien à faire.

J’ai essayé de taper :
mysqld_safe
et j’ai ça qui s’affiche :

171211 01:51:03 mysqld_safe Can't log to error log and syslog at the same time.  Remove all --log-error configuration options for --syslog to take effect.
171211 01:51:03 mysqld_safe Logging to '/var/log/mysql/error.log'.
171211 01:51:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
171211 01:51:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
#45

ca n’affiche rien ou “file not found” ?

#46

ça n’affiche rien.

J’ai regardé les droits en faisant ls -l /var/run et j’ai ça :
drwxr-xr-x 2 mysql root 4096 Dec 10 21:36 mysqld

#47

dans le syslog tu voir qqchose concernant mysql

#48 
ls -l /var/run/mysqld/mysqld.sock
srwxrwxrwx 1 mysql mysql 0 Sep  1 11:01 /var/run/mysqld/mysqld.sock

ls -l /var/run/mysqld/
total 4
-rw-rw---- 1 mysql mysql 5 Sep  1 11:01 mysqld.pid
srwxrwxrwx 1 mysql mysql 0 Sep  1 11:01 mysqld.sock
#49

Moi, j’ai :

ls -l /var/run/mysqld/mysqld.sock
-rw-r--r-- 1 mysql root 0 Dec 10 21:36 /var/run/mysqld/mysqld.sock

ls -l /var/run/mysqld/
total 0
-rw-r--r-- 1 mysql root 0 Dec 10 21:36 mysqld.sock

Je pense que les droits du mysqld.sock ne sont pas bons ? (-rw-r--r--)
Et est-ce normal que je n’ai pas mysqld.pid ?

Je pense que je vais essayer de changer les droits pour mysqld.sock,
j’ai toujours peur de faire une bétise quand il faut changer des droits… là, je vais aller dans le répertoire /var/run/mysqld/ avec la commande cd, et je vais taper :
chmod 755 mysqld.sock ou alors chmod 4777 mysqld.sock

J’ai taper chmod 4777 mysqld.sock
et maintenant, j’ai bien :
-rwsrwxrwx 1 mysql root 0 Dec 10 21:36 mysqld.sock

Mais mysqld.sock est écrit sur un fond ROUGE ?!

J’ai redémarré mysql en tapant service mysql start, et j’ai toujours la même erreur :
start: Job failed to start

#50

le owner et le group c’est mysql, donc il faut encore utiliser chown
toujours rien dans le syslog ?

#51

Voici le syslog, et la plupart des lignes sont sur fond rouge :

Dec 11 06:33:05 advertis-s1 rsyslogd: [origin software="rsyslogd" swVersion="7.4.4" x-pid="1253" x-info="http://www.rsyslog.com"] rsyslogd was HUPed
Dec 11 06:33:06 advertis-s1 postfix/smtpd[26877]: connect from mail.static.s11.93.bp06.net[81.252.93.11]
Dec 11 06:33:06 advertis-s1 postfix/smtpd[24434]: connect from 4.newsletter.brandalley.com[62.210.183.4]
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:06 advertis-s1 postfix/smtpd[24434]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/smtpd[24434]: NOQUEUE: reject: RCPT from 4.newsletter.brandalley.com[62.210.183.4]: 451 4.3.5 <4.newsletter.brandalley.com[62.210.183.4]>: Client host rejected: Server configuration error; from=<feedback@newsletter.brandalley.com> to=<verotasquin@cecp.fr> proto=ESMTP helo=<4.newsletter.brandalley.com>
Dec 11 06:33:06 advertis-s1 postfix/smtpd[24434]: disconnect from 4.newsletter.brandalley.com[62.210.183.4]
Dec 11 06:33:06 advertis-s1 postfix/smtpd[1191]: connect from localhost[127.0.0.1]
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:06 advertis-s1 postfix/smtpd[1191]: 5510430CB6E: client=localhost[127.0.0.1]
Dec 11 06:33:06 advertis-s1 postfix/cleanup[1607]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "bombavr@virgilio.it"
Dec 11 06:33:06 advertis-s1 postfix/cleanup[1607]: warning: 5510430CB6E: virtual_alias_maps map lookup problem for bombavr@virgilio.it -- message not accepted, try again later
Dec 11 06:33:06 advertis-s1 amavis[666]: (00666-02-269) Negative SMTP response to data-dot (<bombavr@virgilio.it>): 451 4.3.0 Error: queue file write error
Dec 11 06:33:06 advertis-s1 amavis[666]: (00666-02-269) (!)FWD from <olympia.f@polystyl-agencement.com> -> <bombavr@virgilio.it>,BODY=8BITMIME 451 4.3.0 from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error: queue file write error
Dec 11 06:33:06 advertis-s1 postfix/cleanup[1653]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "postmaster@advertis-s1.altrium.org"
Dec 11 06:33:06 advertis-s1 postfix/cleanup[1653]: warning: 5587030CB6E: virtual_alias_maps map lookup problem for postmaster@advertis-s1.altrium.org -- message not accepted, try again later
Dec 11 06:33:06 advertis-s1 postfix/smtpd[1191]: disconnect from localhost[127.0.0.1]
Dec 11 06:33:06 advertis-s1 amavis[666]: (00666-02-269) Blocked MTA-BLOCKED {TempFailedInbound}, <olympia.f@polystyl-agencement.com> -> <bombavr@virgilio.it>, Message-ID: <801283f7462c21d2bc2e6976eb82aa2c@www.polystyl-agencement.com>, mail_id: IckM_LXADv9R, Hits: -100.7, size: 1641, 4643 ms
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:06 advertis-s1 postfix/smtpd[26877]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/smtpd[26877]: NOQUEUE: reject: RCPT from mail.static.s11.93.bp06.net[81.252.93.11]: 451 4.3.5 <mail.static.s11.93.bp06.net[81.252.93.11]>: Client host rejected: Server configuration error; from=<MperfBouncesASP00A7001IAJ002BW4R6@republicains-info.org> to=<p.barth@cabinet-barth.com> proto=ESMTP helo=<mail.static.s11.93.bp06.net>
Dec 11 06:33:06 advertis-s1 postfix/smtpd[26877]: disconnect from mail.static.s11.93.bp06.net[81.252.93.11]
Dec 11 06:33:06 advertis-s1 postfix/smtp[1691]: 6ED2A30CBE3: to=<bombavr@virgilio.it>, relay=127.0.0.1[127.0.0.1]:10024, conn_use=269, delay=1694, delays=1577/112/0/4.6, dsn=4.3.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.3.0 id=00666-02-269 - Temporary MTA failure on relaying, from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error: queue file write error (in reply to end of DATA command))
Dec 11 06:33:06 advertis-s1 postfix/smtp[1691]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Dec 11 06:33:06 advertis-s1 postfix/smtp[1691]: warning: 6ED2A30CBE3: flush service failure
Dec 11 06:33:07 advertis-s1 postfix/smtpd[24434]: connect from mail253.neti.rmta-hg-pool.com[80.89.112.253]
Dec 11 06:33:07 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:07 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:07 advertis-s1 postfix/smtpd[24434]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
Dec 11 06:33:07 advertis-s1 postfix/smtpd[24434]: NOQUEUE: reject: RCPT from mail253.neti.rmta-hg-pool.com[80.89.112.253]: 451 4.3.5 <mail253.neti.rmta-hg-pool.com[80.89.112.253]>: Client host rejected: Server configuration error; from=<no-reply@eperflex.com> to=<jacques@cantrelle.net> proto=ESMTP helo=<mail253.neti.rmta-hg-pool.com>
Dec 11 06:33:07 advertis-s1 postfix/sendmail[2261]: fatal: webmaster@vmbfrance.com(33): No recipient addresses found in message header
Dec 11 06:33:07 advertis-s1 postfix/sendmail[2263]: fatal: webmaster@vmbfrance.com(33): No recipient addresses found in message header
Dec 11 06:33:07 advertis-s1 postfix/smtpd[1220]: connect from localhost[127.0.0.1]
Dec 11 06:33:07 advertis-s1 postfix/trivial-rewrite[733]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Dec 11 06:33:07 advertis-s1 postfix/trivial-rewrite[733]: warning: virtual_mailbox_domains lookup failure
Dec 11 06:33:07 advertis-s1 postfix/smtpd[1220]: 2D88530CBA2: client=localhost[127.0.0.1]
Dec 11 06:33:07 advertis-s1 postfix/cleanup[1607]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "dominiquesogetef@orange.fr"
Dec 11 06:33:07 advertis-s1 postfix/cleanup[1607]: warning: 2D88530CBA2: virtual_alias_maps map lookup problem for dominiquesogetef@orange.fr -- message not accepted, try again later
Dec 11 06:33:07 advertis-s1 amavis[666]: (00666-02-270) Negative SMTP response to data-dot (<dominiquesogetef@orange.fr>): 451 4.3.0 Error: queue file write error
Dec 11 06:33:07 advertis-s1 amavis[666]: (00666-02-270) (!)FWD from <diannah.c@polystyl-agencement.com> -> <dominiquesogetef@orange.fr>,BODY=8BITMIME 451 4.3.0 from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error: queue file write error
Dec 11 06:33:07 advertis-s1 postfix/cleanup[1653]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "postmaster@advertis-s1.altrium.org"
Dec 11 06:33:07 advertis-s1 postfix/cleanup[1653]: warning: 2E18A30CBA2: virtual_alias_maps map lookup problem for postmaster@advertis-s1.altrium.org -- message not accepted, try again later
Dec 11 06:33:07 advertis-s1 postfix/smtpd[1220]: disconnect from localhost[127.0.0.1]
Dec 11 06:33:07 advertis-s1 amavis[666]: (00666-02-270) Blocked MTA-BLOCKED {TempFailedInbound}, <diannah.c@polystyl-agencement.com> -> <dominiquesogetef@orange.fr>, Message-ID: <04f6f8ba79ceb616a53b1750f8e5d2ef@www.polystyl-agencement.com>, mail_id: YOE2TW3XLG_7, Hits: -100.7, size: 1777, 220 ms
Dec 11 06:33:07 advertis-s1 postfix/smtp[1691]: 6B9B830900A: to=<dominiquesogetef@orange.fr>, relay=127.0.0.1[127.0.0.1]:10024, conn_use=270, delay=38377, delays=38259/117/0/0.22, dsn=4.3.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.3.0 id=00666-02-270 - Temporary MTA failure on relaying, from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error: queue file write error (in reply to end of DATA command))