RE: [expert] MySql permissions and configuration

2002-02-18 Thread Aron Pilhofer

I think (and don't quote me) you have to create the my.cnf file yourself. I
don't think it is required, but mysql will look for it when it launches. Not
100 percent sure about that, but I think that's why you aren't finding it.

However, the problem you're describing sounds like a permissions issue -
what error message are you getting when you try to create a db?

>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Ken Thompson
>Sent: Monday, February 18, 2002 5:21 PM
>To: [EMAIL PROTECTED]
>Subject: [expert] MySql permissions and configuration
>
>
>Where are the configuration files for MySql found?
>
>I've looked everywhere I can think of and still no joy.
>Looking in /etc/rc.d/init.d/mysql I found this bit of info,
>"# If you want to affect other MySQL variables, you should make
>your changes
># in the /etc/my.cnf or other configuration files.
>"
>Locate doesn't find my.cnf anywhere on my system.
>The problem is that I can't use webmin or phpMyAdmin or the CLI to
>create a
>database.
>I can log onto the test db but that's as far as it goes.
>There has to be a global config file somewhere doesn't there??
>Surley it's not gremlin powered .
>--
>
>Ken Thompson, North West Antique Autos
>Payette, Idaho
>Email: [EMAIL PROTECTED]
>http://www.nwaa.com
>Sales and brokering of antique autos and parts.
>
>Linux- Coming Soon To A Desktop Near You
>Registered Linux User #183936
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-19 Thread Aron Pilhofer

To expand some...

MySQL is a wicked fast db with some limitations. I am using it right now for
a project and I'm really wishing it supported views, for example. To the
good, it is really, really fast, light and stable.

Postgre has many more features and is supposed to be a lot faster than it
used to be with the most recent version. I have seen benchmarks that support
this, and some that refute it. But in any case, it does have a lot better
feature set than MySQL - particularly for handling dates. It also supports
views and subqueries.

PG has a really slick GUI too: PG access. You really can't go wrong with
either one, but there are advantages/disadvantages to each depending on the
project you are planning.


>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of wim
>Sent: Tuesday, February 19, 2002 9:06 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>PostgreSQL and MySQL are databases for Linux.
>
>--
>Kind regards,
>
>Wim De Hul
>Belgacom Belbone
>
>  Mail   : [EMAIL PROTECTED]
>  Mobile : +32 479 952004
>  Ripe   : WDH25-RIPE
>  Registered Linux User: #260015
>
>
>
>Harold Hartley wrote:
>
>> I was wondering how many database software is there available for linux
>> and what the names of them may be..
>>
>> Harold
>>
>>
>>
>>
>> 
>>
>> Want to buy your Pack or Services from MandrakeSoft?
>> Go to http://www.mandrakestore.com
>>
>
>
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



[expert] Video Problems

2002-02-19 Thread Aron Pilhofer

I don't know if this is an expert or newsier question, but here goes:

I own a Radeon 8500. Bought it without looking at the supported hardware
list... duh! OK, so I have lived with lousy video for a few weeks now. But
as of the new version of XFree, the 8500 is supposed to have 2D support. I
know for a fact that this is the case because, while playing around with
another disro, I compiled the kernel/XFree myself and the video looks
great.. or at least good enough for everyday use.

Installing the Cooker distro, I cannot get it to decognize my Radeon from
the get-go. I edited the XFree86 config file to point it to the radeon
driver, restarted X and still it looks like hell.

So, my question is: Is there some other config file I am not aware of that I
need to edit, or do I have to do something else to get it to recognize the
8500? I remember when I was workign with the other distro, I compiled the
kernel with DRI support - do I need to recompile my Mandrake kernel as well?

I'm quite at my wit's end here. Any help would be greatly appreciated.
Thanks in advance...

aron



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-20 Thread Aron Pilhofer

Just FYI, (almost) any script written in PHP for mysql can be adapted quite
easily for any RDBM, including Postgres. That's one of the really nice
things about PHP, IMHO.

Again, though, the difference between MySQL and Postgres really have more to
do with feature set and speed than ease of setup and use. I don't want to
start a religious debate here, but I think everyone who really knows a db
thinks it's the easiest to setup and use. They both have their quirks.
Choose first based on which features you need, that's my advice.

If you need views and subqueries, then it's a pretty simple decision. If you
need to do lightning-fast selects on millions and millions of records, again
it's a pretty easy call.


>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of
>[EMAIL PROTECTED]
>Sent: Wednesday, February 20, 2002 9:36 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>On Wed, 20 Feb 2002, Rob wrote:
>> Postgres (in my experience) has always been very stable and easy
>> to learn and use. Probably the most so of all RDBMs I have used.
>> I dont know what experience (or closed minded ?? viewpoint) Harold
>> has to justify masocism in regard to postgres (maybee he used a very
>> old version a long time ago - ?).
>
>Postgres has been simple for me to use and configure. I had only minor
>administration experience with databases previously (some Oracle), but
>found Postgres easy to setup and use. This is not to say that MySQL was
>difficult, only that I had initial problems with it and authentication
>(it seems I had to add user IDs directly to the tables).
>
>I'm using Postgres now as the backend to my library (about 2,000 books,
>300 CDs). There was not as many pre-made scripts in PHP as there was for
>MySQL, but I did find lots of examples in C and Perl.
>
>
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-20 Thread Aron Pilhofer

