MCSQL (MultiCS+SQL)

What is mcsql?
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.
GENERAL OPTIONS (/var/mcsql/mcsql.cfg)
HTTP PORT: <port value>
Listening port for HTTP server
MYSQL SERVER: <mysqlserver ip/host>
Mysql hostname
MYSQL USERNAME: <username>
Mysql connection
MYSQL PASSWORD: <passsword>
Mysql connection
MYSQL DATABASE: <database>
Mysql database name
FILE IP2COUNTRY: <path>
load ipcountry data from csv file
INSTALLATION ON UBUNTU 18.04 (x86_64)
Install Mysql Server
Ubuntu 18.04 (x86_64)
apt-get update
apt install mysql-server libmysqlclient20
Download and Extract files
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
Edit Config (/var/mcsql/mcsql.cfg)
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
Execution
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
Preview
Screenshots