RE: Upgrading to 3.23.37 from 3.22.32
My suggestion would be to chown the database files to the same ownership of the mysqld daemon. This should solve your persmission issues. -Original Message- From:Adam Douglas [EMAIL PROTECTED] Sent:Thu, 9 Aug 2001 10:11:44 -0600 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Upgrading to 3.23.37 from 3.22.32 Ok but I've have chmod 777 on a couple of tables and I still receive table in read only message. Plus I was under the understanding that you only need say 700 because the mysql daemon it self would be modifying the files directly and not the client using MySQL. > -Original Message- > From: Gerald Clark [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 08, 2001 7:38 AM > To: Adam Douglas > Cc: [EMAIL PROTECTED] > Subject: Re: Upgrading to 3.23.37 from 3.22.32 > > > Except, mysql needs write permission. > > Adam Douglas wrote: > > > MySQL reports read only table. As for file permissions, > everything is fine. > > Everyone has read and execute privileges. > > > > > >> They are probably not owned by mysql anymore. > >> > >> Adam Douglas wrote: > >> > >> > >>> I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was > >>> pkg_delete the old MySQL and install the new one. Before I > >> > >> delete the old > >> > >>> MySQL I copied all the database files to a temporary > >> > >> location. Once the new > >> > >>> installation was successful I copied over all the database > >> > >> files into the > >> > >>> proper location. > >>> > >>> My problem is I seem to have 3 extra tables now, A-1, A-9 > >> > >> and A-ce. The > >> > >>> funny thing is they all seem to be linked to my tables. > >> > >> These tables to my > >> > >>> knowledge were not present in the MySQL 3.22.32. Also I > >> > >> can't seem to remove > >> > >>> the test user from mysql->db, MySQL says it's read only. I > >> > >> never made the > >> > >>> table read only and doesn't seem to be. - 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 ___ Visit http://www.visto.com. Find out how companies are linking mobile users to the enterprise with Visto. - 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
RE: Upgrading to 3.23.37 from 3.22.32
Ok but I've have chmod 777 on a couple of tables and I still receive table in read only message. Plus I was under the understanding that you only need say 700 because the mysql daemon it self would be modifying the files directly and not the client using MySQL. > -Original Message- > From: Gerald Clark [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 08, 2001 7:38 AM > To: Adam Douglas > Cc: [EMAIL PROTECTED] > Subject: Re: Upgrading to 3.23.37 from 3.22.32 > > > Except, mysql needs write permission. > > Adam Douglas wrote: > > > MySQL reports read only table. As for file permissions, > everything is fine. > > Everyone has read and execute privileges. > > > > > >> They are probably not owned by mysql anymore. > >> > >> Adam Douglas wrote: > >> > >> > >>> I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was > >>> pkg_delete the old MySQL and install the new one. Before I > >> > >> delete the old > >> > >>> MySQL I copied all the database files to a temporary > >> > >> location. Once the new > >> > >>> installation was successful I copied over all the database > >> > >> files into the > >> > >>> proper location. > >>> > >>> My problem is I seem to have 3 extra tables now, A-1, A-9 > >> > >> and A-ce. The > >> > >>> funny thing is they all seem to be linked to my tables. > >> > >> These tables to my > >> > >>> knowledge were not present in the MySQL 3.22.32. Also I > >> > >> can't seem to remove > >> > >>> the test user from mysql->db, MySQL says it's read only. I > >> > >> never made the > >> > >>> table read only and doesn't seem to be. - 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
RE: Upgrading to 3.23.37 from 3.22.32
That sounds more accurate to me, but I still seem to be getting table is read only error messages when trying to do updates/grants (haven't tried inserts). I'm lost as to why it's in read only mode. > -Original Message- > From: Stefan Hinz [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 08, 2001 2:23 AM > To: Adam Douglas; 'Gerald Clark'; [EMAIL PROTECTED] > Subject: Re: Upgrading to 3.23.37 from 3.22.32 > > > Dear Gerald, > > does mysqld run as user "mysql"? And does user mysql have the correct > rights for datadir (e. g. /var/lib/mysql/) and all subdirectories? > > (The MySQL Daemon is supposed to be the only one who has rights for > datadir. So, this could be 700 with user mysql as owner. No one else > needs rights to this directory, as no one else will access the > directories and files in datadir directly, only the daemon / > server has > to.) > - Original Message - > From: "Adam Douglas" <[EMAIL PROTECTED]> > To: "'Gerald Clark'" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, August 07, 2001 11:02 PM > Subject: RE: Upgrading to 3.23.37 from 3.22.32 > > > > MySQL reports read only table. As for file permissions, > everything is > fine. > > Everyone has read and execute privileges. > > > > > > > > They are probably not owned by mysql anymore. > > > > > > Adam Douglas wrote: > > > > > > > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. > All I did was > > > > pkg_delete the old MySQL and install the new one. Before I > > > delete the old > > > > MySQL I copied all the database files to a temporary > > > location. Once the new > > > > installation was successful I copied over all the database > > > files into the > > > > proper location. > > > > > > > > My problem is I seem to have 3 extra tables now, A-1, A-9 > > > and A-ce. The > > > > funny thing is they all seem to be linked to my tables. > > > These tables to my > > > > knowledge were not present in the MySQL 3.22.32. Also I > > > can't seem to remove > > > > the test user from mysql->db, MySQL says it's read only. I > > > never made the > > > > table read only and doesn't seem to be. > > > > > > > > Anyone have any ideas of what is going on? I feel kind of > > > lost now, any help > > > > would be greatly appreciated. - 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
Re: Upgrading to 3.23.37 from 3.22.32
Except, mysql needs write permission. Adam Douglas wrote: > MySQL reports read only table. As for file permissions, everything is fine. > Everyone has read and execute privileges. > > >> They are probably not owned by mysql anymore. >> >> Adam Douglas wrote: >> >> >>> I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was >>> pkg_delete the old MySQL and install the new one. Before I >> >> delete the old >> >>> MySQL I copied all the database files to a temporary >> >> location. Once the new >> >>> installation was successful I copied over all the database >> >> files into the >> >>> proper location. >>> >>> My problem is I seem to have 3 extra tables now, A-1, A-9 >> >> and A-ce. The >> >>> funny thing is they all seem to be linked to my tables. >> >> These tables to my >> >>> knowledge were not present in the MySQL 3.22.32. Also I >> >> can't seem to remove >> >>> the test user from mysql->db, MySQL says it's read only. I >> >> never made the >> >>> table read only and doesn't seem to be. >>> >>> Anyone have any ideas of what is going on? I feel kind of >> >> lost now, any help >> >>> would be greatly appreciated. >> -- Gerald L. Clark [EMAIL PROTECTED] - 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
Re: Upgrading to 3.23.37 from 3.22.32
Dear Gerald, does mysqld run as user "mysql"? And does user mysql have the correct rights for datadir (e. g. /var/lib/mysql/) and all subdirectories? (The MySQL Daemon is supposed to be the only one who has rights for datadir. So, this could be 700 with user mysql as owner. No one else needs rights to this directory, as no one else will access the directories and files in datadir directly, only the daemon / server has to.) Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: "Adam Douglas" <[EMAIL PROTECTED]> To: "'Gerald Clark'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 11:02 PM Subject: RE: Upgrading to 3.23.37 from 3.22.32 > MySQL reports read only table. As for file permissions, everything is fine. > Everyone has read and execute privileges. > > > > > They are probably not owned by mysql anymore. > > > > Adam Douglas wrote: > > > > > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was > > > pkg_delete the old MySQL and install the new one. Before I > > delete the old > > > MySQL I copied all the database files to a temporary > > location. Once the new > > > installation was successful I copied over all the database > > files into the > > > proper location. > > > > > > My problem is I seem to have 3 extra tables now, A-1, A-9 > > and A-ce. The > > > funny thing is they all seem to be linked to my tables. > > These tables to my > > > knowledge were not present in the MySQL 3.22.32. Also I > > can't seem to remove > > > the test user from mysql->db, MySQL says it's read only. I > > never made the > > > table read only and doesn't seem to be. > > > > > > Anyone have any ideas of what is going on? I feel kind of > > lost now, any help > > > would be greatly appreciated. > > - > 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
RE: Upgrading to 3.23.37 from 3.22.32
MySQL reports read only table. As for file permissions, everything is fine. Everyone has read and execute privileges. > > They are probably not owned by mysql anymore. > > Adam Douglas wrote: > > > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was > > pkg_delete the old MySQL and install the new one. Before I > delete the old > > MySQL I copied all the database files to a temporary > location. Once the new > > installation was successful I copied over all the database > files into the > > proper location. > > > > My problem is I seem to have 3 extra tables now, A-1, A-9 > and A-ce. The > > funny thing is they all seem to be linked to my tables. > These tables to my > > knowledge were not present in the MySQL 3.22.32. Also I > can't seem to remove > > the test user from mysql->db, MySQL says it's read only. I > never made the > > table read only and doesn't seem to be. > > > > Anyone have any ideas of what is going on? I feel kind of > lost now, any help > > would be greatly appreciated. - 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
Re: Upgrading to 3.23.37 from 3.22.32
They are probably not owned by mysql anymore. Adam Douglas wrote: > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was > pkg_delete the old MySQL and install the new one. Before I delete the old > MySQL I copied all the database files to a temporary location. Once the new > installation was successful I copied over all the database files into the > proper location. > > My problem is I seem to have 3 extra tables now, A-1, A-9 and A-ce. The > funny thing is they all seem to be linked to my tables. These tables to my > knowledge were not present in the MySQL 3.22.32. Also I can't seem to remove > the test user from mysql->db, MySQL says it's read only. I never made the > table read only and doesn't seem to be. > > Anyone have any ideas of what is going on? I feel kind of lost now, any help > would be greatly appreciated. > > - > 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 -- Gerald L. Clark [EMAIL PROTECTED] - 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
