[Asterisk-Users] using unixODBC

[Thierry Wehr]

> -----Message d'origine-----
> De : asterisk-users-bounces at lists.digium.com 
> [mailto:asterisk-users-bounces at lists.digium.com] De la part 
> de Kamran Ahmad
> Envoyé : vendredi 1 avril 2005 11:08
> À : asterisk-users at lists.digium.com
> Objet : [Asterisk-Users] using unixODBC
> 
> hi list
> 
> i know i am asking question out of the scope of this list. 
> actualy i cant find any place to ask question like this. may 
> be someone using ODBC with asterik.
> actualling i want to make ODBC connection for asterisk on my 
> new fedora core 2. i have tried every thing.
> tried rpms..... compiled code nothing works here.....
> i have already done this kind of connection on my other 
> mechine. i dont know why i am getting error.
> 
> actually when i am doing 
> 
> isql asteriskdsn
> [ISQL]ERROR: Could not SQLConnect


Hello

Just give my own config that works well

/etc/odbc.ini
[MySQL-asterisk]
Description  = MySQL asterisk database
Trace       = Off
TraceFile   = stderr
Driver      = MySQL
SERVER      = 127.0.0.1
USER        = connecting-user
PASSWORD    = user-password
PORT        = 3306
DATABASE    = asterisk


/etc/odbcinst.ini
[MySQL]
Description     = MySQL driver for Linux
Driver          = /usr/lib/libmyodbc.so
FileUsage       = 1


/etc/asterisk/res_odbc.conf
[asterisk]
dsn => MySQL-asterisk
username => connecting-user
password => user-password
pre-connect => yes


Hop i'll help you as it works great here

Best regards
Thierry Wehr