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/ ?
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.
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.
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***'; ?>
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
Maybe so, but since you get that error message that line must exist uncommented in some other file that is used when starting services.
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?
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.
Yes because the info I am given, when I try to start apache is: Code: root@martin:~# 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
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'
Iv run the test Code: apache2ctl configtest result Code: Name or service not known: AH00547: Could not resolve host name _default_: -- ignoring! Syntax OK
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?
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 ?
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.
