[Support] kru-x - wordpress

[mjeshurun]

Hi Friends,

I've installed the Wordpress docker app for UnRAID and was able to migrate my website from Namecheap to my UnRAID home server. I'm able to open the website using my server's local [IP address]:[port] and all the website data seems to have been migrated well.

As a second step, I would like to configure the Wordpress website I created on my local server to be reachable using my registered domain name.

Can anyone suggest what steps I should take to connect between the Wordpress website, Cloudflare and Swag (which I use to create Let's Encrypt SSL certificates)?

Any help will be much appreciated.

 

@Nexius2 maybe you can assist? I read your previous posts in the thread, when you tried to setup swag 🙏

Edited October 23, 2022 by mjeshurun

[Eddie Seelke]

11 hours ago, mjeshurun said:

Hi Friends,

I've installed the Wordpress docker app for UnRAID and was able to migrate my website from Namecheap to my UnRAID home server. I'm able to open the website using my server's local [IP address]:[port] and all the website data seems to have been migrated well.

As a second step, I would like to configure the Wordpress website I created on my local server to be reachable using my registered domain name.

Can anyone suggest what steps I should take to connect between the Wordpress website, Cloudflare and Swag (which I use to create Let's Encrypt SSL certificates)?

Any help will be much appreciated.

 

I don't know about Cloudflare or Swag, but I host my personal site using a Wordpress container on UnRAID using Traefik and quic.cloud. For the dynamic domain, I transferred my domain to Google Domains and made the default host as dynamic. My next step is to figure out how to change the container to Wordpress with LiteSpeed.

[mjeshurun]

On 10/24/2022 at 12:58 AM, Eddie Seelke said:

 

I don't know about Cloudflare or Swag, but I host my personal site using a Wordpress container on UnRAID using Traefik and quic.cloud. For the dynamic domain, I transferred my domain to Google Domains and made the default host as dynamic. My next step is to figure out how to change the container to Wordpress with LiteSpeed.

Thanks. I manged to configure my Wordpress instance with the reverse proxy using the NginxProxyManager. For noobs like me, it's simpler to configure than Swag.

[mjeshurun]

Can anyone please explain how to setup a second wordpress instance on the same home server to host a completely different website?

I created a new mariadb database using Adminer, called the database by a new name, created a new user and gave the user a unique password.

I then tried installing the wordpress app again with a different appdata path, container name, and the unique db info I created earlier (db name, db user and db password). The db server info (ip and port) are the same as the first website, but that's the only similarity.

The second instance installs ok, but when I try to open the webui I get the following error message:

 

Error establishing a database connection

 

Am I doing something wrong?

Edited October 25, 2022 by mjeshurun

[Eddie Seelke]

Just now, mjeshurun said:

Can anyone please explain how to setup a second wordpress instance on the same home server to host a completely different website?

I created a new mariadb database using Adminer, called the database by a new name, created a new user and gave the user a unique password.

I then tried installing the wordpress app again with a different container name, and the unique db info I created earlier (db name, db user and db password). The db server info (ip and port) are the same as the first website, but that's the only similarity.

The second instance installs ok, but when I try to open the webui I get the following error message:

 

Error establishing a database connection

 

Am I doing something wrong?

Did you also change the appdata path for the new container?

[mjeshurun]

2 minutes ago, Eddie Seelke said:

Did you also change the appdata path for the new container?

Yes, thank you for mentioning this.

I forgot to indicated in my post that I also gave the second wordpress container a unique appdata folder.

[mjeshurun]

9 minutes ago, Eddie Seelke said:

Did you also change the appdata path for the new container?

Do I need to create a second mariadb container with a different appdata folder and port?

[Eddie Seelke]

1 minute ago, mjeshurun said:

Do I need to create a second mariadb container with a different appdata folder and port?

No, technically you can use the same db user and password as long as you create a new db and give that user permission to read and write it.

[mjeshurun]

20 minutes ago, Eddie Seelke said:

No, technically you can use the same db user and password as long as you create a new db and give that user permission to read and write it.

Hmmm... in that case, I'm not sure why I'm seeing this problem...

[Kru-x]

27 minutes ago, mjeshurun said:

Hmmm... in that case, I'm not sure why I'm seeing this problem...

Hi mjeshurun,

 

My bet it is a DB problem, eg username, permission problem or similar. Try to login to that DB with that username/password with adminer, (not with full admin access)

 

If it works WordPress should work. But I recommend as in many previous posts, not to use the same DB instance, it's easier and less error prone to fire up a second DB container and pair it with the Wordress instance with a different port number.

 

Kru-x

[mjeshurun]

32 minutes ago, Kru-x said:

Hi mjeshurun,

 

My bet it is a DB problem, eg username, permission problem or similar. Try to login to that DB with that username/password with adminer, (not with full admin access)

 

If it works WordPress should work. But I recommend as in many previous posts, not to use the same DB instance, it's easier and less error prone to fire up a second DB container and pair it with the Wordress instance with a different port number.

 

Kru-x

Thanks. In that case I'll just create a second mariadb container.

Should I also create a third db container if I'm going to run Nextcloud?

E.g,

One mariadb container to be used with wordpress site 1

A second mariadb container to be used with wordpress site 2

And a third mariadb container to be used with Nextcloud

 

To each app a different mariadb container?

Edited October 25, 2022 by mjeshurun

[Kru-x]

1 minute ago, mjeshurun said:

Thanks. In that case I'll just create a second mariadb container.

Should I also create a third db container if I'm going to run Nextcloud?

E.g,

One mariadb container to be used with wordpress site 1

A second mariadb container to be used with wordpress site 2

And a third mariadb container to be used with Nextcloud

 

To each app a different mariadb container?

Yea that's correct,

 

I'll "pair" one MariaDb container for each of my application/container that needs it (and I have 10 of them by now).

 

It might seem like an overkill, but it is little overhead to run a DB container and it is more hassle/error prone to use one container for all. Maybe it is due to my lack of DB knowledge, but when you bugger one up, you are going to be happy that the other ones are running like nothing have happened. Promise!

 

Kru-x

[Eddie Seelke]

Just my 2 cents, but you don't need to run more than one db container.  I use phpMyAdmin to manage my databases. As long as you make sure the user has all necessary permissions for the database, it should work.

 

I can start a remote session this afternoon, I am CDT time zone, if that would help. Just send me a PM.

[mjeshurun]

3 hours ago, Eddie Seelke said:

Just my 2 cents, but you don't need to run more than one db container.  I use phpMyAdmin to manage my databases. As long as you make sure the user has all necessary permissions for the database, it should work.

 

I can start a remote session this afternoon, I am CDT time zone, if that would help. Just send me a PM.

Hi everyone,

Just want to give a super big Thank You! shout out to @Eddie Seelke that offered to assist me solve the wordpress databases issues I was facing, and actually helped me very patiently and graciously.

People like Eddie remind me that humanity can be great when we share knowledge and help one another.

Thank you so much, Eddie! 🙏🙏🙏
 

[mjeshurun]

Hello again,

I managed to create a second wordpress container for a second website.

However, I am facing a small problem.

When I configure NginxProxyManager to Force SSL for the www subdomain, the website fails to load showing this error message:

If I disable Force SSL, the website loads using the https URL, but with a browser site info saying that the connection is not fully secure, and uploaded images are now properly displayed:

 

 

Anyone has an idea how I can fix this?

Edited October 29, 2022 by mjeshurun

[Jurak]

Has their been changes to this docker with Cloudflare? Lately all I get with my websites is a white page

Cloudflared docker is throwing many errors.
ERR  error="Unable to reach the origin service. The service may be down or it may not be responding to traffic from cloudflared: x509: certificate is valid for 21178470731dbb32f34cf6950f14c912.7fa6331778a54cb34a30e868165e52de.traefik.default, not jurak.business" cfRay=767068d868f37b19-LAX originService=https://192.168.1.79:18443
2022-11-08T18:35:37Z ERR Failed to handle QUIC stream error="Unable to reach the origin service. The service may be down or it may not be responding to traffic from cloudflared: x509: certificate is valid for 21178470731dbb32f34cf6950f14c912.7fa6331778a54cb34a30e868165e52de.traefik.default, not jurak.business" connIndex=2

[rob1000]

Where can I find the "php.ini" file?

 

When I try to upload a plugin I get the error message so I wanted to adjust the file:

The uploaded file exceeds the statement upload_max_filesize in php.ini.

Edited November 23, 2022 by rob1000

[Kru-x]

5 hours ago, rob1000 said:

Where can I find the "php.ini" file?

 

When I try to upload a plugin I get the error message so I wanted to adjust the file:

The uploaded file exceeds the statement upload_max_filesize in php.ini.

Try the .htaccess method, if it is not in your root folder you can add it.

 

Kru-x

[jowi]

I have 2 wordpress sites, and had some issues with nginx and certificates, but that is now solved.

One of the wordpress sites functions fine (https://hallum.20ten.nl/), the other one (https://dehef.20ten.nl/) i get a 502 error... they are basically configured the same in nginx and also have the correct A records. Both sites worked fine until the certificate issues started, but these are now renewed, but still, the 2nd site looks like it died?

 

I have no clue how to fix this or what is wrong. Normally, the ONLY way to get into the site (using /wp-admin) was over the actual url https://dehef.20ten.nl/. I can not show the site on my unraid server? Not even when i change to Bridge etc.

 

The only thing i can do is check what is in /mnt/appdata/ for this site.

How can i determine what is wrong? 

What is the actual way to start and run a wordpress site locally?

 

Edited December 9, 2022 by jowi

[jowi]

Ok, fixed. There were 2 things wrong. First, for some reason the container port (should point to internal 80) was the same as the external port, so e.g. external port 6262 should point to container port 80, but pointed to internal 6262 as well. Could not change it in the docker port settings (greyed out, also after stopping the container), so i had to delete the 'container port' setting and add it again but now properly.

 

Now, the 502 error was gone, but wp showed an error 'something is wrong' and a white screen.

Some googling suggested to rename the plugin folder and try to start the site. That worked  after that 1 enabled every plugin one by one until i found the culprint, some email form plugin. Deleted it. Site works fine again.

[sjoerd]

Hey,

 

Ported my test WPress site (was on a ubunut 20.04 vw + mariadb + apache2) to this WP docker container and moved de database to the mariadb container (from lscr.io / linuxserver) repo.. Bit tinkering. Got both containers on a custom network so wordpress can easily see the database). Was quite easy to do  - had to import a sql backup I make earlier.

 

Got some question tho..

 

The container-path points to /var/www/html - which is fine I guess, but also includes the wp-content (which holds the user-data like plugins, themes, uploads). I believe that wp-content should be the only thing on appdata - the rest (imho) should be part of the wordpress image.. I can now temper with the wordpress installation. Normally when you restart the container the container is destroyed and recreated. Could you explain that? What if we receive an updated container?

 

Would it be possible (or even recommended??) to add a volume to /var/www/htlm/wp-content > appdata/wordpress-site1/wpcontent and a link to the /var/www/html/wp-config.php to appdata/wordpress-site1/wp-config.php.

 

Planning on have 3 sites running (test, "live" and an internal which is total different)

 

I mean - that is the power of docker right? - one image, multiple containers with diff settings leaving the same files to the image itself

 

Edit:

Yes - that does actually work - I did not find anything on the official docker hub page but this kind of thing normally works as I've done quirks like this myself with my own dockers. To test it a bit further - I stopped the container, pruned it, removed the image. wp-content stays (ofc it does). Then I reinstalled the container from the template (hooray for unraid to save those templates) and I could just visit the site right away. Did found one weird thing. My "live" site (k1600gt.nl) renders well but the version running from the docker does not render a couple of blocks like it should. I checked - nog weird 404's or php error soooo not sure.. Might be a php8 thing since the live site runs 7.4 something.  The live one and the docker one are exactly the same - i restored a back of the database and content into the dockers and fixed the url's,

 

 

Edited February 3, 2023 by sjoerd

[Kru-x]

19 hours ago, sjoerd said:

Hey,

 

Ported my test WPress site (was on a ubunut 20.04 vw + mariadb + apache2) to this WP docker container and moved de database to the mariadb container (from lscr.io / linuxserver) repo.. Bit tinkering. Got both containers on a custom network so wordpress can easily see the database). Was quite easy to do  - had to import a sql backup I make earlier.

 

Got some question tho..

 

The container-path points to /var/www/html - which is fine I guess, but also includes the wp-content (which holds the user-data like plugins, themes, uploads). I believe that wp-content should be the only thing on appdata - the rest (imho) should be part of the wordpress image.. I can now temper with the wordpress installation. Normally when you restart the container the container is destroyed and recreated. Could you explain that? What if we receive an updated container?

 

Would it be possible (or even recommended??) to add a volume to /var/www/htlm/wp-content > appdata/wordpress-site1/wpcontent and a link to the /var/www/html/wp-config.php to appdata/wordpress-site1/wp-config.php.

 

Planning on have 3 sites running (test, "live" and an internal which is total different)

 

I mean - that is the power of docker right? - one image, multiple containers with diff settings leaving the same files to the image itself

 

Edit:

Yes - that does actually work - I did not find anything on the official docker hub page but this kind of thing normally works as I've done quirks like this myself with my own dockers. To test it a bit further - I stopped the container, pruned it, removed the image. wp-content stays (ofc it does). Then I reinstalled the container from the template (hooray for unraid to save those templates) and I could just visit the site right away. Did found one weird thing. My "live" site (k1600gt.nl) renders well but the version running from the docker does not render a couple of blocks like it should. I checked - nog weird 404's or php error soooo not sure.. Might be a php8 thing since the live site runs 7.4 something.  The live one and the docker one are exactly the same - i restored a back of the database and content into the dockers and fixed the url's,

 

 

Hi sjoerd,

 

I can follow your thinking and I wonder myself, but WordPress updates internally and gets updated on the fly, thus you always have the latest version keeping it like it is. Guess they update the docker container for a new install. I think you get in to more trouble to do it that way, than not.

 

Question back, as I see that you are installing new instances. Do you get a problems in "Site Health" on a new install? Eg. open tools/settings/Site Health and see if you get any recommendations of faults, I have a few pesky ones that I don't know how to solve. like "The REST API encountered an unexpected result" & "your site could not complete a call back", doing my head in!

Regards,

Kru-x

[Kru-x]

19 hours ago, sjoerd said:

Hey,

 

Ported my test WPress site (was on a ubunut 20.04 vw + mariadb + apache2) to this WP docker container and moved de database to the mariadb container (from lscr.io / linuxserver) repo.. Bit tinkering. Got both containers on a custom network so wordpress can easily see the database). Was quite easy to do  - had to import a sql backup I make earlier.

 

