Jump to content

status=err SQL error=Could not connect to MySQL server


Recommended Posts

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

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

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

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

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

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

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 by ultra89
Link to comment
Share on other sites

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

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 by SmoothJazz

http://5280jazz.com/nowplaying_image/5280jazz.png

Rob Oyler

5280 Jazz

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...