Kru-x

You must install a database, MB or MySql. That is also done in a container, nothing must be installed on your unraid server file system except from the docker folders. The only tutorial I know about is this discussion (there is a lot of pointers in some threads) or you can find a French tut here: https://forums.unraid.net/topic/102915-tuto-installation-de-wordpress-mariadb. Even if you don’t understand French you will understand what is going on and if you translate the page it’s even better. Kru-x

You must install a database, MB or MySql. That is also done in a container, nothing must be installed on your unraid server file system except from the docker folders. The only tutorial I know about is this discussion (there is a lot of pointers in some threads) or you can find a French tut here: https://forums.unraid.net/topic/102915-tuto-installation-de-wordpress-mariadb. Even if you don’t understand French you will understand what is going on and if you translate the page it’s even better. Kru-x

My guess is that the plugin wants to connect to your db and ad some tables/row in there but is using a older connection method not compatible with the newer mysql syntax. Try to throw in the --default-authentication-plugin=mysql_native_password in the extra parameter and try to restart the container. If it works it douse if not just delete it and restart it again. I would look elsewhere though, Kru-x ps. I mean in the mysql container if that wasn’t clear.

Hi xcsuperfly, Now you puting me on thin ice, but have skimed over it I think it has to do with "default_authentication_plugin=mysql_native_password". What I believe is that the plugin using an old legacy autentication, "mysql_native_password" instead of "caching_sha2_password" Read about the problem here, I know I have had this problem some time ago. The solution I found at that time was to add "--default-authentication-plugin=mysql_native_password" in the extra parameter in the template (advanced). It is just a guess based on the problem I have had, but I could be totaly wrong. AND it is a lot of fiddle to try to findout a problem like this and in worse case you have to change the docker image itself (make your own one and adjust for your needs, then you are in for a ride 🙂 ) Instead I tend to distrust plugin's that is not updated to the latest and always using and untouched official docker containers ( in this case mysql ). Extremly smart guys that look after them and update them for the mass. If you haven't got a specific reason to use this plugin, maybe look at some others, I use "newsletter", its brilliant. Hope it helps, Kru-x

?????? You have internet, don't you? Should make no different at all. Kru-x

You can't access it from your local IP, the page addresses is saved in the data base and WP will redirect to whatever address a user is asking for. WP doesn't know your local address, hence the importance to install WP from the domain.

Phew, glad it works

You are far more advance than me Don't think it is WP, you should be able to reach the install even without the DB has nothing to do with it until you install WP. I know people have had problem with cache, try to connect in "private mode". Reinstall and when you can reach the install with your IP, don't do anything just try to connect to it online from your domain, then install. Sorry don't understand the internal DNS thing so I don't know if that could be in the way, Kru-x

