<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
                                                                <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-16"><TITLE></TITLE>
<META http-equiv=EXPIRES content=0>
<META http-equiv=EXPIRESABSOLUTE content="Tue, 01 Jun 1999 12:00:00 GMT">
<META http-equiv=PRAGMA content=NO-CACHE>
<META http-equiv=CACHE-CONTROL content=PRIVATE>
<META http-equiv=CACHE-CONTROL content=NO-CACHE>
<META content="MSHTML 6.00.2900.2838" name=GENERATOR></HEAD>
                                                        <BODY >
                                                                <DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN class=724535912-06072006>I
still couldn't solve the mediaproxy accounting problem.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006>In the syslog I see following messages
:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006>Jul 6 16:13:51 sesapp mediaproxy[10602]: error:
accounting failed. MySQL error: (2006, 'MySQL server has gone
away')<BR>Jul 6 16:13:51 sesapp mediaproxy[10602]: error: accounting
failed. MySQL error: (2006, 'MySQL server has gone away')<BR>Jul 6
16:13:51 sesapp
mediaproxy[10602]:
SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam
Softphone release 1002t stamp 29726',<BR>Jul 6 16:13:51 sesapp
mediaproxy[10602]:
SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam
Softphone release 1002t stamp 29726',</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006>Mysql server is up and running.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006>What may be the problem here ?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006>Thanks,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=724535912-06072006>ilker</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=724535912-06072006></SPAN></FONT> </DIV><FONT face=Arial
size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] <B>On Behalf Of </B>İlker Aktuna
(Koç.net)<BR><B>Sent:</B> Friday, June 23, 2006 11:25 AM<BR><B>To:</B> Adrian
Georgescu; serusers@lists.iptel.org<BR><B>Subject:</B> RE: [Serusers] Mediaproxy
problem - accounting<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Hi,<BR><BR>Yes I have the python mysql package installed. My
radacct table is like below:<BR><BR>mysql> describe
radacct;<BR>+-------------------------+----------------------+------+-----+---------------------+----------------+<BR>|
Field
|
Type
| Null | Key |
Default
| Extra
|<BR>+-------------------------+----------------------+------+-----+---------------------+----------------+<BR>|
RadAcctId
| bigint(21) |
NO | PRI |
NULL
| auto_increment |<BR>|
AcctSessionId |
varchar(255) | NO |
MUL
|
|
|<BR>|
AcctUniqueId |
varchar(255) | NO |
MUL
|
|
|<BR>|
UserName
| varchar(64) |
NO | MUL
|
|
|<BR>|
Realm
| varchar(64) | YES
| MUL
|
|
|<BR>|
NASIPAddress |
varchar(15) |
NO | MUL
|
|
|<BR>|
NASPortId
| varchar(50) |
NO |
|
|
|<BR>|
NASPortType
| varchar(255) | NO
|
|
|
|<BR>| AcctStartTime
|
datetime
| NO | MUL | 0000-00-00 00:00:00
|
|<BR>|
AcctStopTime |
datetime
| NO | MUL | 0000-00-00 00:00:00
|
|<BR>| AcctSessionTime |
int(12)
| YES | |
NULL
|
|<BR>| AcctAuthentic
| varchar(32) | YES
| |
NULL
|
|<BR>| ConnectInfo_start |
varchar(32) | YES
| |
NULL
|
|<BR>| ConnectInfo_stop |
varchar(32) | YES
| |
NULL
|
|<BR>| AcctInputOctets |
bigint(12) |
YES | |
NULL
|
|<BR>| AcctOutputOctets |
bigint(12) |
YES | |
NULL
|
|<BR>| CalledStationId |
varchar(50) |
NO | MUL
|
|
|<BR>| CallingStationId |
varchar(50) |
NO | MUL
|
|
|<BR>| AcctTerminateCause |
varchar(32) |
NO |
|
|
|<BR>|
ServiceType
| varchar(32) | YES
| |
NULL
|
|<BR>| FramedProtocol |
varchar(32) | YES
| |
NULL
|
|<BR>| FramedIPAddress |
varchar(15) |
NO |
|
|
|<BR>| AcctStartDelay |
int(12)
| YES | |
NULL
|
|<BR>| AcctStopDelay
|
int(12)
| YES | |
NULL
|
|<BR>|
SipMethod
| varchar(50) |
NO |
|
|
|<BR>| SipResponseCode |
smallint(5) unsigned | NO | |
0
|
|<BR>|
SipToTag
| varchar(128) | NO
|
|
|
|<BR>|
SipFromTag
| varchar(128) | NO
|
|
|
|<BR>| SipTranslatedRequestURI |
varchar(255) | NO |
MUL
|
|
|<BR>| SipUserAgents
| varchar(255) | NO
|
|
|
|<BR>| SipApplicationType |
varchar(255) | NO
|
|
|
|<BR>|
SipCodecs
| varchar(255) | NO
|
|
|
|<BR>|
SipRPID
| varchar(255) | NO
|
|
|
|<BR>| SipRPIDHeader
| varchar(255) | NO
|
|
|
|<BR>|
SourceIP
| varchar(255) | NO
| MUL
|
|
|<BR>|
SourcePort
| varchar(255) | NO
|
|
|
|<BR>|
CanonicalURI |
varchar(255) | NO |
MUL
|
|
|<BR>|
DelayTime
| varchar(5) |
NO |
|
|
|<BR>|
Timestamp
| bigint(20) |
NO | |
0
|
|<BR>| DestinationId
| varchar(15) |
NO | MUL
|
|
|<BR>|
Rate
|
text
| NO |
|
|
|<BR>|
Price
| double(20,4) | YES
| |
NULL
|
|<BR>|
Normalized
| enum('0','1') | YES | MUL |
0
|
|<BR>|
BillingId
| varchar(255) | NO
| MUL
|
|
|<BR>|
MediaInfo
| varchar(32) | YES
| MUL |
NULL
|
|<BR>| RTPStatistics
|
text
| NO |
|
|
|<BR>|
FromHeader
| varchar(128) | NO
|
|
|
|<BR>|
UserAgent
| varchar(128) | NO
|
|
|
|<BR>|
Contact
| varchar(128) | NO
|
|
|
|<BR>+-------------------------+----------------------+------+-----+---------------------+----------------+<BR>49
rows in set (0.04 sec)<BR><BR>Any idea where the problem is
?<BR><BR>Thanks,<BR>ilker<BR><BR>-----Original Message-----<BR>From:
serusers-bounces@lists.iptel.org [<A
href="mailto:serusers-bounces@lists.iptel.org">mailto:serusers-bounces@lists.iptel.org</A>]
On Behalf Of Adrian Georgescu<BR>Sent: Friday, June 23, 2006 11:22 AM<BR>To:
serusers@lists.iptel.org<BR>Subject: [Serusers] Mediaproxy problem -
accounting<BR><BR>hi Ilker,<BR><BR>Pl check if you have the mysql python package
installed. On Debian the name of the packet is python-mysqldb<BR><BR>ii
python-mysqldb
1.2.1c3-4 A Python interface
to <BR>MySQL<BR><BR>also make sure you have the extra fields in the radacct
table.<BR><BR>Adrian<BR><BR>=============<BR><BR>Hi,<BR><BR>I am trying to use
dbaccounting with mediaproxy. Undfortunately it doesn't seem to send anything to
mysql db.<BR>How can I trace where the problem is ?<BR><BR>My mediaproxy
accounting config is :<BR><BR>[Accounting]<BR>dbaccounting =
on<BR><BR>[Database]<BR>user = ser<BR>password = heslo<BR>host =
127.0.0.1<BR>database = radius<BR>table =
radacct<BR><BR>Thanks,<BR>ilker</FONT></P></DIV>
<!--445D5241795C-->
<br><br><a href="http://387555.sigclick.mailinfo.com/sigclick/0A090F07/05044F00/0B050A4E/0219182013.jpg"><img src="http://387555.signature1.mailinfo.com/confirm2.6/0A090F07/05044F00/0B050A4E/0219182013.jpg" border="0" nosend="1"></a><!--445D5241795C//--></DIV>
                                                                <DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">
                                                                        <DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">
                                                                                <DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">_____________________________________________________________________________________________________________________________________________</DIV>
                                                                                <DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez. </DIV>
                                                                                <DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.</DIV>
                                                                                <DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">_____________________________________________________________________________________________________________________________________________</DIV>
                                                                                <DIV STYLE="FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana" ALIGN="justify">
</DIV>
</DIV>
</DIV></BODY></HTML>