Mantis Bugtracker
Main | My View | View Issues | Change Log | Docs
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000016 [Resin] minor always 03-02-05 00:00 04-27-05 00:00
Reporter administrator View Status public  
Assigned To
Priority high Resolution fixed  
Status closed   Product Version
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>
Additional Information Linux multiple resin boxes with MS SQL database
Attached Files

- Relationships

- Notes
(0000013)
ferg
03-02-05 00:00

 Fixed with updated to cluster store.
 

- Issue History
Date Modified Username Field Change
03-02-05 00:00 administrator New Issue
11-30-05 00:00 administrator Fixed in Version  => 3.0.13

Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
28 total queries executed.
26 unique queries executed.
Powered by Mantis Bugtracker