Rt 1.3.17

I’ve released RT 1.3.17 and DBIx::SearchBuilder 0.0.3 (not yet to CPAN).
This release adds ticket modification (including watchers) through the
web ui. As far as I know, RT 1.3.17 fulfills all the items in the
“Alpha1” featureset list.

If a couple of you would be willing to download it and attempt an installation,
I’d appreciate it. The first person (other than me) to create a ticket by
mail, cli and web (without hacking code) gets to name the alpha1 release.*

You get bonus points if you do it on oracle.

http://www.fsck.com/pub/rt/devel

Jesse

*Some limitations may apply. If you win, ask me for details :wink:

jesse reed vincent — root@eruditorum.orgjesse@fsck.com
pgp keyprint: 50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
“Mary had a crypto key / She kept it in escrow
And everything that Mary said / The Feds were sure to know” – Sam Simpson

I’ve released RT 1.3.17 and DBIx::SearchBuilder 0.0.3 (not yet to CPAN).
This release adds ticket modification (including watchers) through the
web ui. As far as I know, RT 1.3.17 fulfills all the items in the
“Alpha1” featureset list.

If a couple of you would be willing to download it and attempt an installation,
I’d appreciate it. The first person (other than me) to create a ticket by
mail, cli and web (without hacking code) gets to name the alpha1 release.*

Yay! I’m probably disqualified, though.

You get bonus points if you do it on oracle.

No oracle for me, but on a similar topic, what’s the status of the Pg
port?

Here’s some (fairly trivial) diffs:

Index: Makefile
RCS file: /proj/maps/src/rt/Makefile,v
retrieving revision 1.1.2.3
retrieving revision 1.7
diff -u -r1.1.2.3 -r1.7
— Makefile 2000/09/15 11:05:05 1.1.2.3
+++ Makefile 2000/09/15 11:17:47 1.7
@@ -119,7 +119,8 @@

The user your webserver runs as. needed so that webrt can cache mason

objectcode

-WEB_USER = nobody
+WEB_USER = www-data
+WEB_GROUP = rt

}}}

@@ -203,6 +204,8 @@
s’!!RT_ADMIN_BIN!!‘$(RT_ADMIN_BIN)‘g;
s’!!RT_MAILGATE_BIN!!’$(RT_MAILGATE_BIN)‘g;
s’!!RT_ETC_PATH!!'$(RT_ETC_PATH)'g;\

  •                           s'!!WEB_USER!!'$(WEB_USER)'g;\
    
  •                           s'!!WEB_GROUP!!'$(WEB_GROUP)'g;\
                              s'!!RT_LIB_PATH!!'$(RT_LIB_PATH)'g;" \
                                      $(RT_PERL_MUX) $(RT_MODPERL_HANDLER) $(RT_FASTCGI_HANDLER)
    

Index: README
RCS file: /proj/maps/src/rt/README,v
retrieving revision 1.1.2.2
retrieving revision 1.6
diff -u -r1.1.2.2 -r1.6
— README 2000/09/09 02:01:33 1.1.2.2
+++ README 2000/09/11 06:29:57 1.6
@@ -140,8 +140,8 @@

TODO: THE CALLING CONVENTION FOR THE MAILGATE HAS CHANGED

  • rt-comment: |“/path/to/rt/bin/rt-mailgate general comment”
  • rt: |“/path/to/rt/bin/rt-mailgate general correspond”
  • rt-comment: |“/path/to/rt/bin/rt-mailgate -q general -a comment”
  • rt: |“/path/to/rt/bin/rt-mailgate -q general -a correspond”
    | |
    <----/ |
    |
    @@ -158,7 +158,7 @@

You’ll need an alias like the following for action requests:

  •    rt-action:      |"/path/to/rt/bin/rt-mailgate general action"
    
  •    rt-action:      |"/path/to/rt/bin/rt-mailgate -q general -a action"
    

THE WEB UI
Index: bin/initacls.mysql
RCS file: /proj/maps/src/rt/bin/initacls.mysql,v
retrieving revision 1.1.2.1
retrieving revision 1.2
diff -u -r1.1.2.1 -r1.2
— bin/initacls.mysql 2000/08/10 11:41:51 1.1.2.1
+++ bin/initacls.mysql 2000/08/22 10:34:48 1.2
@@ -18,7 +18,7 @@
PATH=$PATH:$BINDIR
export PATH

-echo “$BINDIR/mysql --host=${HOSTNAME} --user=${DATABASEADMIN} --password=${DBAPASSWD} mysql < $DATABASEACLS”
+echo “$BINDIR/mysql --host=${HOSTNAME} --user=${DATABASEADMIN} -p${DBAPASSWD} mysql < $DATABASEACLS”

