[SOLVED]phpmyadmin is loaded but not showing?

odp · 2014-04-01 12:22:58

HI folks,

Confused by the title, don't be this is exactly what is happening. I have followed the directives in https://bbs.archlinux.org/viewtopic.php?id=178124 and in the official LAMP (using mod_mpm_prefork) and phpMyAdmin wiki.
Meaning I have updated the Alias:

Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
    DirectoryIndex index.html index.php
    AllowOverride All
    Options FollowSymlinks
    Require all granted
</Directory>

made sure /usr/share/webapps and /etc/webapps is in php's open_basedir

and so on...
------------------------------
When I browse to localhost/phpmyadmin the page load and it is blank, but the favicon is present. So I view the page source and there is the markup for the page, it is just not showing. clicking on index.php in the forms action value reveals that index.php is not found?

in my httpd.conf file I have

ProxyPassMatch ^/phpmyadmin/(.*\.php)$ fcgi://127.0.0.1:9000/usr/share/webapps/phpMyAdmin/$1
ProxyPassMatch ^/phpmyadmin(.*/)$ fcgi://127.0.0.1:9000/usr/share/webapps/phpMyAdmin$1index.php

which is stated here https://bbs.archlinux.org/viewtopic.php … 2#p1391072

This is what I got, apache is running, php working, mod_rewrite works, mysqli working, only phpmyadmin is acting up. I am a little blank here.

any advice is appreciated, thanks

Last edited by odp (2014-04-09 11:11:45)

qinohe · 2014-04-01 12:49:52

Well, I'm not quite sure here, but, did you let your browser point to /phpmyadmin:9000
Since you use a proxy?

odp · 2014-04-01 15:49:17

no. All .php is handled like this

ProxyPassMatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/srv/http/$1

qinohe · 2014-04-01 17:42:52

Ah right..did you set;

listen = 127.0.0.1:9000

in your 'php-fpm.conf', and restarted httpd and php-fpm?

odp · 2014-04-02 20:39:39

sure did! As I wrote initialy I have everything I need up and running except phpmyadmin. It loads a blank page but the favicon loads, and if I view the page source I can see that the page is 'loaded' I just can't see it

<!DOCTYPE HTML><html lang='en' dir='ltr' class='firefox firefox28'><meta charset="utf-8" /><meta name="robots" content="noindex,nofollow" /><meta http-equiv="X-UA-Compatible" content="IE=Edge"><style>html{display: none;}</style><link rel="icon" href="favicon.ico" type="image/x-icon" /><link rel="shortcut icon" href="favicon.ico" type="image/x-icon" /><link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&amp;token=ab44c502e8e8abb00f9356daf2fe16df&amp;nocache=4181654235ltr" /><link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.9.2.custom.css" /><title>phpMyAdmin</title><script type="text/javascript" src="js/get_scripts.js.php?token=ab44c502e8e8abb00f9356daf2fe16df&scripts[]=jquery/jquery-1.8.3.min.js&scripts[]=ajax.js&scripts[]=keyhandler.js&scripts[]=jquery/jquery-ui-1.9.2.custom.min.js&scripts[]=jquery/jquery.sprintf.js&scripts[]=jquery/jquery.cookie.js&scripts[]=jquery/jquery.mousewheel.js&scripts[]=jquery/jquery.event.drag-2.2.js&scripts[]=jquery/jquery-ui-timepicker-addon.js&scripts[]=jquery/jquery.ba-hashchange-1.3.js&scripts[]=jquery/jquery.debounce-1.0.5.js&scripts[]=jquery/jquery.menuResizer-1.0.js&scripts[]=cross_framing_protection.js&scripts[]=rte.js&scripts[]=tracekit/tracekit.js&scripts[]=error_report.js&scripts[]=doclinks.js&scripts[]=functions.js&scripts[]=navigation.js&scripts[]=indexes.js&scripts[]=common.js&scripts[]=codemirror/lib/codemirror.js&scripts[]=codemirror/mode/sql/sql.js&scripts[]=codemirror/addon/runmode/runmode.js"></script><script type='text/javascript' src='js/messages.php?lang=en&amp;db=&amp;token=ab44c502e8e8abb00f9356daf2fe16df'></script><script type='text/javascript' src='js/get_image.js.php?theme=pmahomme'></script><script type="text/javascript">// <![CDATA[
PMA_commonParams.setAll({common_query:"token=ab44c502e8e8abb00f9356daf2fe16df",opendb_url:"db_structure.php",safari_browser:"0",querywindow_height:"400",querywindow_width:"600",collation_connection:"utf8_general_ci",lang:"en",server:"1",table:"",db:"",token:"ab44c502e8e8abb00f9356daf2fe16df",text_dir:"ltr",pma_absolute_uri:"https://82.211.226.183/phpmyadmin/",pma_text_default_tab:"Browse",pma_text_left_default_tab:"Structure",confirm:"1"});
AJAX.scriptHandler.add("jquery/jquery-1.8.3.min.js",0).add("ajax.js",0).add("keyhandler.js",1).add("jquery/jquery-ui-1.9.2.custom.min.js",0).add("jquery/jquery.sprintf.js",0).add("jquery/jquery.cookie.js",0).add("jquery/jquery.mousewheel.js",0).add("jquery/jquery.event.drag-2.2.js",0).add("jquery/jquery-ui-timepicker-addon.js",0).add("jquery/jquery.ba-hashchange-1.3.js",0).add("jquery/jquery.debounce-1.0.5.js",0).add("jquery/jquery.menuResizer-1.0.js",0).add("cross_framing_protection.js",0).add("rte.js",1).add("tracekit/tracekit.js",1).add("error_report.js",1).add("messages.php?lang=en&amp;db=&amp;token=ab44c502e8e8abb00f9356daf2fe16df",0).add("get_image.js.php?theme=pmahomme",0).add("doclinks.js",1).add("functions.js",1).add("navigation.js",0).add("indexes.js",1).add("common.js",1).add("codemirror/lib/codemirror.js",0).add("codemirror/mode/sql/sql.js",0).add("codemirror/addon/runmode/runmode.js",0);
$(function() {AJAX.fireOnload("keyhandler.js");AJAX.fireOnload("rte.js");AJAX.fireOnload("tracekit/tracekit.js");AJAX.fireOnload("error_report.js");AJAX.fireOnload("doclinks.js");AJAX.fireOnload("functions.js");AJAX.fireOnload("indexes.js");AJAX.fireOnload("common.js");});
// ]]></script></head><body id='loginform'><div id="page_content">
    <div class="container">
    <a href="./url.php?url=http%3A%2F%2Fwww.phpmyadmin.net%2F&amp;token=ab44c502e8e8abb00f9356daf2fe16df" target="_blank" class="logo"><img src="./themes/pmahomme/img/logo_right.png" id="imLogo" name="imLogo" alt="phpMyAdmin" border="0" /></a>
       <h1>Welcome to <bdo dir="ltr" lang="en">phpMyAdmin</bdo></h1><noscript>
