phpMyAdmin错误504

vxbzzdmp  于 2023-10-20  发布在  PHP
关注(0)|答案(4)|浏览(296)

我有一个非常恼人的问题与我的phpmyadmin。它突然出现了。没有任何变化,我知道已经到我的专用服务器。
当我试图执行任何查询或显示一个需要超过1秒在我的浏览器执行的视图(Firefox在Windows 7上,IE的行为相同),我得到以下错误:

  1. Error in Processing Request
  2. Error code: 504
  3. Error text: Gateway Timeout

查询可以有也可以没有count(*)。它们在具有5 m-50 m行的表上工作。
有时当我点击phpmyadmin中的任何链接时,也会出现同样的错误,例如“浏览”,“服务器”或“结构”。
php脚本cronned运行更密集的查询在同一个专用服务器上的工作不受干扰。
以下是一些技术细节:

  1. Database server
  2. Server: Localhost via UNIX socket
  3. Server type: MySQL
  4. Server version: 5.5.38-0ubuntu0.14.04.1-log - (Ubuntu)
  5. Protocol version: 10
  6. User: XXX@localhost
  7. Server charset: UTF-8 Unicode (utf8)
  8. Web server
  9. Apache/2.4.7 (Ubuntu)
  10. Database client version: libmysql - 5.5.38
  11. PHP extension: mysqli Documentation
  12. phpMyAdmin
  13. Version information: 4.2.3deb1.trusty~ppa.1

我在网上找到了一些线索,并尝试在我的conf.inc.php文件中添加最后两行(见下文),但没有更改,也是在重新启动服务器后:

  1. <?php
  2. /**
  3. * Debian local configuration file
  4. *
  5. * This file overrides the settings made by phpMyAdmin interactive setup
  6. * utility.
  7. *
  8. * For example configuration see
  9. * /usr/share/doc/phpmyadmin/examples/config.sample.inc.php
  10. * or
  11. * /usr/share/doc/phpmyadmin/examples/config.manyhosts.inc.php
  12. *
  13. * NOTE: do not add security sensitive data to this file (like passwords)
  14. * unless you really know what you're doing. If you do, any user that can
  15. * run PHP or CGI on your webserver will be able to read them. If you still
  16. * want to do this, make sure to properly secure the access to this file
  17. * (also on the filesystem level).
  18. */
  19. // Load secret generated on postinst
  20. include('/var/lib/phpmyadmin/blowfish_secret.inc.php');
  21. // Load autoconf local config
  22. include('/var/lib/phpmyadmin/config.inc.php');
  23. /**
  24. * Server(s) configuration
  25. */
  26. $i = 0;
  27. // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
  28. // You can disable a server config entry by setting host to ''.
  29. $i++;
  30. /**
  31. * Read configuration from dbconfig-common
  32. * You can regenerate it using: dpkg-reconfigure -plow phpmyadmin
  33. */
  34. if (is_readable('/etc/phpmyadmin/config-db.php')) {
  35. require('/etc/phpmyadmin/config-db.php');
  36. } else {
  37. error_log('phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php.'
  38. . ' Check group www-data has read access.');
  39. }
  40. /* Configure according to dbconfig-common if enabled */
  41. if (!empty($dbname)) {
  42. /* Authentication type */
  43. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  44. /* Server parameters */
  45. if (empty($dbserver)) $dbserver = 'localhost';
  46. $cfg['Servers'][$i]['host'] = $dbserver;
  47. if (!empty($dbport) || $dbserver != 'localhost') {
  48. $cfg['Servers'][$i]['connect_type'] = 'tcp';
  49. $cfg['Servers'][$i]['port'] = $dbport;
  50. }
  51. //$cfg['Servers'][$i]['compress'] = false;
  52. /* Select mysqli if your server has it */
  53. $cfg['Servers'][$i]['extension'] = 'mysqli';
  54. /* Optional: User for advanced features */
  55. $cfg['Servers'][$i]['controluser'] = $dbuser;
  56. $cfg['Servers'][$i]['controlpass'] = $dbpass;
  57. /* Optional: Advanced phpMyAdmin features */
  58. $cfg['Servers'][$i]['pmadb'] = $dbname;
  59. $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
  60. $cfg['Servers'][$i]['relation'] = 'pma_relation';
  61. $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
  62. $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
  63. $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
  64. $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
  65. $cfg['Servers'][$i]['history'] = 'pma_history';
  66. $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
  67. $cfg['Servers'][$i]['tracking'] = 'pma_tracking';
  68. $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
  69. /* Uncomment the following to enable logging in to passwordless accounts,
  70. * after taking note of the associated security risks. */
  71. // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
  72. /* Advance to next server for rest of config */
  73. $i++;
  74. }
  75. /* Authentication type */
  76. //$cfg['Servers'][$i]['auth_type'] = 'cookie';
  77. /* Server parameters */
  78. //$cfg['Servers'][$i]['host'] = 'localhost';
  79. //$cfg['Servers'][$i]['connect_type'] = 'tcp';
  80. //$cfg['Servers'][$i]['compress'] = false;
  81. /* Select mysqli if your server has it */
  82. //$cfg['Servers'][$i]['extension'] = 'mysql';
  83. /* Optional: User for advanced features */
  84. //$cfg['Servers'][$i]['controluser'] = 'pma';
  85. //$cfg['Servers'][$i]['controlpass'] = 'pmapass';
  86. /* Optional: Advanced phpMyAdmin features */
  87. // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
  88. // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
  89. // $cfg['Servers'][$i]['relation'] = 'pma_relation';
  90. // $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
  91. // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
  92. // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
  93. // $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
  94. // $cfg['Servers'][$i]['history'] = 'pma_history';
  95. // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
  96. /* Uncomment the following to enable logging in to passwordless accounts,
  97. * after taking note of the associated security risks. */
  98. // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
  99. /*
  100. * End of servers configuration
  101. */
  102. /*
  103. * Directories for saving/loading files from server
  104. */
  105. $cfg['UploadDir'] = '';
  106. $cfg['SaveDir'] = '';
  107. //$cfg['AllowArbitraryServer'] = true;
  108. $cfg['LoginCookieValidity'] = 86400;
  109. $cfg['MaxExactCount'] = 0;
  110. $cfg['MaxExactCountViews'] = 0;

