phpmyadmin returns blank page

rubysarda 2021-02-23 06:48:03 UTC #1

Keywords: WordPress - Google Cloud Platform - Technical issue - Other
bnsupport ID: 7c830ae3-e6e6-412a-f0cf-b9e7571c93e8
Description:
I am using ssh tunnel to login to mysql but http://127.0.0.1:8888/phpmyadmin is blank page. Cannot see the login box. Support ticket is 7c830ae3-e6e6-412a-f0cf-b9e7571c93e8

Thanks

gongomgra 2021-02-23 11:11:55 UTC #2

Hi @rubysarda,

I don't see any error related to phpMyAdmin in your logs, but I see one about not enough disk space.

[Tue Feb 23 03:32:58.396887 2021] [proxy_fcgi:error] [pid 24669:tid 140609008285440] [client CLIENT_IP:12272] AH01071: Got error 'PHP message: WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE `wp_options` SET `option_value` = '1614051126.1307199001312255859375' WHERE `option_name` = '_transient_doing_cron' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, wp_cron, spawn_cron, set_transient, update_optionPHP message: PHP Fatal error:  Uncaught Error: Class 'WPMailSMTP\\WP' not found in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/wp-mail-smtp/src/Core.php:152\nStack trace:\n#0 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(287): WPMailSMTP\\Core->init('')\n#1 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, Array)\n#2 /opt/bitnami/apps/wordpress/htdocs/wp-includes/plugin.php(484): WP_Hook->do_action(Array)\n#3 /opt/bitnami/apps/wordpress/htdocs/wp-settings.php(557): do_action('init')\n#4 /opt/bitnami/apps/wordpress/htdocs/wp-config.php(108): require_once('/opt/bitnami/ap...')\n#5 /opt/bitnami/apps/wordpress/htdocs/wp-load.php(37): require_once('/opt/bitnami/ap...')\n#6 /opt/bitnami/apps/wordpress/htdocs/xmlrpc.php(31): require_once('/opt/bitnami/ap...')\n#7 {main}\n  thrown in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/wp-mail-smtp/src/Core.php on line 152'
[Tue Feb 23 03:32:58.397147 2021] [log_config:warn] [pid 24669:tid 140609008285440] (28)No space left on device: [client CLIENT_IP:12272] AH00646: Error writing to logs/access_log

I see you fixed that issue, but I don't know if it has any relationship with the phpMyAdmin issue.

-----------------------------------
Check free amount of disk space
-----------------------------------
Running: df -h
In: /opt/bitnami

Output:

Filesystem      Size  Used Avail Use% Mounted on
udev             13G     0   13G   0% /dev
tmpfs           2.6G   11M  2.6G   1% /run
/dev/sda1        99G  9.4G   85G  10% /
tmpfs            13G     0   13G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs            13G     0   13G   0% /sys/fs/cgroup

Can you SSH connect to your server and run the next command?

curl -LI "http://127.0.0.1/phpmyadmin"

After that, can you start the SSH tunnel again and run the next command from your computer?

curl -LI "http://127.0.0.1:8888/phpmyadmin"

I also see a lot of PageSpeed errors in the Apache logs. Can you try to disable it?

https://docs.bitnami.com/google/apps/wordpress/administration/use-pagespeed/

rubysarda 2021-02-23 20:14:06 UTC #3

When I run the above commands I get an error
curl: (3) Illegal characters found in URL

Thanks for the suggestion on page speed errors. I will disable it over the
weekend.
Can you also tell me what is taking up so much space on the drive?

Thanks,
Ruby

rubysarda 2021-02-23 20:23:18 UTC #4

I removed the " and the output is:

HTTP/1.1 301 Moved PermanentlyDate: Tue, 23 Feb 2021 20:14:51 GMTServer:
ApacheX-Frame-Options: SAMEORIGINLocation:
https://www.talosys.io/phpmyadminContent-Type:
text/html; charset=iso-8859-1HTTP/1.1 403 ForbiddenDate: Tue, 23 Feb 2021
20:14:51 GMTContent-Type: text/html; charset=iso-8859-1Connection:
keep-aliveSet-Cookie: __cfduid=dbc3a24f9a6e28699725d28e6df79390d1614111291;
expires=Thu, 25-Mar-21 20:14:51 GMT; path=/; domain=.talosys.io; HttpOnly;
SameSite=Lax; SecureX-Frame-Options: SAMEORIGINCF-Cache-Status:
DYNAMICcf-request-id:
087220d09b0000368a1abdc000000001Expect-CT: max-age=604800, report-uri="
https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct"Report-To:
{"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com
\/report?s=Ky0BUsnjI6Z0wrKxg%2B1kt9xDVHtNt8YAQF3%2Fm
LolA8zB6tnthIUCl7xT1bOEAVG4d03BQcTMBxlTWWqM04nyBPdbQER5a%2Fmc3iisEDNAQA%3D%3D"}],"max_age":604800,"group":"cf-nel"}NEL:
{"max_age":604800,"report_to":"cf-nel"}Server: cloudflareCF-RAY:
62639d942d88368a-LAXalt-svc: h3-27=":443"; ma=86400, h3-28=":443";
ma=86400, h3-29=":443"; ma=86400

gongomgra 2021-02-24 10:23:22 UTC #5

Hi @rubysarda,

Sorry, I missed the quote character at the end of the command. Thank you for the output. I think I know what's happening. Your Apache configuration is redirecting to your domain name unconditionally, but you can only access phpMyAdmin when using 127.0.0.1 in the request. Please, update the Apache configuration in the bitnami.conf file as explained in the next guide and restart Apache

https://docs.bitnami.com/bch/apps/wordpress/administration/force-https-apache/#approach-b-self-contained-bitnami-installations

After that, can you try to visit phpmyadmin again?

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!