Film at 11.

Just a JE saying I'm still around. I lurk mostly these days. I seem to have used up my insightfulness and funniness and useful tidbits.

I just wish TL would start dating underage girls again so I had something decent to read here.

Car wrecks and job changes? Booooooriiiing. You still have the hot tub, right? Take it with you to Cincy. ;-)

Actually, I have a woman coming to visit for a week or so, but we've known each other for years and from experience I'm not expecting anything exciting to happen. At least she's not trying to make me pay for meals anymore.

Okay, here's what I want to do: when FTP-installing a linux distro (Suse, Debian or Slackware usually) or Cygwin, I want to download only the files I use but have them available locally for reinstallation or setting up another PC. I have multiple PCs available. Here's a sketch:

[Public linux/Cygwin Mirror]
        |
[My proxy/mirror/FTP server]
        |
  [PC getting linux/Cygwin]

From the installing PC I'll specify My proxy/mirror server as the FTP source. The proxy/mirror will mirror the directory listings of the public mirror and download requested files keeping a local copy. Of course if an up-to-date local copy exists it will simply serve it to the installing PC.

The effect will be that I'll have a partial local mirror of the install files, but these are the very files I'm very likely to use again soon. So if I install from another local PC it will be uber-fast. Also my local partial mirror should be easier to fit on a CDROM or two for carrying to/from work.

I expect there's software out there that already does this, but I haven't found it yet.

Does anyone know of a free software package that does this?

I wrote this in response to this post and decided to move the bulk of it here to not be quite so obnoxiously off topic.

Oh, what the heck, might as well quote the parent here:
-----

(This from a guy who is migrating his address book to OpenLDAP because he doesn't want to sync between two PCs.)

Hey, how's that working out for you? I've been thinking of doing exactly that for a couple years now, but people have told me OpenLDAP is kind of a pain to set up for such a simple task and I really know nothing about it. Mac OS X's Address Book LDAP preferences include options like "Search Base" (for example, ou=people, o=company) and "Scope" (base, one level, or subtree); is this more complicated than I want to mess with?

-----

Reading through OpenLDAP manuals can make it sound confusing, but Debian actually did most of the setup via Q & A. I'm not sure if Fink will make it as easy or not. Probably will, though.

The point of confusion is that LDAP can be used for so doggone many things. If you're using it for an address book just think of it as a hash-style database (which it really is on the backend) organized in a tree.

The traditional layout of the tree has the root level of your LDAP server as "o=company" or "o=company,c=country". (o is organization, c is country, ou is orgazational unit, dc is domain component, cn is common name, dn is distinguished name; dn's are the unique keys.) The vogue now is apparently to follow your domain name structure and have your root as "dc=slashdot,dc=org" for example. (I think in theory all LDAPs everywhere should be mergeable and have unique bases, but I'm not sure.) It's common to put the contact info under ou=people, so your LDAP settings in the client will look like "ou=people,dc=slashdot,dc=org" maybe or the old style "ou=people,ou=slashdot,o=osdn,c=us".

If you export your local address book to LDIF and look at it in a text editor you'll see all sorts of cn's, dn's, objectclasses and such. Look them up for fun, but basically each entry needs a dn which can be the cn followed by the ou's and base or it can be uid (user id) or probably many other things depending on what you want to key on. dn's need to be unique.

Here's where I'm hung up because I've been to lazy to fix it: My exported addresses from Mozilla have dn's like "dn: cn=Name,mail=email@domain.tld", and I have to change all those dn's to fit into my LDAP base like "dn: uid=(uniquenumber), ou=people, dc=mysubdomain, dc=gotdns, dc=com". (Like I said you can key on things other than uid if you want. Also I'm not required to put them in ou=people, but what the hey, why not.) I didn't see a utility anywhere that would fix that for me automatically, so I'll have to either hand-edit or script the changes before I can use slapadd to bulk load them into my directory.

I did hand-load a couple of address entries and it works great!

Oh, and scope is the type of query. Set your search base to match your LDAP setup and either base or subtree would work fine I think. If you get really curious there are a couple of RFC's on LDAP queries that are neat reads. Then if you get really crazy like I might then you might integrate Kerberos and get your MS boxen to authenticate to your Unix box ;-).

P.S. Phroggy, I just noticed your user number and web page. Heck, you ought to do it just for the tinkering fun. I'll add a couple of technical things: the backend db can be Berkeley DB or ldbm or a couple of other things; they are library/file-based db's. slapd is the server daemon; slapadd will load the db while slapd is offline, or you can use ldapadd or other ldap clients to update while it's online. But the Debian package installed the db libraries and configured slapd.conf for me based on curses-based config screens. It was amusingly simple after I spent all that time reading up on OpenLDAP. But as usual the "simple thing" threw me: export to LDIF, import to LDAP, right? Uh-oh, gotta edit the dn's first.

