I have problem running asterisk 1.2.21.1 with unixODBC (2.2.12). asterisk-1.2.17 works fine but 1.2.21.1 not: Aug 19 13:44:57 NOTICE[14133] res_odbc.c: registered database handle 'asterisk' dsn->[asterisk] Aug 19 13:44:57 NOTICE[14133] res_odbc.c: Connecting asterisk Aug 19 13:44:57 NOTICE[14133] res_odbc.c: res_odbc: Connected to asterisk [asterisk] Aug 19 13:44:57 NOTICE[14133] res_odbc.c: res_odbc loaded. Aug 19 13:44:57 NOTICE[14133] config.c: Registered Config Engine odbc Aug 19 13:45:04 WARNING[14170] res_odbc.c: SQL Execute returned an error -1: 01000: [unixODBC]Error while executing the query (non-fatal); ERROR: syntax error at or near "ESCAPE" at character 125 (112) After this asterisk crashes. It's on x86. I also saw this bug on another installation of asterisk-1.2.21.1 where the issued SQL command contained at the end of the command 'ESCAPE' and some char, not sure if it was '\'' or something different. This was on amd64. These are both production servers so I didn't have enough time to play with it. If you need more info then please let me know.
Reassigning to chainsaw as he is now the asterisk maintainer.
Sorry, this bug report is incomplete and I can not act on it. Please file a new bug if you still have problems using ODBC on Asterisk 1.2.32 which is currently in the tree. Your new bug will have to include emerge --info and at least a snippet of the relevant configuration file so I can reproduce the bug.