перенос контестов с 2.х на 3.х

[mike_z]

А как перенести контесты?
Развернул новый ejudge на новой ос.
Скопировал папки и xml'ники, но корректно не работает. Нужно ли из БД копировать какие-нибудь таблицы?

[cher]

что значит "корректно не работает"?

[mike_z]

Если нажать кнопку master, то:

Permission denied

Permission denied. The possible reasons are as follows.

You have typed an invalid login ((null)).
You have typed an invalid password.
Your IP-address (192.168.0.11) or protocol (http) is banned for participation.
You do not have permissions to login using the specified role.
Note, that the exact reason is not reported due to security reasons.

Если ткнуть Try again

A request parameter is invalid. Please, contact the site administrator.

Вчера еще была ошибка, вместо Permission denied:

2015-06-08T15:10:03Z:info:loading contest 1 configuration file
2015-06-08T15:10:03Z:info:configuration file parsed ok
mysql: SELECT config_val FROM config WHERE config_key = 'run_version' ;
mysql: ALTER TABLE runs ADD COLUMN token_flags TINYINT NOT NULL DEFAULT 0 AFTER store_flags
2015-06-08T15:10:03Z:error:database error: Duplicate column name 'token_flags'

Была версия: <!-- Generated by ejudge-setup, version 2.3.28+ (SVN r7530) -->

стала 3.3.1



Вот лог:

2015-06-09T07:20:10Z:info:11:HTTPS:192.168.0.11:master/main-page/S93d414e47fca7edf -> OK, 1130
2015-06-09T09:44:23Z:error:13: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:23Z:info:13:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:25Z:error:15: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:25Z:info:15:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:26Z:error:17: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:26Z:info:17:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:26Z:error:19: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:26Z:info:19:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:27Z:error:21: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:27Z:info:21:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:27Z:error:23: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:27Z:info:23:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:27Z:error:25: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:27Z:info:25:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:28Z:error:27: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:28Z:info:27:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:36Z:error:29: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:36Z:info:29:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:37Z:error:31: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:37Z:info:31:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:37Z:error:33: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:37Z:info:33:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:38Z:error:35: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:38Z:info:35:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:38Z:error:37: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:38Z:info:37:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1003 -> OK, 1792
2015-06-09T09:44:40Z:error:39: invalid parameter: cannot parse locale_id
2015-06-09T09:44:40Z:info:39:HTTPS:192.168.0.11:/C1003 -> OK, 1749
2015-06-09T09:44:42Z:error:41: invalid parameter: cannot parse locale_id
2015-06-09T09:44:42Z:info:41:HTTPS:192.168.0.11:/C1003 -> OK, 1749
2015-06-09T09:44:49Z:error:43: permission denied: priv_login failed: this user is not registered for this contest
2015-06-09T09:44:49Z:info:43:HTTPS:192.168.0.11:master/cookie-login/Sb4d017b52da2b889-67d1b350ef3c3613/C1013 -> OK, 1792
2015-06-09T09:46:27Z:error:45: invalid parameter: cannot parse locale_id
2015-06-09T09:46:27Z:info:45:HTTPS:192.168.0.11:/C1003 -> OK, 1749
2015-06-09T10:11:46Z:error:47: invalid parameter: cannot parse locale_id
2015-06-09T10:11:46Z:info:47:HTTPS:192.168.0.11:/C1003 -> OK, 1749

[cher]

А базу данных (database ejudge) вы перенесли?

[dk]

О решении проблемы "Duplicate column name 'token_flags'" я вот здесь написал: ссылка

[mike_z]

удалил новую бд, восстановил старую - заработало. спасибо.