Hello, I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built from source. Everything is working nicely except one small issue. The CDR records are stored in the CSV file correctly and complete. The MySQL storage is working as it should and is automatically updating all the fields except the CLID field. I have compared and constructed and destructed the system 3 times since Thursday and I cannot figure out why the field does not get populated. If I run the import from csv script it correctly populates the CLID so I believe that tables are setup correct. Has any one seen this and could possibly point me at the offending conf file. I am more familiar than I want to be with cdr_xxxx.conf files and I cannot find where the problem is. I have browsed all the wiki's, blogs, and emails looking for a hint and I did not find anything. Anything would be appreciated. Thank you, Eric -- Eric W. Davenport Cert-In Software Systems, Inc. P.O. Box 346 Bakersville, NC 28705 800-873-0110 ewdavenport at certin.com www.certin.com
On Sunday 27 March 2011 19:36:45 Eric W. Davenport wrote:> Hello, > > I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and > libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built > from source. > > Everything is working nicely except one small issue. > > The CDR records are stored in the CSV file correctly and complete. > > The MySQL storage is working as it should and is automatically updating > all the fields except the CLID field. > > I have compared and constructed and destructed the system 3 times since > Thursday and I cannot figure out why the field does not get populated. > > If I run the import from csv script it correctly populates the CLID so I > believe that tables are setup correct. > > Has any one seen this and could possibly point me at the offending conf > file. > > I am more familiar than I want to be with cdr_xxxx.conf files and I > cannot find where the problem is. > > I have browsed all the wiki's, blogs, and emails looking for a hint and > I did not find anything. > > Anything would be appreciated.Do you have "alias callerid => clid" in your cdr_mysql.conf file (in the [columns] context)? -- Tilghman
Thanks Tilghman for your response. I have the following in my cdr_mysql.conf I put it in sometime yesterday and did not have it till then. However, it did not make any difference. [columns] static "<value>" => <column> alias <cdrvar> => <column> alias start => calldate alias callerid => clid alias src => src alias dst => dst alias dcontext => dcontext alias channel => channel alias dstchannel => dstchannel alias lastapp => lastapp alias lastdata => lastdata alias duration => duration alias billsec => billsec alias disposition => disposition alias amaflags => amaflags alias accountcode => accountcode alias userfield => userfield alias uniqueid => uniqueid Thanks again Eric -- Eric W. Davenport Cert-In Software Systems, Inc. P.O. Box 346 Bakersville, NC 28705 800-873-0110 ewdavenport at certin.com www.certin.com
On Monday 28 March 2011 07:57:10 Eric W. Davenport wrote:> Thanks Tilghman for your response. > > I have the following in my cdr_mysql.conf > > I put it in sometime yesterday and did not have it till then. > > However, it did not make any difference.Did you reload after making the change to the config file?> [columns] > static "<value>" => <column> > alias <cdrvar> => <column>These are bogus and should never have been uncommented.> alias start => calldate > alias callerid => clidThese are fine.> alias src => src > alias dst => dst > alias dcontext => dcontext > alias channel => channel > alias dstchannel => dstchannel > alias lastapp => lastapp > alias lastdata => lastdata > alias duration => duration > alias billsec => billsec > alias disposition => disposition > alias amaflags => amaflags > alias accountcode => accountcode > alias userfield => userfield > alias uniqueid => uniqueidThere is no reason to have any of these uncommented, unless the column specified after the arrow is different from the field specified before. -- Tilghman
Thanks again Tilghman OK now I am back to the original.> [columns] > ;static "<value>" => <column> commented now > ;alias<cdrvar> => <column> commented nowThese are bogus and should never have been uncommented. alias start => calldate uncommented now alias callerid => clid uncommented now Rest are all back to commented> ;alias src => src > ;alias dst => dst > ;alias dcontext => dcontext > ;alias channel => channel > ;alias dstchannel => dstchannel > ;alias lastapp => lastapp > ;alias lastdata => lastdata > ;alias duration => duration > ;alias billsec => billsec > ;alias disposition => disposition > ;alias amaflags => amaflags > ;alias accountcode => accountcode > ;alias userfield => userfield > ;alias uniqueid => uniqueidI restarted Asterisk and I still have all the fields outgoing and incoming except for the CLID field. Clid is populated in the CSV Simple file as well as the CSV Custom file. -- Tilghman -- Eric W. Davenport Cert-In Software Systems, Inc. P.O. Box 346 Bakersville, NC 28705 800-873-0110 ewdavenport at certin.com www.certin.com
On Tue, Mar 29, 2011 at 3:52 PM, Eric W. Davenport <ewdavenport at certin.com>wrote:> Hi Warren, > > Thanks for your help, > > I think this is what you want > >Please don't mail me (or anyone else) off the list directly without being specifically asked to. The idea is to keep things on the mailing list in order to help other people who may have the same issues. That being said... That information does indeed look like what I want and it appears to be setup correctly. I will be building a comparable test system later today (using all the same software versions as you) and I'll test to see if I get the same issue. If I do, I'll open a new bug on the issue tracker, and I'll post my results here on the list. -- Thanks, --Warren Selby, dCAP http://www.selbytech.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110329/6fea1448/attachment.htm>
bayardo.sanchez at gmail.com
2011-Mar-30 02:18 UTC
[asterisk-users] CDR MYSQL missing field data
I listened to your email using DriveCarefully and will respond as soon as I can. Download DriveCarefully for free at www.drivecarefully.com -- Sent from my BlackBerry? Senior Support Engineer US Numbers: 561-886-0664 Nicaragua Mobile: +505.8488.6876
Warren, Thank you Eric -- Eric W. Davenport Cert-In Software Systems, Inc. P.O. Box 346 Bakersville, NC 28705 800-873-0110 ewdavenport at certin.com www.certin.com
Good Morning, I agree I commented the lines and now everything works. Thanks for your quick work. Eric -- Eric W. Davenport Cert-In Software Systems, Inc. P.O. Box 346 Bakersville, NC 28705 800-873-0110 ewdavenport at certin.com www.certin.com