From: Herbert Poetzl (herbert_at_13thfloor.at)
Date: Sun 06 Jul 2003 - 21:36:20 BST
On Sun, Jul 06, 2003 at 09:59:43PM +0200, desman_at_gmx.de wrote:
> hi Herbert,
> i tried it with --socket but then it tells me:
> mysqld: File '/var/log/mysql/mysql.log' not found (Errcode: 13)
> 030203 5:20:08 Could not use /var/log/mysql/mysql.log for logging (error
> 030203 5:20:08 mysqld: Can't create/write to file
> '/var/run/mysqld/mysqld.pid' (Errcode: 13)
#define EACCES 13 /* Permission denied */
sorry, but this seems to be a 'simple' permission
problem ... so jut for fun of doing (testing) it
# mkdir -p /var/run/mysqld /var/log/mysql
# chmod a+rx /var /var/run /var/log
# chmod a+rwx /var/run/mysqld /var/log/mysql
as root and try again as whatever user mysql uses ...
> 030203 5:20:08 mysqld: Can't find file: './mysql/host.frm' (errno: 13)
> 030203 5:20:08 mysqld: Error on delete of '/var/run/mysqld/mysqld.pid'
> (Errcode: 2)
#define ENOENT 2 /* No such file or directory */
see solution? above ...
if this issue persists, try to reproduce with
a simple shell script touching/removing the files
as the user mysql uses ...
> all this files exist. And they are accessible by the user ( also tried with
> root )
> With CAPS i mean the vserver specific CAPS in vserver config files.
I know what you meant, and the vserver config CAPS
are the same as the ones in /usr/include/linux/capability.h
> But normaly mysql is workable on vserver kernel 2.4.21 with ctx 17 and
> vquota patch or ?
I don't know, never tried, but I guess so ...
> -----Original Message-----
> From: Herbert Poetzl [mailto:herbert_at_13thfloor.at]
> Sent: Sonntag, 6. Juli 2003 21:40
> To: vserver_at_solucorp.qc.ca
> Subject: Re: [vserver] mysql startup error
> On Sun, Jul 06, 2003 at 07:36:39PM +0200, desman_at_gmx.de wrote:
> > hi,
> Hi Oliver!
> > 030203 2:57:23 Can't start server : Bind on unix socket: Permission
> > 030203 2:57:23 Do you already have another mysqld server running on
> > socket: /var/run/mysqld/mysqld.sock ?
> > 030203 2:57:23 Aborting
> > 030203 2:57:23 mysqld: Shutdown Complete
> > i`m using bind-address directive in my.cnf on Debian 3.0R1
> > mysqld Ver 3.23.49 for pc-linux-gnu on i686
> > How to solve this ?
> probably it is what mysql tries to tell you
> 'Bind on unix socket: Permission denied'
> try to start it in the following way (just for a test)
> # su - mysql (or whatever user mysql is run as)
> # /path/to/mysqld --socket=/tmp/x
> if it reports something about cannot bind to port
> then there is another mysql daemon (or something at
> its port) running, if it works, check the path to
> /var/run/mysqld/mysqld.sock as this user ...
> > I think it`s anything with the CAPS but i haven`t found any list of
> > available CAPS
> > Greetings
> > Oliver