First of all test your odbc-connection via console:
isql telco-ops dba c3podb@2012 -v
You should see a "Connected!"-Message. Do you?
Second: yes I also had problems setting up odbc. The main
"problem/error" for me was, that documentation is sometimes confusing.
Here is my config. Please notice the [section] - namings:
/etc/odbcinst.ini
[MySQL]
Description = MySQL ODBCMyODBC Driver
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
FileUsage = 1
/etc/odbc.ini
[MySQL-asterisk]
Description = MySQL ODBC Driver
Driver = MySQL
Socket = /var/run/mysqld/mysqld.sock
Server = localhost
User = my_username
Password = my_password
Database = my_database
Option = 3
Port =
Charset = utf8
/etc/asterisk/res_odbc.conf
[mysql]
enabled => yes
dsn => MySQL-asterisk
username => my_username
password => my_password
pre-connect => yes
/etc/asterisk/cdr_odbc.conf
[global]
dsn=mysql
loguniqueid=yes
dispositionstring=yes
table=cdr
/etc/asterisk/cel_odbc.conf
[first]
connection=mysql
table=cel|
|
Additionally you will need some configurations for you realtime-config.
This config above is only for cdr- and cel-logging via odbc.
-Thorsten-
Am 10.12.2012 12:23, schrieb Chandrakant Solanki:
/etc/odbc.ini
[telco-ops]
Description = Asterisk realtime and other FUNC_ODBC access
Driver = MySQL
Server = 172.18.100.18
Socket = /var/lib/mysql/data3306/mysql.sock
User = dba
Password = c3podb@2012
Database = mytelcoexample
Port = 3306
Option = 3
On Mon, Dec 10, 2012 at 4:34 PM, Thorsten Göllner <[email protected]
<mailto:[email protected]>> wrote:
Am 10.12.2012 06:37, schrieb Chandrakant Solanki:
Hi All,
OS : CentOS 5 64bit OS & Machine
Asterisk: 1.8.13.0
ODBC Packages:
unixODBC-2.2.11-7.1
mysql-connector-odbc-3.51.12-2.2
unixODBC-devel-2.2.11-7.1
res_odbc.conf
[telco-ops]
enabled => yes
dsn => telco-ops
username => dba
password => c3podb@2012
pre-connect => yes
sanitysql => select 1
idlecheck => 15
;isolation => repeatable_read
pooling => yes
limit => 3600
connect_timeout => 10
negative_connection_cache => 30
Above is my installation package and configuration file
(res_odbc.conf), when I try to execute "odbc show all" it always
gives below output.
*CLI> odbc show all
ODBC DSN Settings
-----------------
Name: telco-ops
DSN: telco-ops
Last connection attempt: 1970-01-01 00:00:00
Pooled: Yes
Limit: 3600
Connections in use: 1
- Connection 1: connected
When Insert/Update/Select query will be executed, it can't update
last connection attempt field. In result, ODBC stuck after few
minutes, and in this case I also need to restart asterisk,
because I can't type any command, it can't give any command's output.
Also updated asterisk with 10.9.0, but same result.
Please show us /etc/odbc.ini too.
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
