Trouble with first web autorization

Yeti installation and upgrade
1

Hi every body, I installed yeti-switch on debian 10. And wen i try to login with web interface login admin and password 111111 are wrong. How can I fix it ?

2

Looks like you didn’t complete all installation steps.

Have you run https://yeti-switch.org/docs/en/installation-1.10/web.html#databases-data-initialization ?

3

I completed data inicialization and update several times. These steps changed nothing

4

could you show logs related to your login attempt from /var/log/yeti/yeti-web.log and output
of SQL:

root@host:~# su - postgres
postgres@host:~$ psql yeti_db_name
psql (11.7 (Debian 11.7-2.pgdg90+1))
Type "help" for help.

yeti_db_name=# \x
Expanded display is on.
yeti_db_name=# \pset pager off
Pager usage is off.
yeti_db_name=# select * from gui.admin_users;
5

Of course, yeti-web.log:

pr 27 09:52:01 yeti YETI-admin[57466]: [09:52:01.565090 ] [FATAL]:
Apr 27 09:52:01 yeti YETI-admin[57466]: [09:52:01.565106 ] [FATAL]: app/controllers/api_controller.rb:28:in debug_mode'#012app/controllers/concerns/with_payloads.rb:5:in append_info_to_raw_payload’#012config/initializers/instrumentation_notification.rb:27:in process_action' Apr 27 09:52:01 yeti YETI-admin[57466]: [09:52:01.571314 ] [ INFO]: Started PUT "/api/rest/system/jobs/AccountBalanceNotify/run" for 127.0.0.1 at 2020-04-27 09:52:01 -0400 Apr 27 09:52:01 yeti YETI-admin[57466]: [09:52:01.572842 ] [FATAL]: Apr 27 09:52:01 yeti YETI-admin[57466]: [09:52:01.573006 ] [FATAL]: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "sys.api_log_config" does not exist#012LINE 8: WHERE a.attrelid = '"sys"."api_log_config"'::...#012 ^#012: SELECT a.attname, format_type(a.atttypid, a.atttypmod),#012 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,#012 c.collname, col_description(a.attrelid, a.attnum) AS comment#012 FROM pg_attribute a#012 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum#012 LEFT JOIN pg_type t ON a.atttypid = t.oid#012 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation#012 WHERE a.attrelid = '"sys"."api_log_config"'::regclass#012 AND a.attnum > 0 AND NOT a.attisdropped#012 ORDER BY a.attnum#012): Apr 27 09:52:01 yeti YETI-admin[57466]: [09:52:01.573169 ] [FATAL]: Apr 27 09:52:01 yeti YETI-admin[57466]: [09:52:01.573310 ] [FATAL]: app/controllers/api_controller.rb:28:in debug_mode’#012app/controllers/concerns/with_payloads.rb:5:in append_info_to_raw_payload'#012config/initializers/instrumentation_notification.rb:27:in process_action’
Apr 27 09:52:01 yeti YETI-admin[57513]: [09:52:01.574150 ] [FATAL]: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation “sys.api_log_config” does not exist#012LINE 8: WHERE a.attrelid = ‘“sys”.“api_log_config”’::…#012 ^#012: SELECT a.attname, format_type(a.atttypid, a.atttypmod),#012 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,#012 c.collname, col_description(a.attrelid, a.attnum) AS comment#012 FROM pg_attribute a#012 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum#012 LEFT JOIN pg_type t ON a.atttypid = t.oid#012 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation#012 WHERE a.attrelid = ‘“sys”.“api_log_config”’::regclass#012 AND a.attnum > 0 AND NOT a.attisdropped#012 ORDER BY a.attnum#012):
Apr 27 09:52:01 yeti YETI-admin[57513]: [09:52:01.574524 ] [FATAL]:
Apr 27 09:52:01 yeti YETI-admin[57513]: [09:52:01.574675 ] [FATAL]: app/controllers/api_controller.rb:28:in debug_mode'#012app/controllers/concerns/with_payloads.rb:5:in append_info_to_raw_payload’#012config/initializers/instrumentation_notification.rb:27:in process_action' Apr 27 09:53:01 yeti YETI-admin[57513]: [09:53:01.616238 ] [ INFO]: Started PUT "/api/rest/system/jobs/DialpeerRatesApply/run" for 127.0.0.1 at 2020-04-27 09:53:01 -0400 Apr 27 09:53:01 yeti YETI-admin[57513]: [09:53:01.619791 ] [FATAL]: Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.621663 ] [ INFO]: Started PUT "/api/rest/system/jobs/CallsMonitoring/run" for 127.0.0.1 at 2020-04-27 09:53:01 -0400 Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.623420 ] [FATAL]: Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.623455 ] [FATAL]: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "sys.api_log_config" does not exist#012LINE 8: WHERE a.attrelid = '"sys"."api_log_config"'::...#012 ^#012: SELECT a.attname, format_type(a.atttypid, a.atttypmod),#012 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,#012 c.collname, col_description(a.attrelid, a.attnum) AS comment#012 FROM pg_attribute a#012 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum#012 LEFT JOIN pg_type t ON a.atttypid = t.oid#012 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation#012 WHERE a.attrelid = '"sys"."api_log_config"'::regclass#012 AND a.attnum > 0 AND NOT a.attisdropped#012 ORDER BY a.attnum#012): Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.623482 ] [FATAL]: Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.623498 ] [FATAL]: app/controllers/api_controller.rb:28:in debug_mode’#012app/controllers/concerns/with_payloads.rb:5:in append_info_to_raw_payload'#012config/initializers/instrumentation_notification.rb:27:in process_action’
Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.625536 ] [ INFO]: Started PUT “/api/rest/system/jobs/EventProcessor/run” for 127.0.0.1 at 2020-04-27 09:53:01 -0400
Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.626811 ] [FATAL]:
Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.626847 ] [FATAL]: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation “sys.api_log_config” does not exist#012LINE 8: WHERE a.attrelid = ‘“sys”.“api_log_config”’::…#012 ^#012: SELECT a.attname, format_type(a.atttypid, a.atttypmod),#012 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,#012 c.collname, col_description(a.attrelid, a.attnum) AS comment#012 FROM pg_attribute a#012 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum#012 LEFT JOIN pg_type t ON a.atttypid = t.oid#012 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation#012 WHERE a.attrelid = ‘“sys”.“api_log_config”’::regclass#012 AND a.attnum > 0 AND NOT a.attisdropped#012 ORDER BY a.attnum#012):
Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.626874 ] [FATAL]:
Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.626891 ] [FATAL]: app/controllers/api_controller.rb:28:in debug_mode'#012app/controllers/concerns/with_payloads.rb:5:in append_info_to_raw_payload’#012config/initializers/instrumentation_notification.rb:27:in process_action' Apr 27 09:53:01 yeti YETI-admin[57513]: [09:53:01.630298 ] [FATAL]: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "sys.api_log_config" does not exist#012LINE 8: WHERE a.attrelid = '"sys"."api_log_config"'::...#012 ^#012: SELECT a.attname, format_type(a.atttypid, a.atttypmod),#012 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,#012 c.collname, col_description(a.attrelid, a.attnum) AS comment#012 FROM pg_attribute a#012 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum#012 LEFT JOIN pg_type t ON a.atttypid = t.oid#012 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation#012 WHERE a.attrelid = '"sys"."api_log_config"'::regclass#012 AND a.attnum > 0 AND NOT a.attisdropped#012 ORDER BY a.attnum#012): Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.632638 ] [ INFO]: Started PUT "/api/rest/system/jobs/AccountBalanceNotify/run" for 127.0.0.1 at 2020-04-27 09:53:01 -0400 Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.633961 ] [FATAL]: Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.634132 ] [FATAL]: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "sys.api_log_config" does not exist#012LINE 8: WHERE a.attrelid = '"sys"."api_log_config"'::...#012 ^#012: SELECT a.attname, format_type(a.atttypid, a.atttypmod),#012 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,#012 c.collname, col_description(a.attrelid, a.attnum) AS comment#012 FROM pg_attribute a#012 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum#012 LEFT JOIN pg_type t ON a.atttypid = t.oid#012 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation#012 WHERE a.attrelid = '"sys"."api_log_config"'::regclass#012 AND a.attnum > 0 AND NOT a.attisdropped#012 ORDER BY a.attnum#012): Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.634297 ] [FATAL]: Apr 27 09:53:01 yeti YETI-admin[57466]: [09:53:01.634440 ] [FATAL]: app/controllers/api_controller.rb:28:in debug_mode’#012app/controllers/concerns/with_payloads.rb:5:in append_info_to_raw_payload'#012config/initializers/instrumentation_notification.rb:27:in process_action’
Apr 27 09:53:01 yeti YETI-admin[57513]: [09:53:01.634841 ] [FATAL]:
Apr 27 09:53:01 yeti YETI-admin[57513]: [09:53:01.634998 ] [FATAL]: app/controllers/api_controller.rb:28:in debug_mode'#012app/controllers/concerns/with_payloads.rb:5:in append_info_to_raw_payload’#012config/initializers/instrumentation_notification.rb:27:in `process_action’

6

postgres@yeti:~$ psql yeti
psql (11.7 (Debian 11.7-2.pgdg100+1))
Type “help” for help.

yeti=# \x
Expanded display is on.
yeti=# \pset pager off
Pager usage is off.
yeti=# select * from gui.admin_users;
(0 rows)

7
  • There are no login attempts in your log.
  • Looks like your databases were not initialized properly

Drop databases and complete initialization steps again. https://yeti-switch.org/docs/en/installation-1.10/web.html#databases-data-initialization

You should not ignore any errors during database initialization.

8

Sorry I don’t know about command for drop database

9

Thanks Dmitry, I made it. Database dropping improved situation