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 >

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 > >> >

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 > >> >> > >> >

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 > >> >> >> > >> >> > >> >