Тестируем 5.3.002

ZeM · Сообщение **ZeM** » Вт июл 01, 2014 06:54

БАГ
Сегодня 1 числа биллинг накрыло и он мне прислал около 52 Счет на оплату за предоставляемые услуги на почту. На моей учетке стоит флаг в ЛС - безлимитный режим. Остальных не заспамило ( т.к. видимо у них нет флага безлимитный режим).

ZeM · Сообщение **ZeM** » Вт июл 01, 2014 07:09

Предложение разработчикам насчет обещанного платежа. В Интерфейсы - Обещанные платежи там помимо интервала в днях добавить галочку Разрешить обещанный платеж в начале нового РП (1 числа 00.00) (независимо прошел ли интервал в днях).
У меня стоит интервал 30 дней и получается такая картинка Следующий обещанный платёж может быть произведён не ранее 01.07.2014 12:26. Т.е. отсчиталось 30 дней ровно с момента прошлой активации.
Добавьте пожалуйста такой флаг.

ZeM · Сообщение **ZeM** » Вт июл 01, 2014 11:56

Еще один глюк...

Разработчики это читают или все в отпуске уже?

kirush · Сообщение **kirush** » Вт июл 01, 2014 14:37

update 3.
У юр лиц у кого установлена галка "работа по предоплате" счета сформировались опять за прошлый месяц (июнь), а за июль счетов нет

и когда все таки реализуете объединение оказанных услуг в один счет?

ZeM · Сообщение **ZeM** » Вт июл 01, 2014 14:59

update 5 вышел.

Avdoshkin

Компания NetUP, спасибо за исправления ошибок в update5!

Очередные нюансы!

1) Исправили ошибку Mantis_ID=2348. Будет реализовано нормально при использовании DES-3526 dhcp_requets(unicast)? Вы игнорируете запросы unicast(без opt82) и ждете broadcast(c opt82), пошли по простому пути.

2) Добавьте пожалуйста поле dhcp-class-identifier в таблицу dhcp_leases, в utm5_admin можно не выводить.

3) Будет ли в настройках "профиль оборудования" длина байт не фиксированной длины?

Компания NetUP, большая просьба к Вам не теряйтесь на форме, мы ждем обратной связи , это очень важно для нас.

Avdoshkin

Не работает UTM5_DHCP x64

1) Linux monit 3.5.0-49-generic #74~precise1-Ubuntu SMP Fri May 2 21:32:31 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

2) Version:5.3-002-update5-debian_wheezy_x64 Rev #14222

3) Через tcpdup пакеты видно что идут, а UTM5_DHCP их не видит.

4) interface=vlan23,10.0.18.253

5) UTM5_DHCP на 32 битной версии работает.

UPD:
UTM5_DHCP x64 заработал.

1) Если ip route не прописан, utm5_dhcp запросы вообще не видит.

starchik

а как в лицевом счету по умолчанию поставить галку Авт. включать???
в настройких админки включено, но это видимо что-то другое???

starchik

после запуска DHCP

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

