Re: Hey what, no pity for a new user?
That didn't work but it led to something that did. It turned out that the owning group didn't have full authorization in the data folder. So, I did a brute force approach. I made mysql the owner of everything, instead of root, made mysql the group of everything (which it already was), then made the group privileges equal to the owner privileges (of everything). It worked. Do you foresee it leading to problems or security risks? Thanks again for your response! On Apr 8, 2004, at 9:01 AM, Paul DuBois wrote: At 8:29 -0600 4/8/04, Kevin Jaques wrote: Thanks for the reply. I feel it is getting me somewhere, but I'm not there yet. The log said, regarding the most recent attempt: 040407 09:55:24 mysqld started 040407 9:55:25 InnoDB: Operating system error number 13 in a file operation. 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: 'create'. InnoDB: Cannot continue operation. 040407 09:55:25 mysqld ended What directory is it referring to? What user/group does mysqld need? I The data directory, as you indicate that you already know below. The user account that is relevant here is whatever account you use for running the server. I will suppose that this is mysql on your system? referred to the web site it mentioned, and the page was enormous without an apparent section on installation or authorization issues. A search revealed that it thought the mysql server should have access to 'datadir'. Well, duh. My data directory shows: [iMac-dv:local/mysql/data] kj% ls -al total 8 drwxr-x--- 5 root wheel 170 5 Apr 08:03 ./ drwxr-xr-x 20 root wheel 680 10 Feb 13:05 ../ -rw-rw 1 mysql wheel 2234 7 Apr 09:55 iMac-dv.local.err drwxr-x--- 20 root wheel 680 10 Feb 13:05 mysql/ drwxr-x--- 2 root wheel68 10 Feb 13:05 test/ So, what now? This shows that it's owned by root/wheel. You want it to be owned by mysql/some-group. I don't know what group that will be for you. mysql? Anyway, in that directory, run this command as root: chown -R mysql . That changes the ownership of the directory and everything under it to mysql. Then restart the server, either from the mysql account, or as root with the --user=mysql option. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- Sincerely, Kevin Jaques (at home) Use [EMAIL PROTECTED] for work related messages Send lawyers, guns and money! Dad get me out of this! - Warren Zevon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
At 8:29 -0600 4/8/04, Kevin Jaques wrote: Thanks for the reply. I feel it is getting me somewhere, but I'm not there yet. The log said, regarding the most recent attempt: 040407 09:55:24 mysqld started 040407 9:55:25 InnoDB: Operating system error number 13 in a file operation. 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: 'create'. InnoDB: Cannot continue operation. 040407 09:55:25 mysqld ended What directory is it referring to? What user/group does mysqld need? I The data directory, as you indicate that you already know below. The user account that is relevant here is whatever account you use for running the server. I will suppose that this is mysql on your system? referred to the web site it mentioned, and the page was enormous without an apparent section on installation or authorization issues. A search revealed that it thought the mysql server should have access to 'datadir'. Well, duh. My data directory shows: [iMac-dv:local/mysql/data] kj% ls -al total 8 drwxr-x--- 5 root wheel 170 5 Apr 08:03 ./ drwxr-xr-x 20 root wheel 680 10 Feb 13:05 ../ -rw-rw 1 mysql wheel 2234 7 Apr 09:55 iMac-dv.local.err drwxr-x--- 20 root wheel 680 10 Feb 13:05 mysql/ drwxr-x--- 2 root wheel68 10 Feb 13:05 test/ So, what now? This shows that it's owned by root/wheel. You want it to be owned by mysql/some-group. I don't know what group that will be for you. mysql? Anyway, in that directory, run this command as root: chown -R mysql . That changes the ownership of the directory and everything under it to mysql. Then restart the server, either from the mysql account, or as root with the --user=mysql option. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey what, no pity for a new user?
A couple days ago, I posted a careful message of my troubles, but no reply to date. Remember, after I tried to assign a password for the root user, it broke. Since then, I discovered that Mac OS X refuses to let me create a user account called 'mysql'. Apparently that account comes preconfigured since the latest version (Panther). But since I had an account by that name before I installed Panther, but then deleted in a misguided attempt to fix my problems, I was in a boat. I created a new dummy account, then used NetInfoManager to rename everything. Then I used Terminal to rename the home directory, and SharePoints to add the new user to the mysql account and delete the dummy group. Then I used Terminal to change the group of all the stuff in the new home directory. So now it has quit complaining about the chown command, but it still quits immediately when I try to run mysqld_safe, as follows: [iMac-dv:/usr/local/mysql] kj% cd /usr/local/mysql [iMac-dv:/usr/local/mysql] kj% sudo bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 040407 09:55:25 mysqld ended [iMac-dv:/usr/local/mysql] kj% I would be happy to just kill it and start over. -- Sincerely, Kevin Jaques (at home) Use [EMAIL PROTECTED] for work related messages Send lawyers, guns and money! Dad get me out of this! - Warren Zevon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
i wouldn't say there is no pity, but there is probably a very low concentration of mysql people running on macos. Just my two cents... dan Kevin Jaques wrote: A couple days ago, I posted a careful message of my troubles, but no reply to date. Remember, after I tried to assign a password for the root user, it broke. Since then, I discovered that Mac OS X refuses to let me create a user account called 'mysql'. Apparently that account comes preconfigured since the latest version (Panther). But since I had an account by that name before I installed Panther, but then deleted in a misguided attempt to fix my problems, I was in a boat. I created a new dummy account, then used NetInfoManager to rename everything. Then I used Terminal to rename the home directory, and SharePoints to add the new user to the mysql account and delete the dummy group. Then I used Terminal to change the group of all the stuff in the new home directory. So now it has quit complaining about the chown command, but it still quits immediately when I try to run mysqld_safe, as follows: [iMac-dv:/usr/local/mysql] kj% cd /usr/local/mysql [iMac-dv:/usr/local/mysql] kj% sudo bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 040407 09:55:25 mysqld ended [iMac-dv:/usr/local/mysql] kj% I would be happy to just kill it and start over. -- Sincerely, Kevin Jaques (at home) Use [EMAIL PROTECTED] for work related messages Send lawyers, guns and money! Dad get me out of this! - Warren Zevon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
I know nothing about Macs specifically. However under linux ... My first question would be 'what's in the error log'? Often in /var/lib/mysql/host.err Next, have you run the mysql_install_db script to create default databases and permissions? Next, have you checked that use mysql has permission to access the data directory and socket directory? Jim PS I am answering loads of questions in the hope that the power of my Karma will force someone to answer mine ... (join problem:indexed columns being ignored) (This email has been scanned for viruses by www.emf-systems.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
At 9:58 -0600 4/7/04, Kevin Jaques wrote: A couple days ago, I posted a careful message of my troubles, but no reply to date. Remember, after I tried to assign a password for the root user, it broke. Since then, I discovered that Mac OS X refuses to let me create a user account called 'mysql'. Apparently that account comes preconfigured since the latest version (Panther). But since I had an account by that name before I installed Panther, but then deleted in a misguided attempt to fix my problems, I was in a boat. I created a new dummy account, then used NetInfoManager to rename everything. Then I used Terminal to rename the home directory, and SharePoints to add the new user to the mysql account and delete the dummy group. Then I used Terminal to change the group of all the stuff in the new home directory. So now it has quit complaining about the chown command, but it still quits immediately when I try to run mysqld_safe, as follows: [iMac-dv:/usr/local/mysql] kj% cd /usr/local/mysql [iMac-dv:/usr/local/mysql] kj% sudo bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 040407 09:55:25 mysqld ended [iMac-dv:/usr/local/mysql] kj% What does the error log say? (It'll probably be in /usr/local/mysql/data, and should be the file with a suffix of .err) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
Jim Page - EMF Systems Ltd [EMAIL PROTECTED] wrote on 07/04/2004 17:14:57: PS I am answering loads of questions in the hope that the power of my Karma will force someone to answer mine ... (join problem:indexed columns being ignored) My first reaction would be to turn your index round. Something with settings of y and n is going to make a rotten index, especially as the first part. It is possible that MySQL will look at that part of it, decide that this is a lousy index, and ditch it. If you put the diffuse part of the index first, then the boolean, it might sort better. I don't think you have to change your query - I think MySQL is savvy enough to commute over the AND. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
Many thanks Alec. I need to wait a couple of hours before I can block access to the DB by messing with the indexes, but I will try out what you suggest. What you say makes sense as probably over 99% of the values in that first col will be 'y'. I will post my progress. I am also looking into recoding the where clause as inner joins ... I didn;t expect this to make any difference as I would have thought mysql figures this out but it _seems_ to cut down the query time to 2-3 secs without using any extra index columns ... bizarre. But I'll take what I can get. Answering questions definitely gets answers ... there is a pithy aphorism in there somewhere ... :) Jim PS I am answering loads of questions in the hope that the power of my Karma will force someone to answer mine ... (join problem:indexed columns being ignored) My first reaction would be to turn your index round. Something with settings of y and n is going to make a rotten index, especially as the first part. It is possible that MySQL will look at that part of it, decide that this is a lousy index, and ditch it. If you put the diffuse part of the index first, then the boolean, it might sort better. I don't think you have to change your query - I think MySQL is savvy enough to commute over the AND. (This email has been scanned for viruses by www.emf-systems.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
I'm not sure if this is part of your problem or not Kevin, seems you have a few issues, so I'll cover them one at at time... getting the permissions and ownership correct, this is cut/paste from the INSTALL docs, pretty much cut/pasteable to your sytem (errr): groupadd mysql useradd -g mysql mysql cd {wherever mysql is installed} scripts/mysql_install_db chown -R root . chown -R mysql data chgrp -R mysql . run mysql with: bin/mysqld_safe --user=mysql setting up the root user access: I found a few times MySQL had issues with setting up the root user, host access. This was in the past, and I've since found it seems ok, but every now and then it bombs out. Never did figure out why. But there is a solution to it. if you read the docs as per installation, it talks about setting up the new install, setting the root user password, and then allowing the host access. here's the root user password setup line: bin/mysqladmin -u root password your_password where your_password is the password you want. and password is the actual word password - so many people get confused about that. and this line: bin/mysqladmin -u root -h `hostname` password password for me, it was always the host access line that failed. but give this a shot. hopefully it helps a bit. Dan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hey what, no pity for a new user?
If apple continues to bundle MySQL with panther and does not give any kind of support for it's users, they should at least donate a few machines to us, so we can play with it and give some kind of support! YEAP I'll keep dreaming! =) jeje -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]