For tables I have used alembic and tables created succesfully
When I am trying to register it is not registering and giving me the error
[Sep 13 06:13:06] NOTICE: res_pjsip/pjsip_distributor.c:508 log_failed_request: Request ‘REGISTER’ from ‘sip:email@example.com’ failed for ‘192.168.2.214:61945’ (callid: 4d133de913a845d7a86dfda1b7d9b007) - No matching endpoint found
What else I have missed the point ? Please suggest
I don’t use ODBC so I’d suggest trying to narrow things down further. Compare again your configuration between the wiki (which is known to work) and yours. Turn on debug in logger.conf and use core set debug 9 to see if ODBC is being queried for things.
If you follow those it should result in a working setup.You’ll want to test to make sure you have a working connection outside of Asterisk. The wiki will tell you how to do that, as well as other debugging steps.
Looking at your configuration though a couple things might be causing your problem. First it looks like you have a couple of environment variables set telling where to find the odbc configuration. Those appear to point to another location for the files than the one you showed:
/usr/local/etc/ vs /etc
Second in your res_odbc.conf file you have the following:
dsn => asterisk
But based on your odbc.ini configuration I believe it should be (the odbc section name):
Thanks for the response,the files /usr/local/etc/ vs /etc are different as in my system ODBCDataSources got stored in /usr/local/etc and i got it fixed by pointing to this location. I got the pointer from your reply,let me see. Thanks anyway.
Your pointer did help me to pull the correct DSN,that was an error. Also,a minor name change in .so file replaced with 64 bit was libmyodbc5a.so.It now picks up the correct DSN.
Now ODBC DSN Settings
Number of active connections: 1 (out of 200)