[asterisk-users] app_prepaid won't load - undefined symbol mysql_num_fields

[Mosiuoa Tsietsi]

Hi Rodrigo,

Thanks for the prompt response. I'm one step ahead of you (sorry for
omitting this info too!).

On my Fedora Core 5 box, I run 
$ yum list | grep mysql and get:

libdbi-dbd-mysql.i386                    0.8.1a-1.2.1
installed
mysql.i386                               5.0.22-2.1
installed
mysql-administrator.i386                 1.1.10-2.fc5
installed
mysql-devel.i386                         5.0.22-2.1
installed
mysql-gui-common.i386                    1.1.10-2.fc5
installed
mysql-server.i386                        5.0.22-2.1
installed
mysqlclient14.i386                       4.1.14-4.2.1
installed
mysqlclient14-devel.i386                 4.1.14-4.2.1
installed
php-mysql.i386                           5.1.6-3
installed
ser-mysql.i386                           0.9.6-4.fc5
installed
 
So I have installed mysql-devel and I do have the libraries for
mysqlclient in /usr/lib/mysql and /usr/lib/mysql is in my path.  So I'm
not sure what I'm missing.

On Sat, 2006-11-04 at 18:12 -0300, Rodrigo Gonzalez wrote:
> Install mysql devel package (depend on your distribution) and will work, 
> it's not finding the library libmysqlclient
> 
> 
> 
> Mosiuoa Tsietsi wrote:
> > Hi again,
> >
> > I downloaded the bristuff-0.3.0-PRE-1s.tar.gz archive from
> > http://www.junghanns.net which has a script you can run to download the
> > sources for asterisk (1.2.10), libpri (1.2.3) and zaptel (1.2.6).  It
> > also has patches for the above as well.  Another script helps build the
> > sources for each for you one-time.
> >
> > Asterisk build properly and when I copy across my app_prepaid.c file
> > into */apps folder, I can successfully run 
> >
> > $ make clean && make && make install
> >
> > I separately have the sources for asterisk-addons-1.2.4 in which I have
> > successfully run 
> >
> > $ make clean && make install
> >
> > after I have built asterisk.
> >
> > It's when I try 
> > $ asterisk -gcvvvvvvvv that I get the error:
> >
> > [ Booting...Nov  4 22:49:49 NOTICE[1861]: cdr.c:1191 do_reload: CDR
> > simple logging enabled.
> > .Nov  4 22:49:49 WARNING[1861]: cdr_addon_mysql.c:361 my_load_module:
> > MySQL database sock file not specified.  Using default
> > Nov  4 22:49:49 WARNING[1861]: loader.c:325
> > __load_resource: /usr/lib/asterisk/modules/app_prepaid.so: undefined
> > symbol: mysql_num_fields
> > Nov  4 22:49:49 WARNING[1861]: loader.c:499 load_modules: Loading module
> > app_prepaid.so failed!
> >
> > The line in question in the source (app_prepaid.c) is :
> >
> > num_fields = mysql_num_fields(result); 
> >
> > where result is of type *MYSQL_RES, which is defined in my mysql.h
> > header.
> >
> > Please help.  
> >
> >
> > _______________________________________________
> > --Bandwidth and Colocation provided by Easynews.com --
> >
> > asterisk-users mailing list
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> >   
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
-- 
The Law of Unintended Consequences:  for every action, there is an
excellent chance of producing an opposite and totally disproportionate
reaction. - Clyde Haberman