From mrdrheath@gmail.com Tue May 22 12:55:35 2018
From: David Heath <mrdrheath@gmail.com>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] htable - unable to update entry when
 event_route[htable:expired:<table>] is executed
Date: Tue, 22 May 2018 10:55:23 +0000
Message-ID: <AM5P18901MB00838450BE8B1DD1C9C97514A4940@AM5P18901MB0083.EURP189.PROD.OUTLOOK.COM>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0903506393=="

--===============0903506393==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi,

Looking for some help/ advice on updating the expiration timer/ values in a h=
ash table when when [htable:expired:<table>] occurs.

On startup my script successfully reads in a set of entries from a DB; I also=
 know from testing/ tracing that I can add new entries to the hash table in r=
equest_route.  My issue occurs when the expiration timer kicks in - my goal w=
as to re-read from the DB to ensure either the entry still exists or hasn=E2=
=80=99t changed and either delete, update or refresh the value until the next=
 time the expiration event occurs.  This way entries in the DB could be modif=
ied overtime.

At the moment all that=E2=80=99s occurring is that in the event_route[htable:=
expired:cli] block the entries are being drained one-by-one.  I re-read the r=
ow from the from the DB and I reset the value using $sht(cli=3D>$shtrecord(ke=
y)) =3D $xavp(cli=3D>MAPPED_CLI); I=E2=80=99ve also tried updating the expira=
tion timer against the key.  I=E2=80=99ve tried both $shtex(cli=3D>$shtrecord=
(key)) =3D 60 and $shtex(cli=3D>$shtrecord(key)) =3D $TS+60 [the latter based=
 on the values shown from sht_print()]  but the entries still get deleted.

I=E2=80=99ve tried this against both 5.1.0 & 5.1.2.

Any help appreciated.


Thanks
David Heath




