I have problem with starting asterisk with realtime configuration using odbc connection. I get this in log and asterisk does not start: Sep 8 12:29:59 NOTICE[32468] cdr.c: CDR simple logging enabled. Sep 8 12:30:00 WARNING[32468] loader.c: /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: SQLFetch Sep 8 12:30:00 WARNING[32468] loader.c: Loading module res_config_odbc.so failed! noload => res_config_odbc.so in modules.conf makes asterisk start but then realtime does not work: Sep 8 12:08:47 WARNING[3400] config.c: Realtime mapping for 'extensions' found to engine 'odbc', but the engine is not available I have unixODBC-2.2.12 installed on that machine. Portage 2.1.4.4 (hardened/linux/x86/2008.0, gcc-3.4.6, glibc-2.6.1-r0, 2.6.25-hardened-r4 i686) ================================================================= System uname: 2.6.25-hardened-r4 i686 Intel(R) Celeron(R) CPU 2.00GHz Timestamp of tree: Fri, 05 Sep 2008 14:36:01 +0000 app-shells/bash: 3.2_p33 dev-java/java-config: 1.3.7, 2.1.6 dev-lang/python: 2.5.2-r6 sys-apps/baselayout: 1.12.11.1 sys-apps/sandbox: 1.2.18.1-r2 sys-devel/autoconf: 2.61-r2 sys-devel/automake: 1.4_p6, 1.10.1 sys-devel/binutils: 2.18-r3 sys-devel/gcc-config: 1.4.0-r4 sys-devel/libtool: 1.5.26 virtual/os-headers: 2.6.23-r3 ACCEPT_KEYWORDS="x86" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=pentium4 -O2 -pipe -fomit-frame-pointer" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /var/qmail/alias /var/qmail/control" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/udev/rules.d" CXXFLAGS="-march=pentium4 -O2 -pipe -fomit-frame-pointer" DISTDIR="/usr/portage/distfiles" FEATURES="distlocks metadata-transfer sandbox sfperms strict unmerge-orphans userfetch" GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo" LDFLAGS="-Wl,-O1" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="apache2 berkdb crypt device-mapper hardened java5 mmx ncurses pam perl pic python readline snmp ssl tcpd vhosts x86 xml" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="authz_host dir log_config mime mime_magic proxy" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i740 i810 imstt mach64 mga neomagic nsc nv r128 radeon rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga via vmware voodoo" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
I forgot to mention the asterisk versions, I tried that with 1.2.27 and 1.2.17 and both behave the same. Here is output of ldd: # ldd -d -r /usr/lib/asterisk/modules/res_config_odbc.so undefined symbol: option_verbose (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLFetch (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_config_get_current_category (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLPrepare (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLRowCount (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_variable_append (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_build_string (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_category_append (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: fetch_odbc_obj (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLBindParameter (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_softhangup (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_register_file_version (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLFreeHandle (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: odbc_smart_execute (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_config_engine_deregister (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_variable_new (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_log (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_update_use_count (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_config_new (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_category_destroy (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLDescribeCol (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLAllocHandle (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLBindCol (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_verbose (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_config_internal_load (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_category_new (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_category_rename (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLGetData (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_variables_destroy (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: SQLNumResultCols (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_config_engine_register (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: odbc_smart_direct_execute (/usr/lib/asterisk/modules/res_config_odbc.so) undefined symbol: ast_unregister_file_version (/usr/lib/asterisk/modules/res_config_odbc.so) linux-gate.so.1 => (0xb8058000) libc.so.6 => /lib/libc.so.6 (0xb7f19000) /lib/ld-linux.so.2 (0xb8059000)
Created attachment 164931 [details] log of build process
Reassigning to chainsaw as he is now the asterisk maintainer. There is another bug about odbc and asterisk, see bug 189449
Miroslav, is this still an issue for you in 1.2.32? If so, could you reopen with emerge -pv asterisk output please?
