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; -- _____________________________________________________________________ -- 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