Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

VM in Azure #336

Open
mikeman23 opened this Issue Mar 21, 2019 · 17 comments

Comments

Projects
None yet
3 participants
@mikeman23
Copy link

mikeman23 commented Mar 21, 2019

Hi. I've just reached out to our I.T. with regards to deploying PN in our company Azure portal. My question is will PN work if our I.T. provided us VM environment running in Azure? As i've tried your one click "deploy to azure" button using a trial account, and it doesn't look like it's using a virtual machine perse hence i'm little confuse if PN will run in a VM.

If it will indeed run. Was wondering what is the minimum VM settings required like what OS it need?

Thanks!
-mike

@patrickebates

This comment has been minimized.

Copy link
Member

patrickebates commented Mar 21, 2019

Deploy to Azure creates a Web App and an Azure SQL DB. Every site I personally deal with in production environments use that model (App Service Plans and SQL DB performance levels vary as needed, of course).

You can certainly run it in a VM. The requirements are more on the PHP side of the equation than the OS build. PN will even run on Linux VMs provided that you have PHP 7 or higher and the matching build of the SqlSrv extension loaded. For Windows VMs, we recommend using the Web Platform Installer to load PHP and SqlSrv extension.

Hardware requirements are also dependent on your traffic and performance requirements rather than the software itself. If you are going to run SQL Server locally on the VM, then you need to build around those requirements. Otherwise even 2GB of RAM would be a starting point without SQL.

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Mar 21, 2019

Thanks Patrick!

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Mar 22, 2019

Hi Patrick,

Quick question about the Web platform installer. Upon installing that in our VM. Is it just a matter of uploading the PN zip file to appropriate folder? Or there's some more MS SQL setup we need to do? Or better yet, do you have any step by step process on how to deploy PN within VM in Azure?

Thanks so much!

@patrickebates

This comment has been minimized.

Copy link
Member

patrickebates commented Mar 22, 2019

So a quick rundown...
You need SQL of some type available (on same server, different server, or use Azure SQL DB), and it needs to be in Mixed Mode Authentication.
An empty database needs to be created, and you need a user with dbo access to it.
IIS needs to be installed.
Use Web Platform Installer to set up PHP 7.2, which should also install the SqlSrv module for PHP
Delete everything within the folder C:\inetpub\wwwroot
Unpack the ZIP into that same folder
Using your browser of choice, try to connect to your VM. The installation should begin.
Should be self-explanatory from that point.

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Mar 22, 2019

Thanks Patrick. Will follow these steps and will report back soon.

@kilasuit

This comment has been minimized.

Copy link

kilasuit commented Mar 24, 2019

I will add another AzureDeploy,json for deploying PN in a VM connecting out to Azure SQL in the coming weeks that will take care of the end to end install of everything

If there is demand, I will also add one where it uses a SQL VM image and installs all prereqs as needed too on a single VM instance (similar to the Wordpress Installs with MySQL)

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Mar 26, 2019

@kilasuit if you can add the option to install PN on a single VM instance, that would be amazing! Please do let me know if it's coming! Would love to try that out.

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Apr 4, 2019

@patrickebates just got my VM installed with IIS. I'm about to install Web Platform Installer. Do i select wordpress in there and install it? Or just select PHP7.2 and SqlSrv to install but no wordpress? Also if my MS SQL will be in another server, how do i connect it to my VM so when i install PN, it would know where to point to that database? Thanks!

@patrickebates

This comment has been minimized.

Copy link
Member

patrickebates commented Apr 4, 2019

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Apr 18, 2019

@patrickebates do you know which SQL drivers to choose from in web platform installer?

@patrickebates

This comment has been minimized.

Copy link
Member

patrickebates commented Apr 18, 2019

I would recommend the newest version that matches both your platform (x86 or x64) and your version of PHP.

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Apr 18, 2019

These are all the sql server listed:
Screen Shot 2019-04-18 at 3 17 05 PM

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Apr 18, 2019

i have php 7.3 installed

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Apr 18, 2019

I also have installed this:
Screen Shot 2019-04-18 at 3 19 58 PM

@patrickebates

This comment has been minimized.

Copy link
Member

patrickebates commented Apr 18, 2019

That should be everything you need.

@mikeman23

This comment has been minimized.

Copy link
Author

mikeman23 commented Apr 18, 2019

That's what i thought. But i'm getting this error:
Screen Shot 2019-04-18 at 3 21 43 PM

@patrickebates

This comment has been minimized.

Copy link
Member

patrickebates commented Apr 18, 2019

If you check phpinfo, is the SqlSrv module listed?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.