https://bugs.contribs.org/show_bug.cgi?id=10620
Bug ID: 10620
Summary: Asterisk not logging to CDR or CEL databases
Classification: Contribs
Product: SME Contribs
Version: 9.2
Hardware: ---
OS: ---
Status: CONFIRMED
Severity: normal
Priority: P3
Component: smeserver-freepbx
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Target Milestone: ---
I realised that calls were not being logged to the databases.
After a lot of hunting there were multiple issues.
First, it is no longer recommended to use mysql directly. ODBC is now default.
You need:
mysql-connector-odbc
unixODBC
Next it transpired that due to a bug in Asterisk the modules for CDR had been
omitted from the source for Asterisk 13.3.2 (reintroduced around 13.11.x)
I took a copy of the 13.22 source, copied the files and make/menu settings
across and rafter a bit of fiddling about I compiled the modules in the 13.3.2
source tree.
That worked, but due to security considerations in Asterisk, you can't just
load the modules because the compile hashes do not match.
A nice fix was found online whereby you can grep the original hash and copy it
to the newly compile files.
Find existing hash:
[root@asterisk modules]# grep -Eaon "[0-9abcdef]{32}" res_xmpp.so
389:c03a66cc29fb79f47c469d2b0a362e5e <<<<<< existing hash
833:99999999999999999999999999999999
833:00000000000000000000000000000000
834:c03a66cc29fb79f47c469d2b0a362e5e
1088:ffffffffffffffffffffffffffffffff
Find the new hash:
[john@www asterisk_modules]$ grep -Eaon "[0-9abcdef]{32}" cel_odbc.so
92:c3dce7edd87c22340749919e0e77916f <<<<<< new hash
588:99999999999999999999999999999999
588:00000000000000000000000000000000
589:c3dce7edd87c22340749919e0e77916f
Change new for old to match the install:
sed -i -e
's/c3dce7edd87c22340749919e0e77916f/c03a66cc29fb79f47c469d2b0a362e5e/g'
cel_odbc.so
The fixed files are here
https://www.reetspetit.com/Other
cdr_adaptive_odbc.so
cel_odbc.so
func_odbc.so
res_config_odbc.so
res_odbc.so
res_odbc_transaction.so
Copy them to /usr/lib64/asterisk/modules and chmod 0755
Assuming you have the DBs already set up from the FreePBX install then the
config files appear to be correct.
signal-event freepbx-update
Check they are loaded
asterisk -vvvr
module show like odbc (may be others)
cdr_adapative.so
func_odbc.so
res_config.so
res_config_transaction.so
module show like cel (may be others)
cel_manager.so
cel_odbc.so
Now check Logging under CDR and CEL
As far as I am aware it is OK to use these files in our build as the code is
all open source.
The only issue is if they upgrade core via the RPMs (doesn't look likely). They
would then need recompiling.
It does make me wonder if bearing in mind how old the source is, it may be
worth compiling our own version from scratch. The big issue there is a spec
file.
Seems the latest srpm I could find was from the FreePBX Distro
asterisk13-13.19.1-1.shmz65.1.195.src.rpm
However, as configured, that requires extra modules not found in buildsys so I
can't just do a mock test build.
subversion
lua-devel
iksemel-devel
Greater mind than mine now required.
--
You are receiving this mail because:
You are the QA Contact for the bug._______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/
