00:04:41
|
*** djazayeri has quit IRC
|
00:10:30
|
*** djazayeri has joined #openmrs
|
00:10:31
|
*** ChanServ sets mode: +o djazayeri
|
00:24:08
|
<r0bby> djazayeri: with the way i'm implementing this i feel bad for the people having to design these :X
|
00:25:29
|
<djazayeri> well, yes, but really the priority should be on the end-user who fills out the reports every day, rather than the admin who has to design one every 3 months.
|
00:25:42
|
<r0bby> <section name="Equipment Status" description="Monitors the status of various vital pieces of equipment on a daily basis"> <question name="Generator Working" description="" questionId="1"/> </section>
|
00:25:52
|
<r0bby> schema will be selected frm a drop-down
|
00:26:02
|
<r0bby> and i'll pass that along seperately
|
00:26:24
|
<r0bby> I'm learning XPath
|
00:26:44
|
<r0bby> it's kinda fun -- thank god for groovy console and its ability to add jars to the classpath on the fly :D
|
00:28:13
|
<r0bby> you see -- this is where groovy will help me heaps -- they have a super easy way to parse XML
|
00:28:33
|
<r0bby> I'd have the method to parse the file out done by now if i used it :)
|
00:43:27
|
<djazayeri> r0bby, isn't this being stored in tables though? where is the xml coming from?
|
00:44:06
|
<r0bby> djazayeri: it's used purely for covenience
|
00:44:37
|
<r0bby> I'm processing it and storing the data then basically discarding it
|
00:45:21
|
<r0bby> I don't feel like changing the data model again
|
00:45:32
|
<r0bby> this is just easier and gets it out the door
|
00:45:50
|
<r0bby> even if it's horribly slow -- (hopefully not *TOO* bad)
|
00:47:52
|
<r0bby> I suppose i could store the XML -- but the idea is to have one <section></section> per section then i guess i'll rebuild it when I load the page and throw it in the form
|
00:48:13
|
<r0bby> (I seriously don't trust myself to not do something insanely stupid)
|
01:16:26
|
*** djazayeri has quit IRC
|
01:53:24
|
*** nribeka__ has joined #openmrs
|
02:09:50
|
*** nribeka_ has quit IRC
|
02:18:12
|
*** upul has joined #openmrs
|
02:18:12
|
*** ChanServ sets mode: +v upul
|
02:27:42
|
*** atomicturtle has joined #openmrs
|
02:43:42
|
*** atomicturtle1 has quit IRC
|
02:48:56
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1718 (defect created): Poor viewing in windows explorer <http://dev.openmrs.org/ticket/1718>
|
04:13:05
|
*** Mkop has joined #openmrs
|
04:25:01
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Creating Database without Demo Data <http://forum.openmrs.org/viewtopic.php?f=9&t=485#p1763> || OpenMRS Forum: Re: Error opening Basic Form via dashboard <http://forum.openmrs.org/viewtopic.php?f=3&t=340#p1762>
|
05:28:33
|
*** atomicturtle1 has joined #openmrs
|
05:28:33
|
*** atomicturtle has quit IRC
|
05:44:57
|
*** mkulumadzi has joined #openmrs
|
07:05:02
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Creating Database without Demo Data <http://forum.openmrs.org/viewtopic.php?f=9&t=485#p1764>
|
07:15:04
|
*** harshini has joined #openmrs
|
07:16:03
|
<r0bby> harshini: hey L)
|
07:17:36
|
*** harshini has quit IRC
|
07:19:12
|
<Mkop> r0bby: still up?
|
07:27:47
|
<r0bby> Mkop: yeh
|
07:28:00
|
<r0bby> trying tgo get this REALLY crappy code finished up
|
07:28:07
|
<r0bby> I've just basically finished
|
07:35:35
|
<r0bby> this code can blow up in so many places it's not funny
|
07:57:02
|
*** Mkop has quit IRC
|
08:28:41
|
*** atomicturtle has joined #openmrs
|
08:44:29
|
*** atomicturtle1 has quit IRC
|
10:47:19
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [9679]: Some Eclipse html/xml validations <http://dev.openmrs.org/changeset/9679>
|
10:48:25
|
*** mkulumadzi has quit IRC
|
11:12:43
|
*** james_regen has joined #openmrs
|
11:12:43
|
*** ChanServ sets mode: +v james_regen
|
11:28:46
|
*** upul has quit IRC
|
11:32:37
|
*** atomicturtle1 has joined #openmrs
|
11:45:38
|
*** atomicturtle has quit IRC
|
11:56:06
|
*** mkulumadzi has joined #openmrs
|
12:10:10
|
*** nribeka__ has quit IRC
|
12:20:33
|
*** amogha has joined #openmrs
|
12:26:10
|
*** pascal` has joined #openmrs
|
12:29:46
|
<amogha> hi pascal
|
12:30:22
|
<pascal`> hey amogha
|
12:32:25
|
*** bwolfe has joined #openmrs
|
12:32:25
|
*** ChanServ sets mode: +o bwolfe
|
12:32:59
|
*** nribeka has joined #openmrs
|
12:32:59
|
*** ChanServ sets mode: +v nribeka
|
12:33:53
|
<amogha> bwolfe :D
|
12:34:10
|
<amogha> was jus looking for you :D
|
12:35:15
|
<bwolfe> whats up?
|
12:35:27
|
<amogha> i need to set up jboss on my lab
|
12:35:47
|
<bwolfe> jboss?
|
12:35:50
|
<bwolfe> why?
|
12:35:51
|
<amogha> yeah
|
12:36:02
|
<amogha> y project is integration of openmrs with openempi
|
12:36:05
|
<amogha> my*
|
12:36:24
|
<bwolfe> I see
|
12:36:31
|
<bwolfe> openempi uses jboss I presume?
|
12:36:34
|
<amogha> and openempi runs on jboss and postgreql
|
12:36:37
|
<amogha> yeah
|
12:36:44
|
<amogha> postgres*
|
12:37:24
|
<bwolfe> amogha: ok, are you having trouble with it or are you just asking permission ?
|
12:37:30
|
<amogha> ive already transferd my jboss, but when i try to do ./run.sh i get permission
|
12:37:36
|
<amogha> denied*
|
12:38:23
|
<amogha> right now jboss is in home/amoga
|
12:38:43
|
<bwolfe> amogha: you probably have to run it as root
|
12:38:48
|
<bwolfe> sudo su ./run.sh
|
12:38:57
|
<bwolfe> err
|
12:39:02
|
<bwolfe> sudo sh ./run.sh
|
12:39:22
|
<amogha> ok ima give it a try jus a sec
|
12:42:20
|
*** upul has joined #openmrs
|
12:42:20
|
*** ChanServ sets mode: +v upul
|
12:43:14
|
<pascal`> hey bwolfe, jmiranda, upul
|
12:43:28
|
<jmiranda> wow, the triple play
|
12:43:31
|
<jmiranda> nice work pascal`
|
12:44:10
|
<jmiranda> good afternoon to you, sir
|
12:44:23
|
<bwolfe> pascal`: just so you know, I don't appreciate having to share my "hey" with jmiranda and upul. those two are sketchy
|
12:44:42
|
<jmiranda> bwolfe, define "sketchy"
|
12:44:43
|
*** upul_ has joined #openmrs
|
12:44:43
|
*** ChanServ sets mode: +v upul_
|
12:44:50
|
<Echidna> hey all
|
12:45:12
|
<nribeka> sketchy is so bwolfe
|
12:45:22
|
<nribeka> he use that term many times
|
12:45:57
|
<bwolfe> sketchy: colorful, scandalous, untrustworthy, smelly. e.g. jmiranda and upul
|
12:46:08
|
<amogha> May I know whether postgres is installed?
|
12:46:23
|
<jmiranda> bwolfe, ok ... yeah, just wanted to make sure we were using the same definition
|
12:47:11
|
<bwolfe> amogha: its probably not. use "sudo yum install postgres". or do "sudo yum list" to see what string to use to install
|
12:47:41
|
<pascal`> hey*
|
12:47:48
|
<Echidna> is "colorful" a negative term?
|
12:47:51
|
<pascal`> * this phrase belongs to bwolfe and bwolfe alone
|
12:50:44
|
<bwolfe> Echidna: no, not usually...but I make it one by grouping it with those other ones. :-)
|
12:51:10
|
<bwolfe> colorful usually means energetic and peppy
|
12:52:35
|
<Echidna> =o
|
12:55:38
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [9680]: serialization.xstream: modified the XStreamSerializer, so that the long ⦠<http://dev.openmrs.org/changeset/9680> || OpenMRS Modules: Serialization Xstream 0.1.6 uploaded to OpenMRS Module Repository <https://dev.openmrs.org/modules/view.jsp?module=serialization.xstream&version=&0.1.6>
|
12:56:30
|
<pascal`> hey Echidna
|
12:57:03
|
<Echidna> hi
|
13:06:37
|
*** upul has quit IRC
|
13:09:07
|
*** deadpool has joined #openmrs
|
13:09:25
|
<deadpool> hey bwolfe quick question
|
13:09:51
|
<bwolfe> deadpool: yes sir
|
13:10:21
|
<deadpool> or anybody for that matter i have a doctor here who wants to know how much openmrs is used for hiv in africa and if it is usefull and all
|
13:11:18
|
<deadpool> he wants to know if it would worth the effort to also make openmrs meet the needs for cancer
|
13:11:50
|
<bwolfe> deadpool: it is worth it. :-)
|
13:11:54
|
<bwolfe> deadpool: let me go work on that
|
13:11:57
|
* bwolfe goes to work on it
|
13:12:02
|
<bwolfe> deadpool: ok, done
|
13:12:04
|
<bwolfe> :-)
|
13:12:14
|
<Echidna> openmrs causes cancer
|
13:12:49
|
<bwolfe> lol
|
13:13:12
|
<deadpool> haha well no he wants to know if it allright because he heard that WHO(who is supporting openmrs) said that it did not meet the needs in africa and that WHO had asked a consulting agency to further develop it non-commercially
|
13:13:13
|
<pascal`> deadpool, suggest he comes to the implementers meeting (=
|
13:13:15
|
<deadpool> is that true
|
13:13:49
|
<bwolfe> deadpool: the concept dictionary lets you define any kind of dataset. most users are HIV because thats the dataset that we ship with openmrs. there are a lot that use it for TB as well
|
13:14:02
|
<bwolfe> deadpool: and then theres also the primary care clinics
|
13:14:33
|
<deadpool> bwolfe yes i know that and i have told him and that(I was telling the doctor that openmrs can be tailored to any ones needs)
|
13:15:04
|
*** upul_ is now known as upul
|
13:15:06
|
<bwolfe> deadpool: I would love to know what exactly (or who exactly) said that it didn't meet needs in africa
|
13:15:20
|
<deadpool> so is the rumor the doctor heard false?
|
13:15:45
|
<Echidna> the defining datasets part is not to be underestimated, though
|
13:16:12
|
<deadpool> well defining datasets is not trivial
|
13:16:55
|
<bwolfe> deadpool: its two-fold false. :-)_
|
13:17:31
|
<bwolfe> deadpool: WHO supports some smaller projects within openmrs...they certainly are not the major supporter
|
13:18:07
|
<bwolfe> deadpool: WHO has consultants working on parts of openmrs...but again on smaller projects like developing an installer, developing the MDRTB module, etc
|
13:18:48
|
<amogha> bwolfe: i have installed my postgres server but it is running into some problems
|
13:19:01
|
<deadpool> so bwolfe i am not trying to say that openmrs is bad and sorry if i offended i didn't mean to but what this doctor said kinda made me a little on edge and stuff and wanted to know if this is true so i can tell the doctor that the effort i have put into it is not waste
|
13:19:13
|
<amogha> when i try to initalize my databse it says
|
13:19:56
|
<bwolfe> deadpool: heh, np, I understand. I didn't mean to come off as offended.
|
13:20:03
|
<amogha> Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists
|
13:20:20
|
<bwolfe> deadpool: I have not heard anyone regretting their decision to use openmrs yet, so I would say that the doctor heard wrong
|
13:20:25
|
<amogha> and when i try to start my service it says i need to intialize my database
|
13:20:47
|
*** bmckown has joined #openmrs
|
13:20:47
|
*** ChanServ sets mode: +o bmckown
|
13:20:47
|
<amogha> i am very new to linux, so can you please help me out?
|
13:20:52
|
<deadpool> thanks bwolfe just wanted to make sure
|
13:20:53
|
<bwolfe> amogha: do you need to do it as root ?
|
13:21:13
|
<Echidna> bwolfe: that person/patient/user redesign scheduled for 1.6, is it gonna happen anytime soon?
|
13:21:29
|
<amogha> yes
|
13:21:35
|
<bwolfe> Echidna: it needs to. I haven't looked into it really though
|
13:21:53
|
<bwolfe> Echidna: it will need to be coded within the next 4-6 weeks probably
|
13:22:05
|
<bwolfe> Echidna: do you have some free time? :-)
|
13:22:05
|
<Echidna> heh
|
13:22:25
|
<Echidna> unfortunately, no =(
|
13:23:21
|
<amogha> erm << still lost in settin up my postgres, bwolfe :(
|
13:24:24
|
<bwolfe> amogha: paste in the statements you are trying to run
|
13:24:34
|
<amogha> oki:D
|
13:24:58
|
<amogha> sudo service postgresql initdb
|
13:25:01
|
<deadpool> well thanks bwolfe i will ttyl
|
13:25:04
|
<deadpool> later all
|
13:25:08
|
*** deadpool has quit IRC
|
13:25:11
|
<amogha> bye deadpool
|
13:25:44
|
<bwolfe> amogha: ok, and then whats the other one?
|
13:26:00
|
<amogha> sudo service postgresql start
|
13:26:35
|
<bwolfe> hmm
|
13:26:53
|
<bwolfe> does google say anything about this?
|
13:27:10
|
<amogha> nothing made sense to me
|
13:27:29
|
<amogha> but im very new as in using it the first time new to linux...
|
13:28:04
|
<bwolfe> amogha: surely googling for " cannot create directory `/var/lib/pgsql/data/pg_log': File exists" should have gotten you an easy answer. :-) no?
|
13:28:20
|
<amogha> ahh jus a sec :d
|
13:33:23
|
<amogha> i was able to initalize n start it
|
13:33:56
|
<amogha> i need to create a user with it, can you tell me how?
|
13:34:25
|
<bwolfe> amogha: create a postgres linux user, or a user within the postgres database?
|
13:34:26
|
*** pascal` has quit IRC
|
13:36:25
|
<upul> Hi jmiranda
|
13:36:32
|
<jmiranda> hey upul
|
13:37:29
|
<amogha> i want a user within the postgres db
|
13:37:35
|
<amogha> hey upul, hey justun
|
13:37:42
|
<amogha> justin*
|
13:37:54
|
<jmiranda> hey amogha
|
13:38:08
|
<upul> jmiranda: i think I will have to select a topic something like 'openmrs causes cancer'
|
13:38:39
|
<jmiranda> upul, i'm speechless
|
13:38:44
|
<upul> do you think datawarehousing part i can come up with something like that
|
13:38:50
|
<upul> hi amogha
|
13:38:59
|
<amogha> causes cancer or causes for cancer?
|
13:42:50
|
<upul> or openmrs is harmful for HIV
|
13:43:31
|
<bwolfe> amogha: I'm not familiar with postgres. I'm assuming you will need to run a postgres command line client (just like mysql has) and then run some postgressql statement. google would help more with that than I can. :-/
|
13:43:55
|
<jmiranda> amogha, are you on windows?
|
13:44:03
|
<upul> amogha: there's psql -U username -h host
|
13:44:57
|
<amogha> yeah justin
|
13:45:55
|
<amogha> oh ima try it upul.
|
13:46:04
|
<jmiranda> amogha, there's a good admin tool called pgAdmin
|
13:46:21
|
<amogha> on linux too?
|
13:46:22
|
<jmiranda> the command psql -U username won't create a user for you
|
13:46:27
|
<jmiranda> just allows you to login
|
13:46:29
|
<amogha> yeah im usin tht on windows
|
13:46:42
|
<amogha> im tryin to set up my lab...
|
13:46:51
|
<upul> yes it's the client
|
13:48:16
|
<jmiranda> upul, is there a root account for postgres?
|
13:48:19
|
<jmiranda> i can't remember
|
13:48:38
|
<upul> it's usually username: postgres
|
13:49:03
|
<jmiranda> oh right
|
13:49:05
|
<amogha> when i try to do this:: su - postgres
|
13:49:21
|
<amogha> and when i type in password, its sayin its incorrect password
|
13:49:47
|
<upul> that's root password it's asking
|
13:50:08
|
<upul> prefix with sudo
|
13:50:12
|
<bwolfe> amogha: which lab are you on?
|
13:50:20
|
<jmiranda> be right back
|
13:50:20
|
<amogha> im on lab4, bwolfe
|
13:50:22
|
*** jmiranda has quit IRC
|
13:50:53
|
<upul> nribeka: are you there?
|
13:51:00
|
<amogha> upul, this is what i got
|
13:51:02
|
<amogha> [amoga@labs4 ~]$ sudo - postgres sudo: '-' requires an argument usage: sudo -V
|
13:51:18
|
<upul> i meant sudo su ...
|
13:51:20
|
<nribeka> hi upul
|
13:52:39
|
<upul> in the patient matching module do you have to say match by first name, last name. Then it'll extract names into a separate table, and take pairs of records and compare them N * N
|
13:52:56
|
<upul> nribeka: is it something like that?
|
13:53:23
|
*** jmiranda has joined #openmrs
|
13:53:23
|
*** ChanServ sets mode: +o jmiranda
|
13:54:01
|
<bwolfe> amogha: does sudo su - postgres work ?
|
13:54:15
|
<nribeka> hold on. lemme remember it. is it going to be N * X
|
13:54:21
|
<nribeka> ups i mean N * N
|
13:54:43
|
<nribeka> it's not going to be N * N upul
|
13:54:58
|
<nribeka> there's a blocking mechanism in the patient matching
|
13:55:10
|
<amogha> hey nribeka
|
13:55:19
|
<nribeka> hi amogha :)
|
13:55:21
|
<amogha> nope bwolfe
|
13:56:13
|
<bwolfe> error?
|
13:56:23
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [9681]: ncd: Various fixes found during investigation. <http://dev.openmrs.org/changeset/9681>
|
13:56:37
|
<amogha> jus sayin it cant find the directory home/postgres..
|
13:56:55
|
<upul> why do you want to login as postgres?
|
13:57:10
|
<amogha> sudo su - postgres We trust you have received the usual lecture from the local System Administrator. It usually boils down to these two things: #1) Respect the privacy of others. #2) Think before you type.
|
13:57:35
|
<amogha> so i can create my database, my project needs tht upul
|
13:58:08
|
<upul> what you need it login to database using psql or pgadmin tool or something
|
13:59:15
|
<bwolfe> amogha: sudo mkdir /home/postgres will make that folder
|
13:59:27
|
<amogha> bwolfe: sudo su - postgres is askin me to enter a password
|
13:59:45
|
<amogha> on windows ive been usin the pgadin tool upul
|
14:00:10
|
<bwolfe> amogha: have you created a linux user called postgres already ?
|
14:00:29
|
<amogha> not tht im aware of, since i dont know how to create one
|
14:00:46
|
<upul> postgres installation creates a postgres user account i think
|
14:01:17
|
<Echidna> lunix =/
|
14:01:24
|
<amogha> yeah upul....
|
14:02:08
|
*** bwolfe has quit IRC
|
14:02:54
|
<amogha> for the user postgres on server, it asked me to give a password when i do it on windows, i set tht passowrd to root during installation
|
14:03:06
|
<amogha> yeah echinda
|
14:03:10
|
<amogha> bwolfe :(
|
14:04:02
|
*** nribeka_ has joined #openmrs
|
14:04:25
|
<upul> amogha: can you connect to database with psql -U postgres
|
14:04:38
|
*** bwolfe has joined #openmrs
|
14:04:38
|
*** ChanServ sets mode: +o bwolfe
|
14:04:50
|
<upul> giving command locally in the machine
|
14:05:28
|
<amogha> your back:D
|
14:06:09
|
<Echidna> my neck, my back..
|
14:06:27
|
<amogha> upul this is what i got :::
|
14:06:37
|
<amogha> sudo su psql -U postgres su: invalid option -- U Try `su --help' for more information. [amoga@labs4 ~]$ psql -U postgres psql: FATAL: Ident authentication failed for user "postgres"
|
14:06:55
|
<upul> nribeka, when comparing records is it comparing records in the same table 1 with 2, 1 with 3...?
|
14:07:10
|
<upul> just 'psql -U postgres'
|
14:07:42
|
<amogha> tht gave fatal : Ident authentication failed for user "postgres"
|
14:08:24
|
<upul> try giving password psql -U postgres -pXXXX try passwords, postgres
|
14:09:45
|
<amogha> ive tried with password postgress also, it dint work upul
|
14:10:20
|
<upul> how about 'psql -U postgres -p'
|
14:11:48
|
<amogha> nope
|
14:13:14
|
<upul> oops -p is port
|
14:13:21
|
<amogha> yeah
|
14:13:41
|
<upul> it's -W
|
14:14:01
|
<amogha> so psql -U postgres -W ??
|
14:14:07
|
<upul> try
|
14:14:57
|
<amogha> psql -U postgres -W Password for user postgres: psql: FATAL: Ident authentication failed for user "postgres"
|
14:15:25
|
<upul> when you say 'psql -U postgres' doesn't it prompt you for password?
|
14:15:34
|
<amogha> it does
|
14:15:41
|
<amogha> and it doesnt accept any passowrd
|
14:15:55
|
<upul> you tried postgres and blank
|
14:16:01
|
<amogha> i havent entered any passowrd yet so im confused why its askin for a password?
|
14:16:35
|
<upul> try 1. postgres 2. just enter
|
14:16:51
|
<amogha> yup jus tried tht, it doesnt work either
|
14:19:14
|
<upul> ah you have to psql from postgres account
|
14:19:29
|
<amogha> and how do i do tht?
|
14:20:03
|
<upul> can you 'sudo su - postgres' if needed give 'sudo mkdir /home/postgres' first
|
14:20:11
|
<amogha> ok
|
14:20:54
|
*** nribeka has quit IRC
|
14:21:10
|
<amogha> sudo su - postgres -bash-3.00$
|
14:21:33
|
<upul> psql
|
14:21:53
|
*** bmckown has quit IRC
|
14:22:12
|
<amogha> i got the interactive terminal
|
14:22:51
|
<amogha> 'Welcome to psql 8.3.7, the PostgreSQL interactive terminal.'
|
14:23:01
|
<upul> there you can 'create database name'
|
14:24:12
|
*** bmckown has joined #openmrs
|
14:24:12
|
*** ChanServ sets mode: +o bmckown
|
14:24:17
|
<upul> CREATE USER username WITH PASSWORD 'password';
|
14:27:52
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [9682]: dataintegrity: added the running with parameters feature to the multiple ⦠<http://dev.openmrs.org/changeset/9682>
|
14:28:36
|
*** atomicturtle1 has quit IRC
|
14:28:43
|
<amogha> it gave a create role
|
14:28:51
|
<amogha> does tht mean it got created?
|
14:29:04
|
<amogha> postgres=# CREATE USER openempi WITH PASSWORD 'openempi'; CREATE ROLE
|
14:31:21
|
<upul> where did create role come from?
|
14:34:28
|
<amogha> next line
|
14:37:41
|
<upul> should be ok
|
14:38:06
|
<upul> also you have to create database and grant access to the user
|
14:38:24
|
<amogha> ok
|
14:38:53
|
<amogha> i did createdb openempi2
|
14:39:25
|
<upul> grant all privileges on database openempi2 to openempi;
|
14:39:49
|
<amogha> i dnt get any statment saying that the operation was succesful
|
14:40:02
|
<upul> did you type the last ';'
|
14:40:44
|
<amogha> no
|
14:40:48
|
<amogha> :-P
|
14:43:31
|
<amogha> postgres-# createdb openempi2; ERROR: syntax error at or near "createdb" LINE 1: createdb openempi2
|
14:44:11
|
<upul> createdb runs from command line not inside psql
|
14:44:27
|
<upul> try create databsae openempi2
|
14:44:31
|
<upul> ;
|
14:46:06
|
<amogha> postgres=# create database openempi2; CREATE DATABASE
|
14:46:39
|
<upul> create database means success
|
14:46:54
|
<amogha> ok
|
14:47:07
|
<amogha> i even granted the permission to it
|
14:50:36
|
<amogha> i have a querry script can u tell me how to run it
|
14:51:15
|
<amogha> upul
|
14:57:00
|
<bwolfe> amogha: in mysql its: source home/username/scriptname.sql
|
14:57:13
|
<amogha> ive done tht and i got an error ben
|
14:57:30
|
<amogha> source /home/amoga/openhie.sql; ERROR: syntax error at or near "source" LINE 1: source /home/amoga/openhie.sql;
|
14:57:52
|
<nribeka_> psql <source-file> ?
|
14:58:06
|
*** ChanServ sets mode: +v nribeka_
|
14:58:12
|
*** nribeka_ is now known as nribeka
|
14:59:47
|
<amogha> it is giving an erro at psql nribeka
|
15:00:45
|
<nribeka> psql -f <source>?
|
15:00:58
|
<nribeka> this is from the mother of all knowledge
|
15:03:18
|
<upul> psql -U user database < file
|
15:04:50
|
<upul> -f also works
|
15:05:20
|
*** atomicturtle has joined #openmrs
|
15:06:04
|
<upul> nribeka: when you said blocking... you mean prevent a=b and b=a?
|
15:06:28
|
<amogha> none of them worked
|
15:06:57
|
<nribeka> james_regen, need to correct me if i'm wrong here
|
15:06:58
|
<upul> amogha: did you give the database name and -U user
|
15:07:56
|
<nribeka> blocking is a process where you group rows based on a certain column
|
15:08:31
|
<nribeka> so you will have a reference column to group rows. i.e. ssn for US
|
15:08:43
|
<nribeka> i hope the wording of it is correct
|
15:09:16
|
<amogha> upul: yes
|
15:09:28
|
<upul> what does it say
|
15:09:41
|
<james_regen> upul: the wording has been changed in the module lately that makes more sense, i think. blocking means "this must match between records"
|
15:12:05
|
<james_regen> instead of matching every record with every other, blocking reduces the search space. there are other blocking schemes like sliding windows, but we just use "person1.name = person2.name"
|
15:12:25
|
<upul> amogha: those work from command line. inside psql it's \i filename
|
15:13:35
|
<amogha> tht seems to work
|
15:13:37
|
<amogha> thanks upul :d
|
15:13:56
|
<amogha> psql:/home/amoga/openhie.sql:2696: ERROR: must be owner of schema public
|
15:13:58
|
<upul> james_regen: so you mean if patients are from 2 states, no need to check names?
|
15:14:41
|
<upul> is 2696 the line number?
|
15:15:04
|
<amogha> guess so
|
15:15:11
|
<james_regen> if state is a field being used for blocking, then the two records (and their names) won't be compared if state does not match exactly
|
15:15:14
|
<upul> what's in it?
|
15:15:17
|
<amogha> so script error then
|
15:16:30
|
<upul> james_regen: it it like for the record in hand compare with all records state != this state, etc.
|
15:17:01
|
<amogha> COMMENT ON SCHEMA public IS 'standard public schema';
|
15:17:09
|
<upul> oops state = thisstate
|
15:18:27
|
<james_regen> upul: yes state = thisstate is exactly right
|
15:18:27
|
<upul> amogha: may be the script was meant to be run as postgres user
|
15:19:26
|
<amogha> yeah
|
15:19:41
|
<amogha> not as postgres user but as the user ive created
|
15:19:57
|
<amogha> upul thanks for the help :d , ive gotta go, seeya laters..............
|
15:20:18
|
<amogha> if you know the solution can you please let me, i'll come n check in a bit:D
|
15:20:23
|
*** amogha has quit IRC
|
15:28:12
|
* r0bby stretches and rubs his eyes
|
15:28:40
|
* nribeka slaps r0bby
|
15:29:19
|
<nribeka> bwolfe, is burke sketchy?
|
15:30:36
|
<bwolfe> nribeka: very
|
15:31:07
|
<nribeka> how about me?
|
15:31:13
|
<bwolfe> nribeka: you're getting there
|
15:33:28
|
*** nribeka_ has joined #openmrs
|
15:36:02
|
<r0bby> am I?!
|
15:36:46
|
<r0bby> so upul how's working w/ burke?
|
15:36:46
|
<r0bby> :)
|
15:37:30
|
<upul> sketchy
|
15:37:38
|
<upul> whatever it means
|
15:38:16
|
*** nribeka__ has joined #openmrs
|
15:38:36
|
<r0bby> upul: flighty
|
15:38:44
|
<r0bby> hard to get a hold of
|
15:39:16
|
<upul> nope, he responds even at untimely hours
|
15:39:18
|
<bwolfe> r0bby: I don't think it means hard to get a hold of...it means he's not a trustoworthy fellow...aka, you wouldn't leave your car unlocked around him
|
15:39:32
|
<r0bby> well yeh
|
15:39:39
|
<bwolfe> e.g.: I drove through this sketchy neighborhood today and saw a lot of sketchy people doing sketchy things
|
15:39:42
|
<r0bby> for some reason i don't see burke robbing me :)
|
15:39:48
|
<bwolfe> and they were doing them sketchily
|
15:39:49
|
<r0bby> Oh yeh
|
15:39:56
|
* r0bby steals bwolfe's wallet
|
15:39:58
|
<r0bby> w00t
|
15:40:01
|
<upul> that sentence is sketchy
|
15:40:03
|
<r0bby> ...IOUs?!?!?!
|
15:40:07
|
*** nribeka has quit IRC
|
15:40:22
|
<r0bby> upul: but seriously, has he been easy to get ahold of
|
15:40:24
|
<bwolfe> r0bby is definitely sketchy now
|
15:40:44
|
<r0bby> bwolfe: leave your car unlocked, keys in the ignition
|
15:40:47
|
<upul> yes, he responds in sometimes 2 mins
|
15:40:57
|
<upul> even before i click 'send' sometimes
|
15:41:15
|
<bwolfe> haha
|
15:41:19
|
<bwolfe> wow, thats good
|
15:41:29
|
<bwolfe> thats about how he was last year for r0bby, right? ;-)
|
15:41:44
|
<r0bby> Oh yeh
|
15:41:56
|
<r0bby> there's a reason groovyforms was in the state it was :)
|
15:42:11
|
<r0bby> Now i just need time and I think i can get it working :)
|
15:43:23
|
<bmckown> sketchy is like suspicious or questionable
|
15:43:29
|
<r0bby> eht rue
|
15:43:38
|
<r0bby> I dont see burke as that
|
15:43:40
|
<r0bby> hell
|
15:43:44
|
<bmckown> meh
|
15:43:44
|
*** ChanServ sets mode: +v nribeka__
|
15:43:51
|
*** nribeka__ is now known as nribeka
|
15:43:51
|
<r0bby> if my dr were sketchy, i'd run for the nearest emergency exit
|
15:44:00
|
<bmckown> i'd still say he's sketchy :-P
|
15:44:23
|
<bmckown> except that the location of the nearest emergency exit is sketchy
|
15:44:26
|
*** nribeka__ has joined #openmrs
|
15:44:35
|
*** ChanServ sets mode: +v nribeka__
|
15:44:35
|
*** nribeka_ has quit IRC
|
15:44:40
|
<r0bby> of course, my endocrinologist wants to run for the nearest emergeny exit
|
15:44:57
|
<r0bby> I still have bloodwork i've yet to have done :) -- r0bby is a difficult patient :)
|
15:45:07
|
*** nribeka has quit IRC
|
15:45:11
|
*** nribeka__ is now known as nribeka
|
15:45:18
|
<r0bby> Who woulda thought
|
15:45:25
|
* r0bby takes nribeka's wallet
|
15:45:30
|
<r0bby> mmmm money
|
15:45:54
|
<Echidna> is it true that americans prefer money clips and loose change to wallets?
|
15:46:04
|
<nribeka> hahaha ... i don't have money
|
15:46:26
|
<bmckown> hmm. i used to have a wallet.
|
15:46:32
|
<bmckown> then r0bby took it away
|
15:46:55
|
<Echidna> my wallet is almost 2 inches thick what with all the cards =/
|
15:47:24
|
<bmckown> oooh. that's like sitting on a rock, no? i have a very thin wallet. not much there.
|
15:47:40
|
<Echidna> yea
|
15:47:50
|
<Echidna> have to take it out when taking longer drives
|
15:48:03
|
<bmckown> my wife uses a purse. she can fit everything in there.
|
15:48:14
|
<Echidna> hah
|
15:48:31
|
<bmckown> one day her car was gone and i saw that her purse was still in the house.
|
15:48:45
|
<bmckown> i checked her purse.. and sure enough... there was her car!
|
15:49:07
|
<r0bby> LOLdid you find the kitchen sink?
|
15:49:18
|
<bmckown> yea, leak included.
|
15:49:40
|
<nribeka> bwolfe, did you get my sketchy mail this morning from that sketchy guy?
|
15:49:49
|
<bwolfe> Echidna: I just switched to a money clip from a wallet. I'm about 2 weeks into the experiment
|
15:49:57
|
<bwolfe> nribeka: the IT guy? yeah. :-p
|
15:50:11
|
<r0bby> i <3 my wallet
|
15:50:19
|
<nribeka> no the guy who said that he's in croatia now
|
15:50:21
|
<nribeka> hahahaha ...
|
15:50:21
|
<r0bby> nribeka: you dont have money
|
15:50:28
|
<r0bby> what is Regenstrief paying you?
|
15:50:28
|
<nribeka> yes rob
|
15:50:29
|
<bwolfe> Echidna: I think I'll stay with the clip...I just need to either keep less cash or go through it faster...the bills get ruffled on the edges too quickly
|
15:50:34
|
<nribeka> i don't bring money with me
|
15:50:42
|
<nribeka> since there's no pnc bank around here
|
15:50:44
|
<bwolfe> r0bby: we're paying him in chickens
|
15:51:01
|
<r0bby> good
|
15:51:54
|
<nribeka> and the chicken will lay eggs
|
15:51:55
|
<nribeka> :D
|
15:52:05
|
<nribeka> and i will have more chickens thanks to RI
|
15:59:24
|
<Echidna> bwolfe: isnt that like, ghetto
|
15:59:37
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1719 (task created): Patch to Liquibase Jar to Speed up Preconditions <http://dev.openmrs.org/ticket/1719> || Justin Miranda: On the Analysis Dashboard <http://blog.justinmiranda.com/2009/08/on-analysis-dashboard.html>
|
15:59:51
|
<bwolfe> Echidna: yes, sketchy and ghetto are usually synonymous
|
16:00:07
|
<Echidna> no i mean having a money clip
|
16:00:53
|
<bwolfe> Echidna: Hmm, I don't know that there is a distinction between ghetto'ers and nonghetto'ers and how they carry their money here
|
16:01:05
|
<bwolfe> ghetto'ers will have chains on their wallets
|
16:01:11
|
<bwolfe> but other than that...
|
16:01:19
|
<Echidna> bwolfe: i have a hibernate question for you. since it's discouraged to put any logic into getters and setters, and you want to monitor the properties and execulte some code if the values change
|
16:01:23
|
<Echidna> how would you go about it
|
16:01:56
|
<Echidna> i prefer not using cash at all, i just carry around some for lunch
|
16:02:01
|
<bwolfe> Echidna: monitor it on save in the service
|
16:02:32
|
<Echidna> bwolfe: i mean in general, not openmrs. lets say there is no service
|
16:02:47
|
<Echidna> what about listeners
|
16:02:59
|
<bwolfe> Echidna: listeners in the pojo ?
|
16:03:09
|
<Echidna> yea
|
16:09:26
|
<bwolfe> Echidna: I suppose thats one way
|
16:10:38
|
<Echidna> know any better?
|
16:30:14
|
*** bmckown_ has joined #openmrs
|
16:30:29
|
*** atomicturtle has left #openmrs
|
16:31:17
|
*** bwolfe_ has joined #openmrs
|
16:31:17
|
*** ChanServ sets mode: +o bwolfe_
|
16:31:28
|
*** bwolfe has quit IRC
|
16:32:18
|
*** bmckown has quit IRC
|
16:42:44
|
*** upul has quit IRC
|
17:32:30
|
<r0bby> is it bad practice to call a validator from outside a controller?
|
17:32:43
|
<r0bby> i pass off processing to my utility class
|
17:32:51
|
<r0bby> (which REALLY belongs in my service class
|
17:33:21
|
<r0bby> I need to validate an XML document contains certain attributes and I want to return useful output to the user
|
17:33:49
|
<r0bby> er XML element
|
17:49:16
|
*** jmiranda has quit IRC
|
17:50:28
|
*** jmiranda has joined #openmrs
|
17:50:28
|
*** ChanServ sets mode: +o jmiranda
|
17:57:33
|
*** mkulumadzi has quit IRC
|
17:59:51
|
*** nribeka_ has joined #openmrs
|
18:15:23
|
<bwolfe_> r0bby: I think you can call a validator from a service method
|
18:17:53
|
*** nribeka has quit IRC
|
18:30:43
|
*** bmckown_ has quit IRC
|
18:31:32
|
*** nribeka has joined #openmrs
|
18:31:32
|
*** ChanServ sets mode: +v nribeka
|
18:46:01
|
*** bmckown_ has joined #openmrs
|
18:48:32
|
*** nribeka_ has quit IRC
|
19:17:16
|
*** bwolfe_ is now known as bwolfe
|
19:40:26
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [9686]: ncd: Updated NCD dataset w/ manual review status type rows. <http://dev.openmrs.org/changeset/9686> || OpenMRS Changesets: Changeset [9685]: Adding modified liquibase jar to speed up preconditions - #1719 <http://dev.openmrs.org/changeset/9685> || OpenMRS Changesets: Changeset [9684]: Adding modified liquibase jar to speed up preconditions - #1719 <http://dev.openmrs.org/changeset/9684> || OpenMRS Changesets: Changeset [9683]: ncd: Reverting to the former generic test message in shouldHandleMessage. <http://dev.openmrs.org/changeset/9683>
|
19:53:36
|
*** james_regen has quit IRC
|
19:55:13
|
*** bmckown_ has quit IRC
|
20:18:27
|
*** nribeka_ has joined #openmrs
|
20:32:43
|
*** nribeka__ has joined #openmrs
|
20:34:37
|
*** winardi has joined #openmrs
|
20:34:54
|
*** ChanServ sets mode: +v winardi
|
20:35:05
|
*** nribeka has quit IRC
|
20:44:32
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1723 (task created): The Installer Should Allow For Upgrading OpenMRS War file <http://dev.openmrs.org/ticket/1723> || OpenMRS Tickets: Ticket #1722 (task created): Add Text to Final Installer Panel <http://dev.openmrs.org/ticket/1722> || OpenMRS Tickets: Ticket #1721 (task created): Update NBI Installer For OpenMRS 1.5 <http://dev.openmrs.org/ticket/1721> || OpenMRS Changesets: Changeset [9688]: install/nbi: Updated the nbi installer to work with openmrs 1.5 (removed ⦠<http://dev.openmrs.org/changeset/9688> || OpenMRS Tickets: Ticket #1720 (task created): NBI Installer Doesn't Start Tomcat or Install MySQL Properly <http://dev.openmrs.org/ticket/1720> || OpenMRS Changesets: Changeset [9687]: sockethl7listener:take care of spaces in provider firstname and/or ⦠<http://dev.openmrs.org/changeset/9687>
|
20:50:38
|
*** nribeka_ has quit IRC
|
20:53:29
|
*** nribeka__ has quit IRC
|
21:16:34
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [9690]: Changed the uuid length to 38 characters - #1711 <http://dev.openmrs.org/changeset/9690> || OpenMRS Tickets: Ticket #1719 (task closed): Patch to Liquibase Jar to Speed up Preconditions <http://dev.openmrs.org/ticket/1719#comment:1> || OpenMRS Changesets: Changeset [9689]: 1.5.x: Adding modified liquibase jar to speed up preconditions - #1719 <http://dev.openmrs.org/changeset/9689>
|
21:23:22
|
<winardi> ah finally ... a good jsp editor plugin for eclipse with auto complete feature :)
|
21:30:24
|
*** winardi has quit IRC
|
21:31:12
|
*** Mkop has joined #openmrs
|
21:47:43
|
*** bwolfe has quit IRC
|
21:47:52
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1724 (task created): Make Bad Database Credentials Error More Descriptive <http://dev.openmrs.org/ticket/1724> || OpenMRS Tickets: Ticket #1711 (enhancement closed): Increase uuid column length to 38 characters <http://dev.openmrs.org/ticket/1711#comment:6> || OpenMRS Changesets: Changeset [9691]: 1.5.x: Changed the uuid length to 38 characters - #1711 <http://dev.openmrs.org/changeset/9691>
|
21:49:40
|
*** Mkop has quit IRC
|
21:49:42
|
*** Mkop1 has joined #openmrs
|
22:16:02
|
*** Mkop1 has quit IRC
|
22:16:24
|
*** Mkop has joined #openmrs
|
22:18:37
|
<OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1725 (task created): Adding Deactivate/Reactivate or Retire/Unretire Options in User Form <http://dev.openmrs.org/ticket/1725>
|