Running WordPress from MySQL Cluster with HAPRoxy

SELinux was contributing to the problem. The main issue was that an HTML page was attempting to talk to another port on the localhost. I would not have seen the problem if the HAProxy was running on a separate host.

The log was revealed in /var/log/messages, where I should have checked but did not considering I didn’t expect it. Fail on my part. The log looked like this:

setroubleshoot: SELinux is preventing the http daemon from connecting to network port 3306 For complete SELinux messages.

SELinux should not have been running to begin with, so I simply disabled it:

echo 0 > /selinux/enforce

To maintain this state upon reboot, simply edit the SELINUX line in /etc/sysconfig/selinux to say SELINUX=permissive rather than SELINUX=enforced. This will log alerts but not stop any processes. To disable SELinux completely, just replaced it with SELINUX=disabled instead.

Related Posts:

  1. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  2. Differences between utf8 and latin1
  3. What specific database privileges does WordPress need?
  4. What is the most secure way to set up the MySQL user in WPMU?
  5. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. Cannot add or update a child row: a foreign key constraint fails
  8. Cannot delete or update a parent row: a foreign key constraint fails
  9. Cannot delete or update a parent row: a foreign key constraint fails
  10. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  11. Rename a column in MySQL
  12. Not unique table/alias
  13. Install mysql-python (Windows)
  14. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  15. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  16. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  17. Disable ONLY_FULL_GROUP_BY
  18. MySQL WHERE IN ()
  19. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  20. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  21. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  22. difference between primary key and unique key
  23. grabbing first row in a mysql query only
  24. How to export a mysql database using Command Prompt?
  25. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  26. Order a MySQL table by two columns
  27. MySQL Error #1133 – Can’t find any matching row in the user table
  28. How can I prevent SQL injection in PHP?
  29. Best way to store an array in MySQL database?
  30. MySQL date formats – difficulty Inserting a date
  31. How to solve “Error: MySQL shutdown unexpectedly”?
  32. How to grant remote access permissions to mysql server for user?
  33. How to check if mysql database exists
  34. #1062 – Duplicate entry for key ‘PRIMARY’
  35. How can I convert a string to a float in mysql?
  36. Is there a Profiler equivalent for MySql?
  37. How to use greater than operator with date?
  38. Drop all databases in MySQL
  39. MySQL – count total number of rows in php
  40. How to get the count of each distinct value in a column?
  41. How to replace the domain name in a WordPress database?
  42. Optimize WordPress Query that take 5 seconds to execute
  43. MySQL Replication Latency Issues in wp-admin pages
  44. Increment value (value = value+1) of $wpdb->update
  45. How can I debug my database connection for unit testing?
  46. Extending the database
  47. SQL query not working in alphabetical post title/content search
  48. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  49. Importing MariaDB into Mysql in WordPress
  50. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  51. Keeping database within limits, please help!
  52. Converting mysql to $wpdb
  53. Update a WordPress post or page takes 60+ seconds
  54. HTML Entities in Post Title
  55. add_post_meta does not respect the content
  56. Modify MySQL Query Based on Dropdown Menu
  57. Select multiple wp_postmeta keys with single select
  58. How can I fix WordPress installation errors?
  59. Backing up and restoring multiple sites efficiently
  60. Alter wp_post table vs. post_meta performance/speed
  61. Are these WordPress tables safe to add indexes to?
  62. SQL syntax error when getting data for a url
  63. Can’t run database query
  64. Import CSV to MySQL, with custom registration field information
  65. Locally restoring a ManageWP full site backup
  66. WordPress doesn’t save changes some times
  67. Update Custom Post Type Taxonomies with SQL
  68. Custom SELECT Query not returning the_title and the_permalink
  69. Why doesn’t custom mysql query return results? Is syntax correct?
  70. Will reducing mysql permissions hinder WP function? [duplicate]
  71. Insert two row in wordpress database
  72. Php Mysql Terms
  73. Export SQL query based on custom field?
  74. Wpdb query with dynamic table name
  75. Lock wait timeout exceeded; try restarting transaction
  76. How to install WordPress from hosting service with mysql database from Compute Engine GCP?
  77. 504 Gateway Time-out after custom plugin inserts data into mysql database
  78. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  79. What is this? MySQL array?
  80. What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
  81. Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
  82. Add row to SQL array
  83. SELECT statement wrong?
  84. mysql query on wp_user and user_meta problem
  85. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  86. Use custom query if main search query returns zero results in wordpress
  87. How to get Attachments(image) with specific width\height ratio
  88. get_results() query not working only when entering strings
  89. Geographical proximity query using post_meta
  90. Can I use mysql queries to replace query_posts()?
  91. Apache Redirect based on WordPress permissions
  92. Add value to array in database
  93. Datatabase error: Commands out of sync
  94. How to Import Multiple Values in custom field
  95. Making CURDATE() recognize current_time()
  96. How should I troubleshoot a database serialization issue with a WordPress migration
  97. Global MySQL replacing of text patterns/matches
  98. Why does the MySQL command line tool ignore the –port parameter?
  99. Postgres equivalent to MySQL’s \G?
  100. Possible SQL injection. How to locate and fix?