#1029716 make-sqldeveloper-package fails on linking in temporary directory

Package:
sqldeveloper-package
Source:
sqldeveloper-package
Submitter:
Robert Mavrinac
Date:
2025-07-08 13:25:01 UTC
Severity:
normal
#1029716#5
Date:
2023-01-26 16:08:37 UTC
From:
To:
# make-sqldeveloper-package sqldeveloper-22.2.1.234.1810-no-jre.zip
make-sqldeveloper-package 0.5.4 Copyright © 2009-2018 Lazarus Long
Debian package builder and installer for Oracle SQL Developer

Environment variables are:
      DEBFULLNAME=""
      DEBEMAIL="root@delta.cs.uwindsor.ca"
Active flags are: (none)
Creating work directory "/tmp/user/0/tmp.ogoOWGN2WK" ... done!
Creating build installation directory "/tmp/user/0/tmp.ogoOWGN2WK/sqldeveloper/usr/share" ... done!
Extracting upstream archive "sqldeveloper-22.2.1.234.1810-no-jre.zip" to "/tmp/user/0/tmp.ogoOWGN2WK/sqldeveloper/usr/share" ... done!
Obtaining upstream full version: "22.2.1.234.1810" ... done!
Renaming the work directory "/tmp/user/0/tmp.ogoOWGN2WK/sqldeveloper" to "/tmp/user/0/tmp.ogoOWGN2WK/sqldeveloper-22.2.1.234.1810" ... done!
Reorganizing the work directory "/tmp/user/0/tmp.ogoOWGN2WK/sqldeveloper-22.2.1.234.1810" to generate FSH compliant package(s) ... /usr/bin/make-sqldeveloper-package: 654: [: Illegal number: libjavafx_font_freetype
/usr/bin/make-sqldeveloper-package: 656: [: Illegal number: libjavafx_font_freetype
ln: failed to create symbolic link '/tmp/user/0/tmp.ogoOWGN2WK/sqldeveloper-22.2.1.234.1810/usr/lib/x86_64-linux-gnu/sqldeveloper/22.2.1.234.1810/.l.i.b.j.a.v.a.f.x._.f.o.n.t._.f.r.e.e.t.y.p.e': File exists

I applied the following changes to /usr/bin/make-sqldeveloper-package to correct the problem:

# diff -c1 make-sqldeveloper-package make-sqldeveloper-package.new
*** make-sqldeveloper-package 2018-01-10 19:05:04.000000000 -0500
--- make-sqldeveloper-package.new   2023-01-26 10:56:34.924672579 -0500
***************
*** 622,624 ****
      local GREP_OPTS_COUNT="${GREP_OPTS} -c"
!     local LN_OPTS_FUNC_REORG="-s"
      local MV_OPTS_FUNC_REORG="--strip-trailing-slashes"
--- 622,624 ----
      local GREP_OPTS_COUNT="${GREP_OPTS} -c"
!     local LN_OPTS_FUNC_REORG="-s -f"
      local MV_OPTS_FUNC_REORG="--strip-trailing-slashes"

I suggest changing
local LN_OPTS_FUNC_REORG="-s"
to
local LN_OPTS_FUNC_REORG="-s -f"


I'm not sure if the "Illegal number" outputs need to be fixed, the packages still build.
Here is the output using the change to LN_OPTS_FUNC_REORG:

# make-sqldeveloper-package sqldeveloper-22.2.1.234.1810-no-jre.zip
make-sqldeveloper-package 0.5.4 Copyright © 2009-2018 Lazarus Long
Debian package builder and installer for Oracle SQL Developer

Environment variables are:
      DEBFULLNAME=""
      DEBEMAIL="root@delta.cs.uwindsor.ca"
Active flags are: (none)
Creating work directory "/tmp/user/0/tmp.OkM7V0yfPp" ... done!
Creating build installation directory "/tmp/user/0/tmp.OkM7V0yfPp/sqldeveloper/usr/share" ... done!
Extracting upstream archive "/root/software/oracle/sqldeveloper-22.2.1.234.1810-no-jre.zip" to "/tmp/user/0/tmp.OkM7V0yfPp/sqldeveloper/usr/share" ... done!
Obtaining upstream full version: "22.2.1.234.1810" ... done!
Renaming the work directory "/tmp/user/0/tmp.OkM7V0yfPp/sqldeveloper" to "/tmp/user/0/tmp.OkM7V0yfPp/sqldeveloper-22.2.1.234.1810" ... done!
Reorganizing the work directory "/tmp/user/0/tmp.OkM7V0yfPp/sqldeveloper-22.2.1.234.1810" to generate FSH compliant package(s) ... ./make-sqldeveloper-package: 654: [: Illegal number: libjavafx_font_freetype
./make-sqldeveloper-package: 656: [: Illegal number: libjavafx_font_freetype
./make-sqldeveloper-package: 654: [: Illegal number: libglass
./make-sqldeveloper-package: 656: [: Illegal number: libglass
./make-sqldeveloper-package: 654: [: Illegal number: libjavafx_font
./make-sqldeveloper-package: 656: [: Illegal number: libjavafx_font
./make-sqldeveloper-package: 654: [: Illegal number: libjfxmedia
./make-sqldeveloper-package: 656: [: Illegal number: libjfxmedia
./make-sqldeveloper-package: 654: [: Illegal number: libprism_sw
./make-sqldeveloper-package: 656: [: Illegal number: libprism_sw
./make-sqldeveloper-package: 654: [: Illegal number: libjavafx_font_pango
./make-sqldeveloper-package: 656: [: Illegal number: libjavafx_font_pango
./make-sqldeveloper-package: 654: [: Illegal number: libglassgtk3
./make-sqldeveloper-package: 656: [: Illegal number: libglassgtk3
./make-sqldeveloper-package: 654: [: Illegal number: ffmpeg-58
./make-sqldeveloper-package: 656: [: Illegal number: ffmpeg-58
./make-sqldeveloper-package: 654: [: Illegal number: libprism_es2
./make-sqldeveloper-package: 656: [: Illegal number: libprism_es2
./make-sqldeveloper-package: 654: [: Illegal number: libjfxwebkit
./make-sqldeveloper-package: 656: [: Illegal number: libjfxwebkit
./make-sqldeveloper-package: 654: [: Illegal number: libjavafx_iio
./make-sqldeveloper-package: 656: [: Illegal number: libjavafx_iio
./make-sqldeveloper-package: 654: [: Illegal number: libglassgtk2
./make-sqldeveloper-package: 656: [: Illegal number: libglassgtk2
./make-sqldeveloper-package: 654: [: Illegal number: ffmpeg-57
./make-sqldeveloper-package: 656: [: Illegal number: ffmpeg-57
./make-sqldeveloper-package: 654: [: Illegal number: lite
./make-sqldeveloper-package: 656: [: Illegal number: lite
./make-sqldeveloper-package: 654: [: Illegal number: libfxplugins
./make-sqldeveloper-package: 656: [: Illegal number: libfxplugins
./make-sqldeveloper-package: 654: [: Illegal number: ffmpeg-56
./make-sqldeveloper-package: 656: [: Illegal number: ffmpeg-56
./make-sqldeveloper-package: 654: [: Illegal number: libdecora_sse
./make-sqldeveloper-package: 656: [: Illegal number: libdecora_sse
./make-sqldeveloper-package: 654: [: Illegal number: libprism_common
./make-sqldeveloper-package: 656: [: Illegal number: libprism_common
done!
Cleaning up work directory "/tmp/user/0/tmp.OkM7V0yfPp/sqldeveloper-22.2.1.234.1810" for compliant package(s) generation:
      deleting foreign binaries, image thumbnails and caches, foreign configuration files, source code, empty directories, done!
      fixing shebang lines, executable bit, done!
      documenting demo files, theme templates, application notes, done!
Populating the "/tmp/user/0/tmp.OkM7V0yfPp/sqldeveloper-22.2.1.234.1810/debian" package control directory:
      finding libraries to build ... done!
      debian/changelog ... done!
      debian/compat ... done!
      debian/control ... done!
      debian/rules ... done!
      debian/sqldeveloper-22.2.1.234.1810.copyright ... done!
      debian/sqldeveloper-22.2.1.234.1810.doc-base ... done!
      debian/libjnidispatch-22.2.1.234.1810.shlibs.amd64 ... done!
      debian/libjnidispatch-22.2.1.234.1810.shlibs.i386 ... done!
      debian/sqldeveloper-22.2.1.234.1810.changelog ... done!
      debian/control ... updated!
      debian/sqldeveloper-22.2.1.234.1810.copyright ... done!
      debian/sqldeveloper-22.2.1.234.1810.install.in ... done!
      debian/sqldeveloper-22.2.1.234.1810.lintian-overrides.amd64 ... done!
      debian/sqldeveloper-22.2.1.234.1810.lintian-overrides.i386 ... done!
      debian/libjnidispatch-22.2.1.234.1810.copyright ... updated!
      debian/sqldeveloper-22.2.1.234.1810.copyright ... updated!
      debian/sqldeveloper-22.2.1.234.1810.install ... done!
      debian/sqldeveloper-22.2.1.234.1810.links ... done!
      debian/sqldeveloper-22.2.1.234.1810.lintian-overrides ... done!
      debian/sqldeveloper-22.2.1.234.1810.manpages ... done!
      debian/sqldeveloper-22.2.1.234.1810.NEWS ... done!
      debian/sqldeveloper-22.2.1.234.1810.postinst ... done!
      debian/sqldeveloper-22.2.1.234.1810.prerm ... done!
      debian/sqldeveloper-22.2.1.234.1810.README.Debian ... done!
      debian/sqldeveloper.22.2.1.234.1810.1 ... done!
      debian/sdcli.22.2.1.234.1810.1 ... done!
      debian/sql.22.2.1.234.1810.bundled.1 ... done!
      debian/sqldeveloper.22.2.1.234.1810.bash ... done!
      debian/sqldeveloper.22.2.1.234.1810.desktop ... done!
      debian/sqldeveloper.22.2.1.234.1810.xpm ... done!
Building debian package(s) from sqldeveloper v22.2.1.234.1810 in "/root":
      sqldeveloper-22.2.1.234.1810_22.2.1.234.1810+0.5.4-1_all.deb ... done!
      libjnidispatch-22.2.1.234.1810_4.2.2+0.5.4-1_amd64.deb ... done!


I am using
Linux hostname 6.1.0-1-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.4-1 (2023-01-07) x86_64 GNU/Linux qnd libc 2.36-8
#1029716#10
Date:
2025-06-30 23:51:15 UTC
From:
To:
The latest version of sqldeveloper that can be packaged without errors
is v20. There is an upstream issue related with this bug [1]. Versions
of sqldeveloper higher than v20 can be packaged running
make-sqldeveloper-package -s (without building libjnidispatch package).

Also this package doesn't work on systems with non-US locales [2],
making the package difficult to use for many users.

These bugs have not been fixed for many years. Looks like the upstream
dead and the package is unsupported. So I suggest to set severity to
serious.

[1] https://github.com/lazarusllong/sqldeveloper-package/issues/6

[2] https://github.com/lazarusllong/sqldeveloper-package/issues/4
#1029716#17
Date:
2025-07-08 13:22:57 UTC
From:
To:
Hi Lazarus,

  This package seems pretty stale, not having any updates since buster.
Your upstream GitHub repo also hasn't seen any commits in seven years.

  As things stand, it looks like this package is useless without fixes.
If that's not going to happen, could you file a RM bug to expedite the
removal as we work to get the trixie RC bug count to zero?

Thanks,
Mathias