Thanks a lot for your quickly reply, but I have changed configuration according to documentation in this file. I have offset set to "1" in BAM and the master-datasources.xml configuration :
master-datasources.xml: ================== <datasources-configuration xmlns:svns=" http://org.wso2.securevault/configuration";> <providers> <provider>org.wso2.carbon.ndatasource.rdbms.RDBMSDataSourceReader</provider> </providers> <datasources> <datasource> <name>WSO2_CARBON_DB</name> <description>The datasource used for registry and user manager</description> <jndiConfig> <name>jdbc/WSO2CarbonDB</name> </jndiConfig> <definition type="RDBMS"> <configuration> <url>jdbc:h2:repository/database/WSO2CARBON_DB;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=60000</url> <username>wso2carbon</username> <password>wso2carbon</password> <driverClassName>org.h2.Driver</driverClassName> <maxActive>50</maxActive> <maxWait>60000</maxWait> <testOnBorrow>true</testOnBorrow> <validationQuery>SELECT 1</validationQuery> <validationInterval>30000</validationInterval> </configuration> </definition> </datasource> <datasource> <name>WSO2BAM_DATASOURCE</name> <description>The datasource used for analyzer data</description> <definition type="RDBMS"> <configuration> <url>jdbc:h2:repository/database/samples/BAM_STATS_DB;AUTO_SERVER=TRUE</url> <username>wso2carbon</username> <password>wso2carbon</password> <driverClassName>org.h2.Driver</driverClassName> <maxActive>50</maxActive> <maxWait>60000</maxWait> <testOnBorrow>true</testOnBorrow> <validationQuery>SELECT 1</validationQuery> <validationInterval>30000</validationInterval> </configuration> </definition> </datasource> <datasource> <name>WSO2BAM_CASSANDRA_DATASOURCE</name> <description>The datasource used for Cassandra data</description> <definition type="RDBMS"> <configuration> <url>jdbc:cassandra://localhost:9161/EVENT_KS</url> <username>admin</username> <password>admin</password> </configuration> </definition> </datasource> <datasource> <name>WSO2BAM_UTIL_DATASOURCE</name> <description>The datasource used for BAM utilities, such as message store etc..</description> <definition type="RDBMS"> <configuration> <url>jdbc:cassandra://localhost:9160/BAM_UTIL_KS</url> <username>admin</username> <password>admin</password> </configuration> </definition> </datasource> <!-- The URL configs are loaded from cassandra-component.xml --> <datasource> <name>WSO2BAM_HIVE_INCREMENTAL_DATASOURCE</name> <definition type="RDBMS"> <configuration> <username>admin</username> <password>admin</password> <dataSourceProps> <property name="replicationFactor">1</property> <property name="strategyClass">org.apache.cassandra.locator.SimpleStrategy</property> <property name="readConsistencyLevel">QUORUM</property> <property name="writeConsistencyLevel">QUORUM</property> <property name="keyspaceName">HIVE_INCREMENTAL_KS</property> </dataSourceProps> </configuration> </definition> </datasource> <datasource> <name>WSO2AM_STATS_DB</name> <description>The datasource used for getting statistics to API Manager</description> <jndiConfig> <name>jdbc/WSO2AM_STATS_DB</name> </jndiConfig> <definition type="RDBMS"> <configuration> <!-- JDBC URL to query the database --> <url>jdbc:h2:<MY_BAM_PATH>/repository/database/APIMGTSTATS_DB;AUTO_SERVER=TRUE</url> <username>wso2carbon</username> <password>wso2carbon</password> <driverClassName>org.h2.Driver</driverClassName> <maxActive>50</maxActive> <maxWait>60000</maxWait> <testOnBorrow>true</testOnBorrow> <validationQuery>SELECT 1</validationQuery> <validationInterval>30000</validationInterval> </configuration> </definition> </datasource> </datasources> </datasources-configuration> Thanks again, Eder 2014-05-26 14:28 GMT+02:00 Udara Rathnayake <[email protected]>: > Hi Eder, > > If you have changed port-offset within BAM please update related > datasource configuration within master-datasources.xml. > Hope this will help. > > Regards, > UdaraR > > > On Mon, May 26, 2014 at 5:48 PM, Eder Castro <[email protected]>wrote: > >> Hi all, >> I want to get stadistics about usage of my apis deployed in AM, but when >> I consume one of my apis, I get one error. >> >> I have installed 1.6.0 AM and 2.4.1 BAM and I do this steps (steps for >> products integration). >> https://docs.wso2.org/display/AM150/Monitoring+Using+WSO2+BAM >> >> I need some help, :D >> >> ERROR IN BAM CONSOLE (When I do a request to a deployed api in AM): >> ======================================================= >> >> [2014-05-26 14:16:32,997] INFO >> {org.wso2.carbon.databridge.core.DataBridge} - user admin connected >> [2014-05-26 14:16:34,363] ERROR >> {me.prettyprint.cassandra.connection.HConnectionManager} - Could not start >> connection pool for host localhost(127.0.0.1):9160 >> [2014-05-26 14:16:34,372] INFO >> {org.wso2.carbon.databridge.persistence.cassandra.datastore.ClusterFactory} >> - Initializing cluster >> [2014-05-26 14:16:34,375] ERROR >> {org.wso2.carbon.databridge.datasink.cassandra.subscriber.BAMEventSubscriber} >> - Error processing event. >> com.google.common.util.concurrent.UncheckedExecutionException: >> me.prettyprint.hector.api.exceptions.HectorException: All host pools marked >> down. Retry burden pu >> shed out to client. >> at >> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2258) >> at com.google.common.cache.LocalCache.get(LocalCache.java:3990) >> at >> com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3994) >> at >> com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4878) >> at >> com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4884) >> at >> org.wso2.carbon.databridge.persistence.cassandra.datastore.ClusterFactory.getCluster(ClusterFactory.java:95) >> at >> org.wso2.carbon.databridge.datasink.cassandra.subscriber.BAMEventSubscriber.receive(BAMEventSubscriber.java:69) >> at >> org.wso2.carbon.databridge.core.internal.queue.QueueWorker.run(QueueWorker.java:81) >> at >> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) >> at java.util.concurrent.FutureTask.run(FutureTask.java:266) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> at java.lang.Thread.run(Thread.java:745) >> Caused by: me.prettyprint.hector.api.exceptions.HectorException: All host >> pools marked down. Retry burden pushed out to client. >> at >> me.prettyprint.cassandra.connection.HConnectionManager.getClientFromLBPolicy(HConnectionManager.java:390) >> at >> me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:244) >> at >> me.prettyprint.cassandra.service.AbstractCluster.describeKeyspace(AbstractCluster.java:199) >> at >> org.wso2.carbon.databridge.persistence.cassandra.datastore.CassandraConnector.createKeySpaceIfNotExisting(CassandraConnector.java:456) >> at >> org.wso2.carbon.databridge.persistence.cassandra.datastore.ClusterFactory.initCassandraKeySpaces(ClusterFactory.java:86) >> at >> org.wso2.carbon.databridge.persistence.cassandra.datastore.ClusterFactory$1.load(ClusterFactory.java:74) >> at >> org.wso2.carbon.databridge.persistence.cassandra.datastore.ClusterFactory$1.load(ClusterFactory.java:54) >> at >> com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3589) >> at >> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2374) >> at >> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2337) >> at >> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2252) >> ... 12 more >> [2014-05-26 14:16:35,370] WARN >> {me.prettyprint.cassandra.connection.CassandraHostRetryService} - Downed >> localhost(127.0.0.1):9160 host still appears to be dow >> n: Unable to open transport to localhost(127.0.0.1):9160 , >> java.net.ConnectException: Connection refused: connect >> >> Thanks a lot! >> Eder >> >> >> >> >> >> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Udara Rathnayake* > Software Engineer > WSO2 Inc. : http://wso2.com > > Mobile : +94 772207239 > Twitter : http://twitter.com/udarakr > Blog : http://udarakr.blogspot.com > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
