So I am getting two separate errors for ISP Config Code: 2018-09-27 00:07 miyagi.gethosting.today Warning 2018-09-27 00:07 miyagi.gethosting.today Warning Let's Encrypt SSL Cert for: orderbaby.com could not be issued. 2018-09-27 00:07 miyagi.gethosting.today Warning Could not verify domain www.orderbaby.com, so excluding it from letsencrypt request. 2018-09-27 00:07 miyagi.gethosting.today Warning Could not verify domain orderbaby.com, so excluding it from letsencrypt request. 2018-09-26 23:55 miyagi.gethosting.today Warning /usr/bin/letsencrypt certonly -n --text --agree-tos --expand --authenticator webroot --server https://acme-v02.api.letsencrypt.org/directory --rsa-key-size 4096 --email [email protected] --domains carnival-funfair.blog --domains www.carnival-funfair.blog --webroot-path /usr/local/ispconfig/interface/acme 2018-09-26 23:55 miyagi.gethosting.today Warning Let's Encrypt SSL Cert for: carnival-funfair.blog could not be issued. 2018-09-26 23:51 miyagi.gethosting.today Warning /usr/bin/letsencrypt certonly -n --text --agree-tos --expand --authenticator webroot --server https://acme-v02.api.letsencrypt.org/directory --rsa-key-size 4096 --email [email protected] --domains carnival-funfair.blog --domains www.carnival-funfair.blog --webroot-path /usr/local/ispconfig/interface/acme 2018-09-26 23:51 miyagi.gethosting.today Warning Let's Encrypt SSL Cert for: carnival-funfair.blog could not be issued. 2018-09-26 23:48 miyagi.gethosting.today Warning /usr/bin/letsencrypt certonly -n --text --agree-tos --expand --authenticator webroot --server https://acme-v02.api.letsencrypt.org/directory --rsa-key-size 4096 --email [email protected] --domains carnival-funfair.blog --domains www.carnival-funfair.blog --webroot-path /usr/local/ispconfig/interface/acme 2018-09-26 23:48 miyagi.gethosting.today Warning Let's Encrypt SSL Cert for: carnival-funfair.blog could not be issued. Code: root@miyagi:~# /usr/local/ispconfig/server/server.sh 27.09.2018-00:11 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 27.09.2018-00:11 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock finished. So I don't know what's going on here exactly... but it is a bit bothersome. I have not been having a goodtime with this mirror setup because of my lack of a proper static IP. but this time it's having issues connecting to the actual hostname... Thanks for any help in advance.
Here is the server.sh output from slave, I must double check this again. I thought at first the errors were because Miyagi was offline? Maybe relevant though... Code: root@daniel-san:~# /usr/local/ispconfig/server/server.sh 27.09.2018-00:13 - WARNING - There is already an instance of server.php running with pid 1320. PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!root@daniel-san:~# ^C root@daniel-san:~# /usr/local/ispconfig/server/server.sh 27.09.2018-00:13 - WARNING - There is already a lockfile set, but no process running with this pid (1320). Continuing. PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 DB::query -> reconnectUnable to load the server configuration from database.PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'miyagi.gethosting.today' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
Code: 27.09.2018-00:49 - DEBUG - Replicated from master: REPLACE INTO `web_domain` (`domain_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`ip_address`,`ipv6_address`,`domain`,`type`,`parent_domain_id`,`vhost_type`,`document_root`,`web_folder`,`system_user`,`system_group`,`hd_quota`,`traffic_quota`,`cgi`,`ssi`,`suexec`,`errordocs`,`is_subdomainwww`,`subdomain`,`php`,`ruby`,`python`,`perl`,`redirect_type`,`redirect_path`,`seo_redirect`,`rewrite_to_https`,`ssl`,`ssl_letsencrypt`,`ssl_letsencrypt_exclude`,`ssl_state`,`ssl_locality`,`ssl_organisation`,`ssl_organisation_unit`,`ssl_country`,`ssl_domain`,`ssl_request`,`ssl_cert`,`ssl_bundle`,`ssl_key`,`ssl_action`,`stats_password`,`stats_type`,`allow_override`,`apache_directives`,`nginx_directives`,`php_fpm_use_socket`,`pm`,`pm_max_children`,`pm_start_servers`,`pm_min_spare_servers`,`pm_max_spare_servers`,`pm_process_idle_timeout`,`pm_max_requests`,`php_open_basedir`,`custom_php_ini`,`backup_interval`,`backup_copies`,`backup_excludes`,`active`,`traffic_quota_lock`,`fastcgi_php_version`,`proxy_directives`,`enable_spdy`,`last_quota_notification`,`rewrite_rules`,`added_date`,`added_by`,`directive_snippets_id`,`enable_pagespeed`,`http_port`,`https_port`,`folder_directive_snippets`,`log_retention`) VALUES ('37','1','3','riud','ru','',3,'*','','meet.gethosting.today','vhost','0','name','/var/www/clients/client1/web37','','web37','client1','-1','-1','n','n','y','1','1','www','php-fpm','n','n','n','','','','y','y','y','n','','','','','CK','meet.gethosting.today','','','','','',NULL,'awstats','All','SSLProxyEngine on\r\n\r\nSSLProtocol All TLSv1 TLSv1.1 TLSv1.2 -SSLv2 -SSLv3 \r\nSSLHonorCipherOrder on\r\n\r\nSSLCipherSuite \"EECDH+ECDSA+AESGCM:EECDH+aRSA+AESGCM:EECDH+ECDSA+SHA256:EECDH+aRSA+SHA256:EECDH+ECDSA+SHA384:EECDH+ECDSA+SHA256:EECDH+aRSA+SHA384:EDH+aRSA+AESGCM:EDH+aRSA+SHA256:EDH+aRSA:EECDH:!ECDH:!aNULL:!eNULL:!MEDIUM:!LOW:!3DES:!MD5:!EXP:!PSK:!SRP:!DSS:!RC4:!SEED\"\r\n\r\nHeader set Strict-Transport-Security \"max-age=31536000\"\r\n\r\nDocumentRoot \"/usr/share/jitsi-meet\"\r\n\r\n<Directory \"/usr/share/jitsi-meet\">\r\n Options Indexes MultiViews Includes FollowSymLinks\r\n AddOutputFilter Includes html\r\n AllowOverride All\r\n Order allow,deny\r\n Allow from all\r\n </Directory>\r\n\r\nErrorDocument 404 /static/404.html\r\n\r\n Alias \"/config.js\" \"/etc/jitsi/meet/meet.gethosting.today-config.js\"\r\n <Location /config.js>\r\n Require all granted\r\n </Location>\r\n\r\nProxyPreserveHost on\r\n ProxyPass /http-bind http://localhost:5280/http-bind/\r\n ProxyPassReverse /http-bind http://localhost:5280/http-bind/\r\n\r\n\r\n RewriteEngine on\r\n RewriteRule ^/([a-zA-Z0-9]+)$ /index.html','','y','dynamic','10','2','1','5','10','0','/var/www/clients/client1/web37/web:/var/www/clients/client1/web37/private:/var/www/clients/client1/web37/tmp:/var/www/meet.gethosting.today/web:/srv/www/meet.gethosting.today/web:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin:/dev/random:/dev/urandom','','none','1',NULL,'y','n','','','n',NULL,'','2018-09-24','admin','0','n','80','443',NULL,'10') 27.09.2018-00:49 - DEBUG - Calling function 'ssl' from plugin 'apache2_plugin' raised by event 'web_domain_update'. 27.09.2018-00:49 - DEBUG - Calling function 'update' from plugin 'apache2_plugin' raised by event 'web_domain_update'. 27.09.2018-00:49 - DEBUG - Writing the vhost file: /etc/apache2/sites-available/meet.gethosting.today.vhost 27.09.2018-00:49 - DEBUG - Writing the PHP-FPM config file: /etc/php/7.2/fpm/pool.d/web37.conf 27.09.2018-00:49 - DEBUG - Calling function 'restartPHP_FPM' from module 'web_module'. 27.09.2018-00:49 - DEBUG - Restarting php-fpm: systemctl reload php7.2-fpm.service 27.09.2018-00:49 - DEBUG - Apache status is: running 27.09.2018-00:49 - DEBUG - Calling function 'restartHttpd' from module 'web_module'. 27.09.2018-00:49 - DEBUG - Restarting httpd: systemctl restart apache2.service 27.09.2018-00:49 - DEBUG - Apache restart return value is: 0 27.09.2018-00:49 - DEBUG - Apache online status after restart is: running 27.09.2018-00:49 - DEBUG - Processed datalog_id 1311 27.09.2018-00:49 - DEBUG - Replicated from master: REPLACE INTO `web_domain` (`domain_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`ip_address`,`ipv6_address`,`domain`,`type`,`parent_domain_id`,`vhost_type`,`document_root`,`web_folder`,`system_user`,`system_group`,`hd_quota`,`traffic_quota`,`cgi`,`ssi`,`suexec`,`errordocs`,`is_subdomainwww`,`subdomain`,`php`,`ruby`,`python`,`perl`,`redirect_type`,`redirect_path`,`seo_redirect`,`rewrite_to_https`,`ssl`,`ssl_letsencrypt`,`ssl_letsencrypt_exclude`,`ssl_state`,`ssl_locality`,`ssl_organisation`,`ssl_organisation_unit`,`ssl_country`,`ssl_domain`,`ssl_request`,`ssl_cert`,`ssl_bundle`,`ssl_key`,`ssl_action`,`stats_password`,`stats_type`,`allow_override`,`apache_directives`,`nginx_directives`,`php_fpm_use_socket`,`pm`,`pm_max_children`,`pm_start_servers`,`pm_min_spare_servers`,`pm_max_spare_servers`,`pm_process_idle_timeout`,`pm_max_requests`,`php_open_basedir`,`custom_php_ini`,`backup_interval`,`backup_copies`,`backup_excludes`,`active`,`traffic_quota_lock`,`fastcgi_php_version`,`proxy_directives`,`enable_spdy`,`last_quota_notification`,`rewrite_rules`,`added_date`,`added_by`,`directive_snippets_id`,`enable_pagespeed`,`http_port`,`https_port`,`folder_directive_snippets`,`log_retention`) VALUES ('37','1','3','riud','ru','',3,'*','','meet.gethosting.today','vhost','0','name','/var/www/clients/client1/web37','','web37','client1','-1','-1','n','n','y','1','1','www','php-fpm','n','n','n','','','','y','y','y','n','','','','','CK','meet.gethosting.today','','','','','',NULL,'awstats','All','SSLProxyEngine on\r\n\r\nSSLProtocol TLSv1 TLSv1.1 TLSv1.2\r\nSSLHonorCipherOrder on\r\n\r\nSSLCipherSuite \"EECDH+ECDSA+AESGCM:EECDH+aRSA+AESGCM:EECDH+ECDSA+SHA256:EECDH+aRSA+SHA256:EECDH+ECDSA+SHA384:EECDH+ECDSA+SHA256:EECDH+aRSA+SHA384:EDH+aRSA+AESGCM:EDH+aRSA+SHA256:EDH+aRSA:EECDH:!ECDH:!aNULL:!eNULL:!MEDIUM:!LOW:!3DES:!MD5:!EXP:!PSK:!SRP:!DSS:!RC4:!SEED\"\r\n\r\nHeader set Strict-Transport-Security \"max-age=31536000\"\r\n\r\nDocumentRoot \"/usr/share/jitsi-meet\"\r\n\r\n<Directory \"/usr/share/jitsi-meet\">\r\n Options Indexes MultiViews Includes FollowSymLinks\r\n AddOutputFilter Includes html\r\n AllowOverride All\r\n Order allow,deny\r\n Allow from all\r\n </Directory>\r\n\r\nErrorDocument 404 /static/404.html\r\n\r\n Alias \"/config.js\" \"/etc/jitsi/meet/meet.gethosting.today-config.js\"\r\n <Location /config.js>\r\n Require all granted\r\n </Location>\r\n\r\nProxyPreserveHost on\r\n ProxyPass /http-bind http://localhost:5280/http-bind/\r\n ProxyPassReverse /http-bind http://localhost:5280/http-bind/\r\n\r\n\r\n RewriteEngine on\r\n RewriteRule ^/([a-zA-Z0-9]+)$ /index.html','','y','dynamic','10','2','1','5','10','0','/var/www/clients/client1/web37/web:/var/www/clients/client1/web37/private:/var/www/clients/client1/web37/tmp:/var/www/meet.gethosting.today/web:/srv/www/meet.gethosting.today/web:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin:/dev/random:/dev/urandom','','none','1',NULL,'y','n','','','n',NULL,'','2018-09-24','admin','0','n','80','443',NULL,'10') 27.09.2018-00:49 - DEBUG - Calling function 'ssl' from plugin 'apache2_plugin' raised by event 'web_domain_update'. 27.09.2018-00:49 - DEBUG - Calling function 'update' from plugin 'apache2_plugin' raised by event 'web_domain_update'. 27.09.2018-00:49 - DEBUG - Writing the vhost file: /etc/apache2/sites-available/meet.gethosting.today.vhost 27.09.2018-00:49 - DEBUG - Writing the PHP-FPM config file: /etc/php/7.2/fpm/pool.d/web37.conf 27.09.2018-00:49 - DEBUG - Calling function 'restartPHP_FPM' from module 'web_module'. 27.09.2018-00:49 - DEBUG - Restarting php-fpm: systemctl reload php7.2-fpm.service 27.09.2018-00:49 - DEBUG - Apache status is: running 27.09.2018-00:49 - DEBUG - Calling function 'restartHttpd' from module 'web_module'. 27.09.2018-00:49 - DEBUG - Restarting httpd: systemctl restart apache2.service 27.09.2018-00:49 - DEBUG - Apache restart return value is: 0 27.09.2018-00:49 - DEBUG - Apache online status after restart is: running 27.09.2018-00:49 - DEBUG - Processed datalog_id 1313 Just rebooted my servers, and now my slave is giving me this, over and over, with varying degrees of accuracy. Though this might be cause for a separate thread.
Thought I posted the log... Sorry, was just after class I posted this and was half asleep. https://pastebin.com/k2TtPHz1 Not the entire log, but back until the 26th somewhat, when it was still working. if you want/need the FULL log, I will grab it. @ahrasis So my LE is disabled from what I understood from that page?
As I read some or most of your domains' renewal conf are broken but I am not sure why. The easiest way is to delete all the broken ones and reissue new certs for them. Note renewal not due warnings are actually normal and not an error. With regards to your post #2 above, I think that are access problems. Retrace and check whether you have created proper access from your cluster server as prescribed in the tutorial(s). I am not sure about your post #3 though but try https://www.howtoforge.com/community/threads/please-read-before-posting.58408/.
I only have about eleven domains hosted. Would you agree with my conclusion, that for simplicity sake, I uninstall all certs and confs and reissue them all from start? It seems to me like uncertifying all the domains and clearing their confs and certs from let's encrypts directories seems most sensible, to ensure no errors are encountered, or to suss out further errors. I figured out about post #2... that SOME thing, keeps rewriting my /etc/hosts file so that all the ips that are pointed to miyagi from daniel-san, are rewritten to daniel-san itself instead of miyagi. This is the second time I've had to fix it. I will open a new thread for getting help with my mirror. All users are setup, as according to the tutorial. It was after I fixed my /etc/hosts that post #3 became the apparent result. I will open a new thread for it after re-reading the please-read-before-posting thread again.