{"id":1340,"date":"2016-01-05T14:59:10","date_gmt":"2016-01-05T19:59:10","guid":{"rendered":"http:\/\/xlinesoft.com\/blog\/?p=1340"},"modified":"2016-01-05T15:04:34","modified_gmt":"2016-01-05T20:04:34","slug":"running-asprunner-net-and-phprunner-apps-on-microsof-azure","status":"publish","type":"post","link":"https:\/\/xlinesoft.com\/blog\/2016\/01\/05\/running-asprunner-net-and-phprunner-apps-on-microsof-azure\/","title":{"rendered":"Running ASPRunner.NET and PHPRunner apps on Microsoft Azure"},"content":{"rendered":"<p>In this article we&#8217;ll show how to deploy PHPRunner or ASPRunner.NET application to Microsoft Azure cloud. I assume you already have an account with Azure, if not, you can create one <a href=\"https:\/\/azure.microsoft.com\/en-us\/pricing\/free-trial\/\">here<\/a>. <\/p>\n<h2>1. Create new application<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_app.png\" alt=\"\" title=\"azure_create_app\" width=\"536\" height=\"481\" class=\"alignnone size-full wp-image-1345\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_app.png 536w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_app-300x269.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_app-150x134.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_app-400x358.png 400w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><br \/>\n<!--more--><\/p>\n<h2>2. Application settings<\/h2>\n<p>Under Tools->Applications settings you can leave default settings that such as .NET Framework 4.6 and PHP 5.4<\/p>\n<h2>3. Test application<\/h2>\n<p>At this moment you should be able to open your application URL like this one in web browser: http:\/\/asprunnernetproject1.azurewebsites.net\/<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_start-300x222.png\" alt=\"\" title=\"azure_start\" width=\"300\" height=\"222\" class=\"alignnone size-medium wp-image-1351\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_start-300x222.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_start-1024x759.png 1024w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_start-150x111.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_start-400x296.png 400w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_start.png 1062w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<h2>4. Deployment settings<\/h2>\n<p>Now we need to upload our PHPRunner or ASPRunner.NET application to Azure. For simplicity sake we will use FTP upload. Proceed to<br \/>\nTools->Deployment credentials, enter FTP username\/password. <\/p>\n<p>You can upload your application using built-in FTP upload tool or use any third party FTP software. Make sure you upload all files and folders  under output directory, including empty folders.<\/p>\n<p>Here are sample settings for ASPRunner.NET or PHPRunner. <\/p>\n<p><strong>FTP server:<\/strong> ftp:\/\/waws-prod-cq1-005.ftp.azurewebsites.windows.net<\/p>\n<p><strong>Username:<\/strong> asprunnernetproject1\\asprunnernetsergey<\/p>\n<p><strong>Password:<\/strong> ******<\/p>\n<p><strong>Upload folder:<\/strong> \/site\/wwwroot<\/p>\n<p><strong>URL:<\/strong> http:\/\/asprunnernetproject1.azurewebsites.net\/<\/p>\n<p>Once uploaded open your application URL in web browser again and it should work at this point<\/p>\n<h2>5. SQL Server database<\/h2>\n<p>If you use a database like MS Access or your own SQL Server\/MySQL\/Postgre server your job is done here and application is ready to go. You can also take it one step further and make your application use SQL Server provided by Azure. <\/p>\n<p>To create a new SQL Server database proceed to &#8216;SQL databases&#8217; and click &#8216;Add&#8217;.  <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_sql_server.png\" alt=\"\" title=\"azure_create_sql_server\" width=\"548\" height=\"410\" class=\"alignnone size-full wp-image-1349\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_sql_server.png 548w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_sql_server-300x224.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_sql_server-150x112.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_sql_server-400x299.png 400w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/p>\n<p>Enter server name, database name, create database user. For test we chose to start with sample database, you may want to start with a blank database and upload your own data after that. <\/p>\n<p>Here are sample connection settings to be used to PHPRunner\/ASPRunner.NET. <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_setup.png\" alt=\"\" title=\"azure_sql_server_connection_setup\" width=\"571\" height=\"336\" class=\"alignnone size-full wp-image-1347\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_setup.png 571w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_setup-300x176.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_setup-150x88.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_setup-400x235.png 400w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/p>\n<p>Note that if you try to connect right now you will get the following error message. <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_error.png\" alt=\"\" title=\"azure_sql_server_connection_error\" width=\"497\" height=\"335\" class=\"alignnone size-full wp-image-1348\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_error.png 497w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_error-300x202.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_error-150x101.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_connection_error-400x269.png 400w\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><\/p>\n<p>By default remote connections are not allowed. Luckily the error message itself tells us what we need to do. We need to proceed to our database in Azure control panel, click &#8216;Open in Visual Studio&#8217; and add a firewall rule allowing connections from our IP address. Luckily, Azure shows your IP address right there and you don&#8217;t need to guess it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_firewall.png\" alt=\"\" title=\"azure_sql_server_firewall\" width=\"809\" height=\"361\" class=\"alignnone size-full wp-image-1346\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_firewall.png 809w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_firewall-300x133.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_firewall-150x66.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_sql_server_firewall-400x178.png 400w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><\/p>\n<p>Now you can connect to your database hosted on Azure from PHPRunner or ASPRunner.NET. <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/phprunner_connected_to_azure_database.png\" alt=\"\" title=\"phprunner_connected_to_azure_database\" width=\"702\" height=\"453\" class=\"alignnone size-full wp-image-1358\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/phprunner_connected_to_azure_database.png 702w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/phprunner_connected_to_azure_database-300x193.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/phprunner_connected_to_azure_database-150x96.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/phprunner_connected_to_azure_database-400x258.png 400w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/p>\n<h2>6. MySQL database<\/h2>\n<p>Similar steps will be required to create and configure a MySQL database. Instead of &#8216;SQL Databases&#8217; you will need to go to Marketplace and choose <em>MySQL database (ClearDB)<\/em> there.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_mysql.png\" alt=\"\" title=\"azure_create_mysql\" width=\"554\" height=\"254\" class=\"alignnone size-full wp-image-1350\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_mysql.png 554w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_mysql-300x137.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_mysql-150x68.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2016\/01\/azure_create_mysql-400x183.png 400w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><\/p>\n<p>This is what you need to know to get started with Windows Azure and PHPRunner\/ASPRunner.NET. Happy cloud computing!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article we&#8217;ll show how to deploy PHPRunner or ASPRunner.NET application to Microsoft Azure cloud. I assume you already have an account with Azure, if not, you can create one here. 1. Create new application<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,1,4,8],"tags":[],"class_list":["post-1340","post","type-post","status-publish","format-standard","hentry","category-asp-net","category-php-category","category-php-code-generator","category-tutorials"],"_links":{"self":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/1340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=1340"}],"version-history":[{"count":12,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/1340\/revisions"}],"predecessor-version":[{"id":1362,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/1340\/revisions\/1362"}],"wp:attachment":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=1340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/categories?post=1340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/tags?post=1340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}