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.

Last updated on: March 27th, 2017
at 05:08 AM Europe/London

The Secret Is: Don’t Use Go-Daddy!

Just seen a post on the Spacial forums where a user wants to set his request function up. His website is hosted by Go Daddy.

Click To Enlarge

The secret is that he will never get SAM Broadcaster requests working as Godaddy don’t have the SQL port 3306 or the other port 1221 open. I’m sure someone will point this out to him eventually.

That’s just one reason to avoid Godaddy!

Another is the fact the owner thinks it’s good fun to go around and kill defenseless wild animals!

 
Shop around for a webhost that allows you to have ports open so you can have a working website would be my advice. Go Daddy suck big time.

Update 30/01/2014: GoDaddy owns up to role in epic Twitter account hijacking. Read about that here

Update 16/04/2014: Yet again GoDaddy are doing stuff you wouldn’t believe if it wasn’t so outrageous. They’ve given someone’s identifiable information to a spammer troll who has then used it against the person.

You can read all about that Here

The Secret is: Do NOT use Go Daddy!!

Last updated on: March 26th, 2017
at 23:33 PM Europe/London

Remote Database Issues?

Every now and then we see users having database issues with RadioDJ.

Then in the next sentence they then mention they are attempting to use a remote MySQL database. STOP IT!

“Trying to run RadioDJ on remote database is a really bad idea, All you need is the slightest connection problem or packet loss and bang it will freeze/crash the program & believe me that’s the last thing you need when running stream”

 
A database running on the same machine is a lot better for performance among other things.

If you need to access the database from outside (i.e request page) then all you need to do is make sure that port 3306 is open on your computer firewall and router.

If you do run RadioDJ with a remote database please don’t start kicking and screaming because something isn’t working right.

Don’t say we didn’t try and warn you…

Last updated on: March 31st, 2017
at 12:59 PM Europe/London

Port 3306 Blocking Stop It!

So a user comes onto the RadioDJ forums saying he is having issues working the WordPress plugin. Then goes onto to say his webhost is HostGator.

That is unfortunately where his problem lies. Hostgator don’t allow connections on port 3306 (SQL).

Click to enlarge

I know of several other companies that actively block ports 3306. Why are these hosts blocking access via these ports.

What are they so afraid of?

Users pay for a service and can’t have much useful content if these ports aren’t open.

Go Daddy are citing “Security Issues” as to why they don’t open port 3306. Strange when other hosting companies are only to happy to let you have access to the SQL port.

My advice is always ask questions before purchasing web space of a provider. Avoid web hosts like HostGator and GoDaddy as they will never open those ports. Even if you ask nicely.

Shop around, Search Google there are webhosts out there who will give you access to the SQL port. So you can have Now playing info and requests on your website.

Last updated on: March 27th, 2017
at 03:01 AM Europe/London

Lazy Sql Programming.

I keep seeing posts on the Spacial forums from users having headaches with SAM Broadcaster and MySQL.

This is nothing new I’ve written about the SQL structure in SAM Broadcaster being badly written before.

Users are being told they cannot use MySQL 5.6 and have to use 5.5 instead.

That just screams Lazy SQL programming to me.

The SAM Broadcaster SQL tables haven’t really changed for over 6 years and the database is prone to crashing.

Where as RadioDJ will work with MySQL 5.6 and the tables don’t crash like the SAM Broadcaster ones do.

If you are having SQL headaches with SAM do yourself a favour uninstall SAM and Install RadioDJ free radio automation software instead & you’ll be better off in the long run.

The database tables in RadioDJ rarely seem to crash or need a repair.

We know of users who have had RadioDJ running for 6 months without so much as a hiccup.

People need to wise up to the fact Spacial Audio just take people’s money for their software without actually doing any work to upgrade their SQL tables or the software itself.

My advice as always is Don’t pay Spacial Audio $$$ for software that isn’t up to the job.

You won’t get any support when things go badly wrong with your database.

Last updated on: March 26th, 2017
at 18:32 PM Europe/London

Translate ยป