| 00:10:08 | *** estebanpv has joined #openmrs |
| 00:21:36 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11486]: patientflags: added generateFlagsForPatient(Patient,Filter) method and ⦠<http://dev.openmrs.org/changeset/11486> |
| 00:26:52 | *** atomicturtle has joined #openmrs |
| 00:32:04 | *** meonkeys has left #openmrs |
| 00:53:37 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11487]: patientflags: changed "tag" field/variable in Tag object to "name" <http://dev.openmrs.org/changeset/11487> |
| 01:02:59 | *** atomicturtle has left #openmrs |
| 01:36:49 | *** estebanpv_ has joined #openmrs |
| 01:54:04 | *** estebanpv has quit IRC |
| 02:13:54 | *** njero has quit IRC |
| 02:14:23 | *** njero has joined #openmrs |
| 02:14:23 | *** ChanServ sets mode: +v njero |
| 02:22:04 | *** njero has quit IRC |
| 02:23:48 | *** upul has joined #openmrs |
| 02:23:49 | *** ChanServ sets mode: +v upul |
| 02:50:02 | *** Guest41363 has joined #openmrs |
| 02:53:38 | *** Guest41363 has quit IRC |
| 03:25:31 | *** atomicturtle has joined #openmrs |
| 03:53:59 | *** atomicturtle has quit IRC |
| 03:55:49 | *** atomicturtle has joined #openmrs |
| 04:55:06 | *** njero has joined #openmrs |
| 04:55:06 | *** ChanServ sets mode: +v njero |
| 05:19:30 | *** upul has quit IRC |
| 05:22:56 | *** upul has joined #openmrs |
| 05:22:56 | *** ChanServ sets mode: +v upul |
| 06:28:23 | *** pascal` has joined #openmrs |
| 06:31:54 | *** pascal` has quit IRC |
| 06:46:21 | *** pascal` has joined #openmrs |
| 06:55:19 | *** atomicturtle has quit IRC |
| 06:55:20 | *** atomicturtle1 has joined #openmrs |
| 06:59:58 | <upul> hey pascal` |
| 07:00:06 | <pascal`> hi upul |
| 07:18:20 | <pascal`> Echidna, feeling better? |
| 07:19:00 | <upul> don't drive naked Echidna |
| 07:20:49 | <pascal`> =O |
| 07:35:41 | <pascal`> upul, ever seen a class not found exception when trying to run a junit testcase? |
| 07:36:03 | <pascal`> i've seen it sometimes, and usually cleaning the project, or refreshing or rebuilding helps, but not this time.. arg. |
| 07:41:42 | <upul> never |
| 07:43:09 | <pascal`> ok |
| 07:43:17 | <pascal`> just needed to make a change to the test and rebuild |
| 07:43:28 | <pascal`> aparently the tests directory isn't in the source path |
| 07:43:36 | <pascal`> so wasn't building when i cleaned/refreshed |
| 07:54:41 | *** estebanpv_ has quit IRC |
| 08:41:21 | *** njero has quit IRC |
| 08:41:50 | *** njero has joined #openmrs |
| 08:41:50 | *** ChanServ sets mode: +v njero |
| 08:57:36 | *** njero has quit IRC |
| 09:03:57 | <upul> i don't get errors in junit i get shiny red bars |
| 09:16:10 | *** r0bby has quit IRC |
| 09:20:43 | *** r0bby has joined #openmrs |
| 09:20:43 | *** ChanServ sets mode: +v r0bby |
| 09:28:12 | <Echidna> pascal`: not rly |
| 09:28:29 | <pascal`> =\ |
| 09:37:25 | <upul> faked sick |
| 09:37:41 | <upul> Echidna malingering |
| 09:49:40 | <Echidna> if i was faking sick i wouldnt be at the office now |
| 09:49:44 | <Echidna> otherwise what is the point |
| 09:53:50 | *** atomicturtle1 has quit IRC |
| 09:54:34 | *** atomicturtle has joined #openmrs |
| 09:57:51 | <upul> i can't go home today until the evening |
| 09:59:02 | <upul> road closed for precident's going to the elections office |
| 10:00:52 | <Echidna> what a dick |
| 10:01:15 | <upul> this is why sri lanka is sri lanka |
| 10:01:32 | <Echidna> are there other candidates? |
| 10:01:57 | <upul> former army chief only contender |
| 10:02:10 | <upul> there's 23 candiates :-D |
| 10:02:31 | <Echidna> who are you voting for |
| 10:02:48 | <upul> most of them are precidents henchmen |
| 10:02:58 | <upul> army chief |
| 10:03:51 | <upul> but he said the stupidest thing last week, government media is saying traitor, traitor since then |
| 10:04:42 | <upul> we have opposition leader who lost, i don't know 15 elections or so |
| 10:05:08 | <Echidna> =o |
| 10:05:21 | <Echidna> so the media is controlled by the govt? |
| 10:05:54 | <upul> he never resigns, until he's going they will be opposition ad inifinitum |
| 10:06:14 | <upul> nope there are some, and many private ones |
| 10:06:37 | <upul> but some of them are bent to governemnt, (businessman) |
| 10:07:30 | <upul> i was hoping army chief and do something like singapore or south korea |
| 10:07:53 | <Echidna> what did they do |
| 10:11:03 | <upul> http://en.wikipedia.org/wiki/Park_Chung-hee |
| 10:11:04 | <upul> http://en.wikipedia.org/wiki/Lee_Kuan_Yew |
| 10:11:45 | <upul> we need somebody like that |
| 10:12:01 | <upul> but i don't think it'll happen |
| 10:17:34 | <upul> yesterday another politican jumped from opposition to governement |
| 10:19:02 | <upul> got a minister position, there's so many like that, i think we have the biggest number of ministers must be 100+ |
| 10:23:38 | <Echidna> =o |
| 10:27:56 | <upul> how's germany Echidna |
| 10:31:47 | <Echidna> cold |
| 10:31:51 | <Echidna> about -5°C |
| 10:32:30 | <upul> cold is good |
| 10:34:02 | <Echidna> not rly |
| 10:34:37 | <upul> i don't like sweaty weather |
| 10:35:59 | <upul> warm countries people do nothing |
| 10:36:15 | <upul> unless somebody drive them with a stick like in singapore |
| 10:38:23 | <upul> how's germany's politicians Echidna |
| 10:38:55 | <Echidna> uptight |
| 10:38:57 | <Echidna> but mostly solid |
| 10:39:09 | <Echidna> as far as not being corrupt goes etc |
| 10:40:29 | <upul> in sri lanka it's bribes, thuggery and currupted |
| 10:41:05 | <upul> that's why germany is germany and sri lanka is sri lanka |
| 10:44:52 | <Echidna> well corruption is common |
| 10:44:59 | <Echidna> it's not jsut a sri lankan thing |
| 10:45:25 | <Echidna> corruption in the public sector is quite common in russia, for example |
| 10:46:36 | <upul> yeah as well as in in somalia, uganda, bangladesh ... :-D |
| 10:52:07 | <upul> and there's a pattern |
| 10:55:53 | <Echidna> well i guess corruption is proportional to poverty |
| 10:59:11 | <Echidna> people play by the rules when they can afford to |
| 11:02:36 | <upul> but if everyone play by the rules then it will come to a state that everyone can afford to |
| 11:05:42 | <Echidna> that kind of thinking is not natural for humans |
| 11:05:49 | <Echidna> people care about themselves |
| 11:07:20 | <upul> but you can make people do the right thing |
| 11:08:07 | <Echidna> people have tried to force people into doing what they thought was right |
| 11:08:21 | <Echidna> all of them were dictatorships and didnt do that well |
| 11:09:02 | <upul> singapore is doing that, and they're doing it really well |
| 11:09:42 | <upul> and south korea did that too |
| 11:10:30 | <upul> in sri lanka 'korea' is a word for shanties area because in 1960 they were like that |
| 11:11:36 | <upul> we sri lankan chimpanzees were bragging we are great |
| 11:15:05 | <upul> s/we/they |
| 11:17:56 | <upul> hope the road is open now |
| 11:18:02 | *** upul has quit IRC |
| 11:29:55 | *** Mkop has joined #openmrs |
| 12:27:10 | *** abdelkarim has joined #openmrs |
| 12:27:16 | <abdelkarim> hello |
| 12:27:43 | <abdelkarim> Am having problem looking at patient page with omrs 1.4.5: java.sql.SQLException: Unknown column 'this_1_.accession_number' in 'field list' |
| 12:28:08 | <abdelkarim> I've heard about a tomcat version issue ; would that be possible ? |
| 12:28:35 | <abdelkarim> Am using Apache Tomcat/6.0.18 |
| 12:28:55 | <Echidna> do you have 6.0.16 by chance? |
| 12:29:39 | <abdelkarim> it's 6.0.18 |
| 12:29:52 | <Echidna> i mean do you have a 6.0.16 around that you could install to test |
| 12:29:56 | <abdelkarim> it's from my repository (ubuntu) |
| 12:30:00 | <Echidna> oh |
| 12:30:04 | <abdelkarim> I certainly can |
| 12:30:15 | <abdelkarim> is 6.0.16 the recommended one ? |
| 12:30:22 | <Echidna> well no |
| 12:30:36 | <Echidna> but i read there was something 6.0.18 and up didnt handle well |
| 12:30:45 | <Echidna> or were more script about that made openmrs mess up |
| 12:30:49 | <Echidna> but that was fixed i think |
| 12:31:00 | <Echidna> it was a single/double quote issue in jsp i think |
| 12:31:07 | <abdelkarim> hum |
| 12:31:08 | <Echidna> so not a db issue |
| 12:31:52 | <abdelkarim> ok ; will try another version |
| 12:33:45 | *** upul has joined #openmrs |
| 12:33:45 | *** ChanServ sets mode: +v upul |
| 12:41:08 | *** Mkop has quit IRC |
| 12:45:13 | <abdelkarim> Echidna: exact same problem with 6.0.14 |
| 12:45:58 | <pascal`> as jmiranda pointed out in the implementers list email, it's a db sync issue |
| 12:46:10 | <pascal`> it's looking for a column called accession_number which doesn't appear to exist |
| 12:48:43 | <abdelkarim> ok |
| 12:48:44 | <abdelkarim> thanks |
| 12:49:49 | *** upul has quit IRC |
| 12:49:57 | *** upul has joined #openmrs |
| 12:49:57 | *** ChanServ sets mode: +v upul |
| 12:55:33 | *** atomicturtle has quit IRC |
| 12:55:58 | *** atomicturtle has joined #openmrs |
| 13:28:13 | *** abdelkarim has left #openmrs |
| 13:41:36 | *** Mkop has joined #openmrs |
| 13:50:25 | *** bwolfe_ has joined #openmrs |
| 13:50:25 | *** ChanServ sets mode: +o bwolfe_ |
| 13:52:36 | *** bwolfe_ is now known as bwolfe |
| 13:55:30 | <pascal`> hey bwolfe |
| 13:55:58 | *** upul has quit IRC |
| 13:57:58 | <bwolfe> hi pascal` |
| 14:07:40 | *** Mkop has quit IRC |
| 14:10:41 | *** atomicturtle has left #openmrs |
| 14:24:54 | <Echidna> hi |
| 14:31:38 | <bwolfe> hi Echidna |
| 14:35:41 | <Echidna> wut up |
| 14:39:13 | *** openmrs_web161 has joined #openmrs |
| 14:39:29 | *** openmrs_web161 has quit IRC |
| 14:41:59 | <Echidna> why do commons-* libraries never complain about missing other commons jars until runtime? |
| 14:48:58 | *** njero has joined #openmrs |
| 14:48:58 | *** ChanServ sets mode: +v njero |
| 14:50:23 | *** pascal` has quit IRC |
| 15:02:15 | *** pascal` has joined #openmrs |
| 15:09:30 | *** pascal` has quit IRC |
| 15:24:11 | *** pascal` has joined #openmrs |
| 15:43:29 | *** atomicturtle has joined #openmrs |
| 15:44:52 | *** upul has joined #openmrs |
| 15:44:52 | *** ChanServ sets mode: +v upul |
| 15:48:36 | <bwolfe> Echidna: they're being "helpful" |
| 15:51:22 | <Echidna> lol.. |
| 16:00:15 | <upul> germany has water bridges |
| 16:03:02 | <upul> http://inlinethumb27.webshots.com/44058/2027614660104237032S600x600Q85.jpg |
| 16:03:07 | <OpenMRSBot> <http://ln-s.net/4ho5> (at inlinethumb27.webshots.com) |
| 16:12:33 | <Echidna> =o |
| 16:12:35 | <Echidna> didnt know |
| 16:14:01 | <upul> http://en.wikipedia.org/wiki/Magdeburg_Water_Bridge |
| 16:14:04 | <OpenMRSBot> <http://ln-s.net/4hoK> (at en.wikipedia.org) |
| 16:28:04 | *** Mkop has joined #openmrs |
| 16:43:23 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1976 (defect created): BIRT Module Error: Cannot get the result set metadata. <http://dev.openmrs.org/ticket/1976> |
| 16:44:31 | <bwolfe> upul: how much time per day do you spend on wikipedia looking up random things?? |
| 16:45:30 | * Mkop goes to check IRC logs.... |
| 16:45:35 | <Mkop> it better be worth it |
| 16:46:04 | <bwolfe> Mkop: I'm thinking its about twice a week upul posts a link to something on wikipedia (something random) |
| 16:51:29 | <Mkop> I don't get the point of that bridge |
| 16:51:47 | <Mkop> why don't the rivers just join, to make a + sign? |
| 16:52:57 | <bwolfe> lol, just put a stop sign in for the two rivers |
| 16:53:46 | <Echidna> a cop with a stick |
| 16:54:16 | <Mkop> I am running right now on 0 hours of sleep and a red bull |
| 16:54:24 | <Mkop> and I'm not at all tired |
| 16:54:37 | <Echidna> red bull contains bull semen |
| 16:54:43 | <Mkop> I had the red bull with me in my final |
| 16:54:49 | <Mkop> wasn't sure if I was gonna need it or not |
| 16:55:02 | <Mkop> but then I noticed myself doze off randomly while reading a question |
| 16:55:05 | <Mkop> that kinda sealed it for me |
| 16:55:09 | <Mkop> Echidna: myth. |
| 16:55:32 | <Echidna> i know =) |
| 16:57:59 | <Mkop> http://www.youtube.com/watch?v=nXa02tB8DLo |
| 16:58:09 | <Mkop> I want to make a commercial for red bull |
| 16:58:29 | <Mkop> shows 6 college students sitting around the table |
| 16:58:38 | <Mkop> bleary-eyed |
| 16:58:51 | <Mkop> clock in the background shows 4am |
| 16:58:58 | <Mkop> each one has a red bull in front of them |
| 16:59:08 | <Mkop> math equations all over the chalk board |
| 16:59:25 | <Mkop> one of them looks up tiredly and says "Welcome to my world. The world of redbull." |
| 17:00:21 | <upul> i just dozed off on the keyboard |
| 17:01:32 | <Mkop> actually, revise my commercial |
| 17:01:42 | <Mkop> the cameraman is walking through the library |
| 17:01:59 | <Mkop> at one table is a group of students with math equations behind them on the chalkboard |
| 17:02:30 | <Mkop> at another table is a guy with a laptop, with Microsoft Word open, and he's asleep on the keyboard |
| 17:02:47 | <Mkop> another guy is half asleep over his biology textbook |
| 17:05:15 | <Echidna> and? |
| 17:05:39 | <Echidna> looks like someone else dozed off on their keyboard lol |
| 17:05:47 | <upul> what's the difference between energy drink and other drink |
| 17:05:58 | <Echidna> the energy, duh! |
| 17:06:54 | <Mkop> I didn't doze off |
| 17:07:03 | <Mkop> the same ending applies |
| 17:07:15 | <Mkop> <Mkop> one of them looks up tiredly and says "Welcome to my world. The world of redbull." |
| 17:07:25 | <Echidna> one of who |
| 17:07:38 | <Mkop> the people in the library |
| 17:07:44 | <Echidna> remember, you moved the camera away from the math table |
| 17:07:52 | <Echidna> and to the table where people are asleept |
| 17:07:53 | <Echidna> -t |
| 17:08:17 | <Mkop> they're only half asleep |
| 17:08:59 | <Echidna> well that's a pretty depressing commercial |
| 17:10:36 | <upul> we have a commercial now in tv some times 3-4 going continously, actors saying vote for precident |
| 17:10:48 | <upul> gross abuse of power |
| 17:11:24 | <Echidna> does the other guy have ads? |
| 17:11:42 | <Echidna> it's common for parties to advertise on tv |
| 17:11:52 | <Echidna> the channels are required to air all of them |
| 17:13:32 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11489]: chica * added checks for null dispense date * fixed doctor list on Manual ⦠<http://dev.openmrs.org/changeset/11489> || OpenMRS Changesets: Changeset [11488]: rgccd * added checks for null dispense date <http://dev.openmrs.org/changeset/11488> |
| 17:13:42 | <upul> haven't seen any yet |
| 17:13:43 | *** atomicturtle1 has joined #openmrs |
| 17:13:44 | *** atomicturtle has quit IRC |
| 17:18:25 | <Echidna> http://www.youtube.com/watch?v=TgbhheNpRZ8 |
| 17:18:38 | <Echidna> the channels are required to identify political ads as such beforehand lol |
| 17:26:03 | <Mkop> they need to include the full 15 seconds before and 15 seconds after? |
| 17:26:33 | <Echidna> well it doesnt have to be 15 seconds |
| 17:27:30 | <Mkop> here, a political ad will usually have a 5 second "I'm Barrack Obama, and I approved this message" or the like |
| 17:27:31 | <Echidna> but they have to say "you're seeing the ad for the <election name> from <full party name>, <party abbreviation>. only the parties are responsible for the contents of the spot." |
| 17:31:24 | *** SparFux has joined #openmrs |
| 17:31:33 | <SparFux> Hi all. |
| 17:31:45 | <upul> hi |
| 17:31:52 | <SparFux> How are you? |
| 17:32:02 | <Echidna> hi |
| 17:32:05 | <Echidna> time to go home |
| 17:32:28 | <SparFux> Ok ok. |
| 17:32:39 | <SparFux> from work? |
| 17:32:59 | <upul> did you get openmrs problems fixed SparFux |
| 17:33:09 | <upul> database error or something |
| 17:34:21 | <SparFux> upul: no, unfortunately not. |
| 17:34:37 | <SparFux> I still got the problem that obviously there is no connection to the database. |
| 17:34:49 | <SparFux> I suspect tomcat6 to be the culprit though. |
| 17:39:26 | <SparFux> the ideas jmiranda had with the /etc/hosts, host.allow and host.deny don't seem to be the reason. |
| 17:40:25 | <upul> what was the issue you had |
| 17:41:31 | <SparFux> I am trying to install the openmrs, 2009-12-09 or stable version 1.5.1. |
| 17:41:51 | <SparFux> in the setup process I tried lots of combinations of options. All have the same failure. |
| 17:42:38 | <upul> SparFux: can you connect to mysql through mysql adminstrator or something? |
| 17:43:03 | <SparFux> the mysql command line works. |
| 17:43:14 | <SparFux> I am searching for the error log... |
| 17:44:36 | <SparFux> http://pastebin.com/m2907ecab |
| 17:46:00 | <SparFux> I get not output in /var/log/tomcat6 about any error and not in /var/log/msql/ |
| 17:46:33 | <SparFux> only the installation process leads me to the page on pastebin. |
| 17:46:38 | <upul> and you have given correct mysql root credentials in the wizard? |
| 17:46:50 | <SparFux> upul: definitely |
| 17:47:04 | <SparFux> sudo -u mysql mysql -u root -p works ok. |
| 17:47:13 | <SparFux> I use the password which I use for this command line, too. |
| 17:47:29 | <SparFux> I read about some connection pooling problem in mysql or tomcat, whatever. |
| 17:47:33 | <SparFux> I am using tomcat6 and mysql5. |
| 17:47:37 | <upul> is there any access denied error in the logs or was that all you got |
| 17:47:56 | <SparFux> 5.1.41 |
| 17:48:23 | <SparFux> wait a moment, I get something in syslog. |
| 17:50:35 | <SparFux> http://pastebin.com/f5c2631d4 |
| 17:52:43 | <upul> do you give anything for mysql url in the wizard or use the default? |
| 17:53:03 | <SparFux> the default. |
| 17:53:16 | <SparFux> I tried to use 127.0.0.1 instead of localhost though, but didn't change anything. |
| 17:56:38 | <upul> try giving localhost and connect through command line, mysql -u root -p -h localhost |
| 17:57:37 | <SparFux> good idea. this works. |
| 17:57:57 | <SparFux> sudo -u tomcat6 mysql -u root -p -h localhost |
| 17:57:59 | <SparFux> work ok. |
| 18:00:27 | <upul> what is your os? |
| 18:02:18 | *** Mkop has quit IRC |
| 18:03:30 | *** bobbytek has joined #openmrs |
| 18:03:36 | *** bobbytek has left #openmrs |
| 18:04:14 | <SparFux> upul: Debian/GNU linux sid. |
| 18:08:02 | <SparFux> I am trying to grasp http://pastebin.com/f5c2631d4 : "java.lang.Thread.run(Thread.java:636) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago." |
| 18:12:01 | <jmiranda> SparFux, i did a ton of research on this |
| 18:12:13 | <jmiranda> on the Communications link failure |
| 18:12:14 | <SparFux> jmiranda: :-) |
| 18:12:20 | <SparFux> Yes. |
| 18:12:29 | <SparFux> perhaps I should installed openjdk dbg version. |
| 18:12:47 | <jmiranda> yeah, i think if it's not fixed with the localhost/127.0.0.1 change |
| 18:13:25 | <SparFux> then? |
| 18:13:35 | <jmiranda> it might be a jdk issue |
| 18:14:01 | <jmiranda> i thought for sure it was a mysql permission issue |
| 18:14:45 | <SparFux> jmiranda: I am definitely sure it's not the mysql permissions. |
| 18:14:55 | <jmiranda> but it sounds like you've tried everything from that |
| 18:15:02 | <jmiranda> perspective |
| 18:15:22 | <SparFux> yes. |
| 18:15:51 | <SparFux> even the point is, user tomcat6 can use mysql command line tool to access mysql db as user "root" with proper passphrase. |
| 18:16:14 | <upul> SparFux: do you have a mysql administrator or something? |
| 18:16:21 | <upul> a gui |
| 18:16:37 | <SparFux> why a gui? |
| 18:17:15 | <SparFux> mysqladmin I think I can install. |
| 18:17:34 | <upul> there was that issue with an extra 'localhost' entry in the user tables preventing connections |
| 18:17:51 | <upul> but in this case it doesn't say access denied but worth a try |
| 18:18:46 | <SparFux> extra localhost? |
| 18:21:42 | <jmiranda> multiple permission rows for the openmrs user |
| 18:21:59 | <SparFux> Ah! |
| 18:22:02 | <SparFux> Hm... |
| 18:22:06 | <SparFux> I have three! |
| 18:22:21 | <jmiranda> select * from mysql.user where user = 'openmrs'; |
| 18:22:24 | <jmiranda> that's fine |
| 18:22:29 | <jmiranda> you might have a couple |
| 18:22:41 | <jmiranda> but you should only one per host |
| 18:22:57 | <SparFux> http://pastebin.com/mf5b9b2b |
| 18:23:23 | <jmiranda> select host, user from mysql.user |
| 18:23:48 | <SparFux> well, I have one for openmrs, but three for root. |
| 18:23:55 | <jmiranda> that pastebin actually looks fine |
| 18:24:15 | <upul> i think those root ones could be a problem |
| 18:24:20 | <jmiranda> nope |
| 18:24:31 | <jmiranda> they specify access for specific hosts |
| 18:24:42 | <SparFux> ok, installed mysql-admin |
| 18:24:44 | <jmiranda> localhost, 127.0.0.1, computer-name |
| 18:24:56 | <jmiranda> root *should* have 3 hosts |
| 18:25:12 | <upul> i didn't see the user, host table |
| 18:25:27 | <upul> there could be root@localhost and root@% then root@localhost gets priority |
| 18:26:10 | <upul> and wizard may be getting the roo@% |
| 18:26:31 | <upul> i had that issue, my solution was to delete the root@localhost entry |
| 18:26:39 | <SparFux> hm.... |
| 18:26:47 | <SparFux> but then wizard should be changed. |
| 18:27:04 | <upul> this openmrs user you created manually isn't it |
| 18:27:28 | <SparFux> yes. |
| 18:27:29 | <upul> wizard shouldn't have been able to touch the db |
| 18:28:15 | <SparFux> I cannot drop that user? |
| 18:28:41 | <upul> which user? |
| 18:28:50 | <jmiranda> here's what mine looks like |
| 18:28:51 | <jmiranda> http://pastebin.com/m3b7c5419 |
| 18:29:36 | <SparFux> http://pastebin.com/m773819ce |
| 18:29:56 | <upul> i had root@% if i remember right |
| 18:30:04 | <upul> SparFux: user, host |
| 18:30:29 | <SparFux> http://pastebin.com/m7b39528c |
| 18:30:47 | <SparFux> I was trying to say: I cannot remove that openmrs user. |
| 18:31:01 | <jmiranda> right, what's the error |
| 18:31:05 | <SparFux> http://pastebin.com/m773819ce |
| 18:31:13 | <jmiranda> i think i ran into something similar on my mac yesterday |
| 18:31:34 | <jmiranda> yeah, that was the error i ran into |
| 18:31:34 | <SparFux> perhaps I should just reinstall the whole mysql crap. |
| 18:31:43 | <jmiranda> give me a second to remember what i did :) |
| 18:32:20 | * jmiranda punches himself for not writing it down |
| 18:32:38 | <SparFux> Yes, this happens to me also everything I don't write something down :-) |
| 18:32:52 | <SparFux> but not sure wether this is the problem for openmrs. |
| 18:33:23 | <upul> why is it talking about a 'openmrs'@'%' when there are no % entries |
| 18:33:30 | <jmiranda> i couldn't get the app to work when the database was in this state |
| 18:33:39 | <jmiranda> so i needed to remove all entries |
| 18:33:48 | <jmiranda> % means all |
| 18:33:55 | <SparFux> got it. |
| 18:33:59 | <jmiranda> do a quick google search on that exact error |
| 18:34:05 | <SparFux> http://pastebin.com/m2a46998d |
| 18:34:11 | <SparFux> this problem is solved. |
| 18:34:18 | <SparFux> drop user 'openmrs'@'localhost' ; |
| 18:34:51 | <upul> but there were no % entries |
| 18:35:40 | <SparFux> upul: I think mysql thinks % is the default when no hosts specified for user to be dropped. |
| 18:35:49 | <jmiranda> i'm on a call, but i'll check back in a little later |
| 18:36:19 | <SparFux> % obviously is the default. |
| 18:36:41 | <SparFux> anyway, perhaps I should kill all my previous installations and reinstall mysql from very scratch. |
| 18:37:47 | <SparFux> or better, I can try mysql 5.0 ? :-) |
| 18:38:02 | <upul> what were you using? |
| 18:38:12 | <SparFux> mysql 5.1 |
| 18:38:36 | <SparFux> 5.1.41 |
| 18:38:39 | <upul> then before reinstalling try removing the roo@'localhost' |
| 18:38:49 | <SparFux> ah, good idea :-) |
| 18:38:53 | <upul> that was the issue for me |
| 18:39:58 | <SparFux> i have root@myhostname, dropping too. |
| 18:40:12 | <SparFux> now only root@127.0.0.1 left. |
| 18:40:35 | <SparFux> same problem persists. |
| 18:41:45 | <SparFux> ok, I have to leave for now. will be back in about an hour I hope. |
| 18:42:14 | *** SparFux has quit IRC |
| 18:45:47 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11490]: chica * updated required rgccd module value <http://dev.openmrs.org/changeset/11490> |
| 18:56:05 | *** r0bby|android has joined #openmrs |
| 18:56:05 | *** ChanServ sets mode: +v r0bby|android |
| 18:59:02 | *** estebanpv has joined #openmrs |
| 19:17:51 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11493]: ncd:Another fix to the latest diff to account for pre-existing reportable ⦠<http://dev.openmrs.org/changeset/11493> || OpenMRS Changesets: Changeset [11492]: ncd:Fixed new SQL diff to delete the old County, Jurisdiction, and Zipcode ⦠<http://dev.openmrs.org/changeset/11492> || OpenMRS Changesets: Changeset [11491]: ncd:Added tests for County, Jurisdiction, and Zipcode DAOs. Added SQL to ⦠<http://dev.openmrs.org/changeset/11491> |
| 19:48:30 | *** jacobb has joined #openmrs |
| 19:48:36 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11494]: chica * removed old installer <http://dev.openmrs.org/changeset/11494> |
| 20:08:16 | *** njero has quit IRC |
| 20:08:46 | *** njero has joined #openmrs |
| 20:08:46 | *** ChanServ sets mode: +v njero |
| 20:09:10 | *** njero_ has joined #openmrs |
| 20:19:55 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11495]: chica * updated form update scripts * added scripts to upgrade from chica ⦠<http://dev.openmrs.org/changeset/11495> |
| 20:20:25 | *** upul has quit IRC |
| 20:26:23 | *** njero has quit IRC |
| 20:45:13 | *** SparFux has joined #openmrs |
| 20:45:21 | <SparFux> re |
| 20:50:29 | <bwolfe> re? |
| 20:50:35 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11496]: chica * added upgrade scripts for location changes <http://dev.openmrs.org/changeset/11496> |
| 20:52:48 | <SparFux> yeah, I have been here one hour before. |
| 20:52:56 | <SparFux> more than one hour. |
| 20:57:31 | <bwolfe> SparFux: looks like 2 hours and 4 mins. :-) |
| 20:59:08 | <SparFux> hehe :-D |
| 21:03:48 | <SparFux> I read an article on the web - don't know where, was at work - that multiple instances of the jdbc driver could be the problem for my database connection problem. |
| 21:04:36 | *** pascal` has quit IRC |
| 21:10:00 | <SparFux> http://pastebin.com/m7c73cd57 |
| 21:10:49 | <SparFux> I now have to hack into my new debian mysql installation agian. Password is unknown. :-( |
| 21:22:03 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11497]: atd scorable_jit_branch * creating branch for development to support ⦠<http://dev.openmrs.org/changeset/11497> || OpenMRS Tickets: Ticket #1977 (defect created): Patient Age Should stop increasing when the patient dies <http://dev.openmrs.org/ticket/1977> |
| 21:46:55 | *** Mkop has joined #openmrs |
| 21:51:30 | *** estebanpv has quit IRC |
| 21:54:07 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11498]: chica scorable_jit_branch * for development to support scorable JITs <http://dev.openmrs.org/changeset/11498> || Justin Miranda: On backing up and restoring large mysql databases <http://blog.justinmiranda.com/2009/12/on-backing-up-and-restoring-large-mysql.html> |
| 23:00:33 | *** njero_ is now known as njero |
| 23:02:34 | *** bwolfe has quit IRC |
| 23:25:12 | *** atomicturtle1 has quit IRC |
| 23:26:00 | *** r0bby|android has quit IRC |
