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 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-exceptions -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-exceptions
> >> -fno-rtti -mpentium'
> >>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
