Re: Custom SQL Query
Thanks for reply But in the sql.conf there are only authorise and accounting queries only. Can I add my query end of to that queries. Then how ?What I would like to do is After I received accounting query. I need to do some calculation and update some tables on 2 different database. Kevin Bonner [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE-Hash: SHA1On Monday 15 December 2003 18:03, Amgaabaatar Purevjal wrote: Hello I need to put some custom query after I receive accounting packet. Where I should look into it? rlm_sql.c is that correct file? Or I could add into accounting query? Thankssql.conf (by default) is where you should specify any query. There are defaults in there which can be modified so that they work with your local table structure.Kevin Bonner-BEGIN PGP SIGNATURE-Version: GnuPG v1.0.7 (GNU/Linux)iD8DBQE/3kAk/9i/ml3OBYMRAi3RAKCKrHJWCBVZNDJKoArQdUN2XRJeSgCgmrMJky0g9ymuz57CzJnBExTt+as==AbDr-END PGP SIGNATURE--List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Custom SQL Query
Hello I need to put some custom query after I receive accounting packet. Where I should look into it? rlm_sql.c is that correct file? Or I could add into accounting query? Thanks
Re: Quintum Help
Thanks The reason I edit dictionary files. I've got following error messages when I start radiusd files: compat = "no"/etc/raddb/users[3]: Parse error (reply) for entry 12345: Unknown attribute Quintum-h323-credit-ammountErrors reading /etc/raddb/usersradiusd.conf[921]: files: Module instantiation failed. My users file has onlu following entries 12345 User-Password = "12345" Quintum-h323-return-code = "h323-return-code=0", Quintum-h323-credit-ammount = "h323-credit-ammount=100", Quintum-h323-return-code = "h323-return-code=0", Quintum-h323-credit-time = "h323-credit-time=200", I've tried without Quintum too. then I' ve got Module: Loaded preprocessModule: Instantiated preprocess (preprocess)Module: Loaded realmModule: Instantiated realm (suffix)Module: Loaded files/etc/raddb/users[3]: Parse error (reply) for entry 12345: Unknown attribute h323-credit-ammountErrors reading /etc/raddb/usersradiusd.conf[921]: files: Module instantiation failed. Alan DeKok [EMAIL PROTECTED] wrote: Amgaabaatar Purevjal <[EMAIL PROTECTED]>wrote: Could you help me to configure freeradius for quintum . I installed radius. But itis rejecting users... rad_recv: Access-Request packet from host 192.168.1.10:24579, id=34, length=157 Attr-4 = 0xc0a8010a Attr-1 = 0x3132333435I am absolutely amazed at the effort you've put into destroying thedefault configuration of the server. You've done a lot of work tomake sure that the server won't be able to do anything.I have no idea why you've done this. The only answer I can give toyour problem is to use the server as it is installed. Don't breakit. Don't edit the dictionary files.Alan DeKok.- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Quintum Help
Never mind I found the error. It was typo that I put ammount instead of amount Thanks a lot Please ignore prevouis reply Alan DeKok [EMAIL PROTECTED] wrote: Amgaabaatar Purevjal <[EMAIL PROTECTED]>wrote: Could you help me to configure freeradius for quintum . I installed radius. But itis rejecting users... rad_recv: Access-Request packet from host 192.168.1.10:24579, id=34, length=157 Attr-4 = 0xc0a8010a Attr-1 = 0x3132333435I am absolutely amazed at the effort you've put into destroying thedefault configuration of the server. You've done a lot of work tomake sure that the server won't be able to do anything.I have no idea why you've done this. The only answer I can give toyour problem is to use the server as it is installed. Don't breakit. Don't edit the dictionary files.Alan DeKok.- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Quintum Help
Could you help me to configure freeradius for quintum . I installed radius. But itis rejecting users Thank You Here is my Quintum and Radius logs RADIUS : 565661:RadiusRequest: Sending Access-Request MsgId=24 to 192.168.1.3,port 1812, Descriptor 3RADIUS : 566160:RadiusResponse: Received response, length=20, id=24, type=3RADIUS : 566160:RadiusSocket: Received ACCESS REJECT RESPONSERADIUS : 566160:RadiusResponse: Created response object 0XB05E84RADIUS : 566160:RadiusSocket: Sent ProcessAccessReject iucaCallBackSendRADIUS : 566160:RadiusHandler: Received iucaCallBackSend Access-RejectRADIUS : 566160:RadiusRequest: Client Process Marked Object=0XBBB204 MsgId=24for DeletionRADIUS : 566160:RadiusRequest: Radius Process Deleted Object=0XBBB204, MsgId=24RADIUS : 566160:RadiusRequest: destroying request object 0XBBB204RADIUS : 566160:RadiusResponse: destroying response object 0XB05E84RADIUS : 566790:RadiusRequest: Created request object 0XD34404 And Radius Log rad_recv: Access-Request packet from host 192.168.1.10:24579, id=34, length=157 Attr-4 = 0xc0a8010a Attr-1 = 0x3132333435 Attr-2 = 0x3132333435 Attr-61 = 0x Attr-31 = 0x36333037373635343634 Quintum-h323-conf-id = "h323-conf-id=33666235 36646263 31310030 003100FF" Quintum-AVPair = "h323-ivr-out=ACCESSCODE:"auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the userauth: Failed to validate the user.Login incorrect: [12345/12345] (from client quintum port 0 cli 6307765464)Delaying request 4 for 1 seconds