[SR-Users] Migrating from OpenSER config file question.

Daniel-Constantin Mierla miconda at gmail.com
Fri Oct 7 09:23:22 CEST 2016 

Hello,


On 06/10/16 19:30, Brian McCrary wrote:
> Hello,
>
> No, I did not have the pv module loaded!  I loaded that module and all 
> is well.  I didn't know I needed it.  I ran into a few other small 
> errors that I was able to easily fix so I now have a good config file 
> and am ready to start importing the old database in.  Thanks for your 
> help!!

good it was sorted out.

For reference, there are some migration/upgrade notes in the wiki for
each major version:

  - http://www.kamailio.org/dokuwiki/doku.php#setup
  - https://www.kamailio.org/wiki/#upgrade

Cheers,
Daniel

>
> Brian
>
>
> On Thu, Oct 06, 2016 at 11:11:02AM +0200, Daniel-Constantin Mierla wrote:
>> Hello,
>>
>> I just tested with:
>>
>> $avp(s:callfwd) = $ruri;
>>
>> using kamailio.cfg from master branch and all is ok.
>>
>> Have you loaded the pv module?
>>
>> Cheers,
>> Daniel
>>
>> On 06/10/16 00:56, Brian McCrary wrote:
>>> Hello,
>>>
>>> Thanks so much for the help in pointing me in the right direction.  I 
>>> finally had some time today to work with Kamailio a little.  I should 
>>> have pointed out I had commented the avp_write line out in the config 
>>> file and had attempted to convert it to the new format as you had 
>>> suggested.  I had $avp(s:callfwd) = $ruri; instead of $avp(callfwd) = 
>>> $ruri; but it seems both give the same error.
>>>
>>> With that being said, thanks for pointing out the sqlops module.  It 
>>> looks like I should be able to make it do everything I need, and then 
>>> some.  There are some things I have been wanting to improve upon and it 
>>> looks like this will certainly help.  There has been a lot of really 
>>> nice things added to these new releases!  I'm going to give that a go 
>>> and see if I can fix the error by eliminating the problem altogether. :)
>>>
>>> Thanks,
>>>
>>> Brian
>>>
>>> On Mon, Oct 03, 2016 at 09:00:24PM +0200, Daniel-Constantin Mierla wrote:
>>>> Hello,
>>>>
>>>> hmm, the format $avp(s:callfwd) should still work fine. I will look
>>>> deeper at it when I get a chance after returning to the office in few
>>>> days. Anyhow, try to use $avp(callfwd), it is the same as $avp(callfwd)
>>>> if you haven't defined an overlapping avp-alias.
>>>>
>>>> On the other hand, I think avp_write(...) is no longer available. Now
>>>> you can use direct assignment, like:
>>>>
>>>> $avp(callfwd) = $ruri;
>>>>
>>>> One very useful additions (in newer versions than 1.0, otherwise being
>>>> quite old by now) is the sqlops module that allows to do all kind of sql
>>>> operations from configuration file, in many cases saving from the
>>>> complexity of using avpops db functions. See:
>>>>
>>>> https://www.kamailio.org/docs/modules/stable/modules/sqlops.html#idp44901364
>>>>
>>>> So you can do INSERT/UPDATE/REPLACE/... as you need from config file,
>>>> building the sql query with the variables you want.
>>>>
>>>> Cheers,
>>>> Daniel
>>>>
>>>> On 30/09/16 18:29, Brian McCrary wrote:
>>>>> Hello group,
>>>>>
>>>>> I know this may be hard to believe but I'm in the process of upgrading 
>>>>> an old, but stable, OpenSER 1.0 group of servers to Kamilio.  I'm 
>>>>> basically going to sort of start from scratch with the database and 
>>>>> export my old MySQL database and write some scripts to reimport the data 
>>>>> using kamctl scripts since the database structure has changed 
>>>>> substantially since then it looks like.
>>>>>
>>>>> I've mostly migrated the config file over fairly easily, except for 
>>>>> AVPops.  I've got a section of config file that writes into the 
>>>>> usr_preferences database for call forwarding, but I seem to get the same 
>>>>> error anywhere I try to write to the database using AVPops.  Here's the 
>>>>> output I get when checking the config:
>>>>>
>>>>>  0(1378) DEBUG: <core> [pvapi.c:268]: pv_cache_add(): PV cache not initialized, doing it now
>>>>>  0(1378) ERROR: <core> [pvapi.c:828]: pv_parse_spec2(): error searching pvar "avp"
>>>>>  0(1378) ERROR: <core> [pvapi.c:1032]: pv_parse_spec2(): wrong char [s/115] in [$avp(s:callfwd)] at [5 (5)]
>>>>>  0(1378) : <core> [cfg.y:3368]: yyerror_at(): parse error in config file 
>>>>> /usr/local/etc/kamailio/kamailio.cfg, line 145, column 4-18: Can't get from cache: $avp(s:callfwd)
>>>>> ERROR: bad config file (1 errors)
>>>>>
>>>>> Here's what I think are the revelant portions of the config file:
>>>>>
>>>>> modparam("avpops", "db_url", "mysql://user:pass@localhost/kamailio")
>>>>> modparam("avpops", "avp_table", "usr_preferences")
>>>>> modparam("avpops", "uuid_column", "uuid")
>>>>> modparam("avpops", "username_column", "username")
>>>>> modparam("avpops", "domain_column", "domain")
>>>>> modparam("avpops", "attribute_column", "attribute")
>>>>> modparam("avpops", "value_column", "value")
>>>>> modparam("avpops", "type_column", "type")
>>>>> <snip>
>>>>>                         if (avp_db_load("$from/username", "$avp(s:callfwd)"))
>>>>>                         {
>>>>>                                 if(!avp_db_delete("$from/username", "$avp(s:callfwd)/usr_preferences"))
>>>>>                                 {
>>>>>                                         sl_send_reply("500", "Server DB error");                                }
>>>>>                                 }
>>>>>
>>>>> #                       avp_write("$ruri","$avp(s:callfwd)"); # Old OpenSER 1.0 syntax...
>>>>>                         $avp(s:callfwd) = $ruri; # New Kamailio syntax ??
>>>>>                         avp_db_store("$from/username","$avp(s:callfwd)/usr_preferences");
>>>>>                         t_relay();
>>>>>                         return;
>>>>>
>>>>> Basically I just want to write the ruri into the usr_preferences 
>>>>> database with an attribute of callfwd but not sure what I'm missing.  I 
>>>>> see the error "Can't get from cache" but not sure how that pertains to 
>>>>> what I'm trying to do.  Anyone have any ideas?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Brian
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>> -- 
>>>> Daniel-Constantin Mierla
>>>> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>>>> Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com
>> -- 
>> Daniel-Constantin Mierla
>> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>> Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com

More information about the sr-users mailing list