Connecting to Database from 2nd Computer

[quarterear]

I am looking for some instructions to setup RDJ so that I can connect to the same database within my LAN. I am using the main computer as the play-out with the DB on that computer and trying to connect to that database with the other instance so I can make changes on my local machine. Any help would be appreciated.

[ghm72]

You need to find the local IP that the RadioDJ database is on it'll be something like 192.168.0.10 then just connect to that machine from the other machine using  the details like this.

You will probably also need to allow access from Windows Firewall or antivirus firewall (if you have one) make sure port 3306 is allowed.




Just make sure the music paths are the same on the remote PC as well as the main PC.

Hope that helps.

[Jhonny]

Em still working on this tutorial, so it's not in the menu yet.
It's about how to setup a simple station.

To get the pc local/internal ip

Just find Different database setup on PC II in the page, it's a bit on the bottom of the page.

Hoop it will help you or others.
 

[Marius]

Also keep in mind that the default "root" user can only connect from localhost (same computer) to the database server, so you will need to change that.

[quarterear]

Thanks everyone! I will try that and get back to you if I still have trouble.

[quarterear]

Hey guys...So I tried what you suggested and am getting this message. Any suggestions?

[attachment deleted by admin]

[Jhonny]

Have you tried this too?
192.168.1.141:3306

Now it's only 192.168.1.141

[quarterear]

Yes tried it with the port as well

[plauri]

Did you mount the correct path of the first pc on the second pc?

[quarterear]

Hi Plauri

Thank you for your response. I'm not sure I understand the mounting part. Can you explain?

[plauri]

On the second pc can you access the path where it's stored your music and your database? You open your File Explorer, then from C you have to mount for example: drive Z:\\music (I'm not sure this is the correct way to write it)

[quarterear]

OK I see what you mean. I don't have a shared drive on the RDJ computer. My thought was that I was connected to it strictly by IP.

[plauri]

OK I see what you mean. I don't have a shared drive on the RDJ computer. My thought was that I was connected to it strictly by IP.

And yes, you have to share your drive!

[quarterear]

Is there any documentation on the site to specifically accomplish this?

[plauri]

Is there any documentation on the site to specifically accomplish this?

I have found this video https://www.youtube.com/watch?v=Z_Hc6ByPP_s