problem with install Firebird 3.0 server on Ubuntu 20.04 LTS WSL2

[lgwsl2]

Environment

Microsoft Windows [Version 10.0.19041.329]
Release: 20.04
Linux version 4.4.0-19041-Microsoft (Microsoft@Microsoft.com) (gcc version 5.4.0 (GCC) ) #1-Microsoft Fri Dec 06 14:06:00 PST 2019

Steps to reproduce

Of course, the standard commands were executed (sudo apt-get update, apt-cache search firebird) and steps.

sudo apt-get install firebird3.0-server
Reading package lists... Done 

Building dependency tree 

Reading state information... Done 

The following packages were automatically installed and are no longer required: 

  libboost-system1.65.1 libboost-thread1.65.1 libnotify4 libwxbase3.0-0v5 libwxgtk3.0-0v5 notification-daemon 

Use 'sudo apt autoremove' to remove them. 

The following additional packages will be installed: 

  firebird3.0-common firebird3.0-common-doc firebird3.0-server-core firebird3.0-utils libfbclient2 libib-util 

Suggested packages: 

  firebird3.0-doc 

The following NEW packages will be installed: 

  firebird3.0-common firebird3.0-common-doc firebird3.0-server firebird3.0-server-core firebird3.0-utils libfbclient2 

  libib-util 

0 upgraded, 7 newly installed, 0 to remove and 0 not upgraded. 

Need to get 0 B/4159 kB of archives. 

After this operation, 16.2 MB of additional disk space will be used. 

Do you want to continue? [Y/n] 

Do you want to continue? [Y/n] Y 

Preconfiguring packages ... 

Selecting previously unselected package firebird3.0-common-doc. 

(Reading database ... 77882 files and directories currently installed.) 

Preparing to unpack .../0-firebird3.0-common-doc_3.0.5.33100.ds4-2ubuntu1_all.deb ... 

Unpacking firebird3.0-common-doc (3.0.5.33100.ds4-2ubuntu1) ... 

Selecting previously unselected package firebird3.0-common. 

Preparing to unpack .../1-firebird3.0-common_3.0.5.33100.ds4-2ubuntu1_all.deb ... 

Unpacking firebird3.0-common (3.0.5.33100.ds4-2ubuntu1) ... 

Selecting previously unselected package libfbclient2:amd64. 

Preparing to unpack .../2-libfbclient2_3.0.5.33100.ds4-2ubuntu1_amd64.deb ... 

Unpacking libfbclient2:amd64 (3.0.5.33100.ds4-2ubuntu1) ... 

Selecting previously unselected package libib-util:amd64. 

Preparing to unpack .../3-libib-util_3.0.5.33100.ds4-2ubuntu1_amd64.deb ... 

Unpacking libib-util:amd64 (3.0.5.33100.ds4-2ubuntu1) ... 

Selecting previously unselected package firebird3.0-server-core:amd64. 

Preparing to unpack .../4-firebird3.0-server-core_3.0.5.33100.ds4-2ubuntu1_amd64.deb ... 

Unpacking firebird3.0-server-core:amd64 (3.0.5.33100.ds4-2ubuntu1) ... 

Selecting previously unselected package firebird3.0-utils. 

Preparing to unpack .../5-firebird3.0-utils_3.0.5.33100.ds4-2ubuntu1_amd64.deb ... 

Unpacking firebird3.0-utils (3.0.5.33100.ds4-2ubuntu1) ... 

Selecting previously unselected package firebird3.0-server. 

Preparing to unpack .../6-firebird3.0-server_3.0.5.33100.ds4-2ubuntu1_amd64.deb ... 

Unpacking firebird3.0-server (3.0.5.33100.ds4-2ubuntu1) ... 

Setting up firebird3.0-common-doc (3.0.5.33100.ds4-2ubuntu1) ... 

Setting up firebird3.0-common (3.0.5.33100.ds4-2ubuntu1) ... 

Setting up libfbclient2:amd64 (3.0.5.33100.ds4-2ubuntu1) ... 

Setting up libib-util:amd64 (3.0.5.33100.ds4-2ubuntu1) ... 

Setting up firebird3.0-server-core:amd64 (3.0.5.33100.ds4-2ubuntu1) ... 

Setting up firebird3.0-utils (3.0.5.33100.ds4-2ubuntu1) ... 

