Page 1 of 1

[SOLVED] Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 8th, '22, 18:13
by Danquest
Hi,

Installing Mageia 8 on a new computer
and having successfully followed this procedure in :
https://wiki.mageia.org/en/Task-lamp-installation
down to the lines :
"
To start phpMyAdmin, in the address bar of your browser, type:
localhost/phpmyadmin
"
The web page : localhost/phpmyadmin remains EMPTY.

I have restarted "httpd" et "mysqld" to ensure that modifications have been applied.

Any explanation and/or solution ?

Waiting/Hoping

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 8th, '22, 18:55
by doktor5000
Did you test this successfully? https://wiki.mageia.org/en/Task-lamp-in ... n#Test_PHP

Cannot really reproduce your issue. Fresh install, installed task-lamp, started httpd.service and in browser visited http://localhost/phpmyadmin - works fine.
FWIW, depending on the browser, https://wiki.mageia.org/en/Task-lamp-installation#Method_1_:_From_the_local_browser_.28on_the_server_concerned.29: is not correct because that is not a proper URL, it's missing the protocol http://localhost/phpmyadmin

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 8th, '22, 19:06
by Danquest
I don't know where I have configured to "allowing phpMyAdmin to anyone other than localhost" !!
How can I correct this ?

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 8th, '22, 23:33
by doktor5000
Well, did you configure something like that? And do you try to access it locally on the box where phpmyadmin is installed, or do you try to access it from somewhere else?
By default it's only allowed from localhost per /etc/httpd/conf/sites.d/phpmyadmin.conf

The configuration for this is also shown in the wiki below https://wiki.mageia.org/en/Task-lamp-in ... terface.29:

This is the default config:

Code: Select all
[root@localhost ~]# cat /etc/httpd/conf/sites.d/phpmyadmin.conf
# phpMyAdmin - Web based MySQL browser written in php
#
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
    ErrorDocument 403 "Access denied per /etc/httpd/conf/webapps.d/phpmyadmin.conf"
</Directory>

<Directory /usr/share/phpmyadmin/setup/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
    ErrorDocument 403 "Access denied per /etc/httpd/conf/webapps.d/phpmyadmin.conf"
</Directory>

# These directories do not require access over HTTP - taken from the original
# phpmyadmin upstream tarball
#
<Directory /usr/share/phpmyadmin/libraries/>
    <IfModule mod_authz_core.c>
        # Apache 2.4
        <RequireAny>
            Require all denied
        </RequireAny>
    </IfModule>
    <IfModule !mod_authz_core.c>
        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from None
    </IfModule>
</Directory>

<Directory /usr/share/phpmyadmin/setup/lib/>
    <IfModule mod_authz_core.c>
        # Apache 2.4
        <RequireAny>
            Require all denied
        </RequireAny>
    </IfModule>
    <IfModule !mod_authz_core.c>
        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from None
    </IfModule>
</Directory>

<Directory /usr/share/phpmyadmin/setup/frames/>
    <IfModule mod_authz_core.c>
        # Apache 2.4
        <RequireAny>
            Require all denied
        </RequireAny>
    </IfModule>
    <IfModule !mod_authz_core.c>
        # Apache 2.2
        Order Deny,Allow
        Deny from All
        Allow from None
    </IfModule>
</Directory>

# This configuration prevents mod_security at phpmyadmin directories from
# filtering SQL etc.  This may break your mod_security implementation.
#
#<IfModule mod_security.c>
#    <Directory /usr/share/phpmyadmin/>
#        SecRuleInheritance Off
#    </Directory>
#</IfModule>
[root@localhost ~]#

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 9th, '22, 12:22
by Danquest
Well, sure I never intended "allowing phpMyAdmin to anyone other than localhost", and still can't see how I might have done it inadvertently !
I have compared line by line my /etc/httpd/conf/sites.d/phpmyadmin.conf to yours : they are identical (for further certainty I have [after saving] replaced them).
Still :
http://localhost/ is ok, showing "It works!"
http://localhost/info.php is ok, showing "PHP Version 8.0.15" ...(all that description with no mention of phpmyadmin)
http://localhost/phpmyadmin/ is WRONG, showing "This page isn’t working localhost is currently unable to handle this request. HTTP ERROR 500" on Chromium, nothing on Firefox (the page is shown blank).
| My project :
I have, for years, developped my web site locally (localhost) before setting - now improving- it on production.
( My localhost site is alternatively on Debian or on Mageia, - at present on Debian 10)
| Note ;
During my execution of https://wiki.mageia.org/en/Task-lamp-installation till I got stuck at "http://localhost/phpmyadmin", in paragraph "Method 1 : From the local browser (on the server concerned):",
I did not go on with the next "Method 2 : From a remote browser (you do not have a graphical user interface):", which did not concern me ...

What else ?

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 9th, '22, 14:35
by sturmvogel
I have never done something like this, so you can call me completly unexperinced at this topic. Call me a MySQL/PHP/MariaDB-Noob if you want :D
But i did try do reproduce your problem and set up a VM for it. I followed the steps from the mentioned wiki and was able to setup everything (as far as my limited understanding of this topic is reaching).

- startet httpd.service
- startet mysqld.service
- Typed "localhost" into browser: It returned "It works!
- i didn't change working directory. It is still at /var/www/html/
- called "mysql_secure_installation" and did nothing change, only enter, enter, enter.....
- restart of MariaDb with "systemctl restart mysqld.service"
- connected to database with "mysql -u root -p" and closed it after i had success
- created info.php file for testing with "echo "<?php phpinfo();?>" >>/var/www/html/info.php && chmod a+r /var/www/html/info.php"
- opened " http://localhost/info.php" in browser an many informations about php show up
- typed "http://localhost/phpmyadmin" into browser and the phpMyAdmin login page showed up
- logged in as root and created new user and database
- restartet computer and accessed phpmyadmin with new user/psswd


So, the wiki itself is correct and works as intended.

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 9th, '22, 15:45
by Danquest
Yes, I agree - except for your "Noob" appreciation.
So, thanks to your redoing on your side, the metapackage implemented by https://wiki.mageia.org/en/Task-lamp-installation is proved correct.
However, I remember seeing something "unexpected" during the installation of Myql during its my execution, but that let me proceed to showing phpmyadmin where I got stuck.
And I have some other unexpected thing in Sources List through my MCC.
I'll look into that again for description and I'll come back to this afterwards.

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 16th, '22, 13:00
by Danquest
Finally, taking into account your console instructions and having further exchanges with my French "co-Mageians" on https://web.libera.chat/#MLO, it was found that
a module called during the execution of that metapackage, did not "match", due to a mixture of modules from 8.1 and 8.0.15 Mageia sources.
So, a problem due to the depositories used during my installation.
Ok now after reinstalling accordingly.
Thanks to you all.

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 16th, '22, 13:44
by morgano

Re: Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 16th, '22, 19:50
by doktor5000
Please don't forget to mark the thread as solved, by editing the subject of the first post and prefix it with [SOLVED], thanks in advance.

Re: [SOLVED] Mageia 8 INSTALL - stuck at phpmyadmin

PostPosted: Feb 17th, '22, 11:32
by Danquest
DONE - THANKS