fusecp / solidcp Goto Github PK

Describe the bug
If you disable a RDS-Server in a hosting space, there is no possibility to enable it, neither for the users/resellers nor for the serveradmin. Only the "Disable" button is shown. In this case no new users are able to login anymore.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'RDS-Servers' in a hosting space
2. Click on 'Disable'

Expected behavior
The button should be changed to "Enable" to allow users, resellers and serveradmin to enable the server and new connections from users.
As an enhancement there should also a "Do you want to disable/enable the RDS server" prompt should also be shown, if you click the buttons to prevent an accidently disabling of the server.

SolidCP Info

• SolidCP Version: 1.4.4

Additional context
There is already an "Enable" button in the code, but it seems that the eval function in the visible attribute delivers a wrong value and prevent the button from being shown:

MSSQL databases should be created as contained databases in SQL 2014 or later.

This will stop users being able to see / attempting to access databases which they do not have permission for:

https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases?view=sql-server-ver15

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

When adding a website using the SimpleDNS 8.x provider the A-records for the domain are not added to the DNS zone. Using older provider (SimpleDNS 5.x) works without issues.

Using standard DNS configuration on service settings

Describe the bug
When a user doesn't have external network enabled in their hosting plan then a VM cannot be created.

To Reproduce
Steps to reproduce the behaviour:

1. Disable External Network in Hosting Plan
2. Try create VM

Expected behaviour
VM to create without an network.

SolidCP Info

• SolidCP Version: 1.4.7

There is an overview of hosting control panels in Wikipedia. Add FuseCP there. Maybe wait until the official website is online under the new name and the old name SolidCP is history, to avoid confusion?
https://en.wikipedia.org/wiki/Comparison_of_web_hosting_control_panels

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

i translate portal to Arabic language but for final need portal to support RTL also There are phrases that have not been accessed and translated

SolidCP Language Pack ar-AE 1.4.7.zip

Resources.zip

Can some documentation be provided on how to customise the theme?

I see there is a theme selector, however no where is it documented on how to add / create one

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Describe the bug
When trying to import uses of a MsSQL 2019 server none are listed

To Reproduce
Steps to reproduce the behaviour:

1. Create SQL User
2. Detach SQL User
3. Go to import resources
4. Select SQL Users

Expected behaviour
Expected behaviour is unattached users to be listed so you can import them

SolidCP Info

• SolidCP Version: 1.4.7

Additional context
It appears when running the SQL Query
select name from master..syslogins where isntname = 0 and sysadmin = 0 and password is not null

from https://github.com/FuseCP/SolidCP/blob/master/SolidCP/Sources/SolidCP.Providers.Database.SqlServer/MsSqlServer.cs#L381 it doesn't return the value. It appears this is due to password always returning null.

Following https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/mapping-system-tables-to-system-views-transact-sql?view=sql-server-ver15 this has been changed and we should now be using sys.sql_logins but this does not have a password field.

Is your feature request related to a problem? Please describe.
Nearly all open-source and commercial solutions similar to SolidCP include a feature to backup a website and send the backup to an offsite location, and most of them also allow you to do this on a schedule. This is a request to add that feature to this solution as well.

Describe the solution you'd like
Add a service that can be added to hosting plans for offsite backups and scheduling the backups to occur. The two most popular offsite backup locations that I can see needing to be present are AWS and FTP.

Describe alternatives you've considered
Right now, we are forced to use other solutions and/or do this manually.

Additional context
Reported in the community forums: https://solidcp.com/forum/question/remote-backup-feature/

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Remove the usage of outdated jquery's and update old methods used.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Description:
Implement in-VM statistics for deeper monitoring purposes - helps both admins reduce time in troubleshooting and users know their usage.

Issues:
Currently, SolidCP Hyper-V offers VM statistics on host level, which could be confusing for users, especially CPU stats as it shown "how much CPU is the VM using from the host", not the actual utilization "inside the VM", and is missing a few parameters such as network speed, bandwidth usage, disk IOPS usage, ...

Ideas:

• As per my checking, there are counters on Windows (host node) that helps providing in-VM stats and we can grab the information from the host itself.
  Source: https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/role/hyper-v-server/detecting-virtualized-environment-bottlenecks
• We can store logs in 30 days grace as it's more than enough for any performance monitor/troubleshooting (even 7 days should be enough).
• Implement a graph in SolidCP portal.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

