Table says it is read only but it is not from file system level
I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - 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: Table says it is read only but it is not from file system level
On Tue, 1 Oct 2002, Rochester, Dean wrote: I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI Hi, Please verify that the user mysqld runs as has access to those tables. Somehow you didn't show us the owners and groups of those table data files. For example, running as 'mysql' user, doing 'chown mysql *' will suffice. BTW, the whole data directory should be owned by the mysqld-running user. Regards, Iikka When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Table says it is read only but it is not from file system level
You are connecting th the server, not the table. The server must have read and write permissions on the files. They must be owned by mysql, as must their directories. Rochester, Dean wrote: I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - 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: Table says it is read only but it is not from file system level
- Original Message - From: Rochester, Dean [EMAIL PROTECTED] To: MySQL (E-mail) (E-mail) [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:22 PM Subject: Table says it is read only but it is not from file system level I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI Hmm, peculiar permissions. Why is everything world-readable? If the mysql database it too, you could be in jeopardy. When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I remember something about compressed databases becoming read-only. Perhaps that is the case? I am using java to do this sql operation. Is that why you made everything world-readable, because you thought the web-daemon would need access? That should not be. The web-daemon will connect over socket (or tcp) to the MySQL server. As long as the databases are owned by the mysql user (if that is what the MySQL daemon runs as), you are okay; use chmod 660 (or perhaps 600 even). - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - 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