[Asterisk-Users] app_dbodbc URGENT

AJ Grinnell agrinnell at crt.net
Thu Jul 22 12:42:54 MST 2004


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







More information about the asterisk-users mailing list