Hi, Follow this guide on the Linux installation: http://doc.otrs.org/2.2/en/html/x354.html
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 GRANT ALL ON otrs.* TO 'otrs'@'localhost'<mailto:'otrs'@'localhost'> DEFINED BY 'somepassword'; 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". Follow the guide (http://doc.otrs.org/2.2/en/html/x354.html) from section 3.2.5 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 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of dohboy Sent: Thursday, May 22, 2008 5:29 PM To: User questions and discussions about OTRS.org Subject: [otrs] How do I migrate OTRS from Windows to Linux? 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<http://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<http://config.pm> and kernel/config folder. Then I manually edited config.pm<http://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
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
