Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies

Have you tried:

mysql --verbose -u username -ppassword

To output more information



On 05/02/12 00:57, Larry Martell wrote:

Just installed mysql on centos 6.2. When I try to start it with service I get:

#service mysqld start
MySQL Daemon failed to start.
Starting mysqld:   [FAILED]

Nothing at all is written to the error log.

But if I start it with mysqld_safe it comes up and works fine.

Anyone know what could be going on here?

-larry



--

*Chris Tate-Davies*

*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15 Stukeley Street | London | WC2B 5LT
*Email:*chris.tatedav...@inflightproductions.com 
mailto:chris.tatedav...@inflightproductions.com

*Web:*www.inflightproductions.com http://www.inflightproductions.com/





-


Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
Registered in England number 1421223

This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information. If you have received it in 
error, please notify the sender immediately and delete the original. Any other 
use of the email by you is prohibited. Please note that the information 
provided in this e-mail is in any case not legally binding; all committing 
statements require legally binding signatures.


http://www.inflightproductions.com



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
 Have you tried:

 mysql --verbose -u username -ppassword

 To output more information

When would I use that? If I try to start it with 'service mysqld
start' it fails to start.



 On 05/02/12 00:57, Larry Martell wrote:

 Just installed mysql on centos 6.2. When I try to start it with service I
 get:

 #service mysqld start
 MySQL Daemon failed to start.
 Starting mysqld:                                           [FAILED]

 Nothing at all is written to the error log.

 But if I start it with mysqld_safe it comes up and works fine.

 Anyone know what could be going on here?

 -larry


 --

 *Chris Tate-Davies*

 *Software Development*
 Inflight Productions Ltd
 Telephone: 01295 269 680
 15 Stukeley Street | London | WC2B 5LT
 *Email:*chris.tatedav...@inflightproductions.com
 mailto:chris.tatedav...@inflightproductions.com
 *Web:*www.inflightproductions.com http://www.inflightproductions.com/





 -


 Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
 Registered in England number 1421223

 This message is for the designated recipient only and may contain
 privileged, proprietary, or otherwise private information. If you have
 received it in error, please notify the sender immediately and delete the
 original. Any other use of the email by you is prohibited. Please note that
 the information provided in this e-mail is in any case not legally binding;
 all committing statements require legally binding signatures.


 http://www.inflightproductions.com


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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies

On 06/02/12 13:33, Larry Martell wrote:

On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com  wrote:

Have you tried:

mysql --verbose -uusername  -ppassword

To output more information

When would I use that? If I try to start it with 'service mysqld
start' it fails to start.



From terminal command...

just try typing it, like this:

mysql --verbose -u username -ppassword


On 05/02/12 00:57, Larry Martell wrote:

Just installed mysql on centos 6.2. When I try to start it with service I
get:

#service mysqld start
MySQL Daemon failed to start.
Starting mysqld:   [FAILED]

Nothing at all is written to the error log.

But if I start it with mysqld_safe it comes up and works fine.

Anyone know what could be going on here?

-larry


--

*Chris Tate-Davies*

*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15 Stukeley Street | London | WC2B 5LT
*Email:*chris.tatedav...@inflightproductions.com
mailto:chris.tatedav...@inflightproductions.com
*Web:*www.inflightproductions.comhttp://www.inflightproductions.com/





-


Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
Registered in England number 1421223

This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify the sender immediately and delete the
original. Any other use of the email by you is prohibited. Please note that
the information provided in this e-mail is in any case not legally binding;
all committing statements require legally binding signatures.


http://www.inflightproductions.com



--

*Chris Tate-Davies*

*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15 Stukeley Street | London | WC2B 5LT
*Email:*chris.tatedav...@inflightproductions.com 
mailto:chris.tatedav...@inflightproductions.com

*Web:*www.inflightproductions.com http://www.inflightproductions.com/





-


Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
Registered in England number 1421223

