CODEWITHSUNDEEP
log4jmulemule-flow
brelian
brelian

Reputation: 503

mule log files into DB

In mule CE version 3.3.0, I have a mule project, and the URL for calling it is http://localhost:8086/mule?msg=Hello-World!!!.

Every time that I call it, in a log file in mule server that it has as a default some lines added as a log.

Now I want to change type of logs in mule? I want to instead the file that mule create it for logs, as a default mule create a table into Database and save important info into it.

Actually I want to have a table log for my projects, and in this table I want to have customers' information such as IP and ...

Is it possible? How can I do it?

Upvotes: 1

Views: 1185

Answers (1)

Vishnu Mishra
Vishnu Mishra

Reputation: 26

You can use Log4j database appender to insert Mule ESB logs into database. Below code snippet is used to do the same.

<appender name="DB" class="org.apache.log4j.jdbc.JDBCAppender">
   <param name="url" value="jdbc:mysql://localhost/DBNAME"/>
   <param name="driver" value="com.mysql.jdbc.Driver"/>
   <param name="user" value="user_id"/>
   <param name="password" value="password"/>
   <param name="sql" value="INSERT INTO LOGS VALUES('%level','%message','%X{muleMessage}','%X{payload}')"/>

   <layout class="org.apache.log4j.PatternLayout">
   </layout>
</appender>

<logger name="log4j.rootLogger" additivity="false">
   <level value="DEBUG"/>
   <appender-ref ref="DB"/>
</logger>

Upvotes: 1

Related Questions