I was wondering if enabling search on multiple search terms in solidcp would be possible any time soon, i.e. enetering more than one keyword/search term (a combination of search terms) in order to obtain results.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Describe the bug
If you create an e-mail activated public folder, the Anonymous permission is set correctly to "CreateItems" but the Default permission is set to none. Therefore this public folder can only accept e-mails from external and from the same organization users. But if a user from an other organization inside the same Exchange infrastructure will send an e-mail to this public folder, he will get an NDR.

To Reproduce
Steps to reproduce the behavior:

1. Create an e-mail activated public folder in Org1
2. Create a mailbox in Org2 (different hosting space) on the same Exchange infrastructure
3. Try to send an e-mail from mailbox in Org2 to public folder in Org1

Expected behavior
When a public folder will be e-mail-activated in SolidCP, also the following right should be applied to it:
Add-PublicFolderClientPermission -Identity "\Org1PF\Test" -User "Default" -AccessRights "CreateItems"
With this right, it's possible to send e-mails from other users in different Orgs on the same infrastructure to this public folder.
To make it more complete, maybe the "CreateItems" right can be removed from the Default user, if the public folder will become "non" e-mail activated in SolidCP.

SolidCP Info

• SolidCP Version: 1.4.6 and previous

Describe the bug
When a deny OU permission is made further up then it will cause the error:

This access control list is not in canonical form and therefore cannot be modified. at System.Security.AccessControl.CommonAcl.ThrowIfNotCanonical()

To Reproduce
Steps to reproduce the behavior:

1. Go to root OU and add a deny permission and apply to all children
2. Create a new Hosted Org in SolidCP
3. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots

SolidCP Info

• SolidCP Version: 1.4.4

Describe the bug
Due to installer changes the version has been hardcoded and needs to be made dynamic again.

To Reproduce
Steps to reproduce the behavior:

1. Build new version of code
2. Look at Portal version number

Expected behavior
A clear and concise description of what you expected to happen.

SolidCP Info

• SolidCP Version: 1.4.6

Is your feature request related to a problem? Please describe.
SolidCP provides no granular disk space reporting for hosted services and 99% of users disk space is related to mail.
If the user cannot see which mailboxes are consuming the most space then there is an expectancy of reliance on the hosting provider to provide this to them which consumers man hours.

Describe the solution you'd like
Add the ability to report on per user disk usage for smartermail mail boxes.
On the SpaceMailAccounts page, add a column to include disk usage.
Describe alternatives you've considered
None

Additional context

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Can the API endpoints be documented.

And can the API authentication method be documented, that way I can build an SDK.

I can't read PHP so the WHMCS module is useless for me

Ability to select different color schemes and design options

I have noticed an issue in the file manager that we can't edit any file with a $ symbol already in the file name.

Similarly, if you try to create a new file with a $ symbol in the filename, the file will not be created correctly.

Can you please support $ symbol handling in filenames?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Is your feature request related to a problem? Please describe.
The current SmarterMail provider uses the legacy SOAP API which has missing and broken functions on it.

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
None due to the fact the legacy API is broken and nolonger updated.

Additional context
The forwarding is broken on the legacy API and has been requested to be fixed multiple times on the forum.

Describe the bug
When creating a CAA record on Microsoft DNS it is never created on the server and no error is given.

To Reproduce
Steps to reproduce the behavior:

1. Go to DNS
2. Create CAA DNS Record
3. Check server and not created

Expected behavior
CAA record to be created

SolidCP Info

• SolidCP Version: v1.4.7

Additional context
The code doesnt appear to have been added to Microsoft DNS for CAA. Details can be found at https://www.ssls.com/knowledgebase/caa-record/#4 on the powershell command

Windows Server 2016 added Unknown record support

Describe the bug
Smartermail IIS log grows due to constant AP calls and the tasks takes a further 6 minutes to process per account. If multiple accounts are added on a single day the task and log will take a while.

To Reproduce

1. Create Smartermail account
2. Run bandwidth task

Expected behavior
The task should run from the day before the account has been made and not from 1/1/0001. We should fill the BandwidthUpdated for the account on creation.

Screenshots
If applicable, add screenshots to help explain your problem.

SolidCP Info

• SolidCP Version: v1+

Additional context
https://solidcp.com/forum/question/count-bandwidth-scheduled-task-infinite-loop-on-smartermail-server/page/3/

As mentioned 5 years ago.... The login screen logo still does not change when changed in the settings:

