Hello
I want to try to integrate Asterisk 17.0 with PostgreSQL and my test device can’t register.
In Asterisk CLI I’ve got this messages:
[Nov 22 17:35:55] DEBUG[13086]: res_config_odbc.c:115 custom_prepare: Skip: 0; SQL: SELECT * FROM ps_contacts WHERE expiration_time <= ? ORDER BY expiration_time
[Nov 22 17:35:55] DEBUG[13086]: res_config_odbc.c:134 custom_prepare: Parameter 1 (‘expiration_time <=’) = ‘1574422555’
[Nov 22 17:35:55] WARNING[13086]: res_odbc.c:538 ast_odbc_print_errors: SQL Execute returned an error: HY000: ERROR: operator does not exist: bigint <= character at character 88;
Error while executing the query
[Nov 22 17:35:55] WARNING[13086]: res_odbc.c:433 ast_odbc_prepare_and_execute: SQL Execute error -1!
But when I try to do the same on MySQL all works fine.
What I do wrong?
Thank you!