[asterisk-users] Compiling asterisk with mysql support

[Ron Bergin]

Matthew  Jordan wrote:
>
> ----- Original Message -----
>> From: "Ron Bergin" <rkb at i.frys.com>
>> To: asterisk-users at lists.digium.com
>> Sent: Tuesday, March 6, 2012 11:05:35 AM
>> Subject: [asterisk-users] Compiling asterisk with mysql support
>>
>> 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.
>
> Please also note that app_saycountpl, res_config_mysql, app_mysql, and
> cdr_mysql are all either extended support modules or deprecated:
>
> https://wiki.asterisk.org/wiki/display/AST/Asterisk+Module+Support+States
>
> Note that if the segmentation fault is occurring in an extended support
> module, development support typically comes from the Asterisk community.
> In the case of deprecated modules, your mileage will vary considerably.
>
> You may want to consider using an ODBC connection instead of interfacing
> directly with the MySQL database, using the following:
>
> * app_mysql => func_odbc
> * cdr_mysql => cdr_adaptive_odbc
> * res_config_mysql => res_odbc
> * app_saycountpl => say.conf
>
>> --
>> Ron Bergin
>> Network Operations Administrator
>> Fry's Electronics, Inc.
>>
>
> Matthew Jordan
> Digium, Inc. | Software Developer
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> Check us out at: http://digium.com & http://asterisk.org
>
> --

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

-- 
Ron Bergin
Network Operations Administrator
Fry's Electronics, Inc.