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

[A J Stiles]

On Monday 24 Jan 2011, Jonas Kellens wrote:
> 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)
>
> [stuff deleted]

Try "hostname=localhost" aot "hostname=127.0.0.1", and make sure the socket 
you specified actually exists.  (On Debian and Ubuntu, it should 
be "sock=/var/run/mysqld/mysqld.sock".)  Also, are you sure you gave the user 
the right password?  Try GRANT ALL ON Asterisk.cdr TO asteriskcdr@"%" 
IDENTIFIED BY "mysecret";

-- 
AJS

Answers come *after* questions.