Website hosting for housewives

Started by messnct, Dec 05, 2022, 02:36 AM

Previous topic - Next topic

messnctTopic starter

Let's define the system minimum requirements of the solution:

- Windows 7 (IIS 7.5)

- PHP 5.2

- MySQL 5



This is quite ancient software - of course, we will not use it. But the latest MySQL 8 is also incompatible with Piwigo.

- Windows 10 (IIS 10)

- PHP 7.3.0

- MySQL 5.7.24


Installing the IIS Web Server


The web server is included in the Windows package, it remains to turn it on. In order to immediately get to the desired menu of the control panel, in the run (WIN+R) menu, enter the command:

    control appwiz.cpl

Select the item: enabling and disabling Windows components. And turn on the components, as in the picture below.
Hosting sites for housewives on the example of Piwigo (IIS PHP MySQL). Part 1 - Installation. Iis, PHP, Mysql, Hosting, Long-post

After the installation is complete (and reboot), open the address in the browser http://localhost . The page should open as in the picture below. If everything is fine, then we continue.
Hosting sites for housewives on the example of Piwigo (IIS PHP MySQL). Part 1 - Installation. Iis, PHP, Mysql, Hosting, Long-post

Installing PHP


PHP is delivered as an archive, which should be unpacked to Program Files (or to Program Files (x86), depending on the bit depth). Click on the link and download PHP, corresponding to the bit depth of the operating system. We are only interested in Non Thread Safe versions. Pay attention to the version of Visual Studio Compiler - you will also have to download it according to the selected PHP version. Links on the left of the page.
Hosting sites for housewives on the example of Piwigo (IIS PHP MySQL). Part 1 - Installation. Iis, PHP, Mysql, Hosting, Longpost

We also need PHP Manager. You can download it from Microsoft.

After installing and unpacking all of the above, open the IIS control panel.

    InetMgr.exe

There we open PHP Manager and register the unpacked PHP.

After registering PHP, we need to check its operation. Check that your PHP version is specified (marked in green) and click the link marked in red. The page should open as in the second screenshot below.
The absence of any errors at this stage is extremely important. Let's move on.

Installing MySQL

We are interested in MySQL Community Server. Download the installer for Windows from the official website. Download the web installer - we don't need all the components. Select manual installation.

Configure the filter to show other releases. Next, a point that requires clarification: we need to select MySQL latest from version 5.x, bit depth, according to the system. Notifer will help you manage the service.

Set a very good password to the root user. Create a new user with full rights and a good password. Allow login only from localhost. Use it.
Hosting sites for housewives on the example of Piwigo (IIS PHP MySQL). Part 1 - Installation. Iis, PHP, Mysql, Hosting, Longpost

We have finished the installation, in the second part I will consider the setup.
A guide for novice users, it's too early for them to know about Nginx and Apache, but everything will be fine.
  •  

BrettUK

I'll even write why this is fierce nonsense:

1. Solutions for the web are sharpened for the LAMP architecture. Linux+Apache+PHP+MySQL. IIS and Windows are missing from the list.

2. Paths in CP/M and Unix systems are built according to different principles. The site assembled on W+I will still need to be ported to LAMP

3. There is no and cannot be an understanding of the operation of the system on the prod.

4. Windows is tailored to work by the client. Even the server room.

5. Licensing issues. From $100 to $1K per person.

6. There is no file rights management.
  •  

SeMl

The fashion for docker is simplicity in deployment at least. Isolation. Scalability.
For the sake of one home site, it's much easier to do everything on pure Linux than to raise Windows with IIS and poke in the interface for half an hour. apt install, slip a few configs and fill the site itself much faster than deploying Windows.
And to make a container is just to write a dockerfile with the commands that were done before. That's it.

I understand if you have a site with serious functionality that uses AD, ASP.Net, MSSQL and so on from Windows - yes, you can't do without IIS here and it would be a crime to shove it on Linux. But PHP and MySQL are a direct path to LAMP. Windows is good in its place. And hosting is not her place at all.
  •  

aricajwalker

I did not expect that in 2023 they would advise you to do hosting on Windows with AIS at home. Even without using a docker, using just lamps, the gain will be as in the use of resources (fuck eats a lot, ais eats a lot) so it is in the simplicity of setting everything up. And about comparing the performance of Nginx + php-fpm or Apache +mod_php with the performance of IIS - it's even useless to argue here.
The highest degree of uselessness and perversion!
  •