Got some question tho..

 

The container-path points to /var/www/html - which is fine I guess, but also includes the wp-content (which holds the user-data like plugins, themes, uploads). I believe that wp-content should be the only thing on appdata - the rest (imho) should be part of the wordpress image.. I can now temper with the wordpress installation. Normally when you restart the container the container is destroyed and recreated. Could you explain that? What if we receive an updated container?

 

Would it be possible (or even recommended??) to add a volume to /var/www/htlm/wp-content > appdata/wordpress-site1/wpcontent and a link to the /var/www/html/wp-config.php to appdata/wordpress-site1/wp-config.php.

 

Planning on have 3 sites running (test, "live" and an internal which is total different)

 

I mean - that is the power of docker right? - one image, multiple containers with diff settings leaving the same files to the image itself

 

Edit:

Yes - that does actually work - I did not find anything on the official docker hub page but this kind of thing normally works as I've done quirks like this myself with my own dockers. To test it a bit further - I stopped the container, pruned it, removed the image. wp-content stays (ofc it does). Then I reinstalled the container from the template (hooray for unraid to save those templates) and I could just visit the site right away. Did found one weird thing. My "live" site (k1600gt.nl) renders well but the version running from the docker does not render a couple of blocks like it should. I checked - nog weird 404's or php error soooo not sure.. Might be a php8 thing since the live site runs 7.4 something.  The live one and the docker one are exactly the same - i restored a back of the database and content into the dockers and fixed the url's,

 

 

