Is cPHulk compatible with MySQL TRADITIONAL mode?

strawbrarian

• June 05, 2018 14:35

MySQL has serveral "[URL=https://dev.mysql.com/doc/refman/5.6/en/sql-mode.html]modes". Some of these are known as "STRICT modes", because in certain conditions they will error out (and cause a transaction to fail) rather than fudge an outcome. As you can read, if you follow that link, one of the strictest modes is the TRADITIONAL mode: [QUOTE]Equivalent to STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION.
Applications backed by MySQL databases should not rely on being able to get away with behaviours that could cause MySQL to throw an error, regardless of the mode of the server, but not all applications are that well-written. Can [URL=https://docs.cpanel.net/search/?product=all&q=68Docs/cPHulk+Brute+Force+Protection]cPHulk use MySQL in TRADITIONAL mode, or does it require a more lenient mode?

• 

  cPanelLauren

  • June 05, 2018 19:47

  Hi @strawbrarian Actually cPHulk shouldn't be using MySQL anymore (not for awhile) it should be using sqlite with the database located here: /var/cpanel/hulkd/cphulk.sqlite
  I don't believe the MySQL mode in this instance should matter anymore

  0
• 

  strawbrarian

  • June 05, 2018 23:38

  cPHulk shouldn't be using MySQL anymore (not for awhile) it should be using sqlite with the database located here: /var/cpanel/hulkd/cphulk.sqlite
  

  
  Looks like you're right! That file does exist on the server and was recently updated, whereas the cphulkd database seems not to have changed for many months. Thanks! Does this mean I ought to delete the cphulkd database from the MySQL server? Or is cPanel/WHM supposed to take care of that automatically?

  0
• 

  cPanelLauren

  • June 06, 2018 12:09

  Hi @strawbrarian At some point, we might remove them automatically but you can remove it yourself if you'd like to now.

  0

Please sign in to leave a comment.