[Asterisk-Users] app_dbodbc URGENT

brian brian at bkw.org
Thu Jul 22 14:46:40 MST 2004


Also compile unixODBC and MyODBC from src .. some binary dists are broken...

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





More information about the asterisk-users mailing list