INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

WordPress installation problems

WordPress installation problems

(OP)
My objective is to install the latest version of Wordpress on a server running MS IIS 7.0.

The server does not have MySQL or Php on it. So obviously I have to install those first.

I installed WordPress before but it was on a server that had it configured already.

I have been following this help me video : https://www.youtube.com/watch?v=3_6Pk9e08Ug

I got to the part of the video where you have to copy phpMyAdmin to the root directory.

I did that then browsed it and got nothing.


Any advice or help would be appreciated.



Artist/Designer

RE: WordPress installation problems

phpmyadmin is just a set of php scripts. to use it you must first have php installed and working correctly. and then to make it useful you must have mysql installed and the mysql client libraries for php.


RE: WordPress installation problems

Oh dear is he mad??? Allowing port 3306 though a firewall so it is externally accessible is ASKING for it to be attacked. MySQL does NOT need to be externally accessible for running WordPress (other content management systems are available) on the same server.


And please expand on "got nothing" with any error message, HTTP status codes etc.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: WordPress installation problems

I prefer accessing mysql over ssh but you can make 3306 externally available and configure mysql to use ssl. I haven't heard that is insecure but I've never looked into it carefully.

RE: WordPress installation problems

(OP)
Ok let me clarify a little better as to what I've done.

I searched everywhere to find a understandable walk through on how to install php and mysql on a iis7 server..the requirements for WordPress. I've never installed php or mysql before so please correct me at any point.

As you can see from the image in my 1st message there is noting on the server about mysql or php.. but then again take a look at the programs/features in the control panel as to what i've installed so far.. --> http://rossow-web.com/inbox/image2.jpg


According to the tutorial the last step for installing php/msql was to place the phpmyadmin folder in the wwwroot directory. I did that. Then tried accessing www.mhoinc.com/phpmyadmin ...with no success but a http error 404.0 not found.

-------------------------
I just found this: http://codex.wordpress.org/Installing_WordPress#Ea...

Its look simple, but what do they mean by Step 1 #3 "Once Web PI is installed, neither XAMPP nor any other web server will be able to use localhost to host a web site locally on your machine. "

Artist/Designer

RE: WordPress installation problems

mysql server is installed. good. is it running?

is php properly bound into IIS? follow the instructions on the php website rather than anywhere else.

RE: WordPress installation problems

(OP)
i dont know if mysql server is running or not. how do i find out? -- i'll google this.

i also have no idea how to or if php is bound to iis. should uninstall php and start again? -- again i'll try to google this

According to the http://windows.php.net/download/ site: "Which version do I choose?

IIS

If you are using PHP as FastCGI with IIS you should use the Non-Thread Safe (NTS) versions of PHP. "


the php install i used:

PHP 5.3 (5.3.28)
VC9 x86 Non Thread Safe (2013-Dec-12 01:58:52)

Installer [45.74MB]
sha1: 8411eaa51b7effed861456097178bb9fc4907b3e

Artist/Designer

RE: WordPress installation problems

(OP)
ChrisHirst, if 3306 is bad, what should i change the port number to?

Artist/Designer

RE: WordPress installation problems

i dont know if mysql server is running or not. how do i find out?

As a place to start, you should be able to look into the server's/workstation's Services and see if the MySQL Server Service is Started.

If you already know how to do this I apologize for stating the obvious...
* Go to that box's MyComputer (or whatever) and right-click to Manage
* Then, within the Management window, go to Services (maybe Services and Applications under which will be Services)
* Within the Services window scroll around to find - <whatever you named your MySQL server>
* In the Status, you should find: Started (or not)

Alternatively you can also go to your Start Button - All Programs - MySQL folder - MySQL Workbench
It should open and show the Local instance of the MySQL Server

Good Luck,
JRB-Bldr

RE: WordPress installation problems

I had a TON of problems figuring out what to modify in my various configuration files while trying to get WordPress installed on my in-house Windows Development workstation.

The gurus here were patient enough with me and ALL of my various questions (see: thread1716-1730088: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. )

Admittedly I was not trying to use IIS (its a 'bear' all by itself), since shutting it down and using Apache in its place seemed to be MUCH easier.

