On Sun, Jul 06, 2003 at 09:59:43PM +0200, [EMAIL PROTECTED] 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
> 13)
> 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
issue an

# 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 ...

HTH,
Herbert

> Greetings
> 
> Oliver
> 
> -----Original Message-----
> From: Herbert Poetzl [mailto:[EMAIL PROTECTED]
> Sent: Sonntag, 6. Juli 2003 21:40
> To: [EMAIL PROTECTED]
> Subject: Re: [vserver] mysql startup error
> 
> 
> On Sun, Jul 06, 2003 at 07:36:39PM +0200, [EMAIL PROTECTED] wrote:
> > hi,
> 
> Hi Oliver!
> 
> > 030203  2:57:23  Can't start server : Bind on unix socket: Permission
> denied
> > 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
> 
> /usr/include/linux/capability.h
> 
> HTH,
> Herbert
> 
> > Greetings
> >
> > Oliver
> >
> 
> 

Reply via email to