[OpenSER-Users] OpenSER + FreeRadius + CDRTool

Dan-Cristian Bogos dan.bogos at gmail.com
Tue Jul 24 11:00:49 CEST 2007


Hi Marc,

can u post somewhere your freeradius configuration(radius.conf+sql.conf)?
Do u have in your radcheck table username "bob at 192.168.95.248"? Also
you should use the digest module to sanitize your message before
sending it to rlm_sql.

I will be out for the rest of the day, so earlier you should expect an
aswer from me tomorrow morning.

DanB

On 7/24/07, Marc LEURENT <lftsy at free.fr> wrote:
> Good Morning,
> I've followed the tutorial, debugging it because of the upgrade de 1.2.1,
> but now freeradius doesn't want to register me...
> Any idea?
>
> Thanks
>
>
> modcall[authorize]: module "mschap" returns noop for request 35
>   modcall[authorize]: module "digest" returns noop for request 35
>     rlm_realm: Looking up realm "192.168.95.248" for User-Name =
> "bob at 192.168.95.248"
>     rlm_realm: No such realm "192.168.95.248"
>   modcall[authorize]: module "suffix" returns noop for request 35
>   rlm_eap: No EAP-Message, not doing EAP
>   modcall[authorize]: module "eap" returns noop for request 35
> radius_xlat:  'bob at 192.168.95.248'
> rlm_sql (sql): sql_set_user escaped user --> 'bob at 192.168.95.248'
> radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM
> radcheck           WHERE Username = 'bob at 192.168.95.248'           ORDER
> BY id'
> rlm_sql (sql): Reserving sql socket id: 4
> rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value,
> op           FROM radcheck           WHERE Username =
> 'bob at 192.168.95.248'           ORDER BY id
> radius_xlat:  'SELECT
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
> FROM radgroupcheck,usergroup WHERE usergroup.Username =
> 'bob at 192.168.95.248' AND usergroup.GroupName = radgroupcheck.GroupName
> ORDER BY radgroupcheck.id'
> rlm_sql_mysql: query:  SELECT
> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
> FROM radgroupcheck,usergroup WHERE usergroup.Username =
> 'bob at 192.168.95.248' AND usergroup.GroupName = radgroupcheck.GroupName
> ORDER BY radgroupcheck.id
> radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM
> radreply           WHERE Username = 'bob at 192.168.95.248'           ORDER
> BY id'
> rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value,
> op           FROM radreply           WHERE Username =
> 'bob at 192.168.95.248'           ORDER BY id
> radius_xlat:  'SELECT
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
> FROM radgroupreply,usergroup WHERE usergroup.Username =
> 'bob at 192.168.95.248' AND usergroup.GroupName = radgroupreply.GroupName
> ORDER BY radgroupreply.id'
> rlm_sql_mysql: query:  SELECT
> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
> FROM radgroupreply,usergroup WHERE usergroup.Username =
> 'bob at 192.168.95.248' AND usergroup.GroupName = radgroupreply.GroupName
> ORDER BY radgroupreply.id
> rlm_sql (sql): Released sql socket id: 4
>   modcall[authorize]: module "sql" returns ok for request 35
> modcall: leaving group authorize (returns ok) for request 35
> auth: type Local
> auth: No User-Password or CHAP-Password attribute in the request
> auth: Failed to validate the user.
> Login incorrect: [bob at 192.168.95.248/<no User-Password attribute>] (from
> client wifirst port 0)
> Delaying request 35 for 1 seconds
> Finished request 35
> Going to the next request
> Waking up in 4 seconds.
>
> Dan-Cristian Bogos a écrit :
> > Yeah,
> >
> > u must tell openser which request to account by setting the flag for
> > accounting (eg: INVITE and BYE methods).
> >
> > I would suggest checking the following docs before going further:
> >
> > http://www.openser.org/docs/modules/1.2.x/acc.html#AEN295
> > http://www.openser.org/docs/openser-radius-1.0.x.html
> >
> > DanB
> >
> > On 7/23/07, Marc LEURENT <lftsy at free.fr> wrote:
> >> I've checked in the radiusclient-ng config file, the acctserver is
> >> configured.
> >> But when I use 'ngrep port 1813' I can't see anything coming
> >> What do you mean by setflag for accounting?
> >> Is there something to add in the openser config file?
> >>
> >> Thanks,
> >> Best Regards
> >>
> >> Marc
> >>
> >> Dan-Cristian Bogos wrote:
> >> > Can u see accounting packets coming in FreeRADIUS (in the case you are
> >> > running this in debug mode it should be easier for you to
> >> > troubleshoot)? Did u mark the packets to be accounted by openser
> >> > (setflag for accounting). U must inform also radiusclient-ng where to
> >> > send the accounting packets.
> >> >
> >> > Let me know what u got.
> >> >
> >> > DanB
> >> >
> >> > On 7/23/07, Marc LEURENT <lftsy at free.fr> wrote:
> >> >> My first problem is that accounting doesn't work...
> >> >> I have followed the
> >> >> http://www.openser.org/docs/openser-radius-1.0.x.html tutorial,
> >> >> compiling freeradius by hand, adding the radius acc
> >> >> but openser doesn't seem to send accounting request to freeradius...
> >> >> (but auth works very well)
> >> >>
> >> >> My openser.cfg looklikes:
> >> >>
> >> >> loadmodule "acc.so"                     # Accounting Module
> >> >> modparam("acc", "radius_config",
> >> >> "/etc/radiusclient-ng/radiusclient.conf")
> >> >>
> >> >> Is there something else to add??
> >> >> Thanks
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Dan-Cristian Bogos wrote:
> >> >> > Hi Marc,
> >> >> >
> >> >> > I am using the scenario u have specified.
> >> >> > What do u mean by "Freeradius doesn't work anymore". Can u post us
> >> >> > some logs? A good point to start troubleshooting would be starting
> >> >> > FreeRADIUS in debug mode (freeradius -X).
> >> >> >
> >> >> > Cheers,
> >> >> > DanB
> >> >> >
> >> >> > On 7/23/07, Marc LEURENT <lftsy at free.fr> wrote:
> >> >> >> Good Morning everybody,
> >> >> >> I hope you had a pleasant week-end!
> >> >> >> I'm trying to set up an infrastructure for prepaid calls for my
> >> >> school
> >> >> >> working with OpenSER + Freeradius + CDRTool
> >> >> >> OpenSER is working well with FreeRadius, but I have followed the
> >> >> CDRTool
> >> >> >> installation tutorial and now Freeradius doesn't work anymore...
> >> >> >> Both OpenSER and freeradius data is stored in an mysql
> >> database, but
> >> >> >> when I was installing CDRTool, I had to modify their database
> >> >> following
> >> >> >> http://cdrtool.ag-projects.com/doc/INSTALL.txt
> >> >> >>
> >> >> >> Is there someone who succeed in setting up this installation...
> >> >> >>
> >> >> >> Any Help or just any hope to succeed?
> >> >> >> PS: I'm using OpenSER 1.2.1-1 compiled by hand, Freeradius 1.1.3-3
> >> >> and
> >> >> >> cdrtool_5.2.1_all.deb
> >> >> >>
> >> >> >> Marc
> >> >> >>
> >> >> >>
> >> >> >> _______________________________________________
> >> >> >> Users mailing list
> >> >> >> Users at openser.org
> >> >> >> http://openser.org/cgi-bin/mailman/listinfo/users
> >> >> >>
> >> >>
> >>
>




More information about the Users mailing list