[Users] Re: [Serusers] acc module db_extra accounting issue

[Marcello Lupo]

Hi,
yes i'm sure that there is no further processing in the script.
As i wrote in a previous email if i change the value type from 3 (int int) to 
2 (int string), and not changing anything else, the value is accounted 
correctly.
I was only using type 3 (int int) for performances reason as the values are 
managed from Openser. If you tell me that there is no difference, in 
performance) between the 2 way of handling values i can use all of them as 
type 2 (int string).
Anyway i will try to change type of column in the acc table from int to 
varchar leaving the avpops values as type 3 (int int) to check the difference 
if any.
Thanks,
Bye,
Marcello


Alle 10:26, domenica 29 gennaio 2006, Daniel-Constantin Mierla ha scritto:
> Hello,
>
> the columns for extra accounting in the acc table must be varchar(). The
> acc module prints the extra variables as string in database. Anyhow, as
> far as I know, it should work with columns of type int, mysql accepts to
> insert a quoted integer (e.g., insert into table test (int_column)
> values ('1234') - is a valid statement).
>
> Are you sure that there is no other processing in the script of that
> avp? Please note that the accounting record is written when the reply is
> received.
>
> To check the proper functionality use following example:
>         avp_write("i:12", "i:102");
>         acc_db_request("done", "acc");
>
> And then check the record in database.
>
> Cheers,
> Daniel
>
> On 01/27/06 12:51, Marcello Lupo wrote:
> > Hi,
> > acc ver:
> >
> >  * $Id: acc.c,v 1.5 2005/07/05 15:43:38 anomarme Exp $
> >
> > avpops ver:
> >
> > * $Id: avpops.c,v 1.14 2005/09/12 17:20:10 miconda Exp $
> >
> > I'm using stable tls version of openser 1.0.0 and shipped modules.
> > Thanks,
> > Bye,
> > Marcello
> >
> > Alle 11:45, venerdì 27 gennaio 2006, Bogdan-Andrei Iancu ha scritto:
> >> Hi Marcello,
> >>
> >> what version are you using?
> >>
> >> regards,
> >> bogdan
> >>
> >> Marcello Lupo wrote:
> >>> Final information.
> >>> If i change the avp type from 3 (int_int) to 2 (int_string) it is
> >>> accounted correctly.
> >>> May be a bug in how int int avp values are passed from avp module to
> >>> acc module?
> >>> Thanks,
> >>> Bye,
> >>> Marcello
> >>>
> >>> Alle 11:32, venerdì 27 gennaio 2006, Marcello Lupo ha scritto:
> >>>> Hi,
> >>>> more information about it..
> >>>> I changed the value to 55 and it is now written in the table as 51 .
> >>>> Thanks
> >>>> Bye,
> >>>> Marcello
> >>>>
> >>>> Alle 11:27, venerdì 27 gennaio 2006, Marcello Lupo ha scritto:
> >>>>> Hi,
> >>>>> i have a db_extra accounting rule like:
> >>>>>
> >>>>> modparam("acc", "db_extra", "customer_code=$avp(i:102)")
> >>>>>
> >>>>> The avp value is 12 and i checked it with avp_print() .
> >>>>>
> >>>>> DEBUG:avpops:print_avp: p=0x2a97a866e8, flags=0
> >>>>> DEBUG:                 id=<102>
> >>>>> DEBUG:                 val_int=<12>
> >>>>>
> >>>>> When it is accounted in the table the value become 11 !!!!!
> >>>>> the field in the table is type int(10) .
> >>>>>
> >>>>> How is it possible??
> >>>>> Thanks,
> >>>>> Bye,
> >>>>> MArcello
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> _______________________________________________
> >>>>> Serusers mailing list
> >>>>> Serusers at iptel.org
> >>>>> http://mail.iptel.org/mailman/listinfo/serusers
> >>>>
> >>>> _______________________________________________
> >>>> Serusers mailing list
> >>>> Serusers at iptel.org
> >>>> http://mail.iptel.org/mailman/listinfo/serusers
> >>>
> >>> _______________________________________________
> >>> Users mailing list
> >>> Users at openser.org
> >>> http://openser.org/cgi-bin/mailman/listinfo/users
> >
> > _______________________________________________
> > Users mailing list
> > Users at openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users