This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information. If you have received it in 
error, please notify the sender immediately and delete the original. Any other 
use of the email by you is prohibited. Please note that the information 
provided in this e-mail is in any case not legally binding; all committing 
statements require legally binding signatures.


http://www.inflightproductions.com



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Reindl Harald


Am 06.02.2012 15:28, schrieb Chris Tate-Davies:
 On 06/02/12 13:33, Larry Martell wrote:
 On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
 chris.tatedav...@inflightproductions.com  wrote:
 Have you tried:

 mysql --verbose -uusername  -ppassword

 To output more information
 When would I use that? If I try to start it with 'service mysqld
 start' it fails to start.

 
 From terminal command...
 
 just try typing it, like this:
 
 mysql --verbose -u username -ppassword

and how can this help if mysqld does not start?



signature.asc
Description: OpenPGP digital signature


Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 7:28 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
 On 06/02/12 13:33, Larry Martell wrote:

 On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
 chris.tatedav...@inflightproductions.com  wrote:

 Have you tried:

 mysql --verbose -uusername  -ppassword

 To output more information

 When would I use that? If I try to start it with 'service mysqld
 start' it fails to start.


 From terminal command...

 just try typing it, like this:


 mysql --verbose -u username -ppassword

The server will not start, so that gives:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

As one would expect if the server is not up.

-larry


 On 05/02/12 00:57, Larry Martell wrote:

 Just installed mysql on centos 6.2. When I try to start it with service
 I
 get:

 #service mysqld start
 MySQL Daemon failed to start.
 Starting mysqld:                                           [FAILED]

 Nothing at all is written to the error log.

 But if I start it with mysqld_safe it comes up and works fine.

 Anyone know what could be going on here?

 -larry

 --

 *Chris Tate-Davies*

 *Software Development*
 Inflight Productions Ltd
 Telephone: 01295 269 680
 15 Stukeley Street | London | WC2B 5LT
 *Email:*chris.tatedav...@inflightproductions.com
 mailto:chris.tatedav...@inflightproductions.com
 *Web:*www.inflightproductions.comhttp://www.inflightproductions.com/





 -


 Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
 Registered in England number 1421223

 This message is for the designated recipient only and may contain
 privileged, proprietary, or otherwise private information. If you have
 received it in error, please notify the sender immediately and delete the
 original. Any other use of the email by you is prohibited. Please note
 that
 the information provided in this e-mail is in any case not legally
 binding;
 all committing statements require legally binding signatures.


 http://www.inflightproductions.com


 --

 *Chris Tate-Davies*

 *Software Development*
 Inflight Productions Ltd
 Telephone: 01295 269 680
 15 Stukeley Street | London | WC2B 5LT
 *Email:*chris.tatedav...@inflightproductions.com
 mailto:chris.tatedav...@inflightproductions.com
 *Web:*www.inflightproductions.com http://www.inflightproductions.com/





 -


 Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
 Registered in England number 1421223

 This message is for the designated recipient only and may contain
 privileged, proprietary, or otherwise private information. If you have
 received it in error, please notify the sender immediately and delete the
 original. Any other use of the email by you is prohibited. Please note that
 the information provided in this e-mail is in any case not legally binding;
 all committing statements require legally binding signatures.


 http://www.inflightproductions.com


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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 7:34 AM, Reindl Harald h.rei...@thelounge.net wrote:


 Am 06.02.2012 15:28, schrieb Chris Tate-Davies:
 On 06/02/12 13:33, Larry Martell wrote:
 On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
 chris.tatedav...@inflightproductions.com  wrote:
 Have you tried:

 mysql --verbose -uusername  -ppassword

 To output more information
 When would I use that? If I try to start it with 'service mysqld
 start' it fails to start.


 From terminal command...

 just try typing it, like this:

 mysql --verbose -u username -ppassword

 and how can this help if mysqld does not start?

Yes, I was wondering the same thing.

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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies

On 06/02/12 14:34, Reindl Harald wrote:


