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

Viewing Issue Advanced Details [ Jump to Notes ] [ View Simple ] [ 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 Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 3.0.13 Product Version
  Product Build
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
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