Re: [Iptablelog-users] IPtables logs analyzer problem

[Nicolas C. <nch...@al...>]

Henrik Klinkmann wrote:
> When trying to open config.php, I get this error:
> "Unable to execute create temporary table filtered_logs select * from
> logs where date > @date_minus_day Mysql error : 1146 - Table
> 'iptables.logs' doesn't exist"
> 
> I suspect it has something to do with Mysql, since I also had problems
> when creating the database.
> "grant create temporary tables  on iptables.* iptables_user@localhost
> identified by 'xx';"
> ('xx' of course replaced) caused an error, so I just run grant create on
> ..., and that worked.
> 
> All other configurations seemed to work properly, but what is at fault
> here?
> 
> My mysql version is 3.23.49, and I run Debian 3.0.
> 
> Please reply to my e-mail address as well.
> 
> Henrik Klinkmann
> 


You'll find the answer on the forum of IPtables logs analyzer :
http://sourceforge.net/forum/forum.php?thread_id=799524&forum_id=213868

2 solutions might work :
- use grant create instead of grant create temporary
- upgrade mysql