[no subject]

2007-05-15 Thread Александр Никулин
Hello How can I get all values of Cisco AVpair from NAS if there are multiple values, for example May 14 16:04:38.193: RADIUS: Cisco AVpair [1] 54 faxrelay-start-time=16:03:58.021 NSK Mon May 14 2007 May 14 16:04:38.193: RADIUS: Vendor, Cisco [26] 59 May 14 16:04:38.193:

Re: differen user for different hotspot

2007-05-15 Thread KES
Authorize user against: username, userpassword, NAS IP User-Name User-Password NAS-IP-Address Hi, Sorry for this noob question, i have 2 Hotspot area (mean have 2 hotspot gateway) on Area A and B and i have 1 mysql as databases.. is it possible to separate user for Area A dan B in 1 databases

Re:

2007-05-15 Thread tnt
Use operator += Ivan Kalik Kalik Informatika ISP Dana 15/5/2007, áĚĹËÓÁÎÄŇ îÉËŐĚÉÎ [EMAIL PROTECTED] piše: Hello How can I get all values of Cisco AVpair from NAS if there are multiple values, for example May 14 16:04:38.193: RADIUS: Cisco AVpair [1] 54

How can I get all values of Cisco AVpair from NAS if there are multiple values

2007-05-15 Thread Александр Никулин
Hello How can I get all values of Cisco AVpair from NAS if there are multiple values, for example May 14 16:04:38.193: RADIUS: Cisco AVpair [1] 54 faxrelay-start-time=16:03:58.021 NSK Mon May 14 2007 May 14 16:04:38.193: RADIUS: Vendor, Cisco [26] 59 May 14 16:04:38.193:

Re: Re:

2007-05-15 Thread Александр Никулин
where should I use operator += ? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: no session showed by radwho, but user still could not login

2007-05-15 Thread A . L . M . Buxey
Hi, I have already checked my NAS and there is no session for [EMAIL PROTECTED], I try with radzap and still not working… the logs show the session still in thw SQL - check your tables for this session. alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Re:

2007-05-15 Thread tnt
Sorry. I didn't read your post well. I thought you wanted to send it FROM radius TO NAS. You will need to write your own accounting queries if you want fax accounting as well. Example for voip accounting: http://www.freeradius.org/radiusd/raddb/pgsql-voip.conf Ivan Kalik Kalik Informatika ISP

Re[3]:

2007-05-15 Thread NikulinAS
Indeed! But I have %{Cisco-AVpair} that have multiple values, and I want all them comes to my database Sorry. I didn't read your post well. I thought you wanted to send it FROM radius TO NAS. You will need to write your own accounting queries if you want fax accounting as well. Example for

AW: SIP UAC authentication using Digest-HA1 and Ldap

2007-05-15 Thread Stadler Karel
Thanks ... installing FreeRadius 1.1.3 worked already best rgds -Karel Stadler auth: type digest Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 0 rlm_digest: Converting Digest-Attributes to something sane... Digest-User-Name =

RE: no session showed by radwho, but user still could not login

2007-05-15 Thread Trio
Thanks for the reply, How to know that the session is still in SQL ? In radchek,radacct table ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 5:05 PM To: FreeRadius users mailing list Subject: Re: no

Re: Re[3]:

2007-05-15 Thread tnt
I am not sure how cisco-vsa-hack works (have you enabled it in radiusd.conf). You should be able to get them as %{faxrelay-start-time}. One of the programmers will confirm/deny this. Ivan Kalik Kalik Informatika ISP Dana 15/5/2007, NikulinAS [EMAIL PROTECTED] piše: Indeed! But I have

RE: no session showed by radwho, but user still could not login

2007-05-15 Thread tnt
SELECT * FROM radacct WHERE AcctStopTime=0 will give you all sessions that database counts as open. Ivan Kalik Kalik Informatika ISP Dana 15/5/2007, Trio [EMAIL PROTECTED] piše: Thanks for the reply, How to know that the session is still in SQL ? In radchek,radacct table ? -Original

RE: no session showed by radwho, but user still could not login

