iptablelog-users — Support, Discussions, User oriented

[Iptablelog-users] problem with iptables log analizer

[Tec. R. S. F. <se...@co...>]

Hi..
I recently installed iptables analizer and i followed all the steps from
the FAQ.

The first problem i had was giving permisions to iptables_user using this
sintaxis:
mysql> grant create temporary tables  on iptables.*
iptables_user@localhost identified by 'xx';


I get an error near of temporary..

after, when i want see the statis on web, i get an error from mysql.. Its
say the user iptables_user cant create tables..
So, i removed the user iptables_user from the config files and im only
using iptables_admin user.

I tryied again on web i finally i get the principal page.. but i dont see
the log of my drop chain..
i only get on database stats:
302 packets in database
0 packets younger than any
0 packets today
First was at 0000-00-00 00:00:00
Last was at 0000-00-00 00:00:00

i think is a problem using dates..
Im using Mandrake 9 with the latest mysql

Thanks.

Re: [Iptablelog-users] Problems accessing main web interface.

[Darren P. <da...@d-...>]

Cheers Gege

Glad to know its not just my system thats causing this.

I'll see about opening it up, I might put a .htaccess file on the directory
anyway.

Thanks again

Darren
----- Original Message -----
From: "gege" <ge...@ge...>
To: "Darren Paxton" <da...@d-...>
Cc: <ipt...@li...>
Sent: Tuesday, November 12, 2002 7:48 PM
Subject: Re: [Iptablelog-users] Problems accessing main web interface.



Hi !

Ouppps, I sorry for my incorrect response to your problem, I have
forgotten that this but has been already identified :

This problem is due to the fact that register_globals is set to off.
Obviouly the script should be able to handle it because turning it on
can lead to security holes.

I have open a bug report on it, it is #624253
(https://sourceforge.net/tracker/index.php?func=detail&aid=624253&group_id=6
3361&atid=503691)

It will be fixed in the next release (next week I think)
If you do not want to wait, turn register_globals to on but before read
http://www.php.net/release_4_1_0.php to known what you are doing...


Sorry again for the delay
Gérald

On Tue, 2002-11-12 at 13:27, Darren Paxton wrote:
> Hi Gege
>
> i've just tried what you suggested
>
> (debug mode currently set to 1, but I tried with both)
>
> The page loads up ONE time only, then the following page is displayed
every
> time
>
> Unable to execute create temporary table filtered_logs select * from logs
> where chain='' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 1064 -
You
> have an error in your SQL syntax near '' at line 1
>
> I've deleted all temp files and cookie and also restarted internet
explorer,
> I am then able to get access to the main page, but any attempt to either
> destroy the session or move pages results in the above error again.
>
> Could there be a permissions problem on the server? What permissions do
you
> suggest should be in the iptables folder under the webserver and who
should
> own those files?
>
> Thanks for your help
>
> Darren
> ----- Original Message -----
> From: "gege" <ge...@ge...>
> To: "Darren Paxton" <da...@d-...>
> Cc: <Ipt...@li...>
> Sent: Monday, November 11, 2002 7:35 PM
> Subject: Re: [Iptablelog-users] Problems accessing main web interface.
>
>
> Hi !
>
> Have you turn on the cookies on your browser ? You need it
> to handle the contexts of the application.
>
> If it is ok, please try to enable the debug feaure and press the
> "Destroy context" button.
>
> If all of this does not work, please send me all the comments of
> the generated page (mostly the header)
>
> Thanks for your feedback, keep me informed
>
> Gérald
>
> On Fri, 2002-11-08 at 13:54, Darren Paxton wrote:
> > hi there
> >
> > Just downlaoded and installed version 0.30 and whenever I try and load
up
> > the main page, I get the following error
> >
> > Unable to execute create temporary table filtered_logs select * from
logs
> > where chain='' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 1064 -
> You
> > have an error in your SQL syntax near '' at line 1
> >
> > this first happened yesterday, however, out of curiosity, I loaded up
this
> > morning and it loaded fine - but when I tried to move to the next page,
> the
> > error came back up again.
> >
> > Does anyone have any ideas?
> >
> > Thanks in advance
> >
> >
> > Darren
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by: See the NEW Palm
> > Tungsten T handheld. Power & Color in a compact size!
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> > _______________________________________________
> > Iptablelog-users mailing list
> > Ipt...@li...
> > https://lists.sourceforge.net/lists/listinfo/iptablelog-users
> >
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Iptablelog-users mailing list
> Ipt...@li...
> https://lists.sourceforge.net/lists/listinfo/iptablelog-users
>
>

