Database thrash/load spikes under RedHat 7.1

2002-03-22 Thread Christopher Manly
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

Re: RedHat 7.1 refuses to open mysqld]

2001-09-25 Thread jim barchuk
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,

Re: The Mysql socket thing using Redhat 7.1

2001-09-05 Thread Ed Carp
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

Re: The Mysql socket thing using Redhat 7.1

2001-09-05 Thread Jason Bailey
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

Re: On Redhat 7.1

2001-09-05 Thread Sinisa Milivojevic
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

Re: On Redhat 7.1

2001-09-05 Thread Cristian Paslaru
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

Re: The Mysql socket thing using Redhat 7.1

2001-09-05 Thread Ed Carp
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

Re: The Mysql socket thing using Redhat 7.1

2001-09-05 Thread Jason Bailey
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

Re: The Mysql socket thing using Redhat 7.1

2001-09-05 Thread Trond Eivind Glomsrød
[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. --

Re: On Redhat 7.1

2001-09-04 Thread Sinisa Milivojevic
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

Re: On Redhat 7.1

2001-09-04 Thread Tony Bibbs
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

Re: On Redhat 7.1

2001-09-04 Thread Sinisa Milivojevic
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

Re: On Redhat 7.1

2001-09-04 Thread Trond Eivind Glomsrød
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

Re: On Redhat 7.1

2001-09-04 Thread Peter Harvey
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?

Re: On Redhat 7.1

2001-09-04 Thread Trond Eivind Glomsrød
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 (

The Mysql socket thing using Redhat 7.1

2001-09-04 Thread jason bailey
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

Re: The Mysql socket thing using Redhat 7.1

2001-09-04 Thread Trond Eivind Glomsrød
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

Re: On Redhat 7.1

2001-09-04 Thread Neil Zanella
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

On Redhat 7.1

2001-09-03 Thread Kalpesh Modha
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:

Re: On Redhat 7.1

2001-09-03 Thread Tony Bibbs
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

Re: On Redhat 7.1

2001-09-03 Thread Carl Troein
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

Re: On Redhat 7.1

2001-09-03 Thread Brett Geer
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.

Re: On Redhat 7.1

2001-09-03 Thread Trond Eivind Glomsrød
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

Re: On Redhat 7.1

2001-09-03 Thread Trond Eivind Glomsrød
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

Re: On Redhat 7.1

2001-09-03 Thread Tony Bibbs
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.

MySQL with Redhat 7.1

2001-07-23 Thread Adrian . Davis
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

Re: MySQL with Redhat 7.1

2001-07-23 Thread Trond Eivind Glomsrød
[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

MYSQL on RedHat 7.1.

2001-07-16 Thread Kalpesh Modha
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

Re: MYSQL on RedHat 7.1.

2001-07-16 Thread Dvoek Michal
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)

RE: MYSQL on RedHat 7.1.

2001-07-16 Thread Milos Rackov
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

Re: MYSQL on RedHat 7.1.

2001-07-16 Thread Nils O. Selåsdal
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

Re: redhat 7.1 setting up mysql

2001-06-27 Thread Trond Eivind Glomsrød
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

Re: redhat 7.1 setting up mysql

2001-06-27 Thread Luis
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

Problems with make on redhat 7.1

2001-06-15 Thread Greg Stienstra
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

Re: Problems with make on redhat 7.1

2001-06-15 Thread Trond Eivind Glomsrød
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