Author Topic: RadioDJ Demo script 2.2  (Read 615 times)

wjr4

  • Jr. Member

  • Offline
  • **
  • 66
RadioDJ Demo script 2.2
« on: March 30, 2021, 08:59:02 PM »
I have recently been having issues with the RadioDJ Demo script 2.2 not connecting to the MySQL server on my computer.
I have openned the ports on my router but it is not showing up...   I was using  PHP 5.6   I have upgraded to 7.4 but I have since reverted back down to 5.6..  I didn't know if there could be a compatibility problem or not..   I am  not sure if my ISP is blocking my ports either.    I opened both 3306   and  been trying different ports to see if that was the problem.

This is the Serv_Inc.php .....   Do you see any anything that could be wrong here ?

$stationName   = "W3Z Hotline";      //Your Station name

$mysql_server   = "*.*.*.*:5357";            // MySQL Server's IP (and port if not default). Ex: (191.268.1.2 or 191.268.1.2:345).
$mysql_database   = "radiodj206";            // MySQL database name
$mysql_user      = "website";               // MySQL database username. Usually root.
$mysql_pass      = "*******";                  // MySQL database password.

$track_repeat   = 120;                  // Don't display the track if it was played in the last X minutes.
$artist_repeat   = 120;                  // Don't display the track if the artist was played in the last X minutes.
$def_timezone   = 'ETC-06:00';      // Set your time-zone.

--------------------------------------------------------------------------------------------------------------------------


Thanks

SteveHS

  • New User

  • Offline
  • *
  • 22
  • Personal Text
    I don't fail... I find ways that don't work.
    • StewartsWebWorks
Re: RadioDJ Demo script 2.2
« Reply #1 on: March 30, 2021, 11:03:35 PM »
FIRST AND FOREMOST !!!
Edit you're post and edit out you're IP address !!!!


Use this script as it will check connections for you and port..
When connection established it shows the config file details

https://www.stewartswebworks.com/databaseportcheck.php

wjr4

  • Jr. Member

  • Offline
  • **
  • 66
Re: RadioDJ Demo script 2.2
« Reply #2 on: April 08, 2021, 03:13:01 AM »
I tried run the scripts and when I use port 3306  it says it connects but my ISP blocks it externally so I can't get the request to work...    I tried to use another port 443  (which I have used in the past and have it forward to 3306 but I can't get that to work either. )..     Any other suggestions ?     I have tried to configure this router with port forwarding and also have tried port triggering, but neither seem to work..    How can I get this work ??



FIRST AND FOREMOST !!!
Edit you're post and edit out you're IP address !!!!


Use this script as it will check connections for you and port..
When connection established it shows the config file details

https://www.stewartswebworks.com/databaseportcheck.php

SteveHS

  • New User

  • Offline
  • *
  • 22
  • Personal Text
    I don't fail... I find ways that don't work.
    • StewartsWebWorks
Re: RadioDJ Demo script 2.2
« Reply #3 on: April 08, 2021, 10:21:28 PM »
I tried run the scripts and when I use port 3306  it says it connects but my ISP blocks it externally so I can't get the request to work...    I tried to use another port 443  (which I have used in the past and have it forward to 3306 but I can't get that to work either. )..     Any other suggestions ?     I have tried to configure this router with port forwarding and also have tried port triggering, but neither seem to work..    How can I get this work ??
If the script shows "Connection Established" then the requests should work fine as there's a connection.
Have you got the request plugin on RadioDJ with auto refresh enabled.

wjr4

  • Jr. Member

  • Offline
  • **
  • 66
Re: RadioDJ Demo script 2.2
« Reply #4 on: April 09, 2021, 04:02:36 AM »
I guess you misunderstood me..

My IPS is blocking 3306 from the internet side..     I  am not able to connect to the webpage that has the demo script on it.   I have tried to use another port to forward in my router but I am not having success with that either.
They have me blocked..   I called them and asked how to forward ports on their router and they send me to a website (not part of their company)..    I can't get it to work..    Weeks before I upgraded the modem and service, everything was working fine..    It is definately something to do with their service and router..
I have been reading articles on the internet on how to change ports, forward ports, trigger ports...  And nothing is working...     My final attempt is to change the config file for MySQL   to change the port from 3306 to something else..
but  I am not 100% sure how to do that..   Can this be done ?     and I am not even sure  that will work either..
I am really at a loss...   I really use RadioDJ for station operation and was using the request feature alot before but now it looks like I can't get it to work anymore..     I wish someone with knoweldge of this could really help me get this to work.    Thanks..


If the script shows "Connection Established" then the requests should work fine as there's a connection.
Have you got the request plugin on RadioDJ with auto refresh enabled.

stevewa

  • Hero Member

  • Offline
  • *****
  • 785
Re: RadioDJ Demo script 2.2
« Reply #5 on: April 12, 2021, 02:03:38 AM »
try this

https://www.yougetsignal.com/tools/open-ports/

Axtran

  • New User

  • Offline
  • *
  • 2
Re: RadioDJ Demo script 2.2
« Reply #6 on: May 25, 2021, 11:59:56 PM »
Hello to all  :)..

I've been fighting for the best part of a full day with the request part of the scripts.

First... I've got connection established when i check databaseportcheck.
Second, I've edited the "serv _inc" with the same credentials used for the databaseport check.

Al should be working fine but when I upload the scripts to a secondairy site, hosted by one.com i get the following message:

https://axtran.be/request.php:

"Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /customers/7/b/5/axtran.be/httpd.www/serv_inc.php:79 Stack trace: #0 /customers/7/b/5/axtran.be/httpd.www/request.php(231): db_conn() #1 {main} thrown in /customers/7/b/5/axtran.be/httpd.www/serv_inc.php on line 79"

Things I have checked:  Permisions for the new user on mysql database (Global is selected)
                                   Port forwarding is active on router. (sould all be ok since i can connect via the databaseportcheck)
                                   Time zone (Europe/Brussels)

Anyone has an idea what the problem can be?  :angel:


stevewa

  • Hero Member

  • Offline
  • *****
  • 785
Re: RadioDJ Demo script 2.2
« Reply #7 on: May 26, 2021, 10:22:22 PM »
no function by that name.... depreciated...

https://www.php.net/manual/en/function.mysql-connect.php