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

[Mosiuoa Tsietsi]

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.