Am 06.02.2012 15:28, schrieb Chris Tate-Davies:

On 06/02/12 13:33, Larry Martell wrote:

On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com   wrote:

Have you tried:

mysql --verbose -uusername   -ppassword

To output more information

When would I use that? If I try to start it with 'service mysqld
start' it fails to start.


 From terminal command...

just try typing it, like this:

mysql --verbose -uusername  -ppassword

and how can this help if mysqld does not start?

I am hoping it will verbose any errors to the terminal.

--

*Chris Tate-Davies*

*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15 Stukeley Street | London | WC2B 5LT
*Email:*chris.tatedav...@inflightproductions.com 
mailto:chris.tatedav...@inflightproductions.com

*Web:*www.inflightproductions.com http://www.inflightproductions.com/





-


Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
Registered in England number 1421223

This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information. If you have received it in 
error, please notify the sender immediately and delete the original. Any other 
use of the email by you is prohibited. Please note that the information 
provided in this e-mail is in any case not legally binding; all committing 
statements require legally binding signatures.


http://www.inflightproductions.com



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 7:42 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
 On 06/02/12 14:34, Reindl Harald wrote:


 Am 06.02.2012 15:28, schrieb Chris Tate-Davies:

 On 06/02/12 13:33, Larry Martell wrote:

 On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
 chris.tatedav...@inflightproductions.com   wrote:

 Have you tried:

 mysql --verbose -uusername   -ppassword

 To output more information

 When would I use that? If I try to start it with 'service mysqld
 start' it fails to start.

  From terminal command...

 just try typing it, like this:

 mysql --verbose -uusername  -ppassword

 and how can this help if mysqld does not start?

 I am hoping it will verbose any errors to the terminal.

If the server is not up, mysql will not connect.

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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Shawn Green (MySQL)

On 2/4/2012 19:57, Larry Martell wrote:

Just installed mysql on centos 6.2. When I try to start it with service I get:

#service mysqld start
MySQL Daemon failed to start.
Starting mysqld:   [FAILED]

Nothing at all is written to the error log.

But if I start it with mysqld_safe it comes up and works fine.

Anyone know what could be going on here?

-larry



If the daemon is attempting to change users during startup, then you 
must be root when you start it.  Otherwise, become the user `mysql` then 
start the daemon (service) under the proper credentials.


http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_user

--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
 On 2/4/2012 19:57, Larry Martell wrote:

 Just installed mysql on centos 6.2. When I try to start it with service I
 get:

 #service mysqld start
 MySQL Daemon failed to start.
 Starting mysqld:                                           [FAILED]

 Nothing at all is written to the error log.

 But if I start it with mysqld_safe it comes up and works fine.

 Anyone know what could be going on here?

 -larry


 If the daemon is attempting to change users during startup, then you must be
 root when you start it.  Otherwise, become the user `mysql` then start the
 daemon (service) under the proper credentials.

 http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_user

I was root when issuing the 'service mysqld start' command. I just
tried it as the mysql user, and it failed in the same way.

I traced the service mysqld start and I saw that it invoked
/etc/init.d/mysqld (which invokes mysqld_safe). When I invoke
/etc/init.d/mysqld (or mysqld_safe) the server comes up fine. Very
odd.

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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Michael Dykman
On Mon, Feb 6, 2012 at 3:34 PM, Larry Martell larry.mart...@gmail.com wrote:
 On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL)
 shawn.l.gr...@oracle.com wrote:
 On 2/4/2012 19:57, Larry Martell wrote:

 Just installed mysql on centos 6.2. When I try to start it with service I
 get:

 #service mysqld start
 MySQL Daemon failed to start.
 Starting mysqld:                                           [FAILED]

 Nothing at all is written to the error log.

 But if I start it with mysqld_safe it comes up and works fine.

 Anyone know what could be going on here?

 -larry


 If the daemon is attempting to change users during startup, then you must be
 root when you start it.  Otherwise, become the user `mysql` then start the
 daemon (service) under the proper credentials.

 http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_user

 I was root when issuing the 'service mysqld start' command. I just
 tried it as the mysql user, and it failed in the same way.

 I traced the service mysqld start and I saw that it invoked
 /etc/init.d/mysqld (which invokes mysqld_safe). When I invoke
 /etc/init.d/mysqld (or mysqld_safe) the server comes up fine. Very
 odd.

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




