+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega International Area (/forum-22.html)
+--- Forum: German Corner (/forum-26.html)
+--- Thread: Autoresponder - vielleicht Problemlösung gefunden (/thread-5133.html)
Autoresponder - vielleicht Problemlösung gefunden - warhog - 12-13-2008 10:19 PM
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.
RE: Autoresponder - vielleicht Problemlösung gefunden - ZooL - 12-14-2008 02:44 AM
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
RE: Autoresponder - vielleicht Problemlösung gefunden - sci2tech - 12-14-2008 05:47 AM
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
";
}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')
";
}