[asterisk-users] Voicemail, SQL & ODBC

RR ranjtech at gmail.com
Thu Nov 30 07:34:37 MST 2006


> RR, mate, I don't think that I have so many problems.
>
> 1.) I asked a simple question:
>
> Is it (still not) possible to connect Asterisk directly (= without ODBC)
> to mySQL for the purpose of storing voicemail data?
>
> Now, some posts later I've got a simple answer:
>
> No!

Oh, haha sorry about that, I read these emails just to take a break
from my regular work and filter them by keyword "voicemail" as that's
all I use (*) for (and conference). Maybe I don't know enough about DB
Connectivity by I thought the MySQL driver I was mentioning earlier is
a direct connector to MySQL and doesn't need ODBC. ODBC I thought was
for applications to talk to DBs for which there's no specific driver.
So if instead of using unixodbc you compile with res_mysql (which you
have for your CDRs) and then configure your res_mysql.conf with the DB
info + in your extconfig.conf say something like

voicemail => mysql,<DSN>,<vm table>

it should work. But what do I know. Maybe someone can confirm this.


>
> 2.) It's not exactly clear to me why my extconfig.conf should humour you

1) it's just a phrase (i.e. humour me) and 2) Wanted to see if you're
configuring your extconfig.conf properly, along the lines of what I
said above

>
> 3.) You're telling me (and everybody else here) that you have *it*
> running with MSSQL. But you're neither telling what *it* exactly is or
> does nor *how* you made it running. Maybe you want your extconfig.conf
> post here?

Umm *it* is the whatever the subject of the email and discussion is(?)
and how I got it running is by what Derek just said :P. Ihave to use
unixODBC, FreeTDS to get it to work with MSSQL server and store the
voicemails in a DB.


More information about the asterisk-users mailing list