Linode Forum

[MathieuB]

Hi,

I got my first Linode (640MB) on Friday night.

Installed a CentOS 5 distro.

Then I installed the following:

mod_ssl
mysql-server
php
php-mysql
ntp (to keep server clock in sync)

with yum install. Updated everything with yum update.

Then I downloaded, unzipped and installed Wordpress.

Then edited config.php with

Code: define('DB_NAME', 'wordpress1');    // The name of the database
define('DB_USER', 'wpuser1');     // Your MySQL username
define('DB_PASSWORD', 'wppassword1'); // ...and password


Then with mysql, did the following:

Code:
mysql> CREATE DATABASE wordpress1;

mysql> GRANT ALL PRIVILEGES ON wordpress1.* TO "wpuser1"@"localhost"
mysql> IDENTIFIED BY "wppassword1";

mysql> FLUSH PRIVILEGES;

However, when I try to access wp-admin/install.php in my browser to install/configure it, all I get is an Apache page.

Also, I'm trying to figure how to install and configure the server for FTP. What I'm looking for is the easiest way to do it and/or a walk-through guide, as I'm very much a noob with console and Linux in general. I'll be the only accessing the FTP.

Thanks in advance for your help.

[hybinet]

What do you mean, "all I get is an Apache page" ? Do you get a "Not Found" error? (In that case, you should check that Wordpress is installed in the correct folder.) Or does Apache show you the Wordpress source code and everything? (In that case, you haven't got mod_php working yet.)

As for FTP, stay away from it, it's very insecure. Especially if you're the only one accessing it, you can just reuse your SSH login/password to connect to your server with SFTP which for all purposes works just like FTP but infinitely more secure. Most sane FTP clients, including FileZilla, supports SFTP as a "server type" option, so you don't even need to install anything else.

[MathieuB]

Trying Filezilla, unable to connect.

Using the ssh adress I get under console for host; assuming that's what I'm supposed to use right? Getting a 'Fatal: unable to initialise SFTP on server: could not connect' error.

As for the Apache page, see yourself:
http://li87-233.members.linode.com/

[hybinet]

Console for host? You mean the Linode Shell? No, that's for the physical machine on which your Linode resides. In order to connect to your Linode itself with SSH/SFTP, you need to use your linode's IP address (under the "Network" tab) or your hostname (li87-233.members.linode.com)

Your Apache page says:
Quote: If you are the website administrator:
You may now add content to the directory /var/www/html/. Note that until you do so, people visiting your website will see this page and not your content.
Did you put Wordpress in /var/www/html yet? If it's installed elsewhere, either move it to /var/www/html , or edit the configuration file also mentioned in your Apache screen so that Apache knows where Wordpress is. (If you change any configurations, restart Apache by typing "service httpd restart".)

[MathieuB]

Alright, thanks to your help, was able to connect via FileZilla and move Wordpress in the var/www/html

Now, when I access 'http://li87-233.members.linode.com/
I get a 'Error establishing a database connection'

Figure something is wrong with the database server.

Assuming that's MySQL, just not sure where to start looking.

[spearson]

Does Code: service mysqld status show that it is running? If not then do Code: service mysqld start

[MathieuB]

Yes, it says that it's running.

[MathieuB]

Issue resolved thanks to the help of mwalling in the IRC.

Simply a mistake of mine, didn't allocate the mysql rights for the user to the right database; simply a typo.

Guess it's what happens when you're too tired after working on it for a while, you forget those little details that makes a big difference.

Thank you.