What Database Issues?

I asked my partner to find out when we actually installed MariaDB on our PC that we run RadioDJ from.

Turns out we’ve had MariaDB installed since June 2014.

Yesterday we upgraded it to the latest version. Which went smoothly after we’d remembered to shut mysqld.exe down as a service.

Click to enlarge

In the last 15 months that we’ve been using MariaDB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden shutdown of the computer.

That was easily fixed using Heidisql to repair the tables.

“We could never say the same about another well known automation program. The database in that would crash when you least expected it and was royal pain to fix again. That’s if you were lucky enough to retrieve your database as that program never had a proper database backup tool.

 
We take a regular daily backups of our database with the RadioDJ database setup tool.

The database in RadioDJ is far more robust and tends not to go wrong unless something major happens on the PC running it.

On the whole MariaDB seems to work like a star.

We’d like to thank the development team at MariaDB for making such a wonderfully stable SQL server program.

What Database Issues? I wouldn’t have a stable reliable music stream without it!

RadioDJ of course has to take some of the credit.

“RadioDJ and MariaDB are the most reliable and stable pieces of software we’ve EVER used and we’ve used lots of other databses”

 
So next time you’re looking to install a database for use with a radio automation program such as RadioDJ

RadioDJ Free radio automation download

@MariaDB is the database program EVERYONE should be using.

RadioDJ Free Radio DJ Automation Software.

What is RadioDJ?

RadioDJ is a free radio studio automation program for use by any DJ or radio station.

Click to enlarge

You can even run multiple Shoutcast/Icecast radio stations if you want using third party virtual audio cables (VACS).

It can also be used as a home entertainment system for music. (Which is what we currently use it for)

Is RadioDJ really free?

Yes! It’s 100% Free with no nasty hidden fees or catches despite what certain software/hosting companies try claim in their blog posts. No keys, activation or patches needed to work the full program.

Will RadioDJ work on Windows 10?

Yes RadioDJ works rather well on Windows 10 with very few issues. Unlike other radio automation programs that have “compatibility” issues.

Read the full article

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 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

Installing RadioDJ on an Apple Mac

Another question I often get asked is will RadioDJ run on an Apple Mac?

Short answer: No as RadioDJ is written in .NET for Windows.

However there is a way to Installing RadioDJ on an Apple Mac but (unfortunately) it does involve a copy of Windows to be installed.

Download & install Oracle Virtual Box

1) Make a virtual disc image from a windows OS installer (.iso) give it a minimum of 1GB RAM.

You can find out how to do that from the Virtualbox Wiki page

2) Install the VirtualBox Extension Pack this can be found on the same download page as the Virtualbox downloads.

3) Install an SQL database server such as Maria DB

A guide to installing MariaDB can be found Here

4) Download RadioDJ and unzip this folder in the download below

RadioDJ Free radio automation download

(If the link isn’t working right click & “Save link as”)

5) Unzip RadioDJ onto the root (C\:) drive of your Windows install and give the folder full read/write privileges.

6) Install the RadioDJ database from the “databasesetup.exe” file inside the setup folder

7) Install Virtual Audio cables you can find these by searching Google

If all has gone to plan you should be good to start importing your music into RadioDJ and once you have that sorted you should be good to start streaming.

It’s really not that difficult to use RadioDJ and still be able to control it on a Mac.

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 »