phpmyadmin suddently gives http error 500

Question

Hi,

I have 3 Droplets all with ubuntu 18.04, Php 7.2.24, phpmyadmin ver. 4.6.6. Until yesterday phpmyadmin worked fine, but now it gives me HTTP Error 500. Otherwise there is nothing wrong with the servers - (not that i know of). Has anyone experienced the same?.

I have no problem using heidisql

Is there a safe solution to fix the problem. One of the servers is in production, and vulnerale to downtime.

Answer 1

kenboye November 23, 2020

SOLVED!!

After many hours i finally found what was wrong.

In /etc/phpmyadmin/config.inc.php last line there was a “;” missing

$cfg[‘TempDir’] = ’/usr/share/phpmyadmin/tmp’; <– ;

Reply Report

RiseandInspire November 23, 2020

This worked for us as well. 🍻
Reply Report
tapishjain November 24, 2020

Thank you for this solution. It worked perfectly.
Reply Report
mjeed503 November 30, 2020

Thank you a lot.

This solved my issue after 2 days of debugging !

The questions is: Why did the file change suddenly? why did this error appear NOW of all times?
Reply Report
webmaster489734 December 5, 2020

Thanks. Fixed it for me.

How did you diagnose this? in which log did you see the error?

Cheers.
Reply Report
- kenboye December 7, 2020
  
  Hi @webmaster489734
  
  I was desperate to fine the error :). Nothing to see in any logs.
  My experience tells me often errors are in config files.
  
  Reply Report
bdmedizone December 11, 2020

Thanks . You saved my life
Reply Report
iamolly December 23, 2020

DUDE!

Amazing!

How the HELL did this happen?

Anyway, thank you for your fix mate!!!!!
Reply Report

Answer 2

RiseandInspire November 23, 2020

This worked for us as well. 🍻
Reply Report
tapishjain November 24, 2020

Thank you for this solution. It worked perfectly.
Reply Report
mjeed503 November 30, 2020

Thank you a lot.

This solved my issue after 2 days of debugging !

The questions is: Why did the file change suddenly? why did this error appear NOW of all times?
Reply Report
webmaster489734 December 5, 2020

Thanks. Fixed it for me.

How did you diagnose this? in which log did you see the error?

Cheers.
Reply Report
- kenboye December 7, 2020
  
  Hi @webmaster489734
  
  I was desperate to fine the error :). Nothing to see in any logs.
  My experience tells me often errors are in config files.
  
  Reply Report
bdmedizone December 11, 2020

Thanks . You saved my life
Reply Report
iamolly December 23, 2020

DUDE!

Amazing!

How the HELL did this happen?

Anyway, thank you for your fix mate!!!!!
Reply Report

Answer 3

arokiaswamyselina November 25, 2020

Can anyone tell why is this so that the phpMyAdmin server working perfectly fine yesterday suddenly misses a semicolon in the code? Would be great to know the reason.

Reply Report

alexdo November 25, 2020

Hey, arokiaswamyselina

This is quite odd. Have you made any recent changes on the server and is there anyone else that have access to the droplet?

You can use the stat command in order to check when was the last time the file was modified and you can use that as cross reference check if you were working at that time.

The command is used like this:

stat file.php

Hope that this helps!
Regards,
Alex
Reply Report

Answer 4

alexdo November 25, 2020

Hey, arokiaswamyselina

This is quite odd. Have you made any recent changes on the server and is there anyone else that have access to the droplet?

You can use the stat command in order to check when was the last time the file was modified and you can use that as cross reference check if you were working at that time.

The command is used like this:

stat file.php

Hope that this helps!
Regards,
Alex
Reply Report

Answer 5

alexdo November 22, 2020

Hello, @lcgondellesm

I will recommend to examine the web server (Apache/Nginx) error_log in order to track down what exactly is causing the issue.

You can simply execute this command and then access phpMyAdmin in order to see the logged error message:

Apache on Ubuntu:

tail -f /var/log/apache2/error.log

Apache on On Centos:

tail -f /usr/local/apache/logs/error_log

Nginx on Ubuntu:

tail -f /var/log/nginx/error.log

Feel free to share any logged messages here so we can investigate this further.

Hope that this helps!
Regards,
Alex

Reply Report

Answer 6

kenboye November 22, 2020

Thanks for you answer @alexdo , but there is nothing to see in the error.log . I checked the access log and can see I try to run /phpmyadmin.

Reply Report

alexdo November 23, 2020

Hello,

If the issue is still persisting you can try using an alternative browser and also use the developer console in the browser (in Chrome press F12 and then. reload the page to see if there are any other error messages).

Can you please let me know if you’re using Apache or Nginx? Have you made any recent changes on the server and can you please confirm if you’ve used this tutorial in order to install phpMyAdmin?

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04

Regards,
Alex

How To Install and Secure phpMyAdmin on Ubuntu 18.04
by Mark Drake
phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 18.04 server.
Reply Report
- kenboye November 23, 2020
  
  Hi @alexdo
  
  I have solved the problem. See my solution further up in the thred. I use Apache.
  
  Thanks again for you replay.
  
  Reply Report
  
  alexdo November 24, 2020
  
  Thanks for sharing what the issue was and how you were able to solve it!
  
  Regards,
  Alex
  
  Reply Report
  
  arokiaswamyselina November 25, 2020
  
  Can anyone tell why is this so that the phpMyAdmin server working perfectly fine yesterday suddenly misses a semicolon in the code? Would be great to know the reason.
  
  Reply Report
  
  alexdo November 25, 2020
  
  Hey, arokiaswamyselina
  
  This is quite odd. Have you made any recent changes on the server and is there anyone else that have access to the droplet?
  
  You can use the stat command in order to check when was the last time the file was modified and you can use that as cross reference check if you were working at that time.
  
  The command is used like this:
  
  stat file.php
  
  Hope that this helps!
  Regards,
  Alex
  
  Reply Report
  
  kenboye November 25, 2020
  
  Same here. We had not touched the server for a couple of days. right after i fixed it, I upgraded phpmyadmin to ver. 4.9.7
  
  Reply Report
  
  alexdo November 28, 2020
  
  Hello,
  
  I hope that everything is running smoothly now.
  
  Regards,
  Alex
  
  Reply Report

Answer 7

alexdo November 23, 2020

Hello,

If the issue is still persisting you can try using an alternative browser and also use the developer console in the browser (in Chrome press F12 and then. reload the page to see if there are any other error messages).

Can you please let me know if you’re using Apache or Nginx? Have you made any recent changes on the server and can you please confirm if you’ve used this tutorial in order to install phpMyAdmin?

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04

Regards,
Alex

How To Install and Secure phpMyAdmin on Ubuntu 18.04
by Mark Drake
phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 18.04 server.
Reply Report
- kenboye November 23, 2020
  
  Hi @alexdo
  
  I have solved the problem. See my solution further up in the thred. I use Apache.
  
  Thanks again for you replay.
  
  Reply Report
  
  alexdo November 24, 2020
  
  Thanks for sharing what the issue was and how you were able to solve it!
  
  Regards,
  Alex
  
  Reply Report
  
  arokiaswamyselina November 25, 2020
  
  Can anyone tell why is this so that the phpMyAdmin server working perfectly fine yesterday suddenly misses a semicolon in the code? Would be great to know the reason.
  
  Reply Report
  
  alexdo November 25, 2020
  
  Hey, arokiaswamyselina
  
  This is quite odd. Have you made any recent changes on the server and is there anyone else that have access to the droplet?
  
  You can use the stat command in order to check when was the last time the file was modified and you can use that as cross reference check if you were working at that time.
  
  The command is used like this:
  
  stat file.php
  
  Hope that this helps!
  Regards,
  Alex
  
  Reply Report
  
  kenboye November 25, 2020
  
  Same here. We had not touched the server for a couple of days. right after i fixed it, I upgraded phpmyadmin to ver. 4.9.7
  
  Reply Report
  
  alexdo November 28, 2020
  
  Hello,
  
  I hope that everything is running smoothly now.
  
  Regards,
  Alex
  
  Reply Report

Related

Question

phpmyadmin suddently gives http error 500

Related

Leave a comment

Looking for something else?

Sign up for our newsletter

Related

Question

phpmyadmin suddently gives http error 500

Related

Leave a comment

Related

question

MySQL server gone down.

question

Keepalived on private network

question

Unable to secure MySQL on fresh LEMP droplet

question

Why doesn't MySQL ask for a password from root?

Looking for something else?