|
Mantis - Resin
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 16 | minor | always | 03-02-05 00:00 | 04-27-05 00:00 | |
|
|
|||||
| Reporter: | administrator | Platform: | |||
| Assigned To: | OS: | ||||
| Priority: | high | OS Version: | |||
| Status: | closed | Product Version: | |||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 3.0.13 | ||
|
|
|||||
| Summary: | 0000016: jdbc distributed sessions | ||||
| Description: |
RSN-6 The following configuration in cluster for distributed database sessions doesn't work. MS SQL is used for storing session objects. when resin starts up it creates persistent-session table fine. But the session value is not distributed among all resin servers in cluster. Resin 3.0.10 config in Linux for jdbc distributed sessions - ----------------------------------------------------------- <server> <class-loader> <tree-loader path="$resin-home/lib"/> </class-loader> <cluster> <srun server-id="s71" host="10.20.10.71" port="6802" index="1"/> <srun server-id="s72" host="10.20.10.72" port="6802" index="2"/> </cluster> <!-- Cluster-info --> <http id="s71" host="*" port="80"/> <http id="s72" host="*" port="80"/> <!-- setup jndi for database based session persistence --> <database> <!-- LoadBal --> <jndi-name>jdbc/session</jndi-name> <driver type="com.microsoft.jdbc.sqlserver.SQLServerDriver"> <url>jdbc:microsoft:sqlserver://10.20.10.20:1433;databaseName=LoadBal;SelectMethod=cursor</url> [^] <user>LoadBal</user> <password>LoadBal</password> </driver> <prepared-statement-cache-size>8</prepared-statement-cache-size> <max-connections>20</max-connections> <max-idle-time>30s</max-idle-time> </database> <!-- LoadBal --> <!-- tell the system which method we are using for session persistence --> <persistent-store type="jdbc"> <init> <data-source>jdbc/session</data-source> </init> </persistent-store> <web-app-default> <session-config> <always-save-session/> <use-persistent-store/> </session-config> </web-app-default> </server> |
||||
| Steps To Reproduce: | |||||
| Additional Information: | Linux multiple resin boxes with MS SQL database | ||||
| Relationships | |||||
| Attached Files: | |||||
| Notes | |||||
|
|
|||||
|
|
||||