Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug: Sessions dont work on PostgreSQL #2546

Closed
MashinaMashina opened this issue Feb 13, 2020 · 1 comment
Closed

Bug: Sessions dont work on PostgreSQL #2546

MashinaMashina opened this issue Feb 13, 2020 · 1 comment
Labels
bug Verified issues on the current code behavior or pull requests that will fix them

Comments

@MashinaMashina
Copy link
Contributor

MashinaMashina commented Feb 13, 2020

CI4 save base64 encoded value, but postgres later returns hex encoded value and base64 cant decode value

If in database handler write this code before get query, all is ok
$this->db->query('SET bytea_output = "escape"');

https://www.postgresql.org/docs/9.0/datatype-binary.html

I dont know how we must work with binary data in Postgres

https://prnt.sc/r1sng5
https://prnt.sc/r1snv9
https://prnt.sc/r1sot1

I have PostgreSQL v12

@MashinaMashina MashinaMashina added the bug Verified issues on the current code behavior or pull requests that will fix them label Feb 13, 2020
@MashinaMashina MashinaMashina changed the title Bug: Sessionns dont work on PostgreSQL Bug: Sessions dont work on PostgreSQL Feb 13, 2020
@pstef
Copy link
Contributor

pstef commented Feb 27, 2020

@MashinaMashina see 4b1774a (which is a part of rejected #2256) for possible inspiration.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Verified issues on the current code behavior or pull requests that will fix them
Projects
None yet
Development

No branches or pull requests

2 participants