Asterisk v20 Realtime problem

Asterisk Asterisk SIP
1

Hello everyone, I’ve installed v20 today twice actually and configured ODBC connection to mysql ,updated necessary sections in extconfig and sorcery. Added a few ednpoints but nothing shows when I type pjsip show registrations, show endpoints, show aors …etc . as if it’s not reading some config file .

“odbc show all” does show it’s connected, if I update func_odbc and "odbc read dsn-name value exec " , I do get the result . But I could not get realtime to work . it doesnt load the data from mysql.

Any ideas? Thans in advance

2

You’d need to provide the actual configuration you’re using, including schema and database dump.

3

I do suspect it to be either schema or or some table related issues. I did create the tables from alembic but maybe collation issues or default schema collation. Now i just deleted the database and started to received errors

SQL Prepare returned an error: HY000: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.31-0ubuntu0.22.04.1]Unknown database 'asterisk'
[Nov  1 16:33:57] WARNING[37106]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [SELECT * FROM ps_contacts WHERE expiration_time <= ? ORDER BY expiration_time]
[Nov  1 16:34:27] WARNING[37106]: res_odbc.c:529 ast_odbc_print_errors: SQL Prepare returned an error: HY000: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.31-0ubuntu0.22.04.1]Unknown database 'asterisk'
[Nov  1 16:34:27] WARNING[37106]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [SELECT * FROM ps_contacts WHERE expiration_time <= ? ORDER BY expiration_time]
[Nov  1 16:34:57] WARNING[37106]: res_odbc.c:529 ast_odbc_print_errors: SQL Prepare returned an error: HY000: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.31-0ubuntu0.22.04.1]Unknown database 'asterisk'
[Nov  1 16:34:57] WARNING[37106]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [SELECT * FROM ps_contacts WHERE expiration_time <= ? ORDER BY expiration_time]
[Nov  1 16:35:27] WARNING[37106]: res_odbc.c:529 ast_odbc_print_errors: SQL Prepare returned an error: HY000: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.31-0ubuntu0.22.04.1]Unknown database 'asterisk'
[Nov  1 16:35:27] WARNING[37106]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [SELECT * FROM ps_contacts WHERE expiration_time <= ? ORDER BY expiration_time]
[Nov  1 16:35:57] WARNING[37106]: res_odbc.c:529 ast_odbc_print_errors: SQL Prepare returned an error: 42S02: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.31-0ubuntu0.22.04
4

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