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

[Bogdan-Andrei Iancu]

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,
>