'cdr_addon_mysql.so' could not be found

Asterisk Asterisk Support
1

I tried to install MySql in my Asterisk, but it show me this problem

debian7*CLI> cdr mysql status
Not currently connected to a MySQL server.
debian7*CLI> module unload cdr_addon_mysql.so
Unable to unload resource cdr_addon_mysql.so
Command 'module unload cdr_addon_mysql.so' failed.
[Sep 22 11:54:28] WARNING[3697]: loader.c:602 ast_unload_resource: Unload failed, 'cdr_addon_mysql.so' could not be found
debian7*CLI> module load cdr_addon_mysql.so
Unable to load module cdr_addon_mysql.so
Command 'module load cdr_addon_mysql.so' failed.
[Sep 22 11:54:31] WARNING[3697]: loader.c:463 load_dynamic_module: Error loading module 'cdr_addon_mysql.so': /usr/lib/asterisk/modules/cdr_addon_mysql.so: cannot open shared object file: No such file or directory
[Sep 22 11:54:31] WARNING[3697]: loader.c:954 load_resource: Module 'cdr_addon_mysql.so' could not be loaded.

But I already created my /etc/asterisk/cdr_mysql.conf

[global]
hostname=localhost
dbname=asteriskcdrdb
table=cdr
password=100567
user=root
port=3306
userfield=1

And my modules is load /etc/asterisk/modules.conf

;
; Asterisk configuration file
;
; Module Loader configuration file 
;

[modules]
autoload=yes
;
; Any modules that need to be loaded before the Asterisk core has been
; initialized (just after the logger has been initialized) can be loaded
; using 'preload'. This will frequently be needed if you wish to map all
; module configuration files into Realtime storage, since the Realtime
; driver will need to be loaded before the modules using those configuration
; files are initialized.
;
; An example of loading ODBC support would be:
;preload => res_odbc.so
;preload => res_config_odbc.so
;
; Uncomment the following if you wish to use the Speech Recognition API
;preload => res_speech.so
;
; If you want Asterisk to fail if a module does not load, then use
; the "require" keyword. Asterisk will exit with a status code of 2
; if a required module does not load.
;
; require = chan_sip.so
; If you want you can combine with preload
; preload-require = res_odbc.so
;
; If you want, load the GTK console right away.
;
noload => pbx_gtkconsole.so
;load => pbx_gtkconsole.so
;
load => res_musiconhold.so
;
; Load one of: chan_oss, alsa, or console (portaudio).
; By default, load chan_oss only (automatically).
;
noload => chan_alsa.so
;noload => chan_oss.so
noload => chan_console.so
;
load => cdr_addon_mysql.so

How can I fix it?

2

Use ODBC to connect your asterisk to mysql instead of cdr_mysql … take a look at the post I have here :

omid-mohajerani.blogspot.com/201 … -odbc.html

1 Like
3

Thanks very much