Package Details: sqsh 2.5.16.1-4

Git Clone URL: https://aur.archlinux.org/sqsh.git (read-only, click to copy)
Package Base: sqsh
Description: Unix/Linux replacement for Sybase's isql
Upstream URL: https://sourceforge.net/projects/sqsh/
Licenses: GPL
Submitter: None
Maintainer: None
Last Packager: terminalmage
Votes: 8
Popularity: 0.000000
First Submitted: 2008-07-15 18:41 (UTC)
Last Updated: 2021-05-10 15:39 (UTC)

Dependencies (3)

Required by (0)

Sources (1)

Latest Comments

1 2 3 4 5 Next › Last »

terminalmage commented on 2023-06-28 14:28 (UTC)

I haven't used sqsh regularly in 10 years and no longer have the means to test it. I have disowned the package so that someone else can maintain it.

80570N commented on 2023-04-09 00:54 (UTC)

In order to build sqsh 2.5.16.1-4 you'll need freetds-patched-enum 1.1.42. https://aur.archlinux.org/cgit/aur.git/snapshot/aur-31ea32fd7c70e8341110dcd17c5ce5b116135f91.tar.gz

D3vil0p3r commented on 2022-12-31 21:49 (UTC)

@terminalImage I confirm it works with your suggestion. Btw it is a pity the project is not actively maintained anymore.

Thank you.

terminalmage commented on 2022-12-30 18:39 (UTC)

sqsh is not being actively maintained, I think. I'm not sure, I haven't used it in a while.

I was able to get sqsh to build with version 1.00.94 of freetds-patched-enum. You can access the files needed to build that version by checking out the AUR git repo and then checking out revision 08d0aa1:

git clone https://aur.archlinux.org/freetds-patched-enum.git
cd freetds-patched-enum
git checkout 08d0aa1

D3vil0p3r commented on 2022-12-30 17:38 (UTC) (edited on 2022-12-30 18:04 (UTC) by D3vil0p3r)

@terminalImage so it means that won't be adapted to the latest version of its dependencies and it will be tied to an old version of freetds (with all security concerns) forever?

Looking for Ubuntu, the freetds version is 1.3.6-1. I tried to build freetds-patched-enum to that version but when I build sqsh, I get the same error...

Could you please inform us which resources and versions we need for making the package usable?

terminalmage commented on 2022-12-30 16:53 (UTC)

I am able to reproduce. As best as I can tell, this has to do with newer versions of freetds removing constants that sqsh relies on.

You might need to try to build an older freetds-patched-enum.

D3vil0p3r commented on 2022-12-30 16:10 (UTC)

@terminalImage thank you for the answer. I submitted freetds-patched-enum in Chaotic repo (waiting for approval) in order to mitigate this situation.

However, once installed this dep, I tried to run makepkg -si or use a package manager as paru sqsh, during the building of the package I get the following error:

<SNIP>
configure: Completed successfully. Please run 'make clean && make' to build sqsh.
make[1]: warning: jobserver unavailable: using -j1.  Add '+' to parent make rule.
make[1]: Entering directory '/tmp/makepkg/sqsh/src/sqsh-2.5/src/sqsh_parser'
gcc -c -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection  -o sqsh_parser.o sqsh_parser.c
gcc -c -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection  -o tsql.o tsql.c
gcc -c -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection  -o tsql.yy.o tsql.yy.c
ar -rcsv  sqsh_parser.a sqsh_parser.o tsql.o tsql.yy.o
a - sqsh_parser.o
a - tsql.o
a - tsql.yy.o
make[1]: Leaving directory '/tmp/makepkg/sqsh/src/sqsh-2.5/src/sqsh_parser'
make[1]: warning: jobserver unavailable: using -j1.  Add '+' to parent make rule.
make[1]: Entering directory '/tmp/makepkg/sqsh/src/sqsh-2.5/src'
gcc -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection -DSQSH_RC='"/etc/sqshrc:${HOME}/.sqshrc"' -DUSE_READLINE    -DUSE_X11       -I/usr/include  -DSYB_LP64   -c -o cmd_alias.o cmd_alias.c
gcc -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection -DSQSH_RC='"/etc/sqshrc:${HOME}/.sqshrc"' -DUSE_READLINE    -DUSE_X11       -I/usr/include  -DSYB_LP64   -c -o cmd_bcp.o cmd_bcp.c
gcc -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection -DSQSH_RC='"/etc/sqshrc:${HOME}/.sqshrc"' -DUSE_READLINE    -DUSE_X11       -I/usr/include  -DSYB_LP64   -c -o cmd_buf.o cmd_buf.c
cmd_buf.c: In function ‘cmd_buf_edit’:
cmd_buf.c:581:29: warning: ‘
   ’ directive writing 1 byte into a region of size between 0 and 4096 [-Wformat-overflow=]
  581 |         sprintf( str, "%s %s\n", editor, path );
      |                             ^~
In file included from /usr/include/stdio.h:906,
                 from cmd_buf.c:25:
In function ‘sprintf’,
    inlined from ‘cmd_buf_edit’ at cmd_buf.c:581:2:
/usr/include/bits/stdio2.h:30:10: note: ‘__builtin___sprintf_chk’ output 3 or more bytes (assuming 4099) into a destination of size 4097
   30 |   return __builtin___sprintf_chk (__s, __USE_FORTIFY_LEVEL - 1,
      |          ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   31 |                                   __glibc_objsize (__s), __fmt,
      |                                   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   32 |                                   __va_arg_pack ());
      |                                   ~~~~~~~~~~~~~~~~~
