search

OpenSIPS / opensips-cp

A Web Control Panel Application for the OpenSIPS, which is intended for both system and user provisioning. It features more than 18 tools, covering important functionalities (MI,statistics) and modules (acc,siptrace,drouting,dialplan) of OpenSIPS.
GNU General Public License v2.0
113 stars 78 forks source link

Opensips CP master branch has installation issue when importing db_schema.mysql (ocp_dashboard) #209

Closed Integration-IT closed 2 years ago

Integration-IT commented 2 years ago

Opensips CP master branch has installation issue when importing db_schema.mysql.

Documentation command will fail with Mysql error statement.

mysql -D opensips < /var/www/html/opensips-cp/config/db_schema.mysql

This version has pipe commands inside MYSQL schema and import goes into error

File opensips-cp/config/db_schema.mysql, line 101 and 108.

| ocp_dashboard | CREATE TABLE `ocp_dashboard` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  `content` text DEFAULT '',
  `order` int(11) DEFAULT NULL,
  `positions` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 |