[asterisk-users] hostname in MySQL CDR records

Anthony Messina amessina at messinet.com
Tue Nov 27 10:37:30 CST 2007


On Thursday 01 November 2007 12:57:10 am Steve Edwards wrote:
> On Wed, 31 Oct 2007, Jim Gottlieb wrote:
> > I would like to send the CDR records from all our machines around the
> > world to a single database.  But I need the hostname included with each
> > record for monitoring purposes.
> >
> > Is there a better way than using the userfield and adding
> > SetCDRUserfield for every call to set the userfield to the name of the
> > host?
>
> Personally, I think the "userfield" is a hack. I prefer to add properly
> named columns to the cdrs table using cdr_addon_mysql. It makes everything
> so much more obvious -- especially when you don't have to cram several
> values into the singularly obtuse userfield.

i'm sure i'm missing something.  i, too, would like to add custom fields using 
cdr_addon_mysql, but how and where would i define them?  can i add a 
[mappings] section to the cdr_mysql.conf file?

-- 
Anthony -  http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E
-------------- 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/20071127/9470750b/attachment.pgp 


More information about the asterisk-users mailing list