[squid-users] Squid + oracle

[Eliezer Croitoru]

Hey,

Currently I do not know of such a helper but it is possible to write one.
If you have a DB machine I can run tests against I might be able to 
write a small helper for a basic authentication or session helper based 
on OracleDB.
For a captive portal you would need two separated systems:
- Web
- external_acl helper

The basics of captive portal is that it works in the IP level and can be 
written in php or any other web scripts.

You can start by looking at:
https://mohammadthalif.wordpress.com/2010/12/14/list-of-open-source-captive-portal-software-and-network-access-control-nac/

The external_acl helper supports a cache for the authentication and can 
be used to allow the access from the first time surfing onwards for a 
period of time.
Take a look at the session helper of squid for more details.

I would recommend to utilize iptables for the captive portal.

All The Bests,
Eliezer

On 18/08/2015 14:58, adricustodio wrote:
> Hello guys.
> I got a few questions.
> I need to authenticate my squid on my oracle database, is that possible ?
> if its possible, i can do like a captive portal ? like a hotspot for that ?
> The last question is... can i drop the connection of a user on squid after X
> minutes ?
> For example, every 5 minutes connected the user need to authenticate again ?
>
> Btw. Im using Centos 7 + iptables + squid
> This is a project that i need to solve.
>
>
>
>
>
> --
> View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Squid-oracle-tp4672730.html
> Sent from the Squid - Users mailing list archive at Nabble.com.
> _______________________________________________
> squid-users mailing list
> squid-users at lists.squid-cache.org
> http://lists.squid-cache.org/listinfo/squid-users
>