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.
...
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