Opened 2 years ago

Last modified 2 years ago

#12665 assigned Question/How do I...?

installing Wordpress on centro.community

Reported by: Tony Nelson Owned by: JaimeV
Priority: Medium Component: Tech
Keywords: Cc:
Sensitive: no

Description

Hello. I've been studying the how to tutorial that you all have prepared here: https://support.mayfirst.org/wiki/faq/wordpress/WordPressInstall

I have created a new wordpress mysql database and cooresponding user with permissions.

When I try to upload the file(s) (zipped or unzipped) via the import tab on the MyPhPAdmin site it says it's too large. I think I may be confusing upload with import. Or maybe I have to use a FTP application to do the upload or transfer?

Change History (29)

comment:1 Changed 2 years ago by JaimeV

Owner: set to JaimeV
Status: newassigned

just to confirm, you are using phpMyAdmin to upload only the old database file?

Did you use sftp to upload the website files themselves?

comment:2 Changed 2 years ago by Tony Nelson

No, I haven't done the database dump from our other site yet. I was told by a friend that I should install the newest WordPress to the site first, then do the process of database dump and transfer. Does that make sense?

comment:3 Changed 2 years ago by JaimeV

Sure that would work, but then it is only the database dump that should be imported through phpmyadmin, the wordpress files should be uploaded to your web folder over sftp.

https://support.mayfirst.org/wiki/faq/files/sftp

comment:4 Changed 2 years ago by Tony Nelson

Ok, to upload/install the WordPress files on the server for centro.community, I use SFTP. But how? Do I use a command prompt (some online tutorials seem to say that will work) or is there an SFTP application I should use?

Later, once that is successful, I'll use FTP and phpmyadmin in order to transfer our other site's files from ausm.community to the new site at centro.community. Does that sound right? Will that require a specific application, or can I use the command prompt for that too?

comment:5 Changed 2 years ago by Tony Nelson

Update. I just downloaded FileZilla which I think will allow me to do both things if I have the right settings/ports/etc in place. : ) Please let me know if that's a bad piece of software to use for this kind of job.

comment:6 Changed 2 years ago by JaimeV

To answer your question above you can use an sftp utility from the command line if you are comfortable working that way but an sftp client with a graphical interface like FileZilla will also work just fine.

You mention you'd like to first test with a new wordpress install, that sounds like a good plan. So generally the first steps are to

  1. Use May First control panel to create new database and user (you won't need phpmyadmin for this)

  1. Download and unpack latest wordpress archive
  1. Upload contents of wordpress archive to your web folder on the server via sftp (the instructions on the wordpress site mention ftp, using sftp is exactly the same but more secure).
  1. Follow the instructions at https://codex.wordpress.org/Installing_WordPress#Step_5:_Run_the_Install_Script to complete your installation

There are a lot of different ways to go about this but my suggestion is to just try it and you'll begin to get an idea of what is involved. It is unlikely that you'll break anything ;)

comment:7 Changed 2 years ago by Tony Nelson

I used the following:

Host: peery.mayfirst.org username: centro password: [the one i created for the centro username] port: [I left this empty]

Then I chose QuickConnect. This is in response:

Status: Resolving address of peery.mayfirst.org Status: Connecting to 162.247.75.205:21... Status: Connection attempt failed with "ECONNREFUSED - Connection refused by server". Error: Could not connect to server Status: Waiting to retry... Status: Resolving address of peery.mayfirst.org Status: Connecting to 162.247.75.205:21... Status: Connection attempt failed with "ECONNREFUSED - Connection refused by server". Error: Could not connect to server Status: Disconnected from server

comment:8 Changed 2 years ago by JaimeV

Hi, make you set filezilla to connect in sftp mode instead of regular ftp.

comment:9 Changed 2 years ago by Tony Nelson

When I go into settings under SFTP it asks me to "add a key file" or alternatively to "use my system's SSH agent and to make sure the SSH_AUTH_SOCK environment variable is set."

comment:10 Changed 2 years ago by JaimeV

Using a key file is not obligatory. I think you only need to change the protocol to sftp.

comment:11 Changed 2 years ago by Tony Nelson

I do not see an option to change the protocol in FileZilla. I'd like to share images with you, but I don't see how to do that here.

comment:12 Changed 2 years ago by JaimeV

Hi, sorry it appears the FileZilla interface has changed somewhat since the last time I looked at it. I just reread the instructions on their page at https://wiki.filezilla-project.org/FileZilla_Client_Tutorial_%28en%29 and it looks like now you should add the prefix sftp:// in front of the hostname to use the sftp protocol. So try adding sftp://peery.mayfirst.org to the hostname field

also, for future reference at the top of the page below the original ticket description there is a button to Attach File.

comment:13 Changed 2 years ago by Tony Nelson

Great, that worked to get me connected. Now, which of the hundreds of folders or subfolders should I install the WordPress unpacked files? I don't see a folder with the same name of the mysql database that I created.

comment:14 Changed 2 years ago by JaimeV

Don't worry about the database for now. The database is a separate entity from your actual website files and you won't interact with it through the filesystem. If you're seeing hundreds of folders then it sounds like you've navigated up the directory tree. Normally when you first login vía sftp you'd be in your home folder and from there you would navigate to centro.community and into the web folder. However if you are having trouble finding that the complete path to the correct folder should be /home/members/msn/sites/centro.community/web

You should upload your wordpress files into that web folder.

comment:15 Changed 2 years ago by Tony Nelson

It worked, it's now there! There's only one other folder in there called .user.ini

