Thank you for the advice; I followed your instructions and I have now migrated OTRS from Windows to Linux successfully. I only had a few minor issues to contend with, which were no big deal. Rather than create the otrs database, I ran through the otrs first-time setup and let it create the database. (Other than the mysql and otrs passwords, I left bogus information in there). After it was done, and I was able to log in and upload my saved configuration via the SysConfig page, which replaced my bogus information. After that was done, I used mysqladmin to drop the otrs database (maybe there is a more elegant way to empty all the tables in a database), then created it again, and imported my mysqldump data into it. The only other issue was the /var/article directory which contains all the email attachments. I used rsync for windows (cygwin) to sync the entire var directory to Linux, then I moved the article directories into the proper place (/opt/otrs/var/articles) and ran the SetPermssions script which fixed up all the attachments. Thanks for the help, you were exactly right that it was worth going through the steps to get a better understanding how it all relates. Thanks again Ron On Fri, May 23, 2008 at 3:02 AM, Lars Jørgensen wrote:

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' <%27otrs%27@%27localhost%27>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:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *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. 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

_______________________________________________ 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/