topic Re: SAM server configuration with mysql backend in ESB in Talend Studio

SAM server configuration with mysql backend in ESB

premchandkar — Sat, 16 Nov 2024 11:15:23 GMT

Hi can any one help me to configure mysql database as my datasource with SAM server for ESB.Please give me some detail steps to configure mysql server in SAM server.

Re: SAM server configuration with mysql backend in ESB

Anonymous — Fri, 10 Apr 2015 12:12:12 GMT

Need details to connect mysql as Datasource instead of Derby(Default) any quick suggestions are appreciated . Thanks in Advance.

Re: SAM server configuration with mysql backend in ESB

Anonymous — Mon, 13 Apr 2015 03:29:22 GMT

Hi,
SAM supports multiple backend DB, e.g MySQL, DB2, Oracle, etc, Derby is the default, if you want to switch to using MySQL Database, please following the steps:
1. install MySQL driver: install mvn:mysql/mysql-connector-java/5.1.18
2. install the provided MySQL datasource feature: features:install tesb-datasource-mysql
3. edit properties in the Container/etc/org.talend.esb.datasource.mysql.cfg according to your MySQL env.
HTH

Re: SAM server configuration with mysql backend in ESB

premchandkar — Mon, 13 Apr 2015 10:11:30 GMT

Hi,
I tried those steps but whenever am starting SAM server through karaf, bydefault derby is running in backend in place of mysql though i placed mysql connector and set the config file with mysql env.

Re: SAM server configuration with mysql backend in ESB

Anonymous — Mon, 20 Apr 2015 07:15:56 GMT

Hi,
Please stop the default SAM (tesb:stop-sam) before you do the steps I proposed. and additional steps:
4) edit etc/org.talend.esb.sam.server.cfg
    db.datasource=ds-mysql
    db.dialect=mysqlDialect
5) install SAM server by features
    features:install tesb-sam-service-soap tesb-sam-service-rest

Re: SAM server configuration with mysql backend in ESB

premchandkar — Thu, 18 Jun 2015 08:37:33 GMT

Still am not getting the right solution though i follow the above steps ....
Could anyone give me some more info..to configure SAM server with mysql as backend
Thanks in Advance

Re: SAM server configuration with mysql backend in ESB

Anonymous — Tue, 20 Sep 2016 08:37:55 GMT

Hi Prem,
Please follow the following steps in order to configure SAM server. let me know if have any questions or email to me my email id is ambothu.kumar@ossscube.com. By using following steps I successfully configured SAM server in TAC.
Service Activity monitoring : Here, we have to install agent (By default, it come in Talend ESB/Run time installation) and server
Agent Config file : /opt/Talend-6.1.1/esb/container/etc/org.talend.esb.sam.agent.cfg
Here, we installed SAM in apache-tomcat server. For installing SAM server, we need to copy sam-server-war.war file from /opt/Talend-6.1.1/esb/add-ons/sam/sam-server-war.war to /opt/Talend-6.1.1/tac/apache-tomcat/webapps/ and then restart apache-tomcat server.

URL : http://<domain>:8080/sam-server-war/services/sam for access SAM server. https://lh3.googleusercontent.com/MUpq_l6A272O25MEV8BQsFETm7GoEXfdhI9rzchwC2dZ9EgYddheCeN6Te3VtRdNQ

To see the whole post, download it here
OriginalPost.pdf

Re: SAM server configuration with mysql backend in ESB

VincentC1 — Fri, 22 Feb 2019 09:05:24 GMT

Hello,

My DB account authentification is securised with the properties sha256_password.
Could you tell me how i can configure the SAM datasource ?

Thanks