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

[ultra89]

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

<?/*
<CONFIG application="SAM" version="4.2.1">
<Database>
<Driver>MYSQL</Driver>
<Host>90.214.103.222</Host>
<Port>3306</Port>
<Database>SAMDB</Database>
<Username>youruser</Username>
<Password>yourpass</Password>
</Database>
</CONFIG>


*/?>

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

[SmoothJazz]

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?

[ultra89]

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

[squirrelfmradio]

Just to make sure I'm understanding this correctly... The SQL Server is on a shared host? That's kind of begging for trouble.

[ultra89]

not really asking for trouble it's on a free host

[squirrelfmradio]

not really asking for trouble it's on a free host

Are you using the cloud version of SAM or running it locally?

[ultra89]

im getting this error now http://urbanreq.000webhostapp.com/test3/web/index.php

but i'm running sam locally

[SmoothJazz]

Is mysql on your remote host or is it on the same computer SAM is located?

[ultra89]

mysql is on the same computer as sam

[SmoothJazz]

Sure looks like a closed port issue on your local network.