AlternC

fixed: ceci est resolu par [5104]

ensure we follow symlinks on /var/lib/alternc/apache-vhost because some clever admins may have moved it to ALTERNC_HTML

après l'upgrade a 3.2.3, je vois que le fichier /var/alternc/apache-vhost/vhosts_all.conf est vide: ###BEGIN OF ALTERNC AUTO-GENERATED FILE - DO NOT EDIT MANUALLY### ## LogFormat informations Include "/etc/alternc/apache_logformat.conf" ###END OF ... [More] ALTERNC AUTO-GENERATED FILE - DO NOT EDIT MANUALLY### enfin... ou presque. du coup, boum. tout est down. [Less]

add changes from wheezy, commented out

don't check disk quotas if they're disabled

fix weird case where user root is not found

fixed: fixed by [5099] thanks!

Created tag /tags/3.1.3 from /branches/stable-3.1:5097

improve lastlogin performance by using indexes, closes #1633, patch by lelutin

when we enable the postlogin hooks in dovecot, our server crashes with too many connexions to mysql. this is a followup to #1632. we get hundreds of such processes: 16112 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh ... [More] /usr/lib/dovecot/script-login 16113 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'a 16115 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16116 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'i 16117 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16118 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'r 16119 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16120 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 's 16150 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16151 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'r 16152 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16153 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'c 16159 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16161 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'l 16160 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16162 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'c 16263 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16264 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'l 16275 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16276 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'i 16302 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16303 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'l 16330 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16331 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'v 16333 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16334 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'm 16415 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16416 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'p 16417 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16418 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 's 16437 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16438 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'x 16444 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16445 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'r 16460 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16465 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'p 16466 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16467 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'i 16468 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16470 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'o 16469 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16471 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'm 16473 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16475 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 's 16478 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16479 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 's 16501 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16502 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'i 16507 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16508 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'i 16510 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16511 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'd 16534 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16535 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'p 16567 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16568 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'm 16577 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16578 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'm 16604 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16605 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'l 16609 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16611 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'c 16612 ? S 0:00 /bin/bash /usr/lib/alternc/popimap-log-login.sh /usr/lib/dovecot/script-login 16613 ? S 0:00 \_ /usr/bin/mysql --defaults-file=/etc/alternc/my.cnf -Bs -e update address a, domaines d, mailbox m set m.lastlogin=now() where a.domain_id=d.id and m.address_id=a.id and concat_ws('@',a.address,d.domaine) = 'j we would need to have a daemon to keep a single persistent connexion to mysql to do those updates or something, because this is ridiculous... [Less]