New installation NetTools problem

Discussion in 'Optigold ISP' started by comnett, Jul 7, 2006.

0
  1. #1
    I recently completed my installation of OptigoldISP. Clients are running on WinXP or Win2k machines. Filemaker Pro server is running on Fedora 3. Filemaker Unlimited is running on Win2k. NetTools Version is 3.0.

    Here's the problem. Anytime I trigger an SQL action I get "ERR: Communication failure during handshake. Is there a server running on 172.30.0.14:3306?"

    There is a server running. Other applications access it just fine. No firewalls are running on the clients or server. I get the same results on all the clients.

    Any suggestions as to what I may have missed in the install or configuration?

    Adam Hardy
    Comnett Computer Services
     
    comnett, Jul 7, 2006 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    What version of MySQL is running on that server? Are you able to access it from the client machine (outside of Optigold)?
     
    digitalpoint, Jul 7, 2006 IP
  3. comnett

    comnett Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    MySQL v4.1.16

    Yes, I can reach the SQL server using the Query Browser.
     
    comnett, Jul 7, 2006 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    Try turning on the debugger for it under My Stuff -> System Info

    Try to make the connection from within Optigold, then check the JavaCompanion Log file under your FileMaker Java Extensions folder and see if it yields anything useful.
     
    digitalpoint, Jul 7, 2006 IP
  5. comnett

    comnett Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I found the problem.

    I needed to set the password in MySQL using the OLD_PASSWORD option.

    Should have thought of it sooner. I had the same problem with my FreeRadius server.

    Thanks anyhow.

    Adam
     
    comnett, Jul 7, 2006 IP