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:[email protected]]
Sent: 16 October 2014 3:37 PM
To: Akila Nimantha [IT/EKO/LOITS]
Cc: Dinesh J Weerakkody; Gihan Anuruddha; [email protected]
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]
<[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>]
Sent: 14 October 2014 5:02 PM
To: Akila Nimantha [IT/EKO/LOITS]
Cc: [email protected]<mailto:[email protected]>
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
<[email protected]<mailto:[email protected]>> wrote:
Hi,
On Mon, Oct 13, 2014 at 6:15 PM, Akila Nimantha [IT/EKO/LOITS]
<[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>]
Sent: 13 October 2014 5:50 PM
To: Akila Nimantha [IT/EKO/LOITS]
Cc: [email protected]<mailto:[email protected]>
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]
<[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>]
Sent: 13 October 2014 4:46 PM
To: Akila Nimantha [IT/EKO/LOITS]
Cc: [email protected]<mailto:[email protected]>
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]
<[email protected]<mailto:[email protected]>> 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
[email protected]<mailto:[email protected]>
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
[email protected]<mailto:[email protected]>
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
[email protected]<mailto:[email protected]>
http://wso2.org/cgi-bin/mailman/listinfo/dev
--
Regards,
Inosh Goonewardena
Associate Technical Lead- WSO2 Inc.
Mobile: +94779966317<tel:%2B94779966317>
_______________________________________________
Dev mailing list
[email protected]<mailto:[email protected]>
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 :
[email protected]<mailto:[email protected]> | 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
[email protected]<mailto:[email protected]>
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
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