Re: [Iptablelog-users] Problems accessing main web interface.

[gege <ge...@ge...>]

Hi !

Ouppps, I sorry for my incorrect response to your problem, I have
forgotten that this but has been already identified :

This problem is due to the fact that register_globals is set to off.
Obviouly the script should be able to handle it because turning it on
can lead to security holes.

I have open a bug report on it, it is #624253
(https://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D624253&group=
_id=3D63361&atid=3D503691)

It will be fixed in the next release (next week I think)
If you do not want to wait, turn register_globals to on but before read
http://www.php.net/release_4_1_0.php to known what you are doing...


Sorry again for the delay
G=E9rald

On Tue, 2002-11-12 at 13:27, Darren Paxton wrote:
> Hi Gege
>=20
> i've just tried what you suggested
>=20
> (debug mode currently set to 1, but I tried with both)
>=20
> The page loads up ONE time only, then the following page is displayed eve=
ry
> time
>=20
> Unable to execute create temporary table filtered_logs select * from logs
> where chain=3D'' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 1064 =
- You
> have an error in your SQL syntax near '' at line 1
>=20
> I've deleted all temp files and cookie and also restarted internet explor=
er,
> I am then able to get access to the main page, but any attempt to either
> destroy the session or move pages results in the above error again.
>=20
> Could there be a permissions problem on the server? What permissions do y=
ou
> suggest should be in the iptables folder under the webserver and who shou=
ld
> own those files?
>=20
> Thanks for your help
>=20
> Darren
> ----- Original Message -----
> From: "gege" <ge...@ge...>
> To: "Darren Paxton" <da...@d-...>
> Cc: <Ipt...@li...>
> Sent: Monday, November 11, 2002 7:35 PM
> Subject: Re: [Iptablelog-users] Problems accessing main web interface.
>=20
>=20
> Hi !
>=20
> Have you turn on the cookies on your browser ? You need it
> to handle the contexts of the application.
>=20
> If it is ok, please try to enable the debug feaure and press the
> "Destroy context" button.
>=20
> If all of this does not work, please send me all the comments of
> the generated page (mostly the header)
>=20
> Thanks for your feedback, keep me informed
>=20
> G=E9rald
>=20
> On Fri, 2002-11-08 at 13:54, Darren Paxton wrote:
> > hi there
> >
> > Just downlaoded and installed version 0.30 and whenever I try and load =
up
> > the main page, I get the following error
> >
> > Unable to execute create temporary table filtered_logs select * from lo=
gs
> > where chain=3D'' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 106=
4 -
> You
> > have an error in your SQL syntax near '' at line 1
> >
> > this first happened yesterday, however, out of curiosity, I loaded up t=
his
> > morning and it loaded fine - but when I tried to move to the next page,
> the
> > error came back up again.
> >
> > Does anyone have any ideas?
> >
> > Thanks in advance
> >
> >
> > Darren
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by: See the NEW Palm
> > Tungsten T handheld. Power & Color in a compact size!
> > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> > _______________________________________________
> > Iptablelog-users mailing list
> > Ipt...@li...
> > https://lists.sourceforge.net/lists/listinfo/iptablelog-users
> >
>=20
>=20
>=20
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Iptablelog-users mailing list
> Ipt...@li...
> https://lists.sourceforge.net/lists/listinfo/iptablelog-users
>=20
>=20

Re: [Iptablelog-users] Problems accessing main web interface.

[Darren P. <da...@d-...>]

Hi Gege

i've just tried what you suggested

