[sr-dev] git:master:4decc7ca: lib/srdb1/schema: use proto_addr_len from sip_trace from/to ip fields

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2021-08-23T20:46:12+02:00

lib/srdb1/schema: use proto_addr_len from sip_trace from/to ip fields

- size of fields is now 64
- they store proto:addr:port
- GH #2831

---

Modified: src/lib/srdb1/schema/entities.xml
Modified: src/lib/srdb1/schema/sip_trace.xml

---

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

---

diff --git a/src/lib/srdb1/schema/entities.xml b/src/lib/srdb1/schema/entities.xml
index 4ca1b6bfed..8021e8e738 100644
--- a/src/lib/srdb1/schema/entities.xml
+++ b/src/lib/srdb1/schema/entities.xml
@@ -30,6 +30,7 @@
 <!ENTITY etag_len "128">
 <!ENTITY aname_len "64">
 <!ENTITY avalue_len "512">
+<!ENTITY proto_addr_len "64">
 <!ENTITY MYSQL_TABLE_TYPE "">
 <!ENTITY USERCOL "username">
 <!ENTITY DEFAULT_ALIASES_EXPIRES "2030-05-28 21:32:15">
diff --git a/src/lib/srdb1/schema/sip_trace.xml b/src/lib/srdb1/schema/sip_trace.xml
index 5aa38369fd..21b4f0ef61 100644
--- a/src/lib/srdb1/schema/sip_trace.xml
+++ b/src/lib/srdb1/schema/sip_trace.xml
@@ -91,7 +91,7 @@
     <column id="fromip">
         <name>fromip</name>
         <type>string</type>
-        <size>&ip_add_len;</size>
+        <size>&proto_addr_len;</size>
         <default/>
         <description>Source IP address</description>
     </column>
@@ -99,7 +99,7 @@
     <column>
         <name>toip</name>
         <type>string</type>
-        <size>&ip_add_len;</size>
+        <size>&proto_addr_len;</size>
         <default/>
         <description>Destination IP address</description>
     </column>