RE: using stored procedures with freeradius (Urgent help request)
I found it, If u return some variables from the accounting sp with some kind of select, you can encounter this problem. -----Original Message----- From: freeradius-devel-bounces+murat.migdisoglu=superonline.net@lists.freeradius.org [mailto:freeradius-devel-bounces+murat.migdisoglu=superonline.net@lists.freeradius.org] On Behalf Of Murat Mığdısoğlu Sent: Saturday, January 28, 2006 3:29 PM To: freeradius-devel@lists.freeradius.org Subject: using stored procedures with freeradius (Urgent help request) Hi all, I'm using freeradius with sybase using freetds and unixodbc. For some purposes, i had to use stored procedures and changed sql statements in sql.con to procedure calls like "EXEC -----". I have to question at this point 1) has anyone used this method before?(in the archie, i saw some mails about sp, so i assume freeradius support it) 2) Examining my logs, i found that some sockets getting 'Invalid cursor State' error from unix-odbc driver in some cases and they don't work anymore. What it can be? Bu e-posta mesaji ve ekleri sadece gonderildigi kisi veya kuruma ozeldir. Eger dogru kisiye ulasmadigini dusunuyorsaniz, bu mesajin yonlendirilmesi, kopyalanmasi veya herhangi bir sekilde kullanilmasi yasaktir.Mesaj iceriginde bulunan fikir ve yorumlar, SUPERONLINE'a degil sadece gondericiye aittir. Bu mesaj bilinen tum viruslere karsi test edilmistir. This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, copying or use of the information is prohibited. The opinions expressed in this message belong to sender alone. There is no implied endorsement by SUPERONLINE.This e-mail has been scanned for all known computer viruses. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html Bu e-posta mesaji ve ekleri sadece gonderildigi kisi veya kuruma ozeldir. Eger dogru kisiye ulasmadigini dusunuyorsaniz, bu mesajin yonlendirilmesi, kopyalanmasi veya herhangi bir sekilde kullanilmasi yasaktir.Mesaj iceriginde bulunan fikir ve yorumlar, SUPERONLINE'a degil sadece gondericiye aittir. Bu mesaj bilinen tum viruslere karsi test edilmistir. This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, copying or use of the information is prohibited. The opinions expressed in this message belong to sender alone. There is no implied endorsement by SUPERONLINE.This e-mail has been scanned for all known computer viruses.
Hi Murat We have a number of installations using stored procedures with postgresql. While we don't currently have any running FreeTDS there is no reason why you shouldn't be able to use it as long as you return data in the format that FreeRADIUS expects. Give me a call if you need more help. You can get my number from Cemil Parlar who i guess works in the same office as you :-) İyi Akşamlar Peter On Sat 28 Jan 2006 19:09, Murat Mığdısoğlu wrote:
I found it, If u return some variables from the accounting sp with some kind of select, you can encounter this problem.
-----Original Message----- From: freeradius-devel-bounces+murat.migdisoglu=superonline.net@lists.freeradius. org [mailto:freeradius-devel-bounces+murat.migdisoglu=superonline.net@lists.fre eradius.org] On Behalf Of Murat Mığdısoğlu Sent: Saturday, January 28, 2006 3:29 PM To: freeradius-devel@lists.freeradius.org Subject: using stored procedures with freeradius (Urgent help request)
Hi all,
I'm using freeradius with sybase using freetds and unixodbc. For some purposes, i had to use stored procedures and changed sql statements in sql.con to procedure calls like "EXEC -----".
I have to question at this point
1) has anyone used this method before?(in the archie, i saw some mails about sp, so i assume freeradius support it)
2) Examining my logs, i found that some sockets getting 'Invalid cursor State' error from unix-odbc driver in some cases and they don't work anymore. What it can be?
Bu e-posta mesaji ve ekleri sadece gonderildigi kisi veya kuruma ozeldir. Eger dogru kisiye ulasmadigini dusunuyorsaniz, bu mesajin yonlendirilmesi, kopyalanmasi veya herhangi bir sekilde kullanilmasi yasaktir.Mesaj iceriginde bulunan fikir ve yorumlar, SUPERONLINE'a degil sadece gondericiye aittir. Bu mesaj bilinen tum viruslere karsi test edilmistir.
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, copying or use of the information is prohibited. The opinions expressed in this message belong to sender alone. There is no implied endorsement by SUPERONLINE.This e-mail has been scanned for all known computer viruses.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
Bu e-posta mesaji ve ekleri sadece gonderildigi kisi veya kuruma ozeldir. Eger dogru kisiye ulasmadigini dusunuyorsaniz, bu mesajin yonlendirilmesi, kopyalanmasi veya herhangi bir sekilde kullanilmasi yasaktir.Mesaj iceriginde bulunan fikir ve yorumlar, SUPERONLINE'a degil sadece gondericiye aittir. Bu mesaj bilinen tum viruslere karsi test edilmistir.
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, copying or use of the information is prohibited. The opinions expressed in this message belong to sender alone. There is no implied endorsement by SUPERONLINE.This e-mail has been scanned for all known computer viruses.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
-- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
participants (2)
-
Murat Mığdısoğlu -
Peter Nixon