CloudPanel Service has not checked in
- It appears the CloudPanel service has not checked in for over 24 hours. Please make sure that the CloudPanel service is running as it is a vital service.
I have seen some other forums that say the cloudpanel schedule service needs to be running. i do not have a cloud panel schedule service. i try to install it and the install fails as well. needless to say i dont have any report gathering of mailbox sizes, emails, etc due to this and i am sure other issues i am not aware of. any help thanks.
Thanks, Lee
lthompson Topic starter
2021-05-21 14:49
i have made sure the user credentials being provided have log on as a service both on local group policy and domain group policy. i have ran gpupdate, logged off and back on, and restarted server. installer goes as far as saying could not start verify you have privilege’s
Jacob Dixon 2021-05-28 11:19
The user installing the service must have access to SQL as well as the user that will run the service. When the installer gets stuck in that position try to open services.msc and you will see CloudPanel Service listed there. Open up the service and re-enter the username/password and save. See if you can start the service and then click Retry on the installer.
If that does not work there should be a log file where the installer is installed to and also some logs in the event viewer if you could post those.
lthompson Topic starter
2021-06-09 12:38
i have tried that already as well. the log says login failed but i know credentials are correct and verified the user has access to sql and can get in to sql mgmt studio with those credentials as well. now cloudpanel itself doesnt even work. I have 210 accounts to add to this and nothing is even working. cloudpanel itself doesnt even work any more. route by sender isnt working any more. nothing from any of these products are working.
lthompson Topic starter
2021-06-09 12:40
[2021-06-01 13:01:52,949] | ERROR | CPService.CPService | Shutting down service because we could not retrieve the settings from the database. Please check your database connection string and try again
[2021-06-01 13:11:36,759] | INFO | CPService.CPService | Job GetSettingsTask was excecuted now and scheduled to run every 15 minutes
[2021-06-01 13:11:36,928] | INFO | CPService.Tasks.Settings.GetSettingsTask| Job Executed: Updating settings from database
[2021-06-01 13:11:47,158] | ERROR | CPService.Tasks.Settings.GetSettingsTask| Error getting settings: System.Data.SqlClient.SqlException (0x80131904): Cannot open database “CloudPanel” requested by the login. The login failed.
Login failed for user ‘CPH\cphdcmgr’.
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user)
at System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe()
at System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode()
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.Table`1.System.Linq.IQueryProvider.Execute[TResult](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
at CPService.Tasks.Settings.GetSettingsTask.Execute(IJobExecutionContext context)
ClientConnectionId:eb3e4316-0fab-46f6-9e5b-33e78a54c0a9
Error Number:4060,State:1,Class:11
[2021-06-01 13:12:36,902] | ERROR | CPService.CPService | Shutting down service because we could not retrieve the settings from the database. Please check your database connection string and try again
Jacob Dixon 2021-06-10 09:36
It says in the logs that the user CPH\cphdcmg does not have access to the SQL database. You most likely installed the service as a different user and entered the CPH\cphdcmg as credentials. The problem is your user had access (because it checks) but the user CPH\cphdcmg does not have access. You need to open SQL Management Studio and grant the user CPH\cphdcmg access (sysadmin) to the SQL server
Did you ever get this resolved? I never heard anything back from my last response:
“It says in the logs that the user CPH\cphdcmg does not have access to the SQL database. You most likely installed the service as a different user and entered the CPH\cphdcmg as credentials. The problem is your user had access (because it checks) but the user CPH\cphdcmg does not have access. You need to open SQL Management Studio and grant the user CPH\cphdcmg access (sysadmin) to the SQL server”
