Make initdb failure when setting up RTFM

Hi,

I have downloaded, extracted and got through most of the set up of
RTFM-2.2.0RC2

The readme has 6 steps, I completed 4 of them but number 5 says to “make
initdb”, it is at this stage I get an error and I can’t find a solution.

After typing “make initdb” I get:
/usr/bin/perl - Ilib -I/usr/share/request-tracker3.4/lib
/usr/local/share/request-tracker3.4/rt-setup-database --action schema
–datadir etc --datafile etc/initialdata --dba rtuser
Can’t open perl script “/usr/local/share/request-tracker3.4
/rt-setup-database”:
No such file or directory
…returned with error: 512
make: *** [initdb] Error 2

The RTFM link does appear in RT at this point, but I am unable to create a
class for RTFM. When attempting this I get an RTFM error which is as
follows:
TFM Error Internal Error: Couldn’t execute the query 'INSERT INTO
FM_Classes (LastUpdatedBy, SortOrder, Created, LastUpdated, Creator,
Description, Name, HotList) VALUES (?, ?, ?, ?, ?, ?, ?, ?)'ERROR: relation
“fm_classes” does not exist

I have found some similar looking problems, but these appeared to be related
to an earlier release and this doesn’t seem to be affecting me (I read about
acl.pg and removing un-necessary table names, but I only have the required
names in there).

Can anyone offer any advice on this one?

Thanks in advance
Tim

Hi Tim,

I also got this error. You should be able to run the schema manually
(and this command assumes you are using MySQL) by running

“mysql rt_db -u root -p < schema.mysql”

where rt_db is the name of your RT database.

I have a different problem. I cannot get RTFM to work at all. I am
curious to know how RT knows about RTFM, as I have no link between the
two and I think that is the source of my problem.

Regards,

Marco.

Tim Hill wrote:

And where is your rt-setup-database script that comes with RT?On 8/10/06, Tim Hill timatqems@gmail.com wrote:

Hi,

I have downloaded, extracted and got through most of the set up of RTFM-2.2.0RC2

The readme has 6 steps, I completed 4 of them but number 5 says to “make initdb”, it is at this stage I get an error and I can’t find a solution.

After typing “make initdb” I get:
/usr/bin/perl - Ilib -I/usr/share/request-tracker3.4/lib /usr/local/share/request-tracker3.4/rt-setup-database --action schema --datadir etc --datafile etc/initialdata --dba rtuser
Can’t open perl script “/usr/local/share/request-tracker3.4/rt-setup-database”:
No such file or directory
…returned with error: 512
make: *** [initdb] Error 2

The RTFM link does appear in RT at this point, but I am unable to create a class for RTFM. When attempting this I get an RTFM error which is as follows:

TFM Error
Internal Error: Couldn’t execute the query 'INSERT INTO FM_Classes (LastUpdatedBy, SortOrder, Created, LastUpdated, Creator, Description, Name, HotList) VALUES (?, ?, ?, ?, ?, ?, ?, ?)'ERROR: relation “fm_classes” does not exist

I have found some similar looking problems, but these appeared to be related to an earlier release and this doesn’t seem to be affecting me (I read about acl.pg and removing un-necessary table names, but I only have the required names in there).

Can anyone offer any advice on this one?

Thanks in advance

Tim


The rt-users Archives

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

Best regards, Ruslan.