Thank you Doug, but if I don't understand things wrong, you are not using adaptive ODBC?
I meanwhile found out that things work when I manually create the columns. Just wondering, is there any official specifications for the default columns, e.g. which datatype they shall have and so on? Also, I am getting this errors: > [Aug 19 20:36:11] WARNING[2386]: res_odbc.c:601 ast_odbc_direct_execute: >> SQL Execute error! Verifying connection to asterisk [asterisk-connector]... > > [Aug 19 20:36:11] ERROR[2386]: cdr_odbc.c:162 odbc_log: CDR direct execute >> failed > > > I guess they have nothing to do with adaptive odbc? As a reference, here is my complete configuration for adaptive odbc: /etc/odbcinst.ini: > > [MySQL] > > Description = ODBC for MySQL > > Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so > > Setup = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so > > FileUsage = 1 > > >> >> /etc/odbc.ini: > > [asterisk-connector] > > Description = MySQL connection to 'asterisk' database > > Driver = MySQL > > Database = asterisk > > Server = localhost > > UserName = user > > Password = password > > Port = 3306 > > Socket = /var/run/mysqld/mysqld.sock > > >> >> >> cdr_adaptive_odbc.conf: > > [mytable] > > connection = asterisk > > table = asterisk_cdr > > >> res_odbc.conf: > > [asterisk] > > enabled => yes > > dsn => asterisk-connector > > username => user > > password => password > > pre-connect => yes > > pooling => no > > limit => 1 > > >> cdr.conf: > > [general] > > enable = yes > > unanswered = yes > > 2012/8/19 Doug Lytle <[email protected]> > Stefan at WPF wrote: > >> Thanks for any hint :-) >> > > /etc/odbc.ini > > [MySQL-cdr] > Description = CDR Database > Driver = MySQL > Socket = /var/lib/mysql/mysql.sock > Server = 172.19.8.9 > User = username > Password = password > Database = asteriskcdr > Option = 3 > > /etc/asterisk/res_odbc.conf > > [MySQL-cdr] > enable => yes > dsn => MySQL-cdr > username => username > password => password > preconnect => yes > > /etc/asterisk/cdr_odbc.conf > > [global] > dsn=MySQL-cdr > ;loguniqueid=yes > dispositionstring=yes > table=cdr > usegmtime=no > ;hrtime=yes > > > Doug > > > -- > Ben Franklin quote: > > "Those who would give up Essential Liberty to purchase a little Temporary > Safety, deserve neither Liberty nor Safety." > > > -- > ______________________________**______________________________**_________ > -- 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<http://lists.digium.com/mailman/listinfo/asterisk-users> >
-- _____________________________________________________________________ -- 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
