Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
rt [2008/10/09 19:54]
93.103.1.78 + http://rtvm.tehcorner.com/rt38/
rt [2009/05/25 00:35] (current)
Line 2: Line 2:
  
 ===== Scripts ===== ===== Scripts =====
 +
 +
 +
 +
 +
 +
 +
  
 ===== Optimization ===== ===== Optimization =====
Line 13: Line 20:
  
 ===== Howto ===== ===== Howto =====
 +
 +==== Request tracker 3.8.2 (Ubuntu-LTS) + NGINX + PostgreSQL ====
 +
 +<​code>​
 +wget http://​download.bestpractical.com/​pub/​rt/​release/​rt-3.8.2.tar.gz
 +tar -xvzf rt-3.8.2.tar.gz
 +make testdeps
 +make fixdeps
 +apt-get install mysql-client
 +apt-get install libdbd-pg-perl libclass-dbi-pg-perl
 +make testdeps
 +make install
 +</​code>​
 +
 +**Upgrading PostgreSQL database**
 +  ## make upgrade
 +   /​opt/​rt3/​sbin/​rt-setup-database --dba rtuser --prompt-for-dba-password --action upgrade
 +
 +=== NGINX setup ===
 +
 +Useful links:
 +   * http://​wiki.bestpractical.com/​view/​FastCGIConfiguration ​
 +   * http://​www.nginx.eu/​nginx-fcgi/​nginx-fcgi.txt
 +   * http://​www.nginx.eu/​nginx-fcgi.html
 +
 +**FCGI/init script**
 +<code bash|f /​etc/​init.d/​rt.fcgi>​
 +#!/bin/sh
 +
 +RTPATH=/​opt/​rt3
 +RTUSER=www-data
 +#​FCGI_SOCKET_PATH=$RTPATH/​var/​fastcgi
 +FCGI_SOCKET_PATH=/​tmp/​rt.fcgi
 +
 +case $1 in
 +    start)
 +        echo -n "​Starting RT: mason_handler.fcgi"​
 +        cd $RTPATH
 +        export FCGI_SOCKET_PATH
 +        su $RTUSER -c "​$RTPATH/​bin/​mason_handler.fcgi"​ &
 +        echo
 +        ;;
 +
 +    stop)
 +        echo -n "​Stopping RT: "
 +        PIDS=`ps axww | awk '/​[m]ason_handler.fcgi/​ { print $1}'`
 +        if [ -n "​$PIDS"​ ]
 +        then
 +            echo -n kill -TERM $PIDS
 +            kill $PIDS
 +            echo
 +        else
 +            echo RT not running
 +        fi
 +        ;;
 +
 +    restart|force-reload)
 +        $0 stop
 +        $0 start
 +        ;;
 +
 +    *)
 +        echo "​Usage:​ /​etc/​init.d/​rt { stop | start | restart }"
 +        exit 1
 +        ;;
 +esac
 +</​code>​
 +
 +**nginx request-tracker vhost config**
 +<code |f /​etc/​nginx/​sites-enable/​rt>​
 +server {
 +        listen ​  80;
 +        server_name ​ rt.xxxx.si;
 +        access_log ​ /​var/​log/​nginx/​rt.xxxx.si-access.log;​
 +
 +        location ​ / {
 +                fastcgi_pass ​ unix:/​tmp/​rt.fcgi;​
 +                #​fastcgi_x_powered_by off; # default on
 +                fastcgi_param ​  ​DOCUMENT_ROOT ​  /​opt/​rt3/​share/​html;​
 +                fastcgi_param ​  ​SCRIPT_FILENAME /​opt/​rt3/​share/​html$fastcgi_script_name;​
 +                fastcgi_param ​  ​PATH_TRANSLATED /​opt/​rt3/​share/​html$fastcgi_script_name;​
 +                fastcgi_param ​  ​SCRIPT_NAME ​ $fastcgi_script_name;​
 +                fastcgi_param ​  ​QUERY_STRING ​   $query_string;​
 +                fastcgi_param ​  ​CONTENT_TYPE ​   $content_type;​
 +                fastcgi_param ​  ​CONTENT_LENGTH ​ $content_length;​
 +                fastcgi_param ​  ​REDIRECT_STATUS 200;
 +                fastcgi_param ​  ​SERVER_ADDR ​    ​$server_addr;​
 +                fastcgi_param ​  ​SERVER_PORT ​    ​$server_port;​
 +                fastcgi_param ​  ​SERVER_PROTOCOL $server_protocol;​
 +                fastcgi_param ​  ​SERVER_SOFTWARE "​nginx/​0.3.15";​
 +                fastcgi_param ​  ​GATEWAY_INTERFACE ​      "​CGI/​1.1";​
 +                fastcgi_param ​  ​SERVER_NAME ​    ​$server_name;​
 +                fastcgi_param ​  ​SERVER_NAME ​    ​$server_name;​
 +                fastcgi_param ​  ​REQUEST_URI ​    ​$request_uri;​
 +                fastcgi_param ​  ​REQUEST_METHOD ​ $request_method;​
 +                fastcgi_param ​  ​REMOTE_USER ​    ​$remote_user;​
 +                fastcgi_param ​  ​REMOTE_ADDR ​    ​$remote_addr;​
 +                fastcgi_param ​  ​REMOTE_PORT ​    ​$remote_port;​
 +        }
 +        location ~* .+\.(html|js|css)$ ​ {
 +                fastcgi_pass ​ unix:/​tmp/​rt.fcgi;​
 +                #​fastcgi_x_powered_by off; # default on
 +                fastcgi_param ​  ​DOCUMENT_ROOT ​  /​opt/​rt3/​share/​html;​
 +                fastcgi_param ​  ​SCRIPT_FILENAME /​opt/​rt3/​share/​html$fastcgi_script_name;​
 +                fastcgi_param ​  ​PATH_TRANSLATED /​opt/​rt3/​share/​html$fastcgi_script_name;​
 +                fastcgi_param ​  ​SCRIPT_NAME ​ $fastcgi_script_name;​
 +                fastcgi_param ​  ​QUERY_STRING ​   $query_string;​
 +                fastcgi_param ​  ​CONTENT_TYPE ​   $content_type;​
 +                fastcgi_param ​  ​CONTENT_LENGTH ​ $content_length;​
 +                fastcgi_param ​  ​REDIRECT_STATUS 200;
 +                fastcgi_param ​  ​SERVER_ADDR ​    ​$server_addr;​
 +                fastcgi_param ​  ​SERVER_PORT ​    ​$server_port;​
 +                fastcgi_param ​  ​SERVER_PROTOCOL $server_protocol;​
 +                fastcgi_param ​  ​SERVER_SOFTWARE "​nginx/​0.3.15";​
 +                fastcgi_param ​  ​GATEWAY_INTERFACE ​      "​CGI/​1.1";​
 +                fastcgi_param ​  ​SERVER_NAME ​    ​$server_name;​
 +                fastcgi_param ​  ​SERVER_NAME ​    ​$server_name;​
 +                fastcgi_param ​  ​REQUEST_URI ​    ​$request_uri;​
 +                fastcgi_param ​  ​REQUEST_METHOD ​ $request_method;​
 +                fastcgi_param ​  ​REMOTE_USER ​    ​$remote_user;​
 +                fastcgi_param ​  ​REMOTE_ADDR ​    ​$remote_addr;​
 +                fastcgi_param ​  ​REMOTE_PORT ​    ​$remote_port;​
 +        }
 +       
 +        location /​NoAuth/​images/​ {
 +                alias /​opt/​rt3/​share/​html/​NoAuth/​images/;​
 +        }
 +}
 +</​code>​
 +
 +=== adding RTFM ===
 +
 +**Download RTFM**
 +
 +   tar -xzvf rtfm.tar.gz
 +
 +Install and patch the database
 +
 +   cd RTFM-2.4.0 ​
 +   perl Makefile.PL ​
 +   make install ​
 +   make initdb
 +
 +add follwing line to /​opt/​rt3/​etc/​RT_SiteConfig.pm
 +   ​Set(@Plugins,​qw(RT::​FM));​
 +
 ====  Changing user pref "​Illegal value for EmailAddress"​==== ====  Changing user pref "​Illegal value for EmailAddress"​====
 If you try to change your email and RT returns you an error **"''​Illegal value for EmailAddress''"​** means that this email address is already in the database. Workaround: If you try to change your email and RT returns you an error **"''​Illegal value for EmailAddress''"​** means that this email address is already in the database. Workaround:
rt.txt ยท Last modified: 2009/05/25 00:35 (external edit)
CC Attribution-Noncommercial-Share Alike 4.0 International
Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0 ipv6 ready