> 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 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 20000731 (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-ex > ceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' > > > > >> LIBC: > > > > >> lrwxrwxrwx 1 root root 13 Aug 13 2001 > /lib/libc.so.6 -> libc-2.2.2.so > > > > >> -rwxr-xr-x 1 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 > > > > >> lrwxrwxrwx 1 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-ex > ceptions -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] > > > -- 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]