[Sequoia] COMMAND show backend *

[Rakesh D]

Hi,
 
 I got the following mesg when I entered command show backend *:
 
 +--------------------------+-------------------------------------+
 | Backend Name             | node1                               |
 | Driver                   | org.gjt.mm.mysql.Driver             |
 | URL                      | jdbc:mysql://localhost:3306/test    |
 | Active transactions      | 0                                   |
 | Pending Requests         | 0                                   |
 | Read Enabled             | false                               |
 | Write Enabled            | false                               |
 | Is Initialized           | false                               |
 | Static Schema            | false                               |
 | Connection Managers      | 1                                   |
 | Total Active Connections | 40                                  |
 | Persistent Connections   | 0                                   |
 | Total Requests           | 0                                   |
 | Total Transactions       | 0                                   |
 | Last known checkpoint    | <unknown>                           |
 +--------------------------+-------------------------------------+
 | Backend Name             | node2                               |
 | Driver                   | org.gjt.mm.mysql.Driver             |
 | URL                      | jdbc:mysql://10.10.10.214:3306/test |
 | Active transactions      | 0                                   |
 | Pending Requests         | 0                                   |
 | Read Enabled             | false                               |
 | Write Enabled            | false                               |
 | Is Initialized           | false                               |
 | Static Schema            | false                               |
 | Connection Managers      | 1                                   |
 | Total Active Connections | 40                                  |
 | Persistent Connections   | 0                                   |
 | Total Requests           | 0                                   |
 | Total Transactions       | 0                                   |
 | Last known checkpoint    | <unknown>                           |
 +--------------------------+-------------------------------------+
 In both the bases, Write Enabled, Static Enabled and Read Enabled are false. 
How can I set values of these variable TRUE. 
 
 This is my virtualdatabase file(test.xml):
 
 <?xml version="1.0" encoding="UTF-8"?> 
 <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.3//EN" 
"http://sequoia.continuent.org/dtds/sequoia-2.10.3.dtd";> 
  
 <SEQUOIA> 
    
   <VirtualDatabase name="test"> 
   <Monitoring> 
   <SQLMonitoring defaultMonitoring="off"> 
       <SQLMonitoringRule queryPattern="^select" caseSensitive="false" 
applyToSkeleton ="false" monitoring="on"/> 
       </SQLMonitoring> 
   </Monitoring> 
  
     <Backup> 
       <Backuper backuperName="MSSQLServer" 
className="org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper" 
options=""/> 
     </Backup> 
  
     <AuthenticationManager> 
       <Admin> 
           <User username="root" password="test"/> 
       </Admin>  
       <VirtualUsers> 
         <VirtualLogin vLogin="user" vPassword="test"/> 
       </VirtualUsers> 
     </AuthenticationManager> 
  
     <DatabaseBackend name="node1" driver="org.gjt.mm.mysql.Driver" 
url="jdbc:mysql://localhost:3306/test" connectionTestStatement="select 1"> 
       <ConnectionManager vLogin="user" rLogin="root" rPassword="test"> 
         <VariablePoolConnectionManager initPoolSize="40"/> 
       </ConnectionManager> 
     </DatabaseBackend> 
     <DatabaseBackend name="node2" driver="org.gjt.mm.mysql.Driver" 
url="jdbc:mysql://10.10.10.214:3306/test" connectionTestStatement="select 1"> 
     <ConnectionManager vLogin="user" rLogin="root" rPassword="my123"> 
         <VariablePoolConnectionManager initPoolSize="40"/> 
       </ConnectionManager> 
     </DatabaseBackend> 
  
     <RequestManager> 
  
       <RequestScheduler> 
         <RAIDb-1Scheduler level="passThrough"/> 
       </RequestScheduler> 
  
       <RequestCache> 
         <MetadataCache/> 
         <ParsingCache/> 
         <ResultCache granularity="table" /> 
       </RequestCache> 
  
       <LoadBalancer> 
         <RAIDb-1> 
           <RAIDb-1-RoundRobin/> 
         </RAIDb-1> 
       </LoadBalancer> 
  
       <RecoveryLog driver="org.gjt.mm.mysql.Driver" 
url="jdbc:mysql://localhost:3306/eglog" login="root" password="test"> 
  
         <RecoveryLogTable/> 
  
         <CheckpointTable/> 
  
         <BackendTable/> 
  
         <DumpTable/> 
  
       </RecoveryLog> 
     </RequestManager> 
   </VirtualDatabase> 
 </SEQUOIA> 
 
 
 
 And this is my controller.xml:
 
 <?xml version="1.0" encoding="UTF-8" ?>
 <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD [EMAIL 
PROTECTED]@//EN" "http://sequoia.continuent.org/dtds/[EMAIL PROTECTED]@.dtd">
 <SEQUOIA-CONTROLLER>
     <Controller ipAddress="127.0.0.1" port="25322">
         <JmxSettings>
             <RmiJmxAdaptor port="1090"/>
         </JmxSettings>
     <VirtualDatabase configFile="test.xml" virtualDatabaseName="test" 
autoEnableBackends="true"/>
     </Controller>
 </SEQUOIA-CONTROLLER>
 
 Please help me to solve this issue.
 Regards,
 Rakesh
 
 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/sequoia