Re: How to store session info in external database?

2013-08-09 Thread Maciej Lew
Thanks, it works. 2013/8/6 Arran Cudbard-Bell a.cudba...@freeradius.org On 6 Aug 2013, at 14:29, Maciej Lew mac...@lanserver.pl wrote: The problem is we have databases in slave mode, only reading is allowed. We want pass these informations to another database... Modules can have

How to store session info in external database?

2013-08-06 Thread Maciej Lew
}'` } } authenticate { Auth-Type PAP { pap } Auth-Type CHAP { chap } Auth-Type MS-CHAP { mschap } } preacct { acct_unique } accounting { # sql } session { # sql } post-auth { # sql } Sorry for any language mistakes :) -- Pozdrawiam Maciej Lew tel

Re: How to store session info in external database?

2013-08-06 Thread Maciej Lew
proxy one.and then make sure your DB is optimisedboth running environment (memory allocation, disk platters etc) , the table indexes and the DB engine used for the tables. alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Pozdrawiam Maciej Lew

Re: freeradius-1.0.5 compilation error (library -lz not found)

2006-01-02 Thread TK Lew
hi :: U need the zlib development package installed. On 1/2/06, K Pang [EMAIL PROTECTED] wrote: Hi All, Happy New Year to all of you! i encounterd some compilation errors when compiling freeradius-1.0.5 on solaris 8. below is the errors. /usr/local/src/freeradius-1.0.5-pi/libtool

Weird Insert sql statement in sqltrace.sql

2005-12-24 Thread TK Lew
hi all :: I have a Freeradius with Oracle 10.0 running but something weird appeared in the sqltrace.sql. Sample weirdness record :: INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,

sqltrace.log

2005-12-05 Thread TK Lew
hi all :: Is it adviseable to turn on the sqltrace.log file under production environment ? Thanks ! BR - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Query local active session database (radutmp)

2005-11-17 Thread TK Lew
hi :: Is it possible to query freeradius local session database (radutmp) to check for simultaneous use.? If exists delete it using radzap command and then only accept the Accouting Start packet which then eventually written to radutmp. I can write the script to delete but I have not ideas how

Re: Query local active session database (radutmp)

2005-11-17 Thread TK Lew
PROTECTED] wrote: On Thu, 2005-11-17 at 23:03 +0800, TK Lew wrote: hi :: Is it possible to query freeradius local session database (radutmp) to check for simultaneous use.? If exists delete it using radzap command and then only accept the Accouting Start packet which then eventually written

Re: Query local active session database (radutmp)

2005-11-17 Thread TK Lew
hi Chris :: Thanks for the reply. Yes indeed my situation is a bit dodgy. I will explore the SQL option as session database. Thanks again. BR On 11/18/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Quoting TK Lew [EMAIL PROTECTED]: hi :: My situation is complicated. I have freeradius

Re: Interaction between accounting data and radutmp

2005-11-15 Thread TK Lew
is to use SQL based session database Thanks again ! Regards On 11/15/05, Alan DeKok [EMAIL PROTECTED] wrote: TK Lew [EMAIL PROTECTED] wrote: Ahthat why but all the NAS are using the same port ! Ask your NAS vendor. I understand that session index is based on NAS port . Any chance

Interaction between accounting data and radutmp

2005-11-14 Thread TK Lew
hi all :: I have a weird problem. If I am not mistaken sessions are logged and remove on accouting-start and accouting-stop but I have encountered where an active session for a particular users have been deleted from the session database without the corresponding accounting stop packet. I am

Re: Interaction between accounting data and radutmp

2005-11-14 Thread TK Lew
hi :: Ahthat why but all the NAS are using the same port ! I understand that session index is based on NAS port . Any chance for it to be based on session id ? Is there a patch for it ?? Thanks again ! On 11/15/05, Alan DeKok [EMAIL PROTECTED] wrote: TK Lew [EMAIL PROTECTED] wrote: I

radutmp

2005-09-26 Thread TK Lew
hi :: Is radutmp attributes can added ? What I need to do if I want called-station-id attribute to be display when run radwho -R ? Thank for any reply. Regards - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

is this possible ?

2005-09-22 Thread TK Lew
hi : I am not sure that anyone have done this before :: We have a customer using Steelbelt radius that forward accounting information to the freeradius server. We can receive the accounting packet and stored it successfully. But the problem is we have another application that will do a mapping

Users file

2005-09-12 Thread TK Lew
Hello, I have configured my users file to have the following entries :: steve Auth-Type := System Calling-Station-ID = calling-station-id I want freeradius to reply back with Calling-Station-Id whic basically the MSISDN but instead I got the calling-station-id? What is the correct

Re: listen on freeradius 1.0.1

2004-10-05 Thread Lew A
oh, shoot, stupid oversight on my part... #bind_address = * #port = 0 listen { ipaddr = 192.168.0.22 port = 0 type = auth } works much better... thanks, and sorry Thank you, Lew A GWI Operations On Tue, 5 Oct 2004, Kevin Bonner wrote: -BEGIN PGP SIGNED MESSAGE

Re: Ldap and Ldap-Group

2004-09-07 Thread Lew A
Nothing to do. Sleeping until we see a request. Why isn't the xlat stuff seeing the groupname_attribute stuff? Am I missing something? All the documentation I read seems to say that this should be working the way I have it setup. Thank you, Lew A GWI Operations On Fri, 3 Sep 2004, Lew A wrote

Ldap and Ldap-Group

2004-09-03 Thread Lew A
... rlm_ldap: user celtadmin authenticated succesfully modcall[authenticate]: module ldap returns ok for request 68 modcall: group Auth-Type returns ok for request 68 Sending Access-Accept of id 221 to 127.0.0.1:4272 Thank you, Lew A GWI Operations - List info/subscribe/unsubscribe? See http

Re: Rejecting connections

2004-07-02 Thread Lew A
On Fri, 2 Jul 2004, Alan DeKok wrote: Lew A [EMAIL PROTECTED] wrote: To do this I had to setup some xlat functions, but we're having a problem. If say we have a customer tester, he doesn't have any static assignments, but he decided to connect to us with a P, it would return a static

ldap.attrmap core dump

2004-07-02 Thread Lew A
copying to see the conditions. There is absolutely no warranty for GDB. Type show warranty for details. This GDB was configured as i386-unknown-freebsd. Core was generated by `radiusd'. Program terminated with signal 11, Segmentation fault. #0 0x10384843 in ?? () (gdb) Thank you, Lew A GWI

Rejecting connections

2004-07-01 Thread Lew A
, Strip-User-Name = Yes Hint = PPP, Service-Type = Framed-User, Framed-Protocol = PPP DEFAULT Prefix == S, Strip-User-Name = Yes Hint = PPP, Service-Type = Framed-User, Framed-Protocol = PPP Thank you, Lew A GWI Operations

Reject connect based on Ldap Attributes

2004-06-23 Thread Lew A
I'm trying to set it up so, when a connection comes in from a certain NAS-IP-Address, and the user trying to connect has a specific Ldap Attribute set they won't be able to connect. I haven't been able to successfully figure out how to do this. I'm using FreeRadius 0.98. It matches default 93,

Ldap Multiple Attributes

2004-06-22 Thread Lew A
statement in the users file for each type of static allowed. Does anyone have any insight on what I need to do? or where I can find documentation for this specific problem? Thank you, Lew A GWI Operations - A tiger can smile A snake will say it loves you Lies make