<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<!-- Template generated by Exclaimer Mail Disclaimers on 11:32:44 Wednesday, 27 May 2015 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.2a79f525-1347-4057-825a-f202038eb911 {
MARGIN: 0cm 0cm 0pt
}
LI.2a79f525-1347-4057-825a-f202038eb911 {
MARGIN: 0cm 0cm 0pt
}
DIV.2a79f525-1347-4057-825a-f202038eb911 {
MARGIN: 0cm 0cm 0pt
}
TABLE.2a79f525-1347-4057-825a-f202038eb911Table {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<p class="2a79f525-1347-4057-825a-f202038eb911"></p>
<div class="WordSection1">
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Dears,
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Recently we had some change on our network, as we replaced cisco platform with Huawei BRAS, now we’re unable to get prober accounting
specially, when customer account are newly created so we can’t get account activation on the first logging in order to calculate Session-timeout, below are the error logs plus the part of the configuration:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">################################<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><AuthBy SQL><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AccountingTable DSL_ACCOUNTING<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef USERNAME,User-Name,%A<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef TIME_STAMP,Timestamp,integer<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef ACCTSESSIONID,Acct-Session-Id<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef acctterminatecause, Acct-Terminate-Cause<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef NASIDENTIFIER,NAS-Identifier<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef NASPORT,NAS-Port,integer<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> #AcctInsertQuery insert into %0 (%1) values (%2)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AuthColumnDef 0,User-Password, check<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AuthColumnDef 1,Expiration, check<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AuthColumnDef 2,Simultaneous-Use, check<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AuthColumnDef 3,Huawei-Domain-Name, reply<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AuthColumnDef 4,GENERIC, reply<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:48.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">AuthSelect select PASSWORD, to_char(EXPIRATION, 'yyyy-mm-dd HH24:MI:SS') Expiration, MAXSESSIONS, EXPIRATION_D "Huawei-Domain-Name"
, Session_Timeout "Session-Timeout" from ITC_ACCOUNTS_H where upper(USERNAME)=upper('%n')
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> CachePasswordExpiry 86400<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> AddToReply Service-Type=Framed-User, Framed-Protocol=PPP, Framed-MTU=1492, Session-Timeout = "until Expiration"<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:48.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">ConnectionAttemptFailedHook sub {my $self = shift;my $dbsource = shift;my $dbusername = shift;my $dbauth = shift;$self->log($main::LOG_ERR,
"Could not connect to SQL database with DBI->connect $dbsource, $dbusername, $dbauth: $@ $DBI::errstr");}
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> DBSource dbi:ODBC:ORADB<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> DBUsername user<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> DBAuth password<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> DateFormat %b %e, %Y %H:%M<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPAnonymous anonymous<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPContextTimeout 1000<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPFAST_PAC_Lifetime 7776000<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPFAST_PAC_Reprovision 2592000<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPTLS_MaxFragmentSize 2048<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPTLS_PEAPVersion 1<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPTLS_SessionResumption 1<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPTLS_SessionResumptionLimit 43200<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> EAPTLS_VerifyDepth 1<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> FailureBackoffTime 600<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> Identifier HUW_POOL<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in;text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> NoConnectionsHook sub { my $self = shift;$self->log($main::LOG_ERR, "Could not connect to any SQL database. Request
is ignored. Backing off for $self- >{FailureBackoffTime} seconds");}<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> NullPasswordMatchesAny 1<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> PasswordPrompt password<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> SIPDigestRealm DefaultSipRealm<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"> Timeout 60<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"></AuthBy><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">LOG:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Handling request with Handler 'Realm=/^(512|1024|2048)\.itc\.net\.sa$/'<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Deleting session for testhuawei@2048.itc.net.sa, 87.101.255.184, 33554442<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Handling with Radius::AuthSQL: HUW_POOL<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Handling with Radius::AuthSQL: HUW_POOL<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Query is: 'select PASSWORD, to_char(EXPIRATION, 'yyyy-mm-dd HH24:MI:SS') Expiration, MAXSESSIONS, EXPIRATION_D
"Huawei-Domain-Name" , Session_Timeout "Session-Timeout" from ITC_ACCOUNTS_H where upper(USERNAME)=upper('testhuawei@2048.itc.net.sa')':
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Radius::AuthSQL looks for match with testhuawei@2048.itc.net.sa [testhuawei@2048.itc.net.sa]<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Radius::AuthSQL ACCEPT: : testhuawei@2048.itc.net.sa [testhuawei@2048.itc.net.sa]<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Session-Timeout="until ValidTo" was specified, but there was no ValidTo or Expiration check item for
this user. Ignored.<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: AuthBy SQL result: ACCEPT,
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Access accepted for
<a href="mailto:testhuawei@2048.itc.net.sa">testhuawei@2048.itc.net.sa</a><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: ERR: There is no value named until Expiration for attribute Session-Timeout. Using 0.<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">Wed May 27 09:09:39 2015: DEBUG: Packet dump:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:windowtext">*** Sending to 87.101.255.184 port 1812 ....</span><o:p></o:p></p>
</div>
<p></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"> </p>
<table style="BORDER-BOTTOM-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none" cellspacing="0" cellpadding="0" face="Verdana" size="2" font="">
<tbody>
<tr>
<td><span style="font-family:Verdana; font-size:x-small; ">Mohammed Alhaj Ali</span></td>
</tr>
<tr>
<td><font size="1" face="Verdana">Integrated Telecom Co. Ltd.</font></td>
</tr>
<tr>
<td><font size="1" face="Verdana">Tel : +966(11) 406-2222 Ext.</font><span style="font-family:Verdana; font-size:xx-small; ">2384</span></td>
</tr>
<tr>
<td><font size="1" face="Verdana">Fax : +966(11) 406-2221</font></td>
</tr>
<tr>
<td><font size="1" face="Verdana">GSM : </font><span style="font-family:Verdana; font-size:xx-small; ">
</span></td>
</tr>
<tr>
<td><span style="font-family:Verdana; font-size:x-small; "><span style="font-family:Verdana; font-size:x-small; "><a href="mailto:m.alhaj@itc.sa" title="Click to send email to Mohammed Alhaj Ali" target=""><span style="font-family:Verdana; font-size:x-small; ">m.alhaj@itc.sa</span></a></span></span></td>
</tr>
</tbody>
</table>
<p class="2a79f525-1347-4057-825a-f202038eb911"></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"><font size="2" face="Verdana"></font></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"><font size="2" face="Verdana"></font></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"><font size="2" face="Verdana"></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"><font size="2" face="Verdana"></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"><a href="http://www.execloud.net"><img id="IMG1" border="0" src="cid:image69148d.JPG@167f63d9.4e8874a2" width="288" height="170"></a></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"><a href="http://www.itc.sa">www.itc.sa</a></p>
<p class="2a79f525-1347-4057-825a-f202038eb911"> </p>
<p class="2a79f525-1347-4057-825a-f202038eb911"></p>
</font>
<p></p>
</font>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
</body>
</html>