Activities of "portx-dev"

I hope this message finds you well.

We are currently using your ABP Commercial framework for our project, and we are facing a challenge related to database migrations. Specifically, we need to utilize the ALGORITHM=INSTANT option in MySQL for certain ALTER TABLE operations to avoid database locks and ensure zero-downtime deployments. However, we have noticed that the current migration framework does not support this option.

We would like to inquire if there is any possibility to extend or customize the migration framework to accommodate the use of ALGORITHM=INSTANT. If there is an existing way to achieve this, we would greatly appreciate any guidance or documentation you could provide.

Thank you in advance for your assistance. We look forward to your advice on how best to proceed.

Best regards,

• ABP Framework version: v8.2
• UI Type: Angular
• Database System: EF Core (MySQL.)

In Angular UI, at identity users screen, modal add/edit user. When username contains non-alphabetic characters, the validate message is displaying incorrectly even though the server returns the correct error. Please help me. Is there any way to fix this problem?

• ABP Framework version: v8.0.3
• UI Type: Angular
• Database System: EF Core MySQL
• Tiered (for MVC) or Auth Server Separated (for Angular): yes
• Exception message and full stack trace:
• Steps to reproduce the issue:

I would like to specify the IP address that can be used to log in for each tenant. Is this possible with ABP Commercial's functions?

ABP Framework version: Commercial 7.4 UI type: Angular DB provider: EF Core

Hi, we have redis commands that timeout. I asked that problem in StackExchange/StackExchange.Redis, and got the answer.

It looks like you're experiencing thread exhaustion (WORKER: (Busy=38,Free=32729,Min=8,Max=32767)), likely from long-running synchronous operations. I can't say about the rest of your application, but you for sure have some synchronous Redis calls (sync-ops: 7262, async-ops: 28127). You'll want to do all those things async to have much better utilization of the thread pool and less blocking/stalls as a result of thread exhaustion (waiting for a new one to become available).

reference: https://github.com/StackExchange/StackExchange.Redis/issues/2558

According to the analysis, what we can do for solving timeout issue in ABP Framework?

ABP Framework version: Commercial 7.2 UI type: Angular DB provider: EF Core

Hi,

We found some redis commands are very slow(1~53s), and fails in test environment. We use amazon elasticache(redis) for our test environment.

slow command examples are below.

HMGET t:3a0c1d64-4d96-0ab6-9c31-0a332a2b8a8e,c:Volo.Abp.LanguageManagement.Texts,k:PortX:PortX_ja HMGET t:3a0c1d64-4d96-0ab6-9c31-0a332a2b8a8e,c:Volo.Abp.LanguageManagement.Texts,k:PortX:AbpValidation_en HMGET c:Volo.Saas.Tenants.Tenant,k:PortX:i:3a0c1d64-4d96-0ab6-9c31-0a332a2b8a8e,n:null EXPIRE t:3a0c1d64-4d96-0ab6-9c31-0a332a2b8a8e,c:Volo.Abp.LanguageManagement.Texts,k:PortX:AbpValidation_en EXPIRE t:3a0c1d64-4d96-0ab6-9c31-0a332a2b8a8e,c:Volo.Abp.LanguageManagement.Texts,k:PortX:AbpValidation_ja EXPIRE c:Volo.Saas.Tenants.Tenant,k:PortX:i:3a0c1d64-4d96-0ab6-9c31-0a332a2b8a8e,n:null HMGET t:3a0c1d64-4d96-0ab6-9c31-0a332a2b8a8e,c:Volo.Abp.PermissionManagement.PermissionGrant,k:PortX:pn:R,pk:admin,n:PortX.RegularProjectRequestHistories.Create

We had a lot of time to investigate the reason with Datadog APM and redis insight, but we've not found the exact reason.

[investigation result]

• the most portion of the commands are fast(12.81ms by 99 percentile). few commands are very slow(1~53s).
• server resource is enough (cpu/memory utilization is under 40%)
• redis resource is enough (cpu/memory utilization is under 40%)
• values returned by slow commands are not so large.
• we don't customize framework code which execute redis commands.
• we found the value of the key t:*:Volo.Abp.LanguageManagement.Texts,k:PortX:PortX_ja is almost empty: { "dictionary": {} }

With these slow commands, we couldn't meet our customers needs.

We doubt

• Amazon Elasticache(redis) have bad compatibility with ABP framework?
• We use Amazon Elasticache(redis) with default parameters. There is room for customization?
• Should we customize some configuration in ABP framework?
• We mis config some setting?

ABP Framework version: Commercial 7.2 UI type: Angular DB provider: EF Core

Is there any document about authorization or session management in abp commercial? If abp commercial application extends authorization function from asp.net core, I want to know the document about it.

my goal

• understand how session is managed in abp commercial.
• how to access backend api with session infos.

background

• Now, I'm setting up OWASP ZAP client to test abp application.
• I want OWASP ZAP client to login abp application itself before penetration test.
• I have to set OWASP ZAP configuration, relating to authorization(ex. authentication method, session management)

Thanks for your support.

ABP Framework version: Commercial 7.2

UI type: Angular

DB provider: EF Core

I plan to embed bi tools like power bi and QuickSight inside ABP Commercial. Does ABP Commercial have a BI library/tool that works well with ABP Commercial? Or do you have a recommended BI library/tool?

ABP Framework version: Commercial 7.2

UI type: Angular

DB provider: EF Core

I want to clone tenant

How would you go about developing such functionality?

Also, if it is difficult to duplicate the tenant, I would like to create a function to export the data of the copy source and import the data to the tenant of the copy destination. Is this possible?

ABP Framework version: Commercial 7.2

UI type: Angular

DB provider: EF Core

I am developing a web application with (UI type**: Angular) in ABP. There is a requirement to call server-side APIs to obtain and display necessary information (for example, the unit name of an organization, etc.) on a specific web page without login. Is there any best practice for achieving this requirement while maintaining security?

• ABP Framework version: Commercial 7.2
• UI type: Angular
• DB provider: EF Core

Hi, I saw that the following issue of TimeZone Setting feature had been merged to 7.4-preview version of abp opensource side . Could you tell when this TimeZone Setting feature be able to use in ABP commercial?

https://github.com/abpframework/abp/issues/16628