search for: usegmtime

Hi! I have set usegmtime=yes in cdr.conf, but unfortunately this is only for cdr-csv, not for cdr-custom. AFAIS there is no such option for cdr_custom.conf. Is there any workaround to get GMT timestamps in cdr-custom too? thanks klaus

Hi list, I am using Asterisk1.6.2 form a long time and upgarding to Asterisk-1.8.23.1. I am using mysql backend for cdr. in asterisk-1.6.2 i have usegmtime=yes and it works as expected insert cdr date in GMT0. now i tested Asterisk-1.8.23.1 and asterisk-11.5 with same results no matter what i configure in cdr_mysql.conf "timezone=UTC usegmtime=yes" cdr always inserted in local time. I dig into code of cdr_mysql.c and find a variable cdrzone...

...nd can access these (the db manager shows that this session is connected) cdr.conf ========== [general] enable=yes cdr_odbc.conf ========== [general] dsn=mydsn username=myuser password=mypassword loguniqueid=yes dispositionstring=yes table=PUB.cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT I must be missing something really really obvious here and would appreciate any help Julian

...dQueueMember','test,Local/1000 at sip,5,,Agent/1000,Local/1000 at sip',9,9,'ANSWERED',3,'1235681438.1') a16-q1:/etc/asterisk# cat cdr.conf [general] enable=yes ;unanswered = no ;batch=no ;size=100 ;time=300 ;scheduleronly=no ;safeshutdown=yes ;endbeforehexten=no [csv] usegmtime=yes ; log date/time in GMT. Default is "no" loguniqueid=yes ; log uniqueid. Default is "no" loguserfield=yes ; log user field. Default is "no" [odbc] usegmtime=yes ; log date/time in GMT. Default is "no" loguniqueid=yes ; log uniqueid. Default i...

...can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=******* ;loguniqueid=yes ;dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=yes ; set to "yes" to log in GMT What am I doing wrong please ? Best Regards, -- SplatNIX IT Services :: Innovation through collaboration

...=> asterisk username => asterisk password => exodus_2009 pre-connect => yes /etc/asterisk/cdr_odbc.conf: ; cdr_odbc.conf ; [global] dsn=asterisk username=asterisk password=exodus_2009 loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT ---------------------------------------------------------------------------------------------------------- Any ideas?

; ; cdr_odbc.conf ; ;[global] ;dsn=MySQL-test ;username=username ;password=password ;loguniqueid=yes ;dispositionstring=yes ;table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT Though, reading from https://issues.asterisk.org/view.php?id=15021, it seems that lines username= and password= in cdr_odbc.conf are not used anymore (the fields in res_odbc.conf are used instead). My question are : 1. Are those lines still u...

Hi, I have configured the cdr throught ODBC with this files: /etc/cdr_odbc.conf [global] dsn=asterisk2 ;loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields /etc/cdr.conf [general] enable=yes unanswered = yes /etc/res_odbc.conf [asterisk] enabled => yes dsn => asterisk-connector pre-connect => yes [aster...

...adius cdr support. Asterisk version 1.6.2.13 Server Radius: Freeradius version 1.X Radius client: radiusclient-ng version 0.5.5 With the Asterisk core debug on 1 when a call terminate, on the console appear this error: Unable to create RADIUS record. CDR not recorded! My cdr.conf is: [radius] usegmtime=yes ; log date/time in GMT loguniqueid=yes ; log uniqueid loguserfield=yes ; log user field radiuscfg=/etc/radiusclient-ng/radiusclient.conf When I load the cdr_radius module no error appear. Any suggestion? Regards - Andrea

I am using the new 1.8.5 and I just found out that Asterisk won't record the call if the call just hangup. I did a test like this: exten => 1009, 1, Hangup() Then I called 1009: == Using UDPTL CoS mark 5 == Using SIP RTP CoS mark 5 -- Executing [1009 at init-1005:1] Hangup("SIP/1007-0000003c", "") in new stack == Spawn extension (init-1005, 1009, 1)

Hi to all, I actually have an asterisk server configured to write CDR mysql records in the same machine (localhost), but I want to write this records to another machine also in mysql at the same time, It is possible? It means that I want save the records in both machines. Thanks in advance. Ricardo Melendez -------------- next part -------------- An HTML attachment was scrubbed... URL:

...-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no loguniqueid=yes loguserfield=yes accountlogs=yes I created the table in the DB so: CREATE TABLE IF NOT EXISTS `cdr` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT ...

...------------- Name: asterisk DSN: asterisk-connector Last connection attempt: 2014-01-11 18:16:40 Pooled: Yes Limit: 1000 Connections in use: 0 -------------- /etc/asterisk/cdr.conf lists below: [general] enable=yes unanswered = yes congestion = yes endbeforehexten=yes [csv] usegmtime=no ; log date/time in GMT. Default is "no" loguniqueid=yes ; log uniqueid. Default is "no" loguserfield=yes ; log user field. Default is "no" accountlogs=yes ; create separate log file for each account code. Default is "yes" -------------- /etc/odbc....

...gured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my cdr.conf so: > > [general] > enable=yes > unanswered = yes > safeshutdown=yes > > [mysql] > usegmtime=no > loguniqueid=yes > loguserfield=yes > accountlogs=yes > > I created the table in the DB so: > > CREATE TABLE IF NOT EXISTS `cdr` ( > `id` int(11) unsigned NOT NULL AUTO_INCREMENT, > `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', > `cli...

...ast_tellstream. (Closes issue #15224. Reported, tested by rbd. Patched, tested by seanbright.) * Update MySQL driver to always return NULL columns, as this is needed for the realtime API to work correctly. (Closes issue #16138. Reported, tested by sohosys. Patched by tilghman.) * Restore usegmtime option in cdr_mysql. (Closes issue #16401. Reported, patched by lordmortis.) * Fix random DTMF duplicate emulation on bridged chan_ooh323 channels. (Closes issue #16664. Reported, tested by vmikhelson. Patched by may213.) * Respond to requests by Avaya IPOffice 403 to stop call drops. (C...

...0 scheduleronly=no endbeforehexten=no safeshutdown=yes cdr_manager.conf [general] enabled=yes cdr_odbc.conf [global] dsn=asterisk username=user password=password loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT loaded files cdr_manager.so cdr_odbc.so cdr_csv.so ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems?...

We have just implemented cdr-custom. Works fine minus the timestamps that appear in the CDR. The system's timezone is GMT. In the configuration usegmtime=yes is set. However, all of the CDRs in the Custom CDR comes as GMT-5. Another oddity is that the standard cdr/Master.csv is using GMT. Please advise. Thanks, kw -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/...

...ast_tellstream. (Closes issue #15224. Reported, tested by rbd. Patched, tested by seanbright.) * Update MySQL driver to always return NULL columns, as this is needed for the realtime API to work correctly. (Closes issue #16138. Reported, tested by sohosys. Patched by tilghman.) * Restore usegmtime option in cdr_mysql. (Closes issue #16401. Reported, patched by lordmortis.) * Fix random DTMF duplicate emulation on bridged chan_ooh323 channels. (Closes issue #16664. Reported, tested by vmikhelson. Patched by may213.) * Respond to requests by Avaya IPOffice 403 to stop call drops. (C...

Hello,

Hi. i am running asterisk 11.5.1 in my system (debian squeeze) and i do get the CDRs through the csv file, that asterisk creates. i would like to have the CDRs in a nice web based tool and after some search i have found http://acdr.com.au/ i do have it installed with all the dependencies (apache, php, mysql), but i do not know how to interface the CDRs. has anyone used this tool or any other