Configuring MSSQL Server
By default SupportCenter plus supports PostgreSQL database. To switch over to SQL server database, you need to configure SQL server to establish connection and start the server :
- Execute the changeDBServer.bat [ changeDBServer.sh for Linux or the command line option is changeDBServer.bat --console] file presented under the [SupportCenter_Home]/bin directory.
- This opens the Database Setup Wizard page.
- Fill in the details of the form to configure sql server.
- Server Type: Select the server type from the combo box. Say MS SQL.
- Host Name: Enter the IP Address/host name in which the database is available. The default host name is 'localhost'
- Port: Specify the port in the given text field. The default value is 1433.
- Database : By default the database name will be supportcenter in non-editable format.
- User Name: Specify the user name to login to the server in the given text field.
- Password: Specify the password for the username in the given text field.
- To check the availability of connection press the Test button. A pop up window pops up showing 'Connection Established' message.
- Click OK to proceed.
- Click Save button to save the SQL server settings.
Migrating Data from PostgreSQL to MSSQL
- Upgrade the SupportCenter server running with PostgreSQL application to latest build
- Start the Server [Important]
- Shutdown the server
- Go to [SupportCenter_Home]/bin
- Take a backup of the data of the mysql database [backUpData.bat or backUpData.sh]
- Run the script changeDBServer.bat
- Enter the MSSQL database details
- Start the Server [Important]
- Shutdown the Server
- Restore the backup [restoreData.bat and provide the backup file got from the earlier step as input]
- Start the server & the data from PostgreSQL should be restored to MSSQL
Configuring MySQL Server
By default SupportCenter plus supports PostgreSQL database. To switch over to MySQL server database, you need to configure MySQL server to establish connection and start the server :
- Execute the changeDBServer.bat [ changeDBServer.sh for Linux or the command line option is changeDBServer.bat --console] file presented under the [SupportCenter_Home]/bin directory.
- This opens the Database Setup Wizard page.
- Fill in the details of the form to configure mysql server.
- Server Type: Select the server type from the combo box. Say MySQL.
- Host Name: Enter the IP Address/host name in which the database is available. The default host name is 'localhost'
- Port: Specify the port in the given text field. The default value is 33356.
- Database : By default the database name will be supportcenter in non-editable format.
- User Name: Specify the user name to login to the server in the given text field.
- Password: Specify the password for the username in the given text field.
- To check the availability of connection press the Test button. A pop up window pops up showing 'Connection Established' message.
- Click OK to proceed.
- Click Save button to save the MySQL server settings.
Migrating Data from PostgreSQL to MySQL
- Upgrade the SupportCenter server running with PostgreSQL application to latest build
- Start the Server [Important]
- Shutdown the server
- Go to [SupportCenter_Home]/bin
- Take a backup of the data of the mysql database [backUpData.bat or backUpData.sh]
- Run the script changeDBServer.bat
- Enter the MySQL database details
- Start the Server [Important]
- Shutdown the Server
- Restore the backup [restoreData.bat and provide the backup file got from the earlier step as input]
- Start the server & the data from PostgreSQL should be restored to MySQL
Configuring remote PostgreSQL Server
If you are using a remote PostgreSQL server and do not want to use the inbuilt server
then perform the following :
- Select Server Type as PostgreSQL server. This opens the database wizard page.
- Specify the Host Name, Port, User Name & Password.
- Click Test button and check the availability of the connection.
- Once the Connection is Established, Save the details and start the server.
Troubleshooting Tips
PostgreSQL Connection Resolution
- Check if the PostgreSQL server is already running.
- Check if the server name or the port number is misspelt or incorrect.
- If the PostgreSQL server is running in a remote machine then there may be a firewall blocking the port number you have entered.
- If none of the above mentioned issues matches then contact your system administrator.
MS-SQL Connection Resolution
If connection is refused and an error is displayed by SQL Server as 'unable to connect to the server' then there could be following reasons :
- The server name is misspelt or the port number is incorrect
- If SQL Server is not configured to use TCP/IP, then enable TCP/IP from SQL Server's Network Utility app.
- If there is a firewall blocking the port 1433 on the server then you will be unable to connect to the server. To confirm the firewall block connect to TCP/IP use \"telnet <server_host>1433\"\n to confirm the block.
- SQL Server Instance is not currently supported by SupportCenter and will be available in our future release. You can also connect to SQL Server named instance once if you know the machine name and port of the named instance.
MySQL Connection Resolution
- Check if the MySQL server is already running.
- Check if the server name or the port number is misspelt or incorrect.
- If the MySQL server is running in a remote machine then there may be a firewall blocking the port number you have entered.
- If none of the above mentioned issues matches then contact your system administrator.
