RadioDJ - Free Radio Automation Software Forum

RadioDJ v1.7+ => v1.7+ - Support Forum => Topic started by: ronsedaille on September 14, 2014, 06:07:25 AM

Title: Connecting RadioDJ On Another PC To MYSQL
Post by: ronsedaille on September 14, 2014, 06:07:25 AM
Hi - I would like to load RadioDJ on a second pc connected to my home network.  This way, I can load music, edit cue points, etc., while RadioDJ is streaming on my primary pc.  What is the most practical way to achieve this?  Thanks for your help!

Ron
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: packzap on September 16, 2014, 03:38:52 AM
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: Marius on September 16, 2014, 06:51:29 AM
Great tutorial packzap!  ;)
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: ronsedaille on September 16, 2014, 08:04:34 AM
Packzap - Success!! Many thanks to you for your clear instructions.  I have been banging my head against the wall trying to do this for a week!   :)

Ron
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: ronsedaille on September 28, 2014, 02:39:14 AM
Just a heads up for people using a Windows 8.1 PC as the host - apparently, the computer IP Address changes periodically, specifically the last digit.  So when you go to log in remotely, you might be using a previous IP and you wont be able to get in.  So I assume that I have to set a Static IP Address in order to avoid this from happening.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: AndyDeGroo on September 28, 2014, 05:32:47 PM
Just a heads up for people using a Windows 8.1 PC as the host - apparently, the computer IP Address changes periodically, specifically the last digit.  So when you go to log in remotely, you might be using a previous IP and you wont be able to get in.  So I assume that I have to set a Static IP Address in order to avoid this from happening.

Changing IP addresses are not Windows 8.1 specific, nor they are Windows specific. They are changing because you are using DHCP on your router and it assigns next available address to next device which connects to LAN. You either configure your router to reserve particular IP address based on MAC address/hostname of PC or use static IP on the PC and risk having the router already assigned the address to other device on the network when you connect the PC with static address configured.

Some router allow to configure more than one address range for LAN. If yours does, configure one address range (for example 192.168.1.2-14) as not managed by DHCP and another (192.168.1.100-.254) as DHCP managed. Then assign static addresses from first space to devices that need static IPs.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: ronsedaille on September 29, 2014, 06:41:32 AM
Thank you, Andy!
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: shyzas on October 03, 2014, 05:45:55 PM
Hello,
one more question to add. Maybe is it possible to somehow extract or load dll of track manager (and cue manager) not loading whole radioDJ, so music manager could do whatever he needs on his computer not interrupting radiodj db (playing on onairpc), if he somehow he hits play or something. We would use same db, and music on network, so onair and music manager computers use everything same.
Thank You.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: AndyDeGroo on October 03, 2014, 06:40:29 PM
Hi, shyzas

Standalone track manager has already been requested on more than (http://www.radiodj.ro/community/index.php?topic=4468.msg25975#msg25975) one occasion (http://www.radiodj.ro/community/index.php?topic=3022.msg16438#msg16438).
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: shyzas on October 03, 2014, 11:09:07 PM
Thank You AndyDeGroo
just didn't find that.

Greetings to Latvia   ;)
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: ronsedaille on October 29, 2014, 03:12:29 AM
What would cause this error, when following the above instructions?  Thanks!

[attachment deleted by admin]
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: AndyDeGroo on October 29, 2014, 03:48:51 PM
What would cause this error, when following the above instructions?  Thanks!
That is because file permissions restrict writing files under C:\Program Files\. Either move RadioDJ directory to somewhere else or change file permissions to allow writing in RadioDJ directory.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: ronsedaille on October 29, 2014, 09:57:04 PM
It worked - Thank you again Andy!
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: radiovoltrega on May 20, 2015, 07:33:42 PM
Hi,

I've followed all the tutorial. Now I can see all my music in Radio Dj from the other pc. But I can't play them. How can I connect with the main music folder in the primary pc?

Thanks.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: mixycsabi on May 20, 2015, 08:05:45 PM
Hi radiovoltrega!

