Hi,
in the process of superseding Cisco ACS with freeradius, I have
enhanced the
dictionary.cisco.vpn3000
with
ATTRIBUTE CVPN3000-Authorization-type 65 integer
ATTRIBUTE CVPN3000-Succ-author-requirement 66 integer
ATTRIBUTE CVPN3000-DN-Fields-String 67 string
this is needed for controlling authorization of external groups.
Is there any "official" way to make this public available??
regards,
Arne Spetzler
PS.: These atts are *not* documented by Cisco. I got them by analysing the debug of
the VPN3000 talking with the ACS - but it works :)
> -----Ursprüngliche Nachricht-----
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Auftrag von
> [EMAIL PROTECTED]
> Gesendet: Mittwoch, 17. Dezember 2003 05:43
> An: [EMAIL PROTECTED]
> Betreff: Freeradius-Users digest, Vol 1 #2639 - 8 msgs
>
>
> Send Freeradius-Users mailing list submissions to
> [EMAIL PROTECTED]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.cistron.nl/mailman/listinfo/freeradius-users
> or, via email, send a message with subject or body 'help' to
> [EMAIL PROTECTED]
>
> You can reach the person managing the list at
> [EMAIL PROTECTED]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Freeradius-Users digest..."
>
>
> Today's Topics:
>
> 1. freeradius mysql simultaneous-use question URGENT (Soujanya Rao)
> 2. Re: freeradius mysql simultaneous-use question URGENT
> (Alan DeKok)
> 3. Re: Freeradius Ip address assignation (Kostas Kalevras)
> 4. RE: Freeradius Ip address assignation (Anson Rinesmith)
> 5. Turk kizlar vaoemae (Mustafa)
> 6. A excite game (cdangelo)
> 7. Re: Custom SQL Query (Amgaabaatar Purevjal)
> 8. Help needed. (Shashidhara S Bapat)
>
> --__--__--
>
> Message: 1
> Date: Tue, 16 Dec 2003 13:14:18 -0800 (PST)
> From: Soujanya Rao <[EMAIL PROTECTED]>
> Subject: freeradius mysql simultaneous-use question URGENT
> To: [EMAIL PROTECTED]
> Reply-To: [EMAIL PROTECTED]
>
> --0-395077745-1071609258=:12985
> Content-Type: text/plain; charset=us-ascii
>
> Hi,
> I am new to freeradius. I need some help in using
> simultaneous-use for detecting double logins using mysql
> only. Here is my current set up:
>
> > select * from radgroup check
> +----+--------------- +---------------------------+----+-------+
> | id | GroupName | Attribute | op | Value |
> +----+----------------+----------------------------+----+-------+
> | 2 | static | Auth-Type | == | Local |
> +----+----------------+----------------------------+----+-------+
> | 4 | static | Simultaneous-Use | := | 1 |
> +----+----------------+----------------------------+-----+--------+
>
> > select * from usergroup
> +----+-----------------+-----------------+
> | id | UserName | GroupName |
> +----+-----------------+-----------------+
> | 33 | PW0000006 | static |
> +----+------------------+----------------+
>
> > select * from radcheck
> +----+-------------------+----------------+----+--------------+
> | id | UserName | Attribute | op | Value |
> +----+-------------------+----------------+----+--------------+
> | 18 | PW0000006 | Password | == | abcd |
> +----+-------------------+----------------+-----+-------------+
>
> In my radius.conf I have a set up like this:
>
> session {
> sql
> }
>
> In sql.conf, the "Simultaneous Use Checking Queries" are uncommented
>
> I am using NTRadping to test for simultaneous-use and am
> failing to do so!
> I am doing an accounting start using NTRadPing for the same
> user with a different NAS-IP-Address (Additional RADIUS
> attributes) and a different port NAS-Port (additional RADIUS
> attribute). Though simultaneous-use is setup the user is not
> stopped for double login at all. It creates two entries in
> the radaact table and when I run accounting stop it updates
> the relevant radacct records with the AcctStopTime.
>
> Can anyone tell me where I am going wrong? This is urgent and
> I am clueless as to what else needs to be done. The
> sqltrace.log does not show that the uncommented statements in
> sql.conf are executed. How do I make sure that they get
> executed. Also please let me know if this is a correct
> procedure for testing the same.
>
> Thanks in advance,
> Soujanya
> .
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing
> --0-395077745-1071609258=:12985
> Content-Type: text/html; charset=us-ascii
>
> <DIV>Hi,</DIV>
> <DIV>I am new to freeradius. I need some help in using
> simultaneous-use for detecting double logins using mysql
> only. Here is my current set up:</DIV>
> <DIV> </DIV>
> <DIV>> select * from radgroup check</DIV>
> <DIV>+----+---------------
> +---------------------------+----+-------+<BR>| id |
> GroupName |
> Attribute  
> ; | op | Value
> |<BR>+----+----------------+----------------------------+----+
> -------+</DIV>
> <DIV>| 2 |
> static |
> Auth-Type
> | == | Local
> |<BR>+----+----------------+----------------------------+----+
> -------+<BR>| 4 |
> static
> | Simultaneous-Use | := |
> 1
> |<BR>+----+----------------+----------------------------+-----
> +--------+</DIV>
> <DIV> </DIV>
> <DIV>> select * from usergroup</DIV>
> <DIV>+----+-----------------+-----------------+<BR>| id
> | UserName | GroupName
> |<BR>+----+-----------------+-----------------+<BR>| 33 |
> PW0000006 | static
> |<BR>+----+------------------+----------------+<BR></DIV>
> <DIV>> select * from radcheck</DIV>
> <DIV>+----+-------------------+----------------+----+---------
> -----+<BR>| id | UserName |
> Attribute | op | Value
> |<BR>+----+-------------------+----------------+----+---------
> -----+<BR>| 18 | PW0000006 | Password | ==
> | abcd
> |<BR>+----+-------------------+----------------+-----+--------
> -----+<BR></DIV>
> <DIV>In my radius.conf I have a set up like this:</DIV>
> <DIV> </DIV>
> <DIV>session {<BR>
> sql<BR>}</DIV>
> <DIV> </DIV>
> <DIV>In sql.conf, the "Simultaneous Use Checking Queries" are
> uncommented</DIV>
> <DIV> </DIV>
> <DIV>I am using NTRadping to test for simultaneous-use and am
> failing to do so!</DIV>
> <DIV>I am doing an accounting start using NTRadPing for the
> same user with a different NAS-IP-Address (Additional
> RADIUS attributes) and a different port NAS-Port
> (additional RADIUS attribute). Though simultaneous-use is
> setup the user is not stopped for double login at all. It
> creates two entries in the radaact table and when I run
> accounting stop it updates the relevant radacct records with
> the AcctStopTime.</DIV>
> <DIV> </DIV>
> <DIV>Can anyone tell me where I am going wrong? This is
> urgent and I am clueless as to what else needs to be done.
> The sqltrace.log does not show that the uncommented
> statements in sql.conf are executed. How do I make sure that
> they get executed. Also please let me know if this is a
> correct procedure for testing the same.</DIV>
> <DIV> </DIV>
> <DIV>Thanks in advance,</DIV>
> <DIV>Soujanya</DIV>
> <DIV>.<BR><BR></DIV><p><hr SIZE=1>
> Do you Yahoo!?<br>
> <a
> href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=21260/*h
> ttp://photos.yahoo.com">New Yahoo! Photos - easier uploading
> and sharing</a>
> --0-395077745-1071609258=:12985--
>
>
> --__--__--
>
> Message: 2
> From: "Alan DeKok" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: freeradius mysql simultaneous-use question URGENT
> Date: Tue, 16 Dec 2003 16:33:11 -0500
> Reply-To: [EMAIL PROTECTED]
>
> Soujanya Rao <[EMAIL PROTECTED]> wrote:
> > Can anyone tell me where I am going wrong? This is urgent and I am
> > clueless as to what else needs to be done.
>
> Ensure that 'sql' is listed in the 'accounting' section.
>
> Run: radiusd -X
>
> Alan DeKok.
>
>
> --__--__--
>
> Message: 3
> Date: Wed, 17 Dec 2003 01:15:30 +0200 (EET)
> From: Kostas Kalevras <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Freeradius Ip address assignation
> Reply-To: [EMAIL PROTECTED]
>
> On Tue, 16 Dec 2003, Oliver Graf wrote:
>
> > On Tue, Dec 16, 2003 at 12:46:18PM -0600, Anson Rinesmith wrote:
> > > I've been trying to get this to work. What must I enable
> and where to get
> > > freeradius to manage the IP pools. I have the setup
> mentioned with an OSPF
> > > setup using ASCEND products that can do dynamic routing.
> It keeps trying to
> > > look for it in my SQL db.
> >
> > I would opt for configure some pools and go... an example is in the
> > standard radiusd.conf.
> >
> > Each pool should have its own db file I would say. But I don't think
> > it does something in sql, it uses gdbm db files.
> >
> > Sorry, I can't be of more help, cause I never used this.
> From the one
> > look I took at it a minute ago, I would ask myself the question: how
> > does the radiusd sense a disconnect?
> >
> > A quick look in the sources shows that it does this by
> looking at the
> > stop records. Be sure it sees all (here is the place where you
> > certainly will loose some IPs over time). And there seems to be a
> > tool called rlm_ippool_tool to clean up those stuck entries. Perhaps
> > with an script that checks those sessions via snmp...
>
> rlm_ippool will also clear an entry if an access-request
> comes in on an assigned
> nas/port combination. So as long as accounting works ok and
> the ip pool is not
> full rlm_ippool should be able to find a free entry.
>
> >
> > Oliver (still feeling good using nas-side pools).
>
> Me too. There's very little reason in using server side pools.
>
> >
> >
> > -
> > List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> >
>
> --
> Kostas Kalevras Network Operations Center
> [EMAIL PROTECTED] National Technical University of Athens, Greece
> Work Phone: +30 210 7721861
> 'Go back to the shadow' Gandalf
>
>
> --__--__--
>
> Message: 4
> From: "Anson Rinesmith" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: RE: Freeradius Ip address assignation
> Date: Tue, 16 Dec 2003 17:41:46 -0600
> Reply-To: [EMAIL PROTECTED]
>
> I have added an ippool main_pool {
> range-start =3D 192.168.31.1
> range-stop =3D 192.168.31.254
> netmask =3D 255.255.255.0
> session-db =3D ${raddbdir}/db.ippool
> ip-index =3D ${raddbdir}/db.ipindex
> override =3D yes
> }
>
> in radiusd.conf
> What steps am I missing?
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Oliver =
> Graf
> Sent: Tuesday, December 16, 2003 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Freeradius Ip address assignation
>
> On Tue, Dec 16, 2003 at 12:46:18PM -0600, Anson Rinesmith wrote:
> > I've been trying to get this to work. What must I enable
> and where to =
> get
> > freeradius to manage the IP pools. I have the setup
> mentioned with an =
> OSPF
> > setup using ASCEND products that can do dynamic routing. It keeps =
> trying
> to
> > look for it in my SQL db.
>
> I would opt for configure some pools and go... an example is in the
> standard radiusd.conf.
>
> Each pool should have its own db file I would say. But I don't think
> it does something in sql, it uses gdbm db files.
>
> Sorry, I can't be of more help, cause I never used this. From the one
> look I took at it a minute ago, I would ask myself the question: how
> does the radiusd sense a disconnect?
>
> A quick look in the sources shows that it does this by looking at the
> stop records. Be sure it sees all (here is the place where you
> certainly will loose some IPs over time). And there seems to be a
> tool called rlm_ippool_tool to clean up those stuck entries. Perhaps
> with an script that checks those sessions via snmp...
>
> Oliver (still feeling good using nas-side pools).
>
>
> -=20
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
>
> --__--__--
>
> Message: 5
> From: Mustafa <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Turk kizlar vaoemae
> Date: Tue, 16 Dec 2003 16:54:43 -0600
> Reply-To: [EMAIL PROTECTED]
>
> PEhUTUw+DQo8SEVBRD4NCjxUSVRMRT5veHlwdm9ueWpvc25qa3JmPC9USVRMRT
> 48L0hFQUQ+
> DQo8Qk9EWT4NCjxzdHlsZT5ta2xuIA0KcCBjIGUgDQprYXQgb3ANCnRnbHUgDQ
> p4IHIgangN
> CnhsbSBjaQ0KbWNrIA0KYyBzZw0KcWR0IGV1IA0Kdzwvc3R5bGU+DQo8c3R5bG
> U+bGkgeSBm
> PC9zdHlsZT48QSB0YXJnZXQ9X2JsYW5rIEhSRUY9Imh0dHA6Ly93d3cuZ2lyaX
> NiZWRhdmEu
> Y29tLyI+PEI+TWVzYWr9biBp52VyafBpbmkgZ/ZyZW1peW9yc2Fu/XogYnVyYX
> lhIHT9a2xh
> ef1u/XouPC9CPjwvQT48QlI+PHN0eWxlPnlveWY8L3N0eWxlPg0KTXNnIElEOi
> BjdmZ0Z2Rz
> dHJ3ICANCjxzdHlsZT5mZmIgcDwvc3R5bGU+PEJSPjxCUj48QlI+PEJSPjxCUj
> 48c3R5bGU+
> aHR3eDwvc3R5bGU+DQo8c3R5bGU+eXMgZXU8L3N0eWxlPjxzdHlsZT5wcGRvPC
> 9zdHlsZT4N
> CjxzdHlsZT53Y2YgeSANCmpoIHUgDQpyIGVkIHV5DQp4bnggZCANCnUgeSBzYw
> 0KdXBjIHRq
> DQppcWIgDQpiIHZzDQp4IGF4IHcgbSANCmk8L3N0eWxlPg0KPC9CT0RZPg0KPC
> 9IVE1MPg0K
>
>
>
> --__--__--
>
> Message: 6
> Date: Tue, 16 Dec 2003 20:49:44 -0500 (EST)
> From: cdangelo <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: A excite game
> Reply-To: [EMAIL PROTECTED]
>
>
>
> --X09U36oO3p2
> Content-Type: text/html;
> Content-Transfer-Encoding: quoted-printable
>
> <HTML>ALERT!<BR><BR>This e-mail, in its original form,
> contained one or more attached files that were infected with
> a virus, worm, or other type of security threat. This e-mail
> was sent from a Road Runner IP address. As part of our
> continuing initiative to stop the spread of malicious
> viruses, Road Runner scans all outbound e-mail attachments.
> If a virus, worm, or other security threat is found, Road
> Runner cleans or deletes the infected attachments as
> necessary, but continues to send the original message content
> to the recipient. Further information on this initiative can
> be found at
> http://help.rr.com/faqs/e_mgsp.html.<BR><BR>Please be advised
> that Road Runner does not contact the original sender of the
> e-mail as part of the scanning process. Road Runner
> recommends that if the sender is known to you, you contact
> them directly and advise them of their issue. If you do not
> know the sender, we advise you to forward this message in its
> entirety (including full headers) to the !
> Road Runner Abuse Department, at [EMAIL PROTECTED]
>
> <HEAD></HEAD><BODY>
>
> <FONT>This is a excite game<br>
> This game is my first work.<br>
> You're the first player.<br>
> I expect you would like it.</FONT></BODY></HTML>
>
> --X09U36oO3p2
> Content-Type: text/plain;
> name="DELETED0.TXT"
> Content-Transfer-Encoding: base64
> Content-ID: <X9O6s8d002di0BlHv>
>
> ZmlsZSBhdHRhY2htZW50OiBpbnN0YWxsLmV4ZQ0KDQpUaGlzIGUtbWFpbCBpbi
> BpdHMgb3Jp
> Z2luYWwgZm9ybSBjb250YWluZWQgb25lIG9yIG1vcmUgYXR0YWNoZWQgZmlsZX
> MgdGhhdCB3
> ZXJlIGluZmVjdGVkIHdpdGggdGhlIFczMi5LbGV6LkhAbW0gdmlydXMgb3Igd2
> 9ybS4gVGhl
> eSBoYXZlIGJlZW4gcmVtb3ZlZC4NCkZvciBtb3JlIGluZm9ybWF0aW9uIG9uIF
> JvYWQgUnVu
> bmVyJ3MgdmlydXMgZmlsdGVyaW5nIGluaXRpYXRpdmUsIHZpc2l0IG91ciBIZW
> xwICYgTWVt
> YmVyIFNlcnZpY2VzIHBhZ2VzIGF0IGh0dHA6Ly9oZWxwLnJyLmNvbSwgb3IgdG
> hlIHZpcnVz
> IGZpbHRlcmluZyBpbmZvcm1hdGlvbiBwYWdlIGRpcmVjdGx5IGF0IGh0dHA6Ly
> 9oZWxwLnJy
> LmNvbS9mYXFzL2VfbWdzcC5odG1sLiANCg==
> --X09U36oO3p2
>
> Content-Type: application/octet-stream;
> name=prodImage[72].jpg
> Content-Transfer-Encoding: base64
> Content-ID: <X9O6s8d002di0BlHv>
>
> /9j/4AAQSkZJRgABAQEASABIAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcHBw
> 8LCwkMEQ8S
> EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcGBw
> 4ICA4eFBEU
> Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh
> 4eHh7/wAAR
> CAC8AJ0DASIAAhEBAxEB/8QAHAABAAMBAQEBAQAAAAAAAAAAAAUGBwQCAwEI/8
> QAPRAAAgED
> AgMFBQcBBwUBAAAAAQIDAAQRBRIGITEHEyJBUWFxgZGhFDJCUrHB0SMVM4KSwu
> HwFmJy0uLx
> /8QAGgEBAAMBAQEAAAAAAAAAAAAAAAECBAMFBv/EACsRAAICAQQBAgUEAwAAAA
> AAAAABAhED
> BBIhMUFR8DNhcdHhEyIjkYGx8f/aAAwDAQACEQMRAD8A/sulKUApSlAKUpQClK
> /CaA/aiOIt
> dtNFWI3KyMZchAo5HHt+NOIuJNG0Cze51S+jgVRnbnLt7lHM1Q9T14cXC2nhtZ
> YLXuy0Ikxv
> JJ6keXQcqrKVItslW6uCxHjeMcxp0pX13/7VY9E1CLVNOhvoQVWQE7T1HPFZs8
> Oy1fI8W2vn
> wzxuvDU1nputiOLTbmZo4bjGDE55gN6gnPPyqkZ88iMXJ0jW6V8ra5huYVmt5E
> liYZV0YEH4
> ivqOddSopSlAKUpQClKUApSlAKUpQClK/G99ARnEWvafoVo1zfzbAFLBQMkgVi
> 3EXaxr+pXM
> 8OlW402zAVEZ1zK7M2Bz8hj41YuLL+PVNcvpWxNDbKQi+RwcAfMGqXBpkdqkon
> HeiW7Z5Ruz
> uXYCPdiqNvpHo6XFjSuatnrVtEuruS5nW/DTRIBl13mRyMkkk/L0q48PwPBpVq
> MqrKg5Yzg+
> lVHRbeSxs7QPPM8c0r3Ds7btqAHAPn6VddGmFzpsMwxhs4+BI/aqTtqyuqctqi
> /B1vmRSDjJ
> GM1U+OdGXU7K3hldVjSQnl6kYH81bcYqF4hRnCYHJBu+ORiqJ00Z9O3HImiA0j
> U9f4Xa3Nnd
> ZEmUkiU5iYry3YPQn2VeeHe0qa6Nst/pRRJdweWJs7GBx0PXPvqgXz95qFpZru
> Yx6kS4X8u3
> PP2c6lrIQxRvbHrlypHqDmu0pNGzKoTjbXP/AE2y0uYrq3S4t5FeJxlWHnX2qi
> 9lV7K8V5ZS
> SFlXbNHk9AwwR8x9avVXTs82S2uhSlKEClKUApSlAKUpQCuHXrtbDRr2+c4W3t
> 3lP+FSf2ru
> qqdrdz9m4A1QZwZou5Ht3cqFoLdJIybhWV7jTLwSZM6SRK3tbAZv1NRvEE7xTy
> lHZ1dpN6qf
> u/0zt/SvOn6kNOuXldSy3NxnIHIOqAY+PKuCy1EX6ymdcd7Ic+zK5/cfKojTPY
> cJQm5I7NNu
> 5nt5U06JhLZrHazxufvbueQPd+lXHhDV7KXTlgd47ZxK6ojEAHxHp9apcsJtNR
> guRN3Us18g
> nJPhkjI8B+B/WpbhaEremNokkj72dJVJ3blD8mHtxzzUTjZ1zY4ZMbv/AB9jQp
> FCgbiBnp7a
> q2tXTR29zdsSQtvI/d+YA6Yr7XMC2OnhZ7maeyjbvIpd+GiIOQpx1FVO8mnu47
> eW6Z4YZdPn
> aNsYBI6A+32VSMH6GbT6aCblutHvTm2X0147EtPIkyE/l2dPpXdoUplvlkdnKx
> SAc+hLcifr
> UFNdobVY84ljiijlX0k2fwRUzoTOIpGZSjMivg11miJrl19C+dnci2/FjW28Ze
> 2ddoPowNaZ
> WPcIXEidotmFBZCsiOwPIEgYH0rYarB2jBnjtl9RSlKscRSlKAUpSgFKUoBWf9
> uFyE4fsrTP
> O5u0XHngHnWgGs77VVE2r6RGTkRh3x7yP4odMVKabMyvtKaLTo5lB3fa5HIP/j
> gfpXBpmiyP
> w/p+qLuijuZ5OQHUjGP1HyNW/WmVbKIODkyM2PLpU9quiPD2SaU8C7JLRVmcAZ
> wHzu5f4gfh
> UKj0Z6htc+SjtbKLQRXMW9TyVT1X1Ue48xUfw7q01pc3NrcOokil7yCQ5G9TyI
> NWWBVnYNco
> Nu5FZW8mxncPhUBxBbm/ju0UL3ZmKpOTjCjGfjyNSnwatOlJbJdMsWoXdtNGkz
> 5WHcsksLDl
> uUg8vXnUHfXGbOBI7X7xK2rPyVTnJ9vXqeXTlXvT0kt7G3BlZtrt1OcRjngk+f
> TnXZrVpDHD
> eapbssgazJtsjIgJznFWuiicYOirabazSzO8pzlygc9ZHP3nPvOAPYK0LiPTxZ
> cT/YxhQ9jE
> wx7FCn6rVM4YvJb7i230657tTFPBGoUYDocEN789a07tWjjtuIdMvcYMsEkXv2
> 4NUdtUzhl4
> y0vPJEaAxi4100sM75FCkeuDnPyrY6xbTpF/tzS5RyZZYmz7zj962moiqMGZ2x
> SlKscRSlKA
> UpSgFKUoAazbtJJk4jhUNju7cH9a0g9Kyfji4EvaBd2hJAisA5I9uAP3odcSuR
> XdS2zRqTOx
> b7xUHkBWq8SOlv2ez5wFFmqj4gAfrWM6qjJqJVSSZO5iI9p5VrvaLmLhGKzC7h
> LLFE3sA8X+
> mqw6NeeNOHPD/BksOoS3V7avbozRgSE8vvbRtB+lekeGLRIrERd6ZlaTHnu5k/
> PNdMOlTW0I
> uowUkitWBRT97LZrzf8Ac28NjHvCGa33AnkQRgke/rU1bo9FShtSj77IywkhEE
> sEMciEMfvt
> 4jt5kn44FdNnczzWXczQSRLOjRNG/kTnzqvXN4dOvTIE+0NOBPK4/KOSoPaTir
> tpoW9tmEaF
> biN1Mit58gTikqXJE1su1afNkNDpi2HFOhXiMN0d1AC/TehOMH4gfKtL7abbvr
> PR5MkFbtl5
> ejRN/FZ9xHlIe6Q7mik7yI+e5SH2/Q1pvG8kepcG6ffp4lMsUw+Kn+ataZgyOS
> lGbM8RZUkt
> Zo3wUSNun5WBreE5gH1FYguSmxNu5YiMZ59a223bdDGw6FQfpVU7M+pvcrPpSl
> KkzClKUApS
> lAKUpQA9KyHji6s7Tju/afwvLbwpuPQ5yAK11ulY12n2kV7xNeEy7AEjDH0AOa
> rNWjRpfiUz
> l06yXVOMbC3MRKC8R290fi/arn2vXv2fTbSAOEMjsckgYOMDr7TVf7E1k1LU7n
> UpEbZbx7Vd
> hjczH/1A+ddnaTImo8SraMqyx2cIJQ9NxIOfgMVL+Rokks8Yy6RXEv7mS2lDKF
> uIYwEJ+7IM
> cwarfEMg12WNsd3CoDKyn+7mU8s+w9KttxZF4bpWYJG21o3UdDVe1Gxmea5ywk
> SVVWaIdcAn
> xCrxdm/E8akq99EREss72Yey7lIBvkU88ydEUezzq1aWO7zAJCsyIp3eRx5VBx
> b11G3QS99b
> QR/0yfvO55DPur3e3Fzp63sroJI1jBV1Piz5ijVqmXyJzlS98k/r7wQRS3TKhA
> kjEo8wTyB+
> tWHRb1b7seB5k2kndt6qA4/ZhVKvLcXtnNcXzZXvkO1Wx4FAOTU32QmW54P4j0
> t8MSvfRgD1
> BH+kVXpGHNBfpqV9NH1ae0jtmAaINnGSwzg/rWvaY27T7Y56xL+grEntI7vSop
> VjWRiCu/HR
> lrb7BQlnAg5hY1H0rnC+bM2qjFJNM+9KUroZBSlKAUpSgFKUPSgIrirUxpeh3F
> 1kCQLtjz+Y
> 9KwQW15DeSSXN9NJ35+0XAnbOI18vPGTk1tXHmkXms2EFva7SqOXcFsE8uWKyD
> XLDUtK1Jf7
> Y025ie7OJZzziRB+EHpz9KsnR6ehjFp88l+7HtSjksNRZ4xAJWF0iE8wmNvP/K
> PnVUmvJNRv
> brUowWLzF+ZwSN3T5V1cJTGz4V4j1tGEi3AS2tgnVFPh+XPNVPS7yeDSij4EgY
> jkc55jIFVk
> k0zrHB/NJru0XB2Pczu+DCy5x6VUY76O9uxfWzuFBKxv5N6qR76l769aeC+S2b
> DCJQVPLHKo
> G0xZwRIIe9WaDvZ4gPENx+8PdUx9DRCGxW+/wdFgwuNXlmWPupFGzuj+fzb3Yx
> XdKI50vLdu
> cZQAMfzY51C6GxaZu5ujPLLySXPNIx5n2+XwqXjmEsF33sfdKdqx8+ZGSAfjzq
> zb7IyxqX9E
> ZqusLZzQ20H9SUu2+HHNgBjPw6/CrP2CXBTXZYpW3C6gOM+ZwG/mqhbWKXF9fT
> WwZrsW7Mty
> 45AFjlB/zzqycM3Q0zVrG6jiEbW4D7ByBG3aR8jUPyVzwTw7EuT6cZC+0q71ey
> sZlSKLfPEC
> MkEE/tWt8Aai2qcH6VeuytI9sgkKnI3AYP1FZFxPqNreRzXMl1F3lzBnkwySTz
> FWrsAuJbbT
> L/QLi5hma2naaHu/JHYnHw5dPWq15MmpSliXFNGo0pSh5opSlAKUpQClKUAwPS
> ubUrG01Czk
> s722juLeQYeORcqR7q6aUHRl3HWkadw3oVrpGkxPDDc3nfuhctgKByGfLpyrPY
> IEuJZ7eUGM
> iV3iPrzXmK0Xtdcvq8CpgvDa7gD/ANzf/NZHDqV5bXE9pdZkt2uHeGTPNcgHbn
> 0on4PZ0UJT
> imuy53UCyLcyQoiXAiw4x97l1qC0pbu4urmPUTGrW7KsEsQxjl0Ps54qUhujNq
> csRkxIka5B
> 6YNebbu0kuXQ7zJ43Q8yUJxkD2V0S5LS3L9r+RXtMMdrqF74TB/UJumxhVA8lP
> tOal7WZpln
> Zh/ebPCPwLk4HvqvAsLi8jlkMljE/fBiMmU/hT28+VTUKfZTbI8mbiQ7rg+Rbq
> V+FQuTXqIJ
> K3379/0d/DCR/Yr+NyDHhVG3qhPOvlc/bIdTumtpMSWwQpgZL4w2PkMV8NDeOC
> 5v5YXyZZok
> eMn73IfXnXTcM8fERMIEqFWIXPPIA/mqsyyTb9/I3vTEtJLKG4ht4UE0av4UAz
> kZrqWONWLL
> GqsepA51FcHyd5wzp5/LCE/y8v2qXqDxJKnQpSlCBSlKAUpSgFKUoBQ0r8NAZV
> 2kg3XFM8Ct
> jdAsefTln/VWaa/bTQYwEMPepHJy5qSuFYfHlWicYOlzxPeg58Mu3I8sD/aqnc
> W5NncvN0Gw
> qpOeSvn9askme1opuFHZ9i7qQzbd0ohGHHVqrOpTXv8A1D9niZLaSKMG3dj4XY
> Abkb3gg1b5
> 58xLEMYMQ2t6VFX+nWuoLI08SyKSCx/FGwAAYenSp4bLYsji7kio2n2yfVJbiV
> B3ZmVhHtxt
> mPIL7hjNWu92W/dRr444kcmTzZ8dag47S8sgRJdJJm4iWFs5Lgnm/vAzUtrEsM
> K2xBKwSkRQ
> qPxE/wDBUI16uSlSXR7jsCsxniz3ouBIqdN20Dl9K/NJ1GHUnnl2PbTyTNGI2G
> CGG3P6VL2j
> I1pE2ThpXII9ef8AFQM8YttTsrxj3caGaQrjmXPIZ+dUqmzLbml6rj/f2Nz7P3
> zoWwtnbK3y
> POrJVG7IZpJNGuVkBG2bln0xyq80TtHjZouORpilKVJzFKUoBSlKAUpSgFeXr1
> XiY7ULeQGa
> AwjiDUSNbvHDFlkvTtJ8hvK/sai725Mhkt4gf7iXB8twPSuXipy19NglQYxLn2
> 72OfrXwt5T
> Jqissw7oGWMR9Scrndj0zmpjwqPo8eJKEZ/Um7V+/sbaflmWMIB6E9f3r8SQPO
> ywMN6OwZW6
> SKPT5VGaDLI+j2yR5M8LNGFI9W6/LNdlpfaabhbITp9pRsgeYJ6//lQ1xaOW1q
> /Jy3MMEYmm
> nJjV2KpH5xry3n5cvjXz1ydrqHTY2URytcJJEmOiKC2fYTiverNGmoJLdzb4ZM
> o6j8oxj/Mf
> 0rl1NHa8F0HeSRHO8noCFPhHuHX2mrXwapQ3KLfv5ff8k1ok6Lpdo8xGwh3Yn8
> Jyai9SvY7i
> 50yF1bMjjBI5HJPn8K/La3Wd4JwJIoZLL+qh+7uPTI8q57K1jbWbVd5eOC3R0D
> 9Q3PB+pqtH
> Haoty8m1dksiPZXmzP3xnPxFXqs67I90Ml1btjLQxuef4gSD+taLQ8PP8R0KUp
> Q4ilKUApSl
> AKUpQCuLXpxbaNeTk42QOR78Gu2oviixuNS0iWztpBG0mASR1GeYoSu+TBNeli
> +123hDRzxP
> BnH4vw160KE2+kRTzJ47eQBuXlnafpVg1zs34mvWAtUto4oZxLEGlAYkD1GQOd
> WLhvs+vCjr
> rs0YgkXDQwuSxPqW5Y+FTZ689TjWJRiyj2MSQG6SLxYd2QflU+dVWe1MUjyxr3
> Virnv52Pil
> fPPb54/it+m7POF5JjKLS4jJxuEdzIA2PXnWadr1hDovEFvb2MCQ20sY7uIDCh
> j1P0pfqdNF
> qVLLtXn1KlHbyXl9bpD3klq5R2c9UwcLn08/nUwkaTukMK+EyzA4HIcsDNfGWw
> WF9LZWk3Ry
> CVwGxuAIJBA/MARWt23ZzoUapJp81xDE5aQAvvzu59T76J12NVqoRdLx0UK3iW
> GIlo1KLbgN
> k8jURqlvHDOl3jaAIw2Bnw5Na4OAbHuJInvbh94wTgDl6VzXXZxZTM5Go3CBto
> A2A7ce+oTM
> kNVFO2yudi+sxXvEN5bYKOiSBVIIJXcpBrXqpPD/AAHDo3E8Ot2987MkLQyKyA
> d4pxjp5ggV
> dqGXUShKbcOhSlKHAUpSgFKUoBSlKAUpSgFKUoBVD7V+F7/iKTTZbCBJWtS5ZW
> cLknGOvkMZ
> q+V+GhfHkeOSlHswU8K8UaXeRm+sJbhrg+OWL+oAcjw8ugxnma2rhtJ49Dso7l
> GSVIVVlPUY
> HnXf51+gc6F82d5nclyftKUocRSlKAUpSgFKUoD/2T==
> --X09U36oO3p2--
>
>
> --__--__--
>
> Message: 7
> Date: Tue, 16 Dec 2003 17:56:01 -0800 (PST)
> From: Amgaabaatar Purevjal <[EMAIL PROTECTED]>
> Subject: Re: Custom SQL Query
> To: [EMAIL PROTECTED]
> Reply-To: [EMAIL PROTECTED]
>
> --0-1734172640-1071626161=:32031
> Content-Type: text/plain; charset=us-ascii
>
> Thanks for reply
> But in the sql.conf there are only authorise and accounting
> queries only. Can I add my query end of to that queries. Then how ?
> What I would like to do is After I received accounting query.
> I need to do some calculation and update some tables on 2
> different database.
>
> Kevin Bonner <[EMAIL PROTECTED]> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Monday 15 December 2003 18:03, Amgaabaatar Purevjal wrote:
> > Hello
> > I need to put some custom query after I receive accounting
> packet. Where I
> > should look into it? rlm_sql.c is that correct file? Or I
> could add into
> > accounting query? Thanks
>
> sql.conf (by default) is where you should specify any query.
> There are
> defaults in there which can be modified so that they work
> with your local
> table structure.
>
> Kevin Bonner
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.7 (GNU/Linux)
>
> iD8DBQE/3kAk/9i/ml3OBYMRAi3RAKCKrHJWCBVZNDJKoArQdUN2XRJeSgCgmrMJ
> ky0g9ymuz57CzJnBExTt+as=
> =AbDr
> -----END PGP SIGNATURE-----
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> --0-1734172640-1071626161=:32031
> Content-Type: text/html; charset=us-ascii
>
> <DIV>Thanks for reply</DIV>
> <DIV>But in the sql.conf there are only authorise and
> accounting queries only. Can I add my query end of to that
> queries. Then how ?<BR>What I would like to do is After I
> received accounting query. I need to do some calculation and
> update some tables on 2 different database.</DIV>
> <DIV><BR><B><I>Kevin Bonner <[EMAIL PROTECTED]></I></B> wrote:</DIV>
> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px;
> MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">-----BEGIN
> PGP SIGNED MESSAGE-----<BR>Hash: SHA1<BR><BR>On Monday 15
> December 2003 18:03, Amgaabaatar Purevjal wrote:<BR>>
> Hello<BR>> I need to put some custom query after I receive
> accounting packet. Where I<BR>> should look into it?
> rlm_sql.c is that correct file? Or I could add into<BR>>
> accounting query? Thanks<BR><BR>sql.conf (by default) is
> where you should specify any query. There are <BR>defaults in
> there which can be modified so that they work with your local
> <BR>table structure.<BR><BR>Kevin Bonner<BR>-----BEGIN PGP
> SIGNATURE-----<BR>Version: GnuPG v1.0.7
> (GNU/Linux)<BR><BR>iD8DBQE/3kAk/9i/ml3OBYMRAi3RAKCKrHJWCBVZNDJ
> KoArQdUN2XRJeSgCgmrMJ<BR>ky0g9ymuz57CzJnBExTt+as=<BR>=AbDr<BR>
> -----END PGP SIGNATURE-----<BR><BR><BR>-<BR>List
> info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html</BLOCKQUOTE>
> --0-1734172640-1071626161=:32031--
>
>
> --__--__--
>
> Message: 8
> Subject: Help needed.
> From: Shashidhara S Bapat <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Organization: Envision Network Technologies Private ltd
> Date: 17 Dec 2003 10:13:49 +0530
> Reply-To: [EMAIL PROTECTED]
>
> Hello All,
> I am a new user to this mailing list. I am using Radius server to see
> how does it authenticate.
> I am running freeradius on Linux machine and it is connected
> to a AP600
> (Access Point) through which users are connected. Users are running on
> Windows 2000 Professional. Following are the configuration I
> have done:
>
> file - "clients.conf":
> # 192.168.100.7 is the IP address of my Access Point
> (wireless) (AP600)
> # which supports RADIUS.
> 192.168.100.7/24 {
> secret = abcde
> shortname = AP-600LAB
> }
>
> file - "users":
> # TECH4 is the name of the wireless client (machine name) which is
> # running on Windows.
> TECH4 Auth-Type := EAP, User-Password == "password"
> Reply-Message = "Hello, %u"
>
>
> I think the problem is with the 'user' part. I dont know which
> 'Auth-Type' I have to use. Please help me in my settings.
> Please let me know what modifications I have to do to make it working.
>
> FYI: The 'radtest' is working fine.
>
>
>
> --
> =-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=
> --Best Regards,
> Shashi.
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
>
>
> --__--__--
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
End of Freeradius-Users Digest
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
