Installation of RTFM 2.2.1 and RT 3.8.0 on Debian Etch fails however 3.6.7 works fine?

RT Users
1

I’m trying to do a fresh install of RT 3.8.0 on Debian Etch machine. I can
install RT 3.6.7 and RTFM 2.2.1 with no problems on the same machine I
remove RT 3.6.7. Then when trying to install (not upgrade) RT 3.8.0 I get
some errors at the install step. See output below

liberty1:/tmp/rt-3.8.0# make install
/usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql
–with-modperl2perl:
>=5.8.3(5.8.8)…found
users:
rt group (www-data)…found
bin owner (root)…found
libs owner (root)…found
libs group (bin)…found
web owner (www-data)…found
web group (www-data)…found
CLI dependencies:
Term::ReadKey…found
Getopt::Long >= 2.24…found
HTTP::Request::Common…found
Term::ReadLine…found
Text::ParseWords…found
LWP…found
CORE dependencies:
Class::ReturnValue >= 0.40…found
Text::Quoted >= 2.02…found
CSS::Squish >= 0.06…found
Encode >= 2.13…found
Module::Versions::Report >= 1.05…found
MIME::Entity >= 5.425…found
DBI >= 1.37…found
Locale::Maketext::Lexicon >= 0.32…found
Devel::StackTrace >= 1.19…found
Digest::base…found
Time::ParseDate…found
File::Temp >= 0.18…found
Locale::Maketext >= 1.06…found
Tree::Simple >= 1.04…found
Text::Template…found
Scalar::Util…found
HTML::Scrubber >= 0.08…found
File::Spec >= 0.8…found
Calendar::Simple…found
DBIx::SearchBuilder >= 1.53…found
Mail::Mailer >= 1.57…found
File::ShareDir…found
Regexp::Common…found
Digest::MD5 >= 2.27…found
HTML::Entities…found
Cache::Simple::TimedExpiry…found
File::Glob…found
Locale::Maketext::Fuzzy…found
Time::HiRes…found
Text::Wrapper…found
Log::Dispatch >= 2.0…found
UNIVERSAL::require…found
Email::Address…found
DASHBOARDS dependencies:
HTML::RewriteAttributes >= 0.02…found
MIME::Types…found
GD dependencies:
GD::Text…found
GD…found
GD::Graph…found
GPG dependencies:
PerlIO::eol…found
GnuPG::Interface…found
ICAL dependencies:
Data::ICal…found
MAILGATE dependencies:
Pod::Usage…found
HTML::TreeBuilder…found
Getopt::Long…found
HTML::FormatText…found
LWP::UserAgent…found
MASON dependencies:
Storable >= 2.08…found
CSS::Squish >= 0.06…found
Apache::Session >= 1.53…found
Errno…found
Devel::StackTrace >= 1.19…found
CGI::Cookie >= 1.20…found
Text::WikiFormat >= 0.76…found
XML::RSS >= 1.05…found
HTML::Mason >= 1.36…found
Digest::MD5 >= 2.27…found
MODPERL2 dependencies:
CGI >= 3.38…found
Apache::DBI…found
HTML::Mason >= 1.36…found
MYSQL dependencies:
DBD::mysql >= 2.1018…found
SMTP dependencies:
Net::SMTP…found
STANDALONE dependencies:
Net::Server::PreFork…found
Net::Server…found
HTTP::Server::Simple >= 0.34…found
HTTP::Server::Simple::Mason >= 0.09…found

