ultra89 Posted May 21, 2019 Share Posted May 21, 2019 hi all i haven't posted in here for ages but i'm getting this error for my requests status=err SQL error=Could not connect to MySQL server what am i doing wrong my config is as follows /* MYSQL 90.214.103.222 3306 SAMDB youruser yourpass */?> the username and pass is not what you see it as but i know you can't paste stuff with the real userame and pass lol so yea what am i doing wrong Link to comment Share on other sites More sharing options...
SmoothJazz Posted May 21, 2019 Share Posted May 21, 2019 Have you tried a port scan to verify that port 3306 is open on the machine with SAM? If it is open locally, verify with your web host they permit OUTBOUND connections using port 3306. What has changed recently? New host? new install? MYSQL upgrade? http://5280jazz.com/nowplaying_image/5280jazz.png Rob Oyler 5280 Jazz Link to comment Share on other sites More sharing options...
ultra89 Posted May 21, 2019 Author Share Posted May 21, 2019 yea i changed to onlineaudiance and nope im using mysql the normal one not mysql community now my requests ain't even showing up i'v done everything port forwarded 1221 and 3306 are both open i checked with my host ages ago about port there ports are open Link to comment Share on other sites More sharing options...
squirrelfmradio Posted May 23, 2019 Share Posted May 23, 2019 Just to make sure I'm understanding this correctly... The SQL Server is on a shared host? That's kind of begging for trouble. Squirrel FM : Always playing with our nuts! www.squirrel.fm Studio systems running RadioDJ, PlayoutONE, & Rivendell Flow 8 Deck & PlayIt Cartwall for live mixing and assist. Remote systems running RadioDJ Pioneer DDJ-SX control surface. Link to comment Share on other sites More sharing options...
ultra89 Posted May 23, 2019 Author Share Posted May 23, 2019 not really asking for trouble it's on a free host Link to comment Share on other sites More sharing options...
squirrelfmradio Posted May 24, 2019 Share Posted May 24, 2019 not really asking for trouble it's on a free host Are you using the cloud version of SAM or running it locally? Squirrel FM : Always playing with our nuts! www.squirrel.fm Studio systems running RadioDJ, PlayoutONE, & Rivendell Flow 8 Deck & PlayIt Cartwall for live mixing and assist. Remote systems running RadioDJ Pioneer DDJ-SX control surface. Link to comment Share on other sites More sharing options...
ultra89 Posted May 24, 2019 Author Share Posted May 24, 2019 im getting this error now http://urbanreq.000webhostapp.com/test3/web/index.php but i'm running sam locally Link to comment Share on other sites More sharing options...
SmoothJazz Posted May 24, 2019 Share Posted May 24, 2019 Is mysql on your remote host or is it on the same computer SAM is located? http://5280jazz.com/nowplaying_image/5280jazz.png Rob Oyler 5280 Jazz Link to comment Share on other sites More sharing options...
ultra89 Posted May 24, 2019 Author Share Posted May 24, 2019 mysql is on the same computer as sam Link to comment Share on other sites More sharing options...
SmoothJazz Posted May 25, 2019 Share Posted May 25, 2019 Sure looks like a closed port issue on your local network. http://5280jazz.com/nowplaying_image/5280jazz.png Rob Oyler 5280 Jazz Link to comment Share on other sites More sharing options...
squirrelfmradio Posted May 25, 2019 Share Posted May 25, 2019 Have you tried disabling Windows Firewall to see if that makes the problem go away? Are you running an A/V product with a built-in firewall? Squirrel FM : Always playing with our nuts! www.squirrel.fm Studio systems running RadioDJ, PlayoutONE, & Rivendell Flow 8 Deck & PlayIt Cartwall for live mixing and assist. Remote systems running RadioDJ Pioneer DDJ-SX control surface. Link to comment Share on other sites More sharing options...
ultra89 Posted May 25, 2019 Author Share Posted May 25, 2019 (edited) my ports 1221 and 3306 are both open there's no closed ports i'v checked with canyouseeme.org and i have tried disabling windows firewall i'm getting this message Sorry, your request failed. The radio station responded with: Unable to connect to 192.168.0.8:1221. Station might be offline, or connection is being blocked. (Err#: 803) which i don't know why it's trying to connect to that ip when it's suppose to connect to my local ip for example 22.3.55.09.778 not the other ip Edited May 25, 2019 by ultra89 Link to comment Share on other sites More sharing options...
SmoothJazz Posted May 26, 2019 Share Posted May 26, 2019 That's different than the mysql connection we have been diagnosing. So is your web site displaying correctly now and it now is a request issue? What is the actual url for your site, the previous one you posted is not working at all. http://5280jazz.com/nowplaying_image/5280jazz.png Rob Oyler 5280 Jazz Link to comment Share on other sites More sharing options...
ultra89 Posted May 26, 2019 Author Share Posted May 26, 2019 (edited) PHP Requests http://urbanreq.000webhostapp.com/testrequests/ HTML Requests http://urbanreq.000webhostapp.com/test but the php one's don't seem to want to budge all the files are uploaded and configured correctly ports are open both of them so i don't know what's going on Edited May 26, 2019 by ultra89 Link to comment Share on other sites More sharing options...
SmoothJazz Posted May 27, 2019 Share Posted May 27, 2019 (edited) 000webhost? I don't know of a free web host that permits you to make an external database connection. Are you sure they permit OUTBOUND connections on both ports 1221 & 3306? Just perused their support forum and saw this Hi @arivano, We are sorry about that. But, as a free web host, we do not provide remote MYSQL connections. But, you do it like following (also this is the way other websites use to update their databases with clients like javascript, android apps and more.) Send a http request from the client application to a PHP file which is on the server. (if you are using javascript this should be an ajax request) This PHP file should contain code to update the database and do any other processing. Important: It is a great security risk to allow client applications to connect to your databases directly. Never do that! They DO NOT allow outbound connections to remote databases. Edited May 27, 2019 by SmoothJazz http://5280jazz.com/nowplaying_image/5280jazz.png Rob Oyler 5280 Jazz Link to comment Share on other sites More sharing options...
ultra89 Posted May 27, 2019 Author Share Posted May 27, 2019 (edited) there the only people to go with as my webhost won't let me have the requests on there server cos it'll mess there servers up but then again i have the php requests on this site http://fuzionrequests.x10.mx/jay/playing.php Edited May 27, 2019 by ultra89 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now