[EMAIL PROTECTED] writes: >Because freeradius has to authenticate with a database which is not owned >by >us. >I can't add anything to that database. > >What I mean is that database just have field Username, Password and other >fields which is >not meaningful to freeradius. > >I have modified sql.conf, I dont know how to modify the authorisation and >accounting setting in sql.conf
Ah, with you now: basically, what you want to do is auth against one SQL (which you have no control over) yet account against another (which, I assume, you do?). I think you can do that. Something like this I'd guess (anyone?): You need to set up multiple separate SQL instances in sql.conf (e.g. 'sql1' to talk to your existing db for auth, editing the SQL statements there in as necessary for the existing server's field and db names, and 'sql2' for the accounting (using the standard freeradius accounting table structure)). Basically, in sql.conf duplicate the existing main 'sql' entry so you have two, rename each one to sql1 and sql2, point the first at your auth db (and edit the SQL lines as needed) and the second at your new accounts db. Put sql1 in the authorization section of radiusd.conf and sql2 in the accounting section. Or something like that. I think... Regards, SB Scott Bartlett BTA Limited, 100 High Street Wandsworth, London SW18 4LA, United Kingdom e: [EMAIL PROTECTED] v: +44 (0)20 8871 4240 f: +44 (0)20 8871 4584 Network Consultancy and Support for Windows 9x/NT and MacOS. Internet connectivity, solutions, and business services. http://www.bta.com. This message is intended only for the use of the person(s) ("The intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by BTA. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
