[Asterisk-Users] Asterisk with MySQL

[Muhammad Rizwan Khan]

Please find the attached files,

Thanks

On Friday 07 January 2005 22:24, you wrote:
> post your /etc/odbc.ini and /etc/odbcinst.ini
>
> -matthew
>
> ----- Original Message -----
> From: "rizwan" <rizwan at advcomm.net>
> To: <Asterisk-users at lists.digium.com>
> Sent: Friday, January 07, 2005 10:19 AM
> Subject: [Asterisk-Users] Asterisk with MySQL
>
> > 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
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-users
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-users
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
[FB_SAMPLE]
Driver		= FIREBIRD
Description		= Firebird driver
Database		= server:employee.gdb
User		= sysdba
Password		= masterkey
With_Schema		= 0
Dialect		= 3
Charset		= 
Role		= 
Nowait		= 0
OldMetaData		= 0
ExecProc		= 0
Dquote		= 0
WithDefault		= 1
TxnMode		= 1
Flusfcommit		= 0
Padvarchar		= 0
Nullschema		= 0
Fixprecision		= 0
Simpleunicode		= 0
wchardefault		= 0

[demo]
Driver		= OOB
Description		= Easysoft ODBC-ODBC Bridge demo data source
SERVER		= demo.easysoft.com
PORT		= 8888
TRANSPORT		= tcpip
TARGETDSN		= pubs
LOGONUSER		= demo
LOGONAUTH		= easysoft
TargetUser		= demo
TargetAuth		= easysoft

-------------- next part --------------
[PostgreSQL]
Description		= ODBC for PostgreSQL
Driver		= /usr/lib/libodbcpsql.so
Setup		= /usr/lib/libodbcpsqlS.so
FileUsage		= 1

[FIREBIRD]
Description		= Easysoft Firebird ODBC Driver
Driver		= /usr/local/easysoft/fb/libfbodbc.so
Setup		= /usr/local/easysoft/fb/libfbodbcS.so
FileUsage		= 1
DontDLClose		= 1

[OOB]
Description		= Easysoft ODBC-ODBC Bridge
Driver		= /usr/local/easysoft/oob/client/libesoobclient.so
Setup		= /usr/local/easysoft/oob/client/libesoobsetup.so
FileUsage		= 2

[MySQL ODBC 3.51 Driver]
DRIVER		= /usr/lib/libmyodbc3.so
SETUP		= /usr/lib/libmyodbc3S.so
FileUsage		= 1