Jul 02 18&#58;01&#58;33  Info  &#58; b7f84900 FileAppender&#58; Using '/netup/utm5/log/dhcp_debug.log' file
Jul 02 18&#58;01&#58;33  Info  &#58; b7f84900 FileAppender&#58; Using '/netup/utm5/log/dhcp_main.log' file
Jul 02 18&#58;01&#58;33  Info  &#58; b7f84900 FileAppender&#58; Using '/netup/utm5/log/dhcp_critical.log' file
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; Connecting to MySQL database
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; Connection parameters username&#58; root; dbname&#58; UTM5 host&#58; 192.168.8.206
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; Setting database character set to <utf8>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; MySQL connection opened
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT hash1,hash2,data FROM license_data ORDER BY id DESC LIMIT 1
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1 rows in 0.001 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Initializing license_center.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Loading license
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Got system  license.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; license #655
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; System license passed checking.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; System license ID &#91;558&#93;
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Parsing license
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Added license <utm5_core> since <1225879695> till <1510132095> serial <558>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Got 2 additional licenses.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; license #1766
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Parsing license
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Added license <utm5_dhcp> since <1404193454> till <1688449454> serial <558>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; license #6f0
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Parsing license
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Added license <utm5_radius> since <1228727242> till <1512979642> serial <558>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; License was readed
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; License loaded
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LicenseCenter&#58; Initing license_center done.
Jul 02 18&#58;01&#58;33  Info  &#58; b7f84900 Application&#58; License key OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LeaseManager&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,block_id FROM accounts WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1647 rows in 0.004 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LeaseManager&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; Registering message handlers..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x5000> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x5007> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x5008> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x5009> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x500a> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x500b> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x500c> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x500d> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x500e> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x500f> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x5010> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x5011> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x5012> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 ModTop&#58; ID <0x70000000> handler <0x09565fa0>
Jul 02 18&#58;01&#58;33  Info  &#58; b7f84900 DHCP_Server&#58; listening eth0/192.168.8.201/00&#58;25&#58;22&#58;14&#58;6c&#58;03/192.168.8.201&#58;67
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LeaseManager&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,block_id FROM accounts WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1647 rows in 0.003 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 LeaseManager&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,tec_id_type,tec_id_disp,tec_id_len,tec_id_offset,port_id_type,port_id_disp,port_id_len,port_id_offset,vlan_id_type,vlan_id_disp,vlan_id_len,vlan_id_offset FROM switch_types WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 3 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; switch template #1 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; switch template #2 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; switch template #3 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,type_id,remote_id,name FROM switches WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 2 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; swicth #1 &#40;Lenina 9&#41; OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; swicth #2 &#40;Mira 27&#41; OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT ip_group_id, account_id FROM service_links,iptraffic_service_links WHERE iptraffic_service_links.is_deleted='0' AND iptraffic_service_links.id=service_links.id
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1636 rows in 0.004 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,ip,mask,mac,switch_id,port_id,vlan_id,pool_id,ip_group_id FROM ip_groups WHERE is_deleted='0' AND &#40;ip_type&0x300&#41;='0' AND &#40;pool_id<>'0' OR switch_id<>'0' OR mac<>''&#41;
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 122 rows in 0.001 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3000 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3754 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3920 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3371 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4488 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4508 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4595 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4594 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4614 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4662 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3443 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3434 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3455 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3439 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4243 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4341 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4809 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3487 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3516 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3547 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3551 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3554 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3677 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4166 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3893 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3691 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4276 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3713 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3714 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3724 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3949 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3988 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4171 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4312 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3727 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4264 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4318 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4320 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4337 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4338 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4369 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4406 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4450 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4395 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4398 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4400 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4407 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4513 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4633 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4627 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4653 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4665 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4800 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3459 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3471 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3473 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3884 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4786 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3885 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4788 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4789 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4790 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4791 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4787 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3698 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3725 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3726 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4448 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3975 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #3514 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4094 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4093 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4460 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4107 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4113 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4111 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4112 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4414 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4322 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4271 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4134 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4141 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4142 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4175 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4684 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4183 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4254 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4236 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4258 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4253 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4262 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4330 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4351 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4340 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4350 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4370 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4371 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4373 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4372 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4478 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4393 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4408 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4470 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4477 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4475 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4479 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4480 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4619 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4623 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4655 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4674 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4673 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4499 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4626 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4685 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4664 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4680 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4686 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4691 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4692 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4801 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; verify&#58; static DHCP binding #4802 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 BindingManager&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 PoolManager&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,lease_time,gateway,netmask,block_pool_id,flags FROM dhcp_pool_info WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT first_ip,last_ip FROM dhcp_pool_ranges WHERE is_deleted='0' AND pool_id='1'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 PoolManager&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 OptionStorage&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='1' AND is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 0 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='2' AND is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 0 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,gateway,netmask,dns1_server,dns2_server,ntp_server,domain_name FROM dhcp_pool_info WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7f84900 OptionStorage&#58; done.
Jul 02 18&#58;01&#58;33  Info  &#58; b7f84900 UTM5 Config&#58; Pid file found&#58; /var/run/utm5_dhcpd.pid; Overwriting
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 Transport&#58; started.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 ModTop&#58; Socket connected to&#58; host <127.0.0.1> port <12758>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7bfeb90 DHCP_Server&#58; listening for 1 sockets
Jul 02 18&#58;01&#58;33  Info  &#58; b7afdb90 StreamConnection&#58; Connection thread started. Peer &#91;127.0.0.1&#93;&#58;12758
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7afdb90 StreamConnection&#58; Connection using SSLv3
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7afdb90 StreamConnection&#58; System message <-31> recived
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7afdb90 StreamConnection&#58; Challenge response sent
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7afdb90 StreamConnection&#58; System message <-33> recived
Jul 02 18&#58;01&#58;33  Info  &#58; b7afdb90 StreamConnection&#58; Connection successfully authorized, user id <-20>
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 Transport&#58; connection with UTM5 core has been restored
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 LeaseManager&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,block_id FROM accounts WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1647 rows in 0.004 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 LeaseManager&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,tec_id_type,tec_id_disp,tec_id_len,tec_id_offset,port_id_type,port_id_disp,port_id_len,port_id_offset,vlan_id_type,vlan_id_disp,vlan_id_len,vlan_id_offset FROM switch_types WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 3 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; switch template #1 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; switch template #2 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; switch template #3 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,type_id,remote_id,name FROM switches WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 2 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; swicth #1 &#40;Lenina 9&#41; OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; swicth #2 &#40;Mira 27&#41; OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT ip_group_id, account_id FROM service_links,iptraffic_service_links WHERE iptraffic_service_links.is_deleted='0' AND iptraffic_service_links.id=service_links.id
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1636 rows in 0.004 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,ip,mask,mac,switch_id,port_id,vlan_id,pool_id,ip_group_id FROM ip_groups WHERE is_deleted='0' AND &#40;ip_type&0x300&#41;='0' AND &#40;pool_id<>'0' OR switch_id<>'0' OR mac<>''&#41;
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 122 rows in 0.001 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3000 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3754 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3920 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3371 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4488 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4508 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4595 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4594 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4614 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4662 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3443 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3434 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3455 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3439 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4243 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4341 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4809 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3487 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3516 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3547 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3551 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3554 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3677 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4166 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3893 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3691 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4276 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3713 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3714 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3724 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3949 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3988 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4171 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4312 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3727 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4264 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4318 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4320 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4337 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4338 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4369 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4406 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4450 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4395 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4398 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4400 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4407 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4513 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4633 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4627 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4653 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4665 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4800 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3459 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3471 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3473 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3884 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4786 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3885 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4788 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4789 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4790 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4791 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4787 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3698 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3725 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3726 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4448 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3975 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #3514 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4094 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4093 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4460 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4107 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4113 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4111 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4112 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4414 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4322 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4271 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4134 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4141 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4142 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4175 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4684 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4183 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4254 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4236 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4258 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4253 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4262 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4330 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4351 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4340 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4350 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4370 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4371 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4373 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4372 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4478 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4393 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4408 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4470 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4477 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4475 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4479 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4480 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4619 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4623 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4655 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4674 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4673 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4499 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4626 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4685 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4664 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4680 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4686 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4691 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4692 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4801 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; verify&#58; static DHCP binding #4802 OK
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 BindingManager&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 PoolManager&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,lease_time,gateway,netmask,block_pool_id,flags FROM dhcp_pool_info WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT first_ip,last_ip FROM dhcp_pool_ranges WHERE is_deleted='0' AND pool_id='1'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 PoolManager&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 OptionStorage&#58; loading..
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='1' AND is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 0 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='2' AND is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 0 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; SELECT id,gateway,netmask,dns1_server,dns2_server,ntp_server,domain_name FROM dhcp_pool_info WHERE is_deleted='0'
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 DBConnection_mysql&#58; <0x9567090> SQL SELECT query&#58; 1 rows in 0.000 sec
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 OptionStorage&#58; done.
Jul 02 18&#58;01&#58;33 ?Debug &#58; b7cffb90 StreamConnection&#58; Sending message ID 0x5000

