Registrations table

inside asteriskcdrdb there is a registrations tables
and it has some Reachable/Unreachable data

| 335 | Stephanie Soto | Reachable | 2024-01-21 23:02:31 |
| 335 | Stephanie Soto | Reachable | 2024-01-21 23:03:02 |
| 335 | Stephanie Soto | Reachable | 2024-01-21 23:03:32 |
| 335 | Stephanie Soto | Reachable | 2024-01-21 23:04:01 |
| 335 | Stephanie Soto | Reachable | 2024-01-21 23:04:31 |
| 335 | Stephanie Soto | Reachable | 2024-01-21 23:05:02 |
| 335 | Stephanie Soto | Reachable | 2024-01-21 23:05:32 |
±----±---------------±----------±----------------------+
1303 rows in set (4.58 sec)

but when I check logs

/var/log/asterisk/full-20240122:[2024-01-21 07:00:08] VERBOSE[21882] res_pjsip/pjsip_configuration.c: Endpoint 335 is now Reachable
/var/log/asterisk/full-20240122:[2024-01-21 07:00:08] VERBOSE[21882] res_pjsip/pjsip_options.c: Contact 335/sip:[email protected]:55290;transport=TCP;x-ast-orig-host=10.0.0.88:5057 is now Reachable. RTT: 93.559 msec
/var/log/asterisk/full-20240122:[2024-01-21 14:41:56] VERBOSE[47740] res_pjsip/pjsip_configuration.c: Endpoint 335 is now Unreachable
/var/log/asterisk/full-20240122:[2024-01-21 19:55:57] VERBOSE[47740] res_pjsip/pjsip_configuration.c: Endpoint 335 is now Reachable
/var/log/asterisk/full-20240122:[2024-01-21 19:55:57] VERBOSE[47740] res_pjsip/pjsip_options.c: Contact 335/sip:[email protected]:60948;transport=TCP;x-ast-orig-host=10.0.0.88:5057 is now Reachable. RTT: 93.870 msec
/var/log/asterisk/full-20240122:[2024-01-21 23:05:59] VERBOSE[47740] res_pjsip/pjsip_configuration.c: Endpoint 335 is now Unreachable
[root@pbx ~]#

so there data is not the same
2024-01-21 23:05:59 - 335 is now Unreachable from Logs biut. not in the registrations table

so I’m wondering how registrations table works

What select clause did you use to get that result set from asteriskcdrd ?

I’ve never seen a registrations table in asteriskcdrdb. Just cel and cdr in my database.

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.