[rt-users] make initdb failure when setting up RTFM

[Marco van Beek]

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:
> 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 <http://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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com