Hi Marc,
can u post somewhere your freeradius configuration(radius.conf+sql.conf)?
Do u have in your radcheck table username "bob(a)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(a)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(a)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(a)192.168.95.248'
rlm_sql (sql): sql_set_user escaped user --> 'bob(a)192.168.95.248'
radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM
radcheck WHERE Username = 'bob(a)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(a)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(a)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(a)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(a)192.168.95.248' ORDER
BY id'
rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value,
op FROM radreply WHERE Username =
'bob(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)openser.org
> >> >>
http://openser.org/cgi-bin/mailman/listinfo/users
> >> >>
> >>
>