[Asterisk-Users] cdr_mysql does not write to mysql db

[Carlos Chavez]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20050727/6ece8fdd/attachment.pgp