Page 1 of 2 12 LastLast
Results 1 to 10 of 16
  1. #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

  2. #2

    Title
    Avid Broadcaster
    Join Date
    May 2009
    Posts
    119
    Rep Power
    12
    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?

    Rob Oyler
    5280 Jazz

  3. #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

  4. #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.

  5. #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

  6. #6

    Title
    Junior Broadcaster
    Join Date
    May 2019
    Location
    Barrhead AB Canada
    Posts
    7
    Rep Power
    0
    Quote Originally Posted by ultra89 View Post
    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.

  7. #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

  8. #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?

    Rob Oyler
    5280 Jazz

  9. #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

  10. #10

    Title
    Avid Broadcaster
    Join Date
    May 2009
    Posts
    119
    Rep Power
    12
    Sure looks like a closed port issue on your local network.

    Rob Oyler
    5280 Jazz

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •