Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Matthew Boehm a écrit : sylvain garcia wrote: Kib Eki a écrit : Asterisk don't use directly mysql database for cdr, astersisk use odbc and odbc connect to mysql. So you must configure odbc corectly wiyt libmyodbc (on debian) the config file are here: Wrong. Asterisk can and does connect to MySQL directly. (Where the hell are these people getting this wrong info?) -Matthew Sorry Mea Culpa ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Dear Kib, As I believe the Realtime options concerning the mysql database can only be used with the Asterisk CVS-HEADversion it's still not implemented on Asterisk v 1.0.* . Thx MAG Kib Eki wrote: Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- Thx MAG ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Kib Eki a crit: Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users Asterisk don't use directly mysql database for cdr, astersisk use odbc and odbc connect to mysql. So you must configure odbc corectly wiyt libmyodbc (on debian) the config file are here: /etc/odbcinst.ini : [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so CPTimeout = CPReuse = FileUsage = 1 /etc/odbc.ini : [MySQL-asterisk] Description = MySQL Asterisk Database Driver = MySQL Socket = /var/run/mysqld/mysqld.sock Server = @ipofMysqlddatabase (not domain name) User = Password = Database = asterisk Option = 3 #Port = /etc/asterisk/cdr_odbc.conf : [global] dsn=MySQL-asterisk username=database_username password=database_password loguniqueid=yes ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Try to put the IP of you CDR server instead of 'localhost', that's work for me. Regards. - Original Message - From: Kib Eki [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Wednesday, July 27, 2005 9:44 AM Subject: [Asterisk-Users] cdr_mysql does not write to mysql db Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
sylvain garcia wrote: Kib Eki a écrit : Asterisk don't use directly mysql database for cdr, astersisk use odbc and odbc connect to mysql. So you must configure odbc corectly wiyt libmyodbc (on debian) the config file are here: Wrong. Asterisk can and does connect to MySQL directly. (Where the hell are these people getting this wrong info?) -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
using localhost in you mysql conf should work, make sure you linux box and the loopback interface up and has a a entry in your /etc/ hosts for localhost and that your firewall (if you have one setup on your localbox) allows traffic from 172.0.0.1 to 172.0.0.1 On Jul 27, 2005, at 6:17 AM, Dpto. Técnico. wrote: Try to put the IP of you CDR server instead of 'localhost', that's work for me. Regards. - Original Message - From: Kib Eki [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Wednesday, July 27, 2005 9:44 AM Subject: [Asterisk-Users] cdr_mysql does not write to mysql db Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Mohamed A. Gombolaty wrote: Dear Kib, As I believe the Realtime options concerning the mysql database can only be used with the Asterisk CVS-HEAD version it's still not implemented on Asterisk v 1.0.* . Thx MAG Wrong. He's not using RealTime. No where in his original post did he mention realtime. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Kib Eki wrote: Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? Do you have the module installed? Is the module loaded? What happens when you type cdr mysql status on asterisk command line? You should see something like this: cytrex*CLI cdr mysql status Connected to [EMAIL PROTECTED], port 3306 using table cdr for 7 hours, 41 minutes, 21 seconds. Wrote 70 records since last restart. If you get no such command then that means the module isn't loaded. If you are using localhost then you need to uncomment the sock and make sure it's path is correct. Don't listen to those other guys. The first two were both wrong. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db - SOLVED
i reinstalled the addons and the module works fine now. Thanks to all!! Neal Lawson wrote: using localhost in you mysql conf should work, make sure you linux box and the loopback interface up and has a a entry in your /etc/ hosts for localhost and that your firewall (if you have one setup on your localbox) allows traffic from 172.0.0.1 to 172.0.0.1 On Jul 27, 2005, at 6:17 AM, Dpto. Técnico. wrote: Try to put the IP of you CDR server instead of 'localhost', that's work for me. Regards. - Original Message - From: Kib Eki [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Wednesday, July 27, 2005 9:44 AM Subject: [Asterisk-Users] cdr_mysql does not write to mysql db Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
On Wed, 2005-07-27 at 09:44 +0200, Kib Eki wrote: Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306 ;sock=/tmp/mysql.sock userfield=1 Thanks and Regards I do not know if this has changed but I remember that when I first installed the mysql cdr addon the database had to be named asteriskcdrdb and the table where everything is written is cdr. Apart from that make sure that the module is loaded when you start Asterisk. Here is my cdr_mysql.conf: [global] hostname=localhost dbname=asteriskcdrdb table=cdr password=dbpassword user=dbuser ;port=3306 sock=/var/lib/mysql/mysql.sock userfield=1 I can see you are missing the table= from your config. -- Telecomunicaciones Abiertas de Mexico Carlos Chavez Director de Tecnologia +52-55-91169161 Ext. 2001 signature.asc Description: This is a digitally signed message part ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_mysql does not write to mysql db
Neal Lawson wrote: using localhost in you mysql conf should work, make sure you linux box and the loopback interface up and has a a entry in your /etc/ hosts for localhost and that your firewall (if you have one setup on your localbox) allows traffic from 172.0.0.1 to 172.0.0.1 Don't you mean 127.0.0.1 ? Plus, in the MySQL API documentation the use of localhost indicates to the API that you want to use a socket connection. If you don't want to use sockets (which you should on local machine), the you need to change to an IP to use TCP. -Matthew ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users