2007-05-15 Thread Trio
I don't think so, it's the result mysql select username,AcctStopTime from radacct WHERE AcctStopTime=0 - ; +---+-+ | username | AcctStopTime| +---+-+ | [EMAIL PROTECTED] | -00-00 00:00:00 | | [EMAIL PROTECTED] | -00-00

RE: no session showed by radwho, but user still could not login

2007-05-15 Thread tnt
++---+---+-+-+ | id | UserName | Attribute | op | Value | ++---+---+-+--+ | 57 | rsa at idola | Simultaneous-Use | := | 0| | 42 | rsa at idola |

Re: no session showed by radwho, but user still could not login

2007-05-15 Thread guildivernos guildivernos
Hi all I'm newbie in freeradius, i've already installed freeradius-1.1.6, Mysql and MikroTik NAS. I'm configuring my radius 1 session for every 1 user : ++---+---+-+-+ | id | UserName | Attribute | op | Value |

RE: no session showed by radwho, but user still could not login

2007-05-15 Thread Trio
:) Please read my 1st email,there is a words I want only 1 session for every user -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 7:51 PM To: FreeRadius users mailing list Subject: RE: no session showed by

Re: no session showed by radwho, but user still could not login

2007-05-15 Thread guildivernos guildivernos
On 5/15/07, Trio [EMAIL PROTECTED] wrote: :) Please read my 1st email,there is a words I want only 1 session for every user Simultaneous-Use := 1 - 1 session for every user -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]

Re: no session showed by radwho, but user still could not login

2007-05-15 Thread Dennis Skinner
Trio wrote: :) Please read my 1st email,there is a words I want only 1 session for every user It is not a boolean option. 0 means you want 0 sessions for every user (i.e. they cannot login). 1 means 1 session, 2 means 2 sessions, etc... -- Dennis Skinner Systems Administrator BlueFrog

Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread yao guoxian
I have installed FreeRADIUS and MySQL on the same machine. FreeRADIUS + MySQL had worked well before Server IP changed. For some reason the server had to be carried to a new place and its IP must be changed. After the server IP changed, FreeRADIUS + MySQL does not work. I have

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread Stefan Winter
Hi, rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Access denied for user 'root'@'202.117.54.251' (using password: YES)' rlm_sql (sql): Failed to connect DB handle #0 Well, that gives a strong hint, doesn't it? Your MySQL

FreeRADIUS 2.0.0-pre1 has been released

2007-05-15 Thread Alan T. DeKok
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The FreeRADIUS team is pleased to announce the release of FreeRADIUS 2.0.0-pre1. This is the first pre release in the process to release a full 2.0.0. It has been almost three years since 1.0.0 was released, and it's high time for the release of

Re: EAP-SIM : symbol lookup error

2007-05-15 Thread Alan Dekok
Ben2148 wrote: I have exactly the same problem (symbol lookup error). Can anyone help me fixing it ? Are you willing to post the error message, or is it a secret? Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog -

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread Alan Dekok
yao guoxian wrote: ... rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Access denied for user 'root'@'202.117.54.251' Can you connect from that IP to MySQL using the MySQL command-line program? If not, check the ACL's on the

Re: EAP-SIM : symbol lookup error

2007-05-15 Thread Ben2148
Here is the error message I get when a client tries to associate : ./freeradius: symbol lookup error: /usr/lib/freeradius/rlm_sim_files-1.1.6.so: undefined symbol: rad_assert and after, the freeradius service crash. -- View this message in context:

Re: HUP stops radiusd

2007-05-15 Thread John Horne
On Mon, 2007-05-14 at 22:56 +0200, Alan DeKok wrote: John Horne wrote: ... Mon May 14 13:38:54 2007 : Info: rlm_eap_tls: Loading the certificate file as a chain Mon May 14 13:38:54 2007 : Error: rlm_eap: SSL error error:0906D06C:PEM routines:PEM_read_bio:no start line Ah I think

FreeRadius 2.0 proxy question - home_server auth and acct server?

2007-05-15 Thread Brian Walters
With the new 2.0 release do we have to make 2 entries for each home server? 1 for auth packets and 1 for acct packets? -- Brian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: FreeRadius 2.0 proxy question - home_server auth and acct server?

