blaqb0x@netscape.net wrote:

I'm trying to get mac authentication to a mysql database where the mac addresses are stripped of all special characters.

If I add this line to the /sql/mysql/dialup.conf file

sql_user_name = "%{Calling-Station-Id}"

the calling-station-id (username passed to mysql) is the correct mac address however, it has still needs to have all the special characters (hyphens) removed.

Can someone show me an example of how to modify the calling-station-id? I suppose using rlm_perl would be the best way as I could modify it using perl.

I like to RFCise my attributes, so instead slip into policy.conf the following: ---- rewrite.calling_station_id { if( "%{request:Calling-Station-Id}" =~ /^([0-9a-f]{2}).?([0-9a-f]{2}).?([0-9a-f]{2}).?([0-9a-f]{2}).?([0-9a-f]{2}).?([0-9a-f]{2})$/i ){ update request { Calling-Station-Id := "%{1}-%{2}-%{3}-%{4}-%{5}-%{6}" } } else { noop } } ---- After you call 'preprocess' in authorize, call 'rewrite.calling_station_id' and you should be good. Trivial to amend to your needs. I also recommend in your SQL syntax you wrap it in a call to LOWER() so then everything is in lowercase in your table. Cheers -- Alexander Clouter .sigmonster says: Snoopy: No problem is so big that it can't be run away from.