The current squirrelsql recipes are failing with the below error
Processor: URLTextSearcher: Error: No match found on URL: http://sourceforge.net/projects/squirrel-sql/files/1-stable/4.8.0/squirrel-sql-4.8.0-MACOSX-install.jar/download
This PR has updated Regex and user-agent's to rectify the error.
Output from a successful -v run
autopkg run -v SQuirreLSQL.munki.recipe
Looking for com.github.bnpl.autopkg.pkg.squirrelsql...
Did not find com.github.bnpl.autopkg.pkg.squirrelsql in recipe map
Rebuilding recipe map with current working directories...
Looking for com.github.bnpl.autopkg.pkg.squirrelsql...
Found com.github.bnpl.autopkg.pkg.squirrelsql in recipe map
Looking for com.github.bnpl.autopkg.download.squirrelsql...
Found com.github.bnpl.autopkg.download.squirrelsql in recipe map
**load_recipe time: 0.006820666982093826
Processing SQuirreLSQL.munki.recipe...
WARNING: SQuirreLSQL.munki.recipe is missing trust info and FAIL_RECIPES_WITHOUT_TRUST_INFO is not set. Proceeding...
Found com.github.bnpl.autopkg.proc.IzPackExecutor in recipe map
URLTextSearcher
URLTextSearcher: Found matching text (prematch): https://sourceforge.net/projects/squirrel-sql/files/1-stable/4.8.0/squirrel-sql-4.8.0-MACOSX-install.jar/download
URLTextSearcher
URLTextSearcher: Found matching text (match): https://downloads.sourceforge.net/project/squirrel-sql/1-stable/4.8.0/squirrel-sql-4.8.0-MACOSX-install.jar?ts=gAAAAABnA8chJBB4pH_B__DxbBTEMl9KkzSBhbC5LbxZ7M6GC974xegtVhoKM2NV8-7qjyYaFGt61x5WPwQxoVknZ9sJEHTqxg%3D%3D&use_mirror=netcologne&r=
URLTextSearcher
URLTextSearcher: Found matching text (namematch): squirrel-sql-4.8.0-MACOSX-install.jar
URLDownloader
URLDownloader: Storing new Last-Modified header: Sun, 01 Sep 2024 08:24:20 GMT
URLDownloader: Storing new ETag header: "66d424b4-377b609"
URLDownloader: Downloaded /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/downloads/squirrel-sql-4.8.0-MACOSX-install.jar
EndOfCheckPhase
PkgRootCreator
PkgRootCreator: Created /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL
PkgRootCreator: Created /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL/Applications
com.github.bnpl.autopkg.proc.IzPackExecutor/IzPackExecutor
spawn java -jar /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/downloads/squirrel-sql-4.8.0-MACOSX-install.jar -console
Command line arguments: -console
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Welcome
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Welcome to the installation of SQuirreL SQL Client 4.8.0!
This software is developed by:
- Gerd Wagner <gerdwagner@users.sourceforge.net>
- Rob Manning <manningr@users.sourceforge.net>
- Colin Bell <colbell@users.sourceforge.net>
The homepage is at: http://www.squirrelsql.org
Press 1 to continue, 2 to quit, 3 to redisplay
1
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Information
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
SQuirreL SQL Client ReadMe
SQuirreL SQL Client is a graphical Java program that will
allow you to view the structure of a JDBC compliant database, browse the
data in tables, issue SQL commands etc. It is free software, and you are
welcome to redistribute it under the terms of the GNU Lesser General
Public License.
The following compatibility matrix shows which version of the Java
Runtime Environment (JRE) is required (minimum version) for different
versions of the SQuirreL SQL Client:
SQuirreL SQL Client Version
JRE Minimum Version
4.3.0 and higher
11
3.8.1 - 4.2.0
1.8
3.0 - 3.8.0
1.6
2.4 - 2.6.x
1.5
2.0 - 2.3.2
1.4
The installation offers two install packages Base and Standard
and a number of optional plugins. The Standard package contains the
following plugins:
Code Completion - Offers code completion the same way as modern IDEs do.
Syntax - Syntax highlighting.
Edit Extras - Auxiliary functions towork with SQL code (for example, formatting)
Graph - create a chart of tablesand foreign-key relationships between them
SQL Script - Generation of SQL and DDL scripts
SQL Bookmarks - Managing SQL code templates
Look and Feel - Switching the look and feel
Look and Feel - Switching the look and feel
The following optional plugins are provided:
DBCopy - Copy database objects from one session to another
DB2 - DBMS-specific capabilities
Derby - DBMS-specific capabilities
Firebird - DBMS-specific capabilities
Firebird Manager - Manage your Firebird Database Server
Hibernate - Tools for developing Hibernate applications
H2 - DBMS-specific capabilities
Informix - DBMS-specific capabilities
Microsoft SQL Server - DBMS-specific capabilities
MySQL - DBMS-specific capabilities
Oracle - DBMS-specific capabilities
PostgreSQL - DBMS-specific capabilities
Refactoring - refactor your database schema using refactoring
patterns
Smart Tools - Handy tools for manipulating data
Session Scripts - run SQL when opening an session
SQL Parametrisation - put variables into your SQL statements
SQL Replace - place environment variables into your SQL
statements
SQL Validator - validate SQL against the ISO SQL-99 standard
Sybase - DBMS-specific capabilities
Internationalization - tools for translators
WIKI tables configurations - How to copy a table as WIKI text for a specific WIKI engine
Swing Violation Detector - Help to detect violated rules of the Swing programming model
For Windows the file squirrel-sql.bat
will run the application. For Unix the file is squirrel-sql.sh. On some
operating systems a shortcut will be created in the menu
system as part of the installation process.
Press 1 to continue, 2 to quit, 3 to redisplay
1
Please read the following information:
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Target Path
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Select the installation path: [/Applications/SQuirreLSQL.app]
/Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL/Applications/SquirreL SQL.app
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Message
The target directory will be created:
/Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL/Applications/SquirreL SQL.app
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Enter O for OK, C to Cancel:
O
Press 1 to continue, 2 to quit, 3 to redisplay
1
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Select Installation Packages
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Select the packs you want to install:
[x] Pack 'Base' required
--------------------------------------
[x] Include optional pack 'Standard'
--------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Mac OS Plugin (older Mac versions only)'
---------------------------------------------------------------------------------------
Enter Y for Yes, N for No:
N
---------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Greenplum'
---------------------------------------------------------
Enter Y for Yes, N for No:
Y
-------------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - WIKI table configurations'
-------------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Swing Violation Dedector'
------------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Multi Source'
------------------------------------------------------------
Enter Y for Yes, N for No:
Y
-------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Vertica'
-------------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------
[ ] Include optional pack 'Optional Plugin - DB2'
---------------------------------------------------
Enter Y for Yes, N for No:
Y
-----------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Derby'
-----------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Firebird '
---------------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Hibernate'
---------------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------
[ ] Include optional pack 'Optional Plugin - H2 '
---------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Informix '
---------------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Microsoft SQL Server '
---------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - MySQL '
------------------------------------------------------
Enter Y for Yes, N for No:
Y
--------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Netezza '
--------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Oracle'
------------------------------------------------------
Enter Y for Yes, N for No:
Y
-----------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - PostgreSQL '
-----------------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Session Scripts'
---------------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Smart Tools '
------------------------------------------------------------
Enter Y for Yes, N for No:
Y
--------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - SQL Parametrisation '
--------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - SQL Replace '
------------------------------------------------------------
Enter Y for Yes, N for No:
Y
--------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - SQL Validator '
--------------------------------------------------------------
Enter Y for Yes, N for No:
Y
-------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Sybase '
-------------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - High resolution icon '
---------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
---------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Internationalization '
---------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
-------------------------------------------------------------------------------
[ ] Include optional pack 'Optional Plugin - Intersystems Cache/IRIS Plugin '
-------------------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
-------------------------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Brazilian Portuguese'
-------------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
--------------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Bulgarian'
--------------------------------------------------------------
Enter Y for Yes, N for No:
Y
----------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Czech'
----------------------------------------------------------
Enter Y for Yes, N for No:
Y
-----------------------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Simplified Chinese'
-----------------------------------------------------------------------
Enter Y for Yes, N for No:
Y
-----------------------------------------------------------
[ ] Include optional pack 'Optional Translation - French'
-----------------------------------------------------------
Enter Y for Yes, N for No:
Y
-----------------------------------------------------------
[ ] Include optional pack 'Optional Translation - German'
-----------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Italian'
------------------------------------------------------------
Enter Y for Yes, N for No:
Y
-------------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Japanese'
-------------------------------------------------------------
Enter Y for Yes, N for No:
Y
-----------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Korean'
-----------------------------------------------------------
Enter Y for Yes, N for No:
Y
-----------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Polish'
-----------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Russian'
------------------------------------------------------------
Enter Y for Yes, N for No:
Y
------------------------------------------------------------
[ ] Include optional pack 'Optional Translation - Spanish'
------------------------------------------------------------
Enter Y for Yes, N for No:
Y
Done!
Press 1 to continue, 2 to quit, 3 to redisplay
1
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Installation
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
====================
Installation started
Framework: 5.1.3-84aaf (IzPack)
Platform: mac_osx,version=15.1,arch=unknown,symbolicName=null,javaVersion=1.8.0_421
[ Starting to unpack ]
[ Processing package: Base (1/39) ]
Cleaning up the target folder ...
[ Processing package: Standard (2/39) ]
Cleaning up the target folder ...
[ Processing package: Optional Plugin - Greenplum (3/39) ]
[ Processing package: Optional Plugin - WIKI table configurations (4/39) ]
[ Processing package: Optional Plugin - Swing Violation Dedector (5/39) ]
[ Processing package: Optional Plugin - Multi Source (6/39) ]
[ Processing package: Optional Plugin - Vertica (7/39) ]
[ Processing package: Optional Plugin - DB2 (8/39) ]
[ Processing package: Optional Plugin - Derby (9/39) ]
[ Processing package: Optional Plugin - Firebird (10/39) ]
[ Processing package: Optional Plugin - Hibernate (11/39) ]
[ Processing package: Optional Plugin - H2 (12/39) ]
[ Processing package: Optional Plugin - Informix (13/39) ]
[ Processing package: Optional Plugin - Microsoft SQL Server (14/39) ]
[ Processing package: Optional Plugin - MySQL (15/39) ]
[ Processing package: Optional Plugin - Netezza (16/39) ]
[ Processing package: Optional Plugin - Oracle (17/39) ]
[ Processing package: Optional Plugin - PostgreSQL (18/39) ]
[ Processing package: Optional Plugin - Session Scripts (19/39) ]
[ Processing package: Optional Plugin - Smart Tools (20/39) ]
[ Processing package: Optional Plugin - SQL Parametrisation (21/39) ]
[ Processing package: Optional Plugin - SQL Replace (22/39) ]
[ Processing package: Optional Plugin - SQL Validator (23/39) ]
[ Processing package: Optional Plugin - Sybase (24/39) ]
[ Processing package: Optional Plugin - High resolution icon (25/39) ]
[ Processing package: Optional Plugin - Internationalization (26/39) ]
[ Processing package: Optional Plugin - Intersystems Cache/IRIS Plugin (27/39) ]
[ Processing package: Optional Translation - Brazilian Portuguese (28/39) ]
[ Processing package: Optional Translation - Bulgarian (29/39) ]
[ Processing package: Optional Translation - Czech (30/39) ]
[ Processing package: Optional Translation - Simplified Chinese (31/39) ]
[ Processing package: Optional Translation - French (32/39) ]
[ Processing package: Optional Translation - German (33/39) ]
[ Processing package: Optional Translation - Italian (34/39) ]
[ Processing package: Optional Translation - Japanese (35/39) ]
[ Processing package: Optional Translation - Korean (36/39) ]
[ Processing package: Optional Translation - Polish (37/39) ]
[ Processing package: Optional Translation - Russian (38/39) ]
[ Processing package: Optional Translation - Spanish (39/39) ]
[ Unpacking finished ]
Installation finished
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Installation Finished
─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
-----------------------------------------
Generate an automatic installation script
-----------------------------------------
Enter Y for Yes, N for No:
N
Installation was successful
Application installed on /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL/Applications/SquirreL SQL.app
[ Writing the uninstaller data ... ]
[ Console installation done ]
4.8.0
PlistEditor
PlistEditor: Updated plist at /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL/Applications/SquirreL SQL.app/Contents/Info.plist
PlistReader
PlistReader: Reading: /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL/Applications/SquirreL SQL.app/Contents/Info.plist
PlistReader: Assigning value of '4.8.0' to output variable 'version'
PlistReader: Assigning value of 'org.squirrelsql.client' to output variable 'PKG_ID'
PkgCreator
PkgCreator: Connecting
PkgCreator: Sending packaging request
PkgCreator: Disconnecting
MunkiImporter
MunkiImporter: Using repo lib: AutoPkgLib
MunkiImporter: plugin: FileRepo
MunkiImporter: repo: /Users/Shared/munki_repo
MunkiImporter: Copied pkginfo to: /Users/Shared/munki_repo/pkgsinfo/apps/SQuirreLSQL-4.8.0.plist
MunkiImporter: pkg to: /Users/Shared/munki_repo/pkgs/apps/SQuirreLSQL-4.8.0.pkg
Receipt written to /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/receipts/SQuirreLSQL.munki-receipt-20241007-123410.plist
The following new items were downloaded:
Download Path
-------------
/Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/downloads/squirrel-sql-4.8.0-MACOSX-install.jar
The following packages were built:
Identifier Version Pkg Path
---------- ------- --------
org.squirrelsql.client 4.8.0 /Users/paul.cossey/Library/AutoPkg/Cache/com.github.bnpl.autopkg.munki.squirrelsql/SQuirreLSQL-4.8.0.pkg
The following new items were imported into Munki:
Name Version Catalogs Pkginfo Path Pkg Repo Path Icon Repo Path
---- ------- -------- ------------ ------------- --------------
SQuirreLSQL 4.8.0 testing apps/SQuirreLSQL-4.8.0.plist apps/SQuirreLSQL-4.8.0.pkg
Hi, @barteklk
The current squirrelsql recipes are failing with the below error
This PR has updated Regex and user-agent's to rectify the error.
Output from a successful -v run