search

switchit-conseil / nestjs-oauth2-server-module

OAuth2 Server for NestJS
MIT License
71 stars 33 forks source link

jsonb data type not supported #9

Open gdg87 opened 4 years ago

gdg87 commented 4 years ago

Hi, I try to use the package with mysql database but I have this error

DataTypeNotSupportedError: Data type "jsonb" in "AccessTokenEntity.createdFrom" is not supported by "mysql" database.

Is possible switch the field type to json in order to support more database.

Thanks

ptesser commented 4 years ago

Hi, it's the same for me. I'm using a MySQL 5.7 database and I think the problem appears because in MYSQL jsonb is not support.

Is there a workaround for this?

Is it possible to change the default entities with custom ones?

Thanks

gdg87 commented 4 years ago

Hi @ptesser, since no news comes from switchit I decide fork it and publish a new package. You can find it here:

https://www.npmjs.com/package/@switchit/nestjs-oauth2-server

If you want to contribute you are welcome.

nmacherey commented 4 years ago

Sorry I was blocked on a bug project for last couple ok weeks.

I will look at your fork and integrate it. Could you propose a Pull request ?

Thanks a lot

Envoyé de mon iPhone

Le 10 juin 2020 à 17:56, gdg87 notifications@github.com a écrit :

 Hi @ptesser, since no news comes from switchit I decide fork it and publish a new package. You can find it here:

https://www.npmjs.com/package/@switchit/nestjs-oauth2-server

If you want to contribute you are welcome.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

ptesser commented 4 years ago

Hi @gdg87, thanks for the fork. I'll watch it, but probably I'll wait that @nmacherey take care of your integration.

Thanks a lot

CayBap commented 3 years ago

I change to json type and I try to run it in mysql set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; it worked