Autoresponder - vielleicht Problemlösung gefunden

[warhog]

Hi,
habe mich heute nach dem Update auf RC7 nochmal hingesetzt um meine Autoresponder zum laufen zu bekommen.
Habe Debian 4 und Postfix/Amavis.
Ich hatte das gleiche Problem wie viele hier das sie zwar funktionieren aber immer eine Fehlermail vom MAILER-DAEMON mitgeschickt wird.
(<user@ispcp-arpl.domain.de> (expanded from <user@domain.de>): Command died with status 1: "/var/www/ispcp/engine/messager/ispcp-arpl-msgr")
War bei mir schon unter RC6 so und hat sich mit den gängigen Tips hier nicht lösen lassen.

Nachdem ich den Debugmodus eingeschaltet habe ist mir in der /var/log/ispcp/ispcp-arpl-msgr/ispcp-arpl-msgr.stdout folgendes aufgefallen:

Code:

push_el() sub_name: arpl_msgr_engine(), msg: sql: |  
                                                SELECT
                                                        t1.`mail_auto_respond_text`
                                                FROM
                                                        `mail_users` as t1
                                                LEFT JOIN (`domain` as t2) ON (t1.`domain_id`=t2.`domain_id`)
                                                WHERE
                                                        t1.`mail_acc` = 'USERNAME'
                                                AND
                                                        t1.`mail_auto_respond`=1
                                                AND
                                                        t2.`domain_name` = 'DOMAINNAME'
                                                AND
                                                        t1.`sub_id`=0
                                                COLLATE utf-8
                                        |
push_el() sub_name: doSQL(), msg: Starting...
push_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> Unknown collation: 'utf'
DEBUG: pop_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> Unknown collation: 'utf'

Ich habe dann kurzerhand aus der Datei "/var/www/ispcp/engine/messager/ispcp-arpl-msgr" in den Zeilen 811, 829, 847 und 865 das "COLLATE utf-8" entfernt.
Seitdem bekomme ich keine Fehlermeldung mehr gebounced und die Autoresponder funktionieren einwandfrei.
Ob das mit RC6 auch funktioniert weiss ich nicht, vielleicht kann das ja jemand mal austesten.

[ZooL]

Code:

push_el() sub_name: arpl_msgr_engine(), msg: sql: |  
                                                SELECT
                                                        t1.`mail_auto_respond_text`
                                                FROM
                                                        `mail_users` as t1
                                                LEFT JOIN (`domain` as t2) ON (t1.`domain_id`=t2.`domain_id`)
                                                WHERE
                                                        t1.`mail_acc` = 'USERNAME'
                                                AND
                                                        t1.`mail_auto_respond`=1
                                                AND
                                                        t2.`domain_name` = 'DOMAINNAME'
                                                AND
                                                        t1.`sub_id`=0
                                                COLLATE utf-8
                                        |
push_el() sub_name: doSQL(), msg: Starting...
push_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> Unknown collation: 'utf'
DEBUG: pop_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> Unknown collation: 'utf'

bin leider von 5 auf 7 kann da nicht mit reden so schnell

[sci2tech]

replace in /var/www/ispcp/engine/messager/ispcp-arpl-msgr

Code:

                if ($pt == 1) {

                    $sql = "
                        SELECT
                            t1.`mail_auto_respond_text`
                        FROM
                            `mail_users` as t1
                        LEFT JOIN (`domain` as t2) ON (t1.`domain_id`=t2.`domain_id`)
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            t2.`domain_name` = '$edmn'
                        AND
                            t1.`sub_id`=0
                        COLLATE utf-8
                    ";

                } elsif ($pt == 2) {

                    $sql = "
                        SELECT
                            `mail_auto_respond_text`
                        FROM
                            `mail_users` as t1
                        LEFT JOIN (`domain_aliasses` as t2) ON (t1.`sub_id`=t2.`alias_id`)
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            t2.`alias_name` = '$edmn'
                        COLLATE utf-8
                    ";

                } elsif ($pt == 3) {

                    $sql = "
                        SELECT
                            `mail_auto_respond_text`
                        FROM
                            `mail_users` as t1
                        LEFT JOIN (`subdomain` as t2) ON t1.`sub_id`=t2.`subdomain_id`
                        LEFT JOIN (`domain` as t3) ON t2.`domain_id`=t3.`domain_id`
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            (CONCAT(t2.`subdomain_name`,'.',t3.`domain_name`) = '$edmn')
                        COLLATE utf-8
                    ";

                } elsif ($pt == 4) {

                    $sql = "
                        SELECT
                            t1.`mail_auto_respond_text`
                        FROM
                            `mail_users` AS t1
                        LEFT JOIN (`subdomain_alias` AS t2) ON (t1.`sub_id`=t2.`subdomain_alias_id`)
                        LEFT JOIN (`domain_aliasses` AS t3) ON (t2.`alias_id`=t3.`alias_id`)
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            (CONCAT(t2.`subdomain_alias_name`,'.',t3.`alias_name`) = '$edmn')
                        COLLATE utf-8
                    ";

                }

with

Code:

                if ($pt == 1) {

                    $sql = "
                        SELECT
                            CONVERT(t1.`mail_auto_respond_text` using utf8)
                        FROM
                            `mail_users` as t1
                        LEFT JOIN (`domain` as t2) ON (t1.`domain_id`=t2.`domain_id`)
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            t2.`domain_name` = '$edmn'
                        AND
                            t1.`sub_id`=0
                    ";

                } elsif ($pt == 2) {

                    $sql = "
                        SELECT
                            CONVERT(t1.`mail_auto_respond_text` using utf8)
                        FROM
                            `mail_users` as t1
                        LEFT JOIN (`domain_aliasses` as t2) ON (t1.`sub_id`=t2.`alias_id`)
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            t2.`alias_name` = '$edmn'
                    ";

                } elsif ($pt == 3) {

                    $sql = "
                        SELECT
                            CONVERT(t1.`mail_auto_respond_text` using utf8)
                        FROM
                            `mail_users` as t1
                        LEFT JOIN (`subdomain` as t2) ON t1.`sub_id`=t2.`subdomain_id`
                        LEFT JOIN (`domain` as t3) ON t2.`domain_id`=t3.`domain_id`
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            (CONCAT(t2.`subdomain_name`,'.',t3.`domain_name`) = '$edmn')
                    ";

                } elsif ($pt == 4) {

                    $sql = "
                        SELECT
                            CONVERT(t1.`mail_auto_respond_text` using utf8)
                        FROM
                            `mail_users` AS t1
                        LEFT JOIN (`subdomain_alias` AS t2) ON (t1.`sub_id`=t2.`subdomain_alias_id`)
                        LEFT JOIN (`domain_aliasses` AS t3) ON (t2.`alias_id`=t3.`alias_id`)
                        WHERE
                            t1.`mail_acc` = '$user'
                        AND
                            t1.`mail_auto_respond`=1
                        AND
                            (CONCAT(t2.`subdomain_alias_name`,'.',t3.`alias_name`) = '$edmn')
                    ";

                }