<div class="error"><img src="themes/dot.gif" title="" alt="" class="icon ic_s_error" /> Javascript must be enabled past this point</div></noscript>
<div class='hide js-show'><form method="get" action="index.php" class="disableAjax"><input type="hidden" name="db" value="" /><input type="hidden" name="table" value="" /><input type="hidden" name="token" value="ab44c502e8e8abb00f9356daf2fe16df" /><fieldset><legend lang="en" dir="ltr">Language</legend><select name="lang" class="autosubmit" lang="en" dir="ltr" id="sel-lang"><option value="ar">&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577; - Arabic</option><option value="bg">&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080; - Bulgarian</option><option value="bn">বাংলা - Bangla</option><option value="ca">Catal&agrave; - Catalan</option><option value="cs">Čeština - Czech</option><option value="da">Dansk - Danish</option><option value="de">Deutsch - German</option><option value="el">&Epsilon;&lambda;&lambda;&eta;&nu;&iota;&kappa;&#940; - Greek</option><option value="en" selected="selected">English</option><option value="en_GB">English (United Kingdom)</option><option value="es">Espa&ntilde;ol - Spanish</option><option value="et">Eesti - Estonian</option><option value="fi">Suomi - Finnish</option><option value="fr">Fran&ccedil;ais - French</option><option value="gl">Galego - Galician</option><option value="hi">&#2361;&#2367;&#2344;&#2381;&#2342;&#2368; - Hindi</option><option value="hu">Magyar - Hungarian</option><option value="ia">Interlingua - Interlingua</option><option value="id">Bahasa Indonesia - Indonesian</option><option value="it">Italiano - Italian</option><option value="ja">&#26085;&#26412;&#35486; - Japanese</option><option value="ko">&#54620;&#44397;&#50612; - Korean</option><option value="lt">Lietuvi&#371; - Lithuanian</option><option value="nb">Norsk - Norwegian</option><option value="nl">Nederlands - Dutch</option><option value="pl">Polski - Polish</option><option value="pt">Portugu&ecirc;s - Portuguese</option><option value="pt_BR">Portugu&ecirc;s - Brazilian portuguese</option><option value="ro">Rom&acirc;n&#259; - Romanian</option><option value="ru">&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081; - Russian</option><option value="si">&#3523;&#3538;&#3458;&#3524;&#3517; - Sinhala</option><option value="sk">Sloven&#269;ina - Slovak</option><option value="sl">Sloven&scaron;&#269;ina - Slovenian</option><option value="sr@latin">Srpski - Serbian latin</option><option value="sv">Svenska - Swedish</option><option value="th">&#3616;&#3634;&#3625;&#3634;&#3652;&#3607;&#3618; - Thai</option><option value="tr">T&uuml;rk&ccedil;e - Turkish</option><option value="uk">&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072; - Ukrainian</option><option value="uz">&#1038;&#1079;&#1073;&#1077;&#1082;&#1095;&#1072; - Uzbek-cyrillic</option><option value="uz@latin">O&lsquo;zbekcha - Uzbek-latin</option><option value="zh_CN">&#20013;&#25991; - Chinese simplified</option><option value="zh_TW">&#20013;&#25991; - Chinese traditional</option></select></fieldset></form></div>
    <br />
    <!-- Login form -->
    <form method="post" action="index.php" name="login_form" class="disableAjax login hide js-show">
        <fieldset>
        <legend>Log in<a href="./doc/html/index.html" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a></legend><div class="item">
                <label for="input_username">Username:</label>
                <input type="text" name="pma_username" id="input_username" value="" size="24" class="textfield"/>
            </div>
            <div class="item">
                <label for="input_password">Password:</label>
                <input type="password" name="pma_password" id="input_password" value="" size="24" class="textfield" />
            </div>    <input type="hidden" name="server" value="1" /></fieldset>
        <fieldset class="tblFooters">
            <input value="Go" type="submit" id="input_go" /><input type="hidden" name="target" value="phpmyadmin" /><input type="hidden" name="token" value="ab44c502e8e8abb00f9356daf2fe16df" /></fieldset>
    </form></div></div></body></html>

