{"id":4,"date":"2007-08-10T00:14:33","date_gmt":"2007-08-10T00:14:33","guid":{"rendered":"http:\/\/tech.moosaico.com\/blog\/?p=4"},"modified":"2011-08-13T12:38:13","modified_gmt":"2011-08-13T12:38:13","slug":"request-tracker-in-ubuntu-using-mysql","status":"publish","type":"post","link":"https:\/\/thejoyofstick.com\/blog\/2007\/08\/10\/request-tracker-in-ubuntu-using-mysql\/","title":{"rendered":"Request Tracker in Ubuntu using MySQL"},"content":{"rendered":"<p>Being a proud user of Request Tracker 0.99 I thought it was time to try a modern version. I installed it in a Ubuntu 6.06 LTS with MySQL as the support rdbs. This synthetise two installation procedures ((http:\/\/wiki.bestpractical.com\/view\/UbuntuInstallGuide &amp; http:\/\/brucetimberlake.com\/linux\/rtinstall.html)) around there that were not so focused.<\/p>\n<p><strong>Installing the packages<\/strong><\/p>\n<pre lang=\"linux\">\r\nsudo apt-get install mysql-server\r\nsudo apt-get install request-tracker3.4<\/pre>\n<p>You may change for 3.6 if you&#8217;re using Ubuntu 7.04. Those two commands installed all I needed. However if you think that something is missing you can type it all.<\/p>\n<pre lang=\"linux\">sudo apt-get install request-tracker3.4 rt3.4-apache rt3.4-clients apache-doc postfix mysql-client mysql-common libdbd-mysql-perl<\/pre>\n<p><strong>Editing the RT configuration files<\/strong><\/p>\n<p>Go to the RT directory and start updating RT_SiteConfig.pm with the info from your site and\/or system.<\/p>\n<pre lang=\"linux\">cd \/etc\/request-tracker3.4\r\nvi RT_SiteConfig.pm<\/pre>\n<p>Change the defaults as you need along this lines.<\/p>\n<pre class=\"brush: perl; title: ; notranslate\" title=\"\">\r\nSet($rtname, 'rt.domain.tld);\r\nSet($DatabaseType, 'mysql');\r\n\r\nSet($DatabaseUser , 'rtuser');\r\nSet($DatabasePassword , 'wibble');\r\nSet($DatabaseName , 'rtdb');\r\n\r\nSet($WebBaseURL , &quot;http:\/\/rt.domain.tld&quot;);\r\n\r\nSet($DatabaseHost,'localhost');\r\nSet($DatabaseRTHost,'localhost');\r\n<\/pre>\n<p>Edit RT_Config.pm and RT_SiteModules.pm as you need. Don&#8217;t forget that these files must finish with 1;<\/p>\n<p><strong>Update RT lib directory<\/strong><\/p>\n<p>We must now store these customized files along the other RT libs.<\/p>\n<pre lang=\"linux\">\r\nsudo cp RT_Config.pm \/usr\/share\/request-tracker3.4\/lib\/RT\/Config.pm\r\nsudo cp RT_SiteConfig.pm \/usr\/share\/request-tracker3.4\/lib\/RT\/SiteConfig.pm\r\nsudo cp RT_SiteModules.pm \/usr\/share\/request-tracker3.4\/lib\/RT\/SiteModules.pm<\/pre>\n<p><strong>Database creation<\/strong><\/p>\n<pre lang=\"linux\">sudo \/usr\/sbin\/rt-setup-database-3.4 --action init \\\r\n        --dba rtuser --prompt-for-dba-password<\/pre>\n<p>Use the same password you defined in SiteConfig.pm<\/p>\n<p><strong>Apache configuration<\/strong><\/p>\n<p>Just create a new file for a virtual host. Change 10.0.0.1 for your IP address and costumize ServerName and ServerAdmin<\/p>\n<pre lang=\"linux\">sudo vi \/etc\/apache\/conf.d\/rt.conf<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nNameVirtualHost 10.0.0.1\r\n&lt;virtualhost 10.0.0.1:80&gt;\r\n    ServerName rt.domain.tld\r\n    ServerAdmin me@domain.tld\r\n    DocumentRoot \/usr\/share\/request-tracker3.4\/html\r\n    AddDefaultCharset UTF-8\r\n    PerlModule Apache::DBI\r\n    ErrorLog \/var\/log\/apache\/rt-error_log\r\n    CustomLog \/var\/log\/apache\/rt-access_log common\r\n    Include \/etc\/request-tracker3.4\/apache-modperl.conf\r\n    &lt;location&gt;\r\n        SetHandler perl-script\r\n    &lt;\/location&gt;\r\n&lt;\/virtualhost&gt;\r\n<\/pre>\n<p>Don&#8217;t forget to reload the apache server to read the new configuration<\/p>\n<pre lang=\"linux\">sudo \/etc\/init.d\/apache reload<\/pre>\n<p><strong>We made it!<\/strong><\/p>\n<p>Let&#8217;s connect and start creating users, groups, queues and moving tickets away. Point your browser to http:\/\/rt.domaind.tld (the address you&#8217;ve defined) and login using user <strong>root<\/strong> with password <strong>password<\/strong>. Change it right now!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Being a proud user of Request Tracker 0.99 I thought it was time to try a modern version. I installed it in a Ubuntu 6.06 LTS with MySQL as the support rdbs. This synthetise two installation procedures ((http:\/\/wiki.bestpractical.com\/view\/UbuntuInstallGuide &amp; http:\/\/brucetimberlake.com\/linux\/rtinstall.html))&hellip; <a href=\"https:\/\/thejoyofstick.com\/blog\/2007\/08\/10\/request-tracker-in-ubuntu-using-mysql\/\" class=\"more-link\">Continue Reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,4],"tags":[],"class_list":["post-4","post","type-post","status-publish","format-standard","hentry","category-apps","category-ubuntu"],"jetpack_shortlink":"https:\/\/wp.me\/pcmwlL-4","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/posts\/4","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/comments?post=4"}],"version-history":[{"count":4,"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/posts\/4\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/posts\/4\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/media?parent=4"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/categories?post=4"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thejoyofstick.com\/blog\/wp-json\/wp\/v2\/tags?post=4"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}