RTIR database initialization problem

RT Users
1

Hi

I have a new installation of RTIR in ubuntu 6.10.

The installed versions are RT 3,4 with apache2 and postgresql and RTIR 1.1.5

The problem takes place when attempt to complete the RTIR
installation, concretely in point 5 of the instructions of
installation, the database initialization.

Up to here it had not had any problem following the instruciones of
wiki for the installation in ubuntu and the README file of RTIR

The problem is this:

root@ubuntu:/usr/src/rtir-1.1.5# make initdb
include /usr/src/rtir-1.1.5/inc/Module/Install.pm
include inc/Module/Install/RTx/Factory.pm
include inc/Module/Install/Base.pm
/usr/bin/perl -Ilib -I/usr/share/request-tracker3.4/lib
/usr/local/share/request-tracker3.4/rt-setup-database --action insert
–datadir etc --datafile etc/initialdata --dba rtuser
–prompt-for-dba-password
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
root@ubuntu:/usr/src/rtir-1.1.5#

The file rt-setup-database, is in the system or at least another one
with the same name, but in another path

root@ubuntu:/usr/src/rtir-1.1.5# find / -name rt-setup-database
/var/lib/dpkg/alternatives/rt-setup-database
/etc/alternatives/rt-setup-database
/usr/sbin/rt-setup-database
root@ubuntu:/usr/src/rtir-1.1.5#

I do not know if they are the same file that i need

root@ubuntu:/usr/src/rtir-1.1.5# head /usr/sbin/rt-setup-database
#!/usr/bin/perl -w

