Error when adding user to CloudPanel
I’ve created the first reseller and company, and all the required plans. I’ve also enabled Exchange for that company.
When I try to add my first user, I get an error in my browser that states:
X Error! An error occurred while updating the entries. See inner exception for details.
The error in the log is:
00 ::: [14] ERROR ::: CloudPanel.Modules.UsersModule — Error creating new user for company KNO1: System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. —> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. —> System.Data.SqlClient.SqlException: Invalid column name ‘TaskType’.
Looks like I need to add something to the SQL database maybe?
Someone else pointed this out to me this weekend. For some reason it left off the column on new installs and I’ll have to fix that
You can open SQL and on the delayedusertasks table just add a new column named TaskType with the integer (int) data type
That took care of it. Thank you!
Once I went back into the Customer though, I got another error:
2015-06-21 20:21:26,614 ::: [15] ERROR ::: CloudPanel.Modules.Admin.ExchangeModule — Error pulling exchange message log history data: System.InvalidOperationException: The cast to value type ‘System.Int32’ failed because the materialized value is null. Either the result type’s generic parameter or the query must use a nullable type.
I quickly realized that I hadn’t forced the scheduler to update. Once I did that, it seems to be fine. Might want to set the scheduler default to pull the initial data during installation.
Thank you again!
Got several companies and users created.
None of them can login to OWA. The only account that can login to OWA is the administrator. I’ve already changed the OWA login type to UPN in the control panel.
When I login as administrator@domain.local everything works fine. When I login as gene@test.com — I get no errors at all and just get bounced back to the OWA login page.
I can’t find anything in the Exchange logs that even resembles an error.
When you create the user did you choose to enable the mailbox? There is a checkbox. Also you can edit the user afterwards and enable the mailbox.
On the users page with the list of users you will see a yellow envelope if they have a mailbox.
It sounds like you didn’t enable a mailbox.
That’s what I thought too, so I double checked. The mailboxes are all enabled.
Didn’t I do a remote session with you and take care of this? Just checking
Didn?t I do a remote session with you and take care of this? Just checking
Yes, you certainly did. I was running everything on Server 2008 R2. It appears that installing CU9 as an update to Exchange 2013 SP2 broke permissions in Exchange.
I have since reinstalled everything using Server 2012 R2, and Installing Exchange CU9 directly. No issues at all (other than having to manually create the TaskType column in the delayedusertasks table)
Everything is working very well so far.
- 5 Forums
- 717 Topics
- 3,651 Posts
- 0 Online
- 260 Members