IRC Chat : 2009-12-15 - OpenMRS

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 &amp;
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> &amp; doesn't work, neither :-\
20:07:49 <SparFux> database name might be openmrs_user? or what?
20:08:44 <jmiranda> code replaces & with &amp; 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/