Installation Problems

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.

7/21/2020 8:16:03 AM
Gravatar
Total Posts 7

Installation Problems

Hi Joe,

I've been using mojo for a long time now. I am trying to do a fresh install and am running into all kinds of issues. I am using MySQL 8.0.12. I have already installed the connector and created a database called mojoportal. When I run the program I keep getting the below errors

 

2020-07-21 09:10:59,676 INFO (null) - (null) - (null) - mojoPortal.Web.Global - Application Started. 
2020-07-21 09:11:01,444 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:  
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'mojoportal.mp_bannedipaddresses' doesn't exist
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText, MySqlParameter[] commandParameters)
   at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress) in C:\mojoportal\mojoportal-master\mojoPortal.Data.MySql\dbBannedIP.cs:line 184
   at mojoPortal.Business.BannedIPAddress.IsBanned(String ipAddress) in C:\mojoportal\mojoportal-master\mojoPortal.Business\BannedIPAddress.cs:line 148
   at mojoPortal.Web.BannedIPBlockingHttpModule.IsBanned(String ip) in C:\mojoportal\mojoportal-master\Web\Components\BannedIPBlockingHttpModule.cs:line 241
   at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e) in C:\mojoportal\mojoportal-master\Web\Components\BannedIPBlockingHttpModule.cs:line 79
2020-07-21 09:11:01,493 ERROR (null) - (null) - (null) - mojoPortal.Web.UrlRewriter - MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'mojoportal.mp_sitehosts' doesn't exist
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean externalConn)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
   at mojoPortal.Data.DBSiteSettings.GetSiteIdByHostName(String hostName) in C:\mojoportal\mojoportal-master\mojoPortal.Data.MySql\dbSiteSettings.cs:line 1975
   at mojoPortal.Business.SiteSettings.GetSiteIdByHostName(String hostName) in C:\mojoportal\mojoportal-master\mojoPortal.Business\SiteSettings.cs:line 2715
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 429
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 402
   at mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentSiteSettings() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 392
   at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl) in C:\mojoportal\mojoportal-master\Web\Components\UrlRewriter.cs:line 410
   at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app) in C:\mojoportal\mojoportal-master\Web\Components\UrlRewriter.cs:line 180
   at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e) in C:\mojoportal\mojoportal-master\Web\Components\UrlRewriter.cs:line 69 
2020-07-21 09:11:01,514 ERROR 10.0.142.12 - en-US - / - mojoPortal.Web.Global -  Referrer(none) useragent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36 
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'mojoportal.mp_sitehosts' doesn't exist
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean externalConn)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
   at mojoPortal.Data.DBSiteSettings.GetSiteIdByHostName(String hostName) in C:\mojoportal\mojoportal-master\mojoPortal.Data.MySql\dbSiteSettings.cs:line 1975
   at mojoPortal.Business.SiteSettings.GetSiteIdByHostName(String hostName) in C:\mojoportal\mojoportal-master\mojoPortal.Business\SiteSettings.cs:line 2715
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 429
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 402
   at mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentSiteSettings() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 392
   at mojoPortal.Web.SiteUtils.SslIsAvailable() in C:\mojoportal\mojoportal-master\Web\Components\SiteUtils.cs:line 2313
   at mojoPortal.Web.Global.Application_BeginRequest(Object sender, EventArgs e) in C:\mojoportal\mojoportal-master\Web\Global.asax.cs:line 445
   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2020-07-21 09:11:01,700 ERROR 10.0.142.12 - en-US - /favicon.ico - mojoPortal.Web.Global -  Referrer(http://localhost:59438/) useragent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36 
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'mojoportal.mp_sitehosts' doesn't exist
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean externalConn)
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
   at mojoPortal.Data.DBSiteSettings.GetSiteIdByHostName(String hostName) in C:\mojoportal\mojoportal-master\mojoPortal.Data.MySql\dbSiteSettings.cs:line 1975
   at mojoPortal.Business.SiteSettings.GetSiteIdByHostName(String hostName) in C:\mojoportal\mojoportal-master\mojoPortal.Business\SiteSettings.cs:line 2715
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 429
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 402
   at mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentSiteSettings() in C:\mojoportal\mojoportal-master\Web\Components\CacheHelper.cs:line 392
   at mojoPortal.Web.SiteUtils.SslIsAvailable() in C:\mojoportal\mojoportal-master\Web\Components\SiteUtils.cs:line 2313
   at mojoPortal.Web.Global.Application_BeginRequest(Object sender, EventArgs e) in C:\mojoportal\mojoportal-master\Web\Global.asax.cs:line 445
   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 

I tried changing the DB name in the user.config to something else and then it tells me DB not found.

 

Please can you assist

Thanks

Uday

 

8/21/2020 6:21:45 PM
Gravatar
Total Posts 2169

Re: Installation Problems

Hi,

When mojoPortal starts the first time, the database is empty (or should be) and a lot of errors are logged. These can be ignored. 

Have you gone to /setup and gotten errors there?

Thanks,
Joe