Looks right, first try to empty your cache in your browser. Still not sure how you can reach your domain on your local network eg "wordpress.mydomain.com:8080" should not work , but 192.168.1.80:8080 should work. Try to delete both folders again especially the DB, then see if you can reach the WordPress install by your local IP (don't install anything from your local IP), then try to reach the WP installer from your domain and install from there if it works. Holing my thumbs. 🙂 Kru-x

How did you redirect in NPM, should be to your internal address eg. 192.168.1.100:8080. Looks like you it asks for the domain:port, shouldn't do that. You shouldn't need to have any special settings for nginx, NPM takes care of it. I don't understand your "wordpress works with wordpress.mydomain.com in local (not via internet)"? Kru-x

Hi Nexius2, Shouldn't be any bigger problem to get you online, but I cant really help with Swag as I have never used it myself nor am I good at setting up Nginx (proxy). Instead I use NPM (NginxProxyManager), makes life much easier and you should also be able to use it for anything else you would like to reach from online like guacamole. There is posts in this thread mentioning setting up WP with NPM, but the most important is to get it to work with your domain first and then install Wordpress. Kru-x

Hang on, why do you say "https://IPADDRESS:PORT"? That is not right, should be your domain, you can't have https on the local IP address.

Check the settings in NPM, have you got "http" selected in Scheme, It must be a setting, it should make no different installing WP. Kru-x

Hi IKWEB, Im not sure if I follow exactly what you are doing, or trying to do, but try this. First delete both the Wordpress folder and the database folder in unraid (to remove eventual old values, from previous installs). Then reinstall both, then make sure you can reach the Wordpress installation on your Domain, going through NPM, and start the install from there and set up your db etc. then it should work. After install you can not reach the WP install from your local ip address, hope it helps, kru-x

Sorry I don't know updraft and can't really tell, you should be able to write in too the folder. Try to sett a different permission on the folder itself. Else as I said try Duplicator, it works great and takes care of any permission issues, at least for me. Kru-x

Hi Bonistir, How was the back-up made and what have you backed up? Only the folders? Most of the settings and data is stored in the DB itself. Do you have a site that you can take a new backup from? If, I suggest using "Duplicator PRO" (a WP plugin), it will clone the whole site + DB and handle all the permissions. Also I use on my unraid "duplicati" docker container to back up the folders both for WP and DB. Though, If it is a heavy site with a lot of traffic you should take a DB snapshot and back up that instead of the DB folder. Only copy and past the folder is going to get you in a heap of problems. Kru-x

That Happens 👍

Need to know how you have set it up, are you on a domain? Is it on local server? How did you install it? on the local or the domain? The problem with WP (or not really a problem) is that WP stores the information in the DB so if you installed it on the local server all pages is going try to redirect to 192.168.1.100:8081. So if you have a domain install WP after you have setup the domain and got it working. Kru-X

Hi matthew42904, What do you mean by 80? is that What it redirects you to when you click the Icon in Unraid? What happens if you try to add http://yourip:port the browser search bar? Eg http://192/168.1.100:8081 Kru-X

Thanks' for that Jowi, good tutorial and even if you don't understand French (as me) it shows the settings. Kru-X

Hi Fonso_s, Did you ever get it up and running? I just today realized that the WordPress container has change and now wont create the DB as I told you. You where on the right track and I have now added the WORDPRESS_DB_NAME to the template. Sorry for all the headaches. Kru-X

It looks right what you have done, did you delete the WP folder in between since you try to install the first time. IMPORTANT It was av while since I did it , but you shouldn't need to add the wp DB/table manually. WP takes care of that on installation. Also you could try to add in the mariaDb template the root password. Eg set the password "mypass" and the in the Wp template add "root" as user and "mypass" as password. And as you seem confident using Table Plus, you can always create a user manually and give that user full access and add that to the WP template but there you have to give that user full unrestricted access. Kru-x

Are you using the same DB as nextcloud? I suggest that you use a separate DB for each container eg one for the WordPress container. Just add a new mariaDB container with a different port then leave the user and password blank in the WP template (of course adjust for the ip and port). Then WP will be able to connect to the DB with as the "root" user and it will create the DB base named "wordpress" inside the MariaDB automatically. Please read through previous threads, you got a lot of similar problems that you have, explained. Let me know how it goes, Kru-x

Hi Fonso_s, Great choice and welcome to the community. What DB are u using? MariaDB? Try to leave the DB user & password blank. It's most likely the privileges to the DB, they must be right. On a new install off the MariaDB the user is "root" and the password non. If u want to use your own you have to set them "as per your template" in the DB. Hope that helps and let me know if it won't work. Kru-x

Hi Dancue, Thanks for letting us know and I am sorry to hear about your mishap. But on the same note I am glad that I gave a good advice (even if it was not followed ;-). You are not the only one that have wanted to run one DB, but I never got that as it is simpler and more workable with one for each, I have always set it up that way. I also backup my DB every 6hours and WP-folder once a day(really an overkill but it doesn't cost anything so why not). Just be aware that you should really (if you have lots of traffic or vital data) not do it this way, if something change during the backup it can become corrupt. You should take a DB dump and back that up instead. I don't bother too much as my site is low traffic and if it miss a beat ones a while it wont bother me too much, hope that wasn't the case. Otherwise how is it working (when it works)? Kru-x