/LESK-Module_SQLUtils

:package: Module for LESK providing a set of utility functions and classes to help interact with SQL Servers.

Primary LanguagePHPGNU General Public License v3.0GPL-3.0

SQLUtils module

To deploy simply clone the repository into the Modules directory from the base or root LESK install, as shown below:

$ cd <MySuperProjectBasedOnLESK>
$ git clone https://github.com/leskhq/LESK-Module_SQLUtils app/Modules/SQLUtils

Then make sure to optimize the master module definition, from the base directory, with:

$ ./artisan module:optimize

Dependencies

None.

Prerequisites

  • A driver or library must be installed and configured on the system to allow communications with the SQL server of choice. In the case where FreeTDS is selected, a sample configuration file is provided in the misc/ directory to set the protocol version to 7.3. Follow these instructions to backup your existing configuration and copy the one provided:
$ sudo cp /etc/freetds.conf /etc/freetds.conf.org
$ sudo cp app/Modules/SQLUtils/misc/freetds.conf /etc/freetds.conf

Installing and activating

Once a new module is detected by the framework, a site administrator can go to the "Modules administration" page and first initialize the module, then enable it for all authorized users to have access.