Mantis - Resin
Viewing Issue Advanced Details
16 minor always 03-02-05 00:00 04-27-05 00:00
administrator  
 
high  
closed  
fixed  
none    
none 3.0.13  
0000016: jdbc distributed sessions
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>
Linux multiple resin boxes with MS SQL database

Notes
(0000013)
ferg   
03-02-05 00:00   
Fixed with updated to cluster store.