This plugin is built to connect XCALLY server to an external Microsoft SQL server using the Sql authentication method, please . 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 pluginand click on the image to download:
| View file | ||
|---|---|---|
|
...
...
After installing the plugin edit the config.json in the following path in order to properly match your Microsoft sql SQL server:
/var/opt/motion2/server/files/plugins/sqlserver-plugin-<many-numbers>/sqlserver-plugin/server
...
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