RT Install-Initial database initialization question

RT Users
1

Hi All,

I have what seems to me to be a pretty straightforward question.

I’m using the instructions for an install on Red Hat Enterprise Linux 4
with RT 3.4.2 and FastCGI 2.4.2 located at

http://wiki.bestpractical.com/index.cgi?RHEL4InstallGuide

I’ve also read the original rt-users@lists.bestpractical.com threads from
when William Harrison first posted and tweaked the instructions. I’m
using:

RT v3.4.2
perl v5.8.5
Apache/2.0.52
mysql  Ver 14.7 Distrib 4.1.10a,
on RHEL 4

My problem is what seems to be a conflict between William’s instructions
and those located elsewhere. For the install of RT (after all dependencies
are installed and all other preceding steps finished), William’s
instructions (which have worked beautifully for me thus far) are:

### Assuming everything is present and it's a go, install and
###  initialize database...
	make install
	make initialize-database
### Make a copy of the dist config file to edit:
	cp /opt/rt3/etc/RT_Config.pm /opt/rt3/etc/RT_SiteConfig.pm
### edit /opt/rt3/etc/RT_SiteConfig.pm
...

However, ‘make install’ finishes by outputting the following:

     Congratulations. RT has been installed.


     You must now configure RT by editing /opt/rt3/etc/RT_SiteConfig.pm.

     (You will definitely need to set RT's database password in
     /opt/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.)

     After that, you need to initialize RT's database by running
'make initialize-database'

I’ve read the FAQs, Docs, & other installation Guides located on the wiki.
I’ve searched wiki.bestpractical.com for “make initialize-database”,
“RT_Config.pm”, and “RT_SiteConfig.pm”; and I’ve searched
lists.bestpractical.com for “make initialize-database”. Thus far, while
I’m pretty confident of how to proceed, I still want to double check.

It seems that, contrary to William’s instructions, I shouldn’t ‘make
initialize-database’ until I’ve configured RT_SiteConfig.pm (presumably
after replacing it with a copy of RT_Config.pm, seeing as RT_SiteConfig.pm
seems to have only a single line of configuration).

However, William’s instructions have worked so flawlessly thus far, that I
want to make sure that there isn’t anything I’m missing here.

So, a relatively simple problem with a very long write-up. Any
suggestions? Thanks,

-Chris Allison
Brandeis University CS Dept.
Systems Operations Guru
chris@cs.brandeis.edu
http://www.cs.brandeis.edu/~guru/

2

Doesn’t really matter. Initialize the db first, or edit eh config files first… they both have to be done and the order simply doesn’t matter.-----Original Message-----
From: Christopher Allison [mailto:chris@cs.brandeis.edu]
Sent: Sunday, July 03, 2005 3:07 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT Install-Initial database initialization question

Hi All,

I have what seems to me to be a pretty straightforward question.

I’m using the instructions for an install on Red Hat Enterprise Linux 4
with RT 3.4.2 and FastCGI 2.4.2 located at

http://wiki.bestpractical.com/index.cgi?RHEL4InstallGuide

I’ve also read the original rt-users@lists.bestpractical.com threads from
when William Harrison first posted and tweaked the instructions. I’m
using:

RT v3.4.2
perl v5.8.5
Apache/2.0.52
mysql  Ver 14.7 Distrib 4.1.10a,
on RHEL 4

My problem is what seems to be a conflict between William’s instructions
and those located elsewhere. For the install of RT (after all dependencies
are installed and all other preceding steps finished), William’s
instructions (which have worked beautifully for me thus far) are:

### Assuming everything is present and it's a go, install and
###  initialize database...
	make install
	make initialize-database
### Make a copy of the dist config file to edit:
	cp /opt/rt3/etc/RT_Config.pm /opt/rt3/etc/RT_SiteConfig.pm
### edit /opt/rt3/etc/RT_SiteConfig.pm
...

However, ‘make install’ finishes by outputting the following:

     Congratulations. RT has been installed.


     You must now configure RT by editing /opt/rt3/etc/RT_SiteConfig.pm.

     (You will definitely need to set RT's database password in
     /opt/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.)

     After that, you need to initialize RT's database by running
'make initialize-database'

I’ve read the FAQs, Docs, & other installation Guides located on the wiki.
I’ve searched wiki.bestpractical.com for “make initialize-database”,
“RT_Config.pm”, and “RT_SiteConfig.pm”; and I’ve searched
lists.bestpractical.com for “make initialize-database”. Thus far, while
I’m pretty confident of how to proceed, I still want to double check.

It seems that, contrary to William’s instructions, I shouldn’t ‘make
initialize-database’ until I’ve configured RT_SiteConfig.pm (presumably
after replacing it with a copy of RT_Config.pm, seeing as RT_SiteConfig.pm
seems to have only a single line of configuration).

However, William’s instructions have worked so flawlessly thus far, that I
want to make sure that there isn’t anything I’m missing here.

So, a relatively simple problem with a very long write-up. Any
suggestions? Thanks,

-Chris Allison
Brandeis University CS Dept.
Systems Operations Guru
chris@cs.brandeis.edu
http://www.cs.brandeis.edu/~guru/
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

3

Doesn’t really matter. Initialize the db first, or edit eh config files first… they both have to be done and the order simply doesn’t matter.

hi
actually it does matter - do the config-file first then do the
database-initialisation otherwise the “make initdb” won’t have enough
information in order to create the database, tables, users,… right.

hth
Harald Kapper, icq# 36178328 http://kapper.net
managing director, owner, loeblichgasse 6
chief executive officer 1090 vienna, .at
tel +43 1 3195500-0, fax +43 1 3195502, hk@kapper.net
--------------mark---------------
The following Statement is False.
The previous Statement is True.
- Welcome to my World -

4

Hmmm… I seem to recall it prompted me for them, but then again, I would need a new install to verify if that was the case.

Oh well. Either way, you are well on your way to a functioning RT installation…

-WcH-----Original Message-----
From: Harald Kapper [mailto:hk@kapper.net]
Sent: Tuesday, July 05, 2005 4:55 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Install-Initial database initialization
question

actually it does matter - do the config-file first then do the
database-initialisation otherwise the “make initdb” won’t have enough
information in order to create the database, tables, users,… right.

5

Hi all,
I am trying to use the RTcontributions i.e. “LDAP Overlay” . Could someone
tell me as to what it actually does since my requirements is to use the
User Login and Password from the Active directory database rather than
from the “Users” table. Does this overlay do that. Also, could someone
explain the following piece of code which needs to go into
RT_SiteConfig.pm?

$LDAPExternalAuth = 1;

$LdapServer=“127.0.0.1”;

$LdapUser=“”;

$LdapPass=“”;

$LdapBase=“ou=Users,dc=example,dc=com”;

$LdapUidAttr=“uid”;

$LdapFilter=“(objectclass=*)”;

$LdapTLS = 1;

$LdapGroup =“cn=RT,ou=Group,dc=example,dc=com”;

$LdapGroupAttribute = ‘uniqueMember’;

$LdapSSLVersion = 3;

Regards,
Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District
(402) 449-8218 phone
(402) 449-8131 fax
ahalya_nathan@mudnebr.com