Yeah, true enough for applications...of course. The question (I thought) was
about the many collections of code snippits out there, which people have
written with one db or another in mind. Very, very easy to adapt those to
whatever database manager/server you are using - maybe I misunderstood.



>-Original Message-
>From: Alexander Skwar [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, February 20, 2002 3:57 PM
>To: Aron Pilhofer
>Cc: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>»Aron Pilhofer« sagte am 2002-02-20 um 12:19:56 -0500 :
>> Just FYI, (almost) any script written in PHP for mysql can be
>adapted quite
>> easily for any RDBM, including Postgres. That's one of the really nice
>> things about PHP, IMHO.
>
>Well, in *theory*, you're right.  But this holds only so long true, as
>you write "pure" SQL and don't use any special RDBMS dependent
>optimizations.  So, while you can very easily switch the backend, you
>really have to take a lot of precautions to ensure that the application
>still works after the switch.
>
>And while I also very much love PHP (and despise Perl for web
>development), it's also very easy to switch the DB backend in Perl,
>thanks to the nice DBI package.
>
>Alexander Skwar
>--
>How to quote:  http://learn.to/quote (german) http://quote.6x.to (english)
>Homepage:  http://www.iso-top.de  | Jabber: [EMAIL PROTECTED]
>   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
>   Uptime: 7 days 13 hours 24 minutes
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-20 Thread Aron Pilhofer

>The developer offered some help and suggested a possible entry in my
>.Xdefaults. This didn't fix the error though. He believes it to be a
>config error on my part.

Ah yes, the old "when in doubt, blame the user" gambit. ;)

But seriously, is there any reason you wouldn't want to use MySQL/Postgres?
Both are fairly light and compact, and neither is a major tax on available
resources. I could understand it if we were talking about a $2,000 pricetag
on an app like MS-SQL server, but the price here is right... and they both
come packaged with most distros, including 'drake. Just curious.



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] MySql permissions and configuration

2002-02-20 Thread Aron Pilhofer

If you never set a root password, you should be able to log in as root with
no pass. MySQL is very picky about syntax. Please, if you can, tell us
exactly what you type when you log in. If you can, also send us a listing
(select * from) your current user table. That might give us a cluse what's
up. Again, though, your best bet might be to blow mysql out completely and
reinstall.



