{"action":"created","issue":{"url":"https://api.github.com/repos/Yubico/yubikey-val/issues/41","repository_url":"https://api.github.com/repos/Yubico/yubikey-val","labels_url":"https://api.github.com/repos/Yubico/yubikey-val/issues/41/labels{/name}","comments_url":"https://api.github.com/repos/Yubico/yubikey-val/issues/41/comments","events_url":"https://api.github.com/repos/Yubico/yubikey-val/issues/41/events","html_url":"https://github.com/Yubico/yubikey-val/issues/41","id":151453803,"number":41,"title":"yk_publicname in ykval-synclib.php","user":{"login":"bmwt","id":705981,"avatar_url":"https://avatars.githubusercontent.com/u/705981?v=3","gravatar_id":"","url":"https://api.github.com/users/bmwt","html_url":"https://github.com/bmwt","followers_url":"https://api.github.com/users/bmwt/followers","following_url":"https://api.github.com/users/bmwt/following{/other_user}","gists_url":"https://api.github.com/users/bmwt/gists{/gist_id}","starred_url":"https://api.github.com/users/bmwt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmwt/subscriptions","organizations_url":"https://api.github.com/users/bmwt/orgs","repos_url":"https://api.github.com/users/bmwt/repos","events_url":"https://api.github.com/users/bmwt/events{/privacy}","received_events_url":"https://api.github.com/users/bmwt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-04-27T18:13:09Z","updated_at":"2016-04-28T14:21:08Z","closed_at":null,"body":"having issues with ykval-queue processing- specifically, something in ykval-synclib.php is not properly passing yk_publicname, causing a bad (null) entry in the yubikeys table. (the \"searching for yk_publicname  in local db\" line)\r\n\r\ndebug info:\r\n\r\nLOG_DEBUG:ykval-queue:synclib:response contains  modified=1461770674 nonce=ihbygicyzcpxrdsattfetzcnocnlvfmg yk_publicname=ccccccddnrki yk_counter=229 yk_use=0 yk_high=21 yk_low=49226\r\nLOG_DEBUG:ykval-queue:synclib:db:DB query is: UPDATE yubikeys SET  modified='1461770674', yk_counter='229', yk_use='0', yk_low='49226', yk_high='21', nonce='ihbygicyzcpxrdsattfetzcnocnlvfmg' WHERE yk_publicname = 'ccccccddnrki' and (229>yk_counter or (229=yk_counter and 0>yk_use))\r\nLOG_INFO:ykval-queue:synclib:database not updated modified=1461770674 nonce=ihbygicyzcpxrdsattfetzcnocnlvfmg yk_publicname=ccccccddnrki yk_counter=229 yk_use=0 yk_high=21 yk_low=49226\r\nLOG_DEBUG:ykval-queue:synclib:searching for yk_publicname  in local db\r\nLOG_DEBUG:ykval-queue:synclib:db:DB query is: SELECT * FROM yubikeys WHERE yk_publicname is NULL LIMIT 1\r\nLOG_NOTICE:ykval-queue:synclib:Discovered new identity \r\nLOG_DEBUG:ykval-queue:synclib:db:DB query is: INSERT INTO yubikeys (active,created,modified,yk_counter,yk_use,yk_low,yk_high,nonce,notes) VALUES ('1','1461780090','-1','-1','-1','-1','-1','0000000000000000','')\r\nLOG_DEBUG:ykval-queue:synclib:db:DB query is: SELECT * FROM yubikeys WHERE yk_publicname is NULL LIMIT 1\r\nLOG_NOTICE:ykval-queue:synclib:params for yk_publicname  not found in database\r\nLOG_DEBUG:ykval-queue:synclib:validation params:  modified= nonce= yk_publicname= yk_counter= yk_use= yk_high= yk_low=\r\nLOG_DEBUG:ykval-queue:synclib:OTP params: \r\nLOG_NOTICE:ykval-queue:synclib:Local server out of sync compared to counters at validation request time. \r\nLOG_WARNING:ykval-queue:synclib:Local server out of sync compared to current local counters. Local server updated. \r\nLOG_ERR:ykval-queue:synclib:Remote server has higher counters than OTP. This response would have marked the OTP as invalid. \r\nLOG_DEBUG:ykval-queue:synclib:deleting queue entry with modified= server_nonce= server=\r\nLOG_DEBUG:ykval-queue:synclib:db:DB query is: DELETE FROM queue WHERE modified = '' and server_nonce = '' and server = ''\r\n"},"comment":{"url":"https://api.github.com/repos/Yubico/yubikey-val/issues/comments/215440278","html_url":"https://github.com/Yubico/yubikey-val/issues/41#issuecomment-215440278","issue_url":"https://api.github.com/repos/Yubico/yubikey-val/issues/41","id":215440278,"user":{"login":"bmwt","id":705981,"avatar_url":"https://avatars.githubusercontent.com/u/705981?v=3","gravatar_id":"","url":"https://api.github.com/users/bmwt","html_url":"https://github.com/bmwt","followers_url":"https://api.github.com/users/bmwt/followers","following_url":"https://api.github.com/users/bmwt/following{/other_user}","gists_url":"https://api.github.com/users/bmwt/gists{/gist_id}","starred_url":"https://api.github.com/users/bmwt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmwt/subscriptions","organizations_url":"https://api.github.com/users/bmwt/orgs","repos_url":"https://api.github.com/users/bmwt/repos","events_url":"https://api.github.com/users/bmwt/events{/privacy}","received_events_url":"https://api.github.com/users/bmwt/received_events","type":"User","site_admin":false},"created_at":"2016-04-28T14:21:08Z","updated_at":"2016-04-28T14:21:08Z","body":"LOG_DEBUG:ykval-queue:synclib:YK-VAL resync adding URL : http://dev-rad.es.net/wsapi/2.0/sync?otp=ccccccddnrkijcktikdlrvlbkreglkvbdehibfbcfdhf&modified=1461701994&yk_publicname=ccccccddnrki&yk_counter=221&yk_use=0&yk_high=73&yk_low=47638&nonce=viesoftpbgyhpkjgtpzuksaxxdktjjge\r\nLOG_DEBUG:ykval-queue:synclib:handle indicated to be for .\r\n\r\n\r\ncurl 7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.19.1 Basic ECC zlib/1.2.3 libidn/1.18 libssh2/1.4.2\r\n\r\nPHP 5.3.3 (cli) (built: Feb  9 2016 10:36:17) \r\n"}}