I use this procedures for CDR to MySQL
http://localhost/reg_status.htm?save=save&..._db_name=DBNAME
http://localhost/reg_status.htm?save=save&...name=TABLE_NAME
http://localhost/reg_status.htm?save=save&..._user_name=root
http://localhost/reg_status.htm?save=save&...d=ROOT_PASSWORD
manualy change pbx.xml;
<cdr_format>$f$t$i$v$m$l$R$S$C$A$x$y$F$T$r$E$W$w$B$b$e$o$c$d$s</cdr_format>
beware of "disable grant tables"
Also you can use this script to create DB and table;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
CREATE SCHEMA IF NOT EXISTS `PBX3` ;
USE `PBX3`;
-- -----------------------------------------------------
-- Table `DBNAME`.`TABLE_NAME`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DBNAME`.`TABLE_NAME` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`sip_from` VARCHAR(255) NULL ,
`sip_to` VARCHAR(255) NULL ,
`call_id` VARCHAR(255) NULL ,
`call_type` VARCHAR(45) NULL ,
`domain` VARCHAR(45) NULL ,
`lang` VARCHAR(45) NULL ,
`account` VARCHAR(45) NULL ,
`start_time` VARCHAR(45) NULL ,
`talk_duration` INT(11) NULL ,
`ring_duration` INT(11) NULL ,
`orig_trunk` VARCHAR(45) NULL ,
`dest_trunk` VARCHAR(45) NULL ,
`calling` VARCHAR(255) NULL ,
`called` VARCHAR(255) NULL ,
`redirect_dest` VARCHAR(255) NULL ,
`hold_duration` INT(11) NULL ,
`wait_duration` INT(11) NULL ,
`start_date_time` VARCHAR(45) NULL ,
`time` VARCHAR(45) NULL ,
`date` VARCHAR(45) NULL ,
`extension` VARCHAR(45) NULL ,
`direction` VARCHAR(1) NULL ,
`remote_call_id` VARCHAR(45) NULL ,
`duration` INT(11) NULL ,
`extn_duration` INT(11) NULL ,
`record_location` VARCHAR(255) NULL ,
PRIMARY KEY (`id`) )
ENGINE = MyISAM;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;