Re: Username in MySQL with regexp
On Monday 10 July 2006 04:16, christian meutes wrote: Hey list, can anybody give me an example for this? cheers, Christian Meutes systems engineer My suggestion is to get it working with the flat users file first, then migrate the config to your MySQL users file. Start simple, then try to get the more complex configuration working. If you already have the regexp line written for your users file, please post it so we can recommend the best way to accomplish the same checks and replies in MySQL. Kevin Bonner pgpa3lB8xHEv8.pgp Description: PGP signature - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Username in MySQL with regexp
DEFAULT, just like in the users file. Alan DeKok. What do i have to set for further reply-item settings in the User-Name column? I have more than one Username which should be checked against a regexp and then should reply individual items. Sorry but i dont understand you answer :-( Christian Meutes systems engineer -- claranet gmbh internet service provider tel +49 (0) 69 - 40 80 18 - 300 email: [EMAIL PROTECTED] http://www.claranet.de/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Hey list, can anybody give me an example for this? cheers, Christian Meutes systems engineer -- claranet gmbh internet service provider tel +49 (0) 69 - 40 80 18 - 300 email: [EMAIL PROTECTED] http://www.claranet.de/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Username in MySQL with regexp
DEFAULT, just like in the users file. Alan DeKok. What do i have to set for further reply-item settings in the User-Name column? I have more than one Username which should be checked against a regexp and then should reply individual items. Sorry but i dont understand you answer :-( Christian Meutes systems engineer -- claranet gmbh internet service provider tel +49 (0) 69 - 40 80 18 - 300 email: [EMAIL PROTECTED] http://www.claranet.de/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Username in MySQL with regexp
Hello Alan, --On Monday, July 03, 2006 12:11:14 PM -0400 Alan DeKok [EMAIL PROTECTED] wrote: Add a compare attribute User-Name, with operator =~, and put the regex into the value field. What has to be in the Username column then? Christian Meutes systems engineer -- claranet gmbh internet service provider tel +49 (0) 69 - 40 80 18 - 300 email: [EMAIL PROTECTED] http://www.claranet.de/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Username in MySQL with regexp
christian meutes [EMAIL PROTECTED] wrote: What has to be in the Username column then? DEFAULT, just like in the users file. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Username in MySQL with regexp
christian meutes [EMAIL PROTECTED] wrote: iam using FreeRADIUS-1.0.5 with MySQL-Backend. Now i want a username check with an regexp operator (=~), so that i can match usernames (+1234567(0-9)) against a regexp of ^\+^1234567 and dont have the need of creating 10 users which have all the same reply attributes. Use the regex operator... How can i accomplish this? The username itself in the MySQL table doesnt has a check row.. Add a compare attribute User-Name, with operator =~, and put the regex into the value field. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html