[sr-dev] git:master:b5cf0796: Merge pull request #2879 from ErhanOnur/fix_ims_usrloc_pcscf_protocol

[GitHub]

Module: kamailio
Branch: master
Commit: b5cf0796ffc308fdd8bf63d1f446608d63c7cac9
URL: https://github.com/kamailio/kamailio/commit/b5cf0796ffc308fdd8bf63d1f446608d63c7cac9

Author: carstenbock <carsten at ng-voice.com>
Committer: GitHub <noreply at github.com>
Date: 2021-11-19T10:26:20+01:00

Merge pull request #2879 from ErhanOnur/fix_ims_usrloc_pcscf_protocol

ims_usrloc_pcscf:  fix on saving protocol info into DB

---

Modified: src/modules/ims_usrloc_pcscf/usrloc_db.c
Modified: utils/kamctl/mysql/ims_usrloc_pcscf-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/b5cf0796ffc308fdd8bf63d1f446608d63c7cac9.diff
Patch: https://github.com/kamailio/kamailio/commit/b5cf0796ffc308fdd8bf63d1f446608d63c7cac9.patch

---

diff --git a/src/modules/ims_usrloc_pcscf/usrloc_db.c b/src/modules/ims_usrloc_pcscf/usrloc_db.c
index ca57a2b4b3..5f0df126fa 100644
--- a/src/modules/ims_usrloc_pcscf/usrloc_db.c
+++ b/src/modules/ims_usrloc_pcscf/usrloc_db.c
@@ -341,7 +341,7 @@ int db_insert_pcontact(struct pcontact* _c)
 		return -1;
 	}
 
-	if (ul_dbf.insert(ul_dbh, keys, values, 15) < 0) {
+	if (ul_dbf.insert(ul_dbh, keys, values, 16) < 0) {
 		LM_ERR("inserting contact in db failed\n");
 		return -1;
 	}
diff --git a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
index cf978df1f5..2a18c59601 100644
--- a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
+++ b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
@@ -17,7 +17,7 @@ CREATE TABLE `location` (
   `socket` varchar(64) DEFAULT NULL,
   `public_ids` varchar(2048) DEFAULT NULL,
   `security_type` int(11) DEFAULT NULL,
-  `protocol` char(5) DEFAULT NULL,
+  `protocol` int(10) DEFAULT NULL,
   `mode` char(10) DEFAULT NULL,
   `ck` varchar(100) DEFAULT NULL,
   `ik` varchar(100) DEFAULT NULL,