Re: Problem with management server communication.
I have the same problem. I have an open bug report here: http://bugs.mysql.com/?id=4761 I can't figure out why my management server can not see my ndb servers. Perhaps I should try to down the secondary interface on all the servers? On Tue, 17 Aug 2004 15:54:29 -0400, Wheeler, Alex [EMAIL PROTECTED] wrote: Yes, now I remember. This happens when I have either 2 interfaces or a disagreement on hostname. If the clients don't see the server or themselves by the same hostname as the server, this type of error can be seen. I've been setup with a node that did the initial communication via eth1 but then tried the remainder via eth0 which corresponded with the hostname, and which obviously didn't work. I ended up temporarily changing the hostname to reference the eth1 ip. -- Alex Wheeler -Original Message- From: IHLING, CHRIS G (CHRIS) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 3:43 PM To: IHLING, CHRIS G (CHRIS) Cc: [EMAIL PROTECTED] Subject: RE: Problem with management server communication. I have no problem pinging either box from both. There is one other strange thing. If I try to use a fully qualified hostname or ip address in the config file I get an error when I try to start the ndbd. -Original Message- From: Jonas Oreland [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 11:42 AM To: IHLING, CHRIS G (CHRIS) Cc: [EMAIL PROTECTED] Subject: Re: Problem with management server communication. Hi, Also make sure that both hostnames are accessible from both computers. I.e. that you can ping both lpsdev3-n1 lpsdev3-n2 from both lpsdev3-n1 lpsdev3-n2 /Jonas IHLING, CHRIS G (CHRIS) wrote: I have removed the [TCP] section from my config file and I am still seeing the same no contact message. Here is the config file I am using: [COMPUTER] Id:1 ByteOrder: Little HostName: lpsdev3-n2 [COMPUTER] Id:2 ByteOrder: Little HostName: lpsdev3-n1 [MGM] Id:1 ExecuteOnComputer: 1 PortNumber: 2200 ArbitrationRank: 1 [DB DEFAULT] NoOfReplicas:2 FileSystemPath: /usr/lps/mysql/data1 [DB] Id:2 ExecuteOnComputer:1 [DB] Id:3 ExecuteOnComputer:2 [API] Id:4 ExecuteOnComputer:1 [API] Id:5 ExecuteOnComputer:2 Is there any way to turn on tracing or check logs to find out more info? -Original Message- From: Wheeler, Alex [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 10:08 AM To: [EMAIL PROTECTED] Subject: RE: Problem with management server communication. I've seen this kind of error before, and if I recall correctly it's due to a misconfiguration of the TCP information. So, if you have any TCP entries in the config.ini file such as [TCP]NodeId1:..., remove them as they are automatically configured anyway. Then stop the nodes, and start again. Make sure you use the -i when starting the clients. -- Alex Wheeler -Original Message- From: IHLING, CHRIS G (CHRIS) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 12:27 PM To: '[EMAIL PROTECTED]' Subject: Problem with management server communication. I am having a problem with the management server getting status from a ndbd started on another machine. The ndbd server will start and report status fine if it is running on the same machine as the management server. The ndbd server will start on a different machine but no status is reported. If the management server is not running ndbd will not start so there must be some kind of communication just no status. Any suggestions on what to try? -- Jonas Oreland, Software Engineer MySQL AB, www.mysql.com -- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster 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 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]
Problem starting mysql server
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. -- 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 starting 4.0.12 server
Yes, probably. I've never used a mysql rpm, so I don't know how they're packaged. /var/lib/mysql is an odd place to stick that socket though. I've always seen it in /tmp or someplace similar (and world readable). errno = 13 -- Permission denied Make sure that directory is owned by mysql, ie $ chown mysql database dir $ chmod 700 database dir It seems rather odd that an rpm would stick anything in /ul/mysql. Did you move the stuff there and create a symbolic link to it? That won't necessarily perserve permissions and ownership. If you're having that much trouble with the rpm, a source build may or may not be what you're looking for. I'd go that route, but any of my co-workers can attest to the fact that I'm an obsessive compiler. -jeff On Wed, 2003-03-26 at 15:49, Saul wrote: From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 25 Mar 2003 21:08:56 -0600 Does the mysql user have permission to write to /var/lib/mysql? -jeff Well, it didn't. But, shouldn't it have been set that way after the rpm package was installed? Now, it says: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030326 16:39:58 Aborting datadir is set to /var/lib/mysql which is a symbolic link to /u1/mysql. For what it's worth, I've been having a lot of problems with mysql. I had mysql 3.23 installed, and was testing a message board (phpBB2) for use with mysql. When I went to make the board production, I used mysqladmin to drop the database I had been using for testing, and then to create a new database (different name) for production. When I tried to run the phpBB2 installer against the new database, it failed. I couldn't figure out what happened; following the same installation instructions, I was getting weird error after weird error. So, I figured I would start from scratch. I figured as long as I was doing that, I would start with mysql 4... and have been having problem, after problem, after problem. I worked for over a week from the sources and got nowhere and then I saw that this release finally hit production and am starting all over again... and here I am unable to run mysql... Does the mysql user have permission to write to /var/lib/mysql? -jeff On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote: Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm files, server won't start. The error (from the log) is: 030325 21:23:41 mysqld started 030325 21:23:41 Can't start server : Bind on unix socket: Permission denied 030325 21:23:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 030325 21:23:41 Aborting 030325 21:23:41 /usr/sbin/mysqld: Shutdown Complete 030325 21:23:41 mysqld ended I've checked, and /var/lib/mysql/mysql.sock doesn't exist. Shouldn't the server create it? How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Saul Organization: Saul Jaffe [EMAIL PROTECTED] MySQL support: [none | licence | email support | extended email support ] Synopsis: Can't start server Severity: serious Priority: high Category: mysql Class:support Release: mysql-4.0.12 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux sflovers.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 13 2001 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Aug 13 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
Re: Problem starting 4.0.12 server
From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 25 Mar 2003 21:08:56 -0600 Does the mysql user have permission to write to /var/lib/mysql? -jeff Well, it didn't. But, shouldn't it have been set that way after the rpm package was installed? Now, it says: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030326 16:39:58 Aborting datadir is set to /var/lib/mysql which is a symbolic link to /u1/mysql. For what it's worth, I've been having a lot of problems with mysql. I had mysql 3.23 installed, and was testing a message board (phpBB2) for use with mysql. When I went to make the board production, I used mysqladmin to drop the database I had been using for testing, and then to create a new database (different name) for production. When I tried to run the phpBB2 installer against the new database, it failed. I couldn't figure out what happened; following the same installation instructions, I was getting weird error after weird error. So, I figured I would start from scratch. I figured as long as I was doing that, I would start with mysql 4... and have been having problem, after problem, after problem. I worked for over a week from the sources and got nowhere and then I saw that this release finally hit production and am starting all over again... and here I am unable to run mysql... Does the mysql user have permission to write to /var/lib/mysql? -jeff On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote: Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm files, server won't start. The error (from the log) is: 030325 21:23:41 mysqld started 030325 21:23:41 Can't start server : Bind on unix socket: Permission denied 030325 21:23:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 030325 21:23:41 Aborting 030325 21:23:41 /usr/sbin/mysqld: Shutdown Complete 030325 21:23:41 mysqld ended I've checked, and /var/lib/mysql/mysql.sock doesn't exist. Shouldn't the server create it? How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Saul Organization: Saul Jaffe [EMAIL PROTECTED] MySQL support: [none | licence | email support | extended email support ] Synopsis: Can't start server Severity: serious Priority: high Category: mysql Class: support Release:mysql-4.0.12 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux sflovers.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 13 2001 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Aug 13 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- Saul Jaffe Mouch Potato [EMAIL PROTECTED] To a touch typist, having the space bar workonly 30% of the time, is damned frustrating. So, insert spaces as needed to make this message make sense. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem starting 4.0.12 server
From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 26 Mar 2003 16:03:38 -0600 Yes, probably. I've never used a mysql rpm, so I don't know how they're packaged. /var/lib/mysql is an odd place to stick that socket though. I've always seen it in /tmp or someplace similar (and world readable). That appears to be the default location. errno = 13 -- Permission denied Make sure that directory is owned by mysql, ie $ chown mysql database dir $ chmod 700 database dir Actually, it was 755... and owned by mysql, group mysql. It seems rather odd that an rpm would stick anything in /ul/mysql. Did you move the stuff there and create a symbolic link to it? That won't necessarily perserve permissions and ownership. I had created /u1/mysql and put a link to it when I installed 3.23. As I said, I had tested with that and everything worked fine. All I did was, after blowing away the databases, and uninstalling 3.23, was to install 4.0.12. I started with the sources and had problems. When the rpms came out, I thought the prebuilt versions would solve my problem as the prebuilt version worked before. If you're having that much trouble with the rpm, a source build may or may not be what you're looking for. I'd go that route, but any of my co-workers can attest to the fact that I'm an obsessive compiler. Well, I could... except that the documentation, as far as I'm concerned, leaves a lot to be desired. -jeff On Wed, 2003-03-26 at 15:49, Saul wrote: From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 25 Mar 2003 21:08:56 -0600 Does the mysql user have permission to write to /var/lib/mysql? -jeff Well, it didn't. But, shouldn't it have been set that way after the rpm package was installed? Now, it says: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030326 16:39:58 Aborting datadir is set to /var/lib/mysql which is a symbolic link to /u1/mysql. For what it's worth, I've been having a lot of problems with mysql. I had mysql 3.23 installed, and was testing a message board (phpBB2) for use with mysql. When I went to make the board production, I used mysqladmin to drop the database I had been using for testing, and then to create a new database (different name) for production. When I tried to run the phpBB2 installer against the new database, it failed. I couldn't figure out what happened; following the same installation instructions, I was getting weird error after weird error. So, I figured I would start from scratch. I figured as long as I was doing that, I would start with mysql 4... and have been having problem, after problem, after problem. I worked for over a week from the sources and got nowhere and then I saw that this release finally hit production and am starting all over again... and here I am unable to run mysql... Does the mysql user have permission to write to /var/lib/mysql? -jeff On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote: Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm files, server won't start. The error (from the log) is: 030325 21:23:41 mysqld started 030325 21:23:41 Can't start server : Bind on unix socket: Permission denied 030325 21:23:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 030325 21:23:41 Aborting 030325 21:23:41 /usr/sbin/mysqld: Shutdown Complete 030325 21:23:41 mysqld ended I've checked, and /var/lib/mysql/mysql.sock doesn't exist. Shouldn't the server create it? How-To-Repeat: Fix: Submitter-Id:submitter ID Originator: Saul Organization: Saul Jaffe [EMAIL PROTECTED] MySQL support: [none | licence | email support | extended email support ] Synopsis:Can't start server Severity:serious Priority:high Category:mysql Class: support Release: mysql-4.0.12 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux sflovers.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O6
Re: Problem starting 4.0.12 server
From: Jeff Kilbride [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Date: Wed, 26 Mar 2003 15:44:49 -0800 Make sure that all the files inside your database directories are owned by mysql: chown -R mysql. database dir The dot at the end of mysql above sets the group to mysql also. The -R means set the permissions recursively. Each time I install a binary distribution and run the scripts/mysql_install_db script, I have to do this or I get the error you've gotten. The mysql daemon needs to be able to read and write these files. Been a unix person for years. Know this... didn't help. Deleted the link. Recreated the link. Then it worked. Don't know why. Now, I just get cannot connect to database anytime trying to connect from inside php... may have to rebuild php... Already rebuilt the Perl modules... --jeff - Original Message - From: Saul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:10 PM Subject: Re: Problem starting 4.0.12 server From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 26 Mar 2003 16:03:38 -0600 Yes, probably. I've never used a mysql rpm, so I don't know how they're packaged. /var/lib/mysql is an odd place to stick that socket though. I've always seen it in /tmp or someplace similar (and world readable). That appears to be the default location. errno = 13 -- Permission denied Make sure that directory is owned by mysql, ie $ chown mysql database dir $ chmod 700 database dir Actually, it was 755... and owned by mysql, group mysql. It seems rather odd that an rpm would stick anything in /ul/mysql. Did you move the stuff there and create a symbolic link to it? That won't necessarily perserve permissions and ownership. I had created /u1/mysql and put a link to it when I installed 3.23. As I said, I had tested with that and everything worked fine. All I did was, after blowing away the databases, and uninstalling 3.23, was to install 4.0.12. I started with the sources and had problems. When the rpms came out, I thought the prebuilt versions would solve my problem as the prebuilt version worked before. If you're having that much trouble with the rpm, a source build may or may not be what you're looking for. I'd go that route, but any of my co-workers can attest to the fact that I'm an obsessive compiler. Well, I could... except that the documentation, as far as I'm concerned, leaves a lot to be desired. -jeff On Wed, 2003-03-26 at 15:49, Saul wrote: From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 25 Mar 2003 21:08:56 -0600 Does the mysql user have permission to write to /var/lib/mysql? -jeff Well, it didn't. But, shouldn't it have been set that way after the rpm package was installed? Now, it says: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030326 16:39:58 Aborting datadir is set to /var/lib/mysql which is a symbolic link to /u1/mysql. For what it's worth, I've been having a lot of problems with mysql. I had mysql 3.23 installed, and was testing a message board (phpBB2) for use with mysql. When I went to make the board production, I used mysqladmin to drop the database I had been using for testing, and then to create a new database (different name) for production. When I tried to run the phpBB2 installer against the new database, it failed. I couldn't figure out what happened; following the same installation instructions, I was getting weird error after weird error. So, I figured I would start from scratch. I figured as long as I was doing that, I would start with mysql 4... and have been having problem, after problem, after problem. I worked for over a week from the sources and got nowhere and then I saw that this release finally hit production and am starting all over again... and here I am unable to run mysql... Does the mysql user have permission to write to /var/lib/mysql? -jeff On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote: Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm
Re: Problem starting 4.0.12 server
Make sure that all the files inside your database directories are owned by mysql: chown -R mysql. database dir The dot at the end of mysql above sets the group to mysql also. The -R means set the permissions recursively. Each time I install a binary distribution and run the scripts/mysql_install_db script, I have to do this or I get the error you've gotten. The mysql daemon needs to be able to read and write these files. --jeff - Original Message - From: Saul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:10 PM Subject: Re: Problem starting 4.0.12 server From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 26 Mar 2003 16:03:38 -0600 Yes, probably. I've never used a mysql rpm, so I don't know how they're packaged. /var/lib/mysql is an odd place to stick that socket though. I've always seen it in /tmp or someplace similar (and world readable). That appears to be the default location. errno = 13 -- Permission denied Make sure that directory is owned by mysql, ie $ chown mysql database dir $ chmod 700 database dir Actually, it was 755... and owned by mysql, group mysql. It seems rather odd that an rpm would stick anything in /ul/mysql. Did you move the stuff there and create a symbolic link to it? That won't necessarily perserve permissions and ownership. I had created /u1/mysql and put a link to it when I installed 3.23. As I said, I had tested with that and everything worked fine. All I did was, after blowing away the databases, and uninstalling 3.23, was to install 4.0.12. I started with the sources and had problems. When the rpms came out, I thought the prebuilt versions would solve my problem as the prebuilt version worked before. If you're having that much trouble with the rpm, a source build may or may not be what you're looking for. I'd go that route, but any of my co-workers can attest to the fact that I'm an obsessive compiler. Well, I could... except that the documentation, as far as I'm concerned, leaves a lot to be desired. -jeff On Wed, 2003-03-26 at 15:49, Saul wrote: From: Jeff Kilpatrick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Organization: Date: 25 Mar 2003 21:08:56 -0600 Does the mysql user have permission to write to /var/lib/mysql? -jeff Well, it didn't. But, shouldn't it have been set that way after the rpm package was installed? Now, it says: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030326 16:39:58 Aborting datadir is set to /var/lib/mysql which is a symbolic link to /u1/mysql. For what it's worth, I've been having a lot of problems with mysql. I had mysql 3.23 installed, and was testing a message board (phpBB2) for use with mysql. When I went to make the board production, I used mysqladmin to drop the database I had been using for testing, and then to create a new database (different name) for production. When I tried to run the phpBB2 installer against the new database, it failed. I couldn't figure out what happened; following the same installation instructions, I was getting weird error after weird error. So, I figured I would start from scratch. I figured as long as I was doing that, I would start with mysql 4... and have been having problem, after problem, after problem. I worked for over a week from the sources and got nowhere and then I saw that this release finally hit production and am starting all over again... and here I am unable to run mysql... Does the mysql user have permission to write to /var/lib/mysql? -jeff On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote: Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm files, server won't start. The error (from the log) is: 030325 21:23:41 mysqld started 030325 21:23:41 Can't start server : Bind on unix socket: Permission denied 030325 21:23:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 030325 21:23:41 Aborting 030325 21:23:41 /usr/sbin/mysqld: Shutdown Complete 030325 21:23:41 mysqld ended I've checked, and /var/lib/mysql/mysql.sock doesn't exist. Shouldn't the server create it? How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Saul Organization: Saul Jaffe [EMAIL PROTECTED] MySQL support: [none | licence | email support | extended email support ] Synopsis: Can't start server Severity
Problem starting 4.0.12 server
Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm files, server won't start. The error (from the log) is: 030325 21:23:41 mysqld started 030325 21:23:41 Can't start server : Bind on unix socket: Permission denied 030325 21:23:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 030325 21:23:41 Aborting 030325 21:23:41 /usr/sbin/mysqld: Shutdown Complete 030325 21:23:41 mysqld ended I've checked, and /var/lib/mysql/mysql.sock doesn't exist. Shouldn't the server create it? How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Saul Organization: Saul Jaffe [EMAIL PROTECTED] MySQL support: [none | licence | email support | extended email support ] Synopsis: Can't start server Severity: serious Priority: high Category: mysql Class: support Release: mysql-4.0.12 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux sflovers.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 13 2001 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Aug 13 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem starting 4.0.12 server
Does the mysql user have permission to write to /var/lib/mysql? -jeff On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote: Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm files, server won't start. The error (from the log) is: 030325 21:23:41 mysqld started 030325 21:23:41 Can't start server : Bind on unix socket: Permission denied 030325 21:23:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 030325 21:23:41 Aborting 030325 21:23:41 /usr/sbin/mysqld: Shutdown Complete 030325 21:23:41 mysqld ended I've checked, and /var/lib/mysql/mysql.sock doesn't exist. Shouldn't the server create it? How-To-Repeat: Fix: Submitter-Id:submitter ID Originator: Saul Organization: Saul Jaffe [EMAIL PROTECTED] MySQL support: [none | licence | email support | extended email support ] Synopsis:Can't start server Severity:serious Priority:high Category:mysql Class: support Release: mysql-4.0.12 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux sflovers.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 13 2001 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Aug 13 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with MySQL server - 3.21.33b
Hello: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RESSTATE TIME WCPU CPUCOMMAND 270 94 44420K 2024K run43:48 97.17% 97.17% mysqld ## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. Could anybody help me out to solve this issue. Regards Sheni R Meledath [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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: Problem with MySQL server - 3.21.33b
Hi, check the niced processes (on BSD #ps aux). These are processes which have been assigned a higher priority and there for kill your server. Also the man page from top (the CPU STATE comes from top ?) writes that the nice % should also be seen in user and system % which is not the case in your snip. Could be of the high CPU overload hope this helps a bit sake. Sheni R. Meledath An: MySQL Masters [EMAIL PROTECTED] [EMAIL PROTECTED] Kopie: Thema:Problem with MySQL server - 3.21.33b 15.05.02 11:24 Hello: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RESSTATE TIME WCPU CPUCOMMAND 270 94 44420K 2024K run43:48 97.17% 97.17% mysqld ## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. Could anybody help me out to solve this issue. Regards Sheni R Meledath [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 mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with a server
Hi! I was running an application that connected to a MySql server on the same computer (workstation W2K). There was no problem. However, I've tried to install the same system (application and MySql server) on a Windows server, and the application fails to connect to the server. With the workstation, the user that connected to the server was: username@localhost, or username@pc_name Actually, in the server, I receive the message that: user username@server_domain_name is not a valid user for the server. Do you know how to solve the problem? Do you know how to give rights to this user? Thank you very much! marc - 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
SV: problem with mysql3.23.49 server under freebsd 4.5
sql,query I cant get the server to starts more than one thread. I have installed the server from the port collections and im running freebsd 4.5 stable Regards leo de geer - 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 starting MySql server
Brian Walker ([EMAIL PROTECTED]) writes: 010609 14:40:21 Do you already have another mysqld server running on port: 3306 ? The manual said to try to telnet in on port 3306 so I did that and got this: [root@www data]# telnet www.sfslsports.com 3306 Trying 209.15.183.134... Connected to www.sfslsports.com. Escape character is '^]'. ( 3.23.38)fHv:[?e Bad handshakeConnection closed by foreign host. Yup, it's running, all right. So, what's the problem? To shut it down: mysqladmin shutdown To start it up: safe_mysqld -- Ed Carp, N7EKG [EMAIL PROTECTED] 214/986-5870 cell phone http://www.pobox.com/~erc I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - 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
Problem starting mysql server
I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 workstation. When I try to start mysql server with safe_mysqld, I got following error message: Start MySQL server deamon exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive 010608 10:54:45 mysqld ended The zlib is version 1.1.3. Can anyone tell me what wrong here? what is this shr.o? Thanks. Weining Zhao - TNRCC 512-239-2593 [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
problem starting mysql server
Description: My Mysql server will not start properly. I am attempting to start it from /usr/local/mysql, by typing the following command :- bin/safe_mysqld -u root The screen responds with :- [1] 5848 # Starting mysqld daemon with databases from /usr/local/mysql/data mysqld daemon ended It simply returns a prompt when I hit return. The error message in the /usr/local/mysql/data/bon.err file is as follows :- mysqld started on Thursday April 26 17:40:44 BST 2001 010426 17:40:44 /usr/local/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 010426 17:40:44 /usr/local/mysql/bin/mysqld: Normal shutdown 010426 17:40:44 /usr/local/mysql/bin/mysqld: Shutdown Complete mysqld ended on Thursday April 26 17:40:44 BST 2001 I have searched the mysql website for any relevant information. But can only find issues surrounding the environment variable MYSQL_HOST, not mysql.host. How-To-Repeat: Use command above Fix: Not known Submitter-Id: submitter ID Originator:Mark Leedham Organization: Startle plc 18-21 Cavaye Place Chelsea London SW10 9PT +44 (0)207 341 0947 MySQL support: none Synopsis: synopsis of the problem (one line) Severity: critical Priority: high Category: mysql Class:support Release: mysql-3.23.33 (Official MySQL binary) Environment: machine System: SunOS bon 5.7 Generic_106541-14 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3 -felide-construc tors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official My SQL binary' --with-extra-charsets=complex --enable-assembler --disable-shared Sorry for sending this again. But the server it was sent from, will not receive mail to the root account. Many Thanks Mark Leedham Unix Systems Administrator Startle plc 18-21 Cavaye Place, Chelsea, London. SW10 9PT Tel Desk :- +44 (0)207 341 0947 Tel Mobile :- +44 (0)773 0983431 Tel Main :- +44 (0)207 341 0999 Tel Fax :- +44 (0)207 341 0888 Email :- [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