[Support] kru-x - wordpress


Kru-x

299 posts in this topic Last Reply

Recommended Posts

26 minutes ago, Fonso_s said:

Hi


Sorry for my incompetence.

 

I'll describe what I've done but I still have the DB Error.

I've instaled a new mariadb instance, an left it like this:

 image.thumb.png.30696f7798e18fecad8a9e198ec0c56e.png

 

After that, I configured I tried to methods, first I mounted a new WP docker but it didn't worked.
I cleaned all up and Installed again the mariadb, entered through console and create a new wordpress database, here you can see the TablePlus info:

 image.png.d37e52f213d025924c552560493548fc.png 

After that I created again another WP docker like this: image.thumb.png.a29818454cc1069e7ec4f6bbfafbb8a1.png


As I said, I still have the "Error establishing a database connection".

Here it is the resume form the Docker panel:

image.thumb.png.a509e8d75f96f0331e020a293c12e128.png

I've read this thread several times, but I still can't figure out what I am doing wrong.
Thanks for your help.

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 

Link to post
  • Replies 298
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

I'm having trouble updating Wordpress. Every time I try to update the website, it asks for FTP credentials. Searching for this issues shows problems with the access rights to the web directory. I've s

Corecctemundo, you can fire up as many instances of WP as you like and NPM can direct to each and everyone of them on a new domain. Or like me, just add a subdomain at your domain provider ex. mysite.

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

Posted Images

I'm using CA Cleanup Appdata to clean everything between tries.

I've tried creating a password in the mariadb docker and setting the root user with the password and it didn't change anything.

image.thumb.png.3d0487a015f38cb23174443992a3c24f.pngimage.thumb.png.ceabe3af9f1722bbe7fc9bb1e60190ea.png

 

Thanks for all your help, I'm goin to  try using portainer to get this running.

Thanks for your time.

Link to post

Some months ago i used this topic to run a wordpress container, and i recall walking through a step by step description (like spaceinvaders tutorials) on how to add the mariadb, how to create the db etc but i can't seem to find it anymore? Is there a step by step tutorial anywhere on how to set up a new wordpress site on unraid?

Link to post
On 4/21/2021 at 6:14 AM, Fonso_s said:

I'm using CA Cleanup Appdata to clean everything between tries.

I've tried creating a password in the mariadb docker and setting the root user with the password and it didn't change anything.

image.thumb.png.3d0487a015f38cb23174443992a3c24f.pngimage.thumb.png.ceabe3af9f1722bbe7fc9bb1e60190ea.png

 

Thanks for all your help, I'm goin to  try using portainer to get this running.

Thanks for your time.

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 

Link to post
On 4/24/2021 at 10:25 PM, jowi said:

Not what i was looking for but i found a tutorial in the french section that had the info i needed: 

 

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

Kru-X

Link to post
5 hours ago, Kru-x said:

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 

 

Hi Kru-X,

 

Yesterday I cleaned up everything, and tried again, this time I used an exclusive mariadb docker with a custom user and password and the database named "wordpress".

I did it twice and I got it running both times, each time with a exclusive docker for both wp and db.

 

Now I want to try make them public to the internet.

 

Thanks for your help.

Link to post
Posted (edited)
7 minutes ago, matthew42904 said:

im sorry if you have said this before but how do i change the port to something other then 80? i have been trying for the past 4 hours and cant find it. is there a way to tell it to change the port from the unraid gui?

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

Edited by Kru-x
Link to post
1 minute ago, Kru-x said:

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

i found the issue. i was hosting it but now my friend cant connect to it. all it dose was load and never connects

Link to post
2 minutes ago, matthew42904 said:

i found the issue. i was hosting it but now my friend cant connect to it. all it dose was load and never connects

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

Link to post
1 minute ago, Kru-x said:

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

never mind i found the issue its a cache issue on his end

Link to post
  • 4 weeks later...
Posted (edited)

