Re: Mysql on FreeBSD with a NT linked database
In the last episode (Jan 15), Nicolas said: On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote: I'm running Freebsd 4.6.2 with mysql server v3.23.49 I have a little question about using Mysql on Freebsd and having a database on a NT 4 linked drive, using Samba (the drive was mounted on my FreeBSD system with Sharity-light because smbmount doesn't work on Freebsd) . I can query my database on the linked drive, but I cannot insert or update anything. I've always the read only error message when I try to insert a row .. Have you verified that the drive is mounted read/write? Hi Jeremy, yes the drive is mounted read-write. I've full acces on it and the folder's attribut is archive only. I wonder is this is a Sharity-light file locking problem. That's possible. Try starting mysql with --skip-locking and see if that helps. Thanks Dan, it was a good idea but I've tried and it doesn't help. I still have an error like table 'XX' is read only : ¬ | - 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: Mysql on FreeBSD with a NT linked database
On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote: Hi, I'm running Freebsd 4.6.2 with mysql server v3.23.49 I have a little question about using Mysql on Freebsd and having a database on a NT 4 linked drive, using Samba (the drive was mounted on my FreeBSD system with Sharity-light because smbmount doesn't work on Freebsd) . I can query my database on the linked drive, but I cannot insert or update anything. I've always the read only error message when I try to insert a row .. Have you verified that the drive is mounted read/write? -- Hi Jeremy, yes the drive is mounted read-write. I've full acces on it and the folder's attribut is archive only. I wonder is this is a Sharity-light file locking problem. [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: Mysql on FreeBSD with a NT linked database
In the last episode (Jan 15), Nicolas said: On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote: I'm running Freebsd 4.6.2 with mysql server v3.23.49 I have a little question about using Mysql on Freebsd and having a database on a NT 4 linked drive, using Samba (the drive was mounted on my FreeBSD system with Sharity-light because smbmount doesn't work on Freebsd) . I can query my database on the linked drive, but I cannot insert or update anything. I've always the read only error message when I try to insert a row .. Have you verified that the drive is mounted read/write? Hi Jeremy, yes the drive is mounted read-write. I've full acces on it and the folder's attribut is archive only. I wonder is this is a Sharity-light file locking problem. That's possible. Try starting mysql with --skip-locking and see if that helps. -- Dan Nelson [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
Mysql on FreeBSD with a NT linked database
Hi, I'm running Freebsd 4.6.2 with mysql server v3.23.49 I have a little question about using Mysql on Freebsd and having a database on a NT 4 linked drive, using Samba (the drive was mounted on my FreeBSD system with Sharity-light because smbmount doesn't work on Freebsd) . I can query my database on the linked drive, but I cannot insert or update anything. I've always the read only error message when I try to insert a row .. Any idea ? Is there any mysql configuration option to apply ? Thanks in advance. Nicolas - 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: Mysql on FreeBSD with a NT linked database
On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote: Hi, I'm running Freebsd 4.6.2 with mysql server v3.23.49 I have a little question about using Mysql on Freebsd and having a database on a NT 4 linked drive, using Samba (the drive was mounted on my FreeBSD system with Sharity-light because smbmount doesn't work on Freebsd) . I can query my database on the linked drive, but I cannot insert or update anything. I've always the read only error message when I try to insert a row .. Have you verified that the drive is mounted read/write? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 30 days, processed 1,007,078,290 queries (381/sec. avg) - 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