[rt-users] RTIR database initialization problem
Daniel Firvida
dfirvida at gmail.com
Fri Jan 19 06:57:01 EST 2007
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 at ubuntu:/usr/local/share/request-tracker3.4/etc/IR# diff
RTIR_Config.pm RTIR_Config.pm.bkp
116,117c116,117
< ReportDefault => qq{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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{'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#',
< '<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a></B>/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 at ubuntu:/usr/local/share/request-tracker3.4/etc/IR#
And now:
root at 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 at 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 greeting
2007/1/18, Jesse Vincent <jesse at 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 at 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 at 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 at 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 at ubuntu:/usr/src/rtir-1.1.5#
> >
> > I do not know if they are the same file that i need
> >
> > root at 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 at bestpractical.com>
> > #
> > # (Except where explicitly superseded by other copyright notices)
> > #
> > root at 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 at 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 at 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
> > _______________________________________________
> > 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
> >
>
> --
>
More information about the rt-users
mailing list