/
Microsoft SQL Server

Microsoft SQL Server

 

XCALLY section

Plugins → Microsoft SQL server

On this page

 

 

Overview

This plugin is built to connect XCALLY server to an external Microsoft SQL server using the Sql authentication method.

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

Installation

To install the plugin:

  1. Download the below zip archive

  1. Upload the zip archive through the admin interface on XCALLY Motion V3, from the AppZone → Plugins section.

  2. After the upload is complete, you can find the plugin row. Click on the three dots button menu and select Install plugin.

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

  1. Add a REST-API block in your Cally Square project, and fill it as the following (write the query with your values) 

5. Restart Motion service (from root) during offline hours to get it working.

# systemctl restart motion

Debugging and 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