2VALite


#1

Hi all.

I trying 2VALite billing system (2valite.vanabel.com).
Only one problem: CDR ratings not work.
Schema: Asterisk generated mysql cdr -> 2vadatabase (cdr table) -> I running cdr_processing.pm -> Nothing.

2VALite log file (this correct?): :open_mouth:

PRICING_ONNET-1=PRICING_GLOBAL
PRICING_GLOBAL-1=ROUNDING_SECS
ROUNDING_SECS-10=INTL_DIAL_DIGITS
INTL_DIAL_DIGITS-00=SIP_DIGITS_DIALING
SIP_DIGITS_DIALING-0=SIP_SRC_CHANNEL
SIP_SRC_CHANNEL-0=ACCOUNT_NO_TYPE
ACCOUNT_NO_TYPE-3=CHECK_LOCAL_DIGITS_INTL
CHECK_LOCAL_DIGITS_INTL-0=CHECK_LOCAL_DIGITS_USA
CHECK_LOCAL_DIGITS_USA-0=LOCAL_DIGITS_TO_CHECK
LOCAL_DIGITS_TO_CHECK-0=MINIMUM_BILLABLE_SECS
MINIMUM_BILLABLE_SECS-1=PROCESS_ROUTINES
PROCESS_ROUTINES-3=REPROCESS_ERRORS
REPROCESS_ERRORS-1=CDR_TESTING
CDR_TESTING-1=CDR_DELETES
CDR_DELETES-1=SER_NAME
SER_NAME-localhost=SER_IMPORT_ACTIVE_NOW
SER_IMPORT_ACTIVE_NOW-1=SER_LAST_VA_BATCH_ID
SER_LAST_VA_BATCH_ID-0=SER_LAST_VA_STAMP
SER_LAST_VA_STAMP-2005-05-27 14:32:16=SER_SERVER_NAME
SER_SERVER_NAME-SantaClaus=SER_SERVER_NAME
SER_SERVER_NAME-216.127.68.21=SER_SERVER_PORT
SER_SERVER_PORT-0=SER_SERVER_ENABLED
SER_SERVER_ENABLED-1=SER_SERVER_LOCATION
SER_SERVER_LOCATION-home=SER_SERVER_INFO
SER_SERVER_INFO-voip - MySQL=SER_DATABASE_TYPE
SER_DATABASE_TYPE-MYSQL=SER_DATABASE_NAME
SER_DATABASE_NAME-2va=SER_SDB_USERNAME
SER_SDB_USERNAME-2va=SER_SDB_PASSWORD
SER_SDB_PASSWORD-*******=CYCLE_STATUS
CYCLE_STATUS-2=INVOICE_NO_STYLE
INVOICE_NO_STYLE-0=ACCOUNTCODE_CHECK
ACCOUNTCODE_CHECK-0=NO_ANSWER_CHECK
NO_ANSWER_CHECK-1=BUSY_CHECK
BUSY_CHECK-1=LASTAPP_VOICEMAIL_CHECK
LASTAPP_VOICEMAIL_CHECK-0=BILLSEC_CHECK
BILLSEC_CHECK-1=INVOICE_DAY_OF_MONTH
INVOICE_DAY_OF_MONTH-7=DST_MATCH_CHECK
DST_MATCH_CHECK-7=
1. Begin Importing CDRs from Asterisk Servers... Not Available in 2VALite

Edit & modified cdr_procesing.pm:
$process_routines = 2

log:

login info: MYSQL, 2va *******
Deleted CDR_ERRORS rows =
DBD::mysql::st execute failed: 'rated' ...... 'where clause' at ../../MODULES/Cdr.pm line 1527.
DBD::mysql::st execute failed: Syntax error '' at ../../MODULES/Cdr.pm line 2063.
Rows Deleted from cdr_rated_summary: -3
DBD::mysql::st execute failed:  Syntax error '' at ../../MODULES/Cdr.pm line 975.
DBD::mysql::st execute failed: 'vendor_id' ...... 'where clause'-at ../../MODULES/Cdr.pm line 975.
DBD::mysql::st execute failed:  Syntax error 'and customer_id = 0 AND src = '0'' ..... at ../../MODULES/Cdr.pm line 975.
DBD::mysql::st execute failed: 'vendor_id' ...... 'field list'-ben at ../../MODULES/Cdr.pm line 401.
Rows Rows added to cdr_rated_summary: 0

Somebody?

Sorry, my english very, very poor… :frowning: