ASP.NET

Re: Upgrading from .Net Core 2.2 to 3.1, SSL and Docker .net core images

17-Jul-20 11:31

Its my computer.
the browsers keep picking up an expired certificate when I run VS 2017 and 2019
I updated my localhost.pfx in my project that I use with Kestrel in a docker container.
Oh it's been years since I had to deal with this. Just happy coding.

If it ain't broke don't fix it
Discover my world at jkirkerx.com

jkirkerx17-Jul-20 11:46

Re: Upgrading from .Net Core 2.2 to 3.1, SSL and Docker .net core images

17-Jul-20 11:46

got it to work finally
I added this to appSettings.json
So now it uses the new pfx file that is not expired.
I still wonder where the other file was coming from, perhaps somewhere in app data.
And I didn't really program Kestrel to run in debug under the project name. Just for running in a Docker container.
hmm....

"Kestrel": {
  "Certificates": {
    "Default": {
      "Path": "localhost.pfx",
      "Password": ""
    }
  }
}

If it ain't broke don't fix it
Discover my world at jkirkerx.com

jkirkerx17-Jul-20 12:36

Generating unique user ID

17-Jul-20 12:36

Now the Docker container builds, didn't have to change the images
Had to do some adjustments on the startup.cs, and move some things around.
So far so good.

If it ain't broke don't fix it
Discover my world at jkirkerx.com

Otekpo Emmanuel7-Jul-20 7:29

Otekpo Emmanuel

7-Jul-20 7:29

Good evening everyone, I want to know the best way to generate unique user ID even when number of registered users are more than two million.

The current way am using to achieve this is by initiating an ID i.e 2083928937 for instance, then checking Database if this ID exists. If it does, then I will increment it by 1 then make a search again for the incremented value until no match is found and the unfound ID will be used.

But am having the feeling that this will cause database issue or even slow down the site as the code have to iterate several times when the site start to have more users.

So, please what is the best way to achieve this?

www.emmason247.com.ng

Richard Deeming7-Jul-20 7:47

7-Jul-20 7:47

Use a Guid / UUID. That way, you'll also mitigate any IDOR[^] issues at the same time.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Otekpo Emmanuel8-Jul-20 3:06

Otekpo Emmanuel

8-Jul-20 3:06

Ok thanks. But is the method am using a good technique?

www.emmason247.com.ng

Richard Deeming8-Jul-20 3:42

8-Jul-20 3:42

It depends on how you're generating the initial ID to check.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Mycroft Holmes8-Jul-20 12:46

Mycroft Holmes

8-Jul-20 12:46

No it is not a good method. You could take advantage of the identity/autoincrement field in the database or use the GUID/UUID method recommended.

Currently you create the ID and then check the DB, the above methods would eliminate the check requirement. You should also have a unique index on the id field in the database.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

David Mujica10-Jul-20 2:47

David Mujica

10-Jul-20 2:47

Consider implementing a Sequence table like:

SequenceName, NextID

The table will consist of a single row such as UserID, 2083928937

This way you immediately know what the next UserID is.

Within a transaction, create the User, then update the sequence table by 1.

Java | [Coffee]

jkirkerx13-Jul-20 11:25

13-Jul-20 11:25

I up vote this method Smile | :)

I do it this way, in which I generate order numbers, where I have a sequence table.
In MongoDB, it can generate a unique Id, based on the server, date and time which is pretty cool.

In the past, I used SQL servers Unique ID with auto increments, but that backfired on me several times.
I forget, but auto increment forgot the last number it was on and added a 1000 to the next number.

I suppose if there was a GUID generator app that worked like Mongo's ObjectId, I would move towards that.

If it ain't broke don't fix it
Discover my world at jkirkerx.com

DerekT-P17-Jul-20 10:44

DerekT-P

17-Jul-20 10:44

Sorry, but I downvoted this - for a number of reasons:
* It requires an additional two physical i/o calls - to get the latest value, and to update it afterwards
* It requires that you have a READ lock on the sequence table; to avoid duplicates, you must read the value, insert the new record, and update it all within a transaction and without allowing any other process to read the value. At best this requires an additional lock, but at worst - if poorly coded - can leave that lock in place for a prolonged period and cause a major performance bottleneck
* It creates sequential user ids; presumably you have secure password / two-factor authentication, but by using sequential numeric ids you're making it very easy for hackers as they can just generate sequential hacks on the id