>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Ken Thompson
>Sent: Wednesday, February 20, 2002 11:16 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] MySql permissions and configuration
>
>
>On Tuesday 19 February 2002 07:45 pm, you wrote:
>> hmm, strange thing,
>>
>> did you ever set up a password for root?
>Nope defaule install, cant make changes to it even as root..
>> -CUT-
>> % mysqladmin -uroot -P$passwordmysql
>> % mysqladmin --flush-privileges
>> -CUT-
>Tried that, seemed to go OK, no error messages but nothing changed
>> or even deeper, have the privilege-tables already been created?
>> -CUT-
>> % mysql_install_db
>> -CUT-
>Tried tha too, same problem, never have been asked for a password
>for root or
>any other user.
>> if you did that, you might also want to try
>>
>> -CUT-
>> % mysql_fix_privilege_tables
>> -CUT-
>Haven't  tried that one yet, does it require root priv's?
>
>> and, as a last guess, what kind of permissions does your mysql-database
>> directory have (probably /var/lib/mysql and /var/lib/mysql/mysql).
>I did change these and am able to create and modify passwordless
>DB's, still
>denied access as root or other users.
>
>> all the files and directories have to be read&change&writeable for the
>> mysql-user
>>
>> hope it helps ...
>>
>> udo
>>
>> On Die, 2002-02-19 at 07:30, Ken Thompson wrote:
>> > On Monday 18 February 2002 05:41 pm, you wrote:
>> > > hi,
>> > >
>> > > my.cnf is **not** for setting up permissions like who is allowed to
>> > > create/alter/update/etc tables.
>> > >
>> > > if you are not allowed to alter tables, it is **very**
>likely that you
>> > > have to "GRANT" the user you are using to connect to the database the
>> > > relevant permissions:
>> > >
>> > > first log into the database:
>> > >
>> > > -CUT--
>> > > % mysql -uroot -pTheMYSQLRootPasswordYouChose mysql
>> > > -CUT--
>> > >
>> > > then tell the database who is allowed to do what:
>> > >
>> > > -CUT--
>> > > GRANT INSERT,UPDATE,DELETE,.... ON foodatabase.* TO
>$username@localhost
>> > > IDENTIFIED BY "$password";
>> > > FLUSH PRIVILEGES;
>> > > -CUT--
>> >
>> > I still get access denied to [EMAIL PROTECTED]
>> > Even logged in as root eg: mysql -uroot -p
>> > It let's me log in but won't let me do annnything..
>> > FWIW, i un-installed MySql and reinstalled it with urpm(e) & (i), same
>> > problem.
>> >
>> > > that should be it.
>> > >
>> > > greets
>> > >
>> > > udo
>> > >
>> > > On Mon, 2002-02-18 at 23:30, Aron Pilhofer wrote:
>> > > > I think (and don't quote me) you have to create the my.cnf file
>> > > > yourself. I don't think it is required, but mysql will look for it
>> > > > when it launches. Not 100 percent sure about that, but I
>think that's
>> > > > why you aren't finding it.
>> > > >
>> > > > However, the problem you're describing sounds like a permissions
>> > > > issue - what error message are you getting when you try to create a
>> > > > db?
>> > > >
>> > > > >-Original Message-
>> > > > >From: [EMAIL PROTECTED]
>> > > > >[mailto:[EMAIL PROTECTED]]On Behalf Of Ken Thompson
>> > > > >Sent: Monday, February 18, 2002 5:21 PM
>> > > > >To: [EMAIL PROTECTED]
>> > > > >Subject: [expert] MySql permissions and configuration
>> > > > >
>> > > > >
>> > > > >Where are the configuration files for MySql found?
>> > > > >
>> > > > >I've looked everywhere I can think of and still no joy.
>> > > >

RE: [expert] MySql permissions and configuration

2002-02-20 Thread Aron Pilhofer

What do you mean *all* the tables? Look in the directory mysql/data/ if
there isn't anything in there, or the tables that are there - namely, user -
are empty, you found your problem.


>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Ken Thompson
>Sent: Wednesday, February 20, 2002 11:18 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] MySql permissions and configuration
>
>
>
>Another thing that's strange, all the tables in /var/lib/mysql are empty.
>Haven't looked at /usr/lib/mysql yet..
>On Tuesday 19 February 2002 07:45 pm, you wrote:
>> hmm, strange thing,
>>
>> did you ever set up a password for root?
>>
>> -CUT-
>> % mysqladmin -uroot -P$passwordmysql
>> % mysqladmin --flush-privileges
>> -CUT-
>>
>> or even deeper, have the privilege-tables already been created?
>> -CUT-
>> % mysql_install_db
>> -CUT-
>>
>> if you did that, you might also want to try
>>
>> -CUT-
>> % mysql_fix_privilege_tables
>> -CUT-
>>
>> and, as a last guess, what kind of permissions does your mysql-database
>> directory have (probably /var/lib/mysql and /var/lib/mysql/mysql).
>>
>> all the files and directories have to be read&change&writeable for the
>> mysql-user
>>
>> hope it helps ...
>>
>> udo
>>
>> On Die, 2002-02-19 at 07:30, Ken Thompson wrote:
>> > On Monday 18 February 2002 05:41 pm, you wrote:
>> > > hi,
>> > >
>> > > my.cnf is **not** for setting up permissions like who is allowed to
>> > > create/alter/update/etc tables.
>> > >
>> > > if you are not allowed to alter tables, it is **very**
>likely that you
>> > > have to "GRANT" the user you are using to connect to the database the
>> > > relevant permissions:
>> > >
>> > > first log into the database:
>> > >
>> > > -CUT--
>> > > % mysql -uroot -pTheMYSQLRootPasswordYouChose mysql
>> > > -CUT--
>> > >
>> > > then tell the database who is allowed to do what:
>> > >
>> > > -CUT--
>> > > GRANT INSERT,UPDATE,DELETE,.... ON foodatabase.* TO
>$username@localhost
>> > > IDENTIFIED BY "$password";
>> > > FLUSH PRIVILEGES;
>> > > -CUT--
>> >
>> > I still get access denied to [EMAIL PROTECTED]
>> > Even logged in as root eg: mysql -uroot -p
>> > It let's me log in but won't let me do annnything..
>> > FWIW, i un-installed MySql and reinstalled it with urpm(e) & (i), same
>> > problem.
>> >
>> > > that should be it.
>> > >
>> > > greets
>> > >
>> > > udo
>> > >
>> > > On Mon, 2002-02-18 at 23:30, Aron Pilhofer wrote:
>> > > > I think (and don't quote me) you have to create the my.cnf file
>> > > > yourself. I don't think it is required, but mysql will look for it
>> > > > when it launches. Not 100 percent sure about that, but I
>think that's
>> > > > why you aren't finding it.
>> > > >
>> > > > However, the problem you're describing sounds like a permissions
>> > > > issue - what error message are you getting when you try to create a
>> > > > db?
>> > > >
>> > > > >-Original Message-
>> > > > >From: [EMAIL PROTECTED]
>> > > > >[mailto:[EMAIL PROTECTED]]On Behalf Of Ken Thompson
>> > > > >Sent: Monday, February 18, 2002 5:21 PM
>> > > > >To: [EMAIL PROTECTED]
>> > > > >Subject: [expert] MySql permissions and configuration
>> > > > >
>> > > > >
>> > > > >Where are the configuration files for MySql found?
>> > > > >
>> > > > >I've looked everywhere I can think of and still no joy.
>> > > > >Looking in /etc/rc.d/init.d/mysql I found this bit of info,
>> > > > >"# If you want to affect other MySQL variables, you should make
>> > > > >your changes
>> > > > ># in the /etc/my.cnf or other configuration files.
>> > > > >"
>> > > > >Locate doesn't find my.cnf anywhere on my system.
>> > > > >The problem is that I can't use webmin or phpMyAdmin or the CLI to

RE: [expert] databases for linux

2002-02-21 Thread Aron Pilhofer

I won't speak for Alexander, but for my part, I find perl syntax to be
slightly less confusing than Sanskrit. But, in the interests of full
disclosure, I am a total weekend hacker, developing my first big application
right now. I tried to learn perl, but I just couldn't. PHP I just... I don't
know... got. Like right away. It made sense to me, and continues to.
However, the folks I know who really do this stuff for a living all swear by
perl.

I know the PHP community is working on something like CPAN (it's called
PEAR), but perl has been around so much longer that PHP has a lot of
catching up to do in that regard. I don't know... I'm getting better and
better at this stuff, so once I am done with this project, maybe I'll make
another stab at perl.

My 2 cents.

>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Rob
>Sent: Thursday, February 21, 2002 4:46 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>On Wednesday 20 February 2002 20:57, Alexander Skwar wrote:
>
>> And while I also very much love PHP (and despise Perl for web
>> development), it's also very easy to switch the DB backend in Perl,
>> thanks to the nice DBI package.
>
>Why do you despise Perl then ?
>No flame wars please.
>Just intrested.
>I have used Perl, PHP, VB, & Java for web programming and currently favour
>perl (in its embedded mod_perl form) but have probably spent the most time
>with Java. I find Perl quick and easy to get simply things
>running. Ditto PHP.
>But when I want to start doing more complicated things like say building
>up class libraries or processing XML messages via SOAP then Perl
>still lets
>me via modules in CPAN but thats not the same for PHP.
>Course I might be missing something re PHP, love to learn more if I am.
>
>Rob
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-21 Thread Aron Pilhofer

I don't think that's right, Alexander. Transactions, yes, but I have heard a
lot of complaining about how they implimented it . (It's not a feature I
care about, so I really have not paid a lot of attention...) None of the
other stuff is in the current stable version. 3.23.4x. They aren't in the
beta 4.x yet either, and aren't scheduled to be implimented until 4.1 (read:
anytime soon, if ever). There's some nice new stuff in the 4.x beta - but it
is still that, beta.


