Download the PHP package webwings/mysql-session-handler without Composer
On this page you can find all versions of the php package webwings/mysql-session-handler. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download webwings/mysql-session-handler
More information about webwings/mysql-session-handler
Files in webwings/mysql-session-handler
Package mysql-session-handler
Short Description MySQL session handler for Nette Framework with optionally encrypted storage
License MIT
Informations about the package mysql-session-handler
MySQL Session handler
Custom PHP session handler for Nette Framework that uses MySQL database for storage.
Requirements
- nette/utils 2.4+
- PHP 7.3+
Installation
Preferred way to install webwings/mysql-session-handler is by using Composer:
Setup
After installation:
1) Create the table sessions using SQL in sql/create.sql.
2) Register an extension in config.neon:
3) Setup DatabaseStorage
Features
- For security reasons, Session ID is stored in the database as an SHA-256 hash.
- Supports encrypted session storage via spaze/encryption which uses paragonie/halite which uses Sodium.
- Events that allow you to add additional columns to the session storage table for example.
- Multi-Master Replication friendly (tested in Master-Master row-based replication setup).
Encrypted session storage
Follow the guide at spaze/encryption to define a new encryption key.
Define a new service:
Add the new encryption service to the session handler:
Migration from unecrypted to encrypted session storage is not (yet?) supported.
Events
onBeforeDataWrite
The event occurs before session data is written to the session table, both for a new session (when a new row is inserted) or an existing session (a row us updated). The event is not triggered when just the session timestamp is updated without any change in the session data.
You can add a new column by calling setAdditionalData()
in the event handler:
Use it to store for example user id to which the session belongs to.
Credits
This is heavily based on MySQL Session handler by Pematon (Marián Černý & Peter Knut & Michal Špaček) thanks!