# Spam chinois qq.com

**URL:** <https://www.debian-fr.org/t/spam-chinois-qq-com/74693>\
**Category:** Support Debian\
**Created:** [Octobre 7, 2017, 9:04 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693 "2017-10-07T21:04:47Z")\
**Posts on this page:** 11\
**Page:** 3

<div class="post-metadata">

**Author:** ![jimbo](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jimbo](https://www.debian-fr.org/u/jimbo)\
**Post date:** [Décembre 10, 2017, 9:50 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/41 "2017-12-10T21:50:00Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![siorac](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/s/a698b9/32.png) [@siorac](https://www.debian-fr.org/u/siorac)\
**Post date:** [Décembre 10, 2017, 10:20 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/42 "2017-12-10T22:20:44Z")

</div>

Il me reste 2,3 Go.

---

<div class="post-metadata">

**Author:** ![jimbo](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jimbo](https://www.debian-fr.org/u/jimbo)\
**Post date:** [Décembre 10, 2017, 10:26 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/43 "2017-12-10T22:26:45Z")

</div>

> [@siorac](#):
>
> Il me reste 2,3 Go.

regarde les logs dans ce cas

---

<div class="post-metadata">

**Author:** ![siorac](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/s/a698b9/32.png) [@siorac](https://www.debian-fr.org/u/siorac)\
**Post date:** [Décembre 10, 2017, 11:01 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/44 "2017-12-10T23:01:36Z")

</div>

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 :

```nohighlight
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

```

---

<div class="post-metadata">

**Author:** ![jimbo](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jimbo](https://www.debian-fr.org/u/jimbo)\
**Post date:** [Décembre 11, 2017, 7:25 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/45 "2017-12-11T07:25:34Z")

</div>

> [@siorac](#):
>
> ça n’affiche rien.

ca n’affiche rien ou «&nbsp;file not found&nbsp;» ?

---

<div class="post-metadata">

**Author:** ![siorac](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/s/a698b9/32.png) [@siorac](https://www.debian-fr.org/u/siorac)\
**Post date:** [Décembre 11, 2017, 8:01 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/46 "2017-12-11T08:01:43Z")

</div>

ç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`

---

<div class="post-metadata">

**Author:** ![jimbo](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jimbo](https://www.debian-fr.org/u/jimbo)\
**Post date:** [Décembre 11, 2017, 8:02 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/47 "2017-12-11T08:02:29Z")

</div>

> [@siorac](#):
>
> ça n’affiche rien.

dans le syslog tu voir qqchose concernant mysql

---

<div class="post-metadata">

**Author:** ![jimbo](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jimbo](https://www.debian-fr.org/u/jimbo)\
**Post date:** [Décembre 11, 2017, 8:04 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/48 "2017-12-11T08:04:23Z")

</div>

> [@siorac](#):
>
> 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

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

```

```plaintext
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

```

---

<div class="post-metadata">

**Author:** ![siorac](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/s/a698b9/32.png) [@siorac](https://www.debian-fr.org/u/siorac)\
**Post date:** [Décembre 11, 2017, 8:15 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/49 "2017-12-11T08:15:14Z")

</div>

Moi, j’ai :

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

```

```nohighlight
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`

---

<div class="post-metadata">

**Author:** ![jimbo](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/j/d78d45/32.png) [@jimbo](https://www.debian-fr.org/u/jimbo)\
**Post date:** [Décembre 11, 2017, 3:24 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/50 "2017-12-11T15:24:20Z")

</div>

> [@siorac](#):
>
> J’ai redémarré mysql en tapant service mysql start, et j’ai toujours la même erreur :  
> start: Job failed to start

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

---

<div class="post-metadata">

**Author:** ![siorac](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/s/a698b9/32.png) [@siorac](https://www.debian-fr.org/u/siorac)\
**Post date:** [Décembre 11, 2017, 3:37 UTC](https://www.debian-fr.org/t/spam-chinois-qq-com/74693/51 "2017-12-11T15:37:03Z")

</div>

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

```nohighlight
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))

```

[Page précédente](https://www.debian-fr.org/t/spam-chinois-qq-com/74693.md?page=2)
