Announcement

Collapse
No announcement yet.

Database connections no longer working on MAC

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database connections no longer working on MAC

    I use a MAC p.c and all my database connections have been working fine until I took a System upgrade from Mountain Lion to Meverick. This is the error:
    Lost connection to MySQL server at 'reading initial communication packet', system error: 61
    On a MAC I in order to get into Scriptcase I have to use (http://127.0.0.1:XX/scriptcase/devel/iface/login.php) and my database connections for the local server I have to use 127.0.10.1 it has never worked using "localhost" only works using the IP address.

    Looking at some posts on the internet for this error all of them say to change the Sever/Host name to use the name of the host instead of the IP address so when I try to change it from 129.0.10.1 to "localhost" it does not work.
    Another post says to to to mysql folder on the p.c. and change the "my.conf" file commenting out the line with 127.0.10.1 however I can't find this file on mysql for Scriptcase can someone tell me where I need to find this line to comment it out?

    Here are the details for my connection:
    Connection name = conn_mysql
    DBMS type = "MySql (Transactional)

    Sever/Host Name or IP: 127.0.10.1
    Port = 3306
    user = root
    pw = password

  • #2
    It looks like a firewall-kind-of-message. Does is give the same problem if you select MySQL non transctional?
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Yes the same thing happens with trans vs not. I just tried it but I don't use non trans. I am sure this is caused by the update to the OS System so I now think that I must revert back from Mavericks back to Monuntain Lion which means I have to copy everything on my p.c. to restore once I downgrade I am hoping I don't have to do nothing special for ScriptCase once I am back to where I was. I think Mavericks has many bugs. Thanks for looking.

      Comment


      • #4
        scriptcase is not from an identified developer, hence it is likely that it is blocked.
        Try this: http://support.apple.com/kb/PH11436 it is needed for various other programs as well (e.g. lazarus from sourceforge)

        Comment


        • #5
          RR - Not sure who "rr" is but your response to go to this link is incorrect: http://support.apple.com/kb/PH11436.
          Your note is not clear also: script case is not from an identified developer, hence it is likely that it is blocked.
          Try this: http://support.apple.com/kb/PH11436 it is needed for various other programs as well (e.g. lazarus from source forge)

          The link you are sending me is not related to my problem: I am trying to access a database via a database connection, I am not trying to open a program from an "unidentified developer".
          Regardless I thank you for taking the time to respond and provide guidance very much appreciate it.

          Comment


          • #6
            Sorry for that, I was too quick. But the security settings between mountain lion and maverick are different on various places.
            Apparently you need to bind the dns in your my.cnf (or my.conf) according to http://stackoverflow.com/questions/4...n-packet-syste
            other solutions may hopefully be found using your exact error message via google. I found dozens of hits with possible solutions.. Anyway I hope you find it.

            Comment

            Working...
            X