Linux-Misc Digest #692, Volume #24 Fri, 2 Jun 00 20:13:02 EDT
Contents:
PostgreSQL vs. MySQL vs. mSQL (milanuk)
Re: applixware linux-intel upgrade (Gerald Willmann)
Re: DSL under linux: No Joy :-< (Jim Thomson)
Re: DSL under linux: No Joy :-< (Hal Burgiss)
Re: mounting ide-scsi device (John)
ppp disconnect
Re: libraries philosophy under linux : Thanks to everyone :) (jack)
Re: Freewwweb slow ? (Craig McCluskey)
Re: ppp disconnect (Nicholas Murison)
Re: Telnet failed under Redhat 6.2 (News Reader)
Re: Q: Console-based Organizer/Calendar apps? (Garry Knight)
Re: GNU Emacs as Default Editor in Helix GNOME 1.2 (john s jacobs anderson)
atd problem: empty atd.pid (Klaus Bartke)
Re: ppp disconnect (Bill Unruh)
Re: PostgreSQL vs. MySQL vs. mSQL (Jerry McBride)
Re: ppp disconnect (Bill Unruh)
----------------------------------------------------------------------------
From: milanuk <[EMAIL PROTECTED]>
Subject: PostgreSQL vs. MySQL vs. mSQL
Date: Fri, 02 Jun 2000 22:03:57 GMT
Hello all,
I am interested in learning some basic SQL skills. I have been digging
around on the web, going thru Deja, etc. looking for info on the merits
of one SQL program vs. another. Basically, the distilled version of
what I've seen so far isthis: PostgreSQL is the most feature complete
and potentially the most reliable for big databases, but kinda slow.
MySQL is blazingly fast, has most of the features commonly used, works
especially well w/ web applications, but doesn't have quite the feature
set of PostgreSQL, and doesn't do huge databases (as) well. mSQL aka
Mini SQL is also fast (as fast as MySQL?), and is definitely intended
for small data sets.
Most of the recommendations that I've seen pushed PostgreSQL for
reliability w/ big mission critical databases, and MySQL for all-out
speed and web stuff.
I am interested in _learning_ SQL, and as such I don't have a
particular _need_ for speed, huge database capability, etc. In this
case, is there one of these three that is best for learning from the
ground up about SQL? I would be interested in hearing peoples
impressions of the support and community related to each. That as much
as anything will play large role in my choice. I don't want to be
_near_ a group that flames on a whim, but I do accept the concept
of 'read first, ask second'.
Thanks for your time,
Monte
--
There are basically three kinds of men. There
are the ones who learn by reading. Then there are
the few who learn by observation. The rest just
have to pee on the electric fence for themselves.
Sent via Deja.com http://www.deja.com/
Before you buy.
------------------------------
From: Gerald Willmann <[EMAIL PROTECTED]>
Subject: Re: applixware linux-intel upgrade
Date: Fri, 2 Jun 2000 15:15:11 -0700
On Fri, 2 Jun 2000, OSguy wrote:
> Applixware will not let you upgrade from anything you bought from RedHat. RedHat
> was originally handling all of those upgrades until they quit selling
> Applixware. You could only get an upgrade from Applixware-4.4.1 or higher from
> Applix (provided you are registered with Applix). Sorry.
>
and you don't think they could send me a reply explaining this?
or commment on whether they offer a student discount?
Gerald
--
------------------------------
Crossposted-To: comp.os.linux.networking,alt.os.linux.suse
Subject: Re: DSL under linux: No Joy :-<
From: Jim Thomson <[EMAIL PROTECTED]>
Date: Fri, 02 Jun 2000 15:16:23 -0700
"Cameron, Gary [WDLN2:2X82:EXCH]" wrote:
> I can't get my DSL working
> under Linux. I have successfully set up both Ethernet and dial up
> networking under Linux before, but am a DSL newbie. I have a 2.2.14
> kernel
> (SuSE 6.4) and am running the latest version of the roaring penguin PPOE
> client, after having no luck with the PPPOE driver suggested by SuSE. I
> run
I'm confused - why are you still running PPP? Seems like all you should
need is dhcpcd to talk to the ISP and get you an IP. Your DSL 'modem' is
already connected to them - it doesn't need to connect (ie dial) right?
good luck.
Jim
------------------------------
From: [EMAIL PROTECTED] (Hal Burgiss)
Crossposted-To: comp.os.linux.networking,alt.os.linux.suse
Subject: Re: DSL under linux: No Joy :-<
Reply-To: [EMAIL PROTECTED]
Date: Fri, 02 Jun 2000 22:43:26 GMT
On Fri, 02 Jun 2000 15:16:23 -0700, Jim Thomson
<[EMAIL PROTECTED]> wrote:
>
>"Cameron, Gary [WDLN2:2X82:EXCH]" wrote:
>
>> I can't get my DSL working
>> under Linux. I have successfully set up both Ethernet and dial up
>> networking under Linux before, but am a DSL newbie. I have a 2.2.14
>> kernel
>> (SuSE 6.4) and am running the latest version of the roaring penguin PPOE
>> client, after having no luck with the PPPOE driver suggested by SuSE. I
>> run
>
>I'm confused - why are you still running PPP? Seems like all you
>should need is dhcpcd to talk to the ISP and get you an IP. Your DSL
>'modem' is already connected to them - it doesn't need to connect (ie
>dial) right?
Not if the provider is shoving PPPoX at you. Many are going this route
now. PPP over Ethernet, and PPP over ATM. This is similar to traditional
PPP dialup, except no dialing takes place (obviously). You authenticate
with username and password, just like dialup. In which case, DHCP would
only get in the way.
--
Hal B
[EMAIL PROTECTED]
--
------------------------------
From: [EMAIL PROTECTED] (John)
Subject: Re: mounting ide-scsi device
Reply-To: [EMAIL PROTECTED]
Date: Fri, 02 Jun 2000 22:50:23 GMT
I cannot beleive that I am having so much trouble with this. I thank
you all for you patients and replies.
Xcdroast uses cdrecord and mkisofs. It is just a GUI front end for
them. Using Xcdroast I am able to burn a CD and my windows maching
will read it. But if I take a purchased CD like Red Hat and try to
mount it, it comes back with "the kernel does not recognize /dev/scd0
as a block device". The purpose of the cdrecord info is to let you
know that something recognizes it and is able to use it.
I must be doing something wrong since cdrecord sees it and can use it
Here is my information from CDrecord.
# cdrecord -scanbus
Cdrecord release 1.8 (i666-pc-linux-gnu)Copyright (C) 1995-2000 J�rg
Schilling
Using libscg version 'schily-0.1'
scsibus0:
0,0,0 0) 'IDE-CD' 'ReWriteable-2X2X6' '3.01' Removable
CD-ROM
0,1,0 1) 'WPI ' ' CDS-24-X ERn' 'A1.0' Removable
CD-ROM
0,2,0 2) *
0,3,0 3) *
0,4,0 4) *
0,5,0 5) *
0,6,0 6) *
0,7,0 7) *
There was previous dicussion about cd-roms being character devices and
scsi being block. I would guess that ide-scsi driver might be the
converter from character to block. Is there an order to loading these
drivers?
All input is appreciated.
On Thu, 01 Jun 2000 08:15:53 -0700, Duane <[EMAIL PROTECTED]>
wrote:
>John wrote:
>>
>> Thank you all for you help but that stillhave not soloved the problem:
>>
>> I ran cdrecord's scanbus before I did anything. cdrecord found the
>> cd-rw and cd (i have 2 devices). I isnmod ide-scsi and sg and tried
>> to mount using mount /dev/sg0 /mnt/cdrom. I still get the message not
>> a block device. I tried to insmod the scsi_mod and sr_mod but they
>> were not found .
>
>Oh, well that is different from the problem most of us thought you were
>having. Don't worry about not finding scsi_mod and sr_mod. That is not
>important. The correct device for mounting is /dev/scd0, not sg0 (as was
>pointed out in another post).
>
>> I do have append="hdc=ide-scsi" right before root=/dev/hda5.
>>
>> What I don't understand is why cdrecord and find them and use them and
>> I can't.
>
>Are you trying to mount a disk before you burn it? No can do. When you
>ran "cdrecord -scanbus", you got something like:
>
># cdrecord -scanbus
>Cdrecord release 1.8a29 Copyright (C) 1995-1999 J�rg Schilling
>Using libscg version 'schily-0.1'
>scsibus0:
> 0,0,0 0) 'PLEXTOR ' 'CD-R PX-W8432T' '1.05' Removable
>CD-ROM
> 0,1,0 1) *
> 0,2,0 2) *
> 0,3,0 3) *
> 0,4,0 4) *
> 0,5,0 5) *
> 0,6,0 6) *
> 0,7,0 7) *
>
>The 0,0,0 is the "device" that is used by cdrecord. I don't know how to
>use xcdroast, but using the the commands from the command line, to
>create a disk of, for example, the /home directory, do (assuming /big is
>large enough to hold the image file):
>
># cd /
># mkisofs -R -l -J -o /big/home.img home
>
>And then burn the disk. Notice the device argument to cdrecord.
>
># cdrecord -v speed=8 dev=0,0,0 /big/home.img
>
>There are other ways of doing things. If you have a reasonably fast
>machine, you don't need to create the image file, and therefore don't
>need a big empty chunk of disk space for it. The mkisofs can be piped
>directly to cdrecord:
>
># mkisofs -R -l -J home | cdrecord -v speed=8 dev=0,0,0 -
>
>Once the disk is burnt, then you can mount it with "mount /dev/scd0
>/mnt/cdrom".
>
>--
>My real email is akamail.com@dclark (or something like that).
------------------------------
Date: Fri, 2 Jun 2000 22:50:31 +0000
From: <[EMAIL PROTECTED]>
Subject: ppp disconnect
Anyone have effective code that will disconnect a modem from the
ISP and then effectively end carrier detect and remove off hook to
turn off the modem and therefore end the connection?
These books I have aren't telling me effective code.
email please
TIA
[EMAIL PROTECTED]
------------------------------
From: jack <[EMAIL PROTECTED]>
Subject: Re: libraries philosophy under linux : Thanks to everyone :)
Date: Fri, 02 Jun 2000 16:10:37 -0400
"Peter T. Breuer" wrote:
>
> [EMAIL PROTECTED] wrote:
> : I would like to thank anyone who posted me an answer.
> : I will now adopt the strategy of using preferably only tarballs of
> : sources.
> : Nevertheless I will continue to think that 450 Mb are a lot (I think I
> : will be considered for this choice a dinosaur :( .
> : RedHat is too big.
>
> No you're quite right. One can comfortably squeeze what is _needed_
> inside about 120MB if you know what you're about (indeed, 30MB for
> a functioning X based system is quite feasible, but it won't have
> development tools on board).
>
> Redhat comes with lots of stuff and no way to say no to it. SuSE and
> Debian have much more available still (debian potato is 2GB of
> compressed archives plus bits and pieces from slink), but you can pick
> and choose so that a minimum install runs about 40-100MB.
>
...and Slackware is even more customizable. I can nicely squeeze
everything I could possibly need for a development system, (no X of
course :) in just under 80M, during a custom install. Now there's a nice
installer that lets you have what you want and nothing else.
MST
------------------------------
From: Craig McCluskey <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.networking,comp.os.linux.setup,alt.os.linux
Subject: Re: Freewwweb slow ?
Date: Fri, 02 Jun 2000 18:19:43 -0500
> Have you recompiled the kernel? If so, make sure you enabled the
> correct options for ppp. If not, check that any ppp modules are
> loaded correctly.
Sorry I wasn't too specific. I can connect with ppp to another ISP.
After much frustration with freewwweb, I started using minicom to
connect
to it. When connected with minicom typing, "ppp," yields the error
message. On the other ISP, typing, "ppp," gives all kinds of output that
starts as text and then rapidly becomes something minicom can't
interpret
(not surprising, since it's binary).
> >Other times, the modem connects and it asks me to type the system
> >password which I obviously don't know.
>
> Whose system password? How does it ask you; how did you connect?
I connect with minicom and get a prompt that says something like,
System Password:
and nothing else.
Craig
------------------------------
From: Nicholas Murison <[EMAIL PROTECTED]>
Subject: Re: ppp disconnect
Date: Sat, 03 Jun 2000 01:28:12 +0200
Reply-To: [EMAIL PROTECTED]
I use the following script to end my connection. Seem to remember I got
it from a HOWTO:
#!/bin/sh
######################################################################
# Determine the device to be terminated.
if [ "$1" = "" ]; then
DEVICE=ppp0
else
DEVICE=$1
fi
######################################################################
# If the ppp0 pid file is present then the program is running. Stop it.
if [ -r /var/run/$DEVICE.pid ]; then
kill -INT `cat /var/run/$DEVICE.pid`
# If the kill did not work then there is no process running for this
# pid. It may also mean that the lock file will be left. You may wish
# to delete the lock file at the same time.
if [ ! "$?" = "0" ]; then
rm -f /var/run/$DEVICE.pid
echo "ERROR: Removed stale pid file"
exit 1
fi
# Success. Let pppd clean up its own junk.
echo "PPP link to $DEVICE terminated."
exit 0
fi
# The ppp process is not running for ppp0
echo "ERROR: PPP link is not active on $DEVICE"
exit 1
--
Nicholas John Murison
~~~~~~~~~~~~~~~~~~~~~
Don't mess with penguins
Registered Linux User #153895 http://counter.li.org
------------------------------
From: [EMAIL PROTECTED] (News Reader)
Crossposted-To: linux.redhat.misc,comp.os.linux.help
Subject: Re: Telnet failed under Redhat 6.2
Date: Fri, 02 Jun 2000 23:35:14 GMT
6.2 uses a separate package for telnet server.
Download and install.
On Fri, 02 Jun 2000 18:15:59 GMT,
Akira Yamanita <[EMAIL PROTECTED]> wrote:
>Karen Jiang wrote:
>>
>> I am upgrading from Redhat 6.1 to 6.2, in hoping it will recognize my sound
>> card (no luck).
>>
>> However, now I can not do telnet. I installed inetd RPM, but it still does
>> not work. Even when I try "telnet localhost", after about 1 minute, it said
>> "connection closed by foreign host". I am trying to add more service into rc
>> scripts by using "control-panel", but when I click on runlevel button, it
>> gave me error message.
>>
>> Did anybody experience the same problem? Why this happens? Suggestions
>> appreciated.
>>
>> p.s. I think it is stupid not to include "inetd" in the workstation
>> configuration.
>
>It sounds like you did a fresh installation of RH 6.2, right?
>
>Make sure you have the telnet daemon loading in /etc/inetd.conf.
>Restart inetd with "killall -HUP inetd"
>
>Also make sure that localhost has access in /etc/hosts.allow
>Just add the line:
>ALL:127.0.0.
------------------------------
From: [EMAIL PROTECTED] (Garry Knight)
Subject: Re: Q: Console-based Organizer/Calendar apps?
Date: Sat, 3 Jun 2000 00:39:41 +0100
Reply-To: [EMAIL PROTECTED]
In article <8h8ej2$c4a$[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
>This message has been posted by:
>[EMAIL PROTECTED] (Dave Ewart)
>
>Does anyone have any recommendations for a _console_-based app
>that has various calendar/scheduling facilities?
>
>Under X, I have tried KOrganizer, which is OK, but I want to run
>the app on a system _without_ X ...
emacs. It has calendar, diary, and appointment facilities.
--
Garry Knight
[EMAIL PROTECTED]
------------------------------
Crossposted-To: gnu.emacs.help,comp.emacs,alt.os.linux.mandrake,comp.os.linux.setup
Subject: Re: GNU Emacs as Default Editor in Helix GNOME 1.2
From: john s jacobs anderson <[EMAIL PROTECTED]>
Date: 02 Jun 2000 19:45:40 -0400
>>>>> "DD" == D D Brierton <[EMAIL PROTECTED]> writes:
DD> The default editor is configured in GNOME by a drop-down list,
DD> and emacsclient is not listed as one of the options, and there
DD> is no obvious way to type in something like "emacsclient
DD> %f". I'd have thought that given that this current version of
DD> GNOME is really tight that the %f oughtn't to have to be
DD> manually specified.
OMM, I can click in the text entry field, and type in what ever, in
addition to using the drop down list. Setting the field to read
'gnuclient %f' causes a gnuclient to spawn and open the file when
choosing 'Edit' from the pop-up menu in GMC.
HTH,
john.
--
========================================================================
John S Jacobs Anderson \ <URL:http://www.xemacs.org>
You'll have to pry my Emacs from my cold \ [EMAIL PROTECTED]
dead oversized control-pressing left pinky finger. -- Randal L. Schwartz
------------------------------
From: Klaus Bartke <[EMAIL PROTECTED]>
Subject: atd problem: empty atd.pid
Date: Sat, 03 Jun 2000 01:51:41 +0200
When starting Linux, the message "Starting at services.." appears with
"done". But the file /var/run/atd.pid remains empty. This causes
(probably) that remote printing from other machines is not possible.
When I shutdown, an error message (empty file /var/run/atd.pid) occurs.
The problem occurs since 1 month. Who can help me?
--
Klaus Bartke
------------------------------
From: [EMAIL PROTECTED] (Bill Unruh)
Subject: Re: ppp disconnect
Date: 3 Jun 2000 00:03:09 GMT
In <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> writes:
>Anyone have effective code that will disconnect a modem from the
>ISP and then effectively end carrier detect and remove off hook to
>turn off the modem and therefore end the connection?
you do not tell us which operating system or which ppp program.
pppd has the idle option which will hang up the system if there is not
activity in x seconds. Or killall pppd will hang up pppd and disconnect
under linux. What do you want and what OS are you using?
------------------------------
From: [EMAIL PROTECTED] (Jerry McBride)
Subject: Re: PostgreSQL vs. MySQL vs. mSQL
Date: Fri, 02 Jun 2000 19:18:35 -0400
In article <8h9b03$cag$[EMAIL PROTECTED]>, milanuk <[EMAIL PROTECTED]> wrote:
> Hello all,
>
>I am interested in learning some basic SQL skills. I have been digging
>around on the web, going thru Deja, etc. looking for info on the merits
>of one SQL program vs. another. Basically, the distilled version of
>what I've seen so far isthis: PostgreSQL is the most feature complete
>and potentially the most reliable for big databases, but kinda slow.
>MySQL is blazingly fast, has most of the features commonly used, works
>especially well w/ web applications, but doesn't have quite the feature
>set of PostgreSQL, and doesn't do huge databases (as) well. mSQL aka
>Mini SQL is also fast (as fast as MySQL?), and is definitely intended
>for small data sets.
>
>Most of the recommendations that I've seen pushed PostgreSQL for
>reliability w/ big mission critical databases, and MySQL for all-out
>speed and web stuff.
>
>I am interested in _learning_ SQL, and as such I don't have a
>particular _need_ for speed, huge database capability, etc. In this
>
Having been down this path... :') mSQL will get your feet wet in both the
SQL and JDBC wadeing pool... When you outgrow the limited SQL subset,
I'd recommend you leap into the mySQL pond. If you outgrow this one, there's
always DB2 on Linux... quite a leap into the ocean though... ;')
Cheers,
Jerry
--
*******************************************************************************
...... <- Stealth Tagline
*******************************************************************************
* NetRexx - The onramp to the Internet - http://www2.hursley.ibm.com/netrexx *
*******************************************************************************
------------------------------
From: [EMAIL PROTECTED] (Bill Unruh)
Subject: Re: ppp disconnect
Date: 3 Jun 2000 00:06:26 GMT
In <[EMAIL PROTECTED]> Nicholas Murison
<[EMAIL PROTECTED]> writes:
>I use the following script to end my connection. Seem to remember I got
>it from a HOWTO:
<script removed>
This is the standard ppp-off program and it is not very good, as the
/var/run/ppp0 file is readable only by root, and thus a user cannot read
it and thus cannot kill the ppp program.
If you only have one pppd running, then
killall pppd
works fine.
If youhave more than one and need to kill depending on the ppp#, then
you could make an suid wrapper for this program and run it that way.
------------------------------
** 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 (and comp.os.linux.misc) via:
Internet: [EMAIL PROTECTED]
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
******************************
