Hi Marc, can u post somewhere your freeradius configuration(radius.conf+sql.conf)? Do u have in your radcheck table username "[EMAIL PROTECTED]"? 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 <[EMAIL PROTECTED]> 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 = "[EMAIL PROTECTED]" 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: '[EMAIL PROTECTED]' rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]' radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '[EMAIL PROTECTED]' 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 = '[EMAIL PROTECTED]' ORDER BY id radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = '[EMAIL PROTECTED]' 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 = '[EMAIL PROTECTED]' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = '[EMAIL PROTECTED]' ORDER BY id' rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = '[EMAIL PROTECTED]' ORDER BY id radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = '[EMAIL PROTECTED]' 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 = '[EMAIL PROTECTED]' 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: [EMAIL PROTECTED]/<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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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@openser.org >> >> >> http://openser.org/cgi-bin/mailman/listinfo/users >> >> >> >> >> >>
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users