30 Jan
2006
30 Jan
'06
1:54 p.m.
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(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