-----Original Message----- From: Rob Zebedee [mailto:rzebedee@evertz.com] Sent: 10 September 2013 15:48 To: opensuse-buildservice@opensuse.org Subject: RE: [opensuse-buildservice] Updating from 2.3 to 2.4.

...

-----Original Message----- From: Adrian Schröter [mailto:adrian@suse.de] Sent: 10 September 2013 15:40 To: opensuse-buildservice@opensuse.org Cc: Rob Zebedee Subject: Re: [opensuse-buildservice] Updating from 2.3 to 2.4.

Am Dienstag, 10. September 2013, 14:32:39 schrieb Rob Zebedee:

...

I could do with some help resolving these issues when updating from 2.3 to 2.4 using the OBS repo

http://download.opensuse.org/repositories/OBS:/Server:/2.4/openSUSE_12

...

...

.1/x8 6_64/. Here is the production.log [INFO |# 6315] Started GET "/" for 10.97.154.39 at 2013-09-10 15:23:49 +0100 [INFO |# 6315] Processing by MainController#index as HTML +[INFO |# 6315] Anonymous request to / [INFO |# 6315] Completed 500 |Internal Server Error in 1ms

[FATAL|# 6315] NoMethodError (undefined method `+' for nil:NilClass): lib/activexml/transport.rb:350:in `http_do'

Sounds like this is not the original file. check with "rpm -V obs-api" if that file is modified. It doesn't look modified but here is the output from the above command optimus-prime:/srv/www/obs/webui/lib/activexml # rpm -V obs-api 5S.T..... c /etc/apache2/vhosts.d/obs.conf ...T..... c /srv/www/obs/api/config/database.yml 5S.T..... c /srv/www/obs/api/config/options.yml ...T..... /srv/www/obs/api/log/production.log ...T..... c /srv/www/obs/webui/config/database.yml 5S.T..... c /srv/www/obs/webui/config/options.yml ...T..... c /srv/www/obs/webui/log/production.log

...

otherwise please send the line, after check possible local patches :)

Sorry not quite sure what you mean by local patches?

...

...

lib/activexml/transport.rb:227:in `direct_http' app/controllers/application_controller.rb:352:in `block in require_configuration' app/controllers/application_controller.rb:350:in `require_configuration'

not sure what else would be helpful to resolve this please let me know.

Rob Zebedee Senior Integration Engineer | Evertz Europe

t: +44 (0)118 9216800 rzebedee@evertz.com

Mediator - Driving productivity for broadcast and new media

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender (as shown above). Kindly do not reproduce, print or forward any material received in error, please delete it immediately. Quartz Electronics Limited (Company No. 3013309) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Limited (Company No. 3458137) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Pte

Limited (Company No.

...

...

200817005N) is incorporated in Singapore and has its registered office at One Marina Boulevard, #28-00. Singapore 018989. Pharos Communications Limited is a wholly owned subsidiary of Evertz Microsystems Limited, registered in Ontario, Canada.

--

Adrian Schroeter email: adrian@suse.de

SUSE LINUX GmbH, GF: Jeff Hawn, Jennifer Guild, Felix Imendörffer, HRB 21284 (AG Nürnberg) Maxfeldstraße 5 90409 Nürnberg Germany

Robert Zebedee Senior Integration Engineer | Evertz Europe

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender (as shown above). Kindly do not reproduce, print or forward any material received in error, please delete it immediately. Quartz Electronics Limited (Company No. 3013309) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Limited (Company No. 3458137) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Pte Limited (Company No. 200817005N) is incorporated in Singapore and has its registered office at One Marina Boulevard, #28-00. Singapore 018989. Pharos Communications Limited is a wholly owned subsidiary of Evertz Microsystems Limited, registered in Ontario, Canada. -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org

I am also seeing an error at startup with the MySQL database Mysqladmin: connect to server at ' localhost' failed Error: 'Access denied for user 'root'@'localhost' (using password: NO)' Then further down Mysql2::Error: Table 'architectures' already exists: CREATE TABLE 'architectures' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'name' varchar(255) CHARACTER SET utf8 NOT NULL, 'recommeded' tinyint(1) DEFAULT '0', 'available' tinyint(1) DEFAULT '0', PRIMARY KEY (id), UNIQUE KEY 'arch_name_index' ('name') ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Just wondering what has gone wrong. This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender (as shown above). Kindly do not reproduce, print or forward any material received in error, please delete it immediately. Quartz Electronics Limited (Company No. 3013309) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Limited (Company No. 3458137) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Pte Limited (Company No. 200817005N) is incorporated in Singapore and has its registered office at One Marina Boulevard, #28-00. Singapore 018989. Pharos Communications Limited is a wholly owned subsidiary of Evertz Microsystems Limited, registered in Ontario, Canada. -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org

-----Original Message----- From: Stefan Botter [mailto:s.botter@jacobs-university.de] Sent: 11 September 2013 11:57 To: opensuse-buildservice@opensuse.org Subject: Re: [opensuse-buildservice] Updating from 2.3 to 2.4.

Hi Rob,

On Tue, 10 Sep 2013 14:32:39 +0000 Rob Zebedee wrote:

...

I could do with some help resolving these issues when updating from 2.3 to 2.4 using the OBS repo

http://download.opensuse.org/repositories/OBS:/Server:/2.4/openSUSE_12 .1/x86_64/.

...

Here is the production.log [INFO |# 6315] Started GET "/" for 10.97.154.39 at 2013-09-10 15:23:49 +0100 [INFO |# 6315] Processing by MainController#index as HTML [INFO |# 6315] Anonymous request to / [INFO |# 6315] Completed 500 Internal Server Error in 1ms

[FATAL|# 6315] NoMethodError (undefined method `+' for nil:NilClass): lib/activexml/transport.rb:350:in `http_do' lib/activexml/transport.rb:227:in `direct_http' app/controllers/application_controller.rb:352:in `block in require_configuration' app/controllers/application_controller.rb:350:in `require_configuration'

not sure what else would be helpful to resolve this please let me know.

... and I thought, that I was the sole user running into that problem!

There are (at least) two database entries missing after an update to 2.4 from a previous OBS installation.

Add the two entries in the projects and repositories table: root# mysql -u root -p[database password] api_production mysql> insert into projects (id,name,title,description,created_at,updated_at) values ('2','deleted',NULL,NULL,now(),now()); mysql> insert into repositories

(id,db_project_id,name,remote_project_name,rebuild,block,linkedbuild,ho stsystem_id) values ('1','1','deleted',NULL,NULL,NULL,NULL,NULL); mysql> quit

You of course may want to check, that there are no entries with the same id's are in the tables already.

The update process does not cover these entries, as they are most probably so basic, that they are expected to be there.

Greetings,

Stefan -- Stefan Botter Network Manager

Jacobs University Bremen gGmbH Campus Ring 1 | 28759 Bremen | Germany

Commercial registry: Amtsgericht Bremen, HRB 18117 President & Geschäftsführer: Prof. Dr. Heinz-Otto Peitgen Provost & Geschäftsführerin: Prof. Dr.-Ing. Katja Windt Chair Board of Governors: Prof. Dr. Karin Lochte

Thanks for the pointers on that. I have managed to roll back to 2.3 for the moment and I am now trying to get 2.4 working on a vm. The issue I am now seeing is in the apache2/error_log is: [Wed Sep 11 16:42:28 2013] [notice] Apache/2.2.21 (Linux/SUSE) mod_ssl/2.2.21 OpenSSL/1.0.0k PHP/5.3.8 Phusion_Passenger/3.0.18 mod_wsgi/3.3 Python/2.7.2 configured -- resuming normal operations /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespawn:105:in `initialize': Connection refused - connect(2) (Errno::ECONNREFUSED) from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespawn:105:in `new' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespawn:105:in `connect' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespawn:112:in `connect' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespawn:86:in `socket' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespawn:90:in `head_request' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespawn:145:in `<main>' Does anyone have any ideas as to where to begin with fixing this. Access to the webui does not work at all and the api page just gives the about xml. Please help it is driving me mad trying to get this to work. Thanks Rob This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender (as shown above). Kindly do not reproduce, print or forward any material received in error, please delete it immediately. Quartz Electronics Limited (Company No. 3013309) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Limited (Company No. 3458137) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Pte Limited (Company No. 200817005N) is incorporated in Singapore and has its registered office at One Marina Boulevard, #28-00. Singapore 018989. Pharos Communications Limited is a wholly owned subsidiary of Evertz Microsystems Limited, registered in Ontario, Canada.

-----Original Message----- From: Stefan Botter [mailto:s.botter@jacobs-university.de] Sent: 11 September 2013 20:20 To: opensuse-buildservice@opensuse.org Subject: Re: [opensuse-buildservice] Updating from 2.3 to 2.4.

Hi Rob,

On Wed, 11 Sep 2013 16:19:02 +0000 Rob Zebedee wrote:

...

Thanks for the pointers on that. I have managed to roll back to 2.3 for the moment and I am now trying to get 2.4 working on a vm. The issue I am now seeing is in the apache2/error_log is: [Wed Sep 11 16:42:28 2013] [notice] Apache/2.2.21 (Linux/SUSE) mod_ssl/2.2.21 OpenSSL/1.0.0k PHP/5.3.8 Phusion_Passenger/3.0.18 mod_wsgi/3.3 Python/2.7.2 configured -- resuming normal operations /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespa wn:105:in `initialize': Connection refused - connect(2) (Errno::ECONNREFUSED) from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespa wn:105:in `new' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespa wn:105:in `connect' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespa wn:112:in `connect' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespa wn:86:in `socket' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespa wn:90:in `head_request' from /usr/lib64/ruby/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/prespa wn:145:in `<main>'

Does anyone have any ideas as to where to begin with fixing this. Access to the webui does not work at all and the api page just gives the about xml. Please help it is driving me mad trying to get this to work.

Did you follow the steps from https://github.com/openSUSE/open-build- service/blob/2.4/dist/README.UPDATERS (the first section 2.3 to 2.4)?

No I had not come across that info I am reading all this before I start again thanks for pointing me in the right direction hopefully I can get this clear in my head.

I did the update from 2.3 to 2.4 several times on different OBS installations, and apart from the missing DB entries, this worked. If you have the working 2.3 setup, try to get back to it, stop all obs processed, update the obs rpms, follow the steps in the README.UPDATERS, and restart the services. You need to have the mysql/mariadb process running, as the db's need updating.

You may want to have a look at the log files of the api and webui apache instances at /srv/www/obs/(api|webui)/logs.

Greetiings,

Stefan -- Stefan Botter Network Manager

Jacobs University Bremen gGmbH Campus Ring 1 | 28759 Bremen | Germany

Commercial registry: Amtsgericht Bremen, HRB 18117 President & Geschäftsführer: Prof. Dr. Heinz-Otto Peitgen Provost & Geschäftsführerin: Prof. Dr.-Ing. Katja Windt Chair Board of Governors: Prof. Dr. Karin Lochte

Robert Zebedee Senior Integration Engineer | Evertz Europe This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender (as shown above). Kindly do not reproduce, print or forward any material received in error, please delete it immediately. Quartz Electronics Limited (Company No. 3013309) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Limited (Company No. 3458137) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Pharos Communications Pte Limited (Company No. 200817005N) is incorporated in Singapore and has its registered office at One Marina Boulevard, #28-00. Singapore 018989. Pharos Communications Limited is a wholly owned subsidiary of Evertz Microsystems Limited, registered in Ontario, Canada.