Тестируем 5.3.002

Pei0t · Сообщение **Pei0t** » Пт мар 28, 2014 20:06

serjk писал(а):Что в свойствах IP-группы прописано, для которой должен выдаться адрес?

Которая в сервисной связке пользователя добавляется? В свойствах IP указан динамический dhcp пул, в свойствах dhcp указан коммутатор и порт.

Pei0t · Сообщение **Pei0t** » Вт апр 01, 2014 09:57

Кто то ещё может дать ответ на пост выше?

serjk · Сообщение **serjk** » Вт апр 01, 2014 10:00

Pei0t писал(а):Кто то ещё может дать ответ на пост выше?

Вы не приводите никакой информации (скриншотов, комментариев, и т.д.)

Причин может быть множество - неправильно указан Remote ID в свойствах коммутатора, неправильно настроен профиль оборудования, какие-то проблемы в свойствах IP-группы или DHCP-пула.. На основании имеющейся информации пока ничего нельзя сказать.

Pei0t · Сообщение **Pei0t** » Вт апр 01, 2014 10:18

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

Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 DHCP_Server&#58; request from 192.168.254.135&#58;68&#58;
DHCP packet header
      op&#58; 1
   htype&#58; 1
    hlen&#58; 6
    hops&#58; 1
     xid&#58; c57e409c
    secs&#58; 10
   flags&#58; 32768
  ciaddr&#58; 0.0.0.0
  yiaddr&#58; 0.0.0.0
  siaddr&#58; 0.0.0.0
  giaddr&#58; 192.168.254.135
  chaddr&#58; d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54
   sname&#58;
    file&#58;
  option &#91;dhcp-message-type&#93;&#58; 01
  option &#91;dhcp-parameter-request-list&#93;&#58; 017932162a
  option &#91;host-name&#93;&#58; MikroTik
  option &#91;dhcp-client-identifier&#93;&#58; 01d4ca6da5ee54
  option &#91;relay-agent-info&#93;&#58; 01604ffe032806c8be19a71860

Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,ip,expired,client_id,binding_id,flags FROM dhcp_leases WHERE mac='d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54' ORDER BY id
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 0 rows in 0.000 sec
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 LeaseManager&#58; no lease for MAC d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54 found
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 DHCP_Server&#58; got DHCPDISCOVER packet
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT COUNT&#40;id&#41; FROM dhcp_leases WHERE expired>'1396336405'
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 1 rows in 0.000 sec
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 BindingManager&#58; mac&#58; d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54 switch_id&#58; 2 port_id&#58; 3 vlan_id&#58; 0
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 BindingManager&#58; start 0 end 8
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 BindingManager&#58; binding #19 port ID not matched
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 BindingManager&#58; mac&#58; 00&#58;00&#58;00&#58;00&#58;00&#58;00 switch_id&#58; 3 port_id&#58; 23 vlan_id&#58; 0
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 BindingManager&#58; binding #23 remote ID not matched
Apr 01 11&#58;13&#58;25 ?Debug &#58; 2c08c00 LeaseManager&#58; no IP-MAC-port binding found for d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54
Apr 01 11&#58;13&#58;25  ERROR &#58; 2c08c00 DHCP_Server&#58; send_offer&#58; LeaseManagerError&#58; no suitable binding

Запрашиваю с Des-3200 с 3го порта с мака d4:ca:6d:a5:ee:54

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

 sudo tcpdump -i bge1 -vvv host 192.168.254.135
tcpdump&#58; listening on bge1, link-type EN10MB &#40;Ethernet&#41;, capture size 65535 bytes
11&#58;18&#58;15.114670 IP &#40;tos 0x0, ttl 30, id 54208, offset 0, flags &#91;none&#93;, proto UDP &#40;17&#41;, length 328&#41;
    192.168.254.135.bootpc > 192.168.254.133.bootps&#58; &#91;udp sum ok&#93; BOOTP/DHCP, Request from d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54 &#40;oui Unknown&#41;, length 300, hops 1, xid 0x78dd6973, secs 36, Flags &#91;Broadcast&#93; &#40;0x8000&#41;
          Gateway-IP 192.168.254.135
          Client-Ethernet-Address d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54 &#40;oui Unknown&#41;
          Vendor-rfc1048 Extensions
            Magic Cookie 0x63825363
            DHCP-Message Option 53, length 1&#58; Discover
            Parameter-Request Option 55, length 6&#58;
              Subnet-Mask, Classless-Static-Route, Default-Gateway, Static-Route
              Domain-Name-Server, NTP
            Hostname Option 12, length 8&#58; "MikroTik"
            Client-ID Option 61, length 7&#58; ether d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54
            Agent-Information Option 82, length 18&#58;
              Circuit-ID SubOption 1, length 6&#58; ^@^D^OM-~^@^C
              Remote-ID SubOption 2, length 8&#58; ^@^FM-HM->^YM-'^X`
            END Option 255, length 0
            PAD Option 0, length 0, occurs 9

Версия 5.3.002-rc1

serjk · Сообщение **serjk** » Вт апр 01, 2014 10:19

dhcp.log в момент запуска тоже бы не помешал еще

Pei0t · Сообщение **Pei0t** » Вт апр 01, 2014 10:23

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

Apr 01 11&#58;23&#58;33  Info  &#58; 2c07400 FileAppender&#58; Using '/netup/utm5/log/dhcp.log' file
UTM5 DHCPD started &#40;0 sec&#41;
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; Connecting to MySQL database
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; Connection parameters username&#58; UTM5test; dbname&#58; UTM5test host&#58; localhost
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; Setting database character set to <utf8>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; MySQL connection opened
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT hash1,hash2,data FROM license_data ORDER BY id DESC LIMIT 1
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 1 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Initializing license_center.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Loading license
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Got system  license.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; license #4fa
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; System license passed checking.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; System license ID &#91;420&#93;
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Parsing license
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Added license <utm5_core> since <1219725526> till <1503981526> serial <420>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Got 3 additional licenses.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; license #4fb
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Parsing license
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Added license <utm5_dynashape> since <1219725535> till <1503981535> serial <420>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; license #4fc
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Parsing license
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Added license <utm5_radius> since <1219725537> till <1503981537> serial <420>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; license #151d
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Parsing license
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Added license <utm5_tel> since <1358865777> till <1643121777> serial <420>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; License was readed
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; License loaded
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LicenseCenter&#58; Initing license_center done.
Apr 01 11&#58;23&#58;33 *ALERT &#58; 2c07400 Application&#58; License key for utm5_dhcpd not found, DHCP lease count is limited to 10
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LeaseManager&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,block_id FROM accounts WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LeaseManager&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; Registering message handlers..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x5000> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x5007> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x5008> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x5009> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x500a> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x500b> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x500c> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x500d> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x500e> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x500f> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x5010> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x5011> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x5012> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 ModTop&#58; ID <0x70000000> handler <0x02cd4320>
Apr 01 11&#58;23&#58;33  Info  &#58; 2c07400 DHCP_Server&#58; listening bge1/192.168.254.133/00&#58;00&#58;00&#58;00&#58;00&#58;00/192.168.254.133&#58;67
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LeaseManager&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,block_id FROM accounts WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 LeaseManager&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> 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'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 3 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; switch template #1 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; switch template #2 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; switch template #3 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,type_id,remote_id,name FROM switches WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 3 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; swicth #1 &#40;DES-3200-18-C1&#41; OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; swicth #2 &#40;DES-3200&#41; OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; swicth #3 &#40;SNR-25a&#41; OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> 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
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> 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;
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; verify&#58; dynamic DHCP binding #19 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; verify&#58; static DHCP binding #24 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 BindingManager&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 PoolManager&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,lease_time,gateway,netmask,block_pool_id,flags FROM dhcp_pool_info WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT first_ip,last_ip FROM dhcp_pool_ranges WHERE is_deleted='0' AND pool_id='1'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 1 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT first_ip,last_ip FROM dhcp_pool_ranges WHERE is_deleted='0' AND pool_id='2'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 1 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 PoolManager&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 OptionStorage&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='1' AND is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 0 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='2' AND is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 0 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,gateway,netmask,dns1_server,dns2_server,ntp_server,domain_name FROM dhcp_pool_info WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c07400 OptionStorage&#58; done.
Apr 01 11&#58;23&#58;33  ERROR &#58; 2c07400 UTM5 Config&#58; Can't unlink pid file /var/run/utm5_unknown.pid&#58; No such file or directory
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 Transport&#58; started.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c08c00 DHCP_Server&#58; listening for 1 sockets
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 ModTop&#58; Socket connected to&#58; host <127.0.0.1> port <12758>
Apr 01 11&#58;23&#58;33  Info  &#58; 3c9e400 StreamConnection&#58; Connection thread started. Peer &#91;127.0.0.1&#93;&#58;12758
Apr 01 11&#58;23&#58;33 ?Debug &#58; 3c9e400 StreamConnection&#58; Connection using SSLv3
Apr 01 11&#58;23&#58;33 ?Debug &#58; 3c9e400 StreamConnection&#58; System message <-31> recived
Apr 01 11&#58;23&#58;33 ?Debug &#58; 3c9e400 StreamConnection&#58; Challenge response sent
Apr 01 11&#58;23&#58;33 ?Debug &#58; 3c9e400 StreamConnection&#58; System message <-33> recived
Apr 01 11&#58;23&#58;33  Info  &#58; 3c9e400 StreamConnection&#58; Connection successfully authorized, user id <-5>
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 Transport&#58; connection with UTM5 core has been restored
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 LeaseManager&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,block_id FROM accounts WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 LeaseManager&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> 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'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 3 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; switch template #1 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; switch template #2 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; switch template #3 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,type_id,remote_id,name FROM switches WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 3 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; swicth #1 &#40;DES-3200-18-C1&#41; OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; swicth #2 &#40;DES-3200&#41; OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; swicth #3 &#40;SNR-25a&#41; OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> 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
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> 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;
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; verify&#58; dynamic DHCP binding #19 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; verify&#58; static DHCP binding #24 OK
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 BindingManager&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 PoolManager&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,lease_time,gateway,netmask,block_pool_id,flags FROM dhcp_pool_info WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT first_ip,last_ip FROM dhcp_pool_ranges WHERE is_deleted='0' AND pool_id='1'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 1 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT first_ip,last_ip FROM dhcp_pool_ranges WHERE is_deleted='0' AND pool_id='2'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 1 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 PoolManager&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 OptionStorage&#58; loading..
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='1' AND is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 0 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT owner_id,opt_id,opt_type,opt_value FROM dhcp_options WHERE owner_type='2' AND is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 0 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,gateway,netmask,dns1_server,dns2_server,ntp_server,domain_name FROM dhcp_pool_info WHERE is_deleted='0'
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 2 rows in 0.000 sec
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 OptionStorage&#58; done.
Apr 01 11&#58;23&#58;33 ?Debug &#58; 2c09000 StreamConnection&#58; Sending message ID 0x5000
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT ip FROM dhcp_leases WHERE expired<'1396337014' AND expired>'1396250614'
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 0 rows in 0.000 sec
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DHCP_Server&#58; request from 192.168.254.135&#58;68&#58;
DHCP packet header
      op&#58; 1
   htype&#58; 1
    hlen&#58; 6
    hops&#58; 1
     xid&#58; b9584539
    secs&#58; 17
   flags&#58; 0
  ciaddr&#58; 0.0.0.0
  yiaddr&#58; 0.0.0.0
  siaddr&#58; 0.0.0.0
  giaddr&#58; 192.168.254.135
  chaddr&#58; d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54
   sname&#58;
    file&#58;
  option &#91;dhcp-message-type&#93;&#58; 01
  option &#91;dhcp-parameter-request-list&#93;&#58; 017932162a
  option &#91;host-name&#93;&#58; MikroTik
  option &#91;dhcp-client-identifier&#93;&#58; 01d4ca6da5ee54
  option &#91;relay-agent-info&#93;&#58; 01604ffe032806c8be19a71860

Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT id,ip,expired,client_id,binding_id,flags FROM dhcp_leases WHERE mac='d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54' ORDER BY id
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 0 rows in 0.000 sec
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 LeaseManager&#58; no lease for MAC d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54 found
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DHCP_Server&#58; got DHCPDISCOVER packet
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; SELECT COUNT&#40;id&#41; FROM dhcp_leases WHERE expired>'1396337014'
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 DBConnection_mysql&#58; <0x802cab400> SQL SELECT query&#58; 1 rows in 0.000 sec
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 BindingManager&#58; mac&#58; d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54 switch_id&#58; 2 port_id&#58; 3 vlan_id&#58; 0
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 BindingManager&#58; start 0 end 8
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 BindingManager&#58; binding #19 port ID not matched
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 BindingManager&#58; mac&#58; 00&#58;80&#58;48&#58;59&#58;95&#58;8e switch_id&#58; 3 port_id&#58; 23 vlan_id&#58; 174
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 BindingManager&#58; binding #24 MAC not matched
Apr 01 11&#58;23&#58;34 ?Debug &#58; 2c08c00 LeaseManager&#58; no IP-MAC-port binding found for d4&#58;ca&#58;6d&#58;a5&#58;ee&#58;54
Apr 01 11&#58;23&#58;34  ERROR &#58; 2c08c00 DHCP_Server&#58; send_offer&#58; LeaseManagerError&#58; no suitable binding

