Port 8080 no longer secure

I cannot get to CP.

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

 

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.

 

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

 

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

 

Yes it is but its already commented out

 

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.

 

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

 

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

 

Iv run the test

Code:

apache2ctl configtest

result

Code:

Name or service not known: AH00547: Could not resolve host name _default_: -- ignoring!
Syntax OK

 

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 ?