[Spce-user] Extend Database field for caller pattern and callee pattern

[Hohl Matthias]

Thanks Andrew for your answer…

I will try it in the next few days.

 

Just for Information:

For EEA and nonEEA routing  I need to extend this pattern to 3.328 signs.

The needed outbound peering rules pattern for caller/callee looks like this:

 

^sips?:(43|351|32|359|34|385|357|420|45|372|358|33|594|30|590|36|354|353|39|370|371|352|351|356|596|262|47|48|351|262|40|1721|421|3861|3862|3863|3865|3866|3867|3868|3869|38640|38641|38642|38644|38645|38646|38647|38648|34|46|44|379|86|49|852|423|31|1787|1939|65|1684|376|244|54|61|1242|973|880|229|1441|975|591|267|55|673|855|1345|56|57|506|1809|1829|1849|593|20|298|679|350|1671|502|504|91|62|98|964|972|1876|81|962|77|254|82|965|996|856|961|853|60|230|52|691|976|264|977|599|687|64|234|92|970|507|595|51|63|974|7|966|27|94|249|268|41|963|886|992|66|90|993|971|598|1340|998|58|84|967|1150|1177|1186|1200|1201|1202|1203|1204|1205|1206|1207|1208|1209|1210|1212|1213|1214|1215|1216|1217|1218|1219|1220|1221|1223|1224|1225|1226|1227|1228|1229|1231|1232|1234|1235|1236|1237|1239|1240|1243|1247|1248|1249|1250|1251|1252|1253|1254|1256|1258|1260|1261|1262|1267|1269|1270|1271|1272|1274|1275|1276|1278|1280|1281|1282|1283|1285|1286|1287|1289|1301|1302|1303|1304|1305|1306|1307|1308|1309|1310|1312|1313|1314|1315|1316|1317|1318|1319|1320|1321|1323|1324|1325|1326|1327|1328|1330|1331|1332|1334|1335|1336|1337|1338|1339|1341|1347|1348|1350|1351|1352|1353|1354|1356|1358|1360|1361|1363|1364|1365|1369|1380|1381|1383|1384|1385|1386|1389|1400|1401|1402|1403|1404|1405|1406|1407|1408|1409|1410|1411|1412|1413|1414|1415|1416|1417|1418|1419|1421|1423|1424|1425|1426|1429|1430|1431|1432|1434|1435|1437|1438|1439|1440|1442|1443|1445|1446|1447|1448|1449|1450|1456|1458|1459|1461|1463|1464|1465|1469|1470|1475|1478|1479|1480|1481|1482|1483|1484|1486|1500|1501|1502|1503|1504|1505|1506|1507|1508|1509|1510|1512|1513|1514|1515|1516|1517|1518|1520|1530|1531|1532|1533|1534|1535|1536|1538|1539|1540|1541|1542|1544|1545|1547|1548|1550|1551|1552|1553|1554|1556|1557|1558|1559|1560|1561|1562|1563|1564|1565|1566|1567|1570|1571|1572|1573|1574|1575|1577|1578|1579|1580|1581|1582|1583|1584|1585|1586|1587|1588|1589|1600|1601|1602|1603|1604|1605|1606|1607|1608|1609|1610|1611|1612|1613|1614|1615|1616|1617|1618|1619|1620|1621|1623|1624|1626|1627|1628|1630|1631|1636|1639|1640|1641|1646|1647|1648|1650|1651|1654|1656|1657|1659|1660|1661|1662|1663|1665|1667|1668|1669|1672|1673|1676|1678|1679|1680|1681|1682|1686|1689|1700|1701|1702|1703|1704|1706|1707|1708|1709|1710|1711|1712|1713|1714|1715|1716|1717|1718|1719|1720|1724|1726|1727|1730|1731|1732|1734|1736|1737|1740|1741|1743|1745|1746|1747|1749|1750|1751|1752|1754|1756|1757|1760|1761|1762|1763|1764|1765|1768|1769|1770|1772|1773|1774|1775|1776|1777|1778|1779|1780|1781|1785|1786|1789|1800|1801|1802|1803|1804|1805|1806|1810|1812|1813|1814|1815|1816|1817|1818|1819|1820|1821|1822|1823|1824|1826|1827|1828|1830|1831|1832|1833|1834|1835|1838|1839|1840|1843|1844|1845|1846|1847|1848|1850|1853|1855|1856|1857|1858|1859|1860|1861|1862|1863|1864|1865|1866|1870|1872|1873|1877|1878|1880|1881|1882|1883|1884|1885|1886|1887|1888|1889|1900|1901|1902|1903|1904|1905|1906|1908|1909|1910|1912|1913|1914|1915|1916|1917|1918|1919|1920|1921|1924|1925|1928|1929|1930|1931|1932|1935|1936|1937|1938|1940|1941|1943|1945|1946|1947|1948|1949|1951|1952|1953|1954|1956|1957|1958|1959|1970|1971|1972|1973|1974|1975|1978|1979|1980|1981|1982|1983|1984|1985|1986|1987|1989|1981|1982|1983|1984|1985|1986|1987|1989).+$

 

I hope this will not increase the load too much…

 

Von: Andrew Pogrebennyk [mailto:apogrebennyk at sipwise.com] 
Gesendet: Montag, 5. März 2018 17:37
An: Hohl Matthias <matthias.hohl at telematica.at>; 'Spce-user' <Spce-user at lists.sipwise.com>
Betreff: Re: [Spce-user] Extend Database field for caller pattern and callee pattern

 

Hi Matthias,
I quickly grep'ed the kamailio code and it should not harm from my point of view, if you increase the length of mentioned provisioning.voip_peer_rules columns as well as kamailio.lcr_rules from_uri and request_uri, but still better to test it before on non-production system.

Andrew

On 03/05/2018 05:30 PM, Hohl Matthias wrote:

Nobody?

 

Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von Hohl Matthias
Gesendet: Samstag, 24. Februar 2018 17:23
An: 'Spce-user'  <mailto:Spce-user at lists.sipwise.com> <Spce-user at lists.sipwise.com>
Betreff: Re: [Spce-user] Extend Database field for caller pattern and callee pattern

 

Hey,

 

does anybody have a qualified answer for me?

Can I increase the db field without harming anything else?

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20180305/e514d35c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5532 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20180305/e514d35c/attachment-0001.p7s>