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:
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...
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?
So I stop my existing database and try to start ServiceDesk...
This is from boot.log:
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!
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!