UNIF Сбор данных

Технические вопросы по UTM 5.0
Ответить
iru
Сообщения: 20
Зарегистрирован: Пт дек 14, 2007 16:53

UNIF Сбор данных

Сообщение iru »

косяк в том что дата разделена темже символом что и столбцы
Формат данных получаемых с АТС:

Код: Выделить всё

cat /var/tftp/billing.csv
1    ,27,01,2011,16,19,17,30      ,8126435010          ,4545054                       ,3  ,0.11    ,0.0pri  ,9  ,2  ,1  ,0  ,0 
2    ,27,01,2011,16,24,37,0       ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.13    ,2  ,9  ,0  ,0  ,0 
3    ,27,01,2011,16,24,40,3       ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.14    ,2  ,9  ,0  ,0  ,0 
4    ,27,01,2011,16,24,50,1       ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.16    ,2  ,9  ,0  ,0  ,0 
5    ,27,01,2011,16,25,09,1       ,8126435020          ,3466080                       ,3  ,0.18    ,0.1pri  ,9  ,2  ,1  ,0  ,0 
6    ,27,01,2011,16,25,00,12      ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.17    ,2  ,9  ,0  ,0  ,0
как быть?
каким образом экспотрировать в UTM?
Вернуться к началу
iru
Сообщения: 20
Зарегистрирован: Пт дек 14, 2007 16:53

Re: UNIF Сбор данных

Сообщение iru »

iru писал(а):косяк в том что дата разделена темже символом что и столбцы
Формат данных получаемых с АТС:

Код: Выделить всё

cat /var/tftp/billing.csv
1    ,27,01,2011,16,19,17,30      ,8126435010          ,4545054                       ,3  ,0.11    ,0.0pri  ,9  ,2  ,1  ,0  ,0 
2    ,27,01,2011,16,24,37,0       ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.13    ,2  ,9  ,0  ,0  ,0 
3    ,27,01,2011,16,24,40,3       ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.14    ,2  ,9  ,0  ,0  ,0 
4    ,27,01,2011,16,24,50,1       ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.16    ,2  ,9  ,0  ,0  ,0 
5    ,27,01,2011,16,25,09,1       ,8126435020          ,3466080                       ,3  ,0.18    ,0.1pri  ,9  ,2  ,1  ,0  ,0 
6    ,27,01,2011,16,25,00,12      ,8123466080          ,6435020                       ,3  ,0.0pri  ,0.17    ,2  ,9  ,0  ,0  ,0
как быть?
каким образом экспотрировать в UTM?
преобразовал скриптами это дело в

Код: Выделить всё

billing# cat /var/tftp/billing.utm
1|27.01.2011_16:19:17|30|8126435010|4545054|3|0.11|0.0pri|9|2|1|0|0
2|27.01.2011_16:24:37|0|8123466080|6435020|3|0.0pri|0.13|2|9|0|0|0
3|27.01.2011_16:24:40|3|8123466080|6435020|3|0.0pri|0.14|2|9|0|0|0
4|27.01.2011_16:24:50|1|8123466080|6435020|3|0.0pri|0.16|2|9|0|0|0
5|27.01.2011_16:25:09|1|8126435020|3466080|3|0.18|0.1pri|9|2|1|0|0
6|27.01.2011_16:25:00|12|8123466080|6435020|3|0.0pri|0.17|2|9|0|0|0
7|28.01.2011_16:59:01|29|8126435010|88129273220|3|0.19|0.0pri|9|2|1|0|0
запускаю с параметрами
/netup/utm5/bin/utm5_unif -n -s /var/tftp/billing.utm

в базе пусо статистики нет, ругаеться в консоле

Код: Выделить всё

billing# /netup/utm5/bin/utm5_unif -n -s /var/tftp/billing.utm
 Notice: Jan 28 17:45:39 28501140 UTM5 Config: Processing config file: /netup/utm5/utm5_unif.cfg
 ERROR : Jan 28 17:45:39 28501140 UTM5 Config: Import: parse error at line 148
 ERROR : Jan 28 17:45:39 28501140 UTM5 Config: Import: parse error at line 172
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; pbx_pos.pbx_called_sid <4> pbx_pos.pbx_calling_sid <3> pbx_pos.pbx_duration <5> pbx_pos.pbx_session_id <0> pbx_pos.pbx_date_time <1> pbx_quote <> pbx_pos.pbx_delimiter <|>
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Count <0> Processing line <1|27.01.2011_16&#58;19&#58;17|30|8126435010|4545054|3|0.11|0.0pri|9|2|1|0|0> size <67>
 Info  &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; Time parsed&#58; 16&#58;19&#58;17.000 MSK Thu Jan 27 2011
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; 1 elements to send unif tel data
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Count <1> Processing line <2|27.01.2011_16&#58;24&#58;37|0|8123466080|6435020|3|0.0pri|0.13|2|9|0|0|0> size <66>
 Info  &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; Time parsed&#58; 16&#58;24&#58;37.000 MSK Thu Jan 27 2011
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; 1 elements to send unif tel data
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Count <2> Processing line <3|27.01.2011_16&#58;24&#58;40|3|8123466080|6435020|3|0.0pri|0.14|2|9|0|0|0> size <66>
 Info  &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; Time parsed&#58; 16&#58;24&#58;40.000 MSK Thu Jan 27 2011
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; 1 elements to send unif tel data
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Count <3> Processing line <4|27.01.2011_16&#58;24&#58;50|1|8123466080|6435020|3|0.0pri|0.16|2|9|0|0|0> size <66>
 Info  &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; Time parsed&#58; 16&#58;24&#58;50.000 MSK Thu Jan 27 2011
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; 1 elements to send unif tel data
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Count <4> Processing line <5|27.01.2011_16&#58;25&#58;09|1|8126435020|3466080|3|0.18|0.1pri|9|2|1|0|0> size <66>
 Info  &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; Time parsed&#58; 16&#58;25&#58;9.000 MSK Thu Jan 27 2011
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; 1 elements to send unif tel data
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Count <5> Processing line <6|27.01.2011_16&#58;25&#58;00|12|8123466080|6435020|3|0.0pri|0.17|2|9|0|0|0> size <67>
 Info  &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; Time parsed&#58; 16&#58;25&#58;0.000 MSK Thu Jan 27 2011
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; 1 elements to send unif tel data
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Count <6> Processing line <7|28.01.2011_16&#58;59&#58;01|29|8126435010|88129273220|3|0.19|0.0pri|9|2|1|0|0> size <71>
 Info  &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; Time parsed&#58; 16&#58;59&#58;1.000 MSK Fri Jan 28 2011
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 UNIF&#58; 1 elements to send unif tel data
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; Moving RADIUS packet into send queue
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 RadiusSocket&#58; RADIUS raw data sent
?Debug &#58; Jan 28 17&#58;45&#58;39 28501140 &#58; Lines sent&#58;<7> working time&#58;<0> sec
вот конфиг

Код: Выделить всё

billing# cat /netup/utm5/utm5_unif.cfg | grep -v '^#'
data_source=pbx
core_host=127.0.0.1
сore_login=init
сore_password=init
radius_dst_host=127.0.0.1
radius_port=1813
radius_secret=secret
radius_nas_name=localhost
pbx_calling_sid=3
pbx_called_sid=4
pbx_duration=5
pbx_session_id=0
pbx_date_time=1
pbx_date_format=%D.%N.%Y_%H&#58;%M&#58;%S
pbx_delimiter=|
pbx_quote=
log_level 3
dont_use_radius 1
гЫде я ошыбся ??
Вернуться к началу
Ответить

Вернуться в «UTM 5.0»