Migração SAPL2.2 para 2.3 em um novo ambiente
-
jrbringer
Jan. 11, 2011, 11:45 a.m.Olá Pessoal,
Estou querendo migrar do SAPL 2.2 para o 2.3.
Segui os procedimentos contidos para uma instalação em um novo
ambiente
http://colab.interlegis.gov.br/wiki/HOWTO-InstalarSAPL23Ubuntu [1]
Os erros a seguir estão acontecendo na MIGRAÇÃO DA BASE DE DADOS
MYSQL parte 2.
Quando executo o seguinte comando:
/var/interlegis/SAPL-2.3-beta/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.sh
Abaixo segue os erros, se alguém puder auxiliar agradeço.
administrador@dmasv03:/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao$
sudo ./sapl_migracao.sh
ok... Encontrado o arquivo Data.fs da versao anterior
ok... Encontrado o arquivo DocumentosSapl.fs da versao anterior
ok... Encontrado o arquivo sapl_old.sql
kill: 70: Usage: kill [-s sigspec | -signum | -sigspec] [pid |
job]... or
kill -l [exitstatus]
ok... SAPL antigo parado.
daemon manager not running
ok... SAPL 2.3 parado
ok... Ajustado o proprietário do arquivo old/Data.fs
./sapl_migracao.sh: 85: /var/interlegis/SAPL-2.3/mysql/bin/mysql:
not found
ok... Importado o arquivo do backup do MySQL
./sapl_migracao.sh: 88: /var/interlegis/SAPL-2.3/mysql/bin/mysql:
not found
ok... Atualizado o banco para a nova estrutura do SAPL 2.3
cp: impossível obter estado de `/var/DocumentosSapl.fs': Arquivo ou
diretório não encontrado
chown: impossível acessar
`/var/interlegis/SAPL-2.3/instances/sapl23/var/DocumentosSapl.fs':
Arquivo ou diretório não encontrado
ok... Arquivo DocumentosSapl.fs copiado
/var/interlegis/SAPL-2.3/instances/sapl23/Products/ZMySQLDA/DABase.py:92:
DeprecationWarning: The ImageFile module will be removed in Zope 2.11.
Use App.ImageFile instead.
from ImageFile import ImageFile
/var/interlegis/SAPL-2.3/instances/sapl23/Products/TextIndexNG2/TextIndexNG.py:28:
DeprecationWarning: Using OFS.content_types is deprecated (will be
removed in Zope 2.11). Instead use zope.app.contenttypes.
from OFS.content_types import guess_content_type
2011-01-10 11:19:13 WARNING textindexng Converter "xls" not
registered because executable "xls2csv" could not be found
2011-01-10 11:19:13 WARNING textindexng Converter "ppt" not
registered because executable "pptHtml" could not be found
2011-01-10 11:19:13 WARNING textindexng Converter "doc" not
registered because executable "wvWare" could not be found
/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/OFS/Application.py:830:
DeprecationWarning: __init__.py of Products.ZMySQLDA has a long
deprecated 'methods' attribute. 'methods' support might be removed in
Zope 2.11 or a later feature release. Please use the 'legacy' argument
of registerClass instead if the methods are constructors. Or refactor
the product using adapters.
DeprecationWarning)
/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.py:1:
DeprecationWarning: Non-ASCII character 'xe7' in file
/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.py
on line 1, but no encoding declared; see
http://www.python.org/peps/pep-0263.html [2] for details
### Script a ser rodado durante o processo de migra��o de
dados de vers�es anteriores do SAPL.
ok... Mount-point dos documentos removido com sucesso
2011-01-10 11:19:13 ERROR Zope.ZODBMountPoint Failed to mount
database. ZConfig.ConfigurationError (No database configured for mount
point at /sapl_old)
Traceback (most recent call last):
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 257, in _getOrOpenObject
conn = self._getMountedConnection(anyjar)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 147, in _getMountedConnection
self._getDB()
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 157, in _getDB
return getConfiguration().getDatabase(self._path)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
line 276, in getDatabase
name = self.getName(mount_path)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
line 293, in getName
self._mountPathError(mount_path)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
line 268, in _mountPathError
raise ConfigurationError(
ConfigurationError: No database configured for mount point at
/sapl_old
Traceback (most recent call last):
File "", line 1, in ?
File
"/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.py",
line 27, in ?
app.manage_addProduct['ZODBMountPoint'].manage_addMounts(paths=['/sapl_old'],create_mount_points=1)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 377, in manage_addMounts
mo._test(app)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 243, in _test
self._getOrOpenObject(parent)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 257, in _getOrOpenObject
conn = self._getMountedConnection(anyjar)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 147, in _getMountedConnection
self._getDB()
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
line 157, in _getDB
return getConfiguration().getDatabase(self._path)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
line 276, in getDatabase
name = self.getName(mount_path)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
line 293, in getName
self._mountPathError(mount_path)
File
"/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
line 268, in _mountPathError
raise ConfigurationError(
ZConfig.ConfigurationError: No database configured for mount point
at /sapl_old
administrador@dmasv03:/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao$
Me desculpem pelo longo e-mail.
Atenciosamente,
Juliano Bringer
CM Domingos Martins-ES -
Jan. 11, 2011, 3:02 p.m.Juliano, infelizmente o Roteiro Básico está com problemas ainda não
corrigidos. Por ora, sugiro utilizar o Roteiro Alternativo que está
funcionando.
att.
Em 11-01-2011 09:45, Juliano Bringer escreveu:> Olá Pessoal,
> Estou querendo migrar do SAPL 2.2 para o 2.3.
> Segui os procedimentos contidos para uma instalação em um novo
> ambiente
>http://colab.interlegis.gov.br/wiki/HOWTO-InstalarSAPL23Ubuntu [1]
> Os erros a seguir estão acontecendo na MIGRAÇÃO DA BASE DE DADOS
> MYSQL parte 2.
> Quando executo o seguinte comando:
> /var/interlegis/SAPL-2.3-beta/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.sh
> Abaixo segue os erros, se alguém puder auxiliar agradeço.
>
> administrador@dmasv03:/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao$
> sudo ./sapl_migracao.sh
> ok... Encontrado o arquivo Data.fs da versao anterior
> ok... Encontrado o arquivo DocumentosSapl.fs da versao anterior
> ok... Encontrado o arquivo sapl_old.sql
> kill: 70: Usage: kill [-s sigspec | -signum | -sigspec] [pid |
> job]... or
> kill -l [exitstatus]
> ok... SAPL antigo parado.
> daemon manager not running
> ok... SAPL 2.3 parado
> ok... Ajustado o proprietário do arquivo old/Data.fs
> ./sapl_migracao.sh: 85: /var/interlegis/SAPL-2.3/mysql/bin/mysql:
> not found
> ok... Importado o arquivo do backup do MySQL
> ./sapl_migracao.sh: 88: /var/interlegis/SAPL-2.3/mysql/bin/mysql:
> not found
> ok... Atualizado o banco para a nova estrutura do SAPL 2.3
> cp: impossível obter estado de `/var/DocumentosSapl.fs': Arquivo ou
> diretório não encontrado
> chown: impossível acessar
> `/var/interlegis/SAPL-2.3/instances/sapl23/var/DocumentosSapl.fs':
> Arquivo ou diretório não encontrado
> ok... Arquivo DocumentosSapl.fs copiado
>
> /var/interlegis/SAPL-2.3/instances/sapl23/Products/ZMySQLDA/DABase.py:92:
> DeprecationWarning: The ImageFile module will be removed in Zope 2.11.
> Use App.ImageFile instead.
> from ImageFile import ImageFile
>
> /var/interlegis/SAPL-2.3/instances/sapl23/Products/TextIndexNG2/TextIndexNG.py:28:
> DeprecationWarning: Using OFS.content_types is deprecated (will be
> removed in Zope 2.11). Instead use zope.app.contenttypes.
> from OFS.content_types import guess_content_type
> 2011-01-10 11:19:13 WARNING textindexng Converter "xls" not
> registered because executable "xls2csv" could not be found
> 2011-01-10 11:19:13 WARNING textindexng Converter "ppt" not
> registered because executable "pptHtml" could not be found
> 2011-01-10 11:19:13 WARNING textindexng Converter "doc" not
> registered because executable "wvWare" could not be found
> /var/interlegis/SAPL-2.3/Zope-2.9/lib/python/OFS/Application.py:830:
> DeprecationWarning: __init__.py of Products.ZMySQLDA has a long
> deprecated 'methods' attribute. 'methods' support might be removed in
> Zope 2.11 or a later feature release. Please use the 'legacy' argument
> of registerClass instead if the methods are constructors. Or refactor
> the product using adapters.
> DeprecationWarning)
>
> /var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.py:1:
> DeprecationWarning: Non-ASCII character 'xe7' in file
> /var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.py
> on line 1, but no encoding declared; see
>http://www.python.org/peps/pep-0263.html [2] for details
> ### Script a ser rodado durante o processo de migra��o de
> dados de vers�es anteriores do SAPL.
> ok... Mount-point dos documentos removido com sucesso
> 2011-01-10 11:19:13 ERROR Zope.ZODBMountPoint Failed to mount
> database. ZConfig.ConfigurationError (No database configured for mount
> point at /sapl_old)
> Traceback (most recent call last):
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 257, in _getOrOpenObject
> conn = self._getMountedConnection(anyjar)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 147, in _getMountedConnection
> self._getDB()
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 157, in _getDB
> return getConfiguration().getDatabase(self._path)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
> line 276, in getDatabase
> name = self.getName(mount_path)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
> line 293, in getName
> self._mountPathError(mount_path)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
> line 268, in _mountPathError
> raise ConfigurationError(
> ConfigurationError: No database configured for mount point at
> /sapl_old
> Traceback (most recent call last):
> File "", line 1, in ?
> File
> "/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao/sapl_migracao.py",
> line 27, in ?
>
> app.manage_addProduct['ZODBMountPoint'].manage_addMounts(paths=['/sapl_old'],create_mount_points=1)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 377, in manage_addMounts
> mo._test(app)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 243, in _test
> self._getOrOpenObject(parent)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 257, in _getOrOpenObject
> conn = self._getMountedConnection(anyjar)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 147, in _getMountedConnection
> self._getDB()
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Products/ZODBMountPoint/MountedObject.py",
> line 157, in _getDB
> return getConfiguration().getDatabase(self._path)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
> line 276, in getDatabase
> name = self.getName(mount_path)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
> line 293, in getName
> self._mountPathError(mount_path)
> File
> "/var/interlegis/SAPL-2.3/Zope-2.9/lib/python/Zope2/Startup/datatypes.py",
> line 268, in _mountPathError
> raise ConfigurationError(
> ZConfig.ConfigurationError: No database configured for mount point
> at /sapl_old
>
> administrador@dmasv03:/var/interlegis/SAPL-2.3/instances/sapl23/Products/ILSAPL/instalacao$
>
> Me desculpem pelo longo e-mail.
> Atenciosamente,
> Juliano Bringer
> CM Domingos Martins-ES
>
>
--Claudio Morale
Analista de Sistemas
Interlegis - Brasília (DF)