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?
Results 1 to 10 of 16
-
05-21-2019, 09:42 AM #1
- Title
- Barely A Broadcaster
- Join Date
- Jun 2016
- Location
- Hastings East Sussex
- Posts
- 84
- Rep Power
- 0
status=err SQL error=Could not connect to MySQL server
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
-
05-21-2019, 01:24 PM #2
- Title
- Avid Broadcaster
- Join Date
- May 2009
- Posts
- 119
- Rep Power
- 12
-
05-21-2019, 06:04 PM #3
- Title
- Barely A Broadcaster
- Join Date
- Jun 2016
- Location
- Hastings East Sussex
- Posts
- 84
- Rep Power
- 0
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
-
05-23-2019, 02:12 PM #4
- Title
- Junior Broadcaster
- Join Date
- May 2019
- Location
- Barrhead AB Canada
- Posts
- 7
- Rep Power
- 0
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.
-
05-23-2019, 03:33 PM #5
- Title
- Barely A Broadcaster
- Join Date
- Jun 2016
- Location
- Hastings East Sussex
- Posts
- 84
- Rep Power
- 0
not really asking for trouble it's on a free host
-
05-24-2019, 01:09 AM #6
- Title
- Junior Broadcaster
- Join Date
- May 2019
- Location
- Barrhead AB Canada
- Posts
- 7
- Rep Power
- 0
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.
-
05-24-2019, 09:17 AM #7
- Title
- Barely A Broadcaster
- Join Date
- Jun 2016
- Location
- Hastings East Sussex
- Posts
- 84
- Rep Power
- 0
im getting this error now http://urbanreq.000webhostapp.com/test3/web/index.php
but i'm running sam locally
-
05-24-2019, 02:26 PM #8
- Title
- Avid Broadcaster
- Join Date
- May 2009
- Posts
- 119
- Rep Power
- 12
Is mysql on your remote host or is it on the same computer SAM is located?
-
05-24-2019, 05:23 PM #9
- Title
- Barely A Broadcaster
- Join Date
- Jun 2016
- Location
- Hastings East Sussex
- Posts
- 84
- Rep Power
- 0
mysql is on the same computer as sam
-
05-25-2019, 01:39 PM #10
- Title
- Avid Broadcaster
- Join Date
- May 2009
- Posts
- 119
- Rep Power
- 12
Sure looks like a closed port issue on your local network.
Bookmarks