# Problem with open\_id\_authentication\_plugin and PostgreSQL 8.2 **URL:** \ **Category:** Rails\ **Created:** [November 17, 2007, 12:07pm UTC](https://www.ruby-forum.com/t/problem-with-open-id-authentication-plugin-and-postgresql-8-2/120479 "2007-11-17T12:07:41Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Nicola\_Piccinini](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/c77e96/32.png) [@Nicola\_Piccinini](https://www.ruby-forum.com/u/Nicola_Piccinini)\ **Post date:** [November 17, 2007, 12:07pm UTC](https://www.ruby-forum.com/t/problem-with-open-id-authentication-plugin-and-postgresql-8-2/120479/1 "2007-11-17T12:07:41Z")
I’m using open\_id\_authentication\_plugin ( [http://svn.rubyonrails.org/rails/plugins/open\_id\_authentication](http://svn.rubyonrails.org/rails/plugins/open_id_authentication) @ 7263 ) and it works perfectly with MySQL. If I switch to PostgreSQL 8.2 (on debian lenny) with a database with UTF8 encoding, I get the following exception: PGError: ERROR: invalid byte sequence for encoding “UTF8”: 0xe0ab03 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by “client\_encoding”. : INSERT INTO open\_id\_authentication\_associations (“handle”, “server\_url”, “lifetime”, “assoc\_type”, “issued”, “secret”) VALUES(E’{HMAC-SHA1}{473ec62e}{ye1zmQ==}‘, E’[http://www.myopenid.com/](http://www.myopenid.com/) server’, 1209600, E’HMAC-SHA1’, 1195296303, E’��nRIʸ�lUYE��S,') RAILS\_ROOT: /home/pic/pg Application Trace | Framework Trace | Full Trace vendor/rails/activerecord/lib/active\_record/connection\_adapters/ abstract\_adapter.rb:150:in `log' vendor/rails/activerecord/lib/active_record/connection_adapters/ postgresql_adapter.rb:404:in `execute’ vendor/rails/activerecord/lib/active\_record/connection\_adapters/ abstract/database\_statements.rb:156:in `insert_sql' vendor/rails/activerecord/lib/active_record/connection_adapters/ abstract/database_statements.rb:44:in `insert\_without\_query\_dirty’ vendor/rails/activerecord/lib/active\_record/connection\_adapters/ abstract/query\_cache.rb:19:in `insert' vendor/rails/activerecord/lib/active_record/connection_adapters/ postgresql_adapter.rb:387:in `insert’ vendor/rails/activerecord/lib/active\_record/base.rb:2056:in `create_without_callbacks' vendor/rails/activerecord/lib/active_record/callbacks.rb:226:in `create\_without\_timestamps’ vendor/rails/activerecord/lib/active\_record/timestamp.rb:29:in `create' vendor/rails/activerecord/lib/active_record/base.rb:2022:in `create\_or\_update\_without\_callbacks’ vendor/rails/activerecord/lib/active\_record/callbacks.rb:213:in `create_or_update' vendor/rails/activerecord/lib/active_record/base.rb:1774:in `save\_without\_validation’ vendor/rails/activerecord/lib/active\_record/validations.rb:891:in `save_without_transactions' vendor/rails/activerecord/lib/active_record/transactions.rb:118:in `save’ vendor/rails/activerecord/lib/active\_record/connection\_adapters/ abstract/database\_statements.rb:66:in `transaction' vendor/rails/activerecord/lib/active_record/transactions.rb:90:in `transaction’ vendor/rails/activerecord/lib/active\_record/transactions.rb:110:in `transaction' vendor/rails/activerecord/lib/active_record/transactions.rb:118:in `save’ vendor/rails/activerecord/lib/active\_record/transactions.rb:130:in `rollback_active_record_state!' vendor/rails/activerecord/lib/active_record/transactions.rb:118:in `save’ vendor/rails/activerecord/lib/active\_record/base.rb:470:in `create' vendor/plugins/open_id_authentication/lib/open_id_authentication/ db_store.rb:28:in `store\_association’ /home/pic/opt/ruby/gems\_repository/gems/ruby-openid-1.1.4/lib/openid/ consumer.rb:681:in `associate' /home/pic/opt/ruby/gems_repository/gems/ruby-openid-1.1.4/lib/openid/ consumer.rb:633:in `get\_association’ /home/pic/opt/ruby/gems\_repository/gems/ruby-openid-1.1.4/lib/openid/ consumer.rb:468:in `begin' /home/pic/opt/ruby/gems_repository/gems/ruby-openid-1.1.4/lib/openid/ consumer.rb:301:in `begin\_without\_discovery’ /home/pic/opt/ruby/gems\_repository/gems/ruby-openid-1.1.4/lib/openid/ consumer.rb:281:in `begin' vendor/plugins/open_id_authentication/lib/open_id_authentication.rb: 96:in `begin\_open\_id\_authentication’ vendor/plugins/open\_id\_authentication/lib/open\_id\_authentication.rb: 155:in `timeout_protection_from_identity_server' vendor/plugins/open_id_authentication/lib/open_id_authentication.rb: 96:in `begin\_open\_id\_authentication’ vendor/plugins/open\_id\_authentication/lib/open\_id\_authentication.rb: 88:in `authenticate_with_open_id' app/controllers/sessions_controller.rb:38:in `open\_id\_authentication’ app/controllers/sessions\_controller.rb:12:in `create' -e:2:in `load’ -e:2 I’am running ruby 1.8.6 (2007-06-07 patchlevel 36) [i486-linux] and edge Rails. Any ideas? Thanks, Nicola