[OpenSIPS-Users] dialog module errors

[Mouncif Benniane]

Bogdan,

I figured out the issue, you are right the errors that were generated
because Mysql client I have installed was not compiled properly with
opensips (version 5.1).
thnanks

On Sun, Nov 15, 2009 at 1:50 PM, Bogdan-Andrei Iancu <bogdan at voice-system.ro
> wrote:

> Hi Mouncif,
>
> Do you get db errors only for the DIALOG module? do you have other
> modules using DB perfectly working?
>
> Have you tried to re-create the dialog table ?
>
> The error is generated directly by the mysql driver (from opensips)
> because it does not recognize the types of the columns from the dialog
> table - are you sure you are using the structure as provided by the
> opensips db installer ?
>
> Regards,
> Bogdan
>
> Mouncif Benniane wrote:
> > I get this errors when starting opensips 1.6 with dialog module
> > enabled ( centos 5.2)
> >
> > WARNING:db_mysql:db_mysql_get_columns: unhandled data type column
> > (hash_id) type id (154246320), use DB_STRING as default
> > WARNING:db_mysql:db_mysql_get_columns: unhandled data type column
> > (dialog) type id (154246392), use DB_STRING as default
> > WARNING:db_mysql:db_mysql_get_columns: unhandled data type column
> > (dialog) type id (154246432), use DB_STRING as default
> > WARNING:db_mysql:db_mysql_get_columns: unhandled data type column
> > (opensips) type id (154246512), use DB_STRING as default
> > WARNING:db_mysql:db_mysql_get_columns: unhandled data type column
> > (def) type id (154246544), use DB_STRING as default
> >
> >
> > my config looks like this:
> >
> > #dialog
> > modparam("dialog", "profiles_with_value", "inbound")
> > modparam("dialog", "dlg_flag", 4)
> > modparam("dialog", "db_url", "mysql://root:passxxxx@localhost/opensips")
> > modparam("dialog", "db_mode", 1)
> > modparam("dialog", "db_update_period", 60)
> > modparam("dialog", "table_name", "dialog")
> >
> >
> > opensips never starts and exit. any ideas?? BTW same config and
> > version worked on centos 4.6.
> >
> >
> > Thanks
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091115/0c7035c9/attachment.htm