Hi,
I know there's a Debian package available, but installing by hand gives
you a much better idea of what is going where and why and will help you trouble
shooting later on.
SKIP the database setup, section 3.2.4, STOP following the
guide and do the steps below instead.
On the Windows box make a dump of the otrs database. I have no idea how
mysql works on windows, but try "mysqldump -u root -p otrs >win-otrs.sql" and
provide it with the database password when requested. Copy the resulting
win-otrs.sql file to your Linux box.
Back on Linux, create a new database (many of these commands will prompt
you for the root password to mysql):
mysqladmin -u root -p create otrs
Setup the permissions for OTRS to use that database:
mysql -u root -p mysql
Import your dump from windows (this one will prompt you for the otrs
password you assigned above)
mysql -u otrs -p otrs < win-otrs.sql
That's the database taken care of. Now you need to copy the OTRS settings
from the Windows installation. That's quite easy, though. In Win-OTRS go to
Admin -> SysConfig and click on the "Download" button on the
left.
Back on Linux, Admin -> SysConfig and select your saved file in
"Load Settings".
That should
do it. If you have created one or more themes on the Windows box, you need to
copy them over manually. They're in Kernel/Output/HTML. Copy them to the same
place on the Linux box and set the correct permissions on
them.
--
Lars
I was wondering if anyone has a how-to or a list of steps to follow
when migrating OTRS from Windows to Linux. I've tried once
unsuccessfully. I've currently got a working OTRS 2.2.6 system running
on windows. It was installed with the win32 installer available on www.otrs.org. My target system is Ubuntu
8.04. I'm no linux expert but I can figure out enough to get
myself in trouble.
On my first attempt, I installed mysql-server,
mysql-client, and otrs2_2.0.4p01-18_all.deb. Then I copied all the
var/articles over, copied the entire contents of the mysql/data folders (yes
this is probably a bad idea, but since the machine is dedicated to otrs I
didn't see any need to preserve anything), and the kernel/config.pm and kernel/config folder. Then I
manually edited config.pm to change the "c:\"
paths to /usr/share/otrs. After restarting mysql, I was able to access
the otrs database with the otrs account and password without a problem, but I
started getting file-system permission errors trying to access
/var/lib/otrs/article when i fired up otrs... this is where I started getting
confused, because the application runs in apache2 as www-data but the files
and directories are all owned by otrs:www-data.. it seemed to me that it ought
to be running with suexec as otrs, but that was beyond the scope of my
understanding. Instead I tried granting www-data write permission to the
var/articles directories. That got around the permission problem, and
I'm able to reach the otrs logon page but it wont accept my credentials.
I think I just totally borked this entire setup so I think I need to
start fresh with some step by step documentation. If anyone can provide
some assistance or some step by step instructions I would greatly appreciate
it!
Thanks