• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

Album Art

Started by djerniehoule, November 14, 2021, 11:26:48 PM

Jhonny

 :cool: no errors, just the request screen.
Currently on
RDJ V 2.0.4.8
MariaDB V 10.6.21
WIN 11 PRO

racketeerradio

Thats because i exported my database from heidieSQL and uploaded it to my webservers' (Bluehost) database so the database is showing my songs, but if i request a song, it wont appear in my RadioDJ. The database isnt connecting to my computer to send info back and forth it is just sitting online not sending info.  (new songs, removed songs, updated album art, etc).  :bash:

RFU

Putting your database on the server is the wrong way to go.

What CMS are you using?
Гордий бути українцем, Ми - Радіо Вільної України.

racketeerradio

I'm using Bluehost. I know that it's not gonna work when putting the database on my server. I just wanted to see if photos song etc work. But when I delete the database, it won't connect my database at all. Yes my credentials (username pass db etc) are correct. 

RFU

It doesn't matter what your host is. I suggest you build a site with wordpress. It's relatively easy to use, and the Wordpress 0.70 plugin for radioDJ works.

The only  problem with the wordpress plugin is that it doesn't display album art. So what I did was commented out the section of the php that showed the now playing details.

Then inserted an iframe into that section using the display.php file from the old RadioDJ now playing plugin. It now shows all the song details as well as the album art.

And, remember, you have to upload your album art to your server and you also have to port forward 3306 on your router to the computer you're running RadioDJ on
Гордий бути українцем, Ми - Радіо Вільної України.

racketeerradio

Okay well I am now trying the Wordpress and downloaded everything I needed to. I went on Wordpress and set up the plugin and it's connected. I am still having the same issue though. When I got to my website: https://racketeerbroadcastassociation.com/Home/request.php again my database won't appear no data at all. As you can see I can edit the codes to edit the look. MySQL is online according to RadioDj and the database is connect in the RadioDj plugin in Wordpress. Not sure why it's not connected any way I go about it.

RFU

Is the wordpress plugin on your site showing Now Playing, coming up, and recently played?
Гордий бути українцем, Ми - Радіо Вільної України.

racketeerradio

Quote from: RFU on January 29, 2022, 09:22:29 AM
Is the wordpress plugin on your site showing Now Playing, coming up, and recently played?
No, nothing like that is showing on the site. I have the menu but when I click on any of them. Nothing shows up on the site

RFU

There shouldn't be any menu item, except in your dashboard settings

When you set up the wordpress 070 plugin did you test the database setup? It should be set to the IP of your router, and your router should port forward to the IP of the computer that's running RadioDJ. there is a test button. The IP in the plugin should look something like XXX.XXX.XXX.XXX:3306

Then us can use a variety of shortcodes to display information on any page you want. The shortcodes are detailed on the same screen as the database setup
Гордий бути українцем, Ми - Радіо Вільної України.

racketeerradio

Thank you very much for the responses!
Sorry menu meaning the bar with Song Request listen Now Playing etc.
and yes when I set up the Wordpress 070 I tested it and it says it's connected and yes I am using my IP address which I found at myipaddress.com (which I added :3306 to the end)
But you are saying to use my routers address? I'll try that when I get home from work. If that doesn't work is there any other advice?

RFU

The IP of your router is different from the IP of your computer.

The IP you should be using in the plugin is the IP of your router, plus :3306

But... in your router settings you have to set the port forward for 3306 to the IP of the computer running RadioDJ

And it's also a good idea to search the internet (I don't know what OS you're using) and find out how to lock the IP for that computer. Otherwise, every time the computer restarts you'll have a new IP and you'll have to reset the port forward on the router
Гордий бути українцем, Ми - Радіо Вільної України.

racketeerradio

Quote from: RFU on January 30, 2022, 12:50:38 AM



Using mysqli client to connect

Successfully connected to RadioDJ database

Database version: 8.0.28

Connection took 0.563 seconds

Last played song: Jimmy Dale Richardson - She's Wild at 2022-01-30 07:12:41

then when i switch to my router IP I get:

Using mysqli client to connect

Connection took 10.01 seconds

Error connecting to RadioDJ database: Connection timed out

Please make sure that you are using correct IP address and port number.
Either your webhost is blocking outgoing MySQL connections or MySQL is not listening on given IP address and port.

RFU

When you do something like WhatsmyIP it's giving you the IP or the router, not the computer

You're getting an error because you didn't set the port forward on the router to the computer running RadioDJ
Гордий бути українцем, Ми - Радіо Вільної України.

racketeerradio

alright Ive updated it and now get this on my database settings in the wordpress plugin:

Error connecting to RadioDJ database: Access denied for user 'racketeerradio'@'box5377.bluehost.com' (using password: YES)

Please check your password and verify that user racketeerradio is allowed to connect to specified database remotely.


RFU

Set up another user in mysql only for the wordpress plugin and use those credentials in the plugin to access the database
Гордий бути українцем, Ми - Радіо Вільної України.