After Apache2 Re install - lost access to admin and all sites

Discussion in 'Installation/Configuration' started by LAKSHA, Sep 21, 2019.

  1. LAKSHA

    LAKSHA Member

    Hello,
    I reinstalled apache2 due to some errors of ennv variables missing
    i am getting refused to connect error after reinstalling it.
    Please suggest and help me resolve the issue.
    million thanks!
     
  2. LAKSHA

    LAKSHA Member

    Hello,
    Mine crashed after reinstalling Apache2 after it got error of ennvv
    I reinstalled apache2 and llost all connection to admin and my websites
    then i tried this suggestion and it threw another error
    here is it


    [email protected]:/tmp# cd ispconfig3_install/install
    [email protected]:/tmp/ispconfig3_install/install# php -q update.php
    >> Update

    Operating System: Debian 8.0 (Jessie) or compatible

    This application will update ISPConfig 3 on your server.

    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: yes

    Creating backup of "/usr/local/ispconfig" directory...
    Creating backup of "/etc" directory...
    mysqldump: Got error: 144: "Table './dbispconfig/sys_datalog' is marked as crashed and last (automatic?) repair failed" when using LOCK TABLES
    Checking ISPConfig database ..
    Some tables where not 'OK'. Please check the list below.

    dbispconfig.sys_datalog
    warning : Table is marked as crashed and last repair failed
    warning : 1 client is using or hasn't closed the table properly
    warning : Size of indexfile is: 16384 Should be: 1024
    error : Found key at page -1 that points to record outside datafile
    error : Corrupt

    Repairing tables
    dbispconfig.sys_datalog
    error : Can't create new tempfile: './dbispconfig/sys_datalog.TMD'
    status : Operation failed

    Press enter to continue or CTRL-C to cancel the installation ..^C
    [email protected]:/tmp/ispconfig3_install/install#

    Please help!
    @till please i request you to please help
    Regards,
    Laksha
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  5. LAKSHA

    LAKSHA Member

    Hello Taleman, Yes Sir , Its the same problem , And you can see my steps i have taken.
     
  6. LAKSHA

    LAKSHA Member

    I am also getting lots of bruteforce every now and then.
     
  7. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I have no idea what that means.
    Does PHPMyadmin work on that host? Try repairing the database table with that.
    Also, what shows
    Code:
    systemctl --state=failed
    But it would be better to stop hijacking thread and use you own newly creted thread.
     
  8. LAKSHA

    LAKSHA Member

    Hi,
    UNIT LOAD ACTIVE SUB DESCRIPTION
    <E2><97><8F> bind9.service loaded failed failed BIND Domain Name Serv
    <E2><97><8F> clamav-daemon.service loaded failed failed Clam AntiVirus usersp
    <E2><97><8F> clamav-freshclam.service loaded failed failed ClamAV virus database
    <E2><97><8F> haveged.service loaded failed failed Entropy daemon using
    <E2><97><8F> le_ispc_pem.service loaded failed failed LSB: LE ISPSERVER.PEM
     
  9. LAKSHA

    LAKSHA Member

    UNIT LOAD ACTIVE SUB DESCRIPTION
    <E2><97><8F> bind9.service loaded failed failed BIND Domain Name Server
    <E2><97><8F> clamav-daemon.service loaded failed failed Clam AntiVirus userspace daemon
    <E2><97><8F> clamav-freshclam.service loaded failed failed ClamAV virus database updater
    <E2><97><8F> haveged.service loaded failed failed Entropy daemon using the HAVEGE
     
  10. LAKSHA

    LAKSHA Member

    $ systemctl

    UNIT LOAD ACTIVE SUB DESCRIPTION
    <E2><97><8F> proc-sys-fs-binfmt_misc.automount loaded failed failed Arbitrary Executable File Formats File System Automount Point
    sys-devices-virtual-net-venet0.device loaded active plugged /sys/devices/virtual/net/venet0
    sys-subsystem-net-devices-venet0.device loaded active plugged /sys/subsystem/net/devices/venet0
    -.mount loaded active mounted /
    dev-mqueue.mount loaded active mounted POSIX Message Queue File System
    run-shm.mount loaded active mounted /run/shm
    tmp.mount loaded active mounted Temporary Directory
    var-www-clients-client1-web1-log.mount loaded active mounted /var/www/clients/client1/web1/log

    SAME FOR ALL THE WEBS AND CLIENTS loaded active mounted

    systemd-ask-password-console.path loaded active waiting Dispatch Password Requests to Console Directory Watch
    systemd-ask-password-wall.path loaded active waiting Forward Password Requests to Wall Directory Watch
    amavis-mc.service loaded active exited LSB: Startup script for amavis master supervisor
    amavis.service loaded active running LSB: Starts amavisd-new mailfilter
     
  11. LAKSHA

    LAKSHA Member

    [email protected]:~# systemctl list-unit-files
    UNIT FILE STATE
    proc-sys-fs-binfmt_misc.automount static
    dev-hugepages.mount static
    dev-mqueue.mount static
    proc-sys-fs-binfmt_misc.mount static
    sys-fs-fuse-connections.mount static
    sys-kernel-config.mount static
    sys-kernel-debug.mount static
    tmp.mount enabled
    systemd-ask-password-console.path static
    systemd-ask-password-wall.path static
    [email protected] disabled
    bind9-resolvconf.service disabled
    bind9.service enabled
    bootlogd.service masked
    bootlogs.service masked
    bootmisc.service masked
    checkfs.service masked
    checkroot-bootclean.service masked
    checkroot.service masked
    clamav-daemon.service enabled
    clamav-freshclam.service enabled
    console-getty.service disabled
    console-shell.service disabled
    [email protected] static
    cron.service enabled
    cryptdisks-early.service masked
    cryptdisks.service masked
    dbus-org.freedesktop.hostname1.service static
    dbus-org.freedesktop.locale1.service static
    dbus-org.freedesktop.login1.service static
    dbus-org.freedesktop.machine1.service static
    dbus-org.freedesktop.timedate1.service static
    debian-fixup.service static
    debug-shell.service disabled
    dovecot.service enabled
    emergency.service static
     
  12. LAKSHA

    LAKSHA Member

    Is it because of checkroot ? i am a novice admin but a fast learner. Any help will be much appreciated, recognized in a review where required :)
     
  13. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    What checkroot? Where checkroot?
    Have you now repaired the broken database table?
     
  14. LAKSHA

    LAKSHA Member

  15. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Chkrootkit probably has no part here. But did you check its log in case it removed some important file?
    Did you check if PHPMyAdmin works? Repearing with that would be easy.
    If not, I would try Internet Search Engines with
    Code:
    mysql repair database
     
  16. LAKSHA

    LAKSHA Member

    I got error below :-(

    Code:
    mysqlcheck -u root -p -r dbispconfig
    Enter password:
    dbispconfig.aps_instances                          OK
    dbispconfig.aps_instances_settings                 OK
    dbispconfig.aps_packages                           OK
    dbispconfig.aps_settings                           OK
    dbispconfig.attempts_login                         OK
    dbispconfig.client                                 OK
    dbispconfig.client_circle                          OK
    dbispconfig.client_message_template                OK
    dbispconfig.client_template                        OK
    dbispconfig.client_template_assigned               OK
    dbispconfig.country                                OK
    dbispconfig.cron                                   OK
    dbispconfig.directive_snippets                     OK
    dbispconfig.dns_rr                                 OK
    dbispconfig.dns_slave                              OK
    dbispconfig.dns_soa                                OK
    dbispconfig.dns_ssl_ca                             OK
    dbispconfig.dns_template                           OK
    dbispconfig.domain                                 OK
    dbispconfig.firewall                               OK
    dbispconfig.ftp_traffic                            OK
    dbispconfig.ftp_user                               OK
    dbispconfig.help_faq                               OK
    dbispconfig.help_faq_sections                      OK
    dbispconfig.iptables                               OK
    dbispconfig.mail_access                            OK
    dbispconfig.mail_backup                            OK
    dbispconfig.mail_content_filter                    OK
    dbispconfig.mail_domain                            OK
    dbispconfig.mail_forwarding                        OK
    dbispconfig.mail_get                               OK
    dbispconfig.mail_mailinglist                       OK
    dbispconfig.mail_relay_recipient                   OK
    dbispconfig.mail_traffic                           OK
    dbispconfig.mail_transport                         OK
    dbispconfig.mail_user                              OK
    dbispconfig.mail_user_filter                       OK
    dbispconfig.monitor_data                           OK
    dbispconfig.openvz_ip                              OK
    dbispconfig.openvz_ostemplate                      OK
    dbispconfig.openvz_template                        OK
    dbispconfig.openvz_traffic                         OK
    dbispconfig.openvz_vm                              OK
    dbispconfig.remote_session                         OK
    dbispconfig.remote_user                            OK
    dbispconfig.server                                 OK
    dbispconfig.server_ip                              OK
    dbispconfig.server_ip_map                          OK
    dbispconfig.server_php                             OK
    dbispconfig.shell_user                             OK
    dbispconfig.software_package                       OK
    dbispconfig.software_repo                          OK
    dbispconfig.software_update                        OK
    dbispconfig.software_update_inst                   OK
    dbispconfig.spamfilter_policy                      OK
    dbispconfig.spamfilter_users                       OK
    dbispconfig.spamfilter_wblist                      OK
    dbispconfig.support_message                        OK
    dbispconfig.sys_config                             OK
    dbispconfig.sys_cron                               OK
    dbispconfig.sys_datalog
    error    : Can't create new tempfile: './dbispconfig/sys_datalog.TMD'
    status   : Operation failed
    dbispconfig.sys_dbsync                             OK
    dbispconfig.sys_filesync                           OK
    dbispconfig.sys_group                              OK
    dbispconfig.sys_ini                                OK
    dbispconfig.sys_log                                OK
    dbispconfig.sys_remoteaction                       OK
    dbispconfig.sys_session                            OK
    dbispconfig.sys_theme                              OK
    dbispconfig.sys_user                               OK
    dbispconfig.web_backup                             OK
    dbispconfig.web_database                           OK
    dbispconfig.web_database_user                      OK
    dbispconfig.web_domain                             OK
    dbispconfig.web_folder                             OK
    dbispconfig.web_folder_user                        OK
    dbispconfig.web_traffic                            OK
    dbispconfig.webdav_user                            OK
    dbispconfig.xmpp_domain                            OK
    dbispconfig.xmpp_user                              OK
     
    Last edited: Sep 21, 2019
  17. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Internet Search Engines:
    Code:
    mysqlcheck error : Can't create new tempfile:
    An alternative is to restore database from the backups you keep.
     
  18. LAKSHA

    LAKSHA Member

    I fixed all the databases and tables with this
    Code:
    myisamchk -r -f sys_datalog.MYI
    But still cant get access to admin panel of Ispconfig3 or any other site.
    Code:
    systemctl --failed
      UNIT                              LOAD   ACTIVE SUB    DESCRIPTION
    <E2><97><8F> proc-sys-fs-binfmt_misc.automount loaded failed failed Arbitrary Executable File Formats File System Automount Point
    <E2><97><8F> bind9.service                     loaded failed failed BIND Domain Name Server
    <E2><97><8F> clamav-daemon.service             loaded failed failed Clam AntiVirus userspace daemon
    <E2><97><8F> clamav-freshclam.service          loaded failed failed ClamAV virus database updater
    <E2><97><8F> haveged.service                   loaded failed failed Entropy daemon using the HAVEGE algorithm
     
    Last edited: Sep 21, 2019
  19. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Have you now repeated that ispconfig update with forced reconfigure?
     
  20. LAKSHA

    LAKSHA Member

    I repeated it , It was a success, However I still cant get login screen

    here is the output below with the commands

    Code:
     
    [email protected]:~# systemctl status
    
    <E2><97><8F> host2
        State: degraded
         Jobs: 0 queued
       Failed: 5 units
        Since: Sat 2019-09-21 11:06:12 EDT; 2min 50s ago
       CGroup: /
               <E2><94><9C><E2><94><80>1 init -z
               <E2><94><94><E2><94><80>system.slice
                 <E2><94><9C><E2><94><80>pure-ftpd-mysql.service
                 <E2><94><82> <E2><94><94><E2><94><80>893 pure-ftpd (SERVER)
                 <E2><94><9C><E2><94><80>postfix.service
                 <E2><94><82> <E2><94><9C><E2><94><80>1082 /usr/lib/postfix/master
                 <E2><94><82> <E2><94><9C><E2><94><80>1087 pickup -l -t unix -u -c
                 <E2><94><82> <E2><94><9C><E2><94><80>1088 qmgr -l -t unix -u
                 <E2><94><82> <E2><94><9C><E2><94><80>1153 smtpd -n smtp -t inet -u
                 <E2><94><82> <E2><94><9C><E2><94><80>1155 tlsmgr -l -t unix -u -c
                 <E2><94><82> <E2><94><9C><E2><94><80>1156 anvil -l -t unix -u -c
                 <E2><94><82> <E2><94><9C><E2><94><80>1161 smtpd -n smtp -t inet -u
                 <E2><94><82> <E2><94><94><E2><94><80>1167 smtpd -n smtp -t inet -u
                 <E2><94><9C><E2><94><80>console-getty.service
                 <E2><94><82> <E2><94><94><E2><94><80>424 /sbin/agetty --noclear --k
                 <E2><94><9C><E2><94><80>amavis.service
                 <E2><94><82> <E2><94><9C><E2><94><80>1072 /usr/sbin/amavisd-new (ma
    
    [1]+  Stopped                 systemctl status
    
    Code:
     
    [email protected]:~# systemctl --failed
      UNIT                              LOAD   ACTIVE SUB    DESCRIPTION
    <E2><97><8F> proc-sys-fs-binfmt_misc.automount loaded failed failed Arbitrary Executable File Formats File System Automount Point
    <E2><97><8F> bind9.service                     loaded failed failed BIND Domain Name Server
    <E2><97><8F> clamav-daemon.service             loaded failed failed Clam AntiVirus userspace daemon
    <E2><97><8F> clamav-freshclam.service          loaded failed failed ClamAV virus database updater
    <E2><97><8F> haveged.service                   loaded failed failed Entropy daemon using the HAVEGE algorithm
    
    Code:
     
    [email protected]:~# systemctl list-unit-files
    
    UNIT FILE                              STATE
    proc-sys-fs-binfmt_misc.automount      static
    dev-hugepages.mount                    static
    dev-mqueue.mount                       static
    proc-sys-fs-binfmt_misc.mount          static
    sys-fs-fuse-connections.mount          static
    sys-kernel-config.mount                static
    sys-kernel-debug.mount                 static
    tmp.mount                              enabled
    systemd-ask-password-console.path      static
    systemd-ask-password-wall.path         static
    [email protected]                        disabled
    bind9-resolvconf.service               disabled
    bind9.service                          enabled
    bootlogd.service                       masked
    bootlogs.service                       masked
    bootmisc.service                       masked
    checkfs.service                        masked
    checkroot-bootclean.service            masked
    checkroot.service                      masked
    clamav-daemon.service                  enabled
    clamav-freshclam.service               enabled
    console-getty.service                  disabled
    
     
    Last edited: Sep 21, 2019

Share This Page