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

[Randeep]

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 at 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>