And after reading your post thoroughly :~(): the container only copies the files the first time to the folder, any subsequent restart docker leaves the existing files and only adds files missing, thus if something changes in the file docker will not override it. But then as you said you should leave all file AS IS except for the wp_content, so you have a point.

 

The read and write access will be different in the container and WordPress wouldn't be able to update the files internally so the internal update would not work, you would have to wait until the container is updated I believe, so you would most likely get in to heaps of problems and I wouldn't recommend it, but then I am not an expert so I could be wrong.

 

Kru-x

Edited February 4, 2023 by Kru-x

[Kronos_]

Hi I have an issue where I get "Cannot select database". I'm using a second instance of mariadb from linux server (other one is being used by nextcloud). I'm not sure what the issue is as it says the username and password are correct but that it can't access the database still. Thanks in advance. sorry If I'm just doing something dumb.

http://192.168.1.1:8081/wp-admin/

wordpress setup

mariadb setup

[Kru-x]

57 minutes ago, Kronos_ said:

Hi I have an issue where I get "Cannot select database". I'm using a second instance of mariadb from linux server (other one is being used by nextcloud). I'm not sure what the issue is as it says the username and password are correct but that it can't access the database still. Thanks in advance. sorry If I'm just doing something dumb.

http://192.168.1.1:8081/wp-admin/

wordpress setup

mariadb setup

Have you given the user "wordpress" full read and write access to the "wordpress" db in mariadb? Sounds like you haven't, 

 

Kru-x