Activities of "maharatha"

Any updates?

We use Pomona for MySQl.We have a requirement to keep the collation to utf8mb4_unicode_ci. So we went ahead and used the dataannotation to make sure all columns have the same unicode.

Here are the issues :

1. We are altering the database to make utf8mb4_unicode_ci in our initial migration : migrationBuilder.Sql("alter database character set utf8mb4 collate utf8mb4_unicode_ci"); This only makes the non varchar column to automatically use the collation as utf8mb4_unicode_cikai_ci. So in order to change the collation of these tables either i have to change the initial migration which i am not a big fan of it or go and change the entity with override.

Can you suggest what would be a good approach to solve this issue ?

Done

Can you send me an email to share the link to the project , i have already shared it with Elsa to look into it ?

This is what is happening :

Elsa creates a MapperConfiguration and uses it to create an IMapper, which is registered with IoC. ABP also creates a MapperConfiguration and uses it to create an IMapper, which is also registered. Because the one from Elsa is registered first, anytime something resolves/injects IMapper, it receives the instance from Elsa, which does not contain any of the mapping configuration from ABP.

Any idea or suggestion you can think of ?

I am trying to integrate Elsa Dshboard to my project.

I was able to intergate the Migration but somehow getting the issue while integrating the Dashboard :

https://elsa-workflows.github.io/elsa-core/docs/guides-dashboard

ComponentNotFoundException: No component for supporting the service Elsa.Dashboard.Areas.Elsa.Controllers.HomeController was found Castle.MicroKernel.DefaultKernel.Castle.MicroKernel.IKernelInternal.Resolve(Type service, Arguments arguments, IReleasePolicy policy, bool ignoreParentContext) Castle.MicroKernel.DefaultKernel.Resolve(Type service, Arguments arguments)

Any help would be highly appreciated.

Also in the start up I added :

 // Add services used for the workflows runtime.
            services.AddElsa(elsa => elsa.AddEntityFrameworkStores<PostgreSqlContext>(options =>
                options.UseNpgsql(_appConfiguration.GetConnectionString("Default"))));
            services.AddHttpActivities(options => options.Bind(_appConfiguration.GetSection("Elsa:Http")));
            services.AddEmailActivities(options => options.Bind(_appConfiguration.GetSection("Elsa:Smtp")));
            services.AddTimerActivities(options => options.Bind(_appConfiguration.GetSection("Elsa:Timers")));

Error I get

AutoMapperMappingException: Missing type map configuration or unsupported mapping. Mapping types: User -> UserLoginInfoDto DOCUHOLD.EDRMS.Authorization.Users.User -> DOCUHOLD.EDRMS.Sessions.Dto.UserLoginInfoDto

What changes needs to be done so that the Social Login, OpenID and Federation can be set by the Tenants as well which will ovverride App specific values.

I would like the Tenants to set values at Settings.

I am also on the same boat. Any step by step help is appreciated

Yes I am using Hangfire.MySqlStorage.

MySql version is 8.0>

I am using .NetCore 3.1 and Angular AspnetZero project/

I was able to integrate hangfire partially, however when i click any link in Hangfire dashboard I get the below error "

An unhandled exception occurred while processing the request. MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank from Set, (select @rownum := 0) r where `Key' at line 3 MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in ResultSet.cs, line 49

MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank from Set, (select @rownum := 0) r where `Key' at line 3 MySql.Data.MySqlClient.MySqlDataReader.ActivateResultSet() in MySqlDataReader.cs, line 116

Am i doing something wrong ?