Where are you storing/reading CDR? Can we now eliminate MySQL since the GUI doesn't use it?
# sqlite /var/lib/asterisk/sqlite.db '.schema ast_cdr'
CREATE TABLE 'ast_cdr' (
id INTEGER,
clid VARCHAR(80) NOT NULL DEFAULT '',
src VARCHAR(80) NOT NULL DEFAULT '',
dst VARCHAR(80) NOT NULL DEFAULT '',
dcontext VARCHAR(80) NOT NULL DEFAULT '',
channel VARCHAR(80) NOT NULL DEFAULT '',
dstchannel VARCHAR(80) NOT NULL DEFAULT '',
lastapp VARCHAR(80) NOT NULL DEFAULT '',
lastdata VARCHAR(80) NOT NULL DEFAULT '',
start DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
answer DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
end DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
duration INT(11) NOT NULL DEFAULT 0,
billsec INT(11) NOT NULL DEFAULT 0,
disposition VARCHAR(45) NOT NULL DEFAULT '',
amaflags INT(11) NOT NULL DEFAULT 0,
accountcode VARCHAR(20) NOT NULL DEFAULT '',
uniqueid VARCHAR(32) NOT NULL DEFAULT '',
userfield VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (id)
);
billsimon Because of reported conflicts between SQLite2 and 3, we're decided to use a standard CSV file for CDR info.
Asterisk-GUI was written a long time ago. I'll be glad to shoot you a copy if you'd like to tackle updating the SQLite piece. It's only used for the CDR. Ast.DB already uses SQLite3 in Asterisk 11, and we've got all of that working fine.
How about we collaborate in a github repo?
I'm curious as to what this new project means, is this something that PIAF will be able to call all it's own and have more control on what happens with the dial plan and perhaps the over all direction of the product, is this a completely different dial plan than FreePBX, if so this sounds like it could be a big step forward for PIAF.
Is there any downloads we can get to play with and is it stable with it's current status or our you just getting started and it will be a while before it gets there. This all seems very exciting if that is what's happening here.
Gary.
I've got git dumbed down to the point where I can use it. Will get you up and running if you're interested.
That will take another lesson (at my end) so perhaps we can hold off until I get something out the door.
Link up your team and customers Phone System Live Chat Video Conferencing
Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.
Check your inbox!
We’ve sent you an email. Click on the button in the email body to verify your email address – (if you can not find it, check your spam folder).
Upon verification you will be directed to the 3CX setup wizard.