>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Alexander Skwar
>Sent: Thursday, February 21, 2002 7:04 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>»Joseph Braddock« sagte am 2002-02-20 um 19:16:20 -0600 :
>> I'd have to concur with Rob.  Postgres seems to be a very
>feature rich and stable database.  We are looking to moving some
>of our Oracle databases to it.  MySQL seems to get much more
>press, but it simply lacks many features required for serious
>database use (stored procedures, transactions, sub-selects, etc).
>This is not intended to start a Postgres vs MySQL war (as both
>have zealots).  MySQL is very good at the things it does.  But
>because of it's limitations, it doesn't fit our specific needs.
>>
>
>Well, MySQL *has* transactions and stored procedures (not as good as
>Oracles, though).  And I think sub-selects are also available in 4.x,
>no?
>
>
>Alexander Skwar
>--
>How to quote:  http://learn.to/quote (german) http://quote.6x.to (english)
>Homepage:  http://www.iso-top.de  | Jabber: [EMAIL PROTECTED]
>   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
>   Uptime: 4 hours 47 minutes
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-21 Thread Aron Pilhofer

I'd call myperl more of a third-party workaround than true stored procedure
support, but it looks interesting. Thanks for the tip. That's the one
feature I really, truely need. There is no support for subqueries, that I
know.