You have two options:
1, Copy all music from main PC to local computer. for example: from main PC d:/music to local PC d:/music (of course you need to copy the jingles, sweepers promos.... folder too)
2, Share the main PC music folder's drive, then connect network drive on the local PC the drive letter needs to same!
I think the second option is the better (I'm using this ;D)

Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: igherardia on May 20, 2015, 10:16:03 PM
for an stand alone music playlist generator or track manager

I disable this dll and xml for plugnis folder

Playlist
auxiliar player
history
playinfo
and stop events.

In that way Radio Dj only display file browser to administrative prorpours
trackManager Playlist builder Options Utilitis

And work perfect

I run Radio DJ in 6 machine with diferent Operation Sistem.
1 of them only contect to mysql from my house on a public ip address to manage events and playlist.

regards

Ignacio
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: radiovoltrega on May 21, 2015, 09:09:38 PM
Thanks for replying  :)

My purpose of doing this is to play the music and jingles that I have in the main pc on another pc that it is on the second studio of our radio. Could I play the music from there?
My music folder is on the desktop (it's drive C). If I share this folder and map the shared folder on the other pc, it will work? Or I have to move the folder to another hard drive?

If I have to move the folder, there's an option to change the location of files from Radio DJ?
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: igherardia on May 22, 2015, 03:14:32 AM
In bouth pc the mapper letter may be the same

Exaple

PC 1 contain mysql and the music falder

Shared the folder and map in the same pc as z:\radiodj

Pc 2 conect drive z to the shared folder in pc 1

If the bouth folder aré the same the music will play
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: radiovoltrega on May 27, 2015, 05:29:45 PM
Thanks to everyone. Now I only have one problem: the music folder is on the desktop of the main hardrive (C:). I have to move the folder to another drive or partition? There's any way to change the location of all the songs on radiodj or I have to change the location of every song manually?

Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: DJ Garybaldy on May 27, 2015, 05:32:45 PM
Thanks to everyone. Now I only have one problem: the music folder is on the desktop of the main hardrive (C:). I have to move the folder to another drive or partition? There's any way to change the location of all the songs on radiodj or I have to change the location of every song manually?

Just use "Relocate tracks" from the utilities menu
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: radiovoltrega on May 27, 2015, 06:22:23 PM
Thank you! Now it woks perfect!!!  :cool: :cool: :) Radio Dj is the best!
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: mikesan on July 16, 2015, 08:21:12 PM
I'm hoping this is a good place for my question (this seems close to my hopeful setup), forgive me if a bit redundant but I am a newbie here (haven't even committed to download RadioDJ yet because still shopping and unsure if this is possible). ...
I need to fully setup and edit the next day's 12 hour automated rotation while today's automated rotation (that I edited yesterday - needing no further editing or attention) is currently playing/streaming.  The history and no-repeat rules are of most importance for all day-to-day rotations. 

Example:
On Sunday I set up an automated rotation (complete with rules not to repeat songs/artists) to stream for 12 hours on Monday.  On Monday, while that rotation is streaming, I need to generate another rotation for Tuesday (using the same rules and history, again to negate any repeats).  With each day's new rotation I am heavy on the editing, inserting pre-recorded breaks and sweepers (done in a separate studio and program) that are unique for the day of broadcast, switching out songs here and there, fine-tuning playlists, etc.

Can this be accomplished on one PC running my only version of RDJ, or do I need 2 versions on 1 PC or 2 PCs with their own versions on each?  The shared history for no-repeat rules is a concept I can't seem to find much on here and wrap my head around how different versions/PCs would/could utilize/share such info (rules and playlists) from another version which is theoretically running solo independently. In essence, due to the variety and vastness of the database, I don't want songs/artist to repeat perhaps over several days.   Does that make sense?  Possible somehow?
Thank you. ==
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: snarfdude on August 21, 2015, 02:04:55 PM
Hi radiovoltrega!

You have two options:
1, Copy all music from main PC to local computer. for example: from main PC d:/music to local PC d:/music (of course you need to copy the jingles, sweepers promos.... folder too)
2, Share the main PC music folder's drive, then connect network drive on the local PC the drive letter needs to same!
I think the second option is the better (I'm using this ;D)


with all the tutorials I have successfully put the software on my production computer....because, well, at any radio studio, you have production and mastrer control. the Database is linked and thanks to the suggestion above, after renaming the drive letter of my DVD player,  I am using the same drive letter to play audio.  Really works nice, and this is a standard setup (or should be) for any studios I have worked in commerical radio.

I'm guessing that any audio I import using the production computer will be passed over to the main control computer? since i'm linked with both the data and audio, this should be the case, but thought I'd ask.

Most commerical radio stations have software (wide orbit, mediatouch) that have separate programs to import audio. I see it's been requested already, so look to that option.


Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: kaypee808 on November 18, 2015, 07:33:30 AM
Just a clarification: In a 2 PC setup (pc1=main and pc2=production), does the server IP of the SQL Server  in PC1 have to be the same as its assigned IP address for LAN purposes, so that PC2's (production) SQL Server will reference PC1's assigned IP address for the two to communicate as far as the database is concerned?
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: Valdis on November 18, 2015, 08:03:13 AM
Just a clarification: In a 2 PC setup (pc1=main and pc2=production), does the server IP of the SQL Server  in PC1 have to be the same as its assigned IP address for LAN purposes, so that PC2's (production) SQL Server will reference PC1's assigned IP address for the two to communicate as far as the database is concerned?

Hi,

The way you've asked the question is not clear at all but I'll try to explain with example setup:

PC1 or main:
1) Running MySQL or MariaDB server
2) Has a LAN IP 192.0.1.101
3) RadioDJ can connect to the database either using the LAN IP or loopback IP (127.0.0.1)

