No cdr data

I read through most of the post but can’t seem to find an answer to my problems. FreePBX is not displaying any cdr data. the call log, Master.csv is being filled with data but nothing in FreePBX. can anyone help?

[quote=“nnishp”]Im having this problem too, although i dont have the option to ./configure or make menuinstall from my directory.

This is asterisk-addons from the asterisk website, newest version as of today. any ideas?[/quote]

U can download addons here ftp.digium.com/pub/asterisk/

Looks like you many need to move back a step and recompile Asterisk. Use menuselect and have a look at section 2, Call Detail Recording. My guess is that unixodbc in not installed on the system, so option 2.4 is not selected.

Report back :slight_smile:

Host CPU : i686 ?

Im having this problem too, although i dont have the option to ./configure or make menuinstall from my directory.

Here are the contents

[root@asterisk asterisk-addons]# dir
app_addon_sql_mysql.c asterisk-ooh323c doc mkdep
app_saycountpl.c cdr_addon_mysql.c format_mp3 README
app_saycountpl.o ChangeLog Makefile res_config_mysql.c
app_saycountpl.so configs Makefile.orig res_sqlite3
[root@asterisk asterisk-addons]#

This is asterisk-addons from the asterisk website, newest version as of today. any ideas?

Recompile asterisk-addons using:
[list]make clean
./configure
make menuselect
make
make install[/list:u]

and ensure the sql options are shelected. If they are not, check the output of ./configure for hints as to what is missing.

[quote=“dirk”]

and ensure the sql options are shelected. If they are not, check the output of ./configure for hints as to what is missing.[/quote]
They are not!


                                              Asterisk-addons Module Selection
                                            *************************************

                                                     Press 'h' for help.

                                                    XXX 1.  app_addon_sql_mysql
                                                    XXX 2.  app_saycountpl
                                                    XXX 3.  cdr_addon_mysql
                                                    XXX 4.  chan_ooh323
                                                    XXX 5.  format_mp3
                                                    XXX 6.  res_config_mysql

When I’m trying to press y nothing happend

Output of make clean and ./configure looks like-

[root@asterisk1 asterisk-addons-1.4.2]# make clean
rm -f *.so *.o .depend
make[1]: Entering directory /usr/src/asterisk-addons-1.4.2/format_mp3' rm -f *.o *.so *~ make[1]: Leaving directory/usr/src/asterisk-addons-1.4.2/format_mp3’
make[1]: Entering directory /usr/src/asterisk-addons-1.4.2/menuselect' rm -f menuselect gmenuselect *.o make[2]: Entering directory/usr/src/asterisk-addons-1.4.2/menuselect/mxml’
/bin/rm -f mxmldoc.o testmxml.o mxml-attr.o mxml-entity.o mxml-file.o mxml-index.o mxml-node.o mxml-search.o mxml-set.o mxml-private.o mxml-string.o libmxml.a mxmldoc doc/mxml.3 doc/mxmldoc.1 testmxml mxml.xml
/bin/rm -f mxmldoc-static libmxml.a
/bin/rm -f *.bck .bak
/bin/rm -f config.cache config.log config.status config.h
/bin/rm -f -r autom4te
.cache
make[2]: Leaving directory /usr/src/asterisk-addons-1.4.2/menuselect/mxml' make[1]: Leaving directory/usr/src/asterisk-addons-1.4.2/menuselect’
[root@asterisk1 asterisk-addons-1.4.2]# ./configure
checking build system type… i686-pc-linux-gnu
checking host system type… i686-pc-linux-gnu
checking target system type… i686-pc-linux-gnu
checking for uname… /bin/uname
checking for gcc… gcc
checking for C compiler default output file name… a.out
checking whether the C compiler works… yes
checking whether we are cross compiling… no
checking for suffix of executables…
checking for suffix of object files… o
checking whether we are using the GNU C compiler… yes
checking whether gcc accepts -g… yes
checking for gcc option to accept ISO C89… none needed
checking for g++… g++
checking whether we are using the GNU C++ compiler… yes
checking whether g++ accepts -g… yes
checking for a BSD-compatible install… /usr/bin/install -c
checking whether ln -s works… yes
checking for GNU make… make
checking for grep… /bin/grep
checking for basename… /bin/basename
checking for dirname… /usr/bin/dirname
checking for sh… /bin/sh
checking for ln… /bin/ln
checking how to run the C preprocessor… gcc -E
checking for grep that handles long lines and -e… (cached) /bin/grep
checking for egrep… /bin/grep -E
checking for ANSI C header files… yes
checking for sys/types.h… yes
checking for sys/stat.h… yes
checking for stdlib.h… yes
checking for string.h… yes
checking for memory.h… yes
checking for strings.h… yes
checking for inttypes.h… yes
checking for stdint.h… yes
checking for unistd.h… yes
checking for initscr in -lcurses… yes
checking curses.h usability… yes
checking curses.h presence… yes
checking for curses.h… yes
checking for initscr in -lncurses… yes
checking for curses.h… (cached) yes
checking for mysql_config… /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient… yes
checking for asterisk.h… no
configure: creating ./config.status
config.status: creating build_tools/menuselect-deps
config.status: creating makeopts

           .$$$$$$$$$$$$$$$=..      
        .$7$7..          .7$$7:.    
      .$$:.                 ,$7.7   
    .$7.     7$$$$           .$$77  
 ..$$.       $$$$$            .$$$7 
..7$   .?.   $$$$$   .?.       7$$$.

$.$. .$$$7. $$$$7 .7$$$. .$$$.
.777. .$$$$$$77$$$77$$$$$7. $$$,
$$$~ .7$$$$$$$$$$$$$7. .$$$.
.$$7 .7$$$$$$$7: ?$$$.
$$$ ?7$$$$$$$$$$I .$$$7
$$$ .7$$$$$$$$$$$$$$$$ :$$$.
$$$ $$$$$$7$$$$$$$$$$$$ .$$$.
$$$ $$$ 7$$$7 .$$$ .$$$.
$$$$ $$$$7 .$$$.
7$$$7 7$$$$ 7$$$
$$$$$ $$$
$$$$7. $$ ™
$$$$$$$. .7$$$$$$ $$
$$$$$$$$$$$$7$$$$$$$$$.$$$$$$
$$$$$$$$$$$$$$$$.

configure: Package configured for:
configure: OS type : Linux
configure: Host CPU : i686

How can I solve this?

Tnx in advance!

make sure your installation is correct wiht the proper cdr_mysql.conf and you have cdr_addon_mysql.so loaded (which requires the asterisk addons plus a change to the Makefile to include the uniqueids).

thank you Philippe cdr_addon_mysql was missing.

My cdr_addon_mysql.so is missing. How can I restore it?