I'm having trouble updating Wordpress. Every time I try to update the website, it asks for FTP credentials. Searching for this issues shows problems with the access rights to the web directory. I've set a separate web directory for the "/var/www/html" path. Do I need to change anything on the permissions there?

As I understand, the docker runs under the root user and should have access? 🤔

 

(Page runs behind HA Reverse-Proxy if that should be an issue?)

 

Update: I was able to fix this by adding the following line to the wp-config.php file:

define('FS_METHOD','direct');

 

 

Edited by Symon
  • Like 1
  • Haha 1
Link to post

Having some issues updating the container.

It says there's an update but it doesn't pull anynthing.

 

When looking and the template I notice there's no repository adress, is this correct?

 

bild.thumb.png.cc39d6cf1ba7e097635d0d38b6837f22.png

Link to post
Posted (edited)

I'm having difficulties with my wordpress container connecting to my mariadb database. I've create the database and can connect to it using the account I created for it from the mariadb container. My nextcloud container is on a different network and has no issues connecting to the same container. I've tried multiple combinations of usernames (wpuser vs wpuser@localhost) and database host ip addresses yet I still get the following page when trying to go to /wp-admin.

 

Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at 192.168.1.192:3306. This could mean your host’s database server is down.

Are you sure you have the correct username and password?

Are you sure you have typed the correct hostname?

Are you sure the database server is running?

If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

 

 

Update: Nevermind. My wpuser mariadb user was created with only local access. I deleted it, recreated it and now it can connect just fine.

Edited by Professor Oak
Link to post
14 hours ago, Amigaz said:

I notice there's no repository adress, is this correct?

Yes.  It's an "official" container, so there is no author/repository, only repository

Link to post
Posted (edited)

Hi, I have this project stopped but this week I've been working on it and I would like to use the site with my own custom domain.

Do you know a tutorial to use Nginx Proxy Manager to redirect to the site? I've looking on the internet and did't find anithing.

 

Thanks in advance!!

EDIT: I had Cloudflare and the DNS wrong, so I wasn't getting access to my url, now I have done it correctly thanks to this video I'm able to access the web with my custom domain.

Edited by Fonso_s
Link to post
Posted (edited)

Two things, when you install the current docker via Community Applications on 6.9.2 it doesn't show as an installed app. Also when you change the port during install the webui link in "docker containers" still points to the default 8080.

 

Thanks for your work on this!

Edited by Juise99
Link to post
  • 3 weeks later...

Hi,

 

I would like to know how Incan restore an exisiting backup in this container. When I tried to copy files in appdata folder of my wordpress installation it is impossible (i tried to copy from krusader with root permissions too and it was impossible)

 

How can I set write permissions in the app data wordpress for restore an external backup in this container?

 

Thank you and best regards

Link to post
15 hours ago, bonistir said:

Hi,

 

I would like to know how Incan restore an exisiting backup in this container. When I tried to copy files in appdata folder of my wordpress installation it is impossible (i tried to copy from krusader with root permissions too and it was impossible)

 

How can I set write permissions in the app data wordpress for restore an external backup in this container?

 

Thank you and best regards

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

Link to post
7 hours ago, Kru-x said:

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

Thank you for reply me Kru-x,

 

I made the backups with updraft wp plugin from my VPS WP installation. This plugin perform a database backup (i restored this backup into unraid mysql container without problems) and perform a backup of files and folders (mainly the content of wp-content folder of my VPS installation) so I need to restore this files in the folder wp-content of the wp installation unraid container.

 

When I try to restore this files in wp-content I have not permissions to write in wp-content folder.

 

Thank you for your help and best regards

 

Link to post
10 hours ago, bonistir said:

Thank you for reply me Kru-x,

 

I made the backups with updraft wp plugin from my VPS WP installation. This plugin perform a database backup (i restored this backup into unraid mysql container without problems) and perform a backup of files and folders (mainly the content of wp-content folder of my VPS installation) so I need to restore this files in the folder wp-content of the wp installation unraid container.

 

When I try to restore this files in wp-content I have not permissions to write in wp-content folder.

 

Thank you for your help and best regards

 

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

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.