Re: [squid-users] Squid + oracle

How is the OID related exactly? If you have a paid DB I assume you can use it.. Leave aside licensing for the DB guy.. he probably knows whether you need to pay more for something. Eliezer On 19/08/2015 13:23, adricustodio wrote: Because its easyer i guess I have no idea how to start wit

Re: [squid-users] Squid + oracle

Because its easyer i guess I have no idea how to start with those tools. As long as i noticed you guys said i need the oracle OID, but that is paid, and i dont think we have paid that. -- View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Squid-oracle-tp46727

Re: [squid-users] Squid + oracle

On 19/08/2015 8:09 a.m., adricustodio wrote: > Oh well, thats not a problem, i think we will make once a week. > I can do that manually i think... or when people create a new user create on > mysql aswell > Thanks for the helps guys I'm just wondering why you are so set on exporting the data

Re: [squid-users] Squid + oracle

Oh well, thats not a problem, i think we will make once a week. I can do that manually i think... or when people create a new user create on mysql aswell Thanks for the helps guys -- View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Squid-oracle-tp4672730p467

Re: [squid-users] Squid + oracle

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 18.08.15 23:57, adricustodio пишет: > Ok, last question > > Squid is able to authenticate on mysql right ? Yes. > > > If i create a mysql base and import all my oracle data there ? will that be > possible ? Yes. The only point is how you will

Re: [squid-users] Squid + oracle

Ok, last question Squid is able to authenticate on mysql right ? If i create a mysql base and import all my oracle data there ? will that be possible ? Will squid authenticate there ? -- View this message in context: http://squid-web-proxy-cache.1019090.n4.nabble.com/Squid-oracle-tp46727

Re: [squid-users] Squid + oracle

On 19/08/2015 2:06 a.m., adricustodio wrote: > I was thinking... isnt it possible to make squid authenticate on a radius > server and the radius goes into the oracle db ? Depends on whether you are using the Captive Portal installation you mentioned, a forward-proxy or interception proxy. Of thos

Re: [squid-users] Squid + oracle

our DB guy said its possible... we dont need to update that much, since we will only need to update when we got a new user, and sometimes this user wont connect on squid.. so it will be updated every 2 days... maybe 1 week... So im thinking about trying that, export my oracle DB as a .mysql and i

Re: [squid-users] Squid + oracle

Hey, It is possible to export and import but you need to ask the question if you need to always update the mysql DB you should run it every minute or so.(it is being done in production systems in many places, dump and update) The other question is how to do it.. I do not know yet how. Eliezer

Re: [squid-users] Squid + oracle

Ohh i see... So i can use OID, but basically i will need to buy more licenses right ? I got another idea... i can export the table i need from oracle as .sql... how about i import that on mysql server on linux and autheticate with mysql ? Would that be possible ? -- View this message in con

Re: [squid-users] Squid + oracle

On 18/08/2015 17:55, Yuri Voinov wrote: PS. BTW, you know how much does Oracle license's cost? Per CPU core? OID and RDBMS licenses separately. And for some it's worth. This is a bit different but if you get into a pants shop and buy a pair in the price of 400$ just because it's custom made fo

Re: [squid-users] Squid + oracle

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Oracle has it's own LDAP server, named Oracle Internet Directory. With Oracle RDBMS at backend. Just go http://oracle.com. Squid supports LDAP auth. PS. BTW, you know how much does Oracle license's cost? Per CPU core? OID and RDBMS licenses sepa

Re: [squid-users] Squid + oracle

Sometimes I even surprise myself. I was talking about an OracleDB supported one. I know that there are other helpers but since Oracle uses another ways to run things, the current helpers, as far as I could understood from him was not of help to him. For a sec I forgot that the script is writt

Re: [squid-users] Squid + oracle

I was thinking... isnt it possible to make squid authenticate on a radius server and the radius goes into the oracle db ? Sorry if it sounds stupid, im new on DB. I usually only work on proxy with ncsa authentication. -- View this message in context: http://squid-web-proxy-cache.1019090.n4.nab

Re: [squid-users] Squid + oracle

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Also, AFAIK, exists Perl DBI interface to Oracle: https://www.google.com/search?q=Perl+Oracle+RBDMS+interface And this is real possibility to write own (or modify existing) auth helper. 18.08.15 19:20, Amos Jeffries пишет: > On 19/08/2015 12:20

Re: [squid-users] Squid + oracle

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 18.08.15 19:20, Amos Jeffries пишет: > On 19/08/2015 12:20 a.m., adricustodio wrote: >> Well the captive portal is not the importante here... > > It is the most critical part of the system. Its very existence > determines whether the rest of your

Re: [squid-users] Squid + oracle

On 19/08/2015 12:20 a.m., adricustodio wrote: > Well the captive portal is not the importante here... It is the most critical part of the system. Its very existence determines whether the rest of your plans are even possible. Its method of session management determins how your database can integ

Re: [squid-users] Squid + oracle

Well, thanks for the help. The captive portal isnt importante, and the connection timeout either. My DB is an oracle/oracle literally... isnt oracle/mysql. So, is there any way ? Im thinking to autheticate on localhost (ncsa) but create a job on my oracle to write the users and passwords on a file

Re: [squid-users] Squid + oracle

On 19/08/2015 12:15 a.m., Eliezer Croitoru wrote: > Hey, > > Currently I do not know of such a helper but it is possible to write one. You surprise me Eliezer. Thought you had been around long enough to be aware of these SQL database helpers:

Re: [squid-users] Squid + oracle

Well the captive portal is not the importante here... First i need to authenticate my users on oracle DB. I was thinking if its possible to create a mysql DB and replicate my oracle on mysql DB and authenticate on the mysql localhost... what do you think ? -- View this message in context: htt

Re: [squid-users] Squid + oracle

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: - W

[squid-users] Squid + oracle

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 minut