0 like 0 dislike
88 views
It would appear that the "uniqueid" field is not being populated in the MySQL CDR DB. Is this an obsolete field or is a bug?
asked Apr 9, 2014 in Education & Reference by Yogi (180 points)
retagged Apr 9, 2014 | 88 views
    

1 Answer

0 like 0 dislike

You need to define MYSQL_LOGUNIQUEID at compile time for it to use that field.

You have two options in /usr/src/asterisk-addons:
1. Either add CFLAGS+=-DMYSQL_LOGUNIQUEID to the Makefile.
Note that recently (around Asterisk 1.4.18 or before) this has changed to ASTCFLAGS+=-DMYSQL_LOGUNIQUEID
2. Or instead add a #define MYSQL_LOGUNIQUEID to the top of cdr_addon_mysql.c.

Finally perform the usual make clean, make, make install. Be sure to check the Makefile for the presence of this flag after having done a CVS update! You 

will most probably also want to index the uniqueid field in your cdr table to improve performance.

You will also have to add a `uniqueid` column in your mysql database after the `accountcode` column:

ALTER TABLE `bit_cdr` ADD `uniqueid` VARCHAR(32) NOT NULL default ''

after `accountcode`;

answered Apr 9, 2014 by Veena

Related questions

1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
asked Jan 21, 2016 in Education & Reference by Sam (1,370 points) | 96 views
0 like 0 dislike
1 answer
1 like 0 dislike
2 answers
0 like 0 dislike
2 answers
asked May 27, 2014 in Education & Reference by Yogi (180 points) | 90 views
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

Mathe Forum Schule und Studenten
1,171 questions
1,311 answers
276 comments
1,602 users