I haven't seen it mentioned, so I'll give it a shot:  Have you checked
the permissions on your data directory?  If you are getting no message
in your .err file thhat is often the cause.  It should be owned by the
mysql user.

-- 
 - michael dykman
 - mdyk...@gmail.com

 May the Source be with you.

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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Frédéric Descamps
Hi,

check your audit.log if you have selinux enabled



On Sat, 2012-02-04 at 17:57 -0700, Larry Martell wrote:
 Just installed mysql on centos 6.2. When I try to start it with service I get:
 
 #service mysqld start
 MySQL Daemon failed to start.
 Starting mysqld:   [FAILED]
 
 Nothing at all is written to the error log.
 
 But if I start it with mysqld_safe it comes up and works fine.
 
 Anyone know what could be going on here?
 
 -larry
 

-- 
Frédéric Descamps, Consultant, Percona Inc.
Mob: +32 495698668 (CET) 
Skype: lefred.descamps
Jabber: lefred.desca...@gmail.com

24/7 Emergency Line +1 888 401 3401 ext 911

Our Services: http://www.percona.com/services.html
Our Blog: http://www.mysqlperformanceblog.com/

Percona Training Workshops: http://www.percona.com/training/

Percona Live MySQL Conference April 10-12 Santa Clara
http://www.percona.com/live/mysql-conference-2012/


signature.asc
Description: This is a digitally signed message part


Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
2012/2/6 Frédéric Descamps lef...@percona.com:
 Hi,

 check your audit.log if you have selinux enabled

Ah, thanks for mentioning this. I didn't even think of that. Sure
enough, if I disabled selinux, it worked. Now I have to figure out why
it's failing under selinux. In the audit log I see these messages when
I try and start it:

type=AVC msg=audit(1328563688.649:3999): avc:  denied  { write } for
pid=25344 comm=touch name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.649:4000): avc:  denied  { write } for
pid=25344 comm=touch name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.651:4001): avc:  denied  { setattr } for
 pid=25345 comm=chown name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.688:4002): avc:  denied  { append } for
pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.688:4003): avc:  denied  { append } for
pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.694:4004): avc:  denied  { append } for
pid=25381 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.694:4005): avc:  denied  { append } for
pid=25381 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.697:4006): avc:  denied  { append } for
pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
type=AVC msg=audit(1328563688.697:4007): avc:  denied  { append } for
pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
scontext=unconfined_u:system_r:mysqld_safe_t:s0
tcontext=unconfined_u:object_r:usr_t:s0 tclass=file

mysql.err was 660 owned by mysql.mysql and the dir it's in was 755,
also owned by mysql.mysql. I tried changing the file to 666 and the
dir to 777, but I got the same errors. I also tried moving the log
file to /tmp, but I still got the same errors. So it's not
permissions. I don't know too much about selinux - Ill have to
research that more.

Thanks again!
-larry




 On Sat, 2012-02-04 at 17:57 -0700, Larry Martell wrote:
 Just installed mysql on centos 6.2. When I try to start it with service I 
 get:

 #service mysqld start
 MySQL Daemon failed to start.
 Starting mysqld:                                           [FAILED]

 Nothing at all is written to the error log.

 But if I start it with mysqld_safe it comes up and works fine.

 Anyone know what could be going on here?

 -larry


 --
 Frédéric Descamps, Consultant, Percona Inc.
 Mob: +32 495698668 (CET)
 Skype: lefred.descamps
 Jabber: lefred.desca...@gmail.com

 24/7 Emergency Line +1 888 401 3401 ext 911

 Our Services: http://www.percona.com/services.html
 Our Blog: http://www.mysqlperformanceblog.com/

 Percona Training Workshops: http://www.percona.com/training/

 Percona Live MySQL Conference April 10-12 Santa Clara
 http://www.percona.com/live/mysql-conference-2012/

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



Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Frédéric Descamps
Larry,

You are welcome.

If you want to create the selinux policy from your audit.log, you can
check the instruction from this post: http://www.lefred.be/?q=node/129

Cheers,

On Mon, 2012-02-06 at 14:54 -0700, Larry Martell wrote:
 2012/2/6 Frédéric Descamps lef...@percona.com:
  Hi,
 
  check your audit.log if you have selinux enabled
 
 Ah, thanks for mentioning this. I didn't even think of that. Sure
 enough, if I disabled selinux, it worked. Now I have to figure out why
 it's failing under selinux. In the audit log I see these messages when
 I try and start it:
 
 type=AVC msg=audit(1328563688.649:3999): avc:  denied  { write } for
 pid=25344 comm=touch name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.649:4000): avc:  denied  { write } for
 pid=25344 comm=touch name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.651:4001): avc:  denied  { setattr } for
  pid=25345 comm=chown name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.688:4002): avc:  denied  { append } for
 pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.688:4003): avc:  denied  { append } for
 pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.694:4004): avc:  denied  { append } for
 pid=25381 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.694:4005): avc:  denied  { append } for
 pid=25381 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.697:4006): avc:  denied  { append } for
 pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 type=AVC msg=audit(1328563688.697:4007): avc:  denied  { append } for
 pid=25238 comm=mysqld_safe name=mysql.err dev=dm-0 ino=1709317
 scontext=unconfined_u:system_r:mysqld_safe_t:s0
 tcontext=unconfined_u:object_r:usr_t:s0 tclass=file
 
 mysql.err was 660 owned by mysql.mysql and the dir it's in was 755,
 also owned by mysql.mysql. I tried changing the file to 666 and the
 dir to 777, but I got the same errors. I also tried moving the log
 file to /tmp, but I still got the same errors. So it's not
 permissions. I don't know too much about selinux - Ill have to
 research that more.
 
 Thanks again!
 -larry
 
 
 
 
  On Sat, 2012-02-04 at 17:57 -0700, Larry Martell wrote:
  Just installed mysql on centos 6.2. When I try to start it with service I 
  get:
 
  #service mysqld start
  MySQL Daemon failed to start.
  Starting mysqld:   [FAILED]
 
  Nothing at all is written to the error log.
 
  But if I start it with mysqld_safe it comes up and works fine.
 
  Anyone know what could be going on here?
 
  -larry
 
 
  --
  Frédéric Descamps, Consultant, Percona Inc.
  Mob: +32 495698668 (CET)
  Skype: lefred.descamps
  Jabber: lefred.desca...@gmail.com
 
  24/7 Emergency Line +1 888 401 3401 ext 911
 
  Our Services: http://www.percona.com/services.html
  Our Blog: http://www.mysqlperformanceblog.com/
 
  Percona Training Workshops: http://www.percona.com/training/
 
  Percona Live MySQL Conference April 10-12 Santa Clara
  http://www.percona.com/live/mysql-conference-2012/
 

-- 
Frédéric Descamps, Consultant, Percona Inc.
Mob: +32 495698668 (CET) 
Skype: lefred.descamps
Jabber: lefred.desca...@gmail.com

24/7 Emergency Line +1 888 401 3401 ext 911

Our Services: http://www.percona.com/services.html
Our Blog: http://www.mysqlperformanceblog.com/

Percona Training Workshops: http://www.percona.com/training/

Percona Live MySQL Conference April 10-12 Santa Clara
http://www.percona.com/live/mysql-conference-2012/


signature.asc
Description: This is a digitally signed message part