on affine en cherchant en base les tokens créés sur la période en question:
-- horaire en GMT 0
select * from "Logs" where "type"='access_token'
and "createdAt" > '2017-01-25 16:30:00' and "createdAt" < '2017-01-25 16:45:00'
and "clientId" = 'cbd89e11-c8a2-45ab-93be-deaade1bd17f'
order by "createdAt" desc limit 1000
2270153;"2017-01-25 16:43:43+00";"access_token";276699;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"87f2c89a77251b00628a39ce17b77c3632978e11","userIp":"89.95.201.57","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:43:43.211+00"
2270152;"2017-01-25 16:43:42+00";"access_token";276699;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"8bddeedb7800192040fe3f63092789b10ce272bd","userIp":"89.95.201.57","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:43:42.9+00"
2270151;"2017-01-25 16:43:41+00";"access_token";;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"bb2da568af51de3e9d3842dab965cd9c95c6bfe1","userIp":"89.95.201.57","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:43:41.883+00"
2270136;"2017-01-25 16:42:47+00";"access_token";226991;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"2c947863fbe219d63d637cc47c3ae5d51967604a","userIp":"176.145.224.47","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/55.0.2883.91 Mobile Safari/537.36"}";"2017-01-25 16:42:47.8+00"
2270108;"2017-01-25 16:39:42+00";"access_token";276691;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"6d369adaa7483e6128a95feb77e579997ac092f7","userIp":"89.86.224.128","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:39:42.108+00"
2270109;"2017-01-25 16:39:42+00";"access_token";276691;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"176521850cca01fa0f92b1689a689c114f7aacac","userIp":"89.86.224.128","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:39:42.475+00"
2270107;"2017-01-25 16:39:40+00";"access_token";;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"8f943b46958e1ab198f947427ecca670a61045ae","userIp":"89.86.224.128","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:39:40.892+00"
2270082;"2017-01-25 16:37:44+00";"access_token";276686;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"6df7f43b21f6093abbd4c27e156fb246b7bf9097","userIp":"89.85.143.157","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:37:44.438+00"
2270083;"2017-01-25 16:37:44+00";"access_token";276686;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"0eda16def32a347dbec02439ddbd557dca01a886","userIp":"89.85.143.157","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:37:44.738+00"
2270081;"2017-01-25 16:37:43+00";"access_token";;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"7ce7711da49a136291c0edee2aa3e7c69e2fd827","userIp":"89.85.143.157","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:37:43.448+00"
2270054;"2017-01-25 16:32:31+00";"access_token";260425;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"456a392116c1306b8c11695cbb1e67fcf7622a30","userIp":"176.148.173.100","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/55.0.2883.91 Mobile Safari/537.36"}";"2017-01-25 16:32:31.627+00"
2270047;"2017-01-25 16:31:50+00";"access_token";276682;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"488bfba6f59ccb711a29a547a4e8748e60f54e71","userIp":"176.161.107.54","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:31:50.414+00"
2270048;"2017-01-25 16:31:50+00";"access_token";276682;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"926c2f536d37cb6e3568ff438ef115f3a647f733","userIp":"176.161.107.54","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:31:50.711+00"
2270046;"2017-01-25 16:31:49+00";"access_token";;"cbd89e11-c8a2-45ab-93be-deaade1bd17f";"{"token":"3f7800502f3e0f6a83cf53e5612d2bde6c85c540","userIp":"176.161.107.54","userAgent":"Mozilla/5.0 (Linux; Android 5.1.1; BouygtelTV Build/MIAMIATV; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/46.0.2490.76 Mobile Safari/537.36"}";"2017-01-25 16:31:49.708+00"
on remarque que la box appelle 2 fois l'url /auth/oauth2/token lorsqu'il y a réponse 403. (token expiré?)
a priori normal, l'échange semble rapide.
erreur le 25/01/2017 entre 17h35 et 17h42 sur bbox associée au compte afrostreamstudiofrance@bbox.fr
Analyse log entries: 01/25/2017 17:35:00 - 01/25/2017 17:42:00 recherche sur : status NOT 200 AND router AND NOT '/alive'
recherche BouygtelTV
on affine en cherchant en base les tokens créés sur la période en question:
on remarque que la box appelle 2 fois l'url /auth/oauth2/token lorsqu'il y a réponse 403. (token expiré?) a priori normal, l'échange semble rapide.
l'analyse du 403 ne montre rien de particulier, nous n'avons pas l'info du body posté, => TODO
TODO: