NixOS下通过Home Manager安装mysql-workbench失败求助

问题场景 #

我是NixOS新手，使用Home Manager安装应用程序时，在home.nix中添加了MySQL Workbench的配置：

home.packages = with pkgs; [
  ...
 mysql-workbench
 ];

执行home-manager switch命令后，构建过程出现错误。

初始报错信息 #

make[2]: *** No rule to make target '/nix/store/8dmk574rg7r7xgsa47xcg7znbvz8kcyy-mysql-8.0.32/lib/mysql/libmysqlclient.so', needed by 'libgdal.so.32.3.6.2'.  Stop.
make[1]: *** [CMakeFiles/Makefile2:3589: CMakeFiles/GDAL.dir/all] Error 2
make: *** [Makefile:136: all] Error 2
error: builder for '/nix/store/x3pq79blki1zd8jagfl5l6g7h1hl86j7-gdal-3.6.2.drv' failed with exit code 2;
       last 10 log lines:
       > [ 94%] Building CXX object gnm/gnm_frmts/db/CMakeFiles/gnm_frmts_db.dir/gnmdbnetwork.cpp.o
       > [ 94%] Built target gnm_frmts
       > [ 94%] Building CXX object gnm/gnm_frmts/file/CMakeFiles/gnm_frmts_file.dir/gnmfiledriver.cpp.o
       > [ 94%] Built target gnm
       > [ 94%] Building CXX object gnm/gnm_frmts/file/CMakeFiles/gnm_frmts_file.dir/gnmfilenetwork.cpp.o
       > [ 94%] Built target gnm_frmts_db
       > [ 94%] Built target gnm_frmts_file
       > make[2]: *** No rule to make target '/nix/store/8dmk574rg7r7xgsa47xcg7znbvz8kcyy-mysql-8.0.32/lib/mysql/libmysqlclient.so', needed by 'libgdal.so.32.3.6.2'.  Stop.
       > make[1]: *** [CMakeFiles/Makefile2:3589: CMakeFiles/GDAL.dir/all] Error 2
       > make: *** [Makefile:136: all] Error 2
       For full logs, run 'nix log /nix/store/x3pq79blki1zd8jagfl5l6g7h1hl86j7-gdal-3.6.2.drv'.
error: 1 dependencies of derivation '/nix/store/cmv85cs2wslj2m3i9vgxdsgi50wn9i4d-mysql-workbench-8.0.30.drv' failed to build
error: 1 dependencies of derivation '/nix/store/fbcg07ss7pc9bc49wpxxpf6406dcqbhc-home-manager-path.drv' failed to build
error: 1 dependencies of derivation '/nix/store/grgzimdpc37yp6cyjwshhk0l5pz92g2f-home-manager-generation.drv' failed to build

当前使用的稳定频道配置：

~ sudo nix-channel --list
home-manager https://github.com/nix-community/home-manager/archive/release-22.11.tar.gz
nixos https://nixos.org/channels/nixos-22.11

尝试的解决方案及后续报错 #

根据建议尝试为单个包使用不稳定频道：

1. 添加并更新不稳定频道：

~ » sudo nix-channel --add https://nixos.org/channels/nixpkgs-unstable nixos-unstable
~ » sudo nix-channel --update

2. 修改home.nix配置：

let
  ...
  unstable = import <nixos-unstable> {};
in
{
  ...
  home.packages = with pkgs; [
    ...
    unstable.mysql-workbench
  ];
}

再次执行home-manager switch后依然报错：

[  5%] Built target mysys_objlib
make: *** [Makefile:156: all] Error 2
error: builder for '/nix/store/lnrjks3272nl67l70l2f3cfv9m52zjla-mysql-8.0.32.drv' failed with exit code 2;
       last 10 log lines:
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/my_md5.cc.o
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/my_rnd.cc.o
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/my_openssl_fips.cc.o
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/my_aes_openssl.cc.o
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/build_id.cc.o
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/posix_timers.cc.o
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/my_getpwnam.cc.o
       > [  5%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/my_largepage.cc.o
       > [  5%] Built target mysys_objlib
       > make: *** [Makefile:156: all] Error 2
       For full logs, run 'nix log /nix/store/lnrjks3272nl67l70l2f3cfv9m52zjla-mysql-8.0.32.drv'.
error: 1 dependencies of derivation '/nix/store/i56gdjgdcd4nrclb9rj7cq43aii3hh4i-mysql-workbench-8.0.32.drv' failed to build
error: 1 dependencies of derivation '/nix/store/fyn6iaq0pflvmnlcwdwcmaxrrqj8nk20-home-manager-path.drv' failed to build
error: 1 dependencies of derivation '/nix/store/6rjk72ldzd0zayqg98sslidkp8hj6hwh-home-manager-generation.drv' failed to build

最终结果 #

后续上述使用不稳定频道的方案可以正常安装MySQL Workbench。

内容的提问来源于stack exchange，提问作者ma4stro