On Sun, 2020-06-28 at 18:36 +0100, André Rodier wrote:
> Hello,
>
> I am testing SOGo backup restoration, from the version 3 to version
> 4.
>
> - backup Version: 3.2.6-2
> - restore Version: 4.0.7-1+deb10u1
>
> However, I have these errors, when calling sogo-tool restore
>
> > /usr/sbin/sogo-tool restore -F ALL /var/backups/sogo/sogo-2020-06-
> > 28_0030 andre
> > <0x0x55add2f1f260[SOGoCache]> Cache cleanup interval set every
> > 300.00 seconds
> > <0x0x55add2f1f260[SOGoCache]> Using host(s) '127.0.0.1' as
> > server(s)
> > 2020-06-28 17:30:53.945 sogo-tool[18360:18360] Creating
> > NGLdapConnection instance for bindDN 'cn=readonly
> > account,ou=users,dc=rodier,dc=me'
> > <0x0x55add2da7300[GCSFolderManager]> ERROR(-[GCSFolderManager
> > performSQL:]): cannot execute
> > SQL 'SELECT c_folder_id, c_path, c_location,
> > c_quick_location,
> > c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 =
> > 'Users' AND c_path2 = 'andre' AND c_path3 = 'Contacts' AND c_path4
> > =
> > 'collected'':
> >
> > NAME:PostgreSQL72FatalError REASON:fatal pgsql error
> > (channel=<0x0x55add2cfa630[PostgreSQL72Channel]:
> > connection=<0x0x55add2e72630[PGConnection]: connection=0x0x55add2e
> > ea
> > 010>>): ERROR: relation "sogo_folder_info" does not exist
> > LINE 1: ...uick_location, c_acl_location, c_folder_type FROM
> > sogo_folde...
> > ^
> >
> > <0x0x55add2da7300[GCSFolderManager]> ERROR(-[GCSFolderManager
> > recordAtPath:]): executing SQL failed: 'SELECT c_folder_id, c_path,
> > c_location, c_quick_location, c_acl_location, c_folder_type FROM
> > sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'andre' AND
> > c_path3 = 'Contacts' AND c_path4 = 'collected''
> > <0x0x55add2da7300[GCSFolderManager]> ERROR(-[GCSFolderManager
> > performSQL:]): cannot execute
> > SQL 'SELECT c_path FROM sogo_folder_info WHERE c_path1 =
> > 'Users' AND c_path2 = 'andre' AND c_path3 = 'Contacts' AND c_path4
> > =
> > 'collected'':
> >
> > NAME:PostgreSQL72FatalError REASON:fatal pgsql error
> > (channel=<0x0x55add2cfa630[PostgreSQL72Channel]:
> > connection=<0x0x55add2e72630[PGConnection]: connection=0x0x55add2e
> > ea010>>): ERROR: relation "sogo_folder_info" does not exist
> > LINE 1: SELECT c_path FROM sogo_folder_info WHERE c_path1 =
> > 'Users' ...
> >
>
> Is it possible to restore a backup from version 3 to version 4 ?
>
> Thanks for your help,
> André Rodier
>
Hello again,
I found the script to update, I called it before, and it is now
working.
Kind regards,
André
--
users@sogo.nu
https://inverse.ca/sogo/lists