Having multiple servers

Tyler

The industry I work in will always need imaging, I don't really use the management part, you may be right about that. Theopenem is the only solution I have found that is actually good at imaging in large quantities, everything else is single user solutions maybe with a hack that lets them scale a tiny bit.

Tyler

Is there a code sheet for verifydb?

It's giving me "5"

theopenem_admin

5 is fine, really any number other than an error message. It's just your checkin time.

Tyler

What is the format for Storage Path with local storage? I don't have the default value anymore

I have the iSCSI target mounted as D:\ and this target is just for Theopenem

theopenem_admin

It would just be d:\ then.

Tyler

Alright so,

Since storage location is configured globally I'm taking the old server down until I retrofit it to an iSCSI target (and install the recent update)

I have:

copied the database over as discussed
Configured the Theopenem sites on the new server
Set Storage Type Local, Storage Path D:\
Disabled the sites in the old server's IIS
Configured the Com Server entry
Added it to the default cluster
Removed the old server from the default cluster

When I go to the Dashboard, it takes 20+ seconds to load, and the whole site locks up

When the dashboard loads, there's nothing listed there.

This feels like something is wrong, but I don't actually know that

theopenem_admin

Did you give IIS permissions to the local storage?

Tyler

I matched the permissions on C:\toems_local_storage, no change, is there somewhere in IIS I have to configure permissions as well?

theopenem_admin

Definitely seems related to storage location. Anything in the application log?

Tyler

@theopenem_admin Just spent a while finding my own mistakes, so now I do have the new server listed correctly on the dashboard and the dashboard loads promptly. I have cleared up a lot of errors, but I'm still getting this one when the dashboard is loaded

FrontEnd.log

2024-03-06 11:53:16,772 [9] ERROR Toems_ApiCalls.ApiRequest Response Data Was Null For Resource: FileSystem/GetSMBFreeSpace/

I suspect something is still configured to think about SMB?
Maybe I'll find it as I regenerate WIE.

ClientAPI.log and Application.log are no longer accruing errors.

This is already solved but for future problem havers, I was getting:

2024-03-06 10:29:21,042 [44] ERROR Toems_ApiCalls.ApiRequest Could Not Complete API Request. The Response Produced An Error.Storage/GetFreeSpace
2024-03-06 10:29:21,074 [44] ERROR Toems_ApiCalls.ApiRequest

{
	"Message":"An error has occurred.",
	"ExceptionMessage":"One or more errors occurred.",
	"ExceptionType":"System.AggregateException",
	"StackTrace":"
		at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
		at Toems_ClientApi.Controllers.Authorization.InterComAuth.AuthenticateAsync(HttpAuthenticationContext context, CancellationToken cancellationToken)
		at System.Web.Http.Controllers.AuthenticationFilterResult.<ExecuteAsync>d__5.MoveNext()
		--- End of stack trace from previous location where exception was thrown ---
		at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
		at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
		at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()",
	"InnerException":
	{
		"Message":"An error has occurred.",
		"ExceptionMessage":"An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure.",
	"ExceptionType":"System.Data.Entity.Core.ProviderIncompatibleException",
	"StackTrace":"
		at System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)
		at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
		at System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
		at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
		at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
		at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
		at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
		at System.Data.Entity.Internal.InternalContext.Initialize()
		at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
		at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
		at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
		at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
		at System.Linq.Queryable.Where[TSource](IQueryable`1 source, Expression`1 predicate)
		at Toems_DataModel.GenericRepository`1.GetFirstOrDefault(Expression`1 filter, Func`2 orderBy)
		at Toems_Service.Entity.ServiceSetting.GetSetting(String settingName)
		at Toems_Service.Entity.ServiceSetting.GetSettingValue(String settingName)
		at Toems_ClientApi.Controllers.Authorization.InterComAuth.<isValidRequest>d__9.MoveNext()",
	"InnerException":
	{
		"Message":"An error has occurred.",
		"ExceptionMessage":"The provider did not return a ProviderManifestToken string.",
		"ExceptionType":"System.Data.Entity.Core.ProviderIncompatibleException",
		"StackTrace":"
			at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
			at System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)",
		"InnerException":
		{
			"Message":"An error has occurred.",
			"ExceptionMessage":"Unable to connect to any of the specified MySQL hosts.",
			"ExceptionType":"MySql.Data.MySqlClient.MySqlException",
			"StackTrace":"
				at MySql.Data.MySqlClient.NativeDriver.Open()
				at MySql.Data.MySqlClient.Driver.Open()
				at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
				at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
				at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
				at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
				at MySql.Data.MySqlClient.MySqlPool.GetConnection()
				at MySql.Data.MySqlClient.MySqlConnection.Open()
				at MySql.Data.MySqlClient.MySqlProviderServices.GetDbProviderManifestToken(DbConnection connection)
				at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)",
			"InnerException":
				{
				"Message":"An error has occurred.",
				"ExceptionMessage":"No such host is known",
				"ExceptionType":"System.Net.Sockets.SocketException",
				"StackTrace":"
					at System.Net.Dns.GetAddrInfo(String name)
					at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
					at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
					at MySql.Data.Common.MyNetworkStream.CreateStream(MySqlConnectionStringBuilder settings, Boolean unix)
					at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings)
					at MySql.Data.MySqlClient.NativeDriver.Open()"
				}
			}
		}
	}
}
2024-03-06 10:29:21,074 [44] ERROR Toems_Service.Workflows.ComServerFreeSpace Com server returned null for status. Check your com server URL!

The problem was that in toec-api\web.config I had pasted incorrectly and had connectionString="server=server=localhost; [...], this kind of error is hard for my eyes to pick up on.

There was also an interim error where an entire html page was dumped in the logs saying the com server's credentials were not authorized to connect from that host, I'll need to go in HeidiSQL and add a GRANT when the next server is coming up.

Tangent on that, for MariaDB, do you recommend sticking with the root account for all servers, or setting different credentials for each server?

theopenem_admin

If it's the only database that's running on there, then it really doesn't matter.