Wordpress Multi-Tier & Multisite on Google Cloud Engine

austinfrey 2018-01-09 15:49:37 UTC #1

Keywords: WordPress - Google Cloud Platform - Technical issue - Other
Description:
Trying to setup a Wordpress Multi-tier instance that also uses the Wordpress Multisite capabilities. Launching the Bitnami Wordpress Multi-Tier image using Google Cloud Launcher is successfull. However when I SSH into the server to make the appropriate updates to the wp-config.php and .htaccess files to enable Networking, I get and error that the DB has been corrupted and must be restored. Following the instruction to restore the DB are also unsuccessful.

Steps to reproduce:
1) Launch "WordPress Multisite Certified by Bitnami" using Google Cloud Launcher
2) SSH into the machine using the "SSH" option in the "Deployment Manager"
3) Add the following to "wp-config.php" to enable Network Setup
4) Followed Network Setup instructions and copy/pasted the the configuration code into wp-config.php and .htaccess
5) When trying to log back in I get the following error "Error establishing a database connection" at /wp-login.php" and "One or more database tables are unavailable. The database may need to be repaired." when visiting "/wp-admin"

Any help appreciated. Thanks!

Bitnami WordPress with Azure Database Services - Install additional Wordpress sites

jariza 2018-01-10 10:23:05 UTC #2

Hi @austinfrey

Could you please share with us the changes you did on the "wp-config.php" and ". htaccess" files?

Are you able to connect via SSH to the database server as described in the link below?
https://docs.bitnami.com/google-templates/apps/wordpress/#how-to-connect-to-the-database-server
Could you connect to it and run the command below? Please share the result with us:

sudo service bitnami status

Best Regards,

Juan Ariza

austinfrey 2018-01-11 00:44:33 UTC #3

@jariza thanks for the reply. here are the two code snippets.

wp-config.php

define('MULTISITE', true);
define('SUBDOMAIN_INSTALL', false);
define('DOMAIN_CURRENT_SITE', '35.185.8.50');
define('PATH_CURRENT_SITE', '/');
define('SITE_ID_CURRENT_SITE', 1);
define('BLOG_ID_CURRENT_SITE', 1);

.htaccess

RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]

# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]

output of sudo service bitnami status

● bitnami.service - LSB: Bitnami Init Script
   Loaded: loaded (/etc/init.d/bitnami)
   Active: active (running) since Thu 2018-01-11 00:40:00 UTC; 6min ago
  Process: 1080 ExecStart=/etc/init.d/bitnami start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/bitnami.service
           ├─1120 /bin/sh ./bin/mysqld_safe --defaults-file=/opt/bitnami/mariadb/conf/my.cnf
           ├─1227 /opt/bitnami/mariadb/sbin/mysqld --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --basedir=/o...
           └─1292 /opt/bitnami/gonit/gonit-linux-x64.run

Jan 11 00:39:56 multi-tier-wordpress-1-node-1 bitnami[1080]: 2018-01-11T00:39:56.435Z - info: Saving configur...isk
Jan 11 00:39:56 multi-tier-wordpress-1-node-1 bitnami[1080]: 2018-01-11T00:39:56.592Z - info: Performing serv...adb
Jan 11 00:40:00 multi-tier-wordpress-1-node-1 bitnami[1080]: com.bitnami.mariadb started
Jan 11 00:40:00 multi-tier-wordpress-1-node-1 bitnami[1080]: 2018-01-11T00:40:00.160Z - info: Starting gonit ...ice
Jan 11 00:40:00 multi-tier-wordpress-1-node-1 systemd[1]: Started LSB: Bitnami Init Script.
Hint: Some lines were ellipsized, use -l to show in full.

jota 2018-01-12 10:33:57 UTC #4

Hi @austinfrey,

This community blog post explains how to enable Multisite in a regular WordPress deployment.

https://community.bitnami.com/t/how-can-i-enable-wordpress-multisite/47708/2?u=jota

As you may notice, those steps refer to the Bitnami WordPress SingleVM deployment. In your case:

Backup the configuration files:

sudo cp -p /opt/bitnami/wordpress/wp-config.php{,.back}
sudo cp -p /opt/bitnami/apache/conf/vhosts/htaccess/wordpress-htaccess.conf{,.back}

Include this block in the wp-config.php file

/** This will enable Wordpress' multisite feature */
define('WP_ALLOW_MULTISITE', true);

Follow the steps to create a network using the WordPress dashboard
Copy the first block in the wp-config.php file
Copy the second one in the /opt/bitnami/apache/conf/vhosts/htaccess/wordpress-htaccess.conf file. Please note that you'll need to copy those lines inside a block.

<Directory "/opt/bitnami/wordpress/">
RewriteEngine On
RewriteBase /
...
</Directory>
<Directory "/opt/bitnami/wordpress/wp-content/plugins/akismet">
...