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/"
<Location /otrs>
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
