Re: [asterisk-users] ODBC Connection Problem
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 t...@ovm-group.com mailto:t...@ovm-group.com 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
Re: [asterisk-users] ODBC Connection Problem
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
Re: [asterisk-users] ODBC Connection Problem
/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 t...@ovm-group.com 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. -- Regards, Chandrakant Solanki -- _ -- 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
Re: [asterisk-users] ODBC Connection Problem
On Mon, Dec 10, 2012 at 5:23 AM, Chandrakant Solanki solanki.chandrak...@gmail.com wrote: Password= c3podb@2012 In case you didn't realize you were sending this out publicly to a publicly archived and searchable list, you might want to change that password now. -- -Chris Harrington ACSDi Office: 763.559.5800 Mobile Phone: 612.326.4248 -- _ -- 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
Re: [asterisk-users] ODBC Connection Problem
On 10 Dec 2012, at 16:13, Christopher Harrington wrote: On Mon, Dec 10, 2012 at 5:23 AM, Chandrakant Solanki solanki.chandrak...@gmail.com wrote: Password= c3podb@2012 In case you didn't realize you were sending this out publicly to a publicly archived and searchable list, you might want to change that password now. Hostname address is RFC1918, he'll probably be ok ;) S-- _ -- 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
Re: [asterisk-users] ODBC Connection Problem
On Mon, Dec 10, 2012 at 10:52 AM, Steven Howes steve-li...@geekinter.netwrote: On 10 Dec 2012, at 16:13, Christopher Harrington wrote: Hostname address is RFC1918, he'll probably be ok ;) Private subnet or not, that's a social engineering and recon target. If all it takes is a Google search for this guy's name and password, that's dangerous. -- -Chris Harrington ACSDi Office: 763.559.5800 Mobile Phone: 612.326.4248 -- _ -- 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