Re: Mysql on FreeBSD with a NT linked database

2003-01-16 Thread Nicolas
 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

2003-01-15 Thread Nicolas

 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

2003-01-15 Thread Dan Nelson
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

2003-01-14 Thread Nicolas
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

2003-01-14 Thread Jeremy Zawodny
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