On Wed, May 6, 2015 at 10:45 AM, Christoph Theis <[email protected]> wrote:
> Hello Richard!
>
> Am 29.04.2015 um 15:46 schrieb Richard Mealing:
> > I just restarted it again and it seems to be running, but I don’t know
> > for how long. I do see instances of this –
> >
> > Error binding parameter 0 - probably unsupported type.
>
> [...]
>
> I haven't seen those errors before.
> Maybe some argument is undefined?
>
> > So, is it sqlite causing these problems? Should I try using memory
> instead?
>
> sqlite should work.
> Have you checked the integrity of the database?
>
I've been experiencing the exact same issue on FreeBSD 9.3 issue since
updating to 0.9.1. (Never had an issue in the 0.8 versions.) Hoping that
0.9.2 will resolve things, but the ports tree hasn't been updated yet for
0.9.2 (it's been reported and the maintainer is working on it).
In a couple instances, I was able to identify that it was entries in
certain jails that caused the error. The easiest thing was to just delete
the entire sqlite database and restart things, but I also had success with
manually clearing the entries out for a particular jail by using the
sqlite3 cli:
sqlite3 /var/db/fail2ban/fail2ban.sqlite3
sqlite> delete from bans where jail='proftpd';
sqlite> .quit
Patrick
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Fail2ban-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fail2ban-users
