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

[Bruce Ferrell]

On 01/24/2011 07:43 AM, Jonas Kellens wrote:
> 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.
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
redo your grant like this:

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

follow it with:

flush privileges;