Hi there,
Now I get another error.
localhost:1090 > load virtualdatabase configuration
/usr/sequoia-2.10.1/config/virtualdatabase/itecban-recovery-mysql.xml
XML file /usr/sequoia-2.10.1/config/virtualdatabase/itecban-recovery-mysql.xml
successfully sent to Sequoia controller.
localhost:1090 > load virtualdatabase configuration
/usr/sequoia-2.10.1/config/virtualdatabase/itecban-mysql.xml
Loading of virtual databases configuration file failed (because of
Failed to create JDBC RecoveryLog).
The controller output is the following
[EMAIL PROTECTED]:/usr/sequoia-2.10.1$ sudo ./bin/controller.sh
10:13:29,862 INFO controller.core.Controller Sequoia controller (2.10.2)
10:13:29,993 INFO controller.core.Controller Loading configuration
file: /usr/sequoia-2.10.1/config/controller/controller.xml
10:13:30,188 INFO controller.core.Controller JMX is enabled
10:13:30,266 INFO controller.core.Controller Starting JMX server on
host: 127.0.0.1
10:13:30,563 INFO controller.core.Controller Waiting for connections
on 0.0.0.0:25322
10:13:30,596 INFO controller.core.Controller Controller started on
2006.10.31 44 at 10:13:30 AM CET
10:13:30,596 INFO controller.core.Controller Controller
127.0.0.1:25322 ready, listening to requests ...
10:13:44,884 INFO backend.DatabaseBackend.ITECBAN_RECOVERY_DB Adding
connection manager for virtual user "itecban"
10:13:44,975 INFO controller.RequestManager.ITECBAN_RECOVERY_DB
Request manager will parse requests with the following granularity:
NO_PARSING
10:13:44,988 INFO controller.core.Controller Adding VirtualDatabase
ITECBAN_RECOVERY_DB
10:13:46,930 INFO aolias.indra.es Adding connection manager for
virtual user "itecban"
10:13:47,261 ERROR controller.xml.DatabasesParser Failed to create
JDBC RecoveryLog
java.lang.RuntimeException: Unable to connect to the database:
java.sql.SQLException: Failed to get connection
(java.sql.SQLException: No controller is available to accept
connections)
at
org.continuent.sequoia.controller.recoverylog.RecoveryLog.<init>(RecoveryLog.java:291)
at
org.continuent.sequoia.controller.xml.DatabasesParser.newRecoveryLog(DatabasesParser.java:2818)
at
org.continuent.sequoia.controller.xml.DatabasesParser.startElement(DatabasesParser.java:599)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:287)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:336)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:223)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:245)
at
org.continuent.sequoia.controller.management.Controller.addVirtualDatabases(Controller.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414)
at javax.management.StandardMBean.invoke(StandardMBean.java:323)
at
com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at
org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318)
at
org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:135)
at
javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1408)
at
javax.management.remote.rmi.RMIConnectionImpl.access$100(RMIConnectionImpl.java:81)
at
javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1245)
at java.security.AccessController.doPrivileged(Native Method)
at
javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1348)
at
javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:782)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)
10:13:47,292 WARN controller.core.Controller Loading of virtual
databases configuration file failed (because of Failed to create JDBC
RecoveryLog).
java.lang.RuntimeException: Unable to connect to the database:
java.sql.SQLException: Failed to get connection
(java.sql.SQLException: No controller is available to accept
connections)
at
org.continuent.sequoia.controller.xml.DatabasesParser.newRecoveryLog(DatabasesParser.java:2826)
at
org.continuent.sequoia.controller.xml.DatabasesParser.startElement(DatabasesParser.java:599)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:287)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:336)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:223)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:245)
at
org.continuent.sequoia.controller.management.Controller.addVirtualDatabases(Controller.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414)
at javax.management.StandardMBean.invoke(StandardMBean.java:323)
at
com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at
org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318)
at
org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:135)
at
javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1408)
at
javax.management.remote.rmi.RMIConnectionImpl.access$100(RMIConnectionImpl.java:81)
at
javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1245)
at java.security.AccessController.doPrivileged(Native Method)
at
javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1348)
at
javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:782)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)
################################################
It might be my config files??
Because the db connectivity works fine, and the mysql users have the
rights to boths db...
###############################################
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.2//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.2.dtd";>
<SEQUOIA>
<VirtualDatabase name="ITECBAN_DB">
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select"
caseSensitive="false"
applyToSkeleton ="false"
monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<AuthenticationManager>
<!-- Administrador para la consola de adminsitracion -->
<Admin>
<User username="admin"
password="admin"/>
</Admin>
<!-- Usuario virtual que usa nuestra aplicacion cliente
para
acceder a la bbdd
virtual-->
<VirtualUsers>
<VirtualLogin vLogin="itecban"
vPassword="itecban"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="aolias.indra.es"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/ITECBAN_DB"
connectionTestStatement="select 1">
<ConnectionManager vLogin="itecban"
rLogin="itecbanITECBAN_DB"
rPassword="itecban">
<VariablePoolConnectionManager
initPoolSize="40"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager caseSensitiveParsing="false">
<RequestScheduler>
<SingleDBScheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table">
<DefaultResultCacheRule>
<RelaxedCaching timeout="10"
keepIfNotDirty="false"/>
</DefaultResultCacheRule>
</ResultCache>
</RequestCache>
<LoadBalancer>
<SingleDB/>
</LoadBalancer>
<RecoveryLog
driver="org.continuent.sequoia.driver.Driver"
url="jdbc:sequoia://localhost:25325/ITECBAN_RECOVERY_DB"
login="itecban"
password="itecban">
<RecoveryLogTable tableName="logtable"
sqlColumnName="ssql"/>
<CheckpointTable tableName="checkpointtable"/>
<BackendTable tableName="backendtable"/>
<DumpTable tableName="dumptable"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
###############################################
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 1.0//EN"
"http://www.objectweb.org/c-jdbc/dtds/c-jdbc-2.10.2.dtd";>
<SEQUOIA>
<VirtualDatabase name="ITECBAN_RECOVERY_DB">
<AuthenticationManager>
<Admin>
<User username="admin"
password="admin"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="itecban"
vPassword="itecban"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="ITECBAN_RECOVERY_DB"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ITECBAN_RECOVERY_DB"
connectionTestStatement="select 1">
<ConnectionManager vLogin="itecban"
rLogin="itecban"
rPassword="itecban">
<VariablePoolConnectionManager initPoolSize="5"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager caseSensitiveParsing="false">
<RequestScheduler>
<SingleDBScheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<SingleDB/>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Thanks in advance
Alfonso
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
