Hey,

Looks like you should be able to set a service variableCGO_ENABLED to 1

https://nixpacks.com/docs/providers/go#environment-variables

I'm not sure if that will automatically add gcc to the build but if it doesn't let me know and we can sort out some config that will.

Hi Brody

I've tried setting the CGO_ENABLED environment variable to 1, but I'm still encountering the same error. I'm unsure why this isn't resolving the issue.

Thanks,

Pol

It's likely that gcc isn't being automatically included in the build.

Try adding this nixpacks.toml file to your project -

[phases.setup]
    nixPkgs = ['...', 'gcc']

Hi Brody

I have done adding the nixpacks.toml file and now it's a different error:
1.112 /root/go/pkg/mod/github.com/ibmdb/go_ibm_db@v0.4.5/api/api_unix.go:14:11: fatal error: sqlcli1.h: No such file or directory

Jul 29 21:16:21

1.112 14 | // #include <sqlcli1.h>

I'm unsure of the cause at the moment. I've attached the error logs from the build for your reference.

As per - https://github.com/ibmdb/go_ibm_db/issues/21#issuecomment-1461194956

It looks like you will have to run setup.go and setenv.sh

If you are able to provide me with a minimal reproduceable example I would be able to dig into this further.

Thank you Brody for this info, by the way, how can we execute this script in Railway for the setup.go and setenv.sh? I have provided the public tests Github repo https://github.com/itrepablik/test-ibm-db2 and I just wanted to test if the errors of `/root/go/pkg/mod/github.com/ibmdb/go_ibm_db@v0.4.5/api/api_unix.go:14:11: fatal error: sqlcli1.h: No such file or directory
will be fixed.

I've already added the following environment variables in Railway:
CGO_CFLAGS=-I$IBM_DB_HOME/include

CGO_ENABLED=1

CGO_LDFLAGS=-L$IBM_DB_HOME/lib

IBM_DB_DOWNLOAD_URL=https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/v11.5.9/linuxx64_odbc_cli.tar.gz

IBM_DB_HOME=/home/uname/go/src/github.com/ibmdb/clidriver

LD_LIBRARY_PATH=/home/uname/go/src/github.com/ibmdb/clidriver/lib

Could you advise on the best approach to execute these scripts and set the environment variables within Railway's deployment process?

Thank you for the repo, I will play around and see if I can get it to build. Will circle back!

Hi brody, please let me know thank you very much!

Hey, I've hacked away at this for quite some time and was able to get setup.go and setenv.sh to run without issues but it made no difference, so, unfortunately, I don't have a solution for you.

Perhaps look into a pure Go database driver so you won't need cgo.

Brody, thank you for your assistance. I believe this is the only official library available for IBM DB2 in Go. I'll explore the possibility of using a Windows machine in the cloud as an alternative solution.