ERROR: relation "fm_classcustomfields_id_seq" does not exist

Hi,

I am trying to install RTFM 2.2.0RC1 with RT 3.4.4 on FreeBSD 6.0 with
Postgresql 8.1.

This is the error that I get:

[root@ded002 RTFM-2.2.0RC1]# make initdb
/usr/bin/perl -Ilib -I/usr/local/rt3/lib
/usr/local/rt3/sbin/rt-setup-database --action schema --datadir etc
–datafile etc/initialdata --dba rt_user --prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your Pg instance on localhost as rt_user.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Creating database schema.
Done setting up database schema.
/usr/bin/perl -Ilib -I/usr/local/rt3/lib
/usr/local/rt3/sbin/rt-setup-database --action acl --datadir etc
–datafile etc/initialdata --dba rt_user --prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your Pg instance on localhost as rt_user.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
DBD::Pg::st execute failed: ERROR: relation
"fm_classcustomfields_id_seq" does not exist
Problem with statement:
GRANT SELECT, INSERT, UPDATE, DELETE ON FM_ClassCustomFields_id_seq to
rt_user;
ERROR: relation “fm_classcustomfields_id_seq” does not exist
…returned with error: 65280
*** Error code 255

Stop in /root/RTFM-2.2.0RC1.

Any ideas on how to get past this point?

Thanks,

Tracy

Hi,

I am trying to install RTFM 2.2.0RC1 with RT 3.4.4 on FreeBSD 6.0 with
Postgresql 8.1.

This is the error that I get:

Looks like the Pg ACL file is a bit out of date. from acl.pg, remove all
table names except:

FM_Classes_id_seq
FM_Classes
FM_Articles_id_seq
FM_Articles
FM_Topics_id_seq
FM_Topics
FM_ObjectTopics_id_seq
FM_ObjectTopics

Jesse Vincent wrote:

Looks like the Pg ACL file is a bit out of date. from acl.pg, remove all
table names except:

FM_Classes_id_seq
FM_Classes
FM_Articles_id_seq
FM_Articles
FM_Topics_id_seq
FM_Topics
FM_ObjectTopics_id_seq
FM_ObjectTopics

Thanks Jesse that did the trick.

Just in case anyone else has this issue the file is in the RTFM download
as /etc/acl.Pg

Tracy Phillips

Tracy Phillips wrote:

Jesse Vincent wrote:

Looks like the Pg ACL file is a bit out of date. from acl.pg, remove all
table names except:

FM_Classes_id_seq
FM_Classes
FM_Articles_id_seq
FM_Articles
FM_Topics_id_seq
FM_Topics
FM_ObjectTopics_id_seq
FM_ObjectTopics

Thanks Jesse that did the trick.

Just in case anyone else has this issue the file is in the RTFM download
as /etc/acl.Pg

Thanks. This fix will be in the next release.

Jesse

signature.asc (189 Bytes)