mrunion · 2014-04-03 13:59:38

I wonder if it's having problems finding jQuery or some other javascript code. Load the page in a browser with dev tools (like Firebug) and try to toggle off the "hide" class on the element:

<form ... name="login_form" ...>

Can you see the form now?

Also, verify the console doesn't show any errors about things not being found.

odp · 2014-04-04 12:50:07

ReferenceError: PMA_commonParams is not defined
localhost/phpmyadmin/
Line 2

<script src="js/get_scripts.js.php?token=b7996e5f1fc21d0f42f4c78a74442b14&scripts[]=jquery/jquery-1.8.3.min.js&scripts[]=ajax.js&scripts[]=keyhandler.js&scripts[]=jquery/jquery-ui-1.9.2.custom.min.js&scripts[]=jquery/jquery.sprintf.js&scripts[]=jquery/jquery.cookie.js&scripts[]=jquery/jquery.mousewheel.js&scripts[]=jquery/jquery.event.drag-2.2.js&scripts[]=jquery/jquery-ui-timepicker-addon.js&scripts[]=jquery/jquery.ba-hashchange-1.3.js&scripts[]=jquery/jquery.debounce-1.0.5.js&scripts[]=jquery/jquery.menuResizer-1.0.js&scripts[]=cross_framing_protection.js&scripts[]=rte.js&scripts[]=tracekit/tracekit.js&scripts[]=error_report.js&scripts[]=doclinks.js&scripts[]=functions.js&scripts[]=navigation.js&scripts[]=indexes.js&scripts[]=common.js&scripts[]=codemirror/lib/codemirror.js&scripts[]=codemirror/mode/sql/sql.js&scripts[]=codemirror/addon/runmode/runmode.js" type="text/javascript">
File not found.
</script>

css: display: none; changed to display: inline;

result I can see the form unstyled in the dom. submitting the form gives me a 'file not found' on what seems to be index.php

so you are right, it can't find jquery, scripts and css. What can I do about that?

Last edited by odp (2014-04-04 12:55:21)

mrunion · 2014-04-04 17:30:52

Not sure, but I would start by verifying that the actual "site" was set up as it should be in Apache, etc. Then I;d check file permissions to make sure the apache user (I assume the phpadmin site runs as the apache user) can actually see and read the file.

Outside of that, I don't have any idea. But it does seem the phpadmin "site" is not completely set up.

odp · 2014-04-09 11:11:25

gobble gobble, ProxyPassMatch always pics the first statement that it can work with. SO having the first rule matching all .php files and proxy to fcgi is not a good solution

ProxyPassMatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/srv/http/$1

This line should be the last, ALWAYS

Arch Linux

#1 2014-04-01 12:22:58

[SOLVED]phpmyadmin is loaded but not showing?

#2 2014-04-01 12:49:52

Re: [SOLVED]phpmyadmin is loaded but not showing?

#3 2014-04-01 15:49:17

Re: [SOLVED]phpmyadmin is loaded but not showing?

#4 2014-04-01 17:42:52

Re: [SOLVED]phpmyadmin is loaded but not showing?

#5 2014-04-02 20:39:39

Re: [SOLVED]phpmyadmin is loaded but not showing?

#6 2014-04-03 13:59:38

Re: [SOLVED]phpmyadmin is loaded but not showing?

#7 2014-04-04 12:50:07

Re: [SOLVED]phpmyadmin is loaded but not showing?

#8 2014-04-04 17:30:52

Re: [SOLVED]phpmyadmin is loaded but not showing?

#9 2014-04-09 11:11:25

Re: [SOLVED]phpmyadmin is loaded but not showing?

Board footer