OpenSIPS-CP and cdrviewer

classic Classic list List threaded Threaded
14 messages Options
Reply | Threaded
Open this post in threaded view
|

OpenSIPS-CP and cdrviewer

Gavin Henry
Hi,


Can anyoen help debug the stored procedure for the cdrs table?

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     | varchar(32)      | YES  |     | NULL    |                |
| from_uri   | varchar(64)      | NO   |     | NULL    |                |
| to_uri     | varchar(64)      | NO   |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

mysql> desc cdrs;
+-----------------+------------------+------+-----+---------------------+----------------+
| Field           | Type             | Null | Key | Default
 | Extra          |
+-----------------+------------------+------+-----+---------------------+----------------+
| cdr_id          | bigint(20)       | NO   | PRI | NULL
 | auto_increment |
| call_start_time | datetime         | NO   |     | 0000-00-00
00:00:00 |                |
| duration        | int(10) unsigned | NO   |     | 0
 |                |
| sip_call_id     | varchar(128)     | NO   |     |
 |                |
| sip_from_tag    | varchar(128)     | NO   |     |
 |                |
| sip_to_tag      | varchar(128)     | NO   |     |
 |                |
| created         | datetime         | NO   |     | 0000-00-00
00:00:00 |                |
+-----------------+------------------+------+-----+---------------------+----------------+
7 rows in set (0.00 sec)

We are using the
/var/www/opensips-cp/web/tools/cdrviewer/opensips_cdrs_1_5.sql from
version 2.0 which has:

USE opensips ;
DROP PROCEDURE IF EXISTS `opensips_cdrs_1_5` ;
DELIMITER //
CREATE PROCEDURE opensips_cdrs_1_5()
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE bye_record INT DEFAULT 0;
  DECLARE v_callid,v_from_tag, v_to_tag VARCHAR(64);
  DECLARE v_inv_time, v_bye_time DATETIME;
  DECLARE inv_cursor CURSOR FOR SELECT time, callid, from_tag, to_tag
FROM opensips.acc where method='INVITE' and cdr_id='0';
  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
  OPEN inv_cursor;
  REPEAT
    FETCH inv_cursor INTO v_inv_time, v_callid, v_from_tag, v_to_tag;
    IF NOT done THEN
      SET bye_record = 0;
      SELECT 1, time INTO bye_record, v_bye_time FROM opensips.acc
WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND
to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER
BY time ASC LIMIT 1;
      IF bye_record = 1 THEN
        INSERT INTO cdrs
(call_start_time,duration,sip_call_id,sip_from_tag,sip_to_tag,created)
VALUES (v_inv_time,UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time),v_callid,v_from_tag,v_to_tag,NOW());
        UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid
AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag
AND to_tag=v_from_tag));
      END IF;
      SET done = 0;
    END IF;
  UNTIL done END REPEAT;
END
//
DELIMITER ;


There is data with BYE and INVITE in our acc table.

Thanks.

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Iulia Bublea-2
Hi,

Try changing the type of cdr_id field from varchar to int(11) not null
default 0


Regards,
Iulia

Gavin Henry wrote:

