Verträge werden nicht vollständig gelöscht

  • 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"

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!