RE: time format

Wed, 14 Aug 2002 11:01:17 -0700

Rodrigo,

 

Thanks for the quick reply, here is the output of the cisco AS5300,  I don’t see any AcctStartTime in the vsa, please enlight me.

 

        NAS-IP-Address = 203.150.198.248

        Cisco-NAS-Port = "ISDN 1:D:1"

        NAS-Port-Type = Async

        User-Name = "11000000024"

        Called-Station-Id = "6690920140"

        Calling-Station-Id = "11000000024"

        Acct-Status-Type = Stop

        Service-Type = Login-User

        h323-gw-id = "h323-gw-id=Thailand_GW01.cityabove.net"

        Cisco-AVPair = "h323-incoming-conf-id=47F779AF AEE711D6 B5B4AE9B 72B98C38"

        h323-call-origin = "h323-call-origin=originate"

        h323-call-type = "h323-call-type=Telephony"

        h323-setup-time = "h323-setup-time=02:05:44.584 CN Thu Aug 15 2002"

        h323-connect-time = "h323-connect-time=02:06:00.412 CN Thu Aug 15 2002"

        h323-disconnect-time = "h323-disconnect-time=02:06:00.412 CN Thu Aug 15 2002"

        h323-disconnect-cause = "h323-disconnect-cause=10"

        h323-voice-quality = "h323-voice-quality=0"

        h323-conf-id = "h323-conf-id=47F779AF AEE711D6 B5B4AE9B 72B98C38"

        Acct-Session-Id = "0003A7F2"

        Acct-Input-Octets = 424

        Acct-Output-Octets = 0

        Acct-Input-Packets = 11

        Acct-Output-Packets = 0

        Acct-Session-Time = 0

        Cisco-AVPair = "subscriber=Unknown"

        Cisco-AVPair = "tariff-type=Unknown"

        Cisco-AVPair = "pre-bytes-in=0"

        Cisco-AVPair = "pre-bytes-out=0"

        Cisco-AVPair = "pre-paks-in=0"

        Cisco-AVPair = "pre-paks-out=0"

        Cisco-AVPair = "nas-rx-speed=0"

        Cisco-AVPair = "nas-tx-speed=0"

        Acct-Delay-Time = 0

 

Raymond

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rodrigo Gonzalez
Sent: Thursday, August 15, 2002 2:15 AM
To: [EMAIL PROTECTED]
Subject: Re: time format

 

Use AcctStartTime NOT h323-setup-time

----- Original Message -----

From: Raymond Chen

Sent: Wednesday, August 14, 2002 3:10 PM

Subject: time format

 

Dear list,

 

Trying to setup the radius to write CDR straight to MySQL database.  But the time from NAS as “h323-setup-time=02:05:44.512 CN Thu Aug 15 2002”   and in the MySQL database script, the time is define as “0000-00-00 00:00:00”.  So when radius trys to insert to database, it returns an error say the format is incompatible.  Any solution to this.

 

Best Regards

 

Raymond

 

Reply via email to