OTRS MySQL InnnoDB

I ran into some issues with MySQL Foreign Key errors apon updating to the latest OTRS.
As our DB was old, it was using MyISAM which was the default for MYSQL 3.
I have changed all the OTRS tables to InnoDB

OTRS cron to check mail

I have put the otrs cron into
/etc/cron.d

Some information on cron available at
http://www.linuxtopia.org/online_books/suse_linux_guides/SLES10/suse_enterprise_linux_server_installation_admin/sec_suse_pakete.html

Upgrading OTRS 2.2.8 to 2.3.3 on SLES 10

Download the rpm package from otrs.org


The instructions on upgrading can be found in opt/otrs

Stop all services
"rcotrs stop-force"
Backup everything - the otrs direcotry (opt/otrs and the mysql DB.

run the rpm

run the mysql upgrade scripts (I used the mysql query administrator to do this)
otrs/scripts/DBUpdate-to-2.3.mysql
i ran into errors when doing this and had to manually step through each line of the sql script.


Run the migration script (you need ot run as the OTRS user, not as root)
$OTRS_HOME/scripts/DBUpdate-to-2.3.pl

however i ran as root and when finsihed run
otrs/bin/SetPermissions.sh

run the 2nd mysql update script
$OTRS_HOME/scripts/DBUpdate-to-2.3.post.mysql.sql

Restart the OTRS services
rcotrs restart-force

OTRS on SLES 10SP2 32bit

Migrating OTRS 2.28 to a new server
then upgrading to OTRS 2.3

To install OTRS in SLES 10sp2 you need to instal some extra perl-gd packages.
The packages can be installed form the SLES10SDK-x86 SP2 DVDs
I managed to find an online repository using google search.

Once you have the packages you must manually install all the "Perl-gd-*" packages
for some reason they wont install automatically (well they wouldnt for me when i attempted to install otrs from the rpm file)

Anyways, once all the perl-gd packages are installed you can then install otrs.
double click on the rpm and away you go.
You will be prompted to install some extra packages, this will be done automatically.

Cron Job - cron tabs

the otrs cron file disappeared from
/var/spool/cron/tabs
so i had to add the file back in there.
I wonder if i have this setup wrong or was it just a once off thing?
anyways i will monitor it and if it happens again i will reconfigure the cron.

SLES 10 sp1 OTRS - Cron Jobs

after setting up a new OTRS installation (www.otrs.org)
I had to setup a cron job to pop emails from our server to check for new tickets.
This website helped - http://en.opensuse.org/SUSE_Package_Conventions/Cron_Jobs

Cron Job to setup was listed on the otrs website
i added in

# --
# cron/postmaster_pop3 - postmaster_pop3 cron of the OTRS
# Copyright (C) 2002-2003 Martin Edenhofer 
# --
# $Id: installation-and-basic-configuration.xml,v 1.10 2006/09/07 13:15:07 cs Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY.
# --
# fetch emails every 10 minutes
*/10 * * * * $HOME/bin/PostMasterPOP3.pl >> /dev/null
# --

to the file
/var/spool/cron/tabs/otrs