can not logon to new install

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
11/7/2012 9:51:08 PM
Gravatar
Total Posts 42

can not logon to new install

Hi

 

just installed version 2.3.9.3 on a new server .... tried the default admin user and password , i logon and there are no errors ...just keeping going back to the home page as if you can not logged on .... ie there is an option to logon and no admin menu available

any ideas ?

 

Thanks

 

Lee

11/8/2012 5:32:53 AM
Gravatar
Total Posts 42

Re: can not logon to new install

quick update...

 

deleted everthing , include the Datebase , complete re install ... same problem

if i try to go to one of the admin pages directly i get forwared to the logon screen.

if i type an incorrent password , i get an error , which is good

buy the correct usier id and password goes back tot he home page ( with a logon option rather than a logo out) 

forgot to mention this is on a hosted service (asp.net 4 etc)

how i can verify the install is correct ....

while waiting for a response i have started reviewing the logon.apsx code for hints without much luck ...

 

Regards

Lee

 

11/8/2012 9:41:12 AM
Gravatar
Total Posts 18439

Re: can not logon to new install

Hi Lee,

If you get an error on the login page that usually means the credential are incorrect or the user does not exist in the database.

If no error then login was successful but if you don't appear to be logged in possibly your browser is blocking cookies so it fails to set an authentication cookie. Maybe check borwser settings or disable any kind of privacy guard software that you may have installed or try using a different web browser to see if you get the same result.

You say you installed it on a new server, was this a clean new installation or did you move an existing installaiton to a new server?

Are you using our precompiled deployment package or did you deploy your own builkd from source code?

I would also check the log for any errors.

Hope that helps,

Joe

11/8/2012 4:07:06 PM
Gravatar
Total Posts 42

Re: can not logon to new install

hi Joe

thanks for the replay

answer your questions

1) i'm logon on with the default admin user id and password.  have tested with an invalid password and do get an error. A corrent password just goes back to the home page. I have also checked the user table to verify the password (admin)

2) browsers. i'm using the same browsers as i'm using for my development system ... no problem .. also used three different pcs to test it.. they all work with the development site/machine put not the NEW production server (hosted)

3) yes installed on new hosted server , deleted DNN and replaced with MP ... using a deployment package (mojoportal-2-3-9-3-mssql-net40-deploymentfiles.zip) . Yes it was a clean install WWWROOT was deleted and unzipped from the install package.

4) cleaned down the log file and rest the server and logged on (tried) ... here is the log

2012-11-09 07:43:49,380 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started.....

basically nothing ...

i have asked host provider what version of .net they are running 4... but i have not way of checking it

i do not think it is a browser problem , more on a server config problem, but i do not know what to test

the site is www.planmysuper.com.au

regards

 

lee berry

 

ps before i cleaned out the log file i took a copy .. i noticed a few no related errors you might want to look at .. like a few missing stored procedures ... banip address might be a problem ....

 

2012-11-08 21:24:22,851 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started.
2012-11-08 21:24:22,929 ERROR (null) - (null) - (null) - mojoPortal.Web.WebTaskManager - System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'mp_TaskQueue_DeleteCompleted'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters)
at mojoPortal.Data.DBTaskQueue.DeleteCompleted()
at mojoPortal.Web.WebTaskManager.StartOrResumeTasks(Boolean appWasRestarted)
2012-11-08 21:24:23,116 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.InvalidOperationException: The stored procedure 'mp_BannedIPAddresses_Exists' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2012-11-08 21:24:45,331 ERROR 202.125.40.22 - en-AU - / - mojoPortal.Web.mojoBasePage - 202.125.40.22-en-AU - /
System.InvalidOperationException: The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBSiteSettings.GetSiteIdByHostName(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
at mojoPortal.Web.SiteUtils.IsMobileDevice()
at mojoPortal.Web.mojoBasePage.OnPreInit(EventArgs e)
at mojoPortal.Web.UI.CmsPage.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2012-11-08 21:24:45,331 INFO 202.125.40.22 - en-AU - / - mojoPortal.Web.mojoBasePage - no sites or no database found in application error so try to redirect to Setup Page
2012-11-08 21:24:45,346 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.InvalidOperationException: The stored procedure 'mp_BannedIPAddresses_Exists' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2012-11-08 21:24:45,346 ERROR (null) - (null) - (null) - mojoPortal.Web.UrlRewriter - System.InvalidOperationException: The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBSiteSettings.GetSiteIdByHostName(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl)
at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)
2012-11-08 21:24:50,588 INFO 202.125.40.22 - en-AU - /Setup/Default.aspx - mojoPortal.Business.SiteSettings - SiteSettings expandoProperties was null so nothing was saved
2012-11-08 21:39:32,073 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Global.asax.cs Application_End
2012-11-08 21:42:06,938 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started.
2012-11-08 22:39:32,177 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Global.asax.cs Application_End
2012-11-09 02:42:22,791 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started.
2012-11-09 02:42:23,212 ERROR 65.55.52.115 - en-US - /privacy.aspx - mojoPortal.Web.PageNotFoundHttpModule - Referrer(none)  PageNotFoundHttpModule handled error.
System.Web.HttpException (0x80004005): The file '/privacy.aspx' does not exist.
at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound)
at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)
at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
at System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)
at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2012-11-09 02:42:23,228 ERROR 65.55.208.59 - en-US - /privacy.aspx - mojoPortal.Web.PageNotFoundHttpModule - Referrer(none)  PageNotFoundHttpModule handled error.
System.Web.HttpException (0x80004005): The file '/privacy.aspx' does not exist.
at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound)
at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)
at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
at System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)
at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2012-11-09 03:39:31,588 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Global.asax.cs Application_End
2012-11-09 03:43:44,501 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started.
2012-11-09 04:39:33,642 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Global.asax.cs Application_End

 

 

 

 

 

11/8/2012 4:45:02 PM
Gravatar
Total Posts 42

Re: can not logon to new install

Hi Joe

just notice one difference between the production (new) and the development server , the URL for the logon

production : http://www.planmysuper.com.au/Secure/Login.aspx?returnurl=%2f

Dev : http://localhost:50236/Secure/Login.aspx?returnurl=%2fDefault.aspx

should it have the default.aspx

regards

lee

 

11/9/2012 1:01:27 AM
Gravatar
Total Posts 42

Re: can not logon to new install

hi Joe

 

all fixed ...  got the Host Provider to install MP... even they had problems installing it..

not sure what !!

 

Thanks

 

Lee

 

11/9/2012 11:45:57 AM
Gravatar
Total Posts 18439

Re: can not logon to new install

Hi Lee,

Glad you got it working.

Those errors about missing procedures are expected until the setup page runs the database scripts that create them.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.