This plugin is built to connect XCALLY server to an external Microsoft SQL server using the Sql authentication method, please notice that Microsoft SQL and its configuration is not part of our product and support, check the official online wiki in order to configure it properly.
Download and Install this plugin and click on the image to download:
After installing the plugin edit the config.json in the following path in order to properly match your Microsoft sql server:
/var/opt/motion2/server/files/plugins/sqlserver-plugin-<many-numbers>/sqlserver-plugin/server
in order to get it working just add a REST-API block in your Cally Square, and fill it as the following (write the query with your values)
Finally restart Motion service (from root) during offline hours to get it working.
# systemctl restart motion
TROUBLESHOOTING:
· You can check if the plugin is working by issuing “pm2 list” with motion user
· All the logs are written in var/log/xcally/sqlserver-plugin-plugin.pm2.log while errors are written in var/log/xcally/sqlserver-plugin-plugin.error.pm2.log, you can also follow its tail in the Linux CLI with motion user: pm2 logs sqlserver-plugin
· In order to debug any issue with the rest-api block you can enable the AGI debug from the Asterisk CLI:
Asterisk*CLI> agi set debug on