Learn about Centmin Mod LEMP Stack today
Register Now

phpmyadmin.sh Addon

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

  1. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    7:25 PM
    drwxr-sr-x 14 phpmyadmin nginx 4.0K Aug 6 17:16 2471_mysqladmin21680

     
  2. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    so directory is correct, does it have the phpmyadmin files ?

    type
    Code:
    ls -lah /usr/local/nginx/html/$(ls /usr/local/nginx/html | grep 'mysqladmin')
    should return something like
    Code:
    ls -lah /usr/local/nginx/html/$(ls /usr/local/nginx/html | grep 'mysqladmin')
    total 764K
    drwxr-sr-x 15 phpmyadmin nginx 4.0K Aug  6 02:19 .
    drwxr-sr-x  4 nginx      nginx 4.0K Aug  5 19:10 ..
    -rw-r--r--  1 phpmyadmin nginx  102 Aug  3 10:02 .coveralls.yml
    drwxr-sr-x  8 phpmyadmin nginx 4.0K Aug  6 02:19 .git
    -rw-r--r--  1 phpmyadmin nginx  657 Aug  3 10:02 .gitignore
    -rw-r--r--  1 phpmyadmin nginx  369 Aug  3 10:02 .jshintrc
    -rw-r--r--  1 phpmyadmin nginx  584 Aug  3 10:02 .scrutinizer.yml
    -rw-r--r--  1 phpmyadmin nginx 2.1K Aug  3 10:02 .travis.yml
    -rw-r--r--  1 phpmyadmin nginx 1.7K Aug  3 10:02 CONTRIBUTING.md
    -rw-r--r--  1 phpmyadmin nginx  23K Aug  6 02:19 ChangeLog
    -rw-r--r--  1 phpmyadmin nginx 1.8K Aug  3 10:02 DCO
    -rw-r--r--  1 phpmyadmin nginx  18K Aug  3 10:02 LICENSE
    drwxr-sr-x  3 phpmyadmin nginx 4.0K Aug  3 10:02 PMAStandard
    -rw-r--r--  1 phpmyadmin nginx 1.5K Aug  3 10:02 README
    -rw-r--r--  1 phpmyadmin nginx 1.5K Aug  3 10:02 README.rst
    -rw-r--r--  1 phpmyadmin nginx 1.5K Aug  3 10:02 browse_foreigners.php
    -rw-r--r--  1 phpmyadmin nginx 6.5K Aug  3 10:02 build.xml
    -rw-r--r--  1 phpmyadmin nginx 4.9K Aug  3 10:02 changelog.php
    -rw-r--r--  1 phpmyadmin nginx  748 Aug  3 10:02 chk_rel.php
    -rw-r--r--  1 phpmyadmin nginx  892 Aug  3 10:02 composer.json
    -rw-r-----  1 phpmyadmin nginx 4.8K Aug  3 10:02 config.inc.php
    -rw-r--r--  1 phpmyadmin nginx 4.6K Aug  3 10:02 config.sample.inc.php
    -rw-r--r--  1 phpmyadmin nginx 5.2K Aug  3 10:02 db_central_columns.php
    -rw-r--r--  1 phpmyadmin nginx 4.4K Aug  3 10:02 db_create.php
    -rw-r--r--  1 phpmyadmin nginx 5.5K Aug  3 10:02 db_datadict.php
    -rw-r--r--  1 phpmyadmin nginx 7.6K Aug  3 10:02 db_designer.php
    -rw-r--r--  1 phpmyadmin nginx  397 Aug  3 10:02 db_events.php
    -rw-r--r--  1 phpmyadmin nginx 4.1K Aug  3 10:02 db_export.php
    -rw-r--r--  1 phpmyadmin nginx  597 Aug  3 10:02 db_import.php
    -rw-r--r--  1 phpmyadmin nginx 9.5K Aug  4 02:20 db_operations.php
    -rw-r--r--  1 phpmyadmin nginx 4.3K Aug  3 10:02 db_qbe.php
    -rw-r--r--  1 phpmyadmin nginx  506 Aug  3 10:02 db_routines.php
    -rw-r--r--  1 phpmyadmin nginx 1.8K Aug  3 10:02 db_search.php
    -rw-r--r--  1 phpmyadmin nginx 1023 Aug  3 10:02 db_sql.php
    -rw-r--r--  1 phpmyadmin nginx  725 Aug  3 10:02 db_sql_autocomplete.php
    -rw-r--r--  1 phpmyadmin nginx  453 Aug  3 10:02 db_sql_format.php
    -rw-r--r--  1 phpmyadmin nginx 1.5K Aug  4 02:20 db_structure.php
    -rw-r--r--  1 phpmyadmin nginx  12K Aug  4 02:20 db_tracking.php
    -rw-r--r--  1 phpmyadmin nginx  360 Aug  3 10:02 db_triggers.php
    drwxr-sr-x  3 phpmyadmin nginx 4.0K Aug  3 10:02 doc
    -rw-r--r--  1 phpmyadmin nginx 4.5K Aug  3 10:02 error_report.php
    drwxr-sr-x  2 phpmyadmin nginx 4.0K Aug  3 10:02 examples
    -rw-r--r--  1 phpmyadmin nginx  18K Aug  3 10:02 export.php
    -rw-r--r--  1 phpmyadmin nginx  19K Aug  3 10:02 favicon.ico
    -rw-r--r--  1 phpmyadmin nginx 2.3K Aug  3 10:02 file_echo.php
    -rw-r--r--  1 phpmyadmin nginx  16K Aug  3 10:02 gis_data_editor.php
    -rw-r--r--  1 phpmyadmin nginx  27K Aug  3 10:02 import.php
    -rw-r--r--  1 phpmyadmin nginx 3.4K Aug  3 10:02 import_status.php
    -rw-r--r--  1 phpmyadmin nginx  22K Aug  3 10:02 index.php
    drwxr-sr-x 10 phpmyadmin nginx 4.0K Aug  6 02:19 js
    drwxr-sr-x 17 phpmyadmin nginx  12K Aug  6 02:19 libraries
    -rw-r--r--  1 phpmyadmin nginx  777 Aug  3 10:02 license.php
    -rw-r--r--  1 phpmyadmin nginx  935 Aug  3 10:02 lint.php
    -rw-r--r--  1 phpmyadmin nginx 2.1K Aug  3 10:02 navigation.php
    -rw-r--r--  1 phpmyadmin nginx 3.9K Aug  3 10:02 normalization.php
    -rw-r--r--  1 phpmyadmin nginx  386 Aug  3 10:02 phpinfo.php
    -rw-r--r--  1 phpmyadmin nginx 1.1K Aug  3 10:02 phpmyadmin.css.php
    -rw-r--r--  1 phpmyadmin nginx 2.6K Aug  3 10:02 phpunit.xml.dist
    -rw-r--r--  1 phpmyadmin nginx 1.1K Aug  3 10:02 phpunit.xml.hhvm
    -rw-r--r--  1 phpmyadmin nginx 1.4K Aug  3 10:02 phpunit.xml.nocoverage
    drwxr-sr-x  2 phpmyadmin nginx 4.0K Aug  6 02:19 po
    -rw-r--r--  1 phpmyadmin nginx 2.8K Aug  3 10:02 prefs_forms.php
    -rw-r--r--  1 phpmyadmin nginx  15K Aug  3 10:02 prefs_manage.php
    -rw-r--r--  1 phpmyadmin nginx 1.2K Aug  3 10:02 print.css
    -rw-r--r--  1 phpmyadmin nginx   26 Aug  3 10:02 robots.txt
    -rw-r--r--  1 phpmyadmin nginx 1.6K Aug  3 10:02 schema_export.php
    drwxr-sr-x  2 phpmyadmin nginx 4.0K Aug  3 10:02 scripts
    -rw-r--r--  1 phpmyadmin nginx 1.1K Aug  3 10:02 server_binlog.php
    -rw-r--r--  1 phpmyadmin nginx  731 Aug  3 10:02 server_collations.php
    -rw-r--r--  1 phpmyadmin nginx 2.6K Aug  3 10:02 server_databases.php
    -rw-r--r--  1 phpmyadmin nginx  611 Aug  3 10:02 server_engines.php
    -rw-r--r--  1 phpmyadmin nginx  791 Aug  3 10:02 server_export.php
    -rw-r--r--  1 phpmyadmin nginx  545 Aug  3 10:02 server_import.php
    -rw-r--r--  1 phpmyadmin nginx  595 Aug  3 10:02 server_modules.php
    -rw-r--r--  1 phpmyadmin nginx  780 Aug  3 10:02 server_plugins.php
    -rw-r--r--  1 phpmyadmin nginx  13K Aug  3 10:02 server_privileges.php
    -rw-r--r--  1 phpmyadmin nginx 2.1K Aug  3 10:02 server_replication.php
    -rw-r--r--  1 phpmyadmin nginx  728 Aug  3 10:02 server_sql.php
    -rw-r--r--  1 phpmyadmin nginx  977 Aug  3 10:02 server_status.php
    -rw-r--r--  1 phpmyadmin nginx  982 Aug  3 10:02 server_status_advisor.php
    -rw-r--r--  1 phpmyadmin nginx 3.4K Aug  3 10:02 server_status_monitor.php
    -rw-r--r--  1 phpmyadmin nginx 2.1K Aug  3 10:02 server_status_processes.php
    -rw-r--r--  1 phpmyadmin nginx 1.8K Aug  3 10:02 server_status_queries.php
    -rw-r--r--  1 phpmyadmin nginx 1.6K Aug  3 10:02 server_status_variables.php
    -rw-r--r--  1 phpmyadmin nginx 1.8K Aug  3 10:02 server_user_groups.php
    -rw-r--r--  1 phpmyadmin nginx 1.3K Aug  3 10:02 server_variables.php
    drwxr-sr-x  4 phpmyadmin nginx 4.0K Aug  3 10:02 setup
    -rw-r--r--  1 phpmyadmin nginx 1.1K Aug  3 10:02 show_config_errors.php
    drwxr-sr-x  2 phpmyadmin nginx 4.0K Aug  3 10:02 sql
    -rw-r--r--  1 phpmyadmin nginx 6.3K Aug  3 10:02 sql.php
    -rw-r--r--  1 phpmyadmin nginx 3.7K Aug  3 10:02 tbl_addfield.php
    -rw-r--r--  1 phpmyadmin nginx 6.6K Aug  3 10:02 tbl_change.php
    -rw-r--r--  1 phpmyadmin nginx  843 Aug  3 10:02 tbl_chart.php
    -rw-r--r--  1 phpmyadmin nginx 3.2K Aug  3 10:02 tbl_create.php
    -rw-r--r--  1 phpmyadmin nginx 5.8K Aug  3 10:02 tbl_export.php
    -rw-r--r--  1 phpmyadmin nginx  939 Aug  3 10:02 tbl_find_replace.php
    -rw-r--r--  1 phpmyadmin nginx 1.4K Aug  3 10:02 tbl_get_field.php
    -rw-r--r--  1 phpmyadmin nginx 1.2K Aug  3 10:02 tbl_gis_visualization.php
    -rw-r--r--  1 phpmyadmin nginx  681 Aug  3 10:02 tbl_import.php
    -rw-r--r--  1 phpmyadmin nginx 1.3K Aug  3 10:02 tbl_indexes.php
    -rw-r--r--  1 phpmyadmin nginx  14K Aug  3 10:02 tbl_operations.php
    -rw-r--r--  1 phpmyadmin nginx  479 Aug  3 10:02 tbl_recent_favorite.php
    -rw-r--r--  1 phpmyadmin nginx 2.5K Aug  3 10:02 tbl_relation.php
    -rw-r--r--  1 phpmyadmin nginx  16K Aug  3 10:02 tbl_replace.php
    -rw-r--r--  1 phpmyadmin nginx 4.8K Aug  3 10:02 tbl_row_action.php
    -rw-r--r--  1 phpmyadmin nginx 1.1K Aug  3 10:02 tbl_select.php
    -rw-r--r--  1 phpmyadmin nginx 1.2K Aug  3 10:02 tbl_sql.php
    -rw-r--r--  1 phpmyadmin nginx 1.7K Aug  4 02:20 tbl_structure.php
    -rw-r--r--  1 phpmyadmin nginx 5.8K Aug  3 10:02 tbl_tracking.php
    -rw-r--r--  1 phpmyadmin nginx  141 Aug  3 10:02 tbl_triggers.php
    -rw-r--r--  1 phpmyadmin nginx  993 Aug  3 10:02 tbl_zoom_select.php
    drwxr-sr-x 12 phpmyadmin nginx 4.0K Aug  4 02:20 templates
    drwxr-sr-x  7 phpmyadmin nginx 4.0K Aug  3 10:02 test
    drwxr-sr-x  4 phpmyadmin nginx 4.0K Aug  3 10:02 themes
    -rw-r--r--  1 phpmyadmin nginx  857 Aug  3 10:02 themes.php
    -rw-r--r--  1 phpmyadmin nginx 1.9K Aug  3 10:02 transformation_overview.php
    -rw-r--r--  1 phpmyadmin nginx 3.9K Aug  3 10:02 transformation_wrapper.php
    -rw-r--r--  1 phpmyadmin nginx 1.2K Aug  3 10:02 url.php
    -rw-r--r--  1 phpmyadmin nginx 7.6K Aug  3 10:02 user_password.php
    -rw-r--r--  1 phpmyadmin nginx  704 Aug  3 10:02 version_check.php
    -rw-r--r--  1 phpmyadmin nginx 8.7K Aug  3 10:02 view_create.php
    -rw-r--r--  1 phpmyadmin nginx 3.6K Aug  3 10:02 view_operations.php
    -rw-r--r--  1 phpmyadmin nginx 1.1K Aug  3 10:02 webapp.php
     
  3. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    The other thing to check is phpmyadmin.sh install and update logs in /root/centminlogs

    Code:
    ls -lahrt /root/centminlogs/ | grep phpmyadmin
    -rw-r--r-- 1 root root 9.2K Aug  3 10:03 centminmod_phpmyadmin_install_030815-100155.log
    -rw-r--r-- 1 root root  19K Aug  4 02:20 centminmod_phpmyadmin_update-040815-021901.log
    -rw-r--r-- 1 root root  518 Aug  5 02:19 centminmod_phpmyadmin_update-050815-021901.log
    -rw-r--r-- 1 root root 7.2K Aug  6 02:19 centminmod_phpmyadmin_update-060815-021901.log
    outputting the install log to SSH screen
    Code:
    cat /root/centminlogs/centminmod_phpmyadmin_install_030815-100155.log
    then copy and paste contents to pastebin.com or gist.github.com so you can share the link

    Also check phpmyadmin dedicated error logs
    Code:
    dedicated php error log: /var/log/php_myadmin_error.log
    ---------------------------------------------------------------
    SSL vhost access log: /var/log/nginx/localhost_ssl.access.log
    SSL vhost error log: /var/log/nginx/localhost_ssl.error.log
    ---------------------------------------------------------------
     
  4. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    The other thing I can think of is if your server has more than 1 IP address and you updated DNS for domain with an IP address that isn't the main server IP address so domain to server host resolution isn't picking up main hostname path.
     
  5. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    7:25 PM
  6. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    7:25 PM
    well if hostname doesn't work then the ip way should work right?
     
  7. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    the pastebin looks good
    only if there's 1 IP address on server.. if you have multiple IP addresses on server and you binded/updated DNS for that hostname.yourdomain.com to an IP other than main IP address, then I can see why it won't work and get 404
     
  8. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Anything in phpmyadmin logs ?
    Code:
    dedicated php error log: /var/log/php_myadmin_error.log
    ---------------------------------------------------------------
    SSL vhost access log: /var/log/nginx/localhost_ssl.access.log
    SSL vhost error log: /var/log/nginx/localhost_ssl.error.log
    ---------------------------------------------------------------
    also contents of /usr/local/nginx/conf/php_2471_mysqladmin21680.conf ?
     
  9. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    7:25 PM
    nothing on the logs.. I only got one 1 ip

    here is my /etc/sysconfig/net file


    NETWORKING=yes
    HOSTNAME=hostname.cinebuffer.com
    GATEWAY=193.105.134.1
     
  10. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Then I'm a bit stumped as the phpmyadmin.sh log output looks good and if you said all files exist at /usr/local/nginx/html/2471_mysqladmin21680 directory then it should work.
     
  11. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    7:25 PM
    that's what I would assume as well:( check your conversations
     
  12. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @Vija okay the problem is just simply that your hostname.cinebuffer.com needs a valid A record pointing to server IP.. i did local pc file edit on my end and confirmed once DNS is value it works without 404 error

    ip access won't work now it seems - valid dns for hostname.cinebuffer.com is needed
     
  13. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    7:25 PM
    How do I add valid dns for the hostname I thought I already had it..
     
  14. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    same as how you added A record for domain.com, add A record for hostname.domain.com at your DNS management/registrar

    you don't need to update DNS though you can do local PC file edit so only you can view it via hostname heh

    If you want to preview newdomain.com on new centminmod server without updating DNS, on Windows PC edit your windows HOSTS file at c:\Windows\System32\Drivers\etc\hosts (see guide at Modify your hosts file | Knowledge Center | Rackspace Hosting or install Hostman app HostsMan - abelhadigital.com which can manage the file too and allows easy dns flushing when you make changes to the hosts file.

    c:\Windows\System32\Drivers\etc\hosts contents to preview without DNS update
    Code:
    centminmodserver-ip-address newdomain.com
    to disable preview comment it out and flush dns for your system
    Code:
    #centminmodserver-ip-address newdomain.com
    Hostsman app to flush dns and edit the c:\Windows\System32\Drivers\etc\hosts file
     
  15. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  16. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    7:25 PM
    Thank you;) I think I got it working.. I am using goddy DNS Records
     
  17. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Great :)
     
  18. pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    5:25 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Does phpmyadmin doesn't work anymore on latest Centminmod 09 beta due to http2/spdy changes?

    I got a new vps to do some tests and after installing phpmyadmin using:

    Code:
    cd /usr/local/src/centminmod-123.09beta01/addons
    wget --no-check-certificate https://github.com/centminmod/phpmyadmin/raw/master/phpmyadmin.sh
    chmod 0700 /usr/local/src/centminmod-123.09beta01/addons/phpmyadmin.sh
    ./phpmyadmin.sh install
    I got this when i try to restart Nginx:

    Code:
    Starting nginx: nginx: [emerg] invalid parameter "spdy" in /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf:3
    Line 3 from phpmyadmin_ssl.conf:

    Code:
    listen 443 ssl spdy;
    But as i can see i was not disable SPDY on installation......:

    Code:
    NGINX_SPDY=y
     
  19. eva2000

    eva2000 Administrator Staff Member

    54,098
    12,177
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,735
    Local Time:
    1:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  20. pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    5:25 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    That was fast :)

    GReat thanks for the update .....

    After editing the spdy to http2 and comment the spdy header as you told me i try to restart the Nginx and i got this now:

    Code:
    [root@vultr addons]# ngxrestart
    shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
    chdir: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory