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 : > > Hi, > > > > check your audit.lo

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

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:

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 wrote: > On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL) > 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

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

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 st

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 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   wrote: > > Have yo

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 wrote: Have you tried: mysql --verbose -u -p To output more information When would I use that? If I try to

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 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 >>>  wrote: Have you tried: mysql --verbose -u  -p To output more in

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 wrote: > On 06/02/12 13:33, Larry Martell wrote: >> >> On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies >>  wrote: >>> >>> Have you tried: >>> >>> mysql --verbose -u  -p >>> >>> To output more information >> >> When would I use that? If I try to

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 >> wrote: >>> Have you tried: >>> >>> mysql --verbose -u -p >>> >>> To output more information >> When would I use that? If I try to start it with 'ser

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 wrote: Have you tried: mysql --verbose -u -p 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

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 wrote: > Have you tried: > > mysql --verbose -u -p > > 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

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

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Thanks Chaim, You just clued me in. First, when you said to post output of ifconfig, I realized my LAN is configured not directly to the public address, but to 192.168.1.250 which is then tied to the public IP through port forwarding. I'm not completely up on why this was done, but when t

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Chaim Rieger
Skip Evans wrote: Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 bge1: flags

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Chaim Rieger wrote: can you post the output of ifconfig please I should have noted that 192.168.1.250 on bge1 is configured for port forwarding to the public IP address of the server. -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http://bigskypengu

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 ether 00:30:48:88

RE: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Mary Bahrami
I have 5.1 a VCS mysql cluster and I set the bind address for the virtual ip the nodes share in the mysql script; didn't look up 6.0 changes yet: $bindir/mysqld_safe --datadir=$datadir --pid-file=$server_pid_file --bind-address=17x.20.999.999 --local_infile=0 $other_args >/dev/null 2>&1 & -O

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Gerald L. Clark wrote: Does that IP address resolve to your hostname? Yes, it does. -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http://bigskypenguin.com =-=-=-=-=-=-=-=-=-= Check out PHPenguin, a lightweight and versatile PHP/MySQL, AJAX & DHTML deve

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Chaim Rieger
Skip Evans wrote: Hey Chaim, I'm sorry, I don't know what you mean by "default route". I am only familiar with the current contents of my.cnf, and mods were made according to instructions I found via Google. I don't see this noted in MySQL anywhere. Is this a network-wide configuration? ca

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Gerald L. Clark
Skip Evans wrote: Hey all, I'm trying to get my MySQL server configured so outside connections can access it with OpenOffice.org 2.4. My server is running on FreeBSD 6.0 and the my.cnf file looks like this currently. [mysqld] user = mysql pid-file = /usr/local/mysql/bigskypenguin.com.pid s

Re: MySQL won't start with external bind-adress in my.cnf

2008-07-29 Thread Skip Evans
Hey Chaim, I'm sorry, I don't know what you mean by "default route". I am only familiar with the current contents of my.cnf, and mods were made according to instructions I found via Google. I don't see this noted in MySQL anywhere. Is this a network-wide configuration? Skip Chaim Rieger

Re: mysql won't start anymore ?!?

2005-07-02 Thread Gleb Paharenko
Hello. It is not enough information to make a conclusion. Follow recommendations from: http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html JanBro <[EMAIL PROTECTED]> wrote: > Hi list, > > I can't get mysql running again and I don't know why. My wag would > be a corrupt

RE: MySQL won't start... was runnnig fine

2004-08-12 Thread Chris Blackwell
occurrence :) chris -Original Message- From: V. M. Brasseur [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 16:21 To: [EMAIL PROTECTED] Subject: Re: MySQL won't start... was runnnig fine This line probably should have been a good hint: >>InnoDB: File operation call: 'tmpfile&#

Re: MySQL won't start... was runnnig fine

2004-08-12 Thread V. M. Brasseur
message had told me which directory was causing the problem :/ chris -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 10:26 To: [EMAIL PROTECTED] Subject: Re: MySQL won't start... was runnnig fine "Chris Blackwell" <[EMAIL PROTECTED]&g

RE: MySQL won't start... was runnnig fine

2004-08-12 Thread Chris Blackwell
causing the problem :/ chris -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 10:26 To: [EMAIL PROTECTED] Subject: Re: MySQL won't start... was runnnig fine "Chris Blackwell" <[EMAIL PROTECTED]> wrote: > now when ever i try

Re: MySQL won't start... was runnnig fine

2004-08-12 Thread Egor Egorov
"Chris Blackwell" <[EMAIL PROTECTED]> wrote: > now when ever i try to start mysql i get the following error in log > > 040812 09:52:34 mysqld started > 040812 9:52:34 Warning: Asked for 196608 thread stack, but got 126976 > 040812 9:52:34 InnoDB: Error: unable to create temporary file > 0408

Re: Mysql won't start

2003-12-01 Thread Chuck Gadd
Michael Burke wrote: InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 031201 20:00:49 mys

Re: Mysql won't start

2003-12-01 Thread Michael Burke
On Mon, 2003-12-01 at 07:00, Chuck Gadd wrote: > Michael Burke wrote: > > > I'm using mysql on redhat 9 and wanted to enable the query log file.I > > copied one of the example my.cnf files to /etc and added an entry: --log > > to enable the log file but when I boot red hat I get a message that >

Re: Mysql won't start

2003-12-01 Thread Chuck Gadd
Michael Burke wrote: I'm using mysql on redhat 9 and wanted to enable the query log file.I copied one of the example my.cnf files to /etc and added an entry: --log to enable the log file but when I boot red hat I get a message that If you are specifying the option on the command line, then you n

Re: Mysql won't start

2003-11-30 Thread Dan Nelson
In the last episode (Nov 30), Michael Burke said: > I'm using mysql on redhat 9 and wanted to enable the query log file.I > copied one of the example my.cnf files to /etc and added an entry: > --log to enable the log file but when I boot red hat I get a message > that mysql started and ended. When

Re: MySQL won't start...

2002-02-12 Thread Gerald Clark
Mysql must own its files and directories. chown -R mysql /var/lib/mysql assumong /var/lib/mysql is the data directory. FISHER,JOE (Non-HP-Roseville,ex1) wrote: >I have 2 SuSE Linux 7.2 machines at home... These boxes have completely >different hardware in each... But the O/S on each, contains

RE: MySQL won't start...

2002-02-08 Thread Eric Mayers
Joe, When you start mysql (presumably with safe_mysqld), you must tell it where your datafiles are. Try bin/safe_mysqld --datadir=/var/lib/mysql/mysql Eric > -Original Message- > From: FISHER,JOE (Non-HP-Roseville,ex1) > [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 11