Compiling asterisk with mysql support

Home » Asterisk Users » Compiling asterisk with mysql support
Asterisk Users 7 Comments

I have a working asterisk test box that I’m rebuilding with mysql support
so that I can test cdr stats (http://www.cdr-stats.org/).

When I run ‘make memuselect’, I select res_config_mysql, app_mysql,
cdr_mysql, and app_saycountpl components. The build/install process goes
fine i.e. no errors. However, I’m getting a seg fault error when starting
asterisk.

# /usr/sbin/safe_asterisk: line 145: 27014 Segmentation fault (core
dumped) nice -n $PRIORITY ${ASTSBINDIR}/asterisk -f ${CLIARGS} ${ASTARGS}
> /dev/${TTY} 2>&1 < /dev/${TTY} CentOS release 5.7
asterisk-1.8.9.2
dahdi-linux-complete-2.6.0
libpri-1.4.12

What am I missing?

7 thoughts on - Compiling asterisk with mysql support

  • Paul Belanger wrote:

    Thanks Paul, I’ll look at getting the backtrace a little later today.

  • Matthew Jordan wrote:

    Thanks for the info. Can I assume that these (mysql) modules will be
    removed soon or will they “come alive again” down the road?

  • Matthew Jordan wrote:

    Mathew,

    Each of those odbc modules are unavailable i.e., marked with XXX

    I even deleted the asterisk build directory and started over, but had the
    same results.

    What prereqs do I need besides these:

    mysql.i386 5.0.95-1.el5_7.1 installed
    mysql-connector-odbc.i386 3.51.26r1127-1.el5 installed
    mysql-devel.i386 5.0.95-1.el5_7.1 installed
    mysql-server.i386 5.0.95-1.el5_7.1 installed
    unixODBC.i386 2.2.11-7.1 installed
    unixODBC-devel.i386 2.2.11-7.1 installed

  • libtool-ltdl-devel should be a dependency for unixODBC-devel in CentOS, but it
    is not. You’ll need to install that and re-run ./configure.

  • Jason Parker wrote:

    Jason,

    Sorry for the delay in responding. I just realized that my response,
    which was shortly after yours, was stuck in limbo on my side.

    Installing libtool-ltdl-devel fixed the odbc problem and asterisk is now
    starting up fine.

    Thanks