[cisco-voip] CCM 6.0 CDR Export to billing server

Mon Nov 26 10:51:40 EST 2007

In CCM 5 and 6 you can't access the database directly so you either have to rely on AXL/SQL statements or use the billing server parameters to get CDR exported every minute or so to an external server. This is now found in the Serviceability section in CCM under Tools>CDR Management.

It asks you to provide the IP, credentials and protocol (FTP or sFTP) to be used to connect to the "billing server".  It then exports flat ASCII files in CSV form to the external server.

You then import it in your database or billing tool and voilà !

   Jean-Francois Guay, ing.
  Consultant Technologies IP - Services Professionnels
  Communications Convergentes et Solutions Mobiles 
  Bell Solutions T.I.C
  ' 514-391-9698

________________________________

From: STEVEN CASPER [mailto:SCASPER at mtb.com] 
Sent: 26 novembre 2007 10:42
To: Guay, Jean-Francois (P010392)
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Problem wth freeSSHd SFTP backups on CCM 6.0

Could you provide some more information or a link on CDR export to the billing server using FTP? I was just discussing this issue this morning with our CDR group. They currently access the SQL CDR table in Call Manager 4.1.3 to pull out CDR data for processing and we were wondering how this would be achieved when we upgrade to CCM 6 and the Informix database.

Thanks,

Steve Casper
Voice Technologies
M&T Bank
(410) 347-6026

>>> <jean-francois.guay at bell.ca> 11/26/2007 10:05 AM >>>

The one TAC suggests is the one I have mentionned, freeFTPd and it works fine in my case.  It is found in solution# K96909292 at ciscotaccc.com

As for support for FTP, yes they should give you the option since that is already supported in the box for the CDR export to the billing server.

   Jean-Francois Guay, ing.
  Consultant Technologies IP - Services Professionnels
  Communications Convergentes et Solutions Mobiles 
  Bell Solutions T.I.C
  ' 514-391-9698

________________________________

From: Jason Wydra [mailto:jasonwydra at gmail.com] 
Sent: 24 novembre 2007 19:00
To: Jonathan Charles
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Problem wth freeSSHd SFTP backups on CCM 6.0

Like Jonathan said, Cisco should at least point us to a supported SFTP server if they're so stuck on not giving us another option.

On 11/24/07, Jason Wydra <jasonwydra at gmail.com> wrote: 

	 I wasted about 8 hours trying to get SFTP working with various server software. I'm going to escalate with Cisco because this is ridiculous!! If my new 6.0 install crashes in the meantime, I'm going to demand Cisco come out and rebuild it from scratch. 

	On 11/24/07, Jonathan Charles <jonvoip at gmail.com > wrote: 

		At the end of the day, you are a tragic victim of Cisco's short-sightedness.

		Every Linux server on the planet has a native SFTP server built in, so 
		those environments and users think this is the coolest thing ever.

		For most environments that are running Windows, SFTP is not supported,
		so we are forced to use really crappy applications to replicate this
		single feature.

		The solution is a mass email, phone and scream campaign to Cisco
		forcing them to support FTP for the backups.

		Which they won't do, because they have caught the Linux religion and
		they drank the kool-aid. 

		Jonathan

		On Nov 23, 2007 4:39 PM, Jason Wydra <jasonwydra at gmail.com> wrote:
		> I have a standalone SFTP server running Windows 2000. The server program I'm 
		> using is freeSSHd. When I add the SFTP server as a back-up device it just
		> hangs up for 5 to 10 minutes and then comes back with "update failed" (no 
		> details). While CCM was hanging I looked at the logs on freeSSHd and I could 
		> see that I got logged in successfully and was granted the SFTP service. Any
		> ideas what might be happening?
		>
		> Thanks,
		> Jason
		> _______________________________________________
		> cisco-voip mailing list
		> cisco-voip at puck.nether.net
		> https://puck.nether.net/mailman/listinfo/cisco-voip 
		>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20071126/3445c1f3/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1804 bytes
Desc: image001.gif
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20071126/3445c1f3/attachment-0002.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1804 bytes
Desc: ATT90679.gif
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20071126/3445c1f3/attachment-0003.gif 