Join the community today
Become a Member

phpmyadmin.sh Addon

Discussion in 'Add Ons' started by eva2000, May 25, 2014.

  1. noly

    noly Member

    106
    16
    18
    Jul 24, 2017
    Germany
    Ratings:
    +28
    Local Time:
    12:38 PM
    1.18.x
    10.2.x
    My browser console is throwing these errors...

    Code:
    [Error] Failed to load resource: the server responded with a status of 404 () (theme.css, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (keyhandler.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (ajax.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (name-conflict-fixes.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (menu_resizer.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (cross_framing_protection.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (config.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (doclinks.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (functions.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (navigation.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (indexes.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (common.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (page_settings.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (sql-lint.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (error_report.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (drag_drop_import.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (shortcuts_handler.js, line 0)
    [Error] Failed to load resource: the server responded with a status of 404 () (console.js, line 0)
    [Error] ReferenceError: Can't find variable: CommonParams
    

    EDIT:

    Updated nginx to 1.21.5
    Updated PHP to 7.4.29


    ...and still getting same errors as above
     
    Last edited: May 30, 2022
  2. BigIron

    BigIron Member

    64
    15
    8
    Sep 18, 2015
    Ratings:
    +19
    Local Time:
    3:38 AM
    I had to download phpMyAdmin-5.2.0-all-languages.zip from the phpMyAdmin site and manually upload the missing files to the proper directories. I also had to replace the entire themes directory.
     
  3. noly

    noly Member

    106
    16
    18
    Jul 24, 2017
    Germany
    Ratings:
    +28
    Local Time:
    12:38 PM
    1.18.x
    10.2.x
    Thank you @BigIron. Uploading the js/dist and /themes folders from the downloaded https://www.phpmyadmin.net/downloads/ did the trick.

    I recognized that the old /js/dist folder contains a .gitignore file. I guess that's what causes the error in the first place.
     
  4. noly

    noly Member

    106
    16
    18
    Jul 24, 2017
    Germany
    Ratings:
    +28
    Local Time:
    12:38 PM
    1.18.x
    10.2.x
    Thank you @BigIron. Uploading the js/dist and /themes folders from the downloaded https://www.phpmyadmin.net/downloads/ did the trick.

    I recognized that the old /js/dist folder contains a .gitignore file. I guess that's what causes the error in the first place.
     
  5. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    1:38 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    I reported too about the .gitignore file :)
     
  6. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:38 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    I see the problem now - might not be same problem as before as I only saw it now and it's fixed in updated phpmyadmin.sh fix yarn install · centminmod/phpmyadmin@8796062. yarn installation seems to now requires tmp directory execution and it's not allowed by default in Centmin Mod for security reasons. Yarn is used to build the CSS files in that directory you report as empty. So without yarn, not CSS files

    You can run the uninstaller /root/tools/phpmyadmin_uninstall.sh and re-try a fresh install with updated phpmyadmin.sh
     
  7. mknobbe

    mknobbe New Member

    6
    0
    1
    Jul 12, 2022
    Ratings:
    +4
    Local Time:
    5:38 AM
    10.3.35
    php version 8.1.8
    Centos 7.9
    Have updated the phpmyadmin install script to the latest (0.2.5)

    Have uninstalled and reinstalled phpmyadmin several times. Cannot figure how to resolve this composer issue

    Code:
    Loading composer repositories with package information
    Updating dependencies
    Your requirements could not be resolved to an installable set of packages.
    
      Problem 1
        - phpmyadmin/phpmyadmin is present at version 1.0.0+no-version-set and cannot be modified by Composer
        - roave/security-advisories dev-latest conflicts with phpmyadmin/phpmyadmin <5.1.3.
        - Root composer.json requires roave/security-advisories dev-latest -> satisfiable by roave/security-advisories[dev-latest].
    
     
  8. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:38 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Looks like a fairly recent issue outlined at phpmyadmin/phpmyadmin 1.0.0+no-version-set conflicts with roave/security-advisories dev-latest. · Issue #76 · Roave/SecurityAdvisories and composer update broken with phpMyAdmin 5.2.0 · Issue #17570 · phpmyadmin/phpmyadmin. Will need to look into this and see what the issue is :)
     
  9. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:38 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @mknobbe just tested this and not able to reproduce your issue right now.

    when are you getting that error ?
     
  10. mknobbe

    mknobbe New Member

    6
    0
    1
    Jul 12, 2022
    Ratings:
    +4
    Local Time:
    5:38 AM
    10.3.35
    I run the uninstall script to remove the previous install. Then I run the install script and the error comes up almost immediately.

    Here is another install attempt trying to install from the master branch instead of the STABLE but it still brings up the same issues.

    Code:
     ./phpmyadmin.sh install
    ---------------------------------------------------------------
    User nginx already exists
    ---------------------------------------------------------------
    ---------------------------------------------------------------
    Installing phpmyadmin from official git repository...
    ---------------------------------------------------------------
    This process can take some time depending on
    speed of the repository and your server...
    
    Cloning into '19183_mysqladmin16693'...
    2022-07-12 13:50:15 URL:https://getcomposer.org/download/latest-stable/composer.phar [2720967/2720967] -> "composer.phar" [1]
    Loading composer repositories with package information
    Info from https://repo.packagist.org: #StandWithUkraine
    Updating dependencies
    Your requirements could not be resolved to an installable set of packages.
    
      Problem 1
        - phpmyadmin/phpmyadmin is present at version 1.0.0+no-version-set and cannot be modified by Composer
        - roave/security-advisories dev-latest conflicts with phpmyadmin/phpmyadmin <5.1.3.
        - Root composer.json requires roave/security-advisories dev-latest -> satisfiable by roave/security-advisories[dev-latest].
    
    yarn install v1.22.4
    [1/5] Validating package.json...
    [2/5] Resolving packages...
    [3/5] Fetching packages...
    info fsevents@2.3.2: The platform "linux" is incompatible with this module.
    info "fsevents@2.3.2" is an optional dependency and failed compatibility check. Excluding it from installation.
    [4/5] Linking dependencies...
    [5/5] Building fresh packages...
    $ yarn run build
    yarn run v1.22.4
    $ webpack
    
    ...and so on..
     
  11. mknobbe

    mknobbe New Member

    6
    0
    1
    Jul 12, 2022
    Ratings:
    +4
    Local Time:
    5:38 AM
    10.3.35
    @eva2000

    Was able to verify that adding

    Code:
    "version": "5.2.0",
    to composer.json will resolve what seems to be composer not being able to determine the phpmyadmin version being installed.

    If I update composer.json in my phpmyadmin install directory and run the update command

    Code:
    php composer.phar update --no-dev
    it will finish up the composer aspect of the phpmyadmin install and I have a functioning phpmyadmin
     
    Last edited: Jul 13, 2022
  12. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:38 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Thanks for the follow up info most useful. Looks like phpmyadmin folks added this workaround fix to next phpmyadmin 5.3 branch composer update broken with phpMyAdmin 5.2.0 · Issue #17570 · phpmyadmin/phpmyadmin but not 5.2 or did they add it to 5.2 as my test didn't get that error you did? But my composer.json didn't have the version tag.

    @mknobbe do you get the error if you run the update script without version info inc omposer.json ?
    Code (Text):
    /root/tools/phpmyadmin_update.sh
     
  13. mknobbe

    mknobbe New Member

    6
    0
    1
    Jul 12, 2022
    Ratings:
    +4
    Local Time:
    5:38 AM
    10.3.35
    Yes, same error
     
  14. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:38 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    strange I still don't get the error if I update using phpmyadmin_update.sh script. Only way to reproduce the error is if I follow this person's steps in installing and updating phpmyadmin composer update broken with phpMyAdmin 5.2.0 · Issue #17570 · phpmyadmin/phpmyadmin but addon/phpmyadmin.sh doesn't use that method to install phpmyadmin

    Oh @mknobbe are you running phpmyadmin.sh and phpmyadmin_update.sh as full root user or as a sudo user?
     
  15. mknobbe

    mknobbe New Member

    6
    0
    1
    Jul 12, 2022
    Ratings:
    +4
    Local Time:
    5:38 AM
    10.3.35
    I'm logged in as root
     
  16. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    1:38 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Export table functionality seems to be problematic on the latest version...

    Export button is not triggered...

    It seems like .js not executing?

    Maybe related to the composer issue?
     
    Last edited: Jul 19, 2022
  17. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    8:38 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Guess that ain't an issue then.
    Any clues of errors in web browser's developer console?
     
  18. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    1:38 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Nothing special i think...

    Chrome:
    [​IMG]

    At Firefox the last loading file is export.js from:

    /server.domain.com/123_mysqladmin45678/js/dist/export.js?v=5.2.0

    I am uploading also the Chrome console...

    Thanks !
     

    Attached Files:

    Last edited: Jul 21, 2022
  19. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    4:08 PM
    I did reinstall phpmyadmin after having css related errors
    When trying to access the new URL I'm getting
    Any advise will help. Thanks
     
  20. quicksalad

    quicksalad Member

    228
    13
    18
    May 31, 2015
    Ratings:
    +20
    Local Time:
    4:08 PM
    upon checking on my phpmyadmin conf
    Code:
    location ^~ /12311_mysqladmin133212/ {
        rewrite ^/(.*) https://hostname/$1 permanent;
    }
    before it was
    Code:
    location ^~ /12311_mysqladmin133212/ {
        rewrite ^/(.*) https://hostname.mydomain.com/$1 permanent;
    }
    after reinstall, I think it generates, crt.key instead of hostname.mydomain.com.key
    I also noticed after I restore from backup, my SSH command prompt is now
    Code:
    [root@hostname ~]#
    before it was
    Code:
    [root@hostname.mydomain.com ~]#