Hi,
I’m experiencing problems with decl_auth when using a database with
users
table and columns names different from default. When I try to register
an
new user using the register form, I got the following error:
*
*
- ActiveRecord::RecordNotFound in UsersController#create
Couldn’t find Role without an ID
RAILS_ROOT: /home/gustavo/CAS/cas-web
Application Trace http://localhost:3000/users# | Framework
Tracehttp://localhost:3000/users#| Full
Trace http://localhost:3000/users#
/home/gustavo/.rvm/gems/jruby-1.5.2/gems/activerecord-2.3.8/lib/active_record/base.rb:1597:in
find_from_ids' /home/gustavo/.rvm/gems/jruby-1.5.2/gems/activerecord-2.3.8/lib/active_record/base.rb:619:in find’
/home/gustavo/CAS/cas-web/app/controllers/users_controller.rb:41:in
`create’
My user.rb file:
class User < ActiveRecord::Base
#==============================
Petro DB Convention Mapping
#==============================
TABLE_NAME = ‘USUARIO’
set_table_name TABLE_NAME
FIRST_NAME_COLUMN = ‘USUA_NM_NOME’
LAST_NAME_COLUMN = ‘USUA_NM_SOBRENOME’
USERNAME_COLUMN = ‘USUA_NM_USUARIO’
CRYPT_PASSWORD_COLUMN = ‘USUA_VL_CRYPT_PASSWORD’
PASSWORD_SALT_COLUMN = ‘USUA_VL_PASSWORD_SALT’
PERSISTENCE_TOKEN_COLUMN = ‘USUA_VL_TOKEN’
LAST_LOGIN_AT_COLUMN = ‘USUA_DT_ULTIMO_LOGIN’
LAST_LOGIN_IP_COLUMN = ‘USUA_VL_IP_ULTIMO_LOGIN’
EMAIL_COLUMN = ‘USUA_VL_EMAIL’
CURRENT_LOGIN_AT_COLUMN = ‘USUA_DT_ATUAL_LOGIN’
CURRENT_LOGIN_IP_COLUMN = ‘USUA_VL_IP_ATUAL_LOGIN’
DEPARTMENT_ID_COLUMN = ‘USUA_CD_DPTO’
CREATED_AT_COLUMN = ‘EVT_DT_CRIACAO’
UPDATED_AT_COLUMN = ‘EVT_DT_ATUALIZACAO’
alias_attribute :first_name, FIRST_NAME_COLUMN
alias_attribute :last_name, LAST_NAME_COLUMN
alias_attribute :username, USERNAME_COLUMN
alias_attribute :crypted_password, CRYPT_PASSWORD_COLUMN
alias_attribute :password_salt, PASSWORD_SALT_COLUMN
alias_attribute :persistence_token, PERSISTENCE_TOKEN_COLUMN
alias_attribute :last_login_at, LAST_LOGIN_AT_COLUMN
alias_attribute :last_login_ip, LAST_LOGIN_IP_COLUMN
alias_attribute :email, EMAIL_COLUMN
alias_attribute :current_login_at, CURRENT_LOGIN_AT_COLUMN
alias_attribute :current_login_ip, CURRENT_LOGIN_IP_COLUMN
alias_attribute :department_id, DEPARTMENT_ID_COLUMN
alias_attribute :created_at, CREATED_AT_COLUMN
alias_attribute :updated_at, UPDATED_AT_COLUMN
acts_as_authentic do |config|
config.login_field USERNAME_COLUMN
config.crypted_password_field CRYPT_PASSWORD_COLUMN
end
acts_as_tagger
#==============================
Associations
#==============================
has_many :events
has_many :assignments, :dependent => :destroy
has_many :roles, :through => :assignments
has_many :event_approval_requests
belongs_to :department, :foreign_key => DEPARTMENT_ID_COLUMN
#==============================
Validations
#==============================
accepts_nested_attributes_for :assignments
validates_associated :roles, :assignments
validates_presence_of :first_name, :last_name, :email, :username
validates_presence_of :department_id, :unless => :admin?
def admin?
roles.first.title == Role::ADMIN_TITLE
end
def to_param
“#{id}-#{username}”
end
def role_symbols
roles.map do |role|
role.title.underscore.to_sym
end
end
end
Register Form:
<% simple_form_for @user do |f| %>
<%= f.error_messages %>
<%= f.input :username %>
<%= f.input :first_name %>
<%= f.input :last_name %>
<%= f.input :email %>
<%= f.association :roles, :as => :radio %>
<%= f.association :department %>
<%= f.button :submit %>
<% end %>
Migration snippet:
change_table :users do |t|
t.rename :first_name, User::FIRST_NAME_COLUMN
t.rename :last_name, User::LAST_NAME_COLUMN
t.rename :username, User::USERNAME_COLUMN
t.rename :crypted_password, User::CRYPT_PASSWORD_COLUMN
t.rename :password_salt, User::PASSWORD_SALT_COLUMN
t.rename :persistence_token, User::PERSISTENCE_TOKEN_COLUMN
t.rename :last_login_at, User::LAST_LOGIN_AT_COLUMN
t.rename :last_login_ip, User::LAST_LOGIN_IP_COLUMN
t.rename :email, User::EMAIL_COLUMN
t.rename :current_login_at, User::CURRENT_LOGIN_AT_COLUMN
t.rename :current_login_ip, User::CURRENT_LOGIN_IP_COLUMN
t.rename :department_id, User::DEPARTMENT_ID_COLUMN
t.rename :created_at, User::CREATED_AT_COLUMN
t.rename :updated_at, User::UPDATED_AT_COLUMN
end
rename_table :users, User::TABLE_NAME
Roles table:
create_table :roles do |t|
t.string :title
t.timestamps
end
Assignment table:
create_table :assignments do |t|
t.integer :user_id
t.integer :role_id
t.timestamps
end
Thanks in advance,
Gustavo