<font color='black' size='2' face='Arial, Helvetica, sans-serif'><font color="black"><font size="2"><font face="Arial, Helvetica, sans-serif">Now RT is coming up, but I noticed couple of things:<br>
1. 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?)<br>
2. How do I make RT to work without the /rt path in the RT_SiteConfig.pm?<br>
<br>
Also, If I want to configure LDAP authentication, how do I go about accomplishing that since the installation was done via aptitude?<br>
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?<br>
<br>
<br>
Thanks,<br>
</font></font></font><font color="black" face="Arial, Helvetica, sans-serif" size="2">
<div> <br>
</div>
<div> <br>
</div>
<div> <br>
</div>
<div style="font-family:arial,helvetica;font-size:10pt;color:black">-----Original Message-----<br>
From: Bart <bart@pleh.info><br>
To: rt-users <rt-users@lists.bestpractical.com><br>
Sent: Thu, Feb 2, 2012 10:00 am<br>
Subject: Re: [rt-users] Help installing RT4 on Ubuntu<br>
<br>
<div id="AOLMsgPart_2_c0c079e2-7aec-466c-ad1f-4a5e5ae99b13">
Hi,
<div><br>
</div>
<div>As mentioned, after the installation you have to manually add the RT config to apache.</div>
<div><br>
</div>
<div>The installation won't configure apache automatically for you, you can probably use the include line Diaulas mentioned.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Let us know if it worked.</div>
<div><br clear="all">
-- Bart<br>
<br>
<br>
<div class="gmail_quote">Op 2 februari 2012 15:12 schreef Diaulas Castro <span dir="ltr"><<a __removedlink__384550944__href="mailto:diaulas.castro@intersolution.inf.br">diaulas.castro@intersolution.inf.br</a>></span> het volgende:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="PT-BR">
<div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US">Did you put /rt in the end of url? Ex: <a target="_blank" __removedlink__384550944__href="http://192.168.1.1/rt">http://192.168.1.1/rt</a><u></u><u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US">Have Ubuntu 11.10 installed 3 weeks ago, don’t remember to change apache conf except of including this line:<u></u><u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"> Include "/etc/request-tracker4/apache2-modperl2.conf”<u></u><u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US">Last 2 lines of my conf:<u></u><u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US">tail -n2 /etc/apache2/sites-available/default<u></u><u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US">Include "/etc/request-tracker4/apache2-modperl2.conf"<u></u><u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"></VirtualHost><u></u><u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;font-family:" lang="EN-US"><u></u> <u></u></span></div>
<div class="MsoNormal"><b><span style="font-size:10.0pt;font-family:">De:</span></b><span style="font-size:10.0pt;font-family:"> <a __removedlink__384550944__href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a> [mailto:<a __removedlink__384550944__href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>]
<b>Em nome de </b>Borngunners<br>
<b>Enviada em:</b> quinta-feira, 2 de fevereiro de 2012 12:04<br>
<b>Para:</b> <a __removedlink__384550944__href="mailto:bart@pleh.info">bart@pleh.info</a>; <a __removedlink__384550944__href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<b>Assunto:</b> Re: [rt-users] Help installing RT4 on Ubuntu<u></u><u></u></span></div>
<div>
<div class="h5">
<div class="MsoNormal"><u></u> <u></u></div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">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....<br>
<br>
Thanks,<u></u><u></u></span></div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:">-----Original Message-----<br>
From: Bart <<a __removedlink__384550944__href="mailto:bart@pleh.info">bart@pleh.info</a>><br>
To: rt-users <<a __removedlink__384550944__href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><br>
Sent: Wed, Feb 1, 2012 10:06 am<br>
Subject: Re: [rt-users] Help installing RT4 on Ubuntu<u></u><u></u></span></div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">Hi,
<u></u><u></u></span></div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?)<u></u><u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">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...<u></u><u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point).<u></u><u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ).<u></u><u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">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).<u></u><u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"><br clear="all">
-- Bart<br>
<br>
<u></u><u></u></span></div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">Op 31 januari 2012 20:36 schreef Borngunners <<a __removedlink__384550944__href="mailto:borngunners@aol.com">borngunners@aol.com</a>> het volgende:<u></u><u></u></span></div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">Okay. Now I have try to reinstall RT again and so far these are the configurations I have:<br>
<br>
<a __removedlink__384550944__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 <a target="_blank" __removedlink__384550944__href="http://helpdesks.uhc.umd.edu">helpdesks.uhc.umd.edu</a>><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 <u></u><u></u></span></div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><br>
PerlResponseHandler Plack::Handler::Apache2<br>
PerlSetVar psgi_app /opt/rt4/sbin/rt-server<u></u><u></u></span></div>
</div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"> </Location><br>
<Perl> <u></u><u></u></span></div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><br>
use Plack::Handler::Apache2;<br>
Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");<u></u><u></u></span></div>
</div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"> </Perl><br>
</VirtualHost><br>
<br>
<br>
thanks,<u></u><u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
<div>
<div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:">-----Original Message-----<br>
From: Kevin Falcone <<a __removedlink__384550944__href="mailto:falcone@bestpractical.com">falcone@bestpractical.com</a>><br>
To: rt-users <<a __removedlink__384550944__href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><u></u><u></u></span></div>
</div>
<div>
<div class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:">Sent: Mon, Jan 30, 2012 6:32 pm<br>
Subject: Re: [rt-users] Help installing RT4 on Ubuntu<u></u><u></u></span></div>
</div>
<div>
<div>
<div>
<pre><tt><span style="">On Mon, Jan 30, 2012 at 05:11:54PM -0500, Borngunners wrote:<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> Hello Falcone,<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> I have tried the config as stated. This is the message I receive after <u></u><u></u></span></tt></pre>
<pre><tt><span style="">starting apche:<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> root@helpdesks:/etc/apache2# /etc/init.d/apache2 start<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> * Starting web server<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> apache2<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> [Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table <u></u><u></u></span></tt></pre>
<pre><tt><span style="">'rt4.Users' doesn't<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> exist at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line <u></u><u></u></span></tt></pre>
<pre><tt><span style="">587.<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)<u></u><u></u></span></tt></pre>
<pre><tt><span style=""><u></u> <u></u></span></tt></pre>
<pre><tt><span style="">You don't appear to have created the RT database.<u></u><u></u></span></tt></pre>
<pre><tt><span style=""><u></u> <u></u></span></tt></pre>
<pre><tt><span style="">When you said<u></u><u></u></span></tt></pre>
<pre><tt><span style=""><u></u> <u></u></span></tt></pre>
<pre><tt><span style="">> > On Thu, Jan 26, 2012 at 12:02:28PM -0500, Borngunners wrote:<u></u><u></u></span></tt></pre>
<pre><tt><span style="">> > > I have installed RT 4 on ubuntu and have tested the web after<u></u><u></u></span></tt></pre>
<pre><tt><span style=""><u></u> <u></u></span></tt></pre>
<pre><tt><span style="">What did you do to install RT? It'd be great if you looked through<u></u><u></u></span></tt></pre>
<pre><tt><span style="">the README and compared the steps to the notes about what you did.<u></u><u></u></span></tt></pre>
<pre><tt><span style=""><u></u> <u></u></span></tt></pre>
<pre><tt><span style="">-kevin<u></u><u></u></span></tt></pre>
</div>
</div>
</div>
<div>
<div>
<pre><tt><span style="">--------<u></u><u></u></span></tt></pre>
<pre><tt><span style="">RT Training Sessions (<a target="_blank" __removedlink__384550944__href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>)<u></u><u></u></span></tt></pre>
<pre><tt><span style="">* Boston </span></tt><tt><span style="font-family:">�</span><span style=""> March 5 & 6, 2012<u></u><u></u></span></tt></pre>
</div>
</div>
</div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><br>
--------<br>
RT Training Sessions (<a target="_blank" __removedlink__384550944__href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>)<br>
* Boston — March 5 & 6, 2012<u></u><u></u></span></div>
</div>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"><u></u> <u></u></span></div>
</div>
</div>
<div>
<pre style="background:white"><tt><span style="">--------<u></u><u></u></span></tt></pre>
<pre style="background:white"><tt><span style="">RT Training Sessions (<a target="_blank" __removedlink__384550944__href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>)<u></u><u></u></span></tt></pre>
<pre style="background:white"><tt><span style="">* Boston </span></tt><tt><span style="font-family:">�</span><span style=""> March 5 & 6, 2012<u></u><u></u></span></tt></pre>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div>
<br>
</div>
</div>
<!-- end of AOLMsgPart_2_c0c079e2-7aec-466c-ad1f-4a5e5ae99b13 -->
<div id="AOLMsgPart_3_c0c079e2-7aec-466c-ad1f-4a5e5ae99b13" 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 __removedlink__384550944__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_c0c079e2-7aec-466c-ad1f-4a5e5ae99b13 -->
</div>
</font></font>