If sequential IDs isn't an issue (and it may not be in all cases) the simplest thing is to use an auto-increment field and return the new ID from the insert statement. Any decent DBMS will keep track without issue. In the event of a transaction rollback there may be a "missing" ID but that shouldn't (be allowed) to cause your application a problem.

A method I use when generating IDs is to use a GUID value (or sometimes a truncated portion of a GUID) and simply INSERT into the table. With a unique key on the ID, then in the vanishingly small likelihood of a duplicate, the INSERT will fail. Catch the "duplicate record" exception, replace the ID with a new GUID and insert again. The performance hit from that is miniscule as it will probably never ever happen.

Message Removed

6-Jul-20 23:46

umeshamin

6-Jul-20 23:46

Message Removed

modified 16-Jul-20 8:55am.

Message Removed

13-Jul-20 11:39

13-Jul-20 11:39

Message Removed

modified 16-Jul-20 8:55am.

pls help

Member 148797912-Jul-20 21:44

Member 14879791

2-Jul-20 21:44

Server Error in '/' Application.
Runtime Error
Description: An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated.

Richard MacCutchan2-Jul-20 21:48

Richard MacCutchan

2-Jul-20 21:48

If you want help then you need to provide proper detailed information. No one here can guess what your code is doing.

ZurdoDev6-Jul-20 8:10

ZurdoDev

6-Jul-20 8:10

Richard MacCutchan wrote:
No one here can guess what your code is doing.

To be fair, I could guess. Big Grin | :-D

Social Media - A platform that makes it easier for the crazies to find each other.

Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.

David Mujica6-Jul-20 7:27

David Mujica

6-Jul-20 7:27

If you run your application on the WebServer where it is hosted, you may get more detail about the error without having to do anything else.

Try to RDC (Remote Desktop Connection) to that server.
Java | [Coffee]

Angular service error http 400 using .Net core api to accept json, escaped quotes crashing api

DerekT-P7-Jul-20 2:18

DerekT-P

7-Jul-20 2:18

No problem; there's a simple and guaranteed solution to this.
Step 1: Turn your computer off.

That's it. You will not see this error message again.

You're welcome. Big Grin | :-D

jkirkerx29-Jun-20 12:48

Re: Angular service error http 400 using .Net core api to accept json, escaped quotes crashing api

29-Jun-20 12:48

I spent all day on this. It just started happening recently.
So I package a model in Angular, and create a body of JSON using JSON.stringify(model)
Then package it all up and send it as a promise. I just noticed that the JSON quotes are escaped out with a slash, and it crashes the API. If I take the slashes out, the API accepts the JSON.

I'm not sure what to make of this, and if I should fix the client side or work on the server side with this.
I put the replace(/\/g, "") in below to test the theory that it's the slashes crashing the API. Now the API works, but I can't see this as a permanent fix.

validateTokenAsPromise(signIn: SignIn): Promise<SignIn> {
    const authUrl = this.baseUrl + "api/auth/AuthenticateAccount";
    const toSignIn = JSON.stringify(signIn).replace(/\\/g, "");    
    const httpOptions = {
      headers: new HttpHeaders({
        "Content-Type": "application/json",
        "Accept": "application/json"
      })
    };
    return this.http.post<SignIn>(authUrl, toSignIn, httpOptions).toPromise();
  }

I send it to a .Net Core controller api, and the api rejects the call, because of the data in the body.
The data has the quotes escaped out.

[Produces("application/json")]
[Route("api/[controller]")]
[ApiController]

