| 00:00.03 | bonez41 | macnewbold, I try just the script, and apparently I don't have perl set up with the right environment variable...I have to run it with 'perl gnc20.pl' to get it to run |
| 00:00.51 | macnewbold | brac is a bot, it grabs titles of html pages when you post a url in here |
| 00:01.01 | bonez41 | oh, I see... |
| 00:01.18 | macnewbold | try 'head -1 gnc20.pl' |
| 00:01.32 | macnewbold | if it isn't something like #!/usr/local/bin/perl, |
| 00:01.41 | macnewbold | or that path doesn't match "which perl" or "where perl" |
| 00:02.06 | macnewbold | then that's why it won't run it the normal way. |
| 00:02.06 | bonez41 | is that head 1 or head l? |
| 00:02.06 | bonez41 | I guess 1 |
| 00:02.06 | bonez41 | ok |
| 00:02.06 | macnewbold | head with the number 1 |
| 00:02.09 | macnewbold | (says to give 1 line instead of 10) |
| 00:02.13 | bonez41 | scott@fyrenice:/tmp$ head -1 gnc20.pl |
| 00:02.13 | bonez41 | #!/usr/bin/perl |
| 00:02.15 | bonez41 | that's the output |
| 00:04.59 | bonez41 | hmmm here's the put from running the script.... |
| 00:05.38 | bonez41 | scott@fyrenice:/tmp$ perl gnc20.pl |
| 00:05.38 | bonez41 | DELETE FROM chart; |
| 00:05.38 | bonez41 | DELETE FROM acc_trans; |
| 00:05.39 | bonez41 | DELETE FROM gl; |
| 00:05.54 | tene | and from running it directly? |
| 00:06.03 | bonez41 | it only works through a small part of the script..looks to me at least, like it's missing most of the script..... |
| 00:06.28 | bonez41 | tene, that's from running there....at the prompt...directly? not sure if it's running directly or not |
| 00:06.31 | bonez41 | or what that means |
| 00:07.12 | tene | I think I misunderstood your problem |
| 00:08.29 | bonez41 | tene, I am trying to convert gnucash financial data over to be used in sql-ledger... |
| 00:08.52 | bonez41 | sql-ledger.org provides a script....but I am not sure it's working correctly......or what the script should produce as output |
| 00:09.26 | tene | do you have the file 'gnucash.xml' in the same directory as you're running the script? |
| 00:10.41 | bonez41 | I changed my gnc20.pl file....replacing 'gnucash.xml' to file named '2lshome' which is my gnucash.xml file.... |
| 00:11.12 | bonez41 | I guess I should change it back...but in changing the script..that error stopped coming up...I think the script just assumes that is the name of the gnucash file... |
| 00:12.02 | tene | Yeah, just that 5th line |
| 00:12.10 | tene | as long as that's the name of the file you're trying to convert. |
| 00:12.21 | bonez41 | even then, if I run it with as original....it outputs the same : scott@fyrenice:/tmp$ perl gnc20.pl |
| 00:12.21 | bonez41 | DELETE FROM chart; |
| 00:12.22 | bonez41 | DELETE FROM acc_trans; |
| 00:12.22 | bonez41 | DELETE FROM gl; |
| 00:12.30 | bonez41 | so yeah, that's the name of the file to convert |
| 00:12.40 | tene | try changing it from: |
| 00:12.47 | tene | $ref = XMLin("./your file"); |
| 00:12.49 | tene | to |
| 00:13.01 | tene | $ref = XMLin("./your file") or die "ono cant read the file"; |
| 00:14.22 | tene | does the header in the xml file say <gnc-2.0> ? |
| 00:14.35 | bonez41 | tene, yeah, the xml header does say gnc-2.0.... |
| 00:14.48 | tene | okay, after making that change, does it die when you try to run it? |
| 00:14.54 | bonez41 | <?xml version="1.0"?> |
| 00:14.54 | bonez41 | <gnc-v2> |
| 00:14.54 | bonez41 | <gnc:count-data cd:type="book">1</gnc:count-data> |
| 00:14.54 | bonez41 | <gnc:book version="2.0.0"> |
| 00:14.59 | bonez41 | actually that's the output.... |
| 00:15.04 | bonez41 | for the gnucash.xml |
| 00:15.23 | tene | perl gnc20.pl |
| 00:16.03 | tene | does it die after making that change? |
| 00:16.24 | bonez41 | ok, running it now with change |
| 00:16.42 | bonez41 | no, the output is exactly the same |
| 00:16.46 | bonez41 | it does NOT die |
| 00:16.59 | bonez41 | scott@fyrenice:/tmp$ perl gnc20.pl |
| 00:16.59 | bonez41 | DELETE FROM chart; |
| 00:16.59 | bonez41 | DELETE FROM acc_trans; |
| 00:16.59 | bonez41 | DELETE FROM gl; |
| 00:17.02 | bonez41 | so, no death |
| 00:17.03 | tene | okay, now: |
| 00:17.42 | tene | grep gnc:account yourfile|wc -l |
| 00:18.07 | bonez41 | scott@fyrenice:/tmp$ grep gnc:account gnucash.xml|wc -l |
| 00:18.07 | bonez41 | 152 |
| 00:18.09 | bonez41 | ok... |
| 00:18.25 | bonez41 | line 152? |
| 00:18.40 | tene | no, that means there's 152 gnc:accounts |
| 00:18.49 | bonez41 | oh...... |
| 00:19.14 | bonez41 | accounts that I want to import..or convert over..right? |
| 00:19.24 | tene | try changing on line 31: |
| 00:19.31 | tene | $ref->{"gnc:account"} |
| 00:19.32 | tene | to: |
| 00:19.52 | tene | $ref->{"gnc-v2"}->{"gnc:account"} |
| 00:20.08 | tene | that's just a guess. I really should look at the XML::Simple docs. |
| 00:20.28 | bonez41 | glad to look if i knew where to look |
| 00:21.05 | tene | okay, nevermind |
| 00:21.11 | tene | ignore that last suggestion. |
| 00:21.24 | tene | http://search.cpan.org/~grantm/XML-Simple-2.14/lib/XML/Simple.pm |
| 00:21.43 | tene | http://search.cpan.org/ is where to go to look up any cpan module and its documentation. |
| 00:22.25 | tene | you could try dumping out $ref |
| 00:22.29 | tene | use Data::Dumper; |
| 00:22.37 | tene | print Dumper($ref); |
| 00:22.50 | bonez41 | at a perl prompt? |
| 00:23.07 | tene | no, add that after the $ref = XMLin(); near the top |
| 00:23.11 | tene | then run the script again |
| 00:23.31 | bonez41 | ok, change back to original, right? and then add that last line |
| 00:23.38 | tene | yeah |
| 00:24.37 | bonez41 | what do I add to the script? |
| 00:24.52 | bonez41 | use Data::Dumper; |
| 00:24.53 | bonez41 | print Dumper($ref); |
| 00:24.56 | bonez41 | that stuff? |
| 00:25.33 | tene | yeah |
| 00:25.39 | tene | like http://allalone.org/foo |
| 00:26.22 | bonez41 | dang, that script is going crazy now... |
| 00:26.34 | tene | yeah... it'll print... a lot of data. |
| 00:26.52 | tene | that means it's reading the file correctly, though. |
| 00:26.57 | bonez41 | it ends up with the same stuff..... |
| 00:27.01 | tene | nodnod |
| 00:27.14 | bonez41 | <PROTECTED> |
| 00:27.14 | bonez41 | <PROTECTED> |
| 00:27.14 | bonez41 | <PROTECTED> |
| 00:27.14 | bonez41 | <PROTECTED> |
| 00:27.14 | bonez41 | <PROTECTED> |
| 00:27.15 | bonez41 | DELETE FROM chart; |
| 00:27.17 | bonez41 | DELETE FROM acc_trans; |
| 00:27.19 | bonez41 | DELETE FROM gl; |
| 00:27.21 | bonez41 | scott@fyrenice:/tmp$ ls |
| 00:27.23 | bonez41 | that's the ending output of it all.. |
| 00:27.57 | tene | try changing it to: |
| 00:28.19 | tene | print Dumper(@{ $ref->{"gnc::account"} }); |
| 00:28.44 | bonez41 | ok, I changed mine to read what you had....first |
| 00:29.05 | bonez41 | now making this current change... |
| 00:29.37 | bonez41 | running script again |
| 00:29.47 | bonez41 | scott@fyrenice:/tmp$ perl gnc20.pl |
| 00:29.47 | bonez41 | DELETE FROM chart; |
| 00:29.47 | bonez41 | DELETE FROM acc_trans; |
| 00:29.47 | bonez41 | DELETE FROM gl; |
| 00:29.49 | bonez41 | same old storey |
| 00:30.02 | bonez41 | that's with the most recent change...print Dumper(@{ $ref->{"gnc::account"} }); |
| 00:30.33 | tene | That's our problem, then. |
| 00:30.54 | bonez41 | ok.. |
| 00:31.15 | bonez41 | how does one read ANYTHING::simpleornot? |
| 00:31.24 | bonez41 | Is that perl, that notation? |
| 00:31.33 | tene | perldoc XML::Simple |
| 00:31.37 | tene | or look it up on cpan |
| 00:33.10 | bonez41 | ok....finally found that... |
| 00:33.33 | tene | wait, it definitely shouldn't be printing *nothing* from the print Dumper() line; |
| 00:34.35 | bonez41 | that line in there... What could be simpler? (Rhetorical). |
| 00:34.36 | bonez41 | <PROTECTED> |
| 00:34.44 | tene | Heh. |
| 00:36.24 | tene | I don't suppose you want to send me the xml file or let me ssh into your box to try it myself. |
| 00:39.58 | *** join/#utah bigdog_ut (n=bigdog@207.135.132.13) |
| 00:57.59 | nick125_lappy | anyone here know of a computer parts distributor that does credit? (I need to be able to order parts, on a regular basis, then pay for them at the end of the month) |
| 01:14.22 | bonez41 | tene |
| 01:14.30 | bonez41 | tene: still here? |
| 01:14.49 | tene | Yes. |
| 01:14.56 | bonez41 | oh, I was busy with last patient..... |
| 01:15.08 | bonez41 | how would I allow you to ssh? |
| 01:15.26 | tene | you could give me an account on your box |
| 01:15.39 | bonez41 | ok...... |
| 01:15.59 | bonez41 | adduser tene right? |
| 01:16.28 | tene | useradd |
| 01:16.32 | tene | adduser is for postgres. |
| 01:16.58 | bonez41 | ok |
| 01:18.01 | bonez41 | ran useradd tene and it just gave the prompt back.... |
| 01:18.28 | bonez41 | is that right? didn't ask for passwd or anything... |
| 01:18.56 | tene | Yes, it is. |
| 01:18.59 | tene | now passwd tene |
| 01:39.49 | *** join/#utah amcnabb (n=amcnabb@c-67-169-251-207.hsd1.ut.comcast.net) |
| 01:40.39 | amcnabb | Hey. I haven't installed Fedora recently. How much space does the default install take on the root partition? |
| 01:40.43 | amcnabb | (FC5) |
| 01:47.28 | amcnabb | I'm guessing that 10GB for a root filesystem would be big enough to install. |
| 01:47.38 | amcnabb | Would it be limiting, though? |
| 01:48.45 | tene | my / is just under 10GB |
| 01:48.54 | amcnabb | How full is it? |
| 01:49.02 | tene | 9.7, with 9.1 used |
| 01:49.17 | amcnabb | That's a little tight. |
| 01:49.45 | tene | This is an FC4 system, and I have quite a bit more than the default install |
| 01:50.46 | amcnabb | I'll probably go with 15GB, then. |
| 01:51.02 | tene | rpm -qa|wc -l |
| 01:51.03 | tene | 1165 |
| 01:51.57 | tene | I have about 3GB in /var/cache |
| 01:52.08 | tene | I have about 3GB in /var/cache/yum, even |
| 01:52.14 | amcnabb | wow |
| 01:53.53 | vontrapp | 3.3G used on / |
| 01:54.12 | amcnabb | That's a pretty big difference. |
| 01:54.24 | amcnabb | vontrapp, are you using fc5? |
| 01:54.29 | vontrapp | but i also don't have kde or gnome (i have parts of gnome i guess) |
| 01:54.30 | vontrapp | debian |
| 01:54.39 | tene | I have both KDE and Gnome installed on this box. |
| 01:55.57 | amcnabb | Cool. Well, I'm going to go repartition. |
| 01:56.01 | amcnabb | Thanks for the input. |
| 02:13.48 | *** join/#utah graphyx (n=mkling@24.144.57.161) |
| 02:14.00 | graphyx | So what is a good site to buy legit mp3's? |
| 02:17.29 | vontrapp | graphyx: just get code monkey, it's free |
| 02:19.59 | vontrapp | "Code Monkey" it's a song, in case you thought it was a p2p app or something |
| 02:23.36 | vontrapp | "Code monkey not say it out loud" |
| 02:23.42 | vontrapp | "Code monkey not crazy, just proud!" |
| 02:27.57 | graphyx | I was looking more along the lines of something by Midnight Oil. |
| 02:35.13 | Supaplex | details details |
| 02:37.58 | *** join/#utah elg (n=fugalh@falcon.fugal.net) |
| 02:39.53 | tene | Buy a compact disc at WalMart like a good little consumer. |
| 02:40.12 | elg | -lart tene |
| 02:40.22 | tene | :( |
| 02:40.32 | elg | -roulette |
| 02:40.32 | brac | elg: chamber 1 of 6 => *BANG* |
| 02:40.41 | tene | -roulette |
| 02:40.42 | brac | tene: chamber 1 of 6 => +click+ |
| 02:40.45 | elg | -roulette |
| 02:40.46 | brac | elg: chamber 2 of 6 => +click+ |
| 02:40.48 | tene | -roulette |
| 02:40.48 | brac | tene: chamber 3 of 6 => *BANG* |
| 02:41.15 | elg | daggone it, blockbuster sent me the wrong movie |
| 02:41.21 | elg | not the one at the top of my queue |
| 02:41.28 | elg | and the last disc they sent was cracked |
| 02:41.48 | tene | they didn't crack it, I did. |
| 02:42.02 | elg | oh, ok. in that case |
| 02:42.08 | elg | ~whaleslap tene |
| 02:42.14 | ibot | ACTION beats tene upside and over the head with a freakishly huge killer whale named Hugh |
| 02:42.23 | elg | and my stupid post office is terribly slow |
| 02:42.33 | elg | which I can't really blame on blockbuster though I might like to |
| 02:54.22 | *** join/#utah RyanE (i=Piadas@rberick.dsl.xmission.com) |
| 03:19.08 | *** join/#utah RyanE_ (i=Piadas@rberick.dsl.xmission.com) |
| 03:34.25 | *** part/#utah graphyx (n=mkling@24.144.57.161) |
| 03:46.57 | emcnabb | ~whaleslap maquis |
| 03:46.58 | ibot | ACTION beats maquis upside and over the head with a freakishly huge killer whale named Hugh |
| 03:47.10 | emcnabb | ~lart goozbach |
| 03:55.56 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 04:09.30 | *** join/#utah spengy (n=spengy@unaffiliated/spengy) |
| 04:14.42 | mheath | man...... |
| 04:14.54 | mheath | I've fallen in love with my dads VW Passat =P |
| 04:19.13 | mheath | A car that detects how much water is on the windshield.......... |
| 04:19.25 | *** join/#utah herlo (n=clints@70.103.228.158) |
| 04:20.16 | mheath | Automatically turns on/off the headlights/interior lights when I'm too stupid to do it.... |
| 04:20.20 | mheath | Climate control, heated seats.. |
| 04:20.26 | mheath | All leather interior |
| 04:22.37 | tene | even the covers of the dials on the dashboard? |
| 04:22.45 | tene | leather is kind of hard to see through... |
| 04:25.39 | QBFreak | tene: you just need to strech it thin enough |
| 04:25.58 | tene | Oh. |
| 04:26.39 | tene | steal mheat's father's car. |
| 04:26.46 | *** join/#utah elg (n=fugalh@falcon.fugal.net) |
| 04:27.04 | mheath | tene: The Passat? |
| 04:27.04 | tene | curses, foiled again! |
| 04:27.07 | mheath | Or the Porsche? |
| 04:27.09 | mheath | Or the Jeep? |
| 04:27.17 | mheath | Or the Mitsubishi Gallant? |
| 04:27.18 | mheath | Or the Jetta? |
| 04:27.18 | tene | Witout my '' I can't be appy anymore! |
| 04:27.29 | QBFreak | mheath: I'll take any one of those :) |
| 04:27.30 | tene | Nor can I op! |
| 04:27.43 | tene | yay! |
| 04:28.39 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 05:09.21 | tensai | ~rlart |
| 05:09.58 | mheath | ~rlart |
| 05:10.10 | mheath | I always seem to get atoponce. |
| 05:10.12 | mheath | Hmm. |
| 05:11.18 | tensai | must be a conspiracy |
| 05:11.30 | maquis | ~rlart |
| 05:12.51 | tensai | ~lart maquis |
| 05:12.55 | mheath | hmmm |
| 05:13.06 | maquis | -lart tensai |
| 05:13.15 | mheath | tomorrow will be very fun but also a very long day. |
| 05:13.55 | maquis | emcnabb: why'd i get whaleslapped? |
| 05:16.18 | tensai | maquis: because you smell like a fish? |
| 05:22.16 | maquis | tensai: huh? |
| 05:22.36 | maquis | ~lameometer m{\w{5}_Jesse} |
| 05:24.23 | tene | ~lameometer maquis |
| 05:24.29 | tene | ~lameometer tene |
| 05:30.32 | tensai | ~seen newsome |
| 05:30.37 | ibot | newsome <n=sorenson@adsl-75-0-136-70.dsl.chcgil.sbcglobal.net> was last seen on IRC in channel #utah, 46d 3h 53m 36s ago, saying: 'The 2 employees we've got are old VA folks'. |
| 05:31.01 | tene | ~lameometer newsome |
| 05:38.43 | mheath | ~lameometer mheath |
| 05:38.54 | mheath | ~lameometer 31337 |
| 05:39.00 | mheath | =P |
| 05:48.23 | ScytheBlade1 | Curious.. |
| 05:48.28 | ScytheBlade1 | ~lameometer #utah |
| 05:48.37 | ScytheBlade1 | lol |
| 05:48.40 | ScytheBlade1 | That's awesome |
| 05:55.09 | mheath | ChanServ 52% .....hahaha. |
| 05:58.20 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 06:07.27 | mheath | Someone wrote an article on CNN about white supremecists seeping into the US Military.... |
| 06:08.21 | mheath | I stumbled upon a related website for an Aryan superiority group....getting a big kick out of it. |
| 06:20.04 | *** join/#utah vontrapp_ (n=von@208.187.198.66) |
| 06:36.12 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 06:36.58 | *** join/#utah nick125_1appy (n=nick@dsl093-220-003.abq1.dsl.speakeasy.net) |
| 06:44.09 | levi_ | Heh, Richard Simmons on Who's Line Is It Anyway |
| 07:41.21 | findlay | I'm way tired |
| 07:41.26 | findlay | ~sleep |
| 07:41.27 | ibot | methinks sleep is overrated, and a poor substitute for caffeine. |
| 07:41.33 | findlay | whatever |
| 08:05.35 | *** join/#utah bigdog_ut (n=bigdog@207.135.132.13) |
| 11:54.25 | emcnabb | good morning |
| 14:13.30 | *** join/#utah elg (n=fugalh@falcon.fugal.net) |
| 14:54.30 | bonez41 | mornin' elg....got a minute to help a perl noob...understand how a script should work? |
| 14:57.26 | tewk | bonez41: What's your perl question? |
| 15:05.56 | bonez41 | tewk, ok....in a nutshell. I have lots of account datat in gnucash..., stored in an .xml file gnucash.xml.. I have a script, 'gnc20.pl' which is SUPPOSED to convert that data over to be useable by 'sql-ledger' an accounting program that uses postgresql...my QUESTION is..how do I get the data, if in fact it is actually converted....into sql-ledger...I run the gnc20.pl script in /tmp, and the gnucash.xml file is also there...for it to work on......i |
| 15:05.56 | bonez41 | t runs and prints lots of stuff to the screen, but in the end I see no changes to either file, no new files......etc.... |
| 15:06.29 | bonez41 | INSERT INTO chart (accno,description,category,link) VALUES ('3003','Retained Earnings','Q',''); |
| 15:06.29 | bonez41 | INSERT INTO gl (reference,description,transdate,notes) VALUES ('64cb83fca178ceda35c3bc4c6745b09b','Bonneville Chapter of Building Officials','2005-04-15',''); |
| 15:06.42 | bonez41 | for example...there's two lines from the script's output..... |
| 15:07.08 | bonez41 | what it all means...is beyond me.... |
| 15:07.16 | bonez41 | I ask in #perl and get the loud and droning chorus of RTFMMMMMMMMMMMMMMMMM |
| 15:07.26 | bonez41 | so I don't dare ask in there any more.... |
| 15:07.50 | bonez41 | tene helped rework the script....yesterday, but now,I am not sure what to do with the output.. |
| 15:08.26 | bonez41 | great..I have overwhelmed you as well... |
| 15:10.35 | tewk | Sorry popped out for a minute |
| 15:10.58 | tewk | perl scriptname gnucash.xml > sql_ledger_import.sql |
| 15:11.21 | tewk | That will redirect the screen output to a file sql_ledger_import.sql |
| 15:12.02 | tewk | I don't know sql-ldedger very well but then you should be able to do something like |
| 15:14.15 | tewk | psql < sql_ledger_import.sql or I think psql has a command to run a sql scrip, try /? inside psql |
| 15:14.27 | tewk | bonez41: |
| 15:15.31 | tewk | those INSERT INTO lines are raw SQL. that modify the postgres data base directly |
| 15:16.43 | tewk | It should work, but be careful, ie backup you database before you start mucking around with it |
| 15:22.46 | *** join/#utah graphyx (n=mkling@24.144.57.161) |
| 15:38.16 | bonez41 | tewk, thanks... |
| 15:39.40 | tewk | bonez41: psql -u user -p password -d database_name -f sql_script_name |
| 15:40.00 | maquis | morning bonez41 and tewk |
| 15:40.19 | bonez41 | maquis, hello ! |
| 15:40.51 | maquis | bonez41: how's it going? |
| 15:40.59 | bonez41 | tewk, when I run your first suggestion perl scriptname gnucash.xml > sql_ledger_import.sql all that does is collect the output...it's not really creating a useable .sql file though, right? |
| 15:41.30 | bonez41 | tewk, what does your last suggestion do? psql -u user ... ? |
| 15:43.42 | maquis | bonez41: it appears to connect to the server using your username and password, and run sql_script_name on the database given by database_name |
| 15:46.35 | tewk | My guess is that the output is a usable sql |
| 15:46.53 | elg | ~spell subtly |
| 15:47.01 | elg | ~dict subtly |
| 15:47.40 | tewk | bonez41: Its hard to know without seeing the output and the script. |
| 15:47.59 | bonez41 | hmmm.. I could paste some of it here.... |
| 15:48.36 | bonez41 | a couple lines....: INSERT INTO acc_trans (trans_id,chart_id,amount,transdate,source,cleared) VALUES ((SELECT id FROM gl WHERE reference = '3de7731d19fe4ea37c48570b771757e6'), (SELECT id FROM chart WHERE a |
| 15:48.36 | bonez41 | ccno = '4005'),8000,'2006-07-05','001481','0'); |
| 15:48.36 | bonez41 | UPDATE gl SET reference = '001481' WHERE reference = '3de7731d19fe4ea37c48570b771757e6'; |
| 15:48.46 | bonez41 | those are the last two lines of the script... |
| 15:49.40 | tewk | the sql script? if so that looks like valid sql to me. |
| 15:50.14 | bonez41 | ok...... |
| 15:50.35 | bonez41 | so I have sql_ledger_import.sql and run it through psql now< as above? |
| 15:51.07 | tewk | Yep, backup first! |
| 15:51.34 | maquis | agreed... |
| 15:51.35 | bonez41 | tewk, I am so lame about this....I don't even know what the database sql-ledger is using is called.....it contains nothing at this point...... |
| 15:51.37 | maquis | backup first! |
| 15:51.46 | bonez41 | nothing really to back up..in sql-ledger |
| 15:51.51 | maquis | good |
| 15:52.57 | tewk | type \l in psql. |
| 15:53.05 | tewk | It will list all the available databases |
| 15:55.02 | bonez41 | hmm can't even get logged in...... |
| 15:55.43 | bonez41 | by this afternoon, I'll have taken up drinkin..and be plastered....at this rate..or all my hair will be pulled out...... |
| 15:56.37 | maquis | bonez41: don't stress too much about it... just have some fun :) |
| 15:56.39 | bonez41 | have to get into psql first... |
| 15:56.50 | bonez41 | I know I have been in there before..... |
| 15:57.45 | maquis | bonez41: if you have root on the machine, you can su to the postgres (or something like that) account, and sign in that way (at least i've been able to do that) |
| 15:59.12 | bonez41 | maquis, ok, I su to root, then su postgres and this makes me postgres.... |
| 15:59.24 | maquis | yeah... |
| 15:59.46 | maquis | now, i'm thinking that you can go into psql without giving a username or password, iirc |
| 15:59.51 | bonez41 | so at the prompt , the postgres prompt now.....what to log in to psql and then to list the databases? |
| 16:00.07 | maquis | run psql, and then list databases |
| 16:00.11 | maquis | should work (maybe) |
| 16:02.49 | bonez41 | postgres@fyrenice:/tmp$ psql |
| 16:02.49 | bonez41 | psql (pg_wrapper): No database specified |
| 16:02.54 | bonez41 | that's what I get... |
| 16:03.00 | maquis | hmmm |
| 16:03.04 | maquis | ummm... |
| 16:03.08 | maquis | how did i get around that? |
| 16:03.45 | bonez41 | not sure... |
| 16:03.50 | maquis | is there an option in man psql to not assign a db? |
| 16:03.58 | maquis | i'd look, but i've actually got to leave in like 2 minutes |
| 16:04.02 | maquis | and i'm not ready yet :) |
| 16:05.56 | bonez41 | maquis, no worry..... |
| 16:06.01 | bonez41 | where are you going this morning? |
| 16:06.41 | maquis | i'm going out with my boyfriend |
| 16:07.53 | bonez41 | oh....good for you......he's a lucky guy....... |
| 16:08.14 | bonez41 | to have the attention of such a smart girl....... |
| 16:22.23 | tewk | bonez41: psql -l at the commandline works also |
| 16:22.41 | tewk | you really ought to read man psql |
| 16:27.51 | bonez41 | that worked.... |
| 16:28.08 | bonez41 | ok, off to treat next patient.....back soon though |
| 16:28.28 | maquis | later all :) |
| 16:30.38 | *** join/#utah tristanbob (n=tristanb@c-67-164-202-102.hsd1.ut.comcast.net) |
| 16:48.33 | *** join/#utah elg (n=fugalh@falcon.fugal.net) |
| 16:49.43 | *** join/#utah TimRiker (n=timr@pdpc/supporter/bronze/TimRiker) |
| 16:49.43 | *** mode/#utah [+o TimRiker] by ChanServ |
| 17:14.36 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 17:20.14 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 17:23.48 | *** part/#utah roscivs (n=ross@c-24-18-48-12.hsd1.mn.comcast.net) |
| 17:25.51 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 17:36.29 | *** join/#utah levi_ (n=levi@levi.dsl.xmission.com) |
| 18:01.37 | *** join/#utah spr (n=spr@c-67-169-251-207.hsd1.ut.comcast.net) |
| 18:08.08 | bonez41 | tewk, that worked....... |
| 18:08.19 | bonez41 | tewk, the import seems to have worked |
| 18:09.08 | tewk | bonez41: Good for you! |
| 18:09.58 | bonez41 | it's not perfect, but at least it imported the chart.... |
| 18:12.52 | bonez41 | so it imported, under chart of accounts...it lists my various accounts, but not sure where each customer's information went..it's not under customers |
| 19:11.16 | *** join/#utah elg (n=fugalh@falcon.fugal.net) |
| 19:36.55 | xbmodder_newlapp | About 40% of this computer programming course is questions about windows, and its programs -_- |
| 20:14.26 | *** join/#utah SpecialK (n=Bob@cpe-66-69-221-165.austin.res.rr.com) |
| 20:24.58 | elg | -lart vontrapp |
| 20:34.54 | *** join/#utah roscivs (n=ross@c-24-18-48-12.hsd1.mn.comcast.net) |
| 20:35.26 | roscivs | hey, anybody know a tool for graphing java class dependencies? |
| 20:36.33 | findlay | eclipse? |
| 20:36.48 | roscivs | will eclipse do that? |
| 20:36.54 | roscivs | with some plugin? |
| 20:37.30 | findlay | I've never used eclipse, but it probably does |
| 20:37.53 | roscivs | oh, well, i use eclipse on a daily basis, and I have never seen any such feature :) |
| 21:05.05 | roscivs | looks like there's an eclipse plugin called Byecycle that appears to do something along those lines |
| 21:06.37 | roscivs | it's really really slow though |
| 21:22.08 | *** join/#utah wps (n=wps@gw6.rapidwave.net) |
| 22:19.37 | *** join/#utah elg (n=fugalh@falcon.fugal.net) |
| 23:22.31 | *** join/#utah mheath (n=mheath@c-67-182-231-23.hsd1.co.comcast.net) |
| 23:35.17 | ScytheBlade1 | Oh how I love you, DNS |
| 23:43.05 | nick125_lappy | why do you love DNS? |
| 23:43.25 | ScytheBlade1 | http://boredom.brantleyonline.com/?p=25 |
| 23:43.36 | nick125_lappy | I usually hate DNS :P |
| 23:43.44 | nick125_lappy | because it never works for me :P |
| 23:44.25 | ScytheBlade1 | Take a read |
| 23:44.27 | ScytheBlade1 | Really |
| 23:44.38 | nick125_lappy | lol |
| 23:44.39 | nick125_lappy | nice |
| 23:45.07 | ScytheBlade1 | ty :) |
| 23:48.37 | tene | ScytheBlade1: is that you, or just something you found? |
| 23:48.50 | ScytheBlade1 | tene, that's me |
| 23:49.20 | tene | how did you configure a vpn to listen on 53/udp without being able to get out on the internet to connect to the server? |
| 23:49.40 | ScytheBlade1 | public access computers they had available |
| 23:49.54 | ScytheBlade1 | Running XP and IE |
| 23:50.07 | tene | let you download/run putty? |
| 23:50.13 | ScytheBlade1 | They sure did |
| 23:50.18 | tene | 'kay |
| 23:50.29 | ScytheBlade1 | Nice to know, huh? ;) |
| 23:50.44 | ScytheBlade1 | After that day |
| 23:50.55 | ScytheBlade1 | We have one IP servicing OpenVPN on :53/udp |
| 23:50.59 | ScytheBlade1 | and squid on :53/tcp |
| 23:51.12 | ScytheBlade1 | All I needed was squid at cherry hill for that one |
| 23:51.17 | ScytheBlade1 | UVSC required OpenVPN |
| 23:53.28 | ScytheBlade1 | Note that I typed that on my Zaurus keyboard... so it's probably filled with misspellings |