Installing ISPConfig via proxy

Discussion in 'Installation/Configuration' started by asgare, Dec 11, 2022.

  1. asgare

    asgare Member

    Hi everyone
    Almost for two months, I have been challenged with auto-installer. I am reminding you that I am trying to install this system in high censorship location. Most apps band here, even if you can't update any OS or antivirus.

    What I did,
    First, I made a VPN server (v2ray protocol ) via German VPS. Then on a brand new Debian 11, I installed Xray to connect it to VPN. Finally proxied via the Proxychain app to bypass the filtering. This scenario took me two months because VPN technology changed rapidly here and also connecting the VPN through the command line was a big problem for me.

    Here is an example of how I ran a command:
    First, that service must be running via Xray:
    upload_2022-12-11_13-5-15.png

    Then in another session, I must run a service with the prefix command "proxychains". Like this:
    upload_2022-12-11_13-8-45.png

    Monitoring the proxy on another window
    upload_2022-12-11_13-9-40.png

    I checked this proxy system multiple times because all of the apps previously won't be installed without this.


    ok

    Now I'm trying to install the ISPConfig.

    First command:
    Code:
    wget -O - https://get.ispconfig.org | sh -s -- --help
    Again error:
    upload_2022-12-11_13-13-59.png

    Code:
    PHP cli missing, trying to install.
    E: The repository 'http://deb.debian.org bullseye-security Release' does not have a Release file.
    PHP cli is missing. Please install package php-cli.
     
  2. asgare

    asgare Member

    Even though I update my source list to solve this issue but still nothing
    upload_2022-12-11_13-52-6.png
     
  3. asgare

    asgare Member

    till
    Please make manual installation
    The manual installation gives us the opportunity. Also to solve problems as we go through them step by step.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    You can just use the manual Debian 10 perfect server guide. It still works fine on Debian 11. You just have to replace PHP 7.3 with 7.4 in package names and when a different package is not found, just use 'apt-cache search' command to check what it's new name is, e.g. getmail4 changed to getmail6. So no rocket science.
     
  5. asgare

    asgare Member

    I remember I did as you said but at the first stage, on installation, it gave me an error for the app "getmail4". When I installed that gave me an error which needs version 4.

    Please give a recommendation on that.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    I answered this already above. When a package is not there, then you use apt-cache search command. so you use:

    apt-cache search getmail

    which returns to you that getmail package name is now getmail6. Then you replace getmail4 in the apt install command with getmail6, that's all. So that's all really simple.
     
  7. asgare

    asgare Member

    Two questions:
    1. In your idea why after passing the proxy again I received this error?
    Code:
    PHP cli missing, trying to install.
    E: The repository 'http://deb.debian.org bullseye-security Release' does not have a Release file.
    PHP cli is missing. Please install package php-cli.
    2. What will be the update of this command for Debian 11?
    Code:
    apt-get -y install apache2 apache2-doc apache2-utils libapache2-mod-php php7.3 php7.3-common php7.3-gd php7.3-mysql php7.3-imap php7.3-cli php7.3-cgi libapache2-mod-fcgid apache2-suexec-pristine php-pear mcrypt  imagemagick libruby libapache2-mod-python php7.3-curl php7.3-intl php7.3-pspell php7.3-recode php7.3-sqlite3 php7.3-tidy php7.3-xmlrpc php7.3-xsl memcached php-memcache php-imagick php-gettext php7.3-zip php7.3-mbstring memcached libapache2-mod-passenger php7.3-soap php7.3-fpm php7.3-opcache php-apcu libapache2-reload-perl

    BDW, this command:
    Code:
    echo "update mysql.user set plugin = 'mysql_native_password' where user='root';" | mysql -u root
    Gave me bellow error:
    Code:
     echo "update mysql.user set plugin = 'mysql_native_password' where user='root';" | mysql -u root
    ERROR 1356 (HY000) at line 1: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
    How should I run this command inside MySQL after logging in?
     
  8. pyte

    pyte Well-Known Member HowtoForge Supporter

    Your "/etc/apt/source.list" seems to contain invalid entries. The string should most likly look like this "deb http://security.debian.org/debian-security bullseye-security main contrib" +non-free at the end if you want them to be enabled.

    You can post your "/etc/apt/source.list", so we can have a look into it.

    Don't blindly copy stuff from the web. "mysql.user" is a view rather than a table since version 10.X. What your most likly looking for is "SET PASSWORD" or "ALTER USER". This should do the trick:

    Code:
    ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'XXXXXXXXXXX';
    
    FLUSH PRIVILEGES;
    
     
    till likes this.
  9. asgare

    asgare Member

    First, thank you for advising me on Wireguard. I installed and my system has shown me it is connected but I tried for two weeks and couldn't bypass the filtering. Finally, I did it via V2ray. Even V2ray has the ability to use Wireguard within but I am not good at the configuration of that.

    This is my source list. I add some extra records to have more mirrors but it seems won't work for me. I don't know.
    Code:
    deb http://deb.debian.org/debian bullseye main
    deb-src http://deb.debian.org/debian bullseye main
    
    deb http://deb.debian.org/debian-security/ bullseye-security main
    deb-src http://deb.debian.org/debian-security/ bullseye-security main
    
    deb http://deb.debian.org/debian bullseye-updates main
    deb-src http://deb.debian.org/debian bullseye-updates main
    deb http://deb.debian.org/debian bullseye-backports main contrib non-free
    deb-src http://deb.debian.org/debian bullseye-backports main contrib non-free
    # deb cdrom:[Debian GNU/Linux 11.5.0 _Bullseye_ - Official amd64 DVD Binary-1 20220910-10:40]/ bullseye contrib main
    
    deb [arch=all] http://ftp.us.debian.org/debian/ bullseye main contrib non-free
    deb-src [arch=all] http://ftp.us.debian.org/debian/ bullseye main contrib non-free
    
    deb [arch=all] http://ftp.us.debian.org/debian/ bullseye-updates main contrib non-free
    deb-src [arch=all] http://ftp.us.debian.org/debian/ bullseye-updates main contrib non-free
    
    deb [arch=all] http://deb.debian.org/ bullseye-security main contrib non-free
    deb-src [arch=all] http://deb.debian.org/ bullseye-security main contrib non-free
    #deb cdrom:[Debian GNU/Linux 11.5.0 _Bullseye_ - Official amd64 DVD Binary-1 20220910-10:40]/ bullseye contrib main
    
    deb http://ftp.linux.org.tr/debian/ bullseye main
    deb-src http://ftp.linux.org.tr/debian/ bullseye main
    
    deb http://security.debian.org/debian-security bullseye-security main contrib
    deb-src http://security.debian.org/debian-security bullseye-security main contrib
    
    # bullseye-updates, to get updates before a point release is made;
    # see https://www.debian.org/doc/manuals/debian-reference/ch02.en.html#_updates_and_backports
    deb http://ftp.linux.org.tr/debian/ bullseye-updates main contrib
    deb-src http://ftp.linux.org.tr/debian/ bullseye-updates main contrib
    ##############Iran
    deb [arch=amd64] http://ftp.ir.debian.org/debian/ bullseye main contrib non-free
    deb-src [arch=amd64] http://ftp.ir.debian.org/debian/ bullseye main contrib non-free
    
    deb [arch=amd64] http://ftp.ir.debian.org/debian/ bullseye-updates main contrib non-free
    deb-src [arch=amd64] http://ftp.ir.debian.org/debian/ bullseye-updates main contrib non-free
    
    ######## Netherland
    deb [arch=amd64] http://ftp.nl.debian.org/debian/ bullseye main contrib non-free
    deb-src [arch=amd64] http://ftp.nl.debian.org/debian/ bullseye main contrib non-free
    
    deb [arch=amd64] http://ftp.nl.debian.org/debian/ bullseye-updates main contrib non-free
    deb-src [arch=amd64] http://ftp.nl.debian.org/debian/ bullseye-updates main contrib non-free
     
  10. asgare

    asgare Member

    This command is the one of steps of installation which gives us the ability to give access to PHPMyAdmin and advice to run like this.
    Code:
    echo "update mysql.user set plugin = 'mysql_native_password' where user='root';" | mysql -u root
    
    In your command, I see no alternation upon 'user' table. if I am wrong please advise me.
    Code:
    ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'XXXXXXXXXXX';
    
    FLUSH PRIVILEGES;
     
  11. pyte

    pyte Well-Known Member HowtoForge Supporter

    Try to replace it with this list and see if it works:

    Code:
    deb http://deb.debian.org/debian/ bullseye main   contrib non-free
    deb-src http://deb.debian.org/debian/ bullseye main   contrib non-free
    
    deb http://security.debian.org/debian-security bullseye-security main   contrib non-free
    deb-src http://security.debian.org/debian-security bullseye-security main   contrib non-free
    
    deb http://deb.debian.org/debian/ bullseye-updates main   contrib non-free
    deb-src http://deb.debian.org/debian/ bullseye-updates main   contrib non-free
    
    You can backup the old list with "mv /etc/apt/source.list /etc/apt/source.list.back", if you want to keep it.
     
  12. pyte

    pyte Well-Known Member HowtoForge Supporter

    The commands that i mentioned here change the root password for the database, and disable auth_socket authentification.
     
  13. asgare

    asgare Member

    one more thing. Till told me for Debian 11 I need to install PHP7.4.
    So there are lots of PHP, can you update this command for my installation?
    Code:
    apt-get -y install apache2 apache2-doc apache2-utils libapache2-mod-php php7.3 php7.3-common php7.3-gd php7.3-mysql php7.3-imap php7.3-cli php7.3-cgi libapache2-mod-fcgid apache2-suexec-pristine php-pear mcrypt  imagemagick libruby libapache2-mod-python php7.3-curl php7.3-intl php7.3-pspell php7.3-recode php7.3-sqlite3 php7.3-tidy php7.3-xmlrpc php7.3-xsl memcached php-memcache php-imagick php-gettext php7.3-zip php7.3-mbstring memcached libapache2-mod-passenger php7.3-soap php7.3-fpm php7.3-opcache php-apcu libapache2-reload-perl
    
     

Share This Page