(debug mode currently set to 1, but I tried with both)

The page loads up ONE time only, then the following page is displayed every
time

Unable to execute create temporary table filtered_logs select * from logs
where chain='' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 1064 - You
have an error in your SQL syntax near '' at line 1

I've deleted all temp files and cookie and also restarted internet explorer,
I am then able to get access to the main page, but any attempt to either
destroy the session or move pages results in the above error again.

Could there be a permissions problem on the server? What permissions do you
suggest should be in the iptables folder under the webserver and who should
own those files?

Thanks for your help

Darren
----- Original Message -----
From: "gege" <ge...@ge...>
To: "Darren Paxton" <da...@d-...>
Cc: <Ipt...@li...>
Sent: Monday, November 11, 2002 7:35 PM
Subject: Re: [Iptablelog-users] Problems accessing main web interface.


Hi !

Have you turn on the cookies on your browser ? You need it
to handle the contexts of the application.

If it is ok, please try to enable the debug feaure and press the
"Destroy context" button.

If all of this does not work, please send me all the comments of
the generated page (mostly the header)

Thanks for your feedback, keep me informed

Gérald

On Fri, 2002-11-08 at 13:54, Darren Paxton wrote:
> hi there
>
> Just downlaoded and installed version 0.30 and whenever I try and load up
> the main page, I get the following error
>
> Unable to execute create temporary table filtered_logs select * from logs
> where chain='' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 1064 -
You
> have an error in your SQL syntax near '' at line 1
>
> this first happened yesterday, however, out of curiosity, I loaded up this
> morning and it loaded fine - but when I tried to move to the next page,
the
> error came back up again.
>
> Does anyone have any ideas?
>
> Thanks in advance
>
>
> Darren
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: See the NEW Palm
> Tungsten T handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> _______________________________________________
> Iptablelog-users mailing list
> Ipt...@li...
> https://lists.sourceforge.net/lists/listinfo/iptablelog-users
>



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Iptablelog-users mailing list
Ipt...@li...
https://lists.sourceforge.net/lists/listinfo/iptablelog-users

Re: [Iptablelog-users] Problems accessing main web interface.

[gege <ge...@ge...>]

Hi !

Have you turn on the cookies on your browser ? You need it
to handle the contexts of the application.

If it is ok, please try to enable the debug feaure and press the
"Destroy context" button.

If all of this does not work, please send me all the comments of=20
the generated page (mostly the header)

Thanks for your feedback, keep me informed

G=E9rald

On Fri, 2002-11-08 at 13:54, Darren Paxton wrote:
> hi there
>=20
> Just downlaoded and installed version 0.30 and whenever I try and load up
> the main page, I get the following error
>=20
> Unable to execute create temporary table filtered_logs select * from logs
> where chain=3D'' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 1064 =
- You
> have an error in your SQL syntax near '' at line 1
>=20
> this first happened yesterday, however, out of curiosity, I loaded up thi=
s
> morning and it loaded fine - but when I tried to move to the next page, t=
he
> error came back up again.
>=20
> Does anyone have any ideas?
>=20
> Thanks in advance
>=20
>=20
> Darren
>=20
>=20
>=20
> -------------------------------------------------------
> This sf.net email is sponsored by: See the NEW Palm=20
> Tungsten T handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> _______________________________________________
> Iptablelog-users mailing list
> Ipt...@li...
> https://lists.sourceforge.net/lists/listinfo/iptablelog-users
>=20

[Iptablelog-users] Problems accessing main web interface.

[Darren P. <da...@d-...>]

hi there

Just downlaoded and installed version 0.30 and whenever I try and load up
the main page, I get the following error

Unable to execute create temporary table filtered_logs select * from logs
where chain='' and TO_DAYS(NOW()) - TO_DAYS(date) < Mysql error : 1064 - You
have an error in your SQL syntax near '' at line 1

this first happened yesterday, however, out of curiosity, I loaded up this
morning and it loaded fine - but when I tried to move to the next page, the
error came back up again.

Does anyone have any ideas?

