store IKE and ESP proposals in SQL database

1 files changed, 32 insertions, 0 deletions

diff --git a/testing/tests/sql/net2net-route-pem/hosts/sun/etc/ipsec.d/data.sql b/testing/tests/sql/net2net-route-pem/hosts/sun/etc/ipsec.d/data.sql
index aeacf493f..2a7b7423e 100644
--- a/testing/tests/sql/net2net-route-pem/hosts/sun/etc/ipsec.d/data.sql
+++ b/testing/tests/sql/net2net-route-pem/hosts/sun/etc/ipsec.d/data.sql
@@ -100,6 +100,14 @@ INSERT INTO private_key_identity (
   1, 6 
 );
 
+/* Algorithms */
+
+INSERT INTO algorithms (
+  algorithm
+) VALUES (
+  'aes128-sha256-modp3072'
+);
+
 /* Configurations */
 
 INSERT INTO ike_configs (
@@ -108,6 +116,12 @@ INSERT INTO ike_configs (
   'PH_IP_SUN', 'PH_IP_MOON'
 );
 
+INSERT INTO ike_config_algorithm (
+  ike_cfg, prio, alg
+) VALUES (
+  1, 1, 1
+);
+
 INSERT INTO peer_configs (
   name, ike_cfg, local_id, remote_id, mobike, dpd_delay
 ) VALUES (
@@ -150,6 +164,24 @@ INSERT INTO peer_config_child_config (
   1, 3
 );
 
+INSERT INTO child_config_algorithm (
+  child_cfg, prio, alg
+) VALUES (
+  1, 1, 1
+);
+
+INSERT INTO child_config_algorithm (
+  child_cfg, prio, alg
+) VALUES (
+  2, 1, 1
+);
+
+INSERT INTO child_config_algorithm (
+  child_cfg, prio, alg
+) VALUES (
+  3, 1, 1
+);
+
 INSERT INTO traffic_selectors (
   type, start_addr, end_addr
 ) VALUES (