[SOLVED] Mageia 8 INSTALL - stuck at phpmyadmin

[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

[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

[Danquest]

I don't know where I have configured to "allowing phpMyAdmin to anyone other than localhost" !!
How can I correct this ?

[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 ~]#

[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 ?

[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
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.

[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.

[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.

[morgano]

Probably yet another expression of Bug 29830 - drakrpm autoselects dependencies from a disabled repo, and install them (upgrade applet too?)

[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.

[Danquest]

DONE - THANKS