BEGIN BPS TAGGED BLOCK {{{

COPYRIGHT:

This software is Copyright (c) 1996-2005 Best Practical Solutions, LLC

jesse@bestpractical.com

(Except where explicitly superseded by other copyright notices)

root@ubuntu:/usr/src/rtir-1.1.5#

If I try to execute the commando who gives error with this file of
manual form (without make initdb), the following error takes place

root@ubuntu:/usr/src/rtir-1.1.5# /usr/bin/perl -Ilib
-I/usr/share/request-tracker3.4/lib /usr/sbin/rt-setup-database
–action insert --datadir etc --datafile etc/initialdata --dba rtuser
–prompt-for-dba-password
“my” variable $id masks earlier declaration in same scope at
/usr/share/request-tracker3.4/lib/RT/CustomField_Overlay.pm line 879.
“my” variable $id masks earlier declaration in same scope at
/usr/share/request-tracker3.4/lib/RT/CustomField_Overlay.pm line 914.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
In order to create or update your RT database,this script needs to
connect to your Pg instance on localhost as rtuser.
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
root@ubuntu:/usr/src/rtir-1.1.5#

what happens? Because it gives these errors?
if I have a symbolic link was solved?
ln -s /usr/sbin/rt-setup-database
/usr/local/share/request-tracker3.4/rt-setup-database

A greeting

2

Hi

I have a new installation of RTIR in ubuntu 6.10.

You probably REALLY want to be running RT 3.7 and RTIR 1.9. RTIR 1.1 was
a development branch that never really got all the way there.

3

Well, I will prove the versions that you are saying to me, but in the
web site the last versions that appear are RT3.6.3 (Thu Dec 21 2006)
http://download.bestpractical.com/pub/rt/release/rt-3.6.3.tar.gz and
RTIR-20060309 (Thu Mar 9 2006)
http://download.bestpractical.com/pub/rt/devel/rtir-20060309.tar.gz
Where is the links to the versions that you say?

I have made a change in the code of
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm to correct
these errors.
The changes that I have done are:

root@ubuntu:/usr/local/share/request-tracker3.4/etc/IR# diff
RTIR_Config.pm RTIR_Config.pm.bkp
116,117c116,117
< ReportDefault => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

ReportDefault => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                  '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

129,130c129,130
< InvestigationDefault => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

InvestigationDefault => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                         '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

142,143c142,143
< BlockDefault => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

BlockDefault => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                 '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

155,156c155,156
< IncidentDefault => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

IncidentDefault => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                    '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

168,169c168,169
< ‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

          '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
          '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

176,177c176,177
< ‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

                 '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                 '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

184,185c184,185
< ‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

                 '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                 '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

191,192c191,192
< ‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

                '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

196,197c196,197
< ‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

              '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
              '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

200,201c200,201
< DueIncidents => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

DueIncidents => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                 '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

207,208c207,208
< NewReports => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

NewReports => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                 '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

214,215c214,215
< ChildReport => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

ChildReport => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                  '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

220,221c220,221
< ChildInvestigation => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

ChildInvestigation => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
                       '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

226,227c226,227
< ChildBlock => qq{‘id/TITLE:#’,
< ‘Subject/Title:Subject’,

ChildBlock => qq{'<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
               '<B><A HREF="$RT::WebPath/Ticket/Display.html?id=__id__">__Subject__</a></B>/Title:Subject',

root@ubuntu:/usr/local/share/request-tracker3.4/etc/IR#

And now:

root@ubuntu:/usr/src/rtir-1.1.5# /usr/bin/perl -Ilib
-I/usr/share/request-tracker3.4/lib /usr/sbin/rt-setup-database
–action insert --datadir etc --datafile etc/initialdata --dba rtuser
–prompt-for-dba-password
“my” variable $id masks earlier declaration in same scope at
/usr/share/request-tracker3.4/lib/RT/CustomField_Overlay.pm line 879.
“my” variable $id masks earlier declaration in same scope at
/usr/share/request-tracker3.4/lib/RT/CustomField_Overlay.pm line 914.
In order to create or update your RT database,this script needs to
connect to your Pg instance on localhost as rtuser.
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
root@ubuntu:
(If i have a symbolic link … “ln -s /usr/sbin/rt-setup-database
/usr/local/share/request-tracker3.4/rt-setup-database” the command
“make initdb” are same to this output)

Now the database initialization does not fail but… somebody can tell
me if this change is correct? or sent a message to rt-devel list?

Thanks
A greeting2007/1/18, Jesse Vincent jesse@bestpractical.com:

On Tue, Jan 16, 2007 at 05:54:29PM +0100, Daniel Firvida wrote:

Hi

I have a new installation of RTIR in ubuntu 6.10.

You probably REALLY want to be running RT 3.7 and RTIR 1.9. RTIR 1.1 was
a development branch that never really got all the way there.

The installed versions are RT 3,4 with apache2 and postgresql and RTIR
1.1.5

The problem takes place when attempt to complete the RTIR
installation, concretely in point 5 of the instructions of
installation, the database initialization.

Up to here it had not had any problem following the instruciones of
wiki for the installation in ubuntu and the README file of RTIR

The problem is this:

root@ubuntu:/usr/src/rtir-1.1.5# make initdb
include /usr/src/rtir-1.1.5/inc/Module/Install.pm
include inc/Module/Install/RTx/Factory.pm
include inc/Module/Install/Base.pm
/usr/bin/perl -Ilib -I/usr/share/request-tracker3.4/lib
/usr/local/share/request-tracker3.4/rt-setup-database --action insert
–datadir etc --datafile etc/initialdata --dba rtuser
–prompt-for-dba-password
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
root@ubuntu:/usr/src/rtir-1.1.5#

The file rt-setup-database, is in the system or at least another one
with the same name, but in another path

root@ubuntu:/usr/src/rtir-1.1.5# find / -name rt-setup-database
/var/lib/dpkg/alternatives/rt-setup-database
/etc/alternatives/rt-setup-database
/usr/sbin/rt-setup-database
root@ubuntu:/usr/src/rtir-1.1.5#

I do not know if they are the same file that i need

root@ubuntu:/usr/src/rtir-1.1.5# head /usr/sbin/rt-setup-database
#!/usr/bin/perl -w

BEGIN BPS TAGGED BLOCK {{{

COPYRIGHT:

This software is Copyright (c) 1996-2005 Best Practical Solutions, LLC

jesse@bestpractical.com

(Except where explicitly superseded by other copyright notices)

root@ubuntu:/usr/src/rtir-1.1.5#

If I try to execute the commando who gives error with this file of
manual form (without make initdb), the following error takes place

root@ubuntu:/usr/src/rtir-1.1.5# /usr/bin/perl -Ilib
-I/usr/share/request-tracker3.4/lib /usr/sbin/rt-setup-database
–action insert --datadir etc --datafile etc/initialdata --dba rtuser
–prompt-for-dba-password
“my” variable $id masks earlier declaration in same scope at
/usr/share/request-tracker3.4/lib/RT/CustomField_Overlay.pm line 879.
“my” variable $id masks earlier declaration in same scope at
/usr/share/request-tracker3.4/lib/RT/CustomField_Overlay.pm line 914.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
Use of uninitialized value in concatenation (.) or string at
/usr/local/share/request-tracker3.4/etc/IR/RTIR_Config.pm line 115.
In order to create or update your RT database,this script needs to
connect to your Pg instance on localhost as rtuser.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
root@ubuntu:/usr/src/rtir-1.1.5#

what happens? Because it gives these errors?
if I have a symbolic link was solved?
ln -s /usr/sbin/rt-setup-database
/usr/local/share/request-tracker3.4/rt-setup-database

A greeting

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

–

4

Daniel Firvida wrote:

Well, I will prove the versions that you are saying to me, but in the
web site the last versions that appear are RT3.6.3 (Thu Dec 21 2006)
http://download.bestpractical.com/pub/rt/release/rt-3.6.3.tar.gz and
RTIR-20060309 (Thu Mar 9 2006)
http://download.bestpractical.com/pub/rt/devel/rtir-20060309.tar.gz
Where is the links to the versions that you say?

I’m on a plane, so it’s hard to check, but there should be a more recent
RTIR snap sitting there. Current RTIR (RTIR2) versions require RT 3.7.
(RTIR 1.1.x are unsupported developer releases that should run with RT
3.4 and RT 3.6. But. Very Unsupported).

Best,
Jesse

signature.asc (189 Bytes)