[sqlite] Disable lock controls on Windows
Hi all, As I remember it is possible to disable the Sqlite locking method in the Unix compiled lib but is it possible also to disable the locking in the Windows compiled lib of Sqlite ? There are locking problems in some "exotic" hardware configuration for which I should manage the locking method from myself using a semaphone file. Any suggest ? Thanks in advance. Regards, Marco Turco IT Business Devl Manager Software XP LLP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SEE encryption lib and odbc
Hi all, We are successfully using the SEE module in Sqlite. All runs well but we need to provide a ODBC connection to a limited number of users. Question: is there a Sqlite odbc driver SEE compatible ? Thanks. Regards, Marco Turco IT Business Devl Manager Software XP LLP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00
Hi all, I'm trying to generate the sqlite3 library but there is no way with Embercadero C++ 7.00. I always receive some warnings and the first two related to the _endthreadex' and '_beginthreadex' cannot permit to link me the library. See below. k:\BCC70\Bin\Bcc32.Exe -DHB_NO_DEFAULT_API_MACROS -M -c -O2 -e -tW -DHB_NO_DEFAULT_STACK_MACROS -DHB_OS_WIN_USED -DHB_FM_STATISTICS_OFF -D__HARBOUR__ -DSQLITE_HAS_CODEC=1 -Ik:\BCC70\Include;k:\XHARBOUR\Include -nK:\sqlite_see_2013\Obj K:\sqlite_see_2013\sqlite3.c Embarcadero C++ 7.00 for Win32 Copyright (c) 1993-2015 Embarcadero Technologies, Inc. K:\sqlite_see_2013\sqlite3.c: Warning W8065 K:\sqlite_see_2013\sqlite3.c 23909: Call to function '_endthreadex' with no prototype in function sqlite3ThreadProc Warning W8065 K:\sqlite_see_2013\sqlite3.c 23936: Call to function '_beginthreadex' with no prototype in function sqlite3ThreadCreate Warning W8057 K:\sqlite_see_2013\sqlite3.c 38624: Parameter 'iOff' is never used in function winUnfetch Warning W8060 K:\sqlite_see_2013\sqlite3.c 80952: Possibly incorrect assignment in function vdbeSorterCompareInt Warning W8060 K:\sqlite_see_2013\sqlite3.c 82583: Possibly incorrect assignment in function vdbeSorterSetupMerge Warning W8057 K:\sqlite_see_2013\sqlite3.c 185433: Parameter 'iDb' is never used in function sqlite3CodecGetKey k:\BCC70\Bin\TLib.Exe K:\sqlite_see_2013\sqlite_see_2013.Lib /P512 @K:\sqlite_see_2013\sqlite_see_2013.bcl , K:\sqlite_see_2013\Debug\sqlite_see_2013.Lst TLIB 6.4 Copyright (c) 1987-2014 Embarcadero Technologies, Inc. +K:\sqlite_see_2013\Obj\sqlite3.Obj Any help ? Thank you in advance Marco
[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00
The problem is when I link the generated library. I receive the following error related to the first two warnings so I'm unable to generate the executable file. Embarcadero C++ 7.00 for Win32 Copyright (c) 1993-2015 Embarcadero Technologies, Inc. K:\RENTMNG\Obj\mod306f.c: k:\BCC70\Bin\iLink32.Exe -Gn -aa -Tpe -s @K:\RENTMNG\RENTMNG.bcl Turbo Incremental Link 6.70 Copyright (c) 1997-2014 Embarcadero Technologies, Inc. Error: Unresolved external '__endthreadex' referenced from K:\ACTIVEXP\SOURCE\SQLITE.SEE\SQLITE3.LIB|sqlite3 Error: Unresolved external '__beginthreadex' referenced from K:\ACTIVEXP\SOURCE\SQLITE.SEE\SQLITE3.LIB|sqlite3 Error: Unable to perform link Marco -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.Smith Sent: Thursday, October 22, 2015 12:12 PM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00 On 2015-10-22 11:01 AM, Marco Turco wrote: > Hi all, > > I'm trying to generate the sqlite3 library but there is no way with > Embercadero C++ 7.00. > > I always receive some warnings and the first two related to the > _endthreadex' and '_beginthreadex' cannot permit to link me the library. > > > > See below. > > > > k:\BCC70\Bin\Bcc32.Exe -DHB_NO_DEFAULT_API_MACROS -M -c -O2 -e -tW > -DHB_NO_DEFAULT_STACK_MACROS -DHB_OS_WIN_USED -DHB_FM_STATISTICS_OFF > -D__HARBOUR__ -DSQLITE_HAS_CODEC=1 > -Ik:\BCC70\Include;k:\XHARBOUR\Include > -nK:\sqlite_see_2013\Obj K:\sqlite_see_2013\sqlite3.c > > > > Embarcadero C++ 7.00 for Win32 Copyright (c) 1993-2015 Embarcadero > Technologies, Inc. > > K:\sqlite_see_2013\sqlite3.c: > > Warning W8065 K:\sqlite_see_2013\sqlite3.c 23909: Call to function > '_endthreadex' with no prototype in function sqlite3ThreadProc > > Warning W8065 K:\sqlite_see_2013\sqlite3.c 23936: Call to function > '_beginthreadex' with no prototype in function sqlite3ThreadCreate > > Warning W8057 K:\sqlite_see_2013\sqlite3.c 38624: Parameter 'iOff' is > never used in function winUnfetch > > Warning W8060 K:\sqlite_see_2013\sqlite3.c 80952: Possibly incorrect > assignment in function vdbeSorterCompareInt > > Warning W8060 K:\sqlite_see_2013\sqlite3.c 82583: Possibly incorrect > assignment in function vdbeSorterSetupMerge > > Warning W8057 K:\sqlite_see_2013\sqlite3.c 185433: Parameter 'iDb' is > never used in function sqlite3CodecGetKey > > k:\BCC70\Bin\TLib.Exe K:\sqlite_see_2013\sqlite_see_2013.Lib /P512 > @K:\sqlite_see_2013\sqlite_see_2013.bcl , > K:\sqlite_see_2013\Debug\sqlite_see_2013.Lst These are just warnings... They are not important and it should still compile. If it fails to compile you should get a message like this: "Error : Failed to compile K:\sqlite_see_2013\sqlite3.c 185433: Some description of what failed" The warnings doesn't mean it did not compile. What makes you think the file failed to compile, is the actual compiled file missing or such? > > > > TLIB 6.4 Copyright (c) 1987-2014 Embarcadero Technologies, Inc. > > +K:\sqlite_see_2013\Obj\sqlite3.Obj > > > > Any help ? Thank you in advance > > > > Marco > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00
Hi, could you please give me the full Bcc32 string you are using ? thank you Marco -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: Thursday, October 22, 2015 4:22 PM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00 Marco Turco wrote: > I'm trying to generate the sqlite3 library but there is no way with > Embercadero C++ 7.00. > > I always receive some warnings and the first two related to the > _endthreadex' and '_beginthreadex' cannot permit to link me the library. > > k:\BCC70\Bin\Bcc32.Exe -DHB_NO_DEFAULT_API_MACROS -M -c -O2 -e -tW > -DHB_NO_DEFAULT_STACK_MACROS -DHB_OS_WIN_USED -DHB_FM_STATISTICS_OFF > -D__HARBOUR__ -DSQLITE_HAS_CODEC=1 > -Ik:\BCC70\Include;k:\XHARBOUR\Include > -nK:\sqlite_see_2013\Obj K:\sqlite_see_2013\sqlite3.c My Borland C++ 5.5.1 (the old, free version) needs -tWM for a multithreaded program; you're using -tW. Regards, Clemens ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00
Solved. At the end I have added the parameter -DSQLITE_THREADSAFE=0 to exclude the multithread code from the library Thank you. Marco -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: Thursday, October 22, 2015 8:51 PM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00 Marco Turco wrote: > could you please give me the full Bcc32 string you are using ? That would not be useful for you; I'm using an incompatible calling convention. Just replace "-tW" with "-tWM". Regards, Clemens ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[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
[sqlite] R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk
Hi, this problem appear only in accessing the sqlite database from Mac OS X on a Windows shared disk. On full Windows networks and also on Mac OS X in local all runs fine. I tried with the oplock enable and disable on the Window server but the Sqlite db always remains locked from the Mac. I have more than 97% of my customers that work stand-alone or in a network environment with less than 4 computer and I haven't any control on the hardware they use so I think the Sqlite solution is preferable instead of a client-server db. I have also some customers with 10-12 computer but due the kind of product there isn't an high concurrency in writing and tracking the locks it appears that only 4-5 locks/day for just 0.3 seconds each one executed on these bigger network. Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per conto di Simon Slavin Inviato: domenica 12 dicembre 2010 20:38 A: General Discussion of SQLite Database Oggetto: 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk
>The situation you're having a problem with ... am I right in saying that the application with problems is a Windows application running inside the Wine layer ? Yes. >What OS (including version) is the host computer running ? Windows Vista Business sp2 >What OS (including version) is the client computer running ? Include the version of Wine if Wine is involved. Mac OS X 10.5.8. Wine 1.1.44 >How is Wine accessing the server ? Did you mount the server in the Macintosh layer, using an 'SMB://' URL, or did you use the Windows facilities to mount it inside Wine ? I mounted the server using the Mac layer (finder->Connect to server) then I mapped a drive (Z:\) into the Wine configuration. It seems the problem is due to a bug on the debian distribution of Samba and the only way to solve it is at this moment to mount the net disk using the nobrl parameter see http://www.mail-archive.com/sqlite-users@sqlite.org/msg20409.html anyway I am not sure this parameter is supported on Mac Os X mount command but I am not an expert in Mac & Unix Os. Any ideas ? Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per conto di Simon Slavin Inviato: domenica 12 dicembre 2010 21:13 A: General Discussion of SQLite Database Oggetto: Re: [sqlite] R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk On 12 Dec 2010, at 7:58pm, Marco Turco wrote: > this problem appear only in accessing the sqlite database from Mac OS > X on a Windows shared disk. The situation you're having a problem with ... am I right in saying that the application with problems is a Windows application running inside the Wine layer ? > On full Windows networks and also on Mac OS X in local all runs fine. What OS (including version) is the host computer running ? What OS (including version) is the client computer running ? Include the version of Wine if Wine is involved. How is Wine accessing the server ? Did you mount the server in the Macintosh layer, using an 'SMB://' URL, or did you use the Windows facilities to mount it inside Wine ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk
>Argh. Any chance of trying it with something other than Vista ? I don't know it's definitely the problem, I'm just allergic to Vista. ;-)) I agree with you. I connected now the Mac to a Window XP 2002 sp3. The same lock problem remains. >One stage of that process is defeating the locking process. Please try mapping the shared drive directly from the Wine stage. I think it isn't possible. It seems Wine only permit to assign a drive letter to an already mounted remote drive. >That bug was fixed years ago. And I think that if it was a problem your Macintosh application would have the same problem. However, if you want to see how to mount that drive from the command-line on a Mac, type 'man mount_smbfs'. Tried. Unfortunately seems that the "nobrl" option is not available. Gr... Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per conto di Simon Slavin Inviato: domenica 12 dicembre 2010 22:09 A: General Discussion of SQLite Database Oggetto: Re: [sqlite] R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk On 12 Dec 2010, at 8:31pm, Marco Turco wrote: >> What OS (including version) is the host computer running ? > Windows Vista Business sp2 Argh. Any chance of trying it with something other than Vista ? I don't know it's definitely the problem, I'm just allergic to Vista. >> How is Wine accessing the server ? Did you mount the server in the > Macintosh layer, using an 'SMB://' URL, or did you use the Windows > facilities to mount it inside Wine ? > I mounted the server using the Mac layer (finder->Connect to server) > then I mapped a drive (Z:\) into the Wine configuration. One stage of that process is defeating the locking process. Please try mapping the shared drive directly from the Wine stage. > It seems the problem is due to a bug on the debian distribution of > Samba and the only way to solve it is at this moment to mount the net > disk using the nobrl parameter see > http://www.mail-archive.com/sqlite-users@sqlite.org/msg20409.html > anyway I am not sure this parameter is supported on Mac Os X mount > command but I am not an expert in Mac & Unix Os. That bug was fixed years ago. And I think that if it was a problem your Macintosh application would have the same problem. However, if you want to see how to mount that drive from the command-line on a Mac, type 'man mount_smbfs'. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] R: R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk
Hi, tried but unfortunately it doesn't runs. The window application running under Wine hasn't direct access to the absolute path. Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per conto di Sylvain Pointeau Inviato: domenica 12 dicembre 2010 22:44 A: General Discussion of SQLite Database Oggetto: Re: [sqlite] R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk ... and if you use the "unix-dotfile" as the VFS name in your open call. Does it work? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to disable locking method on Sqlite (window)
Hi all, I always have problem with locking using MacOSX and Wine on a shared network drive. I checked that Sqlite permit to disable the locking setting SQLITE_ENABLE_LOCKING_STATE=2 but this is only supported on Unix system as I can see on the sqlite3.c source and this is not usable in a MacOSX + Wine due to the fact that the application runs in a Windows like environment. Any ideas to disable the internal Sqlite locking method on a Window app ? Thanks in advance Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] R: R: Crypto lib for Sqlite - suggest required
Hi, thank you for your suggests. My app is an accounting system. This accounting system must support the exchange of db between users that work with the this application so I think the only way is to use the same key for all users. This generate a lack of security of course but anyway my executable is crypted itself using an anti-debug cipher. I also need my app could read the same db crypted and also in the decrypted format because for some special situations I need to provide my app running with the Db decrypted. My doubt about the xor cryptation is that with this solution I can't manage a text search into the db using a select but I need to read all data , decrypt it and then make the text search, for this reason a low level cryptation would be better in my case. Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per conto di Roger Binns Inviato: domenica 9 gennaio 2011 05:16 A: sqlite-users@sqlite.org Oggetto: Re: [sqlite] R: Crypto lib for Sqlite - suggest required -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/08/2011 04:36 AM, Marco Turco wrote: > Essentially I would avoid that my competitors can look inside the Db > structure and import data. On any machine where the database is used the key will have to exist in plain form no matter how convoluted the encryption going on. Your competitors will always be able to run it under a debugger. You don't say if the database content is the same for everyone or if it is different for each user. If it is the same for everyone then all it takes is one bad user and the DB contents will be publishable for all. If it is different per user then I don't see the problem. The only way to be "secure" is to provide the data one value at a time via a web service where you can audit each and every request and not provide everything at once. (And anyone receiving that data can still republish it.) In these situations it is usually enough just to obfuscate the database so it isn't immediately apparent that SQLite is in use. A simple way of doing that is to write your own VFS that calls the normal VFS but xors all data that is being read and written. This is exactly that scheme using Python and demonstrates how much code it is: http://apidoc.apsw.googlecode.com/hg/example.html#example-vfs If you still want to go down the encryption route then be aware that getting encryption right is very hard. More accurately it is trivial to use encryption, and even easier to use it wrongly. People usually get it wrong. Some random subjects: IV, salt, key strengthening The SQLite paid for encryption module is a bargain. It is a one time fee and you get it forever. It will always work with SQLite as the versions change. It does security right and is always thoroughly tested alongside SQLite development. Work out the value of that and the value of your time. Since you won't really be able to prevent copying the data, what you should look for is ways of proving that someone has done so. Obfuscating the database is a good first start since no one could "accidentally" look at the contents - they had to put in deliberate effort. Then throw in some mountweazels: http://en.wikipedia.org/wiki/Fictitious_entry#Motivations_for_creation http://en.wikipedia.org/wiki/Trap_street This would give you enough evidence to sue a competitor. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk0pNnIACgkQmOOfHg372QT8jwCg0DRP/QhGxrOWo2fWDsYNPZj4 tgUAoM0ReVOOJ9exG8rb9iz4cFqZJOWq =w+gv -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite and windows server 2008 DFS
Hi, any experience using an sqlite db on Windows server 2008 with DFS enabled ? A customer with this configuration reported me that there is a lost of data. Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Change a field type
Hi, I have a table with one field defined as smallint(3) and I would like to change the field type now in char(3) (without lost the value inside). How can I make the change ? Do I need to create a new table with the new fields where import the current data or is there a better method ? Thanks in advance Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Alter table: number size
Hi all, I need to alter a field from smallint(1) to smallint(2), is there to do this using ALTER TABLE ? Thanks in advance Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Disable lock control in Sqlite (windows)
Hi all, I need to disable the Sqlite3 locking system for a Windows app that runs on a Mac using the Wine/Crossover API, this due to the fact Wine/Crossover have problem to manage the locking status on a network shared drive. My app already has a built-in locking system so it could runs also without the Sqlite3 internal lock system. So, is there a way to disable the Sqlite locking system (windows) ? As I know this is already available in Sqlite3 unix using the unix-nolock parameter in lib compilation. Thanks in advance Best Regards, Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