[HttpPost("AuthenticateAccount")]
public async Task<SignIn> AuthenticateAccount([FromBody] SignIn authParam)
{

Sending this data to the API, normally it just sends raw, but I wrote a special service to handle Google SignIn and Googles gapi and gapi.auth2. I can't see how this special API" would encode the JSON.

{\"Id\":\"114251204162343478403\",\"FirstName\":\"John\",\"LastName\":\"Smith\",\"AccountName\":\"jsmith@hackme.com\",\"Password\":\"2H3HY4ZwE8Sb5Ajz\",\"Token\":\"eyJhbGciOiJIUsdadasdasd1lIjoiSmltIiwiZW1haWwiOiJqa2lya2VyeEBnbWFpbC5jb20iLCJuYmYiOjE1OTM0NjkwMDYsImV4cCI6MTU5MzY0MTgwNiwiaWF0IjoxNTkzNDY5MDA2LCJpc3MiOiJodHRwczovL2xvY2FsaG9zdDo1MDAxLyIsImF1ZCI6asdsadasdasdasdwMS9hcGkifQ.WdpYg8qDIUtIT4uobyAWVQ01k9iNYJ6wPpa6FIXm3Yg\",\"Role\":\"Customer\",\"ExpiresAt\":\"2020-06-29T23:26:03.812Z\",\"IdpId\":\"gapi\",\"RememberMe\":true,\"Avatar\":{\"Url\":\"https://lh3.googleusercontent.com/a-/AOasdasdasdGJB_aUO-asdasdasdg-ob=s96-c\"}}

Don't get excited about the data, it's fake.

If it ain't broke don't fix it
Discover my world at jkirkerx.com

Richard Deeming29-Jun-20 23:42

Re: Angular service error http 400 using .Net core api to accept json, escaped quotes crashing api

29-Jun-20 23:42

Try removing the JSON.stringify call. I suspect the post method is encoding it again, so it's sending a string rather than a SignIn object.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

jkirkerx30-Jun-20 6:06

30-Jun-20 6:06

Your spot on!
That was the issue. Double stringify.

But after thinking about it last night, and realizing the double stringify, I think I'll keep the replace function. So I put it back to my example. After testing without, seems to be more reliable with it. Weird, I create the model before I send the post. And I'm leaving the .Net side as is.

signIn(): Observable<boolean> {

    let subject = new Subject<boolean>();
    this.auth2.signIn().then(user => {
      const profile = user.getBasicProfile(),
        auth = user.getAuthResponse(),
        token = localStorage.getItem("authToken");

      let gU = new SignIn();
      gU.Id = profile.getId();
      gU.FirstName = profile.getGivenName();
      gU.LastName = profile.getFamilyName();
      gU.AccountName = profile.getEmail();
      gU.Password = "2LsdFDdsfb5Ejr";
      gU.Token = token !== null ? token : "";
      gU.Role = "Account";
      gU.ExpiresAt = new Date(auth.expires_at);
      gU.IdpId = "google";
      gU.RememberMe = true;
      gU.Avatar = new Avatar();
      gU.Avatar.Url = profile.getImageUrl();

      this.validateTokenAsPromise(gU)        
        .then(user => {
          this.zone.run(() => {            
          if (user) {
            localStorage.setItem("Account", JSON.stringify(user, null, "\t"));
            if (user.Token) {
              localStorage.setItem("authToken", user.Token);
            }            
            this.user$.next(user);
            this.isLoggedIn$.next(true);
            this.auth2SignedIn.emit(true);
            subject.next(true);
          } else {
            this.isLoggedIn$.next(false);
            this.auth2SignedIn.emit(false);
            subject.next(false);
          }
        });
      },
      (err) => {
        console.error("GAuth2 Service Error", err);
        this.isLoggedIn$.next(false);
        this.auth2SignedIn.emit(false);
        subject.next(false);
      });
    });
    return subject.asObservable();
  }

If it ain't broke don't fix it
Discover my world at jkirkerx.com

error server

Member 1265427722-Jun-20 2:37

Member 12654277

22-Jun-20 2:37

hello! I have a problem when I want to retrieve data in my application I got this error :

erreur du serveur dans l'application '/'. opération non valide. la connexion est fermée

in asp.net MVC

Re: error server

ZurdoDev22-Jun-20 2:44

ZurdoDev

22-Jun-20 2:44

Something is setup wrong. Not sure what you want us to do.

Social Media - A platform that makes it easier for the crazies to find each other.

Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.

Re: error server

Richard Deeming22-Jun-20 5:19