логи засираются такими сообщениями, пока не закончится место

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

Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #1140
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #1566
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #590
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #435
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #604
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #1680
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #1314
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #1147
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #137
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 Transport&#58; got ACCOUNT_UNBLOCKED for #162
Jul 02 18&#58;01&#58;34 ?Debug &#58; b7afdb90 StreamConnection&#58; Got message ID 0x5010

что это такое???

xxxupg · Сообщение **xxxupg** » Ср июл 02, 2014 23:20

поймали такой баг при тестировании новой сборки на чистой системе:

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

DBConnection_mysql&#58; <0178BB68> SQL query&#58; INSERT INTO credits&#40;payment_trans_id, expire_date, start_date, account_id, value, status&#41; VALUES&#40;'3', '1404937793', '1404333086', '1', '1230,000000', '0'&#41;
ERROR &#58; 1bfdd08 DBConnection_mysql&#58; <0178BB68> MySQL query failed&#58;<Data truncated for column 'value' at row 1> Trying to reconnect&#58; 0

Правильный вариант выглядит так:

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

DBConnection_mysql&#58; <0178BF38> SQL query&#58; INSERT INTO credits&#40;payment_trans_id, expire_date, start_date, account_id, value, status&#41; VALUES&#40;'2', '1404935654', '1404330947', '1', '1230.000000', '0'&#41;
DBConnection_mysql&#58; <0178BF38> SQL query takes 0.000 sec

