| 3,7 → 3,7 |
|---|
| USER_NAME="test" |
| DB_USER=`cat $PASSWD_FILE|grep ^db_user=|cut -d'=' -f2` |
| DB_PASSWORD=`cat $PASSWD_FILE|grep ^db_password=|cut -d'=' -f2` |
| MAC_ADDRESSES="00:11:22:33:44:50 00:11:22:33:44:51 00:11:22:33:44:52" |
| MAC_ADDRESSES="00:11:22:33:44:50 00:11:22:33:44:51 00:11:22:33:44:52" # write here @MAC or user_names (delimiter=space) |
| |
| for MAC in $MAC_ADDRESSES |
| do |
| 13,7 → 13,7 |
|---|
| pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $algo_salt) |
| db_query1="INSERT INTO radcheck (username,attribute,op,value) VALUES ('$MAC', 'Crypt-Password', ':=', '$pass_salt'); INSERT INTO userinfo (username) VALUES ('$MAC');" |
| db_query2="DELETE FROM radcheck WHERE username = '$MAC'; DELETE FROM userinfo WHERE username = '$MAC';" |
| db_radcheck_insert_res=$(mysql -u $DB_USER -p$DB_PASSWORD -D radius -e "$db_query2" -Ns) |
| db_radcheck_insert_res=$(mysql -u $DB_USER -p$DB_PASSWORD -D radius -e "$db_query2" -Ns) # choose here db_query1 or 2 |
| echo -n "$MAC " |
| done |
| echo |