[asterisk-users] Asterisk cdr_odbc problems

[Atlanticnynex]

I meant to scrub the files for my passwords but *failed* 0_0 and pwned my self.

Thanks for the link Jeff. Solved the problem... I was missing iodbc.

Thanks!

On Tue, May 5, 2009 at 10:27 AM, Tiago Durante <tiagodurante at gmail.com> wrote:
> See if that helps you: http://edmundlong.com/edsBlog/odbc-cdr-with-asterisk/
>
> Regards
>
> On Tue, May 5, 2009 at 11:07 AM, Tilghman Lesher
> <tilghman at mail.jeffandtilghman.com> wrote:
>> On Monday 04 May 2009 20:12:19 Atlanticnynex wrote:
>>> I'm trying to get asterisk cdr_odbc configured, but it can't connect
>>> through my odbc driver.
>>>
>>> switchboard*CLI> module load cdr_odbc
>>> [May  4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module:
>>> cdr_odbc: Unable to connect to datasource: asterisk
>>>
>>> /etc/odbcinst.ini:
>>>
>>> [MySQL]
>>> Description     = MySQL driver
>>> Driver          = /usr/lib/odbc/libmyodbc.so
>>> Setup           = /usr/lib/odbc/libodbcmyS.so
>>>
>>>
>>> /etc/odbc.ini:
>>>
>>> [asterisk]
>>>  Description     = asterisk ODBC
>>>  Driver          = MySQL
>>>  Socket          = /var/run/mysqld/mysqld.sock
>>>  Server          = localhost
>>>  User            = asterisk
>>>  Password        = mysql_password
>>>  Database        = asterisk
>>>  Option          = 3
>>>  #Port           =
>>>  Trace       = On
>>>  TraceFile   = /var/log/odbc-asterisk
>>>
>>>
>>>
>>> /etc/asterisk/res_odbc.conf:
>>>
>>> [asterisk]
>>> enabled => yes
>>> dsn => asterisk
>>> username => asterisk
>>> password => exodus_2009
>>> pre-connect => yes
>>>
>>>
>>> /etc/asterisk/cdr_odbc.conf:
>>> ; cdr_odbc.conf
>>> ;
>>> [global]
>>> dsn=asterisk
>>> username=asterisk
>>> password=exodus_2009
>>> loguniqueid=yes
>>> dispositionstring=yes
>>> table=cdr               ;"cdr" is default table name
>>> usegmtime=no             ; set to "yes" to log in GMT
>>>
>>>
>>> ---------------------------------------------------------------------------
>>>-------------------------------
>>>
>>> Any ideas?
>>
>> The password you have in odbc.ini does not match the password in
>> res_odbc.conf.
>>
>> --
>> Tilghman
>>
>> _______________________________________________
>> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>>
>> asterisk-users mailing list
>> To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>
>
>
> --
> Tiago Durante
>
> ,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,
> Perseverance is the hard work you do after you
> get tired of doing the hard work you already did.
> -- Newt Gingrich
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>