no db query after the expires

[jehanzaib_kiani]

Hi there,

something i have noticed that the first registration goes fine, but after the expires my soft phone sends the re-registration to yate but i get Not Found.
i am using [user.auth] , [user.register] and [user.unregister] from DB. it works fine when i register first time i have 60 seconds expire time set on my softphone but after this expire my softphone sends the re-register request to yate but the yate response is Not found. It does not happen when i use regfile

any idea please thanks

[Monica Tepelus]

Hi,

Can you please post a log with sniffer activated?

[jehanzaib_kiani]

Please see the attached logs
thanks

[paulc]

Hi!

The register module expects that the UPDATE affects some rows in the database. For MySQL an identical update returns zero affected rows.

Your user.register query seems incorrect, the `expires` column in the database should hold the absolute expire time not the expire interval:

  UPDATE sip_users SET fullcontact='sip/sip:100@xx.xx.xx.xx:9388',expires='60' WHERE username='100'

For MySQL your queries should probably look like:

  [user.register]
  query=UPDATE users SET fullcontact='${data}',expires=DATE_ADD(NOW(), INTERVAL ${expires} SECOND) WHERE username='${username}'
  
  [engine.timer]
  query=UPDATE users SET fullcontact=NULL,expires=NULL WHERE expires IS NOT NULL AND expires<=NOW()

[jehanzaib_kiani]

woo i think we nailed it
all good much appreciated.