Greetings,
I am attempting to install and utilize Cloud Panel, it looks like a great product.
I have started with a complete fresh installation of Exchange 2013 CU9. I have done virtually no configuration on Exchange except adding the CloudPanel user to the Organizational Management group. The Exchange configuration is an individual single mailbox role and a single client access role spread on the two computers. The Exchange OS is Windows 2012 R2, is fully patched and running McAfee Virus Scan Enterprise 8.8.x. Cloud Panel is installed on its own server also running 2012 R2 fully patched with AV. The SQL (2014) is running on a shared server installation (SQL Server 12.0.4416.0). The CloudPanel SQL authentication account was granted system admin (ouch) as required. The SA rights will be a tough sell to DBA’s, security and compliance groups. Running create scripts as SA and applying Roll or User permissions to tables is more the norm in my world.
I have followed the Support/CloudPanel QuickStart guide outline and successfully executed the powershell commands modifying the organization path as required. The other outlined steps have also been followed and completed successfully. I have further watched the installation video (well done by the way). I would like to suggest a bit more detail regarding prerequisites when hosting CloudPanel on IIS namely the need for the Microsoft System CLR Types for SQL 2012 (x64) and Microsoft Report Viewer 2012 Runtime. These dependent packages could be added to the installer for installation as required (as I remember in Visual Studio setup projects, sorry old time developer myself).
OK on to the issue, upon successful installation (after adding the dependancies mentioned above) and entering the URL http://localhost/cloudpanel/admin/settings for the first time an exception is thrown stating: Cannot find the object “dbo.ResourceMailboxes” because it does not exist or you do not have permissions. Obviously from this point forward I am unable to complete the initial setup outlined in the video.
I am attaching the stack trace in html format for review.
Thanks for the support.
I am not seeing the stack trace but there is a logs folder in CloudPanel contains different log files. Can you email those to me at jdixon@knowmoreit.com?
Running CloudPanel for the first time should update the database each time the application is started. It sounds like something is wrong and it is unable to update the database
Jacob,
Thanks for the quick reply.
I found logs located at “C:Program Files (x86)Know More ITCloudPanelLog” and saw many xml settings files due to my numerous attempts of installation. I opened one of the logs and saw a statement similar to SQL operations pending. I then looked at the SQL server and noticed two databases were created as I named them differently in my installation attempts.
Once I saw the SQL misconfiguration I did the following:
1) Uninstalled CloudPanel, success,
2) Manually removed the file system directory “C:Program Files (x86)Know More IT”, success,
3) Took offline the two SQL databases using SQL Server Management Studio 2014, success,
4) Deleted the two databases using SQL Server Management Studio 2014, success,
5) Deleted the file system associated database files, i.e., .mdb and .ldf, success,
6) Reinstalled CloudPanel, success,
7) Entered http://localhost/cloudpanel/admin/settings, success.
There is no blame being placed here, just my observation: I would attribute the problem to two points where initially the Report Viewer was not installed and the reinstallation of CloudPanel (after a successful uninstall) left remnants of pending operations at the database level through some form of a chained configuration event.
I also want to say thank you for making the product available and that I recognize the hard work and many hours of development to produce the product. I have personally lost more years than I choose to remember developing solutions (35 years in IT).
Please mark this request as closed.
Appreciate it,
Albert
Since the Stack Trace did not survive the original upload, it follows below:
Server Error in '/CloudPanel' Application.
Cannot find the object "dbo.ResourceMailboxes" because it does not exist or you do not have permissions.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot find the object "dbo.ResourceMailboxes" because it does not exist or you do not have permissions.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[SqlException (0x80131904): Cannot find the object "dbo.ResourceMailboxes" because it does not exist or you do not have permissions.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +388
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +717
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +1387
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +533
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +287
System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch(TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action3 executing, Action3 executed) +208
System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) +438
System.Data.Entity.Migrations.DbMigrator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) +251
System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) +111
System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinNewTransaction(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext) +267
System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext) +457
System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection) +638
System.Data.Entity.SqlServer.<>c__DisplayClass1.<Execute>b__0() +15
System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +263
System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements, DbTransaction existingTransaction) +338
System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable1 operations, IEnumerable1 systemOperations, Boolean downgrading, Boolean auto) +1170
System.Data.Entity.Migrations.DbMigrator.AutoMigrate(String migrationId, VersionedModel sourceModel, VersionedModel targetModel, Boolean downgrading) +1037
System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration) +386
System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId) +169
System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase) +1134
CloudPanel.Bootstrapper.UpdateDatabase() +407
CloudPanel.Bootstrapper.ApplicationStartup(TinyIoCContainer container, IPipelines pipelines) +207
Nancy.Bootstrapper.NancyBootstrapperBase`1.Initialise() +660
Nancy.Hosting.Aspnet.NancyHttpRequestHandler..cctor() +32
[TypeInitializationException: The type initializer for ‘Nancy.Hosting.Aspnet.NancyHttpRequestHandler’ threw an exception.]
Nancy.Hosting.Aspnet.NancyHttpRequestHandler..ctor() +0
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) +159
System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) +256
System.Activator.CreateInstance(Type type, Boolean nonPublic) +127
System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark) +14297981
System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +198
System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture) +28
System.Web.HttpRuntime.CreateNonPublicInstance(Type type, Object[] args) +83
System.Web.Configuration.HandlerFactoryCache..ctor(String type) +57
System.Web.HttpApplication.GetFactory(String type) +94
System.Web.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +375
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +288
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34248
`
I’m glad you got it working!
Yeah CloudPanel is still a work in progress. I used to install those prerequisites with the installer but it wasn’t working right with the Report Viewer Runtime. I swear i’ve spent more time getting the installer software “Advanced Installer” working the way I want (which still isn’t) than I would have liked too.
Let me know if you need a walk through or anything and we can schedule a demo.
I feel the pain…
The only other questionable point so far is when configuring the Admin/Settings/Exchange/Server the tool tip crops at the top (no big deal) yet does not say “typically the Hub or CAS server.” When pointed to the mailbox roll server and a database refresh is requested, an error is thrown with object reference not set to an instance of an object. Just my two cents.
I remember reading a thread where a franchise configuration was requested. I guess it would be in my case, can OU admins create their own users and mailboxes under the default authoritative domain?
I’m starving for more documentation.
Thanks again.