Setting up firebird3.0-server (3.0.5.33100.ds4-2ubuntu1) ... 

Statement failed, SQLSTATE = HY000 

operating system directive mmap failed 

-Exec format error 

dpkg: error processing package firebird3.0-server (--configure): 

installed firebird3.0-server package post-installation script subprocess returned error exit status 1 

Processing triggers for systemd (237-3ubuntu10.41) ... 

Processing triggers for man-db (2.8.3-2ubuntu0.1) ... 

Processing triggers for ureadahead (0.100.0-21) ... 

Processing triggers for libc-bin (2.27-3ubuntu1) ... 

Errors were encountered while processing: 

firebird3.0-server 

E: Sub-process /usr/bin/dpkg returned an error code (1) 

When installing firebird examples, it is the same error:

sudo apt-get install firebird3.0-examples 

Reading package lists... Done 

Building dependency tree 

Reading state information... Done 

firebird3.0-examples is already the newest version (3.0.5.33220.ds4-1build2). 

0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 

1 not fully installed or removed. 

After this operation, 0 B of additional disk space will be used. 

Do you want to continue? [Y/n] Y 

Setting up firebird3.0-server (3.0.5.33220.ds4-1build2) ... 

Statement failed, SQLSTATE = HY000 

operating system directive mmap failed 

-Exec format error 

dpkg: error processing package firebird3.0-server (--configure): 

installed firebird3.0-server package post-installation script subprocess returned error exit status 1 

Errors were encountered while processing: 

firebird3.0-server 

E: Sub-process /usr/bin/dpkg returned an error code (1) 

I used to other repositories the link below, even for version 2.5 is the same.
https://help.ubuntu.com/community/Firebird2.5

Manual installation also causes a problem and does not help the solution from
http://tracker.firebirdsql.org/browse/CORE-5445

Actual behavior

Server Firebird 3 or 2.5 not work.

[sirredbeard]

I am curious what is happening in the Firebird postinst script here:

Setting up firebird3.0-server (3.0.5.33100.ds4-2ubuntu1) ... 
Statement failed, SQLSTATE = HY000 
operating system directive mmap failed 
-Exec format error 
dpkg: error processing package firebird3.0-server (--configure): 
installed firebird3.0-server package post-installation script subprocess returned error exit status 1 

Is it trying to start or reach a SQL server?

If it trying to reach systemd that's not going to work.

What happens if you manually start a SQL server and then try installing Firebird?

[therealkenc]

887   stat("/tmp/firebird/fb12_trace", {st_mode=S_IFREG|0660, st_size=0, ...}) = 0
887   openat(AT_FDCWD, "/tmp/firebird/fb12_trace", O_RDWR|O_CREAT|O_CLOEXEC, 0600) = 6
887   fcntl(6, F_SETFD, 0x80000 /* FD_??? */) = -1 EINVAL (Invalid argument)
887   fstat(6, {st_mode=S_IFREG|0660, st_size=0, ...}) = 0
887   geteuid()                         = 0
[... blah blah]
887   mmap(NULL, 876, PROT_READ, MAP_SHARED, 7, 0) = 0x7f92407c6000
887   lseek(7, 876, SEEK_SET)           = 876
887   munmap(0x7f92407c6000, 876)       = 0
887   close(7)                          = 0
887   chown("/tmp/firebird/fb12_trace", 115, 124) = 0
887   chmod("/tmp/firebird/fb12_trace", 0660) = 0
887   fstat(6, {st_mode=S_IFREG|0660, st_size=0, ...}) = 0
887   fstat(6, {st_mode=S_IFREG|0660, st_size=0, ...}) = 0
887   mmap(NULL, 4192, PROT_READ|PROT_WRITE, MAP_SHARED, 6, 0) = -1 ENOEXEC (Exec format error)
887   gettimeofday({tv_sec=1594063405, tv_usec=704912}, NULL) = 0
887   openat(AT_FDCWD, "/var/log/firebird/firebird3.0.log", O_WRONLY|O_CREAT|O_APPEND, 0666) = 7

WSL1 mmap on /tmp has been suspect for a while ref my own #2974 and #3937. Canonical solution is WSL2. [ed] Acknowledge those are EPERM not ENOEXEC, but then noexec isn't a error code returned by mmap(2) so there's that. You won't get one from WSL2.