IPSec configurations

#/etc/ipsec.conf file
config setup
    charondebug="ike 1, knl 1, cfg 0"
    uniqueids=no

conn ikev2-vpn
    auto=add
    compress=yes
    type=tunnel
    keyexchange=ikev2
    fragmentation=yes
    forceencaps=yes
    ike=aes256-sha1-modp1024,3des-sha1-modp1024!
    esp=aes256-sha1,3des-sha1!
    dpdaction=clear
    dpddelay=3600s
    rekey=no
    left=%any
    leftid=13.59.23.146
    leftcert=vpn-server-cert.pem
    leftsendcert=always
    leftsubnet=0.0.0.0/0
    right=%any
    rightid=%any
    rightauth=eap-mschapv2
    rightdns=8.8.8.8,8.8.4.4
    rightsourceip=10.10.10.0/24
    rightsendcert=never
    eap_identity=%identity


#/etc/ipsec.secrets file
# ipsec.secrets - strongSwan IPsec secrets file
: RSA vpn-server-key.pem
#arav %any : EAP "sunshine3003"
# when i uncomment the above line,
#it works. but i need to make it work with MySQL



#/etc/strongswan.d/charon/sql.conf file
sql {
    load = yes
    database = mysql://root:MajekO12#@localhost/ipsec
}





MySQL entries:
INSERT INTO identities (type, data) VALUES (2, X'61726176');
INSERT INTO shared_secrets (type, data) VALUES (2, X'73756e7368696e6533303033');
INSERT INTO shared_secret_identity (shared_secret, identity) VALUES (1, 1);

EAP username: arav
Password: sunshine3003









MySQL dump:
-- MySQL dump 10.13  Distrib 5.7.19, for Linux (x86_64)
--
-- Host: localhost    Database: ipsec
-- ------------------------------------------------------
-- Server version       5.7.19

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `addresses`
--

DROP TABLE IF EXISTS `addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pool` int(10) unsigned NOT NULL,
  `address` varbinary(16) NOT NULL,
  `identity` int(10) unsigned NOT NULL DEFAULT '0',
  `acquired` int(10) unsigned NOT NULL DEFAULT '0',
  `released` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `pool` (`pool`),
  KEY `identity` (`identity`),
  KEY `address` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `addresses`
--

