openSUSE admin

let's see if I actually can help.

Where do you get the Error 403 from?

• ANSWERED: Is it really progress.opensuse.org or the authentication service which is provided by microfocus? -> "the error page that I get has the title "Redmine 500 error"
• ANSWERED: So if login to bugzilla.suse.com/bugzilla.opensuse.org works, how about e.g. http://wiki.opensuse.org/, https://forums.opensuse.org ? -> can login to OBS, IBS, Bugzilla, the wiki and the forums
• Does it work with another browser?
• Can you try to delete cookies?
• Can you try in the private mode of a browser?

As your user in the redmine database was not usable by you so far I deleted the user. Please try again.

If it still does not work or you end up in the same error please open a MF-IT ticket over http://rio.microfocuscloud.com/ as the authentication service provided by MF-IT to my understanding should forward your correct username "dancermak". Still, after trying to re-login I can try to adjust the account again differently if needed.

can't provide more hints, this is user account specific.

I have received a reply from RIO asking for logs that they could use to
narrow down the problem further.

Would it be possible that you send an excerpt from the Redmine logs from
today ~10:50-10:55 when I tried to unsuccessfully to login?

Thanks,

Dan

that's what I found:

Started GET "/login" for 89.12.147.145 at Mon Sep 30 08:52:01 +0000 2019
Processing by AccountController#login as HTML
  Current user: anonymous
Completed 500 Internal Server Error in 336.5ms

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xC4\x8Cerm\xC3...' for column 'lastname' at row 1: UPDATE `users` SET `login` = 'dancermak', `updated_on` = '2019-09-30 08:52:01', `lastname` = 'Čermák'
 WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 33662):
  activerecord (3.2.17) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
  activerecord (3.2.17) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
  activerecord (3.2.17) lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log'
  activesupport (3.2.17) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  activerecord (3.2.17) lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
  activerecord (3.2.17) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
  activerecord (3.2.17) lib/active_record/connection_adapters/mysql2_adapter.rb:213:in `execute'
  activerecord (3.2.17) lib/active_record/connection_adapters/mysql2_adapter.rb:240:in `exec_update'
  activerecord (3.2.17) lib/active_record/connection_adapters/abstract/database_statements.rb:96:in `update'
  activerecord (3.2.17) lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
  activerecord (3.2.17) lib/active_record/persistence.rb:359:in `update'
  activerecord (3.2.17) lib/active_record/locking/optimistic.rb:68:in `update'
  activerecord (3.2.17) lib/active_record/attribute_methods/dirty.rb:74:in `update'
  activerecord (3.2.17) lib/active_record/timestamp.rb:71:in `update'
  activerecord (3.2.17) lib/active_record/callbacks.rb:272:in `update'
  activesupport (3.2.17) lib/active_support/callbacks.rb:403:in `_run__564565134__update__4__callbacks'
  activesupport (3.2.17) lib/active_support/callbacks.rb:405:in `send'
  activesupport (3.2.17) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.17) lib/active_support/callbacks.rb:385:in `_run_update_callbacks'

looks like a codeset or encoding problem. Can you describe what action you triggered? Was this just simply a login attempt?

The general mysql encoding settings should be fine:

mysql> show variables like 'char%';
+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| character_set_client     | utf8                         |
| character_set_connection | utf8                         |
| character_set_database   | utf8mb4                      |
| character_set_filesystem | binary                       |
| character_set_results    | utf8                         |
| character_set_server     | utf8mb4                      |
| character_set_system     | utf8                         |
| character_sets_dir       | /usr/share/mariadb/charsets/ |
+--------------------------+------------------------------+
8 rows in set (0.01 sec)

however the one from the progress database might be the problem:

mysql> show variables like 'char%';
+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| character_set_client     | utf8                         |
| character_set_connection | utf8                         |
| character_set_database   | utf8                         |
| character_set_filesystem | binary                       |
| character_set_results    | utf8                         |
| character_set_server     | utf8mb4                      |
| character_set_system     | utf8                         |
| character_sets_dir       | /usr/share/mariadb/charsets/ |
+--------------------------+------------------------------+
8 rows in set (0.01 sec)

so character_set_database is not set to utf8mb4. https://stackoverflow.com/a/34854453 might be the answer or https://www.redmine.org/issues/10772#note-7 . Potentially also the database is too old itself? See https://www.redmine.org/issues/21398#note-12

problem solved by changing last name to ASCII-only characters. Follow-up in #57530