Re: [Gnumed-devel] gnumed ideas 0.1 and post-0.1 (was Time for a major re-think in 2005)

[catmat]

Karsten Hilbert wrote:

> > I got the java web client running on Carlos's server, but came up 
> > against an access problem for user any-doc ( wrt to  a sql view on  telephone numbers etc).
> >    
> Can you expand on that ? This must be solvable.
>
> Karsten
>  
goto

http://salaam.homeunix.com:8080/gnumed-test-war

the dummy login is admin / password
then search for surname Kirk ( sorry, put the surname field second, a 
usability error).
Kirk comes up.
click Kirk to edit demographics and a blank page comes up.

this is the output when I check the logs

> address@hidden sjtan $ tail -n10 /opt/tomcat5/logs/catalina.out
>         at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
>         at java.lang.Thread.run(Thread.java:534)
> Jan 26, 2005 10:53:30 PM 
> org.gnumed.testweb1.persist.scripted.ScriptedSQLDemographicDataAccess 
> findDemographicDetailById
> SEVERE: java.sql.SQLException: ERROR:  permission denied for relation 
> v_person_comms_flat
>
> Jan 26, 2005 10:53:30 PM org.gnumed.testweb1.actions.ActionUtil 
> setAttributeOnScopeFromMappingAttributeAndScope
> INFO: REQUEST FORM ATTRIBUTE KEYdemographicForm
> Jan 26, 2005 10:53:30 PM 
> org.gnumed.testweb1.actions.DemographicEditAction execute
> INFO: org.gnumed.testweb1.persist.DataSourceException: 
> org.gnumed.testweb1.persist.DataSourceException: 
> java.sql.SQLException: ERROR:  permission denied for relation 
> v_person_comms_flat

the connection user is any-doc.