mORMot Open Source

I can't reproduce it - it work as expected at least on fpc 3.2.2.

edit: ... and mormot 2.3.10775

TRestClientDB use an hidden TRestServerDB; you could map to an external db for example this should work:

Props := TSQLDBZEOSConnectionProperties.Create(...);
Props.ThreadSafeConnection.Connect;
OrmMapExternal(aORMSQLModel, [TYourOrmMapped], Props);
ORMDB:= TRestClientDB.Create(aORMSQLModel, nil, ':memory:', TRestServerDB, False, StringToUtf8(aPassword));
TRestServerDB(ORMDB.Server).Server.CreateMissingTables(0, [itoNoAutoCreateUsers]);

On delphi? seem a potential tricky lifetime or reference issue.. variable V forces the compiler to go through its standard for variant assignment whereas in direct assignment to 'var result' might become invalid if docVariantArray is modified or freed prematurely.

Maybe try `SetVariantByValue(TDocVariantData(docVariantArray).Values[0], Result);`

I posted a small readme there, sorry I had to do it fast as I am at work, feel free to ask.

https://github.com/flydev-fr/the-big-prompt

flydev-fr/mormot-authentication-jwt

I had this issue and I had to write my own TRestServerAuthentication* handler and overriding `SessionCreate()`, `RetrieveSession()` and `Auth()` as because HandleAuthentication is set at RestServer level, session logic is expected.

I found the thread that explain what I said, there: /forum/viewtopic.php?pid=30095#p30095

You will find a nice example (v1) from @Chris75018.

Hi @ab I had read this thread two times but missed this message! thanks

Just use `SetBearer`, you can of course just set header manually.

Yes, you can implement a JWT-based authentication endpoint in your server. Could either be provided directly by your server (via a secret key) or integrated with an existing identity provider like Hanko or Auth0.

Sure, thanks.

I like the idea @mpv

I’m hoping to be there at the next EKON you’ll be participating in to learn, listen to your insights, and finally ask a question I’ve been wanting to ask for over five years! Enjoy the sessions

Hi, I’ve just published a project that you might want to check out. Its based of a larger project I’m working on (inspired by Rails ActionCable and designed to work with mormot MVC). I’ve stripped the code a bit, so you’ll get a WebSockets server and some event handling. I’ve also included a JS client for chat functionality.

I’ll try to create a lighter sample this weekend based on the example you linked from Embarcadero.

You will need NPM or yarn installed to run the js project. I can build it to be ran without js tooling, just let me know. Anyway, you can connect with any websockets client on `ws:127.0.0.1:8082/cable` endpoint.

Files of interest:
- chat_channel.pas
- token/token.pas
- http-server/ws_server.pas

Do not pay attention to InitMVCApp and other mvc things.. hope it help

url:   https://github.com/flydev-fr/mormot-cable

Hi,

are you talking about http.sys? if yes, read there: 11.6.2.2.3. Manual URI authorization

(windows gui tool:  https://codeplexarchive.org/project/httpsysmanager)

If not, then a good chinese<>eng translator for posting here can be found at deepl.com

as scheme name let suggest, it's implemented by default when using `true` for HandleUserAuthentication on Create*(), see lines mormot.rest.server.pas#L6176-L6181

TFileAuthUser is just derived from TAuthUser. Pheraps try with a more basic sample and then go further, I just published a project based on @martindoyle sample (04) and using a part of @tbo example,  you should be able to compile it on D7, grab it from flydev-fr/sample_interfacebasedservice

Hope it help.

you can find an example there: https://github.com/synopse/mORMot2/blob … #L160-L174

LogCompressAlgo is defined as global var in mormot.core.buffers, so include both units buffers and zip as @ColdZer0 said.

Just pushed an update for people interested to see an example of the mvc app using automatic translation based on the msg reference files. Every user, guest or logged, can set his own language kept in cookie session.

ps: I am not claiming it's the right way of doing it as it seem ugly to create and free a changed language on render.

It can be compiled on lazarus. Anyway, the feature is really cool for an hybrid desktop app.

Hi, I can understand your point of view but some statements are false like about the documentation, at contrario the doc is quite gigantic and can be complex on the first read - but once you get a bit familiar with the framework structure and conventions, the doc turn easy to understand and will became your handbook, and it's still also true if we take into account that the current full documentation is about the version 1.

From the ground up, I can only suggest to read the whole introduction which include chapter 1, 2 and 3 - then play without getting into details with the samples, I mean compile, test and then read the code, then going from code to the documentation to make some corelation, also, the whole source code contain detailled comments.

You can find also Thomas (tbo)'s tutorials (read the readme linked on github), and to be honest, the full samples from the v1 are still useful.

Some links:
- doc v1 (v2 is a wip)
- Thomas tutorials (you will find write up, translatable, on delphipraxis)
- Stephan Bester's intros on Medium
- Again, some tutorials based on the v1, but still applies!
- A lot of samples there

The learning curve is rude, but definitely worth it.

Okay, I'll start experimenting with this workflow.

Regarding images, I wanted to know how others do it, like storing images as a blob or other techniques, but after my post, I think that in my case this would definitely not be the way to go. As for the redirection, perhaps I could use it to trigger an initial request to generate the images before a user even visits the page, and thus save a few ms. I hadn't thought of that.

Thanks for your insight @ab

@Lauri I didn't tested on Delphi 2007, but the bugs are still there in Delphi 10, 11 and 12, and only if an invalid variant value exist.

If the variant is valid, you can inspect it and move your mouse hover it, but if you are stepping through code and move cursor hover an invalid variant, the IDE hang and you have to kill it; Killing LSP process only do not work.

The only way I found to avoid the crash, is to move the cursor out of the IDE and starting debugging using keyboard's shortcuts, inspector will show variant (valid/invalid) values. Also, when an AV is triggered, use the keyboard, not the mouse.

That doesn't happen in Lazarus. Years of frustration yes, but if there was only this issue, we could live with it **clown emoji here**

Thanks for your input. I will post the result for the science.

@ColdZer0, is everything still ok?

I am asking because i ran into the same issue in the end of july while testing the new async server, and I want to give another try. I had no junk network traffic as the network is filtered only on known static ips but almost all clients are connecting through 4G routers with sometime high latency and/or random disconnections. The console was "stuck" after ~6h with around 170 clients sending 1 or more requests per secs.

Thanks you both for the debugging and fixes