Talend monitoring service configuration probleme (SAM)

[_AnonymousUser]

Hi
I have a configuration problem with the impementation of the monitoring service talend (SAM), in my setup I use two CentOs servers a tomcat server and a server containing the runtime talend ,
the architecture:
-)I deployed the service that i want to condume on the runtime instance talend
-)I deployed a job consumer.war in the tomcat server (this job will consume the service deployed)
-)the monitoring service sam_monitoring_service.war on the tomcat server
-)an agent instance talend in osgi container talend(the talend runtime instance)
-)Mysql data source on the tomcat server to store data on a pre-configured MySQL database
according to the log of the tomcat the service is consumed and the sam_monitoring_service.war runs well but at the database tables are empty.

thank you.

[Anonymous]

Hi,
did you make changes to the sam-server-war.war/WEB-INF/logserver.properties?
#for Mysql
#db.datasource=java:comp/env/jdbc/datasource
#db.dialect=mysqlDialect
By default SAM server will use Derby as backend DB, you need to switch to Mysql.
HTH
Xilai

[_AnonymousUser]

yes i did it like this:

db.datasource=java:comp/env/jdbc/datasource
db.dialect=mysqlDialect
db.recreate=false
db.createsql=create_mysql.sql

[Anonymous]

ok, and if the datasource name which you configued in the Tomcat is "jdbc/datasource"?
<Resource name="jdbc/datasource" auth="Container"
type="javax.sql.DataSource" username="test" password="test"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/test"
maxActive="8" maxIdle="30" maxWait="10000"/>
which version of ESB product you're using? 5.3 release?
Regards.
Xilai

[_AnonymousUser]

thanks for your help
yes thats already added to $TOMCAT_HOME/conf/context.xml just with different username and password
and i'm using the 5.3 realease like you said

Regards
Fedi

[Anonymous]

Ok then please check one more configuration in your agent.properties (for consumer.war) and Runtime/etc/org.talend.esb.sam.agent.cfg.
service.url=http://localhost:8040/services/MonitoringServiceSOAP
make sure the correct url is set according to your Tomcat configuration.
if it's no problem then please post the detailed logs in Tomcat and Talend Runtime (log/tesb.log).
Thanks.

[_AnonymousUser]

About the consumer.war i just deployed the talend job on the tomcat ,i dont know what the agent.properties configuration is about
Is there a required configuration of the consumer service ?
Regards .
Fedi