Help installing RT4 on Ubuntu

borngunners · January 26, 2012, 5:02pm

I have installed RT 4 on ubuntu and have tested the web after restarting apache, nothing shows up except the normal apache "It Works!"
What am I doing wrong in this case…?

Kevin_Falcone · January 26, 2012, 9:40pm

I have installed RT 4 on ubuntu and have tested the web after restarting apache, nothing shows
up except the normal apache “It Works!”
What am I doing wrong in this case…?

You’re going to need to share your apache config for anyone to be able
to offer advice.

-kevin

Bart · January 30, 2012, 10:33am

Same as with Debian, you need to manually add the RT apache configuration
to apache. If Ubuntu does the same as Debian then you can find an example
under /etc/request-tracker4.

I suspect that you don’t have a config under /etc/apache2/sites-available
for RT, and/or not a link to the RT apache config under
/etc/apache2/sites-enabled/

Make sure you have the RT config in there and a link under sites-enabled,
after that restart apache2 and it should work (if the config is correct).

For example configs you can check the wiki or these lists.

– Bart

Op 26 januari 2012 22:40 schreef Kevin Falcone
falcone@bestpractical.comhet volgende:> On Thu, Jan 26, 2012 at 12:02:28PM -0500, Borngunners wrote:

I have installed RT 4 on ubuntu and have tested the web after
restarting apache, nothing shows
up except the normal apache “It Works!”
What am I doing wrong in this case…?

You’re going to need to share your apache config for anyone to be able
to offer advice.

-kevin

RT Training Sessions (http://bestpractical.com/services/training.html)

Boston — March 5 & 6, 2012

borngunners · January 30, 2012, 7:29pm

This is my /etc/apache2/httpd.conf and /etc/apache2/sites-available/default configuration files
:
<VirtualHost *:80>
ServerName UHC:80
ServerAdmin helpdesk@ticket.com

ErrorLog /var/log/apache2/error.log
TransferLog /var/log/apache2/xfer.log
CustomLog /var/log/apache2/access.log combined
ServerSignature On

#config for your main content
DocumentRoot “/opt/rt4/share/html”
Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/

<Directory “/opt/rt4/share/html”>
Options Indexes FollowSymLinks

AllowOverride None
Allow from all
satisfy any

AddDefaultCharset UTF-8
SetHandler modperl
PerlResponseHandler Plack::Handler::Apache2
PerlSetVar psgi_app /opt/rt4/sbin/rt-server

From: Bart bart@pleh.info
To: rt-users rt-users@lists.bestpractical.com
Sent: Mon, Jan 30, 2012 5:34 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Same as with Debian, you need to manually add the RT apache configuration to apache. If Ubuntu does the same as Debian then you can find an example under /etc/request-tracker4.

I suspect that you don’t have a config under /etc/apache2/sites-available for RT, and/or not a link to the RT apache config under /etc/apache2/sites-enabled/

Make sure you have the RT config in there and a link under sites-enabled, after that restart apache2 and it should work (if the config is correct).

For example configs you can check the wiki or these lists.

– Bart

Kevin_Falcone · January 30, 2012, 8:25pm

This is my /etc/apache2/httpd.conf and /etc/apache2/sites-available/default configuration
files

Please try the config that we ship with RT as documented in
docs/web_deployment.pod (which is referred to from the README).

-kevin

borngunners · January 30, 2012, 10:11pm

Hello Falcone,
I have tried the config as stated. This is the message I receive after starting apche:
root@helpdesks:/etc/apache2# /etc/init.d/apache2 start

Starting web server apache2 [Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table ‘rt4.Users’ doesn’t exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Mon Jan 30 22:08:01 2012] [warning]: RT::Handle=HASH(0xb96785c8) couldn’t execute the query ‘SELECT * FROM Users WHERE Name = ?’ at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xb96785c8)’, ‘SELECT * FROM Users WHERE Name = ?’, ‘RT_System’) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CurrentUser=HASH(0xb9c696c8)’, ‘SELECT * FROM Users WHERE Name = ?’, ‘RT_System’) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125
DBIx::SearchBuilder::Record::LoadByCols(‘RT::CurrentUser=HASH(0xb9c696c8)’, ‘Name’, ‘RT_System’) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CurrentUser=HASH(0xb9c696c8)’, ‘Name’, ‘RT_System’) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 363
RT::Record::LoadByCols(‘RT::CurrentUser=HASH(0xb9c696c8)’, ‘Name’, ‘RT_System’) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1070
DBIx::SearchBuilder::Record::LoadByCol(‘RT::CurrentUser=HASH(0xb9c696c8)’, ‘Name’, ‘RT_System’) called at /opt/rt4/sbin/…/lib/RT/User.pm line 462
RT::User::Load(‘RT::CurrentUser=HASH(0xb9c696c8)’, ‘RT_System’) called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 240
RT::Handle::CheckIntegrity(‘RT::Handle’) called at /opt/rt4/sbin/rt-server line 97
require /opt/rt4/sbin/rt-server called at (eval 6) line 3
eval 'package Plack::Sandbox::_2fopt_2frt4_2fsbin_2frt_2dserver;
{
my $app = do $_file;
if ( !$app && ( my $error = $@ || $! )) { die $error; }
$app;
}

