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 <[EMAIL PROTECTED]> 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' <[EMAIL PROTECTED]>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. 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/ >
_______________________________________________ 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/
