Re: Problems After MySql 5.1.34 - THANKS
Thanks to everyone that offered all the valuable suggestions. SImply replaced the shared-community with shared-compat and all seesm fine. Will live with, or deal with, the missmatch in php libraries later, but for now everything seems to work. Thanks again to everyone that offered such detailed and helpful suggestions :) Gary Smith wrote: You are right. I misspoke regarding mysql - php - apache hell. It happens anytime an interface changes. From: Mark [ad...@asarian-host.net] Sent: Thursday, May 07, 2009 5:57 AM To: mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Well, you don't actually have to recompile PHP entirely, of course: just its mysql.so extension. @TS: Other than that, you basically need to recompile *everything* (or its mysql dynamic libraries) when you upgrade MySQL. This includes Perl, btw; so you'd need to build DBD:mysql as well (same for Python, etc). Walter wrote: Any (major)upgrade of mysql client requires the dependent subsystem to upgrade also. Anything else would be careless since you do not know if the interface has changed. Actually, you *do* know: that's what the changelog is for. :) When C header changes are made, an upgrade is in order. If not, when upgrading between minor versions, say, from 5.0.51 - 5.0.67 (just an example), you won't need to recompile all system-wide MySQL client extensions. I've done this many times, without issue: you just need to be absolutely sure no header changes were made (when in doubt, recompile). I recently upgraded to 5.1.34 as well; and it was indeed a hell. :) It's working just fine, but I spent several hours recompiling MySL client stuff; without doing so, your apps will likely behave erratically, or just segfault altogether. This isn't a MySL hell exclusively, btw. You'll get the same issue upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the beast. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@openenterprise.ca -- _ Johnny Stork Open Enterprise Solutions Empowering Business With Open Solutions http://www.openenterprise.ca Mountain Hosting Secure Hosting Solutions for Business http://www.mountainhosting.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problems After MySql 5.1.34
there is nothing you can make. Any (major)upgrade of mysql client requires the dependent subsystem to upgrade also. Anything else would be careless since you do not know if the interface has changed. basicly you can install both version of libraries and hope for the best. i would do this only as last rescue if an update is not possible. it is in general not clever. re, wh Gary Smith schrieb: Johnny, Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. This is why you are receiving the error through PHP. Of course, I could be wrong, in which case I know people will probably jump me for it. If this is the case, please do as I would like to be wrong here as it would make my compiling life easier every time I update MySql on all of my boxes. Gary From: Johnny Stork [li...@openenterprise.ca] Sent: Wednesday, May 06, 2009 1:03 PM Cc: mysql@lists.mysql.com Subject: Re: Problems After MySql 5.1.34 Typo, moved from 5.0.67 to 5.1.34 Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a pear update produces the errors below. I created a couple of sl but this did not seem to fix the problem. Below is the error and contents of /usr/lib r...@asterisk:~# pear update PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so' - /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/php/modules/mysql.so) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysqli.so' - /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/php/modules/mysqli.so) in Unknown on line 0 Segmentation fault r...@asterisk:~# ls -la /usr/lib/libmy* lrwxrwxrwx 1 root root 26 May 6 09:52 /usr/lib/libmysqlclient_r.so - libmysqlclient_r.so.16.0.0 lrwxrwxrwx 1 root root 28 May 6 11:26 /usr/lib/libmysqlclient_r.so.15 - /usr/lib/libmysqlclient_r.so lrwxrwxrwx 1 root root 28 May 6 11:18 /usr/lib/libmysqlclient_r.so.15.0.0 - /usr/lib/libmysqlclient_r.so lrwxrwxrwx 1 root root 26 May 6 09:52 /usr/lib/libmysqlclient_r.so.16 - libmysqlclient_r.so.16.0.0 -rwxr-xr-x 1 root root 2052884 Mar 31 22:48 /usr/lib/libmysqlclient_r.so.16.0.0 lrwxrwxrwx 1 root root 24 May 6 09:52 /usr/lib/libmysqlclient.so - libmysqlclient.so.16.0.0 lrwxrwxrwx 1 root root 26 May 6 11:14 /usr/lib/libmysqlclient.so.15 - /usr/lib/libmysqlclient.so lrwxrwxrwx 1 root root 24 May 6 09:52 /usr/lib/libmysqlclient.so.16 - libmysqlclient.so.16.0.0 -rwxr-xr-x 1 root root 2044464 Mar 31 22:48 /usr/lib/libmysqlclient.so.16.0.0 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problems After MySql 5.1.34
Hi Johnny, all! Johnny Stork wrote: Typo, moved from 5.0.67 to 5.1.34 Ok, that helps - I checked the contents. Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a pear update produces the errors below. I created a couple of sl but this did not seem to fix the problem. Below is the error and contents of /usr/lib Somewhere during this upgrade you seem to have lost the shared libraries of the MySQL client side which you had with version 5.0.67: /usr/lib/libmysqlclient_r.so.15.0.0 /usr/lib/libmysqlclient.so.15.0.0 MySQL 5.0 comes with version 15 of these libraries, MySQL 5.1 comes with version 16. How these are handled depends on how you install MySQL (assuming Linux): a) If you use tar.gz packages, then MySQL 5.0 has brought version 15 and created symlinks from the unversioned name to the versioned: /usr/lib/libmysqlclient.so - /usr/lib/libmysqlclient.so.15 /usr/lib/libmysqlclient.so.15 - /usr/lib/libmysqlclient.so.15.0.0 /usr/lib/libmysqlclient.so.15.0.0 would be a real file. (Similar for libmysqlclient_r.so) Then, upgrading to 5.1 would bring version 16: /usr/lib/libmysqlclient.so - /usr/lib/libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16 - /usr/lib/libmysqlclient.so.16.0.0 Again, /usr/lib/libmysqlclient.so.16.0.0 would be a real file. Note that this installation changes the symlimk for the unversioned name, but would not touch version 15, there still is /usr/lib/libmysqlclient.so.15 - /usr/lib/libmysqlclient.so.15.0.0 /usr/lib/libmysqlclient.so.15.0.0 would still exist as a real file. b) If you use RPMs, then installing MySQL 5.0 has set up version 15 of the client libraries in the same way. However, the upgrade to MySQL 5.1 would have removed the files brought by 5.0 and just installed the new version 16 (specifically, the 5.1 shared RPM does this). If you use applications that were built against older versions of the MySQL client libraries (like Trixbox), you must not lose these older files. For this purpose, we provide shared-compat RPMs, they contain the current and all previous versions of the client libraries. See this contents listing: prompt rpm -qlvp MySQL-shared-compat-5.1.34-0.glibc23.i386.rpm | cut -c1-11,37- lrwxrwxrwx24 Apr 5 23:56 /usr/lib/libmysqlclient.so - libmysqlclient.so.16.0.0 lrwxrwxrwx24 Apr 5 23:56 /usr/lib/libmysqlclient.so.10 - libmysqlclient.so.10.0.0 -rwxr-xr-x224606 Apr 5 23:56 /usr/lib/libmysqlclient.so.10.0.0 lrwxrwxrwx24 Apr 5 23:56 /usr/lib/libmysqlclient.so.12 - libmysqlclient.so.12.0.0 -rwxr-xr-x221492 Apr 5 23:56 /usr/lib/libmysqlclient.so.12.0.0 lrwxrwxrwx24 Apr 5 23:56 /usr/lib/libmysqlclient.so.14 - libmysqlclient.so.14.0.0 -rwxr-xr-x 1267848 Apr 5 23:56 /usr/lib/libmysqlclient.so.14.0.0 lrwxrwxrwx24 Apr 5 23:56 /usr/lib/libmysqlclient.so.15 - libmysqlclient.so.15.0.0 -rwxr-xr-x 1942232 Apr 5 23:56 /usr/lib/libmysqlclient.so.15.0.0 lrwxrwxrwx24 Apr 5 23:56 /usr/lib/libmysqlclient.so.16 - libmysqlclient.so.16.0.0 -rwxr-xr-x 1989112 Apr 5 23:56 /usr/lib/libmysqlclient.so.16.0.0 lrwxrwxrwx26 Apr 5 23:56 /usr/lib/libmysqlclient_r.so - libmysqlclient_r.so.16.0.0 lrwxrwxrwx26 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.10 - libmysqlclient_r.so.10.0.0 -rwxr-xr-x230560 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.10.0.0 lrwxrwxrwx26 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.12 - libmysqlclient_r.so.12.0.0 -rwxr-xr-x225752 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.12.0.0 lrwxrwxrwx26 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.14 - libmysqlclient_r.so.14.0.0 -rwxr-xr-x 1274796 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.14.0.0 lrwxrwxrwx26 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.15 - libmysqlclient_r.so.15.0.0 -rwxr-xr-x 1950652 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.15.0.0 lrwxrwxrwx26 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.16 - libmysqlclient_r.so.16.0.0 -rwxr-xr-x 1999100 Apr 5 23:56 /usr/lib/libmysqlclient_r.so.16.0.0 lrwxrwxrwx21 Apr 5 23:56 /usr/lib/libndbclient.so - libndbclient.so.2.0.0 lrwxrwxrwx21 Apr 5 23:56 /usr/lib/libndbclient.so.2 - libndbclient.so.2.0.0 -rwxr-xr-x759988 Apr 5 23:56 /usr/lib/libndbclient.so.2.0.0 For comparison, this is the 5.1.34 shared RPM: rpm -qlvp MySQL-shared-5.1.34-0.glibc23.i386.rpm | cut -c1-11,37- lrwxrwxrwx24 Mar 31 22:47 /usr/lib/libmysqlclient.so - libmysqlclient.so.16.0.0 lrwxrwxrwx24 Mar 31 22:47 /usr/lib/libmysqlclient.so.16 - libmysqlclient.so.16.0.0 -rwxr-xr-x 1998728 Mar 31 22:48 /usr/lib/libmysqlclient.so.16.0.0 lrwxrwxrwx26 Mar 31 22:47 /usr/lib/libmysqlclient_r.so -
Re: Problems After MySql 5.1.34
Hi Gary, all, Gary Smith wrote: Johnny, Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Which other approach(es) did you try? This is why you are receiving the error through PHP. Of course, I could be wrong, in which case I know people will probably jump me for it. If this is the case, please do as I would like to be wrong here as it would make my compiling life easier every time I update MySql on all of my boxes. Please see my other mail: - Using tar.gz, the old version of the client libs should not be touched when you upgrade MySQL. - Using RPMs, you need to install shared-compat (and not shared) if you are using application binaries built against older version(s). If you found any problems with this, please tell us! We are considering to change the contents of shared-compat RPMs, so that they would not replace shared any more but just complement it (bring just the old libs, not the current one). The advantage would be that you then can install (or uninstall) them without affecting your clients built against the current version, especially those coming from MySQL directly. However, this would mean a change in usage pattern for existing users, and we are not yet sufficiently sure that our users would welcome it. Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Problems After MySql 5.1.34
Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Well, you don't actually have to recompile PHP entirely, of course: just its mysql.so extension. @TS: Other than that, you basically need to recompile *everything* (or its mysql dynamic libraries) when you upgrade MySQL. This includes Perl, btw; so you'd need to build DBD:mysql as well (same for Python, etc). Walter wrote: Any (major)upgrade of mysql client requires the dependent subsystem to upgrade also. Anything else would be careless since you do not know if the interface has changed. Actually, you *do* know: that's what the changelog is for. :) When C header changes are made, an upgrade is in order. If not, when upgrading between minor versions, say, from 5.0.51 - 5.0.67 (just an example), you won't need to recompile all system-wide MySQL client extensions. I've done this many times, without issue: you just need to be absolutely sure no header changes were made (when in doubt, recompile). I recently upgraded to 5.1.34 as well; and it was indeed a hell. :) It's working just fine, but I spent several hours recompiling MySL client stuff; without doing so, your apps will likely behave erratically, or just segfault altogether. This isn't a MySL hell exclusively, btw. You'll get the same issue upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the beast. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Problems After MySql 5.1.34
Depends on your OS, I guess. On FreeBSD you can just go to the 'php5-extensions' port, run a 'make config', and deselect everything but the MySQL extension. Then it will only build mysql.so for you. Very easy. :) - Mark From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: donderdag 7 mei 2009 15:15 To: ad...@asarian-host.net; mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary this isnt mysql's fault that php has such abysmal build tools..try requesting a web developer to simply download php and run the proprietary binary tools after a week of sleepless nights and endless searching for the right dll/so/lib and endless searching for the right tools i guarantee they will call no joy and implement the webapp in Java! Martin __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité This message is confidential. If you should not be the intended receiver, then we ask politely to report. Each unauthorized forwarding or manufacturing of a copy is inadmissible. This message serves only for the exchange of information and has no legal binding effect. Due to the easy manipulation of emails we cannot take responsibility over the the contents. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: ad...@asarian-host.net Subject: RE: Problems After MySql 5.1.34 Date: Thu, 7 May 2009 12:57:42 + To: mysql@lists.mysql.com Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Well, you don't actually have to recompile PHP entirely, of course: just its mysql..so extension. @TS: Other than that, you basically need to recompile *everything* (or its mysql dynamic libraries) when you upgrade MySQL. This includes Perl, btw; so you'd need to build DBD:mysql as well (same for Python, etc). Walter wrote: Any (major)upgrade of mysql client requires the dependent subsystem to upgrade also. Anything else would be careless since you do not know if the interface has changed. Actually, you *do* know: that's what the changelog is for. :) When C header changes are made, an upgrade is in order. If not, when upgrading between minor versions, say, from 5.0.51 - 5.0.67 (just an example), you won't need to recompile all system-wide MySQL client extensions. I've done this many times, without issue: you just need to be absolutely sure no header changes were made (when in doubt, recompile).. I recently upgraded to 5.1.34 as well; and it was indeed a hell. :) It's working just fine, but I spent several hours recompiling MySL client stuff; without doing so, your apps will likely behave erratically, or just segfault altogether. This isn't a MySL hell exclusively, btw. You'll get the same issue upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the beast. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Windows Live: Keep your life in sync. Check it out. http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009
RE: Problems After MySql 5.1.34
Typically we see the problems with RH/Cent when you upgrade through those channels and then do an install of the 5.1.x series on top of that. I tried it about 9 months ago, so the details are fuzzy. I do know that in attempts to recover we extracted the RPM contents and tried to copy them manually to satisfy the dependency but in the end that didn't work for us for some reason. We ended up just creating a new RPM for 5.1.x and then recompiling the dependent apps against that and storing all of them in our own repo for yum update. From: joerg.bru...@sun.com [joerg.bru...@sun.com] Sent: Thursday, May 07, 2009 2:40 AM To: Gary Smith Cc: mysql@lists.mysql.com Subject: Re: Problems After MySql 5.1.34 Hi Gary, all, Gary Smith wrote: Johnny, Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Which other approach(es) did you try? This is why you are receiving the error through PHP. Of course, I could be wrong, in which case I know people will probably jump me for it. If this is the case, please do as I would like to be wrong here as it would make my compiling life easier every time I update MySql on all of my boxes. Please see my other mail: - Using tar.gz, the old version of the client libs should not be touched when you upgrade MySQL. - Using RPMs, you need to install shared-compat (and not shared) if you are using application binaries built against older version(s). If you found any problems with this, please tell us! We are considering to change the contents of shared-compat RPMs, so that they would not replace shared any more but just complement it (bring just the old libs, not the current one). The advantage would be that you then can install (or uninstall) them without affecting your clients built against the current version, especially those coming from MySQL directly. However, this would mean a change in usage pattern for existing users, and we are not yet sufficiently sure that our users would welcome it. Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Problems After MySql 5.1.34
You are right. I misspoke regarding mysql - php - apache hell. It happens anytime an interface changes. From: Mark [ad...@asarian-host.net] Sent: Thursday, May 07, 2009 5:57 AM To: mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. Well, you don't actually have to recompile PHP entirely, of course: just its mysql.so extension. @TS: Other than that, you basically need to recompile *everything* (or its mysql dynamic libraries) when you upgrade MySQL. This includes Perl, btw; so you'd need to build DBD:mysql as well (same for Python, etc). Walter wrote: Any (major)upgrade of mysql client requires the dependent subsystem to upgrade also. Anything else would be careless since you do not know if the interface has changed. Actually, you *do* know: that's what the changelog is for. :) When C header changes are made, an upgrade is in order. If not, when upgrading between minor versions, say, from 5.0.51 - 5.0.67 (just an example), you won't need to recompile all system-wide MySQL client extensions. I've done this many times, without issue: you just need to be absolutely sure no header changes were made (when in doubt, recompile). I recently upgraded to 5.1.34 as well; and it was indeed a hell. :) It's working just fine, but I spent several hours recompiling MySL client stuff; without doing so, your apps will likely behave erratically, or just segfault altogether. This isn't a MySL hell exclusively, btw. You'll get the same issue upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the beast. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problems After MySql 5.1.34
Typo, moved from 5.0.67 to 5.1.34 Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a pear update produces the errors below. I created a couple of sl but this did not seem to fix the problem. Below is the error and contents of /usr/lib r...@asterisk:~# pear update PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so' - /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/php/modules/mysql.so) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysqli.so' - /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/php/modules/mysqli.so) in Unknown on line 0 Segmentation fault r...@asterisk:~# ls -la /usr/lib/libmy* lrwxrwxrwx 1 root root 26 May 6 09:52 /usr/lib/libmysqlclient_r.so - libmysqlclient_r.so.16.0.0 lrwxrwxrwx 1 root root 28 May 6 11:26 /usr/lib/libmysqlclient_r.so.15 - /usr/lib/libmysqlclient_r.so lrwxrwxrwx 1 root root 28 May 6 11:18 /usr/lib/libmysqlclient_r.so.15.0.0 - /usr/lib/libmysqlclient_r.so lrwxrwxrwx 1 root root 26 May 6 09:52 /usr/lib/libmysqlclient_r.so.16 - libmysqlclient_r.so.16.0.0 -rwxr-xr-x 1 root root 2052884 Mar 31 22:48 /usr/lib/libmysqlclient_r.so.16.0.0 lrwxrwxrwx 1 root root 24 May 6 09:52 /usr/lib/libmysqlclient.so - libmysqlclient.so.16.0.0 lrwxrwxrwx 1 root root 26 May 6 11:14 /usr/lib/libmysqlclient.so.15 - /usr/lib/libmysqlclient.so lrwxrwxrwx 1 root root 24 May 6 09:52 /usr/lib/libmysqlclient.so.16 - libmysqlclient.so.16.0.0 -rwxr-xr-x 1 root root 2044464 Mar 31 22:48 /usr/lib/libmysqlclient.so.16.0.0 -- _ Johnny Stork Open Enterprise Solutions Empowering Business With Open Solutions http://www.openenterprise.ca Mountain Hosting Secure Hosting Solutions for Business http://www.mountainhosting.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Problems After MySql 5.1.34
Johnny, Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 = 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success trying to get it to work otherwise. This is why you are receiving the error through PHP. Of course, I could be wrong, in which case I know people will probably jump me for it. If this is the case, please do as I would like to be wrong here as it would make my compiling life easier every time I update MySql on all of my boxes. Gary From: Johnny Stork [li...@openenterprise.ca] Sent: Wednesday, May 06, 2009 1:03 PM Cc: mysql@lists.mysql.com Subject: Re: Problems After MySql 5.1.34 Typo, moved from 5.0.67 to 5.1.34 Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a pear update produces the errors below. I created a couple of sl but this did not seem to fix the problem. Below is the error and contents of /usr/lib r...@asterisk:~# pear update PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysql.so' - /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/php/modules/mysql.so) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysqli.so' - /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/php/modules/mysqli.so) in Unknown on line 0 Segmentation fault r...@asterisk:~# ls -la /usr/lib/libmy* lrwxrwxrwx 1 root root 26 May 6 09:52 /usr/lib/libmysqlclient_r.so - libmysqlclient_r.so.16.0.0 lrwxrwxrwx 1 root root 28 May 6 11:26 /usr/lib/libmysqlclient_r.so.15 - /usr/lib/libmysqlclient_r.so lrwxrwxrwx 1 root root 28 May 6 11:18 /usr/lib/libmysqlclient_r.so.15.0.0 - /usr/lib/libmysqlclient_r.so lrwxrwxrwx 1 root root 26 May 6 09:52 /usr/lib/libmysqlclient_r.so.16 - libmysqlclient_r.so.16.0.0 -rwxr-xr-x 1 root root 2052884 Mar 31 22:48 /usr/lib/libmysqlclient_r.so.16.0.0 lrwxrwxrwx 1 root root 24 May 6 09:52 /usr/lib/libmysqlclient.so - libmysqlclient.so.16.0.0 lrwxrwxrwx 1 root root 26 May 6 11:14 /usr/lib/libmysqlclient.so.15 - /usr/lib/libmysqlclient.so lrwxrwxrwx 1 root root 24 May 6 09:52 /usr/lib/libmysqlclient.so.16 - libmysqlclient.so.16.0.0 -rwxr-xr-x 1 root root 2044464 Mar 31 22:48 /usr/lib/libmysqlclient.so.16.0.0 -- _ Johnny Stork Open Enterprise Solutions Empowering Business With Open Solutions http://www.openenterprise.ca Mountain Hosting Secure Hosting Solutions for Business http://www.mountainhosting.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: problems with mysql 4.1+suse 10
mario henriquez wrote: hi, i got a problemas in mysql with suse 10 enterprise server, the error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1. when i treat to create a new data base, appears this message. please i need help. thanks. what exact command do you issue to create the DB ? Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with: MySQL 5.0.21 - 64bit
Spoken too soon... Yesterday MySQL died again... there is nothing in the log files... (be it mysqld.log, .err, or /var/log/messages). The hosting provider is running an application called 'big-brother' and a lot of sef-faults appear in the logs from this. I don't know if thins is the cause... if this application is faulting mysql also... The behaviour: the whole machine freezes... all that can be done is to hit the RESET button on the machine ! Friday we downgraded from 5.0 to 4.1. At first we compiled the MySQL server ourselvs... next we deleted it and installed a RPM version... none worked... It appears we hit bug 15815... (http://bugs.mysql.com/bug.php?id=15815)... So be aware with innodb_thread_concurency on 64bit machines... Below are some values as an orientation... for innodb_thread_concurency value per machine workload (at arround 600 simultaneous connections... all used): innodb_thread_concurency / CPU-workload 8 / 90% 4 / 75 - 85% 3 / 60 - 70% 2 / 25% So set it lower... lower... lower... when I left the office friday my colleagues were still working at this... I'll keep you all updated ! -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with: MySQL 5.0.21 - 64bit
Hi Gabriel, Yesterday MySQL died again... there is nothing in the log files... (be it mysqld.log, .err, or /var/log/messages). The hosting provider is running an application called 'big-brother' and a lot of sef-faults appear in the logs from this. I don't know if thins is the cause... if this application is faulting mysql also... The behaviour: the whole machine freezes... all that can be done is to hit the RESET button on the machine ! If the whole machine freezes, this sounds like bad memory, bad cpu, or similar, rather than a MySQL problem. Regardless of how poorly an application could be written, it should not be possible for it to freeze the machine. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with: MySQL 5.0.21 - 64bit
Yup... For now the problem stopped... These humongos values were because they were initialized at MAX_INT on that 64bit machine... In the my.cnf file they were not mentioned at all ! 2^64 - 1 == 18446744073709551615 Now look at the values below ! -- Gabriel PREDA Senior Web Developer On 6/22/06, Dan Buettner [EMAIL PROTECTED] wrote: Gabriel, in your SHOW VARIABLES, I see a handful of settings that are much, much larger than normal: | max_binlog_cache_size | 18446744073709551615 | max_join_size | 18446744073709551615 | max_seeks_for_key | 18446744073709551615 | max_write_lock_count| 18446744073709551615 | myisam_max_sort_file_size | 9223372036854775807 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with: MySQL 5.0.21 - 64bit
Hi, Please let us know what all variables you have configured in your my.cnf files. what is your total size of memory in box. eg : max_connections key_buffer_size sort_buffer_size. Gabriel PREDA wrote: Hi list, Since we bought a better hardware for our dedicated MySQL Server we have been running into some problems. We are using: - Fedora Core 3 - 64bit version - Kernel: 2.6.9-1.667smp - x86_64 - MySQL 5.0.21-standard - for 64bit - RAM: 4 GB - RAID 5 matrix with 3 SCSI disks at 15k rotations We are using InnoDB tables (with one or 2 exceptions... for some FullText indexes)... We are not using transactions... yet ! I'll drop config. details lower... Still at given moments MySQL hangs... it does not accept connections anymore... We can't kill the process... with KILL command... the only thing we can do is ask the hosting provider to do a HARDWARE reset... and someone goes to the machine and pushes the reset button... this hppens at least once a week... Does this happened to someone else ? What was the problem ? Thanx in advance ! -- Thanks Regards, Dilipkumar DBA Support ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with: MySQL 5.0.21 - 64bit
Gabriel, in your SHOW VARIABLES, I see a handful of settings that are much, much larger than normal: | max_binlog_cache_size | 18446744073709551615 | max_join_size | 18446744073709551615 | max_seeks_for_key | 18446744073709551615 | max_write_lock_count| 18446744073709551615 | myisam_max_sort_file_size | 9223372036854775807 These values appear insanely large to me, especially given you've got just 4 GB RAM. I'd adjust these down and see what effect that has. Also, I noticed that your threads_created value seems fairly large (2701) for about 10 hours of uptime. You might consider upping your thread_cache size a bit. Doubt this is causing the hangs though. When the MySQL software hangs, other processes on the machine are still responsive? Anything of interest in your system log? You mention this is new hardware ... wonder if you could have a problem with it. Dan Gabriel PREDA wrote: Hi list, Since we bought a better hardware for our dedicated MySQL Server we have been running into some problems. We are using: - Fedora Core 3 - 64bit version - Kernel: 2.6.9-1.667smp - x86_64 - MySQL 5.0.21-standard - for 64bit - RAM: 4 GB - RAID 5 matrix with 3 SCSI disks at 15k rotations We are using InnoDB tables (with one or 2 exceptions... for some FullText indexes)... We are not using transactions... yet ! I'll drop config. details lower... Still at given moments MySQL hangs... it does not accept connections anymore... We can't kill the process... with KILL command... the only thing we can do is ask the hosting provider to do a HARDWARE reset... and someone goes to the machine and pushes the reset button... this hppens at least once a week... Does this happened to someone else ? What was the problem ? Thanx in advance ! -- Dan Buettner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with Mysql 5 and Visual Basic 5
I think you will need to give the list some more information! What error message do you get? Is it an error when running SQL queries, or a problem connecting to the database? James Harvard At 9:22 am -0300 24/4/06, Gabriel Mahiques wrote: I migrated to mysql 5 but the applications with Visual Basic 5 return error in data. We have installed ODBC 3.51 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems Starting MySQL
Anyone have any ideas on this one? Many thanks. RobL On Friday 10 February 2006 15:07, Rob Lacey wrote: Running as root. RobL On Friday 10 February 2006 14:55, sheeri kritzer wrote: Are you running the startup script as root, or is it setuid? -Sheeri On 2/10/06, Rob Lacey [EMAIL PROTECTED] wrote: Wondering if anyone can shed some light on a problem I am experiencing. I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant Update 2) machine. I have been trying to get the default /etc/init.d/mysqld script to restart the server but I keep running into the same problems. The MySQL server itself is running at the moment and has a number of live databases on it. 060209 18:40:43 mysqld started 060209 18:40:43 [Warning] Can't create test file /var/lib/mysql/thirdeye.lower-test /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 060209 18:40:43 [ERROR] Aborting 060209 18:40:43 [Note] /usr/libexec/mysqld: Shutdown complete 060209 18:40:43 mysqld ended I can't see where the thirdeye.lower-test file creation is coming into this at all. Since as far as can see the startup script doesn't seem to call any script to create test databases. Is this part of mysqld_safe? I can also see that /var/lib/mysql is already owned by mysql.mysql with 755 permissions. Indeed the RedHat startup script makes this so. Therefore the permissions error seems extremely odd as they seem fine to me. I can start the server using the following directly on the command line, which is what the startup script ultimately runs anyway. /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file= /var/run/mysqld/mysqld.pid /dev/null 21 Can anyone give me something further to go on? Many thanks. Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems Starting MySQL
Are you running the startup script as root, or is it setuid? -Sheeri On 2/10/06, Rob Lacey [EMAIL PROTECTED] wrote: Wondering if anyone can shed some light on a problem I am experiencing. I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant Update 2) machine. I have been trying to get the default /etc/init.d/mysqld script to restart the server but I keep running into the same problems. The MySQL server itself is running at the moment and has a number of live databases on it. 060209 18:40:43 mysqld started 060209 18:40:43 [Warning] Can't create test file /var/lib/mysql/thirdeye.lower-test /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 060209 18:40:43 [ERROR] Aborting 060209 18:40:43 [Note] /usr/libexec/mysqld: Shutdown complete 060209 18:40:43 mysqld ended I can't see where the thirdeye.lower-test file creation is coming into this at all. Since as far as can see the startup script doesn't seem to call any script to create test databases. Is this part of mysqld_safe? I can also see that /var/lib/mysql is already owned by mysql.mysql with 755 permissions. Indeed the RedHat startup script makes this so. Therefore the permissions error seems extremely odd as they seem fine to me. I can start the server using the following directly on the command line, which is what the startup script ultimately runs anyway. /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file= /var/run/mysqld/mysqld.pid /dev/null 21 Can anyone give me something further to go on? Many thanks. Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems Starting MySQL
Running as root. RobL On Friday 10 February 2006 14:55, sheeri kritzer wrote: Are you running the startup script as root, or is it setuid? -Sheeri On 2/10/06, Rob Lacey [EMAIL PROTECTED] wrote: Wondering if anyone can shed some light on a problem I am experiencing. I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant Update 2) machine. I have been trying to get the default /etc/init.d/mysqld script to restart the server but I keep running into the same problems. The MySQL server itself is running at the moment and has a number of live databases on it. 060209 18:40:43 mysqld started 060209 18:40:43 [Warning] Can't create test file /var/lib/mysql/thirdeye.lower-test /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 060209 18:40:43 [ERROR] Aborting 060209 18:40:43 [Note] /usr/libexec/mysqld: Shutdown complete 060209 18:40:43 mysqld ended I can't see where the thirdeye.lower-test file creation is coming into this at all. Since as far as can see the startup script doesn't seem to call any script to create test databases. Is this part of mysqld_safe? I can also see that /var/lib/mysql is already owned by mysql.mysql with 755 permissions. Indeed the RedHat startup script makes this so. Therefore the permissions error seems extremely odd as they seem fine to me. I can start the server using the following directly on the command line, which is what the startup script ultimately runs anyway. /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file= /var/run/mysqld/mysqld.pid /dev/null 21 Can anyone give me something further to go on? Many thanks. Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with mysql scheduled backup
Hello. These are some active bugs with different versions of MySQL Administrator. Check if your problem remains with the latest one. Hi All, I'm trying to take scheduled backup from mysql administrator and it always gives me a popup with this message. Enter user name and password for the account under which the task will be executed. it shows me username and password for my windows account and when I click ok on the pop up window, it saves the project . But it never takes the backup at scheduled time or any other time. I can take backups manually by clicking on Execute backup now without any problems. I did all the configuration settings mentioned in the Mysql administrator help. I went in options changed the password setting to obscured. I saw a similar posting for this issue, so I tried the solution mentioned as creating a new connection before taking scheduled backups and that didn't work either. I'm working on windows XP with Mysql server 4.1 and my computer is in a workgroup. Any suggestions will be appreciated. rtroiana [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problems starting MySQL with InnoDB tables
In the process I noticed somehow someone had managed to install a slightly different version of mysql vs. mysql-max, so I uninstalled everything msyql related and started over, came right up with InnoDB support! - Kevin Korngut Mr. Magoo JANIMATION INC. www.janimation.com http://www.janimation.com/ Gleb Paharenko said the following on 5/13/2005 4:34 PM: Hello. You have a rather old version and it is built manually. I suggest you to upgrade to the latest release (4.1.11 or if it is impossible, then to 4.0.24). And check if problem is solved after that. kevin korngut [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: ISO-8859-1, 74 lines --] I'm attempting to configure mysql with InnoDB tables and I'm running into problems. And am using the following version of mysqld-max, Ver 4.0.18-Max for suse-linux on i686 (Source distribution) First I uncommented the following lines in /etc/my.cnf: # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 Then I attempted to start mysqld-max as the user mysql (mysqld-max -u mysql) and got the following: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 80383 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8434638 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbffbcea4, stack_bottom=0x7ca35f80, thread_stack=196608, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x7bcf0ff0 is invalid pointer thd-thread_id=0 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. I then tried mysqld-max -u root which created the InnoDB file; however, when I then attempted to start mysql I got the above error (again, running it as the user mysql and not as root) Anyone seen this or happen to know what's going on?
Re: Re : Problems installing MySQL 4.1 under Fedora Core 3
It only shows this: 050413 23:53:35 mysqld started 050413 23:53:35 mysqld ended Nothing conclusive. prasanna a wrote: Hi please cat the below error file and see /var/lib/mysql/presario2700.err __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems installing MySQL 4.1 under Fedora Core 3
I am pretty sure hat is due to the SELinux policy being set to restrictive. For the brute force fix try editing /etc/selinux/config and set the variable SELINUX=Permissive. There is a more subtle approach that maintains beeter security explained under the SELinux topic in the Fedora doc, sorry I don't have the link handy. Basically you can realx the policy via the targetted settings. Good luck //jjs -Original Message- From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED] Sent: Wed 4/13/2005 10:56 PM To: mysql@lists.mysql.com Subject: Problems installing MySQL 4.1 under Fedora Core 3 I have a Pentium III with Fedora Core 3 notebook and I need to install MySQL 4.1 on it. There was no mysql installed before so I've downloaded the packages and did what I usually do to install the packages. They install great. But when I try to run MySQL I have problems as it does not run. It tries for a while and then quits. I am using the 4.1.11-0.i386 version. I have checked the persmissions under /var/lib/mysql and they were user mysql group root. So I've changed to the MySQL group by using chgrp -R mysql /var/lib/mysql I've created an /etc/my.cnf file by copying the standard /usr/share/doc/packages/MySQL-server/my-medium.cnf It still does not work. My /var/log/messages file shows the following: Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc: denied { append } for pid=5693 exe=/usr/sbin/mysqld path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc: denied { append } for pid=5693 exe=/usr/sbin/mysqld path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file Apr 13 23:53:35 presario2700 kernel: audit(1113458015.267:0): avc: denied { write } for pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 ino=653096 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir Apr 13 23:53:35 presario2700 kernel: audit(1113458015.269:0): avc: denied { write } for pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 ino=653096 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=dir Apr 13 23:54:10 presario2700 lsb_log_message: failed I have no idea what might be wrong. Can anyone help me out? Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Hello. 050314 1:31:06 /usr/sbin/mysqld-max: Shutdown Complete Your error file has this record. And you said that you'd installed only: - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm There are no mysqld-max in listed rpms. I suggest you to check your installation. May be you should remove already installed instances of MySQL and try to install it again. You could also install the server using binary distribution. C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote: I do not know what else to do at this point. I even messed with permissions but I realized it is not the problem. Jeff Steinkamp wrote: Yes, and it look pretty much like yours. Form what I can tell, the daemon is never started during the init cycle, or actually aborts for some reason. Since my machine is a dual boot, Winders and Linux, and I am running a test project on the Winders machine, it will be later this weekend before I can get back to the Linux box and putter around further. Jeff Steinkamp - N7YG Tucson, AZ SCUD Missile Coordinates N32-13-52 W110-52-15 http://home.earthlink.net/~jksteinkamp http://n7yg.webhop.org ___ Nothing is foolproof to a sufficiently talented fool. - Original Message - From: C.F. Scheidecker Antunes [EMAIL PROTECTED] To: Jeff Steinkamp [EMAIL PROTECTED] Sent: Monday, March 14, 2005 10:52 Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box Jeff, I am in SLC Utah. Do you have your /var/log/mysqld.log file? I've put mine on the list so that anyone can see it. thanks, C.F. Jeff Steinkamp wrote: I've had the same problem and for the last month I've not been able to get the mysqld to run. Tried a number of things I've found on the net and nothing works. If you get a solution, I will be interested. Jeff Steinkamp - N7YG Tucson, AZ SCUD Missile Coordinates N32-13-52 W110-52-15 http://home.earthlink.net/~jksteinkamp http://n7yg.webhop.org ___ At 18, I was ashamed of how ignorant my father was. At 21, I was amazed at how much he had learned in three years. - Original Message - From: C.F. Scheidecker Antunes [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, March 13, 2005 21:28 Subject: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended. I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server. The tables are not created not even if I run mysql_install_db. Is there any dependency that is missing? Any necessary library? Any ideas? Thank you, C.F. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Hello. under /var/lib/mysql saying mysqld started and mysqld ended. It is unusual behavior of MySQL to leave the error files without clues. Please, send us the contents of this file. The tables are not created not even if I run mysql_install_db. According to the manual they should be installed automatically, when you're using RPM distribution. How do you start the MySQL server? C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote: Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended. I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server. The tables are not created not even if I run mysql_install_db. Is there any dependency that is missing? Any necessary library? Any ideas? Thank you, C.F. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Hello Mr Paharenko, I have started it with mysqld_safe and I also tried /etc/rc.d/init.d/mysql start Funny thing is that after install the the mysql and test databases are empty so I've tried mysql_install_db which runs but the databases remains empty as well. It is weird. I've done so many MySQL installations under Linux and they are usually so smoth. Any version I try to install on this machine such as 4.0.24 and 4.0.20 is not successful. So I believe that there must be a missing library on this machine. It is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid system. It is running a smp kernel 2.6.10-1.770_FC3smp I am attaching the files for you. As you can see it only has the process number and that it started and ended right away. Again, the base mysql database cannot be created. So I wonder, is there any app missing? If I still FC3 full I can get it running if I remove the original series 3.x and put 4.x Then if I still a clean FC3 and try 4.0 it does not work. Any clues? The attached file is myhost.err under /var/lib/mysql that I've renamed to mysql.log mysqld.log is under /var/log/ and it has the errors Thank you in advance, C.F. Gleb Paharenko wrote: Hello. under /var/lib/mysql saying mysqld started and mysqld ended. It is unusual behavior of MySQL to leave the error files without clues. Please, send us the contents of this file. The tables are not created not even if I run mysql_install_db. According to the manual they should be installed automatically, when you're using RPM distribution. How do you start the MySQL server? C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote: Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended. I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server. The tables are not created not even if I run mysql_install_db. Is there any dependency that is missing? Any necessary library? Any ideas? Thank you, C.F. 050314 02:22:28 mysqld started 050314 02:22:28 mysqld ended 050314 02:27:47 mysqld started 050314 02:27:47 mysqld ended 050314 02:28:00 mysqld started 050314 02:28:00 mysqld ended 050314 01:30:52 mysqld started 050314 01:30:52 mysqld ended 050314 01:30:58 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050314 1:30:58 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050314 1:30:59 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050314 1:30:59 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050314 1:31:02 InnoDB: Started 050314 1:31:02 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:02 Aborting 050314 1:31:02 InnoDB: Starting shutdown... 050314 1:31:06 InnoDB: Shutdown completed 050314 1:31:06 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:06 mysqld ended 050314 01:31:32 mysqld started 050314 1:31:32 InnoDB: Started 050314 1:31:32 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:32 Aborting 050314 1:31:32 InnoDB: Starting shutdown... 050314 1:31:35 InnoDB: Shutdown completed 050314 1:31:35 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:35 mysqld ended 050314 01:32:03 mysqld started 050314 1:32:03 InnoDB: Started 050314 1:32:03 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:03 Aborting 050314 1:32:03 InnoDB: Starting shutdown... 050314 1:32:05 InnoDB: Shutdown completed 050314 1:32:05 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:32:05 mysqld ended 050314 01:32:41 mysqld started 050314 1:32:41 InnoDB: Started 050314 1:32:41 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:41 Aborting 050314 1:32:41 InnoDB: Starting shutdown... 050314 1:32:43 InnoDB: Shutdown completed 050314 1:32:43 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:32:43 mysqld ended 050314 01:32:58 mysqld started 050314 1:32:59 InnoDB: Started 050314 1:32:59 Fatal error: Can't
Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
C.F. Scheidecker Antunes wrote: Hello Mr Paharenko, I have started it with mysqld_safe and I also tried /etc/rc.d/init.d/mysql start Funny thing is that after install the the mysql and test databases are empty so I've tried mysql_install_db which runs but the databases remains empty as well. It is weird. I've done so many MySQL installations under Linux and they are usually so smoth. Any version I try to install on this machine such as 4.0.24 and 4.0.20 is not successful. So I believe that there must be a missing library on this machine. It is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid system. It is running a smp kernel 2.6.10-1.770_FC3smp Fedora supplied RPMS initialize the database when you do a 'service mysqld start' Have you done this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
C.F. Scheidecker Antunes wrote: Hello Mr Paharenko, I have started it with mysqld_safe and I also tried /etc/rc.d/init.d/mysql start Funny thing is that after install the the mysql and test databases are empty so I've tried mysql_install_db which runs but the databases remains empty as well. It is weird. I've done so many MySQL installations under Linux and they are usually so smoth. Any version I try to install on this machine such as 4.0.24 and 4.0.20 is not successful. So I believe that there must be a missing library on this machine. It is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid system. It is running a smp kernel 2.6.10-1.770_FC3smp I am attaching the files for you. As you can see it only has the process number and that it started and ended right away. Again, the base mysql database cannot be created. So I wonder, is there any app missing? If I still FC3 full I can get it running if I remove the original series 3.x and put 4.x Then if I still a clean FC3 and try 4.0 it does not work. Any clues? The attached file is myhost.err under /var/lib/mysql that I've renamed to mysql.log mysqld.log is under /var/log/ and it has the errors Thank you in advance, C.F. Gleb Paharenko wrote: Hello. under /var/lib/mysql saying mysqld started and mysqld ended. It is unusual behavior of MySQL to leave the error files without clues. Please, send us the contents of this file. The tables are not created not even if I run mysql_install_db. According to the manual they should be installed automatically, when you're using RPM distribution. How do you start the MySQL server? C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote: Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended. I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server. The tables are not created not even if I run mysql_install_db. Is there any dependency that is missing? Any necessary library? Any ideas? Thank you, C.F. 050314 02:22:28 mysqld started 050314 02:22:28 mysqld ended 050314 02:27:47 mysqld started 050314 02:27:47 mysqld ended 050314 02:28:00 mysqld started 050314 02:28:00 mysqld ended 050314 01:30:52 mysqld started 050314 01:30:52 mysqld ended 050314 01:30:58 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050314 1:30:58 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050314 1:30:59 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050314 1:30:59 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050314 1:31:02 InnoDB: Started 050314 1:31:02 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:02 Aborting 050314 1:31:02 InnoDB: Starting shutdown... 050314 1:31:06 InnoDB: Shutdown completed 050314 1:31:06 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:06 mysqld ended 050314 01:31:32 mysqld started 050314 1:31:32 InnoDB: Started 050314 1:31:32 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:32 Aborting 050314 1:31:32 InnoDB: Starting shutdown... 050314 1:31:35 InnoDB: Shutdown completed 050314 1:31:35 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:35 mysqld ended 050314 01:32:03 mysqld started 050314 1:32:03 InnoDB: Started 050314 1:32:03 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:03 Aborting 050314 1:32:03 InnoDB: Starting shutdown... 050314 1:32:05 InnoDB: Shutdown completed 050314 1:32:05 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:32:05 mysqld ended 050314 01:32:41 mysqld started 050314 1:32:41 InnoDB: Started 050314 1:32:41 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:41 Aborting 050314 1:32:41 InnoDB: Starting shutdown... 050314 1:32:43 InnoDB: Shutdown completed 050314 1:32:43
Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Hi Bob, Yes the ownership is correct. In fact I did a chmod -R mysql:mysql /var/lib/mysql and I still have the same problem. I wonder if it is because I am running a dual processor machine. Robert A. Rawlinson wrote: C.F. Scheidecker Antunes wrote: Hello Mr Paharenko, I have started it with mysqld_safe and I also tried /etc/rc.d/init.d/mysql start Funny thing is that after install the the mysql and test databases are empty so I've tried mysql_install_db which runs but the databases remains empty as well. It is weird. I've done so many MySQL installations under Linux and they are usually so smoth. Any version I try to install on this machine such as 4.0.24 and 4.0.20 is not successful. So I believe that there must be a missing library on this machine. It is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid system. It is running a smp kernel 2.6.10-1.770_FC3smp I am attaching the files for you. As you can see it only has the process number and that it started and ended right away. Again, the base mysql database cannot be created. So I wonder, is there any app missing? If I still FC3 full I can get it running if I remove the original series 3.x and put 4.x Then if I still a clean FC3 and try 4.0 it does not work. Any clues? The attached file is myhost.err under /var/lib/mysql that I've renamed to mysql.log mysqld.log is under /var/log/ and it has the errors Thank you in advance, C.F. Gleb Paharenko wrote: Hello. under /var/lib/mysql saying mysqld started and mysqld ended. It is unusual behavior of MySQL to leave the error files without clues. Please, send us the contents of this file. The tables are not created not even if I run mysql_install_db. According to the manual they should be installed automatically, when you're using RPM distribution. How do you start the MySQL server? C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote: Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended. I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server. The tables are not created not even if I run mysql_install_db. Is there any dependency that is missing? Any necessary library? Any ideas? Thank you, C.F. 050314 02:22:28 mysqld started 050314 02:22:28 mysqld ended 050314 02:27:47 mysqld started 050314 02:27:47 mysqld ended 050314 02:28:00 mysqld started 050314 02:28:00 mysqld ended 050314 01:30:52 mysqld started 050314 01:30:52 mysqld ended 050314 01:30:58 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050314 1:30:58 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050314 1:30:59 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050314 1:30:59 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050314 1:31:02 InnoDB: Started 050314 1:31:02 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:02 Aborting 050314 1:31:02 InnoDB: Starting shutdown... 050314 1:31:06 InnoDB: Shutdown completed 050314 1:31:06 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:06 mysqld ended 050314 01:31:32 mysqld started 050314 1:31:32 InnoDB: Started 050314 1:31:32 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:31:32 Aborting 050314 1:31:32 InnoDB: Starting shutdown... 050314 1:31:35 InnoDB: Shutdown completed 050314 1:31:35 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:31:35 mysqld ended 050314 01:32:03 mysqld started 050314 1:32:03 InnoDB: Started 050314 1:32:03 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050314 1:32:03 Aborting 050314 1:32:03 InnoDB: Starting shutdown... 050314 1:32:05 InnoDB: Shutdown completed 050314 1:32:05 /usr/sbin/mysqld-max: Shutdown Complete 050314 01:32:05 mysqld ended 050314 01:32:41 mysqld started 050314 1:32:41 InnoDB:
Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
I do not know what else to do at this point. I even messed with permissions but I realized it is not the problem. Jeff Steinkamp wrote: Yes, and it look pretty much like yours. Form what I can tell, the daemon is never started during the init cycle, or actually aborts for some reason. Since my machine is a dual boot, Winders and Linux, and I am running a test project on the Winders machine, it will be later this weekend before I can get back to the Linux box and putter around further. Jeff Steinkamp - N7YG Tucson, AZ SCUD Missile Coordinates N32-13-52 W110-52-15 http://home.earthlink.net/~jksteinkamp http://n7yg.webhop.org ___ Nothing is foolproof to a sufficiently talented fool. - Original Message - From: C.F. Scheidecker Antunes [EMAIL PROTECTED] To: Jeff Steinkamp [EMAIL PROTECTED] Sent: Monday, March 14, 2005 10:52 Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box Jeff, I am in SLC Utah. Do you have your /var/log/mysqld.log file? I've put mine on the list so that anyone can see it. thanks, C.F. Jeff Steinkamp wrote: I've had the same problem and for the last month I've not been able to get the mysqld to run. Tried a number of things I've found on the net and nothing works. If you get a solution, I will be interested. Jeff Steinkamp - N7YG Tucson, AZ SCUD Missile Coordinates N32-13-52 W110-52-15 http://home.earthlink.net/~jksteinkamp http://n7yg.webhop.org ___ At 18, I was ashamed of how ignorant my father was. At 21, I was amazed at how much he had learned in three years. - Original Message - From: C.F. Scheidecker Antunes [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, March 13, 2005 21:28 Subject: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended. I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server. The tables are not created not even if I run mysql_install_db. Is there any dependency that is missing? Any necessary library? Any ideas? Thank you, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems installing MySql...
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM: I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for Windows Server 2003. When I try to use the MySql Administator, and put in the server name, root account and password defined in the my.ini file, it doesn't connect, using 'localhost'. What am I doing incorrectly? Steve Did you remember to cross your fingers and gnash your teeth? What about the blue button, did you press it? (Just kidding) First off, you left out a lot of useful information about your situation: How did you install the 4.0.23 (zip, msi,...)? Have you verified that the server is running? What other connection methods have you tried? Did they work? Have you been following the documented installation procedure ( http://dev.mysql.com/doc/mysql/en/installing.html)? If you have, what step are you on? Have you looked at the Troubleshooting guide ( http://dev.mysql.com/doc/mysql/en/problems.html)? Besides posting to this list, what other things have you tried? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Problems installing MySql...
reconstituted from a munged response (original post) Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM: I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for Windows Server 2003. When I try to use the MySql Administator, and put in the server name, root account and password defined in the my.ini file, it doesn't connect, using 'localhost'. What am I doing incorrectly? Steve Did you remember to cross your fingers and gnash your teeth? What about the blue button, did you press it? (Just kidding) First off, you left out a lot of useful information about your situation: How did you install the 4.0.23 (zip, msi,...)? Have you verified that the server is running? What other connection methods have you tried? Did they work? Have you been following the documented installation procedure ( http://dev.mysql.com/doc/mysql/en/installing.html)? If you have, what step are you on? Have you looked at the Troubleshooting guide ( http://dev.mysql.com/doc/mysql/en/problems.html)? Besides posting to this list, what other things have you tried? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Steve's Reply Steve Grosz [EMAIL PROTECTED] wrote on 02/09/2005 02:01:14 PM: I guess I didn't hold my mouth right.hate it when that happens! :-) I installed from a ZIP file, and the Admin tool does show that the server is running. I have tried to telnet into that server, and it fails, but that may be due to the firewall. Currently I am on step #2.3.10 of the install process. If I didn't answer all your questions, let me know! Thanks for the help!! Steve Just curious, if you are being faithful to the installation docs How is the Admin tool running? You aren't to that step yet... ;-) Anyway, it's odd that you cannot telnet to a server when you say it is up. Note: You DO NOT get a normal telnet session, all you should be able to see when you telnet to a MySQL server is the version number and some garbage characters. That tells you that you have port-to-port connectivity from your machine to the server. It would be prohibitively difficult to use telnet (read: practically impossible) to work directly with a MySQL server manually through telnet. How did you start the server, is it installed as a service or are you running it manually from a command prompt? Is your problem connecting to the server through mysqladmin or getting the server running? Can you connect through the command line client mysql.exe? What error messages are you getting and from what program? And one last thing... please CC: the list on all responses. It will not only help the next dba through a similar issue but it will also make sure you get more responses. In the event that I became unavailable or gave you bad advice, anyone else on the list could kick in and help get you going, too. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Problems installing MySql...
Steve Grosz [EMAIL PROTECTED] wrote on 02/09/2005 03:43:22 PM: I downloaded the MySql Administrator and simply run that. and dragged the icon to the startup menu so it loads MySql on startup. Not entirely sure how to load MySql as a 'service' on Win2003 Server. The only message I get, and this is when trying to administer the server through the Admin tool, is that it can't connect to 'localhost' with 'root' and 'password' defined in my.ini Steve snip - see previous posts in this thread for history Since you are on installation step 2.3.10, I can only guess that you haven't started your MySQL server. There are normally 2 programs you have to have going to use MySQL. The server and a client. I don't think you have your server going. Follow the directions from 2.3.10 on and you should complete your installation just fine. (I would skip 2.3.11 since you are going to be running MySQL as a service anyway) 2.3.13 shows how to test your setup. 2.3.14 has troubleshooting advice. IF you finish the installation procedure and still cannot connect. Come back to the list again and we will be able to help you out some more, OK? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Problems with Mysql database and PHPAdmin
Creating a database is a separate thing from adding permissions for a database to the grant tables. When you create a database it's a free floating database that nobody (except root) has permission to access until you issue the grant statements to make someone own it. But nobody actually owns the database, they just have permission to access and use it. Conversely, you could issue grant statements that allow someone to access and use a database that doesn't exist. You could then later at your leisure create the database. Nothing's automatically added to the grant tables when you create a database, and no database is automatically created when you add entries for a nonexistent one to the grant tables. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems with MySQL 4.0.20
Thank you very much for your bug report! And sorry if I doubted your report at the beginning; I hadn't thought of the rpm script. No problem. I sometimes get bug reports that I know are impossible! Yet they weren't. This one I would have barely noticed if it had not knocked the slaves all offline. Mysql query just in case. -steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with MySQL 4.0.20
Hi! On May 25, Steven Roussey wrote: We had some servers that were upgraded from 4.0.17/18 to 4.0.20 and had several problems thereafter: 1. Tables with FTS indices became corrupted, with queries on them causing segfaults on the servers. Hmm, I don't see any changes in ft-related files since 4.0.18 that could cause it (there were bugfixes, but they affect only *searching* - that is MATCH - and not *updating*). Can you create a test case ? 2. BinLog files were getting created with ownership of root, not mysql. Then Mysql complains that it can not read the file and so goes and creates another (which is fine and owned by mysql). All slaves to the master then die with corruption warnings about the master. I don't really understand how it can happen - I'll let others comment on it. 3. All servers suddenly have a lot of connection errors: Aborted connection 109 to db: 'xyz' user: 'aaa' host: `something.i' (Got timeout reading communication packets) I think, this is because --log-warnings was changed to be ON by default. Disable with --skip-log-warnings 4. Thread stack warnings: Warning: Asked for 196608 thread stack, but got 126976 Same here. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with MySQL 4.0.20
From: Sergei Golubchik [EMAIL PROTECTED] 4. Thread stack warnings: Warning: Asked for 196608 thread stack, but got 126976 Same here. OK, we can disable the warnings in the log file, but what's really behind this warning? A brand new, plain vanilla Fedora Core2 (aka RedHat FC2) installation with MySQL 4.0.20 produced this warning immediately. Does MySQL want more thread stack space? How badly does it need it? How can one make the OS to give it more? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems with MySQL 4.0.20
We start mysql with 'service mysql start' (we install from the RPM for linux). I've never seen mysql create binlog files under the name root before, and after reverting to an old version, it doesn't again. It created a big mess with all the slaves stuck at the end of an older binlog and not advancing to the next one and complaining about corruption. Unfortunately, I don't have the contents of the log (I think the size of the file was 79 bytes) since a script here checks that all the slaves are at a certain point and then deletes the logs on the master. Log: 040519 17:53:41 mysqld started /usr/sbin/mysqld: ready for connections. Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 040520 16:58:54 /usr/sbin/mysqld: Normal shutdown 040520 16:58:56 /usr/sbin/mysqld: Shutdown Complete 040520 16:58:56 mysqld ended 040520 16:59:10 mysqld started 040520 16:59:10 Warning: Asked for 196608 thread stack, but got 126976 /usr/sbin/mysqld: ready for connections. Version: '4.0.20-standard-log' socket: '/tmp/mysql.sock' port: 3306 040520 16:59:14 Failed to open log (file '/binlogs/binlog.032', errno 13) 040520 16:59:34 Aborted connection 134 to db: 'db' user: 'aaa' host: `something.i' (Got an error writing communication packets) 040520 16:59:36 Aborted connection 544 to db: 'db' user: 'aaa' host: `something.i' (Got an error writing communication packets) 040520 16:59:36 Aborted connection 541 to db: 'db' user: 'aaa' host: `something.i' (Got an error writing communication packets) Binary logs are created by the mysqld daemon (after mysqld possibly changes to uid of 'mysql' if --user=mysql was used). So in any case, if mysqld is running as user mysql (no matter if it was 'mysql' which started mysqld or if it was 'root' which did 'mysqld --user=mysql'), the binary logs are created by 'mysql'. If you have some binary logs created by 'root', it means 'mysqld' was run as 'root'; this is what you should really check (if you can provide us with the way you started mysqld ('service mysql start', whatever) and a listing of 'ps -elf | grep mysqld', we may be able to check if it is a MySQL bug but this is quite unlikely, from the above reasoning). Thank you! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Guilhem Bichot [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Software Developer /_/ /_/\_, /___/\___\_\___/ Bordeaux, France ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems with MySQL 4.0.20
Hmm, I don't see any changes in ft-related files since 4.0.18 that could cause it (there were bugfixes, but they affect only *searching* - that is MATCH - and not *updating*). Can you create a test case ? Well, I put up a file in the secret folder a few days ago as referenced in a bug report: http://bugs.mysql.com/?id=3870 There is a select statement that crashes the server found in the log file. I put the files up and posted the bug from a remote computer and couldn't write much about it at the time. The table is fine according to 'check table the_table_name'. The select crashes it. The select also crashes it in older versions of myslq!! Doing a repair in the old version and then doing the select in the old version is OK. That is why I came to the conclusion that the file is corrupt. CHECK TABLE does not find the corruption, however. Another note on this: The tables I had the most problems with had FTS indicies. I can't say that it is more than coincidental just yet. I am not conclusive that it is a cause and effect relationship at this time. Even returning to the older versions of mysql is not getting rid of all our problems (we are seeing extremely high loads on the same stream of queries as usual). Selectively repairing tables has helped. It may be that it is not FTS related and we should repair all tables. We are going to try that tonight. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with Mysql 4.0.15+Tomcat 4.0
Abubakr wrote: Hi, i m using mysql 4.0.15 and tomcat 4 as a webserver on linux 8 machine, now the problem that i am facing is that while testing my web application when i send too many refresh requests to the web page, the server's CPU utilization reaches to 100% for a very long duration of time and on checking the processes going on the server, i see hundreds of processes for tomcat and mysql. Now what am i suppose to do to save my server from crashing and at the same time fulfilling maximum number of requests. I will be very thank ful to u. This could be a Tomcat or MySQL problem, but let's make sure it is not MySQL first. Enable log-slow-queries and log-long-format, then audit the slow log, explain all of the queries that end up there and optimize them starting at the ones that examine the most rows first. To automate the process, you might find my query-wizzard utility helpful, which you can get at http://www.wiley.com/compbooks/pachev/ -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems with mysql
First of all, get rid of Windows and use Linux =) Secondly, try downloading the newest version 4.0.18-nt from mysql.com. That will help you out. I run both Windows, Mac, and Linux versions of MySQL and haven't had any problems with the MySQL installer for any OS. If you have any other questions, please don't hesitate. J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with mysql
Two things first, first of all you obviously don't have mysql correctly installed, message a means mysql dead unexpectedly while trying to start, mysql cannot start. Why? I just don't know you didn't detailed your install procedure. Message b means that you cannot connect to the db because message a. No server is listening on default port or in the default socket. Now... what to do? 1.- Download a more recently mysql version, latest is .18 2.- Check your install procedure and find out the correct procedure at: http://www.mysql.com/doc/en/Quick_Standard_Installation.html, installing mysql is more that simply running the installer (HINT: don't use the installer, use the zip, it is easier to manage) 3.- Would you mind detailing your install procedure, in a step-by-step fashion so we can better help you? Best Regards! On Sun, 2004-02-29 at 10:33, [EMAIL PROTECTED] wrote: Hi, I am currently experiencing a few problems getting mysql to run on my PC. I have a windows XP machine P4 2.6 GHZ. I have downloaded the version mysql 4.0.15 from mysql.com and am struggling to get the program to work. I have follwed the instructions listed in a book i purchased called mysql made easy by Mike McGrath. I currently recieve two error messages when trying to a) start the sql server and b) open the sql monitor. The error messages are as follows: a) Error 1067: The process terminated unexpectedly b) Error 2003: Can't connect to mysql server on 'localhost' 100617 Any help you could offer me would be really appreciated Kind regards Farryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with MySQL on Linux (Linux Newbie)
Donald Tyler [EMAIL PROTECTED] wrote: I am just learning to use Linux and I am having some problems with getting MySQL to load. I have successfully installed tested both Apache PHP, so I am pretty comfortable with the whole configure and make processes. I followed the MySQL installation docs to the letter, however when I try to load the MySQL daemon as instructed, the program just quits after a few seconds. Here is the terminal output: [EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql [1] 30010 [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /var/lib/mysql 030923 09:30:18 mysqld ended Anyone know what I am doing wrong? You can find causes in the error log file (host_name.err file in the /var/lib/mysql). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problems with mysql thru command line
karl james [EMAIL PROTECTED] wrote: Im kinda new at creating databases thru the command line When I try to login using. Mysql -h hostname -username -p I get this message on command line. C:\Documents and Settings\Karl Jamesmysql -h hostname -u username -p -p; 'mysql' is not a recognized as a internal or exteranl command, operable program or batch file. Am I in the wrong section on my computer, what am I doing wrong Im trying to follow examples in book, but its not working right with me. Run it from MySQL /bin directory. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with MySQL, Windows 2003, IIS6, ASP?
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with MySQL, Windows 2003, IIS6, ASP?
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems compiling Mysql in Alpha with Tru64Unix V5.1
julio [EMAIL PROTECTED] wrote: I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8. # make No suffix list. To me it looks like you are running the wrong make, not GNU one. Can help me Julio Rocha -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Problems Configuring MySQL...
Alejandro, Thursday, December 05, 2002, 4:03:23 PM, you wrote: ACG Hi all and thx in advance for trying to fix my problem. ACG I'm instaling for the first time MySQL and when I try to test the program, I ACG receive an error like Cannot connect to localhost (100060)...How can I ACG configure the MySQL. It usually means that MySQL server isn't running. You should run MySQL server as a service or in standalone mode (as I suppose you are using Windows): http://www.mysql.com/doc/en/NT_start.html http://www.mysql.com/doc/en/Win95_start.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Problems installing mysql-max-3.23.53a linux binaries
Hi all. I resolved the problem of starting mysql server changing permissions of /tmp directory to permit user mysql write /tmp/mysql.sock. But when I start mysql server with /etc/init.d/mysql server start I get error @HOSTNAME@. prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Iago Sineiro. -Mensaje original- De: Iago Sineiro [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 20 de noviembre de 2002 10:37 Para: MySql Mail List Asunto: Problems installing mysql-max-3.23.53a linux binaries Hi all. I've downloaded mysql-max-3.23.53a-pc-linux-gnu-i686.tar from www.mysql.com and tried to install it on a linux box. I followed the steps provided at http://www.mysql.com/doc/en/Installing_binary.html shell groupadd mysql (Not really, I have a mysql group) shell useradd -g mysql mysql (Not really, I have a mysql user) shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/safe_mysqld --user=mysql When I execute bin/safe_mysqld --user=mysql prototipo mysql # bin/safe_mysqld --user=mysql [1] 948 prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data 021120 12:49:15 mysqld ended If I look at mysql log: 021120 11:51:26 mysqld started 021120 11:51:26 Can't start server : Bind on unix socket: Permission denied 021120 11:51:26 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 021120 11:51:26 Aborting 021120 11:51:26 /usr/local/mysql/bin/mysqld: Shutdown Complete Also after copying a my.cnf configuration file from support-files to /etc/my.cnf and mysql.server to /etc/init.d/ if I execute /etc/init.d/mysql.server start I also get an error for variable @HOSTNAME and print-defaults: prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data 021120 12:52:05 mysqld ended Iago Sineiro. - 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: Problems installing mysql-max-3.23.53a linux binaries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 20 November 2002 11:41, Iago Sineiro wrote: I resolved the problem of starting mysql server changing permissions of /tmp directory to permit user mysql write /tmp/mysql.sock. But when I start mysql server with /etc/init.d/mysql server start I get error @HOSTNAME@. prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Hmm, that's interesting. Seems like the build script did not replace this variable with the correct path to the hostname binary. For the time being, please replace @HOSTNAME@ with /bin/hostname. [SNIP] then - - pid_file=$datadir/`@HOSTNAME@`.pid + pid_file=$datadir/`/bin/hostname`.pid else [SNIP] Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE923GZSVDhKrJykfIRAh+SAJ9RbPIJUZucM55fa6L9TdRBI2wAqwCdEofI hW/WYU3k48feRG3MyO7VbjU= =GCQu -END PGP SIGNATURE- - 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: Problems installing mysql-max-3.23.53a linux binaries
Thanks Lenz. Now, after modifying the init script, I don't get the advise. Iago Sineiro. -Mensaje original- De: Lenz Grimmer [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 20 de noviembre de 2002 12:27 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: Problems installing mysql-max-3.23.53a linux binaries -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 20 November 2002 11:41, Iago Sineiro wrote: I resolved the problem of starting mysql server changing permissions of /tmp directory to permit user mysql write /tmp/mysql.sock. But when I start mysql server with /etc/init.d/mysql server start I get error @HOSTNAME@. prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Hmm, that's interesting. Seems like the build script did not replace this variable with the correct path to the hostname binary. For the time being, please replace @HOSTNAME@ with /bin/hostname. [SNIP] then - - pid_file=$datadir/`@HOSTNAME@`.pid + pid_file=$datadir/`/bin/hostname`.pid else [SNIP] Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE923GZSVDhKrJykfIRAh+SAJ9RbPIJUZucM55fa6L9TdRBI2wAqwCdEofI hW/WYU3k48feRG3MyO7VbjU= =GCQu -END PGP SIGNATURE- - 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: problems with mySQL and server
Nir, Tuesday, September 24, 2002, 6:21:39 PM, you wrote: NG I am trying to get mySQL set up and am having problems. I am using Win2000. NG I am using the Apache server and believe I have that set up properly as the NG server is in the running state. When I type mysql in the DOS prompt, the NG following error is returned: NG Can't connect to mySQL server on 'localhost'. NG I tried changing the localhost to the hostname of the machine, and I get NG the same error: only with localhost replaced with the name inputted. I am NG using the same machine for both server/client. Check that MySQL is really running. Check also the following link: http://www.mysql.com/doc/en/Can_not_connect_to_server.html There are some notes about your problem. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: Problems starting mysql on sun solaris 8
chown -R mysql.mysql /usr/local/mysql ROUTLEY, Merrindal (MR) wrote: Hi all, I have recently downloaded mysql version 3.23.45 and I am struggling to get it to start. Every time I type in ./safe_mysqld the program starts and then shuts down immediately with the following being written to the error log: --- mysqld started /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno:13) /usr/local/mysql/libexec/mysqld: Normal Shutdown --- Initially there wasn't any 'host.frm' in the mysql home directory but I found one in the mysql/var/mysql directory. I've tried creating a link from the mysql home directory to the host.frm in the mysql/var/mysql directory but this makes no difference. I've tried changing permissions on both the host.frm file and the link so that they were read/write/execute for everybody but this makes no difference. I am running the 'safe_mysqld' command as root. I have run the ./mysql_install_db command which I think has run sucessfully. I received the following message when I ran this command. - 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: Problems starting MySQL as a Service for all users
Kirk, I am somewhat confused by your question. I must misunderstand what it is that you are trying to ask, because what it appears that you are asking makes no sense. Once MySQL was installed as a service, why does it matter which account starts it? Are you not the admin on the box? Are you trying to start multiple instances of the MySQL service? Logging off of the admin account will not stop a service on a Windows 2000 box. Even though you log off the admin account, MySQL should still be running. Or, when you say started do you mean connect to the running server? What is the output of the following command on the server running MySQL? netstat -a -p tcp Respectfully, Charles Q. At 08:23 PM 6/5/2002 -0500, you wrote: I've installed MySQL as a service using mysqld-nt --install on W2K. No problem there, says service successfully installed. BUT, when I try to log off the admin account and on to the regular power user account MySQL will not start automagically and cannot be started manually. Pop back over to the admin account and MySQL acts like nothing was ever wrong. Is this an issue that can be overcome by manually installing MySQL as a service instead of using the above? And how do you accomplish that? If you know or have heard of this before please help me out; I'd really like to have MySQL running for all users (that would enable the Apache-based site I'm running on the same box to access the database at all times). Thanks! Kirk - 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: Problems starting MySQL as a Service for all users
I don't think this makes sense either, but you will see what I mean: FOR MY ADMIN ACCOUNT C:\netstat -a -p tcp Active Connections Proto Local Address Foreign AddressState TCPdynamic:http dynamic:0 LISTENING TCPdynamic:epmap dynamic:0 LISTENING TCPdynamic:microsoft-ds dynamic:0 LISTENING TCPdynamic:1025 dynamic:0 LISTENING TCPdynamic:1027 dynamic:0 LISTENING TCPdynamic:1031 dynamic:0 LISTENING TCPdynamic:3306 dynamic:0 LISTENING TCPdynamic:1031 dynamic:3306 ESTABLISHED TCPdynamic:3306 dynamic:1031 ESTABLISHED TCPdynamic:netbios-ssndynamic:0 LISTENING FOR THE REGULAR USER ACCOUNT C:\netstat -a -p tcp Active Connections Proto Local Address Foreign AddressState TCPdynamic:http dynamic:0 LISTENING TCPdynamic:epmap dynamic:0 LISTENING TCPdynamic:microsoft-ds dynamic:0 LISTENING TCPdynamic:1025 dynamic:0 LISTENING TCPdynamic:1027 dynamic:0 LISTENING TCPdynamic:3306 dynamic:0 LISTENING TCPdynamic:netbios-ssndynamic:0 LISTENING I was under the impression that once something is installed as a service, it is available to the system for all users. This is not the case here. In fact, once I log off admin and onto the other accounts the winmysqladmin manager (which I put in startup for all users) asks if I want to install the service!!! When I click OK it says install failed and I actually have to shut down the tool in order to log off (or else the system hangs). My web site can connect to the server using PHP scripts to grab data with no problems when the admin account is running, but as soon as I log off and on to another account the dynamic part of the site dies. Again, when I was on my admin account I installed the MySQL service from the command prompt using: mysqld-nt --install and the result was service has been installed (paraphrasing). I have uninstalled MySQL completely and reinstalled only to run into the same problem. I'm using the 3.23.49 binary package. -Kirk -Original Message- From: Charles Quesenberry [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:25 AM To: Kirk Brannan Babb Cc: [EMAIL PROTECTED] Subject: Re: Problems starting MySQL as a Service for all users Kirk, I am somewhat confused by your question. I must misunderstand what it is that you are trying to ask, because what it appears that you are asking makes no sense. Once MySQL was installed as a service, why does it matter which account starts it? Are you not the admin on the box? Are you trying to start multiple instances of the MySQL service? Logging off of the admin account will not stop a service on a Windows 2000 box. Even though you log off the admin account, MySQL should still be running. Or, when you say started do you mean connect to the running server? What is the output of the following command on the server running MySQL? netstat -a -p tcp Respectfully, Charles Q. At 08:23 PM 6/5/2002 -0500, you wrote: I've installed MySQL as a service using mysqld-nt --install on W2K. No problem there, says service successfully installed. BUT, when I try to log off the admin account and on to the regular power user account MySQL will not start automagically and cannot be started manually. Pop back over to the admin account and MySQL acts like nothing was ever wrong. Is this an issue that can be overcome by manually installing MySQL as a service instead of using the above? And how do you accomplish that? If you know or have heard of this before please help me out; I'd really like to have MySQL running for all users (that would enable the Apache-based site I'm running on the same box to access the database at all times). Thanks! Kirk - 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: Problems starting MySQL as a Service for all users
FOR MY ADMIN ACCOUNT C:\netstat -a -p tcp TCPdynamic:3306 dynamic:0 LISTENING FOR THE REGULAR USER ACCOUNT C:\netstat -a -p tcp TCPdynamic:3306 dynamic:0 LISTENING ^ The port is available under both accounts - the server is running. I was under the impression that once something is installed as a service, it is available to the system for all users. This is not the case here. In fact, once I log off admin and onto the other accounts I just proove you wrong... Again, when I was on my admin account I installed the MySQL service from the command prompt using: mysqld-nt --install and the result was service has been installed (paraphrasing). I have uninstalled MySQL completely and reinstalled only to run into the same problem. I'm using the 3.23.49 binary package. In your service manager (in the control panel), is the service listed there, and is it started? I personally, don't use the GUI mysqladmin utility. mysql-nt --install installs the service, then I use service manager just like I would for any other service (like IIS) on NT to be started. When you're as a default non admin user account, did you ever try mysql to connect to the server, or even better, telnet to port 3306 ? If so, what errors did you receive back from mysql or the telnet? If you didn't maybe it's time that you do. I doubt this is a service related problem, but I may be wrong... Using the right usernames / passwords / host addresses will also help your cause when you have trouble connecting to the mysql server. -Original Message- From: Charles Quesenberry [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:25 AM To: Kirk Brannan Babb Cc: [EMAIL PROTECTED] Subject: Re: Problems starting MySQL as a Service for all users Kirk, I am somewhat confused by your question. I must misunderstand what it is that you are trying to ask, because what it appears that you are asking makes no sense. Once MySQL was installed as a service, why does it matter which account starts it? Are you not the admin on the box? Are you trying to start multiple instances of the MySQL service? Logging off of the admin account will not stop a service on a Windows 2000 box. Even though you log off the admin account, MySQL should still be running. Or, when you say started do you mean connect to the running server? What is the output of the following command on the server running MySQL? netstat -a -p tcp Respectfully, Charles Q. At 08:23 PM 6/5/2002 -0500, you wrote: I've installed MySQL as a service using mysqld-nt --install on W2K. No problem there, says service successfully installed. BUT, when I try to log off the admin account and on to the regular power user account MySQL will not start automagically and cannot be started manually. Pop back over to the admin account and MySQL acts like nothing was ever wrong. Is this an issue that can be overcome by manually installing MySQL as a service instead of using the above? And how do you accomplish that? If you know or have heard of this before please help me out; I'd really like to have MySQL running for all users (that would enable the Apache-based site I'm running on the same box to access the database at all times). Thanks! Kirk - 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 - 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: problems compiling mysql
Hello, As I understood segmentation fault happens during compilation? Segmentation fault happens always at the same point? If not then it is a problem of your memory, try memtest86 to test your memory (not your but your computer :) ) If it always happens at the same point than it is a kind of incompatibility between MySQL sources and your compilation environment (gcc, make, etc) MySQL has very narrow set of compatible GCC versions. It should by something from 2.95 and 2.91 families (even not whole families may be) no less no more. I have tried this 3 times so far every time i do a 'make', after a while, i get this message: make[2] *** [my_net.lo] Segmentation fault make[2] Leaving directory '/home/per0xide/mysql-3.23.49/libmysql' make[1] *** [all-recursive] Error 1 make[1] Leaving directory ' /home/per0xide/mysql-3.23.49' make:*** [all-recursive-am] Error 2 i have tried it with 3 different versions.. 3.23.49, and 2 of the older versions... and they all crash the same way... i am running debian 2.2... anyone know what the problem could be, and how i can fix it? Thanks, James Thogmartin - 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 -- Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 e-mail: [EMAIL PROTECTED] - 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: Problems installing MySQL on FreeBSD 4.5
Hi Darrin, This is very starnge as I just installed two FreeBSD 4.5 machines this week and had no problems! I installed on SMP based machines, with very few changes from the GENERIC kernel. Is this a fresh install of FreeBSD 4.5? If not can you run a 'make world' and 'make kernel' again? Did you run mergemaster after the upgrade (if it was an upgrade)? Is there anything unusla about you install? Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 9:43 AM Subject: Problems installing MySQL on FreeBSD 4.5 Description: When trying to install MySQLi 3.23.47 and 3.23.48 on FreeBSD 4.5, We get the following errors during the mysql_install_db. /usr/local/bin/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread_create.c (errno = ?) Abort trap - core dumped Installation of grant tables failed! We've tried this on multiple hosts running 4.5, and received the same problem. On a machine running 4.4, installation works fine. How-To-Repeat: Get a machine with a new install (or cvsup'd install) of FreeBSD 4.5. Try installing from ports. Submitter-Id: submitter ID Originator: Darrin Walton MySQL support: [none] Synopsis: Problems installing MySQL on FreeBSD 4.5 Severity: Priority: Category: mysql Class: Release: mysql-3.23.47 (FreeBSD port: mysql-server-3.23.47) Environment: System: FreeBSD distrust.routing.org 4.5-RC FreeBSD 4.5-RC #3: Fri Jan 18 16:37:48 EST 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/DISTRUST i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] Compilation info: CC='cc' CFLAGS='-O2 -pipe -march=pentiumpro' CXX='cc' CXXFLAGS='-O2 -pipe -march=pentiumpro -felide-constructors -fno-rtti - fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1223438 Jan 16 02:12 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Jan 16 02:12 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 595712 Jan 16 02:12 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-de bug --without-readline --without-bench --with-mit-threads=no --with-li bwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.47' --enable-assembler --with-berkeley-db --with-inn odb --prefix=/usr/local i386--freebsd4.5 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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: Problems installing mysql-4.0-alpha on my Redhat
Nilesh Parmar writes: I get the following messages on the console. [1] 28102 $ starting mysql daemon with databases from /var/lib/mysql 011213 :16:56:43 mysqld ended I've not idea why do I get the message mysqld ended. Because it did. You'll have to look in the log file to find out why. Make sure you've taken all the steps necessary for installation, such as setting the right owner for the data directory and running mysql_install_db Error 2002: Can't connect to MySQL server through socket /var/lib/mysql/mysql.sock. Well, since the server fails to start that error is to be expected. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Problems installing mysql-4.0-alpha on my Redhat
Hi, It happens to me, just make sure you are not using any symbolic link, when I try to use symbolic link to mysql 4.0.0-aplha and it won't work. In my case, I just do mv mysql-4.0.0-alpha-pc-linux-gnu-i686 mysql and it works. Wai Lee Zeborg Inc. -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 6:59 AM To: [EMAIL PROTECTED] Subject: Re: Problems installing mysql-4.0-alpha on my Redhat Nilesh Parmar writes: I get the following messages on the console. [1] 28102 $ starting mysql daemon with databases from /var/lib/mysql 011213 :16:56:43 mysqld ended I've not idea why do I get the message mysqld ended. Because it did. You'll have to look in the log file to find out why. Make sure you've taken all the steps necessary for installation, such as setting the right owner for the data directory and running mysql_install_db Error 2002: Can't connect to MySQL server through socket /var/lib/mysql/mysql.sock. Well, since the server fails to start that error is to be expected. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Problems with MYSQL-D-MAx for win 98 DROP TABLE
Luciano Pulvirenti writes: If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not possible delete it after. The command DELETE TABLE TEST responds Table unknown. Thank You Luciano Your CREATE statement is a bit dubious, so check that there is such a table at all. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: Problems compiling mysql on linux 7.0
Which Linux 7.0 are you using? I'll assume you're talking about Redhat. So why don't you just download the mysql rpm and install it instead of doing it from source? Good luck, Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - 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: Problems compiling mysql on linux 7.0
Date |Tue, 14 Aug 2001 16:19:13 -0500 From |Vien Huynhle [EMAIL PROTECTED] Hello! VH BlankI am getting this error when trying to install mysql VH checking for tgetent in -lncurses... no VH checking for tgetent in -lcurses... no VH checking for tgetent in -ltermcap... no VH checking for termcap functions library... configure: error: No curses/termcap library found You need to install ncurses library. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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: problems untarring mysql under solaris
Hi, This is a known problem with solaris tar, I suggest you use gnu tar for solaris, This should solve your current problem. You can get a pre-build package of gnu tar at www.sunfreeware.com [EMAIL PROTECTED] wrote: Hi all: I am running solaris 2.5.1 and I am having difficulties untarring mysql. It decompresses a fair bit and then it shows a crc error. I tried 2 diff ver .38 and .39. In addition, I tried using gnu tar to decompress it however that binary just hangs. any help would be greatly appreciated. regards Imran. - 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: problems startting MySQL under R.H. 7.1
Hi Andy, Try to kill the process first, then restart mysql server. Hope that helps. Thanks, Xi Jiang ITSportsNet Technical Support - Original Message - From: Andy De Paoli [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 1:34 PM Subject: problems startting MySQL under R.H. 7.1 Help, I have a very urgent problem, I installed RedHat 7.1 for a company that wanted to migrate to it with their MySQL database. Unfortunately I encountered problems with MySQL 1. I ran mysql_install_db and got the messages about running mysqladmin to create a root password, OK so far 2. ran mysqladmin -u root password pswd and got an error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' 3. checked and the sock exists, so I figured that mysqld wasn't runnning. 4. tried /usr/bin/safe_mysqld but mysqld ended immediately after it started 5. tail /var/log/mysqld.log contains the message that /usr/libexec/mysqld can't find the file './mysql/host.frm' 6. when I try running /usr/libexec/mysqld as root I get the message regarding Security. Running it as a normal user I get the message: can't start server: Bind on Unix Socket : address already in use. 7. if I run /user/libexec/mysqld -h I get the list of variables, among which basedir:/usr/ datadir: /var/lib/mysql tmpdir: /tmp/ ... Unix socket: /var/lib/mysql/mysql.sock I have tried modifying /etc/my.cnf, /usr/share/mysql/mysql.server ... nothing. When I do a telnet 127.0.0.1 3306 I get unable to connect, connection refused so I assume that mysqld never started. I had previously installed MySQL with earlier verdsions of Red Hat (6.2, 7.0) and even compiled versions but I have never encountered such frustrating problems. Can someone point me in the right direction? (Yes, I have read the manual, the O'Reilly book and online FAQ.) I wold appreciate any pointers or even nidication of whom I could contact for help (and eventual costs), thanks. -- Andy De Paoli emails: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] (these are the ones I remember :-) - 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: problems startting MySQL under R.H. 7.1
Andy De Paoli [EMAIL PROTECTED] writes: Help, I have a very urgent problem, I installed RedHat 7.1 for a company that wanted to migrate to it with their MySQL database. Unfortunately I encountered problems with MySQL 1. I ran mysql_install_db Don't do that. service mysqld start will automatically populate the database if necesarry before starting the service. 4. tried /usr/bin/safe_mysqld but mysqld ended immediately after it started As above. -- 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: Problems Installing MySQL
Oh, and if you're going to use this system as a server for intranet/internet resources, why do you have a Win98 drive installed ?? You won't be able to use it if you're going to keep the system up, running Linux... - Original Message - From: Steve Brazill [EMAIL PROTECTED] To: Gavin Phillips-Page [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 11:06 AM Subject: Re: Problems Installing MySQL You shouldn't place the actual 'RPM's in /usr/local/mysql (/tmp would probably be a better place). I don't think that you have any control over the installation location when using the RPM technique... I am attaching my 'webdocs' on setting up a RedHat Linux system, including the installation and configuration of Apache/PHP/MySQL. Though the 'docs' refer to RedHat 6.2, the installation instructions are the same (I have just built 2 RedHat 7.1 systems without any problems...) If you're going to do any 'real' work with PHP and MySQL, you'll want to install and build the 'source' packages of each product (as apposed to the RPM technique that you have attempted to use). My 'docs' instruct you how to install the 'source' distributions of each package... Since you seletect the 'workstation' type of RedHat install, there might be some packages missing that you'll need to compile each product. Good Luck... - Original Message - From: Gavin Phillips-Page [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 3:51 AM Subject: Problems Installing MySQL We have installed the Red Hat Linux 7.1 Deluxe Edition on a Pentium III PC (450MHZ) with 128MB RAM. We installed the Workstation option. The OS is Windows 98 Millennium Edition. There are 2 Hard Drives. The 6GB Drive has Windows 98 Millennium Edition installed. The 4GB Drive has the Red Hat Linux 7.1 Deluxe Edition installed. We would like to create databases in MySQL and use PHP scripting to enable the apache web server to provide access to the database via an intranet or the internet. Initially we selected MySQL to be installed during the Red Hat Linux installation. When we ran the ³mysqladmin u root ping² command we received an error message stating that the MySQL Daemon did not start. We then ran ³./bin/safe_mysqld Daemon, but we still could not launch MySQL. We contacted Red Hat Support and they pointed us to your site where we printed out ³Installing MySQL². However we are still having problems with the installation. 1. We created a Directory /usr/local/mysql and copied the following files from the Red Hat Linux 7.1 CD to the /usr/local/mysql Directory: mysql-3.23.36.1.i386.rpm : mysql-devel-3.23.36.1.i386.rpm :mysql-3.23.36.1.i386.rpm : mysqlclient9-3.23.22.4.i386.rpm : mysqlserver-3.23.36.1.i386.rpm 2. We then ran the rpm i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm Command from the /usr/local/mysql Directory and received an error message that the file did not exist. 3. We then ran the rpm i mysql-3.23.36.1.i386.rpm mysqlclient9-3.23.22.4.i386.rpm Command from the /usr/local/mysql Directory. Something happened, but the var/lib/mysql Directory was not created. Could you please help with the installation. Can we make MySQL accessible via the KDE main menu if the installation is successful? Best regards Gavin Phillips-Page - 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: problems with MySQL GUI
Arnie Miles writes: Hi: Im using Windows 2000, and Im having problems with MySQL GUI. It works intermittently. Sometimes it just closes out for no apparent reason. Sometimes it will not let a known good user log in. Sometimes it will let a known good user log in, but then will not let that user create a database, and then the next time you try it will let the same user create with no problems. Arnie Hi! I have never heard of a problem as the one you describe. MySQLGUI uses normal C API functions for the functions you describe and does not have a will of it's own on that matter. Are there any error messages. Click on the button in the lower left corner of the main window and see if there are any error messages. Also, please do not, that Save' button saves user profile permanently, while Apply button saves settings only in memory, iso epse, only while mysqlgui is running. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: Problems with MySQL and Poweredge 6450..
Cody Swanson writes: Hey, We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention is to move the database off a smaller machine and load it into this one. We currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with kernel 2.4.4. This is on a dual PIII650 with 1 gig of ram and it runs fine. Here is a copy of a status readout in mysql: cut We have tried 2.2.x kernels and all kinds of memory configs but we are at a loss for what to do. It seems to be a machine problem because the same data on a different machine works fine. If anyone has any ideas I would love it! Thanks. Hi! Please first check a hardware, before we try to isolate a problem. This could be a bug in InnoDB handler, but if all is working well on other machines it could be machine specific. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problems with MySQL and Poweredge 6450..
Cody, did you copy the InnoDB data files, log files, and .frm files verbatim to the new computer? Have you tried wuith the same my.cnf parameters you had in the old computer? Does InnoDB crash always in the same function call? It looks like the internal data dictionary of InnoDB is corrupted. InnoDB tries to load the table definition and crashes while it is adding a column definition for the table. But if it works on another machine, that is strange. On one of our own machines where we have Red Hat 6.2 and software RAID, we have seen sporadic crashes, and sporadic failure of disk i/o. First, it would be useful to know what table it is. If you try simple queries (like fetching one row) from each of the tables in your database, for what table does it crash? What is the create table definition for that table? Have you dropped or altered the table? Regards, Heikki Tuuri Innobase Oy At 02:05 PM 5/22/01 +0300, you wrote: Content-Type: message/rfc822 Content-Description: forwarded message Content-Transfer-Encoding: 7bit Subject: Problems with MySQL and Poweredge 6450.. From: Cody Swanson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Mon, 21 May 2001 16:49:43 -0300 (ADT) Hey, We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention is to move the database off a smaller machine and load it into this one. We currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with kernel 2.4.4. This is on a dual PIII650 with 1 gig of ram and it runs fine. Here is a copy of a status readout in mysql: mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686) Connection id: 232107 Current database: Current user: root@localhost Current pager: stdout Using outfile: '' Server version:3.23.38 Protocol version: 10 Connection:Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime:1 day 19 hours 23 min 39 sec Threads: 55 Questions: 70609984 Slow queries: 15 Opens: 203 Flush tables: 1 Open tables: 155 Queries per second avg: 451.994 As you can see we have quite a load on this poor machine, this is why we wanted to move to a bigger badder machine so we could push more out of MySQL. Anyway, as mentioned before, our machine is a Poweredge 6450 with 4 Xeon 750mhz processors and 4gb of ram. We also have a dell 4 channel PercRaid card that does a raid 5 onto 4 36gb scsi disks. So we loaded Mysql 3.23.38 onto the machine with no extra tweeks, just with the raw install from dell, setup the Innobase driver and imported our data. Once we moved the site onto the new server everything worked great, we could do super heavy queries in no time, it was great! Then a day later I was looking at the .err log and noticed that MySQL had crashed several times! Each time it crashes it restarts itself and the innobase tables fix themselves. Innobase is verry cool! But this is a real problem! So I took the .err file and parsed the stack trace against the symbol file for mysql like the manual says. Here is a copy of the .err file with the stack dump from one crash. This one is from kernel 2.4.3: 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. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x81c508a 0x80f4ca5 0x80f44d4 0x80f823e 0x80f4021 0x80caee6 0x80c4a2d 0x809bdbf 0x8097de1 0x8097522 0x8098177 0x80abede 0x8084967 0x80877fd 0x8082ba9 0x80820d6 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0xb91044a8 is invalid pointer thd-thread_id = 6230 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 6230 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 010516 15:55:52 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 2512947858 InnoDB: Doing recovery: scanned up to log sequence number 0 2512963 Here is the results of running stackresolve: [root@cobalt /tmp]# /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n /tmp/mysql.stack 0x81c508a pthread_sighandler + 150 0x80f4ca5 dict_col_add_to_cache + 153 0x80f44d4 dict_table_add_to_cache + 1128 0x80f823e dict_load_table + 3326 0x80f4021 dict_table_get + 169 0x80caee6 open__11ha_innobasePCciUi + 310
Re: Problems with MySQL and Poweredge 6450..
On Monday 21 May 2001 13:50, Cody Swanson wrote: Hey, We just got a new Dell Poweredge 6450 preloaded with redhat 6.2. Our intention is to move the database off a smaller machine and load it into this one. We currently have MySQL 3.23.38 using the innobase driver on redhat 6.2 with kernel 2.4.4. This is on a dual PIII650 with 1 gig of ram and it runs fine. Here is a copy of a status readout in mysql: mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686) Connection id:232107 Current database: Current user: root@localhost Current pager:stdout Using outfile:'' Server version: 3.23.38 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 1 day 19 hours 23 min 39 sec Threads: 55 Questions: 70609984 Slow queries: 15 Opens: 203 Flush tables: 1 Open tables: 155 Queries per second avg: 451.994 As you can see we have quite a load on this poor machine, this is why we wanted to move to a bigger badder machine so we could push more out of MySQL. Anyway, as mentioned before, our machine is a Poweredge 6450 with 4 Xeon 750mhz processors and 4gb of ram. We also have a dell 4 channel PercRaid card that does a raid 5 onto 4 36gb scsi disks. So we loaded Mysql 3.23.38 onto the machine with no extra tweeks, just with the raw install from dell, setup the Innobase driver and imported our data. Once we moved the site onto the new server everything worked great, we could do super heavy queries in no time, it was great! Then a day later I was looking at the .err log and noticed that MySQL had crashed several times! Each time it crashes it restarts itself and the innobase tables fix themselves. Innobase is verry cool! But this is a real problem! So I took the .err file and parsed the stack trace against the symbol file for mysql like the manual says. Here is a copy of the .err file with the stack dump from one crash. This one is from kernel 2.4.3: 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. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x81c508a 0x80f4ca5 0x80f44d4 0x80f823e 0x80f4021 0x80caee6 0x80c4a2d 0x809bdbf 0x8097de1 0x8097522 0x8098177 0x80abede 0x8084967 0x80877fd 0x8082ba9 0x80820d6 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0xb91044a8 is invalid pointer thd-thread_id = 6230 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 6230 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 010516 15:55:52 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 2512947858 InnoDB: Doing recovery: scanned up to log sequence number 0 2512963 Here is the results of running stackresolve: [root@cobalt /tmp]# /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n /tmp/mysql.stack 0x81c508a pthread_sighandler + 150 0x80f4ca5 dict_col_add_to_cache + 153 0x80f44d4 dict_table_add_to_cache + 1128 0x80f823e dict_load_table + 3326 0x80f4021 dict_table_get + 169 0x80caee6 open__11ha_innobasePCciUi + 310 0x80c4a2d ha_open__7handlerPCcii + 33 0x809bdbf openfrm__FPCcT0UiUiUiP8st_table + 4959 0x8097de1 open_unireg_entry__FP3THDP8st_tablePCcN22b + 69 0x8097522 open_table__FP3THDPCcN21Pb + 950 0x8098177 open_ltable__FP3THDP13st_table_list13thr_lock_type + 71 0x80abede mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15enum_duplicates13thr_lock_type + 302 0x8084967 mysql_execute_command__Fv + 5339 0x80877fd mysql_parse__FP3THDPcUi + 209 0x8082ba9 do_command__FP3THD + 1305 0x80820d6 handle_one_connection__FPv + 578 We have tried 2.2.x kernels and all kinds of memory configs but we are at a loss for what to do. It seems to be a machine problem because the same data on a different machine works fine. If anyone has any ideas I would love it! Thanks. Thanks for a good bug report. Looks like you are using InnoDB tables. Please be aware that although we have tested them, they are not quite 100% production ready, although they are getting better and better. Let's hope
RE: Problems with MySQL++
Sander Pilon writes: Howdy, ./ChangeLog Indeed, those don't appear to be in the tar archive. Any ideas? Do you need them? tar xfz mysql++.tar.gz cd mysql++- ./configure; make; make install Voila. And yes, the mysql online manual has been broken for over 6 months now :) According to mysql people, it will be fixed soon. (Which was something they said.. em.. 5 months ago.) Hi! Actually, those above are only warnings and should be disregarded. Regarding a manual, it has been fixed and put on MySQL++ for download, few months ago ! So, just go and get it from there !! It is fine and complete will all chapters and in all formats. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problems with MySQL++
The 5_Class.html file online is only a few lines and only describes the manipulators, as opposed to the old 5_Class.html file distributed with 1.7.5 and the downloadable one, which is 300Kb and contains descriptions of much, much more. Manipulators is (the only) section 5.1 in the on-line version, whereas it is section 5.66 (!) in the downloadable manual. As far as I can see the downloadable manual is fine, but the on-line version is - unless my proxy hasn't updated in 6 months - not. -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: 29 April 2001 14:32 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Problems with MySQL++ Sander Pilon writes: It is fine and complete will all chapters and in all formats. This page used to have lots of cool documentation... http://www.mysql.com/documentation/mysql++/5_Class.html Yes, and there two versions of manual. One for on-line browsing and the one for download. Both are fine and complete. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problems with MySQL++
On Sun, Apr 29, 2001 at 02:45:06PM +0200, Sander Pilon wrote: The 5_Class.html file online is only a few lines and only describes the manipulators, as opposed to the old 5_Class.html file distributed with 1.7.5 and the downloadable one, which is 300Kb and contains descriptions of much, much more. Manipulators is (the only) section 5.1 in the on-line version, whereas it is section 5.66 (!) in the downloadable manual. As far as I can see the downloadable manual is fine, but the on-line version is - unless my proxy hasn't updated in 6 months - not. It's not just you. I see it just as you described. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 116 days, processed 718,812,371 queries (71/sec. avg) - 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: Problems with MySQL++
Sander Pilon writes: The 5_Class.html file online is only a few lines and only describes the manipulators, as opposed to the old 5_Class.html file distributed with 1.7.5 and the downloadable one, which is 300Kb and contains descriptions of much, much more. Manipulators is (the only) section 5.1 in the on-line version, whereas it is section 5.66 (!) in the downloadable manual. As far as I can see the downloadable manual is fine, but the on-line version is - unless my proxy hasn't updated in 6 months - not. Our WWW people will fix it ASAP. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problems with MySQL++
Howdy, I posted this question over on the plusplus list, but so far I've not received a response. This list seems more active, so perhaps someone here can offer me a hand. I'm trying to get the 1.7.8 distribution of MySQL++ to build as directed in the README -- using automake. When I run automake, I get a message saying that Makefile.am is missing some required files: ./INSTALL ./NEWS ./COPYING ./AUTHORS ./ChangeLog Indeed, those don't appear to be in the tar archive. Any ideas? Do you need them? tar xfz mysql++.tar.gz cd mysql++- ./configure; make; make install Voila. And yes, the mysql online manual has been broken for over 6 months now :) According to mysql people, it will be fixed soon. (Which was something they said.. em.. 5 months ago.) - 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: Problems with MySQL++
Well, cool. If that works I'm happy. I was trying to go by the README and use automake. Thanks! It'd sure be nice if somebody fixed the docs, or at least put a note on the web site that said they're broken. That probably cost me at least a day of confusion. :-( Howdy, I posted this question over on the plusplus list, but so far I've not received a response. This list seems more active, so perhaps someone here can offer me a hand. I'm trying to get the 1.7.8 distribution of MySQL++ to build as directed in the README -- using automake. When I run automake, I get a message saying that Makefile.am is missing some required files: ./INSTALL ./NEWS ./COPYING ./AUTHORS ./ChangeLog Indeed, those don't appear to be in the tar archive. Any ideas? Do you need them? tar xfz mysql++.tar.gz cd mysql++- ./configure; make; make install Voila. And yes, the mysql online manual has been broken for over 6 months now :) According to mysql people, it will be fixed soon. (Which was something they said.. em.. 5 months ago.) - 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: Problems with MySQL fulltext searching.
Hi! mysql SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t; +--++--+ | a| b | x| +--++--+ | MySQL has now support| for full-text search |0 | | Full-text indexes| are called collections | 0.38341854994499 | | Function MATCH ... AGAINST() | is used to do a search |0 | | mysql has now support| for full-text search |0 | | collections support | foo| 0.39634908797834 | +--++--+ 5 rows in set (0.00 sec) mysql INSERT INTO t VALUES ('collections',' support'); Query OK, 1 row affected (0.00 sec) mysql SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t; +--++--+ | a| b | x| +--++--+ | MySQL has now support| for full-text search |0 | | Full-text indexes| are called collections |0 | | Function MATCH ... AGAINST() | is used to do a search |0 | | mysql has now support| for full-text search |0 | | collections support | foo|0 | | collections | support |0 | +--++--+ 6 rows in set (0.00 sec) Briefly, it seems to us that the x column values should have remained the same, or atleast 0 after our addition of the last entry to the table. It seems MySQL detected matches beforehand, but not after. No, you're wrong. The relevance in computed from the semantical values of individual words, and semantical value of the word depends on word frequency in the dataset. Too frequent words receive semantic value 0 and are effectively ignored. See manual. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Problems with Mysql on Sol7 i386
Hi Matt, Probably worth checking the archives for 'restartable' - there are a few messages there. Quentin -Original Message- From: Matt Mueller [mailto:[EMAIL PROTECTED]] Sent: Thursday, 5 April 2001 9:53 a.m. To: [EMAIL PROTECTED] Subject: Problems with Mysql on Sol7 i386 Hello, I am trying to install mysql version 3.23.26 on my sun machine running solaris 7. I have installed gnu make, tar, and gcc-version 2.95.2. I have also tried doing everything that is reccomended for my error such as editing config.cache and even using the reccomended configure line. The error I am getting is: checking for restartable system calls... configure: error can not run test programs while cross compiling Has anyone run into this problem even after updating thier systems? Thanks for the help, Matthew Mueller Matthew Mueller Space Science and Engineering Center University of Wisconsin-Madison Phone: 608.263.8185 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: problems with mysql table
Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- Nuno Ferreira AKA |rider http://rider.lusoweb.pt mailto:[EMAIL PROTECTED] http://www.lusoweb.pt mailto:[EMAIL PROTECTED] - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: problems with mysql table
# isamchk -a -d -e -f -i -l -o imp_addr.ISM ISAM file: imp_addr.ISM Data records: 1223 Deleted blocks: 0 Recordlength:25 Record format: Packed table description: Key Start Len Index Type User time 0.00, System time 0.00 Maximum resident set size 0, Integral resident set size 0 Non physical pagefaults 16, Physical pagefaults 51, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Vouluntary context switches 0, Invouluntary context switches 0 - Anymore available STRONG options i can use ??? cause i think that ones are about all ... and still no good luck :( regards On Fri, 16 Mar 2001, Quentin Bennett wrote: Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- --- Nuno Ferreira mailto:[EMAIL PROTECTED] http://www.lusoweb.pt --- - 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: Problems building mysql++
Hi! As we have underlined so many times on all our mailing lists, 2.96 can not be used for the building of MySQL++. It is a very buggy compiler. Use 2.95.2. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problems building mysql++
- Original Message - From: "Sinisa Milivojevic" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, March 04, 2001 7:32 AM Subject: Re: Problems building mysql++ Quinn Wilson writes: I am trying to build mysql++, I am doing something wrong but I don't know what. I have downloaded and untar'd ungzipped mysql++-1.7.8.tar.gz into mysql++-1.7.8, run configure and then make, make install. I set my LD_LIBRARY_PATH to include the new library and then I try to run the resetdb program in the examples directory and it dies w/ Segmentation fault (core dumped). It seemed to "make" correctly. The version of mysql I am running is 3.23.33, freshly built and installed. This is a Redhat 7.0 i386, I have not had any problems building other applications so I don't think my compiler installation is to blame. Here's what I tried. I found the lt-resetdb program and ran gdb lt-resetdb core and got: GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-redhat-linux"... Core was generated by `./lt-resetdb'. Program terminated with signal 11, Segmentation fault. Reading symbols from /home/quinn/decomp/mysql++-1.7.8/sqlplusint/.libs/libsqlplus.so.1...done. Loaded symbols for /home/quinn/decomp/mysql++-1.7.8/sqlplusint/.libs/libsqlplus.so.1 Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /usr/local/mysql/lib/mysql/libmysqlclient.so.10...done. Loaded symbols for /usr/local/mysql/lib/mysql/libmysqlclient.so.10 Reading symbols from /usr/lib/libstdc++-libc6.2-2.so.3...done. Loaded symbols for /usr/lib/libstdc++-libc6.2-2.so.3 Reading symbols from /lib/libm.so.6...done. Loaded symbols for /lib/libm.so.6 Reading symbols from /lib/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/ld-linux.so.2...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /lib/libnss_files.so.2...done. Loaded symbols for /lib/libnss_files.so.2 #0 chunk_free (ar_ptr=0x464c457f, p=0x40057198) at malloc.c:3071 3071malloc.c: No such file or directory. I stepped through untill I got a SIGSEGV : 90 if (mysql_real_connect(mysql,host,user,passwd,db, 3306,NULL,0)) { (gdb) Program received signal SIGSEGV, Segmentation fault. chunk_free (ar_ptr=0x464c457f, p=0x40057198) at malloc.c:3071 3071malloc.c: No such file or directory. Current language: auto; currently c I don't know what to make of this output, does anyone on this list recognize what's going on? I don't know what to make of this output. Quinn Wilson - [EMAIL PROTECTED] - Lunkee cc Lunky do{;} - "For a list of the ways which technology has failed to improve our quality of life, press 3." Hi! I need more info in order to be able to help you : - What OS it is and which version it is Linux - Redhat - 7.0 - 2.2.16-22 kernel - What is a version of C Library libc6.2-2 - What compiler it is and what version of compiler gcc - 2.96 - What version of STL libraries and MySQL client libraries did you use libstdc++-libc6.2-2 mysql version = 3.23.33, mysql++ version = 1.7.8 Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problems with mysql++ compilation
Christopher McClan writes: Hello, I've followed the instructions from the MySQL web site entitled "Instructions for building MySQLGui with the FL_Editor, and am currently trying to install mysql++1.78. I've made the modifications to sqlinst/connection1.hh sqlinst/result1.hh however when I make I get the following output : [root@cimserv mysql++-1.7.8]# make make all-recursive make[1]: Entering directory `/export/mysql-temp/mysql++-1.7.8' Making all in sqlplusint make[2]: Entering directory `/export/mysql-temp/mysql++-1.7.8/sqlplusint' /bin/sh ../libtool --mode=compile c++ -DHAVE_CONFIG_H -I. -I. -I.. -I. -I../sqlplusint -I/usr/local/mysql//include/mysql -g -O2 -c coldata.cc rm -f .libs/coldata.lo c++ -DHAVE_CONFIG_H -I. -I. -I.. -I. -I../sqlplusint -I/usr/local/mysql//include/mysql -g -O2 -Wp,-MD,.deps/coldata.pp -c -fPIC -DPIC coldata.cc -o .libs/coldata.lo coldata.cc:1: string: No such file or directory In file included from const_string2.hh:2, from const_string3.hh:2, from coldata.cc:2: const_string1.hh:4: stdexcept: No such file or directory const_string1.hh:5: string: No such file or directory const_string1.hh:6: iostream: No such file or directory In file included from coldata4.hh:6, from coldata.cc:3: coldata3.hh:11: string: No such file or directory In file included from coldata2.hh:5, from coldata3.hh:12, from coldata4.hh:6, from coldata.cc:3: coldata1.hh:5: string: No such file or directory In file included from coldata1.hh:7, from coldata2.hh:5, from coldata3.hh:12, from coldata4.hh:6, from coldata.cc:3: exceptions.hh:4: string: No such file or directory In file included from coldata1.hh:8, from coldata2.hh:5, from coldata3.hh:12, from coldata4.hh:6, from coldata.cc:3: type_info1.hh:12: map: No such file or directory In file included from coldata1.hh:10, from coldata2.hh:5, from coldata3.hh:12, from coldata4.hh:6, from coldata.cc:3: null1.hh:4: ostream.h: No such file or directory In file included from coldata4.hh:8, from coldata.cc:3: string_util.hh:4: string: No such file or directory make[2]: *** [coldata.lo] Error 1 make[2]: Leaving directory `/export/mysql-temp/mysql++-1.7.8/sqlplusint' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/mysql-temp/mysql++-1.7.8' make: *** [all-recursive-am] Error 2 [root@cimserv mysql++-1.7.8]# Any ideas? - I've noticed that I don't actually have "ostream.h" on my system at all (obviously thats just the last error though...) Cheers, Christopher. Hi! You do not have STL library included on your system. In order to build MySQL++ you must have a full installation of gcc 2.95.2 But if you are on i386 Linux, why don't you just use our mysqlgui-1.7.4 static binary for Linux ?? You do not have to build it yourself. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problems with mySQL and DBTools
On Thu, 8 Feb 2001, Curtis, Lorenzo wrote: 2. Is there a detailed outline to use to compile Apache with PHP and mySQL effectively? www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: Problems with mySQL and DBTools
do any one knows about a mailling list of oracle? wich is the eamil address for subscribing to it? please mail me back ASAP, cheers On Thu, 8 Feb 2001, clay bond wrote: Date: Thu, 8 Feb 2001 13:23:08 -0500 (EST) From: clay bond [EMAIL PROTECTED] To: unlisted-recipients: ; Cc: [EMAIL PROTECTED] Subject: Re: Problems with mySQL and DBTools On Thu, 8 Feb 2001, Curtis, Lorenzo wrote: 2. Is there a detailed outline to use to compile Apache with PHP and mySQL effectively? www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html -- /"\ \ / ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \ AND POSTINGS - 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: problems running mySQL via Telnet
I suppose you mean that you've been using telnet to access the server and mysql to access the mysql server. From a security standpoint, you should probably install sshd, deinstall telnet, rsh, rexec, etc. and use ssh exclusively to login to your server. Of course, this is only a tiny piece of an overall security strategy, and you should invest some time in developing a complete security solution, if you haven't already. However, this is now almost completely off-topic. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: John Jensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 18:10 Alright, you've got me worried. I have been using telnet to access mysql. Could that have something to do with the problems I have been having with the server? (The root password was erased, but there was no other evidence of a breakin.) On 8 Feb 2001, at 7:56, Quentin Bennett wrote: You don't connect to mysql server using telnet, you use the mysql command line client 'mysql'. -Original Message- From: @ndYD [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 February 2001 07:13 server version: 3.22.34-shareware-debug OS: Windows 98 I tried to access the mySQL- server via the Win-Telnet Client. If the connection is established, the following mysterious string appears: ( 3.22.34-shareware-debugk7qS,~Z), After that, I entered some characters. Then the connection will be closed by the server and the error string "Bad Handshake" appears. Question: Is this feature (Telnet) not available in the shareware-version. Or is this a basically problem? - 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: problems running mySQL via Telnet
Hi, You don't connect to mysql server using telnet, you use the mysql command line client 'mysql'. Regards Quentin -Original Message- From: @ndYD [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 February 2001 07:13 To: [EMAIL PROTECTED] Subject: problems running mySQL via Telnet Hello, server version: 3.22.34-shareware-debug OS: Windows 98 I tried to access the mySQL- server via the Win-Telnet Client. If the connection is established, the following mysterious string appears: ( 3.22.34-shareware-debugk7qS,~Z), After that, I entered some characters. Then the connection will be closed by the server and the error string "Bad Handshake" appears. Question: Is this feature (Telnet) not available in the shareware-version. Or is this a basically problem? Thanks in advance for all tips. Regards Andy - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: problems running mySQL via Telnet
You're trying to use a Telnet client with a MySQL server. Instead, use a MySQL client with a MySQL server and a Telnet client with a Telnet server. Mixing protocols doesn't really work for anybody. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: @ndYD [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12:13 To: [EMAIL PROTECTED] Subject: problems running mySQL via Telnet Hello, server version: 3.22.34-shareware-debug OS: Windows 98 I tried to access the mySQL- server via the Win-Telnet Client. If the connection is established, the following mysterious string appears: ( 3.22.34-shareware-debugk7qS,~Z), After that, I entered some characters. Then the connection will be closed by the server and the error string "Bad Handshake" appears. Question: Is this feature (Telnet) not available in the shareware-version. Or is this a basically problem? Thanks in advance for all tips. Regards Andy - 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: problems running mySQL via Telnet
i agree .. the mysql server _should_ accept telnet sessions. Maybe in a future release ? it'd really be very handy - Original Message - From: "Quentin Bennett" [EMAIL PROTECTED] To: "'@ndYD'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 7:56 PM Subject: RE: problems running mySQL via Telnet Hi, You don't connect to mysql server using telnet, you use the mysql command line client 'mysql'. Regards Quentin -Original Message- From: @ndYD [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 February 2001 07:13 To: [EMAIL PROTECTED] Subject: problems running mySQL via Telnet Hello, server version: 3.22.34-shareware-debug OS: Windows 98 I tried to access the mySQL- server via the Win-Telnet Client. If the connection is established, the following mysterious string appears: ( 3.22.34-shareware-debugk7qS,~Z), After that, I entered some characters. Then the connection will be closed by the server and the error string "Bad Handshake" appears. Question: Is this feature (Telnet) not available in the shareware-version. Or is this a basically problem? Thanks in advance for all tips. Regards Andy - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: problems running mySQL via Telnet
"TT" == The Tilghman [EMAIL PROTECTED] writes: TT You're trying to use a Telnet client with a MySQL server. Instead, TT use a MySQL client with a MySQL server and a Telnet client with a TT Telnet server. Mixing protocols doesn't really work for anybody. well, you can use the telnet client to speak to any service, as long as you are capable of typing the poper protocol characters. Telnet clients are handy for debugging SMTP servers, for example. But in general, you want to use the mysql command line client to speak to mysql. That is, unless you're debugging the mysql protocol ;-) - 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