[OpenSIPS-Users] opensips with mysql error

[Nick Khamis]

Hello Duane,

Thank you so much for your response. I installed (libmysqlclient-dev,
and mysql-client),
re-installed opensips, and it seems to be ok so far. For some reason
CTLENGINE was
set to xmlrpm instead of fifo, and I had an error there. Will keep the
list updated if just
the two packages are sufficent.

P.S. Is there a whitepaper put together for loadbalancing asterisk
boxes using opensips?
We are also using a2billing on the asterisk boxes.

Cheers,

Nick.

On Tue, Nov 8, 2011 at 4:21 PM,  <duane.larson at gmail.com> wrote:
> I would install the following
> unixODBC unixODBC-dev
>
> And then recompile OpenSIPS.
>
> On , Nick Khamis <symack at gmail.com> wrote:
>> I am still getting the error. Not sure if I need to include unixodbc
>>
>> stuff or not. As for the mysql header -dev files
>>
>> I have the following:
>>
>>
>>
>> root at opensips1:/usr/include/mysql# ls
>>
>> decimal.h   m_string.h      my_dbug.h    my_list.h        mysql_com.h
>>
>> mysql.h     my_xml.h      sslopt-case.h
>>
>> errmsg.h    my_alloc.h      my_dir.h     my_net.h         mysqld_ername.h
>>
>> mysql_time.h     plugin.h         sslopt-longopts.h
>>
>> keycache.h  my_attribute.h  my_getopt.h  my_no_pthread.h
>>
>> mysqld_error.h   mysql_version.h  sql_common.h  sslopt-vars.h
>>
>> m_ctype.h   my_config.h     my_global.h  my_pthread.h     mysql_embed.h
>>
>>  my_sys.h          sql_state.h   typelib.h
>>
>>
>>
>> Thanks in Advance,
>>
>>
>>
>> Nick.
>>
>>
>>
>>
>>
>> On Tue, Nov 8, 2011 at 3:56 PM,  duane.larson at gmail.com> wrote:
>>
>> > So are you good now?
>>
>> >
>>
>> > On , Nick Khamis symack at gmail.com> wrote:
>>
>> >> I should mention that the actual mysql server is on a different server.
>>
>> >>
>>
>> >>
>>
>> >>
>>
>> >> Nick.
>>
>> >>
>>
>> >>
>>
>> >>
>>
>> >> On Tue, Nov 8, 2011 at 3:33 PM, Nick Khamis symack at gmail.com> wrote:
>>
>> >>
>>
>> >> > Oooops, I just realized that I misspelled your name. Sorry Duane!
>>
>> >>
>>
>> >> >
>>
>> >>
>>
>> >> > Nick
>>
>> >>
>>
>> >> >
>>
>> >>
>>
>> >> > On Tue, Nov 8, 2011 at 3:32 PM, Nick Khamis symack at gmail.com> wrote:
>>
>> >>
>>
>> >> >> Hello Duan,
>>
>> >>
>>
>> >> >>
>>
>> >>
>>
>> >> >> Thank you so much for your response. That was my post a while back.
>> >> >> I
>>
>> >>
>>
>> >> >> have "libmysqlclient-dev"
>>
>> >>
>>
>> >> >> installed. But I think I left unixodbc out.
>>
>> >>
>>
>> >> >>
>>
>> >>
>>
>> >> >> Cheers,
>>
>> >>
>>
>> >> >>
>>
>> >>
>>
>> >> >> Nick.
>>
>> >>
>>
>> >> >>
>>
>> >>
>>
>> >> >> On Tue, Nov 8, 2011 at 3:29 PM,  duane.larson at gmail.com> wrote:
>>
>> >>
>>
>> >> >>> See if this helps
>>
>> >>
>>
>> >> >>>
>>
>> >>
>>
>> >> >>>
>>
>> >> >>>
>> >> >>> http://opensips-open-sip-server.1449251.n2.nabble.com/MySQL-Database-Connectivity-td6957283.html
>>
>> >>
>>
>> >> >>>
>>
>> >>
>>
>> >> >>> On , Nick Khamis symack at gmail.com> wrote:
>>
>> >>
>>
>> >> >>>> Hello Everyone,
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> I am trying to build OpenSIPS V1.7 from source with MySQL support
>>
>> >> >>>> using:
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> make include_modules="db_mysql" modules
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> make include_modules="db_mysql" install
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> When issuing opensipsctl, i am recieving the following error:
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> error: 'mysql' tool not found: set MYSQL variable to correct tool
>>
>> >> >>>> path
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> On a side note, how do we uninstall OpenSIPS. There is no make
>>
>> >> >>>> uninstall
>>
>> >>
>>
>> >> >>>> task.
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> Thanks in Advance,
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> Nick.
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> _______________________________________________
>>
>> >>
>>
>> >> >>>>
>>
>> >>
>>
>> >> >>>> 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
>>
>> >>
>>
>> >> >>>
>>
>> >>
>>
>> >> >>>
>>
>> >>
>>
>> >> >>
>>
>> >>
>>
>> >> >
>>
>> >>
>>
>> >>
>>
>> >>
>>
>> >> _______________________________________________
>>
>> >>
>>
>> >> 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
>>
>> >
>>
>> >
>>
>>
>>
>> _______________________________________________
>>
>> 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
>
>