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

[o.nash at cs.ucc.ie]

Hello Kris,
I had a problem with configure of rt-3.6.3
had redo configure without option --with-db-rt-pass

./configure --with-apachectl=/usr/local/apache2/bin --with-web-user=wwwrun --with-web-group=www

Then setup the db user and password manually later on.
regards
Oliver


On Mon, 10 Dec 2007, Kris Jacobs wrote:

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