Link.

Just a link for me to come back to later and possibly play with the RAQ software or alternatives. I like SSH administration so far, but if any of these tools help users maintain web pages then I have a couple of ideas....

Update: I started this project but still can't strip the ID3 tags temporarily. I'll put the details and code snippets in a post.

Update 2: I more or less gave up on stripping the MD5 tags for now since it will take too much work. However, all ID3v1 tags are at the end of the file. ID3v2 tags can be and usually are at the beginning of the file, but ID3v2 tags are far less used in my collection, so I used the following command to get the MD5 sum of the first 500KiB of the file. It will miss identical songs that have had ID3v2 tags at the beggining of the file added or altered, but I was able to delete another 1.2 gigs of duplicate mp3s with this test:

head -c 512k <mp3 file> | md5sum -b

md5sum in this command returns a filename of "-", but I used some shell trickery to figure out which sum went with which file.

***************

Foreward: Really my only question here is "how do I calculate the MD5 sum of MP3 song data only--that is, not including ID3v1 or ID3v2 tags?" The rest is just chatting about what I'm doing.

I'm a network admin who thinks he knows enough about programming to pull this off. (I had several programming courses in college and occaionally play around with one language or another but never had a developer job or a serious project.)

I have disorganized, reorganized and relabled MP3 files. I want to find duplicates. Here's my idea to accomplish this:

I'm going to copy information from each MP3 into a database, either directly or through an intermediate delimited text file. The major info will be the path & file name, MD5 sum of the file, and the MD5 sum of the data only (minus the metadata/ID3 tags). I'll probably also try to get the MD5 sum of the first X seconds or X Kbytes of song data to detect duplicate beginings (in case of a truncated duplicate). Secondary info will include all the other stuff like file size, song length and ID3 tag data; this info will just be for me to locate duplicates that aren't byte-exact and to help me decide which of the duplicates to delete.

I could probably do this with a shell script and a couple of utility programs, but it may be simpler to grab a couple of modules from CPAN and use Perl. I don't anticipate having trouble with the metadata or MD5 sums of the entire file, but I don't yet see an easy way to calculate the MD5 sum of only the song portion of the MP3. I'm browsing through CPAN, and there are tons of modules which read and edit ID3 tags but nothing quite like what I have in mind. I did find one that strips the ID3 tags, but it seems to alter the file directly, and I only want to have the tags stripped just long enough to get the MD5 sum.

Sure I could read the data structure of the MP3 file and parse it myself, but I intuit that somebody made a perl module or command line utility that can nondestructively present me the tag-stripped MP3 so I can MD5 it and leave the original file unchanged. Anybody know of such a module or utility?

My app won't be pretty or user friendly. It will probably take a path as input and output either a delimited file or update a mysql or pgsql database directly. Then I will query the database to find what I need. I'm not only finding duplicates; I'll also be looking for files that are unique per storage device, because I have most of my MP3s on my main PC and my MP3 player (w/20G HDD), but there are some MP3s on one device but not on the other and vice versa, not to mention some on my linux box and some on my work PC. I can import from all sources into different tables and play with queries and eventually consolidate and catalog my mp3 collection.

I know there are some various apps that try to do some of these things, but I like working at the command line and having my hands on the raw data; every time I try to deal with an MP3 manager application I hate it.

EDIT: Yeah, I could just delete all my MP3's and re-rip them, but what fun would that be? Mucking about with Perl and SQL sounds so much more fun.

Found it! Rekall. Slashdot article here, sites here and here. Also I now remember I wanted to try out OOo as a db client, too.

*******************
Sometime recently, Slashdot ran an article about a generic database front end that went from proprietary to open source. Kinda like Access but without a database engine--just the user interface. I meant to come back to it later and try it out, but I can't find the article or remember the name of the product! I've searched Slashdot, Freshmeat, Google, Google Groups and Google Directory with all sorts of combinations of keywords like database, front end, mysql, postgresql, report, designer, query but had no luck in finding the article or the software.

I think there was an R in the name of the software.

Does anybody remember that software or article? I think it was in the past couple of weeks.

Thanks!

P.S. To avoid smartass responses like the one I would leave ("Yes, I remember it" with no more info), I also request that you name the software and/or link to the article and/or the software site. :-) Thanks!

Hi. I'm still here. Nobody's pregnant, engaged or dating underage girls. Nothing interesting going on. Well, work is totally shaken up, but I don't feel like whining about that anymore.

