RE: MySqld [problem]

[Dathan Vance Pattishall]

Can you start it with strace running and see where it fails? I suspect its
an issue with finding the group file. If this is the cause you will need to
build mySQL yourself.

Btw please send arch / version / system hardware spec.

--
DVP

> -Original Message-
> From: Mozzi [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 19, 2004 12:24 PM
> To: [EMAIL PROTECTED]
> Subject: MySqld [problem]
> 
> When trying to start mysqld I get the following error
> 
> #safe_mysqld
> Starting mysqld daemon with databases from /var/lib/mysql
> /usr/bin/safe_mysqld: line 275: 32649 Segmentation fault
> $NOHUP_NICENESS
> $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
> $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1
> 040419 22:08:23  mysqld ended
> 
> I am on debian woody and upgraded with apt-get apgrade about two hours
> ago.
> I am @ my wits end, so sorry if someone saw one of my previous posts.
> 
> Mozzi
> 
> --
> ---
> No Microsoft software was used,
> or employees hurt in creating this email.
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysqld problem

[Mark Colvin]

Thanks for taking the time to reply. Could you maybe elaborate and tell me
how I can make mysql the owner of the directory. (Would I also have to stop
and restart mysqld as this was part of my original problem).

-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 14:31
To: Mark Colvin
Cc: MySQL Mailing List (E-mail)
Subject: Re: mysqld problem


Pick/Create a different directory. Make it owned by mysql:mysql, and set
it mode 775.
Mysqld can not write to /usr/local/bin.

Mark Colvin wrote:

>I am having difficulty stopping and starting my mysql server. The mysqld is
>currently running as all of the client machines can access the database. If
>I try to invoke the mysql command from the server box (linux 7.2) I get the
>following -
>
>error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
>(2'
>Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
>
>The mysql.sock does not exists int /tmp directory and I am attempting to
>restart the server to create this. When I run mysqld restart it fails to
>stop and start. I think the server was last started with the safe_mysqld &
>command.  I use the /tmp directory to hold files created by cron jobs and
>this directory is periodically cleared out. This is obviously a problem as
>the mysql.sock currently needs to be in here. I have since changed the
>my.cnf file to read -
>[mysqld]
>datadir=/var/lib/mysql
>socket=/usr/local/bin/mysql.sock
>
>thus changing the directory for mysql.sock to resolve the above issue but I
>can't restart the server to get the mysql.sock recreated. Any ideas?
>
>
>
>
>This e-mail is intended for the recipient only and
>may contain confidential information. If you are
>not the intended recipient then you should reply
>to the sender and take no further ation based
>upon the content of the message.
>Internet e-mails are not necessarily secure and
>CCM Limited does not accept any responsibility
>for changes made to this message.
>Although checks have been made to ensure this
>message and any attchments are free from viruses
>the recipient should ensure that this is the case.
>
>
>
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



This e-mail is intended for the recipient only and
may contain confidential information. If you are
not the intended recipient then you should reply
to the sender and take no further ation based
upon the content of the message.
Internet e-mails are not necessarily secure and
CCM Limited does not accept any responsibility
for changes made to this message. 
Although checks have been made to ensure this
message and any attchments are free from viruses
the recipient should ensure that this is the case.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld problem

[gerald_clark]

Pick/Create a different directory. Make it owned by mysql:mysql, and set 
it mode 775.
Mysqld can not write to /usr/local/bin.

Mark Colvin wrote:

I am having difficulty stopping and starting my mysql server. The mysqld is
currently running as all of the client machines can access the database. If
I try to invoke the mysql command from the server box (linux 7.2) I get the
following -
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
The mysql.sock does not exists int /tmp directory and I am attempting to
restart the server to create this. When I run mysqld restart it fails to
stop and start. I think the server was last started with the safe_mysqld &
command.  I use the /tmp directory to hold files created by cron jobs and
this directory is periodically cleared out. This is obviously a problem as
the mysql.sock currently needs to be in here. I have since changed the
my.cnf file to read -
[mysqld]
datadir=/var/lib/mysql
socket=/usr/local/bin/mysql.sock
thus changing the directory for mysql.sock to resolve the above issue but I
can't restart the server to get the mysql.sock recreated. Any ideas?



This e-mail is intended for the recipient only and
may contain confidential information. If you are
not the intended recipient then you should reply
to the sender and take no further ation based
upon the content of the message.
Internet e-mails are not necessarily secure and
CCM Limited does not accept any responsibility
for changes made to this message. 
Although checks have been made to ensure this
message and any attchments are free from viruses
the recipient should ensure that this is the case.


 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysqld problem

[Victoria Reznichenko]

"Grzegorz Golofit" <[EMAIL PROTECTED]> wrote:
> I have problem with running mysqld
> I installed the following rpm packages incladed with RedHat 7.1 (Seawolf) edition 
> cd`s which I am running on my machine:
> -mysql-3.23.36-1
> - mysql-server-3.23.36.1
> - mysql-devel-3.23.36-1
> First I tried to initialize as a root tables with following command: 
> mysql_install_db and then typed in safe_mysqld &.
> I got the following inforamtion on the screen: Starting mysql deamon with database 
> from /var/lib/mysql and then 
> mysqld ended.
> In the /var/log/mysqld.log file I had the following information: 
> mysql started
> /usr/libexec/mysqld: Can`t find file ' ./mysql/host.frm' (errno: 13)
> mysqld ended
> I couldn`t see any mysql tables or databases in mentioned above file.
> Could you tell me what I did wrong 
> My Linux kernel is 2.4.2-2 on i686 and the glibc is glibc-2.2.2-10. This is 
> partitionless instalation.
> My hardwear is: Athlon 1.8 XP 

$ perror 13
Error code  13:  Permission denied

MySQL server should be owner of the datadir (/var/lib/mysql)


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysqld problem

[Stefan Hinz]

Gregory,

> mysql started
> /usr/libexec/mysqld: Can`t find file ' ./mysql/host.frm' (errno: 13)
> mysqld ended

You forgot to run the mysql_install_db script that sets up the initial
grant tables:

http://www.mysql.com/doc/en/Post-installation.html

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysqld problem

[Simon Green]

Try this in mysql/bin/perror 
Tells you what the error code means.

<---snip--->
> ./perror 13
Error code  13:  Permission denied
<---snip--->

Simon

-Original Message-
From: Grzegorz Golofit [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 08:36
To: [EMAIL PROTECTED]
Subject: Mysqld problem


I have problem with running mysqld
I installed the following rpm packages incladed with RedHat 7.1 (Seawolf)
edition cd`s which I am running on my machine:
-mysql-3.23.36-1
- mysql-server-3.23.36.1
- mysql-devel-3.23.36-1
First I tried to initialize as a root tables with following command:
mysql_install_db and then typed in safe_mysqld &.
I got the following inforamtion on the screen: Starting mysql deamon with
database from /var/lib/mysql and then 
mysqld ended.
In the /var/log/mysqld.log file I had the following information: 
mysql started
/usr/libexec/mysqld: Can`t find file ' ./mysql/host.frm' (errno: 13)
mysqld ended
I couldn`t see any mysql tables or databases in mentioned above file.
Could you tell me what I did wrong 
My Linux kernel is 2.4.2-2 on i686 and the glibc is glibc-2.2.2-10. This is
partitionless instalation.
My hardwear is: Athlon 1.8 XP 

Thanks in advance
Gregory

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysqld problem

[Phil Dobbin]

On 23/3/03 16:36, "Jeff Shapiro" <[EMAIL PROTECTED]> wrote:

> 
> It looks to me like you have a permissions problem with your
> directories. You need to make sure that the directory own for the
> mysql directory tree is your mysql user.

[...]

> I just checked your error code with:
> [~] [0] > perror 13
> Error code  13:  Permission denied
> 
> So it definitely looks like it's a permissions problem.
> 
> Try using this command in the Terminal program:
> 
> chown -R mysql /usr/local/mysql-3.23.51/

Hi, Jeff.

Right on the money! mysqld is now running happily and I can get into my
data. How the hell the permissions got screwed up like that, I've no idea
but now I know the error code, I'll know what to look for if it happens
again.

Many thanks,

Regards,

Phil.


> At 13:09 + 3/23/03, Phil Dobbin wrote:
>> I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
>> 10.1.5 and have a startup script which confirms on boot that it has started
>> but doesn't.
>> 
>> I've tried starting manually from the CLI but no luck. I looked in
>> localhost.err and found:
>> 
>> 030323  9:48:21  /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to
>> file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Can't find file:
>> './mysql/host.frm' (errno: 13)
>> 030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of
>> '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323 09:48:22  mysqld ended
>> 
>> According to the O'Reilly `MySQL Reference Manual' it seems that the daemon
>> may have been damaged but offers no real clue as how to fix it.
>> 
>> One other very odd aspect is that on OS X you create a mysql user in Sys
>> Prefs and I noticed, upon reboot, that this user had disappeared from the
>> pref panel. I re-created but to no avail.
>> 
>> Any help at all on this would be gratefully appreciated.
>> 
>> Regards,
>> 
>> Phil.
>> 
>> 
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysqld problem

[Jeff Shapiro]

It looks to me like you have a permissions problem with your 
directories. You need to make sure that the directory own for the 
mysql directory tree is your mysql user.

You can't use the Users section of Systems Preferences to create the 
MySQL user, you have to use the NetInfo utility.  Apple as 
instructions on how to install MySQL on OS X at:
http://developer.apple.com/internet/macosx/osdb.html

Hmmm, just checked Marc Liyanage's site and for pre-Jaguar he does 
mention to use System Preferences to create the MySQL user. He also 
only suggests to use 3.23.51 with pre-Jaguar as well. I'm not what 
the differences might be between the .51 and .55 for him to make this 
suggestion. I did try using his setup, but I gave up and went with 
the tarball files from MySQL instead. I didn't like all the 
nonstandard stuff that his system did. (At least I think it does some 
nonstandard stuff, it's been a while).

I just checked your error code with:
[~] [0] > perror 13
Error code  13:  Permission denied
So it definitely looks like it's a permissions problem.

Try using this command in the Terminal program:

chown -R mysql /usr/local/mysql-3.23.51/



At 13:09 + 3/23/03, Phil Dobbin wrote:
I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
10.1.5 and have a startup script which confirms on boot that it has started
but doesn't.
I've tried starting manually from the CLI but no luck. I looked in
localhost.err and found:
030323  9:48:21  /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to
file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
030323  9:48:22  /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of
'/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
030323 09:48:22  mysqld ended
According to the O'Reilly `MySQL Reference Manual' it seems that the daemon
may have been damaged but offers no real clue as how to fix it.
One other very odd aspect is that on OS X you create a mysql user in Sys
Prefs and I noticed, upon reboot, that this user had disappeared from the
pref panel. I re-created but to no avail.
Any help at all on this would be gratefully appreciated.

Regards,

Phil.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--

Jeff Shapiro, Colorado Springs, CO, USA

At work I *have* to use a Windows machine, at home I *get* to use a Mac.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysqld problem Re: ownership/permission problems

[Brian Warn]

Not sure how helpful I'll be able to be for you.  I  installed
MySQL-3.23.36-1.i386.rpm and MySQL-client-3.23.36-1.i386.rpm packages.  I
verified that everything worked as root and then shutdown the server.  I
then followed the steps outlined on p. 476 of the manual (also p. 419 of
Monty Widenius' MySQL book).  I also received some advice from another
person on this list -- I've attached it below -- that I used.

I discovered in my (server name).err file -- mine was located in my
/var/lib/mysql directory -- that mysqld couldn't find  the
/var/lib/mysql/mysql/host.frm file.  After changing the permissions on the
mysql table to 760, everything worked fine.  As you'll see below, the
recommendation was to set it to 660.

Hope this helps a bit ...

-Brian
---
Excerpt from note I received:

You should create a "mysql" group also,  and make sure that the "mysql" user
has it as it's "primary group ID" (in /etc/passwd).  Then you can add the
appropriate users (such as your own login) to the group (so you don't have
to be "root" to access the mysql stuff).

You can leave your "mysql" program directory owned by "root.root" (user and
group = "root"),  as long as the "var" subdirectory and all the files and
directories in "var" are owned by "mysql.mysql" with 2770 (rwxrws---) for
the directory permissions and 660 (rw-rw) for the files...   Set the
same ownership and permissions for the 'data' directories (if you've placed
them somewhere else on the system (linked to 'var' via symbolic links).

- Original Message -
From: "Foresight Systems Ltd." <[EMAIL PROTECTED]>
To: "Brian Warn" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 1:57 AM
Subject: Mysqld problem Re: ownership/permission problems


> Dear Sir,
> Since you already have mysql running, we seek your help in sorting out
> some problem.
> mysqld starts and ends instantaneously.
> We are using Red Hat Linux 7.0 /Apache Server on PIII 550 intel
> processor.
> We have compiled the mysql and installed version 3.23.32.
> The contents of our my.cnf file in /etc is as follows :
> 
> # Example mysql config file.
> # You can copy this to one of:
> # /usr/local/mysql/etc/my.cnf to set global options,
> # mysql-data-dir/my.cnf to set server-specific options (in this
> # installation this directory is /usr/local/mysql/var) or
> # ~/.my.cnf to set user-specific options.
> #
> # One can use all long options that the program supports.
> # Run the program with --help to get a list of available options
>
> # This will be passed to all mysql clients
> [client]
> #password = my_password
> port  = 3306
> socket  = /var/lib/mysql/mysql.sock
>
> # Here is entries for some specific programs
> # The following values assume you have at least 32M ram
>
> # The MySQL server
> [mysqld]
> port  = 3306
> socket  = /var/lib/mysql/mysql.sock
> skip-locking
> set-variable = key_buffer=16M
> set-variable = max_allowed_packet=1M
> set-variable = thread_stack=128K
> # Start logging
> log
>
> [mysqldump]
> quick
> set-variable = max_allowed_packet=16M
>
> [mysql]
> no-auto-rehash
>
> [isamchk]
> set-variable = key_buffer=16M
> ==
> The contents on the error file is follows
>
> 010403 16:19:55  mysqld started
> 010403 16:19:56  Can't start server : Bind on unix socket:
> Permission
> denied
> 010403 16:19:56  Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> 010403 16:19:56  Aborting
>
> 010403 16:19:56  mysqld ended
>
> 010403 16:35:05  mysqld started
> 010403 16:35:05  Can't start server : Bind on unix socket:
> Permission
> denied
> 010403 16:35:05  Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> 010403 16:35:05  Aborting
>
> 010403 16:35:05  mysqld ended
>
> 010403 17:09:52  mysqld started
> 010403 17:09:52  Can't start server : Bind on unix socket:
> Permission
> denied
> 010403 17:09:52  Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> 010403 17:09:52  Aborting
>
> 010403 17:09:52  mysqld ended
>
> 
> Further,We have also tried latest available rpm installation -i386
> downloaded from mysql.com.
> using command
> rpm -i rpm-file-name
> but it fails to install rpm package just stating
> can not install rpm
> Please guide, how to create mysql users,set permissions,ownerships etc.
>
> Regards
> Akshaya
>
> Brian Warn wrote:
>
> > I finally did find a discussion in Monty's book on p. 417 about this.
> >
> > Thanks,
> > Brian
> >
> > - Original Message -
> > From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 03, 2001 11:20 AM
> > Subject: Re: ownership/permission problems
> >
> > >
> > > >I haven't had any success so far finding any help in the manual or
>