в логах mysql.log
Код: Выделить всё
081225 19:58:28 185 Connect abills@localhost on abills
185 Query set autocommit=1
185 Query SELECT id, name, nas_identifier, descr, ip, nas_type, auth_type, mng_host_port, mng_user,
DECODE(mng_password, 'test12345678901234567890'), rad_pairs, alive, disable, ext_acct
FROM nas
WHERE ip='10.0.40.1' and nas_identifier=''
ORDER BY nas_identifier DESC
185 Query UPDATE dv_calls SET
status='3',
nas_port_id='0',
acct_session_time=UNIX_TIMESTAMP()-UNIX_TIMESTAMP(started),
acct_input_octets='720840',
acct_output_octets='386030',
ex_input_octets='0',
ex_output_octets='0',
framed_ip_address=INET_ATON('172.0.10.225'),
lupdated=UNIX_TIMESTAMP(),
sum=sum+0,
acct_input_gigawords='0',
acct_output_gigawords='0'
WHERE
acct_session_id="4953B68C1D2700" and
user_name="Avtogen" and
nas_id='1'
185 Query INSERT into s_detail (acct_session_id, nas_id, acct_status, last_update,
sent1, recv1, sent2, recv2, id)
VALUES ("4953B68C1D2700", '1',
'3', UNIX_TIMESTAMP(),
'0', '0',
'0', '0',
'Avtogen')
185 Quit