All dependencies have been found.
/usr/bin/install -c -m 0755 -o root -g www-data -d /opt/rt3/etc
/usr/bin/install -c -m 0440 -o root -g www-data etc/RT_Config.pm
/opt/rt3/etc/RT_Config.pm
[ -f /opt/rt3/etc/RT_SiteConfig.pm ] || /usr/bin/install -c -m 0640 -o root
-g www-data etc/RT_SiteConfig.pm /opt/rt3/etc/RT_SiteConfig.pm
Installed configuration. About to install RT in /opt/rt3
/usr/bin/install -c -m 0755 -d /opt/rt3/var/log
/usr/bin/install -c -m 0770 -d /opt/rt3/var/mason_data
/usr/bin/install -c -m 0770 -d /opt/rt3/var/mason_data/cache
/usr/bin/install -c -m 0770 -d /opt/rt3/var/mason_data/etc
/usr/bin/install -c -m 0770 -d /opt/rt3/var/mason_data/obj
/usr/bin/install -c -m 0770 -d /opt/rt3/var/session_data
/usr/bin/install -c -m 0755 -d /opt/rt3/share/html
/usr/bin/install -c -m 0755 -d /opt/rt3/local/html
/usr/bin/install -c -m 0755 -d /opt/rt3/local/etc
/usr/bin/install -c -m 0755 -d /opt/rt3/local/lib
/usr/bin/install -c -m 0755 -d /opt/rt3/local/plugins
/usr/bin/install -c -m 0755 -d /opt/rt3/local/po
[ -d /opt/rt3/lib ] || /usr/bin/install -c -m 0755 -d /opt/rt3/lib
cd lib && find . -type d -name .svn -prune -o -type d -exec /usr/bin/install
-c -m 0755 -d /opt/rt3/lib/{} ;
cd lib && find . -type d -name .svn -prune -o -type f -exec /usr/bin/install
-c -m 0644 {} /opt/rt3/lib/{} ;
/usr/bin/install -c -m 0755 -d /opt/rt3/etc
cd etc && /usr/bin/install -c -m 0644 acl.Informix acl.Pg acl.Oracle
acl.mysql acl.Sybase schema.Informix schema.Pg schema.Oracle schema.mysql
schema.mysql-4.1 schema.Sybase schema.SQLite initialdata /opt/rt3/etc/
/usr/bin/install -c -m 0755 -d /opt/rt3/bin
cd bin && /usr/bin/install -c -o root -g www-data -m 0755 webmux.pl
rt-mailgate rt rt-crontool standalone_httpd mason_handler.scgi
mason_handler.fcgi mason_handler.svc /opt/rt3/bin/
/usr/bin/install -c -m 0755 -d /opt/rt3/sbin
cd sbin && /usr/bin/install -c -o root -g www-data -m 0755 rt-dump-database
rt-setup-database rt-email-digest rt-email-dashboards rt-email-group-admin
rt-server rt-test-dependencies rt-clean-sessions rt-shredder /opt/rt3/sbin/
[ -d /opt/rt3/share/html ] || /usr/bin/install -c -m 0755 -d
/opt/rt3/share/htmlcd share/html && find . -type d -name .svn -prune -o
-type d -exec /usr/bin/install -c -m 0755 -d /opt/rt3/share/html/{} ;
cd share/html && find . -type d -name .svn -prune -o -type f -exec
/usr/bin/install -c -m 0644 {} /opt/rt3/share/html/{} ;
cd local/html && find . -type d -name .svn -prune -o -type d -exec
/usr/bin/install -c -m 0755 -d /opt/rt3/local/html/{} ;
/bin/sh: line 0: cd: local/html: No such file or directory
make: [local-install] Error 1 (ignored)
cd local/html && find . -type d -name .svn -prune -o -type f -exec
/usr/bin/install -c -m 0644 {} /opt/rt3/local/html/{} ;
/bin/sh: line 0: cd: local/html: No such file or directory
make: [local-install] Error 1 (ignored)
cd local/po && find . -type d -name .svn -prune -o -type d -exec
/usr/bin/install -c -m 0755 -d /opt/rt3/local/po/{} ;
/bin/sh: line 0: cd: local/po: No such file or directory
make: [local-install] Error 1 (ignored)
cd local/po && find . -type d -name .svn -prune -o -type f -exec
/usr/bin/install -c -m 0644 {} /opt/rt3/local/po/{} ;
/bin/sh: line 0: cd: local/po: No such file or directory
make: [local-install] Error 1 (ignored)
cd local/etc && find . -type d -name .svn -prune -o -type d -exec
/usr/bin/install -c -m 0755 -d /opt/rt3/local/etc/{} ;
/bin/sh: line 0: cd: local/etc: No such file or directory
make: [local-install] Error 1 (ignored)
cd local/etc && find . -type d -name .svn -prune -o -type f -exec
/usr/bin/install -c -m 0644 {} /opt/rt3/local/etc/{} ;
/bin/sh: line 0: cd: local/etc: No such file or directory
make: [local-install] Error 1 (ignored)

RT 3.0.0 - RT 3.0.2 would accidentally create a file instead of a dir

[ -f /opt/rt3/share/doc ] && rm /opt/rt3/share/doc
make: [doc-install] Error 1 (ignored)
[ -d /opt/rt3/share/doc ] || /usr/bin/install -c -m 0755 -d
/opt/rt3/share/doc
/usr/bin/install -c -m 0644 ./README /opt/rt3/share/doc/

Make the libraries readable

chmod 0755 /opt/rt3
chown -R root /opt/rt3/lib
chgrp -R bin /opt/rt3/lib
chmod -R u+rwX,go-w,go+rX /opt/rt3/lib
chmod 0755 /opt/rt3/bin
chmod 0755 /opt/rt3/bin
chmod 0755 /opt/rt3/etc
cd /opt/rt3/etc && chmod 0400 acl.Informix acl.Pg acl.Oracle acl.mysql
acl.Sybase schema.Informix schema.Pg schema.Oracle schema.mysql
schema.mysql-4.1 schema.Sybase schema.SQLite initialdata
#TODO: the config file should probably be able to have its

