Thread: [ postfixadmin-Bugs-2339963 ] pgsql DB creation broken w/ schemas
Brought to you by:
christian_boltz,
gingerdog
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 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 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 |
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: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: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: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: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-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-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 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...> - 2009-01-14 15:55:33
|
Bugs item #2339963, was opened at 2008-11-24 20:28 Message generated for change (Settings changed) 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: Closed >Resolution: Fixed 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 |