Hi, Someone or some script should be doing this. Check the mysql history you can see the commands executed to delete the rows. Change your mysql password and try again. Regards, Randeep On Tue, Jul 14, 2015 at 1:48 PM, Sophie Loewenthal < sophie.loewenthal@trimbletl.com> wrote:
Dear everybody,
I was asked to manaully add a user into our Radius db for some thrird party monitoring. Sometimes when I insert the row it's there, but after 5 mins or less the row is removed, as shown below. Does some Radius process remove rows?
* First attempt * mysql> INSERT INTO radcheck (id, username, attribute, op, value) VALUES (DEFAULT,'xmonitor1','User-Password',':=','xxxxxxx'); Query OK, 1 row affected (0.01 sec) mysql> select * from radcheck where username = 'xmonitor1'; Empty set (0.01 sec) (Disappeared immediately!)
* Try again * mysql> INSERT INTO radcheck (id, username, attribute, op, value) VALUES (DEFAULT,'xmonitor1','User-Password',':=','xxxxxxx'); Query OK, 1 row affected (0.00 sec) mysql> select * from radcheck where username = 'xmonitor1'; +-------+-----------+---------------+----+---------+ | id | username | attribute | op | value | +-------+-----------+---------------+----+---------+ | 65745 | xmonitor1 | User-Password | := | xxxxxxx | +-------+-----------+---------------+----+---------+ 1 row in set (0.00 sec) ( Now it's there) ( Let's wait 5 mins and try this query again ) mysql> select * from radcheck where username = 'xmonitor1'; Empty set (0.00 sec) ( Opps. now it's gone ) ( Let's see if some other entry took this id ) mysql> select * from radcheck where id = '65745'; Empty set (0.00 sec) mysql> select * from radcheck where id = 65745; Empty set (0.00 sec) ( Nope ).
Operating System: CentOS 6.2
RADIUS Server: freeradius-mysql-2.1.12-1.el6.x86_64 freeradius-utils-2.1.12-1.el6.x86_64 freeradius-2.1.12-1.el6.x86_64
MYSQL server: percona-xtrabackup-2.2.9-5067.el6.x86_64 Percona-Server-shared-56-5.6.21-rel69.0.el6.x86_64 Percona-Server-server-56-5.6.21-rel69.0.el6.x86_64 Percona-Server-shared-compat-5.5.30-rel30.2.508.rhel6.x86_64 percona-toolkit-2.2.3-1.noarch Percona-Server-client-56-5.6.21-rel69.0.el6.x86_64
I'd be very grateful if somebody could let me know how I could diagnose this, or perhaps tell me the right way to insert a username+password into Radius.
Kind regards. Sophie - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Randeep Mob: +919447831699[kerala] Mob: +919880050349[B'lore] http://twitter.com/Randeeppr http://in.linkedin.com/in/randeeppr [image: --] Randeep Raman [image: http://]about.me/Randeeppr <http://about.me/Randeeppr>