Oh, since my last JE was about T I'll update: I called her a couple of days after the last JE and the conversation went downhill so far that I never called her back.

As I said in last entry I called and left a message Weds 9-10. I didn't get a call back that night, so I wrote her off. I had family visiting for the weekend so I didn't go out.

Sunday morning some girl called and left a message, but it was hard to make out and she sounded timid. I thought it was T but wasn't sure. I still had family in town and didn't feel like calling her back.

I kept putting off calling, and I figured if I hadn't called her by now that I'm probably not as interested as I thought, and then Tuesday--almost 2 weeks after my first call and over a week since the possible return message--I figured what the hell, I'll just call and see where it goes. (That was her that left the message Sunday.)

We met again Thursday night at the blues bar; she brought her friend C along again. Actually C drove her. We hung out, danced and had fun. C wanted to leave early and T didn't seem ready to go. I thought I was being a bit too bold when I offered to drive T home, but she jumped on the suggestion immediately and told C "bye".

We were talking and having a good time, and when we got back to my car I asked if she wanted to hang out anywhere before going home. T seemed noncommital, and I couldn't think of anyplace decent to hang out so I suggested (too boldy, I thought) my place. She was fine with that.

We went back to my place, had a snack, hung out, listened to music and cuddled a lot. (She started it.) She stayed all night, and we got a bit friendly but probably not as friendly as you might imagine. Sorry, no details, but T does seem a little conflicted. Then again I'm starting to think she thinks I might be a player (LOL; the thought cracks me up), so maybe she's being cautious. This was only our second meeting, after all.

I planned on calling T Monday night and seeing about scheduling something Wednesday night because I have family visiting this weekend. But I worked late and got home too late to call.

Tuesday at work I was given the advice to not call her that soon, but to wait a few days. I had met T Saturday, and the advice--from a woman--was to wait to call until Wednesday or Thursday.

