Database thrash/load spikes under RedHat 7.1
Hi, We just moved our operation to a new hosting company, and in the process went from an old version of Slackware linux running MySQL 3.22.xx to systems running RedHat 7.1 and MySQL 3.23.37. When I do a large LOAD DATA INFILE or something else that puts a tidbit of strain on the database, all of a sudden mysql spins out of control, with connections piling up and the load meter spiking, until we hit the connection limit and then things start to calm back down. But it means that our website is more or less unavailable for 15 minutes or so. The database is running on its own server, a 1GHz machine with 1 GB of RAM. The disk is SCSI RAID 5. I've tried cranking up the various tuning parameters, based on the my-huge.cnf that comes with the source distribution. The binary we're running on is the one that comes with the system. I've already tried --memlock, as I've seen reports of the 2.4 linux kernel causing problems when it gets overly agressive about swapping things out. I've also managed to make my RH 7.2 box do this on a smaller scale, running the latest binary RPM from MySQL. Am I missing something obvious? 99% of the time the server is completely bored. Given that we've doubled our RAM and doubled our processor speed on the same size database, there's no reason the server should be running out of gas. -- Christopher Manly Akademos, Inc. 438 West State Street Ithaca, New York 14850 607-269-0180 ext. 16 [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: RedHat 7.1 refuses to open mysqld]
HiHi! I upgraded from RedHat7.0 to 7.1. Now when I start safe_mysqld it says it starts mysql with databases from /var/lib/mysql, but it can't start completelety as it says it refers to /var/mysql/mysql.sock, which does not exist. Please help. /var/mys It's probably in /tmp, which you should change anyway. http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html Have a :) day! jb -- jim barchuk [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: The Mysql socket thing using Redhat 7.1
jason bailey ([EMAIL PROTECTED]) writes: I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. 1. Can i found out if the server is or is not running -which command and what am I looking for? mysqladmin status 2. Can I stop the mysql server mysqladmin shutdown 3. Can I start it? safe_mysqld Where is mysql.sock? In /tmp? If so: ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
Ed, Thanks for the email. I was a bit tired last night and was a little frustrated (4 nights getting nowhere), so apologies if I was little rude (I've just reread my email) and sarcastic, but thanks for the 'Details' pun. I've dug myself into a hole offering to set up a Linux/Apache Webserver for a friend. There's no rush but wanted to use it as a learning experience and am getting problems with mysql- everything else seems ok. jason bailey ([EMAIL PROTECTED]) writes: I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. Yes, thanks for the pun. It was the above /var/lib/mysql/mysql.sock and I noted that deleting it and then running mysql_install_db or possible safe_mysqld recreated. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. Slightly sarcastic- sorry 1. Can i found out if the server is or is not running -which command and what am I looking for? mysqladmin status As I remember and I'm not sure I was going round in circles- this was a call giving the error- I've just read somewhere to check that this is installed, so will do that tonight 2. Can I stop the mysql server mysqladmin shutdown Again an error on that one 3. Can I start it? safe_mysqld Yep it does produces a lot of information and then ends (I think- you see I'm not sure) Where is mysql.sock? In /tmp? If so: ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock mysql.sock is in the directory that the error produces i.e. /var/lib/mysql/mysql.sock ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. This, in my ignorance, looks like a soft link to the mysql.sock in the /var/lib/mysql/mysql.sock location. The file(?) does exist and I'm not sure why a softlink will help unless it's something to do with permissions. Thanks for your suggestions I'll give them a try. Regards Jason Dr Jason Bailey Desktop Applications Consultant Computing Service The University of Sussex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Neil Zanella writes: On Tue, 4 Sep 2001, Sinisa Milivojevic wrote: Red Hat 7.1 has a very nice apache + mysql + php installation and invoking mysql function calls from the php interface works very well. The only aspect that puzzles me a little bit is that when I look at the output of phpinfo(); I see a --without-mysql flag as a configure switch. How is this possible? Thanks, Neil I truly do not know. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
On Wed, 5 Sep 2001, Sinisa Milivojevic wrote: Red Hat 7.1 has a very nice apache + mysql + php installation and invoking mysql function calls from the php interface works very well. The only aspect that puzzles me a little bit is that when I look at the output of phpinfo(); I see a --without-mysql flag as a configure switch. How is this possible? PHP is configured with --without-mysql flag to not be compiled in main PHP. And after that is compiled only mysql module of PHP. You can see php-4...rpm and php-mysql-4...rpm. Is more easy to see if you will look in spec file. -- Cristian Paslaru http://devel.iasi.ro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
Jason Bailey ([EMAIL PROTECTED]) writes: You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. Yes, thanks for the pun. It was the above /var/lib/mysql/mysql.sock and I noted that deleting it and then running mysql_install_db or possible safe_mysqld recreated. Well, it wasn't a pun :) Details are critically important, especially when you work with complex systems like these. I was commenting on the lack of detail in your post - you ran something and something happened, but you weren't quite sure what. It's much more difficult when people have to guess what you did. I'm not trying to flame you at all - but you will probably be able to get a lot more, and a lot higher quality, help if you can supply as much detail as possible. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. Slightly sarcastic- sorry No, this really *is* a bad idea! The mysql.sock file is created by the server - if you delete it, you will not be able to connect locally. ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. This, in my ignorance, looks like a soft link to the mysql.sock in the /var/lib/mysql/mysql.sock location. The file(?) does exist and I'm not sure why a softlink will help unless it's something to do with permissions. If the server is creating mysql.sock in /var/lib/mysql and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
Ed, Once again, thanks for the email response. I'm going to try all the suggestions I've received. A colleague has suggested as I'm new to Linux to select the 'Install Everything' option in red hat 7.1. He suggests that it's probably easier (for me) to get everything installed and work backward (uninstall the unnecessary) as I learn more. If the server is creating mysql.sock in and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- I think this may be my problem in that I couldn't understand whether mysql.sock should be located in /var/lib/mysql but is required to be in /tmp. It certainly appears in /var/lib/mysql I'll try your suggestion for this and check permissions. Well, it wasn't a pun :) Details are critically important, especially when you work with complex systems like these. I was commenting on the lack of detail in your post - My mistake about the Pun. I do agree details are important; I will use mysqlbug next time, if I get no joy. I'd found several, if not more, postings from several people with the same type of question, regarding the error I was getting. I'd assumed that this common problem was well understood and didn't require explicit detail from myself. you ran something and something happened, but you weren't quite sure what. It's much more difficult when people have to guess what you did. I'm not trying to flame you at all - but you will probably be able to get a lot more, and a lot higher quality, help if you can supply as much detail as possible. I would'nt blame you for flaming my first email was a little rude. The detail I will try for next time. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. Slightly sarcastic- sorry No, this really *is* a bad idea! The mysql.sock file is created by the server - if you delete it, you will not be able to connect locally. I'd been sarcastic and was apologising. I realised it was a bad idea but was getting frustrated and wanted to see if it would be recreated as a test if I was running the server at all. On deleting it I was finding that it was being recreated when running something. Something- I wasn't sure about at the time either mysql_install_db or safe_mysqld - still not sure but will check tonight when I get home. Dr Jason Bailey Desktop Applications Consultant Computing Service The University of Sussex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
[EMAIL PROTECTED] (Jason Bailey) writes: If the server is creating mysql.sock in and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- I think this may be my problem in that I couldn't understand whether mysql.sock should be located in /var/lib/mysql but is required to be in /tmp. It certainly appears in /var/lib/mysql I'll try your suggestion for this and check permissions. As written before, it is a permissions problem - mysql_install_db (unnecesarry , don't run it - just run service mysqld start ) will create files owned by root. If you look in the default /etc/my.cnf, the database runs as user mysql (for security reasons). To fix it, do a chown -R mysql.mysql /var/lib/mysql If you had started mysql the same way you start other services (httpd, samba, etc) via tksysv/ntsysv(permanently, on every boot) or service httpd start (do it right now - equivalent to /etc/init.d/httpd start), it would have created the database with correct permissions automatically. mysql_install_db and safe_mysqld aren't necesarry, and will often cause problems. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Trond Eivind Glomsrød writes: Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. We do compile in support for MySQL, but it's in the php-mysql package - just as at support for PostgreSQL is in php-pgsql. -- Trond Eivind Glomsrød Red Hat, Inc. Just a small note from our side. We from MySQL have not noticed a single and slightest inclination of Red Hat towards PostgreSQL so far, when it comes to RH distros. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
I guess where it can get confusing is when a stock RH7.1 install with PHP doesn't have mysql support enabled but postgresql is. To the uninformed user like me who doesn't care to know the individual RPMS in the distro it is easy to make that, obviously wrong, assumption when, by default, the php-postgres RPM is installed. On a lighter note, I am glad to know the php-mysql RPM is on the RH discs...makes future installs a tad bit easier. Sorry for causing such a stir, --Tony On Tue, 4 Sep 2001, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. We do compile in support for MySQL, but it's in the php-mysql package - just as at support for PostgreSQL is in php-pgsql. -- Trond Eivind Glomsrød Red Hat, Inc. Just a small note from our side. We from MySQL have not noticed a single and slightest inclination of Red Hat towards PostgreSQL so far, when it comes to RH distros. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Tony Bibbs writes: I guess where it can get confusing is when a stock RH7.1 install with PHP doesn't have mysql support enabled but postgresql is. To the uninformed user like me who doesn't care to know the individual RPMS in the distro it is easy to make that, obviously wrong, assumption when, by default, the php-postgres RPM is installed. On a lighter note, I am glad to know the php-mysql RPM is on the RH discs...makes future installs a tad bit easier. Sorry for causing such a stir, --Tony Truly, no problems. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Tony Bibbs [EMAIL PROTECTED] writes: I guess where it can get confusing is when a stock RH7.1 install with PHP doesn't have mysql support enabled but postgresql is. That depends on what you install. MySQL isn't (like many other packages) in any of the premade installation categories - you can select it in a custom install, or do a everything install. To the uninformed user like me who doesn't care to know the individual RPMS in the distro it is easy to make that, obviously wrong, assumption when, by default, the php-postgres RPM is installed. It's not installed by default either, but if you select both the postgresql and the web server components you'll get it. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
That depends on what you install. MySQL isn't (like many other packages) in any of the premade installation categories - you can select it in a custom install, or do a everything install. I bet a product like Data Architect ( http://www.codebydesign.com ) would be a great fit in this distro? It supports all features of MySQL... table options... column types and options... etc. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.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: On Redhat 7.1
Peter Harvey [EMAIL PROTECTED] writes: That depends on what you install. MySQL isn't (like many other packages) in any of the premade installation categories - you can select it in a custom install, or do a everything install. I bet a product like Data Architect ( http://www.codebydesign.com ) would be a great fit in this distro? It supports all features of MySQL... table options... column types and options... etc. Looks interesting, as it supports PostgreSQL, MySQL and ODBC. We're not adding packages right now, but I've bookmarked it. Didn't find anything about licensing and such, though. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The Mysql socket thing using Redhat 7.1
HI, I'm a new user to Linux and am interested in MySQL and PHP. I currently use both as a developer elsewhere and am now trying to set up a test server at home. I've searched the MYSQL lists and notice that alot of people are getting a similar problem as myself and I'm not sure if any have got this to work. I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) I've read through the manual about problems starting a server but this has not helped and I've tried to follow help in the lists but again no result. I run mysql_install_db and get the messages about starting up I run safe_mysqld and get something about starting and stopping I've found the the mysql.sock and it's in the location that the error mentions the location of the sock thing?? (It's late and I'm tired and a bit fed up -after being told to forget windows and go to Linux- I really wanted to agree but am now finding it hard too!) I've deleted it and running something above has brought it back again!- this is good I think I've uninstalled mysql and reinstalled the client, server etc but still the same error People keep responding about starting up or restarting the server. Someone has mentioned Services Mqsqld Start which does something but every single time I try mysql I get that error. I'm just going round in circles now. Can someone give me some help. 1. Can i found out if the server is or is not running -which command and what am I looking for? 2. Can I stop the mysql server 3. Can I start it? Using anything to do with mysql or mysqladmin results in the error. I'm currently reading about something to do with configure how ??? Please please please help Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
jason bailey [EMAIL PROTECTED] writes: HI, I'm a new user to Linux and am interested in MySQL and PHP. I currently use both as a developer elsewhere and am now trying to set up a test server at home. I've searched the MYSQL lists and notice that alot of people are getting a similar problem as myself and I'm not sure if any have got this to work. I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) I've read through the manual about problems starting a server but this has not helped and I've tried to follow help in the lists but again no result. I run mysql_install_db and get the messages about starting up I run safe_mysqld and get something about starting and stopping I've found the the mysql.sock and it's in the location that the error mentions the location of the sock thing?? (It's late and I'm tired and a bit fed up -after being told to forget windows and go to Linux- I really wanted to agree but am now finding it hard too!) You shouldn't have done mysql_install_db (which creates db files, owned by root) and safe_mysqld (which will start the database as user mysql, who can't read or write to the necesarry files). Do a chown -R mysql.mysql /var/lib/mysql, then start the database with service mysqld start. If you had done this (or just selected it to start in one of the runlevel managers, like ntsysv or tksysv), it would have initialized the database automatically. To make mysqld start on every boot, do chkconfig mysqld start. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
On Tue, 4 Sep 2001, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. Red Hat 7.1 has a very nice apache + mysql + php installation and invoking mysql function calls from the php interface works very well. The only aspect that puzzles me a little bit is that when I look at the output of phpinfo(); I see a --without-mysql flag as a configure switch. How is this possible? Thanks, Neil - 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
On Redhat 7.1
Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. ANy ideas thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
7.1 doesn't install php with mysql support enabled. You'll need to install the source rpm, edit the php.spec file and do a rpm -bb php.spec and install the resulting rpms. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. --Tony On Sun, 2 Sep 2001, Kalpesh Modha wrote: Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. ANy ideas thanks in advance. - 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: On Redhat 7.1
Kalpesh Modha writes: I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. Are you trying to connect via TCP to a server started with --skip-networking? Are you connecting to the right port? Does it work when you use unix sockets instead of TCP/IP? Can you connect using the command line client (mysql)? That's all I can think of. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Sure it does, what version, what error? brett Kalpesh Modha wrote: Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. ANy ideas thanks in advance. - 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 -- UNIX Ad/DBA/Teaboy/Analyst/Gopher - Intratex Holdings - Pinetown Tel. +27 31 717 4000/4146 Fax. +27 31 717 4001 Rule 1. Before calling me... if its a Windows box... REBOOT IT! Rule 2. If its a Windows box... Don't call me... Rule 3. Windows isn't much good for anything aside from games. Rule 4. Repeat. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Kalpesh Modha [EMAIL PROTECTED] writes: Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. You need to install the php-mysql package, which contains the module PHP needs to support MySQL. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. We do compile in support for MySQL, but it's in the php-mysql package - just as at support for PostgreSQL is in php-pgsql. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Thanks for clearing that up with me...didn't know that. --Tony On 3 Sep 2001, Trond Eivind Glomsrød wrote: Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. We do compile in support for MySQL, but it's in the php-mysql package - just as at support for PostgreSQL is in php-pgsql. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL with Redhat 7.1
I have installed Redhat Linux 7.1 with the supplied MySQL distribution (3.23.36?). I've run the mysql_install_db script, but when I try to start MySQL using ./bin/safe_mysqld --user=mysql , from the installation directory, MySQL starts then ends immedately (MySQL ends) without an error!! The user mysql exists (Created by the install). Are there any other actions I need to do before trying to start MySQL? Can anybody help? Many Thanks, =Adrian= Information in this message is confidential and may also be legally privileged. It is intended solely for the person to whom it is addressed. If you are not the intended recipient, please notify the sender, and then please delete the message from your system immediately. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with Redhat 7.1
[EMAIL PROTECTED] writes: I have installed Redhat Linux 7.1 with the supplied MySQL distribution (3.23.36?). I've run the mysql_install_db script, but when I try to start MySQL using ./bin/safe_mysqld --user=mysql , from the installation directory, MySQL starts then ends immedately (MySQL ends) without an error!! 1) Don't run mysql_install_db or safe_mysqld directly - use service mysqld start, it will automatically initialize the database 2) When you run mysql_install_db, you create the files as root - later, you try to run the database as mysql. This user won't have access to your files. To fix it, do chown -R mysql.mysql /var/lib/mysql. And you should run mysql with service mysqld start in the future - or just enable it by default, with chkconfig mysqld on -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL on RedHat 7.1.
Hello. I am trying to get mysql working on RedHat 7.1 and it works fine however, when I try to make a local connection from either Java or PHP. I get a connection refused message. Whats missing ? Thanks for your help in advance. Regards Kal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL on RedHat 7.1.
Hi, try check your permission in your MySQL and in scripts. S pozdravem Michal Dvoracek [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: MYSQL on RedHat 7.1.
Most likely that there is a problem with where PHP and Java are looking for the socket. One more possibility (I don't know for Java, but for PHP) - you need to install a php-mysql (or mysql-php) package. Regards, Milos Rackov From: Kalpesh Modha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: MYSQL on RedHat 7.1. Hello. I am trying to get mysql working on RedHat 7.1 and it works fine however, when I try to make a local connection from either Java or PHP. I get a connection refused message. Whats missing ? Thanks for your help in advance. Regards Kal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL on RedHat 7.1.
On Monday 16 July 2001 15:03, Kalpesh Modha wrote: Hello. I am trying to get mysql working on RedHat 7.1 and it works fine however, when I try to make a local connection from either Java or PHP. I get a connection refused message. Whats missing ? Thanks for your help in advance. You need to grant the user you are connecting as the appropriate rights from the appropriate host. The jdbc driver uses the default mysql port when connecting(check that mysql are listening to the default port), and if you also connect from the same machine as you run the server, the client will be connecting from 'localhost', or the hostname of your computer, the stacktrace from your javaprogram, or a mysql logfile should tell you which host. So you need to grant the user in question the right to connect to the server from 'localhost'. MySQL manual will tell you how to fo that. -- Nils O. Selåsdal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: redhat 7.1 setting up mysql
wkd [EMAIL PROTECTED] writes: 1. (*) text/plain I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in the past I've had problems with the setup. I had a person come in and setup mysql on redhat 6.0 ( 2 1/2 days later he had it running) the program has been riddle with bugs. The questions are: ( note: mysql is not installed on my computer from redhat. I've had problems with the default setting that come with redhat in the past and did not install then). 1) what rpm files should I used and is there an order to them? mysql and mysql-server (mysql-devel for program development) - just install the rpms (rpm -Uvh mysql mysql-server) and start the service (service mysqld start, which will initialize the database for the first time and start the server) 2) when installing rpm files can you or how can you tell the program where to install the program? This information is embedded in the package - there is a relocate switch, but for most packages this can create some unexpected results -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: redhat 7.1 setting up mysql
Trond Eivind Glomsrød wrote: wkd [EMAIL PROTECTED] writes: 1. (*) text/plain I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in the past I've had problems with the setup. I had a person come in and setup mysql on redhat 6.0 ( 2 1/2 days later he had it running) the program has been riddle with bugs. The questions are: ( note: mysql is not installed on my computer from redhat. I've had problems with the default setting that come with redhat in the past and did not install then). 1) what rpm files should I used and is there an order to them? mysql and mysql-server (mysql-devel for program development) - just install the rpms (rpm -Uvh mysql mysql-server) and start the service (service mysqld start, which will initialize the database for the first time and start the server) 2) when installing rpm files can you or how can you tell the program where to install the program? This information is embedded in the package - there is a relocate switch, but for most packages this can create some unexpected results -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Well the rpm that came with rh 7.1 dont use. Download it from the net. but download the lower case one. I have a link on how to setup apache, mysql and php click on the link below it should show you how to do it. http://www.php.net/manual/en/install.apache.php good luck let me know if you need help with it. Once again i started the mysql book, since i been putting it off. kind of like it. - 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
Problems with make on redhat 7.1
I have been unsuccessful doing a make for mysql-3-23.29 using redhat 7.1 on an Intel Pentium with 64 megabytes. There seems to be a problem with file db.h. I am doing the install from the source tarball mysql-3.23.39.tar.gz , not the RPM. Here is an excerpt from the session: (lines cut, including ./Configure) Making all in share make[3]: Entering directory `/otheros/download/mysql-3.23.39/sql/share' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/otheros/download/mysql-3.23.39/sql/share' make[3]: Entering directory `/otheros/download/mysql-3.23.39/sql' make[3]: *** No rule to make target `../bdb/build_unix/db.h', needed by `mysqld.o'. Stop. make[3]: Leaving directory `/otheros/download/mysql-3.23.39/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/otheros/download/mysql-3.23.39/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/otheros/download/mysql-3.23.39' make: *** [all-recursive-am] Error 2 [root@junco mysql-3. Any assistance in solving this problem would be appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with make on redhat 7.1
Greg Stienstra [EMAIL PROTECTED] writes: I have been unsuccessful doing a make for mysql-3-23.29 using redhat 7.1 on an Intel Pentium with 64 megabytes. There seems to be a problem with file db.h. I am doing the install from the source tarball mysql-3.23.39.tar.gz , not the RPM. It compiles just fine for me, so this is most likely a local configuration issue. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
