MySQL Commands for Radius Database


Radius Back Up Users Commands
Select * from rm_users INTO OUTFILE ‘/tmp/data’ FIELDS ENCLOSED BY ‘”‘ TERMINATED BY ‘,’;

How to change admin password in RADIUS MANAGER
update rm_managers set password=(‘password’) where managername=’admin’;

How to Check Managers List with Passwords
select managername, password from rm_managers;

Conntrack Users Back Up From MYSQL
select * from table INTO OUTFILE ‘/tmp/test.csv’ FIELDS ENCLOSED BY ‘”‘ TERMINATED BY ‘;’ ESCAPED BY ‘”‘ LINES TERMINATED BY ‘rn’;

Radius Users Login & Logout Access Commands
select * from username,acctstarttime,acctstoptime from radacct where username INTO OUTFILE ‘/tmp/logins03.xls’ FIELDS ENCLOSED BY ‘”‘ TERMINATED BY ‘;’ ESCAPED BY ‘”‘ LINES TERMINATED BY ‘rn’;

select username,framedipaddress,acctstarttime,acctstoptime from radacct where username;

How to Check Radius Username & Password
select * from radcheck order by username;

How to take backup Users list for Particular Manager
Select * from rm_users a, rm_managers b where a.owner=b.managername and b.managername=’NAME’ INTO OUTFILE ‘/tmp/users’ FIELDS ENCLOSED BY ‘”‘ TERMINATED BY ‘,’;

How to Check Users List for Particular Manager
Select * from rm_users a, rm_managers b where a.owner=b.managername and b.managername=’NAME’;

select distinct owner from rm_users;

Select b.managername,count(0) from rm_users a, rm_managers b where a.owner=b.managername  group by b.managername;

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s