2007-05-15 Thread Alan Dekok
Brian Walters wrote: With the new 2.0 release do we have to make 2 entries for each home server? 1 for auth packets and 1 for acct packets? Yes, because they are *different* servers. They may be different programs that share no memory or configuration. Or, you can continue to use the

FreeRadius 2.0 Radrelay to multiple servers?

2007-05-15 Thread Brian Walters
Currently I have 3 FR 1.1.3 servers that proxy for a couple of ISP customers. Right now I have radrelay processes point from 1-3, 2-3 and 3-1, 3-2. This allows me to have reasonably matched accounting data on all 3 servers for all my ISP customers while allowing me to load balance my NAS gear

Re: FreeRadius 2.0 Radrelay to multiple servers?

2007-05-15 Thread Brian Walters
On Tue, 2007-05-15 at 18:12 +0200, Alan Dekok wrote: Be warned, the new radrelay functionality is in flux, and isn't really ready for production use. The intent of -pre1 is to get the *rest* of the server tested. Is it still possible to use the OLD radrelay binary until things stabilize a

RE : Re: FreeRadius 2.0 proxy question - home_server auth and acct server?

2007-05-15 Thread Geoffroy Arnoud
Brian Walters wrote: With the new 2.0 release do we have to make 2 entries for each home server? 1 for auth packets and 1 for acct packets? Yes, because they are *different* servers. They may be different programs that share no memory or configuration. Or, you can continue to

Re: MySQL Authentication

2007-05-15 Thread Joseph Sullivan
Hi Alan, I decided to format my Mac and reinstall everything. That fixed all the issues that I have had so far. It compiled perfectly with the Perl Module (which I had to remove before) and MySQL is working flawlessly now. Thanks for pointing me in that direction. Thanks for your hard

RE: no session showed by radwho, but user still could not login

2007-05-15 Thread tnt
Yes. You haven't set up session control properly. Check the nastype entry in clents.conf and make sure that sql is not commented out in session {} part of radiusd.conf. Ivan Kalik Kalik Informatika ISP Dana 15/5/2007, Trio [EMAIL PROTECTED] piše: I change the sql now This is my sql now.. mysql

RE: Pool-Name from Called-Station-Id

2007-05-15 Thread Hugh Messenger
Ala DeKok said: DEFAULT Called-Station-Id =~ ^(\w+_pppoe_\d+)$, Pool-Name := `%{1}` \w \d may not be supported by the regex library on your system. You may have to use [a-fA-F] etc. explictely. I don't seem to be able to get this to work. This is my DEFAULT entry: DEFAULT

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread Kevin Bonner
On Tuesday 15 May 2007 09:39:55 yao guoxian wrote: I have installed FreeRADIUS and MySQL on the same machine. FreeRADIUS + MySQL had worked well before Server IP changed. For some reason the server had to be carried to a new place and its IP must be changed. After the server IP

RE: no session showed by radwho, but user still could not login

2007-05-15 Thread Trio
Im using nas with 'nas' table in my sql here the data mysql select * from nas; +++--+--+---+---+--- +---+ | id | nasname| shortname| type | ports | secret| community | description |

Attributes mapping between LDAP and RADIUS

2007-05-15 Thread Jian Wang
Is there an RFC standardizing the attribute mapping between LDAP and RADIUS? Thanks. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Server IP changed and FreeRADIUS+MySQL does not work

2007-05-15 Thread yao guoxian
Thanks to all of you. I can connect to MySQL using MySQL command-line program. The problem seems having been resolved , yet not completely. I logined as super user ygx other than root. And FreeRADIUS + MySQL works again. I didnt make any other changes except editing sql.conf to

Re[5]:

2007-05-15 Thread NikulinAS
I tried, but unsuccessfully. I read http://osdir.com/ml/freeradius.devel/2005-04/msg00034.html and tried also, but unsuccessfully. I have freeradius-0.9.3 on Linux RedHat 9 Ideas ? I am not sure how cisco-vsa-hack works (have you enabled it in radiusd.conf). You should be able to get them as