davidray

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springsource.org/dtd/spring-beans.dtd">

<!--+
	| Application context containing JDBC AuthenticationProvider 
	| implementation.
	+-->

<beans>
         <bean id="daoAuthenticationProvider" 

davidray

**=securityContextHolderAwareRequestFilter,httpSessionContextIntegrationFilter,httpSessionReuseDetectionFilter,logoutFilter,authenticationProcessingFilter,basicProcessingFilter,requestParameterProcessingFilter,rememberMeProcessingFilter,anonymousProcessingFilter,pentahoSecurityStartupFilter,switchUserProcessingFilter,exceptionTranslationFilter,filterInvocationInterceptor]]

davidray

Processing MorbidityEventsController#edit (for 99.132.187.198 at 2010-06-15 13:07:09) [GET]
[2010-06-15 13:07:09] [INFO ]   Parameters: {"id"=>"136"}
[2010-06-15 13:07:09] [INFO ] logger.using_user_in_session: Using user set in session
[2010-06-15 13:07:09] [INFO ] logger.attempting_to_load_user: Attempting to load user with a UID of Mult Cty STD Surv Mgr
[2010-06-15 13:07:09] [INFO ] logger.user_loaded: User loaded: Mult Cty STD Surv Mgr
[2010-06-15 13:07:09] [INFO ] Rendering template within layouts/application
[2010-06-15 13:07:09] [INFO ] Rendering morbidity_events/edit
[2010-06-15 13:07:11] [FATAL] 
ActionView::TemplateError (can't convert nil into String) on line #54 of app/views/people/_address_form.html.haml:
51:           =a.label(:county)

davidray

[2010-06-14 19:29:04] [INFO ] Rendering morbidity_events/edit
[2010-06-14 19:29:05] [FATAL] 
ActionView::TemplateError (can't convert nil into String) on line #54 of app/views/people/_address_form.html.haml:
51:           =a.label(:county)
52:           %span.data_county
53:             =a.dropdown_code_field(:county_id, 'county', {:include_blank => true}, {}, event)
54:         -core_element :postal_code, a, :horiz do
55:           =a.label(:postal_code)
56:           %span.data_postal_code
57:             =a.core_text_field(:postal_code, {:size => 7, :maxlength=> 10}, event)

davidray

me: actually, that file should be identical to /usr/share/postgresql/contrib/pg_trgm.sql
psql -Xf  /usr/share/postgresql/contrib/pg_trgm.sql postgres
that's what I mean

bfgoodrich11@gmail.com: open("pg_trgm.sql", O_RDONLY)           = -1 ENOENT (No such file or directory)
the stupid thing has to be in the path

me: oh

bfgoodrich11@gmail.com: when you don't specify

davidray

bfgoodrich11@gmail.com: /usr/lib64/postgresql/pg_buffercache.so
/usr/lib64/postgresql/pgcrypto.so
/usr/lib64/postgresql/pgxml.so
/usr/lib64/postgresql/pgrowlocks.so
/usr/lib64/postgresql/pg_freespacemap.so
/usr/lib64/postgresql/pg_stat_statements.so
/usr/lib64/postgresql/pg_trgm.so
/usr/lib64/postgresql/pgstattuple.so
you would think it would default to /usr/lib64/postgres??
 Sent at 4:09 PM on Tuesday

davidray

!!WARNING!!: this may take several minutes. Run: tail -f ./upgrade_db_output.txt to watch upgrade progress
cd ../webapp/
/usr/local/downloads/trisano/2.5.0/05-19-2010-0849AM/distro/../lib/jruby/jruby-1.2.0/bin/jruby -S rake db:migrate RAILS_ENV=production
rake aborted!
An error has occurred, this and all later migrations canceled:
 
ActiveRecord::ActiveRecordError: ERROR: could not access file "$libdir/pg_trgm": No such file or directory: /* $PostgreSQL: pgsql/contrib/pg_trgm/pg_trgm.sql.in,v 1.7 2007/12/09 02:22:46 tgl Exp $ */
 
-- Adjust this setting to control where the objects get created.
SET search_path = public;

davidray

top - 08:51:59 up 381 days, 18:23,  2 users,  load average: 0.93, 2.25, 2.70
Tasks: 108 total,   1 running, 106 sleeping,   0 stopped,   1 zombie
Cpu(s):  0.0%us,  0.2%sy,  0.0%ni, 99.8%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   4048072k total,  2813808k used,  1234264k free,   228092k buffers
Swap:  2097144k total,    71676k used,  2025468k free,  2379900k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                 
 4384 zabbix    25   5  9648  664  592 S    1  0.0   3038:32 zabbix_agentd           
    1 root      20   0  1064   88   52 S    0  0.0   2:20.40 init                    
    2 root      15  -5     0    0    0 S    0  0.0   0:00.00 kthreadd                

davidray

def date_string_born_on
    born_on.nil? ? "" : born_on.to_s(:default)
  end
  def date_string_born_on=(value)
    self.born_on = value
  end

  def date_string_physical_class1_on
    physical_class1_on.nil? ? "" : physical_class1_on.to_s(:default)
  end

davidray

 Nested Loop  (cost=149.78..199.53 rows=1 width=1258)
   Join Filter: (p.event_id = events.id)
   ->  Nested Loop  (cost=149.78..189.26 rows=1 width=742)
         Join Filter: (pl.entity_id = p.secondary_entity_id)
         ->  Nested Loop  (cost=149.78..188.35 rows=1 width=742)
               Join Filter: (places_types.place_id = pl.id)
               ->  Nested Loop  (cost=149.78..176.78 rows=1 width=222)
                     Join Filter: (places_types.type_id = c.id)
                     ->  Seq Scan on codes c  (cost=0.00..11.80 rows=1 width=222)
                           Filter: (deleted_at IS NULL)