LOCK TABLES `addresses` WRITE;
/*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
/*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attribute_pools`
--

DROP TABLE IF EXISTS `attribute_pools`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attribute_pools` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attribute_pools`
--

LOCK TABLES `attribute_pools` WRITE;
/*!40000 ALTER TABLE `attribute_pools` DISABLE KEYS */;
/*!40000 ALTER TABLE `attribute_pools` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attributes`
--

DROP TABLE IF EXISTS `attributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attributes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `identity` int(10) unsigned NOT NULL DEFAULT '0',
  `pool` int(10) unsigned NOT NULL DEFAULT '0',
  `type` int(10) unsigned NOT NULL,
  `value` varbinary(16) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `identity` (`identity`),
  KEY `pool` (`pool`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attributes`
--

LOCK TABLES `attributes` WRITE;
/*!40000 ALTER TABLE `attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `attributes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `certificate_authorities`
--

DROP TABLE IF EXISTS `certificate_authorities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `certificate_authorities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `certificate` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `certificate_authorities`
--

LOCK TABLES `certificate_authorities` WRITE;
/*!40000 ALTER TABLE `certificate_authorities` DISABLE KEYS */;
/*!40000 ALTER TABLE `certificate_authorities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `certificate_distribution_points`
--

DROP TABLE IF EXISTS `certificate_distribution_points`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `certificate_distribution_points` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ca` int(10) unsigned NOT NULL,
  `type` tinyint(3) unsigned NOT NULL,
  `uri` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `certificate_distribution_points`
--

LOCK TABLES `certificate_distribution_points` WRITE;
/*!40000 ALTER TABLE `certificate_distribution_points` DISABLE KEYS */;
/*!40000 ALTER TABLE `certificate_distribution_points` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `certificate_identity`
--

DROP TABLE IF EXISTS `certificate_identity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `certificate_identity` (
  `certificate` int(10) unsigned NOT NULL,
  `identity` int(10) unsigned NOT NULL,
  PRIMARY KEY (`certificate`,`identity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `certificate_identity`
--

LOCK TABLES `certificate_identity` WRITE;
/*!40000 ALTER TABLE `certificate_identity` DISABLE KEYS */;
/*!40000 ALTER TABLE `certificate_identity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `certificates`
--

DROP TABLE IF EXISTS `certificates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `certificates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) unsigned NOT NULL,
  `keytype` tinyint(3) unsigned NOT NULL,
  `data` blob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `certificates`
--

LOCK TABLES `certificates` WRITE;
/*!40000 ALTER TABLE `certificates` DISABLE KEYS */;
/*!40000 ALTER TABLE `certificates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `child_config_proposal`
--

DROP TABLE IF EXISTS `child_config_proposal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `child_config_proposal` (
  `child_cfg` int(10) unsigned NOT NULL,
  `prio` smallint(5) unsigned NOT NULL,
  `prop` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `child_config_proposal`
--

LOCK TABLES `child_config_proposal` WRITE;
/*!40000 ALTER TABLE `child_config_proposal` DISABLE KEYS */;
/*!40000 ALTER TABLE `child_config_proposal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `child_config_traffic_selector`
--

DROP TABLE IF EXISTS `child_config_traffic_selector`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `child_config_traffic_selector` (
  `child_cfg` int(10) unsigned NOT NULL,
  `traffic_selector` int(10) unsigned NOT NULL,
  `kind` tinyint(3) unsigned NOT NULL,
  KEY `child_cfg` (`child_cfg`,`traffic_selector`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `child_config_traffic_selector`
--

LOCK TABLES `child_config_traffic_selector` WRITE;
/*!40000 ALTER TABLE `child_config_traffic_selector` DISABLE KEYS */;
/*!40000 ALTER TABLE `child_config_traffic_selector` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `child_configs`
--

DROP TABLE IF EXISTS `child_configs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `child_configs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `lifetime` mediumint(8) unsigned NOT NULL DEFAULT '1500',
  `rekeytime` mediumint(8) unsigned NOT NULL DEFAULT '1200',
  `jitter` mediumint(8) unsigned NOT NULL DEFAULT '60',
  `updown` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hostaccess` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mode` tinyint(4) unsigned NOT NULL DEFAULT '2',
  `start_action` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `dpd_action` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `close_action` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `ipcomp` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `reqid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `child_configs`
--

LOCK TABLES `child_configs` WRITE;
/*!40000 ALTER TABLE `child_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `child_configs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `identities`
--

DROP TABLE IF EXISTS `identities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `identities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) unsigned NOT NULL,
  `data` varbinary(64) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`,`data`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `identities`
--

LOCK TABLES `identities` WRITE;
/*!40000 ALTER TABLE `identities` DISABLE KEYS */;
INSERT INTO `identities` VALUES (1,2,'arav');
/*!40000 ALTER TABLE `identities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ike_config_proposal`
--

DROP TABLE IF EXISTS `ike_config_proposal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ike_config_proposal` (
  `ike_cfg` int(10) unsigned NOT NULL,
  `prio` smallint(5) unsigned NOT NULL,
  `prop` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ike_config_proposal`
--

LOCK TABLES `ike_config_proposal` WRITE;
/*!40000 ALTER TABLE `ike_config_proposal` DISABLE KEYS */;
/*!40000 ALTER TABLE `ike_config_proposal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ike_configs`
--

DROP TABLE IF EXISTS `ike_configs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ike_configs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `certreq` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `force_encap` tinyint(1) NOT NULL DEFAULT '0',
  `local` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `remote` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ike_configs`
--

LOCK TABLES `ike_configs` WRITE;
/*!40000 ALTER TABLE `ike_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `ike_configs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ike_sas`
--

DROP TABLE IF EXISTS `ike_sas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ike_sas` (
  `local_spi` varbinary(8) NOT NULL,
  `remote_spi` varbinary(8) NOT NULL,
  `id` int(10) unsigned NOT NULL,
  `initiator` tinyint(1) NOT NULL,
  `local_id_type` tinyint(3) NOT NULL,
  `local_id_data` varbinary(64) DEFAULT NULL,
  `remote_id_type` tinyint(3) NOT NULL,
  `remote_id_data` varbinary(64) DEFAULT NULL,
  `host_family` tinyint(3) NOT NULL,
  `local_host_data` varbinary(16) NOT NULL,
  `remote_host_data` varbinary(16) NOT NULL,
  `lastuse` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`local_spi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ike_sas`
--

LOCK TABLES `ike_sas` WRITE;
/*!40000 ALTER TABLE `ike_sas` DISABLE KEYS */;
/*!40000 ALTER TABLE `ike_sas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leases`
--

DROP TABLE IF EXISTS `leases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `address` int(10) unsigned NOT NULL,
  `identity` int(10) unsigned NOT NULL,
  `acquired` int(10) unsigned NOT NULL,
  `released` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leases`
--

LOCK TABLES `leases` WRITE;
/*!40000 ALTER TABLE `leases` DISABLE KEYS */;
/*!40000 ALTER TABLE `leases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `local_spi` varbinary(8) NOT NULL,
  `signal` tinyint(3) NOT NULL,
  `level` tinyint(3) NOT NULL,
  `msg` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logs`
--

LOCK TABLES `logs` WRITE;
/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `peer_config_child_config`
--

DROP TABLE IF EXISTS `peer_config_child_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `peer_config_child_config` (
  `peer_cfg` int(10) unsigned NOT NULL,
  `child_cfg` int(10) unsigned NOT NULL,
  PRIMARY KEY (`peer_cfg`,`child_cfg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `peer_config_child_config`
--

LOCK TABLES `peer_config_child_config` WRITE;
/*!40000 ALTER TABLE `peer_config_child_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `peer_config_child_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `peer_configs`
--

DROP TABLE IF EXISTS `peer_configs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `peer_configs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `ike_version` tinyint(3) unsigned NOT NULL DEFAULT '2',
  `ike_cfg` int(10) unsigned NOT NULL,
  `local_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `remote_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `cert_policy` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `uniqueid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `auth_method` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `eap_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `eap_vendor` smallint(5) unsigned NOT NULL DEFAULT '0',
  `keyingtries` tinyint(3) unsigned NOT NULL DEFAULT '3',
  `rekeytime` mediumint(8) unsigned NOT NULL DEFAULT '7200',
  `reauthtime` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `jitter` mediumint(8) unsigned NOT NULL DEFAULT '180',
  `overtime` mediumint(8) unsigned NOT NULL DEFAULT '300',
  `mobike` tinyint(1) NOT NULL DEFAULT '1',
  `dpd_delay` mediumint(8) unsigned NOT NULL DEFAULT '120',
  `virtual` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pool` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mediation` tinyint(1) NOT NULL DEFAULT '0',
  `mediated_by` int(10) unsigned NOT NULL DEFAULT '0',
  `peer_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `peer_configs`
--

LOCK TABLES `peer_configs` WRITE;
/*!40000 ALTER TABLE `peer_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `peer_configs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pools`
--

DROP TABLE IF EXISTS `pools`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pools` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `start` varbinary(16) NOT NULL,
  `end` varbinary(16) NOT NULL,
  `timeout` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pools`
--

LOCK TABLES `pools` WRITE;
/*!40000 ALTER TABLE `pools` DISABLE KEYS */;
/*!40000 ALTER TABLE `pools` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `private_key_identity`
--

DROP TABLE IF EXISTS `private_key_identity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `private_key_identity` (
  `private_key` int(10) unsigned NOT NULL,
  `identity` int(10) unsigned NOT NULL,
  PRIMARY KEY (`private_key`,`identity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `private_key_identity`
--

LOCK TABLES `private_key_identity` WRITE;
/*!40000 ALTER TABLE `private_key_identity` DISABLE KEYS */;
/*!40000 ALTER TABLE `private_key_identity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `private_keys`
--

DROP TABLE IF EXISTS `private_keys`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `private_keys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) unsigned NOT NULL,
  `data` blob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `private_keys`
--

LOCK TABLES `private_keys` WRITE;
/*!40000 ALTER TABLE `private_keys` DISABLE KEYS */;
/*!40000 ALTER TABLE `private_keys` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proposals`
--

DROP TABLE IF EXISTS `proposals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `proposals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `proposal` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proposals`
--

LOCK TABLES `proposals` WRITE;
/*!40000 ALTER TABLE `proposals` DISABLE KEYS */;
/*!40000 ALTER TABLE `proposals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shared_secret_identity`
--

DROP TABLE IF EXISTS `shared_secret_identity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shared_secret_identity` (
  `shared_secret` int(10) unsigned NOT NULL,
  `identity` int(10) unsigned NOT NULL,
  PRIMARY KEY (`shared_secret`,`identity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shared_secret_identity`
--

LOCK TABLES `shared_secret_identity` WRITE;
/*!40000 ALTER TABLE `shared_secret_identity` DISABLE KEYS */;
INSERT INTO `shared_secret_identity` VALUES (1,1);
/*!40000 ALTER TABLE `shared_secret_identity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shared_secrets`
--

DROP TABLE IF EXISTS `shared_secrets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shared_secrets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) unsigned NOT NULL,
  `data` varbinary(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shared_secrets`
--

LOCK TABLES `shared_secrets` WRITE;
/*!40000 ALTER TABLE `shared_secrets` DISABLE KEYS */;
INSERT INTO `shared_secrets` VALUES (1,2,'sunshine3003');
/*!40000 ALTER TABLE `shared_secrets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `traffic_selectors`
--

DROP TABLE IF EXISTS `traffic_selectors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `traffic_selectors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) unsigned NOT NULL DEFAULT '7',
  `protocol` smallint(5) unsigned NOT NULL DEFAULT '0',
  `start_addr` varbinary(16) DEFAULT NULL,
  `end_addr` varbinary(16) DEFAULT NULL,
  `start_port` smallint(5) unsigned NOT NULL DEFAULT '0',
  `end_port` smallint(5) unsigned NOT NULL DEFAULT '65535',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `traffic_selectors`
--

LOCK TABLES `traffic_selectors` WRITE;
/*!40000 ALTER TABLE `traffic_selectors` DISABLE KEYS */;
/*!40000 ALTER TABLE `traffic_selectors` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-08-08 11:40:26