Cannot Reproduce
Details
Assignee
Pothys - MitrahSoftPothys - MitrahSoftReporter
Sergio BelliSergio BelliPriority
MajorNew Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Details
Details
Assignee
Pothys - MitrahSoft
Pothys - MitrahSoftReporter
Sergio Belli
Sergio BelliPriority
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Created 23 August 2018 at 10:01
Updated 26 February 2019 at 16:02
Resolved 26 February 2019 at 15:40
Hi everybody.
I'm writing a ticket in order to obtain assistance to perform the right configuration of Lucee clustering over database.
At the moment we have some Lucee instances in production environment for our customers.
For an important customer we want to achieve the goal of getting a cluster in production environment, so I search over the internet for possibile solution to our needs.
I found this document : https://rorylaitila.gitbooks.io/lucee/content/clustering.html
Then I started to follow the instructions :
At first I create the schema over our Mysql production database.
Then I configure in Lucee console the datasource, following the instructions I achieve the goal of having a datasource usable for Session Storage (see lucee-datasources.png)
So I go to my Application.cfc and wrote the configuration of the datasource, something like this
{{<!--- clustering - start --->
<cfset THIS.datasources["lucee_sessions"] = {
class: 'org.gjt.mm.mysql.Driver'
, connectionString: 'jdbc:mysql://something:3306/lucee_sessions?useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=true'
, username: 'username'
, password: "pwd"
, storage:true
} />
<cfset THIS.sessionStorage = "lucee_sessions" />
<cfset THIS.sessionCluster = true />
<cfset THIS.sessionType = "cfml" />
<!--- clustering - end --->
}}
At last I go to "Scope management" on lucee console and I have enabled session storage over database (see lucee-scope-sessionstorage.png)
Let me remark that I leave session type at JEE value (see lucee-scope-sessiontype.png)
In order to get session replicated over cluster nodes by means of a database that's all!
Then I go to home page of my production site and I expect to see created the table named cf_session_data over my database schema lucee_sessions ...
Nothing!
The table is not present!
What I have to do in order to perform this configuration?
There are other documents online that describe the process?
Thanks in advance for every kind of help!