DatabaseLog CakePHP plugin to log into DB instead of files. Better to filter and search.
MIT License
Consolidated different connection through connection
config key, and deprecated datasource
one.
Published by dereuromark 9 months ago
Fixed auto-table-creation for e.g. SQLite
Published by dereuromark 11 months ago
Fixed monitor command
Published by dereuromark 11 months ago
Enjoy!
Published by dereuromark about 1 year ago
Please test. Once this has been tested and approved, the stable release can be tagged.
Published by dereuromark about 1 year ago
Published by dereuromark over 1 year ago
Published by dereuromark almost 3 years ago
Note: CakePHP 4.3+ and PHP 7.3+ now
Published by dereuromark over 3 years ago
Better defaults to avoid size overload
Published by dereuromark almost 4 years ago
Fixed badges for BS4 templating.
The BS3 one (class label instead of badge) can be achieved using config.
Published by dereuromark about 4 years ago
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.
Published by dereuromark over 4 years ago
Fixed ORDER BY clause is not in GROUP BY clause
for admin dashboard.
Published by dereuromark almost 5 years ago
Please help to finalize for stable release.
Published by dereuromark over 5 years ago
Published by dereuromark over 5 years ago
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.
Published by dereuromark almost 6 years ago
DatabaseLog.isSearchEnabled
config.Published by dereuromark almost 6 years ago
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.
Published by dereuromark almost 6 years ago
Do not use IP for host name in CLI logging.
Instead, use env('SERVER_NAME')
, if provided.
Published by dereuromark almost 6 years ago
isCli()
entity method to quickly check on this and display command info in Logs view action.Published by dereuromark over 6 years ago
Included commits: https://github.com/dereuromark/CakePHP-DatabaseLog/compare/2.3.4...2.4.0
Compatibility for CakePHP 3.6+.
Enable PHPStan check. Raise min. CakePHP support to 3.5+.