22.04 Upgrade Blank phpmyadmin page

Discussion in 'Server Operation' started by Tastiger, Jan 1, 2023.

  1. Tastiger

    Tastiger Member HowtoForge Supporter

    The title says it all, I've looked through the various threads here in the forums but none seem to fix the issue.
    It seems from searching is that the problem could be linked to php 8 and the version of phpmyadmin

    I can't seem to find a suitable tutorial to upgrade phpmyadmin in the perfect server environment.

    Before upgrade my installation was Perfect Server Ubuntu 20.04, apache etc.
    Hoping I don't have to do a clean installation
     
    Last edited: Jan 1, 2023
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

  3. Tastiger

    Tastiger Member HowtoForge Supporter

    It wasn't until I put the repo in early this morning, after that and also trying your method for updating it still only shows as

    Code:
    root@server2:~# dpkg-query -W -f '${version}\n' phpmyadmin
    4:5.1.4+dfsg1-2+jammy1
    
    So it seems the repo has not been updated for a while, the surrent version is apparently
    phpMyAdmin 5.2.0
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    What shows
    Code:
    apt policy phpmyadmin
     
  5. Tastiger

    Tastiger Member HowtoForge Supporter

  6. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    Tastiger likes this.
  7. Tastiger

    Tastiger Member HowtoForge Supporter

  8. Tastiger

    Tastiger Member HowtoForge Supporter

    Looks like something has changed after 4.9.2
    But it Worked!
    You may wish to update your tutorial to reflect the changes as shown below.


    Attached is the file in question and neither of those variables are in the php file

    PHP:
    <?php
    /**
     * File for vendor customization, you can change here paths or some behaviour,
     * which vendors such as Linux distributions might want to change.
     *
     * For changing this file you should know what you are doing. For this reason
     * options here are not part of normal configuration.
     */

    declare(strict_types=1);

    if (! 
    defined('PHPMYADMIN')) {
        exit;
    }

    return [
        
    /**
         * Path to vendor autoload file. Useful when you want to have vendor dependencies somewhere else.
         */
        
    'autoloadFile' => ROOT_PATH 'vendor' DIRECTORY_SEPARATOR 'autoload.php',

        
    /**
         * Directory where cache files are stored.
         */
        
    'tempDir' => ROOT_PATH 'tmp' DIRECTORY_SEPARATOR,

        
    /**
         * Path to changelog file, can be gzip compressed.
         * Useful when you want to have documentation somewhere else, e.g. /usr/share/doc.
         */
        
    'changeLogFile' => ROOT_PATH 'ChangeLog',

        
    /**
         * Path to license file. Useful when you want to have documentation somewhere else, e.g. /usr/share/doc.
         */
        
    'licenseFile' => ROOT_PATH 'LICENSE',

        
    /**
         * Directory where SQL scripts to create/upgrade configuration storage reside.
         */
        
    'sqlDir' => ROOT_PATH 'sql' DIRECTORY_SEPARATOR,

        
    /**
         * Filename of a configuration file.
         */
        
    'configFile' => ROOT_PATH 'config.inc.php',

        
    /**
         * Filename of custom header file.
         */
        
    'customHeaderFile' => ROOT_PATH 'config.header.inc.php',

        
    /**
         * Filename of custom footer file.
         */
        
    'customFooterFile' => ROOT_PATH 'config.footer.inc.php',

        
    /**
         * Default value for check for version upgrades.
         */
        
    'versionCheckDefault' => true,

        
    /**
         * Path to files with compiled locales (*.mo)
         */
        
    'localePath' => ROOT_PATH 'locale' DIRECTORY_SEPARATOR,

        
    /**
         * Define the cache directory for routing cache and other cache files
         */
        
    'cacheDir' => ROOT_PATH 'libraries' DIRECTORY_SEPARATOR 'cache' DIRECTORY_SEPARATOR,

        
    /**
         * Suffix to add to the phpMyAdmin version
         */
        
    'versionSuffix' => '',
    ];
     
    Last edited: Jan 3, 2023
  9. Tastiger

    Tastiger Member HowtoForge Supporter

    Just a couple of more notes :-
    The upgrade does not create the config file, I had to copy and rename
    also it seems this method doesn't generate a temp file either and shows a warning in the phpmyadmin gui
    I created that directory, CHMOD 775, but I can't seem to get rid of the warning
     
  10. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    edit /usr/share/phpmyadmin/libraries/vendor_config.php
    Code:
    'tempDir' => '/tmp/'
    'configFile' => '/etc/phpmyadmin/config.inc.php',
    

    also, i already had in /etc/phpmyadmin/config.inc.php:
    Code:
    // Load secret generated on postinst
    if (check_file_access('/var/lib/phpmyadmin/blowfish_secret.inc.php')) {
        require('/var/lib/phpmyadmin/blowfish_secret.inc.php');
    }
    
    and /var/lib/phpmyadmin/blowfish_secret_inc.php already contained:
    Code:
    <?php
    $cfg['blowfish_secret'] = '<redacted>';
    
    the blowfish config may have been added during an earlier manual update to 5.0.1.. i know i never had to change anything for that to go up to 5.2.0
     
    Tastiger likes this.
  11. William Desportes

    William Desportes New Member

    Hi everyone,

    phpMyAdmin team member here, you will find on the wiki page why there is a blank screen and how to fix it: github.com/phpmyadmin/phpmyadmin/wiki/DebianUbuntu/#known-issues

    I am the one responsible for the Debian/Ubuntu packaging but unfortunately someone on the Ubuntu team made a mistake that does this white screen, learn more about this here: github.com/phpmyadmin/phpmyadmin/issues/17523#issuecomment-1139443175

    Or the solution may be to apply this patch for PHP 8 support: github.com/phpmyadmin/phpmyadmin/issues/17585#issuecomment-1196750348

    Or more simply to use the php version shipped with your Ubuntu setup and not an older one (reason for the white screen)

    This is why if you use the zip from the phpMyAdmin website there is no error because all the dependencies are bundled into the zip and so the mistake of the Ubuntu team on the symfony dependency is not there.

    Let me know if it also works?
     
    Last edited: Jan 5, 2023
    Th0m likes this.
  12. Tastiger

    Tastiger Member HowtoForge Supporter

    Thanks - all seems good now.;)
     
    ahrasis and William Desportes like this.
  13. schwim

    schwim Member HowtoForge Supporter

    Sorry, I'm confused. You state that we should search the file for those vars and change them, then state that neither vars are found in the file. Are you saying to just add them to the beginning of the file?
     
  14. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    things change over time.. when i originally wrote instructions for upgrading phpmyadmin, it was still using the 4.8 / 4.9 versions.
    you just need to look at what's actually there now and adjust accordingly.
     
    ahrasis likes this.
  15. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    Agreed that is quite an "old" guide. I remember I followed Debian PST to change my PMA install from apt to manual in my ISPConfig Ubuntu server. Thereafter I just used @Th0m script to keep my PMA updated. So far it has been working flawlessly even after recent upgrade to Ubuntu Jammy 22.04.
     
  16. William Desportes

    William Desportes New Member

    Hi everyone,
    The `jammy` and `focal` PPA variants are not up to date with 5.2.1.
    See: https:// github.com /phpmyadmin/phpmyadmin/wiki/DebianUbuntu#install
     

Share This Page