[SR-Users] Cant make from_uri, request_uri work for LCR module

[Antanas Masevicius]

Hello Juha,

it looks like column order a bit changed in my system after using alter table during migrations.
That is prefix col is not it its place. Thus this data:
(1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,'11#',1,NULL,NULL);
should be fixed as:
(1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,NULL,'11#',1,NULL);

Antanas
NTT

On 2012.07.26 12:12, Juha Heinanen wrote:
> Antanas Masevicius writes:
>
>> Here is my DB excerpt which i use to reproduce the problem:
>> INSERT INTO `lcr_rule` VALUES (2617960,90,'118','.*',1,1,'.*');
>> INSERT INTO `lcr_rule_target` VALUES (7771454,90,2617960,1424,0,100);
>> INSERT INTO `lcr_gw` VALUES
>> (1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,'11#',1,NULL,NULL);
> when i try the above, last insert gives:
>
> INSERT INTO `lcr_gw` VALUES
>      ->  (1424,90,'OP1','10.10.10.10','',5060,NULL,1,0,NULL,'11#',1,NULL,NULL);
> ERROR 1048 (23000): Column 'flags' cannot be null
>
> looks like you have made some mistake in above, because according to the
> schema, flags column cannot be null.
>
> -- juha
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users