Install into pre existing MySql installation

[rtorres]

I am moving our Helpdesk to a new VM server that hosts a few other apps that use MySQL currently with xamp. When I try to install OTRS I get the message: "Port 3306 is already in use. MySQL is probably already innstalled on your machine. OTRS installs it's own instance and will need an open port 3306." When I click OK the installer just exits.

How do I install OTRS on an pre existing MySQL installation? Or is there an install override to alow me to specify the MySQL information?

Thanks

[crythias]

You can install from source and follow the INSTALL/README instructions to load schema.

[rtorres]

So since I have a working copy of the system can I just copy the install directory to the new server and reconfirgure the config.pm to match the new server?

[crythias]

For the same schema/version of OTRS, yes.

[rtorres]

Sweet. OK will give this a shot thanks. Is there an easy way to backup and restore the OTRS database? Or is it a straight copy mdf file to other location?

[crythias]

It's preferred to do mysqldump/mysql read, though. binary copies of database files aren't explicitly supported.

[rtorres]

Ok having a bit of trouble here. I read the Install readme and it has direction but for LInux OS only and states to download the installer for Windows. Also read the instructions in Readme.database (Works for Windows) and Readedme.webserver which is made direclty for Linux (unless those are not the correct Install/Readme you are refering to?). When I try to access the installation on the new server I get this:
Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
Path I am ttrying to use is this: http://WebServer:81/otrs/index.pl
Accessing this address: http://WebServer:81/otrs/ just returns a listing of the web directory which is to be expected.

What has been done so far:
- Moved OTRS folder (C:\Program FIles\OTRS\*) and contents within to new server directory xampp\htdocs\OTRS
- Backed up the OTRS DB and imported in on the new server using PHPMYAdmin
- Created OTRS account and password
- Updated the Config.pm to reflect the correct user name, password, db name and password
- All LDAP stuff is still correct
- Nothing is hard coded to the old server

Questions:
- in Config.pm $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; I suspect this is incorrect because it is now using xampp w/apache and mysql that from within it. Do I need to change the DatabaseDNS to reflect some other path?
- $Self->{'DatabaseHost'} = 'localhost'; Should 'localhost' say something different in regards to the DatabaseDSN?
- I also noticed that in the original directory 'C:\Program Files\OTRS\otrs4win\Scripts' there are a few batch files that start, stop and restart Perl, Cron and Apache. Do I need to install strawberry perl if I already have perl 5.x on the new system? Apache is already installed in the xampp directory so do not need to reinstall it.
- Do I need to start with a fresh source instead of moving the exsiting OTRS installation to new server? If so where can I download the complete source?

[crythias]

Basically, you probably at this point should just install on a different, dedicated box.

what did you do about apache config? Did you copy that to conf.d or sites-enabled?

The basic answers to your questions sum up to: if you have perl, apache, mysql, then you only need the otrs source and needed perl modules. Then, follow the instructions as if you're installing from source.