Settings
Steps:
- Place JDBC driver (jar file) under the directory: <pbx-installdir>/webapps/pbx/WEB-INF/lib/
- Use the settings below in Brekeke PBX Admintool > [Options] > [Advanced].
- Restart Brekeke PBX to activate the settings.
Setting Example
com.brekeke.pbx.pbxplugin=com.brekeke.cti.logging.type3.LoggingPluginType3, com.brekeke.pbxconsole.StatusBoard cti.logging.type3.missedlog.all=true cti.logging.type3.phoneid=true cti.logging.type3.real_number=true cti.logging.type3.pbxid=true cti.logging.type3.user=<database user> cti.logging.type3.password=<database password> cti.logging.type3.driver=com.mysql.jdbc.Driver cti.logging.type3.url=jdbc:mysql://<database-hostname>/<database name>?useUnicode=true&characterEncoding=UTF8&autoReconnect=true
Properties
com.brekeke.pbx.pbxplugin
com.brekeke.cti.logging.type3.LoggingPluginType3, com.brekeke.pbxconsole.StatusBoard
This property is necessary to export a log using the method described in this document.
cti.logging.type3.calllog
When set to false, log will not be exported to t_pba_call_log. Default is set to true.
cti.logging.type3.driver
JDBC driver name for connecting database.
cti.logging.type3.instanceid
When set to true, c_instanceid column in t_pbx_ua_log will be used. Default is set to false.
Please set true when cti.logging.type3.pbxid is set to true. (available on version 3.6 or later)
cti.logging.type3.missedlog.all
Set whether the log for incomplete calls will be exported. Default is set to true.
cti.logging.type3.missedlog.ars
Set a route name using a regular expression. Incomplete calls for the specified route will be included in the log export. This property should be used when cti.logging.type3.missedlog.all is set to false.
This setting overrides the settings at:
cti.logging.type3.missedlog.user.in and cti.logging.type3.missedlog.user.out
cti.logging.type3.missedlog.user.in
Set one or a group of user names using a regular expression. Incomplete calls initialized from the particular user(s) will be included in the call log export.
This property should be used when cti.logging.type3.missedlog.all is set to false.
cti.logging.type3.missedlog.user.out
Set one or a group of user names using a regular expression. Incomplete calls sent to the particular user(s) will be included in the call log export.
This property should be used when cti.logging.type3.missedlog.all is set to false.
cti.logging.type3.password
Password for connecting database.
cti.logging.type3.pbxid
When set to false, ID(c_id, c_seq) will be generated and room ID and talker ID are not used. This property is only for compatibility with older version. Please do not set this property unless necessary.
From Brekeke PBX v3.3 or later, the default value is set to true.
cti.logging.type3.phoneid
Set whether the phone number used by UAs will be exported. Default is set to false.
cti.logging.type3.pstn.length
The minimum string length recognized as external PSTN phone numbers. This property is used for setting c_main_seq at t_pbx_call_log. Default value is set to 10.
cti.logging.type3.q850code
When set to true, c_q850code column in t_pbx_ua_log will be used. Default is set to false.
cti.logging.type3.real_number
Set whether real numbers in incoming or outgoing sessions will be exported to table t_pbx_ua_log column c_real_number and c_real_pbx_number. Default is set to false.
cti.logging.type3.rescode
When set to true, c_rescode column in t_pbx_ua_log will be used. Default is set to false.
cti.logging.type3.tag
When set to true, c_tag column in t_pbx_ua_log will be used. Default is set to false. (available on version 3.6 or later)
cti.logging.type3.ualog
When set to false, log will not be exported to t_pbx_ua_log table. Default is set to true.
cti.logging.type3.url
URL for connecting database.
cti.logging.type3.user
User name for connecting database.