> Hi,
>
>
> Can anyoen help debug the stored procedure for the cdrs table?
>
> 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     | varchar(32)      | YES  |     | NULL    |                |
> | from_uri   | varchar(64)      | NO   |     | NULL    |                |
> | to_uri     | varchar(64)      | NO   |     | NULL    |                |
> +------------+------------------+------+-----+---------+----------------+
> 11 rows in set (0.00 sec)
>
> mysql> desc cdrs;
> +-----------------+------------------+------+-----+---------------------+----------------+
> | Field           | Type             | Null | Key | Default
>  | Extra          |
> +-----------------+------------------+------+-----+---------------------+----------------+
> | cdr_id          | bigint(20)       | NO   | PRI | NULL
>  | auto_increment |
> | call_start_time | datetime         | NO   |     | 0000-00-00
> 00:00:00 |                |
> | duration        | int(10) unsigned | NO   |     | 0
>  |                |
> | sip_call_id     | varchar(128)     | NO   |     |
>  |                |
> | sip_from_tag    | varchar(128)     | NO   |     |
>  |                |
> | sip_to_tag      | varchar(128)     | NO   |     |
>  |                |
> | created         | datetime         | NO   |     | 0000-00-00
> 00:00:00 |                |
> +-----------------+------------------+------+-----+---------------------+----------------+
> 7 rows in set (0.00 sec)
>
> We are using the
> /var/www/opensips-cp/web/tools/cdrviewer/opensips_cdrs_1_5.sql from
> version 2.0 which has:
>
> USE opensips ;
> DROP PROCEDURE IF EXISTS `opensips_cdrs_1_5` ;
> DELIMITER //
> CREATE PROCEDURE opensips_cdrs_1_5()
> BEGIN
>   DECLARE done INT DEFAULT 0;
>   DECLARE bye_record INT DEFAULT 0;
>   DECLARE v_callid,v_from_tag, v_to_tag VARCHAR(64);
>   DECLARE v_inv_time, v_bye_time DATETIME;
>   DECLARE inv_cursor CURSOR FOR SELECT time, callid, from_tag, to_tag
> FROM opensips.acc where method='INVITE' and cdr_id='0';
>   DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
>   OPEN inv_cursor;
>   REPEAT
>     FETCH inv_cursor INTO v_inv_time, v_callid, v_from_tag, v_to_tag;
>     IF NOT done THEN
>       SET bye_record = 0;
>       SELECT 1, time INTO bye_record, v_bye_time FROM opensips.acc
> WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND
> to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER
> BY time ASC LIMIT 1;
>       IF bye_record = 1 THEN
>         INSERT INTO cdrs
> (call_start_time,duration,sip_call_id,sip_from_tag,sip_to_tag,created)
> VALUES (v_inv_time,UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time),v_callid,v_from_tag,v_to_tag,NOW());
>         UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid
> AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag
> AND to_tag=v_from_tag));
>       END IF;
>       SET done = 0;
>     END IF;
>   UNTIL done END REPEAT;
> END
> //
> DELIMITER ;
>
>
> There is data with BYE and INVITE in our acc table.
>
> Thanks.
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Iulia Bublea-2
In reply to this post by Gavin Henry
Have you changed in the porcedure the name of the database to the db you
are using?

It appears in 3 places "opensips"...change that to your db.

Regards,
Iulia

Gavin Henry wrote:

