Rt209 /opt/rt2/etc/insertdata failure connecting to database

Hi,

This is sort of a follow-up to:
http://lists.fsck.com/pipermail/rt-users/2001-December/005837.html

make install got further and then ran into trouble at
/opt/rt2/etc/insertdata line 26. Again, the error was a failure to connect
to the database, although this time it was in perl code. Again, the error
message was consistent with an attempt to connect via tcp/ip as far as I can
tell. I definitely have the database configured for socket access only.

Here are the last 5 lines of output from make install:
DBI->connect(dbname=rt2;host=localhost) failed: connectDBStart() –
connect() failed: Connection refused at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 121
Connect Failed connectDBStart() – connect() failed: Connection refused
at /opt/rt2/etc/insertdata line 26
make: *** [insert] Error 255

Just for kicks, I tried modifying the Makefile lines as follows:
#DB_HOST = localhost
#DB_RT_HOST = localhost
DB_HOST =
DB_RT_HOST =

This make install succeeded. So the question is, should both of those
values be blank for socket-only access to the Postgres database? I
understood the Makefile hints to suggest “localhost” for both of these
parameters, but now I am wondering whether I misunderstood.

thanks,
Olaf

last few hundred lines of output from ‘make install’ below. For my full
Makefile, see the link to the earlier post.

