[rt-users] Problem installing rt36 port on FreeBSD

[Kris Jacobs]

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
   http://www.bestpractical.com/rt/docs.html

=====================================================================
===>   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