Hi Inosh, Thanks for the correction.
On Thu, Oct 16, 2014 at 7:06 PM, Inosh Goonewardena <in...@wso2.com> wrote: > Hi, > > On Thu, Oct 16, 2014 at 6:56 PM, Manoj Gunawardena <man...@wso2.com> > wrote: > >> Hi Akila, >> >> seems to be WSO2AM_STATS_DB table doesn't exists and unable to create >> new native thread error indicates the OS cannot create thread for JVM. >> Database configurations correct, but make sure table is created. You can >> start the server with -DsetUp option to create the DB. >> > > -Dsetup will not create the stat DB for you. You have to create it manually > > >> Did u create DB manually? or above option. >> >> If you are still facing the thrift port issue, Please share the >> api-manager.xml >> configuration file. >> >> Thanks >> >> On Thu, Oct 16, 2014 at 3:53 PM, Akila Nimantha [IT/EKO/LOITS] < >> aki...@lolctech.com> wrote: >> >>> 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: T*he 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> 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] >>> *Sent:* 14 October 2014 5:02 PM >>> >>> >>> *To:* Akila Nimantha [IT/EKO/LOITS] >>> *Cc:* 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> >>> wrote: >>> >>> Hi, >>> >>> >>> On Mon, Oct 13, 2014 at 6:15 PM, Akila Nimantha [IT/EKO/LOITS] < >>> 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] >>> *Sent:* 13 October 2014 5:50 PM >>> >>> >>> *To:* Akila Nimantha [IT/EKO/LOITS] >>> *Cc:* 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> 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/</BAMServerURL> >>> >>> <BAMUsername>admin</BAMUsername> >>> >>> <BAMPassword>admin</BAMPassword> >>> >>> <DataSourceName>jdbc/WSO2AM_STATS_DB</DataSourceName> >>> >>> </APIUsageTracking> >>> >>> >>> >>> Regards, >>> >>> Akila >>> >>> >>> >>> >>> >>> *From:* Harsha Kumara [mailto:hars...@wso2.com] >>> *Sent:* 13 October 2014 4:46 PM >>> *To:* Akila Nimantha [IT/EKO/LOITS] >>> *Cc:* 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> 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,TCP,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 >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >>> >>> >>> >>> -- >>> >>> Harsha Kumara >>> >>> Software Engineer, WSO2 Inc. >>> >>> Mobile: +94775505618 >>> >>> Blog: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 >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >>> >>> >>> >>> -- >>> >>> W.G. Gihan Anuruddha >>> >>> Senior Software Engineer | WSO2, Inc. >>> >>> M: +94772272595 >>> >>> 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 >>> >>> >>> >>> >>> -- >>> >>> Regards, >>> >>> Inosh Goonewardena >>> Associate Technical Lead- WSO2 Inc. >>> Mobile: +94779966317 >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> 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 | E : dine...@wso2.com | W : 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 >>> 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 >>> >>> >> >> >> -- >> Manoj Gunawardena >> Tech Lead >> WSO2, Inc.: http://wso2.com >> lean.enterprise.middleware >> Mobile : +94 77 2291643 >> > > > > -- > Regards, > > Inosh Goonewardena > Associate Technical Lead- WSO2 Inc. > Mobile: +94779966317 > -- Manoj Gunawardena Tech Lead WSO2, Inc.: http://wso2.com lean.enterprise.middleware Mobile : +94 77 2291643
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
