Jul 6 16:13:51 sesapp mediaproxy[10602]: error: accounting failed. MySQL error: (2006, 'MySQL server has gone away')
Jul 6 16:13:51 sesapp mediaproxy[10602]: SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam Softphone release 1002t stamp 29726',
Jul 6 16:13:51 sesapp mediaproxy[10602]: SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam Softphone release 1002t stamp 29726',
From: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of İlker Aktuna (Koç.net)
Sent: Friday, June 23, 2006 11:25 AM
To: Adrian Georgescu; serusers@lists.iptel.org
Subject: RE: [Serusers] Mediaproxy problem - accounting
Hi,
Yes I have the python mysql package installed. My
radacct table is like below:
mysql> describe
radacct;
+-------------------------+----------------------+------+-----+---------------------+----------------+
|
Field
|
Type
| Null | Key |
Default
| Extra
|
+-------------------------+----------------------+------+-----+---------------------+----------------+
|
RadAcctId
| bigint(21) |
NO | PRI |
NULL
| auto_increment |
|
AcctSessionId |
varchar(255) | NO |
MUL
|
|
|
|
AcctUniqueId |
varchar(255) | NO |
MUL
|
|
|
|
UserName
| varchar(64) |
NO | MUL
|
|
|
|
Realm
| varchar(64) | YES
| MUL
|
|
|
|
NASIPAddress |
varchar(15) |
NO | MUL
|
|
|
|
NASPortId
| varchar(50) |
NO |
|
|
|
|
NASPortType
| varchar(255) | NO
|
|
|
|
| AcctStartTime
|
datetime
| NO | MUL | 0000-00-00 00:00:00
|
|
|
AcctStopTime |
datetime
| NO | MUL | 0000-00-00 00:00:00
|
|
| AcctSessionTime |
int(12)
| YES | |
NULL
|
|
| AcctAuthentic
| varchar(32) | YES
| |
NULL
|
|
| ConnectInfo_start |
varchar(32) | YES
| |
NULL
|
|
| ConnectInfo_stop |
varchar(32) | YES
| |
NULL
|
|
| AcctInputOctets |
bigint(12) |
YES | |
NULL
|
|
| AcctOutputOctets |
bigint(12) |
YES | |
NULL
|
|
| CalledStationId |
varchar(50) |
NO | MUL
|
|
|
| CallingStationId |
varchar(50) |
NO | MUL
|
|
|
| AcctTerminateCause |
varchar(32) |
NO |
|
|
|
|
ServiceType
| varchar(32) | YES
| |
NULL
|
|
| FramedProtocol |
varchar(32) | YES
| |
NULL
|
|
| FramedIPAddress |
varchar(15) |
NO |
|
|
|
| AcctStartDelay |
int(12)
| YES | |
NULL
|
|
| AcctStopDelay
|
int(12)
| YES | |
NULL
|
|
|
SipMethod
| varchar(50) |
NO |
|
|
|
| SipResponseCode |
smallint(5) unsigned | NO | |
0
|
|
|
SipToTag
| varchar(128) | NO
|
|
|
|
|
SipFromTag
| varchar(128) | NO
|
|
|
|
| SipTranslatedRequestURI |
varchar(255) | NO |
MUL
|
|
|
| SipUserAgents
| varchar(255) | NO
|
|
|
|
| SipApplicationType |
varchar(255) | NO
|
|
|
|
|
SipCodecs
| varchar(255) | NO
|
|
|
|
|
SipRPID
| varchar(255) | NO
|
|
|
|
| SipRPIDHeader
| varchar(255) | NO
|
|
|
|
|
SourceIP
| varchar(255) | NO
| MUL
|
|
|
|
SourcePort
| varchar(255) | NO
|
|
|
|
|
CanonicalURI |
varchar(255) | NO |
MUL
|
|
|
|
DelayTime
| varchar(5) |
NO |
|
|
|
|
Timestamp
| bigint(20) |
NO | |
0
|
|
| DestinationId
| varchar(15) |
NO | MUL
|
|
|
|
Rate
|
text
| NO |
|
|
|
|
Price
| double(20,4) | YES
| |
NULL
|
|
|
Normalized
| enum('0','1') | YES | MUL |
0
|
|
|
BillingId
| varchar(255) | NO
| MUL
|
|
|
|
MediaInfo
| varchar(32) | YES
| MUL |
NULL
|
|
| RTPStatistics
|
text
| NO |
|
|
|
|
FromHeader
| varchar(128) | NO
|
|
|
|
|
UserAgent
| varchar(128) | NO
|
|
|
|
|
Contact
| varchar(128) | NO
|
|
|
|
+-------------------------+----------------------+------+-----+---------------------+----------------+
49
rows in set (0.04 sec)
Any idea where the problem is
?
Thanks,
ilker
-----Original Message-----
From:
serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org]
On Behalf Of Adrian Georgescu
Sent: Friday, June 23, 2006 11:22 AM
To:
serusers@lists.iptel.org
Subject: [Serusers] Mediaproxy problem -
accounting
hi Ilker,
Pl check if you have the mysql python package
installed. On Debian the name of the packet is python-mysqldb
ii
python-mysqldb
1.2.1c3-4 A Python interface
to
MySQL
also make sure you have the extra fields in the radacct
table.
Adrian
=============
Hi,
I am trying to use
dbaccounting with mediaproxy. Undfortunately it doesn't seem to send anything to
mysql db.
How can I trace where the problem is ?
My mediaproxy
accounting config is :
[Accounting]
dbaccounting =
on
[Database]
user = ser
password = heslo
host =
127.0.0.1
database = radius
table =
radacct
Thanks,
ilker
