Help! I can’t install RadioDJ

Installing RadioDJ the easy way…

We know it can be daunting and scary installing new software for the first time, Especially if you aren’t used to using software that requires a database, but don’t panic it’s not as difficult as you might think.

If you follow these easy steps and have a bit of patience then you should have the program up and running in no time.

1) Starting off with a FRESH clean install of your Windows operating system is a good bet.

Don’t forget to backup files before you reformat Windows.

Once you’ve reinstalled Windows and downloaded & installed all required security patches/updates/drivers for your PC then you can begin the process of installing and configuring RadioDJ.

Read the full article

Maria DB & RadioDJ

We came across MariaDB after a user posted on the RadioDJ forums that they were using it with RadioDJ.

Click to enlarge

I have to admit I was surprised by how easy it was to install. It’s a lot more straight forward than the normal MySQL installer.

If you have previously had MySQL installed you will need to see this article about removing it as a service

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

2) Open the file & Install and run when Windows prompts.

3) On the licence agreement screen check the accept box. Click next.

Read the full article

Why bother with Winamp

I can’t help but notice that people are still using Winamp to stream their Internet radio stations with.

Click to enlarge

While Winamp is a great little media player things have moved on in the last 10 years.

There is now better software than Winamp to stream your Internet radio station with namely Radio DJ free radio automation software.

Why bother with Winamp when you have RadioDJ For FREE?

RadioDJ Free radio automation download

RadioDJ is a great automation program especially for someone just starting out in the world of Internet radio.

Click To enlarge

You can find guides and plugins for RadioDJ Here.

You will also need MariaDB installing to run RadioDJ.

There’s also a tutorial On how to setup Maria DB here.

If you get stuck setting things up help & support is always available through the Radio DJ community forums which can be found Here.

So why bother with Winamp? Make the switch to Radio DJ it will make your online radio station sound more professional.

RadioDJ Database Backup

You can now automatically backup your RadioDJ database at a specified hour of the day with the database setup tool.

Click to enlarge

It’s pretty straight forward to set up.

1) Download RadioDJ
2) Unzip the RadioDJ folder to C:\ outside of the program folder.
3) Open up databasesetup.exe inside the setup folder.
4) Install RadioDJ and install your database as per these Instructions
5) In the second tab set the time and location where you want to backup your database.
6) Minimise to the tray and leave it running.

 
It should automatically backup your database at the hour you set it to backup.

Top Tip: Try making sure you backup your database to an external drive. A small 1GB USB pen drive will do. That way you don’t have to worry about losing your database data in the unlikely event of your database crashing or a power cut.

 

Firebird Database SAM Broadcaster

Firebird Database SAM Broadcaster

SAM Broadcaster comes with four different options of database install.

Firebird – MySQL – PostgreSQL – MSSQL

 
Sam Broadcaster Database options

Of the 4 different database options that come with SAM Broadcaster, Firebird appears to be the most unstable database of the four options.

We often see someone complaining that the Firebird database in SAM Broadcaster has crashed on them.

The Firebird database only allows you to load a maximum of 20,000 songs into SAM Broadcaster. So it’s not great if you have a huge music collection.

The MySQL database in SAM Broadcaster doesn’t fare much better as that’s also prone to crashing or becoming corrupted especially if SAM crashes without warning.

The SQL database in RadioDJ is far more stable and lets you load as many songs as you need.

rdj-background-min

RadioDJ Free radio automation download

Plus the MySQL server & database in RadioDJ isn’t that difficult to setup.

The database in RadioDJ seems to be a lot more robust and stable. (It’s over 2 years since we last rebuilt of database from scratch)

You can find a tutorial on how to setup an SQL server here.

The Firebird database that comes with SAM Broadcaster just isn’t fit for purpose. It’s just another reason to stop buying software from Spacial Audio.

RadioDJ Track(s) from SQL Query

Recently the developer of RadioDJ introduced a feature into the program called “Track(s) from SQL Query” which can be used along side track rotations.

SQLQueryrotation

It makes programming songs from the “Top 40” “Most played” or “Two songs by the same artist” a piece of pie.

Read the full article

SAM Broadcaster Bad SQL!

SAM Broadcaster Bad SQL!

We keep seeing posts on the Spacial Audio Facebook pages and forums from people saying that their queue list table within MySQL has crashed and is corrupted.

This is usually the MySQL error that people get.

“Mysqli prepare error: Table ‘samdb_mysql.queuelist’ doesn’t exist”

 
Or they simply just get a message like this.

Click to enlarge

This is nothing new and has been a major issue within SAM Broadcaster SQL tables ever since SAM Broadcaster v2.7.9

It just goes to show that the SQL structure wasn’t written properly in the first place.

In Fact it’s a really badly written SQL structure which is prone to going wrong when you least want it too.

SAM Broadcaster’s badly coded SQL structure was also another reason we ditched the program and started using RadioDJ

We have yet to have a major database crash with RadioDJ.

There is a simple fix for this.

1) Uninstall SAM Broadcaster from your computer.
2) Flush all SAMDB Tables from your SQL server.
3) Install RadioDJ and run the database setup utility.
4) Start enjoying running a stress free radio station!

 
You will be a lot happier in the long run.

There is just no need for SAM Broadcaster to have badly coded SQL tables!

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 »