Hi
We have upgraded CloudPanel and CloudPanel Scheduler from version 3.1.1540 to version 3.2.256.0 a few days ago.
Since then, the Scheduler has not collected any data.
I opened the “service.log” and found the follwing errors:
2018-06-30 23:08:49,383 [QuartzScheduler_Worker-1] ERROR CPService.Tasks.ActiveDirectory.Get_DisabledUsersTask Error processing disabled users: System.ArgumentException: The user name and password must either both be null or both must be non-null.
2018-06-30 23:09:04,071 [QuartzScheduler_Worker-2] ERROR CPService.Tasks.Exchange.Get_ExchDelayedTasks Unable to get tasks from database: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)
In the file “Scheduler.exe.config” I found the following line:
<appSettings>
<add key=”connectionString” value=”server=LAB-DC01.lab.local\SQLEXPRESS;database=CloudPanel;Integrated Security=SSPI”/>
</appSettings>
Which did not reflect our actual sql server, so i changed it to the correct values and restartet the service.
This seams to have solved the first error messages.
In the file log4net.xml I found the follwing line:
<connectionString value=”data source=SQLSVR;initial catalog=test_log4net;integrated security=false;persist security info=True;User ID=sa;Password=sa“/>
Do I have to change the value of “User ID” and “Password” to our actual SQL accound and password??
Is there anything else I should check or modify?
Regards
Roger
WBCH Topic starter
2018-07-02 05:10
Update:
E-Mail-Statistics are now showing again, but when I click the refresh button for the mailbox databases on the dashboard, I receive the follwing error:
Cannot implicitly convert type ‘System.Collections.Generic.List’ to ‘System.Collections.Generic.List’
Reagards
Roger
When you upgrade you should uninstall the service and install it again (not upgrade). This will give you the option of Windows Authentication or Sql Authentication which will put the correct connection string in. If you use Windows Authentication it will use the account that the service is running as for the database, so that account must have access to the database. Also the account running the service must have access to Exchange.
For the email statistics you can go to the new database section located in the menu at the top right and refresh it there. The button on the dashboard is indeed broken but fixed in the next release. The CloudPanel service will make sure those stay up to date so there won’t be a reason to fresh it unless the service isn’t working properly.