请帮帮我

0sgqnhkj

0sgqnhkj1#

我在http{}块中的/etc/nginx/nginx.conf文件中添加了以下行:

  • fastcgi_read_timeout 360;

重启nginx

  • sudo service nginx restart

祝你好运!记得喜欢我。谢谢你!

z6psavjg

z6psavjg2#

最后,我发现这不是我的服务器上的问题,但我当时的互联网连接提供商只是取消(发送此错误消息)所有需要超过10秒才能完成的https请求。

whitzsjs

whitzsjs3#

也许你可以在/etc/nginx/ngix.conf中检查或增加nginx超时设置?检查proxy_send_timeout和proxy_read_timeout。

jucafojl

jucafojl4#

如果你在Nginx中使用php fcgi,请将此添加到

  1. fastcgi_intercept_errors on;
  2. fastcgi_buffers 8 16k;
  3. fastcgi_buffer_size 32k;
  4. fastcgi_connect_timeout 900;//in 900 timeout
  5. fastcgi_send_timeout 900; //in 900secend
  6. fastcgi_read_timeout 900; //in 900secend

/etc/nginx/sites-enabled/phpmyadmin.conf中的示例文件

  1. location ~ ^/phpmyadmin/(.+\.php)$ {
  2. alias /usr/share/phpmyadmin/$1;
  3. fastcgi_pass unix:/run/php/php7.3-fpm.sock; //check what version php you have in /etc/php/
  4. fastcgi_index index.php;
  5. fastcgi_param SCRIPT_FILENAME $request_filename;
  6. # From fastcgi_params
  7. fastcgi_param QUERY_STRING $query_string;
  8. fastcgi_param REQUEST_METHOD $request_method;
  9. fastcgi_param CONTENT_TYPE $content_type;
  10. fastcgi_param CONTENT_LENGTH $content_length;
  11. fastcgi_param SCRIPT_NAME $fastcgi_script_name;
  12. fastcgi_param REQUEST_URI $request_uri;
  13. fastcgi_param DOCUMENT_URI $document_uri;
  14. fastcgi_param DOCUMENT_ROOT /usr/share/phpmyadmin; # <-- Changed
  15. fastcgi_param SERVER_PROTOCOL $server_protocol;
  16. fastcgi_param GATEWAY_INTERFACE CGI/1.1;
  17. fastcgi_param SERVER_SOFTWARE nginx/$nginx_version;
  18. fastcgi_param REMOTE_ADDR $remote_addr;
  19. fastcgi_param REMOTE_PORT $remote_port;
  20. fastcgi_param SERVER_ADDR $server_addr;
  21. fastcgi_param SERVER_PORT $server_port;
  22. fastcgi_param SERVER_NAME $server_name;
  23. fastcgi_param REDIRECT_STATUS 200;
  24. fastcgi_intercept_errors on;
  25. fastcgi_buffers 8 16k;
  26. fastcgi_buffer_size 32k;
  27. fastcgi_connect_timeout 900;
  28. fastcgi_send_timeout 900;
  29. fastcgi_read_timeout 900;
  30. }
展开查看全部

相关问题