Вся соль в , а не .

Avdoshkin

Ошибка dhcp_leases_log!

Version:5.3-002-update5-debian_wheezy_x64 Rev #14222
INSERT INTO dhcp_leases_log(ip,mac,relay_agent_info,account_id,updated,expired) VALUES ('-1190256639','00:0e:08:27:f2:27','0106000407d1000102080006001e58a90c22','0','1404355997','1404356297')

Не вставляет account_id

Avdoshkin

UTM5_RADIUS!

Ради спортивного интереса попробовал работоспособность вашего Radius и наткнулся на очередные трудности.

1) Трудности с авторизацией, необходимо сделать выбор поле User-Name. Пусть будет выбор поля IP,MAC,LOGIN,OPT82 чтобы можно было выбирать самостоятельно какие поля использовать. Оборудования к примеру Cisco предоставляет возможность выбирать User-Name по выбору. У вас этого нет.

2) Услуге "Передача IP трафика" нет возможности нормально прописать атрибуты:
a) Если клиент с положительным балансом отдать атрибуты положительные(access-accept)
b) Если у клиента отрицательный баланс отдать атрибуты отрицательные(access-accept)

3) Выше сказанное по пункту 2 и следовательно нет нормальной реализации с CoA. Если клиент авторизовался с отрицательными атрибутами и у клиента стал баланс положительный необходим отправить CoA c атрибутами положительными.

Может что-то не понимаю в вашей логике UTM5, но нет возможности сделать описанное выше. Все это делается с помощью FreeRadius или самописного(radius) и UTM5_RFW(баланс)

Компания, NetUP возможно ли сделать данный функционал?

OxOyD · Сообщение **OxOyD** » Чт июл 03, 2014 11:25

Добрый день, обновил биллинг с версии 5.2-009 до 5.3.2 и начались проблемы первое что волнует это модуль динамического шейпирования, он собственно перестал работать, сделано у меня так что в три разных временных диапозона срабатывали правила которые запускали мой скрипт, раньше все работало теперь же такое ощущение что модуль просто не обращает внимания на временные диапозоны...

И второе это что перестала работать добровольная блокировка, в логах пишет

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

unable to set voluntary blocking

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

Jul 03 14&#58;17&#58;32 ?Debug &#58; b3afcb70 DBConnection_mysql&#58; <0x9daf580> SQL SELECT query&#58; SELECT block_id, block_date_start, block_date_end FROM voluntary_suspension_data WHERE account_id='86'
Jul 03 14&#58;17&#58;32 ?Debug &#58; b3afcb70 DBConnection_mysql&#58; <0x9daf580> SQL SELECT query&#58; 1 rows in 0.000 sec
Jul 03 14&#58;17&#58;32 ?Debug &#58; b3afcb70 UTM5 DBA&#58; customer_block&#58; account 86 has planning block or already blocked
Jul 03 14&#58;17&#58;32  ERROR &#58; b3afcb70 RPCServer@176.56.22.1&#58; unable to set voluntary blocking

Сегодня обновил биллинг снова, учитывая последнии апдейты.... Что делать ,сталкивался кто нибудь?

П.С. Блокировка в итоге то применятся, но пишет ошибку что невозможно поставить ее, как в логах, так и в личном кабинете...

starchik

как у меня проблемы ни у кого не было?

serjk вы хоть скажите, это какой-то баг или что-то с моим сервером?

starchik

проверил на centos 6 x64, с той же базой все запускается. значит проблема не в БД...

у кого-то стоит этот DHCP на 5 центе x86??

нашел еще одну фигню

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

service utm5_dhcp start
/netup/utm5/dhcpd5.cfg&#58; line 134&#58; rotate_logs&#58; команда не найдена
/netup/utm5/dhcpd5.cfg&#58; line 140&#58; max_logfile_count&#58; команда не найдена
/netup/utm5/dhcpd5.cfg&#58; line 146&#58; max_logfile_size&#58; команда не найдена