CakePHP-DatabaseLog

Improvements

Consolidated different connection through connection config key, and deprecated datasource one.

Fixes

Fixed auto-table-creation for e.g. SQLite

Fixes

Fixed monitor command

CakePHP 5 compatible release

Enjoy!

CakePHP 5 compatible pre-release

Please test. Once this has been tested and approved, the stable release can be tagged.

Fixes

• Fixed up dev dependency.

Fixes

• Fixed bootstrap layout for inline list

Improvements

• Use FrozenTime class where possible instead of basic string usage for date(time) stamps.
• Remove deprecations where possible.

Note: CakePHP 4.3+ and PHP 7.3+ now

Improvements

Better defaults to avoid size overload

• Display DB type and size in dashboard if applicable.
• Log rotation and alerting system improvements

Fixes

Fixed badges for BS4 templating.
The BS3 one (class label instead of badge) can be achieved using config.

CakePHP 4 release

A standalone logging solution for CakePHP apps as database driven approach.
Instead of log files, it logs into an easily searchable and filterable DB backend.

• Detailed log infos added for both Web and CLI log entries.
• Defaults to SQLite as single app application light weight approach.
• Ideal for multi-server or serverless applications where logging to a file is just not convenient.
• Basic monitoring and alert system included.

Fixes

Fixed ORDER BY clause is not in GROUP BY clause for admin dashboard.

CakePHP 4 compatible pre-release.

Please help to finalize for stable release.

Improvements

• Display last errors on dashboard now.
• Remove duplicates by default in non-strict mode (using summary)
• Display URI / CLI command on logs index now

Improvements

For larger log messages (mediumtext) and larger count of rows in your logs table, pagination and other operations will soon become super-slow or even kill the SQL server.
A summary field now takes a truncated version (length of 255), and only that is searchable by default now.

This keeps performance at a good rate. If you need to dive into message content (fulltext search), you need to implement something on top here.

A dashboard has been added for convenience entry into the backend.
The backend is now also Foundation 5+ and BS 3+ compatible in a very basic way.

Migration note: Please make sure you run the included migration. For some DB types it might be necessary to reset the logs here (empty all rows), or manually create valid non-empty summary content.

Improvements

• CakePHP 3.7+ now
• Added FOC/Search as search/filter for log messages as opt-in. Can also be disabled using DatabaseLog.isSearchEnabled config.

Improvements

You can add additional infos into the stacktrace via custom saveCallback callable:

// in your app.php config
'DatabaseLog' => [
	'saveCallback' => function (\DatabaseLog\Model\Entity\DatabaseLog $databaseLog) {
		if (empty($_SESSION) || empty($_SESSION['language'])) {
			return;
		}
		$currentSessionLanguage = $_SESSION['language'];
		$databaseLog->message .= PHP_EOL . 'Language: ' . $currentSessionLanguage;
	},
],

This will run after all the internal processing of the entity has been done, prior to actually saving the log.

Bugfixes

Do not use IP for host name in CLI logging.
Instead, use env('SERVER_NAME'), if provided.

Improvements

• Added CLI vs WEB logging info.
• Added isCli() entity method to quickly check on this and display command info in Logs view action.

Included commits: https://github.com/dereuromark/CakePHP-DatabaseLog/compare/2.3.4...2.4.0

Improvements

Compatibility for CakePHP 3.6+.
Enable PHPStan check. Raise min. CakePHP support to 3.5+.