Работа с Statget

[royun]

Добрый день.

Все настроил по инструкции.

1. Установил MySQL версии 5.1.36 на рабочую станцию, где стоит MC240
2. Создал БД ChNN, пользователя tsi с паролем tsi и разрешил ему доступ к БД ChNN
3. Установил mysql-connector-odbc версии 5.1.5
4. Натроил ODBC так:

Data Source Name: ChNN
Server: Localhost Port: 3306
User: tsi
Password: tsi
DataBase: ChNN

5. Установил программу statget
6. Создал задание для планировщика задач, который запускает программу statget ежедневно, каждый 1 час, в течении 24 часов. В поле «Выполнить» добавил к имени файла программы имя конфигурационного файла, следующим образом:

C:\statget\statget.exe statget.conf

В statget.conf параметры написал следующим образом:

[CONFIG]
Target=cpu3

Error Log File=file.log
Read Log=1
Read Logs Path=./readlogs
Read Logs Keep Period=7
Debug Level=3

ODBC Data Source=ChNN
- тут была строка MySQL Server=, я его удалил, т.к. настроил источник данных ODBC
MySQL Port=3306
MySQL DB=ChNN
MySQL User=tsi
MySQL Pass=tsi

Counters Store Period=32
Busy Hours=1
Busy Hours Store Period=32
SNMP Version=1
Security Name=admin
Pass Phrase=password
Agent Address=192.168.6.88
Community=public
Repetitions=20
ASCID=16
Log Count Change Warnings=1
CountersReset=0
Reports Path=./reports
Reports Count=1
Reports Type 1=StatInOut
Reports Keep Period=30
Journal 5=1
Journal 6=1

#Aggregation
Day Summary=1
Week Summary=1
Month Summary=1
Quarter Summary=1
Year Summary=1
Day Summary Keep Period=32
Week Summary Keep Period=365
Month Summary Keep Period=365
Quarter Summary Keep Period=370
Year Summary Keep Period=1460

Relc Counters=0
[/CONFIG]

В файле error.log пишет:

2011-10-10 08:59:57 : Log started
2011-10-10 08:59:57 : SNMP Agent Address: 192.168.6.88
2011-10-10 08:59:57 : Initializing ODBC...
2011-10-10 08:59:57 : ODBC:Success.
2011-10-10 09:00:03 : SNMPWALK:Timeout
2011-10-10 09:00:10 : SNMPWALK:Timeout
2011-10-10 09:00:10 : WARNING. Got 0 TGs. See log above for SNMP errors or check station configuration.
2011-10-10 09:00:16 : SNMPWALK:Timeout
2011-10-10 09:00:16 : WARNING. Got 0 plans. See log above for SNMP errors or check station configuration.
2011-10-10 09:00:16 : Got no objects. No records will be created.
2011-10-10 09:00:16 : getData: Received from DB 0 TGs and 0 plans. There will be no further processing.
2011-10-10 09:00:16 : 19 seconds elapsed.
2011-10-10 09:00:16 : Log finished

В файле debug.log пишет:

Debug log started at 2011-10-10 08:59:57
Debug level = 3