https://solidcp.com/forum/question/login-page-logo/

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Describe the bug
If you delete a RDS collection or a RDSH server in SolidCP from "Configuration" -> "RDS Servers", the RDSH server is not removed from the RDS deployment in Windows Server.
The issue is, if you don't do it manually and delete the RDSH VM and the computer object in AD, you have no supported possibility to remove this RDSH from the deployment anymore. This can cause other issues with the view on the RDS deployment in Windows Server Manager.

To Reproduce
Steps to reproduce the behavior:

1. Remove an existing RDSH server from SolidCP
2. Login to the RDS gateway and perform a Powershell CMD: "Get-RDServer".

Expected behavior
RDSH servers should be removed from the RDS deployment either on deletion of the RDS collection or the RDSH server in SolidCP.

SolidCP Info

• SolidCP Version: 1.4.6 and earlier

Describe the bug
All users in OU still will be disabled in AD after suspension and activation of the SolidCP account.

To Reproduce
Steps to reproduce the behavior:

1. Suspend and activated a SolidCP account with Hosted organization.
2. Check organization users in AD, after activation of the SolidCP account - they will be still disabled.

Expected behavior
Users in AD should be enabled after activation of the SolidCP account.

SolidCP Info

• SolidCP Version: 1.4.6

Describe the bug
When running Web Application Engines it errors out.

System.NullReferenceException: Object reference not set to an instance of an object.
at SolidCP.Server.WindowsServer.ProductToWPIProduct(Product product)

To Reproduce
Steps to reproduce the behaviour:

1. Go to Configuration -> Servers
2. Click on Web Application Engines

Expected behaviour
SolidCP to provide a list of applications to install

Screenshots

SolidCP Info

• SolidCP Version: 1.4.4

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Exchange 2013+ Contact primary email or secondary email is not set with any value of the External email address.
This is causing mail flow restrictions not to work.

Steps to reproduce the behavior:

1. Create a contact in SolidCP
2. Go to Exchange ECP -> Contacts --> Edit your contact
3. In the General tab: External email is set correct.
4. In the Email addresses tab: internal emails are only listed (even though it states * external email in general tab is the primary email, to edit it adjust the external email)

Due to this Mailflow restrictions (such as limiting Distribution list to only allow to receive email from specific contacts and mailboxes) is not working correctly, and providing the "not authorized to send to the distribution list".

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Many sources and tasks in the audit log are shown in capital letters. I suppose it's a constant for a value, which is missing somewhere. These sources and tasks cannot be filtered, because the value is missing in the select box. There are also a lot of audit log entries, where the item name is missing, for e.g. in the "ADD_USER_TO_RDS_COLLECTION" task it would be useful to see and filter which user was added.

Describe the bug
If you install a Let's Encrypt certificate on a website, SolidCP will show a "Successfull" message, even if the cert creation wasn't successfull and WACS has reported some errors.

To Reproduce
Steps to reproduce the behavior:

1. Create a website on a subdomain for example (subdomain.domain.com). SolidCP will automatically create a subdomain.domain.com and a www.subdomain.domain.com pointer to this website in IIS.
2. In your DNS create only an A record for the subdomain without "www.".
3. Go to the website in SolidCP -> SSL and press "Install Certificate" button
4. You will see a green message box, but no certificate was created, because LE and WACS has reported a missing www.subdomain.domain.com verification.

Expected behavior
SolidCP should show WACS errors, if a creation of a certificate wasn't successful. The "reproduce" section is just only for cause an error in WACS, so I suppose that other errors won't be shown, too (for example rate limit exceeded).

SolidCP Info

• SolidCP Version: 1.4.6

