ODBC issue - Asterisk and openSER Integration

Asterisk Asterisk Support
1

Hi all,

I am having a bit of difficulty determining how to resolve this warning and am posting in hopes that someone may have had a similiar problem and can direct me on how to resolve. I am integrating * and openSER. Although * and openSER are on the same network, all of my phones are on different networks from each other and the * server and SIP router.

This is the messages printout for a particular process:
Jul 17 17:23:07 NOTICE[24442] cdr.c: CDR simple logging enabled.
Jul 17 17:23:07 NOTICE[24442] config.c: Registered Config Engine odbc
Jul 17 17:23:08 NOTICE[24442] res_odbc.c: Adding ENV var: INFORMIXSERVER=my_special_database
Jul 17 17:23:08 NOTICE[24442] res_odbc.c: Adding ENV var: INFORMIXDIR=/opt/informix
Jul 17 17:23:08 NOTICE[24442] res_odbc.c: registered database handle ‘asterisk’ dsn->[asterisk]
Jul 17 17:23:08 NOTICE[24442] res_odbc.c: Connecting asterisk
Jul 17 17:23:08 WARNING[24442] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=1251 [unixODBC][TCX][MyODBC]Client does not support authentication protocol requested by server; conside
Jul 17 17:23:08 NOTICE[24442] res_odbc.c: res_odbc loaded.
Jul 17 17:23:08 NOTICE[24442] config.c: Registered Config Engine mysql

Any help would be appreciated. Thanks in advance.

2

this would appear to be nothing to do with telephony, but your db connection. what’s the complete message ? what is the difference between the authentication method the server wants and what the client can do ?

the last time i saw this message was on a W2K box that was talking to a MySQL db. a client ODBC connector upgrade and MDAC upgrade fixed it.

3

Hello all,
and thanks for the prompt reply. Whew, finally! I thought i’d post this just in case someone runs into a similiar situation. What i did was cd to /etc/init.d/mysql to get to the script and then on the mysqld command line, add this: --old-passwords. Then stop and start mysql. Then go into mysql and do this:

use mysql;
set password for asterisk@localhost=old_password(‘new_password’);
flush privileges;

This makes MyODBC and MySQL satisfied, happy campers.