Hi Inosh, I have already created WSO2AM_STATS_DB in bam_datasources.xml. and also I am using BAM 2.4.1 version downloaded last week. Please check below for WSO2AM_STATS_DB in bam_datasources.xml
<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> <url>jdbc:oracle:thin:@000.000.000.000.000:0000/fusion</url> <username>stats_db</username> <password>stats_db</password> <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName> <maxActive>50</maxActive> <maxWait>60000</maxWait> <testOnBorrow>true</testOnBorrow> <validationQuery>SELECT 1</validationQuery> <validationInterval>30000</validationInterval> </configuration> </definition> </datasource> Regards, Akila From: Inosh Goonewardena [mailto:in...@wso2.com] Sent: 16 October 2014 3:37 PM To: Akila Nimantha [IT/EKO/LOITS] Cc: Dinesh J Weerakkody; Gihan Anuruddha; dev@wso2.org Subject: Re: [Dev] error in setup BAM server in API cluster setup Hi Akila, Seems like you haven't create the datasource for WSO2AM_STATS_DB to BAM(<BAM_HOME>/repository/conf/datasources/bam_datasources.xml) as mentioned in [1]. However, if you are using BAM version prior to BAM 2.4.1 you have to add the datasource to master-datasources.xml(<BAM_HOME>/repository/conf/datasources/master-datasources.xml) Caused by: java.lang.RuntimeException: Error in getting data source properties: The data source: WSO2AM_STATS_DB does not exist for tenant: carbon.super at org.wso2.carbon.hive.data.source.access.util.DataSourceAccessUtil.getDataSourceProperties(DataSourceAccessUtil.java:57) ... 25 more Caused by: java.lang.RuntimeException: The data source: WSO2AM_STATS_DB does not exist for tenant: carbon.super at org.wso2.carbon.hive.data.source.access.util.DataSourceAccessUtil.getDataSourceProperties(DataSourceAccessUtil.java:47) ... 25 more [1] - https://docs.wso2.com/display/AM170/Publishing+API+Runtime+Statistics#PublishingAPIRuntimeStatistics-ConfiguringWSO2BAM On Thu, Oct 16, 2014 at 3:20 PM, Akila Nimantha [IT/EKO/LOITS] <aki...@lolctech.com<mailto:aki...@lolctech.com>> wrote: Hi Dinesh, Gihan, I think not yet solved the problem. What I did was changed to Oracle and try the same. First started bam server and after gateway, keymanager,publisher and finally store. Now noe api manager nodes up and running without any error.but bam server give error repeatedly. Please check server logs bam and store servers. But I can see api invoke events from bam console(by login to the Cassandra cluster). When I trying to subscribe to a api, bam server going down with outofmemmory message. Regards, Akila From: Dinesh J Weerakkody [mailto:dine...@wso2.com<mailto:dine...@wso2.com>] Sent: 14 October 2014 5:02 PM To: Akila Nimantha [IT/EKO/LOITS] Cc: dev@wso2.org<mailto:dev@wso2.org> Subject: Re: [Dev] error in setup BAM server in API cluster setup Hi Akila, Have you solved your problem? On Mon, Oct 13, 2014 at 11:21 PM, Inosh Goonewardena <in...@wso2.com<mailto:in...@wso2.com>> wrote: Hi, On Mon, Oct 13, 2014 at 6:15 PM, Akila Nimantha [IT/EKO/LOITS] <aki...@lolctech.com<mailto:aki...@lolctech.com>> wrote: Dear Gihan, Yes I used figures displayed in my BAM log. Can you please tell me is there a specific server that I should put these configurations. Because I am trying to add BAM in a clustered setup. My followed document says just <api_home> and so on. So what should I change or both. For now I did same configuration in both four components(Gateway,keymanager,publisher and store). You need to configure usage tracking only in APIM-Gateway nodes. Please make sure APIM-Gateway nodes have the access to above BAM thrift server ports(telnet from gateway nodes to make sure). Regards, Akila From: Gihan Anuruddha [mailto:gi...@wso2.com<mailto:gi...@wso2.com>] Sent: 13 October 2014 5:50 PM To: Akila Nimantha [IT/EKO/LOITS] Cc: dev@wso2.org<mailto:dev@wso2.org> Subject: Re: [Dev] error in setup BAM server in API cluster setup Hi Akila, During the BAM server startup, it will show a message like below. Please use that IP address to connect to BAM. [2014-10-13 14:51:17,448] INFO {org.wso2.carbon.databridge.receiver.thrift.internal.ThriftDataReceiver} - Thrift Server started at 0.0.0.0 [2014-10-13 14:51:17,453] INFO {org.wso2.carbon.databridge.receiver.thrift.internal.ThriftDataReceiver} - Thrift SSL port : 7711 [2014-10-13 14:51:17,456] INFO {org.wso2.carbon.databridge.receiver.thrift.internal.ThriftDataReceiver} - Thrift port : 7611 Regards, Gihan On Mon, Oct 13, 2014 at 5:46 PM, Akila Nimantha [IT/EKO/LOITS] <aki...@lolctech.com<mailto:aki...@lolctech.com>> wrote: Hi harsha, Yes ip is correct .i put port as 7617 because I used 6 as BAM offset. please check below for apiusagetracking element details, <APIUsageTracking> <Enabled>true</Enabled> <PublisherClass>org.wso2.carbon.apimgt.usage.publisher.APIMgtUsageDataBridgeDataPublisher</PublisherClass> <ThriftPort>7617</ThriftPort> <BAMServerURL>tcp://172.20.2.150:7617/<http://172.20.2.150:7617/></BAMServerURL> <BAMUsername>admin</BAMUsername> <BAMPassword>admin</BAMPassword> <DataSourceName>jdbc/WSO2AM_STATS_DB</DataSourceName> </APIUsageTracking> Regards, Akila From: Harsha Kumara [mailto:hars...@wso2.com<mailto:hars...@wso2.com>] Sent: 13 October 2014 4:46 PM To: Akila Nimantha [IT/EKO/LOITS] Cc: dev@wso2.org<mailto:dev@wso2.org> Subject: Re: [Dev] error in setup BAM server in API cluster setup Hi Akila, Seems like it's a connection issue. Have you specified correct IPs and ports in the configurations. Thanks, Harsha On Mon, Oct 13, 2014 at 4:08 PM, Akila Nimantha [IT/EKO/LOITS] <aki...@lolctech.com<mailto:aki...@lolctech.com>> wrote: Hi all, I am trying add BAM server(https://docs.wso2.com/display/AM170/Publishing+API+Runtime+Statistics) in API manager Cluster setup(https://docs.wso2.com/display/CLUSTER420/Clustering+API+Manager). I just trying with default H2 database configurations and I get following error. org.wso2.carbon.databridge.agent.thrift.exception.AgentException: Cannot borrow client for TCP,172.20.2.150:7617<http://172.20.2.150:7617>,TCP,172.20.2.150:7717<http://172.20.2.150:7717> at org.wso2.carbon.databridge.agent.thrift.internal.publisher.authenticator.AgentAuthenticator.connect(AgentAuthenticator.java:58) at org.wso2.carbon.databridge.agent.thrift.DataPublisher.start(DataPublisher.java:273) at org.wso2.carbon.databridge.agent.thrift.DataPublisher.<init>(DataPublisher.java:161) at org.wso2.carbon.databridge.agent.thrift.AsyncDataPublisher$ReceiverConnectionWorker.run(AsyncDataPublisher.java:787) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.thrift.transport.TTransportException: Could not connect to 172.20.2.150 on port 7717 at org.apache.thrift.transport.TSSLTransportFactory.createClient(TSSLTransportFactory.java:212) at org.apache.thrift.transport.TSSLTransportFactory.getClientSocket(TSSLTransportFactory.java:166) at org.wso2.carbon.databridge.agent.thrift.internal.pool.client.secure.SecureClientPoolFactory.makeObject(SecureClientPoolFactory.java:90) at org.wso2.carbon.databridge.agent.thrift.internal.pool.client.secure.SecureClientPoolFactory.makeObject(SecureClientPoolFactory.java:48) at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1212) at org.wso2.carbon.databridge.agent.thrift.internal.publisher.authenticator.AgentAuthenticator.connect(AgentAuthenticator.java:50) ... 8 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:618) at sun.security.ssl.SSLSocketImpl.<init>(SSLSocketImpl.java:407) at sun.security.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:88) at org.apache.thrift.transport.TSSLTransportFactory.createClient(TSSLTransportFactory.java:208) what should I do and when we setup BAM in api cluster is there specific server component(gateway or keymanager or store or publisher or both)to setup???????????????????? Regards, Akila This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you. _______________________________________________ Dev mailing list Dev@wso2.org<mailto:Dev@wso2.org> http://wso2.org/cgi-bin/mailman/listinfo/dev -- Harsha Kumara Software Engineer, WSO2 Inc. Mobile: +94775505618<tel:%2B94775505618> Blog:harshcreationz.blogspot.com<http://harshcreationz.blogspot.com> This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you. _______________________________________________ Dev mailing list Dev@wso2.org<mailto:Dev@wso2.org> http://wso2.org/cgi-bin/mailman/listinfo/dev -- W.G. Gihan Anuruddha Senior Software Engineer | WSO2, Inc. M: +94772272595<tel:%2B94772272595> This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you. _______________________________________________ Dev mailing list Dev@wso2.org<mailto:Dev@wso2.org> http://wso2.org/cgi-bin/mailman/listinfo/dev -- Regards, Inosh Goonewardena Associate Technical Lead- WSO2 Inc. Mobile: +94779966317<tel:%2B94779966317> _______________________________________________ Dev mailing list Dev@wso2.org<mailto:Dev@wso2.org> http://wso2.org/cgi-bin/mailman/listinfo/dev -- Dinesh J. Weerakkody Software Engineer WSO2 Inc. lean | enterprise | middleware M : +94 727 361788<tel:%2B94%20727%20361788> | E : dine...@wso2.com<mailto:dine...@wso2.com> | W : www.wso2.com<http://www.wso2.com> This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you. _______________________________________________ Dev mailing list Dev@wso2.org<mailto:Dev@wso2.org> http://wso2.org/cgi-bin/mailman/listinfo/dev -- Regards, Inosh Goonewardena Associate Technical Lead- WSO2 Inc. Mobile: +94779966317 This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you.
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev