RadioDJ - Free Radio Automation Software Forum

Remote setup instructions

AndyDeGroo

Remote setup instructions
« on: September 19, 2014, 05:32:42 AM »
This is a short guide on how to connect WordPress plugin to remote RadioDJ database. I'm open for suggestions on how to improve this post.

First of all you have to understand if your RadioDJ database is accessible from public IP address. That depends on your ISP and how your RadioDJ computer is connected to internet. Fastest way to check your public IP address is to ask google.

If you already have a persistent public IP address, use that for connection. Otherwise, if your IP address is dynamic, you'll have to use some dynamic DNS service like dyn.com (not free) or or free dtdns.com and use the new hostname to connect.
If the computer is behind a router, you'll have to forward port 3306 on the router.

If connecting on port 3306 still fails, you'll have to check if your hosting provider allows external MySQL connections. If not and they can't allow exceptions, you'll have to use some safe port like 21(FTP), 80(HTTP) or 443(HTTPS) to connect to RadioDJ database. That is easier to do if the PC is behind a router and you can forward one of mentioned external ports to 3306 on LAN.

MySQL root user is not allowed to connect remotely by default. That is a security measure. When verifying connection setting you might get an error: Access denied for user 'root'@'123.45.67.89' (using password: YES). You should set up a dedicated MySQL user without host restrictions. Something like radiodj@% should suffice. And please remember to use secure password. Bruteforce attacks on public MySQL servers are common.

If you are still having problems connecting, please post what massages you get when you verify database setting on RadioDJ plugin options page.
« Last Edit: September 19, 2014, 08:51:55 AM by DJ Garybaldy »

Offline gnfb

Re: Remote setup instructions
« Reply #1 on: November 08, 2014, 12:38:04 AM »
This is a short guide on how to connect WordPress plugin to remote RadioDJ database. I'm open for suggestions on how to improve this post.

First of all you have to understand if your RadioDJ database is accessible from public IP address. That depends on your ISP and how your RadioDJ computer is connected to internet. Fastest way to check your public IP address is to ask google.

If you already have a persistent public IP address, use that for connection. Otherwise, if your IP address is dynamic, you'll have to use some dynamic DNS service like dyn.com (not free) or or free dtdns.com and use the new hostname to connect.
If the computer is behind a router, you'll have to forward port 3306 on the router.

If connecting on port 3306 still fails, you'll have to check if your hosting provider allows external MySQL connections. If not and they can't allow exceptions, you'll have to use some safe port like 21(FTP), 80(HTTP) or 443(HTTPS) to connect to RadioDJ database. That is easier to do if the PC is behind a router and you can forward one of mentioned external ports to 3306 on LAN.

MySQL root user is not allowed to connect remotely by default. That is a security measure. When verifying connection setting you might get an error: Access denied for user 'root'@'123.45.67.89' (using password: YES). You should set up a dedicated MySQL user without host restrictions. Something like radiodj@% should suffice. And please remember to use secure password. Bruteforce attacks on public MySQL servers are common.

If you are still having problems connecting, please post what massages you get when you verify database setting on RadioDJ plugin options page.

On this very subject:

My server is at home
I am trying to install and connect heidi so i can then connect the wordpress plugin
I have a mysql server running and working at home on localhost and port 8000 forwarded for the internet radio access

Do i have to setup prort forwarding for 3306 as well?

AndyDeGroo

Re: Remote setup instructions
« Reply #2 on: November 08, 2014, 01:17:37 AM »
My server is at home
I am trying to install and connect heidi so i can then connect the wordpress plugin
I have a mysql server running and working at home on localhost and port 8000 forwarded for the internet radio access

Do i have to setup prort forwarding for 3306 as well?

You'd have to set up port forwarding only if you need to access it from and external web server. I f your web server is on the same PC as MySQL server, you can use localhost or 127.0.0.1 loopback address for connecting to MySQL.

Offline 70vibe-FM

  • *
  • 18
  • 70's rock!
    • 70vibe-fm.com
Re: Remote setup instructions
« Reply #3 on: July 02, 2015, 10:06:39 AM »
Hi there,
It took me months of figuring out how to get my webserver to connect with local host, which has a dynamic IP. This post has solved all my issues and would like to thank you.  :cool: :cool: :cool:
Mark