[rt-users] Problem installing rt36 port on FreeBSD

[o.nash at cs.ucc.ie]

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


On 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
>   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 sales at bestpractical.com or call us at +1 617 812 0745.
>
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at 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 at cs.ucc.ie
PHONE:+35321 4902972