Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Is cPHulk compatible with MySQL TRADITIONAL mode?

Discussion in 'Database Discussion' started by strawbrarian, Jun 5, 2018.

  1. strawbrarian

    strawbrarian Registered

    Joined:
    Apr 11, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    UK
    cPanel Access Level:
    Root Administrator
    MySQL has serveral "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:

    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 cPHulk use MySQL in TRADITIONAL mode, or does it require a more lenient mode?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,230
    Likes Received:
    161
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @strawbrarian

    Actually cPHulk shouldn't be using MySQL anymore (not for awhile) it should be using sqlite with the database located here:

    Code:
    /var/cpanel/hulkd/cphulk.sqlite
    I don't believe the MySQL mode in this instance should matter anymore
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. strawbrarian

    strawbrarian Registered

    Joined:
    Apr 11, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    UK
    cPanel Access Level:
    Root Administrator
    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?
     
  4. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,230
    Likes Received:
    161
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @strawbrarian

    At some point, we might remove them automatically but you can remove it yourself if you'd like to now.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice