FW: Problem installing rt36 port on FreeBSD

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@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.
  3. 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

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
OliverOn 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@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.
  3. 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@bestpractical.com or call us at +1 617 812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@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@cs.ucc.ie
PHONE:+35321 4902972