Once installed, it requires me to do user mapping (the other 'mongo_fdw' didn't)

EnterpriseDB / mongo_fdw

PostgreSQL foreign data wrapper for MongoDB

GNU Lesser General Public License v3.0

326 stars 70 forks source link

Once installed, it requires me to do user mapping (the other 'mongo_fdw' didn't) #19

Closed akauppi closed 9 years ago

akauppi commented 9 years ago

MongoDB is often used without user access control. If I can reach the server, that's it.

I think I've got all else in place now, with this mongodb_fdw variant, but it gives:

temp=# SELECT * FROM results6;
ERROR:  user mapping not found for "..."

how do I create a dummy user mapping to please it?
could the code be changed so that this additional hurdle is removed?

System: OS X 10.10.x, Homebrew, MongoDB '--with-master' selected at build etc.

akauppi commented 9 years ago

This solved the hurdle for me:

temp=# CREATE USER MAPPING FOR CURRENT_USER SERVER mongo_server;
CREATE USER MAPPING

However, I'm getting no data from the JSON typed data fields (was trying to reach to objects-in-an-array, and make them visible in PostreSQL), so probably ending my trials for now.