Upgrade error between version 1.2 to 2.3 on Ubuntu Xenial.

[Mauricio Adriano]

Hello.

We were making a new installation of ica-atom following exactly as the link:

https://www.accesstomemory.org/pt-br/docs/2.3/admin-manual/installation/linux/ubuntu-xenial/

We created an exclusive virtual machine to make it, and the blank installation of version 2.3 works. But, when we were doing the upgrade from the version 1.2 (https://www.accesstomemory.org/pt-br/docs/2.3/admin-manual/installation/upgrading/#installation-upgrading) we had a error message from the system on step "Run the upgrade task":

 Configuration file "/usr/share/nginx/atom/vendor/symfony/lib/config/config/settings.yml, /usr/share/nginx/atom/apps/qubit/config/settings.yml" does not have a registered handler.

In a previous test, some months ago, we used Linux 14.04 and it was the only difference. In this case, we reach the end of the process, and the upgrade happened successfully.

What we can do?

Regards.

[Dan Gillean]

Hi Mauricio,

I have not seen this error before. A couple things to double-check first:

Did you go through the whole installation process, including running the web installer, before you tried to load your old ICA-AtoM database?

Did you remember, before loading it, to drop and recreate the database, as per step 3 in this section?

•  mysql -u username -p -e 'drop database new_database; create database new_database character set utf8 collate utf8_unicode_ci;'

(Remember to add the correct credentials for your username, password if you've used one, and database name in this step)

You said you have a clean installation working previously with Ubuntu 14.04 - what are you using now? 16.04? If so, did you follow the new installation instructions for 16.04?

• https://www.accesstomemory.org/docs/2.3/admin-manual/installation/linux/ubuntu-xenial/

Have you installed any of the dependencies differently?

Thanks! Hopefully we can help you figure this out.

Cheers,

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/cab3a2f5-cb94-4b14-b14a-56dc39c25a0f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mauricio Adriano]

Hi Dan, thanks for your feedback.

About your questions:

- I followed in details the instructions in https://www.accesstomemory.org/docs/2.3/admin-manual/installation/linux/ubuntu-xenial/ , and I chose the option 1 to installation of Atom (tarball).

- I didn't have any error message on installation of dependencies... including the not mandatory components.

- The clean installation runned, I got to access the Atom webinstaller and web interface.

- I also got execute the sql command to drop/create database. The mysql database import was executed without problems too.

- We have the version 1.2 of Ica-Atom running in a Debian server together other services. Our purpose is install/upgrade Atom in an exclusive server, with the structures indicated for it.

PS: the mysql database server is in another server.

Regards.

[Mauricio Adriano]

Dan, I returned the process (how it was a virtual machine) until before the installation of Atom. I executed the same steps and now it seems ok... I'll do some tests more... thanks

Em segunda-feira, 5 de setembro de 2016 15:21:05 UTC-3, Mauricio Adriano escreveu:

[Mauricio Adriano]

An error has occurred on login after the upgrade (attached).

Em segunda-feira, 5 de setembro de 2016 15:21:05 UTC-3, Mauricio Adriano escreveu:

[Dan Gillean]

Hi Mauricio,

Very strange! What did the webserver error logs say for the 500 error? Please share any message you find there related to this error.

Have you tried clearing the cache and restarting services?

Can you confirm the filesystem permissions are correct?

I'm hopeful that this is a different issue than you were facing before... which means we are making progress, even if it doesn't feel that way right now!

Let us know what you find in the error logs.

Cheers,

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

--

You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/5a798e8e-6f4f-406d-b062-2d671b38a453%40googlegroups.com.

[Mauricio Adriano]

Hi Dan.

So, I reviewed the files permissions, and I repeated the upgrade process choosing other theme... same result.

The webserver log before to rebuild search index and clean the cache:

2016/09/09 17:39:25 [error] 3264#3264: *17 FastCGI sent in stderr: "PHP message: Invalid configuration settings: [sf_module_disabled_module]

e header from upstream, client: 10.10.0.124, server: _, request: "GET /index.php/informationobject/browse HTTP/1.1", upstream: "fastcgi://un

http://cedoc.unicentro.br/index.php/?sf_culture=pt_BR"

2016/09/09 17:44:51 [error] 3264#3264: *30 FastCGI sent in stderr: "PHP message: Invalid configuration settings: [sf_module_disabled_module] "admin", [sf_module_disabled_action] "disabled"" while reading response header from upstream, client: 10.10.0.124, server: _, request: "POST /index.php/user/login HTTP/1.1", upstream: "fastcgi://unix:/run/php7.0-fpm.atom.sock:", host: "cedoc.unicentro.br", referrer: "http://cedoc.unicentro.br/index.php/?sf_culture=pt_BR"

The webserver log after rebuild and clean cache:

Stack trace:

#0 /usr/share/nginx/atom/vendor/symfony/lib/config/sfConfigCache.class.php(197): sfConfigCache->callHandler('config/core_com...', Array, '/usr/share/ngin...')

#1 /usr/share/nginx/atom/vendor/symfony/lib/config/sfConfigCache.class.php(249): sfConfigCache->checkConfig('config/core_com...', false)

#2 /usr/share/nginx/atom/vendor/symfony/lib/config/sfApplicationConfiguration.class.php(109): sfConfigCache->import('config/core_com...', false)

#3 /usr/share/nginx/atom/vendor/symfony/lib/config/sfApplicationConfiguration.class.php(51): sfApplicationConfiguration->initConfiguration()

#4 /usr/share/nginx/atom/vendor/symfony/lib/config/sfProjectConfiguration.class.php(611): sfApplicationConfiguration->__construct('prod', false, '/usr/" while reading response header from upstream, client: 10.10.0.124, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php7.0-fpm.atom.sock:", host: "cedoc.unicentro.br"

Em segunda-feira, 5 de setembro de 2016 15:21:05 UTC-3, Mauricio Adriano escreveu:

[Dan Gillean]

Hi Mauricio,

Well, the errors are telling us there is a problem with the values included in your settings.yml file. I'm pasting a copy of mine from 2.3, which I haven't changed from the defaults at installation time - perhaps take a look and see if there are other changes in yours?


​
For example, have you changed the default installation culture to a different culture like pt or pt_BR?

If so, did you make sure that this language is also added to the user interface, and the site re-indexed after? See:

• https://www.accesstomemory.org/docs/2.3/user-manual/administer/settings/#add-remove-languages

Have you changed anything else in this configuration file, or in others?

I'm assuming that restrarting services has not helped? e.g. for 16.04:

• sudo systemctl reload nginx
• sudo systemctl restart php7.0-fpm

I'm sorry, I'm running out of ideas! Let me know about the above, and I'll see if our team has other suggestions.

Regards,

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

--

You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/c8d1e0dd-f24c-4ed8-8139-9cc89df5f6c2%40googlegroups.com.

[Mauricio Adriano]

Hi Dan.

I think the problem is Mysql Server in other server (and version - 5.5). I repeated the installation and I changed the parameters of the webinstaller to the mysql server in local machine (version 5.6) and the system worked.

But, when I performed the symfony to upgrade it happened an error with an "id"; I think only some records have been imported. How I can to determine which record and why the problem is happen?

Em segunda-feira, 5 de setembro de 2016 15:21:05 UTC-3, Mauricio Adriano escreveu:

[Dan Gillean]

Hi Mauricio,

I'm glad to hear that you got the installation working! Thank you for sharing what worked in your case.

Regarding the error - it's possible it's caused by some data corruption created in the previous system. Please see this thread for a place to start - I'm hoping that one of the solutions I've collected there will help you track down the issue. The last link offers a SQL query that should help you identify problem information objects based on ID.

• https://groups.google.com/d/msg/ica-atom-users/hMoevo_26ps/mxTm_RXQFAAJ

Let us know how it goes!

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

--

You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-users+unsubscribe@googlegroups.com.
To post to this group, send email to ica-atom-users@googlegroups.com.
Visit this group at https://groups.google.com/group/ica-atom-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/6c521801-1052-4387-bc66-0cba74a37117%40googlegroups.com.

[Mauricio Adriano]

Hi Dan, by your statements finally I got to up the new database. About the last reported problem, I ran the sql script below in the source database:

select

concat('INSERT INTO status (object_id, type_id, status_id, id, serial_number) VALUES (''',id,''', ''158'', ''159'', NULL, ''0'');')

 from `cedoc`.`object` where

id not in (

SELECT object_id FROM `cedoc`.`status`

where object_id is not null

);

With the result of the sql, I ran again in the same database and after this I performed the steps of upgrade on the new server again ("drop" and "recreate" database, import data, execute upgrade-tool, etc)

I think that it is all ok, we will make tests to confirm.

Thanks a lot!

Em segunda-feira, 5 de setembro de 2016 15:21:05 UTC-3, Mauricio Adriano escreveu: