[Asterisk-Users] Big problems with Voicemails ODBC Storage

[asterisk at mazone.info]

Versions

 

unixODBC 2.2.11 installed by source code

asterisk 1.2.2 recompiled with the CFLAGS options enabled just as mentioned
in the wiki:

 

http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage

 

I’m pooling all the configuration from realtime/MySQL and everything works
perfectly, I’ve checked the connectivity by ODBC with isql utility ant the
connection is up and running!

 

But when I issue the “odbc show” command the asterisk crashes and restarts
automatically

 

lab*CLI> odbc show 

Name: asterisk

DSN: asterisk

Connected: no

 

Feb 16 14:07:35 WARNING[22165]: res_odbc.c:238 odbc_sanity_check: Connection
is down attempting to reconnect...

Feb 16 14:07:35 WARNING[22165]: res_odbc.c:497 odbc_obj_disconnect:
res_odbc: asterisk [asterisk] already disconnected

Feb 16 14:07:35 NOTICE[22165]: res_odbc.c:552 odbc_obj_connect: Connecting
asterisk

Feb 16 14:07:35 WARNING[22165]: res_odbc.c:563 odbc_obj_connect: res_odbc:
Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified 

 

And the configuration is not even shown

 

Here you can see my configuration files

 

res_odbc.conf

 

[asterisk]

dsn => asterisk

;username => myuser

;password => mypass

;pre-connect => yes

 

[mysqlvm]

dsn => MySQL-asterisk

username => username

password => password

;pre-connect => yes 

 

/usr/local/etc/odbc.ini

 

[MySQL-asterisk]

Description     = MySQL ODBC Driver Testing

Driver          = MySQL

Socket          = /var/lib/mysql/mysql.sock

Server          = pbx.1234.com

User            = username

Password        = password

Database        = database

Option          = 3

Port            = 3306

 

/usr/local/etc/odbcinst.ini

 

 

# Example driver definitinions

#

#

 

# Included in the unixODBC package

#[PostgreSQL]

#Description    = ODBC for PostgreSQL

#Driver         = /usr/lib/libodbcpsql.so

#Setup          = /usr/lib/libodbcpsqlS.so

#FileUsage      = 1

 

 

# Driver from the MyODBC package

# Setup from the unixODBC package

[MySQL]

Description     = ODBC for MySQL

Driver          = /usr/lib/libmyodbc.so

Setup           = /usr/local/lib/libodbcmyS.so

FileUsage       = 1

 

 

Any clue what I’m missing ?????

As I said, testing the connectivity by ODBC works just fine
. It seems only
a problem with asterisk, not being able to make identify that thers a ODBC
connection active!!

 

Thanks in advance!!!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060216/e04ee7ff/attachment.htm