I did not use a pre-packaged installation (XAMP, WAMP, etc.) which might have resulted in down-level software versions and 'inheriting' other parameter settings of which I had no knowledge.
Instead I did a 'raw installation.
The general installation sequence I used was as follows:
1. Install the Apache Server (after ensuring that IIS was NOT running)(using httpd-2.4.9-win32-VC11.zip)
2. Install PHP (I used php-5.5.11-Win32-VC11-x86.zip)
3. Confirm that PHP was working. (se: http://kb.mediatemple.net/questions/764/How+can+I+...)
4. Install the MySQL Server
5. Finally install WordPress
And, along the way (as can be seen in the referenced posting), I had a LOT of configuration modification issues to overcome.

I certainly won't try to tell you that the way I did it was best, but you might give it a try and see where it gets you.

Good Luck,
JRB-Bldr





RE: WordPress installation problems

Oh, BTW another tool to use to see what is running (MySQL Server, etc.) is: Process Explorer (free download from web).

I use it instead of the Task Manager window since it gives more information and is, for me anyway, easier to use.

Good Luck,
JRB-Bldr

RE: WordPress installation problems

3306 is not 'bad' it is the default port for MySQL, every script kiddie and 'cracker' on the planet knows that, so will run attacks against every IP or hostname that responds to their probes. MySQL does not need to be open through the firewall at all unless it is a specific server that ONLY runs MySQL and can be only accessed from specific hostnames or IPs.
The average webserver with a running instance of WP connects to the MySQL server via localhost not via the external network. If you have to access the MySQL server remotely, then TCP Wrappers should be used to limit the IPs that can connect to port 3306.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: WordPress installation problems

(OP)
Ultimately what my objective is to convert a clients current website to a WordPress version. I assume so they can update content at will.


I'm working with their in house Windows server running IIS7. So I can't change the server software.

I'm not really versed on IIS7.

Artist/Designer

RE: WordPress installation problems

Oh and the only thing that SSL 'secures' is the communication between server and client.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: WordPress installation problems

(OP)
Just another point; I understand the basic concept of a webserver.. but i'm not a expert...so could you please explain things a bit simpler...

Artist/Designer

RE: WordPress installation problems

(OP)

Quote (CHRisthirst)

The average webserver with a running instance of WP connects to the MySQL server via localhost not via the external network.

and how do i connect MySQL server to WP?

Artist/Designer

RE: WordPress installation problems

first let's ensure that mysql is running properly and accessible. then we can move on to php

  • launch a terminal session (command line).
  • type in mysql -u root -p
  • type your password. if you don't know the password for mysql (not the same as your login) type 'root'. (without quotes).
  • if this is allowed then try to create a database

  • CODE

    create database WPTest; 
  • if this is all good then mysql is working adequately.
  • if not then you will need to reset the root password. follow these steps: http://dev.mysql.com/doc/refman/5.0/en/resetting-p...

Please post back the response with as much text detail as you can in the event of any errors.

RE: WordPress installation problems

on to php now. let's start from scratch.

uninstall absolutely everything to do with php to start with.

the first thing to do is decide whether to use FastCGI or a SAPI. I'd recommend FastCGI simply because that's what php recommends. I do not use windows so cannot speak from experience here.

Assuming you go with FastCGI follow the instructions here: http://www.php.net/manual/en/install.windows.iis7.... under the heading Enabling FastCGI and then follow the rest of the article to download php and configure IIS. Beware that some of the commands are wrapped lines: you need to put them all on one line and be careful of spaces.

This is the link to download from: http://windows.php.net/downloads/releases/php-5.5....

unzip php so that it is in c:\php

use the php-devel.ini version and add the following:

CODE

fastcgi.impersonate = 1
fastcgi.logging = 0
cgi.fix_pathinfo=1
cgi.force_redirect = 0
extension_dir = 'c:\ext' 

if you need to install the Visual C++ redistributable make sure it is the 32bit version as php for windows in 64bit is still experimental so the download link I provided was for the 32 bit version.

RE: WordPress installation problems

Quote:

and how do i connect MySQL server to WP?

localhost or 127.0.0.1

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: WordPress installation problems

Quote:


and how do i connect MySQL server to WP?
just in case you meant something different, when you first start WP (visit the admin site) it will detect that it has not been installed and ask you a bunch of questions about where your database is. for the host question type localhost or 127.0.0.1. For the dbName type wp_test or whatever you called the database that you created (a database server can have many databases each of which can have many tables and views).

@ChristHirst

Quote:

the only thing that SSL 'secures' is the communication between server and client

sure (did I say otherwise?). But if the server is configured to reject non encrypted connections on port 3306 what's the harm (beyond man in the middle attacks which are equally possible on port 22)? Obfuscating the open ports won't help much because a port scan is trivial. So either you are left with no external access or channeling everything over port 80/443 (phpmyadmin) or via an ssh tunnel.

RE: WordPress installation problems

Quote:

sure (did I say otherwise?).

Quote:

and configure mysql to use ssl.

My point is not about changing ports, because having MySQL listening on ANY port that is accessible externally is simply not necessary for the purposes of running WordPress or any other "web app" for that matter. The YouTube video that sparked this chain of debate is intended as a "Dummies Guide" and the result of people following that "guide" is that their MySQL server is going to be open to every "script kiddy cracker" on the Planet.

It is NOT whether you or I know how to access and administer MySQL over SSH, or how to limit external access via TCP Wrappers etc. It is that yet another 'fkn' YouTube "expert" is creating a situation for the people who follow those steps where their MySQL server is wide open for attack. Anyone following that guide is likely to be unaware of what the implications of opening the MySQL port to the Internet actually are, so will NOT be taking any furthewr steps to protect their now exposed database server.

I wonder what his next presentation was?
"How to recover from a 'hacked' WordPress MySQL database" perhaps!




Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: WordPress installation problems

Just for clarification purposes...

Ultimately what my objective is to convert a clients current website to a WordPress version.
I'm working with their in house Windows server running IIS7.


Is their in-house Windows Server (which is running IIS) the same machine as will be their final Web Server?

If so, great.
However if Not, then you should be working on a machine with the same configuration as their Final Web Server - mostly for your own clarity of understanding, but also for the understanding the variety of configuration parameter settings needed.

Its one thing to set up an in-house WP Development system for learning WP (like I did), but it is quite another thing to build a 'Live' (or going to be 'Live') WP site for a client.

Also - I'm not really versed on IIS7.
Well I hope that all works well for you 'as is' or else you have in-house experts to call upon because, not being personally well versed on IIS7 myself, I had one of my VERY knowledgeable cohorts attempt to educate himself on IIS and he got totally lost within its complexities and finally gave up. We had to call in a consultant. (That's why I personally chose Apache over IIS for my own work).

Good Luck,
JRB-Bldr

RE: WordPress installation problems

all good points.

@ChrisHirst - I never watched that yt video. my bad. I do watch youtube videos every now and then on the subject of micro-electronics. there are some useful primers on things like op-amp design which (if you watch enough and cross-relate them) are probably a quicker way of grasping the science than text books. Each primer on its own is (as ever the case) 'dangerously' limited in its knowledge transfer

@JRB_Bldr - configuring IIS is more complex than apache for those of us that are linux users. for sure. it seems counterintuitive sometimes. But if you don't use a package manager or cPanel/webmin etc then configuring apache is quite arcane too.

Oddly enough if you had to start with both from scratch, I suspect that you'd be up and running quicker on IIS than raw apache; and the actual steps for IIS support can all be done for you if you use the msi package from php.net. But I didn't promote that as it doesn't show the user the steps being taken with his/her OS. In a pinch, however, there is nothing wrong with the msi nor with using it provided that you are happy with sticking to php 5.3 (no installer is available [yet] for php 5.4 and 5.5 - I don't know why).

@OP
Here is the link to php 5.3 as an MSI for IIS >=7 on a 32bit machine. http://windows.php.net/downloads/releases/php-5.3....

WP will work absolutely fine on php 5.3.

RE: WordPress installation problems

jpadie - configuring IIS is more complex than apache for those of us that are linux users, for sure. it seems counterintuitive sometimes.

As a 'dyed in the wool' Windows Application Developer (note - I gave up dot-prompts with DOS), IIS is equally as cryptic to us as well - and it proved to be equally so for my cohorts as well.

Oddly enough if you had to start with both from scratch, I suspect that you'd be up and running quicker on IIS than raw apache

I have to say that while I most certainly had my numerous other challenges in getting everything finally working, getting the Apache/PHP part up and running was not a problem at all (once I found that I needed to disable IIS to eliminate conflicts) - and I did a totally 'raw' installation of everything.

My initial attempts (before trying Apache) to install with IIS failed miserably and I couldn't find assistance resources anywhere (at least at that time).

configuring apache is quite arcane too.
Perhaps, but I got things working without needing to do ANY configuration to my Apache at all.
Install it and make sure that its Service was Automatically Started.
Maybe it was only easy for me because I did not need it to be 'outward facing' to the Web - instead only needing to work as an in-house Web Server.

rastaIT34 - Good Luck,
JRB-Bldr

RE: WordPress installation problems

Quote:


Maybe it was only easy for me because I did not need it to be 'outward facing' to the Web - instead only needing to work as an in-house Web Server.

perhaps. I have not seen apache on windows. Does it have a nice configurator? Probably the reason why it worked well is that you could use the vanilla config file. This will generally be the case unless you are running nameserver based virtual hosts (which would be unlikely on a localhost). Likewise complex rewrite rules etc can be a headache. But then regular expressions always are!

then there's the fun issues of securing apache with patches like suphp and suexec...

Don't get me wrong - there's nothing tempting me to the Dark Side of Windows Servers but I do sometimes tear my hair out trying to work out why a particular virtual host is showing content destined to be in another webroot entirely.

RE: WordPress installation problems

(OP)
Jpadie -

1st, thanks for the detailed help.


Quote (jpadie)

launch a terminal session (command line).
type in mysql -u root -p


I launched a terminal window and got this -->

http://rossow-web.com/inbox/image5.jpg

Artist/Designer

RE: WordPress installation problems

(OP)
ok.... let me back up here a bit... this all getting really confusing.

to get wordpress installed, i need to install php and mysql..

can you break it down simply step by step what happens here?

then we move on to install wordpress.

this website i'm working with is an active site that can't come down while i redesign it. so i will have create a sub directory.

Artist/Designer

RE: WordPress installation problems

wordpress is just a set of php scripts. 'installing' it simply means putting the files in a web folder.

you need to focus on installing mysql and php. get those working then we can help with wordpress.

your web server is not responsive so the links above do not work.

RE: WordPress installation problems

The link now works.
You typed in the wrong command. Follow the instructions in my posts.

RE: WordPress installation problems

(OP)
Jpadie,

i guess i don't understand the configuring of the php.ini file. So far I have:

  • downloaded and extracted php-5.4.28-Win32-VC9-x86
  • created a folder in Program Files (x86) named it PHP; in that folder put the PHP5.4 and in it the extracted files
  • there are two files in PHP5.4 folder: php.ini-development and php.ini-production
  • I understand I have to change the name of one of those files to 'php.ini'
  • then configure the php.ini file; according php.net:
Configure the CGI- and FastCGI-specific settings in php.ini file as shown below:

Example #1 CGI and FastCGI settings in php.ini

fastcgi.impersonate = 1
fastcgi.logging = 0
cgi.fix_pathinfo=1
cgi.force_redirect = 0

I don't know which file: php.ini-development or php.ini-production to edit. And then how exactly do i edit it? where in the php.ini file do i paste the info?

----------------

Then I should test the PHP? or is there more to installing php on IIS?


Again according to php.net I need to "create a handler mapping for PHP"

Artist/Designer

RE: WordPress installation problems

i'd start with php.ini.development. it will provide more debug information.

also, for php standardisation, I would store the php files in c:\php and not in the program files directory.

do consider using the msi however (if you are at all uncertain). it will automagically configure IIS for you too. I provided the link to the msi above in my post of 15 May 14 10:47


RE: WordPress installation problems

(OP)
ok cool jpadie....

i undid what i wrote in me previous post. and just used the msi file.

how do i test that i have php installed and configured correctly?

i'm still lost with the php.ini file set up. I haven't touched the file since i installed the msi file you recommended.

Artist/Designer

RE: WordPress installation problems

create a .php file with;

CODE --> php

<?php
phpinfo(); 

in it then open it in a browser, it will tell you everything about the PHP set up.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: WordPress installation problems

(OP)
OK,... i think I am making this harder than it needs be...

referring to: Jpadie 14 May 14 5:12
I followed the steps to test mysql and got this

So then I uninstalled MySQL using the mysql-installer-community-5.6.17.0.msi file. Then reinstalled it using the same file.

I tried the create database WPTest; command again and still got the same result. What am I doing wrong? Did I miss something?



referring to: Jpadie 14 May 14 5:56
PHP Install...

I think this is fine. I tested php install with a phpinfo.php file and got the php result screen.
What more needs to be done here?


So I downloaded WordPress...and was following this http://www.iis.net/learn/application-... to install it on IIS7. I got stuck at the "configuration file" step... I think the issue is I need to create a database. Correct?

Would phpadmin help me with creating a database? Or am I completely wrong here? Is there any Giu front end app that would help?








Artist/Designer

RE: WordPress installation problems

(OP)
I believe I have it installed and working!!

Artist/Designer

RE: WordPress installation problems

(OP)
thanks all for your comments and help..

Artist/Designer

RE: WordPress installation problems

Quote:


Would phpadmin help me with creating a database?

phpmyadmin can create databases. But if you can/could not have created the database manually through the mysql command line client, phpmyadmin would not have been able to do so either.

Quote:


I got stuck at the "configuration file" step... I think the issue is I need to create a database. Correct?

oddly wordpress does need the user to pre-create the database. I have never understood why it does not offer to create one for you.

Quote:


to install it on IIS7

really there is no installation for wordpress. it is just some php scripts like any other website. all you need to do is put it in a web accessible directory. When wordpress first runs it will configure itself based on some parameters it asks you about. All that is needed (as you found out) is a database to have been created.

CODE

CREATE DATABASE wordpress; 

RE: WordPress installation problems

Quote:

really there is no installation for wordpress.

Run wp-admin/install.php after you have extracted the zip into the folder you want the installation to be in.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: WordPress installation problems

(OP)
I managed to get it up and running.

Artist/Designer

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close