Activités de "piseth"

https://zoom.us/j/95815890202?pwd=VnZaVXl6MTM2OWV4M2czcVdVbzlQUT09

It shows Invalid Meeting ID.

By the way, my problem is similar to this ticket but they use Angular. https://support.abp.io/QA/Questions/1179/Cannot-login-through-api

My log is like the following. Can you help? 2022-03-17 10:33:38.696 +03:00 [INF] Antiforgery token validation failed. The required antiforgery cookie ".AspNetCore.Antiforgery.oLLsTIB8lzc" is not present. Microsoft.AspNetCore.Antiforgery.AntiforgeryValidationException: The required antiforgery cookie ".AspNetCore.Antiforgery.oLLsTIB8lzc" is not present. at Microsoft.AspNetCore.Antiforgery.DefaultAntiforgery.ValidateRequestAsync(HttpContext httpContext) at Microsoft.AspNetCore.Mvc.ViewFeatures.Filters.ValidateAntiforgeryTokenAuthorizationFilter.OnAuthorizationAsync(AuthorizationFilterContext context)

https://docs.microsoft.com/en-us/aspnet/core/tutorials/publish-to-iis?view=aspnetcore-6.0&tabs=netcore-cli

If my site has error, why i can run it with both Debug and Release on VS 2022? Certificate error is shown because I use https and i don't have a trusted certificate. If i use normal http => it won't show.

In log, why does it show: 1/ PermissionRequirement: AbpAccount.SettingManagement? 2/ System.InvalidOperationException: An invalid request URI was provided. Either the request URI must be an absolute URI or BaseAddress must be set.

Do i have to configure something in my project before publishing on the server?

hi

can i copy manually the folder libs and paste in bin/Release/net6.0/publish/wwwroot/libs ?

You can try this. Copy wwwrrot to the IIS website directory.

Hi,

I follow your instruction.

1/ i publish my web again in VS 2022 2/ I manually copy libs folder and paste it in wwwroot 3/ I sftp to my server and put it under c:\inetpub\wwwroot\qoe 4/ i restart my site in IIS manager

I can browse it but it looks not fully correct. My logo is not shown and the theme is not fully shown properly. After I login, it brings me to show Error 400 - httpStatusCode=400. Please see the attached images.

The following is the some logs:

=================================================================== System.InvalidOperationException: An invalid request URI was provided. Either the request URI must be an absolute URI or BaseAddress must be set. at System.Net.Http.HttpClient.PrepareRequestMessage(HttpRequestMessage request) at System.Net.Http.HttpClient.CheckRequestBeforeSend(HttpRequestMessage request) at System.Net.Http.HttpClient.SendAsync(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationToken cancellationToken) at System.Net.Http.HttpClient.GetAsync(Uri requestUri) at HealthChecks.UI.Core.HostedService.HealthCheckReportCollector.GetHealthReport(HealthCheckConfiguration configuration) 2022-03-16 12:19:21.321 +03:00 [INF] Notification is sent on same window time. 2022-03-16 12:19:22.220 +03:00 [INF] > Minified /libs/devextreme/js/dx.all.js (4951064 bytes -> 4898570 bytes) 2022-03-16 12:19:22.253 +03:00 [INF] > Minified /libs/devextreme/js/dx.aspnet.mvc.js (8857 bytes -> 3525 bytes) 2022-03-16 12:19:22.258 +03:00 [INF] > Minified /libs/devextreme/js/dx.aspnet.data.js (13456 bytes -> 4550 bytes) 2022-03-16 12:19:22.287 +03:00 [INF] Bundled __bundles/Asiacell.Web.Bundling.DevExtremeScriptContributor.40C91FA5677011A0B991F380F3039C38.js (8175615 bytes) 2022-03-16 12:19:22.681 +03:00 [INF] Authorization failed. These requirements were not met: PermissionRequirement: SettingManagement.Emailing 2022-03-16 12:19:22.683 +03:00 [INF] Authorization failed. These requirements were not met: PermissionRequirement: AbpIdentity.SettingManagement 2022-03-16 12:19:22.689 +03:00 [INF] Authorization failed. These requirements were not met: PermissionRequirement: LeptonThemeManagement.Settings 2022-03-16 12:19:22.691 +03:00 [INF] Authorization failed. These requirements were not met: PermissionRequirement: AbpAccount.SettingManagement 2022-03-16 12:19:22.692 +03:00 [INF] Authorization failed. These requirements were not met:

......

2022-03-16 12:22:01.511 +03:00 [ERR] GetHealthReport threw an exception when trying to get report from /health-status configured with name Asiacell Health Status. System.InvalidOperationException: An invalid request URI was provided. Either the request URI must be an absolute URI or BaseAddress must be set. at System.Net.Http.HttpClient.PrepareRequestMessage(HttpRequestMessage request) at System.Net.Http.HttpClient.CheckRequestBeforeSend(HttpRequestMessage request) at System.Net.Http.HttpClient.SendAsync(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationToken cancellationToken) at System.Net.Http.HttpClient.GetAsync(Uri requestUri) at HealthChecks.UI.Core.HostedService.HealthCheckReportCollector.GetHealthReport(HealthCheckConfiguration configuration)

2022-03-16 12:20:02.061 +03:00 [INF] Request starting HTTP/2 GET https://10.21.161.202:44346/__bundles/Asiacell.Web.Bundling.DevExtremeScriptContributor.40C91FA5677011A0B991F380F3039C38.js?_v=637830191622998915 - - 2022-03-16 12:20:02.061 +03:00 [INF] The file /__bundles/Asiacell.Web.Bundling.DevExtremeScriptContributor.40C91FA5677011A0B991F380F3039C38.js was not modified 2022-03-16 12:20:02.061 +03:00 [INF] Request finished HTTP/2 GET https://10.21.161.202:44346/__bundles/Asiacell.Web.Bundling.DevExtremeScriptContributor.40C91FA5677011A0B991F380F3039C38.js?_v=637830191622998915 - - - 304 - application/javascript 0.4689ms 2022-03-16 12:20:02.062 +03:00 [INF] Request starting HTTP/2 GET https://10.21.161.202:44346/__bundles/Lepton.Global.BF1167448374F84512EABF50AAAB3042.js?_v=637830191639694672 - - 2022-03-16 12:20:02.062 +03:00 [INF] The file /__bundles/Lepton.Global.BF1167448374F84512EABF50AAAB3042.js was not modified 2022-03-16 12:20:02.062 +03:00 [INF] Request finished HTTP/2 GET https://10.21.161.202:44346/__bundles/Lepton.Global.BF1167448374F84512EABF50AAAB3042.js?_v=637830191639694672 - - - 304 - application/javascript 0.4423ms

CopyToPublishDirectory

I follow you by adding in MyProject.Web.csproj and i rebuild my solution but i get the following errors:

Did you publish the wwwroot directory? To restore the wwwroot directory using abp install-libs

On my local laptop, i run abp install-libs and all required libraries are copied to MyProject.Web/wwwroot/libs. However abp libraries and some of other libraries are not copied to bin/Release/net6.0/publish/wwwroot/libs, after I published from Visual Studio Community 2022 (64-bit)

In this case, can i copy manually the folder libs and paste in bin/Release/net6.0/publish/wwwroot/libs ?

I publish the website on my local PC. Then I copy the publish folder to paste in wwwroot in my server. my server has no Internet connection. **I will try run abp install-libs before publish it. ** By the way, currently i use the default appsettings.json which "App": { "SelfUrl":"https://localhost:44346" }, "AuthServer": { "Authority":"https://localhost:44346", "RequireHttpsMetadata":"false" },...

On my server, i want to browse http://10.10.0.1 or https://10.10.0.1 => Should I change my default appsettings.json?

Thanks

• UI type: MVC
• DB provider: EF Core
• Tiered (MVC) or Identity Server Separated (Angular): yes / no
• Exception message and stack trace:
• Steps to reproduce the issue:"

I am trying to deploy my abp applications on IIS. On IIS Manager, when I browse it as http://mywebsite.com or https://mywebsite.com:44346 , i get the following errors:

**1/ if I input Host Name in "Sites Bindings" HTTP Error 500.30 - ASP.NET Core app failed to start

2/ I do not input any host name => http://10.x.x.202/ The Website cannot display the page Most likely causes:

• The website is under maintenance
• The Website has a programming error.**

Please provide your email address, then i will send you the log.txt file to you

*2022-03-12 16:07:31.327 +03:00 [INF] Request starting HTTP/1.1 GET http://10.21.161.202/ - - 2022-03-12 16:07:31.651 +03:00 [ERR] GetHealthReport threw an exception when trying to get report from /health-status configured with name Asiacell Health Status. System.InvalidOperationException: An invalid request URI was provided. Either the request URI must be an absolute URI or BaseAddress must be set.

AUDIT LOG: [500: GET ] /Error

• UserName - UserId : -
• ClientIpAddress : 10.21.161.202
• ExecutionDuration : 16
• Actions:
  • Volo.Abp.AspNetCore.Mvc.UI.Theme.Shared.Controllers.ErrorController.Index (2 ms.) {}
• Exceptions:
  • Could not find file '/libs/abp/core/abp.css' Volo.Abp.AbpException: Could not find file '/libs/abp/core/abp.css' at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundlerBase.GetFileInfo(IBundlerContext context, String file) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundlerBase.GetAndMinifyFileContent(IBundlerContext context, String fileName) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundlerBase.GetFileContentConsideringMinification(IBundlerContext context, String fileName) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundlerBase.Bundle(IBundlerContext context) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundleManager.<>c__DisplayClass16_0.<GetBundleFilesAsync>b__0() at System.Collections.Generic.AbpDictionaryExtensions.<>c__DisplayClass7_02.<GetOrAdd>b__0(TKey k) at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory) at System.Collections.Generic.AbpDictionaryExtensions.GetOrAdd[TKey,TValue](ConcurrentDictionary2 dictionary, TKey key, Func1 factory) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundleCache.GetOrAdd(String bundleName, Func1 factory) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundleManager.GetBundleFilesAsync(BundleConfigurationCollection bundles, String bundleName, IBundler bundler) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.BundleManager.GetStyleBundleFilesAsync(String bundleName) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.TagHelpers.AbpTagHelperStyleService.GetBundleFilesAsync(String bundleName) at Volo.Abp.AspNetCore.Mvc.UI.Bundling.TagHelpers.AbpTagHelperResourceService.ProcessAsync(ViewContext viewContext, TagHelper tagHelper, TagHelperContext context, TagHelperOutput output, List`1 bundleItems, String bundleName)

at System.Net.Http.HttpClient.PrepareRequestMessage(HttpRequestMessage request) at System.Net.Http.HttpClient.CheckRequestBeforeSend(HttpRequestMessage request) at System.Net.Http.HttpClient.SendAsync(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationToken cancellationToken) at System.Net.Http.HttpClient.GetAsync(Uri requestUri) at HealthChecks.UI.Core.HostedService.HealthCheckReportCollector.GetHealthReport(HealthCheckConfiguration configuration) 2022-03-12 16:07:31.906 +03:00 [INF] Application started. Press Ctrl+C to shut down.*

Please help support me to deploy it

Is it correct?

public async Task<List<Student>> GetStudentAsync(CancellationToken cancellationToken = default)
{
         var name = new OracleParameter("Name", OracleDbType.Varchar2, ParameterDirection.Output);
         var address = new OracleParameter("Address", OracleDbType.Varchar2, ParameterDirection.Output);
        
       using (var command = CreateCommand("BEGIN GetStudent(:Name, :Address,);END;", CommandType.Text, new OracleParameter[] { name, address }))
            {
                return ((List<Student>)await command.ExecuteScalarAsync(cancellationToken));
            }
 }

private DbCommand CreateCommand(string commandText, CommandType commandType, params OracleParameter[] parameters)
{
    var command = DbContext.Database.GetDbConnection().CreateCommand();

    command.CommandText = commandText;
    command.CommandType = commandType;
    command.Transaction = DbContext.Database.CurrentTransaction?.GetDbTransaction();

    foreach (var parameter in parameters)
    {
        command.Parameters.Add(parameter);
    }

    return command;
}

hi

I think you just need to change the syntax of the SQL server to the oracle, the principle is the same.

https://github.com/abpframework/abp-samples/blob/master/StoredProcedureDemo/src/StoredProcedureDemo.EntityFrameworkCore/EntityFrameworkCore/Users/AppUserRepository.cs#L27-L40

Thank for your reply. please share me a sample function to do that. I don't know that is why i requested you. Honestly, I will copy and paste into my application.

Hello,

My Abp is MVC Razor with Oracle. I'd like to know how to work with Oracle Procedure?

The following sample is working with Store Procedure, but it is for SQL Server. https://github.com/abpframework/abp-samples/tree/master/StoredProcedureDemo

How can i make my project work with Oracle procedure?

Thanks in advance