PC2 or production:
1) Does not run it's own database and relies on the PC1 for that
2) Has a LAN IP 192.0.1.102
3) RadioDJ can connect to database on PC1 ONLY using the LAN IP of PC1 (192.0.1.101)

Hope that helps,
V
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: kaypee808 on November 18, 2015, 10:57:36 AM
 Thank you Valdis!  That answer is the clearest illustration that I have been looking for. What I will do with the actual audio files in PC1 and PC2, is that since PC2 is my input for editing, ad preparation, playlist editing, programming, etc.,  I will follow the same structure (local drive letter, folder and sub-folders) of PC1 for PC2 and I will just map the audio files in PC1, then I will use a uni-directional synchronization/backup software like NovaBackup Pro or even Microsoft Synctoy (PC2 ==> PC1 with auto-differential backup) that mirrors automatically (maybe, every minute) the audio folder and files in PC2 and copy any files (especially new ones  and keep sub-folder structures) to PC1 Audio folder. This way, if PC1 Audio folder goes bad, I have an exact copy of all audio files in PC2. In other illustrations in this thread, there is only one location of Audio Folder/Files which is in PC1 (Main Computer). I am not sure if this is possible but I think it should work. The only shared file would be the SQL database file which resides in PC1.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: FL Coast on November 19, 2015, 04:08:46 PM
Thank you Valdis!  That answer is the clearest illustration that I have been looking for. What I will do with the actual audio files in PC1 and PC2, is that since PC2 is my input for editing, ad preparation, playlist editing, programming, etc.,  I will follow the same structure (local drive letter, folder and sub-folders) of PC1 for PC2 and I will just map the audio files in PC1, then I will use a uni-directional synchronization/backup software like NovaBackup Pro or even Microsoft Synctoy (PC2 ==> PC1 with auto-differential backup) that mirrors automatically (maybe, every minute) the audio folder and files in PC2 and copy any files (especially new ones  and keep sub-folder structures) to PC1 Audio folder. This way, if PC1 Audio folder goes bad, I have an exact copy of all audio files in PC2. In other illustrations in this thread, there is only one location of Audio Folder/Files which is in PC1 (Main Computer). I am not sure if this is possible but I think it should work. The only shared file would be the SQL database file which resides in PC1.

Welcome kaypee808 to the RadioDJ community.

The setup you are describing is exactly what I have been using for over a year.  I have had no issues and it is the best way to keep an exact copy of everything in case there is an issue with PC1, you can throw PC2 On Air in just a few minutes.  I used Microsoft’s SyncToy 2.1 for quite a while but now prefer the open source program FreeFileSync to maintain my music files on PC1.  It has a few more options.

The other thing you should not forget to be totally protected, or as much as you can be, is to Back-up your database on a regular basis.  I have my PC1 set to back-up the database 2 times per day.  That way I can have an up to date database to use in case the RadioDJ gets corrupted.  I maintain 7 days or 14 back-ups at all times on PC1.

I also have PC2 set to back-up the database each time I connect that machine to the database.  This allows me to have a copy of the database at the exact moment before I make changes to anything.  This back-up is saved to PC2 in the RadioDJ>Set-up>Back-up folder.  This is good to have in case the hard drive or PC1 crashes, you will have a copy of the database you can access and be back on the air in a few minutes on PC2.

I hope this helps as well.

Wayne
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: NewburyHitRadio on December 10, 2015, 08:26:34 PM
Hi there
            Please could someone help me to allow two pcs to run on the same server as I like to use one for advents or weather and one for songs.

The server on both my tower and laptop is the MariaDB 10.1 and this is the set up on both machines.

