SAM server configuration with mysql backend in ESB

[premchandkar]

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.

[Anonymous]

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

[Anonymous]

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

[premchandkar]

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.

[Anonymous]

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

[premchandkar]

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 

[Anonymous]

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

[VincentC1]

Hello,

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

Thanks