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:

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

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'

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

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  

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

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

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

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

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:                    

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

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

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

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

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? can

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

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 21

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=8843UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST mtu 1500 options=1aTXCSUM,VLAN_MTU,VLAN_HWTAGGING inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100

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

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=8843UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST mtu 1500 options=1aTXCSUM,VLAN_MTU,VLAN_HWTAGGING inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet

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

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

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

2004-08-12 Thread Chris Blackwell
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] wrote: now when ever i try to start mysql i get

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

2004-08-12 Thread V. M. Brasseur
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] wrote: now when ever i try to start mysql i get

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

2004-08-12 Thread Chris Blackwell
-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'. Any idea why the server crashed

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

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 If

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

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 I

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