Linux-Misc Digest #813, Volume #27 Tue, 8 May 01 20:13:01 EDT
Contents:
Re: database ("Heikki Tuuri")
Re: Netfilter, IPtables... what the heck is going on? (Mark Schlegel)
Re: Do I need /usr/local, /opt, /tmp and /var partitions? ([EMAIL PROTECTED])
NYC LOCAL: GNUbies meet Wednesday 9 May 2001: Sulzberger on learning to program a
Free Operating System ([EMAIL PROTECTED])
Re: How come... (John Thompson)
Re: landscape printing ("Steve Wolfe")
Re: Running from a RAM Disk ("Steve Wolfe")
Re: that PCMCIA question (Linksys PCMPC100 V2/Dell Inspiron 4000) (Yuri Fialko)
Re: Netfilter, IPtables... what the heck is going on? (TGOS)
Getting Sony DSC-P1 USB Camera to work (Heinz Ruffieux)
Re: linuxconf 7.1 (Pete Barnwell)
----------------------------------------------------------------------------
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
Subject: Re: database
Date: Tue, 08 May 2001 22:11:19 GMT
Hi!
Actually, the InnoDB backend which provides transactions and row level
locking in MySQL
is faster in typical tests than the non-transactional default table type of
MySQL. InnoDB is
also over 10 times faster than PostgreSQL in simple join queries.
See www.innobase.fi for details.
Regards,
Heikki Tuuri
Innobase Oy
[EMAIL PROTECTED] wrote in message ...
>Stefano Ghirlanda <[EMAIL PROTECTED]> writes:
>> Ying Hu <[EMAIL PROTECTED]> writes:
>>> I need one database for our bioinformatics server on linux. Which
>>> free one is the best?
>
>> Warning: I have very limited db experience.
>> Fastest: mysql.
>> More features: postgresql.
>
>> On www.mysql.org they have some comparison among databases if I
>> rememeber well...
>
>You can expect that www.mysql.org would have some degree of bias; at
>minimum, that should be augmented by some equal-but-opposite bias:
><http://openacs.org/why-not-mysql.html>
>
>There is now a way of making MySQL provide transactions, although this
>requires using a different backend which is slower, likely eliminating
>would-be performance advantages.
>
>And the performance differences are controversial, in any case: they
>seem only to apply to the very simplest of queries, and if you're
>building web apps atop this, it's likely to be the Internet link that
>will be the performance bottleneck, irrespective of which database is
>being used.
>--
>(reverse (concatenate 'string "gro.gultn@" "enworbbc"))
>http://vip.hyperusa.com/~cbbrowne/resume.html
>"For be a man's intellectual superiority what it will, it can never
>assume the practical, available supremacy over other men, without the
>aid of some sort of external arts and entrenchments, always, in
>themselves, more or less paltry and base. This it is, that forever
>keeps God's true princes of the Empire from the world's hustings; and
>leaves the highest honors that this air can give, to those men who
>become famous more through their infinite inferiority to the choice
>hidden handful of the Divine Inert, than through their undoubted
>superiority over the dead level of the mass." --Moby Dick, Ch 33
------------------------------
From: Mark Schlegel <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.networking,comp.os.linux.setup
Subject: Re: Netfilter, IPtables... what the heck is going on?
Date: Tue, 8 May 2001 18:08:58 -0400
How about looking here for info
http://www.linuxdoc.org/HOWTO/Adv-Routing-HOWTO-10.htm
also in there is the url:
http://netfilter.filewatcher.org/
I would stay looking at linuxdoc.org is the first place to
start.
Mark
On Tue, 8 May 2001, grooveman wrote:
>Hi.
>
>I have been struggling with this for several days now.
>
>I installed RH 7.1 to act as my gateway/router using IP masq for my
>internal machines.
>
>Low and behold, what do I find -- RH 7.1 kernel 2.4.x does not like to
>support ipchains! Now, I know, I know... It has legacy support for
>this, however, I could not get ip_always_defrag and ip_masq_ftp going on
>it. I have tried the stock kernel, and even recompiled my own -- and I
>configured just about every networking option as a module, and these did
>not show up anywhere on my system.
>
>Ipchains is not much use to me if I can't use ftp! I looked around on
>the web and lurked in groups and found people with the same problem --
>but no real solutions were offered.
>
>So I made it my mission to learn iptables --which IS natively supported
>by 2.4.x. After going nuts looking for ipnatctl (which is referenced in
>the iptables-howto), I finally found out that it has been incorporated
>into iptables (only lost a day or two there!) So, how do I masq with
>iptables? I looked around some more and found that the homesite of
>NETFILTER doesn't appear to be functioning (at least in the last few
>days) http://netfilter.kernelnotes.org .
>
>So -- My question is this: How the heck are we supposed to know what to
>do with iptables? The man page is almost useless here... it is simply
>too complex to contain in one man.
>
>Also: Can anyone tell me how to get my machine to masq without having a
>forward policy of ACCEPT?
>
>Also: What is the equivalent in IPTABLES of ipchains with a -y flag?
>
>IS THERE ANYWHERE A PERSON CAN GO TO ON THE WEB, OR IN THE BOOKSTORE TO
>LEARN HOW TO USE THIS TOOL?
>
>I know that I cannot be the only one frustrated with this.
>
>Thank you all! (I feel a litte better now :0) )
>
>Chris
------------------------------
From: [EMAIL PROTECTED]
Subject: Re: Do I need /usr/local, /opt, /tmp and /var partitions?
Date: Tue, 08 May 2001 15:33:10 -0700
On Mon, 7 May 2001 18:17:40 -0400, wroot <[EMAIL PROTECTED]> spilled
beer on the keyboard and the resulting short-circuit sent this:
>Hi,
>
>
>Does it really make sense to create /usr/local or /opt or /tmp or /var?
>If I run Debian Potato or Redhat6.2 and install
>KDE2 or other software that is ahead of its distribution in /opt or
>/usr/local (separate partition) instead of installing it with all other
>software, will I be
>a) more happy
>b) less happy
It's a dilemma. Of course, it depends on whether you're a newbie or an
experiened user. Why? Because a newbie has no idea how big these
partitions need to be and so either runs out of disk space on one or
another partition due to this (understandable) bad planning or wastes
a lot of space with partitions that are way too big. If you're an
experienced user, you'll look at your current installation and see how
much data is in each, and partition accordingly. So my advice is like
Vanderbilt's response to someone who asked him how much his yacht
cost. He said, "If you have to ask, you can't afford it." In this
case, if you have to ask, use the fewest partitions the install
program allows until you get to know Linux better. You'll know when
you know enough to decide partitioning for yourself: you'll understand
it.
>I'm asking this because it's not trivial to me how Debian, for example,
>will update Pototo if I have KDE2 on it.
AFAIK, Not Debian nor any other distro cares whether the directories
are on a separate partition or not. Or am I missing something in your
question?
------------------------------
From: [EMAIL PROTECTED]
Crossposted-To: comp.os.linux.advocacy,comp.unix.bsd.freebsd.misc
Subject: NYC LOCAL: GNUbies meet Wednesday 9 May 2001: Sulzberger on learning to
program a Free Operating System
Date: 8 May 2001 18:53:47 -0400
This meeting is free and open to the public.
The meeting runs from 6:30 pm to 9:00 pm.
Thanks to support of CALC/Canterbury, the meeting is in their space at
780 Third Avenue between 48th and 49th Streets on the East Side of
Manhattan. Ask at the front desk for CALC/Canterbury, which is on
Concourse Level 1.
Times:
6:30 pm General Q&A
7:00 pm Jay Sulzberger will commence ranting
Subway stops:
IND E and F, the Lexington Avenue stop
IRT 6, the 51st Street stop
If you plan to attend, please visit the Beginners web page at
http://www.gnubies.org
and follow the attendance link so that we can arrange for the appropriate
amount of space.
If you run any well developed free system, such as one of the many free
GNU/Linux systems, or any of the free BSDs, or Squeak, and are willing to
spend some hours and quite a bit of effort, you can learn how to program, I
mean really program, your system to do useful things which no source secret
OS can do out of the box. Some of these useful things depend upon the
software being free, and no source secret competitor will ever be as good.
We will present an approach to programming, and we will attempt to build a
small useful application.
http://www.fsf.org
http://www.debian.org
http://www.freebsd.org
http://www.netbsd.org
http://www.openbsd.org
http://www.squeak.org
http://rsync.samba.org
http://www.gnupg.org
http://www.procmail.org
http://freshmeat.net
http://mitpress.mit.edu/sicp/full-text/book/book.html
http://sicp.ai.mit.edu/Spring-2001
http://www.linuxdoc.org/HOWTO/Bash-Prog-Intro-HOWTO.html
http://www.lisp.org
http://www.schemers.org
http://www.python.org
http://www.mozart-oz.org
http://caml.inria.fr
http://www.perl.org
info tar
man mail
The ancient tradition of heckling is held in high regard by the New York
Tribes of the Free Software Nation, and so I ask that those who wish to
play the game come prepared.
Jay Sulzberger <[EMAIL PROTECTED]>
Corresponding Secretary LXNY
LXNY is New York's Free Computing Organization.
http://www.lxny.org
------------------------------
From: John Thompson <[EMAIL PROTECTED]>
Subject: Re: How come...
Date: Tue, 08 May 2001 16:30:17 -0500
kalasend at YAHOO dot COM wrote:
> How come until today, Linux (or in general Unix) still does not have the
> "undelete" feature?
That's what backups are for. In a multi-user system any
filesystem-level undelete function becomes even less reliable.
--
-John ([EMAIL PROTECTED])
------------------------------
From: "Steve Wolfe" <[EMAIL PROTECTED]>
Subject: Re: landscape printing
Date: Tue, 8 May 2001 16:56:33 -0600
> In HP/UX, I can print a text document landscape with the following
command:
>
> lp -olandscape -dprintername filetoprint
>
> Is there an equivalent command in the Linux lpr world?
Since I generally use landscape in conjunction with other fancy
options, I use mpage to format my output.
steve
------------------------------
From: "Steve Wolfe" <[EMAIL PROTECTED]>
Subject: Re: Running from a RAM Disk
Date: Tue, 8 May 2001 16:59:49 -0600
> However, 64MB for my entire system is a little tight.
A little tight? Goodness, you can put the enire LRP (Linux Router
Project) on a single floppy disk!
> Or does this make sense? The reason I am holding on to RAM disks is that
> RAM is cheaper. For ca. $150 I can get 384MB RAM or 64MB Compact Flash.
Now that I've thought it over, my offiical suggestion is: Just use a
disk. Yes, disks can eventually go bad - but for goodness sake, you're
using DSL. The disk is the least of your worries.
steve
------------------------------
From: Yuri Fialko <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.portable,comp.os.linux.networking,comp.os.linux.hardware
Subject: Re: that PCMCIA question (Linksys PCMPC100 V2/Dell Inspiron 4000)
Date: Tue, 08 May 2001 16:24:11 -0700
Thanks to everybody who responded to my inquiry. The status quo is as follows:
1) According to David Hinds, my problems with the PCM card are actually due to a
bug in the
2.4 kernel. Apparently, this bug was not present in the 2.2 kernel (which might
explain why
the card is working under RH7.0, but not 7.1).
2) I was about to "downgrade" to 2.2, when Jerry McBride indicated that he could
get the card
to work with the 2.4.4 kernel (my RH7.1 has 2.4.2). Does this mean that the bug has
been fixed
in 2.4.4 (David Hinds said that Linux is still working on this problem)?
Incidentally, a response from the Red Hat technical support was:
Thank you for writing Red Hat Installation support.
Undortunately, due to the proprietary nature of laptops we cannot fully support
your case. Waht we can do for you is point you to a link where you can get some
helpful information.
Yuri
Jerry McBride wrote:
> Dean Thompson wrote:
> >
> > Hi Yuri,
> >
> > > I would very much appreciate any advice on how to get my new PCM card to
> > > work. I've installed Redhat 7.1 on Dell Inspiron 4000 laptop; my PCM card
> > > is Linksys Etherfast 10/100 (PCMPC100 V2). Some details on the
> >
> > At this stage it doesn't look like the Card Services are capable of providing
> > support for the PCMPC100 Version 2 cards.
>
> Is the above version number a typo? The reason I ask is that I am using
> a pcmpc100 version 2.0 on my laptop without any problems what-so-ever.
> In fact I grabbed a copy of the pcmcia-cs versionn 3.1.23 and compiled
> it to run with the 2.4.4 kernel... No problem there either. What's
> really nice about this card... it'll do 100baseT in duplex mode with a
> similarily capable hub/swithc box... In other words... quite fast.
>
> Running a base install of Caldera Open Linux 2.40 and the card was
> auto-detected during the install... since that time, I've heavily
> upgraded my laptop without a bit of problems from the PCMPC100...
>
> > A quick check of:
> > http://pcmcia-cs.sourceforge.net/ftp/SUPPORTED.CARDS shows that the basic card
> > is supported and that version 3 is not supported. It doesn't talk about
> > version 2, but a number of postings that google found seemed to confirm the
> > basis that the PCMPC100 V2 card isn't being supported at the moment.
> >
>
> It's hard to believe this is true... Maybe people should begin spreading
> the word... LINKSYS PCMPC100 version 2.0 PCMCIA NIC's work like a charm
> under linux...
>
> --
>
> *******************************************************************************
> * Registered Linux User Number
> 185956 *
> *******************************************************************************
------------------------------
From: TGOS <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.networking,alt.linux,alt.os.linux,comp.os.linux.setup
Subject: Re: Netfilter, IPtables... what the heck is going on?
Date: 8 May 2001 18:27:04 -0500
[Posted and mailed, since I had to remove a few NGs from the header; my server
doesn't carry them]
On Tue, 08 May 2001 21:21:33 GMT, grooveman <[EMAIL PROTECTED]> wrote:
> Low and behold, what do I find -- RH 7.1 kernel 2.4.x does not like to
> support ipchains!
It does not?
Well, I have SuSE 7.1 installed, that uses a 2.4.0 Kernel and it supports
ipchains without problems, after you installed the module for it.
One simple "modprobe ipchains" and the problem was gone.
I think we are both in a similar situation:
One PC with Internet connection should work as Router (with MASQ, because we
only have one public IP address), to give a whole private network of PCs
Internet access as well...right?
Right now I'm building a LFS system on my router and the post you are reading
right now was sent to you through this router, currently working with ipchains.
(to be more precisely: I'm typing this while GCC compiles GLIBC, operated
through SSH access from my workstation...geeez, that takes forever, even on a
550 MHz machine with 128 MB RAM)
> Ipchains is not much use to me if I can't use ftp!
I can and I don't have any FTP module installed.
I downloaded plenty of source code of FTP servers today, using WGET.
On my Windows machine I had to enable PASV for all FTP clients to work, but
after I've done that, everything was working fine, without ip_masq_ftp
installed (I guess WGET uses PASV as standard setting).
> So I made it my mission to learn iptables
That will be my next problem. Once my new LFS system is running, I will have to
write some really good forwarding filters, after all the system should be
secure as well.
(right now everything is widely open, I guess a good hacker would have root
access within 15 minutes ^_^ But I had no choice, I needed Internet access to
get those source packages).
> So -- My question is this: How the heck are we supposed to know what to
> do with iptables?
Good question.
I was browsing the WEB for about one hour today, finding nearly nothing of
interest, except one page.
I don't know if this one is helpful (I had no time to read it so far), but it
looked good, so I bookmarked it.
It may not exactly meet your expectations (personally I believe your Linux
knowledge is far beyond my horizon), but maybe it is at least a bit helpful:
http://www.boingworld.com/workshops/linux/iptables-tutorial/
> I know that I cannot be the only one frustrated with this.
Probably not...but right now I would be already happy if I could compile
FileUtils 4.0, but GCC just refuses to compile it, because
"macro 'strndup' used without args"!??
Oh, I see GLIBC is ready...finally.
Time to go on.
Good luck for your quest.
--
TGOS
------------------------------
From: Heinz Ruffieux <[EMAIL PROTECTED]>
Subject: Getting Sony DSC-P1 USB Camera to work
Date: Tue, 08 May 2001 23:30:08 -0000
Hi,
I recently purchased a Sony DSC-P1 cammera with USB connection and would
like to get it to work with my RH7.1 (out-of-the-box) Linux box.
According to many pages I read this configuration should work right away.
But not in my case. Maybe my CD writer is the problem???
Is there anybody who could give my a hint?
Thanks a lot
Heinz
lsmod gives the following output:
[root@locarno usb]# lsmod
Module Size Used by
sg 26688 0 (unused)
usb-storage 31792 0 (unused)
sr_mod 15264 0 (autoclean)
sd_mod 11728 0 (autoclean) (unused)
r128 156944 1
agpgart 23392 3
autofs 11264 1 (autoclean)
via-rhine 10912 1 (autoclean)
ipchains 38976 0 (unused)
ide-scsi 8352 0
scsi_mod 95104 4 [sg usb-storage sr_mod sd_mod ide-scsi]
ide-cd 26848 0
cdrom 27232 0 [sr_mod ide-cd]
usb-uhci 20720 0 (unused)
usbcore 49664 1 [usb-storage usb-uhci]
insmod usb-storage.o results in the following outpunt in /var/log/messages:
May 9 00:03:29 locarno kernel: Initializing USB Mass Storage driver...
May 9 00:03:29 locarno kernel: usb.c: registered new driver usb-storage
May 9 00:03:29 locarno kernel: USB Mass Storage support registered.
cat /proc/scsi/scsi:
[root@locarno usb]# cat /proc/scsi/scsi
Attached devices:
Host: scsi0 Channel: 00 Id: 00 Lun: 00
Vendor: MITSUMI Model: CR-48X5TE Rev: 1.8A
Type: CD-ROM ANSI SCSI revision: 02
[root@locarno usb]#
[root@locarno usb]# cat /proc/bus/usb/devices
T: Bus=02 Lev=00 Prnt=00 Port=00 Cnt=00 Dev#= 2 Spd=12 MxCh= 2
B: Alloc= 0/900 us ( 0%), #Int= 0, #Iso= 0
D: Ver= 1.00 Cls=09(hub ) Sub=00 Prot=00 MxPS= 8 #Cfgs= 1
P: Vendor=0000 ProdID=0000 Rev= 0.00
S: Product=USB UHCI Root Hub
S: SerialNumber=d800
C:* #Ifs= 1 Cfg#= 1 Atr=40 MxPwr= 0mA
I: If#= 0 Alt= 0 #EPs= 1 Cls=09(hub ) Sub=00 Prot=00 Driver=hub
E: Ad=81(I) Atr=03(Int.) MxPS= 8 Ivl=255ms
T: Bus=01 Lev=00 Prnt=00 Port=00 Cnt=00 Dev#= 1 Spd=12 MxCh= 2
B: Alloc= 0/900 us ( 0%), #Int= 0, #Iso= 0
D: Ver= 1.00 Cls=09(hub ) Sub=00 Prot=00 MxPS= 8 #Cfgs= 1
P: Vendor=0000 ProdID=0000 Rev= 0.00
S: Product=USB UHCI Root Hub
S: SerialNumber=d400
C:* #Ifs= 1 Cfg#= 1 Atr=40 MxPwr= 0mA
I: If#= 0 Alt= 0 #EPs= 1 Cls=09(hub ) Sub=00 Prot=00 Driver=hub
E: Ad=81(I) Atr=03(Int.) MxPS= 8 Ivl=255ms
[root@locarno usb]#
[root@locarno usb]# cat /etc/modules.conf
alias parport_lowlevel parport_pc
alias eth0 via-rhine
alias sound-slot-0 via82cxxx_audio
post-install sound-slot-0 /bin/aumix-minimal -f /etc/.aumixrc -L >/dev/null
2>&1 || :
pre-remove sound-slot-0 /bin/aumix-minimal -f /etc/.aumixrc -S >/dev/null
2>&1 || :
pre-install usb-ohci modprobe usbcore
alias usb-controller usb-uhci
alias scsi_hostadapter ide-scsi
[root@locarno usb]#
--
Posted via CNET Help.com
http://www.help.com/
------------------------------
From: Pete Barnwell <[EMAIL PROTECTED]>
Crossposted-To: alt.os.linux
Subject: Re: linuxconf 7.1
Date: Wed, 09 May 2001 00:32:42 +0100
MrEye wrote:
>
> I just installed rh7.1. the last rh distribution I used was rh6.2. What
> happened to 'linuxconf'. I need it to modify the users. Does rh7.1 have a
> different configuration tool?
RH seem to have something against Linuxconf... There is a version on (I
think) the 1st CD but leaves a lot to be desired.
Best bet is download 1.25r5 from www.solucorp.qc.ca
Oh -if you need to use linuxconf from a web browser RH screwed up the
xinetd bit as well... if you need the fix to that let me know, it's a
bit more involved.
Pete
------------------------------
** FOR YOUR REFERENCE **
The service address, to which questions about the list itself and requests
to be added to or deleted from it should be directed, is:
Internet: [EMAIL PROTECTED]
You can send mail to the entire list by posting to comp.os.linux.misc.
Linux may be obtained via one of these FTP sites:
ftp.funet.fi pub/Linux
tsx-11.mit.edu pub/linux
sunsite.unc.edu pub/Linux
End of Linux-Misc Digest
******************************
