With that attribute commented out, when I try start freeradius, i have this error:
including dictionary file /etc/freeradius/dictionary Errors reading dictionary: dict_init: /etc/freeradius/dictionary.opensips[93]: dict_addattr: Duplicate attribute name Event-Timestamp Willian Mazzardo Depto TI - SYSSVOIP www.syssvoip.com.br 55 3537 2030 2013/3/25 Willian Mazzardo - SYSSVOIP <[email protected]> > Damn it!! > > #ATTRIBUTE Event-Timestamp 230 string > > Its commented !! > > I will try comment this out and make a test. > > > > > Willian Mazzardo > Depto TI - SYSSVOIP > www.syssvoip.com.br > 55 3537 2030 > > > 2013/3/25 Tijmen de Mes <[email protected]> > >> Hi, >> >> Please check if the following is present in the OpenSIPS dictionary: >> >> ### Attributes added by AG Projects ### >> ATTRIBUTE Source-IP 214 string >> ATTRIBUTE Source-Port 215 string >> ATTRIBUTE Canonical-URI 216 string >> ATTRIBUTE Delay-Time 217 string >> ATTRIBUTE Divert-Reason 219 string >> ATTRIBUTE X-RTP-Stat 220 string >> ATTRIBUTE From-Header 221 string >> ATTRIBUTE User-Agent 222 string >> ATTRIBUTE Contact 223 string >> ATTRIBUTE Event 224 string >> ATTRIBUTE Event-Timestamp 230 integer >> ATTRIBUTE SIP-Proxy-IP 231 string >> ATTRIBUTE ENUM-TLD 232 string >> >> >> Best regards, >> >> -- >> Tijmen de Mes >> AG Projects >> >> On 03/25/2013 02:26 PM, Willian Mazzardo - SYSSVOIP wrote: >> >> Hi .. >> >> about date/time issue, what can I do to test? because the %S is >> "working" and give me the right duration time of a call. >> >> My freeradius is FreeRADIUS Version 2.1.10, for host >> x86_64-pc-linux-gnu, built on Jan 7 2013 at 17:11:42 >> >> the dictionaries loaded are: >> >> $INCLUDE /usr/share/freeradius/dictionary >> >> # OpenSER dictionary >> $INCLUDE /etc/freeradius/dictionary.opensips >> >> # MediaProxy dictionary >> $INCLUDE /etc/freeradius/dictionary.mediaproxy >> >> >> >> >> Willian Mazzardo >> Depto TI - SYSSVOIP >> www.syssvoip.com.br >> 55 3537 2030 >> >> >> 2013/3/25 Tijmen de Mes <[email protected]> >> >>> Hi, >>> >>> As I said the event-timestamp should be a 'timestamp', not at date. If >>> it is a date, from_unixtime will not work. If the timestamp is datetime, >>> like in your case, the FROM_UNIXTIME conversions are not needed. The >>> question is, why is the timestamp a datetime? >>> >>> If you use %S it will take the date/time from the sql server. Please be >>> aware that this is not the start/stop date of the request. >>> >>> Which radius version are you running? Are you sure the right >>> dictionaries are loaded? If you specify the application type manually it >>> will be always audio. In SIP more types are possible, like message. >>> >>> >>> Best regards, >>> >>> -- >>> Tijmen de Mes >>> AG Projects >>> >>> >>> On 03/25/2013 12:52 PM, Willian Mazzardo - SYSSVOIP wrote: >>> >>> Hi ... it was like this ... but the date what the script was getting >>> "2013-04-24 00:33 BRT blablabla" and this is wrong ... >>> >>> Yesterday I tried another sql.conf from other CDRTool version I had in >>> my server, wich is: >>> >>> accounting_start_query = "\ >>> CALL insert_radacct_record( \ >>> 'radius', \ >>> '%{Acct-Session-Id}', \ >>> '%{Acct-Unique-Session-Id}', \ >>> '%{Billing-Party}', \ >>> '%{Billing-Party}', \ >>> '%{SIP-Proxy-IP}', \ >>> '%{NAS-Port}', \ >>> * '%S', \* >>> '0', \ >>> '0', \ >>> '0', \ >>> '0', \ >>> '%{Called-Station-Id}', \ >>> '%{Calling-Station-Id}', \ >>> '%{Sip-Response-Code}', \ >>> '%{Service-Type}', \ >>> '%{ENUM-TLD}', \ >>> '%{Framed-IP-Address}', \ >>> '%{Acct-Delay-Time}', \ >>> '0', \ >>> '%{Sip-Response-Code}', \ >>> '%{Sip-Method}', \ >>> '%{Sip-Translated-Request-URI}', \ >>> '%{Sip-To-Tag}', \ >>> '%{Sip-From-Tag}', \ >>> '%{Sip-RPId}', \ >>> '%{Source-IP}', \ >>> '%{Source-Port}', \ >>> '%{Canonical-URI}', \ >>> '', \ >>> '', \ >>> 'audio', \ >>> '%{User-Agent}', \ >>> '%{From-Header}' \ >>> )" >>> >>> accounting_stop_query = "\ >>> CALL update_radacct_record( \ >>> 'radius', \ >>> * '%S', \* >>> '%{Acct-Delay-Time}', \ >>> '%{Connect-Info}', \ >>> '%{X-RTP-Stat}', \ >>> '%{Acct-Session-Id}', \ >>> '%{Sip-To-Tag}', \ >>> '%{Sip-From-Tag}' \ >>> )" >>> >>> accounting_update_query = "\ >>> CALL update_raddact_record_mediaproxy( \ >>> 'radius', \ >>> '%{Acct-Session-Time}', \ >>> '%{Acct-Input-Octets}', \ >>> '%{Acct-Output-Octets}', \ >>> '%{Sip-User-Agents}', \ >>> '%{Media-Codecs}', \ >>> '%{Sip-Application-Type}', \ >>> '%{Media-Info}', \ >>> '0', \ >>> '%{Acct-Session-Id}', \ >>> '%{Sip-To-Tag}', \ >>> '%{Sip-From-Tag}' \ >>> )" >>> >>> accounting_failed_query = "\ >>> CALL insert_radacct_record( \ >>> 'radius', \ >>> '%{Acct-Session-Id}', \ >>> '%{Acct-Unique-Session-Id}', \ >>> '%{Billing-Party}', \ >>> '%{Billing-Party}', \ >>> '%{SIP-Proxy-IP}', \ >>> '%{NAS-Port}', \ >>> * '%S', \* >>> * '%S', \* >>> '0', \ >>> '0', \ >>> '0', \ >>> '%{Called-Station-Id}', \ >>> '%{Calling-Station-Id}', \ >>> '%{Sip-Response-Code}', \ >>> '%{Service-Type}', \ >>> '%{ENUM-TLD}', \ >>> '%{Framed-IP-Address}', \ >>> '%{Acct-Delay-Time}', \ >>> '0', \ >>> '%{Sip-Response-Code}', \ >>> '%{Sip-Method}', \ >>> '%{Sip-Translated-Request-URI}', \ >>> MD5(RAND()), \ >>> '%{Sip-From-Tag}', \ >>> '%{Sip-RPId}', \ >>> '%{Source-IP}', \ >>> '%{Source-Port}', \ >>> '%{Canonical-URI}', \ >>> '', \ >>> '', \ >>> 'audio', \ >>> '%{User-Agent}', \ >>> '%{From-Header}' \ >>> )" >>> } >>> >>> See the field wich have DATE-TIME, in this sql.conf file, have only >>> '%S', where the original sql.conf file has >>> FROM_UNIXTIME(%{Event-Timestamp}), \ >>> FROM_UNIXTIME(%{Event-Timestamp}), \ >>> >>> In field ${Sip-Application-Type}, I had to put "audio" manually to >>> work too ... >>> >>> Now CDRTool is working good, getting Date-Time correctly. >>> >>> >>> Willian Mazzardo >>> Depto TI - SYSSVOIP >>> www.syssvoip.com.br >>> 55 3537 2030 <55%203537%202030> >>> >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> >> >> >> _______________________________________________ >> Users mailing >> [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
