[Asterisk-Dev] Asterisk with MySQL

[rizwan]

Hello

I am getting this error message, when i try to authenticate my users through database.

Jan  7 20:28:08 WARNING[26487]: res_config_odbc.c:69 realtime_odbc: SQL Alloc Handle failed!
Jan  7 20:28:08 NOTICE[26487]: chan_sip.c:7974 handle_request: Registration from 'rizwan <sip:1234567 at 192.168.0.147>' failed for '192.168.0.149'

My conf files are:

 ;res_odbc.conf
[test]
dsn => test
username => root
password =>
pre-connect => yes

 ;extensions.conf 
[test]
switch => Realtime/@realtime_ext

 ;extconfig.conf
sipfriends => odbc,test,sip_buddies
realtime_ext => odbc,test,extensions_table

Can you please help me, what to do here?

Thanks