--===============0903506393==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PCEtLSBUaGlzIGZpbGUgaGFzIGJlZW4gYXV0b21hdGljYWxseSBnZW5lcmF0ZWQuIFNlZSB3ZWIv
UkVBRE1FLm1kIC0tPgo8aHRtbD4KPGhlYWQ+CjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlw
ZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PVdpbmRvd3MtMTI1MiI+CjwvaGVhZD4KPGJv
ZHk+CjxkaXYgaWQ9ImNvbXBvc2UtY29udGFpbmVyIiBzdHlsZT0iZGlyZWN0aW9uOiBsdHIiIGl0
ZW1zY29wZT0iIiBpdGVtdHlwZT0iaHR0cHM6Ly9zY2hlbWEub3JnL0VtYWlsTWVzc2FnZSI+Cjxz
cGFuIGl0ZW1wcm9wPSJjcmVhdG9yIiBpdGVtc2NvcGU9IiIgaXRlbXR5cGU9Imh0dHBzOi8vc2No
ZW1hLm9yZy9Pcmdhbml6YXRpb24iPjxzcGFuIGl0ZW1wcm9wPSJuYW1lIiBjb250ZW50PSJPdXRs
b29rIE1vYmlsZSBmb3IgaU9TIj48L3NwYW4+PC9zcGFuPgo8ZGl2Pgo8ZGl2IHN0eWxlPSJkaXJl
Y3Rpb246IGx0cjsiPkhpLDwvZGl2Pgo8ZGl2Pjxicj4KPC9kaXY+CjxkaXYgc3R5bGU9ImRpcmVj
dGlvbjogbHRyOyI+TG9va2luZyBmb3Igc29tZSBoZWxwLyBhZHZpY2Ugb24gdXBkYXRpbmcgdGhl
IGV4cGlyYXRpb24gdGltZXIvIHZhbHVlcyBpbiBhIGhhc2ggdGFibGUgd2hlbiB3aGVuIFtodGFi
bGU6ZXhwaXJlZDombHQ7dGFibGUmZ3Q7XSBvY2N1cnMuPC9kaXY+CjxkaXY+PGJyPgo8L2Rpdj4K
PGRpdiBzdHlsZT0iZGlyZWN0aW9uOiBsdHI7Ij5PbiBzdGFydHVwIG15IHNjcmlwdCBzdWNjZXNz
ZnVsbHkgcmVhZHMgaW4gYSBzZXQgb2YgZW50cmllcyBmcm9tIGEgREI7IEkgYWxzbyBrbm93IGZy
b20gdGVzdGluZy8gdHJhY2luZyB0aGF0IEkgY2FuIGFkZCBuZXcgZW50cmllcyB0byB0aGUgaGFz
aCB0YWJsZSBpbiByZXF1ZXN0X3JvdXRlLiAmbmJzcDtNeSBpc3N1ZSBvY2N1cnMgd2hlbiB0aGUg
ZXhwaXJhdGlvbiB0aW1lciBraWNrcyBpbiAtIG15IGdvYWwKIHdhcyB0byByZS1yZWFkIGZyb20g
dGhlIERCIHRvIGVuc3VyZSBlaXRoZXIgdGhlIGVudHJ5IHN0aWxsIGV4aXN0cyBvciBoYXNuknQg
Y2hhbmdlZCBhbmQgZWl0aGVyIGRlbGV0ZSwgdXBkYXRlIG9yIHJlZnJlc2ggdGhlIHZhbHVlIHVu
dGlsIHRoZSBuZXh0IHRpbWUgdGhlIGV4cGlyYXRpb24gZXZlbnQgb2NjdXJzLiAmbmJzcDtUaGlz
IHdheSBlbnRyaWVzIGluIHRoZSBEQiBjb3VsZCBiZSBtb2RpZmllZCBvdmVydGltZS48L2Rpdj4K
PGRpdj48YnI+CjwvZGl2Pgo8ZGl2IHN0eWxlPSJkaXJlY3Rpb246IGx0cjsiPkF0IHRoZSBtb21l
bnQgYWxsIHRoYXSScyBvY2N1cnJpbmcgaXMgdGhhdCBpbiB0aGUgZXZlbnRfcm91dGVbaHRhYmxl
OmV4cGlyZWQ6Y2xpXSBibG9jayB0aGUgZW50cmllcyBhcmUgYmVpbmcgZHJhaW5lZCBvbmUtYnkt
b25lLiAmbmJzcDtJIHJlLXJlYWQgdGhlIHJvdyBmcm9tIHRoZSBmcm9tIHRoZSBEQiBhbmQgSSBy
ZXNldCB0aGUgdmFsdWUgdXNpbmcgJHNodChjbGk9Jmd0OyRzaHRyZWNvcmQoa2V5KSkgPSAkeGF2
cChjbGk9Jmd0O01BUFBFRF9DTEkpOwogSZJ2ZSBhbHNvIHRyaWVkIHVwZGF0aW5nIHRoZSBleHBp
cmF0aW9uIHRpbWVyIGFnYWluc3QgdGhlIGtleS4gJm5ic3A7SZJ2ZSB0cmllZCBib3RoICRzaHRl
eChjbGk9Jmd0OyRzaHRyZWNvcmQoa2V5KSkgPSA2MCBhbmQgJHNodGV4KGNsaT0mZ3Q7JHNodHJl
Y29yZChrZXkpKSA9ICRUUyYjNDM7NjAgW3RoZSBsYXR0ZXIgYmFzZWQgb24gdGhlIHZhbHVlcyBz
aG93biBmcm9tIHNodF9wcmludCgpXSAmbmJzcDtidXQgdGhlIGVudHJpZXMgc3RpbGwgZ2V0IGRl
bGV0ZWQuPC9kaXY+CjxkaXY+PGJyPgo8L2Rpdj4KPGRpdiBzdHlsZT0iZGlyZWN0aW9uOiBsdHI7
Ij5JknZlIHRyaWVkIHRoaXMgYWdhaW5zdCBib3RoIDUuMS4wICZhbXA7IDUuMS4yLjwvZGl2Pgo8
ZGl2Pjxicj4KPC9kaXY+CjxkaXYgc3R5bGU9ImRpcmVjdGlvbjogbHRyOyI+QW55IGhlbHAgYXBw
cmVjaWF0ZWQuPC9kaXY+CjxkaXY+PGJyPgo8L2Rpdj4KPGRpdj48YnI+CjwvZGl2Pgo8ZGl2IHN0
eWxlPSJkaXJlY3Rpb246IGx0cjsiPlRoYW5rczwvZGl2Pgo8ZGl2IHN0eWxlPSJkaXJlY3Rpb246
IGx0cjsiPkRhdmlkIEhlYXRoPC9kaXY+CjxkaXY+PGJyPgo8L2Rpdj4KPC9kaXY+CjwvZGl2Pgo8
L2JvZHk+CjwvaHRtbD4K

--===============0903506393==--