Author Topic: Connecting RadioDJ On Another PC To MYSQL  (Read 27753 times)

FreerunMedia

  • Hero Member

  • Offline
  • *****
  • 722
  • Personal Text
    Proud user of RadioDJ
    • Radio 251 , Gewoon gezellig
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #45 on: March 05, 2017, 05:34:05 PM »
hi im a new dj do you guys happen to know any good websites that i can store my audio and video content on

I know this is an old one but this question is giving me pain everywere. Why oh why should you put the audio and video content on a web based server? Not because it is stable that is for sure.  :hihi: Some people need to know that even though you can have 250 thousend terrabyte of space on a web server, with no internet connection you can't do anything with it  :hihi:
Running 3 editions V1.8.2 at www.salto.nl and v1.8.2 at radio251.nl. ( NOW with 2 live studio's! )

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5376
    • Radio DJ Romania
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #46 on: March 05, 2017, 06:03:14 PM »
@FreerunMedia: this question is concerning me as well, but also when users choose to install the database on a web server, even if the RadioDJ computer must run anyway...
Some users just don't seem to understand that more remote connections which they cannot control means more chances to go something wrong.
But i guess, some users like living on the edge  :D
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

marcbeinder

  • Sr. Member

  • Offline
  • ****
  • 321
    • RUOLradio
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #47 on: March 05, 2017, 06:06:22 PM »
@FreerunMedia: this question is concerning me as well, but also when users choose to install the database on a web server, even if the RadioDJ computer must run anyway...
Some users just don't seem to understand that more remote connections which they cannot control means more chances to go something wrong.
But i guess, some users like living on the edge  :D

I can attest to this. I have my database on a web server. Right next to my RDJ computer. And I have problems every now and then.
RUOLradio.com // EncoreMediaSystems.com

Calypso

  • Sr. Member

  • Offline
  • ****
  • 258
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #48 on: March 06, 2017, 07:21:43 AM »
@FreerunMedia: this question is concerning me as well, but also when users choose to install the database on a web server, even if the RadioDJ computer must run anyway...
Some users just don't seem to understand that more remote connections which they cannot control means more chances to go something wrong.
But i guess, some users like living on the edge  :D

My opinion is that if you know what you're doing it can work very well - all depends on the situation. And if you know what you're doing, you know what the risks are. If you don't know that, don't attempt such a setup.

To speak for myself: my database is on a stretched 3 node MySQL cluster (to prevent split brain) and the music is on 2 different servers which are synchronized. Not only because I then always have a backup, but also because I use the same database to play the nonstop as when I play "live", and the nonstop machine is in a datacenter while the live studio is at home. If you want such a setup and you don't know every term I'm talking about: don't attempt it.

mysteriesman

  • New User

  • Offline
  • *
  • 9
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #49 on: April 25, 2017, 12:44:03 PM »
I have a question where you may be able to help, I have a main playout pc with all the music on dropbox mapped as a Z drive, the main system plays fine and imports music in to the database without any problems, I then connect a production pc to the database with a Zdrive and music all fine. I import a track on to production pc and plays fine, the playout pc can see it fine in the database but when I try to play it, it immediately disables the track, this used to work fine but now wont, any ideas????

Calypso

  • Sr. Member

  • Offline
  • ****
  • 258
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #50 on: April 25, 2017, 04:26:49 PM »
I have a question where you may be able to help, I have a main playout pc with all the music on dropbox mapped as a Z drive, the main system plays fine and imports music in to the database without any problems, I then connect a production pc to the database with a Zdrive and music all fine. I import a track on to production pc and plays fine, the playout pc can see it fine in the database but when I try to play it, it immediately disables the track, this used to work fine but now wont, any ideas????

Double check that the file is available on the playout PC; disabling of database entries usually happens when the file is not available on the exact same path. Also try to play the file with a music player - maybe credentials aren't correct.

R-Riks

  • New User

  • Offline
  • *
  • 1
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #51 on: July 19, 2017, 11:35:54 AM »
Hi,
We are working on creating a new radio station in parallel with the one we already have. We want to use the same database as we already have, but with new rotations and different jingles. Has set up a PC Nr 2, but can not play music from the database. When I open the RadioDJ program on PC 2, it's only gray. In the database setup the URL to MySQL is correct and its all green. What is wrong?

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 3595
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • DJ Garybaldy
Re: Connecting RadioDJ On Another PC To MYSQL
« Reply #52 on: July 19, 2017, 11:47:44 AM »
Ignore my last reply I read the question wrong.
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://twitter.com/DJGaryBaldy

Retired from the forums although I will still beta test where possible.