Re: [sqlite] database is locked error on Mac OS X
Hi Richard and Puneet, I just wanted to say thanks, and to record your combined advice that worked. Much of this may be superfluous or painfully obvious, but it worked: 1. In the sqlite-3.3.13 downloaded source directory, execute: ./configure 2. That creates a new file "MakeFile". Edit that file in any text editor, and add these lines: # flag to deal with Mac OS X file locking on shared drives TCC += -DSQLITE_ENABLE_LOCKING_STYLE=1 I put them just before the line: # You should not have to change anything below this line 3. Execute: sudo make sudo make install Done. You can now run/test the new sqlite3 command line tool by executing: /usr/local/bin/sqlite3 which will show: SQLite version 3.3.13 Enter ".help" for instructions Editing a database file on a remote volume now works with this modified latest version. Thanks again. Tom - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: Fwd: [sqlite] database is locked error on Mac OS X
On 3/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: T&B <[EMAIL PROTECTED]> wrote: > Can someone please tell me (politely ;-) where to put the - > DSQLITE_ENABLE_LOCKING_STYLE=1 > > I tried inserting it arbitrarily in the Makefile.in file but it > didn't seem to make a difference. > Do "configure". Then edit the Makefile that is generated. I think Tom is trying to figure out where exactly in the Makefile to insert the D flag. Tom, I am walking on thin ice here, but after you have run ./configure, you could try inserting a line like so pretty much anywhere in your Makefile.in AFTER TCC has been declared. So, you could add a line like so # flag to deal with Mac OS X file locking on shared drives TCC += -DSQLITE_ENABLE_LOCKING_STYLE=1 Obviously, I could be way wrong about this, but if I am, hopefully someone will chime up and tell us so., -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ - collaborate, communicate, compete = - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: Fwd: [sqlite] database is locked error on Mac OS X
T&B <[EMAIL PROTECTED]> wrote: > Can someone please tell me (politely ;-) where to put the - > DSQLITE_ENABLE_LOCKING_STYLE=1 > > I tried inserting it arbitrarily in the Makefile.in file but it > didn't seem to make a difference. > Do "configure". Then edit the Makefile that is generated. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Fwd: [sqlite] database is locked error on Mac OS X
Can someone please tell me (politely ;-) where to put the - DSQLITE_ENABLE_LOCKING_STYLE=1 I tried inserting it arbitrarily in the Makefile.in file but it didn't seem to make a difference. Don't laugh :-[ ;-) Thanks, Tom From: T&B <[EMAIL PROTECTED]> Date: 9 March 2007 1:46:21 PM To: sqlite-users@sqlite.org Subject: [sqlite] database is locked error on Mac OS X Reply-To: sqlite-users@sqlite.org I recently installed SQLite 3.3.13, after having used previous versions. I now get an error: Error: database is locked This is not a bug in SQLite - it is a bug in Apple's implementation (or more precisely their lack of implementation) of POSIX advisory locks for AppleShare mounted volumes. The SQLite sources include an (Apple-supplied) patch to work around the problem. Thank you :-) Recompile with -DSQLITE_ENABLE_LOCKING_STYLE=1 Pardon my ignorance, but where/how exactly do I enter this before recompiling? Thanks, Tom - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] database is locked error on Mac OS X
I recently installed SQLite 3.3.13, after having used previous versions. I now get an error: Error: database is locked This is not a bug in SQLite - it is a bug in Apple's implementation (or more precisely their lack of implementation) of POSIX advisory locks for AppleShare mounted volumes. The SQLite sources include an (Apple-supplied) patch to work around the problem. Thank you :-) Recompile with -DSQLITE_ENABLE_LOCKING_STYLE=1 Pardon my ignorance, but where/how exactly do I enter this before recompiling? Thanks, Tom - To unsubscribe, send email to [EMAIL PROTECTED] -