2017-01-24T15:05:43 [sql] [D]   Message Load (1.4ms)  SELECT  `messages`.* FROM `messages`  WHERE `messages`.`digest` = '471afa83239c89d97aca3fc359f265eff842ff0e'  ORDER BY `messages`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]   Source Load (1.3ms)  SELECT  `sources`.* FROM `sources`  WHERE `sources`.`digest` = 'ee8e5f6065d6ce73da9d8f66e6e28a8716c68db4'  ORDER BY `sources`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]    (1.0ms)  BEGIN
2017-01-24T15:05:43 [sql] [D]   SQL (2.5ms)  INSERT INTO `logs` (`created_at`, `level_id`, `message_id`, `report_id`, `source_id`, `updated_at`) VALUES ('2017-01-24 15:05:43', 3, 5895, 120153, 3672, '2017-01-24 15:05:43')
2017-01-24T15:05:43 [sql] [D]    (5.8ms)  COMMIT
2017-01-24T15:05:43 [sql] [D]   Message Load (1.7ms)  SELECT  `messages`.* FROM `messages`  WHERE `messages`.`digest` = 'ad395e5acf038a42152c70f7858c9368cc793dcb'  ORDER BY `messages`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]   Source Load (1.4ms)  SELECT  `sources`.* FROM `sources`  WHERE `sources`.`digest` = '5a30df2ceb086eedc141acf276f58c275f250a8a'  ORDER BY `sources`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [app] [I] Started POST "/api/auth_source_ldaps" for 10.20.0.8 at 2017-01-24 15:05:43 +0000
2017-01-24T15:05:43 [sql] [D]    (0.9ms)  BEGIN
2017-01-24T15:05:43 [app] [I] Processing by Api::V2::AuthSourceLdapsController#create as JSON
2017-01-24T15:05:43 [app] [I]   Parameters: {"auth_source_ldap"=>{"attr_mail"=>"mail", "tls"=>true, "account"=>"b09876@itsupport.example.com", "name"=>"LDAP-Server", "server_type"=>"active_directory", "groups_base"=>"DC=ITSupport,DC=example,DC=com", "onthefly_register"=>true, "host"=>"ldap-test.com", "account_password"=>"[FILTERED]", "attr_firstname"=>"givenName", "usergroup_sync"=>false, "base_dn"=>"DC=ITSupport,DC=example,DC=com", "attr_lastname"=>"sn", "attr_login"=>"sAMAccountName", "port"=>"636", "ldap_filter"=>"(memberof=CN=TestUsers,OU=Application,OU=Groups,DC=ITSupport,DC=example,DC=com)"}, "apiv"=>"v2"}
2017-01-24T15:05:43 [sql] [D]   SQL (1.2ms)  INSERT INTO `logs` (`created_at`, `level_id`, `message_id`, `report_id`, `source_id`, `updated_at`) VALUES ('2017-01-24 15:05:43', 2, 5892, 120153, 6924, '2017-01-24 15:05:43')
2017-01-24T15:05:43 [sql] [D]   User Load (1.7ms)  SELECT  `users`.* FROM `users`  WHERE `users`.`lower_login` = 'admin' LIMIT 1
2017-01-24T15:05:43 [sql] [D]   AuthSource Load (1.3ms)  SELECT  `auth_sources`.* FROM `auth_sources`  WHERE `auth_sources`.`id` = 3 LIMIT 1
2017-01-24T15:05:43 [sql] [D]    (5.2ms)  COMMIT
2017-01-24T15:05:43 [sql] [D]   CACHE (0.0ms)  SELECT  `users`.* FROM `users`  WHERE `users`.`lower_login` = 'admin' LIMIT 1
2017-01-24T15:05:43 [sql] [D] Authenticated user admin against INTERNAL authentication source
2017-01-24T15:05:43 [sql] [D]   User Load (1.1ms)  SELECT  `users`.* FROM `users`  WHERE `users`.`lower_login` = 'foreman_admin' LIMIT 1
2017-01-24T15:05:43 [sql] [D] Post-login processing for admin
2017-01-24T15:05:43 [sql] [D]   CACHE (0.0ms)  SELECT  `users`.* FROM `users`  WHERE `users`.`lower_login` = 'foreman_admin' LIMIT 1
2017-01-24T15:05:43 [sql] [D]    (1.0ms)  BEGIN
2017-01-24T15:05:43 [sql] [D]   Message Load (2.0ms)  SELECT  `messages`.* FROM `messages`  WHERE `messages`.`digest` = '471afa83239c89d97aca3fc359f265eff842ff0e'  ORDER BY `messages`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]   SQL (1.1ms)  UPDATE `users` SET `last_login_on` = '2017-01-24 15:05:43', `updated_at` = '2017-01-24 15:05:43' WHERE `users`.`id` = 9
2017-01-24T15:05:43 [sql] [D]   Source Load (1.1ms)  SELECT  `sources`.* FROM `sources`  WHERE `sources`.`digest` = '5a30df2ceb086eedc141acf276f58c275f250a8a'  ORDER BY `sources`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]   Role Load (1.1ms)  SELECT  `roles`.* FROM `roles`  WHERE `roles`.`name` = 'Anonymous' LIMIT 1
2017-01-24T15:05:43 [sql] [D]    (2.3ms)  BEGIN
2017-01-24T15:05:43 [sql] [D]    (1.0ms)  SELECT `roles`.id FROM `roles` INNER JOIN `user_roles` ON `roles`.`id` = `user_roles`.`role_id` WHERE `user_roles`.`owner_id` = 9 AND `user_roles`.`owner_type` = 'User'
2017-01-24T15:05:43 [sql] [D]   SQL (1.8ms)  INSERT INTO `logs` (`created_at`, `level_id`, `message_id`, `report_id`, `source_id`, `updated_at`) VALUES ('2017-01-24 15:05:43', 3, 5895, 120153, 6924, '2017-01-24 15:05:43')
2017-01-24T15:05:43 [sql] [D]    (2.2ms)  COMMIT
2017-01-24T15:05:43 [sql] [D]   CACHE (0.0ms)  SELECT  `roles`.* FROM `roles`  WHERE `roles`.`name` = 'Anonymous' LIMIT 1
2017-01-24T15:05:43 [sql] [D]    (2.3ms)  COMMIT
2017-01-24T15:05:43 [sql] [D]   Role Exists (0.9ms)  SELECT  1 AS one FROM `roles` INNER JOIN `user_roles` ON `roles`.`id` = `user_roles`.`role_id` WHERE `user_roles`.`owner_id` = 9 AND `user_roles`.`owner_type` = 'User' AND `roles`.`id` = 24 LIMIT 1
2017-01-24T15:05:43 [sql] [D]    (6.8ms)  SELECT auth_sources.id FROM `auth_sources`  WHERE `auth_sources`.`type` IN ('AuthSourceHidden')
2017-01-24T15:05:43 [sql] [D]   Message Load (7.7ms)  SELECT  `messages`.* FROM `messages`  WHERE `messages`.`digest` = 'ad395e5acf038a42152c70f7858c9368cc793dcb'  ORDER BY `messages`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]   User Load (0.8ms)  SELECT  `users`.* FROM `users`  WHERE (`users`.`auth_source_id` NOT IN (6)) AND `users`.`lower_login` = 'admin'  ORDER BY firstname LIMIT 1
2017-01-24T15:05:43 [sql] [D]   Source Load (1.0ms)  SELECT  `sources`.* FROM `sources`  WHERE `sources`.`digest` = '9dc9520cd8bcfc2ece3725848051cfd114f2ad26'  ORDER BY `sources`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [app] [I] Authorized user admin(Admin User)
2017-01-24T15:05:43 [sql] [D]    (1.7ms)  BEGIN
2017-01-24T15:05:43 [sql] [D]    (1.2ms)  BEGIN
2017-01-24T15:05:43 [sql] [D]   SQL (1.0ms)  INSERT INTO `logs` (`created_at`, `level_id`, `message_id`, `report_id`, `source_id`, `updated_at`) VALUES ('2017-01-24 15:05:43', 2, 5892, 120153, 3675, '2017-01-24 15:05:43')
2017-01-24T15:05:43 [sql] [D]    (1.5ms)  COMMIT
2017-01-24T15:05:43 [sql] [D]   Message Load (0.8ms)  SELECT  `messages`.* FROM `messages`  WHERE `messages`.`digest` = '471afa83239c89d97aca3fc359f265eff842ff0e'  ORDER BY `messages`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]   AuthSource Exists (0.8ms)  SELECT  1 AS one FROM `auth_sources`  WHERE `auth_sources`.`name` = BINARY 'LDAP-Server' LIMIT 1
2017-01-24T15:05:43 [sql] [D]   Source Load (0.8ms)  SELECT  `sources`.* FROM `sources`  WHERE `sources`.`digest` = '9dc9520cd8bcfc2ece3725848051cfd114f2ad26'  ORDER BY `sources`.`id` ASC LIMIT 1
2017-01-24T15:05:43 [sql] [D]    (2.3ms)  BEGIN
2017-01-24T15:05:43 [sql] [D]   SQL (1.1ms)  INSERT INTO `auth_sources` (`account`, `account_password`, `attr_firstname`, `attr_lastname`, `attr_login`, `attr_mail`, `base_dn`, `created_at`, `groups_base`, `host`, `ldap_filter`, `name`, `onthefly_register`, `port`, `server_type`, `tls`, `type`, `updated_at`, `usergroup_sync`) VALUES ('b09876@itsupport.example.com', 'encrypted-OWt0cXVoYlMxRmFlL3FLaGQ2Z1NBSzBBQ1JzaVU0WE8rbGRtYkN5bnV6Zz0tLUk2THE1Z0I3WXk1TmNzVUp1bFA5elE9PQ==--b60164899c515a55ba4ee64cacb19a727a2a6014', 'givenName', 'sn', 'sAMAccountName', 'mail', 'DC=ITSupport,DC=example,DC=com', '2017-01-24 15:05:43', 'DC=ITSupport,DC=example,DC=com', 'ldap-test.com', '(memberof=CN=TestUsers,OU=Application,OU=Groups,DC=ITSupport,DC=example,DC=com)', 'LDAP-Server', 1, 636, 'active_directory', 1, 'AuthSourceLdap', '2017-01-24 15:05:43', 0)
2017-01-24T15:05:43 [sql] [D]   SQL (3.5ms)  INSERT INTO `logs` (`created_at`, `level_id`, `message_id`, `report_id`, `source_id`, `updated_at`) VALUES ('2017-01-24 15:05:43', 3, 5895, 120153, 3675, '2017-01-24 15:05:43')
2017-01-24T15:05:43 [sql] [D]   AuthSource Load (1.2ms)  SELECT  `auth_sources`.* FROM `auth_sources`  WHERE `auth_sources`.`id` = 153 LIMIT 1
2017-0