FW: [rt-users] Problem installing rt36 port on FreeBSD

[Kris Jacobs]

Vivek the ports maintainer suggests this might be an RT problem and not a port problem.

Any ideas?

Thanks! 


-----Original Message-----
From: Kris Jacobs 
Sent: Monday, December 10, 2007 11:37
To: Vivek Khera
Subject: RE: [rt-users] Problem installing rt36 port on FreeBSD

Example below.  At this time, I've granted ALL privs to rt_user/rt_pass on mySQL for troubleshooting purposes.

./rt-setup-database --action insert --datafile /usr/local/rt3/etc/initialdata --dba rt_user --dba-password rt_pass Creating Superuser  ACL...[Mon Dec 10 16:33:54 2007] [err]: System error. right not granted. (/usr/local/rt3/lib/RT/ACE_Overlay.pm:755)
done.
Creating groups...(Error: Could not create group)0.(Error: Could not create group)0.^C


-----Original Message-----
From: Kris Jacobs 
Sent: Monday, December 10, 2007 09:01
To: vivek at khera.org
Subject: FW: [rt-users] Problem installing rt36 port on FreeBSD

Vivek:
 
Alex on the list suggested I send this to you.

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_DBA_USER=root DB_DBA_PASSWORD=xxxx 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 rt3.
DBD::mysql::db do failed: Can't drop database 'rt3'; database doesn't exist at /usr/local/rt3/sbin/rt-setup-database line 262.
Can't drop database 'rt3'; database doesn't exist at /usr/local/rt3/sbin/rt-setup-database line 262.
Now creating a database for RT.
Creating mysql database rt3.
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...[Mon Dec 10 13:52:52 2007] [crit]: Couldn't add the user to his own acl equivalence group: (/usr/local/rt3/lib/RT/Group_Overlay.pm:586)
[Mon Dec 10 13:52:53 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