CDR mysql with asterisk 1.4

Home » Asterisk Users » CDR mysql with asterisk 1.4
Asterisk Users 18 Comments

hello list

i have asterisk 1.4 installed and i want to use CDR mysql during the
installation i didn’t check the cdr mysql with make menuselect

my question : i want to check this option now after the installtion and
configuration of all options but he asks me to do. /configure before to use
make menuselect

i want to know if there any problem if i do. / configure and make
menuselect to install cdr because this server is very important for me and
i can’t stop it

thanks and regards

18 thoughts on - CDR mysql with asterisk 1.4

  • On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
    wrote:

    How did you initially install Asterisk? When compiling from source
    ./configure is the first step before you can run make. It shouldn’t
    prompt to run ./configure for make menuselect if you are just changing
    some options from a previously compile and install.

    If you were able to run make menuselect without configure you might be
    able to load the module while Asterisk is running. You would copy the
    cdr_mysql.so to the lib directory and run module load cdr_mysql.
    However I would still plan this for after hours in case of an issue.

    Ryan

  • i try to run make menuselect without configure but he give me an error and
    he tell me that i must run ./configure before launch make menuselect

    i’m afraid if i launch ./configure and after make menuselet to lost all
    configuration related to asterisk

    BTW i can restart asterisk without issue

    thanks for your response

    2011/11/21 Ryan Wagoner

  • From what I read you are running a pre-compiled asterisk – what you can do
    in that instance is this

    1 create a directory like /usr/local/src/asterisk/1.4-update

    2 wget the matching version as indicated by “core show version”

    3 extract the tar to the directory from step 1

    4 run ./configure

    5 run make menuselect

    6 run make – DO NOT RUN make install

    7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
    CLI

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Monday, November 21, 2011 8:52 AM

    i try to run make menuselect without configure but he give me an error and
    he tell me that i must run ./configure before launch make menuselect

    i’m afraid if i launch ./configure and after make menuselet to lost all
    configuration related to asterisk

    BTW i can restart asterisk without issue

    thanks for your response

    2011/11/21 Ryan Wagoner

    On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
    wrote:
    use
    menuselect
    stop

    How did you initially install Asterisk? When compiling from source
    ./configure is the first step before you can run make. It shouldn’t
    prompt to run ./configure for make menuselect if you are just changing
    some options from a previously compile and install.

    If you were able to run make menuselect without configure you might be
    able to load the module while Asterisk is running. You would copy the
    cdr_mysql.so to the lib directory and run module load cdr_mysql.
    However I would still plan this for after hours in case of an issue.

    Ryan

  • thanks danny and thanks all i will test this solution and i will update you
    by the result

    kind regards

    2011/11/21 Danny Nicholas

  • Hello Danny

    i try to flow your email but when i do make menuselect i didn’t find
    add-ons in order to check the cdr_mysql

    i use asterisk 1.4

    1-how can i do to install this add-ons

    2 i want to do this installation without touching the original
    configuration of asterisk

    thanks and regards

    2011/11/21 Danny Nicholas

  • what i have in “Call Detail Recording” is

    [*] 1. cdr_csv
    [*] 2. cdr_custom
    [*] 3. cdr_manager
    xxx 4. cdr_odbc
    xxx 5. cdr_pgsql
    xxx 6. cdr_radius
    xxx 7. cdr_sqlite
    xxx 8. cdr_tds

    2011/11/29 Danny Nicholas

  • Try running

    ./configure -with-mysql=/usr

    Make menuselect

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 9:06 AM

    what i have in “Call Detail Recording” is

    [*] 1. cdr_csv
    [*] 2. cdr_custom
    [*] 3. cdr_manager
    xxx 4. cdr_odbc
    xxx 5. cdr_pgsql
    xxx 6. cdr_radius
    xxx 7. cdr_sqlite
    xxx 8. cdr_tds

    2011/11/29 Danny Nicholas

    It “should” be a “Call Detail Recording” option, not an add-on.

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 8:45 AM

    i didn’t find him in the menu i have installed the add-ons but i can not
    load the cd_mysql :< please advice 2011/11/29 Danny Nicholas

    It should at least be on the menu although the selection may have XXX
    instead of [ ] or [*] if the dependencies aren’t proper when you run
    ./configure.

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 5:37 AM

    Hello Danny

    i try to flow your email but when i do make menuselect i didn’t find add-ons
    in order to check the cdr_mysql

    i use asterisk 1.4

    1-how can i do to install this add-ons

    2 i want to do this installation without touching the original configuration
    of asterisk

    thanks and regards

    2011/11/21 Danny Nicholas

    From what I read you are running a pre-compiled asterisk – what you can do
    in that instance is this

    1 create a directory like /usr/local/src/asterisk/1.4-update

    2 wget the matching version as indicated by “core show version”

    3 extract the tar to the directory from step 1

    4 run ./configure

    5 run make menuselect

    6 run make – DO NOT RUN make install

    7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
    CLI

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Monday, November 21, 2011 8:52 AM

    i try to run make menuselect without configure but he give me an error and
    he tell me that i must run ./configure before launch make menuselect

    i’m afraid if i launch ./configure and after make menuselet to lost all
    configuration related to asterisk

    BTW i can restart asterisk without issue

    thanks for your response

    2011/11/21 Ryan Wagoner

    On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
    wrote:
    use
    menuselect
    stop

    How did you initially install Asterisk? When compiling from source
    ./configure is the first step before you can run make. It shouldn’t
    prompt to run ./configure for make menuselect if you are just changing
    some options from a previously compile and install.

    If you were able to run make menuselect without configure you might be
    able to load the module while Asterisk is running. You would copy the
    cdr_mysql.so to the lib directory and run module load cdr_mysql.
    However I would still plan this for after hours in case of an issue.

    Ryan

  • after

    ./configure –with-mysql=/usr ****

    Make menuselect****

    ** **same result but i found in module embedding the below options i check
    the cdr and i get the same result

    [ ] 1. apps
    [*] 2. cdr
    [ ] 3. channels
    [ ] 4. codecs
    [ ] 5. formats
    [ ] 6. funcs
    [ ] 7. pbx
    [ ] 8. res
    2011/11/29 Danny Nicholas

  • Mysql is installed and running on your box? What it the path to it?

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 9:20 AM

    after

    ./configure -with-mysql=/usr

    Make menuselect

    same result but i found in module embedding the below options i check the
    cdr and i get the same result

    [ ] 1. apps
    [*] 2. cdr
    [ ] 3. channels
    [ ] 4. codecs
    [ ] 5. formats
    [ ] 6. funcs
    [ ] 7. pbx
    [ ] 8. res

    2011/11/29 Danny Nicholas

    Try running

    ./configure -with-mysql=/usr

    Make menuselect

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 9:06 AM

    what i have in “Call Detail Recording” is

    [*] 1. cdr_csv
    [*] 2. cdr_custom
    [*] 3. cdr_manager
    xxx 4. cdr_odbc
    xxx 5. cdr_pgsql
    xxx 6. cdr_radius
    xxx 7. cdr_sqlite
    xxx 8. cdr_tds

    2011/11/29 Danny Nicholas

    It “should” be a “Call Detail Recording” option, not an add-on.

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 8:45 AM

    i didn’t find him in the menu i have installed the add-ons but i can not
    load the cd_mysql :< please advice 2011/11/29 Danny Nicholas

    It should at least be on the menu although the selection may have XXX
    instead of [ ] or [*] if the dependencies aren’t proper when you run
    ./configure.

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 5:37 AM

    Hello Danny

    i try to flow your email but when i do make menuselect i didn’t find add-ons
    in order to check the cdr_mysql

    i use asterisk 1.4

    1-how can i do to install this add-ons

    2 i want to do this installation without touching the original configuration
    of asterisk

    thanks and regards

    2011/11/21 Danny Nicholas

    From what I read you are running a pre-compiled asterisk – what you can do
    in that instance is this

    1 create a directory like /usr/local/src/asterisk/1.4-update

    2 wget the matching version as indicated by “core show version”

    3 extract the tar to the directory from step 1

    4 run ./configure

    5 run make menuselect

    6 run make – DO NOT RUN make install

    7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
    CLI

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Monday, November 21, 2011 8:52 AM

    i try to run make menuselect without configure but he give me an error and
    he tell me that i must run ./configure before launch make menuselect

    i’m afraid if i launch ./configure and after make menuselet to lost all
    configuration related to asterisk

    BTW i can restart asterisk without issue

    thanks for your response

    2011/11/21 Ryan Wagoner

    On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
    wrote:
    use
    menuselect
    stop

    How did you initially install Asterisk? When compiling from source
    ./configure is the first step before you can run make. It shouldn’t
    prompt to run ./configure for make menuselect if you are just changing
    some options from a previously compile and install.

    If you were able to run make menuselect without configure you might be
    able to load the module while Asterisk is running. You would copy the
    cdr_mysql.so to the lib directory and run module load cdr_mysql.
    However I would still plan this for after hours in case of an issue.

    Ryan

  • yes is installad and is running

    mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql
    /usr/share/man/man1/mysql.1.gz

    2011/11/29 Danny Nicholas

  • ./configure is not finding your mysql install and accounting for it

    I would try

    ./configure -with-mysql=/usr/bin

    Make menuselect

    I’m not the resource you want for this one as I don’t use mysql or any
    databases with my asterisk (prefer to keep things as simple as possible).

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 9:30 AM

    yes is installad and is running

    mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql
    /usr/share/man/man1/mysql.1.gz

    2011/11/29 Danny Nicholas

    Mysql is installed and running on your box? What it the path to it?

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 9:20 AM

    after

    ./configure -with-mysql=/usr

    Make menuselect

    same result but i found in module embedding the below options i check the
    cdr and i get the same result

    [ ] 1. apps
    [*] 2. cdr
    [ ] 3. channels
    [ ] 4. codecs
    [ ] 5. formats
    [ ] 6. funcs
    [ ] 7. pbx
    [ ] 8. res

    2011/11/29 Danny Nicholas

    Try running

    ./configure -with-mysql=/usr

    Make menuselect

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 9:06 AM

    what i have in “Call Detail Recording” is

    [*] 1. cdr_csv
    [*] 2. cdr_custom
    [*] 3. cdr_manager
    xxx 4. cdr_odbc
    xxx 5. cdr_pgsql
    xxx 6. cdr_radius
    xxx 7. cdr_sqlite
    xxx 8. cdr_tds

    2011/11/29 Danny Nicholas

    It “should” be a “Call Detail Recording” option, not an add-on.

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 8:45 AM

    i didn’t find him in the menu i have installed the add-ons but i can not
    load the cd_mysql :< please advice 2011/11/29 Danny Nicholas

    It should at least be on the menu although the selection may have XXX
    instead of [ ] or [*] if the dependencies aren’t proper when you run
    ./configure.

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Tuesday, November 29, 2011 5:37 AM

    Hello Danny

    i try to flow your email but when i do make menuselect i didn’t find add-ons
    in order to check the cdr_mysql

    i use asterisk 1.4

    1-how can i do to install this add-ons

    2 i want to do this installation without touching the original configuration
    of asterisk

    thanks and regards

    2011/11/21 Danny Nicholas

    From what I read you are running a pre-compiled asterisk – what you can do
    in that instance is this

    1 create a directory like /usr/local/src/asterisk/1.4-update

    2 wget the matching version as indicated by “core show version”

    3 extract the tar to the directory from step 1

    4 run ./configure

    5 run make menuselect

    6 run make – DO NOT RUN make install

    7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
    CLI

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of salaheddine
    elharit
    Sent: Monday, November 21, 2011 8:52 AM

    i try to run make menuselect without configure but he give me an error and
    he tell me that i must run ./configure before launch make menuselect

    i’m afraid if i launch ./configure and after make menuselet to lost all
    configuration related to asterisk

    BTW i can restart asterisk without issue

    thanks for your response

    2011/11/21 Ryan Wagoner

    On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
    wrote:
    use
    menuselect
    stop

    How did you initially install Asterisk? When compiling from source
    ./configure is the first step before you can run make. It shouldn’t
    prompt to run ./configure for make menuselect if you are just changing
    some options from a previously compile and install.

    If you were able to run make menuselect without configure you might be
    able to load the module while Asterisk is running. You would copy the
    cdr_mysql.so to the lib directory and run module load cdr_mysql.
    However I would still plan this for after hours in case of an issue.

    Ryan

  • Unless you built your MySQL from Source Code, you need to have the developers’
    package for MySQL installed. That would be mysql-devel (on CentOS / Fedora)
    or libmysqlclient-dev (on Ubuntu / Debian). Then run ./configure again.

  • In order to install MySQL support for asterisk 1.4, you’ll need to download
    the asterisk-addons-1.4 tarball, extract it to it’s own folder. Go to that
    folder, run ./configure, make menuselect, and select the cdr_addon_mysql
    and the res_config_mysql options. Exit make menuselect, then run make,
    make install, and make samples. This should add the necessary modules to
    asterisk, as well as the sample config files.

    This of course assumes you’ve got mysql and it’s development packages
    installed.

  • i use centos 5.5 if i install mysql-devel i can still use the version of
    mysql installed now in my server because i use it with a database and Im
    afraid to install this mysql-devel and i lost the version of mysql reunning
    actually

    please advice

    2011/11/29 A J Stiles

  • Don’t be afraid, it will not cause any problems at all. The *-devel
    packages contain the libraries and header files that are needed for
    developing the application and some of these are used by the asterisk
    addons. It will in no way replace anything you currently have or use.

    Regards

    Ish

  • ** THIS IS NOT THE RIGHT PLACE TO POST A REPLY **

    Yes, it will work fine. mysql-devel doesn’t *replace* an existing mysql
    package; it merely adds some “development” files.

    The -devel packages are a throwback to the bad old days, when Internet
    connectivity was by dial-up modem and hard disk space was scarce.

    Basically, when you build a package from Source Code, there are some files that
    get left behind and aren’t needed just for day-to-day use of the program, but
    are essential if you need to build something else that works with the package.

    To trim down the size of downloadable packages, these “development” files were
    abstracted away into separate packages.

    Nine out of ten Linux users have to compile a package from source at some
    stage and the tenth one is probably lying. Most people wouldn’t notice the
    extra space taken up by -devel packages, and the ones that would — perhaps
    because they’re building embedded systems, or have other disk space
    constraints — are smart enough to know what to do. Yet distributions
    continue to separate out these packages and in the process, make the whole
    process of compiling from source unnecessarily complicated.

    Even an option in the installer to select “always install -devel package if it
    exists” would be a good beginning. Distro maintainers — are you listening?
    Please?