So now I will do the process of installing wordpress onto the site via the directions, right? https://codex.wordpress.org/Installing_WordPress#Step_5:_Run_the_Install_Script

And thanks for telling me how to attach images again!

comment:16 Changed 2 years ago by JaimeV

Yes I see you were able to upload the files. Just once detail, instead of uploading the containing wordpress folder it is better to place only the contents up the wordpress folder directly into the web folder so the web server will find the right files immediately. I'll just go ahead and fix that for you, then you should be able to proceed with the installation normally.

But before that, I'm going to suggest one more optional step, setup an https certificate for you site now. This is super easy vía the MFPL control panel. Just edit your web configuration to use the port "auto".

https://support.mayfirst.org/wiki/faq/security/setup-certificate

Once you've done that the only step left is to remove the default index.html file in your web folder. One that is removed you'll be able to begin your install at https://centro.community

The wordpress installer will ask you for your database information, make sure you use "localhost" as the database host.

comment:17 Changed 2 years ago by Tony Nelson

Okay, I found where to switch it to "auto." I deleted the two server aliases as instructed and it says "record saved," but then they appear again and when I try to submit after switching to "auto" it keeps giving me this message:

Before switching to auto, please remove or change any mayfirst.org subdomains (e.g. you.mayfirst.org) from both your ServerName and ServerAlias.

I've tried it a number of times. I've deleted them, then logged out, then returned and they are there again. I want to get this done before I do the WordPress install, so I'll try the following steps once we can resolve this.

comment:18 Changed 2 years ago by Tony Nelson

UPDATE: I was able to switch it to auto successfully. Turns out I was deleting both aliases instead of just the subdomain with mayfirst in it. My bad, sorry about that. When I first checked the ausm.community site, it gave me a "warning" landing page saying it wasn't secure but showing the https:// in the url. But it's not doing that anymore. Hmmm. Can you verify that both our pages are now https secure?

comment:19 Changed 2 years ago by Tony Nelson

Ahhhh, it worked! I'm so happy - thank you sooooo much! The next step will be importing our whole site from ausm.community, but we have a different thread already started for that, so I'll see you over there! : )

comment:20 Changed 2 years ago by JaimeV

Quick question, do you intend for this site to also respond to the domain ausm.community?

comment:21 Changed 2 years ago by Tony Nelson

I guess that depends on what you mean by "respond." We want to split our current site (mexicosolidarity.org) into two new sites (ausm.community & centro.community). So we want to copy all of the design format of ausm.community to centro.community Since we used the Divi Theme from Elegant themes for the other site, I believe I will have to install that theme first on centro.community, then do a SFTP transfer of the files from ausm.community That way we can delete and edit all the content but keep the theme and formatting the same. That's what we are wanting to do at least. Do you think there are any unnecessary steps or missteps in the process I describe here?

comment:22 Changed 2 years ago by Tony Nelson

When I try to install our theme to the centro.community site, it gives the following message: The uploaded file exceeds the upload_max_filesize directive in php.ini.

Do you know how to fix that?

comment:23 Changed 2 years ago by Tony Nelson

This page lists the fixes in order to increase the file size allowed by our server, but I don't think I have access to the files as they mention in their 4 ways to fix this here: https://atlantisthemes.com/fix-upload_max_filesize/

comment:24 Changed 2 years ago by JaimeV

Hi, sorry to increase your file upload limit you need to edit your custom php.ini file. More instructions here:

https://support.mayfirst.org/wiki/faq/server/change-php-ini-settings

You can use sftp to download the existing file edit it and upload to the same place again.

comment:25 Changed 2 years ago by Tony Nelson

Well, that worked splendidly. Thank you!

comment:26 Changed 2 years ago by Tony Nelson

I know this isn't the place to put this, but I can't seem to get the right login so I can get back to the following ticket: https://support.mayfirst.org/ticket/12500#comment:8

Also, can you help me get all of our logins sorted out? Do you have a list of our login/user names so I can get them in order and figure out which we can consolidate or delete? I'm specifically thinking about the ausm.community and centro.community domains.

comment:27 Changed 2 years ago by JaimeV

It looks like you created that ticket under login name msn. The ticket was flagged as sensitive so other users can't access it but there doesn't appear to be any sensitive information there now so i think I can remove that flag for you.

The control panel has a set hierarchy.

Membership -> Hosting Orders - Users

Users are created under a specific hosting order and hosting orders belong to specific membership.

At the same time users can be given a hierarchy of permissions, they can either be restricted to access the details of their own user, be given access to the entire hosting order , or access beyond to all member options.

Membership acess -> Hosting order access -> User access

User login centro has hosting order access for the centro.community hosting order

User login msn has hosting order access for the mexicosolidarity.org and also has member access for the entire Mexico Solidarity Network membership and all hosting orders.

comment:28 Changed 2 years ago by Tony Nelson

Ok, thanks, that helps a lot. But what is the user associated with hosting order ausm.community? tony? Or does the msn username work for ausm.community too?

Also, why would you need to "unflag" the thread in order for me to see it? Couldn't I see it if I log in with username msn?

comment:29 in reply to:  28 Changed 2 years ago by JaimeV

Replying to https://id.mayfirst.org/centro:

Ok, thanks, that helps a lot. But what is the user associated with hosting order ausm.community? tony?

Yes.

Or does the msn username work for ausm.community too?

It does, as msn has been given member level access that login can access any of your hosting orders.

Also, why would you need to "unflag" the thread in order for me to see it? Couldn't I see it if I log in with username msn?

Yes, you could also do that.

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.