Eric,
When I looked at my cdr.conf recently the comments referred to a plugin that
could be used w/ mysql. I have never logged CDR's to mysql so I don't know what
is involved with the plugin, or even if it is supported by astlinux. Sorry I
couldn't be of more help here.
tm
From: Eric Kowalewski [mailto:[email protected]]
Sent: Thursday, December 30, 2010 1:35 PM
To: 'AstLinux Users Mailing List'
Subject: Re: [Astlinux-users] CDR time
Tom,
Ok, I screwed up. I can confirm that this works:
[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"
However, my mysql logging stopped working back in October. It
could be due to the upgraded version of astlinux. I'm assuming I need an entry
in my cdr.conf like this:
[mysql]
;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"
Is that correct?
Thanks,
Eric
From: Tom Mazzotta [mailto:[email protected]]
Sent: Tuesday, December 28, 2010 9:23 PM
To: AstLinux Users Mailing List
Subject: Re: [Astlinux-users] CDR time
Eric,
I am in the same timezone (EST) and I am running 0.7.4 as well. My cdr.conf
contains the following:
[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"
If simply commenting out the "usegmtime" line doesn't do the trick, then the
problem may be involved with the add-in you are using for mysql (which I am not
using). Perhaps someone else on the list has other ideas?
tm
From: Eric Kowalewski [mailto:[email protected]]
Sent: Tuesday, December 28, 2010 9:09 PM
To: 'AstLinux Users Mailing List'
Subject: Re: [Astlinux-users] CDR time
Tom,
Yeah I tried that, but when I switch that to a "no". It stops
logging altogether.
Eric
From: Tom Mazzotta [mailto:[email protected]]
Sent: Tuesday, December 28, 2010 5:34 PM
To: AstLinux Users Mailing List
Subject: Re: [Astlinux-users] CDR time
Eric,
It's possible you are logging in GMT. I had a similar problem in the past, see:
http://www.mail-archive.com/[email protected]/msg03346.html
Basically, you need to disable GMT in cdr.conf. Hope this helps!
tm
From: Eric Kowalewski [mailto:[email protected]]
Sent: Tuesday, December 28, 2010 4:53 PM
To: 'AstLinux Users Mailing List'
Subject: [Astlinux-users] CDR time
Hello All,
I use astlinux-0.7.4 with mysql (on another machine) and
noticed that my CDR records are 5 hours fast. I made sure that astlinux was
set to the correct time zone (eastern for me). Here is my cdr_mysql.conf.
Pretty simple.
[global]
hostname=10.255.255.2
dbname=astlinux
password=*********
user=root
port=3306
sock=/tmp/mysql.sock
table=cdr
Any ideas?
Eric
________________________________
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 10.0.1191 / Virus Database: 1435/3344 - Release Date: 12/28/10
________________________________
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 10.0.1191 / Virus Database: 1435/3344 - Release Date: 12/28/10
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Astlinux-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/astlinux-users
Donations to support AstLinux are graciously accepted via PayPal to
[email protected].
