API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 11th, 2013
114
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.39 KB | None | 0 0
raw download clone embed print report
  1. Started GET "/api/fact_values?search=fact%20=%20hostname%20and%20(%20host=shinken01.example.com%20or%20host=shinken11.example.com%20or%20host=shinken51.example.com%20" for 192.168.200.117 at Mon Mar 11 17:34:36 +0100 2013
  2. Processing by Api::V1::FactValuesController#index as JSON
  3. Parameters: {"search"=>"fact = hostname and ( host=shinken01.example.com or host=shinken11.example.com or host=shinken51.example.com "}
  4. User Load (0.8ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'remote' LIMIT 1
  5. AuthSource Load (0.5ms) SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  6. User Load (0.8ms) SELECT `users`.* FROM `users` WHERE (login='remote') LIMIT 1
  7. Authenticated user Remote User against INTERNAL authentication source
  8. User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' ORDER BY firstname LIMIT 1
  9. Setting current user thread-local variable to admin
  10. SQL (0.4ms) BEGIN
  11. AREL (0.8ms) UPDATE `users` SET `last_login_on` = '2013-03-11 16:34:36', `updated_at` = '2013-03-11 16:34:36' WHERE `users`.`id` = 17
  12. SQL (0.4ms) COMMIT
  13. Role Load (0.6ms) SELECT `roles`.* FROM `roles` WHERE `roles`.`name` = 'Anonymous' LIMIT 1
  14. SQL (0.4ms) SELECT 1 FROM `roles` INNER JOIN `user_roles` ON `roles`.id = `user_roles`.role_id WHERE `roles`.`id` = 8 AND ((`user_roles`.user_id = 17)) LIMIT 1
  15. Setting current user thread-local variable to remote
  16. Setting current user thread-local variable to nil
  17. Setting current user thread-local variable to remote
  18. FactValue Load (3.2ms) SELECT `fact_values`.`id` AS t0_r0, `fact_values`.`value` AS t0_r1, `fact_values`.`fact_name_id` AS t0_r2, `fact_values`.`host_id` AS t0_r3, `fact_values`.`updated_at` AS t0_r4, `fact_values`.`created_at` AS t0_r5, `fact_names`.`id` AS t1_r0, `fact_names`.`name` AS t1_r1, `fact_names`.`updated_at` AS t1_r2, `fact_names`.`created_at` AS t1_r3, `hosts`.`id` AS t2_r0, `hosts`.`name` AS t2_r1, `hosts`.`ip` AS t2_r2, `hosts`.`environment` AS t2_r3, `hosts`.`last_compile` AS t2_r4, `hosts`.`last_freshcheck` AS t2_r5, `hosts`.`last_report` AS t2_r6, `hosts`.`updated_at` AS t2_r7, `hosts`.`source_file_id` AS t2_r8, `hosts`.`created_at` AS t2_r9, `hosts`.`mac` AS t2_r10, `hosts`.`root_pass` AS t2_r11, `hosts`.`serial` AS t2_r12, `hosts`.`puppet_status` AS t2_r13, `hosts`.`domain_id` AS t2_r14, `hosts`.`architecture_id` AS t2_r15, `hosts`.`operatingsystem_id` AS t2_r16, `hosts`.`environment_id` AS t2_r17, `hosts`.`subnet_id` AS t2_r18, `hosts`.`ptable_id` AS t2_r19, `hosts`.`medium_id` AS t2_r20, `hosts`.`build` AS t2_r21, `hosts`.`comment` AS t2_r22, `hosts`.`disk` AS t2_r23, `hosts`.`installed_at` AS t2_r24, `hosts`.`model_id` AS t2_r25, `hosts`.`hostgroup_id` AS t2_r26, `hosts`.`owner_id` AS t2_r27, `hosts`.`owner_type` AS t2_r28, `hosts`.`enabled` AS t2_r29, `hosts`.`puppet_ca_proxy_id` AS t2_r30, `hosts`.`managed` AS t2_r31, `hosts`.`use_image` AS t2_r32, `hosts`.`image_file` AS t2_r33, `hosts`.`uuid` AS t2_r34, `hosts`.`compute_resource_id` AS t2_r35, `hosts`.`puppet_proxy_id` AS t2_r36, `hosts`.`certname` AS t2_r37, `hosts`.`image_id` AS t2_r38, `hosts`.`organization_id` AS t2_r39, `hosts`.`location_id` AS t2_r40 FROM `fact_values` LEFT OUTER JOIN `fact_names` ON `fact_names`.`id` = `fact_values`.`fact_name_id` LEFT OUTER JOIN `hosts` ON `hosts`.`id` = `fact_values`.`host_id` WHERE (fact_names.name <> '_timestamp') AND (((`fact_names`.`name` = BINARY 'hostname') AND ((`hosts`.`name` = BINARY 'shinken01.example.com') OR (`hosts`.`name` = BINARY 'shinken11.example.com') OR (`hosts`.`name` = BINARY 'shinken51.example.com')))) ORDER BY `fact_values`.`value` ASC LIMIT 20 OFFSET 0
  19. Body: {"shinken51.example.com":{"hostname":"shinken51"},"shinken01.example.com":{"hostname":"shinken01"},"shinken11.example.com":{"hostname":"shinken11"}}
  20. Completed 200 OK in 29ms (Views: 0.5ms | ActiveRecord: 8.4ms)
  21.  
  22.  
  23. Started GET "/api/fact_values?search=fact%20=%20hostname%20and%20(%20host=shinken01.example.com%20or%20host=shinken11.example.com%20or%20host=shinken51.example.com%20" for 192.168.200.117 at Mon Mar 11 17:34:37 +0100 2013
  24. Processing by Api::V1::FactValuesController#index as JSON
  25. Parameters: {"search"=>"fact = hostname and ( host=shinken01.example.com or host=shinken11.example.com or host=shinken51.example.com "}
  26. User Load (0.9ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'remote' LIMIT 1
  27. AuthSource Load (0.4ms) SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  28. User Load (0.9ms) SELECT `users`.* FROM `users` WHERE (login='remote') LIMIT 1
  29. Authenticated user Remote User against INTERNAL authentication source
  30. User Load (6.7ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' ORDER BY firstname LIMIT 1
  31. Setting current user thread-local variable to admin
  32. SQL (0.4ms) BEGIN
  33. AREL (0.9ms) UPDATE `users` SET `last_login_on` = '2013-03-11 16:34:37', `updated_at` = '2013-03-11 16:34:37' WHERE `users`.`id` = 17
  34. SQL (0.4ms) COMMIT
  35. Role Load (0.4ms) SELECT `roles`.* FROM `roles` WHERE `roles`.`name` = 'Anonymous' LIMIT 1
  36. SQL (0.4ms) SELECT 1 FROM `roles` INNER JOIN `user_roles` ON `roles`.id = `user_roles`.role_id WHERE `roles`.`id` = 8 AND ((`user_roles`.user_id = 17)) LIMIT 1
  37. Setting current user thread-local variable to remote
  38. Setting current user thread-local variable to nil
  39. Setting current user thread-local variable to remote
  40. FactValue Load (3.1ms) SELECT `fact_values`.`id` AS t0_r0, `fact_values`.`value` AS t0_r1, `fact_values`.`fact_name_id` AS t0_r2, `fact_values`.`host_id` AS t0_r3, `fact_values`.`updated_at` AS t0_r4, `fact_values`.`created_at` AS t0_r5, `fact_names`.`id` AS t1_r0, `fact_names`.`name` AS t1_r1, `fact_names`.`updated_at` AS t1_r2, `fact_names`.`created_at` AS t1_r3, `hosts`.`id` AS t2_r0, `hosts`.`name` AS t2_r1, `hosts`.`ip` AS t2_r2, `hosts`.`environment` AS t2_r3, `hosts`.`last_compile` AS t2_r4, `hosts`.`last_freshcheck` AS t2_r5, `hosts`.`last_report` AS t2_r6, `hosts`.`updated_at` AS t2_r7, `hosts`.`source_file_id` AS t2_r8, `hosts`.`created_at` AS t2_r9, `hosts`.`mac` AS t2_r10, `hosts`.`root_pass` AS t2_r11, `hosts`.`serial` AS t2_r12, `hosts`.`puppet_status` AS t2_r13, `hosts`.`domain_id` AS t2_r14, `hosts`.`architecture_id` AS t2_r15, `hosts`.`operatingsystem_id` AS t2_r16, `hosts`.`environment_id` AS t2_r17, `hosts`.`subnet_id` AS t2_r18, `hosts`.`ptable_id` AS t2_r19, `hosts`.`medium_id` AS t2_r20, `hosts`.`build` AS t2_r21, `hosts`.`comment` AS t2_r22, `hosts`.`disk` AS t2_r23, `hosts`.`installed_at` AS t2_r24, `hosts`.`model_id` AS t2_r25, `hosts`.`hostgroup_id` AS t2_r26, `hosts`.`owner_id` AS t2_r27, `hosts`.`owner_type` AS t2_r28, `hosts`.`enabled` AS t2_r29, `hosts`.`puppet_ca_proxy_id` AS t2_r30, `hosts`.`managed` AS t2_r31, `hosts`.`use_image` AS t2_r32, `hosts`.`image_file` AS t2_r33, `hosts`.`uuid` AS t2_r34, `hosts`.`compute_resource_id` AS t2_r35, `hosts`.`puppet_proxy_id` AS t2_r36, `hosts`.`certname` AS t2_r37, `hosts`.`image_id` AS t2_r38, `hosts`.`organization_id` AS t2_r39, `hosts`.`location_id` AS t2_r40 FROM `fact_values` LEFT OUTER JOIN `fact_names` ON `fact_names`.`id` = `fact_values`.`fact_name_id` LEFT OUTER JOIN `hosts` ON `hosts`.`id` = `fact_values`.`host_id` WHERE (fact_names.name <> '_timestamp') AND (((`fact_names`.`name` = BINARY 'hostname') AND ((`hosts`.`name` = BINARY 'shinken01.example.com') OR (`hosts`.`name` = BINARY 'shinken11.example.com') OR (`hosts`.`name` = BINARY 'shinken51.example.com')))) ORDER BY `fact_values`.`value` ASC LIMIT 20 OFFSET 0
  41. Body: {"shinken01.example.com":{"hostname":"shinken01"},"shinken11.example.com":{"hostname":"shinken11"}}
  42. Completed 200 OK in 34ms (Views: 0.5ms | ActiveRecord: 14.6ms)
  43.  
  44.  
  45. Started GET "/api/fact_values?search=fact%20=%20hostname%20and%20(%20host=shinken01.example.com%20or%20host=shinken11.example.com%20or%20host=shinken51.example.com%20" for 192.168.200.117 at Mon Mar 11 17:34:38 +0100 2013
  46. Processing by Api::V1::FactValuesController#index as JSON
  47. Parameters: {"search"=>"fact = hostname and ( host=shinken01.example.com or host=shinken11.example.com or host=shinken51.example.com "}
  48. User Load (0.8ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'remote' LIMIT 1
  49. AuthSource Load (0.4ms) SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  50. User Load (0.8ms) SELECT `users`.* FROM `users` WHERE (login='remote') LIMIT 1
  51. Authenticated user Remote User against INTERNAL authentication source
  52. User Load (0.9ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' ORDER BY firstname LIMIT 1
  53. Setting current user thread-local variable to admin
  54. SQL (0.3ms) BEGIN
  55. AREL (0.7ms) UPDATE `users` SET `last_login_on` = '2013-03-11 16:34:38', `updated_at` = '2013-03-11 16:34:38' WHERE `users`.`id` = 17
  56. SQL (0.3ms) COMMIT
  57. Role Load (0.4ms) SELECT `roles`.* FROM `roles` WHERE `roles`.`name` = 'Anonymous' LIMIT 1
  58. SQL (0.4ms) SELECT 1 FROM `roles` INNER JOIN `user_roles` ON `roles`.id = `user_roles`.role_id WHERE `roles`.`id` = 8 AND ((`user_roles`.user_id = 17)) LIMIT 1
  59. Setting current user thread-local variable to remote
  60. Setting current user thread-local variable to nil
  61. Setting current user thread-local variable to remote
  62. FactValue Load (2.8ms) SELECT `fact_values`.`id` AS t0_r0, `fact_values`.`value` AS t0_r1, `fact_values`.`fact_name_id` AS t0_r2, `fact_values`.`host_id` AS t0_r3, `fact_values`.`updated_at` AS t0_r4, `fact_values`.`created_at` AS t0_r5, `fact_names`.`id` AS t1_r0, `fact_names`.`name` AS t1_r1, `fact_names`.`updated_at` AS t1_r2, `fact_names`.`created_at` AS t1_r3, `hosts`.`id` AS t2_r0, `hosts`.`name` AS t2_r1, `hosts`.`ip` AS t2_r2, `hosts`.`environment` AS t2_r3, `hosts`.`last_compile` AS t2_r4, `hosts`.`last_freshcheck` AS t2_r5, `hosts`.`last_report` AS t2_r6, `hosts`.`updated_at` AS t2_r7, `hosts`.`source_file_id` AS t2_r8, `hosts`.`created_at` AS t2_r9, `hosts`.`mac` AS t2_r10, `hosts`.`root_pass` AS t2_r11, `hosts`.`serial` AS t2_r12, `hosts`.`puppet_status` AS t2_r13, `hosts`.`domain_id` AS t2_r14, `hosts`.`architecture_id` AS t2_r15, `hosts`.`operatingsystem_id` AS t2_r16, `hosts`.`environment_id` AS t2_r17, `hosts`.`subnet_id` AS t2_r18, `hosts`.`ptable_id` AS t2_r19, `hosts`.`medium_id` AS t2_r20, `hosts`.`build` AS t2_r21, `hosts`.`comment` AS t2_r22, `hosts`.`disk` AS t2_r23, `hosts`.`installed_at` AS t2_r24, `hosts`.`model_id` AS t2_r25, `hosts`.`hostgroup_id` AS t2_r26, `hosts`.`owner_id` AS t2_r27, `hosts`.`owner_type` AS t2_r28, `hosts`.`enabled` AS t2_r29, `hosts`.`puppet_ca_proxy_id` AS t2_r30, `hosts`.`managed` AS t2_r31, `hosts`.`use_image` AS t2_r32, `hosts`.`image_file` AS t2_r33, `hosts`.`uuid` AS t2_r34, `hosts`.`compute_resource_id` AS t2_r35, `hosts`.`puppet_proxy_id` AS t2_r36, `hosts`.`certname` AS t2_r37, `hosts`.`image_id` AS t2_r38, `hosts`.`organization_id` AS t2_r39, `hosts`.`location_id` AS t2_r40 FROM `fact_values` LEFT OUTER JOIN `fact_names` ON `fact_names`.`id` = `fact_values`.`fact_name_id` LEFT OUTER JOIN `hosts` ON `hosts`.`id` = `fact_values`.`host_id` WHERE (fact_names.name <> '_timestamp') AND (((`fact_names`.`name` = BINARY 'hostname') AND ((`hosts`.`name` = BINARY 'shinken01.example.com') OR (`hosts`.`name` = BINARY 'shinken11.example.com') OR (`hosts`.`name` = BINARY 'shinken51.example.com')))) ORDER BY `fact_values`.`value` ASC LIMIT 20 OFFSET 0
  63. Body: {"shinken51.example.com":{"hostname":"shinken51"},"shinken01.example.com":{"hostname":"shinken01"},"shinken11.example.com":{"hostname":"shinken11"}}
  64. Completed 200 OK in 30ms (Views: 0.6ms | ActiveRecord: 7.9ms)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!