0.4.2

What's Changed

• Added SQL strict mode check in #114

Full Changelog: 0.4.1...0.4.2

0.4.1

What's Changed

• #110 Ensure innodb_file_per_table is ON
• Time based test now injects current date
• Improve test coverage

Full Changelog: 0.4.0...0.4.1

0.4.0

We now can support parsing MySQL create statements and process them with Cadfael using a new run-statement command:

cadfael run-statment resources/mysql/sample.sql

There are some limits here due to the PHP-SQL-Parser library involved that still need to be fixed and properly tagged into releases. At this point UPDATE statements are not supported so a complex DDL file containing multiple CREATE and ALTER statements might return confused results. The application should warn appropriately.

Consider this feature experimental for the moment.

0.3.3

What's Changed

• Fix option shortcode conflict
• Super privilege check (#85)
• Added additional feedback on missing access (if the account used to perform the run doesn't have access to specific tables it will warn the user at the start of the run)
• Increase test coverage and added missing tests. Code coverage is now at 100%
• Added warning for deprecated authentication method in OutdatedAuthenticationMethod check (#85)
• Added in EoL timescale for MySQL 8.1 for UnsupportedVersion
• Minor fixes and improvements as well.
• Update packages and phpcs fixes

0.3.2

What's Changed

• Code coverage improvement by @xsist10 in #92
• Refactored data objects to use PHP 8 constructor declarations. by @xsist10 in #91
• Outdated authentication plugins by @xsist10 in #94
• Locked accounts by @xsist10 in #96
• Refactored query and cleaned up some query bugs. by @xsist10 in #97

Full Changelog: 0.3.1...0.3.2

0.3.1 - Full PHP 8

Important

The minimum PHP version for Cadfael has been bumped to PHP 8.0. In the near future this will be bumped to 8.2 to get support for enums.

To offset this for users stuck on earlier version I will be looking at providing a docker based version that can be run from a container to make it easier for portable usage.

What's Changed

• Misc cleanup by @xsist10 in #87
• Added documentation around ENVIRONMENT VARIABLES by @xsist10 in #88
• Automate the version detection by @xsist10 in #89
• Added Passwordless Account check (#84) by @xsist10 in #86
• Fixed a backwards references to databases in accounts by @xsist10 in #90

Full Changelog: 0.2.6...0.3.1

0.2.6 - Tooling

What's Changed

• Dockerfile now boots and runs tests properly by @xsist10 in #76
• More environmental options by @xsist10 in #77
• User can set reporting level by @xsist10 in #80
• Added version number to CLI output. by @xsist10 in #81
• Bumped version by @xsist10 in #82

Full Changelog: 0.2.5...0.2.6

0.2.5 - Hardening

What's Changed

• Bumped composer dependency versions
• BUGFIX: InformationSchema: version and create_options can be null on mysql 5.7 by @staabm
• BUGFIX: Undefined array key "no_quotes"
• BUGFIX: Avoid loading performance_schema when flag not passed by
• DEV: First iteration of composer setup for docker based development.
• FEATURE: Setup support for environmental variables
• REFACTOR: Refactored Tables in Query Lookup

New Contributors

• @staabm made their first contribution in #65

Full Changelog: 0.2.4...0.2.5

Checks and bugs

What's Changed

• Detect Low cardinality columns using expensive storage for #58
• Bugfix and refactor of sql_require_primary_key check #60

Mascot, Visuals and Query Analysis

• New Mascot for Cadfael!
• External password file can be used for CI work.
• Query parsing supported and first check for functions on index columns in WHERE statement.
• New visual layout for results.
• Added testing resources for testing.