HappyFeat

  • Total activity 58
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 3
  • Subscriptions 12

Activity overview

Latest activity by HappyFeat

  • HappyFeat commented,

    1. Community
    2. Databases
    3. MySQL SSL Config Errors

    I ran up a dummy database on my cPanel web server, configured it for SSL and could connect straight away with MySQLi and after changing the hostname to 127.0.0.1 I could connect with PDO. So I just...

  • HappyFeat commented,

    1. Community
    2. Databases
    3. MySQL SSL Config Errors

    I tried it in the /etc/mysql/my.cnf file, no errors in the mysql log! Log says 2025-02-24T08:29:25.922871Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.2025-02-24T08:29:25....

    • View comment
    • HappyFeat
    • Edited
    • 0 votes

  • HappyFeat commented,

    1. Community
    2. Databases
    3. MySQL SSL Config Errors

    Thanks, I'll give it go outside of business hours and let you know how it goes.

  • HappyFeat commented,

    1. Community
    2. Databases
    3. MySQL SSL Config Errors

    The output is - Default options are read from the following files in the given order:/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf The file /etc/my.cnf, doesn't exist, so I would need to create it. /etc/...

  • HappyFeat commented,

    1. Community
    2. Databases
    3. MySQL SSL Config Errors

    It's Ubuntu 22.04.5MySQL version: 8.0.41-0 There's a /etc/mysql/my.cnf file which includes the following file/folder -    /etc/mysql/mysql.conf.d/mysqld.cnf    /etc/mysql/conf.d/ I put the changes ...

  • HappyFeat commented,

    1. Community
    2. Databases
    3. MySQL SSL Config Errors

    I had to modify the script to match the location of my MySQL configuration file, but it returns the correct file locations and mysql is the owner of the files. # for f in $(grep pem /etc/mysql/mysq...

    • View comment
    • HappyFeat
    • Edited
    • 0 votes

  • HappyFeat created a post,

    MySQL SSL Config Errors

    1. Community
    2. Databases

    I'm trying to set up SSL on my MySQL server using the instructions found here -  https://docs.cpanel.net/knowledge-base/security/how-to-configure-mysql-ssl-connections/ But when I restart MySQL, th...

    • HappyFeat
    • Edited
    • 3 followers
    • 11 comments
    • 0 votes

  • HappyFeat commented,

    1. Community
    2. Security
    3. ModSecurity - View actual SQL Injected

    Thanks I'll have a look in the Apache log

  • HappyFeat created a post,

    ModSecurity - View actual SQL Injected

    1. Community
    2. Security

    Is there anywhere where I can view the actual SQL that was attempted to be injected when ModSecurity detects an SQL Injection? When I look at ModSecurity Tools in WHM it doesn't show this informati...

    • HappyFeat
    • Edited
    • 3 followers
    • 2 comments
    • 0 votes

  • HappyFeat commented,

    1. Community
    2. Installation & Updates
    3. How to enable automatic updates

    I think I worked it out - I think I'm seeing these notifications in the morning, but if I don't do it manually it updates that night.