>-Original Message-
>From: Alexander Skwar [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, February 21, 2002 10:22 AM
>To: Aron Pilhofer
>Cc: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>»Aron Pilhofer« sagte am 2002-02-21 um 09:45:54 -0500 :
>> I don't think that's right, Alexander. Transactions, yes, but I
>have heard a
>
>What's not right?  Depending on the table there are transactions - but I
>also haven't used 'em.  And stored procedures are available in the form
>of myperl - which I also haven't used.
>
>Alexander Skwar
>--
>How to quote:  http://learn.to/quote (german) http://quote.6x.to (english)
>Homepage:  http://www.iso-top.de  | Jabber: [EMAIL PROTECTED]
>   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
>   Uptime: 8 hours 5 minutes
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-21 Thread Aron Pilhofer

That's basically right. There's still a feeling out there that MySQL is the
faster database for selects and such, though I have seen benchmarks all over
the board on that. And it is quite clear that with version 7.1 (I believe)
Postgres has at least closed that speed gap considerably.

In terms of transactions *please someone who cares about such things correct
me if I am wrong* MySQL should catch up with Postgres very, very soon.

In terms of features, again, there really isn't any possible debate here:
Postgres has the best feature set of the two, hands down - views and
triggers are the big ones on my wish list for MySQL. I think the only thing
MySQL does (that I care about) that Postgres doesn't is full-text indexing,
though I may be wrong about that.

The only thing preventing me from switching to PG is the lack of a Windows
version (I know, I know...), which, for reasons I won't get into here,
simply eliminates PG as an option for me - at least for the applications I
am working on.





>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Rob
>Sent: Thursday, February 21, 2002 8:30 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>
>> »Joseph Braddock« sagte am 2002-02-20 um 19:16:20 -0600 :
>> > I'd have to concur with Rob.  Postgres seems to be a very feature rich
>> > and stable database.  We are looking to moving some of our Oracle
>>
>> Well, MySQL *has* transactions and stored procedures (not as good as
>> Oracles, though).  And I think sub-selects are also available in 4.x,
>> no?
>>
>
>I read an intresting (but admitidly possibly wrong) document some time
>ago comparing MySQL and Postgres.
>MySQL was seen to be an SQL frond end/interface to a file based
>system giving
>very very quick select access, but lacking high end features.
>Wheras Postgres was seen to be a slower but more feature rich system.
>I have since seen recent stats (I know - you can make em say what ya want)
>comparing the latest greatest postgres that shows it competing on
>speed with
>MySQL on selects.
>But back to this article I read and transactions.
>The main difference had something to with Atomic transactions I think.
>It was kinda saying that MySQL's transactions were a surface level
>function only causing horrible things to happen within the DB and risking
>all sorts of corruption should something go wrong with the DB during the
>transaction whereas Postgres's transactions were atomic (lots of detail
>about what that meant but I forget) giving it extra marks for reliability.
>
>Rob
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] databases for linux