> Hi,
>
>
> Can anyoen help debug the stored procedure for the cdrs table?
>
> 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     | varchar(32)      | YES  |     | NULL    |                |
> | from_uri   | varchar(64)      | NO   |     | NULL    |                |
> | to_uri     | varchar(64)      | NO   |     | NULL    |                |
> +------------+------------------+------+-----+---------+----------------+
> 11 rows in set (0.00 sec)
>
> mysql> desc cdrs;
> +-----------------+------------------+------+-----+---------------------+----------------+
> | Field           | Type             | Null | Key | Default
>  | Extra          |
> +-----------------+------------------+------+-----+---------------------+----------------+
> | cdr_id          | bigint(20)       | NO   | PRI | NULL
>  | auto_increment |
> | call_start_time | datetime         | NO   |     | 0000-00-00
> 00:00:00 |                |
> | duration        | int(10) unsigned | NO   |     | 0
>  |                |
> | sip_call_id     | varchar(128)     | NO   |     |
>  |                |
> | sip_from_tag    | varchar(128)     | NO   |     |
>  |                |
> | sip_to_tag      | varchar(128)     | NO   |     |
>  |                |
> | created         | datetime         | NO   |     | 0000-00-00
> 00:00:00 |                |
> +-----------------+------------------+------+-----+---------------------+----------------+
> 7 rows in set (0.00 sec)
>
> We are using the
> /var/www/opensips-cp/web/tools/cdrviewer/opensips_cdrs_1_5.sql from
> version 2.0 which has:
>
> USE opensips ;
> DROP PROCEDURE IF EXISTS `opensips_cdrs_1_5` ;
> DELIMITER //
> CREATE PROCEDURE opensips_cdrs_1_5()
> BEGIN
>   DECLARE done INT DEFAULT 0;
>   DECLARE bye_record INT DEFAULT 0;
>   DECLARE v_callid,v_from_tag, v_to_tag VARCHAR(64);
>   DECLARE v_inv_time, v_bye_time DATETIME;
>   DECLARE inv_cursor CURSOR FOR SELECT time, callid, from_tag, to_tag
> FROM opensips.acc where method='INVITE' and cdr_id='0';
>   DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
>   OPEN inv_cursor;
>   REPEAT
>     FETCH inv_cursor INTO v_inv_time, v_callid, v_from_tag, v_to_tag;
>     IF NOT done THEN
>       SET bye_record = 0;
>       SELECT 1, time INTO bye_record, v_bye_time FROM opensips.acc
> WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND
> to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER
> BY time ASC LIMIT 1;
>       IF bye_record = 1 THEN
>         INSERT INTO cdrs
> (call_start_time,duration,sip_call_id,sip_from_tag,sip_to_tag,created)
> VALUES (v_inv_time,UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time),v_callid,v_from_tag,v_to_tag,NOW());
>         UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid
> AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag
> AND to_tag=v_from_tag));
>       END IF;
>       SET done = 0;
>     END IF;
>   UNTIL done END REPEAT;
> END
> //
> DELIMITER ;
>
>
> There is data with BYE and INVITE in our acc table.
>
> Thanks.
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
In reply to this post by Iulia Bublea-2
2009/6/11 Iulia Bublea <[hidden email]>:
> Hi,
>
> Try changing the type of cdr_id field from varchar to int(11) not null
> default 0

That fixed it, thanks.

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
2009/6/11 Gavin Henry <[hidden email]>:
> 2009/6/11 Iulia Bublea <[hidden email]>:
>> Hi,
>>
>> Try changing the type of cdr_id field from varchar to int(11) not null
>> default 0
>
> That fixed it, thanks.
>

Not needed, thanks.

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
In reply to this post by Gavin Henry
2009/6/11 Gavin Henry <[hidden email]>:
> 2009/6/11 Iulia Bublea <[hidden email]>:
>> Hi,
>>
>> Try changing the type of cdr_id field from varchar to int(11) not null
>> default 0
>
> That fixed it, thanks.
>


It is strange though, because caller and callee are unpopulated:

mysql> select * from cdrs;
+---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
| cdr_id  | call_start_time     | duration | sip_call_id
                    | sip_from_tag                         |
sip_to_tag | created             |
+---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
| 1332978 | 2009-06-11 21:07:56 |       17 |
7af42d34-3155-de11-943e-001d09097b69@suretec |
06632e34-3155-de11-943e-001d09097b69 | as52287ce0 | 2009-06-11
21:08:56 |
+---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
2009/6/11 Gavin Henry <[hidden email]>:

> 2009/6/11 Gavin Henry <[hidden email]>:
>> 2009/6/11 Iulia Bublea <[hidden email]>:
>>> Hi,
>>>
>>> Try changing the type of cdr_id field from varchar to int(11) not null
>>> default 0
>>
>> That fixed it, thanks.
>>
>
>
> It is strange though, because caller and callee are unpopulated:
>
> mysql> select * from cdrs;
> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
> | cdr_id  | call_start_time     | duration | sip_call_id
>                    | sip_from_tag                         |
> sip_to_tag | created             |
> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
> | 1332978 | 2009-06-11 21:07:56 |       17 |
> 7af42d34-3155-de11-943e-001d09097b69@suretec |
> 06632e34-3155-de11-943e-001d09097b69 | as52287ce0 | 2009-06-11
> 21:08:56 |
> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
>

I mean in the CP gui, not the above table.

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Iulia Bublea-2
Hi,

I added the caller and callee fields into the stored procedure, for
mysql. It is fixed in the trunk and also on branch 2.0.


Regards,
Iulia

