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 00 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]=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 55 3537 2030 2013/3/25 Willian Mazzardo - SYSSVOIP <[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 > 55 3537 2030 > > > 2013/3/25 Willian Mazzardo - SYSSVOIP <[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 >> 55 3537 2030 >> >> >> 2013/3/25 Tijmen de Mes <[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 >>> 55 3537 2030 >>> >>> >>> 2013/3/25 Tijmen de Mes <[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] >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>>> >>> >>> >>> _______________________________________________ >>> Users mailing >>> [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 >>> >>> >> >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
