#4124 Virtualmin not detecting running MySQL

closed-fixed
nobody
8
2014-08-18
2012-07-31
Anonymous
No

Forwarding to not fixed bug https://sourceforge.net/projects/webadmin/forums/forum/600157/topic/3700506
Bug cased on CentOS 6.3 with MySQL 5.5.25.
Virtualmin shows MySQL Database Server "Down" even after "Start MySQL". Webmin shows "MySQL is not running on your system - database list could not be retrieved." even after "Start MySQL Server".

# service mysqld status
mysqld (pid 3127) is running...

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-07-31
    • labels: --> MySQL Database
      Server
    • priority: 5 --> 8
     
  • Jamie Cameron

    Jamie Cameron - 2012-07-31

    Can you connct to MySQL from the command line on your system, with a command like :

    mysqladmin -u root -pXXX status

    where XXX is the root password?

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-07-31

    The bug appears when changed encoding to "utf8mb4". Fallow http://mathiasbynens.be/notes/mysql-utf8mb4

    my.cnf
    collation-server = utf8mb4_unicode_ci
    character-set-server = utf8mb4

     
  • Jamie Cameron

    Jamie Cameron - 2012-07-31

    How exactly does changing the encoding cause this problem? Does it stop the mysqladmin command from working?

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-07-31

    mysqld continued to work but webserver returned error 500.

     
  • Jamie Cameron

    Jamie Cameron - 2012-07-31

    Ok .. but what about trying the mysqladmin command I suggested below?

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-08-01

    I checked again with

    collation-server = utf8mb4_unicode_ci
    character-set-server = utf8mb4

    # mysqladmin -u root -p status
    Uptime: 142 Threads: 1 Questions: 334 Slow queries: 0 Opens: 40 Flush tables: 1 Open tables: 33 Queries per second avg: 2.352

     
  • Jamie Cameron

    Jamie Cameron - 2012-08-02

    Does it make any difference if you add the line :

    nodbi=1

    to the end of /etc/webmin/mysql/config

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-08-03

    Thanks, jcameron! I removed "nodbi=0" from /etc/webmin/mysql/config line 6 and added "nodbi=1" in last line.

    Now server no longer returns 500 error when my.cnf has "character-set-client-handshake = FALSE". And Virtualmin and Webmin returns correct MySQL status.

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-08-03

    When /etc/webmin/mysql/config line 6 "nodbi=0" is changed to "nodbi=1", it still will return error 500 and Webmin will not detect the MySQL status.

     
  • Jamie Cameron

    Jamie Cameron - 2012-08-03

    So changing to nodbi=1 fixes the issue?

    If so, that indicates that Perl's DBD::MySQL library is failing to connect to MySQL. Perhaps it cannot handle the different character set..

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-08-04

    Yes, nodbi=1 fixed it. I do not know about Perl's DBD::MySQL connection.

     
  • Jamie Cameron

    Jamie Cameron - 2012-08-05
    • status: open --> closed-fixed
     
  • Jamie Cameron

    Jamie Cameron - 2012-08-05

    Ok, sounds like that is the best fix then.

     

Log in to post a comment.