Gavin Henry wrote:

> 2009/6/11 Gavin Henry <[hidden email]>:
>  
>> 2009/6/11 Gavin Henry <[hidden email]>:
>>    
>>> 2009/6/11 Iulia Bublea <[hidden email]>:
>>>      
>>>> Hi,
>>>>
>>>> Try changing the type of cdr_id field from varchar to int(11) not null
>>>> default 0
>>>>        
>>> That fixed it, thanks.
>>>
>>>      
>> It is strange though, because caller and callee are unpopulated:
>>
>> mysql> select * from cdrs;
>> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
>> | cdr_id  | call_start_time     | duration | sip_call_id
>>                    | sip_from_tag                         |
>> sip_to_tag | created             |
>> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
>> | 1332978 | 2009-06-11 21:07:56 |       17 |
>> 7af42d34-3155-de11-943e-001d09097b69@suretec |
>> 06632e34-3155-de11-943e-001d09097b69 | as52287ce0 | 2009-06-11
>> 21:08:56 |
>> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
>>
>>    
>
> I mean in the CP gui, not the above table.
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
Thanks, will test.

On 12/06/2009, Iulia Bublea <[hidden email]> wrote:

> Hi,
>
> I added the caller and callee fields into the stored procedure, for
> mysql. It is fixed in the trunk and also on branch 2.0.
>
>
> Regards,
> Iulia
>
> Gavin Henry wrote:
>> 2009/6/11 Gavin Henry <[hidden email]>:
>>
>>> 2009/6/11 Gavin Henry <[hidden email]>:
>>>
>>>> 2009/6/11 Iulia Bublea <[hidden email]>:
>>>>
>>>>> Hi,
>>>>>
>>>>> Try changing the type of cdr_id field from varchar to int(11) not null
>>>>> default 0
>>>>>
>>>> That fixed it, thanks.
>>>>
>>>>
>>> It is strange though, because caller and callee are unpopulated:
>>>
>>> mysql> select * from cdrs;
>>> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
>>> | cdr_id  | call_start_time     | duration | sip_call_id
>>>                    | sip_from_tag                         |
>>> sip_to_tag | created             |
>>> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
>>> | 1332978 | 2009-06-11 21:07:56 |       17 |
>>> 7af42d34-3155-de11-943e-001d09097b69@suretec |
>>> 06632e34-3155-de11-943e-001d09097b69 | as52287ce0 | 2009-06-11
>>> 21:08:56 |
>>> +---------+---------------------+----------+-----------------------------------------------+--------------------------------------+------------+---------------------+
>>>
>>>
>>
>> I mean in the CP gui, not the above table.
>>
>>
>
>

--
Sent from my mobile device

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

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
mysql> call opensips_cdrs_1_6();
ERROR 1054 (42S22): Unknown column 'caller_id' in 'field list'

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

ASHWINI NAIDU
You need to add column caller_id in CDRS table . Once that is added This error will not appear again



On Sat, Jun 13, 2009 at 2:38 PM, Gavin Henry <[hidden email]> wrote:
mysql> call opensips_cdrs_1_6();
ERROR 1054 (42S22): Unknown column 'caller_id' in 'field list'

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



--
Thanking You,
Ashwini BR Naidu

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
2009/6/13 ASHWINI NAIDU <[hidden email]>:
> You need to add column caller_id in CDRS table . Once that is added This
> error will not appear again

OK thanks, maybe the schema was updated and I never ran it.

Will test.

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Gavin Henry
In reply to this post by ASHWINI NAIDU
2009/6/13 ASHWINI NAIDU <[hidden email]>:
> 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

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: OpenSIPS-CP and cdrviewer

Iulia Bublea-2
In reply to this post by Gavin Henry
Hi,

I have asked around and the caller_id and callee_id fields should not be
in the cdrs table. On svn I placed the stored procedure with the old
structure.

Regards,
Iulia

Gavin Henry wrote:
> mysql> call opensips_cdrs_1_6();
> ERROR 1054 (42S22): Unknown column 'caller_id' in 'field list'
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users