Hello 1.- I am testing a2billing in a SER-Asterisk implementation but using Mysql versions 4.1.15 and 5.0.15 because I want to integrate its cdr with some tables from Ser database, the a2billing-mysql-schema does not work properly in mysql-5 and in 4.1.15 works well but now I found this issue related to cdr?s: I can see cdr records in 'call' table from mysql console but they don't appear in a2bill web interface, I only can see records of current date ...not sure if its a mysql 4.x incompatibility so now I?ve installed postgres to verify, let me now if someone has same problem. 2.- How can I generate invoices in PDF format?, a2billing has the option but it doesnt work for me... do I have to install some aditional software? 3.- I am using caller-id authentication for calls originated in SER but I would like to know if its possible to auto create a card each time a new callerID is found? I?ve already tried with cid_auto_create_card options without success and I think it only works when there is no caller-id present, please confirm that. thanks Rafael -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051115/d1802b03/attachment.htm
Rafael R. GV wrote:> Hello > > 1.- I am testing a2billing in a SER-Asterisk implementation but using > Mysql versions 4.1.15 and 5.0.15 because I want to integrate its cdr > with some tables from Ser database, the a2billing-mysql-schema does not > work properly in mysql-5 and in 4.1.15 works well but now I found this > issue related to cdr?s: I can see cdr records in 'call' table from mysql > console but they don't appear in a2bill web interface, I only can see > records of current date ...not sure if its a mysql 4.x incompatibility > so now I?ve installed postgres to verify, let me now if someone has same > problem.Make sure your cdr table is called 'calls' and not 'call'. This causes a reserved word conflict in mysql 5.0.15, not sure about mysql4. Enable logging in asterisk and raise the debug level from asterisk cli to see what's happening with the INSERT query.> 2.- How can I generate invoices in PDF format?, a2billing has the option > but it doesnt work for me... do I have to install some aditional software?Probably you're missing the tools for creating the pdf files. Pdflib etc.> 3.- I am using caller-id authentication for calls originated in SER but > I would like to know if its possible to auto create a card each time a > new callerID is found? I?ve already tried with cid_auto_create_card > options without success and I think it only works when there is no > caller-id present, please confirm that.To my experience, this feature is currently not working. Mr. Areski is aware of the problem and promised to look into it. Regards, Vahan
Rafael - To generate PDF documents, you may need to install Adobe PDF Writer, or the full version of Acrobat that includes the reader and writer. Just a guess. Cory Andrews Senior Partner +++++++++++ VOIPSupply.com 454 Sonwil Drive Buffalo, NY 14225 +++++++++++ voice - 716.630.1555 X22 email - Cory@VOIPSupply.com fax - 716.630.1548 Rafael R. GV wrote:> Hello > > 1.- I am testing a2billing in a SER-Asterisk implementation but using > Mysql versions 4.1.15 and 5.0.15 because I want to integrate its cdr > with some tables from Ser database, the a2billing-mysql-schema does > not work properly in mysql-5 and in 4.1.15 works well but now I found > this issue related to cdr?s: I can see cdr records in 'call' table > from mysql console but they don't appear in a2bill web interface, I > only can see records of current date ...not sure if its a mysql 4.x > incompatibility so now I?ve installed postgres to verify, let me now > if someone has same problem. > > 2.- How can I generate invoices in PDF format?, a2billing has the > option but it doesnt work for me... do I have to install some > aditional software? > > 3.- I am using caller-id authentication for calls originated in SER > but I would like to know if its possible to auto create a card each > time a new callerID is found? I?ve already tried with > cid_auto_create_card options without success and I think it only works > when there is no caller-id present, please confirm that. > > > thanks > Rafael > > > > > > > > >------------------------------------------------------------------------ > >_______________________________________________ >--Bandwidth and Colocation sponsored by Easynews.com -- > >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
On Tue, 2005-11-15 at 19:01 -0500, Cory Andrews wrote:> Rafael - To generate PDF documents, you may need to install Adobe PDF > Writer, or the full version of Acrobat that includes the reader and > writer. Just a guess.Wouldnt an open source solution that is basically just libraries work better in a server type environment? I know there are many many php scripts that do this that way. I do not know however (never bothered to look) if adobe pdf writer is available outside windows. -- Trixter http://www.0xdecafbad.com Bret McDanel UK +44 870 340 4605 Germany +49 801 777 555 3402 US +1 360 207 0479 or +1 516 687 5200 FreeWorldDialup: 635378 http://www.sacaug.org/ Sacramento Asterisk Users Group -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20051115/8318f1be/attachment.pgp