Hi Adrian,
On 13.05.2016, at 8:38 , Adrian Schröter
wrote: Good news dear OBS admins,
there is again some possible work on this nice friday for you :)
well ;) After the update of my test server (2.6.9 based on the appliance, openSUSE:13.2), I can’t even login as admin anymore. In the webui it displays the error: “No anonymous access. Please log in!” in the production.log I see: [2234:80.20] 2016-05-13T10:24:56+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] Job SendEventEmails#perform (id=114) RUNNING [2234:80.20] 2016-05-13T10:24:56+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] Job SendEventEmails#perform (id=114) FAILED (1 prior attempts) with ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column 'events.mails_sent' in 'where clause': SELECT `events`.* FROM `events` WHERE `events`.`mails_sent` = 0 ORDER BY `events`.`created_at` ASC LIMIT 1000 FOR UPDATE [2234:80.20] 2016-05-13T10:24:56+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] 1 jobs processed at 79.5740 j/s, 1 failed [b3d74d1c-30eb-42c6-98aa-a0bb0df9bfff] [2111:132.49] Started POST "/user/do_login" for 172.16.210.1 at 2016-05-13 10:24:58 +0000 [b3d74d1c-30eb-42c6-98aa-a0bb0df9bfff] [2111:132.50] Processing by Webui::UserController#do_login as HTML [b3d74d1c-30eb-42c6-98aa-a0bb0df9bfff] [2111:132.50] Parameters: {"utf8"=>"✓", "authenticity_token"=>"4e4fegIaVkmRSPcuChtixexBA+9ELf5JsgRootuOmKXT6SMkUBs6+wiuRqmN9DImFaEw10Kzn9z1svaJFo+0oA==", "username"=>"Admin", "password"=>"[FILTERED]", "commit"=>"Log In"} [b3d74d1c-30eb-42c6-98aa-a0bb0df9bfff] [2111:132.52] Redirected to https://buildwebgui.localchoeger/user/login [b3d74d1c-30eb-42c6-98aa-a0bb0df9bfff] [2111:132.52] Completed 302 Found in 21ms (ActiveRecord: 1.9ms | Backend: 0.0ms | XML: 0.0ms) [a398fdc3-1647-4255-b807-6c8bfadb2eab] [2111:132.52] Started GET "/user/login" for 172.16.210.1 at 2016-05-13 10:24:58 +0000 [a398fdc3-1647-4255-b807-6c8bfadb2eab] [2111:132.52] Processing by Webui::UserController#login as HTML [a398fdc3-1647-4255-b807-6c8bfadb2eab] [2111:132.53] Redirected to https://buildwebgui.localchoeger/ [a398fdc3-1647-4255-b807-6c8bfadb2eab] [2111:132.53] Filter chain halted as :check_anonymous rendered or redirected [a398fdc3-1647-4255-b807-6c8bfadb2eab] [2111:132.53] Completed 302 Found in 2ms (ActiveRecord: 0.4ms | Backend: 0.0ms | XML: 0.0ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.53] Started GET "/" for 172.16.210.1 at 2016-05-13 10:24:58 +0000 [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.53] Processing by Webui::MainController#index as HTML [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.55] Rendered webui/main/_systemstatus.html.erb (1.4ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.55] Rendered webui/main/_sponsors.html.erb (0.0ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.55] Rendered webui/main/_news.html.erb (0.0ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.56] Rendered webui/main/index.html.erb within layouts/webui/webui (9.2ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.56] Rendered layouts/webui/_watch_and_search.html.erb (0.2ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.56] Rendered layouts/webui/_header.html.erb (2.9ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.56] Rendered layouts/webui/_personal_navigation.html.erb (0.4ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.56] Rendered layouts/webui/_flash.html.erb (0.3ms) [3ec60d3e-4dc3-4860-98a8-d8452a446c3e] [2111:132.57] Completed 200 OK in 34ms (Views: 19.8ms | ActiveRecord: 6.4ms | Backend: 0.0ms | XML: 0.0ms) [2227:85.43] 2016-05-13T10:25:01+0000: [Worker(delayed_job.0 host:buildservice pid:2227)] Job ProjectLogRotate#perform (id=68) RUNNING [2234:85.21] 2016-05-13T10:25:01+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] Job SendEventEmails#perform (id=76) RUNNING [2234:85.22] 2016-05-13T10:25:01+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] Job SendEventEmails#perform (id=76) FAILED (4 prior attempts) with ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column 'events.mails_sent' in 'where clause': SELECT `events`.* FROM `events` WHERE `events`.`mails_sent` = 0 ORDER BY `events`.`created_at` ASC LIMIT 1000 FOR UPDATE [2234:85.23] 2016-05-13T10:25:01+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] Job SendEventEmails#perform (id=78) RUNNING [2234:85.23] 2016-05-13T10:25:01+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] Job SendEventEmails#perform (id=78) FAILED (4 prior attempts) with ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column 'events.mails_sent' in 'where clause': SELECT `events`.* FROM `events` WHERE `events`.`mails_sent` = 0 ORDER BY `events`.`created_at` ASC LIMIT 1000 FOR UPDATE [2234:85.24] 2016-05-13T10:25:01+0000: [Worker(delayed_job.1 host:buildservice pid:2234)] 2 jobs processed at 58.6388 j/s, 2 failed [2227:85.48] 2016-05-13T10:25:01+0000: [Worker(delayed_job.0 host:buildservice pid:2227)] Job ProjectLogRotate#perform (id=68) FAILED (4 prior attempts) with NoMethodError: undefined method `find_by_number' for #Class:0x00000003ade5f0 Did you mean? find_by_number! [2227:85.48] 2016-05-13T10:25:01+0000: [Worker(delayed_job.0 host:buildservice pid:2227)] 1 jobs processed at 16.7243 j/s, 1 failed I followed README.UPDATERS and of course ran RAILS_ENV="production" rake.ruby2.3 db:migrate and restarted the services. any idea what might went wrong?
We updated the OBS 2.7 packages and appliances to our current 2.7 branch and consider this almost final. The only change which we currently plan are documentation updates.
You can find them tagged as 2.6.99 as usual in the following repositories:
http://download.opensuse.org/repositories/OBS:/Server:/2.7/
SLE 11 builds are available as well, just the RC1 version is still building.
Most important changes are:
* Many improvements in the auto setup scripts
* LDAP support works again
* Lot's of smaller fixes and improvements
This is actually one of the best tested release, due to our new established automated appliance testing.
So, it should be a great friday for you :) adrian
--
Adrian Schroeter email: adrian@suse.de
SUSE Linux GmbH, GF: Felix Imendörffer, Jane Smithard, Graham Norton, HRB 21284 (AG Nürnberg)
Maxfeldstraße 5 90409 Nürnberg Germany
-- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org
-- kind regards, Carsten Hoeger Professional Services Email: carsten.hoeger@open-xchange.com ------------------------------------------------------------------------------------- Open-Xchange AG, Rollnerstr. 14, 90408 Nuremberg, District Court Nuremberg HRB 24738 Managing Board: Rafael Laguna de la Vera, Carsten Dirks, Uwe Reumuth Chairman of the Board: Richard Seibt European Office: Open-Xchange GmbH, Martinstr. 41, D-57462 Olpe, Germany, District Court Siegen, HRB 8718 Managing Directors: Frank Hoberg, Martin Kauss US Office: Open-Xchange. Inc., 530 Lytton Avenue, Palo Alto, CA 94301, USA -------------------------------------------------------------------------------------