gcc -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -fexceptions         -Wp,-D_FORTIFY_SOURCE=2 -Wformat -Werror=format-security         -fstack-clash-protection -fcf-protection -DSQSH_RC='"/etc/sqshrc:${HOME}/.sqshrc"' -DUSE_READLINE    -DUSE_X11       -I/usr/include  -DSYB_LP64   -c -o cmd_connect.o cmd_connect.c
cmd_connect.c: In function ‘SetNetAuth’:
cmd_connect.c:1880:17: error: ‘CS_MAX_CHAR’ undeclared (first use in this function); did you mean ‘CS_VARCHAR’?
 1880 |     CS_CHAR buf[CS_MAX_CHAR+1];
      |                 ^~~~~~~~~~~
      |                 CS_VARCHAR
cmd_connect.c:1880:17: note: each undeclared identifier is reported only once for each function it appears in
cmd_connect.c:1890:7: error: ‘CS_SEC_CHANBIND’ undeclared (first use in this function); did you mean ‘CS_SEC_CHALLENGE’?
 1890 |     { CS_SEC_CHANBIND,       'b', "Channel binding" },
      |       ^~~~~~~~~~~~~~~
      |       CS_SEC_CHALLENGE
cmd_connect.c:1891:7: error: ‘CS_SEC_CONFIDENTIALITY’ undeclared (first use in this function)
 1891 |     { CS_SEC_CONFIDENTIALITY,'c', "Data confidentiality" },
      |       ^~~~~~~~~~~~~~~~~~~~~~
cmd_connect.c:1893:7: error: ‘CS_SEC_INTEGRITY’ undeclared (first use in this function)
 1893 |     { CS_SEC_INTEGRITY,      'i', "Data integrity" },
      |       ^~~~~~~~~~~~~~~~
cmd_connect.c:1895:7: error: ‘CS_SEC_DATAORIGIN’ undeclared (first use in this function)
 1895 |     { CS_SEC_DATAORIGIN,     'o', "Data origin stamping" },
      |       ^~~~~~~~~~~~~~~~~
cmd_connect.c:1896:7: error: ‘CS_SEC_DETECTSEQ’ undeclared (first use in this function)
 1896 |     { CS_SEC_DETECTSEQ,      'q', "Data out-of-sequence detection" },
      |       ^~~~~~~~~~~~~~~~
cmd_connect.c:1897:7: error: ‘CS_SEC_DETECTREPLAY’ undeclared (first use in this function)
 1897 |     { CS_SEC_DETECTREPLAY,   'r', "Data replay detection" },
      |       ^~~~~~~~~~~~~~~~~~~
cmd_connect.c:1933:27: error: ‘CS_SEC_KEYTAB’ undeclared (first use in this function); did you mean ‘CS_SEC_NEGOTIATE’?
 1933 |                           CS_SEC_KEYTAB,          /* Property */
      |                           ^~~~~~~~~~~~~
      |                           CS_SEC_NEGOTIATE
cmd_connect.c:1954:27: error: ‘CS_SEC_MECHANISM’ undeclared (first use in this function)
 1954 |                           CS_SEC_MECHANISM,       /* Property */
      |                           ^~~~~~~~~~~~~~~~
cmd_connect.c: In function ‘ShowNetAuthCredExp’:
cmd_connect.c:2085:23: error: ‘CS_SEC_CREDTIMEOUT’ undeclared (first use in this function)
 2085 |                       CS_SEC_CREDTIMEOUT,     /* Property */
      |                       ^~~~~~~~~~~~~~~~~~
cmd_connect.c:2101:18: error: ‘CS_UNEXPIRED’ undeclared (first use in this function)
 2101 |             case CS_UNEXPIRED:
      |                  ^~~~~~~~~~~~
make[1]: *** [<builtin>: cmd_connect.o] Error 1
make[1]: Leaving directory '/tmp/makepkg/sqsh/src/sqsh-2.5/src'
make: *** [Makefile:34: build-subdirs] Error 2
==> ERROR: A failure occurred in build().
    Aborting...
error: failed to build 'sqsh-2.5.16.1-4': 
error: packages failed to build: sqsh-2.5.16.1-4

Can you reproduce it?

terminalmage commented on 2022-12-27 04:29 (UTC)

The -i flag for makepkg installs the package after building, but the dependencies need to be already installed or available for this to work.

You might want to try using a pacman wrapper.

If you don't want to use a wrapper, then you'll need to manually build freetds-patched-enum and then install it with pacman -U --asdeps freetds-patched-enum-1.3.12-1-x86_64.pkg.tar.zst, before running your makepkg -si for sqsh.

There's nothing to "fix". It's normal for AUR packages to depend on other AUR packages.

D3vil0p3r commented on 2022-12-26 15:59 (UTC)

During the "makepkg -si" of its PKGBUILD, I get:

error: target not found: freetds-patched-enum
==> ERROR: 'pacman' failed to install missing dependencies.
==> Missing dependencies:
  -> freetds-patched-enum
==> Checking buildtime dependencies...
==> ERROR: Could not resolve all dependencies.

"freetds-patched-enum" does not exist in Arch Linux repository, it exists only in AUR, but makepkg uses pacman, so the building fails. Please fix it.

terminalmage commented on 2021-05-10 15:40 (UTC)

Done. :)