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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
