Welcome to Centmin Mod Community
Register Now

phpmyadmin.sh Addon

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

  1. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  2. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    12:12 PM
    Nginx-1.25.x
    MariaDB 10.3.x
  3. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    12:12 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Don't know why but as i had disabled the automated upgrade using the cron i run it manually and i got this:

    Code:
    /root/tools/phpmyadmin_update.sh
    cd /usr/local/nginx/html/15080_mysqladmin2828
    git pull
    From https://github.com/phpmyadmin/phpmyadmin
       b6c9556..42eb0bf  STABLE     -> origin/STABLE
    From https://github.com/phpmyadmin/phpmyadmin
     * [new tag]         RELEASE_4_7_0RC1 -> RELEASE_4_7_0RC1
     * [new tag]         RELEASE_4_7_5 -> RELEASE_4_7_5
     * [new tag]         RELEASE_4_7_6 -> RELEASE_4_7_6
     * [new tag]         RELEASE_4_7_7 -> RELEASE_4_7_7
    error: Your local changes to the following files would be overwritten by merge:
        composer.lock
    Please, commit your changes or stash them before you can merge.
    Aborting
    Updating 6519211..42eb0bf
    2018-01-02 23:03:04 URL:https://getcomposer.org/composer.phar [1845610/1845610] -> "composer.phar" [1]
    Do not run Composer as root/super user! See https://getcomposer.org/root for details
    Loading composer repositories with package information
    Updating dependencies
    Package operations: 2 installs, 7 updates, 0 removals
      - Installing symfony/polyfill-mbstring (v1.6.0): Downloading (100%)         
      - Updating phpmyadmin/sql-parser (v4.1.3 => v4.2.4): Downloading (100%)         
      - Installing psr/simple-cache (1.0.0): Downloading (100%)         
      - Updating symfony/cache (v3.2.7 => v4.0.2): Downloading (100%)         
      - Updating symfony/expression-language (v3.2.7 => v4.0.2): Downloading (100%)         
      - Updating phpmyadmin/motranslator (3.0 => 3.4): Downloading (100%)         
      - Updating phpmyadmin/shapefile (2.0 => 2.1): Downloading (100%)         
      - Updating tecnickcom/tcpdf (6.2.12 => 6.2.13): Downloading (100%)         
      - Updating phpseclib/phpseclib (2.0.4 => 2.0.9): Downloading (100%)         
    Writing lock file
    Generating autoload files
    Don't know if that's the issue:

    But after the upgrade i log out and re login and use also another browser and even if i did manual nprestart i can see the old version and not the updated 4.7.7 :(
     
  4. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    12:12 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Problem found :)

    I was missing the:
    at the:
    Using latest centminmod updated..... :(

    Maybe Centminmod autoupdate that files?

    Also when i run it on my second server i didn't got the 4.7.7 and i got the 4.8.0-dev ...

    Don't know why....

    Any easy way to check the version from cli ?

    Third server report:

    Maybe to busy as it is all around the news and everyone try to upgrade?

    But all servers was updated and working even with that errors :)

    Thank you
     
    Last edited: Jan 3, 2018
  5. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    latest version of /root/tools/phpmyadmin_update.sh has the line for
    Code (Text):
    rm -rf composer.lock
    

    so guess you were using older version

    easiest way to solve these in future is just run the uninstaller for phpmyadmin.sh at /root/tools/phpmyadmin_uninstall.sh and re-install to get latest version
     
  6. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    ouch... that's why i rarely ever install phpmyadmin myself and just do all mysql management via SSH commandline but also why phpmyadmin.sh installer has an auto updater script though phpmyadmin install/update procedures have changes to deal with the lock file which latest phpmyadmin.sh installer does.
     
  7. Itworx4me

    Itworx4me Active Member

    299
    27
    28
    Mar 14, 2017
    Ratings:
    +48
    Local Time:
    2:12 AM
    Nginx 1.25.X
    MariaDB 10.6.X
    Is there a guide on ssh commands for mysql?

    Thanks,
    Itworx4me
     
  8. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    from MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS
     
  9. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    12:12 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    i just got this:

    It works after that but you may want to find that and fix it :)
     
  10. sepulchre

    sepulchre Member

    167
    22
    18
    Dec 22, 2014
    Ratings:
    +28
    Local Time:
    11:12 AM
    Just for the record.
    For the love of god I was trying to figure out why I couldn't access phpmyadmin after installing it via this addon.

    I think I figured it out, not sure if this is correct but just in case I write it down for ppl who are in a similar position.

    So after you have a fresh install of centmin, don't forget to delete the demodomain.com.conf BEFORE you install phpmyadmin.

    So, make a fresh install of centmin, make a vhost file for your domain (#2 option in ./centmin.sh), then delete demodomain.com.conf file located in usr/local/nginx/conf/conf.d (also delete the demodomain in /home/nginx/domains) THEN install phpmyadmin. I deleted demodomain for 3-4 tries after the installation of phpmyadmin, and for the love of god couldn't understand why I can't access it. I guess the conf file of phpmyadmin has a problem seeing 2 conf files, but don't know, maybe I am wrong. But in case I write it down for all ppl.
     
  11. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    You shouldn't need to delete demodomain.com.conf for phpmyadmin addon installed phpmyadmin to work. Just make sure your main hostname vhost is setup correctly with proper DNS entry as per step 1 of Getting Started Guide
     
  12. sepulchre

    sepulchre Member

    167
    22
    18
    Dec 22, 2014
    Ratings:
    +28
    Local Time:
    11:12 AM
    I read step 1 and step 2 multiple times already. It made me crazy, couldn't figure out why I have no access.

    I set my DNS entry yesterday, with no changes. Still after a day, even though I could reach to my domain and ip normally, which means my dns entry was correct, I could not access phpmyadmin at all. No error page, nothing. For this purpose alone I did multiple fresh installs. And now after deleting demodomain.com.conf before phpmyadmin installation, it worked. Maybe it is something else, but meanwhile I didn't change my DNS entries at all. Anyway, I'm happy that it works now, and for future reference I wanted to share it with all people.
     
  13. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Interesting.. might see if demodomain.com.conf is needed anymore :)
     
  14. BigIron

    BigIron Member

    64
    15
    8
    Sep 18, 2015
    Ratings:
    +19
    Local Time:
    2:12 AM
    I'm having this same issue, but I can't continue.

    Main hostname is setup properly.

    Any ideas @eva2000?
     
  15. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    can you post the output for below command to gist.github.com or pastebin.com masking any sensitive info

    within directoy that phpmyadmin.sh is run
    Code (Text):
    bash -x phpmyadmin.sh install
    
     
  16. BigIron

    BigIron Member

    64
    15
    8
    Sep 18, 2015
    Ratings:
    +19
    Local Time:
    2:12 AM
    Sorry, didn't see this till now :)

    myphpadmin error
     
  17. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    from output suggest main hostname isn't setup correctly what output do you get for these commands

    Code (Text):
    SSLHNAME=$(uname -n)
    echo $SSLHNAME
    grep -rw server_name /usr/local/nginx/conf/conf.d/ | grep -w "$SSLHNAME"
    
     
  18. BigIron

    BigIron Member

    64
    15
    8
    Sep 18, 2015
    Ratings:
    +19
    Local Time:
    2:12 AM

    Code:
    [18:53][root@subdomain.domain.com ~]# SSLHNAME=$(uname -n)
    [18:53][root@subdomain.domain.com ~]# echo $SSLHNAME
    subdomain.domain.com
    [18:53][root@subdomain.domain.com ~]# grep -rw server_name /usr/local/nginx/conf/conf.d/ | grep -w "$SSLHNAME"
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.ssl.conf:#       server_name subdomain.domain.com www.subdomain.domain.com;
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.ssl.conf:#       return 302 https://$server_name$request_uri;
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.ssl.conf:  server_name subdomain.domain.com www.subdomain.domain.com;
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.conf:#            server_name subdomain.domain.com;
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.conf:  server_name subdomain.domain.com www.subdomain.domain.com;
    /usr/local/nginx/conf/conf.d/virtual.conf:            server_name subdomain.domain.com;
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.ssl.conf.old:#       server_name subdomain.domain.com www.subdomain.domain.com;
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.ssl.conf.old:#       return 302 https://$server_name$request_uri;
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.ssl.conf.old:  server_name subdomain.domain.com www.subdomain.domain.com;
    [18:53][root@subdomain.domain.com ~]#
    
     
  19. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:12 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    there's the problem your main host name subdomain.domain.com in
    /usr/local/nginx/conf/conf.d/virtual.conf is replicated in
    /usr/local/nginx/conf/conf.d/subdomain.domain.com.ssl.conf so that's why phpmyadmin.sh refuses to install

    as per getting started guide step 1, the main hostname in /usr/local/nginx/conf/conf.d/virtual.conf can not be duplicated in any additional vhosts you create in /usr/local/nginx/conf/conf.d/ when you run centmin.sh menu option 2 etc.
     
  20. BigIron

    BigIron Member

    64
    15
    8
    Sep 18, 2015
    Ratings:
    +19
    Local Time:
    2:12 AM
    Ah, thank you!