2002-02-22 Thread Aron Pilhofer

>Why not? At best its just a "compatibility" DLL that allows easier
>migration between Unix and Windows. For specific applications you don't
>need the full Cygwin install, though you do get a great set of tools
>with it. I use Cygwin to allow a common build environment that works
>seamlessly on Solaris, Linux and Windows/Cygwin.

Didn't know you didn't need the full install, so I'll definitely give that a
try in the future. I'd love to have a version of PG running on my windows
partition. The full package is (as I remember) quite large, and not
particularly friendly for those folks who are not Linux/unix friendly. It
also seemed to run (how to put this) a little weird on my system, and that
was enough to make me skeptical.

The absolute killer for the app I am developing is that first part: there's
no way I can put this out there and require folks  to figure out cygwin and
then postgres. Just ain't going to happen. But I'm not locking myself into
windows - good god no! Banish the thought.

I happen to be writing my application in PHP with an excellent database
abstraction layer, so it will (theoretically) work on any supported
platform, with any one of seven different databases, including Postgres.
That's the open source way. :)


>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Nick Thompson
>Sent: Friday, February 22, 2002 11:08 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [expert] databases for linux
>
>
>Why not? At best its just a "compatabilty" DLL that allows easier
>migration between Unix and Windows. For specific applications you don't
>need the full Cygwin install, though you do get a great set of tools
>with it. I use Cygwin to allow a common build environment that works
>seamlessly on Solaris, Linux and Windows/Cygwin. Seems pointless redoing
>all your hard work for a backwards (closed) system like Windows when
>somebody else has done excellent work doing it for you. Thats the open
>source way...
>
>Nick.
>
>Aron Pilhofer wrote:
>
>>I knew someone was going to mention Cygwin. I've played with it some, but
>>wouldn't under any circumstances consider deploying anything critical that
>>requires it. There are times I wish free software folks were a little less
>>dogmatic, because I think a stable Win32 version of Postgres would be one
>>killer application.
>>
>
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: RE: [expert] Remote backup Again

