Changing the Default SQL port RadioDJ

Changing the Default SQL port RadioDJ:

When it comes to a SQL server running along side RadioDJ some users have found that their webhosts won’t allow connections to the default SQL port 3306.

If you need a specific port open for this to work it’s probably a wise idea to email your website host support department asking if it’s OK to use a non standard port for use with SQL. Otherwise you may get into trouble with them.

If your webhost doesn’t allow mysql connections on a standard 3306 port then you need to get creative by changing the default SQL port in the SQL server.

It’s not as scary as it sounds. Honestly it shouldn’t take too much to sort it.

1) Backup your RadioDJ database using the database setup tool.

2) Uninstall the copy of MySQL that is on your PC. Making sure you have Removed MySQL as a service.

3) Download the Maria DB MSI installer for your version of Windows Here

4) Install Maria DB when you get to this window.

click to enlarge

Change the TCP port number to the one you want to use.

You will also need to make sure the port you want to use is open on your broadband router as well as your website hosts firewall.

5) Click next to install MariaDB with this port. Also make sure you enable “Root access from remote machines”.

Open “task Manager” and see if mysql is running as a service (mysqld.exe) if that’s running then you’ve done it right.

6) If you then open the databasesetup.exe within RadioDJ and enter your server details for the server like this.

Click to enlarge

The most important bit is to have the server IP like this 127.0.0.1:3307

3307 is just an example of a non standard port. This should be the port number you chose when setting Maria DB up.

7) Click on Validate and if you’ve got the SQL connection details correct you should see your SQL server online like the above picture.

8) While still in database setup make sure you restore the RadioDJ backup that you made at the beginning of the tutorial.

9) Start RadioDJ and check everything is restored.

Now we move onto changing the details in the configuration files of the RadioDJ Demo script

You need to edit the serv_inc.php file to look like this.

Click to enlarge

Where its says YourIP you need to put in your External IP address.

Next to that you need the port number so it would look something like this: 145.238.23.54:3307

Then just enter the rest of the connection details and if all goes to plan the demo web script should be working on your website.

If your website host still won’t allow you to have certain ports open for requests. Then it’s time to find a website host who does or rent your own VPS.

Important: You change ports at your own risk. We cannot be held responsible for anything that goes wrong while configuring things.
Translate »