Did You know: RadioDJ has the ability to take online listener requests? Well it does …

RadioDJ free radio automation software

We thought we would do a short tutorial on how to setup RadioDJ Online Requests.

To get the request system working with RadioDJ you need to do the following.

1) Create a new MySQL user that isn’t “root” You can find out how to do that HERE

Tip When setting MariaDB up choose a strong password with lots of number and symbols and write it down!

2) Make sure you have RadioDJ installed and port 3306 unblocked on your router, firewall or even antivirus etc..

3) Place the Plugin_Requests.dll file in the plugin folder within RadioDJ. (This file can be found in the disabled plugins folder)

4) Download the RadioDJ Request Demo web script or WordPress Plugin

“Please Note: The RadioDJ WordPress plugin may not function properly with the new v2.0.0 database as columns have been changed in the database with the upgrade”

5) Upload the demo script file to your web-server via FTP or upload the WordPress plugin to your WP installation.

Then edit the details in the config.php file so it points to your MySQL database and also points to Your external IP address.

(In the WordPress plugin activate and then click on RadioDJ settings from the settings menu)

In config.php in the website template you need to complete these details:

Example Code

########### edit database settings #########
$dataip = "127.0.0.1"; // External IP address
$database = "admin_radiodj"; // Your Database name
$username = "admin_radiodj";  // Your database username
$userpass = "Mysupersecretpassword"; // Your database password

Please don’t copy the example code from this page make sure you enter you server information in config.php between the ” ” marks.

Important: You can change the MySQL ports at your own risk! Be warned some website hosting providers may ban you if you use an alternative port.

You also need to set your Timezone correctly to match the time zone of your server/computer.

Subcategory numbers can be found in the Database Subcategory table use HeidiSQL or other SQL editing tools to find out this information.

6) Make sure your web host/server host allows connections on the port you want to use (Usually the same port as SQL 3306). Any good web-host will have these ports available. Ask before you sign up to any service.

“Companies such as GoDaddy/Hostgator block the required ports and will not open them no matter how much you ask you will have to shop around for a provider who does, any reputable company will answer your questions before you sign up.”

7) If you Opened the SQL port 3306 on your broadband router. Make sure that it points to the internal IP of the computer of the machine running RadioDJ (e.g 192.168.0.3) and the MySQL server.

If you have done all the above and configured everything properly, You should now be able to take online requests from your website.

Support for this web script isn’t available AFAIK, Its a basic starting point for you to code a website around.

“This script is for entertainment purposes only, Use/modify at own risk”

Note: This script won’t work if you have a website host that blocks port 3306 connections (Although you can specify a different port for it in the script) You change/use alternative ports at your OWN RISK!

The RadioDJ request demo has been tested on PHP 7.2 and Apache 2.2 July 2018

Last updated on: 8th August 2018
at 12:51 PM Europe/London

  Translate