Hello everyone,
I’m having a problem with upgrading the CDR module to 2.11.0.3. On upgrade, I get this:
Please wait while module actions are performed
Checking if field did is present in cdr table…
did field already present.
Checking if field recordingfile is present in cdr table…
recordingfile field already present.
Checking if field cnum is present in cdr table…
cnum field already present.
Checking if field cnam is present in cdr table…
cnam field already present.
Checking if field outbound_cnum is present in cdr table…
outbound_cnum field already present.
Checking if field outbound_cnam is present in cdr table…
outbound_cnam field already present.
Checking if field dst_cnam is present in cdr table…
dst_cnam field already present.
Creating cel if needed…
FATAL ERROR
Can not create cel table
Trace Back
/var/www/admin/modules/cdr/install.php:146 die_freepbx()
[0]: Can not create cel table
/var/www/admin/libraries/module.functions.php:1581 include_once()
[0]: /var/www/admin/modules/cdr/install.php
/var/www/admin/libraries/module.functions.php:1548 _modules_doinclude()
[0]: /var/www/admin/modules/cdr/install.php
[1]: cdr
/var/www/admin/libraries/module.functions.php:1157 _module_runscripts()
[0]: cdr
[1]: install
[2]:
/var/www/admin/page.modules.php:397 module_install()
[0]: cdr
/var/www/admin/config.php:306 include()
[0]: /var/www/admin/page.modules.php
Array
(
[0] => Array
(
[file] => /var/www/admin/modules/cdr/install.php
[line] => 146
[function] => die_freepbx
[args] => Array
(
[0] => Can not create cel table
)
)
[1] => Array
(
[file] => /var/www/admin/libraries/module.functions.php
[line] => 1581
[args] => Array
(
[0] => /var/www/admin/modules/cdr/install.php
)
[function] => include_once
)
[2] => Array
(
[file] => /var/www/admin/libraries/module.functions.php
[line] => 1548
[function] => _modules_doinclude
[args] => Array
(
[0] => /var/www/admin/modules/cdr/install.php
[1] => cdr
)
)
[3] => Array
(
[file] => /var/www/admin/libraries/module.functions.php
[line] => 1157
[function] => _module_runscripts
[args] => Array
(
[0] => cdr
[1] => install
[2] => Array
(
[cdr] => Array
(
[rawname] => cdr
[repo] => standard
[description] => Call Data Record report tools for viewing reports of your calls
[name] => CDR Reports
[version] => 2.11.0.3
[publisher] => FreePBX
[license] => GPLv2+
[category] => Reports
[menuitems] => Array
(
[cdr] => CDR Reports
)
[changelog] =>
*2.11.0.3* #6603
*2.11.0.2* #6391
*2.11.0.1* #6255
*2.11.0.0* finish #5782 generate cel and res_odbc conf files, requires odbc.ini to be configured
*2.11.0.beta1.2* #6134 again
*2.11.0.beta1.1* #6134
*2.11.0.beta1.0* adds proper cid fields
*2.11.0.alpha2* #5788, #5782 more
*2.11.0.alpha1* #5782 Adds some CEL support ODBC and CEL manual setup required see cel.man.zip
*2.10.0.4* formatting tweaks
*2.10.0.3* #5500
*2.10.0.2* #5478, $5479
*2.10.0.1* add call recordings to CDR
*2.10.0.0* #1426
*2.10.0.beta4* Bug fixes, re-categorizations
*2.10.0.beta3* Speed up download of csv
*2.10.0.beta2* Bug fixes
*2.10.0.beta1* Play recorded files
*2.10.0.alpha6* Bug fix in recordings settings
*2.10.0.alpha5* Added localization
*2.10.0.alpha4* Added csv export
*2.10.0.alpha3* First public release
*2.10.0.alpha2* Not released to public
*2.10.0.alpha1* Not released to public
*2.10.0.alpha0* Not released to public
[depends] => Array
(
[module] => core ge 2.6.0
)
[location] => release/2.11/cdr-2.11.0.2.tgz
[md5sum] => 6bd6caff8db649734b75064145e254b6
[displayname] => CDR Reports
[items] => Array
(
[cdr] => Array
(
[name] => CDR Reports
[type] => setup
[category] => Reports
[sort] => 0
)
)
[status] => 3
[dbversion] => 2.11.0.2
)
[builtin] => Array
(
[status] => 2
)
)
)
)
[4] => Array
(
[file] => /var/www/admin/page.modules.php
[line] => 397
[function] => module_install
[args] => Array
(
[0] => cdr
)
)
[5] => Array
(
[file] => /var/www/admin/config.php
[line] => 306
[args] => Array
(
[0] => /var/www/admin/page.modules.php
)
[function] => include
)
)
However:
pbx00CLI> cel show status
CEL Logging: Enabled
CEL Tracking Event: ALL
CEL Tracking Event: CHAN_START
CEL Tracking Event: CHAN_END
CEL Tracking Event: HANGUP
CEL Tracking Event: ANSWER
CEL Tracking Event: APP_START
CEL Tracking Event: APP_END
CEL Tracking Event: BRIDGE_START
CEL Tracking Event: BRIDGE_END
CEL Tracking Event: CONF_START
CEL Tracking Event: CONF_END
CEL Tracking Event: PARK_START
CEL Tracking Event: PARK_END
CEL Tracking Event: BLINDTRANSFER
CEL Tracking Event: ATTENDEDTRANSFER
CEL Tracking Event: TRANSFER
CEL Tracking Event: HOOKFLASH
CEL Tracking Event: 3WAY_START
CEL Tracking Event: 3WAY_END
CEL Tracking Event: CONF_ENTER
CEL Tracking Event: CONF_EXIT
CEL Tracking Event: USER_DEFINED
CEL Tracking Event: LINKEDID_END
CEL Tracking Event: BRIDGE_UPDATE
CEL Tracking Event: PICKUP
CEL Tracking Event: FORWARD
CEL Tracking Application: all
CEL Event Subscriber: ODBC CEL backend
CEL Event Subscriber: CEL Custom CSV Logging
pbx00CLI> odbc show
ODBC DSN Settings
Name: asterisk
DSN: mysql-odbc
Last connection attempt: 1969-12-31 16:00:00
Pooled: No
Connected: Yes
pbx00*CLI> cdr mysql status
Connected to asterisk11cdrdb on socket file default using table cdr for 4 hours, 18 minutes, 3 seconds.
Wrote 465 records since last restart and 145 records since last reconnect.
CEL is working properly, local MySQL cel table exists and has data.
I’ve gone through all /etc/asterisk/cel* files, and made sure everything is set appropriately, along with /etc/odbc* and /etc/asterisk/res_odbc*.
Does anyone have any idea why the module fails to upgrade? Or where I can look next? I miss my CDR log, and I’d like it back.