Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorSilverboy
    • CommentTimeNov 30th 2009 edited
     
    When trying to test the connection to my online database I get the following error:
    http://img34.imageshack.us/img34/7028/problemot.th.png
    What could be causing this problem?
  1.  
    It means there is not a valid connection path from your computer to the ip address and port. This can be caused by:

    * The ip address is not reachable from your computer, e.g. because it is on a different network or if firewalls are preventing the traffic.

    * MySQL is not running on that ip or on that port. Or, if it is, it might only accept connections on the same machine (localhost).

    You can verify this from the command line on your computer. Try to establish a connection using the mysql command line client instead:

    mysql -uroot -pPASSWORD -h IPADDRESS -P 3306

    You can also try to ping the ip and see if it is responds. But ping does not always return responses, so it might not work:

    ping IPADDRESS
    • CommentAuthorSilverboy
    • CommentTimeNov 30th 2009
     
    ERROR 2003 (HY000): Can't connect to MySQL server on '80.249.173.141' (111) I get the following error.
    The server and mysql is working,because I have a website on it.
  2.  
    I'm guessing 80.249.173.141 is a host on the public internet, not on a private network. In that case, your ISP is probably blocking external MySQL access for security reasons. You would probably only be able to connect to MySQL by first logging in to the machine using SSH, and then connecting to mysql from the command line on the same machine.

    One way to get Jet Profiler to connect to it would then be to establish and ssh tunnel, see this post:

    http://www.jetprofiler.com/forum/discussion/8/mysql-ssh-tunnel/

    You can also contact your ISP to get more information on how to connect.
    • CommentAuthorSilverboy
    • CommentTimeNov 30th 2009
     
    My website is running on a VPS.It's at a hosting company.But I'll look into that forum post that you linked,and I'll keep you updated.Thanks
    • CommentAuthorSilverboy
    • CommentTimeNov 30th 2009 edited
     
    I typed the following command :
    ssh -N -f -L 3307:localhost:3306 root@80.249.173.141

    and for me it says:
    bind: Address already in use
    channel_setup_fwd_listener: cannot listen to port: 3307
    Could not request local forwarding.

    What now ? :|
  3.  
    Try a different localport, any random number will do as long as it is free. Try e.g.

    ssh -N -f -L 3581:localhost:3306 root@80.249.173.141
    • CommentAuthorSilverboy
    • CommentTimeNov 30th 2009
     
    do you have any idea why my website crashed?

    Unable to establish connection to MySQL
    1045 : Access denied for user 'www-data'@'localhost' (using password: NO)
  4.  
    I doubt an SSH tunnel could make the web site crash. Please check with your ISP.
    • CommentAuthorSilverboy
    • CommentTimeNov 30th 2009
     
    i got the problem solved,the user rights were changed from local to 80.249.173.141.This was the problem.