In the unlikely event of the RadioDJ database going wrong due to a power outage it’s easily fixed using HeidiSQL
Saving your RadioDJ configuration settings is also easy you just backup the RadioDJ program folder to another location (USB Drive/External Drive) after you have all your settings the way you want them.
It’s rare for RadioDJ to actually crash or go wrong.
We can honestly say hand on heart that we’ve never had RadioDJ crash on us while recording a show/mix or even during a live show in the 5+ years since we discovered the program.
The smart DJ’s and radio station owners are now starting to steer away from using SAM Broadcaster.
Just seen a post on the RadioDJ forums from a long time user of the program complaining that the program keeps breaking on him.
“My install(s) of RadioDJ have been breaking. I have had to reinstall and redo all of the install(s) over the past 2 weeks. My track rotations seem to burp and ignore the music and just play VT’s or Sweepers. I am not sure what the heck is going on but it is becoming a pain in the rump. I am wondering if it is my SQL?”
He then goes to on to state that he’s never ran RadioDJ as “Administrator”
“Never have had to start it as an admin ever. That is something Marius has never stated here to do.”
We think you will find that Marius tells EVERYONE to run RadioDJ with full “Administrator” privileges. Its not a RadioDJ problem its a Windows security rule.
Being a long term user of RadioDJ you’d have thought he would have already known this?
You need to run the program as administrator for it work properly otherwise it’s going to cause you “issues” somewhere along the line.
It’s simple enough to mark the RadioDJ.exe with administrator privileges.
TIP: Right Click on the RadioDJ.exe file go to Properties>Shortcut>Advanced>Tick the box that says “Run as Administrator”>Apply>OK & close
That way RadioDJ will always run as administrator when you start the program.
The original problem may indeed lie with the fact this user wasn’t running the program as advised.
PEBKAC (Problem Exists between keyboard and chair)
We’ve always ran RadioDJ as advised and we rarely have any of the “issues” this user has described. I also suspect that the version of MySQL this user is using maybe the root cause of some of their problems as well.
It might be time to upgrade your SQL server to MariaDB?
We’ve had MariaDB installed for over a year now and it’s rare for us to have a problem with our database server.
If you’re not willing to take simple advice like this onboard then you really must have a small amount of knowledge about computers full stop.
“If you don’t have the option to run a program in administrator mode then you may need to ask an IT specialist or even your parents for advice.
Running RadioDJ as administrator isn’t exactly rocket science now is it?
An advert popped up on a forum a couple of days back for Shoutcast Streaming’s samPHPweb & samHTMLweb Web Hosting package.
Is it just me or does the advert actually sound like they only want to host your website if your a SAM Broadcaster user?
Doesn’t sound to me like they would host your website if you were using other software such as RadioDJ
Looking at the price of this website hosting service it’s not that expensive but you could probably do it yourself cheaper.
You could just set up a web server using WAMP on your home PC pointing your domain to your IP and take requests that way.
Or you could rent a VPS server from around $1.25 a month with a hell of a lot more storage space.
Hosting your own website gives you much more control over things especially when you run your own VPS.
You control what ports you have open etc. Unlike SAM Broadcaster RadioDJ only requires 1 port (SQL 3306) to be open for requests.
I started out with an Apache web server on my PC about 11 years ago and it worked great at the time.
In this day and age most broadband connections are pretty stable and fast.
So it shouldn’t be a problem hosting your own website on a home PC.
If you do go a for a VPS, have a look round. There are some pretty but choose what’s best for you and your location.
We have a self managed VPS and it’s usually rock solid and performs like a star. However every server has its limits and sometimes there are outages beyond our control.
It’s really not that hard running your own website. Once you learn how to get it working properly you’ll wonder why you ever paid a website host in the first place.
Remember when it comes to learning stuff like setting up your own web server or VPS Google is your friend not your enemy!
The information is out there if you search hard enough.
If Shoutcast Streaming is only pandering to SAM Broadcaster PHP/HTML users then that would be a shame as I could have pointed a few users of RadioDJ in his direction.
N.B: Running a home web server is dependant on external factors such as your upload & download speeds if you have a poor broadband connection then it may be a better option to look at hosting your website on a VPS.
Before anyone has a go at me!
I’m just pointing out that there are other “alternatives” when it comes to hosting a website/server. You don’t have a monopoly on website hosting!
SAM Broadcaster vs RadioDJ which piece of software wins?
Someone asked me to do a comparison between the 2 pieces of software a while back.
SAM Broadcaster Pro/Studio (Streaming Audio Manager) Price: $299/$699
Requires Online Activation: Yes
Requires Registration Keys: Yes
Supported OS: Windows 7/8/10 (Older 4.x.x versions won’t work on Windows 8/10)
Supported File types: mp3/wma/ogg/flac/m4a/aac/wav
Streaming: Built in encoders (Which are prone to buffering)
Supported Databases: MySQL/Firebird/PostgreSQL/MS SQL
Stability: Very poor reliability. (Users frequently report the program crashes or freezes without warning)
Ease of use: Can be difficult to setup & there are complicated (PAL) scripts to learn if you want advanced automation.
Support: After you buy the product there is very poor customer service
Restrictions: You can only run 1 radio station per SAM Broadcaster licence & with certain versions of SAM you can only stream to one service.
RadioDJ (Free Radio Automation Software) Price: $0.00 FREE/Gratis
Requires Online Activation: No
Requires Registration Keys: No
Supported OS: Windows 7/8/10 (Works brilliantly on Windows 10)
Supported File Types: mp3/wma/ogg/flac/m4a/wav/ac3 (other formats can be added by using BASS add-ons from un4seen.com)
Streaming: Shoutcast/Icecast streaming can be done via a plugin or alternatively you can use a stand alone encoding program.
Supported Databases: MySQL (The database in RadioDJ has been kept simple)
Stability: RadioDJ can run for weeks and months without requiring a restart.
Ease of Use: Once setup RadioDJ is easy to use, like most software it can take time to get used to what the program does.
Support: If you run into an issue with RadioDJ you can get great support on the Community Forums
Restrictions: NONE! You can use the software where you want when you want.
So there you have it. We’ve compared the 2 pieces of software just as someone asked us to.
We still come to the same conclusion everytime.
“We feel SAM Broadcaster isn’t worth the $299 Spacial Audio charge for the program. We really can’t see where the ‘Value’ is”
Actually did we need to write a blog post to tell people that?
In case you haven’t already noticed, SQL tends to allow some pretty insecure permissions by default, allowing root access from any computer.
This is a big problem, especially if you have port forwarding configured on your router to your SQL instance.
However, you can easily create new users using any management interface, so we’ll do it with HeidiSQL
1) Launch HeidiSQL and sign in as root.
2) Select Tools > User Manager
First of all, we’ll remove root access for remote hosts.
There will be several accounts listed for root, from various locations. Select the root account that has just a % sign in the host column. This allows root access from any location, including on the internet and isn’t recommended. On the right hand side, select the drop down and pick the local network that matches your LAN IP range (e.g. 192.168.%)
This makes sure that when you’re on your local network, you can still log in as root. Click save.
Next we’ll add a new restricted user Click add user.
3) Choose a new username (Fred), and pick and repeat a secure password,
4) From host % (Access from anywhere)
5) In the “Allow access to” section, expand (But don’t select by ticking the box) global privileges
6) Choose select and insert
Click Save and Close.
You can now configure your web scripts and WordPress plugins to use this new username and password.
This new user is intended for use for scripts only. It doesn’t have the required permissions to run RadioDJ itself, you can either set up a new user in the same way with extra privileges, or use the root account now we’ve removed access for remote hosts.
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.
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