1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySQL server has gone away (4.1.15)

Discussion in 'Plesk for Linux - 8.x and Older' started by piotrek, Nov 23, 2005.

  1. piotrek

    piotrek Guest

    0
     
    Hi All,

    I use: Mysql 4.1.15, PHP 4.4.1, FC3 from ART.
    I did an upgrade from ART from Mysql 3.23 to 4.1.15 on fresh box with Plesk 7.5.4. Im getting problems with "MySQL server has gone away" and ~ "MySQL lost connection during query" while connecting and doing queries from regular users, added from Plesk control panel. For example:

    [root@hostname ~]# mysql -u REGULAR_USER -p PASSWORD DATABASE_OF_THIS_REGULAR_USER -e 'show tables'
    ERROR 2006 (HY000) at line 1: MySQL server has gone away

    and with all other queries...!

    When i tried to do it with admin user (admin user from Plesk is also root of mysql of course), all works really fine!

    My admin password was not changed since box and plesk installation even after upgrade from ART. I thought that is a problem of famous old_passwords but it is not.

    I dont know what to do Please advice me ...

    Should I downgrade mysql to 3.23. or 4.0?
    Which version of Mysql server is working stable?

    Peter
     
  2. acidbox

    acidbox Guest

    0
     
    I use the Distrib 4.1.10 from ART with no problem on 7.5.4
     
  3. piotrek

    piotrek Guest

    0
     
    i see there only 4.1.12 and newer...
     
  4. acidbox

    acidbox Guest

    0
     
  5. poke

    poke Guest

    0
     
    I've found that giving the server a reboot, then running:
    mysql_fix_priviledge_tables --user=admin --password=`cat /etc/psa/.psa.shadow` and then all of my problems go away, but I've never seen the error "MySQL server has gone away" ...

    Anyway, I have had to run the above and this fixed any issue after updating mysql...
     
  6. piotrek

    piotrek Guest

    0
     
    acidbx, i see now, thanks :)
     
  7. poke

    poke Guest

    0
     
    sure ;)
     
  8. piotrek

    piotrek Guest

    0
     
    thanks poke, i'll try your method...but except of reboot i did mysql_fix_priviledge_tables :)
     
  9. poke

    poke Guest

    0
     
    lol, i read the post wrong... Sorry :D
     
  10. piotrek

    piotrek Guest

    0
     
    unfortunetly reboot didn't help ... last thing i can do is to downgrade Mysql, remove mysql 4.1.15 installation and install mysql 4.1.10 from rpm's....

    yum remove mysql mysql-server mysql-compat

    rpm -i myslql*

    is that correct?
     
  11. poke

    poke Guest

    0
     
    hmm. i 'm not quite sure, I am using the 4.1.15 and it's working great, so I'm not sure that you need to downgrade.

    Is this a production box??!
     
  12. piotrek

    piotrek Guest

    0
     
    Not yet because mysql, but it should :)

    Btw. is not only "Mysql server has gone away":

    As you can see it's also, Lost connection to MySQL server during query.

    I read somewhere that could be caused by wrong settings in /etc/hosts and someone else said that allowing mysqld in /etc/hosts.allow fixed such problems....but i tried almost everything ;-)

    Peter
     
  13. ShadowMan@

    ShadowMan@ Guest

    0
     
    The location you are testing from isn't using a multi-connection rotating/proxy type device is it? I have seen more posts recently (here and other forums) where multiple ISP connections joined by routers to aggregate the connection speeds (or load balancing) have caused connection disconnects. (I hope I'm phrasing it properly)
     
  14. piotrek

    piotrek Guest

    0
     
    it's local connection, not remote so disconnects are practically impossible :)

    Nevermind, i fixed it....BUT, simply commenting lines in my my.cnf file trying to detect possible syntax errors.... I found one long line which dont want to be wraped...:)

    Great thanks for all who decided to help me.
    It was good motivation to intensive thinking... :)
     
  15. fuzzball

    fuzzball Guest

    0
     
Loading...