<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I've noticed this behaviour as well and asked about it on this list [1].<div>But it went passed unnoticed.</div><div><br></div><div>It seems that the mysql.sql file has the same missing column names.</div><div>When I added those column names, everything ran perfectly.</div><div><br></div><div>Regards,</div><div><br></div><div>Simon</div><div><div><br></div><div><br></div><div>[1] <a href="http://markmail.org/message/eqlyxeqjtd7jogsj">http://markmail.org/message/eqlyxeqjtd7jogsj</a> </div><div><br><div><div>On 3 Jun 2011, at 20:00, Stephen Schaeffer wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
Hi all,
<div><br>
</div>
<div>I am in the process of exploring logback so we can migrate our logging off of our current mishmash. As part of that I have been trying to configure to write to a MySQL database.</div>
<div><br>
</div>
<div>In the configuration file I have this:</div>
<div><br>
</div>
<div>
<blockquote type="cite">
<div> <appender name="DB" class="ch.qos.logback.access.db.DBAppender"></div>
<div><font class="Apple-style-span"> <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource"></font></div>
<div><font class="Apple-style-span"> <driverClass>com.mysql.jdbc.Driver</driverClass></font></div>
<div><font class="Apple-style-span"> <url>jdbc:mysql://localhost:3306/test</url></font></div>
<div><font class="Apple-style-span"> <user>logback</user></font></div>
<div><font class="Apple-style-span"> <password>logback</password></font></div>
<div><font class="Apple-style-span"> </connectionSource></font></div>
<div><font class="Apple-style-span"> <insertHeaders>true</insertHeaders></font></div>
<div><font class="Apple-style-span"> </appender></font></div>
</blockquote>
</div>
<div>
<div><br>
</div>
</div>
<div>
<blockquote type="cite">
<div><font class="Apple-style-span"> <root level="DEBUG"></font></div>
<div><font class="Apple-style-span"> <appender-ref ref="STDOUT" /></font></div>
<div><font class="Apple-style-span"> <appender-ref ref="FILE" /></font></div>
<div><font class="Apple-style-span"> <appender-ref ref="DB" /></font></div>
<div> </root></div>
</blockquote>
</div>
<div>
<div><br>
</div>
</div>
<div>And I've run the scripts to set up the tables in MySQL, and logback can apparently connect ok - if I change any of the parameters in the config I get errors about it not connecting.</div>
<div><br>
</div>
<div>On the console and in the logfile I can see output as I would expect, but the DB remains empty. I'm using MySQL 5.1.51 on a Mac, for what that's worth.</div>
<div><br>
</div>
<div><br>
<div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div>
<div><span class="Apple-style-span" style="font-family: 'Lucida Grande', Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); ">
<div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; font-size: 1em; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; ">
<strong style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; ">Stephen
Schaeffer</strong><br>
</div>
</span></div>
</div>
</div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">This message may contain confidential information and is intended for specific recipients unless explicitly noted otherwise. If you have reason to believe you are not an intended recipient of this message, please delete
it and notify the sender. This message may not represent the opinion of IntercontinentalExchange, Inc. (ICE), its subsidiaries or affiliates, and does not constitute a contract or guarantee. Unencrypted electronic mail is not secure and the recipient of this
message is expected to provide safeguards from viruses and pursue alternate means of communication where privacy or a binding message is desired.<br>
</font>
</div>
_______________________________________________<br>Logback-user mailing list<br><a href="mailto:Logback-user@qos.ch">Logback-user@qos.ch</a><br>http://qos.ch/mailman/listinfo/logback-user<br></blockquote></div><br></div></div></body></html>