problem with Automated ISPConfig 3 Installation

Discussion in 'Installation/Configuration' started by brody182, Nov 4, 2021.

  1. brody182

    brody182 Member

    just realized that PHPMyAdmin did not install correctly my Debian 11 fresh install.

    the files exist in the directory "/usr/share/phpmyadmin/config.sample.inc.php" but not this file "
    /usr/share/phpmyadmin/config.inc.php"

    I have to admit, during installation, I did not use su -, but it does not matter because I was logged in as root user

    What do I have to do now? run update.php or run the automated installer again?

    I do not know what else has not been installed.
     
    Last edited: Nov 4, 2021
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    I would run automated installer again correctly in this round.
     
  3. brody182

    brody182 Member

  4. brody182

    brody182 Member

    I used this exact example

    wget -O - https://get.ispconfig.org | sh -s -- --use-nginx --use-ftp-ports=40110-40210 --unattended-upgrades
     
  5. brody182

    brody182 Member

    [ERROR] The server already has ISPConfig installed. Aborting.
     
  6. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    The autoinstaller doesn't currently support reinstall, if you can wipe and reinitialize the vps you could run it fresh.
     
  7. brody182

    brody182 Member

    also, in the administrator, sites, databases, the link to access PHPMyAdmin is :8080/PHPMyAdmin instead it should be :8081/PHPMyAdmin
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    This is configurable under System > Interface > main config, it needs to be set after installation.
     
  9. brody182

    brody182 Member

    PHPMyAdmin URL: /phpmyadmin

    it was always like that,
     
  10. brody182

    brody182 Member

    this is weird because these fields are set in the file /usr/share/phpmyadmin/config.inc.php


    The configuration file now needs a secret passphrase (blowfish_secret).
    [​IMG] The $cfg['TempDir'] (/var/lib/phpmyadmin/tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    You must use the FQDN URL, because /phpmyadmin translates to a local URL on the current port in web browser or in other words, it translates to 8080/phpmyadmin. So if you want to point it to a URL on port 8081, you must use:

    https://yourserver.domain.tld:8081/phpmyadmin

    But that#s all not specific to the auto-installer, has been like this since the first ISPConfig 3 version.
     
  12. original_drew

    original_drew New Member

    Hi Brody,
    Did you do a fresh install? and did that fix the problem for you? because I have exactly the same problem.
     
  13. original_drew

    original_drew New Member

    I've done 2 fresh installs now and have the same error twice.

    Code:
    The $cfg['TempDir'] (/var/lib/phpmyadmin/tmp) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.
    The permissions on that directory are www-data:www-data is the user for ispconfig 'ispaps'?
    This goes away when we chmod -R 757 /var/lib/phpmyadmin/tmp

    along with this we get also get the following error whenever clicking on a table in phpmyadmin
    Code:
    Notice in ./libraries/classes/Display/Results.php#1224
    Trying to access array offset on value of type bool
    It doesn't matter what table... any and all.

    Looks like it's an issue with php7.4 and this version of phpmyadmin. Though, phpmyadmin does say it's compatible UPTO 7.4.
    Actually, php7.4 is generating this error for a lot of mysql frontends.
    https://github.com/sabre-io/Baikal/issues/863
    https://stackoverflow.com/questions...array-offset-on-value-of-type-bool-in-php-7-4
     
  14. original_drew

    original_drew New Member

    The answer was merely updating phpmyadmin. I used Th0m Perfect upgrade tool for phpmyadmin
    https://forum.howtoforge.com/thread...automatically-how-to-update-phpmyadmin.88495/

    So simple to upgrade using his tool :) And now no more errors.

    So I guess for debian 11 auto installer which uses php7.4 as it's base php, we need to set a minimum phpmyadmin >= 5.1. Th0m's upgrade tool automatically set mine to 5.2. and it all now works as expected :)

    Thanks Th0m
     
  15. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    I actually added a fix for the TempDir permission problem to that update script just yesterday. Also, in a future version of the AI the auto-update script for phpMyAdmin will be installed automatically. And from that same moment on the AI will always install the latest phpMyAdmin release.

    See https://git.ispconfig.org/ispconfig/ispconfig-autoinstaller/-/merge_requests/35
     
    ahrasis and till like this.
  16. churbz

    churbz New Member

    I tried re-running the update script to correct the permissions problem on the /var/lib/phpmyadmin/tmp folder to remove the error message "The $cfg['TempDir'] (/var/lib/phpmyadmin/tmp/) is not accessible." However the permissions were not corrected since the version was already the latest.

    Then looking at your git commit I see the permissions need to be 0770. Executing the below command fixed the problem.
    Code:
    cd /var/lib/phpmyadmin
    chmod -R 770 tmp
    
    Thanks.
     
    Th0m, Aldo Giove, till and 1 other person like this.
  17. Robetus

    Robetus Member

    This worked for me:
    In
    /etc/phpmyadmin/config.inc.php
    add
    Code:
    $cfg['TempDir'] = '/tmp';
     

Share This Page