#3872 Can't connect to local MySQL server

fixed
http://www.vim.org/scripts/script.php?script_id=1
vim
2013-05-01
2013-04-30
No

In the last 24 hours, accessing a URL like above gives error:
Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)

That error is the result from mysql_db_query().

I can access the database through the phpMyAdmin web interface as normal.

Inspecting our config files via shell access shows that nothing seems to have changed.

I received two emails about project upgrades, but cannot see any information relevant to MySQL.

How can this be resolved?

Thanks,
John

Discussion

  • Marc Weber

    Marc Weber - 2013-04-30

    logging into the temproary SSH setup I can connect via admin user, however the rw user yields:
    Logging in using SSH I get "ERROR 1203 (42000): User v8rw already has more than 'max_user_connections' active connections"

     
  • John Beckett

    John Beckett - 2013-04-30

    Can mysqld be restarted via shell access?

    I wonder if some kind of attack on the site is causing all those connections, or is it a random glitch.

     
  • Anonymous - 2013-04-30
    • labels: --> siteops, p2, so-53617
    • status: unread --> assigned
    • assigned_to: Chris Tsai
     
  • Anonymous - 2013-04-30

    I've done some further testing, and I found both v8ro and v8admin accounts to be working fine (both via phpmyadmin and shell), whereas v8rw would just continue to prompt for password via phpmyadmin, and shell would, as you've found, show a max connection error.

    I'm escalating this to our operations team to investigate further, I'll keep you posted.

    Regards,
    Chris Tsai, SourceForge.net Support

    PS. the Project Database service is separate from the project tools affected by the Project Upgrade to the Allura system (ie., it's the same on both classic and Allura). So, for this particular issue anyway, the project upgrade would be a red herring.

     
  • Anonymous - 2013-04-30
    • status: assigned --> fixed
     
  • Anonymous - 2013-04-30

    Our staff indicates:

    v8rw has 10 active connections, 4 of which seem to just be sleeping. The other 6 are all waiting for a table lock on vs_sessions. I killed the sleeping connections and the lock went away, freeing up all the waiting slots.

    I just tried http://www.vim.org/scripts/script.php?script_id=1 again and it seems to be working fine now (with a shift+reload, since I had the page with the error message cached)

    Regards,
    Chris Tsai, SourceForge.net Support

     
  • Wayne Davison

    Wayne Davison - 2013-04-30

    Please also change your DB password -- someone might have guessed it.

     
  • John Beckett

    John Beckett - 2013-05-01

    Thanks Chris (and thanks Wayne: I'll discuss the importance of a password change with others).

    Looking around the database shows that someone used Acunetix Web Vulnerability Scanner to probe http://www.vim.org/account/register.php

    They created at least 124 user accounts, which I have not yet deleted so others can view them. I'll think about how the form might be fixed; any clues about what's achievable would be appreciated.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks