0000705: web admin GUI - node edit ArpTime field cannot be modified - PacketFence

(0001245)
user4
2009-06-03 09:40

Jun 03 09:37:30 [debug] I ran command: 'ARGS=node edit 00:00:00:00:00:01 pid="2", detect_date="2009-06-03 09:36:22", regdate="", unregdate="", lastskip="2009-06-03 09:36:22", status="unreg", user_agent="", computername="", notes="", last_arp="2009-06-03 09:36:22", last_dhcp="2009-06-03 09:36:22", switch="", port="", vlan="", dhcp_fingerprint=""' /usr/local/pf/bin/pfcmd
Returned:
Array
(
    [0] => last_dhcp: 2009-06-03 09:36:22
    [1] => user_agent:
    [2] => status: unreg
    [3] => dhcp_fingerprint:
    [4] => computername:
    [5] => regdate:
    [6] => detect_date: 2009-06-03 09:36:22
    [7] => vlan:
    [8] => port:
    [9] => pid: 2
    [10] => switch:
    [11] => notes:
    [12] => unregdate:
    [13] => last_arp: 2009-06-03 09:36:22
    [14] => lastskip: 2009-06-03 09:36:22
)

Jun 03 09:37:30 [debug] I ran command: 'ARGS=node view 00:00:00:00:00:01' /usr/local/pf/bin/pfcmd
Returned:
Array
(
    [0] => mac|pid|detect_date|regdate|unregdate|lastskip|status|user_agent|computername|notes|last_arp|last_dhcp|switch|port|vlan|dhcp_fingerprint|nbopenviolations
    [1] => 00:00:00:00:00:01|2|2009-06-03 09:36:22|||2009-06-03 09:36:22|unreg|||||2009-06-03 09:36:22|||||0
)

(0001246)
user4
2009-06-03 09:42

The SQL call does not transmit the last_arp field:
    $node_modify_sql->execute(
        $new_mac, $existing->{pid},
        $existing->{detect_date}, $existing->{regdate},
        $existing->{unregdate}, $existing->{lastskip},
        $existing->{status}, $existing->{user_agent},
        $existing->{computername}, $existing->{notes},
        $existing->{dhcp_fingerprint}, $existing->{last_dhcp},
        $existing->{switch}, $existing->{port},
        $existing->{vlan}, $mac
    ) || return (0);

(0001247)
user4
2009-06-03 09:54

fixed in mtn revision be1b2d6821af7acb1d9278bf7549bd3aaa4c979a

Issue History
Date Modified	Username	Field	Change
2009-06-03 09:38	user4	New Issue
2009-06-03 09:38	user4	Status	new => assigned
2009-06-03 09:38	user4	Assigned To	=> user4
2009-06-03 09:40	user4	Note Added: 0001245
2009-06-03 09:42	user4	Note Added: 0001246
2009-06-03 09:54	user4	Note Added: 0001247
2009-06-03 09:54	user4	Status	assigned => closed
2009-06-03 09:54	user4	Resolution	open => fixed
2010-04-15 17:55	obilodeau	Category	1.8.3 => 1.8.x
2012-02-29 10:56	obilodeau	Category	1.8.x => core

Notes
(0001245) user4 2009-06-03 09:40	Jun 03 09:37:30 [debug] I ran command: 'ARGS=node edit 00:00:00:00:00:01 pid="2", detect_date="2009-06-03 09:36:22", regdate="", unregdate="", lastskip="2009-06-03 09:36:22", status="unreg", user_agent="", computername="", notes="", last_arp="2009-06-03 09:36:22", last_dhcp="2009-06-03 09:36:22", switch="", port="", vlan="", dhcp_fingerprint=""' /usr/local/pf/bin/pfcmd Returned: Array ( [0] => last_dhcp: 2009-06-03 09:36:22 [1] => user_agent: [2] => status: unreg [3] => dhcp_fingerprint: [4] => computername: [5] => regdate: [6] => detect_date: 2009-06-03 09:36:22 [7] => vlan: [8] => port: [9] => pid: 2 [10] => switch: [11] => notes: [12] => unregdate: [13] => last_arp: 2009-06-03 09:36:22 [14] => lastskip: 2009-06-03 09:36:22 ) Jun 03 09:37:30 [debug] I ran command: 'ARGS=node view 00:00:00:00:00:01' /usr/local/pf/bin/pfcmd Returned: Array ( [0] => mac\|pid\|detect_date\|regdate\|unregdate\|lastskip\|status\|user_agent\|computername\|notes\|last_arp\|last_dhcp\|switch\|port\|vlan\|dhcp_fingerprint\|nbopenviolations [1] => 00:00:00:00:00:01\|2\|2009-06-03 09:36:22\|\|\|2009-06-03 09:36:22\|unreg\|\|\|\|\|2009-06-03 09:36:22\|\|\|\|\|0 )

(0001246) user4 2009-06-03 09:42	The SQL call does not transmit the last_arp field: $node_modify_sql->execute( $new_mac, $existing->{pid}, $existing->{detect_date}, $existing->{regdate}, $existing->{unregdate}, $existing->{lastskip}, $existing->{status}, $existing->{user_agent}, $existing->{computername}, $existing->{notes}, $existing->{dhcp_fingerprint}, $existing->{last_dhcp}, $existing->{switch}, $existing->{port}, $existing->{vlan}, $mac ) \|\| return (0);

(0001247) user4 2009-06-03 09:54	fixed in mtn revision be1b2d6821af7acb1d9278bf7549bd3aaa4c979a

Relationships