The mysql schema is available in the doc/cdr_mysql.txt file (from the asterisk source dir)
James On Thu, 3 Jul 2003, Kim C. Callis wrote: > You can find the comma delimited file at /var/log/asterisk/cdr-csv or if > you are looking to do some easy querying on a database, you need to > create a schema that I am sure someone on the channel has defined > somewhere. At that point you clean up the /etc/asterisk/cdr_mysql.conf > file to point to the appropriate database and authentication > information. > > Kim C. Callis > > -----Original Message----- > From: Angelo Sampietro [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 02, 2003 8:07 AM > To: Kim C. Callis > Cc: [EMAIL PROTECTED] > Subject: Re[4]: [Asterisk-Users] Asterisk PBX Billing > > thanks a lot! > can you tell me where can i find more info about the CDR? > probably this will be the better way to give to the company a summary > with all the phone traffic :) > > Angelo > > > > Thursday, July 3, 2003, 4:37:32 PM, you wrote: > > KCC> There is a CDR (Call Detail Record) which is accessible in two > different > KCC> ways. The first is via a simple comma delimited file which can be > parsed > KCC> and fed into whatever database that you want. The second way is to > dump > KCC> the CDR directly into MySQL, and extract accordingly. So the only > trick > KCC> there is to create a database for billing and create a relationship > that > KCC> will extract from the CDR database. > > KCC> Kim C. Callis > > KCC> -----Original Message----- > KCC> From: [EMAIL PROTECTED] > KCC> [mailto:[EMAIL PROTECTED] On Behalf Of Angelo > KCC> Sampietro > KCC> Sent: Wednesday, July 02, 2003 7:06 AM > KCC> To: Scott Stingel > KCC> Cc: [EMAIL PROTECTED] > KCC> Subject: Re[2]: [Asterisk-Users] Asterisk PBX Billing > > KCC> i think that the problem could be something more easy: > > KCC> it is possible inside asterisk to log all che calls of all the > users > KCC> and know the timing and the number called for each call? > KCC> if it is possible to do that, could be possible to make a program > KCC> that takes this files and generate the costs reading the log > KCC> informations... > > KCC> so for me the real question is: there is a log of all the phone > call > KCC> that are made by asterisk? > > KCC> Angelo > > > > KCC> Wednesday, July 2, 2003, 3:28:22 PM, you wrote: > > SS>> Shepherd- > > SS>> Having designed one of these in the past (in a higher level voice > SS>> environment), I can tell you that this is not a small undertaking. > KCC> It's at > SS>> least as much an SQL job as a voice task. > > SS>> Usually the way to accomplish this is to establish more-or-less a > KCC> pre-paid > SS>> phone card system, where the shop prepays an overall amount for > SS>> international calling access. Then you have to time each call as > it > KCC> is > SS>> occurring, debiting each account, and the master account, in > KCC> real-time. This > SS>> can be a bit complex when you have 20 or 30 calls going at one > time. > KCC> You > SS>> have to cut them off promptly when the money runs out (big > problem). > KCC> And > SS>> you have to provide call detail and charges to them at the end of > KCC> each call, > SS>> using their own retail tariff. > > SS>> To add to the complexity, each country has a different tariff from > KCC> the long > SS>> distance carrier, and within the country, major cities often have > KCC> special > SS>> rates per minute. Mobiles have a different tariff too. Phone card > SS>> platforms usually include a least-cost routing system which chooses > KCC> a > SS>> carrier real time based on the call. Tariffs change weekly and > must > KCC> be > SS>> updated in the system. > > SS>> Anyway, I'm just scratching the surface! I'll write more when I > KCC> can! > > SS>> Cheers > SS>> Scott Stingel > > > SS>> Scott M. Stingel > SS>> Emerging Voice Technology Inc. > > SS>> Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > SS>> URL: www.evtmedia.com <http://www.evtmedia.com> > > > > >>> -----Original Message----- > >>> From: [EMAIL PROTECTED] > >>> [mailto:[EMAIL PROTECTED] On Behalf Of > >>> shepherd fungayi > >>> Sent: Wednesday, July 02, 2003 10:49 AM > >>> To: [EMAIL PROTECTED] > >>> Subject: [Asterisk-Users] Asterisk PBX Billing > >>> > >>> > >>> Hi > >>> > >>> I would like to use the Asterisk PBX as part of a phone shop > >>> system instead > >>> of the usual PBX plus PC. How can I do the the billing in a > >>> way that is > >>> convinient to the phone shop attendant? > >>> > >>> Regards > >>> > >>> Shepherd > >>> > >>> _________________________________________________________________ > >>> Add photos to your messages with MSN 8. Get 2 months FREE*. > >>> http://join.msn.com/?page=features/featuredemail > >>> > >>> _______________________________________________ > >>> Asterisk-Users mailing list > >>> [EMAIL PROTECTED] > >>> http://lists.digium.com/mailman/listinfo/asterisk-users > >>> > >>> > > > > SS>> _______________________________________________ > SS>> Asterisk-Users mailing list > SS>> [EMAIL PROTECTED] > SS>> http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > > > -- > Angelo Sampietro > IT Manager > ARC Interactive > > "After a certain high level of technical skill is achieved, > Science and art tend to coalesce in esthetics, plasticity, and form. > The greatest scientists are always artists as well." > > Albert Einstein > > > _______________________________________________ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users