SD6 MySQL Issues

SD6 MySQL Issues

Since we're having problems getting SD7 to work on Linux, we've got version 6 up and running, but having some issues with the database...

We have an instance of MySQL already running, and if we try to start ServiceDesk we get the following message:

Server is starting. This may take a couple of minutes ...
This evaluation copy is valid for 29 days
Unable to start MySQL server on port 3306. Please free the port.



So I stop my existing MySQL Server and start ServiceDesk, it works fine.

I want ServiceDesk to do one of the following:

A: Use my existing database (this is what I really want)
B: Run on port 33366 out of the way of my existing database (acceptable compromise)

So I create a "servicedesk" user for my existing database and try running the changeDBServer.sh script to point to my database...

************************************************************
DB Server Setup wizard
************************************************************

1) Setup MYSQL Server
2) Setup MSSQL Server
3) Quit
Go to [1/2/3] : 1

Host : localhost
Port : 3306
User : servicedesk
Password : servicedesk

DB Server status : [ Available ]
---- Creating Database------
Database successfully created !!!
----------------------------
My SQl Sever configuration added successfully



















Noticed the password is echo'd to the terminal, which is a bit sloppy, but other than that everything looks good so far...

So now I should be able to start the server, and it should user the database we've just set up above, right?

Server is starting. This may take a couple of minutes ...
This evaluation copy is valid for 29 days
Unable to start MySQL server on port 3306. Please free the port.



So I stop my existing database and try to start ServiceDesk...

Server is starting. This may take a couple of minutes ...
This evaluation copy is valid for 29 days
Database creation failed. Stopping the Server. Please refer logs for more information



This is from boot.log:

20:52:13,387 DEBUG [ServerInfo] db.home: /usr/local/ServiceDesk/mysql

20:52:13,578 DEBUG [SARDeployer] deployed classes for file:/usr/local/ServiceDesk/server/default/lib/mysql_connector.jar

20:52:14,237 DEBUG [UnifiedClassLoader] Added url: file:/usr/local/ServiceDesk/server/default/lib/mysql_connector.jar, to ucl: org.jboss.mx.loading.UnifiedClassLoader3@13e58d4{ url=file:/usr/local/ServiceDesk/





So far it looks like the changeDBserver.sh script has updated the username and password, but is still trying to start the local database!

NOTE: The other ticket I have open on version 7, I was using root with no password when trying to connect to my existing database, I'll go now and try to replicate this error using changeDBserver.sh on version 7 if I specify a different username and password!