Hallo Herr Keppler,
beim bereinigen eines alten Servers ist mir aufgefallen, dass nicht alle Accounts vollständig gelöscht wurden.
Auf dem Server sind die Accounts allerdings gelöscht.
Logfile Einträge habe ich leider keine mehr dazu.
Wie bekomme ich jetzt die alten Datensätze aus der DB raus?
Ziel ist es den bereinigten Server aus LiveConfig zu löschen, da er nicht mehr in Betrieb ist.
Beispielhaft die Datenbak einträge eines Accounts (als CSV):
LIVECONFIG.LOG
Code
"LOG_ID","LOG_LEVEL","LOG_CUSTOMERID","LOG_USERID","LOG_REALUSERID","LOG_TIMESTAMP","LOG_MODULEID","LOG_EVENTID","LOG_MESSAGE","LOG_DATA"
"4029","2","1","1",NULL,"2015-10-27 13:31:06","1","5","Created new system account","webh_99"
"11221","2","1","1",NULL,"2018-10-04 12:36:31","1","8","Deleted hosting subscription","webh_99"LIVECONFIG.HOSTINGCONTRACTS
Code
"HC_ID","HC_SERVERID","HC_MAILSERVERID","HC_DBSERVERID","HC_RCID","HC_RCIDROOT","HC_RCIDLEFT","HC_RCIDRIGHT","HC_CUSTOMERID","HC_OWNERID","HC_NAME","HC_SORT1","HC_SORT2","HC_STATUS","HC_PLANID","HC_DIFFERING","HC_MAXCUSTOMERS","HC_RESALEABLE","HC_MAXUSERS","HC_WEBSPACE","HC_TRAFFIC","HC_EXTDOMAINS","HC_SUBDOMAINS","HC_DNSEDIT","HC_DYNDNS","HC_MAILBOXES","HC_MAILADDRS","HC_MAILQUOTA","HC_PHP","HC_CGI","HC_SSI","HC_SSL","HC_DATABASES","HC_DBEXTACCESS","HC_FTPACCOUNTS","HC_SHELLACCESS","HC_CRONJOBS","HC_APPS","HC_COMMENT","HC_PATH","HC_GROUPNAME","HC_QUOTABLOCKS","HC_QUOTAFILES","HC_QUOTATS","HC_STATSSOFTWARE","HC_STATSSUBDOMAINID","HC_STATSUSER","HC_STATSPASSWD","HC_STATSLANG","HC_DELETED","HC_CREATED","HC_MODIFIED","HC_IPGROUPID","HC_REFRESHCFG","HC_ERRORLOG","HC_LR_CONDTYPE","HC_LR_CONDVALUE","HC_LR_CMP","HC_LR_DELTYPE","HC_LR_DELVALUE","HC_UPDATESTATUS","HC_LOG_FILTERV4","HC_LOG_FILTERV6","HC_DNSSETID","HC_LOCKED"
"99","4","4","4",NULL,NULL,NULL,NULL,"1","1","webh_99","webh_","99","0",NULL,"0",NULL,NULL,"1","100","-1","-1","-1","1",NULL,"-1","-1","1024","2","0","0","2","-1","0","-1","2","0","0",NULL,"/var/www/webh_99","webh_99",NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,"1","2015-10-27 13:30:09","2015-10-27 13:31:06","0",NULL,NULL,"0","3","1","1","100","79","0","0",NULL,"0"LIVECONFIG.ACCOUNTS
Code
"AC_ID","AC_SERVERID","AC_CONTRACTID","AC_USERID","AC_LOGIN","AC_TYPE","AC_SHELL","AC_STATUS","AC_HOME","AC_TMPPWD","AC_CHPASSWDTS","AC_DELETED","backup"
"137","4","99",NULL,"webh_99","0","2","0","/var/www/webh_99",NULL,NULL,"0","1"