<br><br><div class="gmail_quote">On Tue, Sep 1, 2009 at 3:06 PM, Matt Riddell <span dir="ltr"><<a href="mailto:lists@venturevoip.com">lists@venturevoip.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">On 1/09/09 4:54 PM, Glen wrote:<br>
>>>>> Parsing '/etc/asterisk/cbmysql.conf': Found<br>
>>>>> asterisk: symbol lookup error: /usr/lib/asterisk/modules/app_cbmysql.so:<br>
>>>>> undefined symbol: mysql_init<br>
</div><div class="im">>> ldd /usr/lib/asterisk/modules/app_cbmysql.so<br>
> This is the output<br>
><br>
> linux-gate.so.1 => (0xffffe000)<br>
> libpthread.so.0 => /lib/libpthread.so.0 (0xb7f60000)<br>
> libc.so.6 => /lib/libc.so.6 (0xb7e2d000)<br>
> /lib/ld-linux.so.2 (0x80000000)<br>
<br>
</div>Er weird - so it's not even requesting a link to the mysql library.<br>
<br>
Looks like the linking somehow went wrong - if it can't find mysql_init<br>
and it doesn't look for it then surely something went wrong at the<br>
linking stage.<br>
<br>
Can you post me the output of the compilation?<br>
<div><div></div><div class="h5"><br>
--<br>
Cheers,<br>
<br>
Matt Riddell<br>
Director<br></div></div></blockquote><div><br><br>When compiling the module I simply recompiled asterisk (I was told this is the best way), below is the output of that.<br><br>remote:/usr/src/asterisk-1.4.20.1 # make && make install<br>
Generating input for menuselect ...<br>menuselect/menuselect --check-deps menuselect.makeopts<br>Generating embedded module rules ...<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>
make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br> [CC] app_cbmysql.c -> app_cbmysql.o<br>app_cbmysql.c:37:1: warning: "AST_MODULE" redefined<br>
<command-line>: warning: this is the location of the previous definition<br>app_cbmysql.c: In function âcheckMaxâ:<br>app_cbmysql.c:116: warning: implicit declaration of function âast_say_numberâ<br>app_cbmysql.c: In function âroomQueryâ:<br>
app_cbmysql.c:181: warning: unused variable âeatimeâ<br>app_cbmysql.c:337: warning: control reaches end of non-void function<br> [LD] app_cbmysql.o -> app_cbmysql.so<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>
make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br> +--------- Asterisk Build Complete ---------+<br> + Asterisk has successfully been built, and +<br>
+ can be installed by running: +<br> + +<br> + make install +<br> +-------------------------------------------+<br>menuselect/menuselect --check-deps menuselect.makeopts<br>
Generating embedded module rules ...<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>
make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>
make[1]: Nothing to be done for `all'.<br>make[1]: Nothing to be done for `all'.<br>if [ x`/usr/bin/id -un` = xroot ]; then CFLAGS=" -pipe -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -g3 -include /usr/src/asterisk-1.4.20.1/include/asterisk/autoconfig.h -march=i686 " sh build_tools/mkpkgconfig /usr/lib/pkgconfig; fi<br>
mkdir -p /var/lib/asterisk/static-http<br>for x in static-http/*; do \<br> /usr/bin/install -c -m 644 $x /var/lib/asterisk/static-http ; \<br> done<br>mkdir -p /var/lib/asterisk/images<br>for x in images/*.jpg; do \<br>
/usr/bin/install -c -m 644 $x /var/lib/asterisk/images ; \<br> done<br>mkdir -p /var/lib/asterisk/agi-bin<br>make -C sounds install<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/sounds'<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/sounds'<br>mkdir -p /usr/lib/asterisk/modules<br>mkdir -p /usr/sbin<br>mkdir -p /etc/asterisk<br>mkdir -p /usr/bin<br>mkdir -p /var/run<br>mkdir -p /var/spool/asterisk/voicemail<br>
mkdir -p /var/spool/asterisk/dictate<br>mkdir -p /var/spool/asterisk/system<br>mkdir -p /var/spool/asterisk/tmp<br>mkdir -p /var/spool/asterisk/meetme<br>mkdir -p /var/spool/asterisk/monitor<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/utils'<br>
for x in astman stereorize streamplayer aelparse muted; do \<br> if [ "$x" != "none" ]; then \<br> /usr/bin/install -c -m 755 $x /usr/sbin/$x; \<br> fi; \<br>
done<br>make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/utils'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/agi'<br>mkdir -p /var/lib/asterisk/agi-bin<br>for x in agi-test.agi eagi-test eagi-sphinx-test jukebox.agi; do /usr/bin/install -c -m 755 $x /var/lib/asterisk/agi-bin ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/agi'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/res'<br>for x in res_adsi.so res_agi.so res_clioriginate.so res_convert.so res_features.so res_indications.so res_monitor.so res_musiconhold.so res_smdi.so res_speech.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/res'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/channels'<br>for x in chan_agent.so chan_iax2.so chan_local.so chan_mgcp.so chan_oss.so chan_phone.so chan_sip.so chan_skinny.so chan_zap.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/channels'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/pbx'<br>for x in pbx_ael.so pbx_config.so pbx_dundi.so pbx_loopback.so pbx_realtime.so pbx_spool.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/pbx'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/apps'<br>for x in app_adsiprog.so app_alarmreceiver.so app_amd.so app_authenticate.so app_cbmysql.so app_cdr.so app_chanisavail.so app_channelredirect.so app_chanspy.so app_controlplayback.so app_db.so app_dial.so app_dictate.so app_directed_pickup.so app_directory.so app_disa.so app_dumpchan.so app_echo.so app_exec.so app_externalivr.so app_festival.so app_flash.so app_followme.so app_forkcdr.so app_getcpeid.so app_hasnewvoicemail.so app_ices.so app_image.so app_lookupblacklist.so app_lookupcidname.so app_macro.so app_meetme.so app_milliwatt.so app_mixmonitor.so app_morsecode.so app_mp3.so app_nbscat.so app_page.so app_parkandannounce.so app_playback.so app_privacy.so app_queue.so app_random.so app_read.so app_readfile.so app_realtime.so app_record.so app_sayunixtime.so app_senddtmf.so app_sendtext.so app_setcallerid.so app_setcdruserfield.so app_settransfercapability.so app_sms.so app_softhangup.so app_speech_utils.so app_stack.so app_system.so app_talkdetect.so app_test.so app_transfer.so app_url.so app_userevent.so app_verbose.so app_voicemail.so app_waitforring.so app_waitforsilence.so app_while.so app_zapateller.so app_zapbarge.so app_zapras.so app_zapscan.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/apps'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/codecs'<br>for x in codec_a_mu.so codec_adpcm.so codec_alaw.so codec_g726.so codec_gsm.so codec_lpc10.so codec_ulaw.so codec_zap.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/codecs'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/formats'<br>for x in format_g723.so format_g726.so format_g729.so format_gsm.so format_h263.so format_h264.so format_ilbc.so format_jpeg.so format_pcm.so format_sln.so format_vox.so format_wav.so format_wav_gsm.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/formats'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/cdr'<br>for x in cdr_csv.so cdr_custom.so cdr_manager.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/cdr'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/funcs'<br>for x in func_base64.so func_callerid.so func_cdr.so func_channel.so func_cut.so func_db.so func_enum.so func_env.so func_global.so func_groupcount.so func_language.so func_logic.so func_math.so func_md5.so func_moh.so func_rand.so func_realtime.so func_sha1.so func_strings.so func_timeout.so func_uri.so; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>
make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/funcs'<br>make[1]: Entering directory `/usr/src/asterisk-1.4.20.1/main'<br>for x in ; do /usr/bin/install -c -m 755 $x /usr/lib/asterisk/modules ; done<br>make[1]: Leaving directory `/usr/src/asterisk-1.4.20.1/main'<br>
/usr/bin/install -c -m 755 main/asterisk /usr/sbin/<br>/bin/ln -sf asterisk /usr/sbin/rasterisk<br>/usr/bin/install -c -m 755 contrib/scripts/astgenkey /usr/sbin/<br>/usr/bin/install -c -m 755 contrib/scripts/autosupport /usr/sbin/<br>
if [ ! -f /usr/sbin/safe_asterisk ]; then \<br> cat contrib/scripts/safe_asterisk | sed 's|__ASTERISK_SBIN_DIR__|/usr/sbin|;s|__ASTERISK_VARRUN_DIR__|/var/run|;' > /usr/sbin/safe_asterisk ;\<br> chmod 755 /usr/sbin/safe_asterisk;\<br>
fi<br>/usr/bin/install -c -d /usr/include/asterisk<br>/usr/bin/install -c -m 644 include/asterisk.h /usr/include<br>/usr/bin/install -c -m 644 include/asterisk/*.h /usr/include/asterisk<br>if [ -n "" ]; then \<br>
rm -f ;\<br> fi<br>mkdir -p /var/log/asterisk/cdr-csv<br>mkdir -p /var/log/asterisk/cdr-custom<br>mkdir -p /var/lib/asterisk/keys<br>mkdir -p /var/lib/asterisk/firmware<br>mkdir -p /var/lib/asterisk/firmware/iax<br>
mkdir -p /usr/share/man/man8<br>/usr/bin/install -c -m 644 keys/iaxtel.pub /var/lib/asterisk/keys<br>/usr/bin/install -c -m 644 keys/freeworlddialup.pub /var/lib/asterisk/keys<br>/usr/bin/install -c -m 644 doc/asterisk.8 /usr/share/man/man8<br>
/usr/bin/install -c -m 644 contrib/scripts/astgenkey.8 /usr/share/man/man8<br>/usr/bin/install -c -m 644 contrib/scripts/autosupport.8 /usr/share/man/man8<br>/usr/bin/install -c -m 644 contrib/scripts/safe_asterisk.8 /usr/share/man/man8<br>
if [ -f contrib/firmware/iax/iaxy.bin ] ; then \<br> /usr/bin/install -c -m 644 contrib/firmware/iax/iaxy.bin /var/lib/asterisk/firmware/iax/iaxy.bin; \<br> fi<br> +---- Asterisk Installation Complete </div>
</div>