[otrs] OTRS installation on Debian Woody

Although the installation instructions for a Debian installation are not that complicated, I noticed that there was no documented that pointed to what packages need to be installed to meet OTRS dependencies (perl, gd, etc.) So perhaps documenting our installation will help others trying to install OTRS on Debian Woody systems. I've documented our experience with the installation, and how it seemed to work for us. I make no guarantees, other than following these steps got our installation working with Apache-SSL as the web server, Postgresql as the database, and Debian Woody as the operating system. It is based on OTRS RC3. NOTE: These instructions will only mark where installation for Debian differs from the OTRS Manual section 1.2 "Using the tar.gz file to install OTRS on any Linux/Unix platform" subsections 1.2.1 - Install, 1.2.2 - Database, and 1.2.3- Webserver. 1.2.1. Install -------------- 1. This Debian package listing is for an Apache-SSL, Postgresql, Perl, and the appropriate Perl GD and DBI modules: apache-common apache-ssl libapache-dbi-perl libapache-mod-perl libapache-request-perl libapache-session-perl libdigest-md5-perl libmime-perl libnet-dns-perl postgresql postgresql-client postgresql-contrib postgresql-dev libgd-graph-perl libgd-perl libgd-text-perl libgd-tools libgd1 libgd2 libgd2-dev cron sendmail procmail iamerican // or your favorite ispell language dictionary ispell // so that spell-checking works After installing all of these packages "bin/otrs.checkModules" should return OK for all modules (except DBD::mysql, but we aren't going to be using MySQL, so this shouldn't be marked as required). The "perl -cw" instructions for checking module installation did not work for me. 2. "usermod -G www-data otrs" - Apache runs as user/group www-data on Debian 3. chown -R otrs.users /opt/otrs 5. changes to /etc/apache-ssl/httpd.conf (we are using mod_perl): Alias /otrs/ "/opt/otrs/bin/cgi-bin/" SetHandler perl-script PerlHandler Apache::Registry Options ExecCGI PerlSendHeader On </Location> 6. Database setup: Do not user installer.pl since we are not using MySQL 1. As user "postgres" issue a "creatuser -P otrs", say yes to allow creation of other users and databases if you want otrs to be database superuser (not required). Write down your selected password, you will need to provide it when configuring Config.pm in 7. 2. Login as user "otrs", issue a "createdb otrs" 3. Load table schema definitions into otrs database: "psql otrs < /opt/otrs/install/database/OpenTRS-schema.postgresql.sql" 4. Load initial test data into database: "psql otrs < /opt/otrs/install/database/initial_insert.sql" 5. Change /etc/postgresql/pg_hba.conf and modify the following line to allow local connections from user www-data: host all 127.0.0.1 255.0.0.0 trust 7. Config file ($HOME/Kernel/Config.pm), make the following changes (configure the database section with the appropriate password): $Self->{SecureMode} = 1; # Since we are not using MySQL disable #$Self->{DatabaseDSN} ="DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; 8. File Permissions: "/opt/otrs/bin/setPermissions.sh /opt/otrs otrs www-data users www-data" 1.2.2 - See Step 6 above 1.2.3 - See Step 5 above 11. Cronjobs for the OTRS user Make sure you run "/opt/otrs/bin/Cron.sh start" as user otrs. Comment out with a "#" in the crontab the section for fetchmail and postmaster_pop3. Uncomment the daily graphics cron so you can get a graph generated daily. This is it! all messages directed to otrs@localhost should now be piped into OTRS, so configure to your heart's content. -Eddie