It means mysql does not own its directories and files. chown -R mysql /usr/local/that-long-directory-name-that-should-have-been -symlinked
Richard W. Berriman wrote: >The contents of the error log in > >mysql-3.23.49a-pc-linux-gnu-i686/data is: > > >020908 17:00:27 mysqld started > > >020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: >Can't c >reate/write to file >'/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data/accesscomm >.ca.pid' (Errcode: 13) > >020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: >Can't f >ind file: './mysql/host.frm' (errno: 13) > > >020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: >Error o >n delete of >'/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data/accesscomm.ca.pid' > (Errcode: 13) > >020908 17:00:28 /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/bin/mysqld: >Normal >shutdown > >mysqld got signal 11; >This could be because you hit a bug. It is also possible that this binary > >or one of the libraries it was linked agaist is corrupt, improperly built, >or one of the libraries it was linked agaist is corrupt, improperly built, >or misconfigured. This error can also be caused by malfunctioning hardware. >We will try our best to scrape up some info that will hopefully help >diagnose >the problem, but since we have already crashed, something is definitely >wrong > >and this may fail > >key_buffer_size=8388600 >record_buffer=131072 >sort_buffer=2097144 >max_used_connections=0 > > >max_connections=100 >threads_connected=0 >max_connections=100 >threads_connected=0 >It is possible that mysqld could use up to > >key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K >key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K >bytes of memory > > >Hope that's ok, if not, decrease some variables in the equation > >Hope that's ok, if not, decrease some variables in the equation > >020908 17:00:28 mysqld ended > >End Log > >Could it be perhaps because I am installing 3.23 into a new directory? >Would I be wiser to just install 4.x and be done with it? I am installing >3.23 primarily to access search capabilities...which I am now slugging out >in php... > >Perhaps I need to reinstall the other associated packages (Apache and PHP) >in order for compatibilty, but my now aging documentation for 3.22 had me >test out the MySQL install before proceeding... > >Thanks Everyone for helping me out! I'm still hammering at this one :-) > >Richard > >-----Original Message----- >From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] >Sent: Monday, September 09, 2002 5:48 AM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: RE: Upgrading > > >Hello Richard, >I just went through something similar with upgrading from 3.23.49 to 4.03. >The reason you can't connect to MySQL is > >>020908 15:53:33 mysqld ended >> >This should obviously not be here. >Check the error logs to see if they say anything important and/or helpful >there. Most likely found under >/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data in your case. >Also, have you re-linked the usr/local/mysql link with the new folder? >And check to make sure that the data folder is owned by MySQL and that its >group is also MySQL with the correct permissions. >I also found that once I installed the new MySQL, and got it working, I >had to go back and recompile Apache with all the packages you need (of >course making sure to add MySQL support) for it to work correctly. I don't >know if this is necessary but it's how I resolved the problem. >Hope this helps. > >-Nick > >>Update: Now, after rebooting the server, the site can't connect...that's >>more like it ;) >> >>-----Original Message----- >>From: Richard W. Berriman [mailto:[EMAIL PROTECTED]] >>Sent: Sunday, September 08, 2002 4:43 PM >>To: [EMAIL PROTECTED] >>Subject: Upgrading >> >> >> >>Hi! >> >>I have a number of tables in development in 3.22.32 >> >>(running in apache_1.3.12 on a linux kernel) >> >>I'd really like to upgrade to 3.23.49a but my installs in both rpm and >>binary have not succeeded in "taking over" from my previous install. >> >>I've read quite a bit at the mysql.com site, but haven't found the >>appropriate documentation ... my last attempt was >> >>by downloading >> >>MySQL-3.23.49-1.src.rpm, >> >>0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop) >> >>1. cp MySQL-3.23.49-1.src.rpm into /usr/local >>2. rpm --recompile MySQL-3.23.49-1.src.rpm >>3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld & // To start >>MySQL & use it >> >>This returns: >> >>Starting mysqld daemon with databases from /usr/local/m >>ysql-3.23.49a-pc-linux-gnu-i686/data >>020908 15:53:33 mysqld ended >> >>And the Mysql database driven website works... >> >>Yet, when I want to go into line commands (to alter tables for easy >>searching) using: >> >>mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql >> >>I get >> >>ERROR 2002: Can't connect to local MySQL server through socket >>'/tmp/mysql.sock' >> (111) >> >>There is no file by that name there... >> >>Well thankyou for any help :-) >> >>Richard >> >> >> >>--------------------------------------------------------------------- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail >><[EMAIL PROTECTED]> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> >> >>--------------------------------------------------------------------- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail >> ><[EMAIL PROTECTED]> > >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> > > > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php