Re: PostgreSQL/freeradius/cisco ap350 problem

2003-09-30 Thread Alexander M. Pravking
On Tue, Sep 30, 2003 at 04:02:44AM -0400, Nick Taylor wrote: > The problem shows itself when I try to set up accounting with the > database. > > ... > rlm_sql_postgresql: query: UPDATE radacct SET FramedIPAddress = '' WHERE > AcctSessionId = ' 700011' AND UserName = '00022d284b47' AND NASIPAddres

Re: PostgreSQL/freeradius/cisco ap350 problem

2003-09-30 Thread Alan DeKok
Nick Taylor <[EMAIL PROTECTED]> wrote: > > The SQL server spits out: > > ERROR: Bad int8 external representation "" > ERROR: invalid INET value '' So edit the SQL statements to print out something when the attribute doesn't exist: %{Framed-IP-Address:-0.0.0.0} ... See 'doc/variables.tx

PostgreSQL/freeradius/cisco ap350 problem

2003-09-30 Thread Nick Taylor
I am trying to set up mac-based authentication, and accounting using freeradius and postgresql under linux. I've tried to read the documentation and search through the list archive before posting, but if I've missed something pointers to RTFM are always appreciated. I'm in over my head, and I than

Re: POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-16 Thread boggss
guy, my reason of using fr 0.9.1 for pgsql 7.3.2 is that pgsql has triggers and functions that i am using on. i am implementing a lot of stored procedures on it. can you send me the config files of fr + pgsql? i'll be delighted to study it. thanks> Hi> > I did have 0.8.1 working as a test, but late

Re: POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-15 Thread Guy Fraser
Hi I did have 0.8.1 working as a test, but late last week I decided to upgrade to 0.9.1 before modifying dial-admin to work with PostgreSQL. Having run into a problem porting 0.9.1 to FreeBSD I no longer have a functional example to show you. Unless you have a specific reason to use PostgreSQL,

Re: POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-15 Thread boggss
i did that already.it still wont...do you have working configs?al about FR and PGSQL> Make sure the user you have setup to access the database has insert and> update permissions> for the radacct table.> > [EMAIL PROTECTED] wrote:> >>hi list,good day to all...i have setup my postgresql 7

Re: POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-15 Thread boggss
i have done that already... it has all the rights for the db...but still it insert any to the radacct.?> Make sure the user you have setup to access the database has insert and> update permissions> for the radacct table.> > [EMAIL PROTECTED] wrote:> >>hi list,good day to all...i hav

Re: POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-15 Thread Guy Fraser
Make sure the user you have setup to access the database has insert and update permissions for the radacct table. [EMAIL PROTECTED] wrote: hi list, good day to all... i have setup my postgresql 7.3.2 and freeradius 0.9.1 on a freebsd 4.8 machine. i have successfully setup the postgresql and fr

POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-13 Thread boggss
hi list, good day to all... i have setup my postgresql 7.3.2 and freeradius 0.9.1 on a freebsd 4.8 machine. i have successfully setup the postgresql and freeradius to support dial up services. i tried to test the original configuration of freeradius 0.9.1 using ntradping..i was able to authentic

Re: postgresql + freeradius

2002-11-21 Thread Kostas Kalevras
On Thu, 21 Nov 2002 [EMAIL PROTECTED] wrote: > > Hi, I'm working with postgresql and pap authorize module..I have an entry in the > radcheck table of my database that contains a clear text passwod for the user, > so I change this value in the pap module in radius.conf like this: > > pap {

postgresql + freeradius

2002-11-21 Thread mcelleri
Hi, I'm working with postgresql and pap authorize module..I have an entry in the radcheck table of my database that contains a clear text passwod for the user, so I change this value in the pap module in radius.conf like this: pap { encryption_scheme = clear } and