Re: Re MySQL on Redhat 7.3
Peter Goggin [EMAIL PROTECTED] writes: I have installed all of the RPMs for MYSql from the 7.3 distribution from the Next handbooks, but now need to get mysql started. As far as I can tell the manual only talks about binary (not RPM) and sourceinstallations. Is there a set of instructions on how to get mysql started and configured after installing from the RedHat 7.3 CDS? If so where are they? Just start it like any other service: service mysqld start (and use chkconfig mysqld on if you want it to start at boot) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting up a web server wit Redhat 7.3
Peter Goggin [EMAIL PROTECTED] writes: So far as I can tell the mysql files included in the CD set are: mysql-3.23.49-3.i386.rpm mysqlclient9-3.23.22-6.i386.rpm mysql-devil-3.23.49-3.i386.rpm mysql-server-3.23.49-3.i386.rpm Do these files include Innodb support? Yes. Are they sufficient to install mysql? Yes. You don't need the mysqlclient9 package, it's a compat library we ship since the libmysqlclient library was bumped after the release of RHL 7 and we needed existing programs to continue working. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql gcc 3
Lenz Grimmer [EMAIL PROTECTED] writes: On Tuesday 20 August 2002 10:33, Marc Roos wrote: When will testing be finished of compiling mysql with gcc 3? We already successfully compiled MySQL with gcc 3.1 and have just started some tests with gcc 3.2 - so far it looks good... Gcc 3.2 does not work properly with mysql without a patch... we just found a problem in the compiler which affected mysql - C++ programs/libs could in the default -fuse-cxa-atexit mode have some objects destroyed multiple times and some never. Look for changes to decl.c (touching interface_only) in gcc CVS. Not sure if this was a problem with 3.1 as well... 2.96RH should be safer, at any rate, but doesn't have all the features from 3.2. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: graphical interface to mysql on red hat 7.3
Desmond Lee [EMAIL PROTECTED] writes: Hi there I'm doing fine with the command line interface of mysql, no complaints from me. Howerver, another team member who knows nothign about mysql is more familiar with the windows stuff like access. Is there an graphical interface for mysql on red hat v7.3? I figured i'd ask here because this is the most direct and helpful way since there are a lot of guys (and gals) with mysql experience. Try tora, it's included with RHL 7.3 -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL: Problem Installing on RH 7.3
Philip Molter [EMAIL PROTECTED] writes: On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote: : The mysqld.log file says: : : 020717 13:05:05 mysqld started : 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: : './mysql/host.frm' (errno: 13) : 020717 13:05:05 mysqld ended : : But I do see the host.frm file: : : -rw-rw1 root root 8958 Jul 17 13:04 : /var/lib/mysql/mysql/host.frm : : How did you fix this problem? Permissions are wrong. MySQL typically runs as mysql:mysql, not root:root. If I remember correctly, there may have been a problem with the setup scripts that handled this. Check the RH bug reports. The fix is simply to change owner/groups on the necessary files/directories. But Trond can give you specifics. It still may be user error. :) If memory serves... There were some permission problems in RHL 7, fixed in an errata a couple of days after release. The most common problem for a while was people running mysql_install_db as root - the dbs will be created, but owned by root. The database doesn't run as root, and can't write to it. There has been a workaround for that in the initscripts as well. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in rpm from RH 7.3
[EMAIL PROTECTED] writes: En réponse à Jan Kudrman [EMAIL PROTECTED]: I've found it on the online documentation of MySQL.org with comments of user. Since I've replaced the RP of RH 7.3 by RPM of MySQL.org, I don't have any problem No known RH-specific bugs with the MySQL rpms shipped with RHL 7.3 - we've received one report on database corruption, but the had it happen with the ones from mysql.com too when he switched. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL load problems - gcc-2.96?
Mike Robinson [EMAIL PROTECTED] writes: Thanks for your note. You wrote: There are known problems with gcc-2.96 which comes with RH 7.2 distribution. There is disclaimer about it at www.mysql.com/downloads/mysql-3.23.html as you noticed. There is much reading on the GCC 2.96 issue. There seems to be two paths of dicussion. I mention them here with all due respect. The first path is the one I subscribed too when I first got bit on the hindside by this. Basically, the gcc people forked 2.95.2 and it became 2.96. Only, it really wasn't 2.96. The version number 2.96 wasn't actually a version number, rather, the _codename_ for the development branch. I found this whole statement ludicrous. At this point, I figured it was a huge GCC problem that RedHat got sucked into. That sorry excuse for an official statement can be found here: http://gcc.gnu.org/gcc-2.96.html There is no official RedHat position that I can find. I did find this though: http://www.bero.org/gcc296.html does a good job of it, so we decided not to fuel more flamewars. FWIW, reproducible testcases are good... all complex software products have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in interaction with oneanother (e.g. timing/locking issues), so reproducible testcases are a necessity. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL load problems - gcc-2.96?
[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes: FWIW, reproducible testcases are good... all complex software products have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in interaction with oneanother (e.g. timing/locking issues), so reproducible testcases are a necessity. FWIW, it might be worth trying to rebuild the rpms with --disable-assembler. The assembler has had problems in the past in conjuction with compiler optimizations. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help! Error building 4.0.2 under RH Linux 7.2
crashke [EMAIL PROTECTED] writes: Hi Vadim, I don't know but have you read the instructions on the Mysql-website? gcc 2.96RH is a known good and stable compiler, no matter what FUD the site might claim. The below looks like broken code, plain and simple: Lack of declarations. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrade of mySQL on a Red Hat 7.2 - box
Shaun Bramley [EMAIL PROTECTED] writes: Ladies and Gentleman of the list, I have been a member of the list for about two weeks now and I must say that I have learned a lot. Needless to say I am relatively new to the whole db scene. My question is that I installed mySQL onto my linux box (Red Hat 7.2) as part of the installation. I am currently running 3.23.42?? I would like to upgrade my installation to the latest and greatest, however: a) I do not know which files I have to download server, libraries, benchmark/test suites, etc. You can download a newer edition from http://people.redhat.com/teg/mysql/ Just download them and do a rpm -Fvh mysql*i386.rpm afterwards - you'll have replaced the old rpms with newer ones. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.50 client needs IP addresses
Sinisa Milivojevic [EMAIL PROTECTED] writes: [EMAIL PROTECTED] writes: Description: mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: ERROR 2005: Unknown MySQL Server Host 'xxx' (2) Submitter-Id: submitter ID Originator:Rob Steele Organization: FatKat, Inc. MySQL support: none Synopsis: 3.23.50 client needs IP addresses Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.50 (Official MySQL RPM) Hi! The above problem is not caused by any changes in 3.23.50 source. It is caused by having glibc built statically with binaries. Static binaries are a bad idea, and should be reserved for special cases only (recovery binaries, for instance). Things like username and host lookup will suffer otherwise. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pre-release of MySQL 3.23.50
Philip Molter [EMAIL PROTECTED] writes: On Tue, Apr 23, 2002 at 10:26:04AM +0300, Michael Widenius wrote: : : Hi! : : 3.23.50 is basicly just a bug fix release compare do 3.23.49a : : There is however two things one should be aware of regarding 3.23.50 : (both only affecting our Linux x86 binaries (normal and RPM's): : : - We have switched to a new updated glib library, because we found a : critical memory corruption bug (introduced by us) in the old glibc : library that we used to compile 3.23.49. : (older MySQL binaries are not affected by this problem) : - We have changed compiler to gcc 3.0.4 (because the old gcc compiler : we used couldn't compile with an alternative glibc library). Does this affect people who compile MySQL on their own on Linux? If I have my RH7.2 box and I compile my own version of MySQL, am I going to hit these memory corruption issues? No, as we don't use a glibc patched in this way. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and GCC
Barry Blatz [EMAIL PROTECTED] writes: I have a system here based on Red Hat's 7.2 distribution and I am wanting to get MySQL up and running. After browsing your web page it seems that I will have go to a different version of gcc. Not recommended, the most stable gcc-based compiler around FTTB is 2.96RH. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RH 7.2 - mysql Problem !
Ian Linekrans [EMAIL PROTECTED] writes: Hi All ! The configuration: - Redhat 7.2 (Enigma) pre-build installation. - Mysql with the following rpms installed: MySQL-3.23.49a-1.i386.rpm MySQL-client-3.23.49a-1.i386.rpm The installation and connection as root to the database server works fine but when changing the root password according to all the different ways as described by mysql manuals and then trying to reconnect results in the following error : ERROR 1045: Access denied for user: 'root@localhost' (Using password YES) Segmentation fault The same error message appears when changing the password for an another user in the database. Note if no password is set everything works fine ! Soo whats is the deal !!! Anyone who has the same problem - feel free to contact me if you have a solution. You're using mysql rpms from MySQL - use the ones from Red Hat, they are known to work well. You should also be able to copy over the ones from the Skipjack beta and use them - they are the latest version (49a doesn't seem to be a tarball release, it was made because the binaries were bad AFAIK. Wasn't a problem for us). -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Sommai Fongnamthip wrote: If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? Sommai No, they should be fine. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Ireneusz Piasecki [EMAIL PROTECTED] writes: Hi. I have question. U have RH6.2 Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with 2.96 ? I would definitely recommend 2.96RH, as it has fixed many bugs from egcs. It also has far better C++ standards compliance, but that's not an issue here. It's probably still the most stable gcc available at this point... -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Michael Stassen [EMAIL PROTECTED] writes: On Fri, 8 Mar 2002, Trond Eivind Glomsrød wrote: On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake I find this rather unhelpful, as it really doesn't answer the question. I understand that as a RH representative, you stand by the decision to use gcc 2.96, but no matter how wonderful you think it is, the MySQL directions explicitly state not to use it, because Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. None of these have been brought to our attention or documented. Note that the official ones use a different, statically linked version of glibc as well as a very old compiler. Has this issue been resolved? If so, the directions should be updated. If not, I question the helpfulness of advising people to ignore the directions. I have no interest in the arguments over whether 2.96 was a good idea or not, and I take you at your word when you tout the merits of 2.96, but that's not the question here. The question is which compiler to use for *mysql*. The list of people with stable copies of mysql compiled with gcc 2.95.3 is long, and it includes people who had problems with copies compiled with 2.96. Personally, I have no idea whether that's because of a flaw in gcc 2.96 or in mysql, but it's a moot point until it's found and fixed. Has it been? No issues in interaction between gcc 2.96RH and MySQL has been identified since just after the release of Red Hat Linux 7 a year and a half ago (we submitted fixes for these to the MySQL team, and they have been included since the 3.23.midtwenties or so). A generic issue with MySQL is that MySQL seems more stable when compiled with -fno-rtti -fno-exceptions regardless of the compiler version. The newest rpms at http://people.redhat.com/teg/mysql/ are compiled that way, older ones aren't. Still haven't heard of any issues or experience any myself. FWIW, I've ran quite a few tests (the regression tests, the benchmarks etc) with no stability problems whatsoever. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
*mysql, to please stupid filter* On Wed, 6 Mar 2002, Trond Eivind Glomsrød wrote: On Wed, 6 Mar 2002, Ireneusz Piasecki wrote: Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? As I told you, that's a very bad idea. Very bad. I don't would like to change to RH 7.2 You're introducing a _lot_ more risk by just upgrading that part of the system. Upgrading to RHL 7.2 should be painfree, upgrading just glibc will be painful. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Ireneusz Piasecki [EMAIL PROTECTED] writes: Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. Don't do it. You will do bad things to your system. If you want to upgrade to a newer glibc, upgrade it all (newer versions of RHL has mysql included, too :) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Dr. Michael Wittmann [EMAIL PROTECTED] writes: one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's Everyone on RHL 6.2 should be running rpm v4 - if not, they are extremely likely to have plenty of unpatched security holes. besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... I would definitely recommend against a major upgrade, e.g. to 2.2. Sizes and interfaces change, so that while old binaries will continue working, anything compiled afterwards will get in a world of pain. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
John Dean [EMAIL PROTECTED] writes: Hi All you need to do is include a symlink on libmysqlclient.so.11 to point to libmysqlclient.so.10 e.g ln libmysqlclient.so.11 libmysqlclient.so.10 Not a good suggestion for libraries in general. If a library so name has changed, it means it not compatible. Install the older library in addition -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql 4.01 and libmysqlclient.so.10
Ronald Arenas [EMAIL PROTECTED] writes: I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? libmysqlclient.so.10? libmysqlclient.so.11 is not compatible with libmysqlclient.so.10 -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Beware: 2GB was the problem!
Sinisa Milivojevic [EMAIL PROTECTED] writes: Steve Rapaport writes: Thanks to the guy who pointed this out. For the information of others, yes, it's quite possible to have a machine with mysql table files 2GB lying about on the disk, that still doesn't properly support them. I had thought that if Mysql could create a 3GB file, it could use it. Bad assumption. This can get very confusing when Mysql uses these files then occasionally finds them corrupt for no apparent reason, then can't fix them. If your Index or database file approaches 2GB, and you are not CERTAIN that your file system and kernel both support LFS (Large File Support/Summit), you too may have inexplicable problems query, mysql, table -steve MySQL's limitation for file sizes on 32 bit systems is 1 Tb. All other limitations stem from filesystem limitations and MAX_ROWS limitations. Note that unrecommended usage of old compat compilers w/old compat glibc (egcs+glibc 2.1) may lead to this not working properly. MySQL needs to use current libraries with specified flags in order to use the *64 functions. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql installation on linux(RH7.2)
nagendra prasad [EMAIL PROTECTED] writes: hi i downloaded mysql rpms from mysql.com tried to install them on linux. when i use the command rpm -i mysqlpackname in shell it says error:can't get exclusive lock on /var/lib/rpm/packages error:can't open packages database in /var/lib/rpm what shall i do. Install as root. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 3.23.49-1 rpm fails with redhat 7 thu 7.2
[EMAIL PROTECTED] writes: The latest rpms for mysql 3.23.49 produce a signal 4 error when attempting to run the installed mysql server. on all our servers running redhat 7 thru 7.2. Obviously this can't be a kernel 2.2.x issue, since 7.2 is on 2.4.x. I've tried multiple installs now with no success on any of our servers running the above O/S. This effects new installs of redhat, as well as existing ones while upgrading over a previous version of mysql. Which rpms? The ones from mysql.com? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql 4.0 or 3.23 with innodb?
Varshavchick Alexander [EMAIL PROTECTED] writes: Gentlemen, Can you advice please if I'd wish to change the database format from myisam to innodb should I upgrade to mysql 4.0 to get better performance and stability, or switching to innodb alone under 3.23 will do the trick? Switching to 4.0 for stability doesn't seem like a good idea - it's still in development, and classified as alpha. The 3.23 series has been around a lot longer, and is stable. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.49-1.rpm on RH 7.2 probs?
S. William Schulz [EMAIL PROTECTED] writes: Hello, I just upgraded mysql to 3.23.49 using the rpm's. I had been running 3.23.45 for many months now without a problem on a RH 7.2 box logging snort data (so it had moderate load). Which rpms? RPMs from RH (not supported, it's just the Rawhide package built on a RHL 7.2 environment) can be found at http://people.redhat.com/teg/mysql/ -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysql 3.23.49 rpm install
Ireneusz Piasecki [EMAIL PROTECTED] writes: Hi. I want upgrade mysql from 3.23.48 to 3.23.49 but i see that. first. shared # /usr/lib/mc/extfs/rpm run /home/httpd/MySQL-shared-3.23.49-1.i386.rpm UPGRADE Upgrading /home/httpd/MySQL-shared-3.23.49-1.i386.rpm error: failed dependencies: libc.so.6(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 libpthread.so.0(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 Press any key to continue... second. mysql server but ocurrs some strange errors. My system is RH 6.2 The rpm needs glibc 2.2. RHL 6.2 is glibc 2.1. Upgrade Red Hat Linux (upgrade of glibc on its own is highly discouraged) or rebuild the SRPM on your system. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Linux, Athlon MP stability?
Tobias Lind - Telia Internet [EMAIL PROTECTED] writes: Hello! I'm in the process of upgrading my Linux-server (currently a dual P2-400MHz), and have been thinking about getting a system with dual Athlons (maybe 2x Athlon MP 1800+). Does anyone have any experience (good or bad) with a dual Athlon system with Linux running MySQL 3.23.x, and maybe Apache under HEAVY load? Our kernel people love them - Athlon goodness, no VIA chipset. Good performance, good stability. Since the Athlon MP's haven't been around for very long, I'm a bit concerned about the stability under heavy load on the 2.4 kernel... Ve've supported it since RHL 7.1 (which was released before the Athlon MP, if memory serves :). So please, if you have a success- or disaster-story I'd like to know! :) I'm also very interested in what mainboard you are using for the Athlons, and what Linux-kernel version you're running... Red Hat Linux, various release and test versions (kernel and surrounding OS). -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: It's enabled in the MySQL rpms we distribute as part of RHL as well, but it's not the default type for created tables. Thus, most people won't be using it. If memory serves, you need to set various options in order to use it as well. I do not want to sound touchy, touchy, but that is as saying, that e.g. SyBase does not have replication everywhere, as you have to set it with various options. And SyBase has practically invented RDMBS replication, if my memory serves me well. There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Configure-options for compiled MySQL?
John Ericson [EMAIL PROTECTED] writes: I've a compiled MySQL and I need to know if it support unixODBC (Is configured with --with-unixODBC=...). Is there anyway I can see which configure options that was used to produce the binary? Look for MyODBC - there is a link at the MySQL web page (it's also included in RHL 7.2) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Old Messages
Van [EMAIL PROTECTED] writes: Greetings: Anyone else getting lists messages from several days, or longer ago? Phrrrp!: sql database table mysql Same here. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. This depends on the definition. Where do you draw your definitions from ?? And core SQL functionlity that we speak about IS present. Transactions are present, but not in the default table type (MyISAM). My understanding is that this will change in MySQL 4. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Configure-options for compiled MySQL?
John Ericson [EMAIL PROTECTED] writes: I've a compiled MySQL and I need to know if it support unixODBC (Is configured with --with-unixODBC=...). Is there anyway I can see which configure options that was used to produce the binary? Look for MyODBC - there is a link at the MySQL web page (it's also included in RHL 7.2) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. But MySQL has transactions and foreign keys. I said everywhere - you need to use Innobase to get foreign keys, and innobase/db3 to get transactions. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: I said everywhere - you need to use Innobase to get foreign keys, and innobase/db3 to get transactions. As EVERY binary and source we distribute has InnoDB in it, then we have transactions and foreign keys everywhere. It's enabled in the MySQL rpms we distribute as part of RHL as well, but it's not the default type for created tables. Thus, most people won't be using it. If memory serves, you need to set various options in order to use it as well. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: It's enabled in the MySQL rpms we distribute as part of RHL as well, but it's not the default type for created tables. Thus, most people won't be using it. If memory serves, you need to set various options in order to use it as well. I do not want to sound touchy, touchy, but that is as saying, that e.g. SyBase does not have replication everywhere, as you have to set it with various options. And SyBase has practically invented RDMBS replication, if my memory serves me well. There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. This depends on the definition. Where do you draw your definitions from ?? And core SQL functionlity that we speak about IS present. Transactions are present, but not in the default table type (MyISAM). My understanding is that this will change in MySQL 4. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libc6 binary same as i686?
Steve [EMAIL PROTECTED] writes: I'm trying to pick the best path, but between this older K62 and the warning about gcc 2.96, I'm having trouble :) (I'll be using a K62 with RH7.1) The rpms here http://people.redhat.com/teg/mysql/ should work just fine (they're built in a RHL 7.2 environment, but don't think mysql uses anything which changed). -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6
On Wed, 23 Jan 2002, Jim Lucas [jimmysql] wrote: But I am installing all the apps from the RPM's that came from Redhat.com The apps coming from Red Hat Linux work together. You have downloaded and installed a different (development ) version of MySQL. It's not compatible with the old one. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6
On Thu, 24 Jan 2002, Jim Lucas [jimmysql] wrote: Is this what you had to do? No, I don't do it. If you stay with the stable version of MySQL, you avoid this problem. MySQL 4 will show up in Red Hat Linux (at least the development tree when it's declared the) stable branch, and applications will be recompiled. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6
On Thu, 24 Jan 2002, Shankar Unni wrote: Should we take this offline? The Redhat packaging for MySQL calls it mysql (lowercase). MySQL AB's packaging calls it MySQL (upper/mixed case). The layout in each of those packages is quite different. But that wasn't the problem. So version 3.23.41 (the one in RH 7.2) from Red Hat is quite different from the same version (3.23.41) from MySQL AB. So the development thing is a red herring. No, it wasn't - the problem was libmysqlclient.so.10 vs libmysqlclient.so.11 -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing Mysql 4.0.1 on Redhat 7.2 with PHP 4.0.6
Jim Lucas [jimmysql] [EMAIL PROTECTED] writes: When I tried installing MySQL 4.0.1 it said that I had conflicts. It listed the file libmysqlclient.so.10 as being needed by 5 different progs. [root@office2 RPMS]# rpm -Uvh MySQL-shared-4.0.1-2.i386.rpm error: failed dependencies: libmysqlclient.so.10 is needed by mod_auth_mysql-1.11-1 libmysqlclient.so.10 is needed by MyODBC-2.50.37-2 libmysqlclient.so.10 is needed by MySQL-python-0.9.0-2 libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4 libmysqlclient.so.10 is needed by php-mysql-4.0.6-7 now, I went ahead an ran the command with the --nodeps option. now php doesn't know any mysql funciton commands. You can do that, but those apps won't work anymore. I tried reinstalling all my PHP stuff and when I got to php-mysql-4.0.6-7.i386.rpm I got this [root@office2 RPMS]# rpm -Uvh php-mysql-4.0.6-7.i386.rpm error: failed dependencies: libmysqlclient.so.10 is needed by php-mysql-4.0.6-7 The warning was there for a reason. I did some searching and come to find out. the file didn't exsist, but one called libmysqlclient.so.11 did. Which is not so.10, which is what the apps are linked against. Shouldn't it recognize this as a newer file and use it instead, or am I missing something here? Yes - this isn't how it works. You need to recompile all the apps, as the library is different. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Suse V/S Redhat - mysql performance difference.
Jatin Nansi [EMAIL PROTECTED] writes: Hi list, I have 2 servers 1 running redhat 7.2 and the other running suse 7.3. the hardware config is : RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz). Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM). Now i expect to see the suse server go faster than RH, but i am having the reverse happening. The RH server returns a query about 5 times faster. For eg: on RH: mysql select straight_join docm.document_id, docm.document_title, docm.document_date, sources.source_name, cliptypes.cliptype, byline.byline from keywords, documents_7 as docm use index (PRIMARY), dockeys_7 as dock, sources, cliptypes, byline where keywords.keyword_id=dock.keyword_id and docm.document_id=dock.document_id and docm.document_source_id = sources.source_id and docm.document_cliptype_id = cliptypes.cliptype_id and docm.document_byline_id = byline.byline_id and ( keywords.keyword=assam ) order by docm.document_id; Lots of results | 219401 | WRONG POLICIES ARE THE BANE OF ASSAM | 2000-08-21| THE HINDUSTAN TIMES (DELHI)| N. A.| PARASHAR, UTPAL| +-+--+---++--++ 276 rows in set (2.78 sec) same query on suse: Lots of results | 219401 | WRONG POLICIES ARE THE BANE OF ASSAM | 2000-08-21| THE HINDUSTAN TIMES (DELHI)| N. A.| PARASHAR, UTPAL| +-+--+---++--++ 276 rows in set (7.06 sec) This happens for all queries. Of course the data is the same on both systems. The mysqld is what comes with the distrib. (RH - mysql-3.23.22-6 / Suse - mysql-3.23.41-17). That's not what we shipped in RHL 7.2 - that was 3.23.41-1 As for reasons for speed difference, it could be different kernels with different options (the new VM in 2.4.10 and up was very suspect for a long time, and still has some warts), different compilers (we have a mature, stable and well performing compiler in 2.96RH - 2.95 was a bad release, 3.0 still has some warts). Our optimized glibc could also make a difference if Suse doesn't have this. Different filesystems could also mean a difference. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Suse V/S Redhat - mysql performance difference.
Robert Cross [EMAIL PROTECTED] writes: 2. Check what else the Suse system has installed and is running in the background. I've migrated my two systems, (Athlon-based 'base' station and PII/266 laptop) to Suse 7.3 from RH7.0, and there appears to be way more background systems running on Suse than on the old RH one. (Like why do Mandrake/Suse/RedHat insist on running the PCMCIA service on a system that doesn't have PCMCIA sockets?) It exits when it discovers that, so it doesn't run. 3. What file system are you running. I've heard that ReiserFS, and journalling systems in particular, make better use of the device-peering facilities that SCSI has, presumably where you've got a multi disk setup. When I tested, ReiserFS did worse than the rest (ext3, xfs) for databases (this was pgsql, though). -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing of MySQL on redhat 7,2
Egor Egorov [EMAIL PROTECTED] writes: Nasser, Friday, January 18, 2002, 12:01:02 PM, you wrote: NR By the way I run my application which should run on MySQL, I get the error NR message which includes that libmysqlclient.so.6 NR could not find!!! NR What I have down wrong? How did you install MySQL? Have you installed the rpm packages downloaded from mysql site or you have compiled the server on your own? His application is linked against an old version of mysql (libmysqlclient.so.6... that's ancient), newer ones provide libmysqlclient.so.10 (the switch from 9 to 10 was autumn 2000) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock error
Jay Paulson [EMAIL PROTECTED] writes: I'm running RedHat 7.1 and I'm trying to run mysql. I've gone and run the mysql_install_db Not good. If you had just started the script, it would have been done automatically - as it is, you created a set of files you can't access (root owns them, the db runs as user mysql). A chown -R mysql.mysql /var/lib/mysql would fix it. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Redhat 7.2 Linux Maximum Database/Table Size
Benjamin Arai [EMAIL PROTECTED] writes: Oh, I don't know how well that would work. But I do know you will still run into limitations of 2 GB, so if you had 2 drives raided then you now have a 4 GB limit which doesn't help to much. I would think the best solution would be to re-compile your kernel to include large file support and tweak you MySQL for limit-less records. That's what I do when I run into older distro's. If you're running a 2.4 kernel (or some 2.2 kernels, like the one in Red Hat Linux 6.2 enterprise), that's not an issue. You do need glibc 2.2, though - and in many cases, you need to add preprocessor flags as well. (note that glibc 2.1, which is used if you use the old compat compiler on Red Hat Linux 7.x, does not have full LFS support. I.e. compiling with egcs considered harmful) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Turning it on
Tim Bogart [EMAIL PROTECTED] writes: All, I'm new to this list and this is my first post. I hope all of you are well. I just upgraded my laptop to Red Hat Linux 7.2. When I do an rpm -q mysql it tells me I have mysql v mysql-3.23.41-1 installed. The server is not running however and I have never used mysql on this system before. I need to get the server to come up at boot time and I need to set the initial things like the mysqladmin password. chkconfig mysql on will turn it on at boot time. service mysqld start will start it right now, and initialize the database. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL admin with no password
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: Is there a clean way to administrate mysqld without a password by root? I'm looking for ways to make it flush logs, reload my.cnf and shut down cleanly, in an automated way - i.e, no password, but by root. (similar to pg_ctl for postgresql or `kill -HUP` for reloading) (e.g. shut down the server on system shutdown, and make log rotation and kill -HUP will flush everything. We used to do that, but got complaints: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=51711 It wreaked havoc on bin-logs. OTOH, we need to be able to have scripts controlling the DB as root, while not needing to have a passwordless DB account. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL admin with no password
Is there a clean way to administrate mysqld without a password by root? I'm looking for ways to make it flush logs, reload my.cnf and shut down cleanly, in an automated way - i.e, no password, but by root. (similar to pg_ctl for postgresql or `kill -HUP` for reloading) (e.g. shut down the server on system shutdown, and make log rotation and -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stability problems on 4-way server
Dennis Jacobfeuerborn [EMAIL PROTECTED] writes: We are running MySQL version 3.23.43 on one of our servers and have some stability Where did you get that? The MySQL site? Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet connection Software: Base RedHat 7.2 installation Unpatched kernel 2.4.17 2.4.17 has problems with heavy database usage. Does this happen on the supported kernels as well? (I'm guessing yes, this doesn't seem to have anything to do with the kernel... you might want to check if anything suspicious show up in dmesg, though) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to make use of mysql++ with gcc 2.96
Sinisa Milivojevic [EMAIL PROTECTED] writes: luhar-123 writes: Hi guys, i have installed red hat linux 7.2 and mysql server version 3.23.42. but i need mysql++ also.but it seems that gcc version 2.96 will give lot of problems for mysql++. can any one pls give me a solution to use mysql++ on linux 7.2. Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in Yes, install gcc 2.95.2 or 3.0.3 That is very much _NOT_ recommended. Both have serious issues, none are compatible with the other libraries installed. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and kernel upgrade
Sommai Fongnamthip [EMAIL PROTECTED] writes: Hi, I was read recommendation from MySQL download page to upgrade Linux Kernel for latest MySQL version. I have problem because I must still with Linux Red Hat 6.2 (kernel 2.2.16-3) Newer versions of the kernel has been released, and are highly recommended for security reasons. http://www.redhat.com/support/errata/RHSA-2001-142.html -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RedHat DB?!
Deependra B. Tandukar [EMAIL PROTECTED] writes: What is RedHat Database? Postgresql. Is anybody using it? How is it? Better than MySQL? It's postgresql w/support, so the answer would be the same as regular postgresql vs. MySQL. This means that it has things like foreign keys, stored procedures, triggers, subqueries etc. which are missing in MySQL. MySQL is probably a bit more optimized for doing simple queries/inserts, though. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC availability
Venu [EMAIL PROTECTED] writes: No such, as long as it is GPL distribution. Actually, it's Public Domain, not GPL. It's included in Red Hat Linux 7.2. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp haev6.tar.gz Thanks in advance! Ron Jamison Hi! Try a binary from our site. The above one _is_ your site, isn't it? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Robert Alexander [EMAIL PROTECTED] writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Where can I download berkeley DB 3.2.9a for MySQL 3.23.46 installation?
Ziying Sherwin [EMAIL PROTECTED] writes: We are interested in installing MySQL 3.23.46 from source on our Solaris 2.8 machine. However, we could not find berkeley DB 3.2.9a that is required by MySQL package. Does anyone know where to find it? Thanks. Since I am not on this mailing list, please send the reply to [EMAIL PROTECTED] Newer releases of mysql come with a bundled bdb in a subdir. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL - Got Signal 11 - URGENT-RedHat-gcc2.96
Gordan Bobic [EMAIL PROTECTED] writes: On Tuesday 27 Nov 2001 04:11, Ady Wicaksono wrote: gcc 2.96 has bugs that affect MySQL, what bug ? A number of bugs, and they don't just affect MySQL - there is a number of packages that break when compiled using GCC-2.96. Some examples that I presonally ran into at some point are: mPlayer That is known to be mplayer problems. Same problems in their assembly as with gcc 3.0 InterBase DBD driver Haven't seen. There are more, I just can't remember right now. You will find that the kernel, for example, is compiled using kgcc under RedHat v7.X. kgcc is an older version of gcc (egcs, actually) that actually works. Try kgcc --version. RedHat 7.1 and RedHat 7.2 comes with gcc 2.96 And 7.0. 7.2 Also ships with GCC-3.0, which is actually a production release compiler, unlike the 2.96 version, which was a pre-release development snapshot. Uh... gcc 2.96RH is production quality, and the standard compiler. Gcc 3.0 is known to be buggy, and not of production quality. It's not used for anything, it's just a preview (it has more bugs, but it's also closer to the C++ standard than gcc 2.96RH). RedHat have been flamed repeatedly since the release of RH7 over this. By people not knowing what they're talking about. I'm not impressed by idiots who have bugs in their code, won't receive patches and requires you to type in untrue statements about the compiler (mplayer). Just download GCC-2.95.2.1 and the PGCC patches pgcc? Now that's a known good compiler. Not. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL - Got Signal 11 - URGENT-RedHat-gcc2.96
Sasha Pachev [EMAIL PROTECTED] writes: On Monday 26 November 2001 03:40 pm, Ady Wicaksono wrote: gcc 2.96 has bugs that affect MySQL, what bug ? RedHat 7.1 and RedHat 7.2 comes with gcc 2.96 If we knew exactly what bug we would have given Red Hat a test case to fix it. All we know is that strange things happen under load when MySQL is compiled with 2.96, and they stop happening when the user switches to our binary, which is compiled with 2.91 This changes prototypes and C libraries as well (it's a compat compiler, for producing binaries running on RHL 6.2. It's not used for anything else) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL - Got Signal 11 - URGENT-RedHat-gcc2.96
Ady Wicaksono [EMAIL PROTECTED] writes: On Tuesday 27 November 2001 02:38 am, you wrote: On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote: I have an app that uses about 6-7 databases. But the MySQL server is now restarting a lot. I was having a problem with this before - I had about 267 restarts in a matter of a month or two. I shut down the server, ran myisamchk on the databases and it found a lot of open connections, and I guess closed them. I ran MySQL again and it seemed to be fixed for a while. I left work for the holiday weekend and came back. Now I've got close to 2000 log files in a matter of a few days. It appears that it's restarting approximately every 15 seconds. The error log simple contains: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011125 07:24:14 mysqld restarted Over and over and over again. It's filled with these messages, one after another. I'm running 3.23.36-log - any ideas? Try a newer one, like the one shipped with Red Hat Linux 7.2, and see if that helps? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: EMERGENCY - Our production database is crashed
David Potter [EMAIL PROTECTED] writes: We are running Mysql 3.23 on Redhat Linux 7.1. Which version on MySQL, and where did you get it? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: EMERGENCY - Our production database is crashed
Sergei Golubchik [EMAIL PROTECTED] writes: Hi! On Oct 23, David Potter wrote: Dear list members, We are running Mysql 3.23 on Redhat Linux 7.1. We have an emergency. This is the first time we have ever had a problem. Our production database suddenly crashed. I have tried to repair the tables with myisamchk commands, -r, -o, etc and nothing works. Here is the output: myisamchk: error: 'journal.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair myisamchk: error: 'journal.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair This looks like hardware bug or linux kernel bug (there're some in older versions). MySQL, by itself, NEVER writes to .frm file (besides ALTER TABLE and CREATE TABLE). So, as you have .frm file corrupted, it was, most probably, not due to MySQL bug. I'd recommend you to upgrade to the latest linux kernel - especially, if your server is working under high load. Make that the latest errata kernel. You'd want to be very careful about 2.4.10 and up. There are, however, no known corruption problems in existing 2.4.x kernels supported by Red Hat (flaky hardware excepted) on supported configurations (i.e. no reiserfs). -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RH7.1 install question
cedric [EMAIL PROTECTED] writes: The MySQL manual refers to files in /usr/local/. /usr/local/ in RH7.1 is empty. Could this be the reason why I'm having so much trouble installing MySQL? If so, how can I get rpm to install MySQL in /usr/local/? Files managed by rpm shouldn't be in /usr/local, that's for stuff you compile locally. That shouldn't cause any problems, though - just start the database with service mysqld start -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Red Hat 6.2 and kernel 2.2.14 and mysql 3.23.42
[EMAIL PROTECTED] writes: Hi everybody ! I have Red Hat 6.2 and kernel 2.2.14. I installed mysql server 3.23.42 from rpms. Shall i recompile my kernel to the newest version ?? I heard, that kernel 2.2.14 have serious problem on hevy loaded system = using mysql 3.23.42 . You should apply all updates released for Red Hat Linux 6.2 - go to http://www.redhat.com/support/ to find out more. This includes a newer kernel. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: unixODBC..
Srinivasa T.N. [EMAIL PROTECTED] writes: Well, if I use the SQL statements specific to MySQL in my application, then won't I loose portability?? For the most part - there are certain tricks you can try, which takes advantage of text which looks like comments to other databases. If you want to write standards compliant SQL for MySQL, you should really take a look at http://www.mysql.com/doc/C/o/Compatibility.html , to see what MySQL does and doesn't support. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: please help me .........cannot find -lmysqlcliente
katty Iniguez [EMAIL PROTECTED] writes: I use Linux RedHat 7.0 I installed and Configured MySQL-3.23.42 I am installing icradius-0.18.1 installing icradius I got the following: make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 1) Make sure you have mysql-devel installed 2) Make sure you have -L/where/your/mysqlclientlibrary/is on your linker line Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found lmysqlclient) That's something different - /proc/* aren't real files. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't get MySQL running on RH7.0 at all.
Mark Johnson [EMAIL PROTECTED] writes: I must be a moron but I can't seem to figure out what I need to do to get mysql to work on RH, on Mandrake it just worked straight away. chown -R mysql.mysql /var/lib/mysql; chmod a+rX /var/lib/mysql An errata was issued when RHL 7 was release, and more has been released since for various issues. Mysql should be started like any other service: service mysqld start (which is equivalent to /etc/init.d/mysqld start. To make it start on every boot, do chkconfig mysqld on or run ntsysv/tksysv and enable it there. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: configure with mysql
Jason Radley [EMAIL PROTECTED] writes: I have installed redhat linux 7.1 with apache, php and mysql but when installed redhat it didn't add the configure --with-mysql it added --without-mysql is there any way to change this to configure --with-mysql. Just install the php-mysql package - the extensions are dynamic and not build into the main binary. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compile error, 3.23.42 error with macro uint8korr
*mysql-list has an annoying filter* [EMAIL PROTECTED] writes: Environment: machine, os, target, libraries (multiple lines) System: Linux homer 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 It would be useful if you made sure that all errata are applied to your machine, and then try again - the simplest way is just running up2date on your system. It compiles here, on a Roswellish system (and slightly different opions - no Gemini, only BDB and innodb) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: configure with mysql
Dr. Randy Frid [EMAIL PROTECTED] writes: I've tried that to no avail. Everything on my system works perfectly except for this. The MySQL website indicates the following: Tried what? There is a specific php-mysql module. When you install that (restart of apache may also be necesarry), it works. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compile error, 3.23.42 error with macro uint8korr
Shane Corgatelli [EMAIL PROTECTED] writes: It compiles here, on a Roswellish system (and slightly different opions - no Gemini, only BDB and innodb) I removed the --with-gemini option and everything compiles beautifully. I tried it with the mysql+gemini-3.23.41 source and I still get errors. 3.23.41 had assembly problems which was fixed in 3.23.42. This was also released as a patch to this list by the innodb people, who seem to a pretty responsive group. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help with mysql.sock error
adam [EMAIL PROTECTED] writes: I am having trouble with mysql... i keep getting ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) You probably didn't start it the correct way, by using the included initscript (/etc/init.d/mysqld, also usable by service mysqld argument (start, stop etc)). This is also what would have been used had you used tksysv, ntsysv or chkconfig to turn the service on. If you use the mysql_install_db as root and then use safe_mysqld, you'll try to run the database as user mysql - but root will own the files. chown -R mysql.mysql /var/lib/mysql should fix the problem. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
[EMAIL PROTECTED] (Jason Bailey) writes: If the server is creating mysql.sock in and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- I think this may be my problem in that I couldn't understand whether mysql.sock should be located in /var/lib/mysql but is required to be in /tmp. It certainly appears in /var/lib/mysql I'll try your suggestion for this and check permissions. As written before, it is a permissions problem - mysql_install_db (unnecesarry , don't run it - just run service mysqld start ) will create files owned by root. If you look in the default /etc/my.cnf, the database runs as user mysql (for security reasons). To fix it, do a chown -R mysql.mysql /var/lib/mysql If you had started mysql the same way you start other services (httpd, samba, etc) via tksysv/ntsysv(permanently, on every boot) or service httpd start (do it right now - equivalent to /etc/init.d/httpd start), it would have created the database with correct permissions automatically. mysql_install_db and safe_mysqld aren't necesarry, and will often cause problems. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Tony Bibbs [EMAIL PROTECTED] writes: I guess where it can get confusing is when a stock RH7.1 install with PHP doesn't have mysql support enabled but postgresql is. That depends on what you install. MySQL isn't (like many other packages) in any of the premade installation categories - you can select it in a custom install, or do a everything install. To the uninformed user like me who doesn't care to know the individual RPMS in the distro it is easy to make that, obviously wrong, assumption when, by default, the php-postgres RPM is installed. It's not installed by default either, but if you select both the postgresql and the web server components you'll get it. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Peter Harvey [EMAIL PROTECTED] writes: That depends on what you install. MySQL isn't (like many other packages) in any of the premade installation categories - you can select it in a custom install, or do a everything install. I bet a product like Data Architect ( http://www.codebydesign.com ) would be a great fit in this distro? It supports all features of MySQL... table options... column types and options... etc. Looks interesting, as it supports PostgreSQL, MySQL and ODBC. We're not adding packages right now, but I've bookmarked it. Didn't find anything about licensing and such, though. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
jason bailey [EMAIL PROTECTED] writes: HI, I'm a new user to Linux and am interested in MySQL and PHP. I currently use both as a developer elsewhere and am now trying to set up a test server at home. I've searched the MYSQL lists and notice that alot of people are getting a similar problem as myself and I'm not sure if any have got this to work. I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) I've read through the manual about problems starting a server but this has not helped and I've tried to follow help in the lists but again no result. I run mysql_install_db and get the messages about starting up I run safe_mysqld and get something about starting and stopping I've found the the mysql.sock and it's in the location that the error mentions the location of the sock thing?? (It's late and I'm tired and a bit fed up -after being told to forget windows and go to Linux- I really wanted to agree but am now finding it hard too!) You shouldn't have done mysql_install_db (which creates db files, owned by root) and safe_mysqld (which will start the database as user mysql, who can't read or write to the necesarry files). Do a chown -R mysql.mysql /var/lib/mysql, then start the database with service mysqld start. If you had done this (or just selected it to start in one of the runlevel managers, like ntsysv or tksysv), it would have initialized the database automatically. To make mysqld start on every boot, do chkconfig mysqld start. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Kalpesh Modha [EMAIL PROTECTED] writes: Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. You need to install the php-mysql package, which contains the module PHP needs to support MySQL. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. We do compile in support for MySQL, but it's in the php-mysql package - just as at support for PostgreSQL is in php-pgsql. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld or kernel bug?
Robert La Ferla [EMAIL PROTECTED] writes: I saw this message in the log. Is this a mysql or kernel? I also saw one of the mysqld processes (threads?) in the process list as a Zombie. I think it happened at the same time of this log but I don't remember so it's not definite but likely. Kernel or hardware - please report at https://bugzilla.redhat.com/bugzilla/ (even better if you can eliminate the HW question by running a memory checker first) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: discussion: mysql licensing issue and funding issues
Neil Zanella [EMAIL PROTECTED] writes: I would like to comment on the following mysql.com question We have made our product available at zero price under the GNU General Public Licence (GPL), and we also sell it under a commercial licence to those who do not wish to be bound by the terms of the GPL. Out of curiosity, how does the second statement not violate the GNU GPL? They own the code, they can give it out under different licenses if they like. In particular, contributions made to the GPL'd source code cannot be applied to the proprietary source code unless the contributor explicitly states that the contribution goes to both the GPL'd software release and the proprietary source code simultaneously. Which I'm pretty sure they're doing - no code accepted if it doesn't satisfy their demands. This reminds me of something like the emacs/xemacs split with the sole difference of a licensing issue. That has nothing to do with licensing - different groups of developers have different targets (eyecandy vs. stability and speed ;) and processes. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie question
Tom Hicks [EMAIL PROTECTED] writes: I have put a new web server and would like to put a board on it. But when I try to I get an error. I know it is a sql error. On the install I did the configure with apache but I got a few errors. Not sure if I did it right. Well at this point I need it configured for PHP4 and MySql. PHP4 is working fine but the MySQL is not. I get this error. Fatal error: Call to undefined function: mysql_connect() in /home/httpd/zorum_1_0/forum.php on line 1910 I know this is because apache is not connected or configured to call mysql. At this point and am wondering if I might be better off to reinstall the 3 rpm's and config them correctly. I am running Red Hat 7.1 with Apache/1.3.19 You need to install php-mysql. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Events with MySQL
Darius Blaszijk [EMAIL PROTECTED] writes: I'm just beginning with MySQL, and I have the following question. Is there something like events in MySQL. What I want to do is write some message automtically into a table every time a record in some table is changed. You're looking for triggers, and MySQL doesn't have them. PostgreSQL does. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GLIBC 2.2.4
On Fri, 24 Aug 2001, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Peter Zaitsev [EMAIL PROTECTED] writes: I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this somehow does not work with the following diagnose: It builds just fine with glibc 2.2.4 on a current development version of Red Hat Linux (Roswell + a few minor updates). Did you compile glibc yourself or have you used gcc 3? You know better then me that 2.2.4 should NOT be built with gcc 3 ! Which was why I asked :) - 2.2.4 wants 2.96RH or 2.95.3 (2.95.2 should work on IA32, though) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GLIBC 2.2.4
Peter Zaitsev [EMAIL PROTECTED] writes: I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this somehow does not work with the following diagnose: It builds just fine with glibc 2.2.4 on a current development version of Red Hat Linux (Roswell + a few minor updates). Did you compile glibc yourself or have you used gcc 3? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RH Linux 7.1 - Source or Binary
[EMAIL PROTECTED] writes: I have read conflicting reports in the MySQL documentation concerning which type of MySQL is better to install in Linux - Source or Binary? Can some of you please enlighten me to which type you prefer or which you have been successful with? Source can be tuned more, the binary ones shipped with Red Hat Linux 7.1 have been regression tested, tested for integration with other components etc. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb on linux raw partitions
Tonu Samuel [EMAIL PROTECTED] writes: On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x kernel series and are looking to use software RAID + ReiserFS on it. If that's a lost cause, it'll save us some work and frustration knowing sooner rather than later... Maybe this is not what you want to know but hardware IDE controller is really cheap. I personally prefer cheap tuned ATA100 disks on top of hardware RAID. 3ware is nice :) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost bin-log(s) following logrotate affecting recovery, replication
Joel Fowler [EMAIL PROTECTED] writes: I've also reported this problem to Red Hat' Bugzilla as I understand they're responsible for the /etc/logrotate.d/mysql script. It's Bugzilla [Bug 51711] Changed - MySQL looses bin-logs during logrotate. 3.23.41-1 uses a new method for flushing logs prior to logrotate -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem rpm installation of MySQL
Shu Xiao [EMAIL PROTECTED] writes: BTW, if I want to upgrade to new rpm version, what should I do. The RPM program will take care of upgrading itself? If you get the new version of mysql in rpm format (eg. from Rawhide), 'rpm -Uvh mysql*rpm' should take care of it. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem rpm installation of MySQL
Shu Xiao [EMAIL PROTECTED] writes: Hi, I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which include MySQL rpm installation, I saw the file named mysqld under /etc/init.d . I set up symlink to it under /etc/rc3.d and etc/rc5.d. I intended to start MySQL while Linux booting. But I failed to start it. Checking /var/log/mysql.log I saw the follling: 010813 21:03:15 mysqld started 010813 21:03:15 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010813 21:03:15 mysqld ended And here is the configuration file /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I even manual run /etc/init.d/mysqld start and still got the same error. Anybody can point out what wrong here? I do see the host.frm under /var/lib/mysql/mysql. But why it always failed to find it? For some reason (probably a manual mysql_install_db, which is bad and unnecesarry), the database user don't have write access. chown -R mysql.mysql /var/lib/mysql should solve the problem. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub select.
Anders Alstrin [EMAIL PROTECTED] writes: Does anyone know how to do this sub select in MySQL. MySQL doesn't have subselects. Some workarounds can be found at http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Missing_Sub-selects PostgreSQL supports them. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't start MYSQL on Linux
mike cullerton [EMAIL PROTECTED] writes: on 8/6/01 10:13 PM, Trond Eivind Glomsrød at [EMAIL PROTECTED] wrote: Ling Wang [EMAIL PROTECTED] writes: I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . You're not supposed to. To start mysql, as any service, do snip What you've done (and too many others, where do they get this idea?) um, perhaps from the INSTALL-SOURCE notes that come with the mysql distribution But you didn't install from source. It comes with a Linux distribution, and is started as other services there (same way as the LSB standard specifies). shell bin/safe_mysqld --user=mysql If that is done, and mysql_install_db is run as root, I don't see that working either. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't start MYSQL on Linux
On Wed, 8 Aug 2001, Ling Wang wrote: I have to login as root user to do mysql_install_db and safe_mysqld . Otherwise I will get permission denied message. You already made those files, and they're owned by root. You can't overwrite them that way. Just do a chown before you start the database. How come when I type service mysqld start, Linux says command not found? I could not find the command chkconfig either. Both are not path of a user's path[1] - they're admin tools, and are for the use of root. Root can also control which services start with tksysv and ntsysv. [1] They're in /sbin, for the curious. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't start MYSQL on Linux
Ling Wang [EMAIL PROTECTED] writes: I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . You're not supposed to. To start mysql, as any service, do service mysqld start (which is equivalent to running the initscript like this /etc/init.d/mysqld start). This will automatically initialize the database the first time it runs. To make it start when your system starts, do chkconfig mysqld on What you've done (and too many others, where do they get this idea?) is that you've created the database files as root. Then you start the database, which will run as mysql. This user can obviously not write to root's files. Change the ownership manually, and try again - with service mysqld start. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with Redhat 7.1
[EMAIL PROTECTED] writes: I have installed Redhat Linux 7.1 with the supplied MySQL distribution (3.23.36?). I've run the mysql_install_db script, but when I try to start MySQL using ./bin/safe_mysqld --user=mysql , from the installation directory, MySQL starts then ends immedately (MySQL ends) without an error!! 1) Don't run mysql_install_db or safe_mysqld directly - use service mysqld start, it will automatically initialize the database 2) When you run mysql_install_db, you create the files as root - later, you try to run the database as mysql. This user won't have access to your files. To fix it, do chown -R mysql.mysql /var/lib/mysql. And you should run mysql with service mysqld start in the future - or just enable it by default, with chkconfig mysqld on -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Removal of MySQL
michael johnson [EMAIL PROTECTED] writes: Is there a simple command one can give in Linux that will remove all trace of Mysql except the databases so that I can install from fresh? That is very dependent on how you installed it. If you used rpm, you can just do rpm -e mysql mysql-server mysql-devel. If you just want to reinstall another (or the same version), just do rpm -Uvh mysql* with the new set of rpms - add --force if it's an older or the same version you already have installed. [1] (well, it likely won't succeed since the libraries are needed by other applications you might have installed on your system. Remove those applications as well if you want to remove any trace of mysql on your system) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php