About this list Date view Thread view Subject view Author view Attachment view

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
> 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: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
> 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
> >
>
>


About this list Date view Thread view Subject view Author view Attachment view
[Next/Previous Months] [Main vserver Project Homepage] [Howto Subscribe/Unsubscribe] [Paul Sladen's vserver stuff]
Generated on Sun 06 Jul 2003 - 22:01:37 BST by hypermail 2.1.3