Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

[Kees Nuyt]

On Sun, 12 Dec 2010 20:09:49 +0100, "Marco Turco"
 wrote:

>Hi all,
>
>I am having a problem running my Window Sqlite app on Mac OS X with Wine
>emulator.
>
>It runs well in local but when I try to access to a network disk hosted on
>Windows XP then a lock error appears.
>
>I checked on internet about this and as I know Sqlite at this moment doesn't
>support the Samba/CIFS disk with reference to the locking system.
>
>I am really in trouble because I have more than 50 customers with mixed
>network (Windows/Mac OS X) having this problem in the next future.
>
>Any ideas or turn-around to solve this problem ?

Alternatives:

1) Use a database server, like PostgreSQL.
http://www.sqlite.org/whentouse.html
You can develop with SQLite and run production with PostgreSQL,
because the SQL 'dialect' of postgres and sqlite are alike.

2) Redevelop your application so it accesses your sqlite databases
via a webinterface. That way the webserver is the only one to access
the sqlite files.
Make sure they are on local disk or SAN, not on a SMB or NFS share.

3) Use a SQLite stub on the client, connecting to a central SQLite
server instance.
http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork

Hope this helps.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

[Simon Slavin]

On 12 Dec 2010, at 7:09pm, Marco Turco wrote:

> I am having a problem running my Window Sqlite app on Mac OS X with Wine
> emulator.
> 
> It runs well in local but when I try to access to a network disk hosted on
> Windows XP 

The Wine emulator is an excellent emulator but it doesn't correctly emulate all 
the obscure elements of Windows.  Please try it on a proper Windows computer.

> I checked on internet about this and as I know Sqlite at this moment doesn't
> support the Samba/CIFS disk with reference to the locking system.

Sorry, I don't know.  However if you have both Mac and Windows clients trying 
to access the database simultaneously, you should be very careful with your 
settings for oplocks and such things.  Perhaps someone with experience of that 
kind of setup can help.

> I am really in trouble because I have more than 50 customers with mixed
> network (Windows/Mac OS X) having this problem in the next future.

I know this is not what you asked but I have advice.  If you have users with 
more than 5 or ten computers trying to access the database simultaneously, you 
may want to use a proper multi-user SQL engine instead of SQLite.  If you use a 
SQL engine with client/server architecture no disk locking is done: the only 
computer actually accessing the database files is the server.

I'm not saying that SQLite will fail, I'm saying that MySQL (and several 
similar systems) are specially designed for simultaneous multi-user access, and 
they do the job without having to worry about file locking and access from 
different types of computer.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

[Mathieu Schroeter]

Le 12. 12. 10 20:09, Marco Turco a écrit :
> Hi all,
> 
> I am having a problem running my Window Sqlite app on Mac OS X with Wine
> emulator.
> 
> It runs well in local but when I try to access to a network disk hosted on
> Windows XP 
> 
> then a lock error appears.
> 
> I checked on internet about this and as I know Sqlite at this moment doesn't
> support the Samba/CIFS disk with reference to the locking system.
> 
> I am really in trouble because I have more than 50 customers with mixed
> network (Windows/Mac OS X) having this problem in the next future.

Hi,

It works fine for me with a *Linux* Samba Server (SMB1). it is very bugged
with the SMB1, SMB2 and SMB2.1 provided by Microsoft. Even if the Oplocks
are disabled with SMB1.

-- 
Mathieu SCHROETER

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

[Marco Turco]

Hi all,

I am having a problem running my Window Sqlite app on Mac OS X with Wine
emulator.

 

It runs well in local but when I try to access to a network disk hosted on
Windows XP 

then a lock error appears.

 

I checked on internet about this and as I know Sqlite at this moment doesn't
support the Samba/CIFS disk with reference to the locking system.

I am really in trouble because I have more than 50 customers with mixed
network (Windows/Mac OS X) having this problem in the next future.

 

Any ideas or turn-around to solve this problem ?

 

Thanks in advance

 

Marco Turco

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users