2011-10-10 08:59:57 : main:Opening log file.
2011-10-10 08:59:57 : main:Opened log file.
2011-10-10 08:59:57 : main: Allocating memory for buffer
2011-10-10 08:59:57 : main:call to CreateDirectories()
2011-10-10 08:59:57 : CreateDirectories: mkdir returned 0, errno=0
2011-10-10 08:59:57 : CreateDirectories: mkdir returned -1, errno=17
2011-10-10 08:59:57 : main:call to checkAggregationParameters()
2011-10-10 08:59:57 : checkAggregationParameters:Exiting
2011-10-10 08:59:57 : main:call to ODBCInitialize()
2011-10-10 08:59:57 : ODBCInitialize: Connect using DSN name
2011-10-10 08:59:57 : ODBCInitialize: Driver returned string: DSN=ChNN;
2011-10-10 08:59:57 : main:call to PrepareMibs()
2011-10-10 08:59:57 : PrepareMibs:Allocating memory for buffer
2011-10-10 08:59:57 : PrepareMibs:Exiting
2011-10-10 08:59:57 : main:call to getData()
2011-10-10 08:59:57 : SNMPVer = 1
2011-10-10 08:59:57 : addEltexPrefix: called with mcDevType
2011-10-10 08:59:57 : addEltexPrefix: returning eltex.elHardware.mc240.mcDevType
2011-10-10 08:59:57 : makeWalkRequest: called with oidName=eltex.elHardware.mc240.mcDevType
2011-10-10 09:00:03 : makeWalkRequest: Results count=0
2011-10-10 09:00:03 : getData:Requesting trunks count
2011-10-10 09:00:03 : addEltexPrefix: called with mc240TgStatInTable.mc240TgStatInEntry.mc240TgInId
2011-10-10 09:00:03 : addEltexPrefix: returning eltex.elHardware.mc240.mc240TgStatInTable.mc240TgStatInEntry.mc240TgInId
2011-10-10 09:00:03 : makeWalkRequest: called with oidName=eltex.elHardware.mc240.mc240TgStatInTable.mc240TgStatInEntry.mc240TgInId
2011-10-10 09:00:10 : makeWalkRequest: Results count=0
2011-10-10 09:00:10 : snmpErrorsCount = 1
2011-10-10 09:00:10 : getData:SNMP reported 0 trunks
2011-10-10 09:00:10 : getData:Requesting plans count
2011-10-10 09:00:10 : addEltexPrefix: called with mc240UserStatInTable.mc240UserStatInEntry.mc240UserInIndex
2011-10-10 09:00:10 : addEltexPrefix: returning eltex.elHardware.mc240.mc240UserStatInTable.mc240UserStatInEntry.mc240UserInIndex
2011-10-10 09:00:10 : makeWalkRequest: called with oidName=eltex.elHardware.mc240.mc240UserStatInTable.mc240UserStatInEntry.mc240UserInIndex
2011-10-10 09:00:16 : makeWalkRequest: Results count=0
2011-10-10 09:00:16 : snmpErrorsCount = 2
2011-10-10 09:00:16 : getData:SNMP reported 0 plans
2011-10-10 09:00:16 : getData:call to createTables()
2011-10-10 09:00:16 : ODBCCheckIfTableExists: called with tableName=transactions
2011-10-10 09:00:16 : ODBCCheckIfTableExists: returning 1
2011-10-10 09:00:16 : ODBCCheckIfTableExists: called with tableName=call_counters
2011-10-10 09:00:16 : ODBCCheckIfTableExists: returning 1
2011-10-10 09:00:16 : ODBCCheckIfTableExists: called with tableName=usage_counters
2011-10-10 09:00:16 : ODBCCheckIfTableExists: returning 1
2011-10-10 09:00:16 : ODBCCheckIfTableExists: called with tableName=relc_counters
2011-10-10 09:00:16 : ODBCCheckIfTableExists: returning 1
2011-10-10 09:00:16 : ODBCCheckIfTableExists: called with tableName=trunk_names
2011-10-10 09:00:16 : ODBCCheckIfTableExists: returning 1
2011-10-10 09:00:16 : ODBCCheckIfTableExists: called with tableName=plan_names
2011-10-10 09:00:16 : ODBCCheckIfTableExists: returning 1
2011-10-10 09:00:16 : ODBCCheckIfTableExists: called with tableName=busy_hours
2011-10-10 09:00:16 : ODBCCheckIfTableExists: returning 1
2011-10-10 09:00:16 : getData: call to ODBCGetTgIDs()
2011-10-10 09:00:16 : ODBCGetTgIDs: Receiving 0 results
2011-10-10 09:00:16 : getData: call to ODBCGetPlanIDs()
2011-10-10 09:00:16 : ODBCGetPlanIDs: Receiving 0 results
2011-10-10 09:00:16 : getData: Aborted due to zero objects count
2011-10-10 09:00:16 : main:call to ODBCFinalize()
2011-10-10 09:00:16 : main:call to CleanUpLogs()
2011-10-10 09:00:16 : main:call to CleanupReports()

После всех настроек станцию перезагрузили. Отчеты в папке reports так и не появились. Где, что не правильно делаю помогите пожалуйста.

[Анна]

1. Зайдите в файл pbx.ini (мониторинг -> файловая система -> двойным щелчком по фалу pbx.ini ).
2. Установите флаг snmp enable
3. Пропишите
roCommunity: public
rwCommunity: private
4. Подключитесь к станции по телнет, порт 23 и введите команду netupd или рестартаните станцию