Hi Eder,
On Mon, May 26, 2014 at 7:11 PM, Eder Castro <[email protected]>wrote: > 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> > You are using the default port here still. Please check. > <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 >> >> > -- *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
