<html><div style='background-color:'><P><BR><BR></P>
<P>Hi all </P>
<P>Me in trouble I m implementing RADIUS <---> Diameter Translation Agent for which I need a </P>
<P>Diameter Server implemented in java, If there is any then let me tell so that I could implement </P>
<P>Translation Agent </P>
<P>Ahmed</P>
<P><EM><FONT color=#3333cc>m<A href="mailto:khursheedahmedqau@hotmail.com"><FONT face="Times New Roman, Times, Serif">ailto:khursheedahmedqau@hotmail.com</FONT></A><BR><FONT face="Times New Roman, Times, Serif">+92346-5099331</FONT></FONT></EM><IMG height=2 src="http://graphics.hotmail.com/greypixel.gif" width="100%" vspace=9></P>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">
<HR color=#a0c6e5 SIZE=1>
From: <I>freeradius-users-request@lists.freeradius.org</I><BR>Reply-To: <I>freeradius-users@lists.freeradius.org</I><BR>To: <I>freeradius-users@lists.freeradius.org</I><BR>Subject: <I>Freeradius-Users Digest, Vol 25, Issue 68</I><BR>Date: <I>Wed, 16 May 2007 05:41:58 +0200</I><BR>>Send Freeradius-Users mailing list submissions to<BR>> freeradius-users@lists.freeradius.org<BR>><BR>>To subscribe or unsubscribe via the World Wide Web, visit<BR>> http://lists.freeradius.org/mailman/listinfo/freeradius-users<BR>>or, via email, send a message with subject or body 'help' to<BR>> freeradius-users-request@lists.freeradius.org<BR>><BR>>You can reach the person managing the list at<BR>> freeradius-users-owner@lists.freeradius.org<BR>><BR>>When replying, please edit your Subject line so it is more specific<BR>>than "Re: Contents of Freeradius-Users
digest..."<BR>><BR>><BR>>Today's Topics:<BR>><BR>> 1. RE: Pool-Name from Called-Station-Id (Hugh Messenger)<BR>> 2. Re: Server IP changed and "FreeRADIUS+MySQL" does not work<BR>> (Kevin Bonner)<BR>> 3. RE: no session showed by radwho, but user still could not<BR>> login (Trio)<BR>> 4. Attributes mapping between LDAP and RADIUS (Jian Wang)<BR>> 5. Re: Server IP changed and "FreeRADIUS+MySQL" does not work<BR>> (yao guoxian)<BR>> 6. Re[5]: (NikulinAS)<BR>><BR>><BR>>----------------------------------------------------------------------<BR>><BR>>Message: 1<BR>>Date: Tue, 15 May 2007 16:39:47 -0500<BR>>From: "Hugh Messenger" <hugh@alaweb.com><BR>>Subject: RE: Pool-Name from Called-Station-Id<BR>>To: <freeradius-users@lists.freeradius.org><BR>>Message-ID:
<007a01c79739$8fc0dd60$010210ac@DELLBOY><BR>>Content-Type: text/plain; charset="us-ascii"<BR>><BR>><BR>><BR>>Ala DeKok said:<BR>><BR>> > DEFAULT Called-Station-Id =~ "^(\w+_pppoe_\d+)$", Pool-Name :=<BR>>`%{1}`<BR>> ><BR>> > \w && \d may not be supported by the regex library on your system. You<BR>> > may have to use [a-fA-F] etc. explictely.<BR>><BR>>I don't seem to be able to get this to work. This is my DEFAULT entry:<BR>><BR>>DEFAULT Called-Station-Id =~ "^([A-z0-9]+_pppoe_[0-9]+)$", Pool-Name :=<BR>>`%{1}`<BR>> Framed-IP-Netmask = 255.255.0.0,<BR>> Fall-Through = 1<BR>><BR>>... and it seems to be matching on authentication requests, as per this -X<BR>>fragment:<BR>><BR>> users: Matched entry DEFAULT at line 162<BR>><BR>>... where line 162 is the above DEFAULT. And I've triple checked
my regexp<BR>>using my IDE's RX toolkit. But sqlippool isn't picking up that pattern<BR>>match as the pool name:<BR>><BR>>rlm_sql_mysql: query: SELECT FramedIPAddress FROM radippool WHERE<BR>>pool_name = '' AND expiry_time < NOW() ORDER BY pool_name, (UserName <><BR>>'radiustest'), (CallingStationId <> '00:60:B3:45:6A:98'), expiry_time<BR>>LIMIT 1 FOR UPDATE<BR>>sqlippool_query1: SQL query did not return any results<BR>><BR>>If I replace the regexp version with a specific one, like ...<BR>><BR>>DEFAULT Called-Station-Id == "brantley_pppoe_141", Pool-Name :=<BR>>"brantley_pppoe_141"<BR>><BR>>... it all works fine.<BR>><BR>> ><BR>> > Alan DeKok.<BR>><BR>> -- hugh<BR>><BR>><BR>><BR>><BR>>------------------------------<BR>><BR>>Message: 2<BR>>Date: Tue, 15 May 2007 17:49:52
-0400<BR>>From: Kevin Bonner <keb@pa.net><BR>>Subject: Re: Server IP changed and "FreeRADIUS+MySQL" does not work<BR>>To: FreeRadius users mailing list<BR>> <freeradius-users@lists.freeradius.org><BR>>Message-ID: <200705151749.56538.keb@pa.net><BR>>Content-Type: text/plain; charset="utf-8"<BR>><BR>>On Tuesday 15 May 2007 09:39:55 yao guoxian wrote:<BR>> > I have installed FreeRADIUS and MySQL on the same machine.<BR>> > "FreeRADIUS + MySQL" had worked well before Server IP changed. For<BR>> > some reason the server had to be carried to a new place and its IP must be<BR>> > changed.<BR>> > After the server IP changed, "FreeRADIUS + MySQL" does not work.<BR>> > I have edited sql.conf and changed IP to the new correct IP . I<BR>> > also edited the table "user" in the database "mysql" and altered<BR>> >
the Host field from the old IP to the new correct IP. However these<BR>> > mendings do not work.<BR>><BR>>As Alan stated, try connecting to MySQL from the command line to confirm that<BR>>it works. You updated the IPs in mysql.user, but that doesn't affect the<BR>>MySQL permissions. To apply any changes to the mysql privilege tables, you<BR>>must either restart the MySQL service or run "FLUSH PRIVILEGES".<BR>><BR>>Kevin Bonner<BR>>-------------- next part --------------<BR>>A non-text attachment was scrubbed...<BR>>Name: not available<BR>>Type: application/pgp-signature<BR>>Size: 189 bytes<BR>>Desc: not available<BR>>Url : https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070515/0f109f61/attachment-0001.bin<BR>><BR>>------------------------------<BR>><BR>>Message: 3<BR>>Date: Wed, 16 May 2007 08:19:28
+0800<BR>>From: Trio <trioy99@gmail.com><BR>>Subject: RE: no session showed by radwho, but user still could not<BR>> login<BR>>To: "'FreeRadius users mailing list'"<BR>> <freeradius-users@lists.freeradius.org><BR>>Message-ID: <464a4e17.37555d38.6ef7.ffffd0c6@mx.google.com><BR>>Content-Type: text/plain; charset="iso-8859-2"<BR>><BR>>Im using nas with 'nas' table in my sql here the data<BR>>mysql> select * from nas;<BR>>+----+----------------+--------------+----------+-------+-----------+-------<BR>>----+---------------+<BR>>| id | nasname | shortname | type | ports | secret |<BR>>community | description |<BR>>+----+----------------+--------------+----------+-------+-----------+-------<BR>>----+---------------+<BR>>| 1 | 129.47.26.224 | ap-cisco | cisco | 1812 | aironet03 |<BR>>| RADIUS Client |<BR>>| 2 |
129.47.26.111 | mikrotik | mikrotik | 1812 | free |<BR>>| RADIUS Client |<BR>>| 6 | 202.152.57.137 | mikrotik | mikrotik | 1812 | free | NULL<BR>>| RADIUS Client |<BR>>| 5 | 129.47.26.123 | kelapa-sawit | mikrotik | 1812 | utama | NULL<BR>>| RADIUS Client |<BR>>| 7 | 129.47.26.222 | linksys | linksys | 1812 | linksys | NULL<BR>>| RADIUS Client |<BR>>| 8 | 127.0.0.1 | localhost | other | 1812 | chilli | NULL<BR>>| RADIUS Client |<BR>>| 9 | 202.152.4.220 | utama | mikrotik | 1812 | utama | NULL<BR>>| RADIUS Client |<BR>>| 10 | 129.47.26.122 | apbaru | mikrotik | 1812 | free | NULL<BR>>| RADIUS Client |<BR>>+----+----------------+--------------+----------+-------+-----------+-------<BR>>----+---------------+<BR>><BR>>And this is my session section in my radiusd.conf<BR>>session {<BR>> radutmp<BR>><BR>> #<BR>> # See
"Simultaneous Use Checking Querie" in sql.conf<BR>> sql<BR>>}<BR>><BR>>Whats wrong with that my conf ?<BR>><BR>><BR>>Trio<BR>><BR>>-----Original Message-----<BR>>From: freeradius-users-bounces+trioy99=gmail.com@lists.freeradius.org<BR>>[mailto:freeradius-users-bounces+trioy99=gmail.com@lists.freeradius.org] On<BR>>Behalf Of tnt@kalik.co.yu<BR>>Sent: Wednesday, May 16, 2007 3:02 AM<BR>>To: FreeRadius users mailing list<BR>>Subject: RE: no session showed by radwho, but user still could not login<BR>><BR>>Yes. You haven't set up session control properly. Check the nastype<BR>>entry in clents.conf and make sure that sql is not commented out in<BR>>session {} part of radiusd.conf.<BR>><BR>>Ivan Kalik<BR>>Kalik Informatika ISP<BR>><BR>><BR>>Dana 15/5/2007, "Trio" <trioy99@gmail.com> pi?e:<BR>><BR>> >I
change the sql now<BR>> >This is my sql now..<BR>> >mysql> select * from radcheck where username='rsa@idola';<BR>> >+----+-----------+------------------+----+----------+<BR>> >| id | UserName | Attribute | op | Value |<BR>> >+----+-----------+------------------+----+----------+<BR>> >| 57 | rsa@idola | Simultaneous-Use | := | 1 |<BR>> >| 42 | rsa@idola | Password | == | denpasar |<BR>> >+----+-----------+------------------+----+----------+<BR>> >But I try with 2 pc, both using username rsa@idola, guess what happen?<BR>> >All pc can connect perfectly :(<BR>> >1 username can used by 2 pc in the same time.....<BR>> ><BR>> >Any one can explain this ?<BR>> >thanks<BR>> >trio<BR>> >-----Original Message-----<BR>> >From: freeradius-users-bounces+trioy99=gmail.com@lists.freeradius.org<BR>>
>[mailto:freeradius-users-bounces+trioy99=gmail.com@lists.freeradius.org] On<BR>> >Behalf Of Dennis Skinner<BR>> >Sent: Tuesday, May 15, 2007 8:51 PM<BR>> >To: FreeRadius users mailing list<BR>> >Subject: Re: no session showed by radwho, but user still could not login<BR>> ><BR>> >Trio wrote:<BR>> >> :)<BR>> >> Please read my 1st email,there is a words<BR>> >> "I want only 1 session for every user"<BR>> ><BR>> >It is not a boolean option. 0 means you want 0 sessions for every user<BR>> >(i.e. they cannot login). 1 means 1 session, 2 means 2 sessions, etc...<BR>> ><BR>> >--<BR>> >Dennis Skinner<BR>> >Systems Administrator<BR>> >BlueFrog Internet<BR>> >http://www.bluefrog.com<BR>> >-<BR>> >List info/subscribe/unsubscribe? See<BR>>
>http://www.freeradius.org/list/users.html<BR>> ><BR>> >-<BR>> >List info/subscribe/unsubscribe? See<BR>>http://www.freeradius.org/list/users.html<BR>> ><BR>> ><BR>><BR>>-<BR>>List info/subscribe/unsubscribe? See<BR>>http://www.freeradius.org/list/users.html<BR>><BR>><BR>><BR>><BR>>------------------------------<BR>><BR>>Message: 4<BR>>Date: Wed, 16 May 2007 09:35:49 +0800<BR>>From: "Jian Wang" <jwang@a10networks.com.cn><BR>>Subject: Attributes mapping between LDAP and RADIUS<BR>>To: "freeRadius Mailing List - users"<BR>> <freeradius-users@lists.freeradius.org>, "freeRadius Mailing List -<BR>> dev" <freeradius-devel@lists.freeradius.org><BR>>Message-ID:<BR>> <a96f63770705151835g22212c06ibe80437553bc5d6a@mail.gmail.com><BR>>Content-Type: text/plain;
charset="utf-8"<BR>><BR>>Is there an RFC standardizing the attribute mapping between LDAP and RADIUS?<BR>><BR>>Thanks.<BR>>-------------- next part --------------<BR>>An HTML attachment was scrubbed...<BR>>URL: https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070516/5132bb58/attachment-0001.html<BR>><BR>>------------------------------<BR>><BR>>Message: 5<BR>>Date: Wed, 16 May 2007 10:15:28 +0800<BR>>From: "yao guoxian" <yaoguoxian@gmail.com><BR>>Subject: Re: Server IP changed and "FreeRADIUS+MySQL" does not work<BR>>To: "FreeRadius users mailing list"<BR>> <freeradius-users@lists.freeradius.org><BR>>Message-ID:<BR>> <77f387490705151915r23e3088at14911a0fe0cae694@mail.gmail.com><BR>>Content-Type: text/plain; charset="gb2312"<BR>><BR>>Thanks to all of you.<BR>> I can connect to MySQL
using MySQL command-line program.<BR>> The problem seems having been resolved , yet not completely. I logined<BR>>as super user "ygx" other than "root". And "FreeRADIUS ? MySQL" works<BR>>again. I didnt make any other changes except editing sql.conf to<BR>>login as user "ygx".<BR>> The problem maybe exist in the table "user " of the database "mysql",<BR>>which is as follow:<BR>>mysql> select Host,User,Password from user;<BR>>+-------------------------------+--------+-----------------------------------------------------------------------------------+<BR>>| Host | User |<BR>>Password |<BR>>+-------------------------------+--------+-----------------------------------------------------------------------------------+<BR>>| localhost | root |<BR>>*639C78D0EC361EE7FBD5E7B2EE7D4356079DB335 |<BR>>| 202.117.54.251 | root
|<BR>>*639C78D0EC361EE7FBD5E7B2EE7D4356079DB335 |<BR>>| % | ygx | *<BR>>95FF347796503B19B351447515672881EB314534 |<BR>>| % | root |<BR>>*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |<BR>>+------------------------------+---------+-----------------------------------------------------------------------------------+<BR>>Note that user 'root' has different Password .<BR>><BR>>Regards<BR>>Guoxian.<BR>><BR>>2007/5/15, Alan Dekok <aland@deployingradius.com>:<BR>> ><BR>> > yao guoxian wrote:<BR>> > ...<BR>> > > rlm_sql_mysql: Couldn't connect socket to MySQL server<BR>> > > root@202.117.54.251:radius<BR>> > > rlm_sql_mysql: Mysql error 'Access denied for user<BR>> > > 'root'@'202.117.54.251'<BR>> ><BR>> > Can you connect from that IP to MySQL using the MySQL command-line<BR>> > program?
If not, check the ACL's on the machine running MySQL.<BR>> ><BR>> > Alan DeKok.<BR>> > --<BR>> > http://deployingradius.com - The web site of the book<BR>> > http://deployingradius.com/blog/ - The blog<BR>> > -<BR>> > List info/subscribe/unsubscribe? See<BR>> > http://www.freeradius.org/list/users.html<BR>> ><BR>>-------------- next part --------------<BR>>An HTML attachment was scrubbed...<BR>>URL: https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070516/85307965/attachment-0001.html<BR>><BR>>------------------------------<BR>><BR>>Message: 6<BR>>Date: Wed, 16 May 2007 10:41:50 +0700<BR>>From: NikulinAS <NikulinAS@mail.ru><BR>>Subject: Re[5]:<BR>>To: FreeRadius users mailing list<BR>> <freeradius-users@lists.freeradius.org><BR>>Message-ID:
<345157984.20070516104151@mail.ru><BR>>Content-Type: text/plain; charset=iso-8859-2<BR>><BR>>I tried, but unsuccessfully. I read<BR>>http://osdir.com/ml/freeradius.devel/2005-04/msg00034.html and tried<BR>>also, but unsuccessfully.<BR>>I have freeradius-0.9.3 on Linux RedHat 9<BR>><BR>>Ideas ?<BR>><BR>> > I am not sure how cisco-vsa-hack works (have you enabled it in<BR>> > radiusd.conf). You should be able to get them as %{faxrelay-start-time}.<BR>> > One of the programmers will confirm/deny this.<BR>><BR>> > Ivan Kalik<BR>> > Kalik Informatika ISP<BR>><BR>><BR>> > Dana 15/5/2007, "NikulinAS" <NikulinAS@mail.ru> pi?e:<BR>><BR>> >><BR>> >>Indeed! But I have %{Cisco-AVpair} that have multiple values, and I<BR>> >>want all them comes to my database<BR>> >><BR>>
>>> Sorry. I didn't read your post well. I thought you wanted to send it<BR>> >>> FROM radius TO NAS. You will need to write your own accounting queries<BR>> >>> if you want fax accounting as well. Example for voip accounting:<BR>> >><BR>> >>> http://www.freeradius.org/radiusd/raddb/pgsql-voip.conf<BR>> >><BR>> >>> Ivan Kalik<BR>> >>> Kalik Informatika ISP<BR>> >><BR>> >><BR>> >>> Dana 15/5/2007, "????????? ???????" <nikulinas@mail.ru> pi?e:<BR>> >><BR>> >>>>where should I use operator += ?<BR>> >>>>-<BR>> >>>>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR>> >>>><BR>> >>>><BR>> >><BR>> >><BR>> >><BR>> >><BR>>
>>--<BR>> >>? ?????????,<BR>> >> NikulinAS mailto:NikulinAS@mail.ru<BR>> >><BR>> >><BR>> >>-<BR>> >>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR>> >><BR>> >><BR>><BR>> > -<BR>> > List info/subscribe/unsubscribe? See<BR>> > http://www.freeradius.org/list/users.html<BR>><BR>><BR>><BR>>--<BR>>? ?????????,<BR>> NikulinAS mailto:NikulinAS@mail.ru<BR>><BR>><BR>><BR>><BR>>------------------------------<BR>><BR>>-<BR>>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR>><BR>><BR>>End of Freeradius-Users Digest, Vol 25, Issue 68<BR>>************************************************<BR></FONT></BLOCKQUOTE></div><br clear=all><hr>Express yourself instantly with MSN Messenger! <a
href="http://g.msn.com/8HMAEN/2740??PS=47575" target="_top">MSN Messenger</a> Download today it's FREE!</html>