Re: [Iptablelog-users] IPtables logs analyzer problem

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

Henrik Klinkmann wrote:
>>>2 solutions might work :
>>>- use grant create instead of grant create temporary
>>>- upgrade mysql
> 
> Well, as I already said, I tried the first solution, to allow it to
> create all tables, and that worke
> fine. 

Big oups !
Sorry, i read your mail too fastly ang gave you a wrong answer :/


> I still get this error when trying to access my iptables site:
>  "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"
> 
> What is this caused by?

Maybe you may check if the table iptables.logs exists in your database.
 (can't give you the mysql command because i'am using PHPMysql)

If not then, maybe, you forgot to create it ?
In this case run in the directory where db.sql is :
cat db.sql | mysql -u iptables_admin -p iptables