2002-02-22 Thread Aron Pilhofer

Yes, but I am 99 percent sure that license does not cover as many boxes as he needs to 
backup. 

>-Original Message-
>From: Jim Dawson [mailto:[EMAIL PROTECTED]]
>Sent: Friday, February 22, 2002 12:34 PM
>To: [EMAIL PROTECTED]
>Cc: [EMAIL PROTECTED]
>Subject: Re: RE: [expert] Remote backup Again
>
>
>If I am not mistaken, Arkeia has a 'Free for personal use' version as well.
>
>-Original Message-
>From: "Aron Pilhofer" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Date: Thu, 21 Feb 2002 11:28:59 -0500
>Subject: RE: [expert] Remote backup Again
>
>Arkeia does that, but you probably need a license, which is pricey.
>http://www.arkeia.com/
>
>Mondo may be able to do it too. (Just posted the URL.)
>
>
>
>
>>-Original Message-
>>From: [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED]]On Behalf Of Belkie, Dan
>>Sent: Thursday, February 21, 2002 11:05 AM
>>To: '[EMAIL PROTECTED]'
>>Subject: RE: [expert] Remote backup Again
>>
>>
>>Hi guys!
>>Thanks for the help,
>>
>>But im looking for something that can remotely back up data from 
>>windows and
>>Linux boxes. Maybe just a simple FTP? I need to automate it and 
>>would prefer
>>not to have to set up automated FTP clients on each box.
>>
>>Right now I only need data from 4 or 5 boxes (4 windows and 1 Linux), but
>>need to be able to manage about 25 or so in the future.
>>
>>
>>Thoughts?
>>
>>--
>>=
>>Dan Belkie
>>
>>
>>
>>-Original Message-
>>From: Randy Kramer [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, February 20, 2002 6:52 PM
>>To: [EMAIL PROTECTED]
>>Subject: Re: [expert] Remote backup
>>
>>
>>Belkie, Dan wrote:
>>> Can anyone recommend any data backup server software for Linux?
>>> 
>>> I would like to remotely back up my office computers to my home through
>>the
>>> night. I would like to only update the data that has changed.
>>> 
>>> Anyone know of anything like this?
>>
>>Look into rsync.  It's what I plan to use for a similar purpose.  I have
>>some information here, including (I hope) a link to the rsync home page.
>>
>>http://twiki.org/cgi-bin/view/Wikilearn/RsyncInGeneral
>>
>>If you find some better resources, or want to make some notes for others
>>to use, consider registering at
>>http://twiki.org/cgi-bin/view/TWiki/TWikiRegistration and editing or
>>creating pages yourself.
>>
>>Randy Kramer
>>
>>
>>
>
>
>_
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>
>



_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] Fine I give up on everything

2002-02-22 Thread Aron Pilhofer

..[snip]..
>I WILL RECOMEND AGAINST SIGNING UP

That's recommend... with two M's. Bye, nice to know you.





_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] Mandrake 8.2 BETA3

2002-02-25 Thread Aron Pilhofer

nope, worked for me just fine.

BTW, Beta 3 picked up my Radeon 8500 right away, and set the right
settings... first time that's happened yet since the release of the new
XFree, so, this is very good news for Radeon owners who aren't wanting to
farble around with Xfree to get 'drake working right.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ralph Crongeyer
Sent: Sunday, February 24, 2002 5:17 PM
To: [EMAIL PROTECTED]
Subject: [expert] Mandrake 8.2 BETA3