serjk · Сообщение **serjk** » Вт апр 01, 2014 11:02

Попробуйте в профиле оборудования поменять смещение порта с 5 на 7. Судя по всему, в этом ошибка.

Pei0t · Сообщение **Pei0t** » Вт апр 01, 2014 13:26

serjk писал(а):Попробуйте в профиле оборудования поменять смещение порта с 5 на 7. Судя по всему, в этом ошибка.

Заработало, спасибо.

Pei0t · Сообщение **Pei0t** » Ср апр 02, 2014 10:23

При добавлении "дома" в карточке у пользователя эти самые дома почему-то дублируются

В бд дома по одному.

kirush · Сообщение **kirush** » Ср апр 02, 2014 15:01

Когда в планах RC2?

serjk · Сообщение **serjk** » Ср апр 02, 2014 15:09

kirush писал(а):Когда в планах RC2?

Доделываем последнее. Еще необходимо протестировать "плавный" метод списания, по которому есть информация о проблемах.

В идеале, RC2 выйдет до конца недели.

kirush · Сообщение **kirush** » Ср апр 02, 2014 18:48

Заходим в карточку абонента.
Выбираем "Отчет"
Ставим галку "Расчетный период", пауза и вываливаются ВСЕ расчетные периоды с начала работы UTM.

Думаю надо оставить как было раньше только актуальные. Как сделано это в "Тарификация" -> "Расчетные периоды"

serjk · Сообщение **serjk** » Ср апр 02, 2014 19:11

kirush писал(а):Заходим в карточку абонента.
Выбираем "Отчет"
Ставим галку "Расчетный период", пауза и вываливаются ВСЕ расчетные периоды с начала работы UTM.

Думаю надо оставить как было раньше только актуальные. Как сделано это в "Тарификация" -> "Расчетные периоды"

Так было всегда. Так сделано, чтобы можно было смотреть отчеты за прошедшие периоды.

Magnum72

2 serjk
Несколько предложений:
1) В урфе не удобно работать с доп параметрами, так как при получении юзеринфо отображаются только те параметры которые установлены у пользователя, можно ли массив доп. параметров выводить в полном объеме? Сейчас приходится городить примерно так:

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

