IRC Chat : 2010-11-29 - OpenMRS

00:28:56 *** fixl has joined #openmrs
00:43:55 *** r0bby is now known as robbyoconnor
01:09:38 *** misha680 has joined #openmrs
02:19:58 *** misha680 has quit IRC
02:21:01 *** misha680 has joined #openmrs
03:26:04 *** fixl has quit IRC
04:21:47 *** bwolfe has quit IRC
04:53:54 *** muthah has joined #openmrs
05:14:32 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: problem when adding two modules <http://forum.openmrs.org/viewtopic.php?f=8&t=717#p2703>
07:14:44 *** pascal` has joined #openmrs
07:42:36 *** ChanServ sets mode: +v pascal`
09:36:04 *** Hazamonzo has joined #openmrs
09:59:20 *** diptanuc has joined #openmrs
11:20:56 *** fixl has joined #openmrs
11:28:55 *** fixl has quit IRC
13:42:07 *** wyclif_ has quit IRC
13:53:53 *** bwolfe has joined #openmrs
13:53:53 *** ChanServ sets mode: +o bwolfe
13:59:43 *** misha680 has quit IRC
14:04:53 *** fixl has joined #openmrs
14:16:50 *** diptanuc has quit IRC
14:27:44 *** wyclif_ has joined #openmrs
14:28:52 *** bwolfe has quit IRC
14:30:27 *** bwolfe has joined #openmrs
14:30:27 *** ChanServ sets mode: +o bwolfe
14:39:49 *** pascal` has quit IRC
14:58:44 *** fixl has quit IRC
15:02:32 *** wyclif_ has quit IRC
15:09:46 *** wyclif has joined #openmrs
15:10:09 *** wyclif has quit IRC
15:36:36 *** muthah has quit IRC
16:03:28 *** pascal` has joined #openmrs
16:08:59 *** pascal` has quit IRC
16:23:17 *** pascal` has joined #openmrs
16:26:12 <OpenMRSBot> Recent updates in the world of openmrs: On Twitter: OpenMRS: RT @jeanninelemaire: 2nd Latin America #OpenSource Informatics Mtg starts now #IMeCa on #mHealth, @OpenMRS. Watch: http://bit.ly/g182FB <http://twitter.com/OpenMRS/statuses/9270509170597888>
16:28:29 *** pascal` has quit IRC
16:39:20 *** aja has joined #openmrs
16:41:16 *** gbastien has joined #openmrs
17:00:15 <OpenMRSBot> Recent updates in the world of openmrs: On Twitter: OpenMRS: #OpenMRS community members can vote now for the board member election. Read more and vote here: http://go.openmrs.org/election <http://twitter.com/OpenMRS/statuses/9281527594622977> || OpenMRS Announcements List: Action Needed - Voting is Open for the OpenMRS 2010 Community Board Member Position <https://listserv.iupui.edu/cgi-bin/wa-iupui.exe?A2=ind1011&L=openmrs-announce-l&P=704>
17:03:55 *** gbastien has quit IRC
17:04:57 *** gbastien has joined #openmrs
17:07:17 *** pascal` has joined #openmrs
17:29:39 *** diptanuc has joined #openmrs
17:35:53 *** Chris____ has joined #openmrs
17:36:05 <Chris____> Hello All!
17:37:25 <diptanuc> Hey!
17:38:15 <Chris____> How are you? I am new to OpenMRS and just completed my first install this past weekend
17:39:28 <diptanuc> I am good :) Welcome to OpenMRS!
17:40:59 <Chris____> We are working to deploy OpenMRS at one clinic in Colombia
17:42:34 <Chris____> My install , to the Amazon EC2/RDS cloud went well, except I keep getting this error when entering text in the patient search box "ERROR - CommonsLoggingOutput.error(75) |2010-11-28 17:17:15,540| A request has been denied as a potential CSRF attack. "
17:43:32 <Chris____> Have you seen this error before?
17:45:21 <diptanuc> Which version of Apache Tomcat are you seeing?
17:45:29 <diptanuc> *are you using?
17:45:50 <diptanuc> Tomcat 7?
17:53:29 *** pascal` has quit IRC
17:54:27 *** muthah has joined #openmrs
17:54:48 <Chris____> yes dip I am using tomcat 7, downloaded from apache this weekedn
17:55:15 *** muthah_ has joined #openmrs
17:56:11 <Chris____> I also used the most recent version of MRS i could download 1.7.0
17:56:29 *** muthah_ has quit IRC
17:57:02 *** muthah has quit IRC
17:57:14 <Chris____> @diptanuc my Tomcat version is 7.0.4
17:58:07 *** pascal` has joined #openmrs
18:00:41 <Chris____> @diptanuc I think it has to do with the search box becuase after i enter exactly 3 charachters the message appears and the previously sent error appears in the log
18:07:43 <bwolfe> Chris____: can you use tomcat 6 by any chance?
18:07:57 <bwolfe> we haven't tested with tomcat7, but diptanuc might be on the right track for this one...
18:08:13 <bwolfe> I've seen tomcat7 fail with people before, but haven't gone back and tested it.
18:09:00 <Chris____> I don't see why not, I will try uninstallingopenmrs and reinstalling on Tomcat 6
18:13:18 <bwolfe> Chris____: how difficult is that on ec2?
18:14:10 <Chris____> I already have openmrs undeployed and tomcat 7 uninstalled, tomcat 6 downloaded and about to install.
18:15:32 <Chris____> THe actualy EC2 server setup was extremely easy. This was my first ever Windows Server2008 deployment and I had the instance up and running including seperate db server for mysql in 2 days, if i had to do it again i could deploy a box prebuilt with all openmrs dependencies in about an hour
18:16:18 <Chris____> Have you guys done any test cases using AWS EC2?
18:22:41 <diptanuc> bwolfe: I encountered the same problem before with Tomcat 7
18:23:05 <diptanuc> And when I downgraded to tomcat6 things just worked for me
18:23:24 <diptanuc> chris:____: Could you use Tomcat6 and see what happens?
18:24:16 <Chris____> openmrs is deploying on tomcat 6 as we speak
18:24:21 <diptanuc> bwolfe: I have a question for you.
18:24:49 <Chris____> Are one of you open a defect or ticket for that issue?
18:25:14 <diptanuc> Can you tell me how can I add the Concept Dictionary that the OpenMRS installer installs after my installation is over?
18:26:02 <diptanuc> This time i chose not to add the demo data while installing OpenMRS, but now I am not able to see any concepts. I want at-least the default concept dictionary
18:27:18 <Chris____> I do not know exactly, but maybe there is a way to script it into the DB tables
18:29:56 *** deadpool has joined #openmrs
18:33:41 <bwolfe> diptanuc: you can delete all your tables and restart openmrs. it will prompt to reinstall. just choose the same database name
18:34:51 *** Chris____ has quit IRC
18:36:55 <diptanuc> bwolfe: Thanks! I was hoping that since OpenMRS lets you download the concept dictionary in CSV, it would let you import concepts from CSV.
18:38:55 <bwolfe> diptanuc: not really :-/
18:43:00 <diptanuc> bwolfe: How do users add new concept dictionaries in existing openmrs installations which are already in production?
18:43:25 <bwolfe> diptanuc: theres metadataexport module
18:43:29 <bwolfe> or just some sql dumps
18:43:37 <bwolfe> or a complete overwrite using sql dumps
18:43:47 <diptanuc> I see
18:44:43 <diptanuc> Thanks bwolfe. For now I would do a re-installation anyways, I was just thinking loud :)
18:51:49 *** ChrisR has joined #openmrs
19:00:35 <ChrisR> OK, I'm back with an update from my rollback to tomcat 6, after I deploy openmrs and click /openmrs i get the following "The following error occurred at startup: Should not be here because updates were run previously javax.servlet.ServletException: Should not be here because updates were run previously at org.openmrs.web.Listener.startOpenmrs(Listener.java:188) at org.openmrs.web.Listener.contextInitialized(Listener.java:146) at
19:03:49 <bwolfe> ChrisR: that can't be good :-/
19:04:02 <bwolfe> same openmrs version and db?
19:04:20 <ChrisR> yes same, but strange it did not take me to any of the initial confige screens
19:05:00 <ChrisR> I did drop the mysql schema i created for openmrs before redeploying
19:05:49 <bwolfe> the whole db, or just all the tables ?
19:06:10 <ChrisR> the whole db
19:06:16 <ChrisR> i recreated with same name
19:06:49 *** gbastien has quit IRC
19:08:59 <ChrisR> bwolfe: however now that i check the db, there are two tables created "liquibasechangeloglock" and "liquibasechangelog"
19:09:19 <ChrisR> those table were not present before I went to \openmrs from inside tomcat
19:09:59 <bwolfe> ChrisR: if liquibasechangelog is empty you're ok
19:10:09 <ChrisR> they are both empty
19:10:26 <bwolfe> ChrisR: is it a user error? do the same user creds still work that openmrs is using to connect to mysql?
19:11:31 <ChrisR> yes i used them to connect to the database from mysql workbench, but, the setup never asked me for database address or creds
19:11:53 <bwolfe> ChrisR: openmrs uses a file called the "runtime properties" the db name and creds are kept there
19:12:15 <ChrisR> bwolfe: so that file must remain after i undeployed it?
19:12:29 <bwolfe> did you choose "automatically installed database updates" by any chance?
19:12:41 <bwolfe> yes, openmrs is finding the file from before
19:12:55 <ChrisR> during mysql installation, or do you mean in my fisrt openmrs install?
19:13:56 <bwolfe> first openmrs install
19:14:40 <ChrisR> i think i chose yes. I also did not stop openmrs before undeploying and reinstalling
19:14:46 <ChrisR> i did however stop the tomcat server
19:17:13 <ChrisR> bwolfe here are more errors:
19:17:15 <ChrisR> Caused by: org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::0::bwolfe: Reason: Table 'OpenMRSDev.global_property' doesn't exist : Caused By: Precondition Error at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152) at org
19:17:32 <bwolfe> ah, very interesting
19:17:36 <ChrisR> Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::0::bwolfe: Reason: Table 'OpenMRSDev.global_property' doesn't exist : Caused By: Precondition Error at liquibase.ChangeSet.execute(ChangeSet.java:204) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26) at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(D
19:17:54 <bwolfe> so apparently deleting all tables doesn't work :-/
19:18:03 *** aja has quit IRC
19:18:10 <bwolfe> you can delete that runtime properties file and the database and start all over again
19:18:18 <bwolfe> look in the tomcat home dir for th openmrs-runtime.properties file
19:18:28 <bwolfe> /usr/share/tomcat6/.OpenMRS
19:18:35 <bwolfe> or /root/.OpenMRS if running as root
19:18:41 <bwolfe> or /usr/share/tomcat/.OpenMRS
19:22:28 <ChrisR> im running windows server 2008
19:23:06 <bwolfe> oh, then its docs and settings/userrunningtomcat/OpenMRS :-)
19:23:33 <bwolfe> openmrs writes the file location its using in the log file at startup
19:23:35 <ChrisR> maybe windows is my problem, but getting a LAMP instance running in EC2 was more complicated
19:23:48 <ChrisR> im going to try and delete the file and the database and try again
19:25:17 <ChrisR> i dont see that directory in windows
19:25:38 <ChrisR> bwolfe: C:\Users\Administrator\OpenMRS
19:26:34 <diptanuc> Can you delete the OpenMRS folder under Application Setting in windows
19:26:45 <diptanuc> And also the whole openmrs table on mysql?
19:26:52 <diptanuc> That should solve the problem
19:30:03 <ChrisR> ok thanks, i am going to try it!
19:32:28 <diptanuc> Actually I think on Windows you can find the OpenMRS folder in the Application Data folder in Documents And Settings\<User>\ folder
19:32:59 <diptanuc> I use Linux, so I don't remember the name of the folder properly :\
19:35:10 <ChrisR> I'm working on switching to Ubuntu, Canonical maintains machine images for Ubuntu server in AWS so i might try OpenMRS on ubuntu before we put our impl. in production
19:36:09 <diptanuc> Ok
19:36:31 <diptanuc> But your problem would be resolved anyways when you delete the OpenMRS folder
19:36:59 <diptanuc> In ubuntu the folder is in ~/.OpenMRS
19:37:14 <ChrisR> Do you know of any Amazon EC2 deployments of OpenMRS?
19:37:25 <diptanuc> Not sure
19:37:30 <diptanuc> It should be really trivial
19:37:38 <diptanuc> Just fire up a Ubuntu box
19:38:02 <diptanuc> Install Java 6, download tomcat 6 binary
19:38:25 <diptanuc> install the mysql server, and deploy the openmrs war
19:38:38 <diptanuc> And you should be fine :)
19:38:44 <diptanuc> It's really that easy!
19:39:32 <ChrisR> my problem was remote desktop connection
19:40:17 <ChrisR> windows should be fine though, i have a few other apps i'm moving into aws, easier if all servers are a standard build
19:41:32 *** Jason has joined #openmrs
19:41:41 <bwolfe> ChrisR: I know of one person that uses ec2 for openmrs hosting, so I know its possible
19:41:58 *** Jason is now known as Guest10643
19:45:28 <ChrisR> My main concerns right now are data portability and HIPPA compliance with EC2. We are in the early stages of implementation but i don't want to have to move later. Is the person you know about with EC@ impl. supporting United States customers?
19:50:30 *** Guest10643 has quit IRC
19:54:54 <bwolfe> ChrisR: I don't think so
20:02:05 <deadpool> bwolfe i have a quick question i stopped and then started the htmlformentry module and i get this error when i try to click on the administration link The following error happened somewhere on this page:
20:02:05 <deadpool> javax.el.ELException: org.openmrs.api.APIException: Service not found: interface org.openmrs.module.htmlformentry.HtmlFormEntryService (The full error stack trace output is in the source of this page.)
20:02:18 <deadpool> is that supposed to happen?
20:02:58 <bwolfe> deadpool: thats a known issue
20:03:02 <bwolfe> don't click 'stop'
20:03:03 <bwolfe> :-p
20:03:29 <deadpool> ah ok
20:04:06 <deadpool> is there a way to get back to the admin page remove the module and then reload it again?
20:05:15 <deadpool> i tried removing it through the terminal and couldn't find where it was loaded in the ,OpenMRS/modules directory
20:11:08 *** diptanuc has quit IRC
20:11:38 <bwolfe> deadpool: you can go straight to the modules page. use the firefox omni bar and just type in modules.list
20:13:31 <deadpool> uh that takes me to a google search do you mean like localhost:8080/openmrs/modules.list
20:15:30 <deadpool> cause that doesn't work to i get a 404 error
20:16:46 *** chopin has joined #openmrs
20:16:46 *** ChanServ sets mode: +v chopin
20:21:09 <deadpool> bwolfe: uhh what should i do i can't get to modules.list?
20:21:30 <bwolfe> http://localhost:8080/openmrs/admin/modules/module.list ?
20:21:44 <bwolfe> just restarting openmrs should get it back too
20:21:57 <bwolfe> (without deleting htmlformentry omod)
20:21:58 <chopin> unless the module startup is causing openmrs to fail on startup
20:21:58 <deadpool> cool i got it thanks
20:31:04 *** Hazamonzo has quit IRC
20:32:13 *** ChrisR has quit IRC
20:42:34 <deadpool> bwolfe: what file links basicmoduleLink.form to BasicModule.jsp I looked in the moduleApplicationContext.xml but couldn't find it
20:46:35 <bwolfe> an annotation I think
20:46:41 <bwolfe> @RequestMapping
21:02:03 <deadpool> bwolfe: i first built the basic module and tried just changing the namings around and i get this Unable to load/find moduleActivator: 'org.openmrs.module.FirstModule.FirstModuleActivator' Module: FirstModule Module
21:02:26 <bwolfe> thats in your config
21:02:32 <bwolfe> make sure that class + folder exists
21:02:38 <bwolfe> and that hte case is exactly the same
21:02:42 <deadpool> they do
21:02:54 <deadpool> ah they don't
21:02:58 <deadpool> i see where it is thanks
21:03:21 <deadpool> stupid me thanks
21:05:57 *** pascal` has quit IRC
21:08:43 *** ChrisR has joined #openmrs
21:11:25 <ChrisR> @bwolfe
21:11:50 <bwolfe> yessir
21:11:59 <ChrisR> @bwolfe - so i ran the openmrs new install after downgrading to tomcat 6, but then the initial install stops at the following text
21:12:00 <ChrisR> Starting OpenMRS Number of actions completed so far: 680 Server log file output: INFO - LoggingAdvice.invoke(127) |2010-11-29 15:56:38,170| Exiting method changePassword INFO - LoggingAdvice.invoke(102) |2010-11-29 15:56:39,125| In method SchedulerService.saveToMemento. Arguments: INFO - LoggingAdvice.invoke(127) |2010-11-29 15:56:39,126| Exiting method saveToMemento INFO - AbstractSessionFactoryBean.destroy(246) |2010-11-29 15:56:
21:12:12 <ChrisR> scratch that
21:12:23 <ChrisR> Starting OpenMRS Number of actions completed so far: 680 Server log file output: INFO - LoggingAdvice.invoke(127) |2010-11-29 15:56:38,170| Exiting method changePassword INFO - LoggingAdvice.invoke(102) |2010-11-29 15:56:39,125| In method SchedulerService.saveToMemento. Arguments: INFO - LoggingAdvice.invoke(127) |2010-11-29 15:56:39,126| Exiting method saveToMemento INFO - AbstractSessionFactoryBean.destroy(246) |2010-11-29 15:56:
21:13:04 <ChrisR> that is the text, i'm not sure if i should wait or if it is hung, it has been like that for ~20 mins
21:13:54 <bwolfe> just wait
21:14:09 <bwolfe> it looks to be almost done
21:27:04 *** MalteF has joined #openmrs
21:27:04 *** ChanServ sets mode: +v MalteF
21:31:20 <ChrisR> @bwolfe, still on that screen, no change in actions completed number
21:31:53 *** MalteF has quit IRC
21:32:03 <bwolfe> ChrisR: hmm
21:32:18 <bwolfe> perhaps you were right.
21:32:20 <bwolfe> no change in logs ?
21:32:36 <ChrisR> what is the log directory
21:37:26 <ChrisR> liquibaseupdatelogs.txt has not been updated sinve 55 of last hour
21:37:35 <OpenMRSBot> Recent updates in the world of openmrs: New Changeset: OpenMRS trunk #16724: [Mark Goodrich] added text providing a changemessage when updating the reason for exit obs <http://feedproxy.google.com/~r/OMRStrunk/~3/xxdi3uSQz8A/> || New Changeset: OpenMRS 1.7.x #16723: [Mark Goodrich] added text providing a changemessage when updating the reason for exit obs <http://feedproxy.google.com/~r/OMRStrunk/~3/IEHRC1MhKrc/> || New Changeset: OpenMRS 1.6.x #16722: [Mark Goodrich] added text providing a changemessage when updating the reason for exit obs <http://feedproxy.google.com/~r/OMRStrunk/~3/aPI0mL-1xKM/>
21:39:42 <bwolfe> the tomcat logs is what I was asking about
21:39:59 <bwolfe> ChrisR: if you restart the server it should be up
21:40:02 <bwolfe> err, working
21:40:23 <ChrisR> restart the entire box or just the mrs from inside tomcat
21:41:46 <ChrisR> @bwolfe I checked mysql and it looks like the tables have been created
21:41:58 <bwolfe> ChrisR: restart tomcat
21:46:10 <ChrisR> @bwolfe, great, I was able to login!
21:46:29 <bwolfe> whew!
21:47:00 <ChrisR> Thank you a lot! AND, the csrf javascript error is gone!
21:48:04 <deadpool> bwolfe: i get this Unexpected exception parsing XML document from class path resource [applicationContext-service.xml]; nested exception is java.lang.IllegalStateException: Annotation-specified bean name 'firstmoduleController' for bean class [org.openmrs.module.BasicModule.web.controller.FirstModuleController] conflicts with existing, non-compatible bean definition of same name and class [org.openmrs.module.FirstModule.web.
21:48:04 <deadpool> controller.FirstModuleController
21:48:57 <deadpool> i have checked all the files and directories and made sure that they match
21:49:17 <bwolfe> ChrisR: great, can you update your dev list email with that? bonus points if you open a new ticket on tickets.openmrs.org to test openmrs in tomcat7
21:50:07 <bwolfe> deadpool: you can't use 'firstmoduleController' in two places in the moduleApplicationContext file
21:50:17 <bwolfe> change the "id" of one of htem
21:56:22 <ChrisR> i will open the ticket and reply to my dev list mail with the resolution
21:56:33 <ChrisR> @bwolfe i will open the ticket and reply to my dev list mail with the resolution
21:56:47 <ChrisR> @bwolfe, what is your role within the Open MRS Organization?
21:57:59 <bwolfe> ChrisR: mid-level jedi
21:59:01 <ChrisR> @bwolfe, may the force be with you!
21:59:51 <ChrisR> @bwolfe, I'm a product manager for enterprise software development company by day, by night i'm trying to launch a medical informatics company in south america.
22:01:03 <bwolfe> ChrisR: sounds like a double full time job :-)
22:01:48 <ChrisR> It is, I look forward to working with the OpenMRS team though!
22:02:09 <ChrisR> @bwolfe, Before I sign off for today, how do i create an encounter?
22:02:42 <bwolfe> ChrisR: you can do it manually the hard way with the Manage Encounters page...but you're supposed to use a formentry type of module. either 'formentry', 'htmlformentry', or 'xforms'.
22:02:56 <bwolfe> I rec htmlformentry
22:05:14 *** chopin has quit IRC
22:05:19 <deadpool> bwolfe: i am using the downloaded moduleApplicationContext.xml i didn't put any links to firstmodulecontroller in there how is it seeing it
22:05:47 <bwolfe> deadpool: did you copy/paste anything
22:05:52 <bwolfe> ?
22:05:57 <bwolfe> gotta run, be back later
22:06:00 <deadpool> nope
22:06:15 <deadpool> just looked for basicmodule and changed it to firstmodule
22:06:23 <deadpool> ok bwolfe cya later
22:06:49 <ChrisR> @deadpool, what is your project?
22:09:33 <deadpool> just trying to create a module but what i am trying to do is create a questionaire for the registration page for a hospital and this questionairre will help determine if a patient needs financial help or not when pursuing treatment options
22:10:21 <deadpool> but right now i deployed the basic module and now was trying to rename it and now i am getting errors
22:10:53 *** bwolfe has quit IRC
22:12:08 <ChrisR> Sounds like good info to have at registration,we are doing completly new install
22:13:33 <deadpool> ah interesting
22:14:07 <deadpool> yeah i was reading what you were posting can i ask why you chose win 2008 server?
22:18:01 *** chopin has joined #openmrs
22:18:01 *** ChanServ sets mode: +v chopin
22:23:25 <ChrisR> It is what I am framiliar with, our goal now is to become framiliar with OpenMRS and it's capabiliies, we are evaluating a number of MRS systems.
22:23:51 <deadpool> ah cool
22:24:12 <ChrisR> In production for our clients however I think we will be offering Linux, Apache, MySQL for actual deployment
22:24:39 <deadpool> ah gotcha
22:25:04 <ChrisR> Also, the windows EC2 image was easier to configure, I am not much for command line interface, and with trying to evaluate with minimal man hours, windows was easier to setup in a weekend
22:25:33 <ChrisR> Where is your project implemented?
22:29:29 *** ChrisR has quit IRC
22:29:52 <deadpool> in india
22:31:31 *** chopin has quit IRC
23:13:56 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Modules: ID Generation 2.0.1 uploaded to OpenMRS Module Repository <https://dev.openmrs.org/modules/view.jsp?module=idgen&version=&2.0.1> || OpenMRS Modules: HTML Widgets 1.5.6.1 uploaded to OpenMRS Module Repository <https://dev.openmrs.org/modules/view.jsp?module=htmlwidgets&version=&1.5.6.1>