RE: [expert] Help! No lilo - no nothing!
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)
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
RE: [expert] Kudos
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] Mandrake 8.2 BETA3
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] databases for linux
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
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
..[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] databases for linux
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
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
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
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
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
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
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
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 readchangewriteable 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 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 G. -- 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 -- 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 Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com -- Ken Thompson, North West Antique
RE: [expert] MySql permissions and configuration
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 readchangewriteable 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 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 G. -- 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 -- 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 Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com -- 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
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
RE: [expert] MySql permissions and configuration
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 G. -- 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