H2-invent / jitsi-admin

Organize and fully controll your jitsi meet meetings. Make your meeting secure and be sure that only you and your fellows can join your meeting.
https://meetling.de
GNU Affero General Public License v3.0
133 stars 48 forks source link

SMTP issues #187

Closed timowevel1 closed 2 years ago

timowevel1 commented 3 years ago

Hey,

when I access my configured Domain in the Apache Virtual Host, it redirects me to keycloak and throws me an Invalid parameter: redirect_uri error. Any idea how I have to set the redirect url?

Thanks.

timowevel1 commented 3 years ago

Error resolved, now I get a 500 Internal Server error after logging in into keycloak.

[2021-05-14T01:23:58.503890+02:00] request.INFO: Matched route "connect_keycloak_check". {"route":"connect_keycloak_check","route_parameters":{"_route":"connect_keycloak_check","_controller":"App\\Controller\\LoginControllerKeycloak::check","_locale":"de"},"request_uri":"https://jitsi.timowevelsiep.de/index.php/login/keycloak_login/check?code=7c867666-161f-421c-a236-f265dedcf8c4.6b37546d-8a24-46f4-8645-d3cf7eee978a.67a6ccd4-9bf5-45b0-91f5-bae6494c81da&session_state=6b37546d-8a24-46f4-8645-d3cf7eee978a&state=63db472068f94e0f6ef9b5d14f0f6447","method":"GET"} [] [2021-05-14T01:23:58.509886+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-14T01:23:58.509911+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-14T01:23:58.509934+02:00] security.DEBUG: Calling getCredentials() on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-14T01:23:58.560895+02:00] security.DEBUG: Passing guard token information to the GuardAuthenticationProvider {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-14T01:23:58.571538+02:00] php.WARNING: Notice: Undefined index: email {"exception":"[object] (ErrorException(code: 0): Notice: Undefined index: email at /var/www/jitsi-admin/vendor/stevenmaguire/oauth2-keycloak/src/Provider/KeycloakResourceOwner.php:43)"} [] [2021-05-14T01:23:58.571582+02:00] php.WARNING: Notice: Undefined index: given_name {"exception":"[object] (ErrorException(code: 0): Notice: Undefined index: given_name at /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php:60)"} [] [2021-05-14T01:23:58.571601+02:00] php.WARNING: Notice: Undefined index: family_name {"exception":"[object] (ErrorException(code: 0): Notice: Undefined index: family_name at /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php:61)"} [] [2021-05-14T01:23:58.585471+02:00] php.CRITICAL: Uncaught Error: Argument 1 passed to App\Entity\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101 {"exception":"[object] (TypeError(code: 0): Argument 1 passed to App\\Entity\\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101 at /var/www/jitsi-admin/src/Entity/UserBase.php:39)"} [] [2021-05-14T01:23:58.592733+02:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Argument 1 passed to App\Entity\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101" at /var/www/jitsi-admin/src/Entity/UserBase.php line 39 {"exception":"[object] (TypeError(code: 0): Argument 1 passed to App\\Entity\\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101 at /var/www/jitsi-admin/src/Entity/UserBase.php:39)"} [] [2021-05-14T01:24:17.829147+02:00] request.INFO: Matched route "connect_keycloak_check". {"route":"connect_keycloak_check","route_parameters":{"_route":"connect_keycloak_check","_controller":"App\\Controller\\LoginControllerKeycloak::check","_locale":"de"},"request_uri":"https://jitsi.timowevelsiep.de/index.php/login/keycloak_login/check?code=8d165ff6-3694-4d46-9bdb-7c9b4875f982.f3da0dc2-984b-44d9-9141-4a9ae833d03d.67a6ccd4-9bf5-45b0-91f5-bae6494c81da&session_state=f3da0dc2-984b-44d9-9141-4a9ae833d03d&state=a9bdc4595c2c5ff24fb4f28ecf98d883","method":"GET"} [] [2021-05-14T01:24:17.831262+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-14T01:24:17.831278+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-14T01:24:17.831296+02:00] security.DEBUG: Calling getCredentials() on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-14T01:24:17.849294+02:00] security.DEBUG: Passing guard token information to the GuardAuthenticationProvider {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-14T01:24:17.862804+02:00] php.WARNING: Notice: Undefined index: email {"exception":"[object] (ErrorException(code: 0): Notice: Undefined index: email at /var/www/jitsi-admin/vendor/stevenmaguire/oauth2-keycloak/src/Provider/KeycloakResourceOwner.php:43)"} [] [2021-05-14T01:24:17.862863+02:00] php.WARNING: Notice: Undefined index: given_name {"exception":"[object] (ErrorException(code: 0): Notice: Undefined index: given_name at /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php:60)"} [] [2021-05-14T01:24:17.862896+02:00] php.WARNING: Notice: Undefined index: family_name {"exception":"[object] (ErrorException(code: 0): Notice: Undefined index: family_name at /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php:61)"} [] [2021-05-14T01:24:17.874381+02:00] php.CRITICAL: Uncaught Error: Argument 1 passed to App\Entity\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101 {"exception":"[object] (TypeError(code: 0): Argument 1 passed to App\\Entity\\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101 at /var/www/jitsi-admin/src/Entity/UserBase.php:39)"} [] [2021-05-14T01:24:17.875836+02:00] request.CRITICAL: Uncaught PHP Exception TypeError: "Argument 1 passed to App\Entity\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101" at /var/www/jitsi-admin/src/Entity/UserBase.php line 39 {"exception":"[object] (TypeError(code: 0): Argument 1 passed to App\\Entity\\UserBase::setUuid() must be of the type string, null given, called in /var/www/jitsi-admin/src/Security/GuardServiceKeycloak.php on line 101 at /var/www/jitsi-admin/src/Entity/UserBase.php:39)"} []

holema commented 3 years ago

@timowevel03 You have to set the keycloak URL in the .env.local. This error was here diskussed.

142

You have to add the allowed redirect URLs in Keycloak

timowevel1 commented 3 years ago

redirect_uri isnt the problem anymore, I receive the error above. All URLs are set.

holema commented 3 years ago

hey @timowevel03 The problem seems to me, that your apache mod_rewrite is not correct set. in you log there ist url/index.php written. This is normaly not necessary, when apach is set up corect, because the index.php is not triggered directly. it ist only used to rewrite the route. And I think that you keycloak sends the wrong informations like email to the jitsi-admin. That´s the reason why it is null, because the jitsi-admin gets no email from the keycloak.

holema commented 3 years ago

@timowevel03 Is you problem solved?

timowevel1 commented 3 years ago

Not yet, I will try it

timowevel1 commented 3 years ago

I am a bit desperated right now. I also enabled mod_rewrite, Server Error 500. Where exactly can I get logs from? I first get redirected to keycloak. As soon as I log in there, I get back to my FQDN of Jitsi-Admin and there appears the 500.

timowevel1 commented 3 years ago

Okay, got it working by installing another php extensions. It seems to work now but I got issues with smtp setup. Which encryption types are supported?

timowevel1 commented 3 years ago

Keycloak seems to work, I got my Mail at https://www.ionos.de/hilfe/e-mail/allgemeine-themen/serverinformationen-fuer-imap-pop-und-smtp/ Tried all ports, SSL, TLS, nothing works. Keycloak Email sending works fine. Log: [2021-05-20T10:57:54.517748+02:00] app.INFO: Mail To: mail@timowevelsiep.de [] [] [2021-05-20T10:57:54.524136+02:00] doctrine.DEBUG: "START TRANSACTION" [] [] [2021-05-20T10:57:54.524647+02:00] doctrine.DEBUG: INSERT INTO rooms_user (rooms_id, user_id) VALUES (?, ?) [6,3] [] [2021-05-20T10:57:54.525654+02:00] doctrine.DEBUG: "COMMIT" [] [] [2021-05-20T10:57:54.541168+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T10:57:55.682820+02:00] app.ERROR: Exception occurred while flushing email queue: Expected response code 250 but got code "550", with message "550-Requested action not taken: mailbox unavailable 550 invalid DNS MX or A/AAAA resource record " [] [] [2021-05-20T10:57:55.805867+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T10:57:55.811785+02:00] request.INFO: Matched route "dashboard". {"route":"dashboard","route_parameters":{"_route":"dashboard","_controller":"App\\Controller\\DashboardController::dashboard","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/dashboard?snack=Teilnehmer%20wurden%20eingeladen","method":"GET"} [] [2021-05-20T10:57:55.814010+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T10:57:55.823126+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T10:57:55.829977+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T10:57:55.830143+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T10:57:55.830186+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T10:57:55.830220+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T10:57:55.833621+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T10:57:55+02:00"] [] [2021-05-20T10:57:55.837820+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start DESC [1,"2021-05-20T10:57:55+02:00"] [] [2021-05-20T10:57:55.839287+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND r0_.start < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T10:57:55+02:00","2021-05-20T10:57:55+02:00"] [] [2021-05-20T10:57:55.840836+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) AND ((r0_.enddate BETWEEN ? AND ?) OR (r0_.start BETWEEN ? AND ?) OR (r0_.enddate >= ? AND r0_.start <= ?)) [1,"2021-05-20T10:57:55+02:00","2021-05-20T23:59:59+02:00","2021-05-20T10:57:55+02:00","2021-05-20T23:59:59+02:00","2021-05-20T23:59:59+02:00","2021-05-20T10:57:55+02:00"] [] [2021-05-20T10:57:55.841638+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 INNER JOIN server_user ON t0.id = server_user.server_id WHERE server_user.user_id = ? [1] [] [2021-05-20T10:57:55.842516+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.keycloak_group AS keycloak_group_2, t0.server_id AS server_id_3 FROM keycloak_groups_to_servers t0 WHERE t0.keycloak_group = ? ["hotmail.de"] [] [2021-05-20T10:57:55.842792+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T10:57:55.842990+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T10:57:55.848280+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.schedule_meeting = 1 [1] [] [2021-05-20T10:57:55.850330+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN rooms_user ON t0.id = rooms_user.user_id WHERE rooms_user.rooms_id = ? [6] [] [2021-05-20T10:57:55.851632+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN user_user ON t0.id = user_user.user_target WHERE user_user.user_source = ? [1] [] [2021-05-20T10:57:55.852879+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.license_key AS license_key_2, t0.license AS license_3, t0.valid_until AS valid_until_4, t0.url AS url_5 FROM license t0 WHERE t0.license_key IS NULL LIMIT 1 [] [] [2021-05-20T10:57:55.856067+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T10:57:56.196114+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T10:57:56.201098+02:00] request.INFO: Matched route "_wdt". {"route":"_wdt","route_parameters":{"_route":"_wdt","_controller":"web_profiler.controller.profiler::toolbarAction","token":"269584","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/_wdt/269584","method":"GET"} []

When I use another Email provider:

[2021-05-20T11:09:01.095358+02:00] app.INFO: Mail To: mail@timowevelsiep.de [] [] [2021-05-20T11:09:01.124643+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:01.714233+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:01.718306+02:00] request.INFO: Matched route "dashboard". {"route":"dashboard","route_parameters":{"_route":"dashboard","_controller":"App\\Controller\\DashboardController::dashboard","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/dashboard?snack=Teilnehmer%20gel%C3%B6scht","method":"GET"} [] [2021-05-20T11:09:01.720444+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:01.727930+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:01.735052+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:01.735292+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:01.735360+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:01.735417+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:01.797536+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T11:09:01+02:00"] [] [2021-05-20T11:09:01.872250+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start DESC [1,"2021-05-20T11:09:01+02:00"] [] [2021-05-20T11:09:01.881637+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND r0_.start < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T11:09:01+02:00","2021-05-20T11:09:01+02:00"] [] [2021-05-20T11:09:01.894358+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) AND ((r0_.enddate BETWEEN ? AND ?) OR (r0_.start BETWEEN ? AND ?) OR (r0_.enddate >= ? AND r0_.start <= ?)) [1,"2021-05-20T11:09:01+02:00","2021-05-20T23:59:59+02:00","2021-05-20T11:09:01+02:00","2021-05-20T23:59:59+02:00","2021-05-20T23:59:59+02:00","2021-05-20T11:09:01+02:00"] [] [2021-05-20T11:09:01.915768+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 INNER JOIN server_user ON t0.id = server_user.server_id WHERE server_user.user_id = ? [1] [] [2021-05-20T11:09:01.918241+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.keycloak_group AS keycloak_group_2, t0.server_id AS server_id_3 FROM keycloak_groups_to_servers t0 WHERE t0.keycloak_group = ? ["hotmail.de"] [] [2021-05-20T11:09:01.918798+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T11:09:01.919150+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T11:09:01.962538+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.schedule_meeting = 1 [1] [] [2021-05-20T11:09:02.042095+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN rooms_user ON t0.id = rooms_user.user_id WHERE rooms_user.rooms_id = ? [6] [] [2021-05-20T11:09:02.058861+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN user_user ON t0.id = user_user.user_target WHERE user_user.user_source = ? [1] [] [2021-05-20T11:09:02.063415+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.license_key AS license_key_2, t0.license AS license_3, t0.valid_until AS valid_until_4, t0.url AS url_5 FROM license t0 WHERE t0.license_key IS NULL LIMIT 1 [] [] [2021-05-20T11:09:02.087316+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:02.620945+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:02.627541+02:00] request.INFO: Matched route "_wdt". {"route":"_wdt","route_parameters":{"_route":"_wdt","_controller":"web_profiler.controller.profiler::toolbarAction","token":"393219","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/_wdt/393219","method":"GET"} [] [2021-05-20T11:09:03.543641+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:03.546353+02:00] request.INFO: Matched route "room_add_user". {"route":"room_add_user","route_parameters":{"_route":"room_add_user","_controller":"App\\Controller\\RoomController::roomAddUser","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/add-user?room=6","method":"GET"} [] [2021-05-20T11:09:03.551866+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:03.562140+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:03.572821+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:03.573043+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:03.573093+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:03.573143+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:03.578159+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.enddate AS enddate_4, t0.uid AS uid_5, t0.duration AS duration_6, t0.sequence AS sequence_7, t0.uid_real AS uid_real_8, t0.only_registered_users AS only_registered_users_9, t0.agenda AS agenda_10, t0.dissallow_screenshare_global AS dissallow_screenshare_global_11, t0.dissallow_private_message AS dissallow_private_message_12, t0.public AS public_13, t0.show_room_on_joinpage AS show_room_on_joinpage_14, t0.uid_participant AS uid_participant_15, t0.uid_moderator AS uid_moderator_16, t0.max_participants AS max_participants_17, t0.schedule_meeting AS schedule_meeting_18, t0.waitinglist AS waitinglist_19, t0.server_id AS server_id_20, t0.moderator_id AS moderator_id_21 FROM rooms t0 WHERE t0.id = ? LIMIT 1 ["6"] [] [2021-05-20T11:09:03.591413+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN rooms_user ON t0.id = rooms_user.user_id WHERE rooms_user.rooms_id = ? [6] [] [2021-05-20T11:09:03.592404+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.room_id AS room_id_4 FROM waitinglist t0 WHERE t0.room_id = ? [6] [] [2021-05-20T11:09:03.598934+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:06.575544+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:06.580491+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=m","method":"GET"} [] [2021-05-20T11:09:06.586865+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:06.632945+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:06.675368+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:06.676783+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:06.677086+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:06.677161+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:06.677220+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:06.679588+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=ma","method":"GET"} [] [2021-05-20T11:09:06.689544+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%m%"] [] [2021-05-20T11:09:06.718037+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:06.739225+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:06.766666+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:06.775264+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:06.775455+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:06.775525+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:06.775561+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:06.782336+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%ma%"] [] [2021-05-20T11:09:06.793455+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:07.860702+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:07.863206+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mai","method":"GET"} [] [2021-05-20T11:09:07.866243+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:07.875639+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:07.883923+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:07.884148+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:07.884259+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:07.884317+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:07.888561+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mai%"] [] [2021-05-20T11:09:07.895270+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:08.095440+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:08.097845+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail","method":"GET"} [] [2021-05-20T11:09:08.099817+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:08.115412+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:08.122534+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:08.122766+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:08.122834+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.122887+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.133710+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail%"] [] [2021-05-20T11:09:08.142116+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:08.349457+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:08.351061+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40","method":"GET"} [] [2021-05-20T11:09:08.352687+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:08.358894+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:08.367101+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:08.367340+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:08.367411+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.367513+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.371984+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@%"] [] [2021-05-20T11:09:08.377139+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:08.457128+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:08.459265+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40","method":"GET"} [] [2021-05-20T11:09:08.461270+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:08.468659+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:08.475695+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:08.475949+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:08.476009+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.476064+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.480530+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@%"] [] [2021-05-20T11:09:08.483134+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:08.563689+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:08.565597+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40","method":"GET"} [] [2021-05-20T11:09:08.566992+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:08.572050+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:08.576932+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:08.577107+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:08.577170+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.577221+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.580023+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@%"] [] [2021-05-20T11:09:08.582699+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:08.660498+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:08.662995+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40ti","method":"GET"} [] [2021-05-20T11:09:08.665110+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:08.672545+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:08.679081+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:08.679293+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:08.679355+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.679405+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.683298+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@ti%"] [] [2021-05-20T11:09:08.686947+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:08.764528+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:08.766585+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40ti","method":"GET"} [] [2021-05-20T11:09:08.768436+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:08.774413+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:08.780526+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:08.780728+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:08.780790+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.780839+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.784740+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@ti%"] [] [2021-05-20T11:09:08.787715+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:08.916335+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:08.918403+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40tim","method":"GET"} [] [2021-05-20T11:09:08.920041+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:08.926028+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:08.931938+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:08.932149+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:08.932224+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.932271+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:08.937495+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@tim%"] [] [2021-05-20T11:09:08.946304+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:09.112501+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:09.115030+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timo","method":"GET"} [] [2021-05-20T11:09:09.117537+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:09.140892+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:09.163634+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:09.163911+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:09.163978+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:09.164029+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:09.171944+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timo%"] [] [2021-05-20T11:09:09.176584+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:09.177284+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:09.178556+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timow","method":"GET"} [] [2021-05-20T11:09:09.181302+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:09.187661+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:09.192775+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:09.192950+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:09.193026+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:09.193086+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:09.197356+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timow%"] [] [2021-05-20T11:09:09.204447+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:09.374823+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:09.377241+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowe","method":"GET"} [] [2021-05-20T11:09:09.378478+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:09.384557+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:09.390302+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:09.390494+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:09.390543+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:09.390580+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:09.393957+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowe%"] [] [2021-05-20T11:09:09.400533+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:10.096918+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:10.100952+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowev","method":"GET"} [] [2021-05-20T11:09:10.104352+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:10.115177+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:10.125238+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:10.125482+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:10.125550+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.125610+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.130636+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowev%"] [] [2021-05-20T11:09:10.136989+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:10.445300+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:10.447838+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevel","method":"GET"} [] [2021-05-20T11:09:10.450094+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:10.457233+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:10.464448+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:10.464674+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:10.464735+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.464784+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.468599+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevel%"] [] [2021-05-20T11:09:10.473672+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:10.539258+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:10.541771+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevel","method":"GET"} [] [2021-05-20T11:09:10.543783+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:10.551184+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:10.558340+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:10.558590+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:10.558663+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.558724+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.563107+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevel%"] [] [2021-05-20T11:09:10.567082+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:10.648790+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:10.651102+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsi","method":"GET"} [] [2021-05-20T11:09:10.653028+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:10.660282+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:10.667361+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:10.667657+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:10.667723+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.667781+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.672297+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsi%"] [] [2021-05-20T11:09:10.676561+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:10.742893+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:10.745561+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsi","method":"GET"} [] [2021-05-20T11:09:10.747606+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:10.756980+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:10.767373+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:10.767658+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:10.767735+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.767794+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.775216+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsi%"] [] [2021-05-20T11:09:10.782050+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:10.845346+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:10.847301+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsie","method":"GET"} [] [2021-05-20T11:09:10.849149+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:10.854902+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:10.860745+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:10.860963+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:10.861020+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.861087+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.864734+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsie%"] [] [2021-05-20T11:09:10.869009+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:10.920598+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:10.924688+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsiep","method":"GET"} [] [2021-05-20T11:09:10.926769+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:10.934954+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:10.942710+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:10.943183+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:10.943251+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.943352+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:10.950070+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsiep%"] [] [2021-05-20T11:09:10.956289+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:11.140641+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:11.142807+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsiep.d","method":"GET"} [] [2021-05-20T11:09:11.144581+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:11.151111+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:11.156282+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:11.156514+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:11.156583+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.156640+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.160304+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsiep.d%"] [] [2021-05-20T11:09:11.163892+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:11.223888+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:11.227014+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsiep.de","method":"GET"} [] [2021-05-20T11:09:11.229695+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:11.237623+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:11.246243+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:11.246514+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:11.246577+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.246631+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.252435+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsiep.de%"] [] [2021-05-20T11:09:11.257938+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:11.325156+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:11.327370+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsiep.de","method":"GET"} [] [2021-05-20T11:09:11.329211+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:11.335409+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:11.342576+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:11.342858+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:11.342932+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.342991+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.347396+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsiep.de%"] [] [2021-05-20T11:09:11.351538+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:11.426382+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:11.429090+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=mail%40timowevelsiep.de","method":"GET"} [] [2021-05-20T11:09:11.431197+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:11.438187+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:11.447853+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:11.448109+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:11.448193+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.448251+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:11.454002+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%mail@timowevelsiep.de%"] [] [2021-05-20T11:09:11.459037+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:12.561592+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:12.563913+02:00] request.INFO: Matched route "room_add_user". {"route":"room_add_user","route_parameters":{"_route":"room_add_user","_controller":"App\\Controller\\RoomController::roomAddUser","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/add-user?room=6","method":"POST"} [] [2021-05-20T11:09:12.567050+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:12.577722+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:12.588233+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:12.588531+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:12.588612+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:12.588669+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:12.594430+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.enddate AS enddate_4, t0.uid AS uid_5, t0.duration AS duration_6, t0.sequence AS sequence_7, t0.uid_real AS uid_real_8, t0.only_registered_users AS only_registered_users_9, t0.agenda AS agenda_10, t0.dissallow_screenshare_global AS dissallow_screenshare_global_11, t0.dissallow_private_message AS dissallow_private_message_12, t0.public AS public_13, t0.show_room_on_joinpage AS show_room_on_joinpage_14, t0.uid_participant AS uid_participant_15, t0.uid_moderator AS uid_moderator_16, t0.max_participants AS max_participants_17, t0.schedule_meeting AS schedule_meeting_18, t0.waitinglist AS waitinglist_19, t0.server_id AS server_id_20, t0.moderator_id AS moderator_id_21 FROM rooms t0 WHERE t0.id = ? LIMIT 1 ["6"] [] [2021-05-20T11:09:12.678322+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:12.878799+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:12.881283+02:00] request.INFO: Matched route "dashboard". {"route":"dashboard","route_parameters":{"_route":"dashboard","_controller":"App\\Controller\\DashboardController::dashboard","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/dashboard?snack=Einige%20Teilnehmer%20eingeladen.%20%20ist%2Fsind%20nicht%20korrekt%20und%20k%C3%B6nnen%20nicht%20eingeladen%20werden","method":"GET"} [] [2021-05-20T11:09:12.883415+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:12.891966+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:12.899399+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:12.899675+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:12.899739+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:12.899790+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:12.905350+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T11:09:12+02:00"] [] [2021-05-20T11:09:12.913846+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start DESC [1,"2021-05-20T11:09:12+02:00"] [] [2021-05-20T11:09:12.917273+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND r0_.start < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T11:09:12+02:00","2021-05-20T11:09:12+02:00"] [] [2021-05-20T11:09:12.921206+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) AND ((r0_.enddate BETWEEN ? AND ?) OR (r0_.start BETWEEN ? AND ?) OR (r0_.enddate >= ? AND r0_.start <= ?)) [1,"2021-05-20T11:09:12+02:00","2021-05-20T23:59:59+02:00","2021-05-20T11:09:12+02:00","2021-05-20T23:59:59+02:00","2021-05-20T23:59:59+02:00","2021-05-20T11:09:12+02:00"] [] [2021-05-20T11:09:12.922741+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 INNER JOIN server_user ON t0.id = server_user.server_id WHERE server_user.user_id = ? [1] [] [2021-05-20T11:09:12.923968+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.keycloak_group AS keycloak_group_2, t0.server_id AS server_id_3 FROM keycloak_groups_to_servers t0 WHERE t0.keycloak_group = ? ["hotmail.de"] [] [2021-05-20T11:09:12.924488+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T11:09:12.924849+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T11:09:12.936562+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.schedule_meeting = 1 [1] [] [2021-05-20T11:09:12.939791+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN rooms_user ON t0.id = rooms_user.user_id WHERE rooms_user.rooms_id = ? [6] [] [2021-05-20T11:09:12.941398+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN user_user ON t0.id = user_user.user_target WHERE user_user.user_source = ? [1] [] [2021-05-20T11:09:12.943587+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.license_key AS license_key_2, t0.license AS license_3, t0.valid_until AS valid_until_4, t0.url AS url_5 FROM license t0 WHERE t0.license_key IS NULL LIMIT 1 [] [] [2021-05-20T11:09:12.948574+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:13.373474+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:13.376475+02:00] request.INFO: Matched route "_wdt". {"route":"_wdt","route_parameters":{"_route":"_wdt","_controller":"web_profiler.controller.profiler::toolbarAction","token":"79a393","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/_wdt/79a393","method":"GET"} [] [2021-05-20T11:09:14.542500+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:14.545009+02:00] request.INFO: Matched route "room_add_user". {"route":"room_add_user","route_parameters":{"_route":"room_add_user","_controller":"App\\Controller\\RoomController::roomAddUser","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/add-user?room=6","method":"GET"} [] [2021-05-20T11:09:14.549672+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:14.557310+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:14.564073+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:14.564310+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:14.564386+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:14.564469+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:14.572448+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.enddate AS enddate_4, t0.uid AS uid_5, t0.duration AS duration_6, t0.sequence AS sequence_7, t0.uid_real AS uid_real_8, t0.only_registered_users AS only_registered_users_9, t0.agenda AS agenda_10, t0.dissallow_screenshare_global AS dissallow_screenshare_global_11, t0.dissallow_private_message AS dissallow_private_message_12, t0.public AS public_13, t0.show_room_on_joinpage AS show_room_on_joinpage_14, t0.uid_participant AS uid_participant_15, t0.uid_moderator AS uid_moderator_16, t0.max_participants AS max_participants_17, t0.schedule_meeting AS schedule_meeting_18, t0.waitinglist AS waitinglist_19, t0.server_id AS server_id_20, t0.moderator_id AS moderator_id_21 FROM rooms t0 WHERE t0.id = ? LIMIT 1 ["6"] [] [2021-05-20T11:09:14.582135+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN rooms_user ON t0.id = rooms_user.user_id WHERE rooms_user.rooms_id = ? [6] [] [2021-05-20T11:09:14.582868+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.room_id AS room_id_4 FROM waitinglist t0 WHERE t0.room_id = ? [6] [] [2021-05-20T11:09:14.586129+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:16.446268+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:16.448887+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=m","method":"GET"} [] [2021-05-20T11:09:16.451383+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:16.461591+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:16.471738+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:16.471966+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:16.472115+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:16.472271+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:16.478215+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%m%"] [] [2021-05-20T11:09:16.490036+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:16.559530+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:16.561735+02:00] request.INFO: Matched route "search_participant". {"route":"search_participant","route_parameters":{"_route":"search_participant","_controller":"App\\Controller\\ParticipantController::index","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/participant?search=ma","method":"GET"} [] [2021-05-20T11:09:16.563546+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:16.570282+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:16.577451+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:16.577670+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:16.577763+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:16.577838+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:16.582254+02:00] doctrine.DEBUG: SELECT f0_.id AS id_0, f0_.email AS email_1, f0_.keycloak_id AS keycloak_id_2, f0_.created_at AS created_at_3, f0_.username AS username_4, f0_.last_login AS last_login_5, f0_.first_name AS first_name_6, f0_.last_name AS last_name_7, f0_.register_id AS register_id_8, f0_.keycloakGroup AS keycloakGroup_9, f0_.uid AS uid_10 FROM fos_user f0_ INNER JOIN user_user u2_ ON f0_.id = u2_.user_target INNER JOIN fos_user f1_ ON f1_.id = u2_.user_source WHERE f1_.id = ? AND f0_.email LIKE ? [1,"%ma%"] [] [2021-05-20T11:09:16.587558+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:18.305822+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:18.308100+02:00] request.INFO: Matched route "room_add_user". {"route":"room_add_user","route_parameters":{"_route":"room_add_user","_controller":"App\\Controller\\RoomController::roomAddUser","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/add-user?room=6","method":"POST"} [] [2021-05-20T11:09:18.310205+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:18.316586+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:18.322905+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:18.323129+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:18.323193+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:18.323243+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:18.327896+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.enddate AS enddate_4, t0.uid AS uid_5, t0.duration AS duration_6, t0.sequence AS sequence_7, t0.uid_real AS uid_real_8, t0.only_registered_users AS only_registered_users_9, t0.agenda AS agenda_10, t0.dissallow_screenshare_global AS dissallow_screenshare_global_11, t0.dissallow_private_message AS dissallow_private_message_12, t0.public AS public_13, t0.show_room_on_joinpage AS show_room_on_joinpage_14, t0.uid_participant AS uid_participant_15, t0.uid_moderator AS uid_moderator_16, t0.max_participants AS max_participants_17, t0.schedule_meeting AS schedule_meeting_18, t0.waitinglist AS waitinglist_19, t0.server_id AS server_id_20, t0.moderator_id AS moderator_id_21 FROM rooms t0 WHERE t0.id = ? LIMIT 1 ["6"] [] [2021-05-20T11:09:18.358252+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.email = ? LIMIT 1 ["mail@timowevelsiep.de"] [] [2021-05-20T11:09:18.359033+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.enddate AS enddate_4, t0.uid AS uid_5, t0.duration AS duration_6, t0.sequence AS sequence_7, t0.uid_real AS uid_real_8, t0.only_registered_users AS only_registered_users_9, t0.agenda AS agenda_10, t0.dissallow_screenshare_global AS dissallow_screenshare_global_11, t0.dissallow_private_message AS dissallow_private_message_12, t0.public AS public_13, t0.show_room_on_joinpage AS show_room_on_joinpage_14, t0.uid_participant AS uid_participant_15, t0.uid_moderator AS uid_moderator_16, t0.max_participants AS max_participants_17, t0.schedule_meeting AS schedule_meeting_18, t0.waitinglist AS waitinglist_19, t0.server_id AS server_id_20, t0.moderator_id AS moderator_id_21 FROM rooms t0 INNER JOIN rooms_user ON t0.id = rooms_user.rooms_id WHERE rooms_user.user_id = ? [3] [] [2021-05-20T11:09:18.360463+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN rooms_user ON t0.id = rooms_user.user_id WHERE rooms_user.rooms_id = ? [6] [] [2021-05-20T11:09:18.360918+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN user_user ON t0.id = user_user.user_source WHERE user_user.user_target = ? [3] [] [2021-05-20T11:09:18.364497+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:18.377956+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.license_key AS license_key_2, t0.license AS license_3, t0.valid_until AS valid_until_4, t0.url AS url_5 FROM license t0 WHERE t0.license_key IS NULL LIMIT 1 [] [] [2021-05-20T11:09:18.381203+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.license_key AS license_key_2, t0.license AS license_3, t0.valid_until AS valid_until_4, t0.url AS url_5 FROM license t0 WHERE t0.license_key IS NULL LIMIT 1 [] [] [2021-05-20T11:09:18.381637+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.license_key AS license_key_2, t0.license AS license_3, t0.valid_until AS valid_until_4, t0.url AS url_5 FROM license t0 WHERE t0.license_key IS NULL LIMIT 1 [] [] [2021-05-20T11:09:18.473792+02:00] app.INFO: Mail To: mail@timowevelsiep.de [] [] [2021-05-20T11:09:18.483808+02:00] doctrine.DEBUG: "START TRANSACTION" [] [] [2021-05-20T11:09:18.484596+02:00] doctrine.DEBUG: INSERT INTO rooms_user (rooms_id, user_id) VALUES (?, ?) [6,3] [] [2021-05-20T11:09:18.486394+02:00] doctrine.DEBUG: "COMMIT" [] [] [2021-05-20T11:09:18.493217+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:19.023073+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:19.026446+02:00] request.INFO: Matched route "dashboard". {"route":"dashboard","route_parameters":{"_route":"dashboard","_controller":"App\\Controller\\DashboardController::dashboard","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/room/dashboard?snack=Teilnehmer%20wurden%20eingeladen","method":"GET"} [] [2021-05-20T11:09:19.029411+02:00] security.DEBUG: Read existing security token from the session. {"key":"_security_main","token_class":"Symfony\\Component\\Security\\Guard\\Token\\PostAuthenticationGuardToken"} [] [2021-05-20T11:09:19.043844+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 WHERE t0.id = ? [1] [] [2021-05-20T11:09:19.054642+02:00] security.DEBUG: User was reloaded from a user provider. {"provider":"Symfony\\Bridge\\Doctrine\\Security\\User\\EntityUserProvider","username":""} [] [2021-05-20T11:09:19.054931+02:00] security.DEBUG: Checking for guard authentication credentials. {"firewall_key":"main","authenticators":1} [] [2021-05-20T11:09:19.054998+02:00] security.DEBUG: Checking support on guard authenticator. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:19.055050+02:00] security.DEBUG: Guard authenticator does not support the request. {"firewall_key":"main","authenticator":"App\\Security\\GuardServiceKeycloak"} [] [2021-05-20T11:09:19.061651+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T11:09:19+02:00"] [] [2021-05-20T11:09:19.069606+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start DESC [1,"2021-05-20T11:09:19+02:00"] [] [2021-05-20T11:09:19.079084+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.enddate > ? AND r0_.start < ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) ORDER BY r0_.start ASC [1,"2021-05-20T11:09:19+02:00","2021-05-20T11:09:19+02:00"] [] [2021-05-20T11:09:19.082726+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND (r0_.schedule_meeting IS NULL OR r0_.schedule_meeting = 0) AND ((r0_.enddate BETWEEN ? AND ?) OR (r0_.start BETWEEN ? AND ?) OR (r0_.enddate >= ? AND r0_.start <= ?)) [1,"2021-05-20T11:09:19+02:00","2021-05-20T23:59:59+02:00","2021-05-20T11:09:19+02:00","2021-05-20T23:59:59+02:00","2021-05-20T23:59:59+02:00","2021-05-20T11:09:19+02:00"] [] [2021-05-20T11:09:19.085588+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 INNER JOIN server_user ON t0.id = server_user.server_id WHERE server_user.user_id = ? [1] [] [2021-05-20T11:09:19.087184+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.keycloak_group AS keycloak_group_2, t0.server_id AS server_id_3 FROM keycloak_groups_to_servers t0 WHERE t0.keycloak_group = ? ["hotmail.de"] [] [2021-05-20T11:09:19.087677+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T11:09:19.088830+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.url AS url_2, t0.app_id AS app_id_3, t0.app_secret AS app_secret_4, t0.logo_url AS logo_url_5, t0.smtp_host AS smtp_host_6, t0.smtp_port AS smtp_port_7, t0.smtp_password AS smtp_password_8, t0.smtp_username AS smtp_username_9, t0.smtp_encryption AS smtp_encryption_10, t0.smtp_email AS smtp_email_11, t0.smtp_sender_name AS smtp_sender_name_12, t0.slug AS slug_13, t0.privacy_policy AS privacy_policy_14, t0.license_key AS license_key_15, t0.api_key AS api_key_16, t0.static_background_color AS static_background_color_17, t0.show_static_background_color AS show_static_background_color_18, t0.feature_enable_by_jwt AS feature_enable_by_jwt_19, t0.server_email_header AS server_email_header_20, t0.server_email_body AS server_email_body_21, t0.administrator_id AS administrator_id_22 FROM server t0 WHERE t0.id = ? ["0"] [] [2021-05-20T11:09:19.099609+02:00] doctrine.DEBUG: SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.start AS start_2, r0_.enddate AS enddate_3, r0_.uid AS uid_4, r0_.duration AS duration_5, r0_.sequence AS sequence_6, r0_.uid_real AS uid_real_7, r0_.only_registered_users AS only_registered_users_8, r0_.agenda AS agenda_9, r0_.dissallow_screenshare_global AS dissallow_screenshare_global_10, r0_.dissallow_private_message AS dissallow_private_message_11, r0_.public AS public_12, r0_.show_room_on_joinpage AS show_room_on_joinpage_13, r0_.uid_participant AS uid_participant_14, r0_.uid_moderator AS uid_moderator_15, r0_.max_participants AS max_participants_16, r0_.schedule_meeting AS schedule_meeting_17, r0_.waitinglist AS waitinglist_18, r0_.server_id AS server_id_19, r0_.moderator_id AS moderator_id_20 FROM rooms r0_ INNER JOIN rooms_user r2_ ON r0_.id = r2_.rooms_id INNER JOIN fos_user f1_ ON f1_.id = r2_.user_id WHERE f1_.id = ? AND r0_.schedule_meeting = 1 [1] [] [2021-05-20T11:09:19.103424+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN rooms_user ON t0.id = rooms_user.user_id WHERE rooms_user.rooms_id = ? [6] [] [2021-05-20T11:09:19.106752+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.email AS email_2, t0.keycloak_id AS keycloak_id_3, t0.created_at AS created_at_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.register_id AS register_id_9, t0.keycloakGroup AS keycloakGroup_10, t0.uid AS uid_11 FROM fos_user t0 INNER JOIN user_user ON t0.id = user_user.user_target WHERE user_user.user_source = ? [1] [] [2021-05-20T11:09:19.108649+02:00] doctrine.DEBUG: SELECT t0.id AS id_1, t0.license_key AS license_key_2, t0.license AS license_3, t0.valid_until AS valid_until_4, t0.url AS url_5 FROM license t0 WHERE t0.license_key IS NULL LIMIT 1 [] [] [2021-05-20T11:09:19.113644+02:00] security.DEBUG: Stored the security token in the session. {"key":"_security_main"} [] [2021-05-20T11:09:19.540525+02:00] php.INFO: User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead. at /var/www/jitsi-admin/vendor/symfony/web-server-bundle/WebServerBundle.php:23)"} [] [2021-05-20T11:09:19.543367+02:00] request.INFO: Matched route "_wdt". {"route":"_wdt","route_parameters":{"_route":"_wdt","_controller":"web_profiler.controller.profiler::toolbarAction","token":"e690e6","_locale":"de"},"request_uri":"https://jitsiadmin.timowevelsiep.de/_wdt/e690e6","method":"GET"} []

timowevel1 commented 3 years ago

My SMTP settings: MAILER_HOST=smtp.ionos.de MAILER_PORT=587 MAILER_PASSWORD=MyPassword MAILER_USERNAME=mail@timowevelsiep.de MAILER_ENCRYPTION=tls MAILER_TRANSPORT=smtp

holema commented 3 years ago

Do you work in dev or debug mode? This is your error: Exception occurred while flushing email queue: Expected response code 250 but got code "550", with message "550-Requested action not taken: mailbox unavailable 550 invalid DNS MX or A/AAAA resource record "

I think that you run it in debug mode and forgot to set the delivery Email This has to be set in the env with DEV_EMAIL=**@.de**

This are my SMTP settings: They look quite similar. MAILER_HOST=**.kasserver.com MAILER_PORT=587 MAILER_PASSWORD=** MAILER_USERNAME=m** MAILER_ENCRYPTION=tls MAILER_TRANSPORT=smtp

timowevel1 commented 3 years ago

In .env or also .env.local? Got it in prod mode, same error. But as soon as I switch into prod mode, I cant create rooms anymore.

holema commented 3 years ago

Only touch the .env.local file. The .env local holds the fdefault values and these values will be overwritten by the local env.

When you switch to prod mode, you need to make a cach:clear and cache:warmup to prepare the cache for sysmfony.

If it doesn`t work, you can contact us via our contactform. https://h2-invent.com/kontakt

Best regards

timowevel1 commented 3 years ago

It is fixed, thanks. I followed your steps and it worked. Thank you.

bienxanh1901 commented 2 years ago

Okay, got it working by installing another php extensions. It seems to work now but I got issues with smtp setup. Which encryption types are supported?

hello @timololipop, I am facing with same problem 500 internal server error. How do you solve it? I'm current using php7.4-fpm

Thank you!

timowevel1 commented 2 years ago

Hey, I just used an older version of Jitsi Admin.


From: Pham Thanh Hai @.> Sent: Tuesday, January 18, 2022 2:51:11 PM To: H2-invent/jitsi-admin @.> Cc: timololipop @.>; Mention @.> Subject: Re: [H2-invent/jitsi-admin] SMTP issues (#187)

Okay, got it working by installing another php extensions. It seems to work now but I got issues with smtp setup. Which encryption types are supported?

hello @timololipophttps://github.com/timololipop, I am facing with same problem 500 internal server error. How do you solve it? I'm current using php7.4-fpm

Thank you!

— Reply to this email directly, view it on GitHubhttps://github.com/H2-invent/jitsi-admin/issues/187#issuecomment-1015430880, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGA5FL7BNZJBB746UP4B3R3UWVV47ANCNFSM443M3F7A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you were mentioned.Message ID: @.***>

bienxanh1901 commented 2 years ago

@timololipop thank you so much. The version 0.70.7 worked for me. For latest version 0.71.9, I got issue: ERR_TOO_MANY_REDIRECT

timowevel1 commented 2 years ago

Yes, had the same issue


From: Pham Thanh Hai @.> Sent: Tuesday, January 18, 2022 3:42:26 PM To: H2-invent/jitsi-admin @.> Cc: timololipop @.>; Mention @.> Subject: Re: [H2-invent/jitsi-admin] SMTP issues (#187)

@timololipophttps://github.com/timololipop thank you so much. The version 0.70.7 worked for me. For latest version 0.71.9, I got issue: ERR_TOO_MANY_REDIRECT

— Reply to this email directly, view it on GitHubhttps://github.com/H2-invent/jitsi-admin/issues/187#issuecomment-1015478757, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGA5FL3U7GHR5T2MOK4NN33UWV35FANCNFSM443M3F7A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you were mentioned.Message ID: @.***>

holema commented 2 years ago

Hello @timololipop and @bienxanh1901,

sorry for the late replay, I got no notifivcation that you wrote in the old issue.

The ERROR with the TOO_MANY_REDIRECTS is very strange. Did you try to fix it with clearing all your browser cache? What happens when you switch on the dev mode? Thiy you can do by setting the env variable APP_ENV=dev and APP_DEBUG=1. Then you have a debug console and probaly more informations. Or you can write me the URL to the server to entwicklung@h2-invent.com and I can have a look.

For the SMTP stuff, you can set the SMTP Settings here in the .env.local file

> symfony/swift_mailer

MAILER_HOST=serverHost MAILER_PORT=587 MAILER_PASSWORD=Password MAILER_USERNAME=Username MAILER_ENCRYPTION=tls MAILER_TRANSPORT=smtp

I hope this helps you to configure the SMTP correctly.

holema commented 2 years ago

hello @bienxanh1901,

I just talked to a collegue, and he told me that is importent that you install php7.4-ldap extension.

bienxanh1901 commented 2 years ago

Do you mean we should remove php-ldap extension?

holema commented 2 years ago

@bienxanh1901, no, it has to be installed to get composer run. BEcause the Jitsi-Admin is now directly connectable with a LDAP

bienxanh1901 commented 2 years ago

@bienxanh1901, no, it has to be installed to get composer run. BEcause the Jitsi-Admin is now directly connectable with a LDAP

Hello! I have installed php7.4-ldap extension, It still got error TOO_MANY_REDIRECTS after login. I'm currently using keycloak to authenticate to jitsi admin. Does it conflict with the LDAP feature in the new release?

holema commented 2 years ago

Hallo @bienxanh1901 The LDAP Feature is comletly independen of the Keycloak. You still need the keycloak to authenticate to the jitsi-admin. can you post the env.local Kecloak part here, with blacked client-secret? Then I can have a look if there is womething wrong.

Have you set up the groups the correct way? You have to set them up as here described https://github.com/H2-invent/jitsi-admin/wiki/Organize-Jitsi-Servers-via-keycloak-groups

bienxanh1901 commented 2 years ago

Hallo @bienxanh1901 The LDAP Feature is comletly independen of the Keycloak. You still need the keycloak to authenticate to the jitsi-admin. can you post the env.local Kecloak part here, with blacked client-secret? Then I can have a look if there is womething wrong.

Have you set up the groups the correct way? You have to set them up as here described https://github.com/H2-invent/jitsi-admin/wiki/Organize-Jitsi-Servers-via-keycloak-groups

Hi @holema this is keycloak config:

> hwi/oauth-bundle

OAUTH_KEYCLOAK_CLIENT_ID=jitsi OAUTH_KEYCLOAK_CLIENT_SECRET= OAUTH_KEYCLOAK_SERVER=http://localhost:8080/auth OAUTH_KEYCLOAK_REALM=jitsi

< hwi/oauth-bundle

Have you set up the groups the correct way? Yes. I have set up the groups correct. In Release 0.70.7 it works perfectly with same config I have tried to use latest release 0.71.13 but still get error TOO_MANY_REDIRECTS after login.

Thank you

holema commented 2 years ago

See #259 If you use apache and you still have the problem, then please write to entwicklung@h2-invent.com, then we can take a look together to the problem and write the solution here.

holema commented 2 years ago

closed in #259