[asterisk-users] Asterisk cdr_odbc problems

[Tilghman Lesher]

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