Asterisk 1.8 and CDR

Asterisk Asterisk Support
1

Since I upgrade my Asterisk Box from 1.6 to 1.8 my CDR with MySQL stop recording calls. I’ve played with configuration and the last error that I have is
ERROR[26712]: cdr_sqlite3_custom.c:277 write_cdr: attempt to write a readonly database
But I can enter the same record into this database manually through mysql by cut and paste insert string from Asterisk CLI Monitor. Only thought that I have is that 1.8 needs another table structure and some of the indexes from 1.6 are not in 1.8. But difference that I found so far is that 1.8 needs additional “test” field in the cdr table.

Here are my config files:

odbc.ini
[asterisk]
Description =Connection to ‘Asterisk’ database
Driver =MySQL
Database =Asterisk
Server =localhost
User =*******
Password =******
Option =3

odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1

cdr_odbc.conf
[global]
dsn=asterisk
username=************
password=*************
loguniqueid=yes
dispositionstring=yes
table=cdr
;usegmtime=no

res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk
;username => *******
;password => *******
pre-connect => yes
table => cdr

odbc show:
ODBC DSN Settings

Name: asterisk
DSN: asterisk
Last connection attempt:
Pooled: No
Connected: Yes

2

seems to be a permission setting in your DB
Asterisk is able to connect to the DB but not write to it, hence you have the “cannot write on readonly database” error message.

3

That is the thing. I can copy and paste INSER String from Asterisk Monitor into mysql with the same account and have it recorded with no problem. It looks like 1.8 have an additional security settings somewhere. CDR was running fine before I upgraded this box from 1.6.