postfixadmin-tracker Mailing List for PostfixAdmin (Page 44)
Brought to you by:
christian_boltz,
gingerdog
Menu
▾
▴
postfixadmin-tracker — Postfix Admin tracker notification - READ ONLY!
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(5) |
Oct
(67) |
Nov
(83) |
Dec
(47) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(57) |
Feb
(15) |
Mar
(21) |
Apr
(38) |
May
(27) |
Jun
(38) |
Jul
(35) |
Aug
(50) |
Sep
(8) |
Oct
(9) |
Nov
(59) |
Dec
(59) |
| 2009 |
Jan
(27) |
Feb
(42) |
Mar
(63) |
Apr
(46) |
May
(26) |
Jun
(25) |
Jul
(40) |
Aug
(19) |
Sep
(17) |
Oct
(35) |
Nov
(26) |
Dec
(21) |
| 2010 |
Jan
(11) |
Feb
(19) |
Mar
(40) |
Apr
(25) |
May
(23) |
Jun
(17) |
Jul
(10) |
Aug
(18) |
Sep
(21) |
Oct
(12) |
Nov
(10) |
Dec
(22) |
| 2011 |
Jan
(30) |
Feb
(23) |
Mar
(23) |
Apr
(38) |
May
(32) |
Jun
(19) |
Jul
(20) |
Aug
(36) |
Sep
(11) |
Oct
(28) |
Nov
(4) |
Dec
(4) |
| 2012 |
Jan
(6) |
Feb
(3) |
Mar
(16) |
Apr
(28) |
May
(29) |
Jun
(10) |
Jul
(2) |
Aug
(3) |
Sep
|
Oct
(13) |
Nov
(1) |
Dec
(1) |
| 2013 |
Jan
(11) |
Feb
(7) |
Mar
(29) |
Apr
(2) |
May
(3) |
Jun
(15) |
Jul
(8) |
Aug
(5) |
Sep
(5) |
Oct
(4) |
Nov
(27) |
Dec
(81) |
| 2014 |
Jan
(12) |
Feb
(13) |
Mar
(5) |
Apr
|
May
(41) |
Jun
(16) |
Jul
(7) |
Aug
(10) |
Sep
(24) |
Oct
(50) |
Nov
|
Dec
(2) |
| 2015 |
Jan
(5) |
Feb
(2) |
Mar
(7) |
Apr
(20) |
May
(1) |
Jun
(3) |
Jul
(12) |
Aug
(1) |
Sep
(17) |
Oct
(5) |
Nov
(20) |
Dec
(10) |
| 2016 |
Jan
(10) |
Feb
(11) |
Mar
(22) |
Apr
(30) |
May
(33) |
Jun
(3) |
Jul
|
Aug
(12) |
Sep
(20) |
Oct
(11) |
Nov
(15) |
Dec
(8) |
| 2017 |
Jan
(1) |
Feb
(11) |
Mar
(10) |
Apr
|
May
(3) |
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
(1) |
Nov
|
Dec
(3) |
| 2018 |
Jan
(2) |
Feb
|
Mar
(1) |
Apr
|
May
(4) |
Jun
(2) |
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: SourceForge.net <no...@so...> - 2008-11-24 20:55:58
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2339963&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: pgsql DB creation broken w/ schemas Initial Comment: The database creation and upgrade routines for postgreSQL do not fully function when using the schema feature of pgsql. Here's what worked for me: Left is my version, right is 2.2.1.1 from Gentoo ebuild. # diff upgrade.php /usr/share/webapps/postfixadmin/2.2.1.1/htdocs/upgrade.php 79c79 < $sql = "SELECT * FROM " . table_by_key ('config') . " WHERE name = 'version'"; --- > $sql = "SELECT * FROM config WHERE name = 'version'"; 132c132 < $sql = "UPDATE " . table_by_key ('config') . " SET value = $i WHERE name = 'version'"; --- > $sql = "UPDATE config SET value = $i WHERE name = 'version'"; 376c376 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > domain character varying(255) NOT NULL REFERENCES domain, 391c391 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > domain character varying(255) NOT NULL REFERENCES domain, 414c414 < CREATE TABLE ' . table_by_key('mailbox') . ' ( --- > CREATE TABLE mailbox ( 420c420 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > domain character varying(255) NOT NULL REFERENCES domain, 438c438 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > "domain" character varying(255) NOT NULL REFERENCES "domain", 448c448 < on_vacation character varying(255) NOT NULL REFERENCES ' . table_by_key ('vacation') . '(email) ON DELETE CASCADE, --- > on_vacation character varying(255) NOT NULL REFERENCES vacation(email) ON DELETE CASCADE, ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-11-24 20:55 Message: Hi, What you have looks a bit different from what I have from subversion; however, there were some other changes which I've made which might make things better See changeset 487 Thanks! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2339963&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-24 20:28:06
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2339963&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: pgsql DB creation broken w/ schemas Initial Comment: The database creation and upgrade routines for postgreSQL do not fully function when using the schema feature of pgsql. Here's what worked for me: Left is my version, right is 2.2.1.1 from Gentoo ebuild. # diff upgrade.php /usr/share/webapps/postfixadmin/2.2.1.1/htdocs/upgrade.php 79c79 < $sql = "SELECT * FROM " . table_by_key ('config') . " WHERE name = 'version'"; --- > $sql = "SELECT * FROM config WHERE name = 'version'"; 132c132 < $sql = "UPDATE " . table_by_key ('config') . " SET value = $i WHERE name = 'version'"; --- > $sql = "UPDATE config SET value = $i WHERE name = 'version'"; 376c376 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > domain character varying(255) NOT NULL REFERENCES domain, 391c391 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > domain character varying(255) NOT NULL REFERENCES domain, 414c414 < CREATE TABLE ' . table_by_key('mailbox') . ' ( --- > CREATE TABLE mailbox ( 420c420 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > domain character varying(255) NOT NULL REFERENCES domain, 438c438 < domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ', --- > "domain" character varying(255) NOT NULL REFERENCES "domain", 448c448 < on_vacation character varying(255) NOT NULL REFERENCES ' . table_by_key ('vacation') . '(email) ON DELETE CASCADE, --- > on_vacation character varying(255) NOT NULL REFERENCES vacation(email) ON DELETE CASCADE, ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2339963&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-24 11:20:53
|
Bugs item #2338300, was opened at 2008-11-24 12:20 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2338300&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Falco (fschmutz) Assigned to: Nobody/Anonymous (nobody) Summary: French Language Initial Comment: Hello, You know if it s possible to change : $PALANG['pUsersVacation_body_text'] = <<<EOM Je serais absent(e) de <date> jusqu\'au <date>. Pour urgence communiquez avec mon collegue <contact person>. EOM; to $PALANG['pUsersVacation_body_text'] = <<<EOM Je serai absent(e) de <date> jusqu\'au <date>. Pour toute urgence, merci de contacter <contact person>. EOM; I correct the sentence and do it litte bit more french. Thanks & good journey ! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2338300&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-23 15:55:12
|
Bugs item #2073379, was opened at 2008-08-25 10:51 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: v 2.2 Status: Open Resolution: None Priority: 7 Private: No Submitted By: trolo_vk (trolo_vk) Assigned to: Nobody/Anonymous (nobody) Summary: vacation: Invalid from email address WHY? Initial Comment: server#: cat vacation.debug ====== 2008/08/25 12:25:48 ====== Invalid from email address: <aa...@aa...>; exiting. ====== 2008/08/25 12:29:57 ====== Invalid from email address: <bb...@bb...>; exiting. ====== 2008/08/25 12:40:58 ====== [STRIP RECIPIENTS]: | <48B...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [FOUND VACATION]: | <48B...@cc...> | ad...@cc... | =?ISO-8859-2?Q?= <te...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [SEND RESPONSE] for <48B...@cc...>: | FROM: te...@cc... (orig_to: =?ISO-8859-2 <te...@cc...>) | TO: ad...@cc... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnimi zpravami kontaktujte <contact person>. ====== 2008/08/25 12:40:58 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:40:58 2008 Date: Mon, 25 Aug 2008 12:40:58 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: ad...@cc... Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <dd...@dd...>; exiting. ====== 2008/08/25 12:43:12 ====== [STRIP RECIPIENTS]: | <200...@pw...> | te...@cc... ====== 2008/08/25 12:43:12 ====== [FOUND VACATION]: | <200...@pw...> | tre...@ee... | te...@cc... | te...@cc... ====== 2008/08/25 12:43:12 ====== [SEND RESPONSE] for <200...@pw...>: | FROM: te...@cc... (orig_to: te...@cc...) | TO: tre...@ee... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnými zprávami kontaktujte <contact person>. ====== 2008/08/25 12:43:12 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:43:12 2008 Date: Mon, 25 Aug 2008 12:43:12 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: tre...@ee... Result: 250 2.0.0 Ok: queued as AA379DF81C one emial is good and other is not? why? thx for reply ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-11-23 15:55 Message: Yes, I believe it's fixed - but only because we get the to/from address in a different way (i.e. via parameters from postfix). As I understand it, postfix won''t wrap these parameters in < >s, so it's not a problem. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-23 12:26 Message: Do I understand you correct that this should be fixed in the current SVN version? Please add a testcase to be sure and then close this bug as fixed. (BTW: This (and updating the version number in functions.inc.php and the changelog ;-) is the last release blocker for 2.3 IIRC) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-20 06:31 Message: the latest version of vacation doesn't have these particular checks (see changeset 453) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:45 Message: I did some testing with Email::Valid: # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("<foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address(" <foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address("foo <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\" <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\"foo <foo\@example.com>") ? "" : "no\n");' # This means: If there's only the address in <>, it will fail. Prefixing it with anything (quotes, or just a letter) will solve the problem. I'm not sure if this is a bug in Email::Valid or if this address syntax is really invalid - but in practise this syntax appears too often to be ignored. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 22:14 Message: GingerDog: maybe we can add something like (untested, probably needs some tuning to allow whitespace etc.) if $from =~ /^<.*>$/ $from = "\"\"".$from; At least this would be a workaround for the 2.3 release - otherwise lots of vacation notifications will never be sent! ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-31 19:38 Message: Logged In: YES user_id=2192855 Originator: YES I don't know perl! :) but i think that this line if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } check email address, If email address is valid then OK else exit. And i think that when $from=only_email@address.xx then this function not parse good. "and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? " Yes, it is true, but i wait in original solution from postfixadmin team :)) and i think that this prefix I don't mind, because this line check valid email, and then reply go in email address and no in email prefix... hmmm, sorry for my bad english... ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-31 14:18 Message: Logged In: YES user_id=1761957 Originator: NO I'm not sure why prefixing the email address with "" should fix the problem, and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 12:13 Message: Logged In: YES user_id=2192855 Originator: YES So, my solution is: from default code vacation.pl $from = lc ($from); if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } and my solution(provisionally) is: $from = lc ($from); # my big line :)))) $from = "\"\"".$from; if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } i test it and it's work fine ;) so thnx i wait what solution from you... ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-25 12:01 Message: Logged In: YES user_id=1761957 Originator: NO Hi there, Are you able to use the vacation.pl from subversion? It has somewhat better logging in it - which might help identify what the problem is. David ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 11:50 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE2: so, when i send email from www.centrum.cz and i look in vacation.debug, i see: Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <te...@ce...>; exiting. OK, i see header in email and i see: From: <te...@ce...> OK, then i repair my account in centrum.cz and i write my full name, then i send email again and Vacation is good!!! :) i see header in email and i see: From: "Jozko" <te...@ce...> So, when "From:" is only email address(From: <te...@ce...>), script Vacation.pl not know parse "From:" and then write to vacation.debug error: Invalid from email address Is this Bug? thx fo reply and solution again ;) ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 11:21 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE: so not, i write email form this webmail www.orangeportal.sk and vacation is good, but example from webmail www.centrum.cz is not good or my webmail roundcube.cz is not good too... ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 11:12 Message: Logged In: YES user_id=2192855 Originator: YES I found out, that i write email from TH or OUTLOOK then vacation is good, but when I write email from any webmail then vacation is not good(don't send). Sorry for my bad english... Thx for reply and solution ;) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-23 12:26:06
|
Bugs item #2073379, was opened at 2008-08-25 12:51 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: v 2.2 Status: Open Resolution: None Priority: 7 Private: No Submitted By: trolo_vk (trolo_vk) Assigned to: Nobody/Anonymous (nobody) Summary: vacation: Invalid from email address WHY? Initial Comment: server#: cat vacation.debug ====== 2008/08/25 12:25:48 ====== Invalid from email address: <aa...@aa...>; exiting. ====== 2008/08/25 12:29:57 ====== Invalid from email address: <bb...@bb...>; exiting. ====== 2008/08/25 12:40:58 ====== [STRIP RECIPIENTS]: | <48B...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [FOUND VACATION]: | <48B...@cc...> | ad...@cc... | =?ISO-8859-2?Q?= <te...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [SEND RESPONSE] for <48B...@cc...>: | FROM: te...@cc... (orig_to: =?ISO-8859-2 <te...@cc...>) | TO: ad...@cc... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnimi zpravami kontaktujte <contact person>. ====== 2008/08/25 12:40:58 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:40:58 2008 Date: Mon, 25 Aug 2008 12:40:58 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: ad...@cc... Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <dd...@dd...>; exiting. ====== 2008/08/25 12:43:12 ====== [STRIP RECIPIENTS]: | <200...@pw...> | te...@cc... ====== 2008/08/25 12:43:12 ====== [FOUND VACATION]: | <200...@pw...> | tre...@ee... | te...@cc... | te...@cc... ====== 2008/08/25 12:43:12 ====== [SEND RESPONSE] for <200...@pw...>: | FROM: te...@cc... (orig_to: te...@cc...) | TO: tre...@ee... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnými zprávami kontaktujte <contact person>. ====== 2008/08/25 12:43:12 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:43:12 2008 Date: Mon, 25 Aug 2008 12:43:12 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: tre...@ee... Result: 250 2.0.0 Ok: queued as AA379DF81C one emial is good and other is not? why? thx for reply ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-23 13:26 Message: Do I understand you correct that this should be fixed in the current SVN version? Please add a testcase to be sure and then close this bug as fixed. (BTW: This (and updating the version number in functions.inc.php and the changelog ;-) is the last release blocker for 2.3 IIRC) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-20 07:31 Message: the latest version of vacation doesn't have these particular checks (see changeset 453) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-13 00:45 Message: I did some testing with Email::Valid: # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("<foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address(" <foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address("foo <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\" <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\"foo <foo\@example.com>") ? "" : "no\n");' # This means: If there's only the address in <>, it will fail. Prefixing it with anything (quotes, or just a letter) will solve the problem. I'm not sure if this is a bug in Email::Valid or if this address syntax is really invalid - but in practise this syntax appears too often to be ignored. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:14 Message: GingerDog: maybe we can add something like (untested, probably needs some tuning to allow whitespace etc.) if $from =~ /^<.*>$/ $from = "\"\"".$from; At least this would be a workaround for the 2.3 release - otherwise lots of vacation notifications will never be sent! ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-31 21:38 Message: Logged In: YES user_id=2192855 Originator: YES I don't know perl! :) but i think that this line if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } check email address, If email address is valid then OK else exit. And i think that when $from=only_email@address.xx then this function not parse good. "and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? " Yes, it is true, but i wait in original solution from postfixadmin team :)) and i think that this prefix I don't mind, because this line check valid email, and then reply go in email address and no in email prefix... hmmm, sorry for my bad english... ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-31 16:18 Message: Logged In: YES user_id=1761957 Originator: NO I'm not sure why prefixing the email address with "" should fix the problem, and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 14:13 Message: Logged In: YES user_id=2192855 Originator: YES So, my solution is: from default code vacation.pl $from = lc ($from); if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } and my solution(provisionally) is: $from = lc ($from); # my big line :)))) $from = "\"\"".$from; if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } i test it and it's work fine ;) so thnx i wait what solution from you... ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-25 14:01 Message: Logged In: YES user_id=1761957 Originator: NO Hi there, Are you able to use the vacation.pl from subversion? It has somewhat better logging in it - which might help identify what the problem is. David ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:50 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE2: so, when i send email from www.centrum.cz and i look in vacation.debug, i see: Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <te...@ce...>; exiting. OK, i see header in email and i see: From: <te...@ce...> OK, then i repair my account in centrum.cz and i write my full name, then i send email again and Vacation is good!!! :) i see header in email and i see: From: "Jozko" <te...@ce...> So, when "From:" is only email address(From: <te...@ce...>), script Vacation.pl not know parse "From:" and then write to vacation.debug error: Invalid from email address Is this Bug? thx fo reply and solution again ;) ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:21 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE: so not, i write email form this webmail www.orangeportal.sk and vacation is good, but example from webmail www.centrum.cz is not good or my webmail roundcube.cz is not good too... ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:12 Message: Logged In: YES user_id=2192855 Originator: YES I found out, that i write email from TH or OUTLOOK then vacation is good, but when I write email from any webmail then vacation is not good(don't send). Sorry for my bad english... Thx for reply and solution ;) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-23 12:15:08
|
Feature Requests item #2332595, was opened at 2008-11-23 13:15 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2332595&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface Improvements (example) Group: SVN (please specify revision!) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: add "show password" link for mailboxes Initial Comment: SVN r482 introduced showing passwords in edit-mailbox.php - but in a quite broken way because it relied on an browser extension to change the stars in the password field to readable text. r482 was therefore reverted. We should add this feature in a way that works for everybody. (Needless to say that this is only useful for non-encrypted passwords ;-) Some sniplets and ideas from the mailinglist: add a "show password" link (with a $CONF setting to enable it, default should be disabled) which displays the password somewhere (using flash_info or a alert() feeded with a AJAX request) This would have some advantages: - it works in every browser and does not depend on special browser extensions - it only transfers the password on request - which reduces the risk (and number) of passwords in browser cache etc. a lot - it would easily allow to mail a notification to the user, which might be required by some people/companies for privacy or policy reasons > (So far, Postfixadmin is AJAX free, perhaps it should stay this way?) I don't want to do "big" things with AJAX. But I don't see a problem in using something like alert($password_fetched_by_AJAX_request>) The fallback could be that the "show password" link uses flash_info for this - with the disadvantage of causing a page reload (and possibly loose changes). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2332595&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-21 21:11:56
|
Bugs item #1980062, was opened at 2008-05-31 04:25 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1980062&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.1 >Status: Closed >Resolution: Fixed Priority: 7 Private: No Submitted By: Thomas Harold (tgharold) Assigned to: Nobody/Anonymous (nobody) Summary: Long entries in alias.goto field cause log.data field error Initial Comment: Once the length of the alias.goto field approaches 255, PostfixAdmin will start erroring out due to attempting to write information into the log.data field. The fix for this is to make the data field in the log table a "text" (in PostgreSQL) field instead of character(255). ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-21 22:11 Message: Fixed for MySQL in SVN r483. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-20 07:36 Message: it is already text in postgresql ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-13 00:09 Message: We should fix this for 2.3 @GingerDog: What's the PgSQL query needed to change the "data" field to "text"? @Thomas: Are you really still using 2.1? If so, I'd recommend to update to 2.3 when it's released. It contains lots of bugfixes, and hopefully also one for this bug ;-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1980062&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-20 06:36:39
|
Bugs item #1980062, was opened at 2008-05-31 02:25 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1980062&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.1 Status: Open Resolution: None Priority: 7 Private: No Submitted By: Thomas Harold (tgharold) Assigned to: Nobody/Anonymous (nobody) Summary: Long entries in alias.goto field cause log.data field error Initial Comment: Once the length of the alias.goto field approaches 255, PostfixAdmin will start erroring out due to attempting to write information into the log.data field. The fix for this is to make the data field in the log table a "text" (in PostgreSQL) field instead of character(255). ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-11-20 06:36 Message: it is already text in postgresql ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:09 Message: We should fix this for 2.3 @GingerDog: What's the PgSQL query needed to change the "data" field to "text"? @Thomas: Are you really still using 2.1? If so, I'd recommend to update to 2.3 when it's released. It contains lots of bugfixes, and hopefully also one for this bug ;-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1980062&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-20 06:31:31
|
Bugs item #2073379, was opened at 2008-08-25 10:51 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: v 2.2 Status: Open Resolution: None Priority: 7 Private: No Submitted By: trolo_vk (trolo_vk) Assigned to: Nobody/Anonymous (nobody) Summary: vacation: Invalid from email address WHY? Initial Comment: server#: cat vacation.debug ====== 2008/08/25 12:25:48 ====== Invalid from email address: <aa...@aa...>; exiting. ====== 2008/08/25 12:29:57 ====== Invalid from email address: <bb...@bb...>; exiting. ====== 2008/08/25 12:40:58 ====== [STRIP RECIPIENTS]: | <48B...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [FOUND VACATION]: | <48B...@cc...> | ad...@cc... | =?ISO-8859-2?Q?= <te...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [SEND RESPONSE] for <48B...@cc...>: | FROM: te...@cc... (orig_to: =?ISO-8859-2 <te...@cc...>) | TO: ad...@cc... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnimi zpravami kontaktujte <contact person>. ====== 2008/08/25 12:40:58 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:40:58 2008 Date: Mon, 25 Aug 2008 12:40:58 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: ad...@cc... Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <dd...@dd...>; exiting. ====== 2008/08/25 12:43:12 ====== [STRIP RECIPIENTS]: | <200...@pw...> | te...@cc... ====== 2008/08/25 12:43:12 ====== [FOUND VACATION]: | <200...@pw...> | tre...@ee... | te...@cc... | te...@cc... ====== 2008/08/25 12:43:12 ====== [SEND RESPONSE] for <200...@pw...>: | FROM: te...@cc... (orig_to: te...@cc...) | TO: tre...@ee... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnými zprávami kontaktujte <contact person>. ====== 2008/08/25 12:43:12 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:43:12 2008 Date: Mon, 25 Aug 2008 12:43:12 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: tre...@ee... Result: 250 2.0.0 Ok: queued as AA379DF81C one emial is good and other is not? why? thx for reply ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-11-20 06:31 Message: the latest version of vacation doesn't have these particular checks (see changeset 453) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:45 Message: I did some testing with Email::Valid: # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("<foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address(" <foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address("foo <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\" <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\"foo <foo\@example.com>") ? "" : "no\n");' # This means: If there's only the address in <>, it will fail. Prefixing it with anything (quotes, or just a letter) will solve the problem. I'm not sure if this is a bug in Email::Valid or if this address syntax is really invalid - but in practise this syntax appears too often to be ignored. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 22:14 Message: GingerDog: maybe we can add something like (untested, probably needs some tuning to allow whitespace etc.) if $from =~ /^<.*>$/ $from = "\"\"".$from; At least this would be a workaround for the 2.3 release - otherwise lots of vacation notifications will never be sent! ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-31 19:38 Message: Logged In: YES user_id=2192855 Originator: YES I don't know perl! :) but i think that this line if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } check email address, If email address is valid then OK else exit. And i think that when $from=only_email@address.xx then this function not parse good. "and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? " Yes, it is true, but i wait in original solution from postfixadmin team :)) and i think that this prefix I don't mind, because this line check valid email, and then reply go in email address and no in email prefix... hmmm, sorry for my bad english... ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-31 14:18 Message: Logged In: YES user_id=1761957 Originator: NO I'm not sure why prefixing the email address with "" should fix the problem, and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 12:13 Message: Logged In: YES user_id=2192855 Originator: YES So, my solution is: from default code vacation.pl $from = lc ($from); if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } and my solution(provisionally) is: $from = lc ($from); # my big line :)))) $from = "\"\"".$from; if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } i test it and it's work fine ;) so thnx i wait what solution from you... ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-25 12:01 Message: Logged In: YES user_id=1761957 Originator: NO Hi there, Are you able to use the vacation.pl from subversion? It has somewhat better logging in it - which might help identify what the problem is. David ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 11:50 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE2: so, when i send email from www.centrum.cz and i look in vacation.debug, i see: Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <te...@ce...>; exiting. OK, i see header in email and i see: From: <te...@ce...> OK, then i repair my account in centrum.cz and i write my full name, then i send email again and Vacation is good!!! :) i see header in email and i see: From: "Jozko" <te...@ce...> So, when "From:" is only email address(From: <te...@ce...>), script Vacation.pl not know parse "From:" and then write to vacation.debug error: Invalid from email address Is this Bug? thx fo reply and solution again ;) ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 11:21 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE: so not, i write email form this webmail www.orangeportal.sk and vacation is good, but example from webmail www.centrum.cz is not good or my webmail roundcube.cz is not good too... ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 11:12 Message: Logged In: YES user_id=2192855 Originator: YES I found out, that i write email from TH or OUTLOOK then vacation is good, but when I write email from any webmail then vacation is not good(don't send). Sorry for my bad english... Thx for reply and solution ;) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-13 12:24:56
|
Bugs item #2018402, was opened at 2008-07-15 06:52 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.2 >Status: Closed >Resolution: Works For Me Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: error with deleting mailbox or alias Initial Comment: Hi. When I'm want delete a mailbox or alias I see next error: DEBUG INFORMATION: Invalid query: Duplicate entry '2008-07-15 10:22:30' for key 1 and mysql.log 58241 Query DELETE FROM alias WHERE address='te...@ex...' AND domain='example.ru' 58242 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_alias','te...@ex...') 58243 Query SELECT * FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58244 Query DELETE FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58245 Query DELETE FROM vacation WHERE email='te...@ex...' AND domain='example.ru' 58246 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_mailbox','te...@ex...') In my opinion problem be appear at the time of query insert data on table "log" to MySQL in a unit of time. Fixed this problem I can added in file delete.php function sleep(1); 123 $result = db_query ("DELETE FROM $table_mailbox WHERE username='$fDelete' AND domain='$fDomain'"); 124 sleep (1); 125 $postdel_res=mailbox_postdeletion($fDelete,$fDomain); 126 if ($result['rows'] != 1 || !$postdel_res) ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-13 13:24 Message: You indeed have a PRIMARY KEY instead of a normal INDEX on the timestamp field. To fix this, run these two SQL commands: ALTER TABLE `log` DROP PRIMARY KEY; ALTER TABLE `log` ADD INDEX ( `timestamp` ); Since I still have no idea why you have a PRIMARY KEY instead of an INDEX and this is the only report I got about this, I'm closing this bug as "works for me". If you find out where the PRIMARY KEY came from, feel free to reopen ;-) ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-13 04:27 Message: 1) I can't remember when I change log table :) 2) | log | CREATE TABLE `log` ( `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `username` varchar(255) NOT NULL default '', `domain` varchar(255) NOT NULL default '', `action` varchar(255) NOT NULL default '', `data` varchar(255) NOT NULL default '', PRIMARY KEY (`timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=koi8r COMMENT='Postfix Admin - Log' | ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:22 Message: This looks like your "log" table an UNIQUE key on the timestamp field instead of a INDEX. But: I have no _why_ this could happen. Questions: - did you manually modify the log table? - what's the output of SHOW CREATE TABLE log; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-13 03:27:21
|
Bugs item #2018402, was opened at 2008-07-15 04:52 Message generated for change (Comment added) made by nobody You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: error with deleting mailbox or alias Initial Comment: Hi. When I'm want delete a mailbox or alias I see next error: DEBUG INFORMATION: Invalid query: Duplicate entry '2008-07-15 10:22:30' for key 1 and mysql.log 58241 Query DELETE FROM alias WHERE address='te...@ex...' AND domain='example.ru' 58242 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_alias','te...@ex...') 58243 Query SELECT * FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58244 Query DELETE FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58245 Query DELETE FROM vacation WHERE email='te...@ex...' AND domain='example.ru' 58246 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_mailbox','te...@ex...') In my opinion problem be appear at the time of query insert data on table "log" to MySQL in a unit of time. Fixed this problem I can added in file delete.php function sleep(1); 123 $result = db_query ("DELETE FROM $table_mailbox WHERE username='$fDelete' AND domain='$fDomain'"); 124 sleep (1); 125 $postdel_res=mailbox_postdeletion($fDelete,$fDomain); 126 if ($result['rows'] != 1 || !$postdel_res) ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-13 03:27 Message: 1) I can't remember when I change log table :) 2) | log | CREATE TABLE `log` ( `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `username` varchar(255) NOT NULL default '', `domain` varchar(255) NOT NULL default '', `action` varchar(255) NOT NULL default '', `data` varchar(255) NOT NULL default '', PRIMARY KEY (`timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=koi8r COMMENT='Postfix Admin - Log' | ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 22:22 Message: This looks like your "log" table an UNIQUE key on the timestamp field instead of a INDEX. But: I have no _why_ this could happen. Questions: - did you manually modify the log table? - what's the output of SHOW CREATE TABLE log; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 23:49:59
|
Feature Requests item #1719808, was opened at 2007-05-16 08:32 Message generated for change (Settings changed) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=1719808&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: 9evill (simpsas) Assigned to: Nobody/Anonymous (nobody) >Summary: Vacation reply options Initial Comment: Hi could someone create the patch wich makes an option to select how vacation script will replay. Options should be to replay once and replay every time and it should be per user basis. Thanks ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2007-08-22 09:47 Message: Logged In: NO ooyeah some one well do that ..??? lol ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=1719808&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 23:45:24
|
Bugs item #2073379, was opened at 2008-08-25 12:51 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: v 2.2 Status: Open Resolution: None Priority: 7 Private: No Submitted By: trolo_vk (trolo_vk) Assigned to: Nobody/Anonymous (nobody) Summary: vacation: Invalid from email address WHY? Initial Comment: server#: cat vacation.debug ====== 2008/08/25 12:25:48 ====== Invalid from email address: <aa...@aa...>; exiting. ====== 2008/08/25 12:29:57 ====== Invalid from email address: <bb...@bb...>; exiting. ====== 2008/08/25 12:40:58 ====== [STRIP RECIPIENTS]: | <48B...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [FOUND VACATION]: | <48B...@cc...> | ad...@cc... | =?ISO-8859-2?Q?= <te...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [SEND RESPONSE] for <48B...@cc...>: | FROM: te...@cc... (orig_to: =?ISO-8859-2 <te...@cc...>) | TO: ad...@cc... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnimi zpravami kontaktujte <contact person>. ====== 2008/08/25 12:40:58 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:40:58 2008 Date: Mon, 25 Aug 2008 12:40:58 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: ad...@cc... Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <dd...@dd...>; exiting. ====== 2008/08/25 12:43:12 ====== [STRIP RECIPIENTS]: | <200...@pw...> | te...@cc... ====== 2008/08/25 12:43:12 ====== [FOUND VACATION]: | <200...@pw...> | tre...@ee... | te...@cc... | te...@cc... ====== 2008/08/25 12:43:12 ====== [SEND RESPONSE] for <200...@pw...>: | FROM: te...@cc... (orig_to: te...@cc...) | TO: tre...@ee... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnými zprávami kontaktujte <contact person>. ====== 2008/08/25 12:43:12 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:43:12 2008 Date: Mon, 25 Aug 2008 12:43:12 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: tre...@ee... Result: 250 2.0.0 Ok: queued as AA379DF81C one emial is good and other is not? why? thx for reply ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-13 00:45 Message: I did some testing with Email::Valid: # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("foo\@example.com") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("<foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address(" <foo\@example.com>") ? "" : "no\n");' no # perl -we 'use Email::Valid; print (Email::Valid->address("foo <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\" <foo\@example.com>") ? "" : "no\n");' # perl -we 'use Email::Valid; print (Email::Valid->address("\"\"foo <foo\@example.com>") ? "" : "no\n");' # This means: If there's only the address in <>, it will fail. Prefixing it with anything (quotes, or just a letter) will solve the problem. I'm not sure if this is a bug in Email::Valid or if this address syntax is really invalid - but in practise this syntax appears too often to be ignored. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:14 Message: GingerDog: maybe we can add something like (untested, probably needs some tuning to allow whitespace etc.) if $from =~ /^<.*>$/ $from = "\"\"".$from; At least this would be a workaround for the 2.3 release - otherwise lots of vacation notifications will never be sent! ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-31 21:38 Message: Logged In: YES user_id=2192855 Originator: YES I don't know perl! :) but i think that this line if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } check email address, If email address is valid then OK else exit. And i think that when $from=only_email@address.xx then this function not parse good. "and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? " Yes, it is true, but i wait in original solution from postfixadmin team :)) and i think that this prefix I don't mind, because this line check valid email, and then reply go in email address and no in email prefix... hmmm, sorry for my bad english... ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-31 16:18 Message: Logged In: YES user_id=1761957 Originator: NO I'm not sure why prefixing the email address with "" should fix the problem, and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 14:13 Message: Logged In: YES user_id=2192855 Originator: YES So, my solution is: from default code vacation.pl $from = lc ($from); if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } and my solution(provisionally) is: $from = lc ($from); # my big line :)))) $from = "\"\"".$from; if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } i test it and it's work fine ;) so thnx i wait what solution from you... ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-25 14:01 Message: Logged In: YES user_id=1761957 Originator: NO Hi there, Are you able to use the vacation.pl from subversion? It has somewhat better logging in it - which might help identify what the problem is. David ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:50 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE2: so, when i send email from www.centrum.cz and i look in vacation.debug, i see: Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <te...@ce...>; exiting. OK, i see header in email and i see: From: <te...@ce...> OK, then i repair my account in centrum.cz and i write my full name, then i send email again and Vacation is good!!! :) i see header in email and i see: From: "Jozko" <te...@ce...> So, when "From:" is only email address(From: <te...@ce...>), script Vacation.pl not know parse "From:" and then write to vacation.debug error: Invalid from email address Is this Bug? thx fo reply and solution again ;) ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:21 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE: so not, i write email form this webmail www.orangeportal.sk and vacation is good, but example from webmail www.centrum.cz is not good or my webmail roundcube.cz is not good too... ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:12 Message: Logged In: YES user_id=2192855 Originator: YES I found out, that i write email from TH or OUTLOOK then vacation is good, but when I write email from any webmail then vacation is not good(don't send). Sorry for my bad english... Thx for reply and solution ;) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 23:10:01
|
Bugs item #1980062, was opened at 2008-05-31 04:25 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1980062&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.1 Status: Open Resolution: None >Priority: 7 Private: No Submitted By: Thomas Harold (tgharold) Assigned to: Nobody/Anonymous (nobody) Summary: Long entries in alias.goto field cause log.data field error Initial Comment: Once the length of the alias.goto field approaches 255, PostfixAdmin will start erroring out due to attempting to write information into the log.data field. The fix for this is to make the data field in the log table a "text" (in PostgreSQL) field instead of character(255). ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-13 00:09 Message: We should fix this for 2.3 @GingerDog: What's the PgSQL query needed to change the "data" field to "text"? @Thomas: Are you really still using 2.1? If so, I'd recommend to update to 2.3 when it's released. It contains lots of bugfixes, and hopefully also one for this bug ;-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1980062&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 23:01:49
|
Bugs item #2015707, was opened at 2008-07-11 08:04 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2015707&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface (example) Group: v 2.2 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: create-mailbox operation does not show password in op result Initial Comment: create-mailbox operation does not show password in op result when $CONF['generate_password']=='YES' --- create-mailbox.php (revision 401) +++ create-mailbox.php (working copy) @@ -278,22 +278,6 @@ */ $tDomain = $fDomain; - if ($CONF['generate_password'] == "YES") - { - $tMessage .= " / $fPassword)</br />"; - } - else - { - if ($CONF['show_password'] == "YES") - { - $tMessage .= " / $fPassword)</br />"; - } - else - { - $tMessage .= ")</br />"; - } - } - $tQuota = $CONF['maxquota']; if ($fMail == "on") @@ -328,6 +312,23 @@ } } + + if ($CONF['generate_password'] == "YES") + { + $tMessage .= " / $fPassword)</br />"; + } + else + { + if ($CONF['show_password'] == "YES") + { + $tMessage .= " / $fPassword)</br />"; + } + else + { + $tMessage .= ")</br />"; + } + } + } } ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-13 00:01 Message: Thanks for the report and the patch which pointed out that $tMessage is overwritten instead of merged. Fixed in SVN r481 - show password if $CONF['generate_password'] == 'YES' - do not show password if it was _not_ autogenerated and $CONF['show_password'] == 'NO' ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-08-28 18:32 Message: Logged In: NO so, here is patch for this problem: --- create-mailbox.php 2008-07-23 14:41:45.000000000 +0300 +++ create-mailbox-corrected.php 2008-08-28 19:31:13.000000000 +0300 @@ -319,9 +319,9 @@ if (create_mailbox_subfolders($fUsername,$fPassword)) { - $tMessage = $PALANG['pCreate_mailbox_result_success'] . "<br />($fUsername"; + $tMessage = $PALANG['pCreate_mailbox_result_success'] . "<br />($fUsername" . $tMessage; } else { - $tMessage = $PALANG['pCreate_mailbox_result_succes_nosubfolders'] . "<br />($fUsername"; + $tMessage = $PALANG['pCreate_mailbox_result_succes_nosubfolders'] . "<br />($fUsername" . $tMessage; } } ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2015707&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 22:22:31
|
Bugs item #2018402, was opened at 2008-07-15 06:52 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: error with deleting mailbox or alias Initial Comment: Hi. When I'm want delete a mailbox or alias I see next error: DEBUG INFORMATION: Invalid query: Duplicate entry '2008-07-15 10:22:30' for key 1 and mysql.log 58241 Query DELETE FROM alias WHERE address='te...@ex...' AND domain='example.ru' 58242 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_alias','te...@ex...') 58243 Query SELECT * FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58244 Query DELETE FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58245 Query DELETE FROM vacation WHERE email='te...@ex...' AND domain='example.ru' 58246 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_mailbox','te...@ex...') In my opinion problem be appear at the time of query insert data on table "log" to MySQL in a unit of time. Fixed this problem I can added in file delete.php function sleep(1); 123 $result = db_query ("DELETE FROM $table_mailbox WHERE username='$fDelete' AND domain='$fDomain'"); 124 sleep (1); 125 $postdel_res=mailbox_postdeletion($fDelete,$fDomain); 126 if ($result['rows'] != 1 || !$postdel_res) ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:22 Message: This looks like your "log" table an UNIQUE key on the timestamp field instead of a INDEX. But: I have no _why_ this could happen. Questions: - did you manually modify the log table? - what's the output of SHOW CREATE TABLE log; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 22:14:40
|
Bugs item #2073379, was opened at 2008-08-25 12:51 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Vacation Group: v 2.2 Status: Open Resolution: None >Priority: 7 Private: No Submitted By: trolo_vk (trolo_vk) Assigned to: Nobody/Anonymous (nobody) Summary: vacation: Invalid from email address WHY? Initial Comment: server#: cat vacation.debug ====== 2008/08/25 12:25:48 ====== Invalid from email address: <aa...@aa...>; exiting. ====== 2008/08/25 12:29:57 ====== Invalid from email address: <bb...@bb...>; exiting. ====== 2008/08/25 12:40:58 ====== [STRIP RECIPIENTS]: | <48B...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [FOUND VACATION]: | <48B...@cc...> | ad...@cc... | =?ISO-8859-2?Q?= <te...@cc...> | te...@cc... ====== 2008/08/25 12:40:58 ====== [SEND RESPONSE] for <48B...@cc...>: | FROM: te...@cc... (orig_to: =?ISO-8859-2 <te...@cc...>) | TO: ad...@cc... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnimi zpravami kontaktujte <contact person>. ====== 2008/08/25 12:40:58 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:40:58 2008 Date: Mon, 25 Aug 2008 12:40:58 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: ad...@cc... Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <dd...@dd...>; exiting. ====== 2008/08/25 12:43:12 ====== [STRIP RECIPIENTS]: | <200...@pw...> | te...@cc... ====== 2008/08/25 12:43:12 ====== [FOUND VACATION]: | <200...@pw...> | tre...@ee... | te...@cc... | te...@cc... ====== 2008/08/25 12:43:12 ====== [SEND RESPONSE] for <200...@pw...>: | FROM: te...@cc... (orig_to: te...@cc...) | TO: tre...@ee... | VACATION SUBJECT: Dovolenka | VACATION BODY: Som na dovolenke od <date> od <date>. S neodkladnými zprávami kontaktujte <contact person>. ====== 2008/08/25 12:43:12 ====== Mail::Sendmail said :Mail::Sendmail v. 0.79 - Mon Aug 25 12:43:12 2008 Date: Mon, 25 Aug 2008 12:43:12 +0200 Server: localhost Port: 25 From: te...@cc... Subject: Dovolenka To: tre...@ee... Result: 250 2.0.0 Ok: queued as AA379DF81C one emial is good and other is not? why? thx for reply ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:14 Message: GingerDog: maybe we can add something like (untested, probably needs some tuning to allow whitespace etc.) if $from =~ /^<.*>$/ $from = "\"\"".$from; At least this would be a workaround for the 2.3 release - otherwise lots of vacation notifications will never be sent! ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-31 21:38 Message: Logged In: YES user_id=2192855 Originator: YES I don't know perl! :) but i think that this line if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } check email address, If email address is valid then OK else exit. And i think that when $from=only_email@address.xx then this function not parse good. "and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? " Yes, it is true, but i wait in original solution from postfixadmin team :)) and i think that this prefix I don't mind, because this line check valid email, and then reply go in email address and no in email prefix... hmmm, sorry for my bad english... ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-31 16:18 Message: Logged In: YES user_id=1761957 Originator: NO I'm not sure why prefixing the email address with "" should fix the problem, and presumably this will prefix all email addresses with "" even if they already look like '"foo" <fo...@ba...>' ? ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 14:13 Message: Logged In: YES user_id=2192855 Originator: YES So, my solution is: from default code vacation.pl $from = lc ($from); if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } and my solution(provisionally) is: $from = lc ($from); # my big line :)))) $from = "\"\"".$from; if (!Email::Valid->address($from,-mxcheck => 1)) { do_debug("Invalid from email address: $from; exiting."); exit(0); } i test it and it's work fine ;) so thnx i wait what solution from you... ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-08-25 14:01 Message: Logged In: YES user_id=1761957 Originator: NO Hi there, Are you able to use the vacation.pl from subversion? It has somewhat better logging in it - which might help identify what the problem is. David ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:50 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE2: so, when i send email from www.centrum.cz and i look in vacation.debug, i see: Result: 250 2.0.0 Ok: queued as 2D9D9DF81C ====== 2008/08/25 12:42:49 ====== Invalid from email address: <te...@ce...>; exiting. OK, i see header in email and i see: From: <te...@ce...> OK, then i repair my account in centrum.cz and i write my full name, then i send email again and Vacation is good!!! :) i see header in email and i see: From: "Jozko" <te...@ce...> So, when "From:" is only email address(From: <te...@ce...>), script Vacation.pl not know parse "From:" and then write to vacation.debug error: Invalid from email address Is this Bug? thx fo reply and solution again ;) ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:21 Message: Logged In: YES user_id=2192855 Originator: YES UPGRADE: so not, i write email form this webmail www.orangeportal.sk and vacation is good, but example from webmail www.centrum.cz is not good or my webmail roundcube.cz is not good too... ---------------------------------------------------------------------- Comment By: trolo_vk (trolo_vk) Date: 2008-08-25 13:12 Message: Logged In: YES user_id=2192855 Originator: YES I found out, that i write email from TH or OUTLOOK then vacation is good, but when I write email from any webmail then vacation is not good(don't send). Sorry for my bad english... Thx for reply and solution ;) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2073379&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 22:10:40
|
Bugs item #2221002, was opened at 2008-11-04 14:49 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: VARCHAR alias,goto Initial Comment: It is possible to increase varchar in table alias, field goto ? Thanks, a lot of our customers need more than 255 for alias e-mail. Bye ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:10 Message: Good to know that I fixed the right bug ;-) - thanks for testing! ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-12 21:37 Message: Work !! Thanks ! If you need some help to test new update, you can contact me ;) Thanks again Bye --------- Updating database: - old version: 472; target version: 477 updating to version 473 (MySQL)... done --------- ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 21:17 Message: This is probably fixed in SVN r477 (int pointed out the bug on IRC). Please test again ;-) and tell me the result. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 21:07 Message: I assume you are talking about setup.php/upgrade.php? Please run setup.php?debug=1 and tell me the last query it (tries to) execute. ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-12 15:35 Message: Hi, im register to sf now :) But some mistake : DEBUG INFORMATION: Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ NOT NULL' at line 1 Good journey ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 15:03 Message: Thanks for this fix :) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-06 23:10 Message: Good catch - the goto field should never have changed to varchar :-( Fixed in SVN r473. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-06 09:47 Message: Hi, Ideally it would remain a varchar field, and the table would be re-organised to have a proper relational model - i.e. address -> alias, goto; alias, goto etc Instead of being separated by commas. Anyway, interestingly enough, my local postfix database has alias.goto as a text field; and it is initially created as this in the upgrade.php file. However, having said this, the last update Christian made sets it to be a varchar(255). Have we gotten out of sync somewhere? ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-04 14:51 Message: Sorry, we forgot something, maybe it is possible to change this field in text format ? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 22:08:16
|
Bugs item #2013772, was opened at 2008-07-08 22:00 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2013772&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: "undeliverable" marker doesn't detect catchall account Initial Comment: SVN r358, most probably still valid in r399 The "probably undeliverable" marker doesn't detect local catchall aliases and marks targets that use the catchall as undeliverable. Example: Alias *@example.com exists (and example.com is a valid local domain in postfixadmin) Alias fo...@my... -> ba...@ex... is marked as probably undeliverable ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 23:08 Message: Fixed in SVN r480 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2013772&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 21:54:40
|
Bugs item #2147740, was opened at 2008-10-05 14:43 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2147740&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: v 2.2 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Holger Ackermann (hoacker) Assigned to: Nobody/Anonymous (nobody) Summary: Superadmin can't create new "fetch email" Initial Comment: Postfixadmin 2.2.1.1 Super admin can only create "fetch email" for himself and not for other mailboxes. Reason: In sql table "domain_admins" the domain "ALL" ist the only domain listed for the super admin. Function "list_domains_for_admins()" in functions.inc.php returns "ALL" for super admins. The sql query in "fetchmail.php" then expands to "SELECT username FROM mailbox WHERE domain in ('ALL')". This query returns no result as there is no domain "ALL". ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 22:54 Message: Thanks for the report! Fixed in SVN r479. (Note: you'll need to run setup.php again because I have renamed a field.) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2147740&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 21:51:45
|
Bugs item #2265333, was opened at 2008-11-12 00:09 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2265333&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Core Group: SVN (please specify revision!) >Status: Closed >Resolution: Fixed Priority: 8 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: "ssl" is a reserved word in mysql - breaks fetchmail Initial Comment: (SVN r476) The "ssl" field in the fetchmail table causes an "invalid query" error message in MySQL because "ssl" is a reserved word. Options: a) quote the field name b) rename the field a) would be the better solution, but needs to be tested against PgSQL. @GingerDog: Does the following query (with field names in backtick quotes) work in PgSQL? SELECT `id`,`mailbox`,`src_server`,`src_auth`, `src_user`,`src_password`,`src_folder`,`poll_time`, `fetchall`,`keep`,`protocol`,`ssl`,`extra_options`, `mda`,`date`,`returned_text` FROM fetchmail order by id desc This bug affects everything around fetchmail. If we go for a), we need to change - the queries in fetchmail.php - maybe fetchmail.pl - some db_* functions in functions.php ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 22:51 Message: Fixed in SVN r479 (by renaming the field to "usessl") ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 10:17 Message: FWIW, my preference would be to rename the field, as it's bound to cause problems later on if it needs quoting all the time. e.g. s/ssl/use_ssl/ ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 10:16 Message: I don't think PostgreSQL likes back ticks (I certainly don't anyway). I believe you "escape" key words using double quotes - like "ssl". ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2265333&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 20:37:07
|
Bugs item #2221002, was opened at 2008-11-04 14:49 Message generated for change (Comment added) made by fschmutz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: VARCHAR alias,goto Initial Comment: It is possible to increase varchar in table alias, field goto ? Thanks, a lot of our customers need more than 255 for alias e-mail. Bye ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-12 21:37 Message: Work !! Thanks ! If you need some help to test new update, you can contact me ;) Thanks again Bye --------- Updating database: - old version: 472; target version: 477 updating to version 473 (MySQL)... done --------- ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 21:17 Message: This is probably fixed in SVN r477 (int pointed out the bug on IRC). Please test again ;-) and tell me the result. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 21:07 Message: I assume you are talking about setup.php/upgrade.php? Please run setup.php?debug=1 and tell me the last query it (tries to) execute. ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-12 15:35 Message: Hi, im register to sf now :) But some mistake : DEBUG INFORMATION: Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ NOT NULL' at line 1 Good journey ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 15:03 Message: Thanks for this fix :) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-06 23:10 Message: Good catch - the goto field should never have changed to varchar :-( Fixed in SVN r473. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-06 09:47 Message: Hi, Ideally it would remain a varchar field, and the table would be re-organised to have a proper relational model - i.e. address -> alias, goto; alias, goto etc Instead of being separated by commas. Anyway, interestingly enough, my local postfix database has alias.goto as a text field; and it is initially created as this in the upgrade.php file. However, having said this, the last update Christian made sets it to be a varchar(255). Have we gotten out of sync somewhere? ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-04 14:51 Message: Sorry, we forgot something, maybe it is possible to change this field in text format ? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 20:17:19
|
Bugs item #2221002, was opened at 2008-11-04 14:49 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: VARCHAR alias,goto Initial Comment: It is possible to increase varchar in table alias, field goto ? Thanks, a lot of our customers need more than 255 for alias e-mail. Bye ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 21:17 Message: This is probably fixed in SVN r477 (int pointed out the bug on IRC). Please test again ;-) and tell me the result. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 21:07 Message: I assume you are talking about setup.php/upgrade.php? Please run setup.php?debug=1 and tell me the last query it (tries to) execute. ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-12 15:35 Message: Hi, im register to sf now :) But some mistake : DEBUG INFORMATION: Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ NOT NULL' at line 1 Good journey ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 15:03 Message: Thanks for this fix :) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-06 23:10 Message: Good catch - the goto field should never have changed to varchar :-( Fixed in SVN r473. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-06 09:47 Message: Hi, Ideally it would remain a varchar field, and the table would be re-organised to have a proper relational model - i.e. address -> alias, goto; alias, goto etc Instead of being separated by commas. Anyway, interestingly enough, my local postfix database has alias.goto as a text field; and it is initially created as this in the upgrade.php file. However, having said this, the last update Christian made sets it to be a varchar(255). Have we gotten out of sync somewhere? ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-04 14:51 Message: Sorry, we forgot something, maybe it is possible to change this field in text format ? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 20:07:21
|
Bugs item #2221002, was opened at 2008-11-04 14:49 Message generated for change (Comment added) made by christian_boltz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: VARCHAR alias,goto Initial Comment: It is possible to increase varchar in table alias, field goto ? Thanks, a lot of our customers need more than 255 for alias e-mail. Bye ---------------------------------------------------------------------- >Comment By: Christian Boltz (christian_boltz) Date: 2008-11-12 21:07 Message: I assume you are talking about setup.php/upgrade.php? Please run setup.php?debug=1 and tell me the last query it (tries to) execute. ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-12 15:35 Message: Hi, im register to sf now :) But some mistake : DEBUG INFORMATION: Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ NOT NULL' at line 1 Good journey ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 15:03 Message: Thanks for this fix :) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-06 23:10 Message: Good catch - the goto field should never have changed to varchar :-( Fixed in SVN r473. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-06 09:47 Message: Hi, Ideally it would remain a varchar field, and the table would be re-organised to have a proper relational model - i.e. address -> alias, goto; alias, goto etc Instead of being separated by commas. Anyway, interestingly enough, my local postfix database has alias.goto as a text field; and it is initially created as this in the upgrade.php file. However, having said this, the last update Christian made sets it to be a varchar(255). Have we gotten out of sync somewhere? ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-04 14:51 Message: Sorry, we forgot something, maybe it is possible to change this field in text format ? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-12 14:35:25
|
Bugs item #2221002, was opened at 2008-11-04 14:49 Message generated for change (Comment added) made by fschmutz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: VARCHAR alias,goto Initial Comment: It is possible to increase varchar in table alias, field goto ? Thanks, a lot of our customers need more than 255 for alias e-mail. Bye ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-12 15:35 Message: Hi, im register to sf now :) But some mistake : DEBUG INFORMATION: Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') /*!40100 CHARACTER SET latin1 COLLATE latin1_swedish_ci */ NOT NULL' at line 1 Good journey ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-12 15:03 Message: Thanks for this fix :) ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-11-06 23:10 Message: Good catch - the goto field should never have changed to varchar :-( Fixed in SVN r473. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-06 09:47 Message: Hi, Ideally it would remain a varchar field, and the table would be re-organised to have a proper relational model - i.e. address -> alias, goto; alias, goto etc Instead of being separated by commas. Anyway, interestingly enough, my local postfix database has alias.goto as a text field; and it is initially created as this in the upgrade.php file. However, having said this, the last update Christian made sets it to be a varchar(255). Have we gotten out of sync somewhere? ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-04 14:51 Message: Sorry, we forgot something, maybe it is possible to change this field in text format ? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2221002&group_id=191583 |
700 messages has been excluded from this view by a project administrator.
