Related

Product App Platform: Run PHP apps without managing servers Product
NGINX Config Generator Tool
Blank page with nginx & php-fpm installed on all user pages and user registration not working Question Question
Connect to DB installed into dedicated VPS (private networking) Question Question

Question

Install and secure phpmyadmin with Nginx LEMP stack on Ubuntu 20.04

Posted September 29, 2020 306 views
NginxPHPLEMPUbuntu 20.04

As I was following this tutorial https://devanswers.co/install-secure-phpmyadmin-nginx-ubuntu-20-04/, in lack of a DO tutorial existing about installing phpmyadmin on Ubuntu 20.04 with a LEMP stack, I couldn’t get phpmyadmin to work. See:

https://www.donutnetwerk.nl/phpmyadmin

Anyone know where to start troubleshooting?

Add a comment
katovonkatz
By:
katovonkatz
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
denislavgavrilov September 29, 2020

Hey @katovonkatz,

It seems you have set-up the phpmyadmin in different directory other than the one specified in your Apache root /your/path/to/application .

Could you post the Apache configuration and tell me where your phpmyadmin is setup?

You can also check /var/log/nginx/error.log and post the output.

Best,
Dennis

Reply Report
  • katovonkatz September 29, 2020

    Ha @denislavgavrilov , thank you for thinking along.

    You mention Apache, but I haven’t installed Apache, only Nginx.

    The phpmyadmin file is located at /usr/share/phpmyadmin. The location from which the symbolic link is made is /var/www/html/phpmyadmin.

    The error log is huge. I will post only the last part:

    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "\"import\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_pos>
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "abilities\";a:57:{s:13:\"switch_themes\";b:1;s:11:\"edit_themes\";b:1;s:16:\"activate_plugins\";b:1;s:12:\"edit_plugins\";b:1;s:10:\"edit_users\";b:1;s>
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "";b:1;s:14:\"manage_options\";b:1;s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:6>
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "14:\"manage_options\";b:1;s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:6:\"impor>
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query SHOW FULL COLUMNS FROM `wp_options` gemaakt door wp_install, update_o>
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "ormal', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_users' doesn't exist bij query SELECT ID FROM wp_users WHERE user_nicename = 'shw' AND user_login != '>
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "p_install, wp_install_defaults, update_option, add_optionPHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: " wp_install, wp_install_defaults, update_option, add_optionPHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query SHOW FULL >
                SELECT ID, post_name, post_parent, post_type
                FROM wp_posts
                WHERE post_name IN ('hallo-wereld')
                AND post_type IN ('post','attachment')
         gemaakt door wp_install, wp_install_maybe_enable_pretty_permalinks, get_page_by_pathPHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query SHOW FULL COLUMNS FROM `wp_options` gemaakt doo>
2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
2020/09/29 07:19:37 [notice] 83094#83094: signal process started
2020/09/29 09:44:56 [notice] 85973#85973: signal process started
2020/09/29 12:03:29 [notice] 88045#88045: signal process started
    edited by bobbyiliev
    Reply Report
    • denislavgavrilov September 29, 2020

      Hi There,

      This is a mistake on my part. It doesn’t matter if you use NGINX or Apache - they are both WebServers. But please don’t install Apache as well! =)

      Okay, so what I can instantly notice is the following message:
      PHP message: WordPress databasefout Table ‘dn.wpoptions

      Just thinking out loud here. The problems seems to be that the query is wrong. It should be db.wpoptions or similar… the idea is, there isn’t a dn. in mysql. Unfortunately, I haven’t got this message. I will try googling around and get back to you in a while.

      Best,
      Dennis

      Reply Report
denislavgavrilov September 29, 2020

Hi @katovonkatz,

You only need to follow step 2 & 3, not the entire tutorial, to set up your phpmyadmin. Could you try steps 2 & 3 and let me know how it went?

Best,
Dennis

Reply Report
  • katovonkatz October 1, 2020

    I did this several times, without succes. At this point, I feel things have become very messy. I have decided for a total reboot op my VPS and start again. I will get back to you when I have reached this point and let you know what I think is the solution.

    Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help