Manual insert of credentials into radcheck row disappears after five mins ( MySQL )

Sophie Loewenthal sophie.loewenthal at trimbletl.com
Tue Jul 14 10:18:54 CEST 2015


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


More information about the Freeradius-Users mailing list