[sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk
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
Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk
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
Re: [sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk
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
On Sun, 12 Dec 2010 20:09:49 +0100, Marco Turco m.tu...@softwarexp.co.uk 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