;’ called at /usr/local/share/perl/5.10.1/Plack/Util.pm line 118
Plack::Util::_load_sandbox(‘/opt/rt4/sbin/rt-server’) called at /usr/local/share/perl/5.10.1/Plack/Util.pm line 155
Plack::Util::load_psgi(‘/opt/rt4/sbin/rt-server’) called at /usr/local/share/perl/5.10.1/Plack/Handler/Apache2.pm line 32
Plack::Handler::Apache2::load_app(‘Plack::Handler::Apache2’, ‘/opt/rt4/sbin/rt-server’) called at /usr/local/share/perl/5.10.1/Plack/Handler/Apache2.pm line 24
Plack::Handler::Apache2::preload(‘Plack::Handler::Apache2’, ‘/opt/rt4/sbin/rt-server’) called at /etc/apache2/sites-enabled/000-default line 20
eval 'package Apache2::ReadConfig::etc::apache2::sites_enabled::000_default::line_19;
#line 19 /etc/apache2/sites-enabled/000-default
use Plack::Handler::Apache2;
Plack::Handler::Apache2->preload(“/opt/rt4/sbin/rt-server”);

;’ called at /opt/rt4/sbin/…/lib/RT/CurrentUser.pm line 0 (/usr/share/perl/5.10/Carp.pm:47)
[Mon Jan 30 22:08:01 2012] [warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/…/lib/RT/Handle.pm line 242. (/opt/rt4/sbin/…/lib/RT/Handle.pm:241)

RT couldn’t connect to the database where tickets are stored.
If this is a new installation of RT, you should visit the URL below
to configure RT and initialize your database.

If this is an existing RT installation, this may indicate a database
connectivity problem.

The error RT got back when trying to connect to your database was:

Couldn’t find RT_System user in the DB ‘’

[Mon Jan 30 22:08:02 2012] [warning]: (in cleanup) Error while loading /opt/rt4/sbin/rt-server: Can’t locate RT/Authen/ExternalAuth.pm in @INC (@INC contains: /opt/rt4/sbin/…/local/lib /opt/rt4/sbin/…/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /opt/rt4/sbin/…/lib/RT.pm line 659. (/opt/rt4/sbin/…/lib/RT.pm:343)
[Mon Jan 30 17:08:02 2012] [warn] NameVirtualHost *:80 has no VirtualHosts
[ OK ]
root@helpdesks:/etc/apache2#

ThanksFrom: Kevin Falcone falcone@bestpractical.com
To: rt-users rt-users@lists.bestpractical.com
Sent: Mon, Jan 30, 2012 3:25 pm
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

This is my /etc/apache2/httpd.conf and /etc/apache2/sites-available/default
configuration
files

Please try the config that we ship with RT as documented in
docs/web_deployment.pod (which is referred to from the README).

-kevin

:
<VirtualHost *:80>
ServerName UHC:80
ServerAdmin helpdesk@ticket.com

ErrorLog /var/log/apache2/error.log
TransferLog /var/log/apache2/xfer.log
CustomLog /var/log/apache2/access.log combined
ServerSignature On

#config for your main content
DocumentRoot “/opt/rt4/share/html”
Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/

<Directory “/opt/rt4/share/html”>
Options Indexes FollowSymLinks

AllowOverride None
Allow from all
satisfy any

AddDefaultCharset UTF-8
SetHandler modperl
PerlResponseHandler Plack::Handler::Apache2
PerlSetVar psgi_app /opt/rt4/sbin/rt-server

-----Original Message-----
From: Bart bart@pleh.info
To: rt-users rt-users@lists.bestpractical.com
Sent: Mon, Jan 30, 2012 5:34 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Same as with Debian, you need to manually add the RT apache configuration
to apache. If Ubuntu
does the same as Debian then you can find an example under
/etc/request-tracker4.
I suspect that you don’t have a config under /etc/apache2/sites-available
for RT, and/or not a
link to the RT apache config under /etc/apache2/sites-enabled/
Make sure you have the RT config in there and a link under sites-enabled,
after that restart
apache2 and it should work (if the config is correct).
For example configs you can check the wiki or these lists.
– Bart

Op 26 januari 2012 22:40 schreef Kevin Falcone falcone@bestpractical.com
het volgende:

 >    I have installed RT 4 on ubuntu and have tested the web after

restarting apache,

 nothing shows
 >    up except the normal apache "It Works!"
 >    What am I doing wrong in this case....?

 You're going to need to share your apache config for anyone to be able
 to offer advice.
 -kevin
 --------
 RT Training Sessions (http://bestpractical.com/services/training.html)
 * Boston -- March 5 & 6, 2012

RT Training Sessions (http://bestpractical.com/services/training.html)

Boston ** March 5 & 6, 2012

RT Training Sessions (http://bestpractical.com/services/training.html)

Boston ? March 5 & 6, 2012

RT Training Sessions (http://bestpractical.com/services/training.html)

Boston � March 5 & 6, 2012

Josh_Narins · January 30, 2012, 10:25pm

Please review this part of the error message you sent:

RT couldn’t connect to the database where tickets are stored.If this is a new installation of RT, you should visit the URL belowto configure RT and initialize your database.If this is an existing RT installation, this may indicate a databaseconnectivity problem.The error RT got back when trying to connect to your database was:Couldn’t find RT_System user in the DB

Try seeing if you can connect to the RT database with a simple perl DBI and DBD::Mysql script, then try connecting as the RT user, also check if you can find RT tables, like users, once connected.

Josh Narins
Director of Application Development
SeniorBridge

845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Mobile: (917) 488-6248
Fax: (212) 994-4260
jnarins@seniorbridge.com

SeniorBridge
Managing Complex Chronic Care
http://www.seniorbridge.com

SeniorBridge Statement of Confidentiality: The contents of this email message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. Any dissemination, distribution or copying of this email by an unintended or mistaken recipient is strictly prohibited. In said event, kindly reply to the sender and destroy all entries of this message and any attachments from your system. Thank you.

Kevin_Falcone · January 30, 2012, 11:32pm

Hello Falcone,
I have tried the config as stated. This is the message I receive after starting apche:
root@helpdesks:/etc/apache2# /etc/init.d/apache2 start
* Starting web server
apache2
[Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table ‘rt4.Users’ doesn’t
exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)

You don’t appear to have created the RT database.

When you said> > On Thu, Jan 26, 2012 at 12:02:28PM -0500, Borngunners wrote:

 >    I have installed RT 4 on ubuntu and have tested the web after

What did you do to install RT? It’d be great if you looked through
the README and compared the steps to the notes about what you did.

-kevin

borngunners · January 31, 2012, 7:36pm

Okay. Now I have try to reinstall RT again and so far these are the configurations I have:

root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt4
User: rtuser
DBA: root
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Granting access to rtuser@‘localhost’ on rt4.
Done.
Now inserting RT core system objects.
Done.
[Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles
functionality. You should set the ‘active’ property of the ‘default’
lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Config.pm:766)
Now inserting data.
[Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:826)
[Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn’t find row (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:956)
Done inserting data.
Done.

Apache configuration:

ErrorLog /opt/rt4/var/log/apache2.error
TransferLog /opt/rt4/var/log/apache2.access

LogLevel debug

AddDefaultCharset UTF-8

DocumentRoot “/opt/rt4/share/html”

Order allow,deny
Allow from all

   SetHandler perl-script
   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server

use Plack::Handler::Apache2; Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");

thanks,From: Kevin Falcone falcone@bestpractical.com
To: rt-users rt-users@lists.bestpractical.com
Sent: Mon, Jan 30, 2012 6:32 pm
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hello Falcone,
I have tried the config as stated. This is the message I receive after
starting apche:
root@helpdesks:/etc/apache2# /etc/init.d/apache2 start
* Starting web server
apache2
[Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table
‘rt4.Users’ doesn’t
exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line

(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)

You don’t appear to have created the RT database.

When you said

Bart · February 1, 2012, 3:05pm

Hi,

Are you trying to do the source installation on Ubuntu? (btw, which version
of Ubuntu?)

At least, it looks that way. If the above is what you’ve done then I really
don’t understand the external auth errors your getting, a clean
installation doesn’t contain external auth…

My advise would be to make sure you have a clean installation up and
running first before playing with plugins (theres really no point).

Also, if you have the latest Ubuntu server then you can also install RT
using Aptitude ( aptitude search request-tracker4 ).

I assume you’ve documented all your steps up to this point, could you show
us exactly what you’ve done? (you’ve installed plugins, so undo that to
begin with or at least turn off the plugins in the RT_SiteConfig).

– Bart

Op 31 januari 2012 20:36 schreef Borngunners borngunners@aol.com het
volgende:

20_20_Lab · February 1, 2012, 11:36pm

It looks like your running this as a dedicated server (or a virtual host
[ie rt.place.tld]). I run it as a page. Its on the same server as my
nagios install. here is my rt section. There are a number of
differences, but its someplace to start trying.

I also had to add “LoadModule perl_module
/usr/lib/apache2/modules/mod_perl.so” to my apache2.conf. This config
is in my apache2.conf.

<Location /rt>
Order allow,deny
Allow from all

         SetHandler perl-script
         PerlResponseHandler Plack::Handler::Apache2
         PerlSetVar psgi_app /opt/rt4/sbin/rt-server

use Plack::Handler::Apache2; Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");

Now, I dont even begin think that I understand why this works. I had to
try a ton of things to get the two to play nice with eachother. I’m
running 11.10 (I think)

It looks like your running from an elevated prompt (in case your not I’d
start there). If you have no data in your database yet, do a make
dropdb and redo your make initialize-database.

Hope this helps,
MattOn 01/31/2012 11:36 AM, Borngunners wrote:

Okay. Now I have try to reinstall RT again and so far these are the
configurations I have:

root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib
sbin/rt-setup-database --action init --prompt-for-dba-password
In order to create or update your RT database, this script needs to
connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt4
User: rtuser
DBA: root
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Granting access to rtuser@‘localhost’ on rt4.
Done.
Now inserting RT core system objects.
Done.
[Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration
has been replaced by the new Lifecycles
functionality. You should set the ‘active’ property of the ‘default’
lifecycle and add transition rules; see RT_Config.pm for
documentation. (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Config.pm:766)
Now inserting data.
[Tue Jan 31 19:32:37 2012] [info]:
RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments:
SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root,
Name: root, Password: password, Privileged: 1, RealName: Enoch Root
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Tue Jan 31 19:32:37 2012] [error]: Could not set user info
(/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:826)
[Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root :
Couldn’t find row (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:956)
Done inserting data.
Done.

Apache configuration:

ErrorLog /opt/rt4/var/log/apache2.error
TransferLog /opt/rt4/var/log/apache2.access

LogLevel debug

AddDefaultCharset UTF-8

DocumentRoot “/opt/rt4/share/html”

Order allow,deny
Allow from all
   SetHandler perl-script
   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server
use Plack::Handler::Apache2; Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");
thanks,

-----Original Message-----
From: Kevin Falcone falcone@bestpractical.com
To: rt-users rt-users@lists.bestpractical.com
Sent: Mon, Jan 30, 2012 6:32 pm
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

On Mon, Jan 30, 2012 at 05:11:54PM -0500, Borngunners wrote:
Hello Falcone,
I have tried the config as stated. This is the message I receive after
starting apche:
root@helpdesks:/etc/apache2# /etc/init.d/apache2 start
 * Starting web server
apache2
[Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table
‘rt4.Users’ doesn’t
exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
You don’t appear to have created the RT database.

When you said
  On Thu, Jan 26, 2012 at 12:02:28PM -0500, Borngunners wrote:
  >     I have installed RT 4 on ubuntu and have tested the web after
What did you do to install RT? It’d be great if you looked through
the README and compared the steps to the notes about what you did.

-kevin

RT Training Sessions (http://bestpractical.com/services/training.html)

Boston ? March 5& 6, 2012

RT Training Sessions (http://bestpractical.com/services/training.html)

Boston — March 5& 6, 2012

borngunners · February 2, 2012, 2:03pm

I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don’t know what else to do regarding the installing RT. I seriously need help with detail how-to, please…

Thanks,From: Bart bart@pleh.info
To: rt-users rt-users@lists.bestpractical.com
Sent: Wed, Feb 1, 2012 10:06 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hi,

Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?)

At least, it looks that way. If the above is what you’ve done then I really don’t understand the external auth errors your getting, a clean installation doesn’t contain external auth…

My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point).

Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ).

I assume you’ve documented all your steps up to this point, could you show us exactly what you’ve done? (you’ve installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig).

– Bart

Okay. Now I have try to reinstall RT again and so far these are the configurations I have:

root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt4
User: rtuser
DBA: root
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Granting access to rtuser@‘localhost’ on rt4.
Done.
Now inserting RT core system objects.
Done.
[Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles
functionality. You should set the ‘active’ property of the ‘default’
lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Config.pm:766)
Now inserting data.
[Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:826)
[Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn’t find row (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:956)
Done inserting data.
Done.

Apache configuration:

ErrorLog /opt/rt4/var/log/apache2.error
TransferLog /opt/rt4/var/log/apache2.access

LogLevel debug

AddDefaultCharset UTF-8

DocumentRoot “/opt/rt4/share/html”

Order allow,deny
Allow from all

   SetHandler perl-script

   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server

    use Plack::Handler::Apache2;
    Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");

</Perl>

thanks,

From: Kevin Falcone falcone@bestpractical.com
To: rt-users rt-users@lists.bestpractical.com

Sent: Mon, Jan 30, 2012 6:32 pm
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hello Falcone,
I have tried the config as stated. This is the message I receive after
starting apche:
root@helpdesks:/etc/apache2# /etc/init.d/apache2 start
* Starting web server
apache2
[Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table
‘rt4.Users’ doesn’t
exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line

(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)

You don’t appear to have created the RT database.

When you said

Diaulas_Castro · February 2, 2012, 2:12pm

Did you put /rt in the end of url? Ex: http://192.168.1.1/rt

Have Ubuntu 11.10 installed 3 weeks ago, don’t remember to change apache conf except of including this line:

Include "/etc/request-tracker4/apache2-modperl2.conf”

Last 2 lines of my conf:

tail -n2 /etc/apache2/sites-available/default
Include “/etc/request-tracker4/apache2-modperl2.conf”
De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Em nome de Borngunners
Enviada em: quinta-feira, 2 de fevereiro de 2012 12:04
Para: bart@pleh.info; rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] Help installing RT4 on Ubuntu

I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don’t know what else to do regarding the installing RT. I seriously need help with detail how-to, please…

Thanks,

From: Bart <bart@pleh.infomailto:bart@pleh.info>
To: rt-users <rt-users@lists.bestpractical.com mailto:rt-users@lists.bestpractical.com>
Sent: Wed, Feb 1, 2012 10:06 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu
Hi,

Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?)

At least, it looks that way. If the above is what you’ve done then I really don’t understand the external auth errors your getting, a clean installation doesn’t contain external auth…

My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point).

Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ).

I assume you’ve documented all your steps up to this point, could you show us exactly what you’ve done? (you’ve installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig).

– Bart

Okay. Now I have try to reinstall RT again and so far these are the configurations I have:

root@helpdesks:/var/tmp/rt-4.0.4#mailto:root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt4
User: rtuser
DBA: root
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Granting access to rtuser@‘localhost’ on rt4.
Done.
Now inserting RT core system objects.
Done.
[Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles
functionality. You should set the ‘active’ property of the ‘default’
lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Config.pm:766)
Now inserting data.
[Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:826)
[Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn’t find row (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:956)
Done inserting data.
Done.

Apache configuration:

ErrorLog /opt/rt4/var/log/apache2.error
TransferLog /opt/rt4/var/log/apache2.access

LogLevel debug

AddDefaultCharset UTF-8

DocumentRoot “/opt/rt4/share/html”

Order allow,deny
Allow from all

   SetHandler perl-script

   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server

    use Plack::Handler::Apache2;
    Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");
</Perl>

thanks,

From: Kevin Falcone <falcone@bestpractical.com mailto:falcone@bestpractical.com>
To: rt-users <rt-users@lists.bestpractical.com mailto:rt-users@lists.bestpractical.com>
Sent: Mon, Jan 30, 2012 6:32 pm
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hello Falcone,

I have tried the config as stated. This is the message I receive after

starting apche:

root@helpdesks:/etc/apache2# /etc/init.d/apache2 start

* Starting web server

apache2

[Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table

‘rt4.Users’ doesn’t

exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line

(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)

You don’t appear to have created the RT database.

When you said

Bart · February 2, 2012, 3:00pm

Hi,

As mentioned, after the installation you have to manually add the RT config
to apache.

The installation won’t configure apache automatically for you, you can
probably use the include line Diaulas mentioned.

Other then that, it looks like you’ve done the installation the Ubuntu way
(which is ok), all you need to do now is configure Apache.

Let us know if it worked.

– Bart

Op 2 februari 2012 15:12 schreef Diaulas Castro <
diaulas.castro@intersolution.inf.br> het volgende:

borngunners · February 2, 2012, 10:13pm

Now RT is coming up, but I noticed couple of things:

It seems like RT is using sqlite database instead of mysql. (How do you make RT to use mysql? If I make the changes in RT_SiteConfig.pm to use mysql, will it work?)
How do I make RT to work without the /rt path in the RT_SiteConfig.pm?

Also, If I want to configure LDAP authentication, how do I go about accomplishing that since the installation was done via aptitude?
Last but not least I have a backup database from another RT server version 3.8, which was mysql database, how do I go about restoring the database from the fron-end, if possible?

Thanks,From: Bart bart@pleh.info
To: rt-users rt-users@lists.bestpractical.com
Sent: Thu, Feb 2, 2012 10:00 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hi,

As mentioned, after the installation you have to manually add the RT config to apache.

The installation won’t configure apache automatically for you, you can probably use the include line Diaulas mentioned.

Other then that, it looks like you’ve done the installation the Ubuntu way (which is ok), all you need to do now is configure Apache.

Let us know if it worked.

– Bart

Did you put /rt in the end of url? Ex: http://192.168.1.1/rt

Have Ubuntu 11.10 installed 3 weeks ago, don’t remember to change apache conf except of including this line:

Include "/etc/request-tracker4/apache2-modperl2.conf”

Last 2 lines of my conf:

tail -n2 /etc/apache2/sites-available/default
Include “/etc/request-tracker4/apache2-modperl2.conf”

De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com]Em nome de Borngunners
Enviada em: quinta-feira, 2 de fevereiro de 2012 12:04
Para: bart@pleh.info; rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] Help installing RT4 on Ubuntu

I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don’t know what else to do regarding the installing RT. I seriously need help with detail how-to, please…

Thanks,

From: Bart bart@pleh.info
To: rt-users rt-users@lists.bestpractical.com
Sent: Wed, Feb 1, 2012 10:06 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hi,

Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?)

At least, it looks that way. If the above is what you’ve done then I really don’t understand the external auth errors your getting, a clean installation doesn’t contain external auth…

My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point).

Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ).

I assume you’ve documented all your steps up to this point, could you show us exactly what you’ve done? (you’ve installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig).

– Bart

Okay. Now I have try to reinstall RT again and so far these are the configurations I have:

root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt4
User: rtuser
DBA: root
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Granting access to rtuser@‘localhost’ on rt4.
Done.
Now inserting RT core system objects.
Done.
[Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles
functionality. You should set the ‘active’ property of the ‘default’
lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Config.pm:766)
Now inserting data.
[Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:826)
[Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn’t find row (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:956)
Done inserting data.
Done.

Apache configuration:

ErrorLog /opt/rt4/var/log/apache2.error
TransferLog /opt/rt4/var/log/apache2.access

LogLevel debug

AddDefaultCharset UTF-8

DocumentRoot “/opt/rt4/share/html”

Order allow,deny
Allow from all

   SetHandler perl-script 


   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server

    use Plack::Handler::Apache2;
    Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");

</Perl>

thanks,

From: Kevin Falcone falcone@bestpractical.com
To: rt-users rt-users@lists.bestpractical.com

Sent: Mon, Jan 30, 2012 6:32 pm
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hello Falcone,
I have tried the config as stated. This is the message I receive after
starting apche:
root@helpdesks:/etc/apache2# /etc/init.d/apache2 start
* Starting web server
apache2
[Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table
‘rt4.Users’ doesn’t
exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line

(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)

You don’t appear to have created the RT database.

When you said

borngunners · February 6, 2012, 5:03pm

I have successfully installed RT4.0.5 and seems to be able to bring it up via the web… I did receive a warning error message after reloading apache:

root@helpdesks:/etc/apache2/sites-available# /etc/init.d/apache2 reload

Reloading web server config apache2 [Mon Feb 6 16:54:32 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles
functionality. You should set the ‘active’ property of the ‘default’
lifecycle and add transition rules; see RT_Config.pm for documentation. (/opt/rt4/sbin/…/lib/RT/Config.pm:766)
[ OK ]
Please advice on what to do to correct this message.

Thanks,
HajiFrom: Bart bart@pleh.info
To: rt-users rt-users@lists.bestpractical.com
Sent: Thu, Feb 2, 2012 10:00 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hi,

As mentioned, after the installation you have to manually add the RT config to apache.

The installation won’t configure apache automatically for you, you can probably use the include line Diaulas mentioned.

Other then that, it looks like you’ve done the installation the Ubuntu way (which is ok), all you need to do now is configure Apache.

Let us know if it worked.

– Bart

Did you put /rt in the end of url? Ex: http://192.168.1.1/rt

Have Ubuntu 11.10 installed 3 weeks ago, don’t remember to change apache conf except of including this line:

Include "/etc/request-tracker4/apache2-modperl2.conf”

Last 2 lines of my conf:

tail -n2 /etc/apache2/sites-available/default
Include “/etc/request-tracker4/apache2-modperl2.conf”

De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Em nome de Borngunners
Enviada em: quinta-feira, 2 de fevereiro de 2012 12:04
Para: bart@pleh.info; rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] Help installing RT4 on Ubuntu

I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don’t know what else to do regarding the installing RT. I seriously need help with detail how-to, please…

Thanks,

From: Bart bart@pleh.info
To: rt-users rt-users@lists.bestpractical.com
Sent: Wed, Feb 1, 2012 10:06 am
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hi,

Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?)

At least, it looks that way. If the above is what you’ve done then I really don’t understand the external auth errors your getting, a clean installation doesn’t contain external auth…

My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point).

Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ).

I assume you’ve documented all your steps up to this point, could you show us exactly what you’ve done? (you’ve installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig).

– Bart

Okay. Now I have try to reinstall RT again and so far these are the configurations I have:

root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt4
User: rtuser
DBA: root
Now creating a mysql database rt4 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs.
Granting access to rtuser@‘localhost’ on rt4.
Done.
Now inserting RT core system objects.
Done.
[Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles
functionality. You should set the ‘active’ property of the ‘default’
lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Config.pm:766)
Now inserting data.
[Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:826)
[Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn’t find row (/var/tmp/rt-4.0.4/sbin/…/lib/RT/Handle.pm:956)
Done inserting data.
Done.

Apache configuration:

ErrorLog /opt/rt4/var/log/apache2.error
TransferLog /opt/rt4/var/log/apache2.access

LogLevel debug

AddDefaultCharset UTF-8

DocumentRoot “/opt/rt4/share/html”

Order allow,deny
Allow from all

   SetHandler perl-script 


   PerlResponseHandler Plack::Handler::Apache2
   PerlSetVar psgi_app /opt/rt4/sbin/rt-server

    use Plack::Handler::Apache2;
    Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");

</Perl>

thanks,

From: Kevin Falcone falcone@bestpractical.com
To: rt-users rt-users@lists.bestpractical.com

Sent: Mon, Jan 30, 2012 6:32 pm
Subject: Re: [rt-users] Help installing RT4 on Ubuntu

Hello Falcone,
I have tried the config as stated. This is the message I receive after
starting apche:
root@helpdesks:/etc/apache2# /etc/init.d/apache2 start
* Starting web server
apache2
[Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table
‘rt4.Users’ doesn’t
exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line

(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)

You don’t appear to have created the RT database.

When you said