Microsoft SQL Server

Owned by XCALLY Knowledge (Unlicensed)
Last updated: May 17, 2023
2 min read


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.

 

  • 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