Describe the bug
If you go as Serveradmin to "Configuration" -> "Servers" and select a "Remote Desktop Services" server, you have the possibility to add custom DNS settings on the bottom of this page (for example an "_msradc" TXT record. But this DNS record won't be set on a new DNS creation in a hosting space.

To Reproduce
Steps to reproduce the behavior:

1. Go to "Configuration" -> "Servers" and select a "Remote Desktop Services" server.
2. Add a custom DNS record on the bottom of this page and Update this server.
3. Now if you create a new hosting space, which include this RDS server and activate the DNS service, there is no custom DNS record set (like it's working in Exchange server for example)

Expected behavior
A custom DNS record should be set on a creation of a hosting space, which includes the server with custom DNS records, but only if RDS is also a part of the hosting space/hosting plan incl. addons.

SolidCP Info

• SolidCP Version: 1.4.6

If you want to create new or edit existing DNS records for e.g. domain.com, it's currently possible to enter also "test.domain.com" into the record field.

On SimpleDNS I suppose that the API is "fixing" it, so the right record "test.domain.com" will be created, doesn't matter if you enter only "test" or "test.domain.com".

On MS DNS the correct record will only be created, if you enter "test" only. If you enter "test.domaind.com", then a "test.domain.com.domain.com" record will be created.

In general, does it make sense to "cut" the FQDN at the end of the record form field in the background, so the experience will be consistent over all DNS providers? Or maybe it make more sense to create a kind of validator to show an error, if "test.domain.com" is entered into the record field? In this case it would be good to add a text after the form field, showing ".domain.com", so the user will notice to type the record without the FQDN.

How do other DNS software handle it in SolidCP?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Give provision to automatically suspend the subscription at a specific end date.

If we suspend any subscription at that time we need to manually disable its mail accounts, which need a feature to suspend it automatically.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

I want to create a new hosted organization for a customer.

(the domain name on the three boxes)

When I click on 'Create Organization' I get this error:

Error creating organization. See audit log for more details.

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'CREATE_ORG' task on 'domain.es' ORGANIZATION ---> System.Exception: Error executing 'CREATE_ORG' task on 'OU=domain.es,OU=Clientes,DC=domain,DC=local' ORGANIZATION ---> System.Exception: Error executing 'CREATE_ORG' task on 'OU=domain.es,OU=Clientes,DC=domain,DC=local' ORGANIZATION ---> System.Exception: Error executing 'CREATE_ORG' task on 'OU=domain.es,OU=Clientes,DC=domain,DC=local' ORGANIZATION ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Could not enable mail Security Distribution Group 'domain.es' at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at

After that I go to the event viewer at the exchange server and I got this:

• Exchange 2019 server
• SolidCP Version: 1.4.4

Desktop (please complete the following information):

• OS: Windows 10
• Browser Chrome
• Version Versión 78.0.3904.97

Smartermail 100 doesn't appear to allow the user to forward the mailbox. There is no errors in SolidCP and its not set on Smartermail when we check the UI.

Steps to reproduce the behavior:

1. Create a email address
2. Set the forwarding email.
3. Check users Smartermail account and Automated Forwarding is disabled

More info at: https://solidcp.com/forum/question/smartermail-automated-forwarding/

Currently there is no possibility to manage automatic replies for mailboxes via SolidCP.

It would be nice to get a new tab inside a mailbox in SolidCP with automatic replies settings. In my opinion this tab or pane inside the settings tab should be only visible if it's a regular mailbox, if automatic replies are enabled in the hosting space quota and maybe in the mailbox plan (see my questions below).

The following values should be editable and pushed via this PS command:

Set-MailboxAutoReplyConfiguration
-Identity
-AutoReplyState
-StartTime  (if AutoReplyState = scheduled)
-EndTime (if AutoReplyState = scheduled)
-ExternalAudience
-ExternalMessage (if ExternalAudience = None, then ExternalMessage = $null and the field is disabled.)
-InternalMessage

InternalMessage and ExternalMessage should be editable with the already implemented TinyMCE editor in SolidCP to create a clear HTML output. In this case all quotes inside the HTML should be escaped ( " ) while passed to the powershell command, otherwise it will throw errors (see my questions below).

Please be aware, that Exchange handles e-mails between two different tenants/organizations within the same environment as internal messages without any 3rd party extensions.

Additional questions to all, who see it as a useful feature:

• Where is the best place to put these automatic replies settings inside the mailbox configuration? In a seperate tab or as a panel inside the settings tab?

• Does it make sense or is it even possible to allow oof settings also for shared and/or ressource mailboxes?

• Does it make sense to create also a quota for oof inside the mailbox plans? Maybe someone want to make some mailbox plans, which are not allowed to have oof settings while on a global hosting space level it's allowed for all other mailboxes. On the other side it's still allowed for everyone via OWA, so don't know if it would be a useful quota or not.

• Is it enough to escape quotes ( " ) from Internal and ExternalMessage HTML output to avoid errors, or should be other checks/regex/sanitization rules implemented?

Is your feature request related to a problem? Please describe.
ACME1 support is now being removed so WACS is needed.

Describe the solution you'd like
The command to be ran: wacs –import

Describe alternatives you've considered
None provided

Additional context
https://solidcp.com/forum/question/lets-encrypt-renewal-issue-after-update-to-version-1-4-4/

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

The Stored Procudures "GetRDSCollectionById" "UpdateRDSCollectionSettings" are missing three fields that thus never get updated by the UI (RDP Collection > Settings).

• SecurityLayer
• EncryptionLevel
• AuthenticateUsingNLA

Can someone please add those?
The C# code to handle them is all there. So I guess that someone forgot to update the update_db.sql file when deploying these fields?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Describe the bug
Smartermail15 not detected when trying to add it and gives the error “The expected version of the software is not found on your server”

To Reproduce
Steps to reproduce the behaviour:

1. Install SmarterMail 15
2. Go to Servers -> Settings (on the server with SmarterMail 15 is installed)
3. Click add next to mail and select SmarterMail 10.x + from the dropdown
4. See error

Expected behavior
SolidCP to see that the software is installed

SolidCP Info

• SolidCP Version: v1.4.5
• SmarterMail: 15.7.6970

Additional context
I believe this does cover all SmarterMail 15 versions

Describe the bug
If two or more RDS collections in one organization then group policy applies to all users.

To Reproduce
Steps to reproduce the behavior:

1. Make two RDS collections in one organization
2. Add diverse users to each collection
3. Go to User Experience and set up any policies
4. Group policies will applies to all collections

Expected behavior
GPO should applies only to collection group, not for all organization.

SolidCP Info

• SolidCP Version: 1.4.6

Additional context
SolidCP do not remove Authenticated Users from GPO security filter

Describe the bug
When removing the Hosting Space which contains an SimpleDNS domain it doesn't make the call to remove the domain.

To Reproduce
Steps to reproduce the behavior:

1. Create Hosting space with SimpleDNS
2. Add Domain
3. Remove Space
4. Check SimpleDNS Admin and domain is still present

Expected behavior
When the space is removed so is the domain from SimpleDNS.

Screenshots

SolidCP Info

• SolidCP Version: v1.4.5 (Tested)

Additional context
The SimpleDNS API log appears to be empty which suggests no API call has been made.

Describe the bug
When WACS is used it sets the email address to the customer. This is set on the single LE account and therefore all the servers LE domains receive alerts.

To Reproduce
Steps to reproduce the behavior:

1. Create site with SSL
2. Load WACS -> More options -> ACME Account Details
3. Email will be a customer

Expected behavior
A global email address to be set or each customer to have their own ACME Account

SolidCP Info

• SolidCP Version: v1.4.7

Additional context
https://solidcp.com/forum/question/bug-letsencrypt-sends-reminders-to-wrong-customer/

Describe the bug
When trying to backup a database to a folder (Either one time or scheduled) it will error with

To Reproduce
Steps to reproduce the behavior:

1. Go to MsSQL Database
2. Select backup database
3. Select to Copy to Folder

Expected behavior
SQL backup to complete to the folder

Screenshots

• See above

SolidCP Info

• SolidCP Version: 1.4.7

Additional context
https://solidcp.com/forum/question/error-executing-backup-task-value-cannot-be-null-parameter-name-path1/

Is your feature request related to a problem? Please describe.
When a CA like Let's Encrypt is forced to revoke certificate's it is not possible to do this currently.

Describe the solution you'd like
A button to allow for the certificate to be force renewed.

Describe alternatives you've considered
There could be a way to remove and recreate the certificates for each website.

Additional context
LE Source: https://letsencrypt.org/caaproblem/

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Description:
Allow user to supply their own key for Windows installation in case they want to install specific keys that's not activated by AVMA.

Ideas:
Currently, SolidCP already had params in unattended files to change timezone, computer name, ... We can create a field in OStemplate such as: AVMA/VL key, if it's not provided, we will prompt user to supply their own license key on deployment/reinstallation.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

It appears that the Scheduler Action "Execute System Command" has a problem with one of the required parameters, "Server Name". Anything typed into this field doesn't appear to work, throwing an error into the Audit Log. I've attempted using the Server Name defined in the Servers list within the Configurations tab (with and without spaces), I attempted to use the server's machine name, and I attempted to use the server's IP Address.

Steps to reproduce the behavior:

1. Go to 'Scheduled Tasks' within one of your defined websites
2. Click on 'Add Scheduled Task'
3. Fill in the 'Task Name' and select 'Execute System Command' from the 'Task Type' dropdown list
4. Fill in the rest of the 'Task Parameters' (Server Name, Exe Path, Exe Parameters)
5. Save the task
6. Run the task and review the error in the Audit Log

Expected behavior
I expect the specified executable/batch-file is run on the specified server.

• SolidCP Version: 1.4.7

• OS: Windows 10

• Browser Chrome

• Version 91.0.4472.77

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Describe the bug
If a reseller has an domain limit assigned to their hosting plan this is not then enforced against customers

To Reproduce
Steps to reproduce the behavior:

1. Create hosting plan with 1 domain
2. Create Reseller with above plan
3. Create customers for the above reseller wih plans to exceed the reseller hosting plan limit

Expected behavior
The customer to error that they have exceeded quote for domain.

Screenshots

SolidCP Info

• SolidCP Version: v1.4.4

Additional context
https://solidcp.com/forum/question/reseller-can-create-more-than-allowed-number-of-domains/

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Describe the bug
When we remove a hosting space with items, we can get a deadlock transaction, where items are deleted on the server side, but Enterprise does not know about it and will still store this information in the DB..

To Reproduce
There is no 100% way to reproduce it, just happens once per some years.

SolidCP Info

• SolidCP Version: all versions (latest 1.4.7)

Appears

• PackageAsyncWorker.DeletePackagesServiceItems() (fixed in 1.4.8)
• SolidCP.EnterpriseServer.TaskManager.CompleteTask() (possible fixed in 1.5.0 with SQL indexes)
• EnterpriseServer.ObjectUtils.FillCollectionFromDataReader() (need more details after 1.5.0)
• Somewhere else?

Logs

Process ID: 8068

Exception: System.Data.SqlClient.SqlException

Message: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at SolidCP.EnterpriseServer.PackageAsyncWorker.DeletePackagesServiceItems()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Data.SqlClient.SqlException
   at System.Data.SqlClient.SqlConnection.OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1<System.Action>)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(System.Data.SqlClient.TdsParserStateObject, Boolean, Boolean)
   at System.Data.SqlClient.TdsParser.TryRun(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject, Boolean ByRef)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.RunBehavior, System.String, Boolean, Boolean, Boolean)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, Boolean, Int32, System.Threading.Tasks.Task ByRef, Boolean, Boolean, System.Data.SqlClient.SqlDataReader, Boolean)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String, System.Threading.Tasks.TaskCompletionSource`1<System.Object>, Int32, System.Threading.Tasks.Task ByRef, Boolean ByRef, Boolean, Boolean)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(System.Threading.Tasks.TaskCompletionSource`1<System.Object>, System.String, Boolean, Int32, Boolean ByRef, Boolean, Boolean)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(System.Data.SqlClient.SqlConnection, System.Data.CommandType, System.String, System.Data.SqlClient.SqlParameter[])
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(System.String, System.Data.CommandType, System.String, System.Data.SqlClient.SqlParameter[])
   at SolidCP.EnterpriseServer.PackageAsyncWorker.DeletePackagesServiceItems()
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
   at System.Threading.ThreadHelper.ThreadStart()

