Plinq / pgcrypto

A transparent ActiveRecord::Base extension pgcrypto encrypted columns
MIT License
40 stars 18 forks source link

Issues during setup and installation (existing project with data) #1

Open stonehz opened 11 years ago

stonehz commented 11 years ago

I follow the steps but I get some errors Steps followed:

  1. Install gem and migrate db Extensions exists in the db and "pgcrypto_columns" table gets created
  2. Edit Initializer file and add:
PGCrypto.keys[:private] = {:path => "./keys/private.key" , :armored => false, :password => "password" }
PGCrypto.keys[:public] = {:path => "./keys/public.key"}

3 . Edit my user.rb and add the following: pgcrypto :organisation_name (column in my users table)

Starting Server and trying to CRUD User

During Create: It works and the records gets saved During Read/Update I get: PG::Error: ERROR: failed to find conversion function from unknown to bytea

Any Ideas?

flipsasser commented 10 years ago

Wow, sorry, again I missed an issue on Github. I'm updating my notification preferences!

Anyway, how did you generate your keys AND/OR what version of Postgres are you using?