[rt-devel] RT 2.0.14-pre1

[Florian Weimer]

Jesse Vincent <jesse at bestpractical.com> writes:

> It seems to me like the lightest-weight solution here is to create and 
> document an alternate pg 7.2+ schema for RT 2.0.x and create a similar
> schema for the 2.1.x series as the "native" pg schema.

Yes, and while you are at it, you should offer a way to choose the
column type of the ticket ID columns.  AFAIK, some people would like
to have int8 ticket IDs. ;-)

> Slightly longer term is to drop a proper exception system into
> DBIx::SearchBuilder so that it can cope cleanly.

BTW, rt-mailgate should return a special error code to signal the MTA
that the database is temporarily unavailable:

--- rt-gate     2002/07/01 15:42:39     1.1
+++ rt-gate     2002/07/01 15:56:02
@@ -39,7 +39,11 @@
 LoadConfig();

 #Connect to the database and get RT::SystemUser and RT::Nobody loaded
-DBConnect();
+eval { DBConnect(); };
+if ($@) {
+  print "$@\n";
+  exit 57;                     # magic exit status for our Exim config
+}

 #Drop setgid permissions
 RT::DropSetGIDPermissions();


After such a change, mail doesn't get lost just because you are
restarting your database.  (You have to drop the "print" for some
MTAs, and change the exit status to 67 or something like that.)

-- 
Florian Weimer 	                  Weimer at CERT.Uni-Stuttgart.DE
University of Stuttgart           http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT                          fax +49-711-685-5898