owner set separately from the binaries.

chown -R root /opt/rt3/etc
chgrp -R www-data /opt/rt3/etc
chmod 0440 /opt/rt3/etc/RT_Config.pm
chmod 0640 /opt/rt3/etc/RT_SiteConfig.pm

Make the system binaries

cd /opt/rt3/bin && ( chmod 0755 webmux.pl rt-mailgate rt rt-crontool
standalone_httpd mason_handler.scgi mason_handler.fcgi mason_handler.svc ;
chown root webmux.pl rt-mailgate rt rt-crontool standalone_httpd
mason_handler.scgi mason_handler.fcgi mason_handler.svc; chgrp www-data
webmux.pl rt-mailgate rt rt-crontool standalone_httpd mason_handler.scgi
mason_handler.fcgi mason_handler.svc)

Make the system binaries executable also

cd /opt/rt3/sbin && ( chmod 0755 rt-dump-database rt-setup-database
rt-email-digest rt-email-dashboards rt-email-group-admin rt-server
rt-test-dependencies rt-clean-sessions rt-shredder ; chown root
rt-dump-database rt-setup-database rt-email-digest rt-email-dashboards
rt-email-group-admin rt-server rt-test-dependencies rt-clean-sessions
rt-shredder; chgrp www-data rt-dump-database rt-setup-database
rt-email-digest rt-email-dashboards rt-email-group-admin rt-server
rt-test-dependencies rt-clean-sessions rt-shredder)

Make the web ui readable by all.

chmod -R u+rwX,go-w,go+rX /opt/rt3/share/html
/opt/rt3/local/html
/opt/rt3/local/po
chown -R root /opt/rt3/share/html
/opt/rt3/local/html
chgrp -R bin /opt/rt3/share/html
/opt/rt3/local/html

Make the web ui’s data dir writable

chmod 0770 /opt/rt3/var/mason_data
/opt/rt3/var/session_data
chown -R www-data /opt/rt3/var/mason_data
/opt/rt3/var/session_data
chgrp -R www-data /opt/rt3/var/mason_data
/opt/rt3/var/session_data
Congratulations. RT is now installed.

You must now configure RT by editing /opt/rt3/etc/RT_SiteConfig.pm.

(You will definitely need to set RT’s database password in
/opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could be
very dangerous. Note that you do not have to manually add a
database user or set up a database for RT. These actions will be
taken care of in the next step.)

After that, you need to initialize RT’s database by running
‘make initialize-database’

RT still seems to work after i make initialize-database although when I go
to install RTFM I cannot complete the initialize-database step.

Getting the error

Now populating database schema.
Couldn’t finish ‘schema’ step.

ERROR: Couldn’t find schema file(s) ‘*’

…returned with error: 65280
make: *** [initialize-database] Error 255

Im not sure if these are related, any help would be greatly appreciated

Cheers

Cameron

Cameron Batt
Tutoring Australasia - BRW Fast Starter 2008
Level 1, 296-298 Willoughby Road
Naremburn NSW 2065
p +61 2 9906 2700
f +61 2 9906 2776
e cbatt@yourtutor.com.au
w yourtutor.com.au

** Visit our blog at: yourtutor.com.au/blog **

2

Back in July, Cameron posted a message to the list regarding an
installation problem. (See
http://lists.bestpractical.com/pipermail/rt-users/2008-July/052816.html
for his message.) As far as I can tell, there wasn’t a response sent to
the list, and I had a similar problem. I’m posting this in case my
experience helps anyone else out.

Thanks to Ruslan, I’ve now got a fresh working installation of RT 3.8.0.
I went to install RTFM and ran into an issue with the initdb step. It
returned

Working with:
Type: mysql
Host: db01.prl.ab.ca
Name: ref_ill_rt
User: refrt
DBA: refrt
Now populating database schema.
Couldn’t finish ‘schema’ step.

ERROR: Couldn’t find schema file(s) ‘*’

…returned with error: 65280
make: *** [initdb] Error 255

I noticed that it was using the db-rt-user as both user and dba. The
configure line for RT did specify the db-dba as root. I tried the refrt
password, and it connected but returned the error above. (Using the root
password with the above settings returned an access denied message as
expected.) I then replaced the dba in the perl command line with root,
but got the same error as above.

I went hunting for the schema and found it in
RTFM-2.2.1/etc/schema.mysql. So I cheated and ran mysql -h
db01.prl.ab.ca -D ref_ill_rt -u root -p < schema.mysql and it appears to
have worked. The other line in the Makefile refers to acl, but the
acl.mysql file says there aren’t any changes needed in mysql for ACL so
I didn’t run it.

