Re: FreeRadius EAP Postgresql

2003-09-15 Thread Artur Hecker
try putting it in radgroupcheck and usergroup should assign a group to each user. that's how i use it with mysql ciao artur [EMAIL PROTECTED] wrote: Hi, I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and Postgresql. If I put in 'users' file DEFAULT Auth-Type := EAP

Re: FreeRadius EAP Postgresql

2003-09-15 Thread Artur Hecker
i know what you want to do :-) but alan is right. don't set EAP manually. rather do the following: - let the EAP module in the authorization section. put the sql module in the authorization section as well. - create an sql group with Auth-Type := Reject. - create an sql group with Auth-Type

Re: FreeRadius EAP Postgresql

2003-09-14 Thread Alan DeKok
[EMAIL PROTECTED] wrote: Don't set 'Auth-Type := EAP' *anywhere*. It's automatically set by the EAP module. I've set it in the radgroupcheck as this : What part of Don't set it anywhere did you not understand? rlm_eap: EAP-Message not found because

Re: FreeRadius EAP Postgresql

2003-09-14 Thread rolphin
On Sun, Sep 14, 2003 at 10:28:25AM -0400, Alan DeKok wrote: [EMAIL PROTECTED] wrote: Don't set 'Auth-Type := EAP' *anywhere*. It's automatically set by the EAP module. I've set it in the radgroupcheck as this : What part of Don't set it anywhere did you not understand?

Re: FreeRadius EAP Postgresql

2003-09-14 Thread Alan DeKok
[EMAIL PROTECTED] wrote: Do you mean that's impossible to forbids someone to log in if he holds a valid certificate ? No. If authorize don't set EAP, EAP will not be called in authenticate. Yes. That's exactly what I want, I want sql to authorize and

Re: FreeRadius EAP Postgresql

2003-09-14 Thread rolphin
On Sun, Sep 14, 2003 at 02:46:28PM -0400, Alan DeKok wrote: [EMAIL PROTECTED] wrote: You obviously didnt' read any of my earlier messages. I said you didn't have to set Auth-Type to EAP. The EAP module will do it for you. ok, it'll do it only if I use EAP in authorize, which I

FreeRadius EAP Postgresql

2003-09-13 Thread rolphin
Hi, I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and Postgresql. If I put in 'users' file DEFAULT Auth-Type := EAP Everything works find, but if someone gets a certificate he can logs in. I want to permit only user using postgresql. What should I put into radcheck,

Re: FreeRadius EAP Postgresql

2003-09-13 Thread Alan DeKok
[EMAIL PROTECTED] wrote: I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and Postgresql. That won't work. Everything works find, but if someone gets a certificate he can logs in. That's what EAP-TLS is supposed to do. (I don't know If I should put Auth-Type here)

Re: FreeRadius EAP Postgresql

2003-09-13 Thread rolphin
On Sat, Sep 13, 2003 at 06:37:03PM -0400, Alan DeKok wrote: [EMAIL PROTECTED] wrote: I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and Postgresql. That won't work. Everything works find, but if someone gets a certificate he can logs in. That's what EAP-TLS is

freeradius and postgresql

2003-06-21 Thread freeradius_user
list, i have a working freeradius 0.8.1 with mysql 4.0 on freebsd 4.8 deployed. freeradius 0.8.1 with rlm-sql for postgresql 7.3 compiled and installed on freebsd 4.8 with no problems radiusd started without any complains but when i tried to run radtest rlm_sql_postgresql: PostgreSQL

Re: freeradius and postgresql

2003-06-21 Thread Daryl Tester
freeradius_user wrote: rlm_sql_postgresql: PostgreSQL Query failed Error: no connection to the server rlm_sql_getvpdata: database query error Did you enable Postgres for connection via TCP? All the create commands you gave typically use a local Unix domain socket. --

Re: freeradius and postgresql

2003-06-21 Thread freeradius_user
freeradius and postgresql is on the same machine (localhost) - Original Message - From: Daryl Tester [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 21, 2003 4:30 PM Subject: Re: freeradius and postgresql freeradius_user wrote: rlm_sql_postgresql: PostgreSQL Query

Re: freeradius and postgresql

2003-06-21 Thread Daryl Tester
freeradius_user wrote: freeradius and postgresql is on the same machine (localhost) Which still needs a TCP connection. Can you connect to postgresql using 'psql -h localhost'? -- Regards, Daryl Tester, Software Wrangler and Bit Herder, IOCANE Pty. Ltd. SCO Rep: Linux must die! We

freeradius-0.8.1 postgresql

2003-03-16 Thread Frederic JACQUET
Hello all, Seems that the postgresql.conf is a little bit outdated : in both request authorize_group_check_query = SELECT ${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value FROM ${groupcheck_table},${usergroup_table} WHERE

Re: freeradius-0.8.1 postgresql

2003-03-16 Thread Alan DeKok
Frederic JACQUET [EMAIL PROTECTED] wrote: Seems that the postgresql.conf is a little bit outdated : ... it seems that it lacks ,${groupcheck_table}.Op before FROM Check the CVS head. It should be fixed there. anyway even it adding this attribut I can not make freeradius run cleanly. With

Re: freeradius-0.8.1 postgresql

2003-03-16 Thread Frederic JACQUET
Le dim 16/03/2003 à 12:42, Alan DeKok a écrit : Frederic JACQUET [EMAIL PROTECTED] wrote: Seems that the postgresql.conf is a little bit outdated : ... it seems that it lacks ,${groupcheck_table}.Op before FROM Check the CVS head. It should be fixed there. When browsing

Re: freeradius-0.8.1 postgresql

2003-03-16 Thread Frederic JACQUET
Le dim 16/03/2003 à 12:42, Alan DeKok a écrit : Frederic JACQUET [EMAIL PROTECTED] wrote: Seems that the postgresql.conf is a little bit outdated : ... it seems that it lacks ,${groupcheck_table}.Op before FROM Check the CVS head. It should be fixed there. I use a CVS client to get

FreeRADIUS and PostgreSQL

2003-02-16 Thread hamid
Hi, I am trying to setup freeradius with postgreSQL. I have done this before with mysql. Are there any differences in configuration? Thanks in advance, Hamid - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: FreeRADIUS and PostgreSQL

2003-02-16 Thread Amiri
You can configure it in this way: %configure --with-rlm-sql_postgresql-include-dir=/usr/include/pgsql Amiri Iran Data Co. www.irandata.com --- [EMAIL PROTECTED] wrote: Hi, I am trying to setup freeradius with postgreSQL. I have done this before with mysql. Are there any differences

freeradius and postgresql

2002-10-15 Thread Thai DANG
Hi I have a freeradius and postgresql installed but it looks like freeradius can't connect to postgresql. I check the logs and I saw that free radius attempt to connect with that adress (which is false ?) : postgres@localhost:/MYDATABASE postgres is a postgres user localhost is my machine

freeradius with PostgreSQL...

2002-02-12 Thread Gus Rios
Hi, How can i install freeradius with postgreSQL? What are the arguments for 'configure' ? or what other things i have to do? regards, _ Hable con sus amigos en línea, pruebe MSN Messenger: http://messenger.msn.es - List info

freeradius with PostgreSQL...

2002-02-10 Thread Gus Rios
Hi, How can i install freeradius with postgreSQL? What are the arguments for 'configure' ? or what other things i have to do? regards, _ Hable con sus amigos en línea, pruebe MSN Messenger: http://messenger.msn.es - List info