| # | Time | Nick | Message |
|---|
| # | 03:53:04 | darshan has joined #evergreen |
| # | 03:54:18 | darshan | what will be the user and domain and passsword for 8 step in installing opensrf 2.0.1 |
| # | 04:06:20 | darshan | ejabberdctl register <user> <domain> <password> what will be user and password and domain for this |
| # | 04:34:52 | darshan | ? |
| # | 04:55:48 | darshan has quit IRC |
| # | 04:56:47 | darshan1 has joined #evergreen |
| # | 05:01:39 | darshan1 has quit IRC |
| # | 05:45:42 | darshan has joined #evergreen |
| # | 05:46:19 | darshan | hello |
| # | 05:47:30 | darshan | while performing 9.1 step of opensrf 2.0.1 installation,i am receving an error "opensrf is not in sudoers file,this incident will be reported" |
| # | 05:47:42 | darshan | plz guide me for solution |
| # | 06:15:31 | phasefx | darshan: as root, type visudo (this will open a file, probably with the vi(m) editor, which I'm not going to explain how to use) There's a line that starts with the word "root". You should copy that line and paste a new one right below the original. Then, with the new line, change "root" to "opensrf". Save the file and exit vim. THen you'll be able to use sudo from the opensrf account. |
| # | 06:15:37 | phasefx | Alternately, you don't have to use sudo at all. You can just change to the root user and then do what whatever you're doing |
| # | 06:16:21 | phasefx doesn't see the sudo command being used in step 9.1 |
| # | 06:21:32 | darshan | yes |
| # | 06:21:59 | darshan | der si not,but to edit file i was using sudo command and too as an opensrf user |
| # | 06:22:07 | darshan | dats why neways tahnkx |
| # | 06:22:26 | darshan | btw at wat time u all cum online |
| # | 06:29:04 | phasefx | you'll see folks trickle in about 2 hours from now. It's a fluke I'm up, and... I'm going back to bed. :D |
| # | 07:25:39 | darshan | IN opensrf 2.0.1 10th step ,my log file is located at <logfile>/openils/var/log/srfsh.log</logfile> so should i cahge the location to /tmp/srfsh.log |
| # | 07:25:58 | darshan | according to doc |
| # | 07:28:27 | darshan | IN opensrf 2.0.1 10th step ,my log file is located at <logfile>/openils/var/log/srfsh.log</logfile> so should i change the location to /tmp/srfsh.log |
| # | 07:38:44 | csharp | darshan: it doesn't really matter... if you want to preserve your logs, keep them at the /openils/var/log location - if not, change to /tmp (which is probably cleared out each time you upgrade) |
| # | 07:39:15 | csharp | darshan: sorry, *restart*, not "upgrade" |
| # | 08:11:28 | darshan | now when i am performing last step of moving to /openils/bin/srfsh then iam getting error dat is "-bash : cd: /openils/bin/srfsh: Not a directory" |
| # | 08:13:13 | csharp | darshan: what is the exact command you're typing in? |
| # | 08:14:12 | darshan | cd /openils/bin/srfsh |
| # | 08:14:47 | csharp | darshan: where does it say to do that? (which set of instructions are you following?) |
| # | 08:16:03 | darshan | in opensrf 2.0.1 doc,in it i m performing last step ,of testing connection to opensrf |
| # | 08:16:58 | csharp | darshan: it's not 'cd /openils/bin/srfsh' it's just '/openils/bin/srfsh' |
| # | 08:17:06 | darshan | ok |
| # | 08:18:33 | csharp goes away |
| # | 08:18:35 | darshan | no config file found at /root/.srf.xml |
| # | 08:18:50 | darshan | this error is coming now |
| # | 08:19:22 | darshan | sorry this error , no config file found at /root/.srfsh.xml |
| # | 08:23:12 | darshan | ? ru back\ |
| # | 08:23:23 | jenny1 has joined #evergreen |
| # | 08:26:05 | darshan | no config file found at /root/.srfsh.xml |
| # | 08:30:40 | _bott_ has quit IRC |
| # | 08:31:31 | _bott_ has joined #evergreen |
| # | 08:31:56 | plux_ has joined #evergreen |
| # | 08:36:49 | darshan | can ne1 please help me |
| # | 08:37:09 | darshan | why this error is coming so |
| # | 08:40:19 | darshan | on my last step of installing opensrf 2.0.1 ,while starting srfsh ,i m giving command /openils/bin/srfsh |
| # | 08:40:26 | darshan | and so i m gettin error |
| # | 08:40:32 | darshan | no config file found at /root/.srfsh.xml |
| # | 08:40:53 | darshan | ne1 would help me out is appreciable |
| # | 08:44:30 | darshan has quit IRC |
| # | 08:45:00 | darshan has joined #evergreen |
| # | 08:45:05 | darshan | on my last step of installing opensrf 2.0.1 ,while starting srfsh ,i m giving command /openils/bin/srfsh |
| # | 08:52:51 | darshan | and i am gettin error |
| # | 08:53:44 | darshan | that is no config file found at /root/.srfsh.xml |
| # | 08:54:45 | Dyrcona has joined #evergreen |
| # | 08:57:17 | darshan | Dyrcona:? |
| # | 08:57:28 | Dyrcona | ? |
| # | 08:58:23 | darshan | Dyrcona:on my last step of installing opensrf 2.0.1 ,while starting srfsh ,i m giving command /openils/bin/srfsh,and i am gettin error, that is no config file found at /root/.srfsh.xml |
| # | 08:58:42 | darshan | ne suggestion please |
| # | 09:00:29 | Dyrcona | darshan: You need to copy srfsh.xml.example from the OpenSRF examples directory to ~/.srfsh.xml and edit it with the information for your accounts. |
| # | 09:03:29 | collum has joined #evergreen |
| # | 09:05:16 | Dyrcona is going to try turning this http://pastie.org/2735227 into a JSON query. |
| # | 09:06:21 | tsbere | Dyrcona: http://pastie.org/2732987 might be a more accurate variant. |
| # | 09:08:34 | Dyrcona | tsbere: show off. :) |
| # | 09:08:59 | Dyrcona | tsbere: I like it. I'll give that one a shot and see what I get. |
| # | 09:10:38 | Meliss has joined #evergreen |
| # | 09:10:52 | Dyrcona | tsbere: So, I can lose this, too: $row->[2] = join(':',@{$row->[2]}); |
| # | 09:11:45 | tsbere | Dyrcona: Yep. Although you will need to have a transform in the json query version for that one. |
| # | 09:11:57 | tsbere believes that is possible |
| # | 09:12:11 | kmlussier has joined #evergreen |
| # | 09:16:55 | Dyrcona | tsbere: Well, I could always cheat and use the reporter or cstore/storage configuration with DBI. |
| # | 09:17:39 | Dyrcona does that now in his own scripts. |
| # | 09:17:54 | eeevil | Dyrcona: you'll need to move the join to actor.org_unit_descendants() into a where-clause subquery, but yeah, it's doable |
| # | 09:18:16 | fortin has joined #evergreen |
| # | 09:20:15 | eeevil | Dyrcona: and you'll need to adjust how you're doing the pubdate comparison ... but IN or " = OR = " instead of "like '%'|| foo ||'%'" |
| # | 09:20:29 | eeevil | er, s/$/ should work/ |
| # | 09:20:44 | Dyrcona | eeevil: Yeah, I figured that would need some heavy modification. |
| # | 09:20:55 | Dyrcona | it's tsbere's code anyway. ;) |
| # | 09:21:20 | eeevil | ah, well, like I always say: when in doubt, blame tsbere! ;) |
| # | 09:21:24 | Dyrcona | We started with something written by bshum and then mangled it beyond recognition. |
| # | 09:21:43 | Dyrcona | git blame .... :) |
| # | 09:22:34 | gmcharlt | always git blame, never git praise ;) |
| # | 09:23:48 | csharp | @praise git blame |
| # | 09:23:48 | pinesol_green` | csharp: Error: There are no praises in my database for #. |
| # | 09:24:20 | csharp | pinesol_green`: you are the most boringest bot ever |
| # | 09:24:20 | pinesol_green` | csharp: Error: "you" is not a valid command. |
| # | 09:26:58 | tsbere | eeevil: In all fairness, it started off as psql, and Dyrcona was moving it into a perl script as a straight query. Moving it further to, say, json query throws out some of the original thoughts on the matter ;) |
| # | 09:28:45 | AaronZ-PLS has joined #evergreen |
| # | 09:29:26 | gmcharlt | @praise git blame |
| # | 09:29:26 | pinesol_green` git blame is the very model of a modern major hacker |
| # | 09:32:11 | eeevil | tsbere: totally just messing around |
| # | 09:32:28 | darshan | asa root:-/openils/bin/srfsh on running this command i m gettin error no config file found at /root/.srfsh.xml ,then as u said i again run command "cp /openils/conf/srfsh.xml.example /home/opensrf/.srfsh.xml" |
| # | 09:32:48 | darshan | and now again running i am getting same error :-/openils/bin/srfsh |
| # | 09:33:16 | Dyrcona thinks he should have paid a little more attention to what list his email was going to. |
| # | 09:33:57 | Dyrcona | darshan: If you're running as root, it needs to be in /root. I'd suggest not being root and running as opensrf user. |
| # | 09:34:39 | darshan | sorry but it would help me much more if u mention command for it |
| # | 09:34:48 | darshan | please |
| # | 09:36:03 | darshan | did u mean i should run /openils/bin/srfsh as an opensrf user and not as an root |
| # | 09:36:10 | darshan | ? |
| # | 09:36:28 | darshan | <Dyrcona>did u mean i should run /openils/bin/srfsh as an opensrf user and not as an root |
| # | 09:36:56 | Dyrcona | darshan: Yes, if that user has the configuration and root doesn't. Really you should never do anything as root unless you absolutely have to and then you should use sudo to do only what you need. |
| # | 09:37:18 | darshan | ok |
| # | 09:37:46 | Dyrcona | darshan: Evergreen and the installation instructions assume that the user is comfortable enough with Linux to understand these things already. My sincere suggestion to you is that you stop playing with Evergreen and more about Linux, first. |
| # | 09:37:50 | darshan | but in doc they hav given as a root |
| # | 09:38:02 | darshan | in 1.6 version they hav given |
| # | 09:38:07 | csharp | gmcharlt++ |
| # | 09:38:08 | darshan | and not in 2.0.1 |
| # | 09:38:20 | darshan | so i decide to perform this step as root |
| # | 09:38:26 | darshan | ok i m trying it |
| # | 09:41:40 | darshan | <Dyrcona> u wer really really really really correct |
| # | 09:41:45 | darshan | thankxxxxxxxxxx alot |
| # | 09:42:37 | gmcharlt | @praise add $who is kind and patient to newbies |
| # | 09:42:37 | pinesol_green` | gmcharlt: The operation succeeded. Praise #2 added. |
| # | 09:43:04 | Dyrcona | @praise gmcharlt |
| # | 09:43:04 | pinesol_green` gmcharlt is the very model of a modern major hacker |
| # | 09:43:33 | Dyrcona | darshan: you are welcome. |
| # | 09:44:58 | darshan | <Dyrcona> now i m again stuck |
| # | 09:46:04 | Dyrcona | darshan: tell us the problem. |
| # | 09:46:29 | darshan | srfsh# request opensrf.math add 2 2 on running this step its showing me received no data from server |
| # | 09:46:47 | darshan | y its happening so |
| # | 09:47:09 | Dyrcona | darshan: make sure that your opensrf services are running, that ejabberd is running, and check all of your configurations to make sure that they are correct. |
| # | 09:48:04 | Dyrcona | darshan: start by looking at .srfsh.xml and comparing it to /openils/conf/opensrf_core.xml |
| # | 09:55:37 | darshan | ok |
| # | 09:56:21 | darshan | tell me where can see .srfsh.xml file |
| # | 10:00:26 | darshan | i cant see .srfsh.xml in home directory of opensrf user |
| # | 10:01:22 | darshan | its example file is loacted at /openils/conf/srfsh.xml.example |
| # | 10:02:12 | darshan | and over der the loglevel is 4 <loglevel>4</loglevel> and in doc der r saying to keep it 3 |
| # | 10:02:27 | darshan | is that can be point of issue i m getting |
| # | 10:02:29 | darshan | ? |
| # | 10:04:07 | darshan | <Dyrcona>? |
| # | 10:04:25 | Dyrcona | darshan: ls -a |
| # | 10:04:51 | csharp | darshan: you really need to learn more about Linux before proceeding... |
| # | 10:04:53 | darshan | where should i run this command |
| # | 10:04:54 | Dyrcona | darshan: As I said before, you should really learn more about using Linux before you attempt something as complex as installing Evergreen. |
| # | 10:05:05 | Dyrcona | csharp++ |
| # | 10:05:38 | darshan | please i will ,but at this point help me frnds |
| # | 10:06:15 | csharp | darshan: that's probably the best help we can give you - there are many resources on the web for help with Linux (especially Ubuntu) |
| # | 10:06:23 | Dyrcona | darshan: The point is, we really can't help you until you know more about Linux, sorry. |
| # | 10:07:22 | darshan | but i m not asking about linux command |
| # | 10:07:51 | darshan | i just want to knew wat should i do now to solve my prb |
| # | 10:08:10 | darshan | i checked and my all serveices r running |
| # | 10:09:14 | csharp | darshan: this forum post provides some useful links for learning Ubuntu/Linux: http://ubuntuforums.org/showthread.php?t=801404 |
| # | 10:09:20 | Dyrcona | darshan: What you are asking to do requires running Linux commands, and your questions demonstrate a lack of knowledge in how Linux and the command line function. |
| # | 10:09:53 | Dyrcona | darshan: Without that basic knowledge on your part, we really can't help you further. This is not a forum for teaching linux. |
| # | 10:11:03 | Dyrcona | darshan: I'd recommend the Linux for Dummies series. Despite the condescending titles, they are actually well written, and I know a couple of the authors in the series. |
| # | 10:12:50 | darshan | ok just tell only one think wat problem is der dat is incomplete to my task for not successfully testing opensrf |
| # | 10:12:57 | darshan | i dont want ne solution |
| # | 10:13:08 | darshan | i just need to know wat wrong is happening |
| # | 10:13:13 | darshan | as dyrcona said |
| # | 10:13:17 | Dyrcona | darshan: You need to edit your configuration files. |
| # | 10:13:36 | Dyrcona | For that, you need to know how to find the files on the command line using ls, cd, and find. |
| # | 10:13:41 | darshan | check all services and all |
| # | 10:13:58 | darshan | and i check |
| # | 10:14:13 | Dyrcona | No. To configure the system properly. It does not come setup properly out of the box. Linux is not Winblows. Every system is different. |
| # | 10:14:39 | darshan | ok |
| # | 10:14:43 | Dyrcona | For security reasons, you can't just use a "default" configuration. |
| # | 10:14:50 | darshan | i agreed |
| # | 10:15:52 | Dyrcona | So, you need to come back when you can find files in command terminals, and when you've learned to edit files with one of the common editors on Linux: vim, nano, pico, emacs, gedit, etc. |
| # | 10:16:08 | darshan | ok |
| # | 10:16:19 | darshan | i think i knew them well |
| # | 10:16:26 | darshan | but no od=ffence to u |
| # | 10:16:43 | Dyrcona | darshan: No offence to you, but the questions you ask imply that you do not know them at all. |
| # | 10:17:01 | darshan | ya |
| # | 10:17:17 | Dyrcona | darshan: You asked how to find .srfsh.xml. I answered that you should use ls -a. You then asked where to run it. |
| # | 10:17:41 | Dyrcona | darshan: That is after you were told to copy the file to /home/opensrf/.srfsh.xml. |
| # | 10:18:05 | Dyrcona | darshan: The above exchange implies to me that you do not know the first about Linux file structure or the command line. |
| # | 10:19:01 | darshan | it correct that i m new born to linux |
| # | 10:19:12 | darshan | but i m in learning stage |
| # | 10:19:30 | csharp | darshan: Evergreen is not a good program to try installing at this stage |
| # | 10:19:35 | darshan | n with ur help i will learn only |
| # | 10:19:37 | csharp | darshan: start simpler |
| # | 10:19:51 | darshan | i m force to |
| # | 10:20:30 | darshan | i have even had good command on it |
| # | 10:20:32 | mrpeters-isl | darshan: perhaps you should tell the person "forcing" you that you're not experienced enough with Linux to try installing Evergreen? |
| # | 10:20:44 | mrpeters-isl | and perhaps they can get you the help you need at a more basic level |
| # | 10:20:50 | leed has quit IRC |
| # | 10:21:41 | darshan | ok |
| # | 10:21:43 | csharp | darshan: all of us here have had to put in the time to learn Linux. It's not something you can just learn on the fly, unfortunately |
| # | 10:24:06 | phasefx cut his teeth on Unix Power Tools back in the day; good stuff |
| # | 10:26:52 | leed has joined #evergreen |
| # | 10:31:16 | Dyrcona | Back to that query.... |
| # | 10:31:30 | Dyrcona | This was something that Bibliomation uses to dump data for a vendor. |
| # | 10:31:44 | Dyrcona | One of our members is signing up to use that vendor. |
| # | 10:32:00 | Dyrcona | So, we got the query originally from bshum and modified it a bit. |
| # | 10:32:22 | Dyrcona | Since the vendor wants a "csv" I thought I'd put it in perl and use Text::CSV. |
| # | 10:32:38 | tsbere | And now I am trying to decide if I want to look into making it RSS-able or otherwise visible in the TPac to provide a "new materials at location X" page. <_< |
| # | 10:33:18 | Dyrcona | tsbere: I thought of that last night, too, but SuperCat has some of those functions already. |
| # | 10:33:38 | tsbere | So teach SuperCat how to run it. :P |
| # | 10:34:15 | Dyrcona | Anyway, since the vendor is currently picking files up from the Bibliomation web server, we think we should possibly make this a WWW module (or yeah, a SuperCat feed). |
| # | 10:34:49 | Dyrcona | Now would be the time to work it out since only 1 customer of the vendor seems to be using it, and we could integrate as part of the standard Evergreen. |
| # | 10:35:11 | Dyrcona | We have other vendors for whom we gather similar information, so it may simplify a lot more things in the long run. |
| # | 10:35:48 | Dyrcona | I should actually ask someone at EBSCO about using an isbn feed instead of us uploading files to them every month. |
| # | 10:36:14 | Dyrcona has been chatty today. |
| # | 10:36:24 | Dyrcona | and it only not even lunch time. |
| # | 10:37:00 | Dyrcona | ouch..... I must have read the cursed scroll of learning disability. |
| # | 10:38:12 | jeff | i have supercat patches from the old "you can't release this" days. i'm in the process of digging them out. |
| # | 10:38:23 | jeff | you may beat me. dunno. |
| # | 10:39:46 | Dyrcona | jeff: cool. |
| # | 10:40:05 | Dyrcona | The more hands in this the better from my perspective. |
| # | 10:40:51 | Dyrcona | It would be a great example for some of our more sceptical members of how different elements of the community can collaborate on the same goal. |
| # | 10:44:27 | mrpeters-isl | has there been any discussion about adding ACH payments to Acquisitions? Pending sponsorship? |
| # | 10:46:37 | darshan | <Dyrcona> i search it,the file name .srfsh.xml is not present newer |
| # | 10:48:02 | sndwrx has quit IRC |
| # | 10:48:08 | Dyrcona | darshan: if you copied it and if srfsh starts as user opensrf then it must be at /home/opensrf/.srfsh.xml. |
| # | 10:48:25 | darshan | ya ur true |
| # | 10:48:54 | Dyrcona | darshan: You need to edit that file so srfsh can actually talk to ejabberd. You will find the relevant information in /openils/conf/opensrf_core.xml if that is properly configured. |
| # | 10:49:39 | jeff has quit IRC |
| # | 10:49:53 | darshan | hey igot it , |
| # | 10:49:55 | darshan | ok |
| # | 10:50:26 | Dyrcona wonders if it would be ok to add a csv output to supercat feeds if it isn't there already. |
| # | 10:50:39 | jeff has joined #evergreen |
| # | 10:50:39 | jeff has joined #evergreen |
| # | 10:52:17 | yboston has joined #evergreen |
| # | 10:53:45 | Dyrcona is going to work on his PhoneList branch, then make a pullrequest bug. |
| # | 10:57:58 | mrpeters-isl | what's your phonelist idea? |
| # | 10:59:16 | mrpeters-isl | we have libraries who actually call each and every patron who has an item due that day. I've toyed with the idea of making a staff client interface where you could pick an org unit and a date and get a list of all items checked out from that org unit which are due on a given date |
| # | 10:59:30 | mrpeters-isl | with the circ and user info |
| # | 11:00:19 | Dyrcona | mrpeters-isl: PhoneList is a WWW module for Evergreen that produces a CSV of patron information for items on the hold shelf. It is designed to be used by an automated calling solution that one of our members uses. |
| # | 11:00:39 | Dyrcona | mrpeters-isl: Long term goals include adding a list for overdues. |
| # | 11:00:55 | mrpeters-isl | cool! |
| # | 11:01:04 | Dyrcona | mrpeters-ils: I am presently going to add excel output as an option. |
| # | 11:01:59 | Dyrcona | what's cooler is the library in question gets the data daily with a curl program and has the calls happen without staff intervention. |
| # | 11:02:28 | darshan | <Dyrcona> i want to ask wat should i compare over in opensrf_core.xml file ,should i campare <srfsh> element but its not present in opensrf_core.xml file |
| # | 11:02:30 | mrpeters-isl | yeah that's awesome. atheos has had us doing hold calls with Asterisk for a while. Also totally intervention free. |
| # | 11:02:46 | mrpeters-isl | darshan: hostnames and passwords, perhaps? |
| # | 11:03:07 | mrpeters-isl | hint: srfsh's gotta be able to talk to ejabberd |
| # | 11:03:24 | Dyrcona | darshan: what mrpeters-isl said. |
| # | 11:03:32 | darshan | ok |
| # | 11:03:42 | Dyrcona | darshan: I think it is covered in the README somewhat. |
| # | 11:04:28 | Dyrcona | mrepeters-isl: I'd love to make ODF formats available as output in Evergreen, but doing it properly requires a lot of overhead. |
| # | 11:04:59 | mrpeters-isl | yeah, probably no need. csv gets you the same place, afterall |
| # | 11:05:15 | Dyrcona | BTW, if you're going to upgrade to Oneiric, do NOT install the lo-menu package. It breaks LibreOffice for me. |
| # | 11:06:19 | Dyrcona | mrpeters-isl: yeah. Which makes me wonder if I should really bother with Excel output from PhoneList and just stick with csv. |
| # | 11:07:01 | mrpeters-isl | i wouldnt! |
| # | 11:08:14 | mrpeters-isl has quit IRC |
| # | 11:08:38 | mrpeters-isl has joined #evergreen |
| # | 11:08:39 | Dyrcona | I'm cursed. Everyone I chat with disconnects. |
| # | 11:08:50 | Dyrcona | wb. |
| # | 11:08:54 | Dyrcona | :) |
| # | 11:09:25 | Dyrcona scratches a task off his todo list....Add Excel output to PhoneList. |
| # | 11:13:12 | Dyrcona | mrpeters-isl: http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/dyrcona/PhoneList.pm |
| # | 11:14:19 | darshan | guys correct me if i m not-is it at below the comment jabber login settings our domains should match that of the private router |
| # | 11:14:41 | Dyrcona | darshan: that is correct. |
| # | 11:14:42 | mrpeters-isl | awesome...ill keep an eye on this |
| # | 11:14:51 | darshan | ok |
| # | 11:15:00 | darshan | i make comparison in it |
| # | 11:15:07 | darshan | and overder |
| # | 11:18:17 | mrpeters-isl | is it possible for a json query in, say, Actor.pm to return all columns or do each need to be defined individually in the select => |
| # | 11:18:44 | darshan | <logfile>/openils/var/log/osrfsys.log</> and in .srfsh.xml it is <logfile>/openils/var/log/srfsh.log</> |
| # | 11:19:10 | Dyrcona | darshan: That's fine. |
| # | 11:19:16 | Dyrcona | Mine is the same and it works. |
| # | 11:19:42 | darshan | and <loglevel>3</loglevel> which is <loglevel>4</loglevel> in .srfsh.xml |
| # | 11:19:49 | Dyrcona | ditto |
| # | 11:20:05 | darshan | ok next |
| # | 11:20:26 | bshum | Does anyone know off hand which file(s) the receipt macros are specified in? |
| # | 11:20:27 | darshan | <loglength> this element is not der in .srfsh.xml |
| # | 11:21:27 | darshan | <setting_config>/openils/conf/opensrf.xml</> thios is also not present in .srfsh.xml |
| # | 11:21:40 | bshum | At first I was thinking they were somehow related to fm_IDL.xml stuff, but it seems like that isn't really the case. |
| # | 11:22:26 | jeff | bshum: they're locally on the client now. print_list_templates |
| # | 11:22:56 | jeff | bshum: there are some legacy hardcoded ones in the staff client js,i believe those are enabled with an ou setting. |
| # | 11:22:58 | darshan | remaining all is same |
| # | 11:23:11 | jeff | bshum: and the defaults are of course in the staff client js to begin with. |
| # | 11:23:43 | jeff | bshum: there's also new ou settings for including things in all receipts, tsbere's work, iirc. |
| # | 11:24:01 | phasefx | bshum: for a given list that's being printed, there's a util.list class, it has a dump_with_keys method, and those column keys are the are macros. Some newer lists use fm_IDL.xml for generating the column definitions (and the id's), but the early ones tend to be arbitrarily defined in various columns functions in various util.js files |
| # | 11:24:06 | Dyrcona | mrpeters-isl: $query = { from => 'aou' }; returns everything for me, so I'd say, yes. |
| # | 11:24:53 | Dyrcona | mrpeters-isl: If you join, though it will return the combined columns from all joined tables, I suspect. |
| # | 11:25:33 | Dyrcona | darshan: sounds about right. |
| # | 11:26:58 | darshan | now u only say wat then prb should be |
| # | 11:27:14 | darshan | my ejabberd and memcache both services r running |
| # | 11:27:39 | bshum | jeff: phasefx: Ahh okay, thanks guys. I'll take a look at those to see if I can learn something. Someone here was asking me why there wasn't a library phone macro, and I couldn't tell them which ones we really had (or didn't have) |
| # | 11:27:44 | darshan | even 11 step is running |
| # | 11:27:58 | Dyrcona | darshan: try this: ps ax | grep opensrf |
| # | 11:28:15 | Dyrcona | is opensrf.math in that list? |
| # | 11:29:00 | darshan | wait |
| # | 11:29:26 | phasefx | bshum: if there's a column in a list for it, and that list uses a receipt template, then there's a macro for it |
| # | 11:31:00 | darshan | <Dyrcona> yes |
| # | 11:31:06 | darshan | there r many in it |
| # | 11:31:24 | jeff | bshum: there is a library phone macro in one of my working branches. |
| # | 11:32:28 | jeff | bshum: https://bugs.launchpad.net/evergreen/+bug/608308 |
| # | 11:32:33 | Dyrcona | darshan: Then, I don't know why you are getting no response from the server at this point. |
| # | 11:32:53 | darshan | ok |
| # | 11:33:07 | darshan | can u suggest me wat else can i check |
| # | 11:33:50 | Dyrcona | darshan: Maybe someone else can help you, now. I'm not sure what would be wrong at this point. |
| # | 11:35:21 | darshan | ok |
| # | 11:35:44 | bshum | jeff: Ah, neat. |
| # | 11:36:06 | Dyrcona | mrpeters-isl: Actually, it doesn't appear to work with joins unless you specify columns. |
| # | 11:36:10 | bshum | jeff: I'll see if we can use that, but that definitely seems like a good thing to include in base Evergreen of the future. |
| # | 11:36:47 | phasefx | jeff: is that ready for a pullrequest? |
| # | 11:37:12 | jeff | phasefx: i was going to add addresses, but i could always add that later. |
| # | 11:37:35 | phasefx | don't let me rush you |
| # | 11:37:52 | phasefx | just wasn't sure :) |
| # | 11:38:10 | darshan | ne1 can help me plzz...srfsh# request opensrf.math add 2 2 ,after running this i m getting received no data from server |
| # | 11:47:42 | darshan has quit IRC |
| # | 11:48:11 | darshan has joined #evergreen |
| # | 11:48:39 | darshan | ne1 can help me plzz...srfsh# request opensrf.math add 2 2 ,after running this i m getting received no data from server |
| # | 11:48:48 | mrpeters-isl | darshan, once is enough |
| # | 11:49:01 | mrpeters-isl | your question has been answered several times |
| # | 11:49:17 | darshan | but its unsolved |
| # | 11:49:29 | mrpeters-isl | the problem is in your configuration. your questions are all answered many times in the past for other users. |
| # | 11:49:44 | mrpeters-isl | I reccomend using Google to search your error. You'll find many people who have had the same problems. |
| # | 11:50:23 | darshan | can u ans me |
| # | 11:50:41 | mrpeters-isl | darshan: i've answered you already, as has Dyrcona |
| # | 11:51:11 | mrpeters-isl | also try http://open-ils.org/dokuwiki/doku.php?id=troubleshooting:checking_for_errors |
| # | 11:51:31 | darshan | if der is ne prb in configuration y dont u predict out |
| # | 11:51:52 | mrpeters-isl | darshan: no software in the world is going to predict inexperience |
| # | 11:52:26 | darshan | if you cant sort out my prb than,dont interrupt me |
| # | 11:52:29 | mrpeters-isl | the OpenSRF install process is VERY well documented. The problem is likely a lack of reading the documentation fully. |
| # | 11:52:49 | mrpeters-isl | I'm right here, telling you what you need to do to fix your problem. |
| # | 11:53:35 | darshan | ya trying it |
| # | 11:54:33 | fortin_ has joined #evergreen |
| # | 11:55:36 | fortin has quit IRC |
| # | 11:55:44 | fortin_ is now known as fortin |
| # | 12:09:18 | darshan | <dyrcona>frnd r u der |
| # | 12:12:56 | atheos | I need an irc filter for juvenile texting lingo |
| # | 12:13:21 | darshan | <dyrcona> thankx ,its done |
| # | 12:14:08 | darshan | <dyrcona> the prb was i was having 4 as my loglevel in .srfsh.xml and 3 in opensrf_core.xml |
| # | 12:15:30 | darshan | i changes to 3 as loglevel in .srf,xml and stop and restart all router serveices |
| # | 12:15:46 | darshan | and now i m getting proper output |
| # | 12:15:52 | darshan | thnkx |
| # | 12:18:09 | darshan | <mrpeters-isl> thankx.... |
| # | 12:18:44 | mrpeters-isl | atheos: y u dont predict |
| # | 12:19:06 | atheos has filtered your comment. please resubmit in english |
| # | 12:19:58 | darshan has quit IRC |
| # | 12:26:28 | Dyrcona | I don't really think that was darshan's problem..... |
| # | 12:27:56 | Dyrcona | 'cause srfsh works for me with loglevel 4 in .srfsh.xml and 3 in opensrf_core.xml |
| # | 12:29:08 | Dyrcona returns to his lunch time web surfing. |
| # | 12:32:41 | mrpeters-isl | when constructing a json query with perl, how would be the best way to handle a date entry (ex 10/21/2011) so it matches a DB timestamp like "2011-10-21 19:36:44.447568-04" |
| # | 12:33:07 | mrpeters-isl | so, srfsh query would be like "authstring" "10/21/2011" |
| # | 12:39:42 | mrpeters-isl | the ultimate goal, would be feeding $due_date to the API via a Dojo calendar |
| # | 12:51:34 | Dyrcona | mrpeters-isl: the value field from the Dojo calendar ought to work, not the display-value or whatever its called. |
| # | 12:55:53 | tsbere | mrpeters-isl: Dojo already spits it out in a form that I believe postgres is happy with when sending it to the server. |
| # | 13:06:09 | leed has quit IRC |
| # | 13:35:04 | akilsdonk has joined #evergreen |
| # | 13:58:11 | youdonotexist has joined #evergreen |
| # | 14:09:45 | jenny1 has left #evergreen |
| # | 14:10:34 | mrpeters-isl | oh, sweet then! |
| # | 14:16:42 | mrpeters-isl | if fleshing from a circ.id to a ac.barcode that'd just be a flesh = 1, right? Since I can directly link circ.usr to ac.usr ? |
| # | 14:17:22 | tsbere | fleshing from circ to barcode is 2. 1 to flesh the usr, one to flesh the card. |
| # | 14:17:58 | tsbere | so the circ gets 'usr' fleshed, the user gets 'card' fleshed, then you will have access to the barcode |
| # | 14:18:22 | mrpeters-isl | ok, lets say we throw au.first_given_name into the mix...still 2 right? or do they need to be combined to 4? |
| # | 14:19:00 | Dyrcona | still 2. anything in au.* comes with fleshing the usr. |
| # | 14:19:13 | jeff | mrpeters-isl: if you're starting with the circ, flesh 1 will get you the copy barcode and the user first_given, etc. flesh 1 will not give you the user's card barcodes or the user's addresses. you'd need flesh 2. |
| # | 14:19:52 | mrpeters-isl | ok, so really it's just the highest depth in the whole flesh_fields group |
| # | 14:19:59 | jeff | mrpeters-isl: you should be able to make requests at various fleshing levels and observe the returned objects with Data::Dumper or similar. experimentation is sometimes the best illustration. |
| # | 14:20:10 | tsbere | mrpeters-isl: Think of it this way. Build a tree with the various things you need. One level for the circ, another for the user, another for the card. When you have the entire tree assembled, find the *deepest* point in the tree (in this case, the third level, the card). Subtract 1. That is your flesh number. |
| # | 14:20:16 | Dyrcona agrees with jeff. |
| # | 14:20:17 | jeff | mrpeters-isl: i don't follow your "highest depth in the whole flesh_fields group" |
| # | 14:20:30 | mrpeters-isl | just what tsbere said is what i was thinking |
| # | 14:20:31 | Dyrcona agrees with tsbere. |
| # | 14:20:38 | jeff | and yes, what tsbere said. |
| # | 14:20:39 | mrpeters-isl | the tree is a perfect illustration |
| # | 14:20:49 | Dyrcona | experimenting with Data::Dumper can teach a lot. |
| # | 14:24:39 | mrpeters-isl | am I making sense of de-flesh properly? http://pastie.org/2736730 |
| # | 14:25:34 | mrpeters-isl | or i guess circ->usr->card->barcode would make more sense |
| # | 14:31:35 | tsbere | au => ['card'], family name and first given name aren't links and thus aren't fleshed. |
| # | 14:32:24 | tsbere | They come across when usr is fleshed. Which, BTW, you will need to add in. The ac => barcode flesh there is also not what you want. |
| # | 14:35:55 | mrpeters-isl | hm what else would it be? |
| # | 14:36:50 | tsbere | mrpeters-isl: The "flesh fields" section there is every *link* you want to be fleshed. To go from circ to barcode you need to have circ => ['usr'], au => ['card']. The result should then allow you to get at $var->usr->card->barcode |
| # | 14:37:27 | tsbere | Not to mention $var->usr->first_given_name, $var->usr->family_name, etc |
| # | 14:38:32 | mrpeters-isl | yeah, i was just trying to deflesh the card.barcode before moving on to others |
| # | 14:39:38 | mrpeters-isl | http://pastie.org/2736803 -- look a bit better? |
| # | 14:40:03 | mrpeters-isl | i guess, can i think of the deflesh like my tree from fleshing |
| # | 14:40:35 | mrpeters-isl | circ.id > circ.usr > au.card > ac.barcode |
| # | 14:41:17 | tsbere | remove the extra two au entries, for starters. |
| # | 14:41:33 | Dyrcona | http://pastie.org/2736822 |
| # | 14:41:56 | Dyrcona | Mine uses one of my helper libs and a hard coded circ id just to show you what needs done. |
| # | 14:41:57 | tsbere | And if you are trying to get the names out, you have to get the names *before* you wipe out the usr entry, as they live in there. |
| # | 14:42:26 | tsbere also dislikes "de-fleshing" things to anything other than their ID values |
| # | 14:42:51 | tsbere | de-fleshing the card entry to the value of card->id? Fine. De-fleshing to the value of card->barcode? Not so much. |
| # | 14:43:38 | mrpeters-isl | how else would i get the barcode of the user? |
| # | 14:43:48 | mrpeters-isl | if given any circ, the goal is to get all of the information about the user and the item |
| # | 14:44:50 | tsbere | So flesh out the stuff and hand it to the next layer *still fleshed*. I think even the staff client can handle getting fully fleshed results back. |
| # | 14:53:22 | Dyrcona | More fun: http://pastie.org/2736861 |
| # | 14:53:33 | lisah___ has joined #evergreen |
| # | 14:53:59 | mrpeters-isl | Dyrcona reads my mind |
| # | 14:54:22 | mrpeters-isl | i need to go a level deeper, though, to reporter.materialized_simple_record to get title, author, etc. |
| # | 14:55:19 | mrpeters-isl | acn => ['record'], rmsr => ['id'] im thinking |
| # | 14:55:43 | Dyrcona | I think that might require a search with a join. |
| # | 14:55:46 | tsbere | I think you may need to go an extra level deeper, through the bib. |
| # | 14:56:09 | tsbere | acn => record is the bib, which I believe has a link to rmsr |
| # | 14:56:22 | tsbere | check fm_idl.xml to be sure ;) |
| # | 14:56:30 | Dyrcona | yeah.... just a sec.. |
| # | 14:56:37 | mrpeters-isl | i think 2 is enough |
| # | 14:57:07 | mrpeters-isl | or, 3 i guess ... forgot to include circ.target_copy |
| # | 14:57:30 | mrpeters-isl | so circ > acp > acn > rmsr should work acn.record = rmsr.id |
| # | 14:58:09 | mrpeters-isl | i dont think we'd have to go through biblio.record_entry |
| # | 14:58:23 | tsbere | mrpeters-isl: acn's "record" does not, in the IDL, link to rmsr, last I looked. I believe record goes to biblio.record_entry, which likely links to rmsr. |
| # | 14:58:46 | matt_carlson has joined #evergreen |
| # | 14:58:47 | tsbere | So you will, if using fleshed fields, need to include biblio.record_entry |
| # | 14:59:49 | mrpeters-isl | ah, so even though acn.record may be equal to rmsr.id, it won't work here because fieldmapper doesn't know that is true? |
| # | 15:00:28 | tsbere | Because fieldmapper has been told that acn.record is a link to bre, not a link to rmsr |
| # | 15:00:42 | mrpeters-isl | right ok |
| # | 15:00:52 | mrpeters-isl | i think this is starting to gel. I appreciate your patience. |
| # | 15:00:56 | Dyrcona | This is fun: http://pastie.org/2736893 |
| # | 15:01:02 | Dyrcona | Like a treasure hunt. :) |
| # | 15:01:13 | mrpeters-isl | Dyrcona; looks like what i am trying |
| # | 15:01:36 | mrpeters-isl | though i was thinking flesh would be 3, not 4 |
| # | 15:01:56 | mrpeters-isl | oh, no you are right |
| # | 15:02:05 | edoceo | Are these still the latest: http://open-ils.org/dokuwiki/doku.php?id=community_servers#virtual_server_images - Isn't there a newer one outthere some where? |
| # | 15:04:33 | bshum | edoceo: I think those are the newest ones that I'm aware of anyways. |
| # | 15:05:12 | bshum | brian_f might have a newer Evergreen cloud image though than 2.0.6 (since his community one is listed at 2.0.9) |
| # | 15:05:27 | bshum | Though that ought to get updated to 2.1.0/2.0.10 eventually |
| # | 15:08:54 | Callender has quit IRC |
| # | 15:10:27 | Dyrcona | I prefer this: http://pastie.org/2736939 |
| # | 15:10:41 | Dyrcona | It gets title and author in mixed case, the way our members like to see it. |
| # | 15:11:31 | tsbere | With the catch of having more than one potential answer for title/author, I think. |
| # | 15:11:47 | Dyrcona | Yes, so pick the first or use 'em all. :) |
| # | 15:11:59 | mrpeters-isl | yeah, i need to look at how things like checkout are getting item info |
| # | 15:12:07 | mrpeters-isl | but rmsr is a good start for me |
| # | 15:12:08 | tsbere | Useful for, say, perl level reporting. Not so much for, say, the reporter. :P |
| # | 15:12:44 | mrpeters-isl now with a working API, begins the journey of creating a new xul interface for it |
| # | 15:17:01 | Dyrcona | Didn't know I had a time machine: Pasted 1 minute from now |
| # | 15:18:09 | jeff | Dyrcona: most places where titles are displayed are using the mods transform of the marcxml |
| # | 15:18:23 | Dyrcona | Yep. |
| # | 15:21:34 | Callender has joined #evergreen |
| # | 15:26:51 | phasefx | mrpeters-isl: incidentally, I think we're trying to minimize creation of new xul interfaces, with the goal of moving away from it at some point |
| # | 15:30:52 | matt_carlson has quit IRC |
| # | 15:32:46 | mrpeters-isl | i see...is there something else I should try to learn instead? |
| # | 15:32:55 | mrpeters-isl | i guess a dojo interface? |
| # | 15:33:18 | mrpeters-isl | my vision was something just like holds.xul except for items due on a particular date |
| # | 15:33:25 | edoceo | We're looking at setting some additional preferences for our Patrons - is that a StatCat thing? |
| # | 15:34:03 | jeff | edoceo: there is a user settings framework in place. currently, it is used to store things such as notification default preferences, default search scope when logged in, etc. |
| # | 15:34:41 | edoceo | I'd been looking for some docs on that, tsbere pointed me that direction but I cannot find - do you have some clues? |
| # | 15:35:38 | jeff | edoceo: there are existing api calls for manipulating user preferences. there are areas in the database where these prefs are stored. i can point you there. |
| # | 15:37:03 | bshum | Bleh, spam |
| # | 15:37:04 | jeff | edoceo: the database table where user settings are stored is actor.usr_setting. they're just key/value pairs, with the value sometimes being JSON. |
| # | 15:37:10 | edoceo | I would appreciate that; I hoping that I'm not going to have to make any table adjustments; just put and get 'Email Reciept' preferences as true/false or somthing |
| # | 15:37:13 | phasefx | mrpeters-isl: Dojo and/or template toolkit. Though holds.xul is already powering most every other holds list interface; depending on what you're doing exactly you could probably plug it into holds.xul as a peer to all the other hold retrieval methods |
| # | 15:37:27 | jeff | edoceo: sounds likely! |
| # | 15:37:30 | edoceo | jeff: cool |
| # | 15:38:32 | jeff | edoceo: api methods open-ils.actor.patron.settings.update, open-ils.actor.patron.settings.retrieve |
| # | 15:38:54 | mrpeters-isl | well, it probably wouldnt want to go into holds.xul because i'm actually looking for circulations |
| # | 15:41:20 | youdonotexist has quit IRC |
| # | 15:42:45 | youdonotexist has joined #evergreen |
| # | 15:43:00 | youdonotexist has quit IRC |
| # | 15:50:39 | tsbere | phasefx: I think mrpeters-isl is looking to build a "list of things due today" interface for use by staff that, for some weird reason, call people about that. |
| # | 15:53:53 | phasefx | fun |
| # | 15:54:19 | phasefx | mrpeters-isl: you could just ship the item barcodes to Item Status, similar to the button that does such for Copy Buckets |
| # | 15:54:51 | phasefx | it won't be smooth if there are tons of stuff due in, though |
| # | 15:55:02 | tsbere would probably just build a daily recurring report <_< |
| # | 15:55:08 | phasefx nods |
| # | 15:55:55 | plux_ has quit IRC |
| # | 16:00:39 | Meliss has quit IRC |
| # | 16:02:37 | mrpeters-isl | just an excercise trying to learn things |
| # | 16:03:09 | mrpeters-isl | agrees with recurring report...but this seemed like a good thing to try #1 buiding an API for and then #2 trying to get it into an easy to use interface in the client |
| # | 16:06:41 | Dyrcona | mrpeters-isl: you could also try it as a web module. |
| # | 16:07:56 | mrpeters-isl | are there any interfaces that switched over from xul to dojo or tt yet that i could dig through? |
| # | 16:09:10 | mrpeters-isl | actually starting tot hink the transit list would be a good place to start, if i went the xul route |
| # | 16:15:20 | collum has quit IRC |
| # | 16:17:47 | Dyrcona wonders how you would do now() - 14 days in a json query. |
| # | 16:20:16 | tsbere | One option would be the age function, I guess. |
| # | 16:20:33 | tsbere | But I think that is quite a bit slower |
| # | 16:20:52 | senator | Dyrcona: assuming perl, i think in practice we use DateTime to generate a timestamp from an interval expression like yours, and use that |
| # | 16:23:08 | Dyrcona | senator: thanks. i thought of trying something like that. |
| # | 16:23:31 | Dyrcona | playing with what mrpeters-isl shared earlier gave me some ideas for some things that I am working on. |
| # | 16:23:49 | senator | cool |
| # | 16:25:44 | kmlussier has quit IRC |
| # | 16:25:55 | csharp | okay - still trudging through this script (161-20 upgrade)... now getting 'ERROR: relation "actor_usr_usrgroup_idx" already exists' |
| # | 16:26:21 | csharp | is it better to go in and manually drop this index or comment out that part of the script |
| # | 16:26:25 | csharp | ? |
| # | 16:26:39 | mrpeters-isl | i think dropping it would be fine, since you're going to recreate it |
| # | 16:29:30 | csharp | interesting... I don't see that in psql. I do see actor.usr_usrgroup_seq |
| # | 16:32:46 | Dyrcona | heh....everything i've checked out at work: http://pastie.org/2737331 |
| # | 16:33:21 | csharp | oh, there it is: "actor_usr_usrgroup_idx" btree (usrgroup) |
| # | 16:33:35 | eeevil | I'd recommend the reverse, as long as the index definitions are the same ... no need to spend the time building it if it's already there |
| # | 16:33:48 | csharp | eeevil: okay - I'll comment it out |
| # | 16:33:54 | senator | csharp: when you just want to see indexes alone, try \di actor.* (for example) |
| # | 16:34:01 | csharp | senator: thanks! |
| # | 16:35:25 | senator | no prob |
| # | 16:36:23 | Dyrcona | FYI: Looks like it is faster to get an idlist from search_action_circulation and then retrieve each circulation and do the fleshing in the retrieve. |
| # | 16:37:10 | senator | really? that is kinda surprising. |
| # | 16:37:25 | Dyrcona | well, maybe its a case of caching.... |
| # | 16:38:15 | Dyrcona | I didn't really do a "scientific" timing of it. |
| # | 16:38:16 | senator | Dyrcona: if you persistently get results like that, i'd like to look into that |
| # | 16:38:21 | Dyrcona | ok |
| # | 16:38:25 | senator | if true sounds like something we should fix |
| # | 16:38:41 | berick | Dyrcona: another option at your disposal is $e->search_action_circulation([ stuff ], {substream => 1}), which fetches a stream of results |
| # | 16:38:48 | berick | instead of a giant blob, which can gum up the works |
| # | 16:39:36 | Dyrcona | berick: how do I use the substream? I know how to use ->recv for an opernsrf request is it the same? |
| # | 16:40:03 | berick | Dyrcona: all you have to do is add it to the call. on your end, you'll still get back an array of results |
| # | 16:40:17 | Dyrcona | ok. will try substream. |
| # | 16:40:19 | berick | only difference is under the covers |
| # | 16:40:22 | jeff | berick: by "gum up the works", do you mean "sends a perhaps too-large xmpp message?, or something else? |
| # | 16:41:37 | berick | jeff: mainly too-large xmpp message, but I also have to wonder if 1 big message in some contexts just takes longer to deliver than a pile of smaller ones |
| # | 16:42:10 | jeff | berick: thanks. got it. |
| # | 16:42:45 | berick | running in substream mode should def. be faster than fetching a list of IDs then fetching each circ individually |
| # | 16:42:47 | Dyrcona | berick: whoa! substream rocks. one of my test searches didn't work at all, but now it does. |
| # | 16:43:04 | Dyrcona | berick: yes, substream does seem really fast. |
| # | 16:43:11 | berick | Dyrcona: i'd guess too-big message in that case... cool |
| # | 16:43:40 | Dyrcona | berick: yes, probably. I was fooling around on my dev box and tried getting everything checked out at our central office. |
| # | 16:44:34 | Dyrcona | once I figure out how to say give me stuff due x days ago at this library, I'll be 100% in business. :) |
| # | 16:45:15 | Dyrcona searches code for using datetime in perl. |
| # | 16:47:34 | AaronZ-PLS has quit IRC |
| # | 16:48:25 | Dyrcona | berick++ |
| # | 16:48:27 | Dyrcona | sentator++ |
| # | 16:48:32 | Dyrcona | jeff++ |
| # | 16:48:36 | Dyrcona | mrpeters-isl++ |
| # | 16:48:55 | Dyrcona | cstoreeditor just became seriously more powerful for me today thanks to you guys. |
| # | 16:49:06 | Dyrcona | tsbere++ |
| # | 17:09:02 | csharp | okay - now getting this error: http://pastebin.com/a4WsWW73 |
| # | 17:09:32 | csharp | key text: ERROR: each UNION query must have the same number of columns |
| # | 17:11:18 | tsbere | seems that you have a column on your main table that you don't have on the audit table. Or the other way around, I guess. |
| # | 17:12:19 | csharp | hmm |
| # | 17:14:42 | Dyrcona | the column have to be in the same order, too, don't they? |
| # | 17:15:09 | tsbere | I think the same names will suffice |
| # | 17:16:22 | tsbere | I could be wrong, though |
| # | 17:16:40 | Dyrcona | you are probably right. |
| # | 17:16:55 | Dyrcona | if they have the same names and datatypes |
| # | 17:17:10 | tsbere | I think "same names" only works with the * though. If you manually order them I think it uses that order. |
| # | 17:18:18 | tsbere | so select x, y, z union all select z, y, x will only work if x and z have the same type |
| # | 17:18:29 | Dyrcona | I haven't done too many unions since Sybase. |
| # | 17:18:34 | matt_carlson has joined #evergreen |
| # | 17:19:34 | csharp | tsbere: sho nuff - you're right: auditor.actor_usr_lifecycle has 41 columns and actor.usr has 39 |
| # | 17:19:52 | tsbere | csharp: The auditor should have more columns |
| # | 17:20:07 | csharp | hmm... |
| # | 17:20:10 | tsbere | csharp: But it should have 3 more, not 2 more |
| # | 17:20:45 | tsbere | the audit id/time and the action that caused the entry |
| # | 17:21:00 | tsbere | So your actor.usr table has a column that isn't in your auditor table |
| # | 17:21:14 | csharp | no - I'm wrong - I was looking at the wrong table |
| # | 17:21:24 | csharp | both have 39 columns |
| # | 17:21:49 | tsbere | Then actor.usr has 3 extra columns that didn't make it into the audit table? |
| # | 17:22:16 | csharp | or auditor has three too few |
| # | 17:22:32 | csharp contemplates suicide |
| # | 17:24:18 | tsbere | csharp: check the last 3 column names on actor.usr, see if they exist on the auditor table? |
| # | 17:24:35 | akilsdonk has quit IRC |
| # | 17:25:01 | fortin has quit IRC |
| # | 17:28:58 | Dyrcona | well, that's enough fun for 1 day. |
| # | 17:29:02 | Dyrcona has quit IRC |
| # | 17:34:33 | csharp | looks like claims_returned_count, alias, and juvenile do not exist in the auditor table |
| # | 17:34:52 | csharp | tsbere: thanks so much for your sane help :-) |
| # | 17:35:23 | matt_carlson has quit IRC |
| # | 17:36:21 | matt_carlson has joined #evergreen |
| # | 17:37:44 | jeff | stupid postgrsql tricks: |
| # | 17:37:50 | jeff | select count(*), a.attname from pg_catalog.pg_class c join pg_catalog.pg_attribute a on (a.attrelid = c.oid) where relname in ('usr', 'actor_usr_history') group by a.attname having count(*) < 2; |
| # | 17:38:06 | jeff | will show you the fields that are not shared between usr and actor_usr_history |
| # | 17:38:51 | jeff | makes some assumptions to keep the query from being too huge -- like that you don't have two same-named tables in different schemas. |
| # | 17:49:25 | csharp | jeff: thanks! will try |
| # | 17:51:49 | yboston has quit IRC |
| # | 17:52:50 | csharp | appropriately, the different columns are audit_time and audit_action |
| # | 17:53:01 | csharp is very confused |
| # | 17:53:23 | csharp | but I'm going to have to stop and pay attention to my family now ;-) |
| # | 18:22:32 | matt_carlson has quit IRC |
| # | 18:24:38 | dbwells__ has joined #evergreen |
| # | 18:28:18 | dbwells_ has quit IRC |
| # | 18:37:12 | matt_carlson has joined #evergreen |
| # | 18:38:44 | tsbere throws http://pastie.org/2737897 out as a possible test for csharp to run later, expanding on what jeff mentioned earlier |
| # | 18:47:55 | matt_carlson has quit IRC |
| # | 18:59:33 | lisah___ has quit IRC |
| # | 19:01:37 | csharp | tsbere++ # thanks - will try tomorrow |
| # | 19:33:18 | matt_carlson has joined #evergreen |
| # | 19:37:46 | matt_carlson has quit IRC |
| # | 23:45:43 | Callender has quit IRC |
April 10-13