issues since upgrade

Discussion in 'Installation/Configuration' started by chief, Sep 27, 2023.

  1. chief

    chief Member HowtoForge Supporter

    debian 12 - ispconfig 3.2.11
    I upgraded from debian 11 to 12 and upgraded ispconfig 3.2.9 to 3.2.11
    I followed this tutorial - https://www.howtoforge.com/update-the-ispconfig-perfect-server-from-debian-11-to-debian-12/
    at the end it states to update phpmyadmin - SO I DID!!
    after finishing all of the upgrades - now they all have phpmyadmin installed.
    mx1, mx2, ns1, ns2, ns3, webmail - they shouldnt have phpmyadmin??
    RIGHT?
    Will it be a case of deleting the contents of
    Code:
    # Directory where phpMyAdmin is installed
    phpMyAdmindir="/usr/share/phpmyadmin"[code]
    to stop it? or is there a symlink as well?
    
    dave
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Would that stop PHPMyadmin? I find it strange it would.
    @Th0m , should the phpmyadmin update script have uninstall option?
    I read the update script, but can not see where it makes the apache conf that enables phpmyadmin. So I can not give advice on how to disable it. You would need to examine how phpadmin now is configured to start.
     
    chief likes this.
  3. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    In the tutorial, it is clearly mentioned that the update of phpmyadmin is optional, and if you have it installed, then it is recommended to be upgraded, and since you updated it, I assumed you already had it installed earlier in those servers?

    Anyway you could also learn if it was installed by apt or manually by going back to the tutorial you followed in creating the servers or via command line (you can find in the script how to check if it was installed via apt).

    In any event, you should be able to remove it in the same way it was installed. It also does not mean you must uninstall it as it will work only in a web server, but you may if you want to.

    And no, I don't think @Th0m script have uninstall option for phpmyadmin as it is just updating it to latest version. The script also will run directly from the specified command and will not be downloaded to the server.
     
    Last edited: Sep 29, 2023
    chief likes this.
  4. chief

    chief Member HowtoForge Supporter

    leading on from this, phpmyadmin on my web01 webserver complains about no tmp.
    i created
    Code:
    /usr/share/phpmyadmin/tmp
    chmod 777 tmp
    vim /usr/share/phpmyadmin/config.inc.php - adding
    $cfg['TempDir'] = 'tmp';
    systemctl restart apache2
    when logging in to phpmyadmin it now states the following
    Code:
    The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. 
    Or alternatively go to 'Operations' tab of any database to set it up there.
    and
    Code:
    Invalid server index: 0
    i googled it and a solution came back
    Code:
    dpkg-reconfigure -plow phpmyadmin
    it asks.
    1. reinstall database = yes?
    2. connection type = unix socket?
    3. authentication plugin = default?
    4. provide mysql database name = phpmyadmin?
    5. mysql username of phpmyadmin = phpmyadmin@localhost?
    6. mysql application password for phpmyadmin = generate one?
    7. name of the database admin = root?
    8. choose webserver = apache2 (it is)
    then systemctl restart apache2[/code]
    but again when i log in, still states
    Code:
    The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. 
    Or alternatively go to 'Operations' tab of any database to set it up there.
    and
    Code:
    Invalid server index: 0
     
  5. chief

    chief Member HowtoForge Supporter

    also, when i ran the above, it never seemed to change anything - my config.inc.php is the same.
     
  6. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    I normally follow this tutorial if phpmyadmin got problems since it is a manual install and have step-by-step guide, (other tutorials are using apt install), so carefully following this guide helps me to troubleshoot as well. https://www.howtoforge.com/perfect-...stall-phpmyadmin-database-administration-tool

    You can also use apt purge and apt install to clean and reinstall it, if this is your preferred way, but like I said, it mainly depends on tutorial you followed to install it in the first place.
     
    chief likes this.
  7. chief

    chief Member HowtoForge Supporter

    I followed this one https://www.howtoforge.com/tutorial/ispconfig-multiserver-setup-debian-ubuntu
    and it just worked on webservers out of the box
     
  8. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    So you have PHPMyadmin installed via apt on the web server host, and on the other hosts in the multiserver setup you used Th0ms script to install it with direct download?
     
  9. chief

    chief Member HowtoForge Supporter

    I followed the auto script to setup the machines.
    Followed tutorial to upgrade debian 11 to 12.
    At the end of the script it states to upgrade phpmyadmin.
    so in my ignorance i followed it. yes.
    is it best to remove it ?
     
  10. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    The script only updates it if it's not installed by apt. So that can not have installed it manually.
     
    chief likes this.
  11. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    From what I read in the script, it checks if apt has installed phpmyadmin, and exit if this is the case. But then it looks to me it downloads phpmyadmin and installs it. So after running the script phpmyadmin is installed, one way or the other.
     
    chief likes this.
  12. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    I think it would be safe to remove it from your other servers (other than the web servers) if you so wished. I would simply run `apt purge phpmyadmin` if it was installed via apt or run `rm -rf /usr/share/phpmyadmin /etc/phpmyadmin /var/lib/phpmyadmin
    /etc/apache2/conf-*/phpmyadmin.conf
    ` if it was installed manually.
     
    chief likes this.
  13. chief

    chief Member HowtoForge Supporter

    thanks you all.
    I only need phpmyadmin on:
    webservers..

    not on:
    panel - master
    name server's
    mail server's
    webmail server
    ?

    dave
     
  14. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    It should be fine to remove it from them.
     

Share This Page