<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif">Hello list,<br>
<br>
I keep on getting the error :<br>
<br>
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)<br>
<br>
<br>
I have a 'cdr' table in my MySQL-DB. On this table the user
'asteriskcdr' has select, insert, update privileges.<br>
<br>
<span class="syntax"><span
class="syntax_alpha syntax_alpha_reservedWord">GRANT</span> <span
class="syntax_alpha syntax_alpha_reservedWord">SELECT</span> <span
class="syntax_punct syntax_punct_listsep">,</span> <span
class="syntax_alpha syntax_alpha_reservedWord">INSERT</span> <span
class="syntax_punct syntax_punct_listsep">,</span><span
class="syntax_alpha syntax_alpha_reservedWord">UPDATE</span> <span
class="syntax_alpha syntax_alpha_reservedWord">ON</span> <span
class="syntax_quote syntax_quote_backtick">`Asterisk`</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_quote syntax_quote_backtick">`cdr`</span> <span
class="syntax_alpha syntax_alpha_reservedWord">TO</span> <span
class="syntax_quote syntax_quote_single">'asteriskcdr'</span><span
class="syntax_punct syntax_punct_user">@</span><span
class="syntax_quote syntax_quote_single">'127.0.0.1'</span><span
class="syntax_punct syntax_punct_queryend">;</span></span><br>
</font><font face="Helvetica, Arial, sans-serif"><br>
<br>
cdr_mysql.conf :<br>
<br>
[global]<br>
hostname=127.0.0.1<br>
dbname=Asterisk<br>
table=cdr<br>
password=mysecret<br>
user=asteriskcdr<br>
port=3306<br>
sock=/tmp/mysql.sock<br>
userfield=1<br>
<br>
I really don't know why Asterisk cannot connect to the table..<br>
<br>
<br>
Kind regards,<br>
Jonas.<br>
</font>
</body>
</html>