Lucee Database Session Storage

allow_storage.png

alter_table.sql

USE lucee_sessions;
ALTER TABLE cf_session_data ADD PRIMARY KEY(cfid,name);

Application.cfc

component {

	this.datasources["lucee_sessions"] = {
		  class: 'org.gjt.mm.mysql.Driver'
		, connectionString: 'jdbc:mysql://192.168.33.10:3306/lucee_sessions?useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=true'
		, username: 'lucee_sessions'
		, password: "encrypted:8c3ea865feab8133a7614f58aee150cddee0ed6f82a476f1"
		
		// optional settings
		, storage:true // default: false
	};

	this.sessionTimeout = createTimeSpan(0,0,20,0); //Set a default session timeout of 20 minutes
	this.sessionStorage = "lucee_sessions"; //Set our session storage to the lucee_sessions datasource
	this.sessionCluster = true; //Set true if more than one Lucee instance connected to the same sessison store
	this.sessionType = "cfml"; //Needed for session clustering

	function onSessionStart(){
		session.someData = "My Data";
	}
}

database.sql

CREATE DATABASE lucee_sessions;
CREATE USER lucee_sessions@'localhost' identified by '123456';
GRANT ALL ON lucee_sessions.* to lucee_sessions@'localhost' identified by '123456';
FLUSH PRIVILEGES;

index.cfm

<cfdump var="#now()#">

mysql_create.png

session_data.png

storage_yes.png