Problem installing rt36 port on FreeBSD

I’ve spent 4 days on the web and this list’s archives researching and troubleshooting this problem, and I’ve not been able to come up with a solution.

So, I subscribed to this list, here goes!

With root privileges in /usr/ports/www/rt36 I run this command:

make WITH_APACHE2=yes INITIAL_INSTALL=yes DB_TYPE=mysql DB_HOST=localhost DB_DATABASE=rt36 DB_DBA_USER=root DB_DBA_PASSWORD=xxxx DB_USER=rt36 DB_PASSWORD=rt36 install

The installation appears to run fine, all the way up to what looks like creating my initial system user in the MySQL database.

I’m assuming that it’s trying to create a record in the Users table, but there are zero records in all tables.
The db gets created, the tables get created, but no records are created.

Here are the final few lines of output from my installation:

Congratulations. RT has been installed.

You must now configure RT by editing /usr/local/rt3/etc/RT_SiteConfig.pm.

(You will definitely need to set RT’s database password in
/usr/local/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)
Dropping mysql database rt36.
DBD::mysql::db do failed: Can’t drop database ‘rt36’; database doesn’t exist at /usr/local/rt3/sbin/rt-setup-database line 262.
Can’t drop database ‘rt36’; database doesn’t exist at /usr/local/rt3/sbin/rt-setup-database line 262.
Now creating a database for RT.
Creating mysql database rt36.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Done setting up database ACLs.
Now inserting RT core system objects
Checking for existing system user…not found. This appears to be a new installation.
Creating system user…[Fri Dec 7 14:07:49 2007] [crit]: Couldn’t add the user to his own acl equivalence group: (/usr/local/rt3/lib/RT/Group_Overlay.pm:586)
[Fri Dec 7 14:07:50 2007] [crit]: Couldn’t stash the user in groupmembers (/usr/local/rt3/lib/RT/User_Overlay.pm:497)
Could not create user
*** Error code 255 (ignored)

To complete the installation of this port, please follow these steps:

  1. Edit /usr/local/rt3/etc/RT_SiteConfig.pm, by referring to
    the default config file (/usr/local/rt3/etc/RT_Config.pm).
  2. Configure the email and web gateways. Please refer to
    ‘SETTING UP THE MAIL GATEWAY’ in /usr/local/rt3/README
  3. Restart Apache.
  4. Do remember to CHANGE the root’s password for the web interface.
    The default is “password” (without the quotes.)
  5. Configure RT per the instructions at
    Resources — Best Practical Solutions

===> Registering installation for rt-3.6.5

As you can see, it appears to be running into trouble when creating the system user in the database. Is this a correct deduction?

What can I do to fix it?

Thanks for taking the time to look this over!

Kris Jacobs
Calhoun County
Information Technology
161 East Michigan Avenue
Battle Creek, MI 49014
269.969.6813

Hi Kris,
I just completed my second install of rt-3.6.3 on ubuntu 7.1
my previous install was on open suse 10.1
While it is not an easy thing to install it can be done with care.
I initially used the book RT Essentials By Jesse Vincent … O’Reilly
to act as a guide.
The method used it this book works.
[I am not sure about BSD unix though]
I used Apache2 2.0.61
mod_perl 2.0.3
perl 5.8.8
If you are still stuck I can send you a itemized list of steps needed.
But I would suggest the book …
regards
OliverOn Fri, 7 Dec 2007, Kris Jacobs wrote:

I’ve spent 4 days on the web and this list’s archives researching and troubleshooting this problem, and I’ve not been able to come up with a solution.

So, I subscribed to this list, here goes!

With root privileges in /usr/ports/www/rt36 I run this command:

make WITH_APACHE2=yes INITIAL_INSTALL=yes DB_TYPE=mysql DB_HOST=localhost DB_DATABASE=rt36 DB_DBA_USER=root DB_DBA_PASSWORD=xxxx DB_USER=rt36 DB_PASSWORD=rt36 install

The installation appears to run fine, all the way up to what looks like creating my initial system user in the MySQL database.

I’m assuming that it’s trying to create a record in the Users table, but there are zero records in all tables.
The db gets created, the tables get created, but no records are created.

Here are the final few lines of output from my installation:


Congratulations. RT has been installed.

You must now configure RT by editing /usr/local/rt3/etc/RT_SiteConfig.pm.

(You will definitely need to set RT’s database password in
/usr/local/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)
Dropping mysql database rt36.
DBD::mysql::db do failed: Can’t drop database ‘rt36’; database doesn’t exist at /usr/local/rt3/sbin/rt-setup-database line 262.
Can’t drop database ‘rt36’; database doesn’t exist at /usr/local/rt3/sbin/rt-setup-database line 262.
Now creating a database for RT.
Creating mysql database rt36.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Done setting up database ACLs.
Now inserting RT core system objects
Checking for existing system user…not found. This appears to be a new installation.
Creating system user…[Fri Dec 7 14:07:49 2007] [crit]: Couldn’t add the user to his own acl equivalence group: (/usr/local/rt3/lib/RT/Group_Overlay.pm:586)
[Fri Dec 7 14:07:50 2007] [crit]: Couldn’t stash the user in groupmembers (/usr/local/rt3/lib/RT/User_Overlay.pm:497)
Could not create user
*** Error code 255 (ignored)

To complete the installation of this port, please follow these steps:

  1. Edit /usr/local/rt3/etc/RT_SiteConfig.pm, by referring to
    the default config file (/usr/local/rt3/etc/RT_Config.pm).
  2. Configure the email and web gateways. Please refer to
    ‘SETTING UP THE MAIL GATEWAY’ in /usr/local/rt3/README
  3. Restart Apache.
  4. Do remember to CHANGE the root’s password for the web interface.
    The default is “password” (without the quotes.)
  5. Configure RT per the instructions at
    Resources — Best Practical Solutions

=====================================================================
===> Registering installation for rt-3.6.5

As you can see, it appears to be running into trouble when creating the system user in the database. Is this a correct deduction?

What can I do to fix it?

Thanks for taking the time to look this over!

Kris Jacobs
Calhoun County
Information Technology
161 East Michigan Avenue
Battle Creek, MI 49014
269.969.6813


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Oliver Nash
Computer Systems Support Group
Department of Computer Science
University College Cork
Ireland
EMAIL:o.nash@cs.ucc.ie
PHONE:+35321 4902972

Thanks - I’ve got it going though.
I simply created a new FreeBSD VM from scratch with a minimal install, then built RT36 OK on Apache 1.3 instead of 2.2

-KrisFrom: o.nash@cs.ucc.ie [mailto:o.nash@cs.ucc.ie]
Sent: Friday, December 14, 2007 09:25
To: Kris Jacobs kjacobs@calhouncountymi.gov
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Problem installing rt36 port on FreeBSD

Hi Kris,
I just completed my second install of rt-3.6.3 on ubuntu 7.1
my previous install was on open suse 10.1
While it is not an easy thing to install it can be done with care.
I initially used the book RT Essentials By Jesse Vincent … O’Reilly
to act as a guide.
The method used it this book works.
[I am not sure about BSD unix though]
I used Apache2 2.0.61
mod_perl 2.0.3
perl 5.8.8
If you are still stuck I can send you a itemized list of steps needed.
But I would suggest the book …
regards
Oliver