| 00:00:22 | *** r0bby has joined #openmrs |
| 00:00:22 | *** ChanServ sets mode: +v r0bby |
| 00:24:14 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11467]: visitscheduler: adding means to void or modify an appointment. <http://dev.openmrs.org/changeset/11467> |
| 00:39:59 | *** atomicturtle has joined #openmrs |
| 01:08:56 | *** atomicturtle has quit IRC |
| 01:10:48 | *** atomicturtle has joined #openmrs |
| 01:14:52 | *** jmiranda has quit IRC |
| 01:14:52 | *** Echidna has quit IRC |
| 01:14:52 | *** atomicturtle has quit IRC |
| 01:14:52 | *** jacobb has quit IRC |
| 01:14:52 | *** r0bby has quit IRC |
| 01:14:52 | *** njero has quit IRC |
| 01:40:42 | *** jmiranda has joined #openmrs |
| 01:40:42 | *** jacobb has joined #openmrs |
| 01:40:42 | *** Echidna has joined #openmrs |
| 01:40:42 | *** njero has joined #openmrs |
| 01:40:42 | *** r0bby has joined #openmrs |
| 01:40:42 | *** atomicturtle has joined #openmrs |
| 01:40:42 | *** irc.freenode.net sets mode: +ovv jmiranda njero r0bby |
| 01:46:30 | *** jmiranda has quit IRC |
| 01:46:30 | *** Echidna has quit IRC |
| 01:46:30 | *** atomicturtle has quit IRC |
| 01:46:30 | *** jacobb has quit IRC |
| 01:46:30 | *** njero has quit IRC |
| 01:46:30 | *** r0bby has quit IRC |
| 01:50:55 | *** jmiranda has joined #openmrs |
| 01:50:55 | *** jacobb has joined #openmrs |
| 01:50:55 | *** Echidna has joined #openmrs |
| 01:50:55 | *** njero has joined #openmrs |
| 01:50:55 | *** r0bby has joined #openmrs |
| 01:50:55 | *** atomicturtle has joined #openmrs |
| 01:50:55 | *** irc.freenode.net sets mode: +ovv jmiranda njero r0bby |
| 01:54:48 | *** jmiranda has quit IRC |
| 01:54:48 | *** Echidna has quit IRC |
| 01:54:48 | *** atomicturtle has quit IRC |
| 01:54:48 | *** jacobb has quit IRC |
| 01:54:48 | *** njero has quit IRC |
| 01:54:48 | *** r0bby has quit IRC |
| 02:00:22 | *** jmiranda has joined #openmrs |
| 02:00:22 | *** jacobb has joined #openmrs |
| 02:00:22 | *** Echidna has joined #openmrs |
| 02:00:22 | *** njero has joined #openmrs |
| 02:00:22 | *** r0bby has joined #openmrs |
| 02:00:22 | *** atomicturtle has joined #openmrs |
| 02:00:23 | *** irc.freenode.net sets mode: +ovv jmiranda njero r0bby |
| 02:06:41 | *** jmiranda has quit IRC |
| 02:06:41 | *** Echidna has quit IRC |
| 02:06:41 | *** atomicturtle has quit IRC |
| 02:06:41 | *** jacobb has quit IRC |
| 02:06:41 | *** njero has quit IRC |
| 02:06:41 | *** r0bby has quit IRC |
| 02:13:59 | *** jmiranda has joined #openmrs |
| 02:13:59 | *** jacobb has joined #openmrs |
| 02:13:59 | *** Echidna has joined #openmrs |
| 02:13:59 | *** njero has joined #openmrs |
| 02:13:59 | *** r0bby has joined #openmrs |
| 02:13:59 | *** atomicturtle has joined #openmrs |
| 02:13:59 | *** irc.freenode.net sets mode: +ovv jmiranda njero r0bby |
| 02:23:06 | *** jmiranda has quit IRC |
| 02:23:06 | *** Echidna has quit IRC |
| 02:23:06 | *** atomicturtle has quit IRC |
| 02:23:06 | *** jacobb has quit IRC |
| 02:23:06 | *** njero has quit IRC |
| 02:23:06 | *** r0bby has quit IRC |
| 02:28:24 | *** jmiranda has joined #openmrs |
| 02:28:24 | *** njero has joined #openmrs |
| 02:28:24 | *** jacobb has joined #openmrs |
| 02:28:24 | *** Echidna has joined #openmrs |
| 02:28:24 | *** r0bby has joined #openmrs |
| 02:28:24 | *** atomicturtle has joined #openmrs |
| 02:28:24 | *** irc.freenode.net sets mode: +ov jmiranda r0bby |
| 02:31:57 | *** jmiranda has quit IRC |
| 02:31:57 | *** Echidna has quit IRC |
| 02:31:57 | *** atomicturtle has quit IRC |
| 02:31:57 | *** jacobb has quit IRC |
| 02:31:57 | *** njero has quit IRC |
| 02:31:57 | *** r0bby has quit IRC |
| 02:37:49 | *** upul has joined #openmrs |
| 02:37:49 | *** njero has joined #openmrs |
| 02:37:49 | *** jacobb has joined #openmrs |
| 02:37:49 | *** Echidna has joined #openmrs |
| 02:37:49 | *** r0bby has joined #openmrs |
| 02:37:49 | *** atomicturtle has joined #openmrs |
| 02:37:49 | *** irc.freenode.net sets mode: +v r0bby |
| 02:41:31 | *** njero has quit IRC |
| 02:41:36 | *** upul has quit IRC |
| 02:42:15 | *** upul has joined #openmrs |
| 02:42:15 | *** ChanServ sets mode: +v upul |
| 02:50:18 | *** upul has quit IRC |
| 02:50:18 | *** Echidna has quit IRC |
| 02:50:18 | *** atomicturtle has quit IRC |
| 02:50:18 | *** jacobb has quit IRC |
| 02:50:18 | *** r0bby has quit IRC |
| 02:52:14 | *** upul has joined #openmrs |
| 02:52:14 | *** atomicturtle has joined #openmrs |
| 02:52:14 | *** r0bby has joined #openmrs |
| 02:52:14 | *** Echidna has joined #openmrs |
| 02:52:14 | *** jacobb has joined #openmrs |
| 02:52:14 | *** irc.freenode.net sets mode: +vv upul r0bby |
| 03:03:33 | *** r0bby has quit IRC |
| 03:04:10 | *** r0bby has joined #openmrs |
| 03:04:11 | *** ChanServ sets mode: +v r0bby |
| 03:40:33 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #672 (enhancement closed): Remove exeception when stopping an already stopped task <http://dev.openmrs.org/ticket/672#comment:1> |
| 03:47:28 | *** r0bby has quit IRC |
| 03:47:28 | *** jacobb has quit IRC |
| 03:47:28 | *** atomicturtle has quit IRC |
| 03:47:28 | *** Echidna has quit IRC |
| 03:47:28 | *** upul has quit IRC |
| 04:01:59 | *** r0bby has joined #openmrs |
| 04:01:59 | *** jacobb has joined #openmrs |
| 04:01:59 | *** Echidna has joined #openmrs |
| 04:01:59 | *** atomicturtle has joined #openmrs |
| 04:01:59 | *** upul has joined #openmrs |
| 04:01:59 | *** irc.freenode.net sets mode: +vv r0bby upul |
| 04:08:04 | *** Echidna has quit IRC |
| 04:08:04 | *** upul has quit IRC |
| 04:08:04 | *** atomicturtle has quit IRC |
| 04:08:04 | *** jacobb has quit IRC |
| 04:08:04 | *** r0bby has quit IRC |
| 04:26:24 | *** atomicturtle1 has joined #openmrs |
| 04:26:24 | *** r0bby has joined #openmrs |
| 04:26:24 | *** jacobb has joined #openmrs |
| 04:26:24 | *** Echidna has joined #openmrs |
| 04:26:24 | *** upul has joined #openmrs |
| 04:26:24 | *** irc.freenode.net sets mode: +vv r0bby upul |
| 04:47:29 | *** Echidna has quit IRC |
| 04:47:29 | *** atomicturtle1 has quit IRC |
| 04:47:29 | *** upul has quit IRC |
| 04:47:29 | *** jacobb has quit IRC |
| 04:47:29 | *** r0bby has quit IRC |
| 04:55:07 | *** atomicturtle1 has joined #openmrs |
| 04:55:07 | *** r0bby has joined #openmrs |
| 04:55:07 | *** jacobb has joined #openmrs |
| 04:55:07 | *** Echidna has joined #openmrs |
| 04:55:07 | *** upul has joined #openmrs |
| 04:55:07 | *** irc.freenode.net sets mode: +vv r0bby upul |
| 05:29:22 | *** njero has joined #openmrs |
| 05:29:22 | *** ChanServ sets mode: +v njero |
| 06:00:28 | *** njero has quit IRC |
| 06:00:28 | *** Echidna has quit IRC |
| 06:00:28 | *** atomicturtle1 has quit IRC |
| 06:00:28 | *** upul has quit IRC |
| 06:00:28 | *** jacobb has quit IRC |
| 06:00:28 | *** r0bby has quit IRC |
| 06:04:19 | *** njero has joined #openmrs |
| 06:04:19 | *** atomicturtle1 has joined #openmrs |
| 06:04:19 | *** r0bby has joined #openmrs |
| 06:04:19 | *** jacobb has joined #openmrs |
| 06:04:19 | *** Echidna has joined #openmrs |
| 06:04:19 | *** upul has joined #openmrs |
| 06:04:19 | *** irc.freenode.net sets mode: +vvv njero r0bby upul |
| 06:05:48 | *** pbrandt` has joined #openmrs |
| 06:06:07 | *** pbrandt` is now known as pascal` |
| 06:26:35 | *** Mkop has joined #openmrs |
| 06:49:12 | *** Mkop has quit IRC |
| 06:54:44 | *** atomicturtle has joined #openmrs |
| 06:54:44 | *** atomicturtle1 has quit IRC |
| 07:05:33 | <upul> http://news.yahoo.com/s/ap/20091214/ap_on_hi_te/us_toppling_tvs |
| 07:05:37 | <OpenMRSBot> <http://ln-s.net/4hH5> (at news.yahoo.com) |
| 07:05:39 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11468]: personrefactoring branch: debugging after deploying in a real environment, ⦠<http://dev.openmrs.org/changeset/11468> |
| 07:11:28 | <pascal`> upul, interesting link |
| 07:55:29 | <upul> :-o http://news.yahoo.com/s/ap/20091215/ap_on_sc/climate_gore_13 |
| 07:55:31 | <OpenMRSBot> <http://ln-s.net/4hHI> (at news.yahoo.com) |
| 08:43:59 | *** njero has quit IRC |
| 08:44:28 | *** njero has joined #openmrs |
| 08:44:28 | *** ChanServ sets mode: +v njero |
| 08:48:01 | <upul> http://www.theage.com.au/technology/technology-news/internet-censorship-plan-gets-the-green-light-20091215-ktzc.html |
| 08:48:04 | <OpenMRSBot> <http://ln-s.net/4hHk> (at www.theage.com.au) |
| 08:55:43 | *** njero has quit IRC |
| 09:13:10 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: regarding uuid generation <http://forum.openmrs.org/viewtopic.php?f=22&t=543#p1996> |
| 09:45:08 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: PatientSearch textfield in innerHTML <http://forum.openmrs.org/viewtopic.php?f=8&t=544#p1997> |
| 10:03:19 | *** r0bby has quit IRC |
| 10:03:23 | *** r0bby has joined #openmrs |
| 10:03:23 | *** ChanServ sets mode: +v r0bby |
| 10:09:01 | *** atomicturtle1 has joined #openmrs |
| 10:09:52 | *** atomicturtle has quit IRC |
| 10:13:27 | <r0bby> Gg |
| 10:13:30 | <r0bby> er |
| 10:31:58 | <upul> hey pascal` |
| 10:32:33 | <upul> check this out http://students.ee.sun.ac.za/~super/surveys/b1/index.php?a=1&b=1&c=2&d=3 |
| 10:32:38 | <OpenMRSBot> <http://ln-s.net/4hIX> (at students.ee.sun.ac.za) |
| 10:33:46 | <pascal`> hey upul |
| 10:34:17 | <upul> check my choices |
| 10:35:11 | <pascal`> heh |
| 10:36:20 | <upul> you should have got the results unless you gave a fake email address |
| 10:36:37 | <pascal`> i did get |
| 10:37:14 | <pascal`> http://students.ee.sun.ac.za/~super/surveys/b8/index.php?a=2&b=1&c=2&d=3 |
| 10:37:19 | <OpenMRSBot> <http://ln-s.net/4hIZ> (at students.ee.sun.ac.za) |
| 10:37:30 | <pascal`> upul, only our first ones differ |
| 10:39:01 | <upul> you have a good ear |
| 10:39:13 | <upul> do must be cleaning it often |
| 10:39:20 | <upul> :-p |
| 10:39:52 | <upul> both |
| 10:40:01 | <upul> did not imply half deaf |
| 10:40:10 | <upul> :-D |
| 10:41:00 | <pascal`> heh |
| 10:46:15 | <upul> there's great cricket match between sri lanka and india |
| 11:18:50 | <upul> bye |
| 11:18:52 | *** upul has left #openmrs |
| 11:27:16 | <r0bby> !jmiranda++ |
| 11:27:53 | <r0bby> I approve of 1736 |
| 11:27:55 | <r0bby> :D |
| 11:30:06 | *** Mkop has joined #openmrs |
| 12:34:43 | *** pascal` has quit IRC |
| 12:34:43 | *** r0bby has quit IRC |
| 12:34:43 | *** Mkop has quit IRC |
| 12:34:43 | *** Echidna has quit IRC |
| 12:34:43 | *** atomicturtle1 has quit IRC |
| 12:34:43 | *** jacobb has quit IRC |
| 12:41:39 | *** upul has joined #openmrs |
| 12:41:39 | *** Mkop has joined #openmrs |
| 12:41:39 | *** atomicturtle1 has joined #openmrs |
| 12:41:39 | *** r0bby has joined #openmrs |
| 12:41:39 | *** pascal` has joined #openmrs |
| 12:41:39 | *** jacobb has joined #openmrs |
| 12:41:39 | *** Echidna has joined #openmrs |
| 12:41:39 | *** irc.freenode.net sets mode: +v r0bby |
| 12:43:33 | *** upul has quit IRC |
| 12:43:40 | *** upul has joined #openmrs |
| 12:43:40 | *** ChanServ sets mode: +v upul |
| 12:57:00 | *** upul has quit IRC |
| 12:57:12 | *** upul has joined #openmrs |
| 12:57:12 | *** ChanServ sets mode: +v upul |
| 13:05:47 | *** pascal` has quit IRC |
| 13:09:22 | *** pascal` has joined #openmrs |
| 13:21:38 | *** pascal` has quit IRC |
| 13:21:38 | *** r0bby has quit IRC |
| 13:21:38 | *** upul has quit IRC |
| 13:21:38 | *** Mkop has quit IRC |
| 13:21:39 | *** Echidna has quit IRC |
| 13:21:39 | *** jacobb has quit IRC |
| 13:21:39 | *** atomicturtle1 has quit IRC |
| 13:22:32 | *** atomicturtle has joined #openmrs |
| 13:22:32 | *** pascal` has joined #openmrs |
| 13:22:32 | *** upul has joined #openmrs |
| 13:22:32 | *** Mkop has joined #openmrs |
| 13:22:32 | *** r0bby has joined #openmrs |
| 13:22:32 | *** jacobb has joined #openmrs |
| 13:22:32 | *** Echidna has joined #openmrs |
| 13:22:32 | *** irc.freenode.net sets mode: +vv upul r0bby |
| 13:24:57 | *** kane77 has joined #openmrs |
| 13:39:30 | *** r0bby|android has joined #openmrs |
| 13:39:30 | *** ChanServ sets mode: +v r0bby|android |
| 13:44:03 | *** bwolfe_ has joined #openmrs |
| 13:44:03 | *** ChanServ sets mode: +o bwolfe_ |
| 14:05:23 | *** njero has joined #openmrs |
| 14:05:23 | *** ChanServ sets mode: +v njero |
| 14:13:38 | *** bwolfe_ has quit IRC |
| 14:31:38 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11470]: chica: check for "higher" term value of lead level and if so conclude ⦠<http://dev.openmrs.org/changeset/11470> || OpenMRS Changesets: Changeset [11469]: sockethl7listenener * added dependency to chirdlutil module <http://dev.openmrs.org/changeset/11469> |
| 14:48:06 | *** upul_ has joined #openmrs |
| 14:48:06 | *** ChanServ sets mode: +v upul_ |
| 14:49:07 | *** upul has quit IRC |
| 14:49:11 | *** upul_ is now known as upul |
| 15:12:42 | *** Mkop has quit IRC |
| 15:18:36 | *** Mkop has joined #openmrs |
| 15:20:33 | *** meonkeys has joined #openmrs |
| 15:21:23 | <meonkeys> you guys know docpaul, yes? |
| 15:28:04 | *** meonkeys has quit IRC |
| 15:28:04 | *** Echidna has quit IRC |
| 15:30:58 | *** Echidna has joined #openmrs |
| 15:31:32 | *** Echidna has quit IRC |
| 15:32:22 | *** meonkeys has joined #openmrs |
| 15:35:44 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11471]: mdrtb-1.5.x: Fix odd issue with translating message codes that contain ⦠<http://dev.openmrs.org/changeset/11471> |
| 15:45:51 | *** Echidna has joined #openmrs |
| 15:45:59 | <upul> hi meonkeys |
| 15:46:15 | <meonkeys> upul: you can call me Adam. :) |
| 15:46:15 | <upul> hi Echidna |
| 15:46:16 | <upul> Adam, you can call me upul :-p |
| 15:51:14 | *** Echidna has quit IRC |
| 15:55:44 | *** r0bby|android has quit IRC |
| 15:56:22 | <upul> meonkeys: adam, you were looking for docpaul? |
| 15:56:37 | <meonkeys> found him, he's in #mifos |
| 15:57:22 | <upul> is he :-) |
| 16:01:10 | *** Echidna has joined #openmrs |
| 16:10:28 | *** atomicturtle has quit IRC |
| 16:10:41 | *** atomicturtle has joined #openmrs |
| 16:11:52 | *** Echidna has quit IRC |
| 16:22:53 | *** Echidna has joined #openmrs |
| 16:32:57 | *** atomicturtle has quit IRC |
| 16:33:16 | *** atomicturtle has joined #openmrs |
| 16:51:44 | *** Mkop has quit IRC |
| 16:57:33 | *** bwolfe has joined #openmrs |
| 16:57:33 | *** ChanServ sets mode: +o bwolfe |
| 16:59:21 | *** upul_ has joined #openmrs |
| 16:59:21 | *** ChanServ sets mode: +v upul_ |
| 16:59:56 | *** upul has quit IRC |
| 17:00:00 | *** upul_ is now known as upul |
| 17:01:28 | *** atomicturtle has quit IRC |
| 17:01:28 | *** njero has quit IRC |
| 17:01:28 | *** jacobb has quit IRC |
| 17:05:27 | *** jacobb has joined #openmrs |
| 17:09:20 | *** atomicturtle has joined #openmrs |
| 17:09:20 | *** njero has joined #openmrs |
| 17:09:20 | *** irc.freenode.net sets mode: +v njero |
| 17:14:47 | *** SparFux has joined #openmrs |
| 17:15:30 | *** Echidna has quit IRC |
| 17:19:54 | *** SparFux has quit IRC |
| 17:19:54 | *** atomicturtle has quit IRC |
| 17:19:54 | *** njero has quit IRC |
| 17:23:55 | *** SparFux has joined #openmrs |
| 17:23:55 | *** atomicturtle has joined #openmrs |
| 17:23:55 | *** njero has joined #openmrs |
| 17:23:55 | *** irc.freenode.net sets mode: +v njero |
| 17:24:34 | *** Echidna has joined #openmrs |
| 17:33:05 | *** SparFux has quit IRC |
| 17:33:05 | *** atomicturtle has quit IRC |
| 17:33:05 | *** njero has quit IRC |
| 17:44:57 | *** jacobb has quit IRC |
| 17:44:57 | *** upul has quit IRC |
| 17:44:57 | *** pascal` has quit IRC |
| 17:44:57 | *** kane77 has quit IRC |
| 17:44:57 | *** bwolfe has quit IRC |
| 17:44:57 | *** r0bby has quit IRC |
| 17:44:57 | *** Echidna has quit IRC |
| 17:44:57 | *** meonkeys has quit IRC |
| 17:54:07 | *** bwolfe has joined #openmrs |
| 17:54:07 | *** atomicturtle has joined #openmrs |
| 17:54:07 | *** jacobb has joined #openmrs |
| 17:54:07 | *** kane77 has joined #openmrs |
| 17:54:07 | *** Echidna has joined #openmrs |
| 17:54:07 | *** njero has joined #openmrs |
| 17:54:07 | *** upul has joined #openmrs |
| 17:54:07 | *** meonkeys has joined #openmrs |
| 17:54:07 | *** pascal` has joined #openmrs |
| 17:54:07 | *** r0bby has joined #openmrs |
| 17:54:07 | *** irc.freenode.net sets mode: +ovvv bwolfe njero upul r0bby |
| 17:56:23 | *** Echidna has quit IRC |
| 17:56:23 | *** atomicturtle has quit IRC |
| 17:56:23 | *** njero has quit IRC |
| 17:56:38 | *** atomicturtle has joined #openmrs |
| 17:56:38 | *** njero has joined #openmrs |
| 17:56:38 | *** Echidna has joined #openmrs |
| 17:56:38 | *** irc.freenode.net sets mode: +v njero |
| 18:16:42 | *** SparFux has joined #openmrs |
| 18:16:56 | <SparFux> Hello? |
| 18:18:02 | <upul> Hi |
| 18:25:02 | *** pascal` has quit IRC |
| 18:25:02 | *** upul has quit IRC |
| 18:25:02 | *** kane77 has quit IRC |
| 18:25:02 | *** bwolfe has quit IRC |
| 18:25:02 | *** r0bby has quit IRC |
| 18:25:02 | *** Echidna has quit IRC |
| 18:25:02 | *** atomicturtle has quit IRC |
| 18:25:02 | *** SparFux has quit IRC |
| 18:25:02 | *** njero has quit IRC |
| 18:25:02 | *** jacobb has quit IRC |
| 18:25:02 | *** meonkeys has quit IRC |
| 18:35:36 | *** bwolfe has joined #openmrs |
| 18:35:36 | *** kane77 has joined #openmrs |
| 18:35:36 | *** SparFux has joined #openmrs |
| 18:35:36 | *** Echidna has joined #openmrs |
| 18:35:36 | *** njero has joined #openmrs |
| 18:35:36 | *** atomicturtle has joined #openmrs |
| 18:35:36 | *** jacobb has joined #openmrs |
| 18:35:36 | *** upul has joined #openmrs |
| 18:35:36 | *** meonkeys has joined #openmrs |
| 18:35:36 | *** pascal` has joined #openmrs |
| 18:35:37 | *** r0bby has joined #openmrs |
| 18:35:37 | *** irc.freenode.net sets mode: +ovvv bwolfe njero upul r0bby |
| 18:41:01 | *** atomicturtle has quit IRC |
| 18:41:01 | *** Echidna has quit IRC |
| 18:41:01 | *** SparFux has quit IRC |
| 18:41:01 | *** njero has quit IRC |
| 18:45:58 | *** pascal` has quit IRC |
| 18:45:58 | *** upul has quit IRC |
| 18:45:58 | *** kane77 has quit IRC |
| 18:45:58 | *** bwolfe has quit IRC |
| 18:45:58 | *** r0bby has quit IRC |
| 18:45:58 | *** jacobb has quit IRC |
| 18:45:58 | *** meonkeys has quit IRC |
| 18:59:19 | *** bwolfe has joined #openmrs |
| 18:59:20 | *** Echidna has joined #openmrs |
| 18:59:20 | *** njero has joined #openmrs |
| 18:59:20 | *** atomicturtle has joined #openmrs |
| 18:59:20 | *** SparFux has joined #openmrs |
| 18:59:20 | *** kane77 has joined #openmrs |
| 18:59:20 | *** jacobb has joined #openmrs |
| 18:59:20 | *** upul has joined #openmrs |
| 18:59:20 | *** meonkeys has joined #openmrs |
| 18:59:20 | *** pascal` has joined #openmrs |
| 18:59:20 | *** r0bby has joined #openmrs |
| 18:59:20 | *** irc.freenode.net sets mode: +ovvv bwolfe njero upul r0bby |
| 19:05:01 | *** atomicturtle1 has joined #openmrs |
| 19:05:01 | *** atomicturtle has quit IRC |
| 19:05:10 | <upul> switch to paidnode |
| 19:05:11 | <SparFux> my idea is to have custom input forms to fill the OpenMRS data model with data I need. |
| 19:05:14 | <Echidna> you can define your own forms |
| 19:05:46 | <bwolfe> SparFux: it is possible to deisgn something on top of the openmrs model. I know of several groups doing that with ruby, php, and .net |
| 19:05:47 | <bwolfe> SparFux: but then you lose a lot of the power of the community. if you just want custom forms, why not just use the formentry, htmlformentry, or xforms modules to make custom forms for openmrs ? |
| 19:05:54 | *** r0bby|android has joined #openmrs |
| 19:05:54 | *** ChanServ sets mode: +v r0bby|android |
| 19:05:54 | <Echidna> bwolfe: SparFux wants to implement it in germany |
| 19:05:54 | <Echidna> i wonder what that would take |
| 19:05:56 | <SparFux> bwolfe: good idea. preferrred should be htmlformentry. |
| 19:06:03 | <bwolfe> oh no, not another german! ;-) |
| 19:06:23 | <Echidna> ve own zis channel now |
| 19:06:31 | <SparFux> Look, germany is the place, nothing more. basically I have to collect data about pateients from my workplace, that is why I want to use web interface. |
| 19:06:33 | <bwolfe> actually SparFux, between Echidna and frank knoll, you have a lot of german to live up to! |
| 19:10:40 | *** pascal` has quit IRC |
| 19:10:40 | *** upul has quit IRC |
| 19:10:40 | *** kane77 has quit IRC |
| 19:10:40 | *** bwolfe has quit IRC |
| 19:10:40 | *** r0bby has quit IRC |
| 19:10:40 | *** atomicturtle1 has quit IRC |
| 19:10:40 | *** SparFux has quit IRC |
| 19:10:40 | *** Echidna has quit IRC |
| 19:10:40 | *** njero has quit IRC |
| 19:10:40 | *** r0bby|android has quit IRC |
| 19:10:40 | *** jacobb has quit IRC |
| 19:10:40 | *** meonkeys has quit IRC |
| 19:21:17 | *** bwolfe has joined #openmrs |
| 19:21:17 | *** Echidna has joined #openmrs |
| 19:21:17 | *** njero has joined #openmrs |
| 19:21:17 | *** SparFux has joined #openmrs |
| 19:21:17 | *** atomicturtle1 has joined #openmrs |
| 19:21:17 | *** r0bby|android has joined #openmrs |
| 19:21:17 | *** kane77 has joined #openmrs |
| 19:21:17 | *** jacobb has joined #openmrs |
| 19:21:17 | *** upul has joined #openmrs |
| 19:21:17 | *** irc.freenode.net sets mode: +ovvv bwolfe njero r0bby|android upul |
| 19:21:17 | *** meonkeys has joined #openmrs |
| 19:21:17 | *** pascal` has joined #openmrs |
| 19:21:17 | *** r0bby has joined #openmrs |
| 19:21:17 | *** irc.freenode.net sets mode: +v r0bby |
| 19:23:23 | *** atomicturtle1 has quit IRC |
| 19:23:23 | *** SparFux has quit IRC |
| 19:23:23 | *** Echidna has quit IRC |
| 19:23:23 | *** njero has quit IRC |
| 19:23:41 | *** atomicturtle1 has joined #openmrs |
| 19:23:41 | *** SparFux has joined #openmrs |
| 19:23:41 | *** njero has joined #openmrs |
| 19:23:41 | *** Echidna has joined #openmrs |
| 19:23:41 | *** irc.freenode.net sets mode: +v njero |
| 19:24:16 | <Echidna> bwolfe might now |
| 19:24:17 | <SparFux> I don't get the error. |
| 19:24:17 | <Echidna> he's a lunix fiend |
| 19:24:29 | <SparFux> That's nice. |
| 19:24:41 | <SparFux> well, the database is not created yet. |
| 19:25:32 | <bwolfe> whats the error? freakynode kicked me again... |
| 19:25:56 | <Echidna> [20:20:01] <SparFux> access denied (java.io.FilePermission /var/lib/tomcat6/webapps/openmrs/WEB-INF/dwr-modules.xml delete) |
| 19:25:58 | <r0bby|android> damn this phone |
| 19:26:19 | <SparFux> http://pastebin.com/mafe5eea |
| 19:27:01 | <SparFux> log says: javax.servlet.ServletException: OpenMRS initialization is required. Visit /openmrs to run the setup wizard. |
| 19:27:23 | <SparFux> but running /openmrs is what I am trying. connecting to localhost:8080/openmrs/ |
| 19:28:13 | <bwolfe> r0bby|android: ahaha, hate the droid already?! |
| 19:28:31 | <bwolfe> SparFux: strange |
| 19:28:44 | <bwolfe> SparFux: are you using an ubuntu tomcat installation? |
| 19:29:02 | <SparFux> http://pastebin.com/f7f9b122e |
| 19:29:07 | <SparFux> no, debian sid. |
| 19:29:09 | <r0bby|android> I have no 3g |
| 19:29:20 | <SparFux> I had it running one time. annoying :-) |
| 19:29:27 | <bwolfe> SparFux: ah, so an apt-get install tomcat, though, right? |
| 19:29:36 | <r0bby|android> I'm on wifi right now |
| 19:29:46 | <SparFux> bwolfe: yes. |
| 19:29:49 | <bwolfe> r0bby|android: that sucks. no fast connection ever, or just not near you ? |
| 19:30:03 | <r0bby|android> funny thing |
| 19:30:15 | <SparFux> bwolfe: then copied the .war file in /var/lib/tomcat6/webapps |
| 19:30:25 | <bwolfe> SparFux: see the TOMCAT6_SECURITY bit on this page: http://openmrs.org/wiki/Step-by-Step_Installation_for_Implementers |
| 19:30:26 | <OpenMRSBot> <http://ln-s.net/27Dh> (at openmrs.org) |
| 19:30:26 | <r0bby|android> att and T-Mobile have 3g |
| 19:30:49 | <bwolfe> r0bby|android: but vzw claims to have all those nice maps |
| 19:31:09 | <r0bby|android> yes this is why I'm laughing |
| 19:31:39 | *** upul has left #openmrs |
| 19:40:44 | <r0bby|android> be glad you waited ben |
| 19:42:44 | <SparFux> bwolfe: aha. |
| 19:43:02 | <SparFux> feels bad to turn off a security manager though. |
| 19:43:47 | <r0bby|android> I wanted to throw this thing against the wall on several occasions |
| 19:43:57 | <bwolfe> r0bby|android: thats too bad...only because of 3g, or other reasons? |
| 19:43:57 | <SparFux> and I had to remove /usr/share/tomcat6/.OpenMRS :-) |
| 19:45:30 | <bwolfe> r0bby|android: although you're not the most patient person in the world...so thats not really saying much ;-) |
| 19:45:33 | <r0bby|android> er no it froze a lot; apps would refuse to launch; wouldn't read my SD card |
| 19:45:33 | <r0bby|android> the update fixed a lot |
| 19:45:41 | *** Echidna has quit IRC |
| 19:45:41 | *** atomicturtle1 has quit IRC |
| 19:45:41 | *** SparFux has quit IRC |
| 19:45:41 | *** njero has quit IRC |
| 19:45:42 | <r0bby|android> I'm high strung that's for sure |
| 19:46:05 | *** atomicturtle1 has joined #openmrs |
| 19:46:05 | *** SparFux has joined #openmrs |
| 19:46:05 | *** njero has joined #openmrs |
| 19:46:05 | *** Echidna has joined #openmrs |
| 19:46:05 | *** irc.freenode.net sets mode: +v njero |
| 19:46:33 | *** Mkop has joined #openmrs |
| 19:50:28 | *** jmiranda has joined #openmrs |
| 19:50:28 | *** ChanServ sets mode: +o jmiranda |
| 19:51:22 | * jmiranda just realized he wasn't connected ... (wondering why it was so quiet) |
| 19:51:28 | <SparFux> how is file /usr/share/tomcat6/.OpenMRS/openmrs-runtime.properties created anyway? |
| 19:51:51 | <jmiranda> in openmrs 1.5+, it's created during the initialization process |
| 19:52:03 | <SparFux> hm... |
| 19:53:25 | <SparFux> that is when accessing localhost:8080/openmrs first time? |
| 19:53:37 | <jmiranda> yes |
| 19:53:44 | <jmiranda> when you answer all of those questions |
| 19:53:47 | <Echidna> yea |
| 19:53:53 | <jmiranda> most of those answers go in runtime properties |
| 19:53:55 | <SparFux> I get this when trying to access this site: http://pastebin.com/m4a9990f8 |
| 19:53:58 | <jmiranda> (probably all) |
| 19:55:04 | <SparFux> it's an error I get and then installation restarts. |
| 19:55:16 | <jmiranda> does the user who runs the tomcat process have access to that directory |
| 19:55:28 | <jmiranda> read/write |
| 19:55:35 | <bwolfe> SparFux: does the database you're trying to create exist already ? |
| 19:55:46 | *** kane77 has quit IRC |
| 19:55:49 | <r0bby|android> I keep getting Mamlin LOL |
| 19:56:07 | <SparFux> ERROR - UpdateFilterModel.updateChanges(63) |2009-12-15 20:39:48,989| Unable to get the database changes |
| 19:56:12 | <SparFux> no, it does not exist. |
| 19:56:14 | <r0bby|android> android adds last names from its address book LOL |
| 19:56:48 | <SparFux> perhaps that user already exists? |
| 19:57:55 | <SparFux> but at least I cannot drop him. |
| 19:58:20 | <jmiranda> the other issue is whether you're entering the right root password |
| 19:58:57 | <SparFux> definitely. |
| 19:59:13 | <SparFux> it's the one I enter via sudo -u mysql mysql -u root -p |
| 20:01:20 | <jmiranda> ok |
| 20:02:10 | <SparFux> even with creating db by hand it fails with same error. |
| 20:02:29 | <SparFux> perhaps something wrong with this string: jdbc:mysql://localhost:3306/@DBNAME@?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8 |
| 20:03:36 | <SparFux> how to check wether the user already exists? |
| 20:04:02 | <SparFux> SELECT user FROM mysql.user WHERE user=' '; |
| 20:04:12 | <jmiranda> ahh |
| 20:04:15 | <SparFux> SELECT user FROM mysql.user WHERE user='openmrs'; |
| 20:04:15 | <SparFux> Empty set (0.00 sec) |
| 20:04:22 | <jmiranda> & should be replaced with & |
| 20:04:29 | <SparFux> database and user don't exist. |
| 20:04:47 | <jmiranda> it might be openmrs_user |
| 20:05:41 | <SparFux> Unable to create the database |
| 20:06:51 | <SparFux> hm... |
| 20:07:22 | <SparFux> & doesn't work, neither :-\ |
| 20:07:49 | <SparFux> database name might be openmrs_user? or what? |
| 20:08:44 | <jmiranda> code replaces & with & anyway |
| 20:08:53 | <SparFux> ok. |
| 20:09:06 | <jmiranda> user might be created as openmrs_user |
| 20:09:08 | <SparFux> so the string should be ok. |
| 20:09:11 | <SparFux> ah. |
| 20:09:12 | <SparFux> mompl. |
| 20:09:14 | <jmiranda> yeah, it looks ok |
| 20:09:22 | <jmiranda> which version of mysql are you running? |
| 20:09:30 | <jmiranda> mysql> select version(); |
| 20:09:43 | <SparFux> ok, I give password for root via init, anyway. |
| 20:10:01 | <SparFux> 5.1.41-3 |
| 20:11:35 | <SparFux> WARN - InitializationFilter.executeStatement(528) |2009-12-15 21:10:39,422| error executing sql: create user '?'@'localhost' identified by '?' |
| 20:11:54 | <SparFux> hm... seems like init interface bug. |
| 20:12:17 | <SparFux> create user does not use proper user name. |
| 20:13:23 | <bwolfe> SparFux: what username is it trying to use? I think its based on the database name you choose |
| 20:14:09 | <SparFux> database name is openmrs |
| 20:14:16 | <SparFux> WARN - InitializationFilter.executeStatement(528) |2009-12-15 21:13:48,772| error executing sql: create database `?` default character set utf8 |
| 20:14:25 | <SparFux> now I get this error. |
| 20:14:37 | <SparFux> I now explicitely specify a user openmrs |
| 20:15:51 | <SparFux> I need the grant line for mysql. I think the setup interface needs everything set up in mysql. doing it by itself fails here. |
| 20:16:38 | <SparFux> grant all priviledges on openmrs to openmrs |
| 20:16:39 | <jmiranda> grant all on openmrsdbname.* to openmrsusername; |
| 20:17:12 | <jmiranda> weird, i've gone through the process in the past |
| 20:17:24 | <jmiranda> and it's created both the user and database |
| 20:17:30 | <SparFux> Error while checking the connection user account |
| 20:17:57 | <jmiranda> can you do everything from the command line first |
| 20:18:01 | <bwolfe> SparFux: are you using the root account to create the user and database? (I think the initialization wizard asks for a user/password twice) |
| 20:18:53 | <SparFux> yes. I did that but it seems to fail. Now what I am trying is to setup database and database user myself and give openmrs prog the names and passwords. |
| 20:19:32 | <SparFux> now it worked. but why? |
| 20:19:45 | <SparFux> I just did again: mysql> grant all on openmrs.* to openmrs ; |
| 20:19:52 | <SparFux> and redid the init process... hm... |
| 20:20:08 | <SparFux> ah no. I haven't started it this time. same error. |
| 20:21:13 | <SparFux> perhaps I just switch to nightly build. |
| 20:22:42 | <jmiranda> i would suggest (backing up and) dropping any existing databases, deleting the openmrs user |
| 20:22:42 | <bwolfe> SparFux: which version are you using now ? |
| 20:22:55 | <SparFux> 1.5.1 |
| 20:22:56 | <jmiranda> removing the runtime properties and trying again using the root user |
| 20:23:37 | <jmiranda> it seems like you're in an inbetween state that might be difficult to debug |
| 20:23:38 | <SparFux> how to completely uninstall? |
| 20:23:47 | <SparFux> yes. |
| 20:25:24 | <SparFux> I have to restart tomcat to have the .war extracted. |
| 20:25:41 | <jmiranda> i think it's just |
| 20:25:47 | <jmiranda> mysql> drop database openmrs; |
| 20:25:53 | <jmiranda> mysql> drop user openmrs; |
| 20:26:14 | <SparFux> ok, I did that in mysql already, but I mean the deinstallation in tomcat :-) |
| 20:26:19 | <jmiranda> $ rm /path/to/OpenMRS-runtime.properties |
| 20:27:02 | <SparFux> now tomcat does not even extract .war |
| 20:28:04 | <SparFux> java.lang.IllegalArgumentException: Document base /var/lib/tomcat6/webapps/openmrs does not exist or is not a readable directory |
| 20:28:11 | <SparFux> suggests my de-installation was incomplete. |
| 20:28:16 | <jmiranda> yeah, this is what i was saying earlier |
| 20:28:44 | <jmiranda> your tomcat user does not seem to have read/write on the /var/lib/tomcat6 or /usr/share/tomcat6 directories |
| 20:28:51 | <SparFux> I remove the .war, the dir, the database, database user, |
| 20:28:52 | <jmiranda> this would cause some of these issues |
| 20:29:21 | <SparFux> aha. perhaps that's debian default. |
| 20:29:34 | *** jacobb has quit IRC |
| 20:31:37 | <jmiranda> ps -ef |
| 20:31:47 | <jmiranda> tell me which user is to the left of the java process |
| 20:33:36 | <jmiranda> and to remove the WAR, you can do this |
| 20:33:53 | <jmiranda> actually do it from tomcat to be safe |
| 20:34:06 | *** Mkop has quit IRC |
| 20:34:31 | <SparFux> I reinstalled the whole tomcat6. |
| 20:35:25 | <jmiranda> geez |
| 20:42:40 | <SparFux> it does not even install the .war anymore. |
| 20:45:54 | <SparFux> and in the manager html interface of tomcat I get FAIL - Invalid context path was specified |
| 20:46:18 | <jmiranda> :) |
| 20:46:20 | <jmiranda> sweet |
| 20:46:30 | <SparFux> hm... ok, wrong field. now it's deployed. |
| 20:47:22 | <SparFux> then I guess I have to start it. |
| 20:49:09 | <SparFux> I can deploy the file, but not start i.e. extract it. |
| 20:49:27 | <SparFux> FAIL - Application at context path /openmrs could not be started |
| 20:49:55 | <SparFux> the whole /var/lib/tomcat6 and /usr/share/tomcat6 should be owned by tomcat user, right? |
| 20:52:33 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: regarding uuid generation <http://forum.openmrs.org/viewtopic.php?f=22&t=543#p1999> || OpenMRS Forum: Re: PatientSearch textfield in innerHTML <http://forum.openmrs.org/viewtopic.php?f=8&t=544#p1998> |
| 20:53:43 | <jmiranda> SparFux, yes, owned by tomcat |
| 20:53:50 | <jmiranda> are you starting tomcat as user tomcat |
| 20:54:28 | <jmiranda> SparFux, i just jumped on a call so i might not have my full attention split for about 30 minutes |
| 20:55:09 | <SparFux> yes. |
| 20:55:16 | <SparFux> no prob. |
| 20:56:01 | *** Mkop has joined #openmrs |
| 20:56:38 | <SparFux> shit! only 40k file downloaded right away! |
| 20:57:44 | <SparFux> that's stupid. |
| 21:00:10 | <bwolfe> SparFux: did you do a wget or download directly to the webapps folder? |
| 21:00:28 | <SparFux> I re-downloaded with firefox. formerly used wget. |
| 21:00:36 | <SparFux> anyway, get the same error. |
| 21:01:39 | <SparFux> but it was 1.5.1 again. |
| 21:01:48 | <SparFux> deployed from manager/html |
| 21:02:16 | <jmiranda> wget probably wouldn't work for the war since you need to go through a license agreement |
| 21:02:23 | <jmiranda> (just fyi) |
| 21:02:49 | <SparFux> yes. |
| 21:03:16 | <jmiranda> so you deploy the war from tomcat |
| 21:03:26 | <jmiranda> and you still get the "invalid context" issue |
| 21:03:55 | <jmiranda> or does the init servlet come up? |
| 21:04:05 | <SparFux> same error with 2009-12-09. |
| 21:04:35 | <SparFux> the init process starts, then I get until button "finish". when pressing this one, I get the error. |
| 21:05:15 | <SparFux> ERROR - UpdateFilterModel.updateChanges(?) |2009-12-15 22:02:48,229| Unable to get the database changes |
| 21:05:55 | <jmiranda> ok |
| 21:07:46 | <SparFux> persistently get this error: http://pastebin.com/m57489bcf |
| 21:07:46 | <Mkop> I'm trying to set up a VM for openmrs development. I probably want the tomcat6-user package, right? |
| 21:08:27 | <bwolfe> Mkop: whats in the tomcat6-user package? |
| 21:08:41 | <SparFux> in the logfile I get no errors though. |
| 21:09:08 | <SparFux> This package contains files needed to create a user Tomcat instance. |
| 21:09:45 | <jmiranda> SparFux, trying to run through it myself with tomcat6 and mysql 5.1 |
| 21:10:19 | <Mkop> "This package contains files needed to create a user Tomcat instance." |
| 21:11:24 | <bwolfe> SparFux: are you changing that very first textbox in the initialization wizard at all ? |
| 21:12:17 | <SparFux> the long cryptic string? |
| 21:12:38 | <SparFux> no, I am not changing that string. |
| 21:12:50 | <SparFux> jdbc:mysql://localhost:3306/@DBNAME@?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8 |
| 21:12:54 | <SparFux> It seems ok, moreover. |
| 21:14:55 | <SparFux> but I get a feeling this string might be the key. |
| 21:15:50 | <bwolfe> SparFux: is your db installed on port 3306? are you using mysql 5 at least? |
| 21:16:02 | <jmiranda> yeah, mysql 5.1 |
| 21:16:24 | <SparFux> bwolfe: yes, 3306, nmap confirms that. |
| 21:16:36 | <SparFux> 3306/tcp open mysql |
| 21:17:12 | <SparFux> and the version: http://pastebin.com/m6142ac50 |
| 21:17:19 | <SparFux> 5.1.41-3 |
| 21:18:09 | <bwolfe> hmm |
| 21:18:12 | <bwolfe> strange |
| 21:18:40 | <SparFux> oh, I killed my connection string :-) |
| 21:18:59 | <SparFux> I deleted it to test and now it's gone. hehe |
| 21:19:25 | <bwolfe> and you're using the root user for it to create the user/db ? |
| 21:19:52 | <bwolfe> and the db doesn't exist, and no db users exist (apart from the debian mysql user) |
| 21:19:54 | <SparFux> yes. |
| 21:20:00 | <SparFux> root and the proper password. |
| 21:20:13 | <SparFux> the pw I use with sudo -u mysql mysql -u root -p |
| 21:24:04 | <SparFux> the database does not exist, neither does the user. |
| 21:25:39 | <bwolfe> SparFux: hmm, I don't see how your logs are like that. try this: stop tomcat, clear out the log files, start tomcat, and then see what it says in there |
| 21:26:18 | <jmiranda> i've asked this a couple of times, but i just need to make sure ... |
| 21:26:37 | <SparFux> I can see from the timestamps. http://pastebin.com/md0a6d88 |
| 21:26:51 | <jmiranda> does tomcat6 user have read/write on all directories and subdirectories of /usr/share/tomcat6 and /var/lib/tomcat6 |
| 21:27:02 | <SparFux> once I could install openmrs, but I was not sure what I did back then. Not that I forgot, but I was just trying something that didn't work before. |
| 21:27:07 | <jmiranda> i am getting a similar error when tomca6 user does not have these permissions |
| 21:27:10 | <SparFux> jmiranda: yes, he has. |
| 21:27:39 | <SparFux> I checked again, he does here. |
| 21:27:47 | <jmiranda> ok cool |
| 21:28:22 | <SparFux> how can I get the database connection line back? :-) |
| 21:29:02 | <Mkop> can you create a mini app (i.e. non-Tomcat) that tries to connect to mysql and do something? that should help isolate the problem |
| 21:29:39 | <SparFux> I have mysql command line tool? |
| 21:29:57 | <SparFux> how to log out of manager html tomcat api? |
| 21:30:35 | <SparFux> ah, restarted openmrs, now line is back. |
| 21:30:39 | <Mkop> maybe mysql isn't opening the port properly, or tomcat6 is somehow blocked from connecting to the port? |
| 21:31:42 | <SparFux> it's running on locqalhost. |
| 21:31:50 | <SparFux> there is no firewall active there. |
| 21:32:16 | <SparFux> I create database by hand again. |
| 21:33:00 | <bwolfe> SparFux: you can create the database and rows manually using the sql files on the release notes page: http://openmrs.org/index.php?title=Release_Notes-1.5.1 |
| 21:33:05 | <OpenMRSBot> <http://ln-s.net/4hQx> (at openmrs.org) |
| 21:34:24 | <SparFux> bwolfe: sure. |
| 21:35:51 | <bwolfe> SparFux: someone also put a step by step for debian + openmrs on the wiki recently: http://openmrs.org/wiki/OpenMRS_Debian_Appliance |
| 21:35:54 | <OpenMRSBot> <http://ln-s.net/4hR2> (at openmrs.org) |
| 21:36:03 | <bwolfe> I haven't looked at it closely to see if there is anything special in there |
| 21:36:57 | <SparFux> bwolfe: ok, I am using tomcat6. |
| 21:37:22 | <SparFux> how to run the sql script? |
| 21:37:40 | <SparFux> mysql database < *.sql ? |
| 21:38:05 | <bwolfe> mysql -uroot -p -e"source file.sql" |
| 21:38:11 | <bwolfe> mysql -uroot -p -e"source file.sql" openmrs |
| 21:40:17 | <SparFux> ERROR 1050 (42S01) at line 1554: Table 'liquibasechangeloglock' already exists |
| 21:40:18 | <SparFux> AHA! |
| 21:40:18 | <SparFux> I have to create database openmrs, right? |
| 21:40:18 | <SparFux> I did that and get that error. |
| 21:40:54 | <SparFux> hm... I think this error might be due to the script itself. |
| 21:41:22 | <SparFux> nope, hold on. |
| 21:41:32 | <SparFux> it was due to my first wrong way to execute the script. |
| 21:41:58 | <SparFux> It's the script http://pastebin.com/m7feb3022 |
| 21:42:58 | <jmiranda> drop database openmrs; |
| 21:43:01 | <jmiranda> then rerun that |
| 21:43:47 | <SparFux> ERROR 1049 (42000): Unknown database 'openmrs' |
| 21:43:51 | <jmiranda> sorry |
| 21:43:54 | <SparFux> hehe |
| 21:43:59 | <jmiranda> create database openmrs default charset utf8; |
| 21:43:59 | <SparFux> create database openmrs ; |
| 21:44:01 | <SparFux> then rerun? |
| 21:44:17 | <jmiranda> i thought the script might have the create database line in there |
| 21:44:21 | <SparFux> running. |
| 21:44:27 | <jmiranda> i just ran through the wizard |
| 21:44:38 | <SparFux> same error. |
| 21:44:47 | <SparFux> did you use 1.5.1 ? |
| 21:44:51 | <jmiranda> which same error |
| 21:45:02 | <jmiranda> (yes, i downloaded the war from the downloads page) |
| 21:45:11 | <SparFux> http://pastebin.com/m6c9acb7c |
| 21:45:23 | <SparFux> after utf8 creation and rerunning script. |
| 21:45:32 | <SparFux> how come this talbe already exists? |
| 21:45:57 | <SparFux> it gets created twice! |
| 21:46:01 | <SparFux> in this script. |
| 21:46:23 | <SparFux> line 1554 and 11\ |
| 21:46:25 | <SparFux> 11 |
| 21:47:13 | <bwolfe> SparFux: ha! that definitely seems like a bug in that script. does the 1.5.0 release notes sql have that too?! |
| 21:47:16 | <SparFux> the whole file is duplicated. |
| 21:47:37 | <SparFux> wait, perhaps I got a download error again? |
| 21:48:01 | <SparFux> the whole script is doubled. |
| 21:49:07 | <jmiranda> SparFux, i just ran into the same error |
| 21:49:32 | <SparFux> no, the zip file gives me double script :-) |
| 21:49:56 | <SparFux> it's two instances of the script concatenated :-) ? |
| 21:50:58 | <SparFux> hm... not exactly it seems. |
| 21:51:30 | <SparFux> but the script is broken. at least parts of it are identical. |
| 21:52:28 | *** atomicturtle1 has quit IRC |
| 21:52:36 | <jmiranda> it at least creates all the tables once :) |
| 21:52:50 | <jmiranda> at least it did for me |
| 21:52:56 | <jmiranda> it might not have all the data |
| 21:52:59 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11472]: sync: Added a scheduled task to delete old sync records - #609 <http://dev.openmrs.org/changeset/11472> |
| 21:54:29 | <SparFux> then I go with that. |
| 21:55:21 | *** atomicturtle has joined #openmrs |
| 21:55:37 | <SparFux> Ok, after script was running I get the same error, but not the last context error. |
| 21:56:01 | <SparFux> only the ERROR - UpdateFilterModel.updateChanges(63) |2009-12-15 22:43:24,880| Unable to get the database changes |
| 21:56:06 | <jmiranda> SparFux, it doesn't have any of the static data it needs to run (unfortunately) :) |
| 21:56:25 | <SparFux> so I may use 1.5.0 whereever that is. |
| 21:56:39 | <SparFux> http://openmrs.org/index.php?title=Release_Notes-1.5.0 |
| 21:56:42 | <OpenMRSBot> <http://ln-s.net/4hRH> (at openmrs.org) |
| 21:58:03 | <jmiranda> what's the pastebin equivalent for images |
| 21:58:03 | <SparFux> same error! |
| 21:58:15 | <jmiranda> yeah, let me double check something with you |
| 21:58:19 | <SparFux> jmiranda: I used to have my own webserver running locally. |
| 21:59:28 | <SparFux> both, 1.5.1 and 1.5.0 scripts sql have complete blocks identical. |
| 22:00:47 | *** r0bby|android has quit IRC |
| 22:01:34 | <jmiranda> i see CREATE TABLE `liquibasechangelog` about four times |
| 22:02:09 | <njero> jmiranda: Skitch |
| 22:02:29 | <njero> jmiranda: But it might be Mac only.. |
| 22:02:45 | <SparFux> Well, OpenMRS becomes more and more interesting to me. |
| 22:02:52 | <jmiranda> :) |
| 22:03:06 | <SparFux> it seems to have great reputation. |
| 22:03:53 | <SparFux> http://www.regenstrief.org/ suggests to me, people have made some thoughts before they came up with this "data model" :-) |
| 22:04:21 | <SparFux> and if I can fastly get the forms and reports up some day... |
| 22:04:50 | <SparFux> I mean, xforms for example is standard, and OpenOffice can handle that. |
| 22:05:21 | <jmiranda> SparFux, can you look at these images and let me know if you this is what you tried to do during the install process |
| 22:05:23 | <jmiranda> http://imagebin.org/75626 |
| 22:05:50 | <jmiranda> http://imagebin.org/75628 |
| 22:06:28 | <SparFux> yes. |
| 22:06:46 | <jmiranda> for step 3 ... i checked "no" for the auto-update question |
| 22:06:50 | <SparFux> yes it is. |
| 22:06:53 | <jmiranda> unlike in this screenshot |
| 22:06:54 | <jmiranda> http://openmrs.org/wiki/Image:Configure_step_3.png |
| 22:06:57 | <OpenMRSBot> <http://ln-s.net/4hRO> (at openmrs.org) |
| 22:07:18 | <SparFux> on 3/6 I did both no. |
| 22:07:24 | <SparFux> 3 of 6. |
| 22:07:35 | <SparFux> Ah!!! |
| 22:08:05 | <SparFux> hm... |
| 22:08:07 | <jmiranda> hmm, that shouldn't have caused a problem |
| 22:08:15 | <SparFux> Yes. It shouldn't. |
| 22:08:16 | <jmiranda> but i usually answer 1 = yes, 2 = no |
| 22:08:25 | <jmiranda> step 4 is easy as well |
| 22:08:36 | <jmiranda> just type a password |
| 22:09:03 | <jmiranda> step 5 is a pain, but you could just enter "test" or something else all the way through |
| 22:09:24 | <jmiranda> and step 6, just click Finish |
| 22:09:31 | <SparFux> I did enter test. |
| 22:09:35 | <SparFux> yes. |
| 22:09:39 | <SparFux> still I get the probelm. |
| 22:09:48 | <jmiranda> ok |
| 22:10:51 | <SparFux> but this is strange: WARN - InitializationFilter.executeStatement(528) |2009-12-15 23:09:14,796| error executing sql: create database `?` default character set utf8 |
| 22:10:59 | <jmiranda> and you grabbed this war |
| 22:10:59 | <SparFux> create database '?' |
| 22:11:00 | <jmiranda> http://imagebin.org/75630 |
| 22:11:14 | <SparFux> yes, the first one. |
| 22:11:14 | <jmiranda> yeah, it gets substituted |
| 22:11:26 | <SparFux> aha. |
| 22:11:49 | <jmiranda> wow |
| 22:11:53 | <jmiranda> i'm stumped |
| 22:12:05 | <SparFux> hm... |
| 22:12:07 | <SparFux> me too. |
| 22:12:21 | <SparFux> and I tried snapshot, too. |
| 22:12:25 | <jmiranda> njero, thanks for the recommendation ... skitch is for mac |
| 22:12:35 | <SparFux> my mysql does not give any logfiles. |
| 22:12:47 | <jmiranda> yeah i was going to suggest turning on sql logging |
| 22:13:03 | <jmiranda> but you need to do that in the runtime properties file ... which shouldn't exist yet |
| 22:14:13 | <SparFux> hm... but the mysql itself can be told to log on runtime. |
| 22:14:39 | <jmiranda> ls -l /usr/share/tomcat6/.OpenMRS/openmrs-runtime.properties |
| 22:14:42 | <jmiranda> does that exist |
| 22:15:25 | *** r0bby|android has joined #openmrs |
| 22:15:25 | *** irc.freenode.net sets mode: +v r0bby|android |
| 22:15:31 | <SparFux> this dir is empty. /usr/share/tomcat6/.OpenMRS/ |
| 22:15:55 | <jmiranda> SparFux, yeah ... i just don't know the configuration for mysql logging offhand |
| 22:16:06 | <SparFux> I can do that in the config file... |
| 22:16:51 | <SparFux> done |
| 22:16:55 | <jmiranda> ok |
| 22:17:14 | <jmiranda> well "drop database openmrs;" |
| 22:17:18 | *** r0bby|android has quit IRC |
| 22:17:29 | <jmiranda> and give it another shot through the web interface |
| 22:17:34 | <SparFux> http://pastebin.com/f75e3b6d1 |
| 22:17:36 | <jmiranda> tailing the mysql logs while you're at it |
| 22:18:43 | <jmiranda> are you using '' as your root password? |
| 22:19:16 | <SparFux> it seems , nothing happens on mysql side. |
| 22:19:22 | <jmiranda> i wonder if that might have something to do with it |
| 22:19:26 | <SparFux> jmiranda: no |
| 22:19:45 | <SparFux> root password is something with upper and lowercase and numbers. |
| 22:19:49 | <jmiranda> ok |
| 22:21:41 | <SparFux> though I get three root users by this: http://pastebin.com/m1d6214ed |
| 22:21:50 | <SparFux> perhaps that's the problem? |
| 22:22:46 | <SparFux> ok, but same password. |
| 22:23:01 | <SparFux> it's root@localhost root@127.0.0.1 and root@res (hostname) |
| 22:23:08 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11473]: mdrtb15. fixed deleting bacteriologies bug. changed font size on ⦠<http://dev.openmrs.org/changeset/11473> || OpenMRS Tickets: Ticket #1971 (task created): Privilege for managing the scheduler page should be Manage Scheduler instead of View Task <http://dev.openmrs.org/ticket/1971> |
| 22:23:11 | *** r0bby|android has joined #openmrs |
| 22:23:11 | *** ChanServ sets mode: +v r0bby|android |
| 22:23:13 | <SparFux> password hashes are identical. |
| 22:24:12 | <SparFux> btw, I am using OpenJDK? is that the problem? |
| 22:24:38 | * jmiranda would love it if the installer log stacktraces :( |
| 22:24:43 | *** r0bby|android has quit IRC |
| 22:24:48 | *** r0bby|android has joined #openmrs |
| 22:24:48 | *** ChanServ sets mode: +v r0bby|android |
| 22:24:52 | <jmiranda> SparFux, shouldn't be |
| 22:26:03 | <SparFux> the debian isntallation tutorial does not give any additional hint. it may be tomcat6 is the reason as opposed to using tomcat5.5 |
| 22:26:06 | <jmiranda> ... a problem (that is) |
| 22:26:27 | <jmiranda> i just ran through the same thing on ubuntu |
| 22:26:37 | <SparFux> or perhaps because I am using localhost:8080/openmrs/ and not some hostname? |
| 22:26:37 | <jmiranda> with tomcat 6, mysql 5.1.31 |
| 22:26:49 | <jmiranda> i did the same thing |
| 22:26:57 | <SparFux> I have 5.1.41. |
| 22:27:03 | <SparFux> can't be the problem. |
| 22:27:10 | <jmiranda> right, but that shouldn't be the issue |
| 22:27:22 | <jmiranda> i was just looking into that angle though |
| 22:27:26 | <SparFux> than the culprit might be in /etc/tomcat6 |
| 22:27:57 | <SparFux> I can tar that perhaps. |
| 22:28:07 | <SparFux> and you diff or you send yours and I diff. :-) |
| 22:28:43 | <SparFux> create a runtime.properties by hand? |
| 22:28:49 | <SparFux> and log sql. |
| 22:28:58 | <SparFux> I can try this. |
| 22:29:20 | <jmiranda> yeah, we'll do that (create runtime properties) and i'll send you a sample SQL dump |
| 22:30:36 | <Mkop> I'm having a lot of trouble with this ubuntu vm |
| 22:30:37 | <Mkop> don't know why |
| 22:31:31 | <Mkop> it's downloading something, and sticks at 100% CPU for a long time, but doesn't seem to be making progress |
| 22:32:13 | <SparFux> how to log sql in runtime.properties? |
| 22:38:07 | <jmiranda> SparFux, i'll respond in a few minutes |
| 22:38:23 | <jmiranda> just need to finish uploading the sql script and the runtime properties example |
| 22:41:46 | <SparFux> k |
| 22:42:07 | *** r0bby|android has quit IRC |
| 22:43:10 | *** Mkop has quit IRC |
| 22:43:32 | *** Echidna has quit IRC |
| 22:43:32 | *** SparFux has quit IRC |
| 22:43:32 | *** njero has quit IRC |
| 22:50:09 | *** SparFux has joined #openmrs |
| 22:50:09 | *** njero has joined #openmrs |
| 22:50:09 | *** Echidna has joined #openmrs |
| 22:50:09 | *** irc.freenode.net sets mode: +v njero |
| 22:50:41 | <jmiranda> SparFux, http://openmrs.justinmiranda.com/data/openmrs-12152009.sql.gz |
| 22:50:43 | <OpenMRSBot> <http://ln-s.net/4hRs> (at openmrs.justinmiranda.com) |
| 22:52:19 | <SparFux> re |
| 22:52:27 | <SparFux> jmiranda: back. |
| 22:53:09 | <jmiranda> http://openmrs.justinmiranda.com/data/openmrs-runtime.properties |
| 22:53:11 | <OpenMRSBot> <http://ln-s.net/4hRt> (at openmrs.justinmiranda.com) |
| 22:53:13 | <jmiranda> download that too |
| 22:53:15 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11474]: mdrtb15. changed arguments for dst graphic custom tag to remove ⦠<http://dev.openmrs.org/changeset/11474> |
| 22:53:22 | <jmiranda> then you'll need to do the following |
| 22:55:19 | <SparFux> copy runtime-prop into /usr/share/tomcat6/.OpenMRS :-) |
| 22:56:43 | <SparFux> sudo -u mysql mysql -u root -p -e "source openmrs-12152009.sql" openmrs |
| 22:57:15 | <SparFux> ?? |
| 22:57:43 | <jmiranda> well first you need to create the user and database |
| 22:57:45 | <jmiranda> so run this |
| 22:57:57 | <jmiranda> create user openmrs identified by 'openmrs'; |
| 22:57:59 | <SparFux> create user too? |
| 22:58:00 | <jmiranda> (something like that) |
| 22:58:09 | <jmiranda> create database openmrs default charset utf8; |
| 22:58:17 | <SparFux> it's on the page. |
| 22:58:19 | <jmiranda> grant all on openmrs.* to openmrs; |
| 22:58:29 | <SparFux> use OpenMRS; create user openmrs identified by 'openmrs'; GRANT ALL ON openmrs.* TO 'openmrs'@'%'; Go to C:\Documents and Settings\LocalService\Application Data\OpenMRS |
| 22:58:39 | <jmiranda> ok cool |
| 22:58:50 | <jmiranda> i was close |
| 22:59:07 | <jmiranda> i usually run the script like this |
| 22:59:22 | <jmiranda> mysql -u root -p openmrs < openmrs-12152009.sql |
| 22:59:42 | <jmiranda> i know the other way works (and might be faster), but just wanted to share my method |
| 23:00:18 | <SparFux> sudo -u mysql mysql -u root -p -e "source openmrs-12152009.sql" openmrs |
| 23:00:26 | <SparFux> it's the same I think. |
| 23:00:39 | <SparFux> it is. |
| 23:01:18 | <SparFux> ok, no errors so far. |
| 23:01:36 | <SparFux> I copied properties to /usr/share/tomcat6/.OpenMRS |
| 23:02:08 | *** atomicturtle has quit IRC |
| 23:02:31 | <SparFux> then to the localhost:8080/openmrs? |
| 23:02:43 | <jmiranda> let's see |
| 23:03:06 | <jmiranda> make sure the properties are readable (maybe writable) by tomcat6 |
| 23:03:41 | <jmiranda> you can do a "chown -R tomcat6:tomcat6 /usr/share/tomcat6" just to be sure |
| 23:03:59 | <SparFux> done |
| 23:04:06 | <SparFux> yes. |
| 23:04:27 | *** atomicturtle has joined #openmrs |
| 23:05:51 | <SparFux> have to redeploy. |
| 23:06:18 | <SparFux> java.lang.RuntimeException: error getting unrun updates on the database |
| 23:06:32 | <jmiranda> SparFux, yeah that totally makes sense |
| 23:06:45 | <jmiranda> i'm kidding |
| 23:06:55 | <SparFux> hm... |
| 23:07:12 | <jmiranda> yeah, so maybe this is a mysql5 or tomcat6 issue |
| 23:07:14 | <SparFux> I undeploy. then deploy again. |
| 23:07:17 | <jmiranda> this is incredible |
| 23:08:01 | <SparFux> hm... |
| 23:08:14 | <SparFux> I hit the nastiest bug of all, not known which package. as ever :-) |
| 23:08:39 | <SparFux> perhaps thhe init thing does not want the database to be there? |
| 23:09:14 | <jmiranda> so when you go to localhost:8080/openmrs |
| 23:09:21 | <jmiranda> what you still get the init script? |
| 23:09:48 | <jmiranda> could you send me a screenshot and a "tail -1000 catalina.out" |
| 23:10:04 | <jmiranda> or /var/log/syslog if you're not redirecting |
| 23:11:44 | <SparFux> catalina.log? |
| 23:11:59 | <SparFux> is there a smaller tool for screenshots than gimp? |
| 23:12:22 | <jmiranda> just do an ALT-PRINT SCREEN |
| 23:13:14 | <jmiranda> i use a firefox plugin called Snapper |
| 23:15:16 | *** Echidna has quit IRC |
| 23:15:16 | *** SparFux has quit IRC |
| 23:15:16 | *** njero has quit IRC |
| 23:19:11 | *** SparFux has joined #openmrs |
| 23:19:11 | *** njero has joined #openmrs |
| 23:19:11 | *** Echidna has joined #openmrs |
| 23:19:11 | *** irc.freenode.net sets mode: +v njero |
| 23:19:39 | *** Echidna has quit IRC |
| 23:19:39 | *** SparFux has quit IRC |
| 23:19:39 | *** njero has quit IRC |
| 23:22:14 | *** SparFux has joined #openmrs |
| 23:22:14 | *** njero has joined #openmrs |
| 23:22:14 | *** Echidna has joined #openmrs |
| 23:22:14 | *** irc.freenode.net sets mode: +v njero |
| 23:23:06 | <jmiranda> SparFux, so let's try one more thing |
| 23:23:34 | <jmiranda> connection.url=jdbc:mysql://localhost:3306/openmrs?autoReconnect=true |
| 23:24:05 | <jmiranda> actually, i guess i need to see the error log before making a suggestion |
| 23:24:33 | <SparFux> May I simply try the tomcat 5.5? |
| 23:25:06 | <jmiranda> sure, give it a shot |
| 23:25:12 | <jmiranda> you won't need to stop tomcat6 |
| 23:25:24 | <jmiranda> because tomcat5 will run on port 8180 |
| 23:25:46 | <jmiranda> but remember to disable tomcat security in /etc/init.d/tomcat5.5 |
| 23:29:27 | <SparFux> yes. |
| 23:29:57 | <SparFux> access denied, hm.. |
| 23:31:22 | <SparFux> Error! |
| 23:31:22 | <SparFux> A runtime properties file is needed for OpenMRS to start up consistently. |
| 23:31:22 | <SparFux> OpenMRS is unable to create this file: /usr/share/tomcat5.5/.OpenMRS/openmrs-runtime.properties |
| 23:31:22 | <SparFux> Because of this error: No such file or directory |
| 23:31:22 | <SparFux> You must correct this before continuing. |
| 23:31:25 | <SparFux> srz |
| 23:31:26 | <SparFux> sry |
| 23:31:44 | <SparFux> http://pastebin.com/m34014473 |
| 23:33:37 | <SparFux> so, tomcat 5 does not work, too.. |
| 23:39:11 | *** r0bby|android has joined #openmrs |
| 23:39:16 | *** ChanServ sets mode: +v r0bby|android |
| 23:43:37 | <SparFux> you mean the tomcat6 error log? |
| 23:43:41 | <SparFux> it has no errors. |
| 23:49:55 | <SparFux> don't I need libmysql-java ? |
| 23:51:27 | <SparFux> perhaps some jdbc stuff is just missing here? |
| 23:53:36 | <SparFux> libmysql-java - Java database (JDBC) driver for MySQL |
| 23:57:27 | <bwolfe> SparFux: that jar is included in the openmrs war file |
| 23:58:11 | <SparFux> ok. |
| 23:58:34 | <SparFux> doesn't work anyway. :-) |
| 23:59:55 | <SparFux> https://rl2.dnsalias.net/openmrs/ |