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:

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

2012-02-04 Thread Larry Martell
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 wo

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
ull 2>&1 & -Original Message- From: Skip Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 10:38 AM To: mysql@lists.mysql.com Subject: MySQL won't start with external bind-adress in my.cnf Hey all, I'm trying to get my MySQL server configured so outside c

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

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

2008-07-29 Thread Skip Evans
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 socket = /tmp/mysql

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

mysql won't start anymore ?!?

2005-07-02 Thread JanBro
Hi list, I can't get mysql running again and I don't know why. My wag would be a corrupt mysql.exe? I had it running for almost a year now and besides the fact that my ibdata1 rose to a size of more than 2.5 G (with actual data of less than 100 M) I didn't encounter problems. but this morning I

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

MySQL won't start... was runnnig fine

2004-08-12 Thread Chris Blackwell
Hi,   I have been running 4.1.3 on redhat9, installed from the mysql rpm package.  It has been running great until the server crashed for an unknown reason 2 days ago.   now when ever i try to start mysql i get the following error in log   040812 09:52:34  mysqld started040812  9:52:34  Warn

Re: INNOB error and mysql won't start

2003-12-29 Thread Heikki Tuuri
QL technical support from https://order.mysql.com/ - Original Message - From: "M.D. DeWar" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, December 29, 2003 10:33 PM Subject: Re: INNOB error and mysql won

Re: INNOB error and mysql won't start

2003-12-29 Thread M.D. DeWar
> To: <[EMAIL PROTECTED]> Sent: Monday, December 29, 2003 12:41 PM Subject: Re: INNOB error and mysql won't start > Hi! > > What version of MySQL you are running? > > Is the output below ALL you get into the .err log? > > In >= 4.0 you can disbale InnoDB by put

Re: INNOB error and mysql won't start

2003-12-29 Thread Heikki Tuuri
mber 29, 2003 7:36 PM Subject: INNOB error and mysql won't start > Hello, > I have a problem that started. > I am getting this error in /var/log/messages > > 31229 12:44:47 Can't init databases > 031229 12:44:47 Aborting > > 031229 12:44:47 InnoDB: Warning: shu

INNOB error and mysql won't start

2003-12-29 Thread M.D. DeWar
Hello, I have a problem that started. I am getting this error in /var/log/messages 31229 12:44:47 Can't init databases 031229 12:44:47 Aborting 031229 12:44:47 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 031229 12:44:47 /usr/local/libexe

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

Mysql won't start

2003-11-30 Thread Michael Burke
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 I try to start mysql in a terminal window I get the same r

Mysql won't start but compiled correctly

2002-09-20 Thread Super-User
HI, Can anyone figure this out ? I have been trying this out for quite some time. It compiles fine but when I run root@love(scripts)# ./mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Inst

mysql won't start via init script

2002-02-14 Thread Faine, Mark
If I start mysql by changing to the msyql directory and run safe_mysqld --user=mysql & everything works fine, if I try to start mysql at boot time with an init script it starts and immediately dies the log files say it can't find a certain library file (a file that is in my LD_LIBRARY_PATH). It ha

MySQL won't start...

2002-02-12 Thread Victoria Reznichenko
FISHER, Friday, February 08, 2002, 9:01:10 PM, you wrote: Feoen> I have 2 SuSE Linux 7.2 machines at home... These boxes Feoen> have completely different hardware in each... But the Feoen> O/S on each, contains virtually all of Feoen> the same applications... Feoen> On the first machine, MyS

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

MySQL won't start...

2002-02-12 Thread FISHER,JOE (Non-HP-Roseville,ex1)
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 virtually all of the same applications... On the first machine, MySQL started right up, and has been working correctly ever since... On the second machine, MySQL w

MySQL won't start...

2002-02-09 Thread Victoria Reznichenko
FISHER, Friday, February 08, 2002, 9:01:10 PM, you wrote: Feoen> I have 2 SuSE Linux 7.2 machines at home... These boxes Feoen> have completely different hardware in each... But the Feoen> O/S on each, contains virtually all of Feoen> the same applications... Feoen> On the first machine, MyS

RE: MySQL won't start...

2002-02-08 Thread Eric Mayers
ary 08, 2002 11:01 AM > To: '[EMAIL PROTECTED]' > Subject: MySQL won't start... > > > 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 > virtually all of > the same ap