[asterisk-users] Unable to insert cdr-data into mysql-DB

[Jonas Kellens]

Hello list,

I keep on getting the error :

ERROR[1707] cdr_addon_mysql.c: Cannot connect to database server 
127.0.0.1: (1045) Access denied for user 'asteriskcdr'@'localhost' 
(using password: YES)


I have a 'cdr' table in my MySQL-DB. On this table the user 
'asteriskcdr' has select, insert, update privileges.

GRANT SELECT , INSERT ,UPDATE ON `Asterisk`.`cdr` TO 
'asteriskcdr'@'127.0.0.1';


cdr_mysql.conf :

[global]
hostname=127.0.0.1
dbname=Asterisk
table=cdr
password=mysecret
user=asteriskcdr
port=3306
sock=/tmp/mysql.sock
userfield=1

I really don't know why Asterisk cannot connect to the table..


Kind regards,
Jonas.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110124/d0e7c15f/attachment.htm>