MCSql is Multi-CardServer with 
 - SQL database
 - Control Panel with multi-level sub-reseller system and unlimited slaves (standalone servers).
 - Unlimited multi user connections with different protocols.
 - Separated cache-ex data from csp-cache.
 - Embedded Three CW-filters in cache-ex, csp-cache and ecm/cw core handler.
 - Optimized cache, cacheex, camd35 server and ecm/cw core handler.
 * This software does not contain any encryption algorithms or key materials for any dvb operator.

History log:
 [10.06.2020] r44
	- avoid sending disabled profiles to connected clients
	- fixed client connection/disconnection to multiple slaves
	- profile: added check CRC option
	- cache/ex: fixed blocked half nulled replies of tunneled ndz cards

Listening port for HTTP server

Mysql hostname

Mysql connection

Mysql connection

Mysql database name

load ipcountry data from csv file

Ubuntu 18.04 (x86_64)

apt-get update
apt install mysql-server libmysqlclient20

wget -O /usr/local/bin/mcsql http://infosat.org/mcsql/files/mcsql
chmod +x /usr/local/bin/mcsql
wget -O /usr/local/bin/slave http://infosat.org/mcsql/files/slave
chmod +x /usr/local/bin/slave
mkdir /var/mcsql
cd /var/mcsql
wget http://infosat.org/mcsql/files/mcsql-data.tgz
tar -xzf mcsql-data.tgz

Setup your MYSQL server parameters: server, database, username and password
Installation will fail if you dont put the right password for mysql server knowing that most of users do

MYSQL SERVER: localhost
MYSQL USERNAME: *** MYSQL USERNAME ***
MYSQL PASSWORD: *** MYSQL PASSWORD ***
MYSQL DATABASE: mcsql

Execute Main (use library 'libmysqlclient.so.20')

mcsql

Open now your browser and enter the server url where mcsql is hosted with the port of http server (ex: http://localhost:5500)

default login user: admin
default login pass: admin

Execute Slave Server ( slave <control_port> )
example control port is 2738

slave 2738

OR show all debug info

slave -vall 2738