Hi, Well I did not get the zip file but did find the solution. What I did not know was to add the information into the database. Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from radcheck; +----+------------+----------------+----+------------------------------------+ | id | UserName | Attribute | op | Value | +----+------------+----------------+----+------------------------------------+ | 1 | fred | User-Password | == | wilma | | 2 | barney | User-Password | == | betty | | 3 | dialrouter | User-Password | == | dialup | | 4 | frankr | User-Password | == | missy | | 6 | flr | Crypt-Password | == | $1$M/Dyy6Ix$wEc4DMMhp4MK222lTn1X/0 | | 7 | flr3 | Crypt-Password | == | $1$NxQPW2DB$glf2EPj/iPS3H8SwId6mA. | | 5 | flr1 | Crypt-Password | == | $1$HoIOzDKM$.TZWU5kiU9.sjHGrbSkc.1 | | 8 | flr1 | Auth-Type | == | Crypt-Local | | 9 | flr | Auth-Type | == | Crypt-Local | | 10 | flr3 | Auth-Type | == | Crypt-Local | | 11 | flr2 | Crypt-Password | == | $1$bZTA.bno$RgogLTF9j9/H7jTsnAsLQ. | | 12 | flr2 | Auth-Type | == | Crypt-Local | | 13 | flr4 | Crypt-Password | == | $1$Q42F5AEu$Oq7g9z2s38PsQ4Qzjv14Z0 | | 14 | flr4 | Auth-Type | == | Crypt-Local | +----+------------+----------------+----+------------------------------------+ 14 rows in set (0.01 sec) Below is a test bash shell that works #!/bin/bash set -v IDV=$(mysql radius -e "select max(id)+1 from radcheck;" | grep -v max) USV=$(mysql radius -e "select UserName from usergroup where UserName = '$1';" | grep -c $1) HTS=$(grep master-host /etc/my.cnf | awk -F= '{ print $2 }') HPW=$(grep master-password /etc/my.cnf | awk -F= '{ print $2 }') HUS=$(grep master-user /etc/my.cnf | awk -F= '{ print $2 }') HCP=$(openssl passwd -1 $2) echo "$2 $HCP" if [ $USV -eq 0 ] then RSV=$(mysql radius -e "select UserName from radcheck where UserName = '$1';" | grep -c "$1") if [ $RSV -eq 0 ] then echo "Adding user $1 $2" echo "insert into usergroup (UserName, GroupName) values('$1', 'dynamic');" > /tmp/maddusr.tmp echo "insert into radcheck ( UserName, Attribute, op, Value) values('$1', 'Crypt-Password', '==', '$HCP');" >> /tmp/maddusr.tmp echo "insert into radcheck ( UserName, Attribute, op, Value) values('$1', 'Auth-Type', '==', 'Crypt-Local');" >> /tmp/maddusr.tmp echo "select * from usergroup;" >> /tmp/maddusr.tmp echo "select * from radcheck;" >> /tmp/maddusr.tmp cat /tmp/maddusr.tmp mysql radius < /tmp/maddusr.tmp > /tmp/maddusr.log radtest $1 $2 localhost 1 p1zzap1e | tee -a /tmp/maddusr.log # rm -f /tmp/maddusr.tmp fi fi [root@localhost ~]# Frank Reiss Impeva Labs, Inc. Phone: 1-850-872-7099 COMPANY CONFIDENTIAL NOTICE This electronic mail transmission and any accompanying documents contain information belonging to the sender which may be company confidential and legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or action taken in reliance on the message is strictly prohibited. If you have received this message in error, please delete it. Thank You ----- Original Message ----- From: "Marco Spiga" <ctxspi@gmail.com> To: "Frank Reiss" <f.reiss@impeva.com> Cc: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Saturday, January 14, 2006 6:55 AM Subject: Re: How do you setup MD5 using Freeradius and MySQL?
On Fri, Jan 13, 2006 at 06:18:41PM -0600, Frank Reiss wrote:
From: "Frank Reiss" <f.reiss@impeva.com> To: <freeradius-users@lists.freeradius.org> Date: Fri, 13 Jan 2006 18:18:41 -0600 X-Mailer: Microsoft Outlook Express 6.00.2900.2180 Subject: How do you setup MD5 using Freeradius and MySQL?
HI,
Well I tested the MD5 authentication using the user file and that worked but I still can not figure out how to do it against the mysql database. Is there anyone out there that knows hot to set this up I would appreciate some HELP!!
Frank Reiss - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---fine del testo---
If you want I send you a file tar.gz that work fine with Postgresql and eap-md5!!! I think there are few differences!!! Sorry for my bad english!!! -- !!!!! Messaggio da Marco !!!!!