A process serving application pool 'SolidCP Enterprise Server Pool' suffered a fatal communication error with the Windows Process Activation Service. The process id was '8068'. The data field contains the error number.

Faulting application name: w3wp.exe, version: 10.0.14393.0, time stamp: 0x57899b8a
Faulting module name: KERNELBASE.dll, version: 10.0.14393.3986, time stamp: 0x5f77fd5b
Exception code: 0xe0434352
Fault offset: 0x0000000000034f38
Faulting process id: 0x1f84
Faulting application start time: 0x01d6f50d45397058
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report Id: 75fb10e3-e397-48f9-b903-6978d52a2789
Faulting package full name: 
Faulting package-relative application ID: 

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Describe the bug
When creating a TXT record such as "v=spf1 redirect=Somewhere.net" in SolidCP it is applied to SimpleDNS as multiple strings ("v=spf1" "redirect=Somewhere.net")

To Reproduce
Steps to reproduce the behavior:

1. Go to Users domain
2. Edit DNS
3. Add record with data: v=spf1 redirect=Somewhere.net

Expected behavior
To be created as one string.

SolidCP Info

• SolidCP Version: 1.4.7

Additional context

Workaround: Create record with "" around the data.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Is your feature request related to a problem? Please describe.
In some countries an different date/time format is used and currently only the US format is displayed.

Describe the solution you'd like
Each user profile should be able to set their locale and date/time format. There should also be a policy for the default format

Describe alternatives you've considered
None

Additional context
https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

Forum post: https://solidcp.com/forum/question/datetime-locale/

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.