postfixadmin-tracker Mailing List for PostfixAdmin (Page 43)
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-12-13 07:32:52
|
Bugs item #2423106, was opened at 2008-12-13 02:18 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2423106&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: Accepted Priority: 5 Private: No Submitted By: Matt Rude (evenly) Assigned to: Nobody/Anonymous (nobody) Summary: SQL Upgrade 495 has SQL error Initial Comment: SVN Version 499 I was having a problem upgrading my PA to the last's SVN version. When I would run the upgrade.php script page it would error out on the upgrade_495_mysql function. Attached is the patch. ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-12-13 07:32 Message: Hi; thanks for the bug report - sorry for breaking it - it obviously works with postgresql, and I ran the individual sql commands on the mysql db - and they worked... clearly I failed to type properly, and should have tested it a little more. Anyhow, fixed in changeset 500. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2423106&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-12-13 02:18:44
|
Bugs item #2423106, was opened at 2008-12-12 20:18 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=2423106&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: Open Resolution: None Priority: 5 Private: No Submitted By: Matt Rude (evenly) Assigned to: Nobody/Anonymous (nobody) Summary: SQL Upgrade 495 has SQL error Initial Comment: SVN Version 499 I was having a problem upgrading my PA to the last's SVN version. When I would run the upgrade.php script page it would error out on the upgrade_495_mysql function. Attached is the patch. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2423106&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-12-12 20:56:10
|
Bugs item #2378038, was opened at 2008-12-02 15:42 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2378038&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: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: clear transport field after editing of domain Initial Comment: After editing of domain the transport field is blank. ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-12-12 20:56 Message: fixed in changeset 499 thanks for reporting the bug. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-12-12 20:56 Message: Thanks for the bug report; we believe this has been fixed in subversion. ---------------------------------------------------------------------- Comment By: Georgi Naplatanov (goshoo) Date: 2008-12-02 15:45 Message: I forgot to login when create this artifact. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2378038&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-12-09 12:16:28
|
Bugs item #2209340, was opened at 2008-10-30 09:01 Message generated for change (Comment added) made by lathiere You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2209340&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: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: "invalid parameter" when deleting an alias Initial Comment: on the Admin interface, when I try to delete an alias, I've got the message "invalid parameter". ---------------------------------------------------------------------- Comment By: Benoit Lathiere (lathiere) Date: 2008-12-09 12:16 Message: The problem : When You click on "delete" in the search page, the URL is : http://server/postfixadmin/delete.php?delete=j.white&domain=toto.org but the URL must be http://server/postfixadmin/delete.php?table=alias&delete=j.white&domain=toto.org (as in mailbox deletion) The first parameter "table" is missing. You have just to modify your template/search.php file like this : Line86 : print " <td><a href=\"delete.php?table=alias&"; Line 96 : print " <td><a href=\"delete.php?table=alias&delete=" . urlencode ($tAlias[$i]['address']) . "&domain=" . $tAlias[$i]['domain'] . "\"onclick=\"return confirm ('" . $PALANG['confirm'] . $PALANG['pOverview_get_aliases'] . ": ". $tAlias[$i]['address'] . "')\">" . $PALANG['del'] . "</a></td>\n"; ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-06 08:49 Message: works for me; what version of postfixadmin are you using? ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-10-30 09:08 Message: By the way, my email for responses : b.l...@is... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2209340&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-12-02 15:45:12
|
Bugs item #2378038, was opened at 2008-12-02 17:42 Message generated for change (Comment added) made by goshoo You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2378038&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: clear transport field after editing of domain Initial Comment: After editing of domain the transport field is blank. ---------------------------------------------------------------------- Comment By: Georgi Naplatanov (goshoo) Date: 2008-12-02 17:45 Message: I forgot to login when create this artifact. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2378038&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-12-02 15:42:47
|
Bugs item #2378038, was opened at 2008-12-02 15:42 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=2378038&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: clear transport field after editing of domain Initial Comment: After editing of domain the transport field is blank. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2378038&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-29 20:46:01
|
Bugs item #2359801, was opened at 2008-11-29 18:45 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=2359801&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: Open Resolution: None Priority: 5 Private: No Submitted By: Luis (luiscastilho) Assigned to: Nobody/Anonymous (nobody) Summary: Login errors should be less specific Initial Comment: When trying to log in, the login page errors tell you if it's the login or the password that's not valid. This way an attacker could discover valid logins and then focus on finding the right password for that account (with a dictionary attack and some luck, for example). In the .lang files, "pLogin_username_incorrect" and "pLogin_password_incorrect" should print the same error. Something like "Invalid login and/or password". ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2359801&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-27 10:37:00
|
Bugs item #2353128, was opened at 2008-11-27 09:59 Message generated for change (Comment added) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2353128&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: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: yava (vyava) Assigned to: Nobody/Anonymous (nobody) Summary: User alias goto ends with ',' Initial Comment: When user changes goto to empty, query "select * from postfix.alias;" shows goto="us...@do...d,". replace '$goto = implode(",",$goto);' with '$goto = trim(implode(",",$goto),",");' in /var/www/postfixadmin/users/edit-alias.php line 86 or don't append empty $goto on line 83. ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-11-27 10:36 Message: I think this is already fixed in what is in subversion/trunk. (firstly, users/edit-alias.php doesn't exist, and secondly /edit-alias.php doesn't use implode any longer) thanks David ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2353128&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-27 09:59:45
|
Bugs item #2353128, was opened at 2008-11-27 11:59 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=2353128&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: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: yava (vyava) Assigned to: Nobody/Anonymous (nobody) Summary: User alias goto ends with ',' Initial Comment: When user changes goto to empty, query "select * from postfix.alias;" shows goto="us...@do...d,". replace '$goto = implode(",",$goto);' with '$goto = trim(implode(",",$goto),",");' in /var/www/postfixadmin/users/edit-alias.php line 86 or don't append empty $goto on line 83. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2353128&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-25 17:03:46
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by nobody 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: Nobody/Anonymous (nobody) Date: 2008-11-25 17:03 Message: Where DB=unified SCHEMA=postfix and there are no other tables in any schema within unified, and postfix is not on the schema_path. postgres=# \c unified You are now connected to database "unified". unified=# select relname from pg_class where relname = 'domain'; relname --------- domain (1 row) unified=# select relname from pg_class where relname = 'postfix.domain'; relname --------- (0 rows) ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-25 15:48 Message: Power outage ATM, otherwise I'd give an answer for those selects... *sigh* Will do as soon as I can look. _pgsql_field_exists does not work properly with schemas. With DB: unified schema: postfix and table: domain that INCLUDES the quota column, the _pgsql_field_exists call on line 516 returns FALSE. It needs to return TRUE since the column does exist. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-25 09:56 Message: Hi, I've not used schema's with postgres before - so does the following still work to determine if a table/object exists? : "SELECT relname from pg_class WHERE relname = 'domain'" (for example) and "SELECT relname from pg_class WHERE relname = 'postfix.domain'" (for example) I still can't see what problem you are gettign with upgrade_4_pgsql.... (Line 407 fixed) ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:29 Message: Comparing to subversion trunk via the link you posted: line 407 is wrong, should be: CREATE TABLE ' . table_by_key('mailbox') . ' ( ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:21 Message: Then back into setup.php on line ~312 There's a db_query that needs " . table_by_key('domain') . " tossed in as well. There's comment: "// XXX" just above it if you need something to search for. After all that it lets me create the domain admin user. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:14 Message: The first if within upgrade_4_pgsql fails when $table_domain = "postfix.domain"; 0 Rows are returned, even though quota exists in my db already. postfix is the schema I'm using within a DB called "unified". Since the column already exists, I commented this if section out and continue... Each of the DB changes that uses "REFERENCES" needs to be modified to use table_by_key for the reference as well. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:07 Message: Subvesion version - see https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk/upgrade.php Can you elabourate on the problem in update_4_pgsql... I can't see anything wrong with it ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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-25 15:48:07
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by nobody 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: Nobody/Anonymous (nobody) Date: 2008-11-25 15:48 Message: Power outage ATM, otherwise I'd give an answer for those selects... *sigh* Will do as soon as I can look. _pgsql_field_exists does not work properly with schemas. With DB: unified schema: postfix and table: domain that INCLUDES the quota column, the _pgsql_field_exists call on line 516 returns FALSE. It needs to return TRUE since the column does exist. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-25 09:56 Message: Hi, I've not used schema's with postgres before - so does the following still work to determine if a table/object exists? : "SELECT relname from pg_class WHERE relname = 'domain'" (for example) and "SELECT relname from pg_class WHERE relname = 'postfix.domain'" (for example) I still can't see what problem you are gettign with upgrade_4_pgsql.... (Line 407 fixed) ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:29 Message: Comparing to subversion trunk via the link you posted: line 407 is wrong, should be: CREATE TABLE ' . table_by_key('mailbox') . ' ( ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:21 Message: Then back into setup.php on line ~312 There's a db_query that needs " . table_by_key('domain') . " tossed in as well. There's comment: "// XXX" just above it if you need something to search for. After all that it lets me create the domain admin user. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:14 Message: The first if within upgrade_4_pgsql fails when $table_domain = "postfix.domain"; 0 Rows are returned, even though quota exists in my db already. postfix is the schema I'm using within a DB called "unified". Since the column already exists, I commented this if section out and continue... Each of the DB changes that uses "REFERENCES" needs to be modified to use table_by_key for the reference as well. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:07 Message: Subvesion version - see https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk/upgrade.php Can you elabourate on the problem in update_4_pgsql... I can't see anything wrong with it ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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-25 14:00:36
|
Bugs item #2338300, was opened at 2008-11-24 12:20 Message generated for change (Comment added) made by fschmutz 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: Languages Group: None Status: Closed Resolution: Accepted 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 ! ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-25 15:00 Message: Ok, it s fixed, thanks good job ! Bye ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-25 11:00 Message: Hi - yes, a seperate issue; my failure to test... fixed now ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-25 00:06 Message: Some mistakes with last update : When i execute upgrade.php Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/postfixadmin/upgrade.php on line 375 Bye ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 22:01 Message: Merged; See changeset 488 ---------------------------------------------------------------------- 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-25 13:05:00
|
Bugs item #2343328, was opened at 2008-11-25 14:04 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=2343328&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: SVN (please specify revision!) Status: Open Resolution: None Priority: 8 Private: No Submitted By: Christian Boltz (christian_boltz) Assigned to: Nobody/Anonymous (nobody) Summary: Can't delete domain alias Initial Comment: SVN r491 I have (in my local test installation): bar.de is an alias domain for: baz.de ... [delete] If I click the delete link, I get an error message "invalid parameter". The delete link points to delete.php?table=alias_domain&delete=bar.de&domain=bar.de That's a release blocker, but hopefully easy to fix. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2343328&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-25 10:01:51
|
Bugs item #1882082, was opened at 2008-01-29 21:23 Message generated for change (Settings changed) made by gingerdog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1882082&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: Languages Group: None >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: Norwegian bokmål-support Initial Comment: I have translated all the strings to Norwegian bokmål, the majority language in Norway. -- Morten Hustveit ---------------------------------------------------------------------- Comment By: Odd Henriksen (oddhenriksen) Date: 2008-05-06 22:51 Message: Logged In: YES user_id=1672080 Originator: NO As there doesn't seem to be any activity on this, I've created a new and complete Norwegian (bokmål) translation with all latest strings, and will create a new ticket and post it there. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2008-01-29 23:09 Message: Logged In: YES user_id=593261 Originator: NO Hmmm, I have some "problems" with your translation: - we already have a norwegian translation (nn.lang) - you have translated an old version of the language file, which means I will need some time to merge it for the current version - and the number of translated strings in nn.lang and your file are roughly the same The latest norwegian translation file is: http://postfixadmin.svn.sourceforge.net/viewvc/*checkout*/postfixadmin/trunk/languages/nn.lang Is it possible for you to use this file as base for your translation? I would really appreciate that. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1882082&group_id=191583 |
|
From: SourceForge.net <no...@so...> - 2008-11-25 10:00:52
|
Bugs item #2338300, was opened at 2008-11-24 11:20 Message generated for change (Comment added) made by gingerdog 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: Languages Group: None >Status: Closed Resolution: Accepted 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 ! ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-11-25 10:00 Message: Hi - yes, a seperate issue; my failure to test... fixed now ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-24 23:06 Message: Some mistakes with last update : When i execute upgrade.php Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/postfixadmin/upgrade.php on line 375 Bye ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:01 Message: Merged; See changeset 488 ---------------------------------------------------------------------- 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-25 09:56:55
|
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-25 09:56 Message: Hi, I've not used schema's with postgres before - so does the following still work to determine if a table/object exists? : "SELECT relname from pg_class WHERE relname = 'domain'" (for example) and "SELECT relname from pg_class WHERE relname = 'postfix.domain'" (for example) I still can't see what problem you are gettign with upgrade_4_pgsql.... (Line 407 fixed) ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:29 Message: Comparing to subversion trunk via the link you posted: line 407 is wrong, should be: CREATE TABLE ' . table_by_key('mailbox') . ' ( ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:21 Message: Then back into setup.php on line ~312 There's a db_query that needs " . table_by_key('domain') . " tossed in as well. There's comment: "// XXX" just above it if you need something to search for. After all that it lets me create the domain admin user. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:14 Message: The first if within upgrade_4_pgsql fails when $table_domain = "postfix.domain"; 0 Rows are returned, even though quota exists in my db already. postfix is the schema I'm using within a DB called "unified". Since the column already exists, I commented this if section out and continue... Each of the DB changes that uses "REFERENCES" needs to be modified to use table_by_key for the reference as well. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:07 Message: Subvesion version - see https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk/upgrade.php Can you elabourate on the problem in update_4_pgsql... I can't see anything wrong with it ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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 23:06:24
|
Bugs item #2338300, was opened at 2008-11-24 12:20 Message generated for change (Comment added) made by fschmutz 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: Languages Group: None Status: Closed Resolution: Accepted 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 ! ---------------------------------------------------------------------- Comment By: Falco (fschmutz) Date: 2008-11-25 00:06 Message: Some mistakes with last update : When i execute upgrade.php Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/postfixadmin/upgrade.php on line 375 Bye ;) ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 22:01 Message: Merged; See changeset 488 ---------------------------------------------------------------------- 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-24 21:29:08
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by nobody 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: Nobody/Anonymous (nobody) Date: 2008-11-24 21:29 Message: Comparing to subversion trunk via the link you posted: line 407 is wrong, should be: CREATE TABLE ' . table_by_key('mailbox') . ' ( ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:21 Message: Then back into setup.php on line ~312 There's a db_query that needs " . table_by_key('domain') . " tossed in as well. There's comment: "// XXX" just above it if you need something to search for. After all that it lets me create the domain admin user. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:14 Message: The first if within upgrade_4_pgsql fails when $table_domain = "postfix.domain"; 0 Rows are returned, even though quota exists in my db already. postfix is the schema I'm using within a DB called "unified". Since the column already exists, I commented this if section out and continue... Each of the DB changes that uses "REFERENCES" needs to be modified to use table_by_key for the reference as well. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:07 Message: Subvesion version - see https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk/upgrade.php Can you elabourate on the problem in update_4_pgsql... I can't see anything wrong with it ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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 21:22:05
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by nobody 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: Nobody/Anonymous (nobody) Date: 2008-11-24 21:21 Message: Then back into setup.php on line ~312 There's a db_query that needs " . table_by_key('domain') . " tossed in as well. There's comment: "// XXX" just above it if you need something to search for. After all that it lets me create the domain admin user. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:14 Message: The first if within upgrade_4_pgsql fails when $table_domain = "postfix.domain"; 0 Rows are returned, even though quota exists in my db already. postfix is the schema I'm using within a DB called "unified". Since the column already exists, I commented this if section out and continue... Each of the DB changes that uses "REFERENCES" needs to be modified to use table_by_key for the reference as well. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:07 Message: Subvesion version - see https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk/upgrade.php Can you elabourate on the problem in update_4_pgsql... I can't see anything wrong with it ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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 21:14:45
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by nobody 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: Nobody/Anonymous (nobody) Date: 2008-11-24 21:14 Message: The first if within upgrade_4_pgsql fails when $table_domain = "postfix.domain"; 0 Rows are returned, even though quota exists in my db already. postfix is the schema I'm using within a DB called "unified". Since the column already exists, I commented this if section out and continue... Each of the DB changes that uses "REFERENCES" needs to be modified to use table_by_key for the reference as well. ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:07 Message: Subvesion version - see https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk/upgrade.php Can you elabourate on the problem in update_4_pgsql... I can't see anything wrong with it ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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 21:07:30
|
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 21:07 Message: Subvesion version - see https://postfixadmin.svn.sourceforge.net/svnroot/postfixadmin/trunk/upgrade.php Can you elabourate on the problem in update_4_pgsql... I can't see anything wrong with it ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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 21:02:49
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by nobody 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: Nobody/Anonymous (nobody) Date: 2008-11-24 21:02 Message: Wow, quick response. I don't know anything about subversion, the above right side was from the 2.2.1.1 release as retrieved via Gentoo ebuild process, left side was the changes I made. I have never before played with pgsql btw - so it's probably ugly, but it got me through version 3 of the DB changes. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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 21:02:27
|
Bugs item #2338300, was opened at 2008-11-24 11:20 Message generated for change (Settings changed) made by gingerdog 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: Languages Group: None >Status: Closed >Resolution: Accepted 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 ! ---------------------------------------------------------------------- Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:01 Message: Merged; See changeset 488 ---------------------------------------------------------------------- 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-24 21:01:45
|
Bugs item #2338300, was opened at 2008-11-24 11:20 Message generated for change (Comment added) made by gingerdog 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 ! ---------------------------------------------------------------------- >Comment By: GingerDog (gingerdog) Date: 2008-11-24 21:01 Message: Merged; See changeset 488 ---------------------------------------------------------------------- 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-24 21:00:17
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Comment added) made by nobody 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: Nobody/Anonymous (nobody) Date: 2008-11-24 21:00 Message: _pgsql_field_exists also doesn't work in regard to function upgrade_4_pgsql. I haven't figured out a solution. First time playing with pgsql. ---------------------------------------------------------------------- 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 |
700 messages has been excluded from this view by a project administrator.