Below is the complete run from perl Makefile.PL up to the error message
in case it helps.

Michael

[root@reftrack RTFM-2.2.1]# perl Makefile.PL
Using RT configurations from /opt/rt3/lib/RT.pm:
./bin => /opt/rt3/local/bin
./etc => /opt/rt3/local/etc/FM
./html => /opt/rt3/share/html
./lib => /opt/rt3/local/lib
./po => /opt/rt3/local/po/FM
./sbin => /opt/rt3/local/sbin
For first-time installation, type ‘make initdb’.
*** Module::AutoInstall version 1.03
*** Checking for Perl dependencies…
[Core Features]
Cannot reliably compare non-decimal formatted versions.
Please install version.pm or Sort::Versions.

  • RT …loaded. (3.8.0 >= 3.4.2)
  • Text::WikiFormat …loaded. (0.79)
  • Tree::Simple …loaded. (1.18)
  • HTML::TreeBuilder …loaded. (3.23)
  • Time::ParseDate …loaded. (2006.0814)
  • HTML::FormatText …loaded. (2.04)
  • YAML …loaded. (0.66)
    *** Module::AutoInstall configuration finished.
    Open input ‘/root/RTFM-2.2.1/t/utils.pl’ file for substitution
    Open output ‘/root/RTFM-2.2.1/t/utils.pl’ file for substitution
    Writing Makefile for RTFM
    [root@reftrack RTFM-2.2.1]# make
    Manifying blib/man3/RT::FM::Topic_Overlay.3pm
    Manifying blib/man3/RT::FM::Article.3pm
    Manifying blib/man3/RT::FM::TopicCollection_Overlay.3pm
    Manifying blib/man3/RT::FM::ObjectTopic.3pm
    Manifying blib/man3/RT::FM::Record.3pm
    Manifying blib/man3/RT::FM::ObjectTopicCollection_Overlay.3pm
    Manifying blib/man3/RT::URI::fsck_com_rtfm.3pm
    Manifying blib/man3/RT::FM::Class.3pm
    Manifying blib/man3/RT::FM::ArticleCollection.3pm
    Manifying blib/man3/RT::URI::a.3pm
    Manifying blib/man3/RT::FM::Article_Overlay.3pm
    Manifying blib/man3/RT::FM::ObjectTopicCollection.3pm
    Manifying blib/man3/RT::FM::ClassCollection_Overlay.3pm
    Manifying blib/man3/RT::FM::ArticleCollection_Overlay.3pm
    Manifying blib/man3/RT::FM::Class_Overlay.3pm
    Manifying blib/man3/RT::FM::SearchBuilder.3pm
    Manifying blib/man3/RT::FM::TopicCollection.3pm
    Manifying blib/man3/RT::FM::Topic.3pm
    Manifying blib/man3/RT::FM::ClassCollection.3pm
    Manifying blib/man3/RT::FM::System.3pm
    [root@reftrack RTFM-2.2.1]# make install
    Writing
    /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/RTFM/.packli
    st
    Appending installation info to
    /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
    [root@reftrack RTFM-2.2.1]# make initdb
    /usr/bin/perl -Ilib -I/opt/rt3/local/lib -I/opt/rt3/lib
    /opt/rt3/sbin/rt-setup-database --action schema --datadir etc --datafile
    etc/initialdata --dba refrt --prompt-for-dba-password
    In order to create or update your RT database, this script needs to
    connect to your mysql instance on db01.prl.ab.ca as refrt
    Please specify that user’s database password below. If the user has no
    database
    password, just press return.

Password:
Working with:
Type: mysql
Host: db01.prl.ab.ca
Name: ref_ill_rt
User: refrt
DBA: refrt
Now populating database schema.
Couldn’t finish ‘schema’ step.

ERROR: Couldn’t find schema file(s) ‘*’

…returned with error: 65280
make: *** [initdb] Error 255

3

Back in July, Cameron posted a message to the list regarding an
installation problem. (See
The rt-users July 2008 Archive by thread
052816.html
for his message.) As far as I can tell, there wasn’t a response sent
to
the list, and I had a similar problem. I’m posting this in case my
experience helps anyone else out.

There was a bug with the packaging tools and 3.8, this was
corrected in the RTFM trunk.

The problem was the
–datafile etc/initialdata

argument being passed during make initdb

-kevin

4

There was a bug with the packaging tools and 3.8, this was
corrected in the RTFM trunk.

Has the fix made it into the current release of RTFM?

Richard

5

There was a bug with the packaging tools and 3.8, this was
corrected in the RTFM trunk.

Has the fix made it into the current release of RTFM?

There are enough other bugs with rtfm and 3.8 that I’m
currently waiting for the 3.8.1 release before cutting
an RTFM release candidate.

-kevin