Linux-Misc Digest #157, Volume #20 Tue, 11 May 99 19:13:16 EDT
Contents:
Re: Newbie Database Questions (Ferdinand Tempel)
Re: RedHat price... (Johan Kullstam)
Re: Odd math problem. (Johan Kullstam)
Re: Newbie: Learning Linux And Databases (Brian Hostetter)
Ip Over SCSI... (Alessandro Surace)
What app Is a better Dialup alternative to pon/poff??? ( Leili)
job for sendmail? (pces)
Re: FreeBSD vs. Linux vs. Windows (Vernon Schryver)
Re: URGENT. Dead or life. (Kevin Reeder)
Re: I did something stupid and now I can't boot... (Kevin Reeder)
Re: Caldera OpenLinux 1.3 ("Damon J. Rygiewicz")
Re: Java working with glibc2.1 (RedHat 6/Debian Potato etc) (Hans Wolters)
sticky shift keys in linux ([EMAIL PROTECTED])
How to setup a PPP dialup Server in Linux ? ("Chow Hoi Ka, Eric")
web-based email server for multiple domains ([EMAIL PROTECTED])
Re: Odd math problem. (Marco Anglesio)
Re: kernel 2.2 ("Damon J. Rygiewicz")
How to low-level format a SCSI ("Albert Wiersch")
----------------------------------------------------------------------------
From: Ferdinand Tempel <[EMAIL PROTECTED]>
Subject: Re: Newbie Database Questions
Date: Tue, 11 May 1999 21:58:14 +0000
The Magician wrote:
>
> I'm a total Linux newbie. My goal is to configure a web server (Apache),
> and give it database capabilites. I have looked at a product called MySQL,
> and it looks like it would be the ticket. However, life in the world of
> Windows is very proprietary, and makes my job more difficult. Our databases
> are currently in MS ACCESS (.MDB) format, and I would like to convert them
> to a Linux friendly file-type. Does anyone know what would be the best
> format for these databases to be converted into? Also, if anyone has
> experience with MySQL, could they PLEASE tell me what types of databases
> this program supports? Thanks.
Download this script from
http://www.cynergi.net/exportsql/
and execute follow the instructions given in the script.
The script will produce a few text files representing the full database
you were running the script in.
The one you will be interested in is the one that had the phrase "add"
(I think it was called "esql_add.txt") in it.
Now fire up linux, and copy the mentioned textfile from the windows to
the linux partition (not really necessary, but you want to be working in
linux anyway right?)
Start the MySQL daemon (mysqld) (if not allready started), and create a
new database using the mysql program (read the online manual at
http://www.mysql.com !!), say you call it "new_database".
Quit mysql and type the following at the prompt:
[linux_prompt]# mysql new_database < esql_add.txt
This command will copy your complete database including tables and data
to your mysql database.
Maybe there will be some error messages from mysql: That means you might
need to edit the textfile a bit to suit mysql needs, but that's not too
hard.
Even I could manage manage to convert a database (Access97) with 4
tables and 4032 entries in the main table, and I'm no power user.
Good luck with it.
PS: Don't be tempted to detour the procedure using MySQL for windows: I
couldn't read the created database on my Linux box.
Regards,
--
/*
FoT
*/
------------------------------
From: Johan Kullstam <[EMAIL PROTECTED]>
Subject: Re: RedHat price...
Date: 11 May 1999 10:34:01 -0400
[EMAIL PROTECTED] (Ray) writes:
> I just checked out the price on the newest version of RedHat (6.0),
> and I see that the basic boxed set is going to sell for between
> $75-$80, to which I say, "ARE THEY OUT OF THEIR EVER-LOVING MINDS?!"
> Is there really that much new in 6.0 to justify such an extreme price
> hike?
i don't know. this is for you to judge.
> Personally, this has dead-set me against getting RedHat 6.0 as my
> next Linux. It'll be Caldera or SuSE for me! Most likely the
> latter...
caldera and suse seem to be fine choices. a cd pressing of redhat-6.0
from cheapbytes or linux systems for $2 (or whatever) is also viable.
there's also debian.
if $80 seems too high, take your business elsewhere. i see no
reason for all this kvetching.
--
johan kullstam
------------------------------
From: Johan Kullstam <[EMAIL PROTECTED]>
Subject: Re: Odd math problem.
Date: 11 May 1999 10:28:34 -0400
Nic Percival <[EMAIL PROTECTED]> writes:
> I've encountered a strange problem with the following code...
>
> #include<stdio.h>
> #include<stdlib.h>
>
> main()
> {
> double fred=1235;
> int dpt, sg;
> char *jack;
>
>
> jack = ecvt( fred, 16, &dpt, &sg );
> puts(jack);
>
> }
>
> If you compile this normally, all is fine, the result is
> '1235000000000000'. If however
> you link in libm, or libstdc++, the result is '1234999999999999'.
> Any idea what's going on here?
yes. it's called floating point. double precision only has 15-16
decimal digits of significant figures in the mantissa. your number
has (slightly) exceeded this. it has been approximated. there is no
problem here. you have just expected too much.
--
johan kullstam
------------------------------
Crossposted-To: comp.os.linux.development.apps,comp.os.linux.setup
From: Brian Hostetter <[EMAIL PROTECTED]>
Subject: Re: Newbie: Learning Linux And Databases
Date: Tue, 11 May 1999 17:22:35 GMT
Oracle 8.0.5.1 Enterprise Edition is listed as a "FREE" download, not a
"TRAIL" download on Oracle's site and can be had, anonymously, via ftp
to ftp.oracle.com/pub/www/otn/linux. Also, the Oracle Application
Server is listed as free as well and can be had through the same means.
Watch out, though, DB is a 171 MB file and App Server is a 181 MB file.
Brian Hostetter
Jose Santiago wrote:
>
> Rupinder wrote:
>
> > Postgre - any good?
> > Informix-SE - reliable? I have heard many people have problems with
> >
> > this...
> > Sybase - is this free...? I'll have to call them... there is no
> > price
> > on their site... Is it good and reliable?
> > Oracle 8 - $3000 CDN !!! - too expensive !!!
>
> Use MySQL http://www.mysql.com . You will need a version of Linux with
> Linux Threads. Slackware 4.0 has them.
>
> --
> Jose Santiago
>
> Senior Systems Analyst - Scientific Systems
> Komatsu Mining Systems - Peoria Operations
> 2300 N.E. Adams Street
> P.O. Box 240
> Peoria, IL 61650-0240
>
> Voice:309-672-7325 Fax:309-672-7753
> mailto:[EMAIL PROTECTED]
>
>
------------------------------
From: Alessandro Surace <[EMAIL PROTECTED]>
Subject: Ip Over SCSI...
Date: Tue, 11 May 1999 17:14:48 +0200
Hi Boys & Girls...
Somebody has news on Ip over SCSI....???
I want to construct a small network with its .
Can You help Me!!!
Gooddd
Bye
Bye
Ale
------------------------------
From: <[EMAIL PROTECTED]> Leili
Subject: What app Is a better Dialup alternative to pon/poff???
Date: Tue, 11 May 1999 17:35:32 GMT
I Have a new Debian linux setup. It doesn't have
x-windows, or other gui's, just text interface since its an old
computer with small hd, anyway, what is a good secure and "friendlier"
alternative to pon/poff??
as for pon/poff, where is the password stored, I would like to get rid
of the file if i can.
btw, is it possible to get pon to "password prompt" me everytime I
sign on to my ppp host, instead of having a password stored on my
computer???
thanks,
------------------------------
From: pces <[EMAIL PROTECTED]>
Subject: job for sendmail?
Date: Tue, 11 May 1999 23:23:45 +0800
Reply-To: [EMAIL PROTECTED]
Here's a hypothetical scenario.
A user is at home. Enters email and then dials ppp to a work server and
uploads
it to the mail server.
ie.
>From : John Doe (localhost)
To : Alan Doe ([EMAIL PROTECTED])
Subject: *code*: Hi!
Message body...
End message
The From address _isn't_ a valid email address.
In the message subject, the user enters a special text code that the
mail server
processes. If the code is *precisely* what is required, then the
message body
is then copied to a NEW message, with the signature (bearing
just the user's name) appended to the new message. Also, the TO
field is also copied verbatim to the new message's TO field. The FROM
field, on the other hand, is a 'valid' email address. The Subject is
parsed
for the _real_ subject (in this example, after the *code* :, ie. Hi!)
and
the real subject is placed in the SUBJECT of the new message.
ie. (new message)
FROM: [EMAIL PROTECTED] //example..
TO : Alan Doe([EMAIL PROTECTED])
SUBJECT: Hi!
Message body...
John Doe
--- Signature
This message is then sent to a mail job queue, and after so many
minutes(or whatever), the
diald server then dials to the ISP, connects, and then the message is
then sent to
the ISP's message server to be sent to the intended addressee..in this
case,
[EMAIL PROTECTED]
I'm sorry if this whole example is somewhat convoluted, but basically it
is a a re-package-
redirect to-and send to-type of process. At work(small business), we
only have
one email address and I'm considering a possibility of giving the bosses
the 'capability'
to send emails to their clients via the one single email address.
In a sense, it's like IP Masquerading, but with email instead of IP
Packets. Should
I even bother? The Network at work is WinNT based with the Win95
workstations.
I'm considering in sticking a Linux mail/ppp server using one of the
unused 486's
available. Any comments? Of course, if this is not particularly
'valid' in terms
of code of the Internet, I can think of other avenues..
I know I can apply for multiple email addresses, but there are costs
involved, and in
this time of economic downturn(working in HK right now), my bosses think
it's
frivilous. However, if I've given them the taste of what emailing
customers are
all about, I'm sure they'll change their minds. ;)
Any information/clarifications appreciated.
------------------------------
From: [EMAIL PROTECTED] (Vernon Schryver)
Crossposted-To: comp.unix.bsd.freebsd.misc
Subject: Re: FreeBSD vs. Linux vs. Windows
Date: 11 May 1999 07:44:47 -0600
In article <7h8feg$59l$[EMAIL PROTECTED]>, Leslie Mikesell <[EMAIL PROTECTED]> wrote:
>>>This one seemed not to limit the queue runs - at least not until
>>>the system was at a point where I didn't have the patience to
>>>wait for a prompt (probably hours).
>>
>>Did whoever configured sendmail to run the queue every 30 seconds
>>also turn on the load limiting?--it sounds unlikely that someone foolish
>>enough to do the first would be wise enough to do the second.
>
>No. If it is necessary, is there some reason that there isn't a
>useful default or a mention of the option in the man page?
The load limiting is mentioned in the "op" document. Look for QueueLA,
RefuseLA, and CurrentLA. They were called x and X in the old days.
A better question might be why the QueueIntvl can be set as low as 1
second. On the other hand, it's easy to imagine wierd but valid situations
in which 1 second queue runs are appropriate and where any values for
QueueLA and RefuseLA that you'd care to document would be wrong. Since
I first encountered the load limits, appropriate defaults for standard
installations (QueueIntvl >= 15m) have increased about 40x, at least for
some systems. Recall the classic UNIX dictum about sharp edged tools.
In article <[EMAIL PROTECTED]>,
Marco Anglesio <[EMAIL PROTECTED]> wrote:
>>not offered as the result of the DOS attack, then you have *NOT* defended
>>against it. A Denail Of Service attack's goal is, by common definition,
>>to deny the service. "Taking a system down hard" is not a DOS attack,
>>except in the secondary, uninteresting sense that all deaths are due to
>>heart failure.
>
>I wouldn't find it uninteresting; taking the system down hard also denies
>one, in one's capacity as administrator, to review the logs of the event
>in their entirety. The system goes down - but why did it go down? What put
>it over the edge? Can we defend against this in the future?
>
>We want black boxes in aircraft to do as much of the same thing as
>physically possible - to go on recording until the airplane physically
>comes apart (and even then, as long as possible).
Of course, but that does not contradict what I said. I complained about
the uninteresting and useless equivalent of declaring the cause of all
crashes to be "aircraft hit the ground." It is useful to distinguish
types of attacks and defenses. A defense against a system crash is more
valuable than a DOS defense, and in this case, not a defense against a
DOS attack but a cause of denying the service. That DOS attacks are talked
about more in recent years is a poor reason to claim that a defense against
"taking the system down hard" is DOS defense, particularly when disabling
the service an intended result of the defense.
Vernon Schryver [EMAIL PROTECTED]
------------------------------
From: Kevin Reeder <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.questions,comp.os.linux.help
Subject: Re: URGENT. Dead or life.
Date: Tue, 11 May 1999 10:40:07 -0700
==============6849A7A1BC874BC8FBD9350C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I believe that you have two problems. One, XDM is not recognizing your
password because you need to enable shadow passwords. If you installed
Red Hat you'll find a solution in the installation guide; other
installations I'm not sure of but at least you know what the problem is.
Two, you must have set your default run level to 5 (i.e., X windows) and
will need to edit the /etc/inittab file to reset the default to 3. Be
very careful with that file. The line you want to edit looks like this:
id:5:initdefault:. You want to change that 5 to 3. To do all of this you
will need to boot to Linux from your floppy drive and may need to use a
rescue disk. 'Hope this helps.
Kevin
Nuno Donato wrote:
> This is a dead or life situation.
> I am going to explain what happened to me, because I REALLY need help.
> I have changed a file, that contains info about the window-managers.
> Now, every time i run linux, XDM autostarts, i enter the username(root
> is the only user), and the password. But there must be an error some
> whera, because, no window manager run.
> And I am taken again to enter the name and password.
> How can I solve this. If i haven't XDM enabled, I could edit the file
> again from the console.
> My second question is, how can I turn off LILO?
>
> Please I really need help.
==============6849A7A1BC874BC8FBD9350C
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<HTML>
I believe that you have two problems. One, XDM is not recognizing
your password because you need to enable shadow passwords. If you
installed Red Hat you'll find a solution in the installation guide; other
installations I'm not sure of but at least you know what the problem is.
Two, you must have set your default run level to 5 (i.e., X windows) and
will need to edit the /etc/inittab file to reset the default to 3.
Be <B>very </B>careful with that file. The line you want to edit
looks like this: id:5:initdefault:. You want to change that
5 to 3. To do all of this you will need to boot to Linux from your
floppy drive and may need to use a rescue disk. 'Hope this helps.
<P>Kevin
<P>Nuno Donato wrote:
<BLOCKQUOTE TYPE=CITE>This is a dead or life situation.
<BR>I am going to explain what happened to me, because I REALLY need help.
<BR>I have changed a file, that contains info about the window-managers.
<BR>Now, every time i run linux, XDM autostarts, i enter the username(root
<BR>is the only user), and the password. But there must be an error some
<BR>whera, because, no window manager run.
<BR>And I am taken again to enter the name and password.
<BR>How can I solve this. If i haven't XDM enabled, I could edit the file
<BR>again from the console.
<BR>My second question is, how can I turn off LILO?
<P>Please I really need help.</BLOCKQUOTE>
</HTML>
==============6849A7A1BC874BC8FBD9350C==
------------------------------
From: Kevin Reeder <[EMAIL PROTECTED]>
Subject: Re: I did something stupid and now I can't boot...
Date: Tue, 11 May 1999 10:56:37 -0700
==============5AB154078A9DA0C66E238DEE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I am trying repair to a system crash of my own and am able to do the
following: mkdir /mnt/linux and then mount -t ext2 /dev/hd# /mnt/linux
(where # = the # of your root partition).
That should help.
Kevin
Mladen Gavrilovic wrote:
> In my epic battle to upgrade my glib to 2.1, in a moment of stupidity I
> renamed my /lib to /oldlib instead of copying it. Now nothing works. I
> can't rename it back because mv doesn't work. Basically only cd works.
> I am running RedHat 5.0. I can boot off the CD into a live system
> (rescue mode) but I have no idea how to mount my the linux partition
> (hda4) to rename the directory back to /lib. Can anyone help me?
>
> Regards,
>
> Mladen
==============5AB154078A9DA0C66E238DEE
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<HTML>
I am trying repair to a system crash of my own and am able to do the following:
<I>mkdir /mnt/linux</I> and then <I>mount -t ext2 /dev/hd# /mnt/linux</I>
(where # = the # of your root partition).
<P>That should help.
<P>Kevin
<P>Mladen Gavrilovic wrote:
<BLOCKQUOTE TYPE=CITE>In my epic battle to upgrade my glib to 2.1, in a
moment of stupidity I
<BR>renamed my /lib to /oldlib instead of copying it. Now nothing
works. I
<BR>can't rename it back because mv doesn't work. Basically only
cd works.
<BR>I am running RedHat 5.0. I can boot off the CD into a live system
<BR>(rescue mode) but I have no idea how to mount my the linux partition
<BR>(hda4) to rename the directory back to /lib. Can anyone
help me?
<P>Regards,
<P>Mladen</BLOCKQUOTE>
</HTML>
==============5AB154078A9DA0C66E238DEE==
------------------------------
From: "Damon J. Rygiewicz" <[EMAIL PROTECTED]>
Subject: Re: Caldera OpenLinux 1.3
Date: Tue, 11 May 1999 17:31:37 -0500
OpenLinux 1.3 only installs the libc5, however, you can install the runtime
of glibc from the install CD. I forgot where the package is located,
however, I'm sure it isn't too hard to find.
Damon
------------------------------
From: [EMAIL PROTECTED] (Hans Wolters)
Crossposted-To: uk.comp.os.linux
Subject: Re: Java working with glibc2.1 (RedHat 6/Debian Potato etc)
Date: 11 May 1999 22:42:45 GMT
Reply-To: [EMAIL PROTECTED]
Phillip Deackes <[EMAIL PROTECTED]> found a keyboard
and wrote the following ....
>There is a glibc 2.1 compiled jdk 1.1.7 at the following url which works
>fine here:
>
>http://shell.ncm.com/~kreilede/
>
>All you need to do is download the tar.gz archive (18 MB!!) and unzip
>and untar it. No compiling needed.
What's the difference with the glibc version's that www.blackdown.org has on
their mirror's?
Regards Hans
--
22 Linux Search Engines in one applet
http://home.gelrevision.nl/~h.wolter/
Linux Links/CMI8330 Soundpro HOWTO
http://home.gelrevision.nl/~h.wolter/linux.htm
------------------------------
From: [EMAIL PROTECTED]
Crossposted-To: comp.os.linux.setup
Subject: sticky shift keys in linux
Date: Tue, 11 May 1999 15:12:06 GMT
How do I make the Shift-keys (and preferably Control, Alt) sticky, as
you can under Windows NT? Sticky means that pressing Shift, releasing it
and pressing "a" gives you "A", etc.
This should work under X (maybe on console too, but I don't care so
much), at least under KDE.
--
please cc email: [EMAIL PROTECTED]
no spam please
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
------------------------------
From: "Chow Hoi Ka, Eric" <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.networking
Subject: How to setup a PPP dialup Server in Linux ?
Date: Wed, 12 May 1999 02:42:35 +0800
Reply-To: [EMAIL PROTECTED]
Hello,
How can I setup a PPP dialup Server in Linux and the clients that dialup
to the Linux can connect to the Internet through the Linux PPP
Server(which is connecting to the Internet) ??
Best regards,
Eric
--
_ _
/ ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
/ / | | \ \
_( /_ | _ Chow Hoi Ka, Eric _ | _) )_
(((\ \> |/ ) ( \| </ /)))
(\\\\ \_/ / E-Mail : [EMAIL PROTECTED] \ \_/ ////)
\ / \ /
\ _/ http://www.sftw.umac.mo/~d951686/ \_ /
/ / |____________________________________________| \ \
/ / \ \
------------------------------
From: [EMAIL PROTECTED]
Subject: web-based email server for multiple domains
Date: Tue, 11 May 1999 21:39:34 GMT
I would like to set up a single server as a mail server for multiple
domains and provide email accounts for multiple users in those domains.
I can configure sendmail to handle virtual domain hosting, but I need
to have distinct users; i.e. you can't have [EMAIL PROTECTED] and
[EMAIL PROTECTED] unless you set up pop users joe1 and joe2 and then tell
them to configure their clients--too confusing for most users.
Is there a product or a HOWTO using freeware to set up this kind of
virtual domain email hosting arrangement that simplifies the
administration and does not require users to know what is going on
behind the scenes?
Ideally, I can log on to mail.masterdomain.com with a web browser,
choose a domain, add/delete users, etc...
Then, users log on to mail.theirdomain.com.
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
------------------------------
From: [EMAIL PROTECTED] (Marco Anglesio)
Subject: Re: Odd math problem.
Reply-To: [EMAIL PROTECTED]
Date: Tue, 11 May 1999 15:48:00 GMT
On Tue, 11 May 1999 11:43:41 +0100, Nic Percival <[EMAIL PROTECTED]> wrote:
>If you compile this normally, all is fine, the result is
>'1235000000000000'. If however
>you link in libm, or libstdc++, the result is '1234999999999999'.
Perhaps you've exceeded the precision of said number values? After all,
123500000000000 is not 1.235E16, but rather 1.235000000000000E16. Do you
wish to have that much precision in your calculations?
If that is so (and I don't know whether it is or not, not knowing the
particulars of your case), then it isn't an odd problem at all; you've
merely reached the limits of the standard math functionality on such and
such an architecture. There are math libraries which provide greater
precision, of course, and if it's very important to be very precise you
could use them yourself.
marco
--
,--------------------------------------------------------------------------.
> Marco Anglesio | Love is a perky elf dancing a merry <
> [EMAIL PROTECTED] | little jig and then suddenly he turns <
> http://www.the-wire.com/~mpa | on you with a miniature machine gun. <
> | --Matt Groening, Life in Hell <
`--------------------------------------------------------------------------'
------------------------------
From: "Damon J. Rygiewicz" <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.networking
Subject: Re: kernel 2.2
Date: Tue, 11 May 1999 17:41:35 -0500
Check this out!
http://www.redhat.com/support/docs/rhl/kernel-2.2/kernel2.2-upgrade.html
Hope it helps!
Damon
------------------------------
From: "Albert Wiersch" <[EMAIL PROTECTED]>
Crossposted-To: comp.os.linux.hardware
Subject: How to low-level format a SCSI
Date: Tue, 11 May 1999 10:42:11 -0500
How can I low level format a SCSI drive on my remote Linux system?
I don't want to have to physically go to it to do so (want to do it through
telnet). I think the SCSI BIOS has a format utility, but I would like a
Linux program to do it. Can't access the SCSI BIOS from here.
The drive doesn't have any useful files on it right now... I would just like
to low-level format it and then set it up as a backup drive.
(Please send your reply to my email, too. Thanks!)
Thanks,
Albert
------------------------------
** 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
******************************
