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"

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!