<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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.<br>
<br>
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.<br>
<br>
<Location /rt><br>
Order allow,deny<br>
Allow from all<br>
<br>
SetHandler perl-script<br>
PerlResponseHandler Plack::Handler::Apache2<br>
PerlSetVar psgi_app /opt/rt4/sbin/rt-server<br>
</Location><br>
<Perl><br>
use Plack::Handler::Apache2;<br>
Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");<br>
</Perl><br>
<br>
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)<br>
<br>
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.<br>
<br>
Hope this helps,<br>
Matt<br>
<br>
On 01/31/2012 11:36 AM, Borngunners wrote:
<blockquote
cite="mid:8CEAE66CC35259E-1B14-1DEE4@webmail-m076.sysops.aol.com"
type="cite"><font color="black" face="Arial, Helvetica,
sans-serif" size="2"><font color="black" face="Arial, Helvetica,
sans-serif" size="2">
<div> Okay. Now I have try to reinstall RT again and so far
these are the configurations I have:<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:root@helpdesks:/var/tmp/rt-4.0.4#">root@helpdesks:/var/tmp/rt-4.0.4#</a> make initialize-database<br>
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib
sbin/rt-setup-database --action init
--prompt-for-dba-password<br>
In order to create or update your RT database, this script
needs to connect to your mysql instance on localhost as
root<br>
Please specify that user's database password below. If the
user has no database<br>
password, just press return.<br>
<br>
Password:<br>
Working with:<br>
Type: mysql<br>
Host: localhost<br>
Name: rt4<br>
User: rtuser<br>
DBA: root<br>
Now creating a mysql database rt4 for RT.<br>
Done.<br>
Now populating database schema.<br>
Done.<br>
Now inserting database ACLs.<br>
Granting access to rtuser@'localhost' on rt4.<br>
Done.<br>
Now inserting RT core system objects.<br>
Done.<br>
[Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus
configuration has been replaced by the new Lifecycles<br>
functionality. You should set the 'active' property of the
'default'<br>
lifecycle and add transition rules; see RT_Config.pm for
documentation.
(/var/tmp/rt-4.0.4/sbin/../lib/RT/Config.pm:766)<br>
Now inserting data.<br>
[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)<br>
[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)<br>
[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)<br>
Done inserting data.<br>
Done.<br>
<br>
<br>
Apache configuration:<br>
<VirtualHost helpdesks.uhc.umd.edu><br>
ErrorLog /opt/rt4/var/log/apache2.error<br>
TransferLog /opt/rt4/var/log/apache2.access<br>
# LogLevel debug<br>
<br>
AddDefaultCharset UTF-8<br>
<br>
DocumentRoot "/opt/rt4/share/html"<br>
<Location /><br>
Order allow,deny<br>
Allow from all<br>
<br>
SetHandler perl-script<br>
PerlResponseHandler Plack::Handler::Apache2<br>
PerlSetVar psgi_app /opt/rt4/sbin/rt-server<br>
</Location><br>
<Perl><br>
use Plack::Handler::Apache2;<br>
Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");<br>
</Perl><br>
</VirtualHost><br>
<br>
<br>
thanks,<br>
</div>
<div> <br>
</div>
<div> <br>
</div>
<div
style="font-family:arial,helvetica;font-size:10pt;color:black">-----Original
Message-----<br>
From: Kevin Falcone <a class="moz-txt-link-rfc2396E" href="mailto:falcone@bestpractical.com"><falcone@bestpractical.com></a><br>
To: rt-users <a class="moz-txt-link-rfc2396E" href="mailto:rt-users@lists.bestpractical.com"><rt-users@lists.bestpractical.com></a><br>
Sent: Mon, Jan 30, 2012 6:32 pm<br>
Subject: Re: [rt-users] Help installing RT4 on Ubuntu<br>
<br>
<div id="AOLMsgPart_1_e904b5bd-e9e8-4c8f-9eb2-1e04d70869ba"
style="margin: 0px;font-family: Tahoma, Verdana, Arial,
Sans-Serif;font-size: 12px;color: #000;background-color:
#fff;">
<pre style="font-size: 9pt;"><tt>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
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
</tt></pre>
</div>
<!-- end of AOLMsgPart_1_e904b5bd-e9e8-4c8f-9eb2-1e04d70869ba -->
<div id="AOLMsgPart_3_e904b5bd-e9e8-4c8f-9eb2-1e04d70869ba"
style="margin: 0px;font-family: Tahoma, Verdana, Arial,
Sans-Serif;font-size: 12px;color: #000;background-color:
#fff;">
<pre style="font-size: 9pt;"><tt>--------
RT Training Sessions (<a moz-do-not-send="true" href="http://bestpractical.com/services/training.html" target="_blank">http://bestpractical.com/services/training.html</a>)
* Boston � March 5 & 6, 2012
</tt></pre>
</div>
<!-- end of AOLMsgPart_3_e904b5bd-e9e8-4c8f-9eb2-1e04d70869ba -->
</div>
</font></font>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">--------
RT Training Sessions (<a class="moz-txt-link-freetext" href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>)
* Boston — March 5 & 6, 2012</pre>
</blockquote>
<br>
</body>
</html>