Hello everyone,

I'm a newbie to MojoPortal, evaluating it for some weeks, probably going to use it in a new project coming in.

Everything in mojo seems very easy and straight-forward. However I'm not figuring out how to change my System Log to write in my database instead of file system. I already created the "Log" table in MySql  log4net database, and changed log4net.config appender to something like:

<appender name="ADONetAppender" type="log4net.Appender.ADONetAppender">
<bufferSize value="1"/>
<connectionType value="MySql.Data.MySqlClient.MySqlConnection, MySql.Data"/>
<connectionString value="server=localhost;uid=mojouser;pwd=mojo123;database=log4net;"/>
<commandText value="INSERT INTO Log Date,Thread,Level,Logger,Message,Exception,Context) VALUES (?log_date, ?thread, ?log_level, ?logger, ?message, ?exception, ?context)"/>
<parameter>

.......... </appender>

changed the appender ref as follows:

<appender-ref ref="ADONetAppender"/>

and commented the lines refering and defining RollingLogFileAppender.

What am I doing wrong?

I'm using Windows 7, MySQL database and MojoPortal 2.3.4.5

Cheers,

Carlos