29 Jan
2006
29 Jan
'06
11:26 a.m.
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(a)iptel.org
>>> http://mail.iptel.org/mailman/listinfo/serusers
>>>
>> _______________________________________________
>> Serusers mailing list
>> Serusers(a)iptel.org
>> http://mail.iptel.org/mailman/listinfo/serusers
>>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users