[asterisk-users] Asterisk cdr_odbc problems

[Tiago Durante]

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