Hi Jürgen: Sadly Apple’s favourite song seems to be “I did it my way!” (I am on Mojave 10.14 - and unable to install later releases without patching, which I don’t do.)
Referring to my 31 March 2021 email — Re: Notes about git-svn source control in macOS: "macOS Catalina 10.15 Command line tool support for Subversion — including svn, git-svn, and related commands — is no longer provided by Xcode. (50266910)” Based on the above my conclusion is that: if you are an Apple developer using macOS version >= Catalina 10.15 you need to install either svn or git yourself! I think this also apples to sqlite3. respect…. Peter > On Oct 8, 2022, at 1:29 PM, Dr. Jürgen Sauermann > <m...@xn--jrgen-sauermann-zvb.de> wrote: > > Hi Peter, > > yes, we could document this. However, I am lacking the necessary information > to do so. > As far as SVN is concerned, it should now also be possible to use git (with > some minor > quirks due to the lack of SVN version numbers). > > Best Regards, > Jürgen > > > On 10/5/22 11:32 PM, Peter Teeson wrote: >> Hi Jürgen: >> >> My recollection is that Apple used to distribute a number of command line >> apps for developers and did put them in the correct dirs. >> They stopped distributing svn and also sql around 2017. >> I wonder if we should document the README prerequisite about this issue? >> >> Gandalf:trunk pteeson$ ./configure --with-sqlite3=/usr/local/opt/sqlite3 >> checking for gcc... gcc >> …….. >> checking for __atomic_fetch_add_4 in -latomicity... no >> checking for SQLite3 library >= 3.0.0... yes >> checking for pg_config... no >> >> repeat >> >> Peter >> >>> On Oct 5, 2022, at 10:43 AM, Dr. Jürgen Sauermann >>> <m...@xn--jrgen-sauermann-zvb.de <mailto:m...@xn--jrgen-sauermann-zvb.de>> >>> wrote: >>> >>> Hi Peter, >>> >>> thanks. A closer look into the m4/ax_lib_sqlite3.m4 macro reveals two >>> problems, which apparently only >>> occurs on macOS: >>> >>> 1. The m4 macro looks for include/sqlite3.h only in the directories /usr, >>> /usr/local, and /opt, >>> while macOS decides to install in /usr/local/opt. Therefore sqlite.h is >>> not found even >>> though it exists. In defence of the m4 script I should mention that, >>> according to the >>> Linux File Hierarchy Standard (aka. FHS), /usr/local/opt is not a suitable >>> location for >>> that file and the fault is more on the macOS side. >>> >>> 2. The m4 macro is faulty when sqlite.h is not found. This is due to a >>> quirk in bash. In the >>> bash shell you can compare two strings or string variables. However if any >>> of the two strings >>> is empty (like it happens when sqlite.h is not found) then the comparison >>> does not return >>> an equal or not equal result, but instead raises the syntax error (on line >>> 19090) that you >>> see below. >>> >>> Both problems should be fixed in SVN 1593 now. >>> >>> BTW installation mismatches caused by non-standard installation directories >>> can >>> sometimes (!) be fixed by ./configure options. In the above case something >>> along the >>> lines of >>> >>> ./configure --with-sqlite3=/usr/local/opt >>> >>> may have worked (whether it does or does not work depends entirely on the >>> m4 macro). >>> >>> Best Regards, >>> Jürgen >>> >>> >>> On 10/3/22 11:29 PM, Peter Teeson wrote: >>>> Hi Jürgen: >>>> I started with an empty dir, downloaded current version 1592, and >>>> ./configure. Same warning. >>>> >>>> The m4/ax_lib_sqllite3.m4 says: >>>> >>>> "dnl If no intallation prefix to the installed SQLite library is given >>>> dnl the macro searches under /usr, /usr/local, and /opt." >>>> >>>> Gandalf:~ pteeson$ cd /usr/local/opt/sqlite3/include >>>> Gandalf:include pteeson$ ls -al sql* >>>> -rw-r--r-- 1 502 staff 581196 18 Jun 2020 sqlite3.h >>>> -rw-r--r-- 1 502 staff 35269 18 Jun 2020 sqlite3ext.h >>>> >>>> checking for SQLite3 library >= 3.0.0... yes >>>> cat: /include/sqlite3.h: No such file or directory >>>> ./configure: line 19090: test: !=: unary operator expected <====== >>>> configure: WARNING: Can not find SQLITE_VERSION macro in sqlite3.h header >>>> to retrieve SQLite version! >>>> >>>> I found it in the header >>>> #define SQLITE_VERSION "3.32.3" >>>> #define SQLITE_VERSION_NUMBER 3032003 >>>> #define SQLITE_SOURCE_ID "2020-06-18 14:00:33 >>>> 7ebdfa80be8e8e73324b8d66b3460222eb74c7e9dfd655b48d6ca7e1933cc8fd" >>>> >>>> So I do not know how to proceed further to help isolate what’s up. >>>> >>>> respect… >>>> >>>> Peter >>>> >>>>> On Oct 3, 2022, at 8:12 AM, Dr. Jürgen Sauermann >>>>> <m...@xn--jrgen-sauermann-zvb.de >>>>> <mailto:m...@xn--jrgen-sauermann-zvb.de>> wrote: >>>>> >>>>> Hi Peter, >>>>> >>>>> thanks for reporting this. It looks like the m4/ax_lib_sqlite3.m4 macro >>>>> shipped with >>>>> GNU APL has been outdated over time. I have updated it from a more recent >>>>> version from here: >>>>> >>>>> https://ac-archive.sourceforge.net/ac-archive/ax_lib_sqlite3.m4 >>>>> <https://ac-archive.sourceforge.net/ac-archive/ax_lib_sqlite3.m4> >>>>> >>>>> I hope this fixes the problem at your end, please let me know. >>>>> >>>>> Best Regards, >>>>> Jürgen >>>>> >>>>> >>>>> On 10/2/22 11:03 PM, Peter Teeson wrote: >>>>>> Hi Jürgen: >>>>>> >>>>>> Doing some investigation I came across this(see my comments below): >>>>>> >>>>>> ./configure >>>>>> ……. >>>>>> checking for SQLite3 library >= 3.0.0... yes >>>>>> cat: /include/sqlite3.h: No such file or directory >>>>>> ./configure: line 19132: test: !=: unary operator expected >>>>>> configure: WARNING: Cannot find SQLITE_VERSION macro in sqlite3.h header >>>>>> to retrieve SQLite version! >>>>>> >>>>>> locate sqlite >>>>>> ……. >>>>>> /usr/bin/sqlite3 >>>>>> /usr/lib/libsqlite3.0.dylib >>>>>> /usr/lib/libsqlite3.dylib >>>>>> /usr/lib/sqlite3 >>>>>> >>>>>> Gandalf:trunk pteeson$ cd /usr/lib >>>>>> Gandalf:lib pteeson$ ls -al s* >>>>>> lrwxr-xr-x 1 root wheel 27 12 Jun 14:42 sqlite3 -> >>>>>> /System/Library/Tcl/sqlite3 >>>>>> >>>>>> ========= My questions ======= >>>>>> This version and location of sqlite3 goes back to macOS Snow Leopard >>>>>> (2009). >>>>>> It has been part of every macOS release up to and including Mojave >>>>>> (2017-last version I can run on my HW) >>>>>> >>>>>> --with-sqlite3=[ARG] >>>>>> Build the native function for SQL using sqlite3. ARG may provide the >>>>>> non-default location of the sqlite3 library. >>>>>> >>>>>> (1) Based on the above it seems macOS version is not in the default >>>>>> location. >>>>>> What is the default location on Unix type systems? Also Windows? >>>>>> >>>>>> So what is the most elegant solution to this? >>>>>> (I don’t use sqlite and for sure I will not remember every time I >>>>>> download a new version of Gnuapl.) >>>>>> >>>>>> (2) Would adding a note to the README make sense? >>>>>> Or recognize macOS and fix it in configure? >>>>>> >>>>>> (3) Forget about it >>>>>> >>>>>> Anyway I thought to pass it on for your comment. >>>>>> >>>>>> respect >>>>>> >>>>>> Peter >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