<!-- Poluchaem informatciu o polzovatele -->
    <call function="rpcf_get_userinfo" output="0"/>

<!-- Fix nepolnogo massiva dop parametrov -->
    <call function="rpcf_get_uaparam_list" output="0"/>
    <for name="i" from="0" count="uparam_size">
      <set dst="magic" value="0" />
      <set dst="id_tmp" src="id" src_index="i"/>
      <for name="j" from="0" count="size&#40;parameter_id&#41;">
        <set dst="parameter_id_tmp" src="parameter_id" src_index="j"/>
        <if variable="parameter_id_tmp" value="id_tmp" condition="eq">
          <set dst="magic" value="1" />
        </if>
      </for>
      <if variable="magic" value="0" condition="eq">
        <set src="id_tmp" dst="parameter_id" dst_index="size&#40;parameter_value&#41;"/>
        <set dst="parameter_value" dst_index="size&#40;parameter_value&#41;" value=""/>
      </if>
    </for>

    <for name="i" from="0" count="size&#40;parameter_id&#41;">
      <set dst="parameter_id_tmp" src="parameter_id" src_index="i"/>
      <if variable="parameter_id_tmp" value="1" condition="eq">
        <if variable="param_1" value="!unset!" condition="ne">
          <set dst="parameter_value" dst_index="i" src="param_1" />
        </if>
      </if>
      <if variable="parameter_id_tmp" value="2" condition="eq">
        <if variable="param_2" value="!unset!" condition="ne">
          <set dst="parameter_value" dst_index="i" src="param_2" />
        </if>
      </if>
      <if variable="parameter_id_tmp" value="3" condition="eq">
        <if variable="param_3" value="!unset!" condition="ne">
          <set dst="parameter_value" dst_index="i" src="param_3" />
        </if>
      </if>
      <if variable="parameter_id_tmp" value="4" condition="eq">
        <if variable="param_4" value="!unset!" condition="ne">
          <set dst="parameter_value" dst_index="i" src="param_4" />
        </if>
      </if>
      <if variable="parameter_id_tmp" value="5" condition="eq">
        <if variable="param_5" value="" condition="ne">
          <set dst="parameter_value" dst_index="i" src="param_5" />
        </if>
      </if>
.....

2) При закрытии периода выставляются инвойсы только при наличии списаний в текущем РП, можно ли выставлять их нулевыми всегда, требуется для формирования отчетности?

3) При закрытии периода существуют ситуации когда платеж введенный в систему на последних секундах периода, отражается в транзакциях как платеж данного периода, при этом баланс лицевого счета на начало следующего периода еще не учитывает последний платеж. я бы вообще запретил подключения к ядру в момент смены РП.

4) в таблице balance_history просьба указывать балансы для всех не удаленных лицевых счетов, а не только те по котором были списания.

5) В урфе сделать возможным сравнении сравнивать переменную с элементом массива, сейчас приходится городить:

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

      <set dst="service_id" src="service_id_array" src_index="i"/>
      <if variable="service_id" value="503" condition="eq">
        <error code="67" comment="The leased device detected"/>
      </if>

было бы здорово написать так:

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

      
      <if variable="service_id" value="somevar" array_index="i" condition="eq">
        <error code="67" comment="The leased device detected"/>
      </if>

6) При окончании перевода в новый РП и при завершении цикла периодических списании дать возможность запускать пользовательский скрипт и замораживать ядро до получения от него ответа, нужно для того чтобы получать корректные срезы данных для формирования отчетности.

7) При проведении разовой услуги добавить возможность добавлять группу пользователю.

В юзерлог добавить информацию об изменении персонального менеджера и даты подключения, и доработать информацию об изменениях в IP группе.

MaxDM · Сообщение **MaxDM** » Чт апр 03, 2014 10:10

Magnum72 писал(а):я бы вообще запретил подключения к ядру в момент смены РП.

+100500 ) А так костылями сейчас запрещаем.