Re: Can't start MySQL 5.0.67
On Monday 08 September 2008, Joe Tseng said: I've got a server running FreeBSD7 and got MySQL 5.0.67 installed on it today. I ran mysql_install_db and then assigned the root password. I tried to get it running on boot (mysql_enable=YES) and by hand (/usr/local/etc/rc.d/mysql-server start) but I can't get the daemon to start. What else do I need to do to get this working? - Joe Check the logfiles in /var/db/mysql, they will usually tell you what it's choking on. My first guess without more info would be you probably don't have something configured correctly. Beech -- --- Beech Rintoul - FreeBSD Developer - [EMAIL PROTECTED] /\ ASCII Ribbon Campaign | FreeBSD Since 4.x \ / - NO HTML/RTF in e-mail | http://people.freebsd.org/~beech X - NO Word docs in e-mail | Skype: akbeech / \ - http://www.FreeBSD.org/releases/7.0R/announce.html --- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Can't start MySQL 5.0.67
So I checked in that directory you suggested and I found this: 080908 13:35:05 mysqld started 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 080908 13:35:05 mysqld ended So my questions are: 1. What directory is it referring to? Is it /var/db/mysql by default? I just tried to give ownership using chown -R mysql /var/db/mysql but that made no difference. 2. I've read also for this kind of issue I have to reinstall the software... When I initially installed this from ports I didn't use any kind of extra parameters. Are they needed? From: [EMAIL PROTECTED] To: freebsd-questions@freebsd.org Date: Mon, 8 Sep 2008 10:56:48 -0800 CC: [EMAIL PROTECTED] Subject: Re: Can't start MySQL 5.0.67 On Monday 08 September 2008, Joe Tseng said: I've got a server running FreeBSD7 and got MySQL 5.0.67 installed on it today. I ran mysql_install_db and then assigned the root password. I tried to get it running on boot (mysql_enable=YES) and by hand (/usr/local/etc/rc.d/mysql-server start) but I can't get the daemon to start. What else do I need to do to get this working? - Joe Check the logfiles in /var/db/mysql, they will usually tell you what it's choking on. My first guess without more info would be you probably don't have something configured correctly. Beech -- --- Beech Rintoul - FreeBSD Developer - [EMAIL PROTECTED] /\ ASCII Ribbon Campaign | FreeBSD Since 4.x \ / - NO HTML/RTF in e-mail | http://people.freebsd.org/~beech X - NO Word docs in e-mail | Skype: akbeech / \ - http://www.FreeBSD.org/releases/7.0R/announce.html --- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] _ Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Can't start MySQL 5.0.67
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joe Tseng wrote: So I checked in that directory you suggested and I found this: 080908 13:35:05 mysqld started 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 080908 13:35:05 mysqld ended So my questions are: 1. What directory is it referring to? Is it /var/db/mysql by default? I just tried to give ownership using chown -R mysql /var/db/mysql but that made no difference. 2. I've read also for this kind of issue I have to reinstall the software... When I initially installed this from ports I didn't use any kind of extra parameters. Are they needed? From: [EMAIL PROTECTED] To: freebsd-questions@freebsd.org Date: Mon, 8 Sep 2008 10:56:48 -0800 CC: [EMAIL PROTECTED] Subject: Re: Can't start MySQL 5.0.67 On Monday 08 September 2008, Joe Tseng said: I've got a server running FreeBSD7 and got MySQL 5.0.67 installed on it today. I ran mysql_install_db and then assigned the root password. I tried to get it running on boot (mysql_enable=YES) and by hand (/usr/local/etc/rc.d/mysql-server start) but I can't get the daemon to start. What else do I need to do to get this working? - Joe Check the logfiles in /var/db/mysql, they will usually tell you what it's choking on. My first guess without more info would be you probably don't have something configured correctly. Beech Hi Joe, Do you have a my.cnf file anywhere? If so, look for the following options and make sure that the directories they are set to are also accessible by the mysql user: innodb_data_home_dir innodb_data_file_path If that doesn't work, I often use truss (http://www.freebsd.org/cgi/man.cgi?query=trussapropos=0sektion=0manpath=FreeBSD+7.0-RELEASEformat=html) to debug permissions issues like this. You'll usually be able to tell from its output what syscall generates an EACCES and causes MySQL to fail. Regards, Greg - -- Greg Larkin http://www.FreeBSD.org/ - The Power To Serve http://www.sourcehosting.net/ - Ready. Set. Code. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIxX4k0sRouByUApARAsKWAJ9kXqvPltMfS8GE3GQWHKey1CxXZQCghwNz zzA4qQBzxZqci87+bufKCto= =rMlL -END PGP SIGNATURE- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Can't start MySQL 5.0.67
On Monday 08 September 2008, Joe Tseng said: So I checked in that directory you suggested and I found this: 080908 13:35:05 mysqld started 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 080908 13:35:05 mysqld ended So my questions are: 1. What directory is it referring to? Is it /var/db/mysql by default? I just tried to give ownership using chown -R mysql /var/db/mysql but that made no difference. 2. I've read also for this kind of issue I have to reinstall the software... When I initially installed this from ports I didn't use any kind of extra parameters. Are they needed? Yes, the /var/db/mysql dir needs to be readable and writeable by mysql. Try the following: chown -R mysql:mysql /var/db/mysql. The error is telling you that innodb can't create /var/db/mysql/ibdata1. After fixing permissions, you may need to do another initdb. Beech From: [EMAIL PROTECTED] To: freebsd-questions@freebsd.org Date: Mon, 8 Sep 2008 10:56:48 -0800 CC: [EMAIL PROTECTED] Subject: Re: Can't start MySQL 5.0.67 On Monday 08 September 2008, Joe Tseng said: I've got a server running FreeBSD7 and got MySQL 5.0.67 installed on it today. I ran mysql_install_db and then assigned the root password. I tried to get it running on boot (mysql_enable=YES) and by hand (/usr/local/etc/rc.d/mysql-server start) but I can't get the daemon to start. What else do I need to do to get this working? - Joe Check the logfiles in /var/db/mysql, they will usually tell you what it's choking on. My first guess without more info would be you probably don't have something configured correctly. Beech -- --- Beech Rintoul - FreeBSD Developer - [EMAIL PROTECTED] /\ ASCII Ribbon Campaign | FreeBSD Since 4.x \ / - NO HTML/RTF in e-mail | http://people.freebsd.org/~beech X - NO Word docs in e-mail | Skype: akbeech / \ - http://www.FreeBSD.org/releases/7.0R/announce.html --- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Can't start MySQL 5.0.67
Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did it... Thx to all for the help. - Joe From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Mon, 8 Sep 2008 11:46:02 -0800 CC: freebsd-questions@freebsd.org Subject: Re: Can't start MySQL 5.0.67 On Monday 08 September 2008, Joe Tseng said: So I checked in that directory you suggested and I found this: 080908 13:35:05 mysqld started 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 080908 13:35:05 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 080908 13:35:05 mysqld ended So my questions are: 1. What directory is it referring to? Is it /var/db/mysql by default? I just tried to give ownership using chown -R mysql /var/db/mysql but that made no difference. 2. I've read also for this kind of issue I have to reinstall the software... When I initially installed this from ports I didn't use any kind of extra parameters. Are they needed? Yes, the /var/db/mysql dir needs to be readable and writeable by mysql. Try the following: chown -R mysql:mysql /var/db/mysql. The error is telling you that innodb can't create /var/db/mysql/ibdata1. After fixing permissions, you may need to do another initdb. Beech From: [EMAIL PROTECTED] To: freebsd-questions@freebsd.org Date: Mon, 8 Sep 2008 10:56:48 -0800 CC: [EMAIL PROTECTED] Subject: Re: Can't start MySQL 5.0.67 On Monday 08 September 2008, Joe Tseng said: I've got a server running FreeBSD7 and got MySQL 5.0.67 installed on it today. I ran mysql_install_db and then assigned the root password. I tried to get it running on boot (mysql_enable=YES) and by hand (/usr/local/etc/rc.d/mysql-server start) but I can't get the daemon to start. What else do I need to do to get this working? - Joe Check the logfiles in /var/db/mysql, they will usually tell you what it's choking on. My first guess without more info would be you probably don't have something configured correctly. Beech -- --- Beech Rintoul - FreeBSD Developer - [EMAIL PROTECTED] /\ ASCII Ribbon Campaign | FreeBSD Since 4.x \ / - NO HTML/RTF in e-mail | http://people.freebsd.org/~beech X - NO Word docs in e-mail | Skype: akbeech / \ - http://www.FreeBSD.org/releases/7.0R/announce.html --- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] _ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Can't start MySQL 5.0.67
Joe Tseng wrote: Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did it... Thx to all for the help. - Joe [snip] Look in /usr/local/share/mysql for my.cnf examples you can use for tuning your install. One thing that bit me once was the location of the my.cnf changed. I used to keep it in /var/db/mysql but found after one particular upgrade it seemed like it wasn't being read any longer. That was because the FreeBSD port install's new default location changed to /usr/local/etc. -Mike ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
