| 00:14:52 | *** wluyima has joined #openmrs |
| 00:25:45 | *** burke_away is now known as burke |
| 00:40:03 | *** mnunez has joined #openmrs |
| 01:30:47 | *** Gagaman has joined #openmrs |
| 01:34:13 | *** mnunez has quit IRC |
| 02:11:39 | *** Gagaman has quit IRC |
| 02:28:09 | *** mnunez has joined #openmrs |
| 02:49:16 | *** upul` has joined #openmrs |
| 02:49:16 | *** ChanServ sets mode: +v upul` |
| 02:59:18 | *** mnunez has quit IRC |
| 03:07:06 | *** burke has quit IRC |
| 03:55:45 | *** surangak has joined #openmrs |
| 04:07:54 | *** mnunez has joined #openmrs |
| 04:41:07 | <surangak> djazayeri, hi, mm r u still here ? |
| 04:41:31 | <surangak> djazayeri, any idea if I can read a global propery from javascript ? |
| 05:22:47 | *** finbrein has quit IRC |
| 05:30:57 | *** sunbiz has joined #openmrs |
| 05:30:57 | *** ChanServ sets mode: +v sunbiz |
| 05:53:10 | *** surangak_ has joined #openmrs |
| 05:53:10 | *** surangak has quit IRC |
| 05:59:11 | *** surangak has joined #openmrs |
| 05:59:11 | *** surangak_ has quit IRC |
| 06:02:39 | *** surangak_ has joined #openmrs |
| 06:02:39 | *** surangak has quit IRC |
| 06:19:45 | *** sunbiz has left #openmrs |
| 06:30:00 | *** finbrein has joined #openmrs |
| 06:33:02 | *** djazayeri1 has joined #openmrs |
| 06:34:37 | *** djazayeri has quit IRC |
| 06:49:40 | *** sunbiz has joined #openmrs |
| 06:49:40 | *** ChanServ sets mode: +v sunbiz |
| 06:49:45 | *** sunbiz has left #openmrs |
| 07:04:10 | *** dkayiwa has joined #openmrs |
| 07:07:16 | <finbrein> dkayiwa: on building the openmrs-webapp and starting the jetty server, what about the client |
| 07:07:36 | <dkayiwa> finbrein: client is the browser |
| 07:08:33 | <finbrein> ok, the weblink |
| 07:08:45 | <dkayiwa> yup |
| 07:08:57 | <finbrein> what's the pattern? |
| 07:09:17 | <dkayiwa> you just point your browser to the url |
| 07:09:35 | <finbrein> what's the url pattern? |
| 07:09:40 | <finbrein> url? |
| 07:10:42 | <dkayiwa> after running the server, url is something like http://localhost:8080/openmrs |
| 07:14:34 | <finbrein> i got java.lang.NullPointerException in eclipse with http://localhost:8080/openmrs/initialsetup entered to the browser top box. Warning flagged for parameter" /openmrs/initialsetup" |
| 07:22:59 | <finbrein> this line printed in console "2011-11-11 09:15:51.456::INFO: Started SelectChannelConnector@0.0.0.0:8080" before "Started Jetty Server". I think it's strange with the 0.0.0.0. I am thinking it should be localhost or 127.0.0.1 |
| 07:23:27 | <dkayiwa> you can ignore that value |
| 07:23:38 | <dkayiwa> as long as you have the initial setup page |
| 07:31:11 | <finbrein> ok, i am trying to get it to run still. |
| 07:31:13 | <finbrein> thx |
| 07:42:27 | <finbrein> In WEB-INF, I've got "openmrs.js" file, Is it not weird? |
| 07:56:13 | <dkayiwa> ignore it for now |
| 08:13:51 | *** robbyoconnor has joined #openmrs |
| 08:13:51 | *** ChanServ sets mode: +v robbyoconnor |
| 08:16:31 | <finbrein> dkayiwa: by the way, if i want to run webapp with tomcat and not jetty, can i use "tomcat:run" as the goal? |
| 08:16:34 | <surangak_> robbyoconnor, this is very late in your time right ? |
| 08:33:11 | *** dkayiwa has quit IRC |
| 09:13:12 | *** upul` has quit IRC |
| 09:31:23 | *** upul` has joined #openmrs |
| 09:31:23 | *** ChanServ sets mode: +v upul` |
| 09:40:09 | *** djazayeri1 has quit IRC |
| 09:45:35 | *** dkayiwa has joined #openmrs |
| 09:45:49 | <dkayiwa> finbrein: sorry i got diconnected |
| 09:46:17 | <finbrein> no problem |
| 09:49:58 | <finbrein> can i use "tomcat:run" as the goal to run the webapp on Tomcat. The current documentation uses "jetty:run" using Jetty to run the app. |
| 09:50:53 | <dkayiwa> finbrein: not at the moment |
| 09:51:04 | <finbrein> only jetty? |
| 09:52:13 | <dkayiwa> yes |
| 09:53:26 | <finbrein> why do we have tomcat in the documentation? I guess the document should be modified to do exactly what it should do. |
| 09:53:30 | <finbrein> I believe |
| 09:53:54 | <dkayiwa> which page are you looking at |
| 09:56:56 | <finbrein> https://wiki.openmrs.org/display/docs/Step+by+Step+Installation+for+Developers |
| 09:56:57 | <OpenMRSBot> <http://ln-s.net/8_PW> (at wiki.openmrs.org) |
| 09:58:13 | <finbrein> Option: Tomcat section near the foot of the page |
| 09:59:01 | <finbrein> Optional: Tomcatsection |
| 09:59:07 | <finbrein> Optional: Tomcat section |
| 09:59:59 | <dkayiwa> yes you can still use tomcat instead of jetty, but not in the same way |
| 10:00:26 | <dkayiwa> in otherwards, as of now, you can use tomcat but not with "tomcat:run" |
| 10:01:07 | <dkayiwa> jetty is the currently maven built in one we can run with jetty:run |
| 10:01:25 | <dkayiwa> with tomcat, you would have to do some more work than just that |
| 10:01:44 | <finbrein> i go with jetty for now |
| 10:02:18 | <dkayiwa> yes if you do not want to spend time figuring out what it would take you to do it using tomcat |
| 10:13:48 | <dkayiwa> hi surangak_ |
| 10:14:39 | <surangak_> dkayiwa, heloooo |
| 10:14:54 | <dkayiwa> surangak_: have you run trunk of recent |
| 10:15:24 | <surangak_> dkayiwa, mm.. afraid I havent, I've been working with 1.8.2 over the past two weeks :( |
| 10:15:38 | <dkayiwa> ok |
| 10:15:50 | <surangak_> sorry I couldnt help with that :( |
| 10:16:02 | <dkayiwa> no problem :) |
| 10:40:23 | *** surangak_ has quit IRC |
| 11:27:24 | *** upul` has left #openmrs |
| 12:14:07 | *** dkayiwa has quit IRC |
| 12:14:58 | *** dkayiwa has joined #openmrs |
| 12:42:33 | *** dkayiwa_ has joined #openmrs |
| 12:44:29 | *** dkayiwa has quit IRC |
| 12:44:30 | *** dkayiwa_ is now known as dkayiwa |
| 12:56:25 | *** kishoreyekkanti has joined #openmrs |
| 13:15:51 | *** downeym has joined #openmrs |
| 13:15:51 | *** OpenMRSBot sets mode: +o downeym |
| 13:15:51 | *** ChanServ sets mode: +o downeym |
| 13:23:16 | *** r-friedman has joined #openmrs |
| 13:24:09 | <r-friedman> wluyima: hi wyclif got a minute? |
| 13:24:30 | *** wluyima has quit IRC |
| 13:25:42 | <r-friedman> hi dkayiwa got a minute? |
| 13:25:48 | <dkayiwa> sure |
| 13:26:45 | <r-friedman> how do we do join tables? do we put in all the audit fields? do we need a DAO object, if so what does it extend? or does hibernate handle it all? |
| 13:27:14 | <dkayiwa> hibernate does the join for us |
| 13:27:33 | <dkayiwa> via the DAO hibernate implementation class |
| 13:28:32 | <r-friedman> does the DAO class (and table) have an id field? |
| 13:29:04 | <r-friedman> does it have audit info? |
| 13:29:27 | <dkayiwa> the DAO does not tie to any table |
| 13:29:36 | <dkayiwa> and so the DAO has no id field |
| 13:29:54 | <r-friedman> ok, i think i misunderstood you |
| 13:29:55 | <dkayiwa> Instead the DAO persists a domanin (entity) object, which then has the id field |
| 13:30:13 | <dkayiwa> ok |
| 13:30:42 | <r-friedman> so we have Table1, Table2, and the join table between them |
| 13:31:07 | <dkayiwa> ok |
| 13:31:10 | <r-friedman> Table1 and Table2 in their hibernate have sets with many-to-many that reference eachother |
| 13:31:28 | <r-friedman> the only reference to the join table is in the set directive |
| 13:31:36 | <r-friedman> on both sides |
| 13:32:16 | <r-friedman> so we know that join table has 2 fields, table1_id and table2_id |
| 13:32:21 | *** james_regen has joined #openmrs |
| 13:32:21 | *** ChanServ sets mode: +v james_regen |
| 13:32:29 | <r-friedman> and hibernate knows it too |
| 13:32:35 | <dkayiwa> yes the parent Object (for Table1) has a set field for (Table2) objects for a one to many |
| 13:33:27 | <r-friedman> and vice versa (they're both sets and its many-to-many |
| 13:33:50 | <r-friedman> so the first question is sort of a policy question |
| 13:34:09 | <dkayiwa> the child object (Table2) does not have a set field for the parent |
| 13:34:31 | <dkayiwa> infact it may not even be aware of the parent (if you chose) |
| 13:35:21 | <dkayiwa> but if you chose, then if may |
| 13:35:27 | <dkayiwa> an example is Form and FormField |
| 13:35:30 | <r-friedman> it's not really a parent child (one-to-many), it's many to many, like the relation between person and itself for relationships |
| 13:36:06 | <r-friedman> now for relationships, the join table also has information -- the relationship type |
| 13:36:06 | <dkayiwa> where Form has Set<FormField> formFields and FormField has a Form form field |
| 13:36:44 | <r-friedman> but a one-to-many can be done without a join table and we typically don't use a join table |
| 13:36:56 | <dkayiwa> correct |
| 13:37:07 | <r-friedman> many-to-many requires a join table and it's the join table that concerns me |
| 13:37:13 | <dkayiwa> ok |
| 13:37:50 | <r-friedman> assuming it's a pure join table (carries no data) |
| 13:37:59 | <r-friedman> does it have an id field? |
| 13:38:10 | <r-friedman> does it have audit fields (created by etc.)? |
| 13:38:26 | <dkayiwa> it has an id field |
| 13:38:40 | <dkayiwa> and it may also have audit fields |
| 13:38:58 | <dkayiwa> to keep track of relationship changes audit |
| 13:40:03 | <r-friedman> right, but the only changes that can occur are voiding/retiring a table1 record or a table2 record |
| 13:40:22 | <r-friedman> the join table is never directly modified |
| 13:41:06 | <dkayiwa> actually i look at the join table to trac the relationship modifications |
| 13:41:24 | <dkayiwa> that would be different from table1 or table2 |
| 13:41:27 | <dkayiwa> separately |
| 13:41:36 | <r-friedman> well, that's true in relationship because it's carrying data |
| 13:42:02 | <r-friedman> wait |
| 13:42:33 | <r-friedman> so you're saying you can delete a relationship without modifying either of the data tables? |
| 13:42:51 | <dkayiwa> correct |
| 13:43:08 | <dkayiwa> and the relationship table then keeps track of that information |
| 13:43:19 | <dkayiwa> eg. marriage or divorce date |
| 13:43:42 | <r-friedman> but that leaves voided relationships in the table which have to be checked for |
| 13:43:51 | <dkayiwa> correct |
| 13:44:40 | <r-friedman> so do the join tables extend baseopenmrsmetadata or data? |
| 13:45:09 | <dkayiwa> i would make it extend data |
| 13:45:29 | <dkayiwa> for i do not look at the relationship between the two as metadata |
| 13:46:10 | <r-friedman> that's what i would say too, but voided will eventually become a physical delete while retired wont |
| 13:46:31 | <dkayiwa> void is for data while retire is for metadata |
| 13:46:37 | <r-friedman> yeah |
| 13:47:19 | <r-friedman> so i think if t1 is table2's collection of t1 objects |
| 13:47:57 | <r-friedman> you could actually do t1.add x where x is a t2 object |
| 13:48:13 | <r-friedman> and hibernate would take care of the table update |
| 13:48:26 | <dkayiwa> ok |
| 13:48:28 | <r-friedman> but if we're going to mung around with audit informaiton |
| 13:48:47 | <r-friedman> we can't do that, we have to use an api call to write the db explicitly |
| 13:49:18 | <dkayiwa> ok |
| 13:49:48 | <r-friedman> and that means we need a DAO object for the join table, right? |
| 13:50:44 | <dkayiwa> not necesarily |
| 13:50:58 | <dkayiwa> actually i would not create a separate DAO for the join table |
| 13:51:12 | <r-friedman> just reference it in HQL? |
| 13:51:27 | <dkayiwa> yes |
| 13:52:05 | <dkayiwa> boundary as to when to create another DAO is about a group of related db services |
| 13:52:24 | <r-friedman> ok, i think we are not communicating again |
| 13:52:34 | <dkayiwa> looks like |
| 13:53:05 | <r-friedman> when i say DAO object, I don't mean an object that provides api methods, i mean the object that contains the table field getters and setters |
| 13:53:21 | <dkayiwa> oh i see!!! |
| 13:53:24 | <dkayiwa> now i get you |
| 13:54:19 | <r-friedman> I think from what we have been saying that we need one of these for the join table and it extends data |
| 13:54:42 | <dkayiwa> ok |
| 13:54:51 | <r-friedman> and that we need an api call to make and break relations which uses that object and maintains the audit info |
| 13:55:19 | *** burke has joined #openmrs |
| 13:55:19 | *** ChanServ sets mode: +o burke |
| 13:55:28 | <dkayiwa> ok |
| 13:55:52 | *** burke has quit IRC |
| 13:56:05 | <r-friedman> but what worries me is, if we have the collection of t2's in t1, had we just done an add to it, it would now be up to date |
| 13:56:23 | <r-friedman> but if we mung around with the join table's DAO, the collections might not update |
| 13:56:33 | <dkayiwa> ok |
| 13:57:57 | <r-friedman> do we know that the api method will be reflected in the t1 collection automatically or does the collection ahve to be refreshed? |
| 13:59:20 | <dkayiwa> i think it may be auto refreshed. not sure though |
| 13:59:39 | <r-friedman> hmmmm |
| 14:00:41 | <r-friedman> ok, at least i know how to make the join table |
| 14:00:48 | <dkayiwa> ok |
| 14:00:56 | <r-friedman> thanks much |
| 14:01:05 | <dkayiwa> yo welcome |
| 14:09:55 | *** rafa has joined #openmrs |
| 14:10:17 | *** rafa has quit IRC |
| 14:10:30 | *** rafa has joined #openmrs |
| 14:10:31 | *** ChanServ sets mode: +v rafa |
| 14:23:40 | *** wluyima has joined #openmrs |
| 14:29:30 | *** djazayeri has joined #openmrs |
| 14:29:30 | *** ChanServ sets mode: +o djazayeri |
| 14:34:41 | *** dkayiwa has quit IRC |
| 14:37:57 | *** dawn_ has joined #openmrs |
| 14:41:17 | *** dawn_ has left #openmrs |
| 14:41:21 | *** dawn_ has joined #openmrs |
| 14:41:21 | *** ChanServ sets mode: +v dawn_ |
| 15:05:27 | <djazayeri> good morning rafa, wluyima, dkayiwa |
| 15:05:33 | <djazayeri> (no dkayiwa I see) |
| 15:05:59 | <rafa> hey |
| 15:06:18 | <djazayeri> rafa: last day in the office in boston? |
| 15:06:26 | *** dawn_ has quit IRC |
| 15:06:32 | <rafa> djazayeri: yesterday was my last day |
| 15:06:38 | <rafa> djazayeri: today is holiday |
| 15:06:43 | <rafa> djazayeri: office is closed |
| 15:08:20 | <wluyima> djazayeri, hi |
| 15:08:45 | <wluyima> rafa, enjoy your vacation |
| 15:08:56 | <downeym> wluyima: can we do anything to shorten the name of this page? https://wiki.openmrs.org/display/RES/Improved+release+testing+by+loading+partial+production+data+into+a+Standalone |
| 15:09:22 | <rafa> wluyima: it's not really vacation :) I'm working. |
| 15:09:40 | <djazayeri> downeym: I named that page |
| 15:09:44 | <djazayeri> is it really a problem that it's long? |
| 15:10:35 | <djazayeri> rafa: okay, I remember hearing that the office was closed |
| 15:10:49 | <djazayeri> Oh well, we'll keep working in the salt mine |
| 15:11:06 | <downeym> djazayeri: just wondered if it could be more concise :) |
| 15:12:15 | <djazayeri> downeym: It's a fairly specific page, and one that will be abandoned after this sprint, so I intend to spend 0 more seconds thinking about its name. :-) |
| 15:12:22 | <djazayeri> rafa: want to report? |
| 15:12:31 | <rafa> djazayeri: sure |
| 15:12:53 | <rafa> djazayeri: I'm working on limiting the size of data we export |
| 15:13:05 | <rafa> djazayeri: it's tedious |
| 15:13:17 | <djazayeri> tedious but straightforward? |
| 15:13:21 | <djazayeri> or tedious and complex? |
| 15:13:30 | <rafa> djazayeri: seems only tedious so far |
| 15:13:37 | <djazayeri> okay, that's good |
| 15:14:15 | <djazayeri> And I guess that will take you the rest of the day? |
| 15:14:23 | <rafa> djazayeri: yes |
| 15:15:11 | <djazayeri> and no blockers |
| 15:15:16 | <rafa> no blockers |
| 15:16:00 | <djazayeri> okay, wluyima? |
| 15:16:07 | <djazayeri> I see you've been creating tickets. |
| 15:16:11 | <rafa> djazayeri: just a moment |
| 15:16:11 | <djazayeri> Thanks for doing this, by the way! |
| 15:16:21 | <djazayeri> okay, wluyima, wait for rafa then |
| 15:16:33 | <rafa> djazayeri: let me check again my assumption |
| 15:17:09 | <finbrein> Could not create connection to database server. What to do? |
| 15:17:15 | <rafa> djazayeri: the goal is to export all tables and data except patient data in a few hardcoded tables |
| 15:17:37 | <djazayeri> rafa: for core, yes, that's definitely the case |
| 15:17:44 | <djazayeri> for modules, I guess it's the same |
| 15:18:03 | <djazayeri> but we'll need some way to determine which module tables are patient data |
| 15:18:14 | <djazayeri> I guess it could be hardcoded, though that will get very tedious |
| 15:18:24 | <wluyima> ok |
| 15:18:45 | <djazayeri> maybe we can assume that any table with a "patient_id" column is patient data? |
| 15:19:00 | *** rafa_ has joined #openmrs |
| 15:19:00 | *** ChanServ sets mode: +v rafa_ |
| 15:19:37 | <rafa_> djazayeri: the thing is that this approach fail if module tables reference core patient data that we did not include |
| 15:19:50 | *** dawn_ has joined #openmrs |
| 15:19:50 | *** ChanServ sets mode: +v dawn_ |
| 15:19:56 | <rafa_> djazayeri: is that all right? |
| 15:20:26 | <rafa_> (lost connection for a moment) |
| 15:20:51 | <djazayeri> rafa_: while you were gone, I proposed that we assume any table with a "patient_id" column is patient data |
| 15:21:21 | <rafa_> djazayeri: what about "encounter_id", etc.? |
| 15:21:21 | <djazayeri> and thus treating it specially in the hardcoded way |
| 15:21:42 | *** rafa has quit IRC |
| 15:21:53 | <rafa_> ping |
| 15:21:57 | <djazayeri> hopefuly patient_id and encounter_id will be enough |
| 15:22:33 | <rafa_> djazayeri: you realize that it's not a very reliable approach... |
| 15:23:18 | <djazayeri> rafa_: but a more reliable approach would be 1000% more work, right? |
| 15:23:30 | <rafa_> djazayeri: yes |
| 15:24:12 | <djazayeri> Could you build in the ability for us to hardcode a list of module tables to treat specially, but for now that's an empty list? |
| 15:24:17 | <djazayeri> or is that not even worth it at this point? |
| 15:25:00 | <djazayeri> rafa_: anyway, I'm aware that it's not 100% reliable, but I don't have any better suggestions at this point. |
| 15:25:00 | <rafa_> djazayeri: I'll see how I can fit that in my current idea |
| 15:25:34 | <rafa_> okay thanks |
| 15:26:04 | <rafa_> wluyima: go ahead |
| 15:26:33 | <wluyima> yesterday: |
| 15:26:33 | <wluyima> -Made some fixes in the installation and removed unused code |
| 15:26:33 | <wluyima> -dev call |
| 15:26:33 | <wluyima> -Fixed bug when fetching/installing modules |
| 15:26:33 | <wluyima> -Creatd a couple of tickets TRUNK-2851, TRUNK-2852, TRUNK-2853, TRUNK-2854 |
| 15:26:34 | <wluyima> -Code review of Rafal's ticket for importing test data |
| 15:26:36 | <wluyima> today: |
| 15:26:38 | <wluyima> -Fix authentication to work, involves making changes in TRUNK-2838 and RELTEST-4 |
| 15:26:40 | <wluyima> -Other sprint tickets |
| 15:27:25 | <rafa_> wluyima: I think it's best to create a new ticket for authentication |
| 15:28:17 | <djazayeri> rafa_: you mean instead of modifying an existing ticket? |
| 15:28:24 | <rafa_> yes |
| 15:28:31 | <wluyima> rafa_, which ticket? |
| 15:28:57 | <rafa_> wluyima: i was refering to Fix authentication to work, involves making changes in TRUNK-2838 and RELTEST-4 |
| 15:29:28 | <wluyima> rafa_, i think we created TRUNK-2838 and RELTEST- for this task |
| 15:30:03 | <rafa_> wluyima: ohh sorry |
| 15:30:07 | <rafa_> wluyima: you're right |
| 15:30:16 | <rafa_> wluyima: I thought it's something different |
| 15:30:20 | <wluyima> rafa_, it is just that i made a partial commit for TRUNK-2838 just to capture them but not send them |
| 15:31:01 | <wluyima> rafa_, now i need to make sure they are sent to the server and edit the http requests for modules and test data |
| 15:31:03 | <rafa_> wluyima: okay nevermind :) |
| 15:31:30 | <djazayeri> wluyima: blockers? |
| 15:31:45 | <finbrein> hey rafa_: can you advise on making connection to the database from the webapp. |
| 15:31:46 | *** kishoreyekkanti has quit IRC |
| 15:31:54 | *** chopin has joined #openmrs |
| 15:32:34 | <wluyima> no blockers, rafa_, djazayeri how do you feel about making the page for requesting production url, openmrs username and password one step instead of 2 |
| 15:33:01 | <rafa_> wluyima: I feel it'd be better :) |
| 15:33:04 | <djazayeri> wluyima: I guess that's fine. |
| 15:33:10 | <wluyima> ok |
| 15:33:21 | <djazayeri> Burke and I were thinking that first you ask for the url, and test that to make sure it exists and has the module running |
| 15:33:37 | <rafa_> finbrein: what do you mean? what is it that you're trying to achieve? |
| 15:33:52 | <djazayeri> but I guess there's no reason we couldn't also ask for username and password on that page, assuming they'll get it right |
| 15:33:52 | <wluyima> djazayeri, we can capture all but just store the username and password for later use when needed |
| 15:33:56 | <chopin> if someone has a chance, please verify I'm not crazy in re: TRUNK-2857 |
| 15:33:57 | <chopin> !TRUNK-2857 |
| 15:33:58 | <OpenMRSBot> chopin: Error: "TRUNK-2857" is not a valid command. |
| 15:34:03 | <chopin> !ticket TRUNK-2857 |
| 15:34:04 | <OpenMRSBot> chopin: [#TRUNK-2857] Improper table constraint of form.encounter_type to users.user_id - OpenMRS JIRA - https://tickets.openmrs.org/browse/TRUNK-2857 |
| 15:34:18 | <djazayeri> My report |
| 15:34:24 | <wluyima> djazayeri, ok |
| 15:34:45 | <djazayeri> Thursday: |
| 15:34:45 | <djazayeri> * Implementers call |
| 15:34:45 | <djazayeri> * Dev call |
| 15:34:45 | <djazayeri> * Leadership call |
| 15:34:45 | <djazayeri> * almost finished: STAND-32 - Improved build and package process for standalone |
| 15:34:46 | <djazayeri> * on hold: STAND-31 and STAND-17 (one-time prompt for standalone configuration on initial startup) |
| 15:34:47 | <djazayeri> Friday: |
| 15:34:47 | <djazayeri> * finish STAND-32 - Improved build and package process for standalone |
| 15:34:48 | <djazayeri> * try to finish STAND-31 and STAND-17 (one-time prompt for standalone configuration on initial |
| 15:35:30 | <wluyima> djazayeri, great |
| 15:35:37 | <finbrein> just getting started and i have run the openmrs webapp. But connection to the database fails which is ok. The webapp should be configured to work with the mysql databse i installed on my local machine. |
| 15:35:41 | <wluyima> djazayeri, when do you hope to be done with these for testing |
| 15:35:52 | <djazayeri> wluyima: sometime today |
| 15:35:56 | <wluyima> djazayeri, cool |
| 15:36:15 | <wluyima> djazayeri, because out goal to day is to have something functional end to end |
| 15:36:59 | <djazayeri> wluyima: exactly |
| 15:37:02 | <wluyima> djazayeri, i hope to work on the issue of standalone not asking for databse credentials too |
| 15:37:09 | <rafa_> finbrein: you need to deploy war and you'll see installation wizard when you can enter connection details for your mysql installation |
| 15:37:34 | <djazayeri> wluyima: great |
| 15:37:51 | *** rafa_ has quit IRC |
| 15:38:04 | <finbrein> rafa_: how? |
| 15:38:42 | <djazayeri> wluyima, rafa_: okay, done scrumming, back to work! |
| 15:38:52 | <djazayeri> (oops, rafa lost connection again) |
| 15:39:21 | <dawn_> thnx for the updates! |
| 15:39:29 | <wluyima> djazayeri, ok, talk to you later |
| 15:42:08 | <finbrein> i am using jetty not tomcat |
| 15:55:12 | *** chopin has quit IRC |
| 15:59:35 | *** dawn_ has quit IRC |
| 16:04:43 | *** dawn_ has joined #openmrs |
| 16:04:43 | *** ChanServ sets mode: +v dawn_ |
| 16:06:34 | *** chopin has joined #openmrs |
| 16:25:41 | *** james_regen has quit IRC |
| 16:39:15 | <finbrein> can someone help pls? |
| 16:40:11 | <finbrein> i am in the "Step by step installation for developers" |
| 16:41:58 | <finbrein> I have installed the webapp but having issues connecting to the Jetty server (started) from the web browser. During run, there is an error whereby connection to mysql database failed. |
| 16:42:12 | <finbrein> I would appreciate an answer. thx. |
| 16:45:58 | *** deadpool has joined #openmrs |
| 16:47:43 | *** kishoreyekkanti has joined #openmrs |
| 16:55:29 | *** srinivasa has joined #openmrs |
| 16:57:48 | *** surangak has joined #openmrs |
| 17:01:44 | <downeym> finbrein: is mysqld running? |
| 17:01:59 | <finbrein> yeson port 3306 |
| 17:02:42 | <finbrein> yes |
| 17:05:18 | <downeym> what is the specific error message exactly? |
| 17:08:17 | <finbrein> i can send the full message to dev@openmrs.org now. There are many lines in there. |
| 17:11:15 | <downeym> pastebin.com is fine too |
| 17:12:46 | <downeym> finbrein: looks like you may have supplied the wrong mysql root password during the openmrs initial setup |
| 17:13:38 | <finbrein> downeym: what is the right password? |
| 17:14:11 | <downeym> finbrein: whatever password you gave root when you installed mysql :) http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-windows |
| 17:14:13 | <OpenMRSBot> <http://ln-s.net/3SZk> (at dev.mysql.com) |
| 17:14:52 | <finbrein> downeym: link to pastebin, http://pastebin.com/Q3YB6UGz |
| 17:15:16 | <finbrein> downeym: i used test |
| 17:15:43 | <finbrein> downeym: i used "test" as the password. What must I do now? |
| 17:17:25 | <downeym> finbrein: openmrs asks for the user id and password for this user at the beginning of its initial setup. |
| 17:17:41 | *** downeym sets mode: +v chopin |
| 17:17:44 | *** downeym sets mode: +v wluyima |
| 17:17:47 | *** downeym sets mode: +v surangak |
| 17:17:52 | *** downeym sets mode: +v r-friedman |
| 17:17:55 | *** downeym sets mode: +v kishoreyekkanti |
| 17:19:34 | <finbrein> downeym: there are "user" and "developer" setup. I am using the developer guide, starting from here - https://wiki.openmrs.org/display/docs/Step+by+Step+Installation+for+Developers |
| 17:19:35 | <OpenMRSBot> <http://ln-s.net/8_PW> (at wiki.openmrs.org) |
| 17:20:14 | <finbrein> downeym: openmrs hasn't ask for username and password. |
| 17:20:28 | *** dawn_ has quit IRC |
| 17:21:49 | *** chopin_ has joined #openmrs |
| 17:21:56 | <downeym> Hi chopin_ and welcome to the #openmrs IRC channel. |
| 17:24:05 | <finbrein> downeym: what do you think? |
| 17:24:11 | *** chopin has quit IRC |
| 17:28:17 | <deadpool> finbrein: did you get to see the initial setup? |
| 17:29:44 | <deadpool> mnunez: did you get your form save thing worked out? |
| 17:29:47 | <finbrein> ddeadpool: i am not sure. What's the link for the initial setup you are referring to? |
| 17:30:00 | <finbrein> deadpool: i am not sure. What's the link for the initial setup you are referring to? |
| 17:30:33 | *** mnunez has quit IRC |
| 17:30:43 | <deadpool> finbrein: you installed java and mysql right |
| 17:30:59 | <deadpool> so after you start the jetty server i |
| 17:31:05 | <finbrein> deadpool: yes |
| 17:31:12 | <deadpool> you go to localhost:8080/openmrs |
| 17:31:36 | <deadpool> once you go there it will ask you for information to create openmrs-runtime.properties |
| 17:31:44 | <finbrein> deadpool: i have done that and i got something like this - http://pastebin.com/Q3YB6UGz |
| 17:31:45 | <deadpool> like user/pass for mysql |
| 17:33:03 | <deadpool> finbrein: hmmm try going to localhost:8080/openmrs and see what you get |
| 17:36:44 | <finbrein> deadpool: on running "localhost:8080/openmrs" in the browser brox, i get "http://localhost:8080/openmrs/initialsetup" and then the server crashes. |
| 17:37:14 | *** dawn_ has joined #openmrs |
| 17:37:14 | *** ChanServ sets mode: +v dawn_ |
| 17:38:20 | <finbrein> deadpool: prior to the line where the server crashes, their is an error connecting to the database. |
| 17:39:11 | <deadpool> that seems funny cause you shouldn't be connecting to the database yet |
| 17:39:22 | <deadpool> can you connect to the database on the command line? |
| 17:39:39 | <deadpool> or gui what not? |
| 17:40:05 | <deadpool> are you on linux or windows or mac? |
| 17:40:46 | <finbrein> deadpool: yes i can login with the "test" password using the MySQL client |
| 17:41:06 | <finbrein> deadpool: WIndows 7 |
| 17:41:35 | <deadpool> finbrein: can you locate where your openmrs-runtimes.properties is located |
| 17:41:43 | <deadpool> like what is in it |
| 17:42:11 | <deadpool> delete it if you find it and try again |
| 17:43:00 | <finbrein> deadpool:"openmrs-runtimes.properties" is not in the project. Is it installed as part of the openmrs project by default? |
| 17:43:56 | <deadpool> yeah it is but i think somehow it got created and it is using that to start openmrs and the information in there is not correct |
| 17:44:03 | <finbrein> deadpool: i got this warning "WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2437) |2011-11-11 19:35:47,556| Unable to find a runtime properties file at H:\AAA_STUFF\OpenMRS\workspaceOpenMRS\openmrs\webapp\openmrs-runtime.properties" |
| 17:44:23 | <deadpool> so it looks in multiple places |
| 17:44:33 | <deadpool> search for it |
| 17:44:43 | <deadpool> win7 should have a search function right? |
| 17:48:11 | <finbrein> deadpool: I have searched and "openmrs-runtime.properties" does not exist on my PC |
| 17:48:58 | <deadpool> finbrein: are you running openmrs from eclipse? |
| 17:49:24 | <deadpool> finbrein: openmrs-runtime.properties is a hidden file |
| 17:49:26 | <finbrein> deadpool: yes Eclipse Helios |
| 17:49:30 | <deadpool> you need to search hidden files |
| 17:49:59 | <finbrein> deadpool: ok |
| 17:56:18 | <finbrein> deadpool: it doesn't exist on pc. I have installed Eclipse on an external HDD. It doesn't exist there either. |
| 17:57:03 | <deadpool> hmmm... finbrein i am not sure about windows cause i use linux and i don't use eclipse so i don't know but |
| 17:57:14 | <deadpool> did you do an mvn build and then mvn jetty:run |
| 17:57:35 | <finbrein> deadpool: yes I did |
| 17:57:38 | <deadpool> ok |
| 17:58:04 | <deadpool> hmmm... the next thing i can think of is maybe try creating the file |
| 17:58:15 | <finbrein> deadpool: i am using the Base Directory - "${workspace_loc:/openmrs-webapp}" |
| 17:58:48 | <deadpool> finbrein: did you build from the webapp directory or the previous directory? |
| 17:59:40 | <finbrein> deadpool: what do you mean by previous directory? |
| 18:00:08 | <deadpool> the trunk directory where webapps and src and all the other directories are located |
| 18:02:00 | <finbrein> deadpool: i think you mean, the "openmrs" project. Yes, I built the parent project and automatically, all others including openmrs-webapp project should be built since they are all included in the "openmrs" project. |
| 18:02:27 | <deadpool> yeah |
| 18:03:17 | <deadpool> finbrein: now all i can think of is to create the openmrs-runtime.properties |
| 18:04:11 | <finbrein> deadpool: previously, you stated that the "$openmrs-runtimes.properties" is created after running "localhost:8080/openmrs" in the browser. |
| 18:04:24 | <finbrein> deadpool: can you clarify? |
| 18:05:40 | <finbrein> deadpool: "openmrs-runtime.properties" file |
| 18:06:02 | <deadpool> so once you build and deploy the war you navigate to localhost:8080 and then you will get a initialsetup page where it will ask for your mysql database name, user/pass to access the database and user/pass for openmrs |
| 18:06:25 | <deadpool> and then it will install all the tables openmrs needs once it has all those |
| 18:06:36 | <deadpool> for some reason your build thinks it has all that |
| 18:06:46 | <deadpool> did you already create an openmrs database? |
| 18:09:11 | <finbrein> deadpool: no |
| 18:10:08 | <finbrein> deadpool: do i create an openmrs database? and how to deploy the war file? |
| 18:10:38 | <deadpool> no there is something wrong fundamentally of which i am not seeing |
| 18:11:01 | <deadpool> finbrein: do an mvn clean |
| 18:11:11 | <deadpool> and do the build again and see if it works |
| 18:12:20 | *** nickwilkie has quit IRC |
| 18:12:22 | <finbrein> deadpool: ok |
| 18:13:26 | <deadpool> if that doesn't work maybe reintstall mysql or something and try again and if that doesn't work we should get djazayeri or downeym back in |
| 18:17:36 | *** dawn_ has quit IRC |
| 18:19:13 | <finbrein> deadpool: i'll try that again |
| 18:19:22 | <finbrein> deadpool: thx |
| 18:21:58 | *** dawn_ has joined #openmrs |
| 18:21:58 | *** ChanServ sets mode: +v dawn_ |
| 18:25:28 | *** kishoreyekkanti has quit IRC |
| 18:28:45 | *** dawn__ has joined #openmrs |
| 18:28:45 | *** ChanServ sets mode: +v dawn__ |
| 18:28:45 | *** dawn_ has quit IRC |
| 18:28:46 | *** dawn__ is now known as dawn_ |
| 18:29:07 | <deadpool> finbrein: lemme know how it goes |
| 18:29:32 | <finbrein> deadpool: ok |
| 18:34:30 | *** mnunez has joined #openmrs |
| 18:36:32 | *** surangak has quit IRC |
| 18:36:32 | *** dawn_ has quit IRC |
| 18:36:33 | *** dawn__ has joined #openmrs |
| 18:36:33 | *** ChanServ sets mode: +v dawn__ |
| 18:37:50 | *** dawn__ has quit IRC |
| 18:37:58 | *** surangak has joined #openmrs |
| 18:58:17 | *** rafa has joined #openmrs |
| 18:58:17 | *** ChanServ sets mode: +v rafa |
| 19:02:30 | *** rafa has quit IRC |
| 19:03:47 | *** surangak has quit IRC |
| 19:07:30 | *** r-friedman has quit IRC |
| 19:14:40 | *** nickwilkie has joined #openmrs |
| 19:14:52 | *** chopin_ has quit IRC |
| 19:17:58 | *** nickwilkie has quit IRC |
| 19:18:08 | *** nickwilkie has joined #openmrs |
| 19:18:28 | *** chopin has joined #openmrs |
| 19:19:46 | *** nickwilkie has quit IRC |
| 19:24:01 | *** mnunez has quit IRC |
| 19:27:54 | *** nribeka has joined #openmrs |
| 19:27:54 | *** ChanServ sets mode: +v nribeka |
| 19:41:28 | *** finbrein has quit IRC |
| 19:53:27 | *** ChanServ sets mode: +v chopin |
| 19:54:28 | <downeym> Hi chopin and welcome to the #openmrs IRC channel. |
| 19:54:53 | <chopin> hi downeym and thanks |
| 20:22:54 | *** srinivasa has quit IRC |
| 20:53:10 | *** rafa has joined #openmrs |
| 20:53:10 | *** ChanServ sets mode: +v rafa |
| 20:53:30 | *** rafa has quit IRC |
| 21:24:02 | *** chopin has quit IRC |
| 22:02:00 | *** finbrein has joined #openmrs |
| 22:27:53 | *** nribeka has quit IRC |
| 22:59:20 | *** morristic has joined #openmrs |
| 23:00:14 | <morristic> Hello everyone. |
| 23:23:25 | *** downeym has quit IRC |
| 23:36:27 | *** mnunez has joined #openmrs |
| 23:45:05 | *** wluyima has quit IRC |
| 23:47:51 | *** mnunez has quit IRC |
| 23:58:32 | *** mnunez has joined #openmrs |