MySQL TCP/IP.
Hostname IP 127.0.0.1.
Prompt for credentials in untick.
User is set as root.
port 3306 and set up on router for both computers.
Compressed client/server protocool unticked.
Databases: is saying separated by semicolon.
Comment has nothing in it.

Both datebases for radio dj are set up and records are in both computers.
Both machine can run radio dj on server if there is only one on the server.

Now I do not understand how to make a drive as all music is on C: drive on both machines.

Can you help me please.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: jawas on December 21, 2015, 10:25:12 PM

I love that all audio files on either a PC (PC1 Distant ) radiodj with the software , and the hen I add a song in the software , it is added automatically in the Pc2 (other Ip)

The problem that arises is the path of the file: // musics / , the Pc2 should have a network file path \\ serverPc1 \ musics \ adele- hello.mp3

How to do that ?

thank
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: snarfdude on February 13, 2016, 09:30:30 PM
I've used these instructions and starts off working fine for 2 machines for me, and then I go back to the computers, and weill not play audio. database is there, the setup when clicking to validate says the DB is there, everything looks good, and I have set the source for the audio the same as the primary machine, but when I load the audio from the DB manually, I just get a blank screen, and it happens with more then one file. instant players all dead.

I know I set it up right, because it DID work, but now even when I tried to reboot did nothing. I'm think I'm missing something. static IP set for the source machine. using maria DB and win 7 for the primary and win XP and win 7 for the attached machines.

any ideas?

Scott S.





  • Map a drive letter to the master song library location on pc 1. For example "R". Set both pc's to see that mapped location. 
  • Set up a second SQL account in the database for the second pc. See tutorial for more info on this step, http://www.radiodj.ro/tutorials/how-to-add-a-remote-mysql-user.html.
  • Copy the entire RadioDJ folder and subfolders to c:\ of second pc.
  • Go to c:\radiodj\setup on second pc and double click “database setup.exe” to start it up.
  • On the database installation tab, MySQL server line, enter in the ip address of the machine containing the RadioDJ mysql database.
  • MySQL database name is the default one “radiodj161”.
  • Enter the mysql username & password created for this second pc in the mysql user manager (Heidi) from the host pc.
    Click “Validate”. After a few seconds, it should say “Mysql server is online” in green at bottom left of window.
  • Click “OK” and window should close.
  • Go to c:\radiodj folder and run radiodj.exe. The program should come up.  Check Tracks Manager to see if any songs are listed.  If not, install was not correct.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: NewburyHitRadio on February 14, 2016, 11:22:22 AM
Please could someone help me setup a map on Radio DJ on windows XP as in the list on 1 it says  Map a drive letter to the master song library location on pc 1. For example "R". Set both pc's to see that mapped location. 

How do I set the map for the second machine?

David, Newbury Hit Radio.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: DJ Garybaldy on February 14, 2016, 12:17:09 PM
Mapping network drives on Windows XP was always a pain in the backside.

Not had a copy of XP installed for at least 3 years now. So I can't help you on that issue.

