DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
Prev
Next
Forums Getting Started Installing DNN Platform

Installation Error on Windows Plesk - First time installing DNN

 6 Replies
 2 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Saiprem
New Around Here
Posts: 2
New Around Here
10/16/2024 11:26 PM

    I am the administrator of a Plesk server installed on an AWS EC2 instance. I am able to run standard .NET applications on the sample domains created within the Plesk server. Currently, I am exploring DotNetNuke (DNN) for one of my domains to evaluate its site customization features. Unfortunately, I am encountering issues that are preventing me from progressing with the DNN installation.

    Below are the versions of the software used in my environment:

    Operating Systsem : Microsoft Windows Server 2022
    DNN Version : 9.13.4
    SQL Server DB : Microsoft SQL Server, v15.00.2000
    ASP.NET Framework : 4.8.0
    Plesk Version : Plesk Obsidian v18.0.64_build20241008.15

    Error screens : 

    The screen is not progressing, and I found the below logs in the directory httpdocs/Portals/_default/Logs

    2024-10-17 02:35:13.221+00:00 [EC2AMAZ-A1P179A][D:2][T:8][ERROR] DotNetNuke.Data.PetaPoco.PetaPocoHelper - [3] Error executing SQL: ;Exec dbo.GetPortalAliases
    Could not find stored procedure 'dbo.GetPortalAliases'.
    2024-10-17 02:35:13.221+00:00 [EC2AMAZ-A1P179A][D:2][T:8][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbo.GetPortalAliases'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args)
       at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, Int32 timeoutSec, String sql, Object[] args)
       at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String procedureName, Object[] commandParameters)
       at DotNetNuke.Entities.Portals.PortalAliasController.<>c.b__16_0(CacheItemArgs c)
       at DotNetNuke.Common.Utilities.DataCache.GetCachedDataFromDictionary(CacheItemArgs cacheItemArgs, CacheItemExpiredCallback cacheItemExpired)
    ClientConnectionId:c47cffa6-d5fc-4179-8ba0-447f3d676e32
     

    On the other hand I can connect to database using PHP script without any issues.

     

    I noticed the below 403 errors in the network tab. Based on some suggestions, I attempted the installation by disabling the HTTP to HTTPS redirect. However, I am still encountering a 403 error. I have followed the recommended steps in the DNN installation guide and assigned the necessary permissions to the entire httpdocs directory as outlined here: DNN Folder Setup Guide.

    Do I need to install DNN in a subdirectory? Currently, I have extracted the DNN installation zip directly under the httpdocs folder

     

     

    Could you please help me resolve the error mentioned above, as I am having difficulty progressing with the installation?

     

    Thank you in advance.

    Prem

    2
    Will Strohl
    Senior Member
    Posts: 1426
    Senior Member
    10/17/2024 11:30 AM

      Hello!  

      This could be anything.  The user account needs to be properly set-up (including being a dbo), and the network connection needs to be allowed.  

      I've generated some installation videos using AWS Workspaces in the videos below.  Maybe that will be helpful for you.  Perhaps there's a easy-to-miss step that will jump out at you.  😎 

      Saiprem
      New Around Here
      Posts: 2
      New Around Here
      10/21/2024 12:05 AM

         

        Hi Will,
        Thanks for your reply.
        In my case, most of the installations were done through the Plesk administration control panel. In the plesk administration I navigated to 
        Plesk Admin Login → Tools & Settings → Updates → Add and Remove Product Components

        Below is the list of installed product components. I’m not sure how to verify the settings as described in the video you shared. Could you please guide me on that especially in case of plesk?