[rt-users] Good Instruction for RT3 + Apache2 + FastCGI + MYSQL

[Rommie]

Yes, Its works..Thanks Les, Jim, Richard. But I'm not yet finished. I hope
you guys will stick with me.

I just post these messages for future reference
----------------------------
[root at server2 rt-3-0-5]# make initialize-database
/usr/bin/perl //usr/local/rt/sbin/rt-setup-database --action init --dba
postgres
Now creating a database for RT.
Creating Pg database rt3.
Now populating database schema.
Creating database schema.
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'attachments_pkey' for table 'attachments'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'queues_pkey' for table 'queues'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'links_pkey' for table 'links'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'principals_pkey' for table 'principals'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'groups_pkey' for table 'groups'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'scripconditions_pkey' for table 'scripconditions'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'transactions_pkey' for table 'transactions'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'scrips_pkey' for table 'scrips'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'acl_pkey'
for table 'acl'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'groupmembers_pkey' for table 'groupmembers'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'cachedgroupmembers_pkey' for table 'cachedgroupmembers'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'users_pkey' for table 'users'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'tickets_pkey' for table 'tickets'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'scripactions_pkey' for table 'scripactions'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'templates_pkey' for table 'templates'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'ticketcustomfieldvalues_pkey' for table 'ticketcustomfieldvalues'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'customfields_pkey' for table 'customfields'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'customfieldvalues_pkey' for table 'customfieldvalues'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'sessions_pkey' for table 'sessions'
schema sucessfully inserted
Now inserting 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...done.
Now inserting RT data
Creating Superuser  ACL...Creating groups...3.4.5.6.7.8.9.done.
Creating users...10.12.done.
Creating queues...1.2.done.
Creating ACL...2.3.done.
Creating ScripActions...1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.done.
Creating ScripConditions...1.2.3.4.5.6.7.8.9.done.
Creating templates...1.2.3.4.5.6.7.8.9.10.11.12.done.
Creating scrips...1.2.3.4.5.6.7.8.9.10.11.12.13.done.
---------------------------------------------

---rommie

>>From: "Rommie" <request_tracker at acerhomes.com>
>> Yes. Its working.
>>
>> [root at server2 rt-3-0-5]# psql -U postgres template1
>> Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
>
> In the RedHat default setup postmaster only listens on local
> unix domain sockets.  Psql uses them but perl/DBI needs
> tcp sockets even for local connections.   You need to edit
> /var/lib/pgsql/data/postgresql.conf and set
> tcpip_socket = true, then restart postgresql.  You will also
> have to set the authentication mode in
> /var/lib/pgsql/data/pg_hba.conf.   A line like:
> host  all  all   127.0.0.1  255.255.255.255   trust
> will let anything work for testing but you'll want to change
> it from trust to password as soon as you can.
>
> However, I've done all that, updated to postgresql 7.3.4 and
> got the basics working but it still takes about a minute and a
> half for the first screen to come up after importing the 13,000
> tickets from an rt2/mysql system that is fairly fast.  (And I
> did do a vacuum analyze after the import.)  I thought
> at first it was from using perl 5.6.1 on a RH7.3 system but have
> repeated the setup on RH9 with approximately the same results.
> I haven't had time to try switching to mysql yet.
>
> ---
>    Les Mikesell
>      les at futuresource.com