Port 8080 no longer secure

Discussion in 'ISPConfig 3 Priority Support' started by mrbronz, Apr 13, 2021.

  1. mrbronz

    mrbronz Member HowtoForge Supporter

    I cannot get to CP.

    I have just checked and Apache has stopped and I can not get it to start
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Read apache error log.
    Try starting apache and see what errors you get:
    Code:
    systemctl start apache2
    systemctl status apache2
    Are there failing websites, with .err in the vhost filename in /etc/apache/sites-enabled/ ?
     
  3. mrbronz

    mrbronz Member HowtoForge Supporter

    I've done that but it won't start

    Code:
    Job for apache2.service failed because the control process exited with error code.
    error:
    Code:
    Apr 14 12:31:23 martin systemd[1]: Starting The Apache HTTP Server...
    Apr 14 12:31:23 martin apachectl[1125]: AH00548: NameVirtualHost has no effect and will be removed in the next release /etc/apache2/sites-enabled/000-ispconfig.vhost:7
    Apr 14 12:31:24 martin apachectl[1125]: Action 'start' failed.
    Apr 14 12:31:24 martin apachectl[1125]: The Apache error log may have more information.
    Apr 14 12:31:24 martin systemd[1]: apache2.service: Control process exited, code=exited, status=1/FAILURE
    Apr 14 12:31:24 martin systemd[1]: apache2.service: Failed with result 'exit-code'.
    Apr 14 12:31:24 martin systemd[1]: Failed to start The Apache HTTP Server.
    
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely you removed the SSL cert somehow, maybe this happened due to using acme.sh manually. Do an ispconfig update:

    ispconfig_update.sh --force

    and let the updater create a new ssl cert.
     
  5. mrbronz

    mrbronz Member HowtoForge Supporter

    I'm getting an error

    Code:
    Unable to call mysql command line with credentials from mysql_clientdb.conf
    I've checked this file and the credentials are correct

    Code:
    <?php
    $clientdb_host          = 'localhost';
    $clientdb_user          = 'root';
    $clientdb_password      = '****password***'; 
    ?>
    
     
  6. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Can you log in to the database as root with those credentials using
    Code:
    mysql -u root -p
     
  7. mrbronz

    mrbronz Member HowtoForge Supporter

    Im getting

    Code:
    mysql: unknown variable 'general_log_file=/var/log/mysql/mysql.log'
    Where is this error coming from, Im assuming that

    Code:
    /etc/mysql/mariadb.conf.d/50-server.cnf
    is what is being used
     
    Last edited: Apr 14, 2021
  8. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Is that error line in that file? In some other file?
    On my host that line is commented out with #.
     
  9. mrbronz

    mrbronz Member HowtoForge Supporter

    Yes it is but its already commented out
     
  10. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Maybe so, but since you get that error message that line must exist uncommented in some other file that is used when starting services.
     
  11. mrbronz

    mrbronz Member HowtoForge Supporter

    But that's a problem because I have no idea of where to look, I have done a search for every instance that line is mentioned so it could take a while to get the correct source file.
    However, if I have not changed anything how could this suddenly be a problem?
     
  12. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Try 'grep -R general_log_file /etc/mysql/'
     
  13. mrbronz

    mrbronz Member HowtoForge Supporter

    Thank you for that

    I found it at the bottom of
    Code:
    /etc/mysql/mariadb.cnf
    However, after commenting the line out, this allowed me to use the SQL credential and also to run the ispconfig_update.sh --force command.

    However, Apache will not start.
     
  14. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Did you go back to #22 and examine the errors?
     
  15. mrbronz

    mrbronz Member HowtoForge Supporter

    Yes because the info I am given, when I try to start apache is:

    Code:
    [email protected]:~# systemctl start apache2
    Job for apache2.service failed because the control process exited with error code.
    See "systemctl status apache2.service" and "journalctl -xe" for details.
    
    The results are as follows
    Code:
    # systemctl status apache2.service
    ● apache2.service - The Apache HTTP Server
       Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
       Active: failed (Result: exit-code) since Thu 2021-04-15 11:31:08 BST; 3min 18s ago
         Docs: https://httpd.apache.org/docs/2.4/
      Process: 1456 ExecStart=/usr/sbin/apachectl start (code=exited, status=1/FAILURE)
    
    Apr 15 11:31:07 martin systemd[1]: Starting The Apache HTTP Server...
    Apr 15 11:31:07 martin apachectl[1456]: AH00548: NameVirtualHost has no effect and will be removed in the next release /etc/apache2/sites-enabled/000-ispconfig.vhost/ispcon
    Apr 15 11:31:08 martin apachectl[1456]: Action 'start' failed.
    Apr 15 11:31:08 martin apachectl[1456]: The Apache error log may have more information.
    Apr 15 11:31:08 martin systemd[1]: apache2.service: Control process exited, code=exited, status=1/FAILURE
    Apr 15 11:31:08 martin systemd[1]: apache2.service: Failed with result 'exit-code'.
    Apr 15 11:31:08 martin systemd[1]: Failed to start The Apache HTTP Server.
    
    Code:
    # journalctl -xe
    Apr 15 11:39:30 martin postfix/smtpd[1676]: connect from unknown[141.98.10.136]
    Apr 15 11:39:32 martin postfix/smtpd[1676]: warning: unknown[141.98.10.136]: SASL LOGIN authentication failed: UGFzc3dvcmQ6
    Apr 15 11:39:32 martin postfix/smtpd[1676]: disconnect from unknown[141.98.10.136] ehlo=1 auth=0/1 quit=1 commands=2/3
    Apr 15 11:39:54 martin postfix/smtpd[1297]: connect from unknown[45.133.1.131]
    Apr 15 11:39:56 martin postfix/smtpd[1297]: warning: unknown[45.133.1.131]: SASL LOGIN authentication failed: UGFzc3dvcmQ6
    Apr 15 11:39:56 martin postfix/smtpd[1297]: disconnect from unknown[45.133.1.131] ehlo=1 auth=0/1 quit=1 commands=2/3
    Apr 15 11:40:01 martin systemd[1]: Starting The Apache HTTP Server...
    -- Subject: A start job for unit apache2.service has begun execution
    -- Defined-By: systemd
    -- Support: https://www.debian.org/support
    --
    -- A start job for unit apache2.service has begun execution.
    --
    -- The job identifier is 19524.
    Apr 15 11:40:01 martin apachectl[1851]: AH00548: NameVirtualHost has no effect and will be removed in the next release /etc/apache2/sites-enabled/000-ispconfig.vhost/ispcon
    Apr 15 11:40:01 martin apachectl[1851]: Action 'start' failed.
    Apr 15 11:40:01 martin apachectl[1851]: The Apache error log may have more information.
    Apr 15 11:40:01 martin systemd[1]: apache2.service: Control process exited, code=exited, status=1/FAILURE
    -- Subject: Unit process exited
    -- Defined-By: systemd
    -- Support: https://www.debian.org/support
    --
    -- An ExecStart= process belonging to unit apache2.service has exited.
    --
    -- The process' exit code is 'exited' and its exit status is 1.
    Apr 15 11:40:01 martin CRON[1884]: pam_unix(cron:session): session opened for user root by (uid=0)
    Apr 15 11:40:01 martin CRON[1886]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; don
    Apr 15 11:40:01 martin systemd[1]: apache2.service: Failed with result 'exit-code'.
    -- Subject: Unit failed
    -- Defined-By: systemd
    -- Support: https://www.debian.org/support
    --
    -- The unit apache2.service has entered the 'failed' state with result 'exit-code'.
    Apr 15 11:40:01 martin CRON[1883]: pam_unix(cron:session): session opened for user root by (uid=0)
    Apr 15 11:40:01 martin systemd[1]: Failed to start The Apache HTTP Server.
    -- Subject: A start job for unit apache2.service has failed
    -- Defined-By: systemd
    -- Support: https://www.debian.org/support
    --
    -- A start job for unit apache2.service has finished with a failure.
    --
    -- The job identifier is 19524 and the job result is failed.
    Apr 15 11:40:01 martin CRON[1885]: pam_unix(cron:session): session opened for user getmail by (uid=0)
    Apr 15 11:40:01 martin CRON[1890]: (getmail) CMD (/usr/local/bin/run-getmail.sh > /dev/null 2>> /dev/null)
    Apr 15 11:40:01 martin CRON[1889]: (root) CMD (/usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done)
    Apr 15 11:40:01 martin CRON[1885]: pam_unix(cron:session): session closed for user getmail
    Apr 15 11:40:01 martin CRON[1884]: pam_unix(cron:session): session closed for user root
    
    Code:
    [ 2021-04-15 11:39:16.8007 1822/7fc50374a700 Ser/Server.h:464 ]: [UstRouter] Shutdown finished
    [ 2021-04-15 11:39:16.8007 1822/7fc502ec8700 Ser/Server.h:817 ]: [UstRouterApiServer] Freed 0 spare client objects
    [ 2021-04-15 11:39:16.8008 1822/7fc502ec8700 Ser/Server.h:464 ]: [UstRouterApiServer] Shutdown finished
    [ 2021-04-15 11:39:16.8008 1817/7fa2bf5be700 Ser/Server.h:817 ]: [ServerThr.2] Freed 128 spare client objects
    [ 2021-04-15 11:39:16.8008 1817/7fa2bf5be700 Ser/Server.h:464 ]: [ServerThr.2] Shutdown finished
    [ 2021-04-15 11:39:16.8012 1817/7fa2bed3c700 Ser/Server.h:817 ]: [ApiServer] Freed 0 spare client objects
    [ 2021-04-15 11:39:16.8012 1817/7fa2bed3c700 Ser/Server.h:464 ]: [ApiServer] Shutdown finished
    [ 2021-04-15 11:39:16.8017 1822/7fc503849980 age/Ust/UstRouterMain.cpp:523 ]: Passenger UstRouter shutdown finished
    [ 2021-04-15 11:39:16.8441 1817/7fa2c0779980 age/Cor/CoreMain.cpp:967 ]: Passenger core shutdown finished
    [ 2021-04-15 11:40:01.3828 1856/7f5a88d32980 age/Wat/WatchdogMain.cpp:1291 ]: Starting Passenger watchdog...
    [ 2021-04-15 11:40:01.3981 1859/7fe6e4c7d980 age/Cor/CoreMain.cpp:982 ]: Starting Passenger core...
    [ 2021-04-15 11:40:01.3982 1859/7fe6e4c7d980 age/Cor/CoreMain.cpp:235 ]: Passenger core running in multi-application mode.
    [ 2021-04-15 11:40:01.3995 1859/7fe6e4c7d980 age/Cor/CoreMain.cpp:732 ]: Passenger core online, PID 1859
    [ 2021-04-15 11:40:01.4149 1864/7f14178a0980 age/Ust/UstRouterMain.cpp:529 ]: Starting Passenger UstRouter...
    [ 2021-04-15 11:40:01.4168 1864/7f14178a0980 age/Ust/UstRouterMain.cpp:342 ]: Passenger UstRouter online, PID 1864
    AH00016: Configuration Failed
    
    [ 2021-04-15 11:40:01.4412 1864/7f14177a1700 age/Ust/UstRouterMain.cpp:422 ]: Signal received. Gracefully shutting down... (send signal 2 more time(s) to force shutdown)
    [ 2021-04-15 11:40:01.4413 1864/7f14178a0980 age/Ust/UstRouterMain.cpp:492 ]: Received command to shutdown gracefully. Waiting until all clients have disconnected...
    [ 2021-04-15 11:40:01.4413 1864/7f1416f1f700 Ser/Server.h:817 ]: [UstRouterApiServer] Freed 0 spare client objects
    [ 2021-04-15 11:40:01.4413 1864/7f1416f1f700 Ser/Server.h:464 ]: [UstRouterApiServer] Shutdown finished
    [ 2021-04-15 11:40:01.4416 1864/7f14177a1700 Ser/Server.h:464 ]: [UstRouter] Shutdown finished
    [ 2021-04-15 11:40:01.4417 1864/7f14178a0980 age/Ust/UstRouterMain.cpp:523 ]: Passenger UstRouter shutdown finished
    
    [ 2021-04-15 11:40:01.4424 1859/7fe6e4344700 age/Cor/CoreMain.cpp:532 ]: Signal received. Gracefully shutting down... (send signal 2 more time(s) to force shutdown)
    [ 2021-04-15 11:40:01.4424 1859/7fe6e4c7d980 age/Cor/CoreMain.cpp:901 ]: Received command to shutdown gracefully. Waiting until all clients have disconnected...
    [ 2021-04-15 11:40:01.4425 1859/7fe6e4344700 Ser/Server.h:817 ]: [ServerThr.1] Freed 128 spare client objects
    [ 2021-04-15 11:40:01.4426 1859/7fe6e4344700 Ser/Server.h:464 ]: [ServerThr.1] Shutdown finished
    [ 2021-04-15 11:40:01.4427 1859/7fe6e3ac2700 Ser/Server.h:817 ]: [ServerThr.2] Freed 128 spare client objects
    [ 2021-04-15 11:40:01.4427 1859/7fe6e3ac2700 Ser/Server.h:464 ]: [ServerThr.2] Shutdown finished
    [ 2021-04-15 11:40:01.4428 1859/7fe6e3240700 Ser/Server.h:817 ]: [ApiServer] Freed 0 spare client objects
    [ 2021-04-15 11:40:01.4428 1859/7fe6e3240700 Ser/Server.h:464 ]: [ApiServer] Shutdown finished
    
    [ 2021-04-15 11:40:01.4496 1859/7fe6e4344700 age/Cor/CoreMain.cpp:532 ]: Signal received. Gracefully shutting down... (send signal 1 more time(s) to force shutdown)
    [ 2021-04-15 11:40:01.4817 1859/7fe6e4c7d980 age/Cor/CoreMain.cpp:967 ]: Passenger core shutdown finished
    
    I cannot see anything obvious that standout that would help me to get the apache server to start


    [edit]
    Thought I would throw the apache error log in for good measure
    Code:
    [ 2021-04-15 13:45:33.0408 7470/7f6c00721980 age/Wat/WatchdogMain.cpp:1291 ]: Starting Passenger watchdog...
    [ 2021-04-15 13:45:33.0550 7473/7f218bcf9980 age/Cor/CoreMain.cpp:982 ]: Starting Passenger core...
    [ 2021-04-15 13:45:33.0552 7473/7f218bcf9980 age/Cor/CoreMain.cpp:235 ]: Passenger core running in multi-application mode.
    [ 2021-04-15 13:45:33.0566 7473/7f218bcf9980 age/Cor/CoreMain.cpp:732 ]: Passenger core online, PID 7473
    [ 2021-04-15 13:45:33.0787 7478/7fc2fa5b4980 age/Ust/UstRouterMain.cpp:529 ]: Starting Passenger UstRouter...
    [ 2021-04-15 13:45:33.0816 7478/7fc2fa5b4980 age/Ust/UstRouterMain.cpp:342 ]: Passenger UstRouter online, PID 7478
    AH00016: Configuration Failed
    
    [ 2021-04-15 13:45:33.1137 7473/7f218b3c0700 age/Cor/CoreMain.cpp:532 ]: Signal received. Gracefully shutting down... (send signal 2 more time(s) to force shutdown)
    [ 2021-04-15 13:45:33.1141 7473/7f218bcf9980 age/Cor/CoreMain.cpp:901 ]: Received command to shutdown gracefully. Waiting until all clients have disconnected...
    [ 2021-04-15 13:45:33.1143 7473/7f218ab3e700 Ser/Server.h:817 ]: [ServerThr.2] Freed 128 spare client objects
    [ 2021-04-15 13:45:33.1143 7473/7f218ab3e700 Ser/Server.h:464 ]: [ServerThr.2] Shutdown finished
    [ 2021-04-15 13:45:33.1147 7473/7f218a2bc700 Ser/Server.h:817 ]: [ApiServer] Freed 0 spare client objects
    [ 2021-04-15 13:45:33.1147 7473/7f218a2bc700 Ser/Server.h:464 ]: [ApiServer] Shutdown finished
    [ 2021-04-15 13:45:33.1150 7473/7f218b3c0700 Ser/Server.h:817 ]: [ServerThr.1] Freed 128 spare client objects
    [ 2021-04-15 13:45:33.1150 7473/7f218b3c0700 Ser/Server.h:464 ]: [ServerThr.1] Shutdown finished
    
    [ 2021-04-15 13:45:33.1157 7478/7fc2fa4b5700 age/Ust/UstRouterMain.cpp:422 ]: Signal received. Gracefully shutting down... (send signal 2 more time(s) to force shutdown)
    [ 2021-04-15 13:45:33.1158 7478/7fc2fa5b4980 age/Ust/UstRouterMain.cpp:492 ]: Received command to shutdown gracefully. Waiting until all clients have disconnected...
    [ 2021-04-15 13:45:33.1159 7478/7fc2f9c33700 Ser/Server.h:817 ]: [UstRouterApiServer] Freed 0 spare client objects
    [ 2021-04-15 13:45:33.1159 7478/7fc2f9c33700 Ser/Server.h:464 ]: [UstRouterApiServer] Shutdown finished
    [ 2021-04-15 13:45:33.1161 7478/7fc2fa4b5700 Ser/Server.h:464 ]: [UstRouter] Shutdown finished
    [ 2021-04-15 13:45:33.1169 7478/7fc2fa5b4980 age/Ust/UstRouterMain.cpp:523 ]: Passenger UstRouter shutdown finished
    
    [ 2021-04-15 13:45:33.1255 7473/7f218b3c0700 age/Cor/CoreMain.cpp:532 ]: Signal received. Gracefully shutting down... (send signal 1 more time(s) to force shutdown)
    [ 2021-04-15 13:45:33.1575 7473/7f218bcf9980 age/Cor/CoreMain.cpp:967 ]: Passenger core shutdown finished
     
    Last edited: Apr 15, 2021
  16. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    That may be all. I believe apachectl has a config test, I don't remember which option it is, but it might give an indication of the problem.

    Edit: it is 'apachectl -t'
     
    Last edited: Apr 15, 2021
  17. mrbronz

    mrbronz Member HowtoForge Supporter

    Iv run the test
    Code:
    apache2ctl configtest
    result
    Code:
    Name or service not known: AH00547: Could not resolve host name _default_: -- ignoring!
    Syntax OK
    
     
  18. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    the apache error log has different timestamp than your other logs (by a couple hours), does anything different show up in the error log if you attempt to start apache again?
     
  19. mrbronz

    mrbronz Member HowtoForge Supporter

    Is there a way to remove all websites so I can rebuild them including ISPC3?
    I not getting anywhere with this?

    Is it possible to just remove all sites in sites-available sites-enabled then reinstall ?
     
  20. till

    till Super Moderator Staff Member ISPConfig Developer

    It's not very likely that your issue is related to websites. You made changes to the ispconfig SSL cert, so the most likely reason is that you accidentially removed the iSPConfig SSL cert. Run an ISPConfig update as I mentioned earlier, your MySQL must be started at that time of course, so do not do the update before you fixed your mysql issue.
     

Share This Page