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
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
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: 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
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
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
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
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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: 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]
Re: Problem with Mysql 4.0.18 + Debian
That sounds like a typical mod_perl-problem. The script is making new connections and doesn't close the old ones. You should add debug-code to your script and add * * * * * root mysql -e 'show processlist' /tmp/mysql_processlist_debug_`date +%s`.txt to your /etc/crontab in order to log the processlist once every minute in a txt-file in /tmp Jan [EMAIL PROTECTED] wrote: Thanks for the two responses. William Mussatto said: Are you running mod_perl? Yes I am, with Perl 5.8.3. Victor Pendleton said: What does mysql show processlist look like? Here is what it looks like currently, but the system is not in its unresponsive phase right now. I can't force it to go all wonky on me, it will probably be tomorrow before the process count explodes again. ++-+---+-+-+--+---+--+ | Id | User| Host | db | Command | Time | State | Info | ++-+---+-+-+--+---+--+ | 8 | citidel | localhost | citidel | Sleep | 0| | NULL | | 71 | citidel | localhost | citidel | Sleep | 2192 | | NULL | | 72 | citidel | localhost | citidel | Sleep | 2141 | | NULL | | 78 | citidel | localhost | citidel | Sleep | 1503 | | NULL | | 79 | citidel | localhost | citidel | Sleep | 1503 | | NULL | | 87 | citidel | localhost | citidel | Sleep | 741 | | NULL | | 88 | citidel | localhost | citidel | Sleep | 730 | | NULL | | 89 | citidel | localhost | citidel | Sleep | 607 | | NULL | | 95 | citidel | localhost | citidel | Query | 0| NULL | show processlist | ++-+---+-+-+--+---+- Ryan Richardson said: -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian (woody) server running a good sized database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 + perl and using mysql as the backend. In my.cnf, I have max_connections=300. Here's the problem. I had the site up several days, with everything running perfectly. Ordinarily there would be about 11 mysql processes running. However, after a few days of running smoothly, the number of mysql processes increases to over 170, and the site crashes. Formerly I'd get errors like DBI connect('yada yada, ...) failed: Too many connections at DB.pm line 25 However once I set max_connections to 300 (default is 90), mysql will still accept connections, but it is still way too slow to be usable, so the website becomes unreachable. I've read on this list that people running MySQL w/ FreeBSD can have similar sounding problems. I am wondering if there is a connection. I know that the site is getting virtually no traffic, so the problem is not that it is being overloaded. I have tried this scenario at least a dozen times, and the same thing always happens. Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with Mysql 4.0.18 + Debian
Thanks for the two responses. William Mussatto said: Are you running mod_perl? Yes I am, with Perl 5.8.3. Victor Pendleton said: What does mysql show processlist look like? Here is what it looks like currently, but the system is not in its unresponsive phase right now. I can't force it to go all wonky on me, it will probably be tomorrow before the process count explodes again. ++-+---+-+-+--+---+--+ | Id | User| Host | db | Command | Time | State | Info | ++-+---+-+-+--+---+--+ | 8 | citidel | localhost | citidel | Sleep | 0| | NULL | | 71 | citidel | localhost | citidel | Sleep | 2192 | | NULL | | 72 | citidel | localhost | citidel | Sleep | 2141 | | NULL | | 78 | citidel | localhost | citidel | Sleep | 1503 | | NULL | | 79 | citidel | localhost | citidel | Sleep | 1503 | | NULL | | 87 | citidel | localhost | citidel | Sleep | 741 | | NULL | | 88 | citidel | localhost | citidel | Sleep | 730 | | NULL | | 89 | citidel | localhost | citidel | Sleep | 607 | | NULL | | 95 | citidel | localhost | citidel | Query | 0| NULL | show processlist | ++-+---+-+-+--+---+- Ryan Richardson said: -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian (woody) server running a good sized database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 + perl and using mysql as the backend. In my.cnf, I have max_connections=300. Here's the problem. I had the site up several days, with everything running perfectly. Ordinarily there would be about 11 mysql processes running. However, after a few days of running smoothly, the number of mysql processes increases to over 170, and the site crashes. Formerly I'd get errors like DBI connect('yada yada, ...) failed: Too many connections at DB.pm line 25 However once I set max_connections to 300 (default is 90), mysql will still accept connections, but it is still way too slow to be usable, so the website becomes unreachable. I've read on this list that people running MySQL w/ FreeBSD can have similar sounding problems. I am wondering if there is a connection. I know that the site is getting virtually no traffic, so the problem is not that it is being overloaded. I have tried this scenario at least a dozen times, and the same thing always happens. Ryan While I am not a mod_perl expert it does create a connection for each child. I'm not clear on the pooling of these connections but you might check the number of apache children next time it goes un-responsive. Do each of your perl scripts include an explicit ' $dbh-disconnect;'? That may be needed to return things to the pool. You might also make sure that the $dbh is 'my'ed and that its scope is less than the entire program. For example putting it inside of set of { } and ensuring that the program flow falls out the bottom so the $dbh goes out of scope. I run in a multi-virtual host environment so mod_perl is conter productive for us so my experience is limited. I'd look at mod_perl and $dbh connection pooling on google. I'd be interested in what you find. We have a php mail system and I've had to increase the number of connections because of its connection pooling. -- William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with Mysql 4.0.18 + Debian
Hi, A quick fix would be to set the wait_timeout variable in the my.cnf to a much smaller value than 28800 (default value). Try to add wait_timeout=60 in the my.cnf for example, the connections should be automatically closed after 60 secondes if there are not used anymore. Regards, Jocelyn Fournier www.presence-pc.com - Original Message - From: Jan Kirchhoff [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 7:43 PM Subject: Re: Problem with Mysql 4.0.18 + Debian That sounds like a typical mod_perl-problem. The script is making new connections and doesn't close the old ones. You should add debug-code to your script and add * * * * * root mysql -e 'show processlist' /tmp/mysql_processlist_debug_`date +%s`.txt to your /etc/crontab in order to log the processlist once every minute in a txt-file in /tmp Jan [EMAIL PROTECTED] wrote: Thanks for the two responses. William Mussatto said: Are you running mod_perl? Yes I am, with Perl 5.8.3. Victor Pendleton said: What does mysql show processlist look like? Here is what it looks like currently, but the system is not in its unresponsive phase right now. I can't force it to go all wonky on me, it will probably be tomorrow before the process count explodes again. ++-+---+-+-+--+---+ --+ | Id | User| Host | db | Command | Time | State | Info | ++-+---+-+-+--+---+ --+ | 8 | citidel | localhost | citidel | Sleep | 0| | NULL | | 71 | citidel | localhost | citidel | Sleep | 2192 | | NULL | | 72 | citidel | localhost | citidel | Sleep | 2141 | | NULL | | 78 | citidel | localhost | citidel | Sleep | 1503 | | NULL | | 79 | citidel | localhost | citidel | Sleep | 1503 | | NULL | | 87 | citidel | localhost | citidel | Sleep | 741 | | NULL | | 88 | citidel | localhost | citidel | Sleep | 730 | | NULL | | 89 | citidel | localhost | citidel | Sleep | 607 | | NULL | | 95 | citidel | localhost | citidel | Query | 0| NULL | show processlist | ++-+---+-+-+--+---+ - Ryan Richardson said: -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian (woody) server running a good sized database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 + perl and using mysql as the backend. In my.cnf, I have max_connections=300. Here's the problem. I had the site up several days, with everything running perfectly. Ordinarily there would be about 11 mysql processes running. However, after a few days of running smoothly, the number of mysql processes increases to over 170, and the site crashes. Formerly I'd get errors like DBI connect('yada yada, ...) failed: Too many connections at DB.pm line 25 However once I set max_connections to 300 (default is 90), mysql will still accept connections, but it is still way too slow to be usable, so the website becomes unreachable. I've read on this list that people running MySQL w/ FreeBSD can have similar sounding problems. I am wondering if there is a connection. I know that the site is getting virtually no traffic, so the problem is not that it is being overloaded. I have tried this scenario at least a dozen times, and the same thing always happens. Ryan -- 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: Problem with Mysql 4.0.18 + Debian
Jocelyn Fournier wrote: Hi, A quick fix would be to set the wait_timeout variable in the my.cnf to a much smaller value than 28800 (default value). Try to add wait_timeout=60 in the my.cnf for example, the connections should be automatically closed after 60 secondes if there are not used anymore. But as you wrote its only a quick fix and when the load on the server increases the problem will show up again... sooner or later. Better find the bug in the perl-script, it's probably just a missing $dbh-disconnect (or it's in the wrong place) as somebody else here suggested already. we did a lot of bigger web-projects with heavy load and load-balancing on linux/apache/mysql/mod_perl - environments and it works perfectly, and all problems I've had before that were like Ryan's were just because of mistakes in my database-connection/disconnection functions. Try google, there are lots of webpages dealing with the traps of mod_perl and what one has to watch out for! Jan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem with Mysql 4.0.18 + Debian
What does mysql show processlist look like? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian (woody) server running a good sized database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 + perl and using mysql as the backend. In my.cnf, I have max_connections=300. Here's the problem. I had the site up several days, with everything running perfectly. Ordinarily there would be about 11 mysql processes running. However, after a few days of running smoothly, the number of mysql processes increases to over 170, and the site crashes. Formerly I'd get errors like DBI connect('yada yada, ...) failed: Too many connections at DB.pm line 25 However once I set max_connections to 300 (default is 90), mysql will still accept connections, but it is still way too slow to be usable, so the website becomes unreachable. I've read on this list that people running MySQL w/ FreeBSD can have similar sounding problems. I am wondering if there is a connection. I know that the site is getting virtually no traffic, so the problem is not that it is being overloaded. I have tried this scenario at least a dozen times, and the same thing always happens. Ryan -- 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: Problem with Mysql 4.0.18 + Debian
Victor Pendleton said: What does mysql show processlist look like? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian (woody) server running a good sized database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 + perl and using mysql as the backend. In my.cnf, I have max_connections=300. Here's the problem. I had the site up several days, with everything running perfectly. Ordinarily there would be about 11 mysql processes running. However, after a few days of running smoothly, the number of mysql processes increases to over 170, and the site crashes. Formerly I'd get errors like DBI connect('yada yada, ...) failed: Too many connections at DB.pm line 25 However once I set max_connections to 300 (default is 90), mysql will still accept connections, but it is still way too slow to be usable, so the website becomes unreachable. I've read on this list that people running MySQL w/ FreeBSD can have similar sounding problems. I am wondering if there is a connection. I know that the site is getting virtually no traffic, so the problem is not that it is being overloaded. I have tried this scenario at least a dozen times, and the same thing always happens. Ryan Are you running mod_perl? -- William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with Mysql 4.0.18 + Debian
Ryan, Here's the problem. I had the site up several days, with everything running perfectly. Ordinarily there would be about 11 mysql processes running. However, after a few days of running smoothly, the number of mysql processes increases to over 170, and the site crashes. Formerly I'd get errors like DBI connect('yada yada, ...) failed: Too many connections at DB.pm line 25 Are you running Perl from CGI or mod_perl? If you run it from mod_perl, maybe you have problem with persistent connection. Maybe you forgot to disconnect DB handler. --Batara -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with Mysql 4.0.18 + Apache
Hello: I posted this before but I have made some changes since then (not that they helped much). I have a Debian (woody) server running a good sized database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 + perl and using mysql as the backend. In my.cnf, I set max_connections=300. Here's the problem. I had the site up for weeks, with everything running perfectly. Ordinarily there would be about 11 mysql processes running (according to ps). However, when I switched my domain name over to this server, immediately the number of mysql processes increases to over 150, and the site crashes. Formerly I'd get errors like DBI connect('yada yada, ...) failed: Too many connections at DB.pm line 25 However once I set max_connections to 300 (default is 90), mysql will still accept connections, but it is still way too slow to be usable, so the website becomes unreachable. I know that the site is getting virtually no traffic, so the problem is not that it is being overloaded. I have tried this scenario at least a dozen times, and the same thing always happens. Is this a known issue with Apache + mysql 4.0.18? Ryan Are you using mod_perl by any chance? You might check to make sure that you are calling 'disconnect' at the end of each call. With mod_perl connections may stay open. I see a similar problem with php. Also, mod_perl will cause the children to be larger. -- William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem Installing MySQL Max
Lou Olsten wrote: I haven't figured out where to get the libstdc++ That's part of gcc usually found in /usr/local/lib or in the lib dir under the gcc installation dir. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem running MySQL on MacOS X.3
If you don't have a process mysqld running, then mysql isn't running. You may try starting up mysql directly (just type mysqld), rather than through the startup script or through mysqld_safe, since they suppress the error messages. You should then see some error message that may help determine why mysql isn't running. Also, to access mysql, you should provide user name and password. You won't be able to access it if you don't, unless it's configured that way. mysql -u username -p Keep in mind that the username and password are not related to the username and password in the OS. Many people trying to run it on a Mac miss this point. You may also try running the repair disk permissions from Apple's Disk Utility and then installing MySQL again. In the past there had been privilege issues on certain folders that prevented MySQL from running or installing correctly. That said, I've been running MySQL on a Mac for quite some time without a problem. So if will run. There are some known issues with running 4.1 on a Mac. On May 10, 2004, at 5:21 PM, Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I have /usr/local/mysql and so on as per the docs. I also installed MySQLStartupItem. However, I don't actually appear to have a functional installation. If I do: /usr/local/mysql/bin/mysql or even sudo /usr/local/mysql/bin/mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) although /tmp/mysql.sock does exist, which seems to indicate the server is running. But then again ps -a -x doesn't seem to show it, so maybe it isn't; if I do ps -A |fgrep mysql on my Linux box, where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld. I tried starting the server manually as suggested in the docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try running mysql I get error 2002 as before. I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most welcome! Please cc any replies to me as I am not currently subscribed to any of the MySQL lists. Thanks in advance, Tim Jarman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- 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]
Re: Problem running MySQL on MacOS X.3
Did you configure MySQL and run the /usr/local/mysql/scripts/mysql_install_db to initialize your data directory? - Gabriel On May 10, 2004, at 5:21 PM, Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I have /usr/local/mysql and so on as per the docs. I also installed MySQLStartupItem. However, I don't actually appear to have a functional installation. If I do: /usr/local/mysql/bin/mysql or even sudo /usr/local/mysql/bin/mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) although /tmp/mysql.sock does exist, which seems to indicate the server is running. But then again ps -a -x doesn't seem to show it, so maybe it isn't; if I do ps -A |fgrep mysql on my Linux box, where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld. I tried starting the server manually as suggested in the docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try running mysql I get error 2002 as before. I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most welcome! Please cc any replies to me as I am not currently subscribed to any of the MySQL lists. Thanks in advance, Tim Jarman -- 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: Problem running MySQL on MacOS X.3
ps should show you something like the following: Jupiter:~/desktop hcir$ ps uax | grep mysql root 291 0.0 0.118644 1072 ?? S 3May04 0:00.06 sh ./bin/safe_mysqld --user=mysql mysql 338 0.0 2.551720 19872 ?? S 3May04 10:17.86 /usr/local/mysql-standard-4.1.0-alpha-apple-darwin6.4-powerpc/bin/ mysqld hcir20399 0.0 0.018172344 std S+ 10:52AM 0:00.01 grep mysql if you dont see this i would check the error log after you try to start the server with something like: #/usr/local/mysql/bin/mysqld_safe -uuser - hcir On May 11, 2004, at 10:29 AM, Gabriel Ricard wrote: Did you configure MySQL and run the /usr/local/mysql/scripts/mysql_install_db to initialize your data directory? - Gabriel On May 10, 2004, at 5:21 PM, Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I have /usr/local/mysql and so on as per the docs. I also installed MySQLStartupItem. However, I don't actually appear to have a functional installation. If I do: /usr/local/mysql/bin/mysql or even sudo /usr/local/mysql/bin/mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) although /tmp/mysql.sock does exist, which seems to indicate the server is running. But then again ps -a -x doesn't seem to show it, so maybe it isn't; if I do ps -A |fgrep mysql on my Linux box, where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld. I tried starting the server manually as suggested in the docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try running mysql I get error 2002 as before. I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most welcome! Please cc any replies to me as I am not currently subscribed to any of the MySQL lists. Thanks in advance, Tim Jarman - hcir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem running MySQL on MacOS X.3
Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I have /usr/local/mysql and so on as per the docs. I also installed MySQLStartupItem. However, I don't actually appear to have a functional installation. If I do: /usr/local/mysql/bin/mysql or even sudo /usr/local/mysql/bin/mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) although /tmp/mysql.sock does exist, which seems to indicate the server is running. But then again ps -a -x doesn't seem to show it, so maybe it isn't; if I do ps -A |fgrep mysql on my Linux box, where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld. I tried starting the server manually as suggested in the docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try running mysql I get error 2002 as before. I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most welcome! Please cc any replies to me as I am not currently subscribed to any of the MySQL lists. Tim: perror 61 will reveal some details about why exactly the connection on /tmp/mysql.sock cannot happen. If that does not make it obvious ( and it is a good possibility that it would not), try mysql -h 127.0.0.1 instead to bypass the Unix socket and use TCP/IP. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem running MySQL
Franz Klein [EMAIL PROTECTED] wrote: I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a network. I have administrator privileges. I have also installed MySQL Administrator. When I try to look at the users I get the following error message: Could not fetch Usernames MySQL Error Nr. 1044 Access denied for user: '@%' to database 'mysql' When I run WinMySQLAdmin 1.4 and click on the 'Databases' tab no databases are listed. When I work from the console and at the mysql prompt when I type in SHOW DATABSES; it only lists the test database but not the mysql database. When I use the MySQL Contorl Client to view the server I get: ERROR 1227: Access denied. You need the PROCESS privilege for this operation I have tried using the mysql_fix_privileges.sql but that also gives me lots of errors. Does anybody have an idea of what is wrong? I have repeatedly tried to reinstall MySQL. You connected to MySQL server as anonymous user that has pribileges only on the database 'test'. Connect as user that has enough privileges, for example as user 'root'. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with mySQL and Mac OS X
I'm running mysql 4.0.17 on Mac OS X 10.2.8 without problems. My first guess would be that the upgrade reset the permissions on /tmp, so now the mysql user doesn't have permission to create mysql.sock. Try cd /tmp sudo chmod 1777 . then see if mysqld will start. (While you're in /tmp, make sure there isn't an old mysql.sock still sitting there.) Michael Jon Pearse wrote: Hi, I've recently been having some problems with mySQL on one of my OS X computers. It was working perfectly until I upgraded from OS 10.2.6 to OS 10.2.8, and now mysqld refuses to start up, showing the following -- [EMAIL PROTECTED] mysql]$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 031220 01:08:05 mysqld ended [EMAIL PROTECTED] mysql]$ -- The error log shows the following: -- 031220 01:08:05 mysqld started 031220 1:08:05 Can't start server : Bind on unix socket: Permission denied 031220 1:08:05 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 031220 1:08:05 Aborting -- I've tried reinstalling mySQL, I've repaired permissions, I've also done some fairly radical things with permissions, but to no avail. If anyone has any suggestions, I'd be incredibly grateful. I'm running mySQL (standard) 4.1.1a for MacOS X, running under MacOS 10.2.8. Thanks for any help, -Jon --- http://www.jonpearse.net[EMAIL PROTECTED] Some people come into our lives and quickly go. Some stay for a while and leave footprints on our hearts. And we are never, ever the same. --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem with 'mysql' command on Mac OS X 1.3 (Panther)
What version of mysql are you using? I'm running 4.0.14 and I upgraded without a problem. On Friday, October 31, 2003, at 01:20 PM, Anderson, James H [IT] wrote: Ever since upgrading I haven't been able to use the 'mysql' command--it just hangs. Otherwise, the database seems to be working properly. I even tried rebuilding from source but it didn't solve the problem. I've attached ktrace/kdump output of the problem. I'm hoping someone can interpret this stuff and let me know what the problem is. Thanks, jim kdump.out -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- 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]
RE: problem with MySQL and latest release of Mac OX X (Panther)
'mysql -A sampdb' hangs as does every other mysql command. There are no recent entries in hostname.err. -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 5:52 PM To: Anderson, James H [IT]; [EMAIL PROTECTED] Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) Could you look at you're hostname.err file and see if it says checking table? Also try mysql -A sampdb - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 2:03 PM --To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED] --Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) -- --BTW, nothing's changed in my.cnf... -- --.my.cnf - --[client] --host=localhost --user=jim --password=password -- --No query, I just entered 'mysql sampdb'. It hung indefinitely; I had to --kill --the window. --Since I couldn't get into mysql I don't know the value of any variables. -- -- ---Original Message- --From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 4:42 PM --To: Anderson, James H [IT]; [EMAIL PROTECTED] --Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) -- -- --Can you post you're my.cnf options / your query in question / how long --have you seen it hang / what status it is in / and your show status --vars. -- -- -- --- Dathan Vance Pattishall -- - Sr. Programmer and mySQL DBA for FriendFinder Inc. -- - http://friendfinder.com/go/p40688 -- -- -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 1:06 PM To: [EMAIL PROTECTED] Subject: problem with MySQL and latest release of Mac OX X (Panther) Much to my surprise and chagrin, I'm having a problem using MySQL --after upgrading to the latest release of Mac OS X this past weekend. As far --as I can tell, the server seems to be running, but when I attempt to --execute the mysql command it just hangs. Any ideas? Thanks, jim -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem with MySQL and latest release of Mac OX X (Panther)
Can you post youre my.cnf options / your query in question / how long have you seen it hang / what status it is in / and your show status vars. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 1:06 PM --To: [EMAIL PROTECTED] --Subject: problem with MySQL and latest release of Mac OX X (Panther) -- --Much to my surprise and chagrin, I'm having a problem using MySQL after --upgrading to the latest release of Mac OS X this past weekend. As far as --I can tell, the server seems to be running, but when I attempt to execute --the mysql command it just hangs. Any ideas? -- --Thanks, -- --jim -- -- --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: problem with MySQL and latest release of Mac OX X (Panther)
BTW, nothing's changed in my.cnf... .my.cnf --- [client] host=localhost user=jim password=password No query, I just entered 'mysql sampdb'. It hung indefinitely; I had to kill the window. Since I couldn't get into mysql I don't know the value of any variables. -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 4:42 PM To: Anderson, James H [IT]; [EMAIL PROTECTED] Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) Can you post you're my.cnf options / your query in question / how long have you seen it hang / what status it is in / and your show status vars. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 1:06 PM --To: [EMAIL PROTECTED] --Subject: problem with MySQL and latest release of Mac OX X (Panther) -- --Much to my surprise and chagrin, I'm having a problem using MySQL after --upgrading to the latest release of Mac OS X this past weekend. As far as --I can tell, the server seems to be running, but when I attempt to execute --the mysql command it just hangs. Any ideas? -- --Thanks, -- --jim -- -- --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: problem with MySQL and latest release of Mac OX X (Panther)
Could you look at youre hostname.err file and see if it says checking table? Also try mysql -A sampdb - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 2:03 PM --To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED] --Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) -- --BTW, nothing's changed in my.cnf... -- --.my.cnf - --[client] --host=localhost --user=jim --password=password -- --No query, I just entered 'mysql sampdb'. It hung indefinitely; I had to --kill --the window. --Since I couldn't get into mysql I don't know the value of any variables. -- -- ---Original Message- --From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 4:42 PM --To: Anderson, James H [IT]; [EMAIL PROTECTED] --Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) -- -- --Can you post you're my.cnf options / your query in question / how long --have you seen it hang / what status it is in / and your show status --vars. -- -- -- --- Dathan Vance Pattishall -- - Sr. Programmer and mySQL DBA for FriendFinder Inc. -- - http://friendfinder.com/go/p40688 -- -- -Original Message- From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 1:06 PM To: [EMAIL PROTECTED] Subject: problem with MySQL and latest release of Mac OX X (Panther) Much to my surprise and chagrin, I'm having a problem using MySQL --after upgrading to the latest release of Mac OS X this past weekend. As far --as I can tell, the server seems to be running, but when I attempt to --execute the mysql command it just hangs. Any ideas? Thanks, jim -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with MySQL 4.0.14 - Server Crash
[EMAIL PROTECTED] wrote: I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. MySQL always crashs with error 11 Segmentation fault. I don't know why but I try to dump database (about 200,000 lines) and install MySQL 4.0.14 windows version and try to import database again to MySQL windows version. Nothing change database server crash. Then I downgrade to MySQL 3.23.55 (windows). There is no any problem, import work fine. Then I try to use MySQL 4.0.12 (windows), there is no problem again. I try to upgrade my Linux server to MySQL 4.0.13. The result is same as MySQL 4.0.14. Then I try to find which Query is crash. And know that MySQL 4.0.14 (Windows) always crashs when try to read field that include blank value in key (primary, index, unique) even MyISAM or InnoDB, server will crash. This bug is fixed in v4.0.15. * Fixed crash in comparisons of strings using the tis620 character set. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with MySQL 4.0.14 - Server Crash
Hi! On Sep 10, Victoria Reznichenko wrote: [EMAIL PROTECTED] wrote: I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. MySQL always crashs with error 11 Segmentation fault. I don't know why but I try to dump database (about 200,000 lines) and install MySQL 4.0.14 windows version and try to import database again to MySQL windows version. Nothing change database server crash. Then I downgrade to MySQL 3.23.55 (windows). There is no any problem, import work fine. Then I try to use MySQL 4.0.12 (windows), there is no problem again. I try to upgrade my Linux server to MySQL 4.0.13. The result is same as MySQL 4.0.14. Then I try to find which Query is crash. And know that MySQL 4.0.14 (Windows) always crashs when try to read field that include blank value in key (primary, index, unique) even MyISAM or InnoDB, server will crash. This bug is fixed in v4.0.15. * Fixed crash in comparisons of strings using the tis620 character set. Vita, why do you think that this bugfix is relevant ? How do you know he is using tis620 charset - was it in some other email ? Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with MySQL 4.0.14 - Server Crash
Victoria, Thanks. -- __ Sign-up for your own personalized E-mail at Mail.com http://www.mail.com/?sr=signup CareerBuilder.com has over 400,000 jobs. Be smarter about your job search http://corp.mail.com/careers -- 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.0.12 on MAC OSX 10.1.3
Devang Panchalia [EMAIL PROTECTED] wrote: Hi, I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message 030821 time MySqld ended. Does anyone know what the problem is ...?? Check error log. (You can find it in the MySQL data dir). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing MYSql 4.0.12 on MAC OSX 10.1.3
It may be that you did not give the mysql user ownership of the Data folder? Check your permissions first by typing: [KieranMac:~] kieran% ls -al /usr/local/mysql/ this shold show data folder as something like this: drwxr-x--- 13 mysql wheel 442 Aug 19 19:52 data Type this on the command line to make mysql the owner if it is not the owner: sudo chown -R mysql /usr/local/mysql/data For detailed support, this is a great site: http://www.entropy.ch/software/macosx/mysql/ On Thursday, August 21, 2003, at 07:00 AM, Devang Panchalia wrote: Hi, I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message 030821 time MySqld ended. Does anyone know what the problem is ...?? Devang. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ___ Kieran Kelleher Palm Harbor, Florida USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing MySQL v4.0.14b
At 17:35 17/8/2003 +0100, Debbie wrote: Hi, Hi, I have just downloaded MySQLv4.0.14b for windows and 21% through the installation, it displays the following error: An error occurred during the move dataq process: -132 Component: File Group: File: The above frequently happens because the installer tries to write a file that is being using by another process (the re-write action is denied and then the installer aborts). Take a look if any other application is using, for example, the libmysql.dll, if the mysql.exe is running, etc. Stop the applications before the setup. The MD5 hash matches the one on your website and I have spent another 5 hours or so downloading it again from your main site instead of a mirror site, but it stills does the same thing. I'm installing it into the the same folder as the previous version (3.23.49). Could you tell me what I could possibly be doing wrong or of a way I could get around this, please? With Regards, Debbie Figg -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem installing mysql
Make sure your firewall isn't blocking port 3306 (the default tcp port) on localhost (127.0.0.1). Firewalls DO matter. I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: Cannot connect to localhost port... my machine is not connected to internet. I also have firewall installed on my machine, but this should not matter. Any suggestions why I may be getting this error. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem with mysql-crashes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote: before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Is that a self-compiled binary or one of ours? Its not reproducible nor I know a query which does it. (The log shows that at the end, so no query :-( : Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x5e13a478 is invalid pointer thd-thread_id=2223573 ) Not very helpful. Does this occur under high load only? The server is the standalone db-server for one accessing webserver, its running RedHat-Linux 7.2 with all their latest patches. Kernel 2.4.19-XFS with MySQL running on an XFS-filesystem. No replication but query-cache enabled. What version of glibc is this system running on? Is it 2.2.3 by chance? Ok but now the worse thing started for 2 times I already got this problem in the logs: Number of processes running now: 16 mysqld-max process hanging, pid 17193 - killed mysqld-max process hanging, pid 17191 - killed mysqld-max process hanging, pid 17190 - killed mysqld-max process hanging, pid 17145 - killed mysqld-max process hanging, pid 17144 - killed mysqld-max process hanging, pid 17098 - killed mysqld-max process hanging, pid 17025 - killed mysqld-max process hanging, pid 16987 - killed mysqld-max process hanging, pid 28393 - killed mysqld-max process hanging, pid 28392 - killed mysqld-max process hanging, pid 28391 - killed mysqld-max process hanging, pid 28389 - killed mysqld-max process hanging, pid 28388 - killed mysqld-max process hanging, pid 28387 - killed mysqld-max process hanging, pid 28386 - killed mysqld-max process hanging, pid 28385 - killed 030722 20:46:26 mysqld restarted Afterwards there is a init-process taking 99% from one CPU. The first time I tried to reboot the machine, which didn't work as the shutdown process was hanging then. Any ideas whats wrong and how to fix it? Didn't see a mention of a fix for that problem in the 4.0.14-changelog, will it still fix it? What version of glibc is being used on that system? I noticed that you use the Max binary, which is dynamically linked - so it will use the locally installed libc.so. Is there any special reason for using Max? Or could you try to use our statically linked Standard binary instead? The problem above looks very similar to the problems we had when we linked against glibc 2.2.3 instead of 2.2.5: under high load, a mysqld thread starts eating up all CPU resources on an SMP system. Unfortunately we never found the reason for that - it did not seem to happen when using glibc 2.2.5... Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/HoQOSVDhKrJykfIRAh+MAJ91+kr7H92xcK4JtFhz5HQ3r6LGgwCggT/v OCHlqAabKjd6FnL6PMOmKRg= =U2ag -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 with mysql-crashes
Hi Lenz, thanks a lot for your reply! Is that a self-compiled binary or one of ours? It are the MySQL-4.0.13-MAX-RPMs from your site. Not very helpful. Does this occur under high load only? Yeah I know, otherwise I would have tried to generate a reproducible testcase with a given query or such. Any way to have valid pointers there? Nope, the load on that system is mostly around 0.5 with peaks up to 1.5, not something I would call a high load for a dual-system. Also the crashes are at many different times (even in the deep night) so I don't think its related to load :-(. What version of glibc is this system running on? Is it 2.2.3 by chance? Nope, sorry. Its glibc-2.2.4-32. What version of glibc is being used on that system? I noticed that you use the Max binary, which is dynamically linked - so it will use the locally installed libc.so. Is there any special reason for using Max? Or could you try to use our statically linked Standard binary instead? Yeah I could try that instead, maybe I should try with 4.0.13 to see if its a problem of that version. Or should I better try 4.0.14 already? I was hosting a couple of bdb-tables for some time, but no longer now. Currently only myisam and innodb-tables so I could try the standard-built too. The problem above looks very similar to the problems we had when we linked against glibc 2.2.3 instead of 2.2.5: under high load, a mysqld thread starts eating up all CPU resources on an SMP system. Unfortunately we never found the reason for that - it did not seem to happen when using glibc 2.2.5... Hmm, maybe 2.2.4 has the same problem? The problem is that the init-process is taking all the cpu, didn't see a mysql-process doing the same before. Thanks, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem When Mysql runs on a Machine with multiple NIC.
Paul DuBois [EMAIL PROTECTED] 7/10/2003 10:22:27 AM At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of [EMAIL PROTECTED] instead it will be equal to the rights of the [EMAIL PROTECTED] Is this behaviour correct or a bug. This is correct behavior. MySQL doesn't know that localhost and PrimaryIPAddress are the same host. How to make the mysql client to use the secondary IP Address to connect to the Mysql server?. Thanks, Srinivasulu. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem When Mysql runs on a Machine with multiple NIC.
Specify other account(s)? [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] etc... Me fail English? That's unpossible ###___Archon___### - Original Message - From: P Srinivasulu [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 10, 2003 2:40 PM Subject: Re: Problem When Mysql runs on a Machine with multiple NIC. Paul DuBois [EMAIL PROTECTED] 7/10/2003 10:22:27 AM At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of [EMAIL PROTECTED] instead it will be equal to the rights of the [EMAIL PROTECTED] Is this behaviour correct or a bug. This is correct behavior. MySQL doesn't know that localhost and PrimaryIPAddress are the same host. How to make the mysql client to use the secondary IP Address to connect to the Mysql server?. Thanks, Srinivasulu. -- 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: Problem When Mysql runs on a Machine with multiple NIC.
At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of [EMAIL PROTECTED] instead it will be equal to the rights of the [EMAIL PROTECTED] Is this behaviour correct or a bug. This is correct behavior. MySQL doesn't know that localhost and PrimaryIPAddress are the same host. Thanks, Srinivasulu. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://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 replication
Dan Houtz [EMAIL PROTECTED] wrote: I'm currently trying to setup replication following the directions from the mysql manual, however, once I configure the slave server with the server-id parameter, it fails to load. If I remove server-id=2 from my.cnf then the server starts up fine. I'm hoping someone can help me out: Master and Slace are both running mySQL 3.23.52 Master Config: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-innodb log-bin server-id=1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log Pid-file=/var/run/mysqld/mysqld.pid Slave Config: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock master-host=192.168.0.8 master-user=replicate master-password=password server-id=2 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid here is what the slave server logs when started (it appears to hang on each attempted start/-restart): Number of processes running now: 1 mysqld process hanging, pid 22725 - killed 030604 15:44:44 mysqld restarted Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 22749 - killed 030604 15:44:44 mysqld restarted 030604 15:44:44 Can't start server: Bind on TCP/IP port: Address already in use 030604 15:44:44 Do you already have another mysqld server running on port: 3306 ? 030604 15:44:44 Aborting 030604 15:44:44 /usr/libexec/mysqld: Shutdown Complete 030604 15:44:44 mysqld ended But it's not a replication related error. Do you use InnoDB? Do you have any entries in the my.cnf related to the InnoDB startup options? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem starting mysql server
-Original Message- From: Rehaz Golamnobee [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 3:41 AM ... I have just upgraded my MySQL from version 3.23 to 4.0.13. However I cannot start the server. When I type mysqld_safe I get the following : [1] 1730 Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql 030529 11:10:51 mysqld ended [1]+ Done mysqld_safe Sounds like it's never starting up at all, which explains why you can't connect to it. First thing I'd do is check your config file. Are you using the same config file as you did with 3.23? If so, you almost surely need to update it to suit 4.x, working from the examples that came with it. I don't recall details, but I'm quite sure that there are variable settings that will cause this behavior. You might first try one of the generic sample config files that came with your new version, just to see if it'll start up properly. Then try modifying one variable at a time, restarting after each. Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem starting mysql server
You should probably also take a look at your error log (dbmaster.err)...it'll tell you in much more detail why mysqld ended rather than continued running as expected. Often this will be something as simple as your directory permissions not being set right on your data dir... Chris Nick Arnett wrote: -Original Message- From: Rehaz Golamnobee [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 3:41 AM ... I have just upgraded my MySQL from version 3.23 to 4.0.13. However I cannot start the server. When I type mysqld_safe I get the following : [1] 1730 Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql 030529 11:10:51 mysqld ended [1]+ Done mysqld_safe Sounds like it's never starting up at all, which explains why you can't connect to it. First thing I'd do is check your config file. Are you using the same config file as you did with 3.23? If so, you almost surely need to update it to suit 4.x, working from the examples that came with it. I don't recall details, but I'm quite sure that there are variable settings that will cause this behavior. You might first try one of the generic sample config files that came with your new version, just to see if it'll start up properly. Then try modifying one variable at a time, restarting after each. Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling mysql-connector-java 3.1.0-alpha
Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pierre wrote: Hi, I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system with gcc-3.2, but for the make I got this : # ant Buildfile: build.xml Overriding previous definition of reference to non.test.sources clean: [delete] Deleting directory /tmp/build-mysql-jdbc init: [copy] Copying 78 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copied 2 empty directories to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copying 3 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [mkdir] Created dir: /tmp/build-mysql-jdbc/clover [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/db [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/report compile-core: [javac] Compiling 72 source files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:21: package junit.framework does not exist [javac] import junit.framework.TestCase; [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:38: cannot resolve symbol [javac] symbol : class TestCase [javac] location: class testsuite.BaseTestCase [javac] public abstract class BaseTestCase extends TestCase { [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:125: cannot resolve symbol [javac] symbol : method fail () [javac] location: class testsuite.BaseTestCase [javac] fail(); [javac] ^ [...] It would be great if you could help me with this ! Best regards, Pierre. We don't distribute the junit jar files. If you want to compile the driver with the testsuite, then you need to get junit from www.junit.org. ok thank you, it was not clear that it was junit that was missing. Is there a reason you're compiling the driver yourself? It does come already compiled :) -Mark I'm on LFS so I prefer to compile everything myself :) Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem starting mysql server
Rehaz Golamnobee writes: Hi I have just upgraded my MySQL from version 3.23 to 4.0.13. However I cannot start the server. When I type mysqld_safe I get the following : [1] 1730 Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql 030529 11:10:51 mysqld ended [1]+ Done mysqld_safe When I type mysql at the Linux:/# prompt, I get the following : Error 2002 : Can't connect to local MYSQL server through socket '/var/lib/mysql/mysql.sock' (2). I looked for the file mysql.sock in /var/lib/mysql/ but it was not there. I used Find File in Linux and it could not find mysql.sock anywhere on the system. I remember that the file mysql.sock was found at /var/lib/mysql/ in version 3.23. Can you please help ? These are the details of my system : SuSe Linux O.S version 8.1 Professional Kernel version 2.4.19 Machine - Pentium 4 2.00 GHz (Dell optiplex GX260) Thank you Rehaz. This list, [EMAIL PROTECTED], is dedicated to repeatable test case, and this is not the one. You can not connect as the server is not running, and all possible causes for problems in starting MySQL server are fully explained in our manual. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling mysql-connector-java 3.1.0-alpha
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pierre wrote: Hi, I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system with gcc-3.2, but for the make I got this : # ant Buildfile: build.xml Overriding previous definition of reference to non.test.sources clean: [delete] Deleting directory /tmp/build-mysql-jdbc init: [copy] Copying 78 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copied 2 empty directories to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copying 3 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [mkdir] Created dir: /tmp/build-mysql-jdbc/clover [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/db [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/report compile-core: [javac] Compiling 72 source files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:21: package junit.framework does not exist [javac] import junit.framework.TestCase; [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:38: cannot resolve symbol [javac] symbol : class TestCase [javac] location: class testsuite.BaseTestCase [javac] public abstract class BaseTestCase extends TestCase { [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:125: cannot resolve symbol [javac] symbol : method fail () [javac] location: class testsuite.BaseTestCase [javac] fail(); [javac] ^ [...] It would be great if you could help me with this ! Best regards, Pierre. We don't distribute the junit jar files. If you want to compile the driver with the testsuite, then you need to get junit from www.junit.org. Is there a reason you're compiling the driver yourself? It does come already compiled :) -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+1fkHtvXNTca6JD8RAljMAKCPc66NJzUMgMDGAdbBeZyegb2LwQCgnb2Z YKxQvy44MvEp9WAoigBBtcU= =X3Yt -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 reinstalling MySQL on Mac OS X
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, thanks for reporting this. I assume, you used the MySQL package from mysql.com? On Thu, 6 Mar 2003, Perry Arnold wrote: I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X machine (version 10.2.4) and I couldn't get it to start up. When I run bin/mysqld_safe, I kept getting the error Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist [note: I later figured out that I *think* I'm getting this error because my machine does not have a recognizable hostname (i.e. you can't look it up via normal DNS)]. Hmm, this case is currently not properly handled, indeed. Thanks for the hint! mysql_install_db simply aborts, if the host name cannot be resolved, but the error does not get fed back to the installer itself... After mucking around for quite a while without much success, I decided to start over and reinstall from scratch. So, I deleted my mysql directory and reinstalled from the Package. Now, when I try to run bin/mysqld_safe, I get the following error: InnoDB: Operating system error number 13 in a file operation. It looks like when you reinstall from the package, it skips the step where it changes file permissions of the data directory and its subdirectories. How-To-Repeat: On a fresh MacOS X 10.2.4 system, (1) install the 4.0.11-gamma package, (2) delete the mysql directories (the /usr/local/mysql link and /usr/local/mysql-standard-4.0.11-gamma-apple-darwin6.4-powerpc directory), (3) install the 4.0.11 package again, (4) run bin/mysqld_safe. Fix: Change the file permissions of the data directory and its subdirectories. Ideally, this would be fixed within the Package installer, but a release note or something would work as well. This is interesting. Are you sure you removed all mysql directories in /usr/local? The installation package includes a postinstall script, that does the following: [SNIP] if cd /usr/local/mysql ; then if [ ! -f data/mysql/db.frm ] ; then ./scripts/mysql_install_db fi if [ -d data ] ; then chown -R mysql data fi else exit $? fi [SNIP] /usr/local/mysql is a symlink, pointing to the real installation directory and is included in the package itself. So if you really removed all files, the ownerships should have been set up correctly. Unfortunately it's very hard to debug this problem, since the Package Installer does not offer any logging functionality... After looking through your mail again, I wonder how you tried to start MySQL. Did you use sudo mysqld_safe, as described in the docs? If you try it as a normal user (omitting sudo, the directory permissions and ownerships indeed will give you a permission denied error message. This is intentional! Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+eJjQSVDhKrJykfIRAu9eAJ9AWiSgVNOB9e3LMMxzllQ2VTNESQCfa/mg /FXb3eaPfsHvOtK0zfPXqsg= =glQe -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL, MyODBC, Access 2002 and Japanese.
Don't know, but: Are you using the Japanese Access 2002? What locale is your OS configured for? HTH, Tore. - Original Message - From: Juan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 6:12 AM Subject: Problem with MySQL, MyODBC, Access 2002 and Japanese. Help!, I am developing a multilingual site in English, Spanish and Japanese. I am using MySQL with PHP in the server side, and Access 2002 in the local side, using MyODBC to communicate MySQL with Access 2002. MySQL and PHP works toguether ok in Japanese, English and Spanish (using EUC_JP in both PHP and MySQL), Access 2002 (XP operating system) works ok in japanese (XP use UNICODE). The big problem is MyODBC. When I connect Access 2002 with MySQL (via MyODBC) to view the japanese characters stored in MySQL, in Access 2002 I only see a lot of strange characteres, I view the same characters without problems using phpMyAdmin. I have been several days searching the web without success. Any suggestion to solve this problem (in English or Spanish, no Japanese :-)? ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem building mysql as an embedded server
Hi All, I am trying to run mysqld as an embedded server within my application. I have read the manual which says to run configure with --with-embedded-server option, but I have not succeded in building libmysqld.a. It builds all the remaining libs, but I don't find libmysqld.a anywhere within the install directory. The command I used is : ./configure --prefix=/home/dir --with-embedded-server=yes make make install I also tried, ./configure --prefix=/home/dir --with-embedded-server without any success in building libmysqld.a. Is this a bug ? Can anyone please help in resolving this ? Thanks, Ashok I'm guessing you are using the 3.23 source download. It's confusing because the documentation provided with the 3.23 source says that it can be configured with --with-embedded-server but, as far as I can tell, the embedded server was added with the 4.0 release. Anyway, binaries for the 4.0 embedded server are available for download. --- Travis McLeskey - [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem Editing mysql Text field
Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: Daniel Negron/KBE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 8:13 PM Subject: Problem Editing mysql Text field Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem Editing mysql Text field
This is weird, all of a sudden it starts working, if it happens again though I will try another front end. Thank you for your advice Thank you, --- -Daniel Negron // \\* / _ __ ___ \Lotus Notes Admin / Developer | | |/ /| _ ) | KB Electronic, Inc. | | ' | _ \ | 12095 NW 39th Street | |_|\ \|___/ | Coral Springs, FL. 33065 \ \_\ /954.346.4900 x 122 \\ // email: [EMAIL PROTECTED] - http://www.kbelectronics.com --- |+- || Insanely | || Great | || insanely420@Pu| || nkAss.com | || | || 02/13/2003 | || 11:22 AM | || | |+- | | | | To: [EMAIL PROTECTED], Daniel Negron/KBE [EMAIL PROTECTED] | | cc: | | Subject: Re: Problem Editing mysql Text field | | Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: Daniel Negron/KBE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 8:13 PM Subject: Problem Editing mysql Text field Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling mysql-3.23.53
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 9 Dec 2002, Pierre wrote: I tried mysql-4.0.5a-beta, and same error... Try to compile without --with-libwrap - seems like there is a buglet in this part of the code - or do you desperately need TCP wrapper support? Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE99OVmSVDhKrJykfIRAltwAJ47tlKimR5lmPpa1K07Zkd+xW1xsACeKbB7 HJhbGPT33foF6BvVyJO2n9M= =Tgea -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling mysql-3.23.53
I tried mysql-4.0.5a-beta, and same error... Pierre. On 2002.12.08 02:36 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql' g++ -s -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex -I. -I../include -I.. -I. -I/usr/local/BerkeleyDB.4.1/include -O3 -DDBUG_OFF -O3 -march=i686 -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc /usr/include/tcpd.h: In function `void* handle_connections_sockets(void*)': /usr/include/tcpd.h:131: too many arguments to function `void sock_host()' mysqld.cc:2444: at this point in file /usr/include/tcpd.h:69: too many arguments to function `int hosts_access()' mysqld.cc:2445: at this point in file /usr/include/tcpd.h:124: too many arguments to function `char* eval_client()' mysqld.cc:2453: at this point in file gmake[3]: *** [mysqld.o] Error 1 gmake[3]: Leaving directory `/tmp/mysql-3.23.53/sql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/tmp/mysql-3.23.53/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-3.23.53' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling mysql 3.23.53
I finally found the solution : I had bad old include files in /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/ that come from a old gcc installation. I removed them and now it's ok. Pierre. On 2002.11.13 06:50 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in client gmake[2]: Entering directory `/tmp/mysql-3.23.53/client' g++ -s -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -I/usr/local/BerkeleyDB.4.1/include -O3 -DDBUG_OFF -O3 -march=i686 -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc In file included from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:86, from mysql.cc:48: /usr/include/unctrl.h: In function `int NCURSES_EXPORT(char*)': /usr/include/unctrl.h:57: parse error before `(' token In file included from mysql.cc:48: /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:406: non-localfunction `int add_wch(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:407: non-localfunction `int add_wchnstr(const NCURSES_EXPORT(char*)::cchar_t*, int)' useslocal type `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:408: non-localfunction `int add_wchstr(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:422: non-localfunction `void bkgrndset(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:423: non-localfunction `int bkgrnd(const NCURSES_EXPORT(char*)::cchar_t*)' uses local type`const NCURSES_EXPORT(char*)::cchar_t' [...] I have ncurses-5.3 installed. It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL-GUI
On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote: Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) and I just downloaded MySQL-GUI and can't seem to get it working. It keeps telling me that it cannot connect through the socket (111). Can someone tell me what I'm doing wrong? I tried to set the path using a shell program in /etc/profile.d/mysqlgui.sh and I even exported the value of PATH. At present, my version of MySQL-GUI is in /usr/local/mysqlgui. Any help would be appreciated. I believe MySQL-GUI tried by default to connect to the mysql server (mysqld) running on localhost using the socket connection (as supposed to tcp/ip ). The error message you are getting seems to indicate that your computer does not run mysqld. Check out here how to get it started: http://www.mysql.com/doc/en/Automatic_start.html /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with MySQL-GUI
running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? = Original Message From R. Hannes Niedner [EMAIL PROTECTED] = On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote: Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) and I just downloaded MySQL-GUI and can't seem to get it working. It keeps telling me that it cannot connect through the socket (111). Can someone tell me what I'm doing wrong? I tried to set the path using a shell program in /etc/profile.d/mysqlgui.sh and I even exported the value of PATH. At present, my version of MySQL-GUI is in /usr/local/mysqlgui. Any help would be appreciated. I believe MySQL-GUI tried by default to connect to the mysql server (mysqld) running on localhost using the socket connection (as supposed to tcp/ip ). The error message you are getting seems to indicate that your computer does not run mysqld. Check out here how to get it started: http://www.mysql.com/doc/en/Automatic_start.html /h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL-GUI
On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote: running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? If I am not mistaken the socket works only for a connection between server and client running on the same host. It is more effective since it skips the network stacks and you can see it as a kind of shortcut. But whenever you connect from the outside (or use mysql -h localhost -P 3306 for the localhost connection) the communication between client and server happens via tcp/ip via port 3306 (standard port you may choose another if you see fit or run several servers on the same host). This is very much like a browser contacting a webserver via port 80 (again that is just the default). I am sure other members on this excellent list will fill in the gaps or correct me where I am in error. Best/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with MySQL-GUI
i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? = Original Message From R. Hannes Niedner [EMAIL PROTECTED] = On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote: running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? If I am not mistaken the socket works only for a connection between server and client running on the same host. It is more effective since it skips the network stacks and you can see it as a kind of shortcut. But whenever you connect from the outside (or use mysql -h localhost -P 3306 for the localhost connection) the communication between client and server happens via tcp/ip via port 3306 (standard port you may choose another if you see fit or run several servers on the same host). This is very much like a browser contacting a webserver via port 80 (again that is just the default). I am sure other members on this excellent list will fill in the gaps or correct me where I am in error. Best/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL-GUI
On 11/10/02 9:42 PM, daniel [EMAIL PROTECTED] wrote: i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? I guess I lost you. All I wanted to say is this: If you run mysql (client) and mysqld (server) on the same computer you can just type: 'mysql' on the command line and then the client automatically connects you to the server using the socket. The computer in this case is called 'localhost': local: because everything happens local, and is completely independent if you are connected to any network or not host: because your computer hosts the mysql server As soon as you connect to a mysql server running on a remote computer you can either telnet or ssh into that remote computer, call mysql and connect via the socket on that computer but in many cases (if you have remote connect privileges) you can just call: mysql -h the.remote.dbhost -P 3306 -u dbusername -p and use your local client (running on your computer) to connect to the mysqld (server) running on the remote computer and then you use tcp/ip and not the socket. ...but you knew all this anyway :-)/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql on windows
Hi, It's possible, to have some software/scripts which run in out of environment space. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Norris, Joseph [EMAIL PROTECTED] To: Mysql_List (E-mail) [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 7:32 PM Subject: problem with mysql on windows Group, We have been running along with little or no problems with mysql installed on windows 2000. Just recently I have been noticing a creation - great qty of creation of temp files in my script directories. I have all of my scripts on C drive with mysql on my D drive using junction to make a logical link from c to d for all mysql files in data directory. The temp files contain nothing, but still the question - why are they being created when they were not being created before. Any and all ideas appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysql jdbc Connector
janesh wrote: HI I am accessing mysql through Websphere 5.0 through jsp file . it says SQLException: Cannot connect to MySQL server on host:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) SQLState: 08S01 VendorError: 0 This exception is also listed in Your mysql driver Readme file , resolution for this is not clear. Since i am using same machine , and other parameters are correct , i am unable to find the solution Please get back to me with relevant solution. Thanks Janesh Does WebSphere 5.0 implement security policies? If so, you might not have a socket-connect security policy in your JSP. The java.security.AccessControlException is always thrown from a security manager. My guess is WebSphere 5.0 has a custom one or has configured the JVM to disallow socket access. You'll have to check your WebSphere-5.0 docs to see. I have run the driver in WebSphere-4.0 and WebSphere-5.0 developer edition with no issues, so it must be something related to your WebSphere config. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysql.
you need the ncurses libraries. Philippe Benchemoul wrote: Hi, I try to install mysql 3.23.52 on a debian 2.2.8 with the sources. ./configure --prefix=/usr/local/progs/mysql For the configure level, I have the message : checking for termcap functions library... configure: error: No curses/termcap library found I have tried to install termcap-compat with apt-get install termcap-compat but the problem isn't resolved. If you have an idea . Best regards. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling mysql-3.23.52
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 08 September 2002 02:25, Javier Suarez wrote: Im having a problem compiling the version of the subject, the problem is with the gethotsbyname function and the message is the next: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/opt/src/apache/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opt/src/apache/mysql-3.23.52' make: *** [all-recursive-am] Error 2 The system is Suse 8.0 and the Glibc is the glibc-2.2.5-38 Any solution or should I install the RPM from Suse? :-( Make sure that the GNU C++ compiler (package gpp) is installed and run configure again. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9e3aTSVDhKrJykfIRAj0WAJ9VlTx71gxGy5hfEIseDnfTrlcTowCfS6UR 2+G02aOAx0r9JCilji0Zyxo= =PdX6 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem Installing mysql-3.23.52
( mysql, query ) Can anyone help. I'm installing (at the mo) 4.0.3 Beta, but the error message is the same which ever version.. libmysql.c: In function `mysql_real_connect': libmysql.c:1675: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1675: too few arguments to function `gethostbyname_r' libmysql.c:1675: warning: assignment makes pointer from integer without a cast There's an argument mismatch; I don't have the source to this version so I can't help you. However, what architecture/compiler are you using? This might help the others help you :-) DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem Installing mysql-3.23.52
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 28 August 2002 22:53, Carlos Oyarzún wrote: I´m trying to install mysql-3.23.52 on a machine running RedHat 7.0. I´m using the following procedure: ./configure --prefix=/usr/local/mysql make make install The first two commands run fine, but run install gives me the following error, make[2]: *** [install-benchSCRIPTS] Error 1 make[2]: Leaving directory `/usr/local/mysql/sql-bench' make[1]: *** [install-am] Error 2 make[1]: Leaving directory `/usr/local/mysql/sql-bench' make: *** [install-recursive] Error 1 Does anyone know what the problem is? Actually, the interesting error messages are a bit above the snippet you posted. These ones alone do not give any clues... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9bd8sSVDhKrJykfIRApMJAJ9QsyJUD0CFp92kDzWcHhPPy0ydpACfeLuc XRb9jMRCZReHM5TUYR2GWUI= =KI/R -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysql making my server extremly slow
Magnet, Monday, August 19, 2002, 11:11:38 PM, you wrote: M I manage a web server having a lot of http connections, using M Apache/PHP/MySQL. When there are too many simultaneous connections (so, many M MySQL requests), MySQL stops working efficiently and makes my load average M increase a LOT (already seen it at 100 !). The only way to make it decrease M is to stop MySQL (I am forced to killall -9 mysqld, since it's the faster M way and I hardly can do much on the shell while the load is so high). M I am using MySQL server 3.53.52 (last stable), and it's working perfectly M when there is not too many SQL requests... but since it's a large website, M the problem happens each day at 9pm and we just cannot go on like this. M As the dedicated server (Linux Red Hat 7.2) is provided by a webhosting M company, MySQL was already installed when I got root access (although it was M 3.53.51), and I didn't change the my.cnf file (well, I tried but it wasn't M working anymore...). Here is my my.cnf file : M [magnet@ns3286 dev]$ cat /etc/my.cnf M [mysqld] M set-variable = connect_timeout=20 M set-variable = max_connections=100 M [magnet@ns3286 dev]$ M (yes I know it's short, tried to put a basic one but my tables weren't M read anymore...). M Well, I guess my problem is quite common, even if I didn't find any way to M fix it on the MySQL website! I'm sure there are some MySQL experts around M there able to help me without telling me to RTFM, since I did so (or tried, M since IMHO this manual is far from ergonomic). If someone is willing to help M me, and needs some information not listed there, just ask me, I will answer M asap... Can you send a list of processes? (mysqladmin processlist) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql threads on freebsd
On Tue, 11 Jun 2002 08:36:55 +0200 Leo De Geer [EMAIL PROTECTED] wrote: im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? from what method / tools, you get this information ? try mysqladmin -p status -- Linux is not user-friendly. It _is_ user-friendly. It is not ignorant-friendly and idiot-friendly. -- Seen somewhere on the net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php