NOTICE: CREATE TABLE will create implicit sequence ‘transactions_id_seq’
for SERIAL column ‘transactions.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
’transactions_pkey’ for table ‘transactions’
CREATE INDEX Transactions1 ON Transactions (Ticket)
CREATE INDEX Transactions2 ON Transactions (EffectiveTicket)
CREATE TABLE Scrips (
id serial NOT NULL ,
ScripCondition integer ,
ScripAction integer ,
Stage varchar(32) ,
Queue integer ,
Template integer ,
Creator integer ,
Created timestamp ,
LastUpdatedBy integer ,
LastUpdated timestamp ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘scrips_id_seq’ for
SERIAL column ‘scrips.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index ‘scrips_pkey’
for table ‘scrips’
CREATE TABLE ACL (
id serial NOT NULL ,
PrincipalId integer ,
PrincipalType varchar(25) ,
RightName varchar(25) ,
RightScope varchar(25) ,
RightAppliesTo integer ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘acl_id_seq’ for SERIAL
column ‘acl.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index ‘acl_pkey’ for
table ‘acl’
CREATE INDEX ACL1 ON ACL (RightScope, PrincipalId)
CREATE INDEX ACL2 ON ACL (RightScope, RightAppliesTo, RightName,
PrincipalType, PrincipalId)
CREATE TABLE GroupMembers (
id serial NOT NULL ,
GroupId integer ,
UserId integer ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘groupmembers_id_seq’
for SERIAL column ‘groupmembers.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
’groupmembers_pkey’ for table ‘groupmembers’
CREATE UNIQUE INDEX GroupMembers1 ON GroupMembers (GroupId, UserId)
CREATE TABLE ObjectKeywords (
id serial NOT NULL ,
Keyword integer NOT NULL ,
KeywordSelect integer NOT NULL ,
ObjectType varchar(32) NOT NULL ,
ObjectId integer NOT NULL ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘objectkeywords_id_seq’
for SERIAL column ‘objectkeywords.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
’objectkeywords_pkey’ for table ‘objectkeywords’
CREATE UNIQUE INDEX ObjectKeywords1 ON ObjectKeywords (ObjectId, ObjectType,
KeywordSelect, Keyword)
CREATE INDEX ObjectKeywords2 ON ObjectKeywords (ObjectId, ObjectType)
CREATE INDEX ObjectKeywords3 ON ObjectKeywords (Keyword)
CREATE TABLE Keywords (
id serial NOT NULL ,
Name varchar(255) NOT NULL ,
Description varchar(255) ,
Parent integer ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘keywords_id_seq’ for
SERIAL column ‘keywords.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index ‘keywords_pkey’
for table ‘keywords’
CREATE UNIQUE INDEX Keywords1 ON Keywords (Name, Parent)
CREATE INDEX Keywords2 ON Keywords (Name)
CREATE INDEX Keywords3 ON Keywords (Parent)
CREATE TABLE Users (
id serial NOT NULL ,
Name varchar(120) NOT NULL ,
Password varchar(40) ,
Comments TEXT ,
Signature TEXT ,
EmailAddress varchar(120) ,
FreeformContactInfo TEXT ,
Organization varchar(200) ,
Privileged integer ,
RealName varchar(120) ,
Nickname varchar(16) ,
Lang varchar(16) ,
EmailEncoding varchar(16) ,
WebEncoding varchar(16) ,
ExternalContactInfoId varchar(100) ,
ContactInfoSystem varchar(30) ,
ExternalAuthId varchar(100) ,
AuthSystem varchar(30) ,
Gecos varchar(16) ,
HomePhone varchar(30) ,
WorkPhone varchar(30) ,
MobilePhone varchar(30) ,
PagerPhone varchar(30) ,
Address1 varchar(200) ,
Address2 varchar(200) ,
City varchar(100) ,
State varchar(100) ,
Zip varchar(16) ,
Country varchar(50) ,
Creator integer ,
Created timestamp ,
LastUpdatedBy integer ,
LastUpdated timestamp ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘users_id_seq’ for
SERIAL column ‘users.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index ‘users_pkey’
for table ‘users’
CREATE UNIQUE INDEX Users1 ON Users (Name)
CREATE INDEX Users2 ON Users (Name)
CREATE INDEX Users3 ON Users (id, EmailAddress)
CREATE INDEX Users4 ON Users (EmailAddress)
CREATE TABLE Tickets (
id serial NOT NULL ,
EffectiveId integer ,
Queue integer ,
Type varchar(16) ,
IssueStatement integer ,
Resolution integer ,
Owner integer ,
Subject varchar(200) DEFAULT ‘[no subject]’ ,
InitialPriority integer ,
FinalPriority integer ,
Priority integer ,
Status varchar(10) ,
TimeWorked integer ,
TimeLeft integer ,
Told timestamp ,
Starts timestamp ,
Started timestamp ,
Due timestamp ,
Resolved timestamp ,
LastUpdatedBy integer ,
LastUpdated timestamp ,
Creator integer ,
Created timestamp ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘tickets_id_seq’ for
SERIAL column ‘tickets.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index ‘tickets_pkey’
for table ‘tickets’
CREATE INDEX Tickets1 ON Tickets (Queue, Status)
CREATE INDEX Tickets2 ON Tickets (Owner)
CREATE INDEX Tickets3 ON Tickets (EffectiveId)
CREATE INDEX Tickets4 ON Tickets (id, Status)
CREATE INDEX Tickets5 ON Tickets (id, EffectiveId)
CREATE TABLE ScripActions (
id serial NOT NULL ,
Name varchar(255) ,
Description varchar(255) ,
ExecModule varchar(60) ,
Argument varchar(255) ,
Creator integer ,
Created timestamp ,
LastUpdatedBy integer ,
LastUpdated timestamp ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘scripactions_id_seq’
for SERIAL column ‘scripactions.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
’scripactions_pkey’ for table ‘scripactions’
CREATE TABLE Templates (
id serial NOT NULL ,
Queue integer NOT NULL DEFAULT 0 ,
Name varchar(40) NOT NULL ,
Description varchar(120) ,
Type varchar(16) ,
Language varchar(16) ,
TranslationOf integer ,
Content TEXT ,
LastUpdated timestamp ,
LastUpdatedBy integer ,
Creator integer ,
Created timestamp ,
PRIMARY KEY (id)
)
NOTICE: CREATE TABLE will create implicit sequence ‘templates_id_seq’ for
SERIAL column ‘templates.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
’templates_pkey’ for table ‘templates’
schema sucessfully inserted
cp etc/acl.Pg ‘//opt/rt2/etc/acl.Pg’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!’“Pg”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_RT_PASS!!’“rt_pass”‘g;
s’!!DB_RT_HOST!!’“localhost”‘g;
s’!!DB_RT_USER!!’“rt_user”‘g;
s’!!DB_DATABASE!!’“rt2”‘g;"
file://opt/rt2/etc/acl.Pg
bin/initacls.Pg ‘/usr’ ‘localhost’ ‘’ ‘postgres’ ‘hithere’ ‘rt2’
’//opt/rt2/etc/acl.Pg’
Enter the postgres administrator’s database password to create a new user
for rt
psql -d rt2 -f file://opt/rt2/etc/acl.Pg -U postgres
DROP USER
CREATE USER
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
CHANGE
[ -f file://opt/rt2/etc/config.pm ] &&
mv file://opt/rt2/etc/config.pm file://opt/rt2/etc/config.pm.old &&

chmod 000 file://opt/rt2/etc/config.pm.old
cp -rp ./etc/config.pm file://opt/rt2/etc/config.pm
/usr/bin/perl -p -i -e "
s’!!DB_TYPE!!’“Pg”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_PORT!!’""‘g;
s’!!DB_RT_PASS!!’“rt_pass”‘g;
s’!!DB_RT_USER!!’“rt_user”‘g;
s’!!DB_DATABASE!!’“rt2”‘g;
s’!!MASON_HTML_PATH!!’"/opt/rt2/WebRT/html"‘g;
s’!!MASON_LOCAL_HTML_PATH!!’"/opt/rt2/local/WebRT/html"‘g;
s’!!MASON_SESSION_PATH!!’"/opt/rt2/WebRT/sessiondata"‘g;
s’!!MASON_DATA_PATH!!’"/opt/rt2/WebRT/data"‘g;
s’!!RT_LOG_PATH!!’"/tmp"‘g;
s’!!RT_VERSION!!’“2.0.9”‘g;
" file://opt/rt2/etc/config.pm
[ -d file://opt/rt2/lib ] || mkdir file://opt/rt2/lib
chown -R root file://opt/rt2/lib
chgrp -R bin file://opt/rt2/lib
chmod -R 0755 file://opt/rt2/lib
( cd ./lib;
/usr/bin/perl Makefile.PL INSTALLSITELIB=//opt/rt2/lib
INSTALLMAN1DIR=//opt/rt2/man/man1
INSTALLMAN3DIR=//opt/rt2/man/man3
&& make
&& make test
&& /usr/bin/perl -p -i -e " s’!!RT_VERSION!!‘2.0.9’g;" blib/lib/RT.pm ;
make install
INSTALLSITEMAN1DIR=//opt/rt2/man/man1
INSTALLSITEMAN3DIR=//opt/rt2/man/man3
)
Writing Makefile for RT
make[1]: Entering directory /home/olaf/rt/rt-2-0-9/lib' Manifying blib/man3/RT::Links.3pm Manifying blib/man3/RT::Watchers.3pm Manifying blib/man3/RT::Group.3pm Manifying blib/man3/RT::Keyword.3pm Manifying blib/man3/RT::Record.3pm Manifying blib/man3/RT::ScripConditions.3pm Manifying blib/man3/RT::Action::Generic.3pm Manifying blib/man3/RT::Transaction.3pm Manifying blib/man3/RT::Interface::Email.3pm Manifying blib/man3/RT::Link.3pm Manifying blib/man3/RT.3pm Manifying blib/man3/RT::Watcher.3pm Manifying blib/man3/RT::ObjectKeywords.3pm Manifying blib/man3/RT::EasySearch.3pm Manifying blib/man3/RT::ScripActions.3pm Manifying blib/man3/RT::Scrip.3pm Manifying blib/man3/RT::GroupMembers.3pm Manifying blib/man3/RT::Action::SendPasswordEmail.3pm Manifying blib/man3/RT::Transactions.3pm Manifying blib/man3/RT::Scrips.3pm Manifying blib/man3/RT::Action::SendEmail.3pm Manifying blib/man3/RT::User.3pm Manifying blib/man3/RT::ScripCondition.3pm Manifying blib/man3/RT::Users.3pm Manifying blib/man3/RT::Ticket.3pm Manifying blib/man3/RT::ACE.3pm Manifying blib/man3/RT::Queue.3pm Manifying blib/man3/RT::Interface::CLI.3pm Manifying blib/man3/RT::Tickets.3pm Manifying blib/man3/RT::GroupMember.3pm Manifying blib/man3/RT::Template.3pm Manifying blib/man3/RT::Templates.3pm Manifying blib/man3/RT::Queues.3pm Manifying blib/man3/RT::Date.3pm Manifying blib/man3/RT::CurrentUser.3pm Manifying blib/man3/RT::ScripAction.3pm Manifying blib/man3/RT::Keywords.3pm Manifying blib/man3/RT::ObjectKeyword.3pm Manifying blib/man3/RT::Attachment.3pm Manifying blib/man3/RT::Groups.3pm Manifying blib/man3/RT::KeywordSelect.3pm Manifying blib/man3/RT::Condition::Generic.3pm Manifying blib/man3/RT::Handle.3pm Manifying blib/man3/RT::ACL.3pm Manifying blib/man3/RT::Attachments.3pm make[1]: Leaving directory/home/olaf/rt/rt-2-0-9/lib’
make[1]: Entering directory /home/olaf/rt/rt-2-0-9/lib' PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/us r/lib/perl5/5.6.0 test.pl 1..1 ok 1 make[1]: Leaving directory/home/olaf/rt/rt-2-0-9/lib’
make[1]: Entering directory /home/olaf/rt/rt-2-0-9/lib' Manifying blib/man3/RT::Links.3pm Skipping file://opt/rt2/lib/RT.pm (unchanged) Skipping file://opt/rt2/lib/RT/KeywordSelects.pm (unchanged) Skipping file://opt/rt2/lib/RT/Links.pm (unchanged) Skipping file://opt/rt2/lib/RT/Watchers.pm (unchanged) Skipping file://opt/rt2/lib/RT/Group.pm (unchanged) Skipping file://opt/rt2/lib/RT/Keyword.pm (unchanged) Skipping file://opt/rt2/lib/RT/Record.pm (unchanged) Skipping file://opt/rt2/lib/RT/ScripConditions.pm (unchanged) Skipping file://opt/rt2/lib/RT/Transaction.pm (unchanged) Skipping file://opt/rt2/lib/RT/TestHarness.pm (unchanged) Skipping file://opt/rt2/lib/RT/Link.pm (unchanged) Skipping file://opt/rt2/lib/RT/Watcher.pm (unchanged) Skipping file://opt/rt2/lib/RT/ObjectKeywords.pm (unchanged) Skipping file://opt/rt2/lib/RT/EasySearch.pm (unchanged) Skipping file://opt/rt2/lib/RT/ScripActions.pm (unchanged) Skipping file://opt/rt2/lib/RT/Scrip.pm (unchanged) Skipping file://opt/rt2/lib/RT/GroupMembers.pm (unchanged) Skipping file://opt/rt2/lib/RT/Transactions.pm (unchanged) Skipping file://opt/rt2/lib/RT/Scrips.pm (unchanged) Skipping file://opt/rt2/lib/RT/User.pm (unchanged) Skipping file://opt/rt2/lib/RT/ScripCondition.pm (unchanged) Skipping file://opt/rt2/lib/RT/Users.pm (unchanged) Skipping file://opt/rt2/lib/RT/Ticket.pm (unchanged) Skipping file://opt/rt2/lib/RT/ACE.pm (unchanged) Skipping file://opt/rt2/lib/RT/Queue.pm (unchanged) Skipping file://opt/rt2/lib/RT/Tickets.pm (unchanged) Skipping file://opt/rt2/lib/RT/Template.pm (unchanged) Skipping file://opt/rt2/lib/RT/GroupMember.pm (unchanged) Skipping file://opt/rt2/lib/RT/Templates.pm (unchanged) Skipping file://opt/rt2/lib/RT/Queues.pm (unchanged) Skipping file://opt/rt2/lib/RT/Date.pm (unchanged) Skipping file://opt/rt2/lib/RT/CurrentUser.pm (unchanged) Skipping file://opt/rt2/lib/RT/ScripAction.pm (unchanged) Skipping file://opt/rt2/lib/RT/Keywords.pm (unchanged) Skipping file://opt/rt2/lib/RT/ObjectKeyword.pm (unchanged) Skipping file://opt/rt2/lib/RT/Attachment.pm (unchanged) Skipping file://opt/rt2/lib/RT/Groups.pm (unchanged) Skipping file://opt/rt2/lib/RT/KeywordSelect.pm (unchanged) Skipping file://opt/rt2/lib/RT/Handle.pm (unchanged) Skipping file://opt/rt2/lib/RT/ACL.pm (unchanged) Skipping file://opt/rt2/lib/RT/Attachments.pm (unchanged) Skipping file://opt/rt2/lib/RT/Interface/Email.pm (unchanged) Skipping file://opt/rt2/lib/RT/Interface/CLI.pm (unchanged) Skipping file://opt/rt2/lib/RT/Interface/Web.pm (unchanged) Skipping file://opt/rt2/lib/RT/Condition/NewDependency.pm (unchanged) Skipping file://opt/rt2/lib/RT/Condition/StatusChange.pm (unchanged) Skipping file://opt/rt2/lib/RT/Condition/AnyTransaction.pm (unchanged) Skipping file://opt/rt2/lib/RT/Condition/Generic.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/Generic.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/OpenDependent.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/StallDependent.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/SendPasswordEmail.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/Notify.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/SendEmail.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/README.hackers (unchanged) Skipping file://opt/rt2/lib/RT/Action/ResolveMembers.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/NotifyAsComment.pm (unchanged) Skipping file://opt/rt2/lib/RT/Action/Autoreply.pm (unchanged) Installing file://opt/rt2/man/man3/RT::Links.3pm Installing file://opt/rt2/man/man3/RT::Watchers.3pm Installing file://opt/rt2/man/man3/RT::Group.3pm Installing file://opt/rt2/man/man3/RT::Keyword.3pm Installing file://opt/rt2/man/man3/RT::Record.3pm Installing file://opt/rt2/man/man3/RT::ScripConditions.3pm Installing file://opt/rt2/man/man3/RT::Action::Generic.3pm Installing file://opt/rt2/man/man3/RT::Transaction.3pm Installing file://opt/rt2/man/man3/RT::Interface::Email.3pm Installing file://opt/rt2/man/man3/RT::Link.3pm Installing file://opt/rt2/man/man3/RT.3pm Installing file://opt/rt2/man/man3/RT::Watcher.3pm Installing file://opt/rt2/man/man3/RT::ObjectKeywords.3pm Installing file://opt/rt2/man/man3/RT::EasySearch.3pm Installing file://opt/rt2/man/man3/RT::ScripActions.3pm Installing file://opt/rt2/man/man3/RT::Scrip.3pm Installing file://opt/rt2/man/man3/RT::GroupMembers.3pm Installing file://opt/rt2/man/man3/RT::Action::SendPasswordEmail.3pm Installing file://opt/rt2/man/man3/RT::Transactions.3pm Installing file://opt/rt2/man/man3/RT::Scrips.3pm Installing file://opt/rt2/man/man3/RT::Action::SendEmail.3pm Installing file://opt/rt2/man/man3/RT::User.3pm Installing file://opt/rt2/man/man3/RT::ScripCondition.3pm Installing file://opt/rt2/man/man3/RT::Users.3pm Installing file://opt/rt2/man/man3/RT::Ticket.3pm Installing file://opt/rt2/man/man3/RT::ACE.3pm Installing file://opt/rt2/man/man3/RT::Queue.3pm Installing file://opt/rt2/man/man3/RT::Interface::CLI.3pm Installing file://opt/rt2/man/man3/RT::Tickets.3pm Installing file://opt/rt2/man/man3/RT::GroupMember.3pm Installing file://opt/rt2/man/man3/RT::Template.3pm Installing file://opt/rt2/man/man3/RT::Templates.3pm Installing file://opt/rt2/man/man3/RT::Queues.3pm Installing file://opt/rt2/man/man3/RT::Date.3pm Installing file://opt/rt2/man/man3/RT::CurrentUser.3pm Installing file://opt/rt2/man/man3/RT::ScripAction.3pm Installing file://opt/rt2/man/man3/RT::Keywords.3pm Installing file://opt/rt2/man/man3/RT::ObjectKeyword.3pm Installing file://opt/rt2/man/man3/RT::Attachment.3pm Installing file://opt/rt2/man/man3/RT::Groups.3pm Installing file://opt/rt2/man/man3/RT::KeywordSelect.3pm Installing file://opt/rt2/man/man3/RT::Condition::Generic.3pm Installing file://opt/rt2/man/man3/RT::Handle.3pm Installing file://opt/rt2/man/man3/RT::ACL.3pm Installing file://opt/rt2/man/man3/RT::Attachments.3pm Writing file://opt/rt2/lib/auto/RT/.packlist Appending installation info to /usr/lib/perl5/5.6.0/i386-linux/perllocal.pod make[1]: Leaving directory/home/olaf/rt/rt-2-0-9/lib’
cp -rp ./webrt/* file://opt/rt2/WebRT/html
cp -p ./bin/webmux.pl file://opt/rt2/bin/webmux.pl
cp -p ./bin/rt-mailgate file://opt/rt2/bin/rt-mailgate
cp -p ./bin/rtadmin file://opt/rt2/bin/rtadmin
cp -p ./bin/rt file://opt/rt2/bin/rt
cp -p ./bin/mason_handler.fcgi file://opt/rt2/bin/mason_handler.fcgi
cp -p ./bin/mason_handler.scgi file://opt/rt2/bin/mason_handler.scgi
/usr/bin/perl -p -i -e "s’!!RT_PATH!!’"/opt/rt2"‘g;
s’!!PERL!!’"/usr/bin/perl"‘g;
s’!!RT_VERSION!!’“2.0.9”‘g;
s’!!RT_ETC_PATH!!’"/opt/rt2/etc"‘g;
s’!!RT_LIB_PATH!!’"/opt/rt2/lib"'g;"
file://opt/rt2/bin/webmux.pl
file://opt/rt2/bin/mason_handler.fcgi
file://opt/rt2/bin/mason_handler.scgi
file://opt/rt2/bin/rt
file://opt/rt2/bin/rtadmin
file://opt/rt2/bin/rt-mailgate

Make the libraries readable

chmod -R 0755 file://opt/rt2
chown -R root file://opt/rt2/lib
chgrp -R bin file://opt/rt2/lib
chown -R root file://opt/rt2/bin
chgrp -R rt file://opt/rt2/bin
chmod 0755 file://opt/rt2/bin
chmod 0755 file://opt/rt2/bin
chmod 0755 file://opt/rt2/etc
chmod 0500 file://opt/rt2/etc/*
#TODO: the config file should probably be able to have its

owner set seperately from the binaries.

chown -R root file://opt/rt2/etc
chgrp -R rt file://opt/rt2/etc
chmod 0550 file://opt/rt2/etc/config.pm

Make the interfaces executable and setgid rt

chown root file://opt/rt2/bin/rt-mailgate
file://opt/rt2/bin/mason_handler.fcgi
file://opt/rt2/bin/mason_handler.scgi
file://opt/rt2/bin/rt
file://opt/rt2/bin/rtadmin
chgrp rt file://opt/rt2/bin/rt-mailgate
file://opt/rt2/bin/mason_handler.fcgi
file://opt/rt2/bin/mason_handler.scgi
file://opt/rt2/bin/rt
file://opt/rt2/bin/rtadmin
chmod 0755 file://opt/rt2/bin/rt-mailgate
file://opt/rt2/bin/mason_handler.fcgi
file://opt/rt2/bin/mason_handler.scgi
file://opt/rt2/bin/rt
file://opt/rt2/bin/rtadmin
chmod g+s file://opt/rt2/bin/rt-mailgate
file://opt/rt2/bin/mason_handler.fcgi
file://opt/rt2/bin/mason_handler.scgi
file://opt/rt2/bin/rt
file://opt/rt2/bin/rtadmin

Make the web ui readable by all.

chmod -R u+rwX,go-w,go+rX file://opt/rt2/WebRT/html
file://opt/rt2/local/WebRT/html
chown -R root file://opt/rt2/WebRT/html
file://opt/rt2/local/WebRT/html
chgrp -R bin file://opt/rt2/WebRT/html
file://opt/rt2/local/WebRT/html

Make the web ui’s data dir writable

chmod 0770 file://opt/rt2/WebRT/data
file://opt/rt2/WebRT/sessiondata
chown -R nobody file://opt/rt2/WebRT/data
file://opt/rt2/WebRT/sessiondata
chgrp -R rt file://opt/rt2/WebRT/data
file://opt/rt2/WebRT/sessiondata
cp -rp ./tools/insertdata
file://opt/rt2/etc
/usr/bin/perl -p -i -e " s’!!RT_ETC_PATH!!’/opt/rt2/etc’g;
s’!!RT_LIB_PATH!!’/opt/rt2/lib’g;"
file://opt/rt2/etc/insertdata
/usr/bin/perl /opt/rt2/etc/insertdata
DBI->connect(dbname=rt2;host=localhost) failed: connectDBStart() –
connect() failed: Connection refused at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 121
Connect Failed connectDBStart() – connect() failed: Connection refused
at /opt/rt2/etc/insertdata line 26
make: *** [insert] Error 255