| 00:15.22 | thebigdog | mindjuju, you have that done for me yet? |
| 00:16.42 | mgeary | fungus: you still around? |
| 00:18.08 | fungus | yes |
| 00:25.16 | *** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 00:43.10 | mgeary | fungus: sorry, didn't see your reply. i'm heading out, but wanted to ask a couple of Qs about the NS stuff |
| 00:43.16 | mgeary | i'll look for you later tonight or tomorrow |
| 00:43.32 | fungus | ok |
| 00:44.17 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 01:10.57 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 01:10.57 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 04:47.26 | *** join/#uphpu knine (n=knine@128.187.146.132) |
| 05:25.37 | influx^^ | "I wrote 20 short programs in Python yesterday. It was wonderful. Perl, I'm leaving you." http://imgs.xkcd.com/comics/python.png |
| 05:26.48 | knine | ha |
| 05:42.55 | *** join/#uphpu jnbek (n=jnbek@72.8.114.148) |
| 12:18.06 | *** join/#uphpu influx^_^ (n=influx@influx.dsl.xmission.com) |
| 12:18.11 | influx^_^ | HAA |
| 13:40.16 | *** join/#uphpu jsmith_ (n=jsmith@68.246.38.7) |
| 13:41.00 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 14:17.01 | *** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 14:17.01 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 15:11.18 | *** join/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 15:19.40 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 15:19.40 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 15:20.01 | timinator | morning all |
| 15:39.40 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 15:39.40 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 15:42.56 | *** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 15:42.56 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 15:46.00 | timinator | thebigdog is in the house!!! |
| 15:46.18 | thebigdog | oh yes |
| 15:53.55 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 15:53.55 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 15:59.49 | *** join/#uphpu wps (n=wps@64.0.192.53) |
| 15:59.49 | *** mode/#UPHPU [+o wps] by ChanServ |
| 16:04.50 | mindjuju | mornin' gents |
| 16:05.00 | wps | good morning |
| 16:05.35 | *** join/#uphpu fungus (n=olsonl@2001:5c0:8fff:fffe:0:0:0:1647) |
| 16:05.35 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:14.47 | *** join/#uphpu mikesmullin (i=user@63.76.119.176) |
| 16:16.49 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 16:16.49 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:26.27 | mindjuju | for those of you who have a moment, this is funny - http://www.yahoo.com/s/752534 |
| 16:38.45 | *** join/#uphpu kingsol (n=kingsol@64.0.193.254) |
| 16:42.12 | *** part/#uphpu kingsol (n=kingsol@64.0.193.254) |
| 16:49.09 | *** join/#uphpu unum_ (n=unum@70.89.247.221) |
| 16:55.30 | fungus | http://www.dell.com/content/topics/segtopic.aspx/m1730_wow?c=us&cs=19&l=en&s=dhs&dgc=EM&cid=26383&lid=601037 |
| 16:56.20 | mindjuju | thebigdog should see that |
| 16:57.35 | timinator | mindjuju: that is pretty cool |
| 16:58.44 | timinator | fungus: that's pretty cool too |
| 16:58.52 | timinator | little pricey though |
| 16:59.36 | mindjuju | yeah, true that |
| 16:59.49 | fungus | A *little* pricey? I would say a whole lot pricey. |
| 17:00.08 | timinator | yes |
| 17:03.33 | thebigdog | it has the full keyboard which is really nice |
| 17:03.34 | fungus | I love that song |
| 17:03.47 | mindjuju | yeah, it's a good 'un |
| 17:04.23 | fungus | The laptop also has great options like blu-ray, raid, solid-state drives, etc. |
| 17:05.45 | mindjuju | k, now to kick it into high gear |
| 17:10.29 | *** join/#uphpu kingsol (n=kingsol@64.0.193.254) |
| 17:18.29 | *** join/#uphpu kingsol (n=kingsol@64.0.193.254) |
| 17:22.00 | timinator | for mindjuju |
| 17:23.28 | mindjuju | :) |
| 17:23.34 | mindjuju | that's a good 'un too |
| 17:26.06 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 17:26.06 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 17:49.14 | *** join/#uphpu xilch|w (n=xilch@ip65-44-116-165.z116-44-65.customer.algx.net) |
| 18:19.57 | *** join/#uphpu bradym (n=bradym@Qst4FC.quinstreet.com) |
| 18:19.57 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 18:20.29 | mindjuju | ~chuckfact |
| 18:20.31 | jbot | There is no chin under Chuck Norris Beard. There is only another fist |
| 18:23.25 | *** join/#uphpu kingsol (n=kingsol@64.0.192.139) |
| 18:23.40 | *** join/#uphpu SunSparc (n=sparky@66.7.114.125) |
| 18:27.46 | mindjuju | ~stressed |
| 18:27.46 | jbot | Looks like I picked the wrong week to quit smoking! |
| 18:30.52 | Utah_Dave | jsmith: have you tried BeautifulSoup? |
| 18:31.15 | jsmith | Utah_Dave: Never heard of it... |
| 18:31.56 | jsmith | Utah_Dave: Looks very nice... if only I was better at Python |
| 18:32.09 | jsmith | Utah_Dave: I'm doing it in PHP since it's the language (for better or worse) that I know best |
| 18:32.23 | jsmith | (and the fact that I've got 30 minutes to get this proof-of-concept working) |
| 18:32.35 | Utah_Dave | I'm in the same boat, but it wasn't too hard to figure out, actually. |
| 18:32.36 | SunSparc | Why would POST data not be reaching the server when I click Submit on a form? |
| 18:32.38 | Utah_Dave | Oh, I see |
| 18:37.33 | SunSparc | I click submit on the form and then I echo out SERVER and REQUEST. The SERVER info is displayed. Some GET info is displayed. Some Cookie info is displayed. But no POST info is displayed. |
| 18:37.44 | mgeary | Beautiful Soup is cool |
| 18:38.14 | mgeary | SunSparc: woah |
| 18:38.16 | mgeary | you're back |
| 18:38.20 | SunSparc | :) |
| 18:38.26 | mgeary | we thought our MR friends had abandoned us for good |
| 18:38.31 | SunSparc | hehe |
| 18:38.35 | *** part/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 18:38.37 | SunSparc | Nope, still here. |
| 18:38.39 | mgeary | why the long absence? |
| 18:38.40 | SunSparc | Just really busy |
| 18:38.50 | SunSparc | Holiday rush :) |
| 18:38.53 | mgeary | ah. the inference, of course, is that the rest of us are NOT busy ;) |
| 18:39.07 | SunSparc | Naturally |
| 18:39.08 | SunSparc | :) |
| 18:39.11 | mgeary | :) |
| 18:39.11 | SunSparc | lol |
| 18:39.30 | mgeary | re: your problem. Are you *certain* that your input fields are within your form tags? |
| 18:40.26 | SunSparc | Yes |
| 18:40.50 | *** join/#uphpu jondoe (n=jason@67.42.124.159) |
| 18:44.52 | jnbek | 5<::>Vic Vance beat up his brother Lance, just so I could devastate you all with: /mp3/music/Opeth/Opeth - Deliverance - 02 - Deliverance.mp3 [3:46/13:38] [202 kbps] Freq: [44100] Current Volume: [83%] Genre: [Progressive Death Metal] Playlist position: [300/1714]<:-^-_-^-:>5 |
| 18:45.11 | mgeary | uh....... |
| 18:45.50 | jnbek | sorry wrong window |
| 18:47.41 | synic | he had to listen to his brother's death metal, and then got beat up. He can't be doing very well. |
| 18:52.14 | jnbek | hehe, Opeth isn't so bad, they add alot of 70's rock/blues/folk music in with their metal |
| 18:57.14 | *** join/#uphpu eggyknap (n=jtolley@ip67-88-113-150.z113-88-67.customer.algx.net) |
| 18:57.31 | mindjuju | hi eggyknap |
| 18:57.36 | mindjuju | thebigdog, you around? |
| 18:57.39 | eggyknap | :) |
| 18:57.57 | mindjuju | thebigdog is our resident PostgreSQL guru |
| 18:58.09 | mindjuju | well, really anything SQL |
| 18:58.36 | eggyknap | For the rest of those watching, I've been talking w/ mindjuju on #utos about the possibility of a PostgreSQL users' group. |
| 18:58.41 | jsmith | w00t! |
| 18:58.46 | jsmith | PostgreSQL rocks! |
| 18:59.10 | jsmith | But I'd be happy to hang out on the mailing list, etc. if there were! |
| 18:59.16 | mindjuju | well, i know josephscott is a user too |
| 18:59.28 | mindjuju | actually, and PoeticIntensity |
| 18:59.37 | eggyknap | I might just get the PostgreSQL guys to set up a list, and see who joins up. |
| 19:00.05 | jsmith | UPHPU now stands for "Utah PHP, Happiness, and PostgreSQL Users Group" |
| 19:00.19 | mindjuju | wish thebigdog was around, he could say when brastos OS database group was planning to meet |
| 19:00.27 | PoeticIntensity | mindjuju, ....? |
| 19:00.29 | PoeticIntensity | huh? |
| 19:00.30 | josephscott | wasn't there going to be an open source db group some where? |
| 19:00.38 | mindjuju | looking to see who was PostgreSQL users |
| 19:00.41 | PoeticIntensity | I think brasto is heading that up. |
| 19:00.50 | PoeticIntensity | ah... yup. I'm using it - for sure. |
| 19:00.57 | mindjuju | yeah, was telling eggyknap that brasto was headed in that direction, first meet in Jan |
| 19:01.08 | mindjuju | but didn't know date, location @ linuxnetworx though |
| 19:01.21 | josephscott | there are lot of good general db issues that aren't db specific that are run to chat about |
| 19:03.01 | eggyknap | Well, FWIW, the pugs.postgresql.org guy I know says he can likely create a list for me. I'll probably get it set up, and start publicizing to see who joins. |
| 19:03.44 | thebigdog | im here now |
| 19:04.10 | eggyknap | thebigdog == brato ? |
| 19:04.20 | eggyknap | Oh, nm :) |
| 19:04.33 | thebigdog | no |
| 19:05.18 | mindjuju | thebigdog is postgreSQL guru |
| 19:05.28 | mindjuju | and knew the date of the OS database group meet |
| 19:05.34 | mindjuju | jan sometime, if i recall? |
| 19:05.52 | thebigdog | not sure on that |
| 19:06.01 | mindjuju | oh, gotcha |
| 19:06.12 | mindjuju | eggyknap looking to start UG for postgreSQL |
| 19:06.52 | thebigdog | oh |
| 19:07.03 | thebigdog | yeah that specific on database might not fly |
| 19:07.17 | thebigdog | herlo and brato had that conversation |
| 19:07.28 | eggyknap | My thoughts exactly. I'm mostly trying to gauge interest. |
| 19:07.37 | thebigdog | they do have oracle user groups but that is huge |
| 19:07.59 | thebigdog | a database group that is open to all is a great idea imho |
| 19:08.18 | thebigdog | http://udbug.org/ |
| 19:08.22 | thebigdog | that is the website |
| 19:08.23 | mindjuju | yeah, even MS SQL 2k, and 2k5 |
| 19:08.31 | thebigdog | yeah |
| 19:08.34 | eggyknap | Ok, there's a site already? Neat :) |
| 19:08.59 | thebigdog | we started to discuss the possiblity of a joint meeting |
| 19:09.07 | mindjuju | oh snap! he is covering ms sql 2k |
| 19:09.09 | thebigdog | uphpu and udbug |
| 19:09.19 | thebigdog | it is a db in use |
| 19:09.31 | mindjuju | well, wth, maybe i'll go |
| 19:10.00 | thebigdog | i wanted to do the jan meeting with uphpu and udbug |
| 19:10.10 | thebigdog | so that we can get that group started with some attendance |
| 19:10.33 | thebigdog | giving brasto some time to talk about the group and where he wants to go with it |
| 19:12.40 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 19:12.40 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 19:27.54 | *** join/#uphpu kingsol_ (n=kingsol@64.0.193.254) |
| 19:49.49 | timinator | what's the key command to force a PC to boot from a CD? |
| 19:50.39 | jsmith | timinator: Depends on the machine... F11 or F12 on some machines (although F12 often does PXE boot instead) |
| 19:55.58 | timinator | k, thx |
| 19:56.48 | timinator | F1 and F2 didn't work.... got it to work by changing the boot sequence.... don't know why it wouldn't have the CD drive on a higher priority |
| 19:56.50 | timinator | crazy |
| 20:01.26 | jsmith | Of course not... same reason you can't get "Country Ham and Red-eye Gravy" grits in anything but the assortment pack |
| 20:01.46 | mgeary | uhh, 'cause The Man won't let us? |
| 20:02.31 | beandog | and my peanut butter is never on sale |
| 20:02.38 | beandog | its a conspiracy |
| 20:03.53 | mgeary | it's the 10th and final step to establishing a Fascist State |
| 20:04.54 | beandog | its all about the Jif. |
| 20:05.12 | mgeary | the whole point of the web is that it's non-modal |
| 20:16.21 | timinator | Adams PB rocks |
| 20:16.24 | timinator | :) |
| 20:22.06 | beandog | too oily |
| 20:25.13 | timinator | mix it up..... there's no hydrogenated oils... much better for you :) |
| 20:34.56 | *** join/#uphpu pelaofeliz (n=PelaoFel@67.108.236.230) |
| 20:36.45 | mindjuju | haven't noticed that much difference between peanut butter, but the important thing is that it be EXTRA crunchy |
| 20:39.36 | mgeary | hey, help me out with a SSH tunnel issue: |
| 20:40.16 | mindjuju | mgeary, for ssh tunneling i've found herlo, fungus and dataw0lf to have tons of knowledge |
| 20:40.22 | mgeary | i've got a machine with a firewall on all ports but 22 and 80. I can ssh in and start a VNC server, but how do i set up the tunnel such that i can launch a VNC viewer on my local machine on a local port and forward it to the firewalled machine? |
| 20:40.43 | mgeary | i've set up tunnels between a broker machine, but haven't done it before from one machine directly to another |
| 20:40.55 | Utah_Dave | mgeary: I'd use NX server |
| 20:40.59 | mgeary | ? |
| 20:41.15 | Utah_Dave | It's like VNC, but it does all the tunneling and everything for you. |
| 20:41.21 | mgeary | does it work on Mac? |
| 20:41.30 | fungus | ssh -L 5900:localhost:5900 server.domain.com |
| 20:41.30 | Utah_Dave | It's fast and encrypts everything |
| 20:41.34 | mgeary | thanks fungus |
| 20:41.42 | Utah_Dave | are both machines macs? |
| 20:41.46 | fungus | Then just vncviewer into your localhost |
| 20:42.26 | eggyknap | NX is neat -- if you can make it work. Perhaps it's just me, but I've had a pretty painful time making it work decently. |
| 20:42.51 | Utah_Dave | I just set it up yesterday and it was really easy |
| 20:43.04 | beandog | timinator, mix it up? |
| 20:43.06 | Utah_Dave | but the server seems to be only for Linux or Solaris |
| 20:43.20 | Utah_Dave | They have clients for linux, Mac OS, Windows, etc |
| 20:43.44 | timinator | beandog: ya, you stir it up.... PB naturally separates |
| 20:43.51 | timinator | but Adams is all natural |
| 20:44.12 | mgeary | fungus: should that also be dropping me into a shell on my remote server? |
| 20:44.21 | mgeary | but it is |
| 20:44.26 | fungus | yes, it should |
| 20:44.30 | mgeary | k |
| 20:45.00 | timinator | Ingredients: Peanuts and <=1% Salt |
| 20:45.23 | timinator | whereas the others have preservatives and hydrogenated oils |
| 20:45.30 | timinator | and other crap |
| 20:45.50 | mindjuju | timinator, the real question is though, does Adams make extra crunchy? |
| 20:46.00 | mindjuju | not just crunchy, mind you, but extra crunchy |
| 20:46.10 | *** join/#uphpu Jacob_Kerr (i=Jacob@c-67-186-242-129.hsd1.ut.comcast.net) |
| 20:46.15 | beandog | well theres a few other "all natural" things I wouldnt eat either. |
| 20:46.18 | timinator | not sure |
| 20:46.49 | Jacob_Kerr | ok I am trying to connect to an encrypted sqlite database does anyone have any experience with that? |
| 20:47.18 | beandog | how do you encrypt the db? |
| 20:47.19 | mindjuju | pickled eggs, pork feet and onions are absolutely off my list of "prolly all natural ingredients" but would never touch |
| 20:47.28 | Jacob_Kerr | I did not encrypt it so I do not know.. |
| 20:47.39 | Jacob_Kerr | it was done in cgi and I am trying to connect via php |
| 20:48.09 | Jacob_Kerr | this is the error I am getting: Warning: sqlite_open(): file is encrypted or is not a database in /var/www/vhosts/massagetableoutlet.com/httpdocs/custom-cart/cartdb.php on line 7 |
| 20:48.09 | timinator | mindjuju: LOL |
| 20:48.21 | SunSparc | mindjuju: what about fried snickers? |
| 20:48.44 | mindjuju | uh, you know, i didn't know they had that |
| 20:48.50 | mindjuju | last i heard of fried was twinkies |
| 20:48.52 | mgeary | opium is "all natural" |
| 20:48.56 | mindjuju | but never had those either |
| 20:50.35 | timinator | mgeary: so is weed |
| 20:50.37 | timinator | LOL |
| 20:50.43 | SunSparc | Hmm, how about a chocolate covered, snicker-stuffed, twinkie, with opium sprinkles. |
| 20:50.43 | mgeary | exactly |
| 20:51.02 | mgeary | just because it's natural doesn't mean consuming it is a good idea. Hemlock and Tree Frogs are also natural |
| 20:52.01 | timinator | Trees: Earth's Renewable Resource |
| 20:57.35 | Jacob_Kerr | is there anyway to connect to an encrypted sqlite database via PHP? |
| 20:57.59 | Jacob_Kerr | I tired sqlite_open and got: Warning: sqlite_open(): file is encrypted or is not a database in /var/www/vhosts/massagetableoutlet.com/httpdocs/custom-cart/cartdb.php on line 7 |
| 20:59.29 | timinator | mindjuju: for extra crunchy PB that doesn't have all the junk in it, you should go to Smith's. They have a peanut grinder. It's very cool. |
| 20:59.38 | beandog | well |
| 20:59.45 | beandog | make sure its really a databse |
| 20:59.47 | beandog | run file on it |
| 20:59.48 | eggyknap | timinator: any idea how much it is? |
| 20:59.51 | beandog | see if its sqlite2 or sqlite3 |
| 21:00.45 | timinator | why would one use sqlite? |
| 21:01.04 | mindjuju | jacob_kerr - http://php.net/sqlite |
| 21:01.09 | mindjuju | look about half way |
| 21:01.29 | mindjuju | <PROTECTED> |
| 21:01.43 | mindjuju | look for entry by this dude - papafox888 at hotmail dot com |
| 21:02.37 | fungus | timinator: because SQLite is light, requires no separate server to manage, and is easily portable. |
| 21:03.39 | timinator | hmm |
| 21:04.19 | *** join/#uphpu brasto (n=brasto@out.lnxi.com) |
| 21:04.19 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 21:04.43 | beandog | http://arstechnica.com/news.ars/post/20071205-adobes-pdf-now-an-iso-standard.html |
| 21:08.48 | timinator | it's self contained, huh? That's cool. So, could this be used as a client side DB? |
| 21:08.56 | mgeary | yes. is all the time |
| 21:09.04 | timinator | VERY COOL |
| 21:09.32 | mgeary | but browser security sandbox prevents it from being a client-side storage place for web apps, though recent discussions have inclined around this |
| 21:09.33 | timinator | all the time? am I the only one who's not aware of that technique? |
| 21:09.58 | mgeary | i use sqlite to drive standalone client-side multimedia apps |
| 21:10.33 | timinator | is there a tutorial or sample code that you'd recommend? |
| 21:10.50 | Jacob_Kerr | thanx u guys |
| 21:11.04 | mgeary | well, i'm talking about building things in Director, and there's an Xtra that wraps sqlite. |
| 21:11.06 | SunSparc | I am running php on my local machine. I do a phpinfo to try and see which php.ini file it is using. It just says |
| 21:11.11 | SunSparc | "/etc" |
| 21:11.42 | SunSparc | I do a locate and disable all php.ini files that I find and restart apache. |
| 21:11.50 | SunSparc | phpinfo does not change |
| 21:11.55 | SunSparc | Any idea? |
| 21:14.41 | mgeary | yes |
| 21:14.50 | mgeary | it's not using *any* php.ini file |
| 21:14.58 | mgeary | if it were, it would actually list the file, not just /etc |
| 21:15.01 | SunSparc | That is what it appears |
| 21:15.07 | mgeary | do you *want* to use one? |
| 21:15.12 | SunSparc | Yes |
| 21:15.16 | mgeary | if so, put it in /etc/php.ini and restart apache |
| 21:15.20 | mgeary | see what you get |
| 21:15.34 | SunSparc | I tried putting one there and it did not get it. Let me do it again, just for grins. |
| 21:15.47 | SunSparc | Because I am not sure I am not crazy |
| 21:15.49 | SunSparc | :) |
| 21:16.27 | brasto | for jdbc connection to mysql I need a jdbc server on the host with mysql, and a jdbc client on the client machine, right? |
| 21:17.18 | thebigdog | no |
| 21:18.20 | thebigdog | brasto you need a jdbc driver from where you are making the connection from |
| 21:18.29 | thebigdog | if you are doing a webapp then the app needs the driver |
| 21:18.37 | thebigdog | if you are client then the client needs the driver |
| 21:18.51 | eggyknap | jdbc should know how to talk to the mysql server directly |
| 21:18.55 | thebigdog | basically whatever is making the connection needs access to the driver |
| 21:19.03 | brasto | good, that simplifies things |
| 21:19.15 | eggyknap | brasto: You're the one, IIRC, trying to set up a UDBUG meeting in Jan sometime? |
| 21:19.27 | brasto | now I need to figure out how to configure jdbc, which I installed on my opensuse machine. |
| 21:19.34 | brasto | eggyknap: yes |
| 21:19.42 | thebigdog | brasto what needs to talk with mysql? |
| 21:20.00 | eggyknap | brasto: make sure the jdbc jar in in your classpath. As to the URLs you need to use, that should be in the driver documentation. |
| 21:20.33 | SunSparc | mgeary: Thanks, I was going crazy. It worked this time. Probably just the stress and lack of sleep. :) |
| 21:20.51 | mgeary | heh |
| 21:20.52 | mgeary | np |
| 21:21.40 | brasto | thebigdog: want to connect openoffice to a remote mysql |
| 21:21.49 | thebigdog | oh ok |
| 21:21.58 | thebigdog | i can tell you |
| 21:22.05 | brasto | then I can create a view on my server-side addressbook that fits the openoffice addressbook fields |
| 21:22.17 | thebigdog | yeah |
| 21:22.21 | thebigdog | in options |
| 21:22.27 | thebigdog | under openoffice.org base |
| 21:22.35 | thebigdog | go to connections |
| 21:22.42 | brasto | eggyknap: might those config files be in /etc somewhere |
| 21:23.16 | thebigdog | see if the driver is loaded already |
| 21:23.20 | thebigdog | if not then we need to load it |
| 21:23.37 | brasto | thebigdog: I'm on "Set up a JDBC connection". |
| 21:23.40 | eggyknap | I'm not sure exactly how OpenOffice does it (it's been a long time since I tried Base). Most java apps use a classpath environment variable or an option passed to the Java VM |
| 21:24.09 | thebigdog | check the connections in the base section of the options |
| 21:24.17 | thebigdog | see if the driver is there already |
| 21:24.27 | thebigdog | openoffice shipts with a mysql driver already |
| 21:24.32 | brasto | eggyknap: I was thinking OOo would use an existing defined jdbc connection, but I'm not sure where to define it |
| 21:24.33 | thebigdog | atleast 2.3 version |
| 21:25.16 | brasto | thebigdog: I'm not sure how to define a jdbc url |
| 21:25.23 | thebigdog | dont worry |
| 21:25.26 | brasto | jdbc:<hostname>? |
| 21:25.34 | thebigdog | get out of that for a minute |
| 21:25.38 | brasto | and what to put for driver class? |
| 21:25.39 | brasto | ok |
| 21:25.39 | Jacob_Kerr | I guess I have: sqlite.c,v 1.62.2.16 |
| 21:25.49 | thebigdog | you need to see if you have one already |
| 21:25.54 | Jacob_Kerr | so the I should be able to connect via sqlite_open right |
| 21:26.27 | brasto | Jacob_Kerr: sqlite is a different kind of database. |
| 21:27.10 | thebigdog | brasto, can you see the driver in there already under the options |
| 21:27.42 | brasto | thebigdog: I don't think it has it already because when I open Base, it asks me to create or select an existing database. |
| 21:28.00 | thebigdog | in the options |
| 21:28.12 | brasto | there's no options box yet in Base. |
| 21:28.17 | brasto | I'll try another of the apps |
| 21:28.36 | thebigdog | what version of open office you have? |
| 21:28.46 | brasto | 2.3 |
| 21:29.22 | thebigdog | ok under options go to openoffice.org |
| 21:29.24 | thebigdog | then to java |
| 21:29.37 | thebigdog | you should have 1 java runtime env setup |
| 21:29.56 | thebigdog | click on the class path |
| 21:30.00 | brasto | I want into Calc, then Tools, Options, OpenOffice.org Base. |
| 21:30.17 | thebigdog | k now go up to openoffice.org |
| 21:30.22 | thebigdog | at the very top of the options |
| 21:30.26 | brasto | I see it now |
| 21:30.31 | thebigdog | then java |
| 21:30.40 | thebigdog | you should have a jre installed |
| 21:30.48 | brasto | it says "Use Java runtime environment" |
| 21:30.59 | thebigdog | k and you have a list of them in a box |
| 21:31.18 | thebigdog | on right you have add, parameters..., classpath |
| 21:31.24 | thebigdog | select the classpath |
| 21:31.25 | brasto | yep |
| 21:31.31 | thebigdog | then go find the archive |
| 21:31.38 | thebigdog | mysql jdbc jar file |
| 21:32.20 | brasto | not sure where the mysql jdbc jar file is |
| 21:32.31 | thebigdog | have you downlaoded one |
| 21:32.57 | thebigdog | grab from here if you need one http://dev.mysql.com/downloads/connector/j/3.1.html |
| 21:32.59 | brasto | I installed jre, and installed all things using YaST that had keyword 'JDBC'... |
| 21:33.34 | brasto | ok, I'll see if I have it with a find command and do the download if I don't |
| 21:34.13 | thebigdog | yeah you can search system for all *.jar files that have mysql in the name |
| 21:34.28 | thebigdog | once you add that to the classpath then you can create your connection |
| 21:34.41 | brasto | are they commonly in /etc, /usr, /opt, or somewhere else? |
| 21:34.59 | thebigdog | not sure on opensuse |
| 21:35.06 | thebigdog | probably /usr/share |
| 21:35.08 | thebigdog | or /var/share |
| 21:35.28 | brasto | hadn't thought of /var - that was too obvious... |
| 21:35.32 | thebigdog | or jdbc url would be like the folowing |
| 21:35.51 | thebigdog | jdbc:mysql://<hostname>:<3306>/<dbname> |
| 21:36.15 | thebigdog | jdbc driver class would be the following: org.gjt.mm.mysql.Driver |
| 21:36.22 | thebigdog | or org.git.mm.mysql.Driver |
| 21:36.27 | thebigdog | can remember which one |
| 21:36.34 | thebigdog | git or gjt |
| 21:36.57 | eggyknap | I just tried it w/ Postgresql, and it turns out you don't stick the JDBC jar in the classpath. You've gotta configure OpenOffice to know where the driver is (Tools->Extensions or some such). At least on my version (2.2) |
| 21:39.37 | thebigdog | never heard of that |
| 21:39.42 | brasto | I think I found it: |
| 21:39.44 | brasto | find / -iname '*.jar' | grep mysql |
| 21:39.45 | brasto | /usr/share/java/mysql-connector-java.jar |
| 21:39.45 | brasto | /usr/share/java/mysql-connector-java-3.1.12.jar |
| 21:39.51 | thebigdog | those are the ones |
| 21:40.04 | thebigdog | eggyknap, did you restart openoffice after the classpath change? |
| 21:40.05 | brasto | the first is a shortcut to the latest |
| 21:40.13 | thebigdog | that is cool |
| 21:43.31 | eggyknap | thebigdog: there was no classpath involved. After installing the driver in that extensions dialog, I did not have to restart OpenOffice to make it work. |
| 21:44.06 | eggyknap | FWIW, my oo.org installation has MySQL drivers built it -- but I have no idea what MySQL versions it supports |
| 21:46.15 | thebigdog | the help has always said to put in the classpath section under java |
| 21:46.24 | thebigdog | not sure why it would allow it under the extensions |
| 21:47.05 | brasto | I'm closer, but I'm getting "Communications link failure due to underlying exception" - however, I think I'm using OOo's native MySQL connector because I picked "MySQL" in the drop-down, not "jdbc". |
| 21:47.30 | thebigdog | yeah you need jdbc with that |
| 21:48.08 | brasto | it does let you select jdbc after you pick mysql, but I don't know yet if it's using the one I added in Tools, Options |
| 21:48.16 | thebigdog | im not sure how the openoffice mysql connector works |
| 21:48.45 | thebigdog | does it give option for odbc wiht mysql |
| 21:48.48 | brasto | ah, a little better - I flushed privilidges in mysql |
| 21:49.03 | brasto | still not quite there, one moment... |
| 21:52.45 | *** join/#uphpu Black_Chaos (n=admin@oalug/member/blackchaos) |
| 21:52.45 | *** mode/#UPHPU [+v Black_Chaos] by ChanServ |
| 21:56.42 | brasto | OK, if I open Base, it brings up a Database Wizard. I can 'Create a new database', 'Open an existing database file', or 'Connect to an existing database'. Under 'Connect to...', I can choose 'JDBC', 'MySQL', 'ODBC', and others. |
| 21:56.42 | brasto | If I choose 'JDBC', it asks for a 'Datasource URL' with prefix 'jdbc:' entered for me and for a 'JDBC driver class'. |
| 21:56.43 | brasto | If I choose MySQL, it asks if I want to connect to MySQL using ODBC or JDBC. I choose JDBC, and it asks for "Name of the database", "Server URL", "Port number", and "MySQL JDBC driver class". I fill that stuff in and can't connect. |
| 21:57.15 | thebigdog | use jdbc connection |
| 21:57.27 | thebigdog | then add the stuff i gave you above to configure it |
| 21:57.33 | thebigdog | the url and driver |
| 22:02.22 | brasto | thebigdog: I added it the other way and I'm getting the same error. It says "Communications link failure due to underlying exception", then "java.net.SocketException", then "Message: java.net.ConnectException: Connection refused. |
| 22:02.29 | brasto | Then it gives me a stacktrace. |
| 22:02.48 | thebigdog | make sure mysql allows you to connect to it for your box |
| 22:03.00 | brasto | ah... that's it |
| 22:03.11 | brasto | I set the user that I'm using to connect from localhost |
| 22:03.14 | thebigdog | mysql is telling you that you cannot connect |
| 22:07.37 | brasto | ok, the user has rights, but I still can't connect... maybe the port is blocked? |
| 22:07.53 | thebigdog | can you connect commandline |
| 22:08.04 | thebigdog | and make sure you have perms in the database ot connect too |
| 22:08.48 | brasto | I connect command line via ssh... but I haven't tried from this host to that one on cli... |
| 22:09.02 | thebigdog | yeah that might be it |
| 22:09.44 | thebigdog | perms in db for connection |
| 22:13.32 | brasto | mysql -h polaris.lnxi.com |
| 22:13.32 | brasto | ERROR 2003 (HY000): Can't connect to MySQL server on 'polaris.lnxi.com' |
| 22:13.41 | brasto | installed the client and ran that |
| 22:13.48 | brasto | checking system logs on polaris server... |
| 22:14.05 | thebigdog | did you check the database for perms |
| 22:14.30 | thebigdog | in mysql your user needs to have perms to connect from any box or a specific one |
| 22:15.07 | brasto | I gave rights in mysql for any box |
| 22:15.21 | brasto | but I should specify a user since root can only connect from local host |
| 22:15.23 | brasto | one moment |
| 22:16.02 | brasto | same error |
| 22:16.09 | brasto | maybe the host isn't allowing that port |
| 22:18.32 | brasto | where's ubuntu's config file for allowing/disallowing connections by port? |
| 22:20.24 | brasto | brb |
| 23:05.39 | brasto | ~afk |
| 23:05.40 | jbot | hmm... afk is Away From Keyboard |
| 23:05.48 | mgeary | ~aflak |
| 23:05.52 | SunSparc | Night all. |
| 23:06.01 | brasto | ~aflac |
| 23:11.13 | mindjuju | ~chuckfact |
| 23:11.14 | jbot | Chuck Norris uses Tabasco Sauce for eye drops |
| 23:15.33 | brasto | lol |
| 23:23.36 | brasto | anyone know how to see what ports ubuntu allows? |
| 23:23.45 | brasto | or where the config file is? |
| 23:23.58 | synic | huh? |
| 23:24.01 | synic | there is no firewall by default |
| 23:24.11 | synic | the ports that are open correspond to the services you run |
| 23:24.11 | herlo | brasto: nmap 127.0.0.1 |
| 23:24.27 | brasto | I can't connect to an ubuntu server via mysql remotely, or via vnc |
| 23:24.39 | synic | probably need to change the listen address in /etc/mysql/my.cnf |
| 23:24.57 | brasto | herlo - I'd forgotten about /etc/services |
| 23:25.01 | thebigdog | it should be listening on 3306 |
| 23:25.08 | thebigdog | that is the default |
| 23:25.08 | brasto | checking |
| 23:25.33 | thebigdog | nmap will tell you |
| 23:25.40 | thebigdog | if it is listening |
| 23:27.24 | brasto | thebigdog and herlo, nmap's not installed but apt-cache search shows it as available, what's the apt-<install> command? |
| 23:27.54 | herlo | brasto: sudo aptitude install nmap |
| 23:28.08 | thebigdog | i dont use that crap |
| 23:28.26 | brasto | my.cnf has 3306 properly set |
| 23:28.46 | thebigdog | do you have an external ip address? |
| 23:28.48 | brasto | thebigdog doesn't use nmap or apt? |
| 23:28.55 | thebigdog | apt |
| 23:29.00 | brasto | not for this ubuntu server |
| 23:29.02 | thebigdog | i love nmap |
| 23:30.27 | brasto | nmap tells me: 3306/tcp open mysql |
| 23:30.49 | thebigdog | i think it is the perms of the user in the database |
| 23:30.55 | brasto | I'll try by ip instead of hostname... |
| 23:31.17 | brasto | perms for user in database are set to allow all hosts, no password since it's view only |
| 23:31.19 | mindjuju | what? thebigdog is getting a perm ? |
| 23:31.46 | thebigdog | ok watching a japanese music video makes me think they are lip syncing to american underneath |
| 23:31.55 | thebigdog | mindjuju, i already have one |
| 23:31.59 | timinator | Anyone following the Housing Market: http://www.reuters.com/article/politicsNews/idUSWAT00853020071205?feedType=RSS&feedName=politicsNews&rpc=22&sp=true |
| 23:32.15 | thebigdog | brasto, try adding a password |
| 23:35.16 | thebigdog | if timinator where japanese and played guitar - http://www.youtube.com/watch?v=vUoLenaRa9E&feature=related |
| 23:35.52 | thebigdog | i would tell him to just play and sing the stupid song |
| 23:36.04 | timinator | ~flip thebigdog |
| 23:36.05 | jbot | ACTION gives thebigdog the .|.. ..|. |
| 23:36.05 | brasto | thebigdog: ipchains is installed on this ubuntu box |
| 23:36.48 | thebigdog | cool...now you can fix them |
| 23:37.51 | brasto | ~lart ubuntu's lack of normal cli commands |
| 23:37.51 | jbot | eats ubuntu's lack of normal cli commands and falls over dead |
| 23:37.55 | thebigdog | this would be me on the guitar - http://www.youtube.com/watch?v=UVdyHs_IX1I |
| 23:38.30 | timinator | LOL ....love your hair in that one thebigdog |
| 23:38.43 | thebigdog | well yah |
| 23:38.44 | PoeticIntensity | yo..... |
| 23:38.54 | PoeticIntensity | I have kind of a weird request, but since I trust most of ya on here... |
| 23:38.56 | mindjuju | here is me on the guitar - http://www.youtube.com/watch?v=SCplsXu1HRk |
| 23:39.04 | mindjuju | wow, didn't know they got this on youtube! |
| 23:39.12 | PoeticIntensity | I just got a webcam enabled in Linux, and the new Skype seems to work with it. |
| 23:39.32 | PoeticIntensity | Do any of you use the new 2.0 version, and if so, would you mind testing it out with me? |
| 23:39.42 | PoeticIntensity | I just want to verify that the video actually streams.. |
| 23:40.07 | mindjuju | i thought skype was on 3? |
| 23:40.10 | PoeticIntensity | hehe... |
| 23:40.19 | timinator | I love the Godfather |
| 23:40.25 | PoeticIntensity | umm... nope. |
| 23:40.27 | PoeticIntensity | 2.0 is in beta. |
| 23:40.35 | mindjuju | curious, my skype is on 3.2.0.163 |
| 23:40.42 | thebigdog | mindjuju, i dont think so |
| 23:40.56 | PoeticIntensity | ah yes... |
| 23:41.02 | PoeticIntensity | the Linux version is on 2.0. |
| 23:41.09 | mindjuju | oh, gotcha |
| 23:41.21 | mindjuju | k, if you want to breach the OS chasm and call me you can |
| 23:44.24 | thebigdog | now this is more like me - |
| 23:44.25 | brasto | uninstalled iptables and still can't connect to mysql server on remote host... I've tried multiple users who's passwords I have. They all say ERROR 2003 (HY000): Can't connect to MySQL server on '<IP or hostname>' (111) |
| 23:44.41 | thebigdog | http://www.youtube.com/watch?v=wgtZ7oOCmdM&feature=related |
| 23:44.46 | PoeticIntensity | mindjuju, you wanna PM me your nick? |
| 23:45.16 | mindjuju | yeah, cause you'd never guess what it is |
| 23:45.26 | mindjuju | guess, it starts with an m and ends with a u |
| 23:45.30 | PoeticIntensity | hehe.. |
| 23:45.32 | PoeticIntensity | adding you now |
| 23:46.10 | PoeticIntensity | yes |
| 23:47.33 | *** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 23:47.58 | bradym | brasto: are you working with iptables on the local machine or the remote host? both need to be setup properly, in addition to mysql allowing remote connections |
| 23:48.29 | bradym | make sure my.cnf doesn't have the "skip-networking" option specified.. |
| 23:48.52 | brasto | bradym: iptables was on remote machine. I uninstalled it |
| 23:49.06 | brasto | there's no need for it anyway since it's only accessible inside the network here. |
| 23:49.17 | bradym | and your local machine/network allows outbound connections on port 3306? |
| 23:49.27 | brasto | ah, I'll check |
| 23:49.51 | thebigdog | man mindjuju they got me rocking - http://www.youtube.com/watch?v=BFSzXnTtObY&feature=related |
| 23:51.20 | cycokilr | http://www.gophp5.org/ |
| 23:51.30 | cycokilr | haha.. that's good.. |
| 23:51.40 | Jacob_Kerr | is it possible for php5 to conflict with any php4 scripts? |
| 23:51.47 | synic | welcome to a year ago, cycokilr |
| 23:51.56 | cycokilr | shut it.. i just noticed it.. |
| 23:52.38 | thebigdog | hehe |
| 23:53.20 | thebigdog | www.gophp6.org |
| 23:53.27 | timinator | so, are sqlite databases setup as individual .db files? |
| 23:53.50 | cycokilr | did you buy that one for later? |
| 23:54.00 | bradym | timinator: individual files, you can use whatever file extension you want |
| 23:54.22 | Jacob_Kerr | the ones I am dealing with has no extension |
| 23:54.22 | timinator | that's cool |
| 23:55.24 | thebigdog | cycokilr, nope...i figure they are working on it now |
| 23:55.31 | brasto | ok, I think I've confirmed its on the server level and not the mysql level. when I try to connect to my public server I get a different message saying that my host is not allowed to connect. |
| 23:55.44 | brasto | that's coming from the mysql server |
| 23:57.35 | brasto | stopped firewall on local machine anyway for testing |
| 23:59.27 | mindjuju | thebigdog - that's a good video of you shredding on the guitar, but ya'll need more cowbell |
| 23:59.57 | thebigdog | we sure do |
