The env setting does NOT work in docker file?

[ZacZelner]

Hi, I am using dockerfile to build one application using go_ibm_db.

The application works well in my local mac, and I am using:
export DB2HOME=/Users/zac/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver
export CGO_CFLAGS=-I$DB2HOME/include
export DYLD_LIBRARY_PATH=$DB2HOME/lib
export CGO_LDFLAGS=-L$DB2HOME/lib

however, I set these env in the dockerfile, and can not work well.
dockerfile:
ENV DB2HOME=/Users/zac/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver
ENV CGO_CFLAGS=-I$DB2HOME/include
ENV DYLD_LIBRARY_PATH=$DB2HOME/lib
ENV CGO_LDFLAGS=-L$DB2HOME/lib

I print these env values out before I run the application in the dock images.
cd /go/src/demowithJS

echo $DB2HOME
echo $CGO_CFLAGS
echo $DYLD_LIBRARY_PATH
echo $CGO_LDFLAGS

bee run

There is the error:
zac$ docker run -it -p 8081:8081 ocvtest
/Users/zac/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver
-I/Users/zac/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/include
/Users/zac/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib
-L/Users/zac/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib

---

| ___
| |/ / ___ ___
| ___ \ / _ \ / _
| |/ /| /| /
_/ _| __| v1.10.0
2019/12/10 02:16:52 INFO ▶ 0001 Using 'demowithJS' as 'appname'
2019/12/10 02:16:52 INFO ▶ 0002 Initializing watcher...
github.com/ibmdb/go_ibm_db/api
github.com/astaxie/beego/config
github.com/astaxie/beego/utils
github.com/astaxie/beego/vendor/gopkg.in/yaml.v2

github.com/ibmdb/go_ibm_db/api

../github.com/ibmdb/go_ibm_db/api/api_unix.go:12:11: fatal error: sqlcli1.h: No such file or directory
// #include <sqlcli1.h>
^~~~~~~~~~~
compilation terminated.

Please help us, thanks!

[ZacZelner]

IF I changed the
dockerfile:
ENV DB2HOME=/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver (delete the Users/zac)
ENV CGO_CFLAGS=-I$DB2HOME/include
ENV DYLD_LIBRARY_PATH=$DB2HOME/lib
ENV CGO_LDFLAGS=-L$DB2HOME/lib

error changed to be:
2019/12/10 02:50:29 ERROR ▶ 0003 Failed to build the application: # github.com/ibmdb/go_ibm_db/api
/usr/bin/ld: cannot find -ldb2
/usr/bin/ld: cannot find -ldb2

[akhilravuri1]

Hi @ZacZelner

Why are you using DYLD_LIBRARY_PATH?

If you are using docker you might be creating windows or Linux containers. so you need to set PATH or LD_LIBRARY_PATH

Thanks,
Akhil

[ZacZelner]

Hi Akhil,

I have changed the dockerfile to be:
FROM golang:1.13.4

ENV PATH $PATH:$GOPATH/bin
ENV DB2HOME=/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver
ENV CGO_CFLAGS=-I$DB2HOME/include
ENV LD_LIBRARY_PATH=/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib
ENV CGO_LDFLAGS=-L$DB2HOME/lib

ADD github.com /go/src/github.com
...

still got the same issue with my comment 1#:

github.com/ibmdb/go_ibm_db/api

/usr/bin/ld: cannot find -ldb2
/usr/bin/ld: cannot find -ldb2
collect2: error: ld returned 1 exit status
2019/12/11 01:40:11 ERROR ▶ 0003 Failed to build the application: # github.com/ibmdb/go_ibm_db/api
/usr/bin/ld: cannot find -ldb2
/usr/bin/ld: cannot find -ldb2
collect2: error: ld returned 1 exit status

[akhilravuri1]

Hi @ZacZelner

ENV DB2HOME=/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver

This has to be DB2HOME=$GOAPTH/src/github.com/ibmdb/go_ibm_db/installer/clidriver
and LD_LIBRARY_PATH=$GOAPTH/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib

[ZacZelner]

Hi Akhil,

I have changed the dockerfile to be:
FROM golang:1.13.4