Thanks in advance


Darren

Re: [Iptablelog-users] Fatal error: Failed opening required 'config.php'

[gege <ge...@ge...>]

Hi !

For the moment, the netfilter analyzer is not designed to be 
used from a /usr/lib/php directory but directly from the 
directory which is accessible from the web server.

I will investigate on the possibility to store php files
away from the web server public directory but not for the
next release.

Thank you for your feed-back

Gerald

On Tue, 2002-11-05 at 22:04, Alexey N. Shananin wrote:
> Hi! 
> I'm getting a fillowing error in browser output: 
> 
> "Fatal error: Failed opening required 'config.php' 
> (include_path='/usr/lib/php') in /var/www/html/iptables/utils/Context.php on 
> line 25"
> 
> I configured url_base in config.php to point to iptables installation 
> directory(where index.php exists)
> What should I do with it?  
> How could I make config.php visible. 
> Thanks! 
> 
> 
> -- 
> Best regards,
> 
> Alexey N. Shananin, Java Developer 
> Park.RU mailto:sha...@pa...
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by: See the NEW Palm 
> Tungsten T handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> _______________________________________________
> Iptablelog-users mailing list
> Ipt...@li...
> https://lists.sourceforge.net/lists/listinfo/iptablelog-users
> 

[Iptablelog-users] Fatal error: Failed opening required 'config.php'

[Alexey N. S. <sha...@su...>]

Hi! 
I'm getting a fillowing error in browser output: 

"Fatal error: Failed opening required 'config.php' 
(include_path='/usr/lib/php') in /var/www/html/iptables/utils/Context.php on 
line 25"

I configured url_base in config.php to point to iptables installation 
directory(where index.php exists)
What should I do with it?  
How could I make config.php visible. 
Thanks! 


-- 
Best regards,

Alexey N. Shananin, Java Developer 
Park.RU mailto:sha...@pa...

Re: [Iptablelog-users] bug

[gege <ge...@ge...>]

Hi !

You're right, I know the problem but I was to lazy to correct it ;-)
I have opened a bug issue on this problem. It is #624256
(https://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D624256&group=
_id=3D63361&atid=3D503691)

It will be corrected in the next release, I think in the next week

Thanks for your bug report !

G=E9rald

On Tue, 2002-10-15 at 11:34, Olivier TISSIER wrote:
> I am new to this list... Maybe this bug has been found.
> When you restart the "deamon", it rewrites the rules again. So there are =
2 entries for the same rule in the database.
> No way to modify this by checking the date?=20
> Olivier
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Iptablelog-users mailing list
> Ipt...@li...
> https://lists.sourceforge.net/lists/listinfo/iptablelog-users
>=20

[Iptablelog-users] bug

[Olivier T. <ot...@ac...>]

I am new to this list... Maybe this bug has been found.
When you restart the "deamon", it rewrites the rules again. So there are 2 entries for the same rule in the database.
No way to modify this by checking the date? 
Olivier

[Iptablelog-users] Re: Iptablelog-users -- confirmation of subscription -- request 288631

[Olivier T. <ot...@ac...>]

On Tue, 15 Oct 2002 02:31:58 -0700
ipt...@li... wrote:

> Iptablelog-users -- confirmation of subscription -- request 288631
> 
> We have received a request from 213.244.7.11 for subscription of your
> email address, <ot...@ac...>, to the
> ipt...@li... mailing list.  To confirm the
> request, please send a message to
> ipt...@li..., and either:
> 
> - maintain the subject line as is (the reply's additional "Re:" is
> ok),
> 
> - or include the following line - and only the following line - in the
> message body: 
> 
> confirm 288631
> 
> (Simply sending a 'reply' to this message should work from most email
> interfaces, since that usually leaves the subject line in the right
> form.)
> 
> If you do not wish to subscribe to this list, please simply disregard
> this message.  Send questions to
> ipt...@li....


-- 
Olivier TISSIER
.accelance msp
Tel.  +33 4 26 29 12 22
Fax   +33 4 26 29 12 20
www.accelance.fr