Your best bet would probably be to search Google (https://www.google.co.uk/search?client=ubuntu&channel=fs&q=how+to+map+a+network+drive+on+windows+xp) for an answer.

XP was discontinued at least 2 years ago now.

Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: NewburyHitRadio on February 14, 2016, 03:40:12 PM
Not sure if its Windows xp I need to map the network drive or windows 10.  The Radio DJ program is on Windows xp and the second one is windows 10 without the DJ program as I can put that on when I have done the mapping.

David, Newbury Hit Radio.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: snarfdude on February 15, 2016, 04:53:50 AM
Mapping network drives on Windows XP was always a pain in the backside.

Not had a copy of XP installed for at least 3 years now. So I can't help you on that issue.

Your best bet would probably be to search Google (https://www.google.co.uk/search?client=ubuntu&channel=fs&q=how+to+map+a+network+drive+on+windows+xp) for an answer.

XP was discontinued at least 2 years ago now.

Yes we all know that, but the reality of life is former op systems do not necessarily disappear because support ends. XP is far from dead in the world of IT admins and programmers who have built software around XP and I saw a recent job posting where experience with win 2000 was certainly an asset. That was a bit surprising.  I still have a win 98 machine with old audio software I use occasionally. It's still rock solid. The whole sky is falling attitude with op systems because you don't upgrade all the time, is a more of a money grab then anything else. Back up your files and if anything happens, you can always re ghost an image in again anyway.

Mapping to XP a problem? not really. very easy actually. I even moved around the DVD/CD drives to accommodate the write drive letter I needed for the mapping. That was fairly simple. It's more complicated to do that on 7 then XP....but I digress.

After some hit and miss Tsing, I suspect the issue is with the maria DB and maybe a IP address issue. one machine didnt work all weekend, and powered up today and now works. The master machine i'm playing off has a static IP on the network, so you wouldn't think it would matter. Weird. Oh well, I'll struggle through with this. maybe  making static ips for the needed machines will resolve the issue. It's only being used as live assist for now anyway. It has a way to go to be a primary system for me, but might get there at some point.









Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: packzap on February 15, 2016, 05:37:39 PM
How to map a network drive in Windows Vista, 7, 8 and 10, http://www.wintuts.com/Map-Network-Drive  (http://www.wintuts.com/Map-Network-Drive)

Be sure to verify the mapped drive letter (for example "R") shows and is accessible in Windows File manager.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: eLseven on June 28, 2016, 02:19:34 PM
just a little question, if i play a track on secondary pc, would it be counted as a played track on primary pc? would it affected radiodj report on primary pc?
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: Marius on June 28, 2016, 03:48:13 PM
Yes, whenever a track is played, it will is updated with the current date and time and also is added to the history.
The new version will support to be set as a secondary player and won't launch events or update tracks date time.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: eLseven on June 30, 2016, 05:47:41 PM
Yes, whenever a track is played, it will is updated with the current date and time and also is added to the history.
The new version will support to be set as a secondary player and won't launch events or update tracks date time.

wow that would be great. i am so glad to know that  :ok: :ok: thank you so much sir  :ok:
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: marcbeinder on June 30, 2016, 05:50:39 PM
Quick question...will the new version be able to be set up to control RadioDJ on the primary pc from a secondary pc?
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: djrobin3124 on July 13, 2016, 06:55:39 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
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: Jhonny on July 13, 2016, 07:01:09 PM
Hay,
Think your country is inportent for it.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: SideShow Nate on January 09, 2017, 10:16:37 PM
I'm having a helluva time trying to get this all to work!   :'( Here's my issue & question....

I have RadioDJ up & running great at my home along with a database playing all my music & want to be able to access my database from a live remote location (my studio or any other place) via the internet & be able to do a live broadcast. How would I go about making that happen? Be gentle with me as I'm a total noob to this!
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: DJ Garybaldy on January 10, 2017, 01:18:39 PM
I'm having a helluva time trying to get this all to work!   :'( Here's my issue & question....

I have RadioDJ up & running great at my home along with a database playing all my music & want to be able to access my database from a live remote location (my studio or any other place) via the internet & be able to do a live broadcast. How would I go about making that happen? Be gentle with me as I'm a total noob to this!

You'd be better having a  clone of your database on your system you use at remote locations. Trying to get RadioDJ to access a remote database is a bad idea.

Just take a database backup on the main machine and restore that on the laptop etc.. Making sure songs have the same path or simply just use relocate tracks from the utilities menu.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: SideShow Nate on January 11, 2017, 06:13:59 PM
You'd be better having a  clone of your database on your system you use at remote locations. Trying to get RadioDJ to access a remote database is a bad idea.

Just take a database backup on the main machine and restore that on the laptop etc.. Making sure songs have the same path or simply just use relocate tracks from the utilities menu.

Ok. Going to give that a shot tonight. Another quick one too if ya gotta sec... Will I be able to just then interrupt my stream on Caster.fm at a break & proceed the regular way I would at home from the startup? This was the way I was planning on trying from the git go but wanted to see if there was a way to have a main database where I could just access via the interwebs.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: SideShow Nate on January 26, 2017, 05:22:54 AM
To be honest, I don't know what I did, but all of a sudden the whole system works perfectly!  :D I know that I switched my hardware out A1 to ASIO4ALL & RadioDJ to Virtual AUX & BOOM! I'm now using the mirrored copy of the main server on my laptop & able to broadcast anywhere by setting events to turn on & off back at home!! \m/ 8) \m/ Thank you for the help!
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: FreerunMedia 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:
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: Marius 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
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: marcbeinder 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.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: Calypso 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.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: mysteriesman 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????
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: Calypso 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.
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: R-Riks 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?
Title: Re: Connecting RadioDJ On Another PC To MYSQL
Post by: DJ Garybaldy on July 19, 2017, 11:47:44 AM
Ignore my last reply I read the question wrong.