-$BINDIR/mysql --host=${HOSTNAME} --user=${DATABASEADMIN} --password=${DBAPASSWD} mysql < $DATABASEACLS
+$BINDIR/mysql --host=${HOSTNAME} --user=${DATABASEADMIN} -p${DBAPASSWD} mysql < $DATABASEACLS
Index: bin/testdeps.pl
RCS file: /proj/maps/src/rt/bin/testdeps.pl,v
retrieving revision 1.1.2.2
retrieving revision 1.2
diff -u -r1.1.2.2 -r1.2
— bin/testdeps.pl 2000/09/09 02:01:33 1.1.2.2
+++ bin/testdeps.pl 2000/09/11 05:58:59 1.2
@@ -13,6 +13,23 @@

TODO Polish this a whole lot

+# in a MakeMaker-based install, you can do:
+# ‘PREREQ_PM’ => {
+# ‘DBI’ => 1.13,
+# ‘HTML::Mason’ => 0.87,
+# ‘Date::Manip’ => 0,
+# ‘Date::Format’ => 0,
+# ‘MIME::Entity’ => 5.108,
+# ‘Mail::Mailer’ => 1.20,
+# ‘CGI::Cookie’ => 1.06,
+# ‘Log::Dispatch’ => 1.6,
+# ‘HTML::Entities’ => 0,
+# ‘Text::Wrapper’ => 0,
+# ‘Text::Template’ => 0,
+# ‘DBIx::SearchBuilder’ => 0,
+# ‘Apache::Session’ => 1.03,
+# },

use strict;

Index: bin/webmux.pl
RCS file: /proj/maps/src/rt/bin/webmux.pl,v
retrieving revision 1.1.2.2
retrieving revision 1.4
diff -u -r1.1.2.2 -r1.4
— bin/webmux.pl 2000/09/09 02:01:33 1.1.2.2
+++ bin/webmux.pl 2000/09/11 06:29:57 1.4
@@ -61,8 +61,8 @@

my $ah = &RT::Interface::Web::NewApacheHandler($interp);

-chown ( [getpwnam(‘nobody’)]->[2], [getgrnam(‘nobody’)]->[2],

  •    $interp->files_written );   # chown nobody
    

+chown ( [getpwnam(‘!!WEB_USER!!’)]->[2], [getgrnam(‘!!WEB_GROUP!!’)]->[2],

  •    $interp->files_written );   # chown !!WEB_USER!!.!!WEB_GROUP!!
    

meow
_ivan

I’d appreciate it. The first person (other than me) to create a ticket by
mail, cli and web (without hacking code) gets to name the alpha1 release.*

Yay! I’m probably disqualified, though.

Nope. you count. I take it that means you made it happen?

You get bonus points if you do it on oracle.

No oracle for me, but on a similar topic, what’s the status of the Pg
port?

I dunno. the folks doing the original postgres port fel off the face of the earth. There are several components to this that would need doing:
1. Adding a SearchBuilder::Handle::Pg
The interesting thing here is how to deal with uniqueids for
inserts…but it shouldn’t be too hard.
2. Creating a schema
This is really just porting the existing mysql schema
3. ACLs and database creation.

Anyone wanna sign up for any of these three tasks?

Here’s some (fairly trivial) diffs:

I’ll try to integrate those into 1.3.18 (which I suspect Ivan gets to name)

    -j

I dunno. the folks doing the original postgres port fel off the face of the earth. There are several components to this that would need doing:
1. Adding a SearchBuilder::Handle::Pg
The interesting thing here is how to deal with uniqueids for
inserts…but it shouldn’t be too hard.
Ya, postgres has a different idea of OID. (I.E. when you do an insert into
table with auto-incremented column, you can get back an OID of the row
inserted, then you have to do a query (select pkey from table where
oid=youroid) to get the pkey. This allows to scale where more than one
field is autoincremented, or where autoincremented field is not pkey (or
where’s no pkey).

    2. Creating a schema
            This is really just porting the existing mysql schema

I’ll probably start with oracle schema, as mysql has way too many
non-portable idiosyncrasies.

    3. ACLs and database creation.

Anyone wanna sign up for any of these three tasks?
Tomorrow is hacking day, and I’ll try to do all that.

I managed to get RT 1.3.somewhere-in-march with postgres, shouldn’t be
that hard to do it again. That RT was badly broken so I threw it away and
never worked more on it :slight_smile:

-alex