Problems with rt3-elixus on FreeBSD 4.8-REL

I installed rt3-elixus via ports under FreeBSD 4.8-REL. Specifically, I have
rt3-elixus-8352 installed:

pkg_info | grep rt3

rt3-elixus-8352 An industrial-grade ticketing system with elixus.org
patche

The port installed fine. However, when I try to setup the rt3 databases I
get a failure:

./rt-setup-database --action init --dba root --prompt-for-dba-password

In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password: Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
DBD::mysql::st execute failed: Duplicate key name ‘ACL1’ at
./rt-setup-database line 159, <SCHEMA_LOCAL> line 14.
Problem with statement:
CREATE INDEX ACL1 on ACL(RightName, ObjectType,
ObjectId,PrincipalType,PrincipalId)
Duplicate key name ‘ACL1’ at ./rt-setup-database line 160, <SCHEMA_LOCAL>
line 14.

Has anyone successfully installed rt3-elixus on FreeBSD via ports?

Dustin Puryear

?b 五, 2003-11-07 03:22, Dustin Puryear ?g?D?G

I installed rt3-elixus via ports under FreeBSD 4.8-REL. Specifically, I have
rt3-elixus-8352 installed:
Duplicate key name ‘ACL1’ at ./rt-setup-database line 160, <SCHEMA_LOCAL>
line 14.
Has anyone successfully installed rt3-elixus on FreeBSD via ports?

Thanks for the report. This is indeed an oversight in build 8352.

Can you help me by changing www/rt3-elixus/Makefile to:
PORTVERSION= 8747

and replace www/rt3-elixus/distinfo with this line:
MD5 (rt-8747.tar.gz) = 864a6ed052ec88daa2539635c295e02d

then make install as usual? It seems to work for me here.

If it also works for you, I’ll ask the committer to update the ports.

Thanks,
/Autrijus/

signature.asc (187 Bytes)

so what’s the difference between the rt3-elixus and the regular rt version anyway?From: rt-users-bounces@lists.fsck.com
[mailto:rt-users-bounces@lists.fsck.com]On Behalf Of Autrijus Tang
Sent: Saturday, November 08, 2003 9:08 AM
To: Dustin Puryear
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Problems with rt3-elixus on FreeBSD 4.8-REL

?b 五, 2003-11-07 03:22, Dustin Puryear ?g?D?G

I installed rt3-elixus via ports under FreeBSD 4.8-REL. Specifically, I have
rt3-elixus-8352 installed:
Duplicate key name ‘ACL1’ at ./rt-setup-database line 160, <SCHEMA_LOCAL>
line 14.
Has anyone successfully installed rt3-elixus on FreeBSD via ports?

Thanks for the report. This is indeed an oversight in build 8352.

Can you help me by changing www/rt3-elixus/Makefile to:
PORTVERSION= 8747

and replace www/rt3-elixus/distinfo with this line:
MD5 (rt-8747.tar.gz) = 864a6ed052ec88daa2539635c295e02d

then make install as usual? It seems to work for me here.

If it also works for you, I’ll ask the committer to update the ports.

Thanks,
/Autrijus/

so what’s the difference between the rt3-elixus and the regular rt version anyway?

Well, pkg-descr says:

Developed by elixus.org and supported by OurInternet, Inc, rt3-elixus is
a beefed-up branch based on the latest -pre/-rc/-final release of RT3.
It features an alternate Tabbed UI, Workflow editor, many more custom field
types (including multiple-entry fields), Object Attributes, and has been
ported to Microsoft Windows.  

I think that’s about it. :slight_smile:

The TabbedUI thing (accessible as /Work/ and /Edit/, as opposed to / and /Admin/)
is our alternate UI, which is the main difference between the two branches.

Thanks,
/Autrijus/

Hmm…

Well, I have RT3 (the “normal” version) running on Windows with PostgreSQL,
Exim, and Apache, entirely under Cygwin. It installs OOTB after a few minor
tweaks (including one or two “force install” cmds to CPAN for prerequisite
packages). Oh, and I guess mod_perl/mod_fastcgi don’t work quite right, so
I had to add to use cgi-fcgi and launch Mason from inittab instead…

Is there a place where I should submit the full story?

Regards,
J[ ]