Hi again.
Trying Rate module, i have this info:
2013-03-25 15:32:13 on-net [email protected]
audio [email protected] 00:03 0.0000 0 0
The rate is 0.0000, but into Rates, I have Destination = 55559 and the
tariff.
Into telnet command i tried this:
ShowPrice From=sip:[email protected]
To=sip:[email protected] Gateway=187.5XXXXXXX Duration=59
0.0525
Increment: 6 s
Min duration: 30 s
Duration: 60 s
App: audio
Destination: 55
Customer: [email protected]
Connect: 0.0000
StartTime: 2013-03-25 15:18:47
--
Span: 1
Duration: 60 s
ProfileId: grn_premium / weekday
RateId: grn_premium / 0-24h
Rate: 0.0525 / 60 s
Price: 0.0525
but when I put To=sip:[email protected] the return is 0.
What am I missing?
Thanks
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br <http://www.syssvoip.com.br>
55 3537 2030
2013/3/25 Willian Mazzardo - SYSSVOIP <[email protected]
<mailto:[email protected]>>
Hi ... another thing.
Please review CSV files for importing sample data, because those
errors:
Mar 25 14:10:34 xen cdrtool[31701]: Database error for query
insert into log
(date,login,ip,url,results,description,datasource,reseller_id)#012
values
(NOW(),'ImportScript','localhost','customers.csv-e50d270391eb500aea66cc52600888d4','','Imported
/var/spool/cdrtool/customers.csv','/var/spool/cdrtool',0): Field
'reedit' doesn't have a default value (1364)
and
Reading file /var/spool/cdrtool/customers.csv
Importing customers from /var/spool/cdrtool/customers.csv for
reseller 0:
Database error for query insert into billing_customers
(
reseller_id,
gateway,
domain,
subscriber,
profile_name1,
profile_name2,
timezone,
profile_name1_alt,
profile_name2_alt
) values (
'0',
'',
'',
'',
'grn_premium',
'grn_premium',
'Europe/Amsterdam',
'',
''
): Field 'increment' doesn't have a default
value (1364)Database error for query insert into log
(date,login,ip,url,results,description,datasource,reseller_id)
values
(NOW(),'ImportScript','localhost','customers.csv-e50d270391eb500aea66cc52600888d4','','Imported
/var/spool/cdrtool/customers.csv','/var/spool/cdrtool',0): Field
'reedit' doesn't have a default value (1364)Reading file
/var/spool/cdrtool/destinations.csv
Thanks
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br <http://www.syssvoip.com.br>
55 3537 2030 <tel:55%203537%202030>
2013/3/25 Willian Mazzardo - SYSSVOIP <[email protected]
<mailto:[email protected]>>
Hi ... I`ve made the change in sql.conf
from FROM_UNIXTIME(blablabla) to '%S' and worked.
now I will see how to get rating work.
Thanks for your help Tijmen !! great job.
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br <http://www.syssvoip.com.br>
55 3537 2030 <tel:55%203537%202030>
2013/3/25 Tijmen de Mes <[email protected]
<mailto:[email protected]>>
Hi,
This is generated by the first radius server the ACC is
arriving. If you use only 1 server without any proxy,
relay or forwarding, I guess you can also use the %S
since there is no possibility to measure the network delay
in this case.
Best regards,
--
Tijmen de Mes
AG Projects
On 03/25/2013 03:58 PM, Willian Mazzardo - SYSSVOIP wrote:
Yes .. but how ? the filed in there is ${Event-Timestamp}
... but where is this generated?
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br <http://www.syssvoip.com.br>
55 3537 2030 <tel:55%203537%202030>
2013/3/25 Tijmen de Mes <[email protected]
<mailto:[email protected]>>
Hi,
If you find the cause for this, the problem will be
solved:
You see it FROM_UNIXTIME(), is empty , so that
won't work. You have to find out why the
event-timestamp attribute is now empty. To give
you any hints, what is in the detail file, and
in which format, is the attribute only defined
once in the dictionaries?
--
Tijmen de Mes
AG Projects
_______________________________________________
Users mailing list
[email protected]
<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
