CDR not showing call logs

FreePBX Installation / Upgrade
1

I’m running Asterisk 1.6.1 and FreePBX 2.7.0.2 on Ubuntu 9.04. My CDR logs are not writing in FreePBX, and based on the asterisk logs, I beleive its a Mysql rights issue. I am just unsure how to correct it. Here is the log of the incoming call:


[2010-05-28 09:41:00] VERBOSE[24428] pbx.c:     -- Executing [s@macro-dial:3] AGI("SIP/66.193.176.35-00000003", "dialparties.agi") in new stack
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- Launched AGI Script /var/lib/asterisk/agi-bin/dialparties.agi
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:  dialparties.agi: Starting New Dialparties.agi
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:  dialparties.agi: Caller ID name is 'Name Unavailabl' number is '18778426622'
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:        > dialparties.agi: USE_CONFIRMATION:  'FALSE'
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:        > dialparties.agi: RINGGROUP_INDEX:   ''
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:  dialparties.agi: Methodology of ring is  'none'
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- dialparties.agi: Added extension 1001 to extension map
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:        > dialparties.agi: Extension 1001 has call screening off
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- dialparties.agi: Extension 1001 cf is disabled
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- dialparties.agi: Extension 1001 do not disturb is disabled
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:        > dialparties.agi: extnum 1001 has:  cw: 0; hascfb: 0 [] hascfu: 0 []
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:  dialparties.agi: EXTENSION_STATE: 0 (NOT_INUSE)
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:  dialparties.agi: Extension 1001 has ExtensionState: 0
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- dialparties.agi: Checking CW and CFB status for extension 1001
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- dialparties.agi: dbset CALLTRACE/1001 to 18778426622
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- dialparties.agi: Filtered ARG3: 1001
[2010-05-28 09:41:00] VERBOSE[24428] res_agi.c:     -- <SIP/66.193.176.35-00000003>AGI Script dialparties.agi completed, returning 0
[2010-05-28 09:41:00] VERBOSE[24428] pbx.c:     -- Executing [s@macro-dial:7] Dial("SIP/66.193.176.35-00000003", "SIP/1001,,tr") in new stack
[2010-05-28 09:41:00] VERBOSE[24428] netsock.c:   == Using SIP RTP TOS bits 184
[2010-05-28 09:41:00] VERBOSE[24428] netsock.c:   == Using SIP RTP CoS mark 5
[2010-05-28 09:41:00] VERBOSE[24428] app_dial.c:     -- Called 1001
[2010-05-28 09:41:00] VERBOSE[24428] app_dial.c:     -- SIP/1001-00000004 is ringing
[2010-05-28 09:41:03] VERBOSE[24428] app_macro.c:   == Spawn extension (macro-dial, s, 7) exited non-zero on 'SIP/66.193.176.35-00000003' in macro 'dial'
[2010-05-28 09:41:03] VERBOSE[24428] app_macro.c:   == Spawn extension (macro-exten-vm, s, 9) exited non-zero on 'SIP/66.193.176.35-00000003' in macro 'exten-vm'
[2010-05-28 09:41:03] VERBOSE[24428] pbx.c:   == Spawn extension (from-did-direct, 1001, 1) exited non-zero on 'SIP/66.193.176.35-00000003'
[2010-05-28 09:41:03] ERROR[24428] cdr_addon_mysql.c: Cannot connect to database server localhost: (1045) Access denied for user 'asteriskuser'@'localhost' (using password: YES)
[2010-05-28 09:41:21] VERBOSE[4445] dnsmgr.c:        > doing dnsmgr_lookup for 'callcentric.com'
[2010-05-28 09:41:21] VERBOSE[4445] srv.c:        > ast_get_srv: SRV lookup for '_sip._UDP.callcentric.com' mapped to host alpha9.callcentric.com, port 5080
[2010-05-28 09:41:21] VERBOSE[4445] dnsmgr.c:        > doing dnsmgr_lookup for 'callcentric.com'
[2010-05-28 09:41:21] VERBOSE[4445] srv.c:        > ast_get_srv: SRV lookup for '_sip._UDP.callcentric.com' mapped to host alpha8.callcentric.com, port 5080

Here is the line regarding cdr_addon_mysql.c:

2010-05-28 09:41:03] ERROR[24428] cdr_addon_mysql.c: Cannot connect to database server localhost: (1045) Access denied for user 'asteriskuser'@'localhost' (using password: YES)
2 
mythbox*CLI> module show like cdr
Module                         Description                              Use Count
cdr_custom.so                  Customizable Comma Separated Values CDR  0
app_cdr.so                     Tell Asterisk to not maintain a CDR for  0
cdr_csv.so                     Comma Separated Values CDR Backend       0
func_cdr.so                    Call Detail Record (CDR) dialplan functi 0
cdr_addon_mysql.so             MySQL CDR Backend                        0
app_forkcdr.so                 Fork The CDR into 2 separate entities    0
cdr_manager.so                 Asterisk Manager Interface CDR Backend   0
7 modules loaded