RE: installation problem of MySQL on OS Lion
Share error log file -Original Message- From: Martin Mueller martinmuel...@northwestern.edu Sent: 29-07-2015 21:05 To: mysql@lists.mysql.com mysql@lists.mysql.com Subject: installation problem of MySQL on OS Lion I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit without updating file. I'll be grateful for any help Martin Mueller Professor emeritus of English and Classics Northwestern University
installation problem of MySQL on OS Lion
I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit without updating file. I'll be grateful for any help Martin Mueller Professor emeritus of English and Classics Northwestern University
Install problem on MySQL Enterprise Monitor on linux
I tried to install the mysql monitor, but stumbled on some problems. Here is what I did. 1. Installed a second instance of mysql server on one of our servers into a different folder rather than into the regular folder because there is already another instance of mysql server running on the same server. 2. created the user service_manager user with a password. 3. The new instance runs on different socket, different port, different pid file and different binaries. 4. Now I switched to the regular env. and installed myql monitor. 5. Install had one error which is below. Setup has completed installing the MySQL Enterprise Monitor files on your computer (errors were found during the installation process). No other error and no log files are created. 6. Started the mysql monitor. Here is what I found. $ ./mysqlmonitorctl.sh status MySQL Enterprise MySQL is not running MySQL Enterprise Tomcat is not running $ ./mysqlmonitorctl.sh start Using CATALINA_BASE: /opt/app/mysql_mon/ent_mon/apache-tomcat Using CATALINA_HOME: /opt/app/mysql_mon/ent_mon/apache-tomcat Using CATALINA_TMPDIR: /opt/app/mysql_mon/ent_mon/apache-tomcat/temp Using JRE_HOME:/opt/app/mysql_mon/ent_mon/java $ ./mysqlmonitorctl.sh status MySQL Enterprise MySQL is not running MySQL Enterprise Tomcat is running $ I believe mysql monitor is conflicting with the old instance of mysql server. Did anyone come across this problem? I can't use the existing mysql server as the version is not compatible with mysql monitor requirements. Any help is appreciated. Thanks BA
facing problem in MYSQL
Dear Sir/Mam, we are facing the problem in our server, kindly help us to solve our problem. mysqlbug script is attached with this mail. hope for your positive response ASAP. -- Regards Er. Ajay Bansal System Officer District Sessions Court, Amritsar +919988460582 | so...@indianjudiciary.gov.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: facing problem in MYSQL
Hi Ajay, there is no attachment.. On Sat, Jul 28, 2012 at 1:17 PM, Ajay Bansal, System Officer so...@indianjudiciary.gov.in wrote: Dear Sir/Mam, we are facing the problem in our server, kindly help us to solve our problem. mysqlbug script is attached with this mail. hope for your positive response ASAP. -- Regards* *Er. Ajay Bansal System Officer District Sessions Court, Amritsar +919988460582 | so...@indianjudiciary.gov.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
Re: Problem with mysql
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote: Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
use mysql; select * from user; see if you able to see 'r2-d2' entry in this table. also you can try this grant all on . to 'root'@'%' idenfified by 'secret-password'; regards anandkl On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes sq...@dahl-stamnes.netwrote: On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote: Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=anan...@gmail.com
Re: Problem with mysql
On Monday 11 January 2010 09:55, Ananda Kumar wrote: use mysql; select * from user; see if you able to see 'r2-d2' entry in this table. also you can try this grant all on . to 'root'@'%' idenfified by 'secret-password'; I just found the cause of the problem... /etc/nsswitch.conf. It said that files should be used before dns. After I changed the order, it worked (so did the strange sendmail problem I had). But still I wonder why it worked on the other host, since it also had the order files dns in it's nsswitch.conf file... Thanks for your support. -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I read you solved your problem, but by reverse I meant what r2-d2.dahl-stamnes.net resolves to. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
(Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I read you solved your problem, but by reverse I meant what r2-d2.dahl-stamnes.net resolves to. Sorry (...) what 192.18.2.22 resolves to. -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote: (Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I read you solved your problem, but by reverse I meant what r2-d2.dahl-stamnes.net resolves to. Sorry (...) what 192.18.2.22 resolves to. it resolv to r2-d2.dahl-stamnes.net -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Problem with mysql
Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some unknown reason I cannot connect to the local host using a full hostname. This is what I have done: r2-d2# mysql -u root -p grant all on . to 'root'@'r2-d2' idenfified by 'secret-password'; grant all on . to 'root'@'r2-d2.dahl-stamnes.net' idenfified by 'secret-password'; flush privileges; quit r2-d2# mysql -h r2-d2 -u root -p (works) r2-d2# mysql -h r2-d2.dahl-stamnes.net -u root -p ERROR 1130 (HY000): Host 'r2-d2.dahl-stamnes.net.' is not allowed to connect to this MySQL server Then I did: r2-d2# mysql -u root -p grant all on . to 'root'@'jedi.dahl-stamnes.net' idenfified by 'secret-password'; jedi# mysql -h r2-d2.dahl-stamnes.net -u root -p (works) I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
Hi, The grant stmt has to be as below. Grant all on databasename.tablename to usern...@iporhostname identified by 'password'; Use as above Grant stmt doesn't require a flush stmt. Suresh Kuna MySQL DBA --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo: sq...@dahl-stamnes.net Subject: Problem with mysql Sent: Jan 10, 2010 3:20 PM Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some unknown reason I cannot connect to the local host using a full hostname. This is what I have done: r2-d2# mysql -u root -p grant all on . to 'root'@'r2-d2' idenfified by 'secret-password'; grant all on . to 'root'@'r2-d2.dahl-stamnes.net' idenfified by 'secret-password'; flush privileges; quit r2-d2# mysql -h r2-d2 -u root -p (works) r2-d2# mysql -h r2-d2.dahl-stamnes.net -u root -p ERROR 1130 (HY000): Host 'r2-d2.dahl-stamnes.net.' is not allowed to connect to this MySQL server Then I did: r2-d2# mysql -u root -p grant all on . to 'root'@'jedi.dahl-stamnes.net' idenfified by 'secret-password'; jedi# mysql -h r2-d2.dahl-stamnes.net -u root -p (works) I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com Sent from BlackBerry® on Airtel
Re: Problem with mysql
On Sunday 10 January 2010 12:34, sureshkumar...@gmail.com wrote: Hi, The grant stmt has to be as below. Grant all on databasename.tablename to usern...@iporhostname identified by 'password'; Use as above Grant stmt doesn't require a flush stmt. Woops... Seems like the * in my first mail has dissapeared. The correct grant statment I used was: r2-d2# mysql -u root -p grant all on *.* to 'root'@'r2-d2' idenfified by 'secret-password'; grant all on *.* to 'root'@'r2-d2.dahl-stamnes.net' idenfified by 'secret-password'; grant all on *.* to 'root'@'jedi.dahl-stamnes.net' idenfified by 'secret-password'; --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo: sq...@dahl-stamnes.net Subject: Problem with mysql Sent: Jan 10, 2010 3:20 PM Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some unknown reason I cannot connect to the local host using a full hostname. This is what I have done: r2-d2# mysql -u root -p grant all on . to 'root'@'r2-d2' idenfified by 'secret-password'; grant all on . to 'root'@'r2-d2.dahl-stamnes.net' idenfified by 'secret-password'; flush privileges; quit r2-d2# mysql -h r2-d2 -u root -p (works) r2-d2# mysql -h r2-d2.dahl-stamnes.net -u root -p ERROR 1130 (HY000): Host 'r2-d2.dahl-stamnes.net.' is not allowed to connect to this MySQL server Then I did: r2-d2# mysql -u root -p grant all on . to 'root'@'jedi.dahl-stamnes.net' idenfified by 'secret-password'; jedi# mysql -h r2-d2.dahl-stamnes.net -u root -p (works) I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with mysql
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement +261 34 29 155 34 / +261 33 11 207 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Problem with MySQL user
I'm working with two VMs, one a web server, one a MySQL database server. In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for the web site, and that works. The VMs got shipped off to a hosting facility. They got the 172.16.1.X network between the two VMs up, but when they try to mysql -h 172.16.1.1 -uuser -p and enter the password, they get an error denying 'user'@'hostname' Why is MySQL resolving the IPs? I figured it would be quicker to fix that than it would be to look up the specific privileges for that user, add 'user'@'hostname', and then go in and start modifying the config (it's set in settings.php as well as several places in the httpd.conf) I do have /etc/hosts entries on both VMs resolving both 172.16.1.1 / 2 to known hostnames. -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Problem with MySQL user
Hi John, You can turn of name resolution by adding skip-name-resolve to the [mysqld] section of your my.cnf file. Regards, Gavin Towey -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Wednesday, September 16, 2009 4:24 PM To: mysql@lists.mysql.com Subject: Problem with MySQL user I'm working with two VMs, one a web server, one a MySQL database server. In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for the web site, and that works. The VMs got shipped off to a hosting facility. They got the 172.16.1.X network between the two VMs up, but when they try to mysql -h 172.16.1.1 -uuser -p and enter the password, they get an error denying 'user'@'hostname' Why is MySQL resolving the IPs? I figured it would be quicker to fix that than it would be to look up the specific privileges for that user, add 'user'@'hostname', and then go in and start modifying the config (it's set in settings.php as well as several places in the httpd.conf) I do have /etc/hosts entries on both VMs resolving both 172.16.1.1 / 2 to known hostnames. -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Compile problem (was: MySQL Community Server 5.1.35 has been released)
Dave, do you really consider it helpful to do reply all to a release announcement, trying to send it to the announce and packagers list, including a full quote of the announcement text, and using the original subject line, when you are asking for help about a compile problem? Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: [[...]] Error in compiling: mv -f .deps/liboptions_la-priv.Tpo .deps/liboptions_la-priv.Plo /bin/sh ../../libtool --preserve-dup-deps --tag=CXX --mode=link g++ -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -DDEFAULT_PID_FILE_NAME=/usr/contrib/mysqld/mysqlmanager.pid -DDEFAULT_LOG_FILE_NAME=/usr/contrib/mysqld/mysqlmanager.log -DDEFAULT_SOCKET_FILE_NAME=/tmp/mysqlmanager.sock -DDEFAULT_PASSWORD_FILE_NAME=/etc/mysqlmanager.passwd -DDEFAULT_MYSQLD_PATH=/usr/contrib/libexec/mysqld -DDEFAULT_CONFIG_FILE=my.cnf -DPROTOCOL_VERSION=10 -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -o liboptions.la liboptions_la-options.lo liboptions_la-priv.lo ../../libmysql/get_password.lo -lm test: unrecognized integer ` ar cru .libs/liboptions.a .libs/liboptions_la-options.o .libs/liboptions_la-priv.o ../../libmysql/.libs/get_password.o ~ranlib .libs/liboptions.a/liboption' ../../libtool: arith: syntax error: 47 + .libs/liboptions_la-options.o~RANLI gmake[2]: *** [liboptions.la] Error 2 gmake[2]: Leaving directory `/usr/src/contrib/mysql/mysql-5.1.35/server-tools/instance-manager' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/src/contrib/mysql/mysql-5.1.35/server-tools' gmake: *** [all-recursive] Error 1 *** Error code 2 Stop. Help!! I can't. I cannot even try to help you, if you do not provide the necessary information. All I can do is give you the corresponding line from my log, split into several lines for better readability: /bin/sh ../../libtool --preserve-dup-deps --tag=CXX --mode=link gcc -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused-function -Wunused-label -Wunused-value -Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mtune=native -O3 -fno-omit-frame-pointer -g -fno-implicit-templates -fno-exceptions -fno-rtti -DDEFAULT_PID_FILE_NAME=/usr/local/mysql/var/mysqlmanager.pid -DDEFAULT_LOG_FILE_NAME=/usr/local/mysql/var/mysqlmanager.log -DDEFAULT_SOCKET_FILE_NAME=/tmp/mysqlmanager.sock -DDEFAULT_PASSWORD_FILE_NAME=/etc/mysqlmanager.passwd -DDEFAULT_MYSQLD_PATH=/usr/local/mysql/libexec/mysqld -DDEFAULT_CONFIG_FILE=my.cnf -DPROTOCOL_VERSION=10 -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused-function -Wunused-label -Wunused-value -Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mtune=native -O3 -fno-omit-frame-pointer -g -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o liboptions.la liboptions_la-options.lo liboptions_la-priv.lo ../../libmysql/get_password.lo -lpthread -lcrypt -lnsl -lm -lpthread This was running on Linux (SuSE 10.3) running on an Athlon, using libtool 1.5.24 and gcc 4.2.1. Looking at the text you quote, it seems the commands executed by libtool got garbled: A command starting with ar cru suddenly continues with ~ranlib which doesn't make any sense to me. I suspect some problem around your libtool installation, or with your file system (affecting some generated files). Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com (+49 30) 417 01 487 Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer 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: Problem compiling mysql-5.1.33
most likely a missing include it should have at least: #include sys/time.h #include sys/resource.h Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem schrieb: make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP -MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc In file included from safe_process.cc:48: /usr/include/sys/resource.h:63: field `ru_utime' has incomplete type /usr/include/sys/resource.h:64: field `ru_stime' has incomplete type why is this taking place? Compile options ./configure --prefix=/usr/contrib --localstatedir=/usr/contrib/mysqld --without-innodb --disable-debug --with-ssl=/usr/contrib --enable-thread-safe-client -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Problem compiling mysql-5.1.33
make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP -MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc In file included from safe_process.cc:48: /usr/include/sys/resource.h:63: field `ru_utime' has incomplete type /usr/include/sys/resource.h:64: field `ru_stime' has incomplete type why is this taking place? Compile options ./configure --prefix=/usr/contrib --localstatedir=/usr/contrib/mysqld --without-innodb --disable-debug --with-ssl=/usr/contrib --enable-thread-safe-client -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with MySQL prompt
Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log ## ISTANZE DELLA PARTE PRODUZIONE ##--- ## ISTANZA SIA DI PRODUZIONE ##-- [mysqld01] defaults-file = /etc/mysql.config/my50_SIA.cnf socket = /tmp/mysql50_SIA.sock port = 3307 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA ## ISTANZA IPPOFONO DI PRODUZIONE ##--- [mysqld02] defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf socket = /tmp/mysql50_IPPOFONO.sock port = 3306 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/mysql50_IPPOFONO.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO ### ## ISTANZE DELLA PARTE SVILUPPO ##- ## ISTANZA SIA DI SVILUPPO ## [mysqld11] defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf socket = /tmp/mysql50_SIA_SVILUPPO.sock port = 3317 pid-file = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ mysql50_SIA_SVILUPPO.pid datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO but if I put the variable prompt in the specific my.cnf (for example / etc/mysql.config/my50_SIA_SVILUPPO.cnf), the prompt doesn't change By Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha scritto: Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati Mob: 9912924044 Email-id: prajapat...@gmail.com Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it
Re: Problem with MySQL prompt
Hi Stefano, I have tested. It's working fine without any issue. Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add the below entires and restart the mysql server. [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates prompt = 'mysql5.1.30 ' [r...@linux18 ~]# mysql --defaults-file=/etc/my1.cnf Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.30 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql5.1.30 Thanks, -Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi stefano.elm...@sociale.itwrote: Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log ## ISTANZE DELLA PARTE PRODUZIONE ##--- ## ISTANZA SIA DI PRODUZIONE ##-- [mysqld01] defaults-file = /etc/mysql.config/my50_SIA.cnf socket = /tmp/mysql50_SIA.sock port = 3307 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA ## ISTANZA IPPOFONO DI PRODUZIONE ##--- [mysqld02] defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf socket = /tmp/mysql50_IPPOFONO.sock port = 3306 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/mysql50_IPPOFONO.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO ### ## ISTANZE DELLA PARTE SVILUPPO ##- ## ISTANZA SIA DI SVILUPPO ## [mysqld11] defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf socket = /tmp/mysql50_SIA_SVILUPPO.sock port = 3317 pid-file = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/mysql50_SIA_SVILUPPO.pid datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO but if I put the variable prompt in the specific my.cnf (for example /etc/mysql.config/my50_SIA_SVILUPPO.cnf),the prompt doesn't change By Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha scritto: Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it email%3astefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati Mob: 9912924044 Email-id: prajapat...@gmail.com Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com
Re: Problem with MySQL prompt
Hi Krishna, the problem is that you use --default-file on the command line and in this mode it's working fine, I also tried, but I have the configuration of the variable default-file in the general my.cnf and I enter in MySQL in this way: mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1408 Server version: 5.0.51b-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql in my case the prompt doesn't change Il giorno 23/dic/08, alle ore 11:01, Krishna Chandra Prajapati ha scritto: Hi Stefano, I have tested. It's working fine without any issue. Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add the below entires and restart the mysql server. [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates prompt = 'mysql5.1.30 ' [r...@linux18 ~]# mysql --defaults-file=/etc/my1.cnf Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.30 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql5.1.30 Thanks, -Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log ## ISTANZE DELLA PARTE PRODUZIONE ##--- ## ISTANZA SIA DI PRODUZIONE ##-- [mysqld01] defaults-file = /etc/mysql.config/my50_SIA.cnf socket = /tmp/mysql50_SIA.sock port = 3307 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA ## ISTANZA IPPOFONO DI PRODUZIONE ##--- [mysqld02] defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf socket = /tmp/mysql50_IPPOFONO.sock port = 3306 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/ mysql50_IPPOFONO.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO ### ## ISTANZE DELLA PARTE SVILUPPO ##- ## ISTANZA SIA DI SVILUPPO ## [mysqld11] defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf socket = /tmp/mysql50_SIA_SVILUPPO.sock port = 3317 pid-file = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ mysql50_SIA_SVILUPPO.pid datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO but if I put the variable prompt in the specific my.cnf (for example /etc/mysql.config/my50_SIA_SVILUPPO.cnf), the prompt doesn't change By Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha scritto: Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati Mob: 9912924044 Email-id: prajapat...@gmail.com Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it
Re: Problem with MySQL prompt
Hi Stefano, I believe that, different mysql configuration file for different mysql instance is a better idea. In your case, if any thing goes wrong with my.cnf Then, it is going to effect all mysql instance (either restart mysql server or any other way). It has a lots of disadvantages. You might be using mysql_multi to manage mysql instance (restart, start, stop) As, you told me. You have 1 general my.cnf and three different my.cnf for mysql instance. In one of my.cnf add and try [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates prompt = 'mysql5.1.30 ' But again, if you are connecting with socket then it will not show the changed prompt. Try, to connect using defaults-file. I feel that connecting to mysql server using socket is not reading the configuration file. i mean to say the it's using default available to it. Thanks, Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 5:14 PM, Stefano Elmopi stefano.elm...@sociale.itwrote: Hi Krishna, the problem is that you use --default-file on the command line and in this mode it's working fine, I also tried, but I have the configuration of the variable default-file in the general my.cnf and I enter in MySQL in this way: mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1408 Server version: 5.0.51b-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql in my case the prompt doesn't change Il giorno 23/dic/08, alle ore 11:01, Krishna Chandra Prajapati ha scritto: Hi Stefano, I have tested. It's working fine without any issue. Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add the below entires and restart the mysql server. [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates prompt = 'mysql5.1.30 ' [r...@linux18 ~]# mysql --defaults-file=/etc/my1.cnf Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.30 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql5.1.30 Thanks, -Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log ## ISTANZE DELLA PARTE PRODUZIONE ##--- ## ISTANZA SIA DI PRODUZIONE ##-- [mysqld01] defaults-file = /etc/mysql.config/my50_SIA.cnf socket = /tmp/mysql50_SIA.sock port = 3307 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA ## ISTANZA IPPOFONO DI PRODUZIONE ##--- [mysqld02] defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf socket = /tmp/mysql50_IPPOFONO.sock port = 3306 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/mysql50_IPPOFONO.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO ### ## ISTANZE DELLA PARTE SVILUPPO ##- ## ISTANZA SIA DI SVILUPPO ## [mysqld11] defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf socket = /tmp/mysql50_SIA_SVILUPPO.sock port = 3317 pid-file = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/mysql50_SIA_SVILUPPO.pid datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO but if I put the variable prompt in the specific my.cnf (for example /etc/mysql.config/my50_SIA_SVILUPPO.cnf),the prompt doesn't change By Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha scritto: Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel.
Re: Problem with MySQL prompt
Hi Krishna, I use the script mysql_multi to stop and the start several, or all, instances. At the end, to work with more ease, I will create scripts to connect to each instance and in the script force the variable prompt at the connection seems easy Thanks for all !!! Il giorno 23/dic/08, alle ore 13:51, Krishna Chandra Prajapati ha scritto: Hi Stefano, I believe that, different mysql configuration file for different mysql instance is a better idea. In your case, if any thing goes wrong with my.cnf Then, it is going to effect all mysql instance (either restart mysql server or any other way). It has a lots of disadvantages. You might be using mysql_multi to manage mysql instance (restart, start, stop) As, you told me. You have 1 general my.cnf and three different my.cnf for mysql instance. In one of my.cnf add and try [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates prompt = 'mysql5.1.30 ' But again, if you are connecting with socket then it will not show the changed prompt. Try, to connect using defaults-file. I feel that connecting to mysql server using socket is not reading the configuration file. i mean to say the it's using default available to it. Thanks, Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 5:14 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: Hi Krishna, the problem is that you use --default-file on the command line and in this mode it's working fine, I also tried, but I have the configuration of the variable default-file in the general my.cnf and I enter in MySQL in this way: mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1408 Server version: 5.0.51b-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql in my case the prompt doesn't change Il giorno 23/dic/08, alle ore 11:01, Krishna Chandra Prajapati ha scritto: Hi Stefano, I have tested. It's working fine without any issue. Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add the below entires and restart the mysql server. [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates prompt = 'mysql5.1.30 ' [r...@linux18 ~]# mysql --defaults-file=/etc/my1.cnf Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.30 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql5.1.30 Thanks, -Krishna Chandra Prajapati On Tue, Dec 23, 2008 at 2:00 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log ## ISTANZE DELLA PARTE PRODUZIONE ##--- ## ISTANZA SIA DI PRODUZIONE ##-- [mysqld01] defaults-file = /etc/mysql.config/my50_SIA.cnf socket = /tmp/mysql50_SIA.sock port = 3307 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA ## ISTANZA IPPOFONO DI PRODUZIONE ##--- [mysqld02] defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf socket = /tmp/mysql50_IPPOFONO.sock port = 3306 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/ mysql50_IPPOFONO.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO ### ## ISTANZE DELLA PARTE SVILUPPO ##- ## ISTANZA SIA DI SVILUPPO ## [mysqld11] defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf socket = /tmp/mysql50_SIA_SVILUPPO.sock port = 3317 pid-file = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ mysql50_SIA_SVILUPPO.pid datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO but if I put the variable prompt in the specific my.cnf (for example /etc/mysql.config/my50_SIA_SVILUPPO.cnf), the prompt doesn't change By Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha scritto: Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.it wrote: I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put
Problem with MySQL prompt
I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with MySQL prompt
Ciao Stefano, how do you connect to the different instances? if you use different operating system users or different mysql home directories just put in the home directory of each user a .my.cnf file (or my.cnf in the mysql home) with just the prompt setting in the [mysql] section. NOTE: in the home directory of the user the file starts with the dot(.my.cnf). The search order of mysql cnf files is, if my memory does not betray me, /etc/my.cnf $MYSQL_HOME/my.cnf $MYSQL_USER/.my.cnf they are all taken into consideration (like cascading style sheets) with the last setting overwriting the prevoius read ones. The only thing the prevent from reading all of the configuration files is specifying the option --defaults-file=/pat/to/my.cnf in the command line. Sorry I cannot test it now, so please try it. Aloha Claudio 2008/12/22 Stefano Elmopi stefano.elm...@sociale.it I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it email%3astefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: Problem with MySQL prompt
Stefano Elmopi wrote: If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. This is because the client reads from my.cnf before it starts talking to the server, and it can read any my.cnf file it likes. There's no way you can mandate that a single my.cnf file gets used for both the server and any client session connecting to it. Instead of running mysql(1) directly, I'd run it via one of three scripts, each of which sets up its environment so as to force mysql(1) to read a different my.cnf file in each case. This will also let you hard-code other information about each particular server that isn't important to keep secret, like the login name and the DB name. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with MySQL prompt
Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi stefano.elm...@sociale.itwrote: I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it email%3astefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati Mob: 9912924044 Email-id: prajapat...@gmail.com
Re: Problem with MySQL prompt
Thanks for the all answers !!! It's ok, even if I have three different my.cnf for my three instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log ## ISTANZE DELLA PARTE PRODUZIONE ##--- ## ISTANZA SIA DI PRODUZIONE ##-- [mysqld01] defaults-file = /etc/mysql.config/my50_SIA.cnf socket = /tmp/mysql50_SIA.sock port = 3307 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/SIA ## ISTANZA IPPOFONO DI PRODUZIONE ##--- [mysqld02] defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf socket = /tmp/mysql50_IPPOFONO.sock port = 3306 pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/mysql50_IPPOFONO.pid datadir= /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO ### ## ISTANZE DELLA PARTE SVILUPPO ##- ## ISTANZA SIA DI SVILUPPO ## [mysqld11] defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf socket = /tmp/mysql50_SIA_SVILUPPO.sock port = 3317 pid-file = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/ mysql50_SIA_SVILUPPO.pid datadir= /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO to have three different prompts, I have to create three scripts connection where I configure the prompt variable. I say right? By Il giorno 22/dic/08, alle ore 12:07, Warren Young ha scritto: Stefano Elmopi wrote: If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. This is because the client reads from my.cnf before it starts talking to the server, and it can read any my.cnf file it likes. There's no way you can mandate that a single my.cnf file gets used for both the server and any client session connecting to it. Instead of running mysql(1) directly, I'd run it via one of three scripts, each of which sets up its environment so as to force mysql(1) to read a different my.cnf file in each case. This will also let you hard-code other information about each particular server that isn't important to keep secret, like the login name and the DB name. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=stefano.elm...@sociale.it Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem with MySQL prompt
prajapat...@gmail.com (Krishna Chandra Prajapati) writes: You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. It's a shame that the prompt can't be defined dynamically based on characteristics of the current connection. That would make it much easier to distinguish which db instance you are talking to and only have a single configuration. Is there not an entry in bugs.mysql.com for this? I had a quick look but couldn't find one. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Problem with mysql passive connections
Hi all, I've a server where between 1-2 there comes a high load from less than 1k queries there's a jump to 60+k queries. It all started after adding more RAM to the server. Anyone seen this before ? Regards, Toke Herkild -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
startup problem on mysql 5.0.45
After a shutdown regular on my mysql master, when the mysql process startup apper the error below 070802 16:07:08 [Warning] The syntax for replication startup options is deprecat ed and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 070802 16:07:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 070802 16:07:11 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 31 1653757185. InnoDB: Doing recovery: scanned up to log sequence number 31 1653757205 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 0 row operations to undo InnoDB: Trx id counter is 0 864831488 InnoDB: Last MySQL binlog file position 0 624186576, file name .\morisot-bin.000 184 InnoDB: Starting in background the rollback of uncommitted transactions InnoDB: Cleaning up trx with id 0 864830109 070802 16:07:11InnoDB: Assertion failure in thread 3856 in file .\fsp\fsp0fsp.c line 3204 InnoDB: Failing assertion: xdes_get_bit(descr, XDES_FREE_BIT, buf_frame_get_page _no(header) % FSP_EXTENT_SIZE, mtr) == FALSE InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: about forcing recovery. InnoDB: Thread 1472 stopped in file .\os\os0thread.c line 122 InnoDB: Thread 2752 stopped in file .\os\os0sync.c line 532 If I add in my.ini the words innodb_force_recovery =3 mysql start in read only mode, but with the possibility to execute a global dump. But the dump file are correct (there are 4 innodb dbs)? How it is possible to define in which table of the unique dump file there is the error ? Many thanks in advance Massimo Someboby can help to find which is the problem ?
Re: keyboard-ONLY problem with mysql-client and UTF8; compilation flags?
On 10 jun 2007, at 20.47, tAndRead wrote: Hi all, snip when I try to add a foreign text from the keyboard in the mysql client, keystrokes are ignored! unless they are numbers, commas etc (using kde-konsole with the the DeJaVu international font) I believe this has to do something with the compilation and not configuration; because if I use the mysql-client rpm packages from SUSE 10.2, the keyboard works ok in interactive mysql sessions! Any ideas will be very much appreciated! This is probably a problem with your terminal program. I've had similar problems with other apps. -- Home is not where you are born, but where your heart finds peace - Tommy Nordgren, The dying old crone [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
keyboard-ONLY problem with mysql-client and UTF8; compilation flags?
Hi all, I have compiled mysqld 5.0.37 with utf support: ( configure --with-charset=utf8 --with-extra-charsets=none) utf8 is the default in my.cnf: ( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 ) mysqld acknowledges it: mysql show variables like charac%; +--+-+ | Variable_name | Value | +--+-+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /opt/servers/mysql/data/mysql/charsets/ | +--+-+ and my databases/tables are created with DEFAULT CHARSET=utf8 Shouldn't everything be OK? well, SELECTs display foreign chars ok, and batch inserts with mysqlinsert-cmds-file work ok BUT when I try to add a foreign text from the keyboard in the mysql client, keystrokes are ignored! unless they are numbers, commas etc (using kde-konsole with the the DeJaVu international font) I believe this has to do something with the compilation and not configuration; because if I use the mysql-client rpm packages from SUSE 10.2, the keyboard works ok in interactive mysql sessions! Any ideas will be very much appreciated!
keyboard-ONLY problem with mysql-client and UTF8; compilation flags?
Hi all, I have compiled mysqld 5.0.37 with utf support: ( configure --with-charset=utf8 --with-extra-charsets=none) utf8 is the default in my.cnf: ( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 ) mysqld acknowledges it: mysql show variables like charac%; +--+-+ | Variable_name | Value | +--+-+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /opt/servers/mysql/data/mysql/charsets/ | +--+-+ and my databases/tables are created with DEFAULT CHARSET=utf8 Shouldn't everything be OK? well, SELECTs display foreign chars ok, and batch inserts with mysqlinsert-cmds-file work ok BUT when I try to add a foreign text from the keyboard in the mysql client, keystrokes are ignored! unless they are numbers, commas etc (using kde-konsole with the the DeJaVu international font) I believe this has to do something with the compilation and not configuration; because if I use the mysql-client rpm packages from SUSE 10.2, the keyboard works ok in interactive mysql sessions! Any ideas will be very much appreciated!
Problem installing MySQL 5.0.24a from RHEL RPM on Centos Linux VPS box
Hi list, I'm trying to install MySQL 5.0.24a RHEL RPM on a Centos Linux VPS box. uname -a output on this box: Linux my.host.com 2.6.9-022stab078.14-enterprise #1 SMP Wed Jul 19 14:35:02 MSD 2006 i686 athlon i386 GNU/Linux It already has MySQL 4.1 RHEL installed on it - I checked this with rpm -q mysql, which shows: mysql-4.1.20-1.RHEL4.1 The 4.1 install came by with the box, probably (not sure but maybe able to find out from the previous administrator or the hosting provider). I don't want to uninstall the 4.1 if I can help it. Reason: though I'm fairly comfortable with Linux software installations in general, I haven't installed MySQL before, and so not sure of all the files that get installed, and their locations, particularly into other directories than the base installation directory (e.g. there is a file called my.cnf in /etc). So not sure if all the files installed with 4.1 will be properly removed if I uninstall 4.1, and if they don't, it may create conflicts; e.g. some config file of 4.1might get used when I try to run 5.0 after installing it, and this might lead to strange errors. So I want to install MySQL 5.0 into a different location. That is why I used the --prefix option in the install command that I used: rpm --install --test --hash --verbose --prefix /root/mysql5.0rhel4 MySQL-server-standard-5.0.24a-0.rhel4.i386.rpm When I run the above command (as root), I get this error message: warning: MySQL-server-standard-5.0.24a-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: package MySQL-server-standard is not relocatable Does this mean that this RPM can only be installed in the standard/default location? Is there any way or any other kind of package (e.g. not an RPM but a tar.gz) that will work - for the binary package, I mean - such that it will allow me to install MySQL into some base location (directory) specified by me? Otherwise I can install MySQL from the source tarball which I've already downloaded, but thought to avoid that route if possible, as I suspect it might take some time (not sure). This is because I just previously installed the GNU C++ compiler (g++) on the box, which I had to do because I had tried to install MySQL from the source tarball earlier and got a message C++ compiler fails sanity check, and Googling for that message, indicated that the C++ compiler was not installed on the system - my guess is that the C++ compiler is not there by default on the box because it is a VPS, so they want to minimize the disk space used by default. So I downloaded and installed the g++ compiler. It worked ok - I wrote a short C++ test program, could compile and run it. So the reason I want to avoid installing MySQL from source, is because the C++ compiler build+install, took a good amount of time, over 3.5 hours, probably because it compiles hundreds of small source files, and so does a lot of file I/O, and my client doesn't want to spend a lot of time on the install (the project is on a tight schedule). Thanks for any help or pointers. Vasudev Ram http://www.dancingbison.com 10.times say Truly rural
Subquery Problem With mysql-4.0 (Works with mysql-5.0)
I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works fine on mysql-5.0 but it give error with mysql-4.0. Query** SELECT c.MASTER_CO_ID as Expr1 FROM company LEFT OUTER JOIN (select MASTER_CO_ID,SLAVE_CO_ID from favorites where MASTER_CO_ID = '1' GROUP BY MASTER_CO_ID,SLAVE_CO_ID) c ON company.CO_ID = c.SLAVE_CO_ID GROUP BY c.MASTER_CO_ID *** Error with mysql4.0 #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 'select MASTER_CO_ID,SLAVE_CO_ID from favorites where MAS *** I have two tables company and favorites, like CREATE TABLE `company` ( `CO_ID` varchar(36) NOT NULL default '', `CO_NAME` varchar(50) default NULL, PRIMARY KEY (`CO_ID`), FULLTEXT KEY `CO_NAME` (`CO_NAME`,`INDUSTRY_NAME`,`CO_ADDR1`,`CO_ADDR2`,`CO_PIN`,`CO_URL`,`CO_INFO`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `favorites` ( `FAV_ID` bigint(20) NOT NULL auto_increment, `MASTER_CO_ID` varchar(36) default NULL, `SLAVE_CO_ID` varchar(36) default NULL, PRIMARY KEY (`FAV_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
Re: Subquery Problem With mysql-4.0 (Works with mysql-5.0)
2006/6/5, MySQL Nexeia [EMAIL PROTECTED]: I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works fine on mysql-5.0 but it give error with mysql-4.0. Query** SELECT c.MASTER_CO_ID as Expr1 FROM company LEFT OUTER JOIN (select MASTER_CO_ID,SLAVE_CO_ID from favorites where MASTER_CO_ID = '1' GROUP BY MASTER_CO_ID,SLAVE_CO_ID) c ON company.CO_ID = c.SLAVE_CO_ID GROUP BY c.MASTER_CO_ID *** MySQL 4.0.x does not support subquery. Subqueries are only supported starting with 4.1. Error with mysql4.0 #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 'select MASTER_CO_ID,SLAVE_CO_ID from favorites where MAS *** I have two tables company and favorites, like CREATE TABLE `company` ( `CO_ID` varchar(36) NOT NULL default '', `CO_NAME` varchar(50) default NULL, PRIMARY KEY (`CO_ID`), FULLTEXT KEY `CO_NAME` (`CO_NAME`,`INDUSTRY_NAME`,`CO_ADDR1`,`CO_ADDR2`,`CO_PIN`,`CO_URL`,`CO_INFO`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `favorites` ( `FAV_ID` bigint(20) NOT NULL auto_increment, `MASTER_CO_ID` varchar(36) default NULL, `SLAVE_CO_ID` varchar(36) default NULL, PRIMARY KEY (`FAV_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ; -- http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB Memory Problem causing mysql to crash
Dobromir, As I said in my first message (see the message quoted below), MySQL could use up to 4.991913 G of memory. So you could use more than 4GB. Check out the calculation below. Also read the rest of my message, regarding thread size, the manual page for crashing, max_connections, slow query logs, and disk partitions. You haven't indicated that you've done any of what I mentioned, and you might be using more than 4G anyway. -Sheeri On 5/8/06, Dobromir Velev [EMAIL PROTECTED] wrote: Hi, I'm aware of the fact that this is a 32 bit system - and I've tried to make sure that mysqld will not use more than 4 GB. As you can see the innodb_buffer_pool_size is 2 Gb and the total amount of memory used by the MyISAM key buffer size and the per thread variables is less then 2 GB. There are no other services on this machine so the memory should not be a problem. This server was working fine for almost a year until recently it started crashing. Could it be some memory problem I've ran into and can you suggest anything I can do to avoid similar problems in the future. Thanks Dobromir Velev On Saturday 06 May 2006 01:23, Heikki Tuuri wrote: Dobromir, you are running a 32-bit operating system. Then the size of the mysqld process is limited to 2 GB, or at most to 4 GB. The amount of total RAM 8 GB does not help here, since 2^32 = 4 G. You should reduce the key_buffer_size or innodb_buffer_pool_size in my.cnf. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: sheeri kritzer [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, May 05, 2006 10:50 PM Subject: Re: InnoDB Memory Problem causing mysql to crash Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB (I used the default binlog_cache_size value of 32K plus your settings) MySQL could use up to 4.991913 G of memory. Shouldn't be a problem, unless of course your 8G of machine is running something other than MySQL. Is it? Because the fact that it could not allocate memory means that something was trying to use memory that didn't exist Did MySQL dump a core file? Did you follow this advice? You seem to be running 32-bit Linux and have 473 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap= for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html Did you read the man page? 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. Also, did you try to look at your slow query logs to see if there was some kind of query hogging memory? What about backups running at the same time? I'll note that you maxxed out your connections, which shouldn't cause a crash, but might indicate that your server tuning is not up-to-date with your actual usage. Are your data and logfiles are on a diffferent partitions? We had problems with one machine where the data and logfiles were on the same partition, and it would crash -- we moved to a machine that was the same except for the different OS partitions, and it didn't crash! We figure the disk seeking just killed the OS so it segfaulted the mysql process. -Sheeri On 5/4/06, Dobromir Velev [EMAIL PROTECTED] wrote: Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the l= ast month without obvoius reason Any help will be appreciated. Dobromir Velev My Server is Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELs= mp Dual 3.2 GHz Intel Xeon 8 GB RAM with 3 x 146GB SCA Ultra 320 10K RPM SCSI Drives my.cnf settings innodb_buffer_pool_size=3D2000M innodb_additional_mem_pool_size=3D20M innodb_log_file_size=3D150M innodb_log_buffer_size=3D8M innodb_flush_log_at_trx_commit=3D0 innodb_lock_wait_timeout=3D50 key_buffer_size=3D1000M read_buffer_size=3D500K read_rnd_buffer_size=3D1200K sort_buffer_size=3D1M thread_cache=3D256 thread_concurrency=3D8 thread_stack=3D126976 myisam_sort_buffer_size=3D64M max_connections=3D600 The error log shows the following message: InnoDB: Fatal error: cannot allocate 1048576 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 2263507272 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB
Re: InnoDB Memory Problem causing mysql to crash
Hi, I'm aware of the fact that this is a 32 bit system - and I've tried to make sure that mysqld will not use more than 4 GB. As you can see the innodb_buffer_pool_size is 2 Gb and the total amount of memory used by the MyISAM key buffer size and the per thread variables is less then 2 GB. There are no other services on this machine so the memory should not be a problem. This server was working fine for almost a year until recently it started crashing. Could it be some memory problem I've ran into and can you suggest anything I can do to avoid similar problems in the future. Thanks Dobromir Velev On Saturday 06 May 2006 01:23, Heikki Tuuri wrote: Dobromir, you are running a 32-bit operating system. Then the size of the mysqld process is limited to 2 GB, or at most to 4 GB. The amount of total RAM 8 GB does not help here, since 2^32 = 4 G. You should reduce the key_buffer_size or innodb_buffer_pool_size in my.cnf. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: sheeri kritzer [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, May 05, 2006 10:50 PM Subject: Re: InnoDB Memory Problem causing mysql to crash Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB (I used the default binlog_cache_size value of 32K plus your settings) MySQL could use up to 4.991913 G of memory. Shouldn't be a problem, unless of course your 8G of machine is running something other than MySQL. Is it? Because the fact that it could not allocate memory means that something was trying to use memory that didn't exist Did MySQL dump a core file? Did you follow this advice? You seem to be running 32-bit Linux and have 473 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap= for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html Did you read the man page? 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. Also, did you try to look at your slow query logs to see if there was some kind of query hogging memory? What about backups running at the same time? I'll note that you maxxed out your connections, which shouldn't cause a crash, but might indicate that your server tuning is not up-to-date with your actual usage. Are your data and logfiles are on a diffferent partitions? We had problems with one machine where the data and logfiles were on the same partition, and it would crash -- we moved to a machine that was the same except for the different OS partitions, and it didn't crash! We figure the disk seeking just killed the OS so it segfaulted the mysql process. -Sheeri On 5/4/06, Dobromir Velev [EMAIL PROTECTED] wrote: Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the l= ast month without obvoius reason Any help will be appreciated. Dobromir Velev My Server is Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELs= mp Dual 3.2 GHz Intel Xeon 8 GB RAM with 3 x 146GB SCA Ultra 320 10K RPM SCSI Drives my.cnf settings innodb_buffer_pool_size=3D2000M innodb_additional_mem_pool_size=3D20M innodb_log_file_size=3D150M innodb_log_buffer_size=3D8M innodb_flush_log_at_trx_commit=3D0 innodb_lock_wait_timeout=3D50 key_buffer_size=3D1000M read_buffer_size=3D500K read_rnd_buffer_size=3D1200K sort_buffer_size=3D1M thread_cache=3D256 thread_concurrency=3D8 thread_stack=3D126976 myisam_sort_buffer_size=3D64M max_connections=3D600 The error log shows the following message: InnoDB: Fatal error: cannot allocate 1048576 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 2263507272 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. 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 buil= t, or misconfigured. This error can also be caused by malfunctioning hardwar= e. We will try our best to scrape up some info that will hopefully help diag
Re: InnoDB Memory Problem causing mysql to crash
Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB (I used the default binlog_cache_size value of 32K plus your settings) MySQL could use up to 4.991913 G of memory. Shouldn't be a problem, unless of course your 8G of machine is running something other than MySQL. Is it? Because the fact that it could not allocate memory means that something was trying to use memory that didn't exist Did MySQL dump a core file? Did you follow this advice? You seem to be running 32-bit Linux and have 473 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html Did you read the man page? 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. Also, did you try to look at your slow query logs to see if there was some kind of query hogging memory? What about backups running at the same time? I'll note that you maxxed out your connections, which shouldn't cause a crash, but might indicate that your server tuning is not up-to-date with your actual usage. Are your data and logfiles are on a diffferent partitions? We had problems with one machine where the data and logfiles were on the same partition, and it would crash -- we moved to a machine that was the same except for the different OS partitions, and it didn't crash! We figure the disk seeking just killed the OS so it segfaulted the mysql process. -Sheeri On 5/4/06, Dobromir Velev [EMAIL PROTECTED] wrote: Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the last month without obvoius reason Any help will be appreciated. Dobromir Velev My Server is Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp Dual 3.2 GHz Intel Xeon 8 GB RAM with 3 x 146GB SCA Ultra 320 10K RPM SCSI Drives my.cnf settings innodb_buffer_pool_size=2000M innodb_additional_mem_pool_size=20M innodb_log_file_size=150M innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=0 innodb_lock_wait_timeout=50 key_buffer_size=1000M read_buffer_size=500K read_rnd_buffer_size=1200K sort_buffer_size=1M thread_cache=256 thread_concurrency=8 thread_stack=126976 myisam_sort_buffer_size=64M max_connections=600 The error log shows the following message: InnoDB: Fatal error: cannot allocate 1048576 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 2263507272 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. 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=1048576000 read_buffer_size=507904 max_used_connections=600 max_connections=600 threads_connected=473 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1935995 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. You seem to be running 32-bit Linux and have 473 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html thd=(nil) 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... Cannot determine thread, fp=0xbff1f558, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8072d74 0x826d678 0x8213c74 0x8213d04 0x8218b84 0x81d5ba6 0x80fd659 0x826ae2c 0x82a0cda New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it 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. Number of processes running now: 0 060503 16:37:21 mysqld restarted 060503 16:37:21 Can't start server: Bind
Re: InnoDB Memory Problem causing mysql to crash
Dobromir, you are running a 32-bit operating system. Then the size of the mysqld process is limited to 2 GB, or at most to 4 GB. The amount of total RAM 8 GB does not help here, since 2^32 = 4 G. You should reduce the key_buffer_size or innodb_buffer_pool_size in my.cnf. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: sheeri kritzer [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, May 05, 2006 10:50 PM Subject: Re: InnoDB Memory Problem causing mysql to crash Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB (I used the default binlog_cache_size value of 32K plus your settings) MySQL could use up to 4.991913 G of memory. Shouldn't be a problem, unless of course your 8G of machine is running something other than MySQL. Is it? Because the fact that it could not allocate memory means that something was trying to use memory that didn't exist Did MySQL dump a core file? Did you follow this advice? You seem to be running 32-bit Linux and have 473 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap= for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html Did you read the man page? 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. Also, did you try to look at your slow query logs to see if there was some kind of query hogging memory? What about backups running at the same time? I'll note that you maxxed out your connections, which shouldn't cause a crash, but might indicate that your server tuning is not up-to-date with your actual usage. Are your data and logfiles are on a diffferent partitions? We had problems with one machine where the data and logfiles were on the same partition, and it would crash -- we moved to a machine that was the same except for the different OS partitions, and it didn't crash! We figure the disk seeking just killed the OS so it segfaulted the mysql process. -Sheeri On 5/4/06, Dobromir Velev [EMAIL PROTECTED] wrote: Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the l= ast month without obvoius reason Any help will be appreciated. Dobromir Velev My Server is Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELs= mp Dual 3.2 GHz Intel Xeon 8 GB RAM with 3 x 146GB SCA Ultra 320 10K RPM SCSI Drives my.cnf settings innodb_buffer_pool_size=3D2000M innodb_additional_mem_pool_size=3D20M innodb_log_file_size=3D150M innodb_log_buffer_size=3D8M innodb_flush_log_at_trx_commit=3D0 innodb_lock_wait_timeout=3D50 key_buffer_size=3D1000M read_buffer_size=3D500K read_rnd_buffer_size=3D1200K sort_buffer_size=3D1M thread_cache=3D256 thread_concurrency=3D8 thread_stack=3D126976 myisam_sort_buffer_size=3D64M max_connections=3D600 The error log shows the following message: InnoDB: Fatal error: cannot allocate 1048576 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 2263507272 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. 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 buil= t, or misconfigured. This error can also be caused by malfunctioning hardwar= e. We will try our best to scrape up some info that will hopefully help diag= nose the problem, but since we have already crashed, something is definitely w= rong and this may fail. key_buffer_size=3D1048576000 read_buffer_size=3D507904 max_used_connections=3D600 max_connections=3D600 threads_connected=3D473 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = =3D 1935995 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. You seem to be running 32-bit Linux and have 473 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap= for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html thd=3D(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see
InnoDB Memory Problem causing mysql to crash
Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the last month without obvoius reason Any help will be appreciated. Dobromir Velev My Server is Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp Dual 3.2 GHz Intel Xeon 8 GB RAM with 3 x 146GB SCA Ultra 320 10K RPM SCSI Drives my.cnf settings innodb_buffer_pool_size=2000M innodb_additional_mem_pool_size=20M innodb_log_file_size=150M innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=0 innodb_lock_wait_timeout=50 key_buffer_size=1000M read_buffer_size=500K read_rnd_buffer_size=1200K sort_buffer_size=1M thread_cache=256 thread_concurrency=8 thread_stack=126976 myisam_sort_buffer_size=64M max_connections=600 The error log shows the following message: InnoDB: Fatal error: cannot allocate 1048576 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 2263507272 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. 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=1048576000 read_buffer_size=507904 max_used_connections=600 max_connections=600 threads_connected=473 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1935995 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. You seem to be running 32-bit Linux and have 473 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html thd=(nil) 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... Cannot determine thread, fp=0xbff1f558, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8072d74 0x826d678 0x8213c74 0x8213d04 0x8218b84 0x81d5ba6 0x80fd659 0x826ae2c 0x82a0cda New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it 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. Number of processes running now: 0 060503 16:37:21 mysqld restarted 060503 16:37:21 Can't start server: Bind on TCP/IP port: Address already in use 060503 16:37:21 Do you already have another mysqld server running on port: 3306 ? 060503 16:37:21 Aborting and the resolved stack trace is 0x8072d74 handle_segfault + 420 0x826d678 pthread_sighandler + 184 0x8213c74 ut_malloc_low + 132 0x8213d04 ut_malloc + 20 0x8218b84 os_aio_simulated_handle + 916 0x81d5ba6 fil_aio_wait + 214 0x80fd659 io_handler_thread + 25 0x826ae2c pthread_start_thread + 220 0x82a0cda thread_start + 4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem accessing mysql from PHP
I am getting this error and I do not know why? Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client I can access mysql from the command line and I can access it from mysql Administrator. When I run a php program I get an error. I also I am ahving problems accessing the DB from phpmyadmin I am running php 4.4.2 Client API version 3.23.49 mysql 5.0.18-nt apache 2.0.55 Help? Nestor :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem accessing mysql from PHP
Nestor [EMAIL PROTECTED] wrote on 03/10/2006 02:33:50 PM: I am getting this error and I do not know why? Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client I can access mysql from the command line and I can access it from mysql Administrator. When I run a php program I get an error. I also I am ahving problems accessing the DB from phpmyadmin I am running php 4.4.2 Client API version 3.23.49 mysql 5.0.18-nt apache 2.0.55 Help? Nestor :-) This is not just a FAQ but it is a VFAQ: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Problem installing mysql on Debian linux
Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix /home/grtsel/mysql and the output error was: checking for FIONREAD in sys/ioctl.h... yes checking for TIOCSTAT in sys/ioctl.h... no checking if struct dirent has a d_ino member... yes checking whether signal handlers are of type void... yes checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found I installed ncurses package from source in order to bypass this problem but nothing happend... Does anyone know what's going wrong..? Please help me... Gregory
Re: Problem installing mysql on Debian linux
On 2/25/06, Tselemegkos Grigorios [EMAIL PROTECTED] wrote: Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix /home/grtsel/mysql and the output error was: checking for FIONREAD in sys/ioctl.h... yes checking for TIOCSTAT in sys/ioctl.h... no checking if struct dirent has a d_ino member... yes checking whether signal handlers are of type void... yes checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found I installed ncurses package from source in order to bypass this problem but nothing happend... Does anyone know what's going wrong..? Please help me... Gregory, You need to install the termcap libraries. What version of Debian are you using? Why don't you install MySQL 5.0.18? Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing mysql on Debian linux
Thanks for the reply Sam, :-) I'm using Debian 3.1 I thought that termcap libraries where into ndevel package, which i installed. Where can i find the termcap libraries. Do i have to do something special in the configure of termcap or mysql? I need a version of mysql 4.1.0 because i need to install CDSware (it has problems with earlier versions) Does mysql 5.0.18 compile without termcap libraries installed? Gregory - Original Message - From: Sam Tran [EMAIL PROTECTED] To: Tselemegkos Grigorios [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, February 25, 2006 9:34 PM Subject: Re: Problem installing mysql on Debian linux On 2/25/06, Tselemegkos Grigorios [EMAIL PROTECTED] wrote: Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix /home/grtsel/mysql and the output error was: checking for FIONREAD in sys/ioctl.h... yes checking for TIOCSTAT in sys/ioctl.h... no checking if struct dirent has a d_ino member... yes checking whether signal handlers are of type void... yes checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found I installed ncurses package from source in order to bypass this problem but nothing happend... Does anyone know what's going wrong..? Please help me... Gregory, You need to install the termcap libraries. What version of Debian are you using? Why don't you install MySQL 5.0.18? Sam __ Χρησιμοποιείτε Yahoo!; Βαρεθήκατε τα ενοχλητικά μηνύματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://mail.yahoo.gr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem installing MySQL 5.0
Hello everybody, This is the first time I try to install MySQL 5.0, I think I followed the steps showed by the documentation in the right way, but when I run the command: rpm -i MySQL-server-Version-.i386.rpm I get back the error: error: Failed dependencies: perl(DBI) is needed by MySQL-server-standard-5.0.18-0.rhel3 I am trying to install MySQL on this platform: - CPU:AMD Athlon 800 Mhz - Operating System: Linux Fedora core 2, release 2.6.5-1.358 The packages I have downloaded are: - MySQL-server-standard-5.0.18-0.rhel3.i386.rpm - MySQL-client-standard-5.0.18-0.rhel3.i386.rpm After the error, I found a few information on internet about perl(DBI), so I downloaded it and installed it on my system. The test step (make test) ended with error 355 (??), but I run anyway make install which ended without problems, I think. At this point I do not know what to do, so I need your help to solve this problem. Greetings Francesco Vincenti * *
Re: Problem installing MySQL 5.0
You can force the installation (--nodeps) when installing the RPM package. Even if you build DBI (and not install it from RPM) it won't be in the RPM database, and you'll get the same error. You should be able to get a FC2 RPM for the DBI module - download that RPM and install it, then install MySQL - that would be the easiest course of action... -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 http://www.otg-nc.com Francesco Vincenti wrote: Hello everybody, This is the first time I try to install MySQL 5.0, I think I followed the steps showed by the documentation in the right way, but when I run the command: rpm -i MySQL-server-Version-.i386.rpm I get back the error: error: Failed dependencies: perl(DBI) is needed by MySQL-server-standard-5.0.18-0.rhel3 I am trying to install MySQL on this platform: - CPU:AMD Athlon 800 Mhz - Operating System: Linux Fedora core 2, release 2.6.5-1.358 The packages I have downloaded are: - MySQL-server-standard-5.0.18-0.rhel3.i386.rpm - MySQL-client-standard-5.0.18-0.rhel3.i386.rpm After the error, I found a few information on internet about perl(DBI), so I downloaded it and installed it on my system. The test step (make test) ended with error 355 (??), but I run anyway make install which ended without problems, I think. At this point I do not know what to do, so I need your help to solve this problem. Greetings Francesco Vincenti * * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing MySQL 5.0
Hello Chander, thank you very much. I tried to do in your way ad the installation works! I downloaded the perl(DBI) .rpm and I installed it the first time using the command: rpm -Uvh perl-DBI-1.50-1.i386.rpm but I got back an error about one glibc library not founded, so I use this format: rpm -Uvh --nodeps perl-DBI-1.50-1.i386.rpm and the installation finished without problems. Then, I installed both MySQL-server-standard-5.0.18-0 .rhel3.i386.rpm, with which I have had the problem, and MySQL-client-standard-5.0.18-0.rhel3.i386.rpm and all went in the right way. Greetings Francesco Vincenti
Re: Problem installing MySQL on Mac OSX 10.4.3
Those message are kind of odd, even on a messed up system. I would first run the repair privileges in the disk utility for good measure, then delete all traces of MySQL and just start over. MySQL should be in /usr/local/mysql. To remove it just type: sudo rm -R /usr/local/mysql Then try installing again. If you are running OSX Server, things may be a little different. Apple puts MySQL files in different places on there server install as I recall. You may need to poke around a bit to find them. Check /usr/local and also /etc On Dec 2, 2005, at 5:26 PM, Ton Kuypers wrote: Hi, I've downloaded the mysql-max-4.1.15-apple-darwin8.2.0- powerpc.dmg and tried to install it, but I keep on getting the error You cannot continue. There is nothing to install. I've also tried the mysql-max-5.0.16-osx10.4-powerpc.dmg and the mysql-standard-4.1.15-apple-darwin8.2.0-powerpc.dmg, all give the same result... Can anyone help me? I think the previous person using this Mac screwed up some things, I've found traces of mySQL on the system, but I cannot find anything usable anymore. Any help is welcome! warm regards, Ton Kuypers Digital Media Partners bvba Tel. +32 (0)477 / 739 530 Fax +32 (0)14 / 71 03 04 http://www.dmp-int.com -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem installing MySQL on Mac OSX 10.4.3
Hi, I've downloaded the mysql-max-4.1.15-apple-darwin8.2.0-powerpc.dmg and tried to install it, but I keep on getting the error You cannot continue. There is nothing to install. I've also tried the mysql-max-5.0.16-osx10.4-powerpc.dmg and the mysql-standard-4.1.15-apple-darwin8.2.0-powerpc.dmg, all give the same result... Can anyone help me? I think the previous person using this Mac screwed up some things, I've found traces of mySQL on the system, but I cannot find anything usable anymore. Any help is welcome! warm regards, Ton Kuypers Digital Media Partners bvba Tel. +32 (0)477 / 739 530 Fax +32 (0)14 / 71 03 04 http://www.dmp-int.com
Re: Problem with MySQL 5 on OS X Tiger
Hello. Some tips from the manual could be helpful. See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/starting-server.html untz wrote: Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger... Ran the installer and it installed everything to /usr/local/ ... Updated my .bash_profile by creating a MYSQL_HOME variable and appending that MYSQL_HOME/bin to the PATH variable... Now, the problem is that when I try to check my installation by typing mysql, I receive an ERROR message... Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Here's my .bash_profile: Raven:~ untz$ cat .bash_profile . ~/.profile AXIS_HOME=/Developer/axis-1_3; AXIS_LIB=$AXIS_HOME/lib; AXISCLASSPATH=$AXIS_LIB/axis.jar:$AXIS_LIB/commons-discovery.jar: $AXIS_LIB/commons-logging.jar:$AXIS_LIB/jaxrpc.jar:$AXIS_LIB/saaj.jar: $AXIS_LIB/log4j-1.2.8.jar:$AXIS_LIB/xml-apis.jar:$AXIS_LIB/ xercesImpl.jar; JAVA_HOME=/System/Library/frameworks/JavaVM.framework/Versions/1.5.0/ Home; J2EE_HOME=/Developer/JavaTools/j2sdkee1.3.1; J2ME_HOME=/Developer/JavaTools/j2me_wireless_toolkit2.2; CATALINA_HOME=/Developer/JavaTools/tomcat/jakarta-tomcat-5.5.9; MYSQL_HOME=/usr/local/mysql CLASSPATH=.:$J2EE_HOME/lib/j2ee.jar:$CATALINA_HOME/common/lib/ servlet-api.jar:$CATALINA_HOME/common/lib/jsp-api.jar:/Developer/ Database/hsqldb/lib/hsqldb.jar; PATH=$PATH:$JAVA_HOME/bin:$J2EE_HOME/bin:$J2ME_HOME/bin:/usr/local/ bin:/opt/local/bin:$MYSQL_HOME/bin; VIMRUNTIME=/Applications/Vim.app/runtime; export AXIS_HOME AXIS_LIB AXISCLASSPATH JAVA_HOME J2ME_HOME J2EE_HOME CATALINA_HOME MYSQL_HOME PATH VIMRUNTIME bash Can anyone tell me what possibly I am doing wrong? Many, many thanks! -Unnsse -- 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]
Problem with MySQL 5 on OS X Tiger
Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger... Ran the installer and it installed everything to /usr/local/ ... Updated my .bash_profile by creating a MYSQL_HOME variable and appending that MYSQL_HOME/bin to the PATH variable... Now, the problem is that when I try to check my installation by typing mysql, I receive an ERROR message... Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Here's my .bash_profile: Raven:~ untz$ cat .bash_profile . ~/.profile AXIS_HOME=/Developer/axis-1_3; AXIS_LIB=$AXIS_HOME/lib; AXISCLASSPATH=$AXIS_LIB/axis.jar:$AXIS_LIB/commons-discovery.jar: $AXIS_LIB/commons-logging.jar:$AXIS_LIB/jaxrpc.jar:$AXIS_LIB/saaj.jar: $AXIS_LIB/log4j-1.2.8.jar:$AXIS_LIB/xml-apis.jar:$AXIS_LIB/ xercesImpl.jar; JAVA_HOME=/System/Library/frameworks/JavaVM.framework/Versions/1.5.0/ Home; J2EE_HOME=/Developer/JavaTools/j2sdkee1.3.1; J2ME_HOME=/Developer/JavaTools/j2me_wireless_toolkit2.2; CATALINA_HOME=/Developer/JavaTools/tomcat/jakarta-tomcat-5.5.9; MYSQL_HOME=/usr/local/mysql CLASSPATH=.:$J2EE_HOME/lib/j2ee.jar:$CATALINA_HOME/common/lib/ servlet-api.jar:$CATALINA_HOME/common/lib/jsp-api.jar:/Developer/ Database/hsqldb/lib/hsqldb.jar; PATH=$PATH:$JAVA_HOME/bin:$J2EE_HOME/bin:$J2ME_HOME/bin:/usr/local/ bin:/opt/local/bin:$MYSQL_HOME/bin; VIMRUNTIME=/Applications/Vim.app/runtime; export AXIS_HOME AXIS_LIB AXISCLASSPATH JAVA_HOME J2ME_HOME J2EE_HOME CATALINA_HOME MYSQL_HOME PATH VIMRUNTIME bash Can anyone tell me what possibly I am doing wrong? Many, many thanks! -Unnsse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with MySQL 5 on OS X Tiger
Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket file at /tmp/mysql.sock -- This is where the server will create it's socket file by default. It is an indication that your MySQL Server is in fact installed, but simply not started. If my memory serves me correctly the OSX Installer package includes a System Preferences module. Try opening your system prefs and looking for a MySQL button in the Other section. That control panel applet should allow you to easily start the server. Otherwise, running the following command should suffice: sudo mysqld_safe --user=mysql Once you have been prompted for your sudo password you can background the process by press Ctrl-Z and then entering the command bg to the shell. I hope this helps, Kind Regards, -- Lachlan Mulcahy, Support Engineer MySQL AB, Melbourne, Australia Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with MySQL 5 on OS X Tiger
Lachlan Mulcahy wrote: Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket file at /tmp/mysql.sock -- This is where the server will create it's socket file by default. It is an indication that your MySQL Server is in fact installed, but simply not started. If my memory serves me correctly the OSX Installer package includes a System Preferences module. Try opening your system prefs and looking for a MySQL button in the Other section. That control panel applet should allow you to easily start the server. Otherwise, running the following command should suffice: sudo mysqld_safe --user=mysql Once you have been prompted for your sudo password you can background the process by press Ctrl-Z and then entering the command bg to the shell. I hope this helps, Kind Regards, That will work, but I find it simpler when starting manually to run `sudo -v` to get prompted for my password, then `sudo mysqld_safe ` to start mysql. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with mysql-administrator-1.1.5, s.o.
Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running under Windows NT Sp6. Starting the tools I get the error message, like procedure GetFileSizeEx not found in Kernel32.dll. Suppose you have to define #ifdef NT while compiling, or similar, because procedure GetFileSizeEx isn't present in Windows NT Sp6 installation, Thanks Wolfgang Bogenrieder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with mysql-administrator-1.1.5, s.o.
Hello. It doesn't run on Windows NT 4 and below. See: http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html Wolfgang Bogenrieder wrote: Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running under Windows NT Sp6. Starting the tools I get the error message, like procedure GetFileSizeEx not found in Kernel32.dll. Suppose you have to define #ifdef NT while compiling, or similar, because procedure GetFileSizeEx isn't present in Windows NT Sp6 installation, Thanks Wolfgang Bogenrieder -- 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]
Help! Problem moving MySQL data dir to a larger file system
I'm running MySQL (--ersion says mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The datadir was in it's own filesystem, mounted at /mysql, but it's now filled up (it's a 15 GB partition and it has 1.5 MB free). I shut down MySQL (did a kill `cat /mysql/mysql.pid` and waited for the daemon to exit), created a new directory (/z/mysql, in a filesystem with about 30 GB free), and verified that the files copied ok. I now try to restart mysql with /usr/local/bin/mysqld_safe --datadir=/z/mysql --pid-file=/z/mysql/mysql.pid /dev/null 21 . When I do a ps ax afterwards I don't see mysqld running. The host name is www2, so I looked in /z/mysql/www2.err and saw: 051107 00:32:49 mysqld started /usr/local/libexec/mysqld: File './www2-bin.46' not found (Errcode: 13) 051107 0:32:49 [ERROR] Could not use www2-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 051107 0:32:49 [ERROR] Aborting 051107 0:32:49 [Note] /usr/local/libexec/mysqld: Shutdown complete 051107 00:32:49 mysqld ended This confuses the crap out of me! I looked again in the /mysql directory, and there is no file named www2-bin.46 prewent. There is a www2-bin.45, and that same file is present in /z mysql and is the same size. So why is mysql looking for that non-existent file? And what do I have to do to make this work again? This is kind of a critical problem for us. -- Dan Mahoney [EMAIL PROTECTED] How you behave towards cats here below determines your status in Heaven. Robert Heinlein There are two means of refuge from the miseries of life - music and cats - Albert Schweitzer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help! Problem moving MySQL data dir to a larger file system
Hi Daniel, Check your permissions. Your mysqld process is probably trying to create the log file but can't and is telling you via the error code 13 message $ perror 13 System error: 13 = Permission denied $ Regards Daniel C. Mahoney wrote: I'm running MySQL (--ersion says mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The datadir was in it's own filesystem, mounted at /mysql, but it's now filled up (it's a 15 GB partition and it has 1.5 MB free). I shut down MySQL (did a kill `cat /mysql/mysql.pid` and waited for the daemon to exit), created a new directory (/z/mysql, in a filesystem with about 30 GB free), and verified that the files copied ok. I now try to restart mysql with /usr/local/bin/mysqld_safe --datadir=/z/mysql --pid-file=/z/mysql/mysql.pid /dev/null 21 . When I do a ps ax afterwards I don't see mysqld running. The host name is www2, so I looked in /z/mysql/www2.err and saw: 051107 00:32:49 mysqld started /usr/local/libexec/mysqld: File './www2-bin.46' not found (Errcode: 13) 051107 0:32:49 [ERROR] Could not use www2-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 051107 0:32:49 [ERROR] Aborting 051107 0:32:49 [Note] /usr/local/libexec/mysqld: Shutdown complete 051107 00:32:49 mysqld ended This confuses the crap out of me! I looked again in the /mysql directory, and there is no file named www2-bin.46 prewent. There is a www2-bin.45, and that same file is present in /z mysql and is the same size. So why is mysql looking for that non-existent file? And what do I have to do to make this work again? This is kind of a critical problem for us. -- Dan Mahoney [EMAIL PROTECTED] How you behave towards cats here below determines your status in Heaven. Robert Heinlein There are two means of refuge from the miseries of life - music and cats - Albert Schweitzer -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem starting MySQL With Moved Data Directory
Hello. and restarted MySQL with /etc/init.d/mysql start, I get the following: Starting MySQL database server: mysqld. Checking for crashed MySQL tables in the background. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' Is there something in MySQL error log? See: http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html http://dev.mysql.com/doc/mysql/en/Error_log.html Hal Vaughan wrote: I'm using MySQL 4.0.24-10 on Debian Sarge (Linux, and the stable branch of Debian, just to clarify). I had a setup of a program I've been working on for several years that is on a RAID. I changed MySQL's data directory so it will be on the same RAID and backed up, along with all my other data and programs. Originally this was set up under a Debian-based distro that was based on the testing and unstable branches of Debian. Before putting the server into production, I wanted to change it to Debian Stable (Sarge) for safety. (I'll sleep easier at night if it's on Sarge with regular security updates than depending on unstable packages!) So I backed up all the data on the RAID, wiped the original boot/system drive, installed Debian Sarge, did an fsck on the RAID, found errors, wiped it out, restored the original data, including the MySQL db files. When I installed MySQL on the re-done system, it worked. When altered the line in /etc/mysql/my.cnf from: datadir = /var/lib/mysql to: datadir = /thresh/tNet/db and restarted MySQL with /etc/init.d/mysql start, I get the following: Starting MySQL database server: mysqld. Checking for crashed MySQL tables in the background. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' However, after I got this, I entered mysql and got a connection. The databases and tables seemed intact. I checked, and it turned out that somewhere in the backup/restore process the ownership of the files was changed. I went through and changed the ownership of /thresh/tNet/db to mysql:mysql and changed the ownership of /thresh/tNet/db/mysql to mysql:root. Basically, I changed the ownership of the files in the new data directory to match what I found in /var/lib/mysql, then I stopped and restarted MySQL. I still got the same error messages. While MySQL is working, I don't want to do anything with it because I'm not clear why debian-sys-maint needs access, as opposed to just the user mysql. To test, I made sure all the files from the db directory on down were set for all to read and write and all directories set for all to read, write, and execute. That doesn't help. So what is wrong, what do I need to do, and why didn't I get this error when using the same database directory before? Thanks for any help! Hal -- 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]
Problem starting MySQL With Moved Data Directory
I'm using MySQL 4.0.24-10 on Debian Sarge (Linux, and the stable branch of Debian, just to clarify). I had a setup of a program I've been working on for several years that is on a RAID. I changed MySQL's data directory so it will be on the same RAID and backed up, along with all my other data and programs. Originally this was set up under a Debian-based distro that was based on the testing and unstable branches of Debian. Before putting the server into production, I wanted to change it to Debian Stable (Sarge) for safety. (I'll sleep easier at night if it's on Sarge with regular security updates than depending on unstable packages!) So I backed up all the data on the RAID, wiped the original boot/system drive, installed Debian Sarge, did an fsck on the RAID, found errors, wiped it out, restored the original data, including the MySQL db files. When I installed MySQL on the re-done system, it worked. When altered the line in /etc/mysql/my.cnf from: datadir = /var/lib/mysql to: datadir = /thresh/tNet/db and restarted MySQL with /etc/init.d/mysql start, I get the following: Starting MySQL database server: mysqld. Checking for crashed MySQL tables in the background. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' However, after I got this, I entered mysql and got a connection. The databases and tables seemed intact. I checked, and it turned out that somewhere in the backup/restore process the ownership of the files was changed. I went through and changed the ownership of /thresh/tNet/db to mysql:mysql and changed the ownership of /thresh/tNet/db/mysql to mysql:root. Basically, I changed the ownership of the files in the new data directory to match what I found in /var/lib/mysql, then I stopped and restarted MySQL. I still got the same error messages. While MySQL is working, I don't want to do anything with it because I'm not clear why debian-sys-maint needs access, as opposed to just the user mysql. To test, I made sure all the files from the db directory on down were set for all to read and write and all directories set for all to read, write, and execute. That doesn't help. So what is wrong, what do I need to do, and why didn't I get this error when using the same database directory before? Thanks for any help! Hal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
possible MySQL bug - insert into 'double' column problem with mysql 4.1
Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. Is this a known problem? Does anyone have a solution? I'm running standard MySQL binaries on redhat linux 7.2 kernel 2.4.20-28.7smp. Help! Cheers, Andrew mysql desc table1; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| mediumint(6) | | PRI | NULL| auto_increment | | GeoQuality| varchar(5) | YES | | NULL|| | lon | double(7,6) | YES | MUL | NULL|| | lat | double(7,6) | YES | | NULL|| | GeocodeDate | date | YES | | NULL|| | GeocodeSource | varchar(25) | YES | | NULL|| | state | varchar(70) | YES | | NULL|| | client_id | varchar(40) | YES | MUL | NULL|| +---+--+--+-+-++ 15 rows in set (0.00 sec) mysql INSERT INTO table1VALUES (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL); Query OK, 1 row affected, 1 warning (0.01 sec) mysql select * from table1 where id=8002\G *** 1. row *** id: 8002 GeoQuality: 2a lon: -0.361080 lat: 9.99 GeocodeDate: 2005-08-31 GeocodeSource: ES052 state: NULL client_id: NULL 1 row in set (0.00 sec) Mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1
Hello Andrew, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. Is this a known problem? Does anyone have a solution? I'm running standard MySQL binaries on redhat linux 7.2 kernel 2.4.20-28.7smp. Help! Cheers, Andrew mysql desc table1; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| mediumint(6) | | PRI | NULL| auto_increment | | GeoQuality| varchar(5) | YES | | NULL|| | lon | double(7,6) | YES | MUL | NULL|| | lat | double(7,6) | YES | | NULL|| | GeocodeDate | date | YES | | NULL|| | GeocodeSource | varchar(25) | YES | | NULL|| | state | varchar(70) | YES | | NULL|| | client_id | varchar(40) | YES | MUL | NULL|| +---+--+--+-+-++ 15 rows in set (0.00 sec) mysql INSERT INTO table1VALUES (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL); Query OK, 1 row affected, 1 warning (0.01 sec) My guess is that the second value overflows the maximum value in the column and that MySQL is SILENTLY inserting the max value for the column. Have you tried a larger double column? Obviously: screw silent data changes!! mysql select * from table1 where id=8002\G *** 1. row *** id: 8002 GeoQuality: 2a lon: -0.361080 lat: 9.99 GeocodeDate: 2005-08-31 GeocodeSource: ES052 state: NULL client_id: NULL With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1
Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon | double(7,6) | YES | MUL | NULL|| | lat | double(7,6) | YES | | NULL|| From the manual: DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL] M is the total number of decimal digits and D is the number of digits following the decimal point. URL: http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html mysql INSERT INTO table1VALUES (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL); Query OK, 1 row affected, 1 warning (0.01 sec) mysql select * from table1 where id=8002\G *** 1. row *** id: 8002 GeoQuality: 2a lon: -0.361080 lat: 9.99 You have created your columns with a max width of 7, out of which 6 are decimals, but you are trying to insert a number with 8 digits. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: possible MySQL bug - insert into 'double' column problem with mysql 4.1
Thanks; you're absolutely right - doh! It's just amazing that this ever worked in MySQL 4.0 and below... Andrew -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Mon, 19 Sep 2005 12:27 To: mysql@lists.mysql.com Cc: Andrew Braithwaite Subject: Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1 Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon | double(7,6) | YES | MUL | NULL| | | lat | double(7,6) | YES | | NULL| | From the manual: DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL] M is the total number of decimal digits and D is the number of digits following the decimal point. URL: http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html mysql INSERT INTO table1VALUES (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL); Query OK, 1 row affected, 1 warning (0.01 sec) mysql select * from table1 where id=8002\G *** 1. row *** id: 8002 GeoQuality: 2a lon: -0.361080 lat: 9.99 You have created your columns with a max width of 7, out of which 6 are decimals, but you are trying to insert a number with 8 digits. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1
Hmm - and further to this. Strange differences of behaiour between the last two production versions of MySQL sh-2.05b# ln -s mysql-standard-4.0.24-apple-darwin7.7.0-powerpc mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.24-standard-log mysql create table wibble3 ( - test1 double(3,6), - test2 double(7,6), - test3 double(9,6)); Query OK, 0 rows affected (0.11 sec) mysql desc wibble3; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | test1 | double(7,6) | YES | | NULL| | | test2 | double(7,6) | YES | | NULL| | | test3 | double(9,6) | YES | | NULL| | +---+-+--+-+-+---+ 3 rows in set (0.17 sec) mysql insert into wibble3 values(50.123456,50.123456,50.123456); Query OK, 1 row affected (0.08 sec) mysql select * from wibble3; +---+---+---+ | test1 | test2 | test3 | +---+---+---+ | 50.123456 | 50.123456 | 50.123456 | +---+---+---+ 1 row in set (0.08 sec) sh-2.05b# ln -s mysql-standard-4.1.10a-apple-darwin7.7.0-powerpc mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.10a-standard-log mysql insert into wibble3 values(50.123456,50.123456,50.123456); Query OK, 1 row affected, 2 warnings (0.11 sec) mysql select * from wibble3; +---+---+---+ | test1 | test2 | test3 | +---+---+---+ | 50.123456 | 50.123456 | 50.123456 | | 9.99 | 9.99 | 50.123456 | +---+---+---+ 2 rows in set (0.06 sec) Looks like while MySQL 4.1 was not changing what was stored in the data but changing what is inserted into new records to match the proper data tye definitions. On 19/9/05 17:49, Andrew Braithwaite [EMAIL PROTECTED] wrote: Thanks; you're absolutely right - doh! It's just amazing that this ever worked in MySQL 4.0 and below... Andrew -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Mon, 19 Sep 2005 12:27 To: mysql@lists.mysql.com Cc: Andrew Braithwaite Subject: Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1 Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon | double(7,6) | YES | MUL | NULL| | | lat | double(7,6) | YES | | NULL| | From the manual: DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL] M is the total number of decimal digits and D is the number of digits following the decimal point. URL: http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html mysql INSERT INTO table1VALUES (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL); Query OK, 1 row affected, 1 warning (0.01 sec) mysql select * from table1 where id=8002\G *** 1. row *** id: 8002 GeoQuality: 2a lon: -0.361080 lat: 9.99 You have created your columns with a max width of 7, out of which 6 are decimals, but you are trying to insert a number with 8 digits. -- Roger -- 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: solution found for my.cnf problem in mysql 5.0.6
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I followed the steps in http://lists.mysql.com/internals/25364 and fixed my script, so, it would appear that the script is bad for the max version of mysql 5.0.6, for Solaris 8. - -- Love is mutual self-giving that ends in self-recovery. Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCpFlmikQgpVn8xrARAh9qAJ0ekN/cqiuFPRs2urLkU5e2ulbFlQCfQ5+r TJknK26B3tkDnFGa6hrlcXM= =oLsU -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling mysql 4.1.11 on AIX 5.1
Hi Jon, all! Jon Earle wrote: Joerg Bruehe said: Still, this seems to be a problem with the header files supplied / used by gcc. Are you sure you used the fixincludes script? Hi Joerg, I tried your suggestion as per: cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/ mv include inc cd install-tools export TARGET_MACHINE=AIX ./fixinc.sh /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include As I wrote: I have not been using gcc on AIX for quite some time, I just remember that it need(s/ed) this step. From fixinc.sh, I was getting errors [[...]] When I ran MySQL's configure, modified as per a number of posts regarding openssl directives to be: ./configure \ --prefix=/usr2/tools/mysql \ --with-big-tables \ --with-low-memory \ --with-vio \ --with-openssl \ --with-openssl-includes=/usr2/tools/openssl/include \ --with-openssl-libs=/usr2/tools/openssl/lib \ --without-extra-tools \ --without-docs \ --without-bench \ --enable-local-infile I then received many errors of the form: ... checking dlfcn.h usability... no checking dlfcn.h presence... yes configure: WARNING: dlfcn.h: present but cannot be compiled configure: WARNING: dlfcn.h: check for missing prerequisite headers? configure: WARNING: dlfcn.h: see the Autoconf documentation configure: WARNING: dlfcn.h: section Present But Cannot Be Compiled configure: WARNING: dlfcn.h: proceeding with the preprocessor's result configure: WARNING: dlfcn.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## checking for dlfcn.h... yes ... The config.log showed [[...]] So, it appears I've made things worse. :( Any ideas where to go from here? Sorry, I have none but: Check with the AIX newsgroup, comp.unix.aix. Some years ago, when AIX was at the center of my activities, I found that to be a very helpful and active community. The error messages you publish IMO seem to be general GCC issues and not specifically related to the MySQL sources. I hope you get your issues solved, Jörg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling mysql 4.1.11 on AIX 5.1
Joerg Bruehe said: Still, this seems to be a problem with the header files supplied / used by gcc. Are you sure you used the fixincludes script? Hi Joerg, I tried your suggestion as per: cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/ mv include inc cd install-tools export TARGET_MACHINE=AIX ./fixinc.sh /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include From fixinc.sh, I was getting errors saying that TARGET_MACHINE was not defined, so I took a stab in the dark and set it to AIX (couldn't find any docs to suggest anything else...) It seemed to run to completion after that. When I ran MySQL's configure, modified as per a number of posts regarding openssl directives to be: ./configure \ --prefix=/usr2/tools/mysql \ --with-big-tables \ --with-low-memory \ --with-vio \ --with-openssl \ --with-openssl-includes=/usr2/tools/openssl/include \ --with-openssl-libs=/usr2/tools/openssl/lib \ --without-extra-tools \ --without-docs \ --without-bench \ --enable-local-infile I then received many errors of the form: ... checking dlfcn.h usability... no checking dlfcn.h presence... yes configure: WARNING: dlfcn.h: present but cannot be compiled configure: WARNING: dlfcn.h: check for missing prerequisite headers? configure: WARNING: dlfcn.h: see the Autoconf documentation configure: WARNING: dlfcn.h: section Present But Cannot Be Compiled configure: WARNING: dlfcn.h: proceeding with the preprocessor's result configure: WARNING: dlfcn.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## checking for dlfcn.h... yes ... The config.log showed (for the above error, similar messages were emitted for other errors): ... configure:5338: checking dlfcn.h usability configure:5350: gcc -c -Wa,-many -maix64conftest.c 5 In file included from conftest.c:23: /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/stdio.h:268: error: parse error before __gnuc_va_list /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/stdio.h:269: error: parse error before __gnuc_va_list /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/stdio.h:270: error: parse error before __gnuc_va_list /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/stdio.h:272: error: parse error before __gnuc_va_list In file included from conftest.c:23: /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/stdio.h:474: error: parse error before __gnuc_va_list /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/stdio.h:475: error: parse error before __gnuc_va_list /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/stdio.h:476: error: parse error before __gnuc_va_list ... The last configure message was: ... checking for char... no checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! So, it appears I've made things worse. :( Any ideas where to go from here? Cheers! Jon -- Jon Earle Software Developer / Network Manager Specialising in Open Source Software Solutions http://kronos.honk.org/~earlej/ Rocket science is a lot more fun when you actually have rockets. -- US Navy Ad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling mysql 4.1.11 on AIX 5.1
Hi! Jon Earle wrote: Hi all! I'm having trouble building the latest stable on AIX 5.1. My env is as follows: Relevant GNU tools: [[...]] gcc-3.3.2-4.aix5.1.ppc.rpm [[...]] I admit I did not use gcc on AIX for quite some time. Results in the following error: ... checking term.h usability... no checking term.h presence... yes configure: WARNING: term.h: present but cannot be compiled configure: WARNING: term.h: check for missing prerequisite headers? configure: WARNING: term.h: see the Autoconf documentation configure: WARNING: term.h: section Present But Cannot Be Compiled configure: WARNING: term.h: proceeding with the preprocessor's result configure: WARNING: term.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## checking for term.h... yes Still, this seems to be a problem with the header files supplied / used by gcc. Are you sure you used the fixincludes script? ... config.log has this to say on that: ... configure:22525: checking term.h usability configure:22537: gcc -c -mcpu=powerpc -Wa,-manyconftest.c 5 In file included from conftest.c:90: /usr/include/term.h:1194: error: parse error before bool /usr/include/term.h:1225: error: parse error before SGTTY [[...]] IMO, this points into the same direction. Other than that, I have no idea. Double-check / repeat fixincludes. If all else fails, I propose you check (the archives of) the comp.unix.aix newgroup. [[...]] As of now, I believe my Qs are: 1. What is the correct usage of curses, term and termcap? Which do I need? And why don't the MySQL folks run into this problem - what's their AIX 5.1 environment like that gives them a smooth compilation? On AIX, we use IBM's compiler. 2. The docs say that using CXX=gcc (to use gcc as a c++ compiler) is preferable. Why does it seem to fail for me, forcing me to using the true g++ compiler? AFAIK, the main difference between gcc and g++ ist the list of libraries included by default when the compiler acts as a front-end to the linker. Your problems seem to occur in earlier stages. HTH, Jörg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem compiling mysql 4.1.11 on AIX 5.1
Hi all! I'm having trouble building the latest stable on AIX 5.1. My env is as follows: Relevant GNU tools: autoconf-2.58-1.aix5.1.noarch.rpm automake-1.7.9-1.aix5.1.noarch.rpm binutils-2.14-3.aix5.1.ppc.rpm bison-1.875-2.aix5.1.ppc.rpm flex-2.5.4a-6.aix4.3.ppc.rpm gcc-3.3.2-4.aix5.1.ppc.rpm libtool-1.5-2.aix5.1.ppc.rpm m4-1.4.1-1.aix5.1.ppc.rpm make-3.80-1.aix5.1.ppc.rpm patch-2.5.4-4.aix4.3.ppc.rpm zlib-1.2.1-2.aix5.1.ppc.rpm zlib-devel-1.2.1-2.aix5.1.ppc.rpm PATH: /opt/freeware/bin:/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr1/acct/jonathan/bin:/usr/bin/X11:/sbin:. Compiler Flags: CC=gcc CFLAGS=-mcpu=powerpc -Wa,-many CXX=gcc CXXFLAGS=-mcpu=powerpc -Wa,-many -felide-constructors -fno-exceptions -fno-rtti export CC CXX CFLAGS CXXFLAGS Configure directives: ./configure \ --prefix=/usr2/tools/mysql \ --enable-assembler \ --with-big-tables \ --with-low-memory \ --with-openssl=/usr2/tools/openssl \ --without-extra-tools \ --without-docs \ --without-bench \ --enable-local-infile Results in the following error: ... checking term.h usability... no checking term.h presence... yes configure: WARNING: term.h: present but cannot be compiled configure: WARNING: term.h: check for missing prerequisite headers? configure: WARNING: term.h: see the Autoconf documentation configure: WARNING: term.h: section Present But Cannot Be Compiled configure: WARNING: term.h: proceeding with the preprocessor's result configure: WARNING: term.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## checking for term.h... yes ... config.log has this to say on that: ... configure:22525: checking term.h usability configure:22537: gcc -c -mcpu=powerpc -Wa,-manyconftest.c 5 In file included from conftest.c:90: /usr/include/term.h:1194: error: parse error before bool /usr/include/term.h:1225: error: parse error before SGTTY /usr/include/term.h:1242: error: parse error before sgr_mode /usr/include/term.h:1243: error: parse error before sgr_faked /usr/include/term.h:1254: error: parse error before funckeystarter /usr/include/term.h:1255: error: parse error before _fl_rawmode /usr/include/term.h:1265: error: parse error before '*' token /usr/include/term.h:1267: error: parse error before bit_vector /usr/include/term.h:1271: error: parse error before check_turn_off /usr/include/term.h:1272: error: parse error before _cur_pair /usr/include/term.h:1273: error: parse error before '*' token /usr/include/term.h:1276: error: parse error before '}' token ... If I search for ''bool'' in the include files referenced in the configure test, I only get: sys/types.h:typedef int boolean_t; Type bool does appear to be defined in curses.h, which is not used in the term.h test. Compiling stops with: ... if gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I. -I../.. -I../../include -I./../.. -I..-O3 -DDBUG_OFF -mcpu=powerpc -Wa,-many -MT term.o -MD -MP -MF .deps/term.Tpo -c -o term.o term.c; \ then mv -f .deps/term.Tpo .deps/term.Po; else rm -f .deps/term.Tpo; exit 1; fi In file included from /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/include/curses.h:136, from term.c:62: /usr/include/term.h:1351: error: conflicting types for `tgetstr' /usr/local/include/termcap.h:27: error: previous declaration of `tgetstr' /usr/include/term.h:1355: error: conflicting types for `tgetflag' /usr/local/include/termcap.h:26: error: previous declaration of `tgetflag' /usr/include/term.h:1355: error: conflicting types for `tgetnum' /usr/local/include/termcap.h:25: error: previous declaration of `tgetnum' /usr/include/term.h:1357: error: conflicting types for `tputs' /usr/local/include/termcap.h:31: error: previous declaration of `tputs' term.c: In function `term_set': term.c:941: warning: passing arg 1 of `tgetstr' discards qualifiers from pointer target type term.c: In function `term_echotc': term.c:1445: warning: passing arg 1 of `tgetstr' discards qualifiers from pointer target type make[3]: *** [term.o] Error 1 make[3]: Leaving directory `/usr1/acct/jonathan/ostk/build/mysql-4.1.11/cmd-line-utils/libedit' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr1/acct/jonathan/ostk/build/mysql-4.1.11/cmd-line-utils' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr1/acct/jonathan/ostk/build/mysql-4.1.11' make: *** [all] Error 2 In config.h, HAVE_CURSES_H, HAVE_TERMCAP_H and HAVE_TERM_H are all defined and set to 1. I tried removing HAVE_TERM_H, but curses.h just includes it anyway. If I #undef HAVE_TERMCAP_H and rerun make, then it stops at: ... gcc: installation problem, cannot exec `cc1plus': No such file or directory make[2]: *** [my_new.o] Error 1 make[2]: Leaving directory `/usr1/acct/jonathan/ostk/build/mysql-4.1.11/mysys'
Problem With Mysql Ms Access with Time
Hi: I have this data: ventas_encabezado_historico_sat Query VEH_EMPRESA VEH_TIENDA VEH_FECHA VEH_STATUS VEH_TOTAL VEH_HORA DLC T01 6/1/2003 V 30 8:31:05 AM DLC T01 6/1/2003 V 114.28 8:38:44 AM DLC T01 6/1/2003 V 63.2 8:41:13 AM DLC T01 6/1/2003 V 8.75 8:42:47 AM dlc T01 6/1/2003 V 12.35 8:50:59 AM dlc T01 6/1/2003 V 63.97 8:53:10 AM DLC T01 6/1/2003 V 10 8:54:24 AM DLC T01 6/1/2003 V 50.65 8:57:54 AM DLC T01 6/1/2003 V 36 9:01:04 AM Where veh_fecha is type date, veh_hora is type date and veh_total is double And I have this code where I try to get the # of registres and a sum in a specific date for a specific time interval (15 minutes) but the select do not work, it returns 0 o the result of the full day, what Im doing wrong? HORA_INICIO = TimeSerial(7, 0, 0) '7:00 am Do Cantidad_Ventas = 0 VALOR_VENTAS = 0 'voy a calcular los valores de atención strSQL = select Count(*) as Cantidad, Sum(veh_total) as Valor from _ ventas_encabezado_historico_sat where _ veh_empresa=' EMP ' and _ veh_tienda=' Tienda ' and _ veh_fecha= MakeUSDate(MAX_ESTADISTICA) and _ Veh_hora= MakeUSTime(HORA_INICIO) And _ veh_hora MakeUSTime(HORA_INICIO + TimeSerial(0, 15, 0)) Set RST = DB.OpenRecordset(strSQL) 'ya tengo calculado los valores, los tengo que guardar Cantidad_Ventas = RST!Cantidad If IsNull(RST!valor) = True Then VALOR_VENTAS = 0 Else VALOR_VENTAS = RST!valor End If RST.Close Set RST = DB.OpenRecordset(Select * from estad_atencion where 1=0) RST.AddNew RST!est_empresa = EMP RST!est_tienda = Tienda RST!est_fecha = MAX_ESTADISTICA RST!est_hora = HORA_INICIO RST!est_atencion = Cantidad_Ventas RST!est_valor = VALOR_VENTAS RST.Update RST.Close HORA_INICIO = HORA_INICIO + TimeSerial(0, 15, 0) Loop Until HORA_INICIO TimeSerial(22, 0, 0) Function MakeUSDate(X As Variant) As String If Not IsDate(X) Then Exit Function MakeUSDate = # Month(X) / Day(X) / Year(X) # End Function Function MakeUSTime(X As Variant) As String If Not IsDate(X) Then Exit Function MakeUSTime = # Hour(X) : Minute(X) : Second(X) # End Function -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.10 - Release Date: 4/14/2005
re: problem with mysql-max-5.0.3 for Solaris 8 32 bit
It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file from http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-max-5.0.3-beta-sun-solaris2 .8-sparc.pkg.gz/from/http://mysql.mirrors.pair.com/ James, Sorry about this. Somehow the 64bit tarball was used for this package. I've fixed it now and uploaded a new 32bit Solaris 2.8 PKG. Note that it will take a bit to propagate out to the mirrors (probably 8-10 hrs). Thanks for notifying us about this. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: problem with mysql-max-5.0.3 for Solaris 8 32 bit
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file from http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-max-5.0.3-beta-sun-solaris2.8-sparc.pkg.gz/from/http://mysql.mirrors.pair.com/ - -- Love is mutual self-giving that ends in self-recovery. Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCSGQkikQgpVn8xrARAqr1AJsFslyPkjRck+5uNTPbU3gxoLx9fwCeJEEn fdly9uy3J0L38pkizClQNzY= =hmti -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A complex normalisation problem in MySQL 4.0.20 (innodb engine)
Dear friends we have a problem here. We have 3 tables - table language (id int not null auto_increment primarykey, languageName tinytext) - table country (id int not null auto_increment primarykey, defaultName tinytext, defaultLanguage tinytext) - table countryToLanguage ((languageID int, countryID int) primary key, countryNameInLanguage tinytext) in the table countryToLanguage, the column languageID is a foreign key referencing language (id) in the table countryToLanguage, the column countryID is a foreign key referencing country(id) in the table country, the column defaultLanguage is a foreign key referencing language(id) In order for the database to be perfectly normalised, we think it the column defaultName in the table country should be a foreign key referencing back countryToLanguage ((languageID int, countryID int)). What do you think? If you do that then there are lot of problems in updating the tables. -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A complex normalisation problem in MySQL 4.0.20 (innodb engine)
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 08:08:53 AM: Dear friends we have a problem here. We have 3 tables - table language (id int not null auto_increment primarykey, languageName tinytext) - table country (id int not null auto_increment primarykey, defaultName tinytext, defaultLanguage tinytext) - table countryToLanguage ((languageID int, countryID int) primary key, countryNameInLanguage tinytext) in the table countryToLanguage, the column languageID is a foreign key referencing language (id) in the table countryToLanguage, the column countryID is a foreign key referencing country(id) in the table country, the column defaultLanguage is a foreign key referencing language(id) In order for the database to be perfectly normalised, we think it the column defaultName in the table country should be a foreign key referencing back countryToLanguage ((languageID int, countryID int)). What do you think? If you do that then there are lot of problems in updating the tables. -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com I don't think so. You already have the country's name in it's own language on the countryToLanguage table, don't you? What name in which language is the defaultName column supposed to represent? If you can define what the *contents* of that field is supposed to be, then you should be able to decide on which table it should reside. Normalization has a lot to do about reducing duplication. It appears that you have two fields that represent the name of a country. How many names does each country get to have in your database? What is the best way of storing the name(s) of a country that meets YOUR business needs? Answer those questions and you will solve your problem. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: A complex normalisation problem in MySQL 4.0.20 (innodb engine)
I don't think so. You already have the country's name in it's own language on the countryToLanguage table, don't you? What name in which language is the defaultName column supposed to represent? If you can define what the *contents* of that field is supposed to be, then you should be able to decide on which table it should reside. Normalization has a lot to do about reducing duplication. It appears that you have two fields that represent the name of a country. How many names does each country get to have in your database? What is the best way of storing the name(s) of a country that meets YOUR business needs? You pointed our the problem. The country has different names in different languages. One of the names is the default name. So you could introduce a flag default yes/no in table countryToLanguage. Is that normalised? The answer should be yes, but you have to introduce an additional column, which increases the space hold by the table. Then if you normalise, you introduce un useful information (i.e. the information that a language is not the default language, which means filling the column with 0 when it is not the default). What do you think? Answer those questions and you will solve your problem. Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A complex normalisation problem in MySQL 4.0.20 (innodb engine)
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 10:25:27 AM: I don't think so. You already have the country's name in it's own language on the countryToLanguage table, don't you? What name in which language is the defaultName column supposed to represent? If you can define what the *contents* of that field is supposed to be, then you should be able to decide on which table it should reside. Normalization has a lot to do about reducing duplication. It appears that you have two fields that represent the name of a country. How many names does each country get to have in your database? What is the best way of storing the name(s) of a country that meets YOUR business needs? You pointed our the problem. The country has different names in different languages. One of the names is the default name. So you could introduce a flag default yes/no in table countryToLanguage. Is that normalised? The answer should be yes, but you have to introduce an additional column, which increases the space hold by the table. Then if you normalise, you introduce un useful information (i.e. the information that a language is not the default language, which means filling the column with 0 when it is not the default). What do you think? Answer those questions and you will solve your problem. Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com I think you are on the right track. There can be several languages within a country and several countries for each language. That's why you chose the table model you have. For each language-country association, it makes sense to qualify that association with additional information. Depending on my business needs I would probably go FARTHER than just marking an association as default or not and adding the native representation of the country's name. Some countries have multiple official languages (for instance, Canada has declared both French and English as their official languages. I think Switzerland has 3 or 4 official languages but I am not completely sure). In other countries the Official language may not be the one used most commonly (I think that Spanish is the Official language of the Philippines but Tagalog is a very common (if not the most common) dialect. The official Cantonese of China may not be the most commonly used language within that country). I guess how detailed you get with the data depends on how detailed the international information needs to be. I would ask the people who are going to use this database what they need it for and how much detail your data needs to support. That way you get a sense of the granularity you need to provide. This is one of those cases where relational databases are flexible enough to provide far more information than a situation may require. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Authorizing Problem in MySQL 4 with Mandrake 10
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hash: SHA1 Hi All, I installed a fresh copy of Mandrake Linux 10.0 with MySQL. I tried to login to MySQL server ,But it says that authorization is failed. My hostname is localhost and user is root.I entered the root password. Here is the log :- [EMAIL PROTECTED] html]# mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Please help me to solve this problem. Best Regards, Prabath. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCHRXVIlUQPx/AjvYRAo2fAKCJ+DWXNgSbfW3RySeJGADUSytjWACgxHYt SHHwE2P22LankU/ovx/s28M= =k/T0 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Authorizing Problem in MySQL 4 with Mandrake 10
Prabath Ranasinghe (by way of Prabath Ranasinghe [EMAIL PROTECTED]) ha scritto: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hash: SHA1 Hi All, I installed a fresh copy of Mandrake Linux 10.0 with MySQL. I tried to login to MySQL server ,But it says that authorization is failed. My hostname is localhost and user is root.I entered the root password. Here is the log :- [EMAIL PROTECTED] html]# mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Please help me to solve this problem. Best Regards, Prabath. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCHRXVIlUQPx/AjvYRAo2fAKCJ+DWXNgSbfW3RySeJGADUSytjWACgxHYt SHHwE2P22LankU/ovx/s28M= =k/T0 -END PGP SIGNATURE- If you still have NO password trying to use it will give you an error ;) try # mysql -h localhost -u root regards Francesco Riosa -- No problem is so formidable that you can't walk away from it. ~ Charles M. Schulz But sometimes run fast is better ~ Francesco R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Authorizing Problem in MySQL 4 with Mandrake 10
Be careful maybe you are mistaking here: the mysql root user as nothing to see with the mandrake root user. For exemple I lauch the mysql server as root from command line whereas I'm just a user on my desktop. So the mandrake root password and the mysql root password are also completly different. maybe this can be helpful: http://dev.mysql.com/doc/mysql/en/unix-post-installation.html From: Prabath Ranasinghe [EMAIL PROTECTED] (by way of Prabath Ranasinghe [EMAIL PROTECTED]) Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Authorizing Problem in MySQL 4 with Mandrake 10 Date: Wed, 23 Feb 2005 18:46:29 -0500 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hash: SHA1 Hi All, I installed a fresh copy of Mandrake Linux 10.0 with MySQL. I tried to login to MySQL server ,But it says that authorization is failed. My hostname is localhost and user is root.I entered the root password. Here is the log :- [EMAIL PROTECTED] html]# mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Please help me to solve this problem. Best Regards, Prabath. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCHRXVIlUQPx/AjvYRAo2fAKCJ+DWXNgSbfW3RySeJGADUSytjWACgxHYt SHHwE2P22LankU/ovx/s28M= =k/T0 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
offtopic: Problem initialize MySQL DataSource for WebSphere App. Server 6
Hello, I have problem to configure MySQL datasource for WebSphere Application Server 6 (WAS6) from admin console. 1.) I have configured new JDBC Provider for MySQL (4.0.20a) as following: Name: MySQL JDBC Provider Class path: ${UNIVERSAL_JDBC_DRIVER_PATH}/mysql.jar Implementation class name: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource 2.) Then I created new 'Data sources (Version 4)' as following: Name: DS4mysql JNDI name: jndi/DS4mysql Database name: myDB Default user ID: myUser Default password: myPasswd After saving all changes I have try to test connection to the database by clicking on button 'Test connection'. Connection test passed successfull. But when I have run WAR packaged application using this configured datasource version 4, there was following error occured: com.ibm.websphere.naming.CannotInstantiateObjectException: Exception occurred while the JNDI NamingManager was processing a javax.naming.Reference object. Root exception is javax.naming.NamingException: Attempted to use a 4.0 DataSource from a 2.3 (or higher) servlet. Invalid configuration. Maybe it means I cannot use DataSource version 4, but I have to configure just DataSource properties on the 'MySQL JDBC Provider' page under 'Additional properties' part. But I don't konow how can I configure this, because there are missing properties for defining db name, username, password, ... If anybody know, how to configure datasource (NOT Version 4) in WAS6 for MySQL database, please let mi know. Thank you in advance, with best regards, Julian Legeny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Data loss problem with mysql
Andy, Thanks a lot for the response. We are using Linux OS. Is there any configuration parameter that enables more frequent flush or a parameter that enables direct write to disk and any idea about performance implications. Thanks once again, Ravi -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 1:28 PM To: Ravi T Ramachandra (WT01 - EMBEDDED PRODUCT ENGINEERING SOLUTIONS) Cc: [EMAIL PROTECTED] Subject: Re: Data loss problem with mysql On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote: Dear all, We are running mysql 4.0.17 on linux environment. Our database resides on external disk connected via FC cables. We recently noticed a loss of data in the following scenario. Inserted a row in a table in a separate transaction by a java application, queried a row in the table in a separate transaction by a java application and was successful. Then the FC cable connecting to external db disks was pulled and after sometime put it back Now the inserted row is missing in the database. From our logs, we have a query log that shows the inserted statement prior to FC cable disconnection. After cable pull, we have taken database dump that reveals the missing row that was inserted prior to FC cable disconnection. If somebody would have accidentally deleted, then we can expect the delete statement in the query log. But there is no delete statement in the query log. Can anybody help. What operating system(s) are you using for the system you are making the query from and also for the external database server? mysqld makes as much use of database server system memory as possible and a lot the live database will be cached in memory. If you insert a row and then read it back, it will be in the table but the table is in memory and hasn't necessarily been written to physical disk. Also, UNIX and Unix-like systems normally work with disk buffers so that when a file is written to, it is the disk buffer that is written to, not the physical disk itself. The disk buffers are then flushed out to disk every 30 seconds. It could be that the FC cable was unplugged during the buffer flush, causing the operating system to abort the flush and not update the file on the physical disk. Andy Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Data loss problem with mysql
Dear all, We are running mysql 4.0.17 on linux environment. Our database resides on external disk connected via FC cables. We recently noticed a loss of data in the following scenario. Inserted a row in a table in a separate transaction by a java application, queried a row in the table in a separate transaction by a java application and was successful. Then the FC cable connecting to external db disks was pulled and after sometime put it back Now the inserted row is missing in the database. From our logs, we have a query log that shows the inserted statement prior to FC cable disconnection. After cable pull, we have taken database dump that reveals the missing row that was inserted prior to FC cable disconnection. If somebody would have accidentally deleted, then we can expect the delete statement in the query log. But there is no delete statement in the query log. Can anybody help. With Regards, Ravi Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments.
Re: Data loss problem with mysql
On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote: Dear all, We are running mysql 4.0.17 on linux environment. Our database resides on external disk connected via FC cables. We recently noticed a loss of data in the following scenario. Inserted a row in a table in a separate transaction by a java application, queried a row in the table in a separate transaction by a java application and was successful. Then the FC cable connecting to external db disks was pulled and after sometime put it back Now the inserted row is missing in the database. From our logs, we have a query log that shows the inserted statement prior to FC cable disconnection. After cable pull, we have taken database dump that reveals the missing row that was inserted prior to FC cable disconnection. If somebody would have accidentally deleted, then we can expect the delete statement in the query log. But there is no delete statement in the query log. Can anybody help. What operating system(s) are you using for the system you are making the query from and also for the external database server? mysqld makes as much use of database server system memory as possible and a lot the live database will be cached in memory. If you insert a row and then read it back, it will be in the table but the table is in memory and hasn't necessarily been written to physical disk. Also, UNIX and Unix-like systems normally work with disk buffers so that when a file is written to, it is the disk buffer that is written to, not the physical disk itself. The disk buffers are then flushed out to disk every 30 seconds. It could be that the FC cable was unplugged during the buffer flush, causing the operating system to abort the flush and not update the file on the physical disk. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem installing Mysql 4.1 on Fedora 2
Hi: When i tried to install Mysql using the rpm on a Fedora 2 .. i received this error: shellrpm -i MySQL-server-4.1.7-0.i386.rpm warning: MySQL-server-4.1.7-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5error: Failed dependencies: MySQL conflicts with mysql-3.23.58-9 MySQL-server conflicts with mysql-server-3.23.58-9 Any suggestions? Thanks, Oscar Fernando Telesat, más fácil...más Internet. http://www.telesat.com.co/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing Mysql 4.1 on Fedora 2
I had the same problem. It just won't seem to upgrade. You need to uninstall mysql-3.23.58-9 and mysql-server-3.23.58-9 first. Enter something like this: rpm -ev mysql-3.23.58-9 mysql-server-3.23.58-9 When it's done, then install version 4.x On Tue, 2004-11-16 at 15:43, [EMAIL PROTECTED] wrote: Hi: When i tried to install Mysql using the rpm on a Fedora 2 .. i received this error: shellrpm -i MySQL-server-4.1.7-0.i386.rpm warning: MySQL-server-4.1.7-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5error: Failed dependencies: MySQL conflicts with mysql-3.23.58-9 MySQL-server conflicts with mysql-server-3.23.58-9 Any suggestions? Thanks, Oscar Fernando Telesat, más fácil...más Internet. http://www.telesat.com.co/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem runnig mysql with a particular collation
hello everyone, i have problem running mysqld with particular charset and collation, i test two cases: I use mysql-4.1.3-beta , and Fedora Core 2 for my tests 1) ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_turkish_ci make;make install ; in this case mysql_install_db doesn't create tables and grants fopr them.I couldn't solve the problem, this happens just in the case i configure mysql with commands --with-charset=utf8 --with-collation=utf8_turkish_ci 2) ./configure --prefix=/usr/local/mysql make;make install;mysql_install_db --user=mysql ; ... mysqld --default-character-set=utf8 --default-collation=utf8_turkish_ci but it doesn't change the mysql charset because in mysql command i run: mysql\s server-charset=latin1_swedish_ci client-charset=latin1_swedish_ci (no change in default charset and collation) appreciation for any help; regards - Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!
Re: I have a problem with MySQL.
If you give more details maybe someone on the list will be able to help. Astghik Barseghian wrote: Hello Philippe, I am trying to use DBMail from MySQL to send and receive messages but I get an SQL sytax error. Could you please tell me is there any way to use the mentioned component, or how can I execute the dll function from MySQL. Thank you. -- http://www.freenet.am/ -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem running MySQL in high school lab
I second Todd's suggestion. There is no need to run Cygwin in order to have the MySQL servers or clients or any of its tools operating under Win32 (95, 98, 2000, ME, 2003, XP, etc). I only ever use Cygwin when I need to run a remote Linux desktop and as a teaching tool. Everything else I do with MySQL is platform specific. If I am on a *nix platform, I use *nix tools. If I am on Win32, I use Win32 tools. The differences are minimal and the stability is well worth it. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Donny Simonton [EMAIL PROTECTED] wrote on 08/30/2004 09:37:26 PM: Todd, I don't use Windows XP as a production machine, but I do run MySQL on my personal machine running Windows XP, I run the Windows version of MySQL. Is there any reason that you are using Cygwin to run MySQL when you can run the MySQL windows binaries without any problems? The only thing I can think of is you are trying to teach them linux as well. I know in the MySQL training classes offered by MySQL they are always taught using Windows 2000 or XP, and they use the standard MySQL windows installer. Donny -Original Message- From: Todd O'Bryan [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 8:09 PM To: [EMAIL PROTECTED] Subject: Problem running MySQL in high school lab I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't start the server, but I fixed that, and now mysqld works fine. Unfortunately, if you then mysql -u root, after a rather short period of time, the program crashes and pops an error message to the screen. The message, which I should have written down but didn't, says that an assertion has failed in ftell.c (not sure about the filename, but the gist is right) and stream != NULL (that I'm sure of) and then the program dies. I don't have similar problems when I'm logged in as me (which has Administrator privileges) or the machine Administrator. It must be a permissions problem, but I don't know what I need to give the students to prevent it. The MySQL stuff on the local machines need not be secure, so I've given full access to all users in the entire /cygwin/usr/local/ directory and its subdirectories, which is where I installed MySQL and all the other packages we're going to be playing with. There are some kids in there who don't need the temptation of being logged in as an Administrator, and since we're going to be using JDBC later for which the MySQL server will need to be running almost constantly in the background, I'd like to get this resolved with the least amount of temptation. The lab is all Windows XP Professional machines, and the students log into a domain hosted by a server in another teacher's lab. Any ideas appreciated, Todd P.S. If you could cc me any replies, I'd appreciate it, since I read the list on digest. -- 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]
Problem running MySQL in high school lab
I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't start the server, but I fixed that, and now mysqld works fine. Unfortunately, if you then mysql -u root, after a rather short period of time, the program crashes and pops an error message to the screen. The message, which I should have written down but didn't, says that an assertion has failed in ftell.c (not sure about the filename, but the gist is right) and stream != NULL (that I'm sure of) and then the program dies. I don't have similar problems when I'm logged in as me (which has Administrator privileges) or the machine Administrator. It must be a permissions problem, but I don't know what I need to give the students to prevent it. The MySQL stuff on the local machines need not be secure, so I've given full access to all users in the entire /cygwin/usr/local/ directory and its subdirectories, which is where I installed MySQL and all the other packages we're going to be playing with. There are some kids in there who don't need the temptation of being logged in as an Administrator, and since we're going to be using JDBC later for which the MySQL server will need to be running almost constantly in the background, I'd like to get this resolved with the least amount of temptation. The lab is all Windows XP Professional machines, and the students log into a domain hosted by a server in another teacher's lab. Any ideas appreciated, Todd P.S. If you could cc me any replies, I'd appreciate it, since I read the list on digest. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem running MySQL in high school lab
Todd, I don't use Windows XP as a production machine, but I do run MySQL on my personal machine running Windows XP, I run the Windows version of MySQL. Is there any reason that you are using Cygwin to run MySQL when you can run the MySQL windows binaries without any problems? The only thing I can think of is you are trying to teach them linux as well. I know in the MySQL training classes offered by MySQL they are always taught using Windows 2000 or XP, and they use the standard MySQL windows installer. Donny -Original Message- From: Todd O'Bryan [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 8:09 PM To: [EMAIL PROTECTED] Subject: Problem running MySQL in high school lab I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't start the server, but I fixed that, and now mysqld works fine. Unfortunately, if you then mysql -u root, after a rather short period of time, the program crashes and pops an error message to the screen. The message, which I should have written down but didn't, says that an assertion has failed in ftell.c (not sure about the filename, but the gist is right) and stream != NULL (that I'm sure of) and then the program dies. I don't have similar problems when I'm logged in as me (which has Administrator privileges) or the machine Administrator. It must be a permissions problem, but I don't know what I need to give the students to prevent it. The MySQL stuff on the local machines need not be secure, so I've given full access to all users in the entire /cygwin/usr/local/ directory and its subdirectories, which is where I installed MySQL and all the other packages we're going to be playing with. There are some kids in there who don't need the temptation of being logged in as an Administrator, and since we're going to be using JDBC later for which the MySQL server will need to be running almost constantly in the background, I'd like to get this resolved with the least amount of temptation. The lab is all Windows XP Professional machines, and the students log into a domain hosted by a server in another teacher's lab. Any ideas appreciated, Todd P.S. If you could cc me any replies, I'd appreciate it, since I read the list on digest. -- 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: Dependency problem with MySQL rpm's (Fedora Core 1)
Frank Perez [EMAIL PROTECTED] wrote: I am trying to install MySQL 5.0.0 on a fresh install of Fedora Core 1, however I am running into a little trouble and I was hoping someone could give me a little insight on what I might be doing wrong. I am able to install the 'server', 'clients', and 'devel' packages with no problems, but if I try to install either the 'shared' or the 'Max' packages I get the following dependency errors: error: Failed dependencies: libcrypto.so.0.9.6 is needed by MySQL-shared-5.0.0-0 libssl.so.0.9.6 is needed by MySQL-shared-5.0.0-0 Download 5.0.1a. 5.0.0 is linked with SSL while 5.0.1a is not (which is right). -- 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]
Dependency problem with MySQL rpm's (Fedora Core 1)
Hello everyone, I am trying to install MySQL 5.0.0 on a fresh install of Fedora Core 1, however I am running into a little trouble and I was hoping someone could give me a little insight on what I might be doing wrong. I am able to install the 'server', 'clients', and 'devel' packages with no problems, but if I try to install either the 'shared' or the 'Max' packages I get the following dependency errors: error: Failed dependencies: libcrypto.so.0.9.6 is needed by MySQL-shared-5.0.0-0 libssl.so.0.9.6 is needed by MySQL-shared-5.0.0-0 I am a little confused because I do have the openssl-0.9.7a-23 and openssl-devel-0.9.7a-23 and when I do a locate for the two library files it is looking for I find this: [EMAIL PROTECTED] rpms]# locate libcrypto.so. /lib/libcrypto.so.0.9.7a /lib/libcrypto.so.4 [EMAIL PROTECTED] rpms]# locate libssl.so. /lib/libssl.so.4 /lib/libssl.so.0.9.7a Does do the shared packages not work with a newer version of the library? Should I upgrade the SSL packages to newer ones? I would really like to learn how to use stored proceedures and UDF's so if someone could help me get passed this hump I would really appreciate it. Frank Perez __ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
Hi All I am very confused about MySQL 4.1.3. I have problems with the character set and the collation. Under 4.0.20 I had never such problems. I downloaded the beta-files from version 4.1.3b and zipped it to c:\mysql. Then I loaded my data within a script with load data infile into my tables... The point is, that all tables have now the collation 'latin1_swedish_ci'?!!? Is this the default collation? Why does this collation appear? Interesting is, that the meta-data (all tables in the mysql-db) does have the 'latin1_swedish_ci' - collation too. The problem is now with phpmyadmin, if I make a select like SUBSTRING_INDEX( domain, '.', -2 ) from url_cat, the following error-message appears: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE). I found out, that if I use the following statement select SUBSTRING_INDEX( domain, _latin1'.', -2 ) from url_cat it works But the Problem is, i won't change all my old scripts from 4.0!!! I found out, that if I use mysql in DOS, everything works without error!!! Do I have to change something in phpmyadmin (i have version 2.6.0rc1)? I am very confused about it and i don't know how and which character-set and collation I have to choose. I live in Switzerland... Which character-set and collation I have to choose? Is there a 'standard' character-set/collation I should use? Do I have to set parameters in the my.cnf - file? My system runs under Windows XP with SP2. Thank you in advance for your help. Yours Martin Rytz DBA from Switzerland
RE: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
This is not a mysql problem, it is a phpmyadmin problem. You must be using 2.6.0 rc1, download 2.6.0 beta 2 and you won't have the problem any more. I have complained to them about it, but not exactly sure what they are going to do. Donny -Original Message- From: Martin Rytz [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 9:35 AM To: [EMAIL PROTECTED] Subject: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) Hi All I am very confused about MySQL 4.1.3. I have problems with the character set and the collation. Under 4.0.20 I had never such problems. I downloaded the beta-files from version 4.1.3b and zipped it to c:\mysql. Then I loaded my data within a script with load data infile into my tables... The point is, that all tables have now the collation 'latin1_swedish_ci'?!!? Is this the default collation? Why does this collation appear? Interesting is, that the meta-data (all tables in the mysql-db) does have the 'latin1_swedish_ci' - collation too. The problem is now with phpmyadmin, if I make a select like SUBSTRING_INDEX( domain, '.', -2 ) from url_cat, the following error-message appears: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE). I found out, that if I use the following statement select SUBSTRING_INDEX( domain, _latin1'.', -2 ) from url_cat it works But the Problem is, i won't change all my old scripts from 4.0!!! I found out, that if I use mysql in DOS, everything works without error!!! Do I have to change something in phpmyadmin (i have version 2.6.0rc1)? I am very confused about it and i don't know how and which character-set and collation I have to choose. I live in Switzerland... Which character-set and collation I have to choose? Is there a 'standard' character-set/collation I should use? Do I have to set parameters in the my.cnf - file? My system runs under Windows XP with SP2. Thank you in advance for your help. Yours Martin Rytz DBA from Switzerland -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Permissions problem with MySQL 4.1.3 | Update: Same with 5.0.1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I also tried the 5.0.1 MAX binaries looking for a solution to my previously posted problem of permissions (see at the bottom of the message for the previous post). According to the hostname.err file: 040810 13:31:44 mysqld started 040810 13:31:44 bdb: /usr/local/mysql5/data: Permission denied 040810 13:31:44 bdb: /usr/local/mysql5/data/log.01: Permission denied 040810 13:31:44 bdb: PANIC: Permission denied 040810 13:31:44 bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 040810 13:31:44 bdb: fatal region error detected; run recovery 040810 13:31:44 bdb: /usr/local/mysql5/data: Permission denied 040810 13:31:44 InnoDB: Started; log sequence number 0 43634 040810 13:31:44 Can't init databases 040810 13:31:44 Aborting 040810 13:31:44 InnoDB: Starting shutdown... 040810 13:31:46 InnoDB: Shutdown completed; log sequence number 0 43634 040810 13:31:46 /usr/local/mysql5/bin/mysqld: Shutdown complete 040810 13:31:46 mysqld ended A complete archived plaintext strace logfile can be found here: http://www.lwo-lab.net/log.mysql-list.01.gz It was generated using: # strace -v -s 512 -o log -f -v -t ./mysqld --user=mysql Before suggesting any chmod/chown, please take a look at this: tearspath www # ls -l -h /usr/local/mysql5/data/ total 19M -rw-rw 1 mysql mysql 4.0M Aug 10 14:25 ib_logfile0 -rw-rw 1 mysql mysql 4.0M Aug 9 14:36 ib_logfile1 -rw-rw 1 mysql mysql 10M Aug 10 14:25 ibdata1 drwxr-x--- 2 mysql mysql 4.0K Aug 9 14:27 mysql -rw-rw 1 mysql root 6.1K Aug 10 13:31 tearspath.err drwxr-x--- 2 mysql mysql 4.0K Jul 27 20:53 test I'd like to add that mysqld is properly running as mysql:mysql according to the strace log: 12299 14:25:07 setgid32(506)= 0 12299 14:25:07 setuid32(1006) = 0 (506 and 1006 are the respective GID and UID for mysql and mysql) Any help will be really appreciated, I'm on this for a month now. Thanks in advance. Elie `woe` BLETON Elie `woe` BLETON wrote: | Hello, | | I'd like to ask for some help on a problem which have prevented my mysql | server to run since I updated it from 4.0 to 4.1 | Anyway, even if in the idea it's an update, in the facts it's a fresh | install, from sources. | Sources were configure'd with ./configure --prefix=/usr/local/mysql. | | After doing everything I could find on google, manual, mailing lists and | stuff, I still have basicly the same problems : | | (a) Running mysql_install_db --user=mysql /dev/null prints a lot of | errors, most of them are Errcode: 13 (Permission denied), and resulting | Table 'xxx.yyy' doesn't exist messages. See Annex A for detailed output. | | (b) Running libexec/mysqld --console --user=mysql prints : | InnoDB: Operating system error number 13 in a file operation. | InnoDB: The error means mysqld does not have the access rights to | InnoDB: the directory. | InnoDB: File name /usr/local/mysql/var/ibdata1 | InnoDB: File operation call: 'create'. | InnoDB: Cannot continue operation. | | Running both of these programs as root works fine, but I don't really | want mysql to run as root, even if it's just for testing purposes. | | There are some points which seems really strange to me. First point is | that mysql_install_db is able to create mysql and test directories | in var without problem. | Nothing changes if I chown -R mysql:mysql /usr/local/mysql/var | Nothing changes if I chown -R mysql:mysql /usr/local/mysql | Nothing changes if I chmod -R 777 /usr/local/mysql | Nothing changes if these these elements are made altogether. | | The other strange point is that if the var directory isn't owned by | mysql user, InnoDB complaints about not beeing able to create | innodb.status. in var. Once var is owned by mysql, it can create the | file without problem. | I can't understand why it cannot create ibdata1 if it can create the | other one. | | I've also tried to install_db as root, then run mysqld as root for one | time in order to get inno files created properly. Switching back to | mysqld --user=mysql isn't possible anyway. | | I'm open to any suggestion or help, and available to provide any further | information as needed. Thanks in advance for your time. | | Elie `woe` BLETON | | APPENDIX A | Output of /usr/local/mysql/bin/mysql_install_db --user=mysql | | ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' | (Errcode: 13) | ERROR: 1146 Table 'mysql.db' doesn't exist | ERROR: 1146 Table 'mysql.db' doesn't exist | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/host.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/user.MYI' (Errcode: 13)