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.

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

7/21/2020 8:16:03 AM

uhebbar

Total Posts 11

View Posts

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

Joe Davis

Total Posts 2239

View Posts

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

10/13/2020 3:37:51 AM

burgerskelly

Total Posts 1

View Posts

Re: Installation Problems

mojoPortal is amazing!

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