Hallo,
ich nutze seit längerem EGW CE auf dem Webspace meines Hosters (netcup). Aktuell versuche ich EGW auf einer VM mit Debian 11 (Xen Hypervisor) zum Laufen zu bekommen und die Daten zu importieren. Ich habe mich an die folgenden Anleitung gehalten:
Angepasst hatte ich nur Befehle fürdas Repository für Debian 11. Es funktioniert auch alles wunderbar bis ich versuche die Sicherung der EGW vom Webspace einzuspielen.
Hier die Infos der EGW aus Webspace und VM:
Webspace:
egroupware-docker (21.1.20211130)
PHP Version 7.4.30
MySQL: 8.0
VM:
egroupware-docker (21.1.20220916)
PHP Version 7.4.30
MariaDB docker
root@debiandocker:~# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
c633a4cc9077 nginx:stable-alpine "/docker-entrypoint.…" 2 days ago Up 56 minutes 127.0.0.1:8080->80/tcp egroupware-nginx
840924f8a44a phpswoole/swoole:4.6-php7.4-alpine "docker-php-entrypoi…" 2 days ago Up 56 minutes egroupware-push
0394d7f2d108 containrrr/watchtower:latest "/watchtower --sched…" 2 days ago Up 56 minutes 8080/tcp egroupware-watchtower
075c5c790555 egroupware/egroupware:21.1 "/entrypoint.sh php-…" 2 days ago Up 56 minutes 9000/tcp egroupware
d86b903686a5 mariadb:10.4 "docker-entrypoint.s…" 2 days ago Up 56 minutes 3306/tcp egroupware-db
b4c2231e1a42 quay.io/egroupware/collabora-key:stable "/start-collabora-on…" 2 days ago Up 56 minutes 127.0.0.1:9980->9980/tcp collabora-key
Beim Import erscheinen folgende Fehlermeldungen:
Restore started, this might take a few minutes ...
CreateTableSQL('egw_ea_accounts','acc_id I AUTOINCREMENT NOTNULL PRIMARY, acc_name C(80), ident_id I1 NOTNULL, acc_imap_host C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL, acc_imap_ssl I1 NOTNULL NOQUOTE DEFAULT 0, acc_imap_port I1 NOTNULL NOQUOTE DEFAULT 143, acc_sieve_enabled L NOQUOTE DEFAULT 0, acc_sieve_host C(128) CONSTRAINT "CHARACTER SET ascii", acc_sieve_port I1 NOQUOTE DEFAULT 4190, acc_folder_sent C(128), acc_folder_trash C(128), acc_folder_draft C(128), acc_folder_template C(128), acc_folder_archive C(128), acc_smtp_host C(128), acc_smtp_ssl I1 NOTNULL NOQUOTE DEFAULT 0, acc_smtp_port I1 NOTNULL NOQUOTE DEFAULT 25, acc_smtp_type C(32) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'emailadmin_smtp', acc_imap_type C(32) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'emailadmin_imap', acc_imap_logintype C(20) CONSTRAINT "CHARACTER SET ascii", acc_domain C(100), acc_user_editable L NOTNULL DEFAULT 1, acc_sieve_ssl I1 NOQUOTE DEFAULT 1, acc_modified T NOTNULL, acc_modifier I1, acc_smtp_auth_session L, acc_folder_junk C(128), acc_imap_default_quota I1, acc_imap_timeout I2, acc_user_forward L NOQUOTE DEFAULT 0, acc_further_identities I1 NOTNULL NOQUOTE DEFAULT 1, acc_folder_ham C(128), acc_spam_api C(128)') sql=Array ( [0] => CREATE TABLE `egw_ea_accounts` ( `acc_id` INTEGER NOT NULL AUTO_INCREMENT, `acc_name` VARCHAR(80), `ident_id` TINYINT NOT NULL, `acc_imap_host` VARCHAR(128) CHARACTER SET ascii NOT NULL, `acc_imap_ssl` TINYINT NOT NULL DEFAULT 0, `acc_imap_port` TINYINT NOT NULL DEFAULT 143, `acc_sieve_enabled` TINYINT DEFAULT 0, `acc_sieve_host` VARCHAR(128) CHARACTER SET ascii, `acc_sieve_port` TINYINT DEFAULT 4190, `acc_folder_sent` VARCHAR(128), `acc_folder_trash` VARCHAR(128), `acc_folder_draft` VARCHAR(128), `acc_folder_template` VARCHAR(128), `acc_folder_archive` VARCHAR(128), `acc_smtp_host` VARCHAR(128), `acc_smtp_ssl` TINYINT NOT NULL DEFAULT 0, `acc_smtp_port` TINYINT NOT NULL DEFAULT 25, `acc_smtp_type` VARCHAR(32) CHARACTER SET ascii DEFAULT 'emailadmin_smtp', `acc_imap_type` VARCHAR(32) CHARACTER SET ascii DEFAULT 'emailadmin_imap', `acc_imap_logintype` VARCHAR(20) CHARACTER SET ascii, `acc_domain` VARCHAR(100), `acc_user_editable` TINYINT NOT NULL DEFAULT 1, `acc_sieve_ssl` TINYINT DEFAULT 1, `acc_modified` DATETIME NOT NULL, `acc_modifier` TINYINT, `acc_smtp_auth_session` TINYINT, `acc_folder_junk` VARCHAR(128), `acc_imap_default_quota` TINYINT, `acc_imap_timeout` SMALLINT, `acc_user_forward` TINYINT DEFAULT 0, `acc_further_identities` TINYINT NOT NULL DEFAULT 1, `acc_folder_ham` VARCHAR(128), `acc_spam_api` VARCHAR(128), PRIMARY KEY (`acc_id`) )CHARACTER SET utf8 )
Invalid default value for 'acc_imap_port'
Invalid SQL: INSERT INTO egw_ea_accounts (acc_id,acc_name,ident_id,acc_imap_host,acc_imap_ssl,acc_imap_port,acc_sieve_enabled,acc_sieve_host,acc_sieve_port,acc_folder_sent,acc_folder_trash,acc_folder_draft,acc_folder_template,acc_folder_archive,acc_smtp_host,acc_smtp_ssl,acc_smtp_port,acc_smtp_type,acc_imap_type,acc_imap_logintype,acc_domain,acc_user_editable,acc_sieve_ssl,acc_modified,acc_modifier,acc_smtp_auth_session,acc_folder_junk,acc_imap_default_quota,acc_imap_timeout,acc_user_forward,acc_further_identities,acc_folder_ham,acc_spam_api) VALUES (3,'service-edv@lebenshilfe-detmold.de',3,'',2,993,0,'',0,NULL,NULL,NULL,NULL,NULL,'mail.fitzke-it.de',3,465,'Smtp','Imap',NULL,NULL,1,2,'2022-03-15 06:31:24',11,NULL,NULL,NULL,NULL,0,1,NULL,'') Table 'egroupware.egw_ea_accounts' doesn't exist (1146)
Invalid SQL: INSERT INTO egw_ea_accounts (acc_id,acc_name,ident_id,acc_imap_host,acc_imap_ssl,acc_imap_port,acc_sieve_enabled,acc_sieve_host,acc_sieve_port,acc_folder_sent,acc_folder_trash,acc_folder_draft,acc_folder_template,acc_folder_archive,acc_smtp_host,acc_smtp_ssl,acc_smtp_port,acc_smtp_type,acc_imap_type,acc_imap_logintype,acc_domain,acc_user_editable,acc_sieve_ssl,acc_modified,acc_modifier,acc_smtp_auth_session,acc_folder_junk,acc_imap_default_quota,acc_imap_timeout,acc_user_forward,acc_further_identities,acc_folder_ham,acc_spam_api) VALUES (4,'service-edv@lebenshilfe-detmold.de',4,'',2,993,0,'',0,NULL,NULL,NULL,NULL,NULL,'mail.fitzke-it.de',1,587,'Smtp','Imap',NULL,NULL,1,2,'2022-03-15 06:35:44',11,NULL,NULL,NULL,NULL,0,1,NULL,'') Table 'egroupware.egw_ea_accounts' doesn't exist (1146)
Invalid SQL: INSERT INTO egw_ea_accounts (acc_id,acc_name,ident_id,acc_imap_host,acc_imap_ssl,acc_imap_port,acc_sieve_enabled,acc_sieve_host,acc_sieve_port,acc_folder_sent,acc_folder_trash,acc_folder_draft,acc_folder_template,acc_folder_archive,acc_smtp_host,acc_smtp_ssl,acc_smtp_port,acc_smtp_type,acc_imap_type,acc_imap_logintype,acc_domain,acc_user_editable,acc_sieve_ssl,acc_modified,acc_modifier,acc_smtp_auth_session,acc_folder_junk,acc_imap_default_quota,acc_imap_timeout,acc_user_forward,acc_further_identities,acc_folder_ham,acc_spam_api) VALUES (5,'SMTP only',5,'',2,993,0,'',0,NULL,NULL,NULL,NULL,NULL,'mail.fitzke-it.de',1,587,'Smtp','Imap','','',0,2,'2022-03-15 06:54:30',8,0,NULL,NULL,NULL,0,1,NULL,'') Table 'egroupware.egw_ea_accounts' doesn't exist (1146)
Invalid SQL: INSERT INTO egw_infolog_users (info_res_id,info_id,account_id,info_res_deleted,info_res_modified,info_res_modifier,info_res_status,info_res_attendee) VALUES (225,128,'8',NULL,NULL,8,'NEEDS-ACTION',NULL) Duplicate entry '127-8' for key 'egw_infolog_users_id_account_id' (1062)
Invalid SQL: INSERT INTO egw_infolog_users (info_res_id,info_id,account_id,info_res_deleted,info_res_modified,info_res_modifier,info_res_status,info_res_attendee) VALUES (227,129,'8',NULL,NULL,8,'NEEDS-ACTION',NULL) Duplicate entry '127-8' for key 'egw_infolog_users_id_account_id' (1062)
----- gekürzt ----
Invalid SQL: INSERT INTO egw_infolog_users (info_res_id,info_id,account_id,info_res_deleted,info_res_modified,info_res_modifier,info_res_status,info_res_attendee) VALUES (572,307,'9',NULL,NULL,8,'NEEDS-ACTION',NULL) Duplicate entry '127-9' for key 'egw_infolog_users_id_account_id' (1062)
EGroupware API version 21.1.001 found. EGroupware configuration file (header.inc.php) version 1.29 exists and is up to date Start updating the database ... /usr/share/egroupware/api/src/Db.php (822)
Database error
Invalid SQL: INSERT INTO egw_admin_queue (cmd_uid,cmd_creator,cmd_creator_email,cmd_created,cmd_type,cmd_status,cmd_scheduled,cmd_modified,cmd_modifier,cmd_modifier_email,cmd_error,cmd_errno,cmd_requested,cmd_requested_email,cmd_comment,cmd_data,remote_id,cmd_app,cmd_account,cmd_rrule,cmd_parent) VALUES ('',6,'Admin User',1666891091,'setup_cmd_update',3,NULL,NULL,NULL,NULL,'Invalid SQL: INSERT INTO egw_openid_scopes (scope_identifier,scope_description,scope_created) VALUES (\'groups\',\'Groups\',\'2022-10-27 17:18:11\')\nField \'scope_updated\' doesn\'t have a default value (1364)',1364,NULL,NULL,NULL,'{\"domain\":\"default\",\"config_user\":\"admin\",\"config_passwd\":\"*************************\",\"backup\":false,\"verbose\":true,\"result\":1364}',NULL,NULL,NULL,NULL,NULL)
Out of range value for column 'cmd_errno' at row 1 (1264)
Ab diesem Moment ist kein Login in EGW mehr möglich. Mit den Zugangsdaten vom Webspace erscheint ein “Datenbank Fehler!”
Der Zugriff auf das Setup ist möglich mit den Zugangsdaten von der VM Installation.
Unter Anwendungen im Setup erscheint zudem folgender Fehler:
api-Erfordert Neuinstallation oder manuelle Reparatur - C EGroupware API 21.1.001 21.1.001 Potentielles Problem
- Kästchen zur Aktualisierung etc. existieren nicht
Ich hoffe ich habe zu dem Problem erst mal die notwendigsten Informationen eingefügt und hoffe ihr könnt mir weiterhelfen.
Grüße
Steffen
