[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Help-gnu-radius] (no subject)
From: |
David Friedman |
Subject: |
[Help-gnu-radius] (no subject) |
Date: |
Wed, 20 Feb 2002 22:19:51 -0500 |
User-agent: |
Mutt/1.2.5i |
I'm a bit confused by these errors:
Feb 20 22:04:34: Acct.error: MYSQL Error (-1): Cannot Query:UPDATE calls SET
status=,acct_session_time=18,acct_input_octets=6721,acct_output_octets=12153,connect_term_reason=45
WHERE user_name='michele' AND status = 1 AND
acct_session_id='BFEF7BFE:000CE862'
Feb 20 22:04:34: Acct.error: MYSQL Error: query UPDATE calls SET
status=,acct_session_time=18,acct_input_octets=6721,acct_output_octets=12153,connect_term_reason=45
WHERE user_name='michele' AND status = 1 AND
acct_session_id='BFEF7BFE:000CE862'
# Query to be used on session end
acct_stop_query UPDATE calls \
SET status=%C{Acct-Status-Type},\
acct_session_time=%C{Acct-Session-Time},\
acct_input_octets=%C{Acct-Input-Octets},\
acct_output_octets=%C{Acct-Output-Octets},\
connect_term_reason=%C{Acct-Terminate-Cause} \
WHERE user_name='%C{User-Name}' \
AND status = 1 \
AND acct_session_id='%C{Acct-Session-Id}'
mysql> desc calls;
+---------------------+--------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default |
Extra |
+---------------------+--------------------+------+-----+---------------------+-------+
| status | int(5) | | MUL | 0 |
|
| user_name | varchar(32) binary | | MUL | |
|
| event_date_time | datetime | | | 0000-00-00 00:00:00 |
|
| nas_ip_address | varchar(17) | | | 0.0.0.0 |
|
| nas_port_id | int(10) | YES | | NULL |
|
| acct_session_id | varchar(17) | | | |
|
| acct_session_time | int(10) | YES | | NULL |
|
| acct_input_octets | int(10) | YES | | NULL |
|
| acct_output_octets | int(10) | YES | | NULL |
|
| connect_term_reason | int(10) | YES | | NULL |
|
| framed_ip_address | varchar(17) | YES | | NULL |
|
| called_station_id | varchar(32) | YES | | NULL |
|
| calling_station_id | varchar(32) | YES | | NULL |
|
+---------------------+--------------------+------+-----+---------------------+-------+
13 rows in set (0.00 sec)
mysql>
Any idea how to fix this? Thanks.
--
David Friedman (address@hidden)
www.irctoo.net - IRCtoo... because it's not just irc.
- [Help-gnu-radius] (no subject),
David Friedman <=