[OpenSIPS-Users] opensips with mysql error

duane.larson at gmail.com duane.larson at gmail.com
Tue Nov 8 23:40:29 CET 2011


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.



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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111108/d944b5d6/attachment-0001.htm>


More information about the Users mailing list