[OpenSIPS-Users] opensips with mysql error

[Nick Khamis]

Thanks again Duane! I am currently working my way through the OpenSIPS
Asterisk Integration, and
will make my way to the LB.

Have a nice Evening,

Nick.

On Tue, Nov 8, 2011 at 5:40 PM,  <duane.larson at gmail.com> wrote:
> This is all I know.
>
> http://www.opensips.org/Resources/DocsTutLoadbalancing
>
> On , Nick Khamis <symack at gmail.com> wrote:
>> 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
>>
>> >
>>
>> >
>>
>>
>>
>> _______________________________________________
>>
>> 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
>
>