Categories
Mastering Development

IdentityServer4: “code challenge required” under hybrid flow

I have a MVC client accessing a web API protected by IDS4 server. It works perfectly when I use ResponseType = "code". But when I change it to ResponseType = "code id_token" (hybrid flow), I start to get this "Sorry, there was an error : invalid_request code challenge required" error. Here is my client configuration […]

Categories
Mastering Development

Custom Identity User class with one to many relationship creates extra column with Entity Framework Core

I’m using MS Identity along with Entity Framework Core on .NET 5, using a code first approach with a postgresql database. I am trying to extend the identity classes like this public class User : IdentityUser<int> { public ICollection<UserLogin> Logins { get; set; } } public class UserLogin : IdentityUserLogin<int> { public User User { […]

Categories
Database Development

mysql creating sort index making queries slow

We have a view table the query for the view is pasted below. The problem is that whenever we try to query items view our database start making sorting index which make the over all time of our response very slow. CREATE VIEW items_view AS SELECT item_detail.*, item.name, item.description, item.thumbnail_url, item.large_image_url, item.ios_url, item.android_url, item.vr_url, item.vr_updated_url, […]

Categories
Mastering Development

Field ‘id’ expected a number but got ‘Saurav’. ValueError at /recruiter/

I am a newbie to Django. I am trying to populate Candidate table which I earlier created to be used by Admin. But later requirement changed and I have to get it populated by user so I am using form. But I am getting this error , I think because in the table Candidate there […]

Categories
Mastering Development

Fill Many to Many field through API

I am trying to implement an API to add Agent. The Agent has Many To Many field, Role. I am using Django and Django Rest Framework. Here is the models : class Role(models.Model): code = models.CharField(max_length=50, primary_key=True) labe = models.CharField(max_length=50) def __str__(self): return ‘%s %s’ % (self.labe, self.code) class Agent(models.Model): firstName = models.CharField(max_length=60) lastName = […]

Categories
Database Development

Recursive CTE Multiple Levels

I have a table showing which roles recursively grant access to which resources within a database. For example: The Default_Role grants access to the App_Role, the App_Role grants access to the Security_Role, and the Security_Role grants access to three tables (customers, sales, users). So a member of the Default_Role is granted all of these, but […]

Categories
Mastering Development

cypress cucumber error Step implementation missing for: Given User checks out user with role TestRole and auth testAut

I’m getting cypress error Step implementation missing for: Given User checks out user with role TestRole and auth testAut. Feature File: Feature: Initial Test Scenario Outline: Test file to test feature files. Given User checks out user with role <role> and auth <aut> And User visit home page Then User click sign in link on […]

Categories
Database Development

Conditions with to pass as a input parameter values

I need help asap. I have created a SP which will parameter value, and will execute giving values as a Input. CREATE PROCEDURE [dbo].[sp_ApplicationUser] ( @ApplicationID_FK INT , @UserName VARCHAR(50), @Role VARCHAR(50) , @Access VARCHAR(50) ) AS BEGIN SET NOCOUNT ON INSERT INTO dbo.tblSec_ApplicationUser_Dev ( ApplicationID_FK, UserName, [Role], Access ) VALUES (@ApplicationID_FK, @UserName, @Role, @Access) […]

Categories
Ask Geographic Information System (GIS)

How to upgrade GeoServer to new version without loss of oldversion settings?

Every time GeoServer announce new version, I am going to upgrade my current version to new version, but unfortunately whenever I will upgrade to new version I’ll lost some important settings and configurations from previous version in new version, such as: users list,role,security, furthermore some extensions configuration for example: GeoFence users rules, web-cache settings,etc,However,I don’t […]

Categories
Ask Geographic Information System (GIS)

How to upgrade GeoServer to new version without loss of oldversion settings?

Every time GeoServer announce new version, I am going to upgrade my current version to new version, but unfortunately whenever I will upgrade to new version I’ll lost some important settings and configurations from previous version in new version, such as: users list,role,security, furthermore some extensions configuration for example: GeoFence users rules, web-cache settings,etc,However,I don’t […]