[Asterisk-Users] app_dbodbc URGENT

[brian]

odbc.ini:
[MySQL-asterisk]
Description     = MySQL ODBC Driver Testing
Driver          = MySQL
;Socket          = /var/run/mysqld/mysqld.sock
Server          = localhost
User            = user
Password        = pass
Database        = asterisk
Option          = 3
#Port           =

you specify the driver info in odbcinst.ini:

[MySQL]
Description     = MySQL ODBC MyODBC Driver
Driver          = /usr/lib/libmyodbc3.so
FileUsage       = 1

Don't know what example told you to use the driver = /path/to/the.so in
odbc.ini... but here is what I have that works.

bkw


> -----Original Message-----
> From: asterisk-users-admin at lists.digium.com [mailto:asterisk-users-
> admin at lists.digium.com] On Behalf Of AJ Grinnell
> Sent: Thursday, July 22, 2004 2:43 PM
> To: asterisk-users at lists.digium.com
> Subject: RE: [Asterisk-Users] app_dbodbc URGENT
>
> Yes I know that it says that, I am using isql to connect, and it works
> just
> fine, which is why this is making me so mad. Anything else I can check on
> the asterisk end?
>
>
>
> -----Original Message-----
> From: asterisk-users-admin at lists.digium.com
> [mailto:asterisk-users-admin at lists.digium.com]On Behalf Of brian
> Sent: Thursday, July 22, 2004 2:39 PM
> To: asterisk-users at lists.digium.com
> Subject: RE: [Asterisk-Users] app_dbodbc URGENT
>
>
> Its very clear why...
>
> app_dbodbc.c:441 odbc_load_module: app_dbodbc: Unable to connect to
> datasource: MySQL-asterisk
>
> use isql to test..
>
> isql <dsn> <username> <password>
>
> I suspect that wont even work.  It clearly says it can't connect.
>
> bkw
>
> > -----Original Message-----
> > From: asterisk-users-admin at lists.digium.com [mailto:asterisk-users-
> > admin at lists.digium.com] On Behalf Of AJ Grinnell
> > Sent: Thursday, July 22, 2004 12:19 PM
> > To: Asterisk
> > Subject: [Asterisk-Users] app_dbodbc URGENT
> >
> > I have been searching for the last two days and I cannot seem to set
> > Asterisk to work from a database, can someone please tell me what I am
> > doing
> > wrong here?  Here are my files
> >
> > [app_dbodbc.so] => (Database access functions for Asterisk extension
> > logic)
> >   == Parsing '/etc/asterisk/odbc.conf': Found
> >        > app_dbodbc: dsn is MySQL-asterisk
> >        > app_dbodbc: username is asterisk
> >        > app_dbodbc: password is [secret]
> >        > app_dbodbc: Error SQLConnect -1
> > Jul 22 13:15:18 ERROR[8192]: app_dbodbc.c:441 odbc_load_module:
> > app_dbodbc:
> > Unable to connect to datasource: MySQL-asterisk
> >        > app_dbodbc: Unable to connect to datasource: MySQL-asterisk
> >   == Registered application 'ODBCget'
> >   == Registered application 'ODBCput'
> >   == Registered application 'ODBCdel'
> >   == Registered application 'ODBCdeltree'
> >
> > My odbc.conf
> > [global]
> > dsn = MySQL-asterisk
> > username = asterisk
> > password = ******
> >
> > My odbc.ini
> > [ODBC Data Sources]
> > MySQL-asterisk   = Asterisk PBX
> >
> > [MySQL-asterisk]
> > Driver       = /usr/local/lib/libmyodbc.so
> > Description  = Asterisk PBX
> > SERVER       = localhost
> > PORT         = 3306
> > USER         = asterisk
> > PASSWORD     = DIDO1223
> > DATABASE     = asterisk
> > TRACEFILE    = /tmp/odbc.trace
> > TRACE        = 1
> >
> >
> >
> >
> > _______________________________________________
> > 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
>
> --
>
> This message has been scanned by Arialink for dangerous content and is
> believed to be clean. For more information please email
> support at arialink.com
>
>
>
>
> _______________________________________________
> 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