Make initialize database Problem in New Install

Greetings,

After several weeks at looking at different request tracking systems I’ve
finally decided upon RT. However, when I go to initialize the database for
the first time I get the following error:

Password: Now creating a database for RT.
Creating Pg database rt3.
Now populating database schema.
Creating database schema.
Died at //opt/rt3/sbin/rt-setup-database line 161.

The database is created but without any tables.

My environment is as follows:
OS: RedHat 9
Database: Postgres 7.3.4 from RPM (postgresql-7.3.4-3)
Perl: 5.8 from RPM (perl-5.8.0-88.3)
RT: 3.0.7_01 (Nov 17 22:56:02 2003)
rt-test-dependencies reports nothing missing

Can anyone shed some light on where I am going wrong?

Thanks in advance,

Ken McKinlay
Dy 4 Systems
ken.mckinlay@dy4.com
1-613-599-9199 x5506

McKinlay, Ken said:

After several weeks at looking at different request tracking systems I’ve
finally decided upon RT. However, when I go to initialize the database for
the first time I get the following error:

Password: Now creating a database for RT.
Creating Pg database rt3.
Now populating database schema.
Creating database schema.
Died at //opt/rt3/sbin/rt-setup-database line 161.

The database is created but without any tables.

Can anyone shed some light on where I am going wrong?

I installed RT on my system just the other day and also had this problem.
It seems that the file used for initialising a Postgres database
(schema.Pg) is actually designed to run through psql, not through
rt-setup-database. To get it up and running i had to let it create the
database, run the Pg script through psql, and then modify
rt-setup-database to skip these two stages (by commenting out the
appropriate lines).

Jody
knew (at) pimb (dot) org