Between the advice, some dental work and my family not calling to confirm plans I decided not to call T Tuesday night. (I wasn't sure I'd be able to eat a nice dinner by Weds night; turns out it would've been okay.)

Tonight, Wednesday night, I called but got voicemail, and I left a message and my number.

Anyway, the "when to call" advice got me wondering. I'm not particularly worried about it, but I figure the next day is probably too soon, and two weeks is way too long. What do you think?

After meeting a girl in a bar and getting her phone number, call her back:

A. 30 minutes after parting for a booty call.
B. The next morning.
C. The next day.
D. 2-3 days
E. 4-5 days
F. 6-8 days
G. 9-14 days
G-and-a-half. 4 to 6 weeks
G-and-three-quarters. When really drunk, desperate and lonely.
H. Sucka! Gonna show this # to friends and post it on the trophy wall!
I. Next morning, push her out of bed and tell her to make breakfast.
J. Doesn't matter, 'cause it's a fake number, anyway.

As seen in my most recent JE I had no luck last night in meeting women or even striking up a conversation. When leaving the parking garage, though, I passed a Blues Bar that boasted live entertainment. I recognized the name as someone had mentioned it to me before. I made a note to come back to it sometime.

Tonight (Saturday night) I almost didn't go out. I was discouraged by Friday night's utter lack of interest and the money I spent failing so. I even played some Quake II for a couple of hours, and the sun went down. But I decided I really should go out, but this time I would do something that I enjoy more than just trying to meet women. So I looked up the blues bar's schedule and saw that their bands started at 9:30 tonight. Cool! I like late starts.

So I played the computer, ate and showered. I decided just to wear a t-shirt, old jeans and tennis shoes tonight because I wasn't really trying. As I got in the car I noticed the shirt had a faint smell of mildew; oh well, I wasn't planning on getting close to anyone, and maybe the smoke at the bar would mask the smell. I arrived at the bar right as the band started. Oops, no seating room. So I stood, but the band was great.

I was standing where everyone had to walk by to enter or leave the stage room, so I got to watch a lot of nice women go by. Nobody seemed interested, though, but I was there for the music tonight.

At the start of the second set two black ladies stood near me to watch. They were having fun and we talked a bit. As the band played on we danced in place a bit and talked some more. I bought them a round of beers. At first I thought the one with the cuter face (we'll call her C, TechnoLust-style) might be interested because she was closer to me and started brushing against my arm while dancing. It quickly came out that she was married, but unhappily and seemed to be acting single. That turned me off, because I don't want to mess with a married woman; if you don't want to be married, get divorced but don't stay married and play around.

The other girl--the one with the nicer body, who we'll call T--then seemed much more interested in me. She told me I was cute. She and I started talking and she talked a lot. Through the night it became more apparent that she liked me. I was a bit apprehensive because I haven't been out with a black woman before, and her face--although not ugly--wasn't particularly attractive to me, but she had a good personality and a nice body and very smooth skin.

Maybe they were both into me, because at the end of the night T got more physical with me and then C suddenly wanted to leave. T gave me her cell phone number, and we have tentative plans to go to a jazz restaurant.

=====

While I was hanging with T and C and we were going outside for a smoke/cool-down break (T and I don't smoke, but it was hot inside) a very pretty woman--better face than C, better body than T, my skin color, and a funny personality--made an amusing quip about the way I looked at a statue as I passed. I don't know if she was showing interest or just having fun, but I don't think I could've started a conversation with her without pissing off T and C. It was tempting to try, anyway. D'oh! I just realized I should've tried to find her after T and C left. At the time I was tired and decided to go home myself, and my mind was racing with analyzing the evening and debating on wheter I really want to take T out or not. (I think I will.)

I am almost the stereotypical Slashdot dude. I'm very overweight, spend too much time on computers and haven't (before last weekend) dated much or got laid in years. I don't live with mom, though, and in fact I live alone and am financially independent. Sorry.

Last weekend on a spur-of-the moment roadtrip mini-vacation I got laid for the first time in...well, a long time (at least two years). That helped clear out a lot of the anxiety I had built up about women, increased my confidence/self-image and greatly increased my desire to start dating again. The girl I was with lives about 6 hours away, and it was more of a one-night thing than a long-distance relationship type thing.

So I went bar hopping. I've never done this before, even when I was actively dating. I went to a TGI Fridays at 4pm on Friday and stayed until 6pm. This particular place had been recommended to me by a couple of guys at work, but only couples and much older (late 40's to 60's, and I'm 33) people came in. After eating an appetizer sampler I played the NTN trivia game with some of the other guys until 6, then decided it wasn't going to get better and headed downtown.

I walked around downtown a bit before going into a huge bar with two restaurants, 4 bar areas, a video game area, a dance club and cosmic bowling (bowling plus black lights, music and projection TVs showing crazy stuff). Nothing happening in the restaurant/bar area, so I went through the video game area. It was early enough that kids were still allowed, so lots of families here. Nothing happening in the bowling area, and the dance club was in the middle of a private party, so I went back and played some video games.

As it got later, all the kids disappeared (I think they kick all the kids out after 9pm) and more adults showed up. Most of the women had dates, and I wasn't getting any eye contact or any other signals. The only group of women that didn't have guys around looked gay and didn't look at me once, even for a second. Plus they were french kissing each other.

I went back to the bowling area; nothing still. Went to the dance club, but nobody was dancing, and there were 2 girls and about 100 guys. (The private party had ended.)

Back to the video game area. I got some eye contact on the way in from one of three girls who just came in. Cool. I walk scout the area a little more to give them time to settle in. The go to the bar and order drinks. I go to the bar and order a drink, but they're not looking my way now. One is a really gorgeous blond, but the other two are nice, too, and one of them had looked at me. I don't think I've had enough signals to approach with success, so I'm watching, waiting an looking around, but three guys come up and join the girls, and the girls are obviously very into them; so much that I think they might've arranged to meet there.

It's getting late and I'm tired, so I leave and head home, stopping at the Wal-Mart to get some stuff for the apartment I've been meaning to get.

Well, I suppose it's a halfway decent first step to becoming more social even though the only conversations I struck up were with the bartenders, the NTN trivia players and a (male) coworker I ran into at Wal-Mart.

(No, the lesbians weren't really french kissing each other. Everything else is true.)

I'm submitting this story shortly. If it's posted you can leave me feedback here. If not, you can discuss it here.
=====
Much speculation is found on Usenet and Slashdot about why the SCO and Caldera web sites have been down Saturday and Sunday, but Eric S. Raymond says they are being hit by a "massive denial-of-service attack" and asks the attackers to "Please stand down *now*."

He's making a list, checking it twice, gonna find out who's naughty or nice. But have the exams ever been this thorough?

...or...

OH!! OH!!! OHHHHHHHH Christmas tree!!!!

Ah hell. I had it all figured out. I've been adding more friends lately because it's easier than browsing through friends-of-friends. So I started moving my 4 'tech interest' friends to my foe list--not to be real foes, but to bookmark them separately from 'social interest' friends. Then I realized my little stunt does actually affect others. I have fans now (hi fans!), so whoever I add to my foe list will show up as foe-of-a-friend when my fans are reading their posts. So I felt guilty and put my not-foes back as friends. So much for my clever ideas. And I'll probably recklessly start adding friends now. I guess I'm officially out of control. :-)