Hase anyone else had problems with disk 2 of 8.2 BETA3?  I downloaded both
images and the md5sum file and both images checked out against the file, so
I burned them. But The second disk (with 30 seconds left and only 7 packages
left to install) hangs.

Just wanted to know If anyone else is having problems with disk 2 before I
download it again.

Ralph
--




__
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/




_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] Kudos

2002-03-02 Thread Aron Pilhofer

Not to be rude, but... yes, I'd hate for you to be pedantic too. This is an
informal list. Let's keep it that way, eh?

Thanks.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Deryk Barker
Sent: Saturday, March 02, 2002 1:04 PM
To: [EMAIL PROTECTED]
Subject: Re: [expert] Kudos


Thus spake James ([EMAIL PROTECTED]):

> All,
>
>To the developers at Mandrake Kudo's all around.

I hate to be pedantic, but "kudos" is a) singluler b) all lower
case. It's from the Greek.
--
|Deryk Barker, Computer Science Dept. | Music does not have to be
understood|
|Camosun College, Victoria, BC, Canada| It has to be listened to.
|
|email: [EMAIL PROTECTED] |
|
|phone: +1 250 370 4452   | Hermann Scherchen.
|





_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] Help! No lilo - no nothing!

2002-03-04 Thread Aron Pilhofer

You probably didn't install it on the MBR.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Eduardo M. A. M.
Mendes
Sent: Sunday, March 03, 2002 11:24 PM
To: [EMAIL PROTECTED]
Subject: [expert] Help! No lilo - no nothing!


Hello

I have installed linux Mandrake on my notebook.  The installation went fine
(some errors with tcl-8.3 and xpdf rpm files) but I can't boot the system
via
lilo.   I have Windows Xp Home Edition and Mandrake 8.2beta (don't call me
crasy please) on the machine.

I can run LM 8.2 if I use the boot diskette (it didn't skip this step).
LM 8.2 is running ok. I can't run Xp since I have no boot diskette for the
OS.

How can I fix lilo so as to have a dual boot?

My notebook is Sony VAIO.

Many thanks

Eduardo




_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



RE: [expert] Help! No lilo - no nothing! (odd solution)

2002-03-04 Thread Aron Pilhofer

Well, that's a new one. How interesting... it's nice to know, though. Thanks
for reporting back.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Eduardo M. A. M.
Mendes
Sent: Monday, March 04, 2002 10:04 AM
To: [EMAIL PROTECTED]
Subject: Re: [expert] Help! No lilo - no nothing! (odd solution)


Hello

Thanks for the help.

a) I did install lilo at least a dozen times (playing compact. lba, linear,
menu etc.).

b)  I managed to get  the menu at boot time by removing the batttery and
putting it back again.  Yes, somehow SONY doesn't like changes on lilo, so
by
removing any kind of power suppy from the notebook SONY's "memory" is lost
and lilo changes are accepted.

The only problem is something funny characters just before the word boot:.
I
have nmo idea what causes that.

Many thanks

Ed




On Monday 04 March 2002 08:08 am, you wrote:
> You probably didn't install it on the MBR.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Eduardo M. A. M.
> Mendes
> Sent: Sunday, March 03, 2002 11:24 PM
> To: [EMAIL PROTECTED]
> Subject: [expert] Help! No lilo - no nothing!
>
>
> Hello
>
> I have installed linux Mandrake on my notebook.  The installation went
fine
> (some errors with tcl-8.3 and xpdf rpm files) but I can't boot the system
> via
> lilo.   I have Windows Xp Home Edition and Mandrake 8.2beta (don't call me
> crasy please) on the machine.
>
> I can run LM 8.2 if I use the boot diskette (it didn't skip this
step).
> LM 8.2 is running ok. I can't run Xp since I have no boot diskette for the
> OS.
>
> How can I fix lilo so as to have a dual boot?
>
> My notebook is Sony VAIO.
>
> Many thanks
>
> Eduardo
>
>
>
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com




_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com