ENV PATH $PATH:$GOPATH/bin
ENV DB2HOME=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver
ENV CGO_CFLAGS=-I$DB2HOME/include
ENV LD_LIBRARY_PATH=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib
ENV CGO_LDFLAGS=-L$DB2HOME/lib

Still got the same error:
github.com/ibmdb/go_ibm_db/api
/usr/bin/ld: cannot find -ldb2
/usr/bin/ld: cannot find -ldb2
collect2: error: ld returned 1 exit status
2019/12/11 07:54:33 ERROR ▶ 0003 Failed to build the application: # github.com/ibmdb/go_ibm_db/api
/usr/bin/ld: cannot find -ldb2
/usr/bin/ld: cannot find -ldb2
collect2: error: ld returned 1 exit status

Please help me to check it again.

I have print all the env before I run the go application.
echo $GOPATH
echo $DB2HOME
echo $CGO_CFLAGS
echo $LD_LIBRARY_PATH
echo $CGO_LDFLAGS

zac$ docker run -it -p 8081:8081 ocvtest
/go
/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver
-I/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/include
/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib
-L/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib

[akhilravuri1]

Hi @ZacZelner
can you confirm that clidriver is present in this path(/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver)

[ZacZelner]

Yes, the clidriver is in this path.
The application can work well in my local Mac.

[akhilravuri1]

Can you share the docker file?

[akhilravuri1]

Your DockeFile should insclude

cd /root \
go get -d github.com/ibmdb/go_ibm_db \  
cd /root/go/src/github.com/ibmdb/go_ibm_db/installer \
go run setup.go
ENV DB2HOME=/root/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver \
IBM_DB_HOME=/root/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver \
CGO_CFLAGS=-I/root/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/include \
CGO_LDFLAGS=-L/root/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib \
LD_LIBRARY_PATH=/root/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib:$LD_LIBRARY_PATH \
PATH=/root/go/src/github.com/ibmdb/go_ibm_db/installer/clidriver/bin:$PATH

[ZacZelner]

Here is my dockerfile:

dockerfile:
FROM golang:1.13.4

ENV PATH $PATH:$GOPATH/bin
ENV DB2HOME=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver
ENV CGO_CFLAGS=-I$DB2HOME/include
ENV LD_LIBRARY_PATH=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib
ENV CGO_LDFLAGS=-L$DB2HOME/lib

ADD github.com /go/src/github.com

ADD build.sh /build.sh

RUN chmod +x /build.sh

RUN /build.sh

ADD demowithJS /go/src/demowithJS

ADD run.sh /

RUN chmod +x /run.sh

CMD ["/run.sh"]

build.sh:
#/bin/bash

cd /go/src/github.com/beego/bee

go install

run.sh:

#!/bin/bash

cd /go/src/demowithJS

echo $GOPATH
echo $DB2HOME
echo $CGO_CFLAGS
echo $LD_LIBRARY_PATH
echo $CGO_LDFLAGS

bee run

[ZacZelner]

changed the dockerfile:
FROM golang:1.13.4

ENV PATH=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver/bin:$PATH
ENV DB2HOME=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver
ENV IBM_DB_HOME=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver
ENV CGO_CFLAGS=-I$DB2HOME/include
ENV LD_LIBRARY_PATH=$GOPATH/src/github.com/ibmdb/go_ibm_db/installer/clidriver/lib:$LD_LIBRARY_PATH
ENV CGO_LDFLAGS=-L$DB2HOME/lib

same error

[akhilravuri1]

Hi @ZacZelner

I have understood a little bit about this why it is failing.
Are you trying to copy the driver from the local dir?

Thanks,
Akhil

[ZacZelner]

yes, I am copy the local dir, since there are lots of other sources I need under gitHub.com too, so I just copy them all into Docker.

I also thought the go_ibm_db in the GitHub need to install the driver firstly, so I chose to copy it from local.

If this is not supported, how should I write the go_ibm_db part in the docker file?

[akhilravuri1]

No that should not be a problem..I wanted to in the same how you are doing so I asked.

Can you please add this line before running the sample program

RUN go env

and please paste the output.
check whether CGO_LDFLAGS and CGO_CFLAGS have the values that are not.

Thanks,
Akhil