New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Need some help with Wordpress on a VPS
realbusiness
Member
in Help
Hi
My sys-admin guy was away and I managed to get myself in a little bit of a problem.
The task is to move a WP install from a shared hosting to a band new VPS.
Successfully manages to install LEMP with a "demo" database and "demouser" as the database owner.
Imported all WP files from shared to VPS in /
mysql -h localhost -u database_user -p database_name < backup_db.sql
Edited the wp-config.php to reflect the new demo & demouser details.
Still loads up a blank page however?
Comments
The most common issue with getting the white screen of death is the server not being able to connect to the database.
Make sure you got the correct info in the config for the database
Did the domain change?
All the guides I have read so far, do a new install and then replace the wp-contents folder, I am not sure if that is the only was to work it out?
I also feel the Database isn't communicating with WP
Generally this is the correct way:
http://codex.wordpress.org/Moving_WordPress
It gets more complicated if your domain changes
Did you adjust the nginx vhosts? Did you restart nginx and possibly php5-fpm?
WordPress has a specific "can't connect to database" page; so I don't think that's the issue. You're getting a white screen and my guess is that probably means PHP parse error with display_startup_errors set to off.
The most common issue is to try to move the wp installation to a different domain name. Another issue could be a non proper configuration of nginx+php to handle any httpaccess rewrites - if you had apache and rewrite rules in your old server.
You could use the plugin "xcloner" to move your site more easily, if you want.
(One of the reasons I don't like WP. Buggy, heavy and unflexible CMS. Joomla and Drupal are far better than WP. The only think that makes gaining so much popularity is the ease of initial installation of the core and themes, and the easines for a noobie to add some articles. But if you want something more, it is a pain in the ass...)
Thank you, I removed the .htaccess and used the rewrite rule in sites-available server block
I will re-install the server and try again.
An advice: If your WP installation was relying in Apache, then, install apache in your new server. It will solve some of the problems you may have with php and rewrite rules.
I don't think it's a php and/or rewrite issue. I am not sure whether it's Vultr or database error.
Vultr has been giving me creeps from the outset, every new server that you deploy, lately has had "sudo command not found error"
and then editing etc / hosts and / etc / hostname to make it go away. Not sure if this could be something preventing error. But then I edited server block to test index.html and that worked fine.
So it's gotta be either php or a database issue.
Money is on php not being able to communicate properly.
what does /var/log/nginx/error.log say?
What OS do you use?
You know you have to specify how nginx has to connect to PHP, in the file you are editing in sites-enabled right?
After that, flush permissions on MySQL. And make sure not to let your sysadmin go again
There are some templates that sudo is not installed by default. Apt-get install sudo or yum install sudo should resolve it.
Why shoudl you habe any problems with vultr instances? I have never faced any issue.
Check if php is working properly. Create a simple php test file and see if the file is giving you the php info properly.
SOme advices: Before dumping the database, do a repair and optimize.
Then, try to install xcloner to your original WP, backup the site via the xcloner's interface, move the .tar.gz file to the new server among with the tho php files and restore it. If there is any error in the data base, xcloner will not import it to the new server.
You haven't answer yet if you are trying to move the WP to another domain, subdomain or even folder. If this is the case, it's probably the reason for giving you blank page. Are you able to login to the wp-admin section?
If you've installed php5-fpm and nginx, you need a file similar to this on
server { listen 80; root /PATH/TO/WORDPRESS; index index.html index.htm index.php; server_name YOURSITE.com www.YOURSITE.com; location / { try_files $uri $uri/ /index.php?$args; } location ~ \.php$ { fastcgi_split_path_info ^(.+\.php)(/.+)$; fastcgi_pass unix:/var/run/php5-fpm.sock; fastcgi_index index.php; include fastcgi_params; } location ~ /\.ht { deny all; } }Just replace the sections in CAPS and you're good to go. Remember to ask your sysadmin to set pathinfo=0 on
To flush mysql privileges
(-p only if you've set a root password, else run mysql_secure_installation first)
And use this command:
Ok, with a big relief, I can say that ignoring Vultr's guide and by using DO's guide, I have managed to get everything up and running again!
Thank you all for your help.
I have big problem with them hence I moved most of my servers to @DediServe and wished I did it long long time ago.
Dediserve have the best customer server I have seen from any Unmanaged VPS provider.
Their servers are fast too.
The reason I kept one Vultr was my last payment was a lot more than I needed, so had some credit left over. But needless to say I won't be deploying anymore with Vultr.
And the error was "sudo unable to resolve host" which is something to do with their latest Venom update. This is a problem even if you deploy a new server.