[OpenSIPS-Users] OpenSIPS-CP and cdrviewer

[Gavin Henry]

2009/6/13 ASHWINI NAIDU <ashwini.naidu at gmail.com>:
> You need to add column caller_id in CDRS table . Once that is added This
> error will not appear again

I just checked out trunk and cdrs.mysql doesn't have that column. Is
it supposed to be in the acc table, but ours has:

mysql> desc acc;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| method     | char(16)         | NO   |     |         |                |
| from_tag   | char(64)         | NO   |     |         |                |
| to_tag     | char(64)         | NO   |     |         |                |
| callid     | char(64)         | NO   | MUL |         |                |
| sip_code   | char(3)          | NO   |     |         |                |
| sip_reason | char(32)         | NO   |     |         |                |
| time       | datetime         | NO   |     | NULL    |                |
| cdr_id     | int(11)          | NO   |     | 0       |                |
| from_uri   | varchar(64)      | NO   |     | NULL    |                |
| to_uri     | varchar(64)      | NO   |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+
11 rows in set (0.03 sec)


Also in our svn checkout,

/usr/local/src/opensips_1_5/scripts/mysql# grep caller_id *

-- 
http://www.suretecsystems.com/services/openldap/
http://www.suretectelecom.com