Error 403 on new web

Discussion in 'Installation/Configuration' started by rfnx, Jun 7, 2024.

Page 4 of 6
  1. rfnx

    rfnx Member

    Damn, now ISPC can no longer be reached, the port is closed!
    What did I do? I only copied the vhost!
    All is still on its place
    upload_2024-6-7_11-17-38.png
     
    rfnx, Jun 7, 2024
    #61
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    To be expected because you did not follow that post to the end! Go back to that other post, read it completely, and execute the remaining commands.
     
    till, Jun 7, 2024
    #62
  3. rfnx

    rfnx Member

    Yah exactly, its back *sigh*

    brb
     
    rfnx, Jun 7, 2024
    #63
  4. ztk.me

    ztk.me Well-Known Member HowtoForge Supporter

    have a good sleep, take a deep breath and do things at a time, if you lose focus, stop.
    maybe it would be better to make backups and start with a fresh install
     
    ztk.me, Jun 7, 2024
    #64
    rfnx likes this.
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    My current guess is that he copy/pasted php config to the apache directives field on the options tab of the website, and maybe some apache config into the custom php.ini settings field. This will result in a non-working vhost file (.err file) plus a failed php-fpm daaemon as php-fpm also doe snot like apache config instead of php.ini settings in its pool file. If my guess is correct, then a reinstall is not needed, just remove the input from that two fields on options tab (or copy it to the right field, if they have been mixed up) and only put valid config there.
     
    till, Jun 7, 2024
    #65
    rfnx and ztk.me like this.
  6. rfnx

    rfnx Member

    Nope! Not again reinstalled a month or two ago!

    Will get that done, ... just need a clear head :confused:
     
    rfnx, Jun 7, 2024
    #66
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    And just to mention it, that .io site has a .err file too, you should check that as well if you added wrong things in apache directives or custom php.ini, the config of the .io site could not be applied since December, last attempt to apply it was two days ago.
     
    till, Jun 7, 2024
    #67
    rfnx and ztk.me like this.
  8. rfnx

    rfnx Member

    Here is the respective Apache Directives:

    upload_2024-6-7_11-35-44.png

    uups!

    Thats php.ini content

    If I remember correctly, the "Custom php.ini settings" field was missing ...

    I moved it to the right field and restarted.

    Now there is also the wiki!

    Thank you both! Great work!

    upload_2024-6-7_11-41-36.png
     
    rfnx, Jun 7, 2024
    #68
    till likes this.
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    The field is always there when you have PHP enabled that uses a mode that supports custom php.ini configurations. So if the field was missing, you either had php disabled or set it not to php-fpm or fastcgi mode.
     
    till, Jun 7, 2024
    #69
    rfnx likes this.
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Restarting was ok but not needed in any way. ISPConfug applies changes automatically; a restart while writing changes could even cause issues, so it is better not to restart manually next time.
     
    till, Jun 7, 2024
    #70
    rfnx likes this.
  11. rfnx

    rfnx Member

    Obviously I was on Fast-CGI o_O

    All is fine now!!! <3
     
    rfnx, Jun 7, 2024
    #71
  12. rfnx

    rfnx Member

    Adaptopedia.com can start its Wiki for Healing Plants soon now!
    THANK YOU !!!

    BTW: I just didnt smk enough of the last months :D
     
    rfnx, Jun 7, 2024
    #72
  13. rfnx

    rfnx Member

    Just a last Question:

    Why do I get the HY000/2002) Error no matter whether localhost, 127.0.0.1 or domain?

    upload_2024-6-7_12-7-28.png
     
    rfnx, Jun 7, 2024
    #73
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    Post the content of the file /etc/hosts from the server.
     
    till, Jun 7, 2024
    #74
  15. rfnx

    rfnx Member

    Code:
    127.0.0.1    localhost
127.0.1.1    hostname.domain.tld    hostname

# The following lines are desirable for IPv6 capable hosts
::1     localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
202.61.255.41    hostname.domain.tld    hostname
    SQL port is open for localhost and remote

    bind-address is excluded in /etc/mysql/mariadb.conf.d/50-server.cnf

    SQL password in usr/local/ispconfig/server/lib/mysql_clientdb.conf is correct
     
    Last edited: Jun 7, 2024
    rfnx, Jun 7, 2024
    #75
  16. rfnx

    rfnx Member

    And here we are why I had to reset te SQL password, this is an endless issue for me!
    I always stuck here in each and every installation!
     
    rfnx, Jun 7, 2024
    #76
  17. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Taleman, Jun 7, 2024
    #77
  18. till

    till Super Moderator Staff Member ISPConfig Developer

    The MySQL password never needs to be reset, at least not unless you gave the cleartext password to someone and want to change it for that reason. Resetting the MySQL root password is also no cure for your connection problem, so doing that does not makes much sens see to me.

    Then you must do something wrong outside of ISPConfig every time again, which causes MySQL to fail. So we should try to find out what that is, so that you do not do that again in future. I'm sure your issues are completely unrelated to ISPconfig or the automated installation, as there would be tens of thousands of systems that would fail like this, which is not the case.

    The hosts file is ok, but not completely right. I would not define the hostname for two IP addresses. Remove the line:

    Code:
    127.0.1.1    hostname.domain.tld    hostname
     
    till, Jun 7, 2024
    #78
  19. rfnx

    rfnx Member

    I really don't know what it is but something on the system i seriously wrong!

    I set back the Hosts file like described in https://www.howtoforge.com/perfect-...cot-ispconfig-3-2/#-configure-thenbsphostname
    It's now

    Code:
    127.0.0.1       localhost.localdomain    localhost
192.168.0.1   hostname.domain.tld hostname

# The following lines are desirable for IPv6 capable hosts
::1     localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
    But I still get the (HY000/2006) error tryin to perform the Mediawiki installation:
    upload_2024-6-8_11-49-42.png
    Same over phpMyadmin, just here a different error code:
    upload_2024-6-8_11-48-0.png


    nmap also shows that the SQL port is closed both inside and outside and it has no effect when I open it via ufw.



    It now does ...
    related to the HowTo:
    https://www.howtoforge.com/perfect-...cot-ispconfig-3-2/#-configure-thenbsphostname


    I have adjusted the host file according to your recommendations:

    .. and restarted but the problem still exists.
    .
    I think I really have to set up the server again if I want to run another site on it with my poor Linux knowledge :(
     
    Last edited: Jun 8, 2024
    rfnx, Jun 8, 2024
    #79
  20. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Taleman, Jun 8, 2024
    #80
Page 4 of 6

Share This Page