Re: [Help-gnu-radius] Mysql Accounting

[Gerald]

> Everything seems OK. Are you experiencing any problems?

Nothing is getting written to the accounting DB...

Here's a test auth:

radauth -s x.x.x.x:foobar username password
PASS


Then on the mysql server:

mysql> use accounting
Database changed
mysql> describe calls;
+---------------------+----------+------+-----+---------------------+-------+
| Field               | Type     | Null | Key | Default             |
Extra |
+---------------------+----------+------+-----+---------------------+-------+
| status              | int(3)   | YES  |     | NULL                |
|
| user_name           | char(32) | YES  |     | NULL                |
|
| event_date_time     | datetime |      |     | 0000-00-00 00:00:00 |
|
| nas_ip_address      | char(17) | YES  |     | NULL                |
|
| nas_port_id         | int(6)   | YES  |     | NULL                |
|
| acct_session_id     | char(16) |      |     |                     |
|
| acct_session_time   | int(11)  | YES  |     | NULL                |
|
| acct_input_octets   | int(11)  | YES  |     | NULL                |
|
| acct_output_octets  | int(11)  | YES  |     | NULL                |
|
| connect_term_reason | int(4)   | YES  |     | NULL                |
|
| framed_ip_address   | char(17) | YES  |     | NULL                |
|
| called_station_id   | char(32) | YES  |     | NULL                |
|
| calling_station_id  | char(32) | YES  |     | NULL                |
|
+---------------------+----------+------+-----+---------------------+-------+
13 rows in set (0.00 sec)

mysql> select * from calls;
Empty set (0.00 sec)

mysql>


Radius server works fine with the mysql username/password DB but it's not
working with the accounting.users that's on the same mysql server. I'm not
a mysql expert by far but I can run the mysql client and connect into the
server and read the DB. I know I've got to be missing something obvious.

As before, thanks for any help in advance,

Gerald