How is pma supposed to be setup on a slave?

Discussion in 'ISPConfig 3 Priority Support' started by atle, Mar 21, 2021.

  1. atle

    atle Member HowtoForge Supporter

    I have a master, with ISPConfig running, and pma is available on master:8080/phpmyadmin, which is fine.
    The slave www server has been installed with all services (auto install script), but as a slave, and with www and db enabled in ISPConfig. Hence there is nothing there running on 8080. customerdomain/phpmyadmin shows "File not found.". How am I supposed to access pma?

    pma is there, it is installed on the server, but not configured in apache it seems.
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Which auto install script did you use?
     
  3. atle

    atle Member HowtoForge Supporter

    yours
     
  4. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Alright. Is this a apache or nginx server?
     
  5. atle

    atle Member HowtoForge Supporter

    Yup, apache.
     
  6. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    What is the output of
    Code:
    cat /etc/apache2/conf-available/phpmyadmin.conf
    ?
     
  7. atle

    atle Member HowtoForge Supporter

    Code:
    root@www1:~# cat /etc/apache2/conf-available/phpmyadmin.conf
    # phpMyAdmin default Apache configuration
    
    Alias /phpmyadmin /usr/share/phpmyadmin
    
    <Directory /usr/share/phpmyadmin>
     Options FollowSymLinks
     DirectoryIndex index.php
    
     <IfModule mod_php7.c>
     AddType application/x-httpd-php .php
    
     php_flag magic_quotes_gpc Off
     php_flag track_vars On
     php_flag register_globals Off
     php_value include_path .
     </IfModule>
    
    </Directory>
    
    # Authorize for setup
    <Directory /usr/share/phpmyadmin/setup>
     <IfModule mod_authn_file.c>
     AuthType Basic
     AuthName "phpMyAdmin Setup"
     AuthUserFile /etc/phpmyadmin/htpasswd.setup
     </IfModule>
     Require valid-user
    </Directory>
    
    # Disallow web access to directories that don't need it
    <Directory /usr/share/phpmyadmin/libraries>
     Order Deny,Allow
     Deny from All
    </Directory>
    <Directory /usr/share/phpmyadmin/setup/lib>
     Order Deny,Allow
     Deny from All
    </Directory>
     
  8. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Alright, what happens when you run
    Code:
    a2enconf phpmyadmin
    ?
     
  9. atle

    atle Member HowtoForge Supporter

    It says
     
  10. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Alright, so it should be working. Are you sure the customer domain is pointed to the right server?
     
  11. atle

    atle Member HowtoForge Supporter

    yep, https://blogg.click
    I have a site om the master as well, /phpmyadmin does not work on that either, only the 8080 one works.
     
  12. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    What is the content of /usr/share/phpmyadmin?
    Code:
    ls -la /usr/share/phpmyadmin
     
  13. atle

    atle Member HowtoForge Supporter

    Code:
    root@www1:~# ls -la /usr/share/phpmyadmin
    total 836
    drwxr-xr-x  12 root root  4096 mar 12 11:39 .
    drwxr-xr-x 263 root root 12288 mar 12 17:59 ..
    -rw-r--r--   1 root root  1560 jun  4  2019 ajax.php
    -rw-r--r--   1 root root  1750 jun  4  2019 browse_foreigners.php
    -rw-r--r--   1 root root  9570 jun  4  2019 ChangeLog
    -rw-r--r--   1 root root  3194 jun  4  2019 changelog.php
    -rw-r--r--   1 root root   856 jun  4  2019 chk_rel.php
    -rw-r--r--   1 root root  3216 jun  4  2019 CODE_OF_CONDUCT.md
    -rw-r--r--   1 root root  3181 jun  4  2019 composer.json
    -rw-r--r--   1 root root 93959 jun  4  2019 composer.lock
    -rw-r--r--   1 root root  4493 mar 12 11:39 config.inc.php
    -rw-r--r--   1 root root  4516 mar 12 11:39 config.inc.php~20210312113917
    -rw-r--r--   1 root root  4476 mar 12 11:39 config.inc.php~20210312113918
    -rw-r--r--   1 root root  4516 jun  4  2019 config.sample.inc.php
    -rw-r--r--   1 root root  2104 jun  4  2019 CONTRIBUTING.md
    -rw-r--r--   1 root root  5674 jun  4  2019 db_central_columns.php
    -rw-r--r--   1 root root  5878 jun  4  2019 db_datadict.php
    -rw-r--r--   1 root root  7545 jun  4  2019 db_designer.php
    -rw-r--r--   1 root root   271 jun  4  2019 db_events.php
    -rw-r--r--   1 root root  4631 jun  4  2019 db_export.php
    -rw-r--r--   1 root root   899 jun  4  2019 db_import.php
    -rw-r--r--   1 root root  1038 jun  4  2019 db_multi_table_query.php
    -rw-r--r--   1 root root  9860 jun  4  2019 db_operations.php
    -rw-r--r--   1 root root  4859 jun  4  2019 db_qbe.php
    -rw-r--r--   1 root root   365 jun  4  2019 db_routines.php
    -rw-r--r--   1 root root  1997 jun  4  2019 db_search.php
    -rw-r--r--   1 root root   746 jun  4  2019 db_sql_autocomplete.php
    -rw-r--r--   1 root root   485 jun  4  2019 db_sql_format.php
    -rw-r--r--   1 root root   952 jun  4  2019 db_sql.php
    -rw-r--r--   1 root root  1011 jun  4  2019 db_structure.php
    -rw-r--r--   1 root root  4415 jun  4  2019 db_tracking.php
    -rw-r--r--   1 root root   273 jun  4  2019 db_triggers.php
    -rw-r--r--   1 root root  1816 jun  4  2019 DCO
    drwxr-xr-x   3 root root  4096 jun  4  2019 doc
    -rw-r--r--   1 root root  4605 jun  4  2019 error_report.php
    drwxr-xr-x   2 root root  4096 jun  4  2019 examples
    -rw-r--r--   1 root root 15919 jun  4  2019 export.php
    -rw-r--r--   1 root root 22486 jun  4  2019 favicon.ico
    -rw-r--r--   1 root root 15984 jun  4  2019 gis_data_editor.php
    -rw-r--r--   1 root root 23976 jun  4  2019 import.php
    -rw-r--r--   1 root root  3404 jun  4  2019 import_status.php
    -rw-r--r--   1 root root 20222 jun  4  2019 index.php
    drwxr-xr-x   7 root root  4096 jun  4  2019 js
    drwxr-xr-x   6 root root  4096 jun  4  2019 libraries
    -rw-r--r--   1 root root 18092 jun  4  2019 LICENSE
    -rw-r--r--   1 root root   894 jun  4  2019 license.php
    -rw-r--r--   1 root root  1430 jun  4  2019 lint.php
    drwxr-xr-x  46 root root  4096 jun  4  2019 locale
    -rw-r--r--   1 root root   311 jun  4  2019 logout.php
    -rw-r--r--   1 root root  2309 jun  4  2019 navigation.php
    -rw-r--r--   1 root root  4143 jun  4  2019 normalization.php
    -rw-r--r--   1 root root   729 jun  4  2019 package.json
    -rw-r--r--   1 root root   467 jun  4  2019 phpcs.xml.dist
    -rw-r--r--   1 root root   507 jun  4  2019 phpinfo.php
    -rw-r--r--   1 root root   740 jun  4  2019 phpmyadmin.css.php
    -rw-r--r--   1 root root  2493 jun  4  2019 prefs_forms.php
    -rw-r--r--   1 root root 14356 jun  4  2019 prefs_manage.php
    -rw-r--r--   1 root root  1594 jun  4  2019 prefs_twofactor.php
    -rw-r--r--   1 root root  1213 jun  4  2019 print.css
    -rw-r--r--   1 root root  1522 jun  4  2019 README
    -rw-r--r--   1 root root    29 jun  4  2019 RELEASE-DATE-4.9.0.1
    -rw-r--r--   1 root root    26 jun  4  2019 robots.txt
    -rw-r--r--   1 root root   659 jun  4  2019 schema_export.php
    -rw-r--r--   1 root root   785 jun  4  2019 server_binlog.php
    -rw-r--r--   1 root root   818 jun  4  2019 server_collations.php
    -rw-r--r--   1 root root   798 jun  4  2019 server_databases.php
    -rw-r--r--   1 root root   784 jun  4  2019 server_engines.php
    -rw-r--r--   1 root root  1085 jun  4  2019 server_export.php
    -rw-r--r--   1 root root   634 jun  4  2019 server_import.php
    -rw-r--r--   1 root root   784 jun  4  2019 server_plugins.php
    -rw-r--r--   1 root root 14195 jun  4  2019 server_privileges.php
    -rw-r--r--   1 root root  2432 jun  4  2019 server_replication.php
    -rw-r--r--   1 root root   698 jun  4  2019 server_sql.php
    -rw-r--r--   1 root root   862 jun  4  2019 server_status_advisor.php
    -rw-r--r--   1 root root  2962 jun  4  2019 server_status_monitor.php
    -rw-r--r--   1 root root   897 jun  4  2019 server_status.php
    -rw-r--r--   1 root root  1879 jun  4  2019 server_status_processes.php
    -rw-r--r--   1 root root  1423 jun  4  2019 server_status_queries.php
    -rw-r--r--   1 root root  1562 jun  4  2019 server_status_variables.php
    -rw-r--r--   1 root root  1868 jun  4  2019 server_user_groups.php
    -rw-r--r--   1 root root   798 jun  4  2019 server_variables.php
    drwxr-xr-x   4 root root  4096 jun  4  2019 setup
    -rw-r--r--   1 root root  1040 jun  4  2019 show_config_errors.php
    drwxr-xr-x   2 root root  4096 jun  4  2019 sql
    -rw-r--r--   1 root root  6128 jun  4  2019 sql.php
    -rw-r--r--   1 root root  3754 jun  4  2019 tbl_addfield.php
    -rw-r--r--   1 root root  6349 jun  4  2019 tbl_change.php
    -rw-r--r--   1 root root   972 jun  4  2019 tbl_chart.php
    -rw-r--r--   1 root root  3365 jun  4  2019 tbl_create.php
    -rw-r--r--   1 root root  4343 jun  4  2019 tbl_export.php
    -rw-r--r--   1 root root   999 jun  4  2019 tbl_find_replace.php
    -rw-r--r--   1 root root  1450 jun  4  2019 tbl_get_field.php
    -rw-r--r--   1 root root  1234 jun  4  2019 tbl_gis_visualization.php
    -rw-r--r--   1 root root   684 jun  4  2019 tbl_import.php
    -rw-r--r--   1 root root  1401 jun  4  2019 tbl_indexes.php
    -rw-r--r--   1 root root 15352 jun  4  2019 tbl_operations.php
    -rw-r--r--   1 root root   452 jun  4  2019 tbl_recent_favorite.php
    -rw-r--r--   1 root root  2375 jun  4  2019 tbl_relation.php
    -rw-r--r--   1 root root 16972 jun  4  2019 tbl_replace.php
    -rw-r--r--   1 root root  5005 jun  4  2019 tbl_row_action.php
    -rw-r--r--   1 root root  1130 jun  4  2019 tbl_select.php
    -rw-r--r--   1 root root  1176 jun  4  2019 tbl_sql.php
    -rw-r--r--   1 root root  2042 jun  4  2019 tbl_structure.php
    -rw-r--r--   1 root root  5797 jun  4  2019 tbl_tracking.php
    -rw-r--r--   1 root root   141 jun  4  2019 tbl_triggers.php
    -rw-r--r--   1 root root  1049 jun  4  2019 tbl_zoom_select.php
    drwxr-xr-x  19 root root  4096 jun  4  2019 templates
    drwxr-xr-x   4 root root  4096 jun  4  2019 themes
    -rw-r--r--   1 root root   956 jun  4  2019 themes.php
    -rw-r--r--   1 root root  1910 jun  4  2019 transformation_overview.php
    -rw-r--r--   1 root root  4617 jun  4  2019 transformation_wrapper.php
    -rw-r--r--   1 root root  1296 jun  4  2019 url.php
    -rw-r--r--   1 root root  1934 jun  4  2019 user_password.php
    drwxr-xr-x  15 root root  4096 jun  4  2019 vendor
    -rw-r--r--   1 root root  1085 jun  4  2019 version_check.php
    -rw-r--r--   1 root root  6604 jun  4  2019 view_create.php
    -rw-r--r--   1 root root  3866 jun  4  2019 view_operations.php
    -rw-r--r--   1 root root 29031 jun  4  2019 yarn.lock
     
  14. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Have you done any customizations? What did you do prior to running the install script?

    On all of my systems it is working fine, so it must be a local issue.
     
  15. atle

    atle Member HowtoForge Supporter

    No, no customisations at all. It is not in production yet. apt-get update and upgrade was done prior to the auto install script was run. Only two test sites setup, one on each server. All servers were re-installed from scratch with the auto-install script about a week ago, the www server at the same time you released 3.2.3.

    the master was updated with the update script, the www was installed from scratch with 323
     
  16. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Can you take a look at the Apache log for that web?
     
  17. atle

    atle Member HowtoForge Supporter

    Yes, I have done that and there was just a 404 for the /phpmyadmin request, and nothing in the error_logs. I am now re-installing the test site. Will take another look at the log files when it is back up in a couple of minutes.
     
  18. atle

    atle Member HowtoForge Supporter

    I made a re-install of the site, and now I get a 503, hm.
    [​IMG]
     
  19. atle

    atle Member HowtoForge Supporter

  20. atle

    atle Member HowtoForge Supporter

    Noticed that I have installed mod_sec with owasp, will disable it to see if makes a difference, it might throw a 503 then it is hit.
     

Share This Page