Request token Sql error with Postgres invalid input syntax for integer: \"xxx\"

[abumostafa]

I found an issue while request an access token with postgres database.

curl --data "client_id=xxx_client&client_secret=someSecret&grant_type=password&username=email@example.com&password=somePassword" http://api.example.com/oauth/v2/token

i got sql error ERROR: invalid input syntax for integer: "xxx" the problem is postgres is type strict.

[mappedinn]

requesting an access token should be like this:

/oauth/v2/token?client_id=6_p6z1cvjowcgwokc00gwgc8ookc4k80wsgcwwcg0ggsw0sw440&client_secret=2q38hc3vpd4w4s0ccwgssowgkgg0o0gww044o0w0s0ws48ss80&grant_type=client_credentials&redirect_uri=http://localhost/minnapi/web/app_dev.php/&username=user&password=pass

So, it is normal that you get xxx is not an integer.

The clientid is the concat of the id of your client + the + the random id