Hmmm, but it gets updated :
MariaDB [asterisk]> select * from ps_contacts;
Empty set (0.00 sec)
MariaDB [asterisk]> select * from ps_contacts;
+-----------------------------------------+-----------------------------------------------------------------+-----------------+-------------------+----------------+------+---------------------------------------+-----------------+------------+----------------------+----------------------+----------+--------------------------------------+----------+---------------+
| id | uri | expiration_time | qualify_frequency | outbound_proxy | path | user_agent | qualify_timeout | reg_server | authenticate_qualify | via_addr | via_port | call_id | endpoint | prune_on_boot |
+-----------------------------------------+-----------------------------------------------------------------+-----------------+-------------------+----------------+------+---------------------------------------+-----------------+------------+----------------------+----------------------+----------+--------------------------------------+----------+---------------+
| 101^3B@081abe6612fa091b114670a1271b94cd | sips:101@176.12.16.218:35254^3Btransport=ws^3Brtcweb-breaker=no | 1560268750 | 10 | | | IM-client/OMA1.0 sipML5-v1.2016.03.04 | 3 | | no | df7jal23ls0d.invalid | 0 | b94f79dc-064d-efc8-f54a-40c5673531b3 | 101 | yes |
+-----------------------------------------+-----------------------------------------------------------------+-----------------+-------------------+----------------+------+---------------------------------------+-----------------+------------+----------------------+----------------------+----------+--------------------------------------+----------+---------------+
1 row in set (0.00 sec)
MariaDB [asterisk]>
MariaDB [asterisk]>
MariaDB [asterisk]>
MariaDB [asterisk]>
MariaDB [asterisk]> select * from ps_contacts;
+-----------------------------------------+-----------------------------------------------------------------+-----------------+-------------------+----------------+------+---------------------------------------+-----------------+------------+----------------------+----------------------+----------+--------------------------------------+----------+---------------+
| id | uri | expiration_time | qualify_frequency | outbound_proxy | path | user_agent | qualify_timeout | reg_server | authenticate_qualify | via_addr | via_port | call_id | endpoint | prune_on_boot |
+-----------------------------------------+-----------------------------------------------------------------+-----------------+-------------------+----------------+------+---------------------------------------+-----------------+------------+----------------------+----------------------+----------+--------------------------------------+----------+---------------+
| 101^3B@081abe6612fa091b114670a1271b94cd | sips:101@176.12.16.218:35254^3Btransport=ws^3Brtcweb-breaker=no | 1560268750 | 10 | | | IM-client/OMA1.0 sipML5-v1.2016.03.04 | 3 | | no | df7jal23ls0d.invalid | 0 | b94f79dc-064d-efc8-f54a-40c5673531b3 | 101 | yes |
| 102^3B@ade44845821be7424558ff141e7669b4 | sip:102@176.12.16.218:37995^3Bob | 1560269481 | 10 | | | CSipSimple_ali_n-28/r2457 | 3 | | no | 176.12.16.218 | 37995 | kmzfQmEl7JrUcq8inyiYYWqMATPDYxak | 102 | no |
+-----------------------------------------+-----------------------------------------------------------------+-----------------+-------------------+----------------+------+---------------------------------------+-----------------+------------+----------------------+----------------------+----------+--------------------------------------+----------+---------------+
2 rows in set (0.00 sec)
MariaDB [asterisk]>
Damn if I know what’s going on here … version 16.4 right … ODBC is
mysql-connector-odbc-5.3.11
How about the odbc config ?
odbc.ini :
[asterisk]
Driver = MySQL
Description = MySQL connection to asterisk database
Server = localhost
Port = 3306
Database = asterisk
UserName = root
Password = --deleted–
Socket = /var/run/mysqld/mysqld.sock
odbcinst.ini :
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5a.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc5S.so
UsageCount = 10