asterisk users - Jun 2007 - write some custom values to CDR table

Hi,

   I write the CDR of my Asterisk 1.2.17 server in MySQL database  
using cdr_addon_mysql.so.

   Now I'm trying to write some custom values to userfield column by  
the SET(CDR(USERFILED)=SOME_TEXT) sintax, but nothing gets writeen in  
MySQL cdr table!!

   Why? I'm I skeeping something or what?

   Taking a look at the URL:  
http://www.voip-info.org/wiki/index.php?page=Asterisk+func+cdr
it seems to be this, the purpose of this SET(CDR(<NAME>))  
sintax, right?!

   Regards,
Ricardo.




-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070612/35849022/attachment.htm

Ricardo:
By default, the module cdr_addon_mysql doesn't store the userfield in the
table. You should configure this option by adding to the configuration file
cdr_mysql.conf the next line:
 userfield=1

Hope this helps.
Tom?s.

2007/6/12, rjcarvalho@reit.up.pt
<rjcarvalho@reit.up.pt>:
>
> Hi,
>
> I write the CDR of my Asterisk 1.2.17 server in MySQL database using
> cdr_addon_mysql.so.
>
> Now I'm trying to write some custom values to userfield column by the *
> Set(CDR(userfiled)=some_text)* sintax, but nothing gets writeen in MySQL
> cdr table!!
>
> Why? I'm I skeeping something or what?
>
> Taking a look at the URL:
> http://www.voip-info.org/wiki/index.php?page=Asterisk+func+cdr
> it seems to be this, the purpose of this *Set(CDR(<name>))* sintax,
> right?!
>
> Regards,
> Ricardo.
>
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070612/b7bb9c8c/attachment.htm

rjcarvalho@reit.up.pt wrote:
>
> Hi,
>
> it seems to be this, the purpose of this *Set(CDR(<name>))* sintax, 
> right?!
>
This should be:

SetCDRUserField()

show application setcdruserfield

Doug

-- 
 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."

Thanks to all that replied!

   Both suggestions you made, work just fine!

   Regards,
Ricardo.

   Quoting Doug Lytle <support@drdos.info>:
> rjcarvalho@reit.up.pt wrote:
>>
>> Hi,
>>
>> it seems to be this, the purpose of this *Set(CDR(<name>))*
sintax, right?!
>>
>
> This should be:
>
> SetCDRUserField()
>
> show application setcdruserfield
>
> Doug
>
> -- 
>
> Ben Franklin quote:
>
> "Those who would give up Essential Liberty to purchase a little
> Temporary Safety, deserve neither Liberty nor Safety."
>
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> ? ?http://lists.digium.com/mailman/listinfo/asterisk-users



-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070612/e32ea28b/attachment.htm

On 6/12/07, Doug Lytle <support@drdos.info> wrote:
> rjcarvalho@reit.up.pt wrote:
> >
> > Hi,
> >
> > it seems to be this, the purpose of this *Set(CDR(<name>))*
sintax,
> > right?!
> >
>
> This should be:
>
> SetCDRUserField()
>
> show application setcdruserfield
Actually SetCDRUserfield is deprecated in 1.4, and you will get
warning messages in your log. So, better use Set(CDR(userfield))
instead


Regards,
Atis