[OpenSIPS-Users] Dialplan module is not connecting to Database

[Richard Robson]

OK,

I was passing the MI command via the CP interface and getting the errors
there

it is working via the console

[root at gl-sip-01 ~]# opensipsctl fifo dp_translate greenlight:11 01382843843
Output:: 441382843843
ATTRIBUTES::

[root at gl-sip-01 ~]# opensipsctl fifo dp_translate 11 01382843843
Output:: 441382843843
ATTRIBUTES::

I think I will stop using the CP.

Thanks Richard


On 23/03/2016 12:47, Bogdan-Andrei Iancu wrote:
> Hi Richard,
>
> So, at the end , what is the full correct syntax for calling the
> dp_translate via fifo ?
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> http://www.opensips-solutions.com
>
> On 23.03.2016 13:37, Richard Robson wrote:
>> Hi Guys,
>>
>> I've got this working now.
>>
>> Here's a couple of things I've found.
>>
>> You appear to need partitions, despite the documentation to the
>> contrary.
>> The MI command dp_translate does not accept the partition:dpid as a
>> valid input it seems to want just the dpid
>> the New book has " in its examples. These don't get added to the
>> database entries
>>
>> regards,
>>
>> Richard
>>
>>
>>
>> On 22/03/2016 16:13, Bogdan-Andrei Iancu wrote:
>>> Hi Richard,
>>>
>>> Have you provided the partition name while firing the MI command ?
>>>
>>> See
>>> http://www.opensips.org/html/docs/modules/2.1.x/dialplan.html#id294353
>>> (1.8.2. dp_translate)
>>>
>>> Regards,
>>>
>>> Bogdan-Andrei Iancu
>>> OpenSIPS Founder and Developer
>>> http://www.opensips-solutions.com
>>>
>>> On 22.03.2016 14:28, Richard Robson wrote:
>>>> Hi,
>>>>
>>>> I'm trying to use the dialplan module, but every time I get a "400
>>>> Wrong
>>>> db connection para"
>>>>
>>>> the connection is the same for all other modules, which are working
>>>> fine
>>>> and I can connect via opensipsCP, mysql and phpmyadmin.
>>>>
>>>> I'm using version 2.1
>>>>
>>>> Mar 22 12:22:13 gl-sip-01 opensips: ERROR:dialplan:mi_translate:
>>>> Unable
>>>> to get connection
>>>> Mar 22 12:22:13 gl-sip-01 opensips:
>>>> DBG:mi_datagram:mi_datagram_server:
>>>> command process (dp_translate)succeded
>>>> Mar 22 12:22:13 gl-sip-01 opensips:
>>>> DBG:mi_datagram:mi_datagram_server:
>>>> the response: 400 Wrong db connection para#012 has been sent in 29
>>>> octets
>>>>
>>>> Dialplan table:
>>>>
>>>> +----+------+------+----------+------------------+-------------+-----------+----------+---------+----------+-------+
>>>>
>>>>
>>>> | id | dpid | pr   | match_op | match_exp        | match_flags |
>>>> subst_exp | repl_exp | timerec | disabled | attrs |
>>>> +----+------+------+----------+------------------+-------------+-----------+----------+---------+----------+-------+
>>>>
>>>>
>>>> |  1 |   10 |    1 |        1 | "^0[1-9][0-9]+$" |           0 |
>>>> "^0(.*)$" | "44\0"   |         |        0 |       |
>>>> +----+------+------+----------+------------------+-------------+-----------+----------+---------+----------+-------+
>>>>
>>>>
>>>>
>>>>
>>>> #### Dialplan ####
>>>> loadmodule "dialplan.so"
>>>> modparam("dialplan", "db_url",
>>>>           "mysql://root:opensips@127.0.0.1:3306/opensips")
>>>>
>>>> I also tried with the same results:
>>>> modparam("dialplan", "partition", "   default : table_name =
>>>> dialplan ;
>>>> db_url = mysql://root:opensips@127.0.0.1:3306/opensips")
>>>>
>>>> does anyone know why this is happening for this module only
>>>>
>>>> Regards,
>>>>
>>
>


-- 
Richard Robson
Greenlight Support
01382 843843
support at greenlightcrm.com