Hallo!
Ich habe versucht, das Backup einer 1.8 in eine frische 14.3
einzuspielen, über die entsprechende Funktion von egrouproupware.
Danach Konvertierung über /setup. Die User der 1.8 waren im LDAP.
Das Ergebnis nach langer Rechenzeit waren so viele Meldungen, dass
ich gar nicht wüsste, wo ich anfangen soll. (Beispiele siehe unten)
Kurzgesagt: funktioniert nicht.
Da ich vermute, dass einiges schlichtweg am fehlenden LDAP liegen
wird, mal ganz pauschal:
Wie wäre die korrekte Vorgehensweise?
Funktioniert das überhaupt, wenn die User in der 1.8 im LDAP waren?
Ein paar Infos:
- Der Rechner mit der 1.8 existiert nicht mehr
- Daten der Festplatte noch vorhanden
- LDAP ist auf dem neuen Rechner nicht eingerichtet (Ubuntu, keine
Ahnung wie LDAP dort installiert/eingerichtet wird)
Gruß,
Olaf
#######################################
Beispiel für Fehler beim Einlog-Versuch:
Invalid SQL: INSERT INTO egw_access_log
(session_php,loginid,ip,li,account_id,user_agent,session_dla,session_action)
VALUES (‘bad login or
password’,‘sysop@default’,‘127.0.0.1’,1466515956,0,‘Mozilla/5.0 (X11;
Ubuntu; Linux i686; rv:42.0) Gecko/20100101
Firefox/42.0’,1466515956,’/login.php’) Unknown column ‘user_agent’ in
’field list’ (1054)
######################################
Meldungen beim Einspielen des Backups:
Wiederherstellung gestartet, das kann einige Minuten dauern …
CreateIndexSQL(‘egw_wiki_pages’,‘wiki_body’,Array ( [0] => FULLTEXT
) ,‘egw_wiki_pages_body’) sql=Array ( [0] => ALTER TABLE
egw_wiki_pages ADD FULLTEXT INDEX egw_wiki_pages_body (wiki_body)
)
The used table type doesn’t support FULLTEXT indexes
CreateIndexSQL(‘egw_access_log’,‘session_dla’,Array
( ) ,‘egw_access_log_session_dla’) sql=Array ( [0] => ALTER TABLE
egw_access_log ADD INDEX egw_access_log_session_dla (session_dla)
)
Key column ‘session_dla’ doesn’t exist in table
CreateIndexSQL(‘egw_access_log’,‘session_php’,Array
( ) ,‘egw_access_log_session_php’) sql=Array ( [0] => ALTER TABLE
egw_access_log ADD INDEX egw_access_log_session_php (session_php)
)
Key column ‘session_php’ doesn’t exist in table
CreateIndexSQL(‘egw_access_log’,‘notification_heartbeat’,Array
( ) ,‘egw_access_log_notification_heartbeat’) sql=Array ( [0] => ALTER
TABLE egw_access_log ADD INDEX
egw_access_log_notification_heartbeat (notification_heartbeat) )
Key column ‘notification_heartbeat’ doesn’t exist in table
CreateIndexSQL(‘egw_addressbook’,‘carddav_name’,Array
( ) ,‘egw_addressbook_carddav_name’) sql=Array ( [0] => ALTER TABLE
egw_addressbook ADD INDEX egw_addressbook_carddav_name
(carddav_name) )
Key column ‘carddav_name’ doesn’t exist in table
CreateIndexSQL(‘egw_addressbook_lists’,‘list_uid’,Array ( [0] => UNIQUE
) ,‘egw_addressbook_lists_list_uid’) sql=Array ( [0] => ALTER TABLE
egw_addressbook_lists ADD UNIQUE INDEX
egw_addressbook_lists_list_uid (list_uid) )
Key column ‘list_uid’ doesn’t exist in table
CreateIndexSQL(‘egw_addressbook_lists’,‘list_carddav_name’,Array ( [0]
=> UNIQUE ) ,‘egw_addressbook_lists_list_carddav_name’) sql=Array ( [0]
=> ALTER TABLE egw_addressbook_lists ADD UNIQUE INDEX
egw_addressbook_lists_list_carddav_name (list_carddav_name) )
Key column ‘list_carddav_name’ doesn’t exist in table
CreateIndexSQL(‘egw_cal’,‘cal_deleted’,Array ( ) ,‘egw_cal_deleted’)
sql=Array ( [0] => ALTER TABLE egw_cal ADD INDEX egw_cal_deleted
(cal_deleted) )
Key column ‘cal_deleted’ doesn’t exist in table
CreateIndexSQL(‘egw_cal’,‘caldav_name’,Array
( ) ,‘egw_cal_caldav_name’) sql=Array ( [0] => ALTER TABLE egw_cal
ADD INDEX egw_cal_caldav_name (caldav_name) )
Key column ‘caldav_name’ doesn’t exist in table
CreateIndexSQL(‘egw_cal_dates’,Array ( [0] => recur_exception [1] =>
cal_id ) ,Array ( ) ,‘egw_cal_dates_recur_exception_id’) sql=Array
( [0] => ALTER TABLE egw_cal_dates ADD INDEX
egw_cal_dates_recur_exception_id (recur_exception, cal_id) )
Key column ‘recur_exception’ doesn’t exist in table
CreateIndexSQL(‘egw_infolog’,‘caldav_name’,Array
( ) ,‘egw_infolog_caldav_name’) sql=Array ( [0] => ALTER TABLE
egw_infolog ADD INDEX egw_infolog_caldav_name (caldav_name) )
Key column ‘caldav_name’ doesn’t exist in table
CreateIndexSQL(‘egw_links’,‘deleted’,Array ( ) ,‘egw_links_deleted’)
sql=Array ( [0] => ALTER TABLE egw_links ADD INDEX
egw_links_deleted (deleted) )
Key column ‘deleted’ doesn’t exist in table
CreateIndexSQL(‘egw_notificationpopup’,‘notify_created’,Array
( ) ,‘egw_notificationpopup_notify_created’) sql=Array ( [0] => ALTER
TABLE egw_notificationpopup ADD INDEX
egw_notificationpopup_notify_created (notify_created) )
Key column ‘notify_created’ doesn’t exist in table
CreateIndexSQL(‘egw_sqlfs’,Array ( [0] => fs_dir [1] => fs_active [2]
=> fs_name(16) ) ,Array ( ) ,‘egw_sqlfs_fs_dir_fs_active_fs_name’)
sql=Array ( [0] => ALTER TABLE egw_sqlfs ADD INDEX
egw_sqlfs_fs_dir_fs_active_fs_name (fs_dir, fs_active, fs_name
(16)) )
Duplicate key name ‘egw_sqlfs_fs_dir_fs_active_fs_name’
CreateIndexSQL(‘egw_tracker_replies’,‘reply_visible’,Array
( ) ,‘egw_tracker_replies_reply_visible’) sql=Array ( [0] => ALTER
TABLE egw_tracker_replies ADD INDEX
egw_tracker_replies_reply_visible (reply_visible) )
Key column ‘reply_visible’ doesn’t exist in table
#####################
Dann auf egroupware/setup
–> Konfigurationsbenutzer ->
Es sieht so aus als benutzen Sie Version 1.8.001 von EGroupware.
Wir werden Ihre Tabellen/Einträge automatisch zu 14.3.007 aktualisieren
–>
process->pass(): #1 for upgrade processing
process->upgrade(): Incoming : appname: phpgwapi, version: 1.8.001,
status: process->upgrade(): phpgwapi(1.8.001 --> 14.3.007): running
phpgwapi_upgrade1_8_001() --> 1.9.001 process->upgrade():
phpgwapi(1.9.001 --> 14.3.007): running phpgwapi_upgrade1_9_001() -->
1.9.002 process->upgrade(): phpgwapi(1.9.002 --> 14.3.007): running
phpgwapi_upgrade1_9_002() --> 1.9.003 process->upgrade():
phpgwapi(1.9.003 --> 14.3.007): running phpgwapi_upgrade1_9_003() -->
1.9.004 process->upgrade(): phpgwapi(1.9.004 --> 14.3.007): running
phpgwapi_upgrade1_9_004() --> 1.9.005 process->upgrade():
phpgwapi(1.9.005 --> 14.3.007): running phpgwapi_upgrade1_9_005()
CreateIndexSQL(‘egw_access_log’,‘li’,Array ( ) ,‘egw_access_log_li’)
sql=Array ( [0] => ALTER TABLE egw_access_log ADD INDEX
egw_access_log_li (li) )
Duplicate key name ‘egw_access_log_li’
–> 1.9.006
process->upgrade(): phpgwapi(1.9.006 --> 14.3.007): running
phpgwapi_upgrade1_9_006() --> 1.9.007 process->upgrade():
phpgwapi(1.9.007 --> 14.3.007): running phpgwapi_upgrade1_9_007() -->
1.9.008 process->upgrade(): phpgwapi(1.9.008 --> 14.3.007): running
phpgwapi_upgrade1_9_008() --> 1.9.009 process->upgrade():
phpgwapi(1.9.009 --> 14.3.007): running phpgwapi_upgrade1_9_009() -->
1.9.010 process->upgrade(): phpgwapi(1.9.010 --> 14.3.007): running
phpgwapi_upgrade1_9_010()
Can’t connect/bind to LDAP server ‘localhost’ and
dn=‘cn=admin,dc=OLAF,dc=local’!
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
egroupware-german mailing list
egroupware-german@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-german
