netsandbox / docker-rt Goto Github PK

RT 5.0 will release "soon" would be great to have a docker image for our integration tests :)

If I have time this weekend I'll try to build a PR.

This container is not very useful for testing against RT5 instances if there is no easy way to programmatically generate an auth token.

Can you please add functionality that established an auth token from a known environmental variable?

Use case:

#docker-compose.yml

version: "3.8"

services:

    my_webservice:
        ...
        environment:
            - RT_AUTH_TOKEN: <some-random-static-hex>
  
   request_tracker:
       image: netsandbox/request-tracker:5.0
       environment:
           - RT_AUTH_TOKEN: <same-random-static-hex>

This would be very nice to have

As a work around I am willing to generate one at startup with my own dockerfile if possible though. But it seems like it requires user interaction of some kind

Thank you for this docker repo!

Please, would it be possible to add postgres suport (dbd::pg) into image?
We want to use your docker image with external postgres server.

Thank you

With the release 4.4.1 I can't start the container because apache couldn't find rt-server.fcgi

Logs from docker logs

07/09/2016 02:41:40AH00526: Syntax error on line 2 of /etc/apache2/sites-enabled/rt.conf:
07/09/2016 02:41:40FastCgiServer: "/opt/rt4/sbin/rt-server.fcgi" stat(/opt/rt4/sbin/rt-server.fcgi) failed: No such file or directory
07/09/2016 02:42:07AH00526: Syntax error on line 2 of /etc/apache2/sites-enabled/rt.conf:
07/09/2016 02:42:07FastCgiServer: "/opt/rt4/sbin/rt-server.fcgi" stat(/opt/rt4/sbin/rt-server.fcgi) failed: No such file or directory
07/09/2016 02:42:26AH00526: Syntax error on line 2 of /etc/apache2/sites-enabled/rt.conf:
07/09/2016 02:42:26FastCgiServer: "/opt/rt4/sbin/rt-server.fcgi" stat(/opt/rt4/sbin/rt-server.fcgi) failed: No such file or directory
07/09/2016 02:42:41AH00526: Syntax error on line 2 of /etc/apache2/sites-enabled/rt.conf:
07/09/2016 02:42:41FastCgiServer: "/opt/rt4/sbin/rt-server.fcgi" stat(/opt/rt4/sbin/rt-server.fcgi) failed: No such file or directory
07/09/2016 02:43:48AH00526: Syntax error on line 2 of /etc/apache2/sites-enabled/rt.conf:
07/09/2016 02:43:48FastCgiServer: "/opt/rt4/sbin/rt-server.fcgi" stat(/opt/rt4/sbin/rt-server.fcgi) failed: No such file or directory

Hi @netsandbox ,

I hope you will be fine.

So I created a docker-compose.yml file to run RT using your image which obviously supports SQLite by default but I needed to run MySQL DB at the back-end. This image lacks Perl drivers for MySQL resulting an error of missing dependency called libdbd-mysql-perl & some other troubleshooting & debug tools incl. iputils & net-tools which are necessary to checkup the inter-container connectivity & DB connectivity as well with MySQL.

Therefore, I downloaded your Dockerfile & altered it to install the above tools using Debian 12 as base image which looked as under:

FROM debian:12 AS package-installer
LABEL org.opencontainers.image.authors="Christian Loos [email protected]"
SHELL ["/bin/bash", "-o", "pipefail", "-c"]
RUN apt-get update &&
apt-get install -y
libdbd-mysql-perl
iputils-ping
net-tools
traceroute &&
apt-get clean &&
rm -rf /var/lib/apt/lists/*
FROM netsandbox/request-tracker-base:latest
COPY --from=package-installer / /
WORKDIR /usr/local/src
RUN curl -fsSL "https://download.bestpractical.com/pub/rt/release/rt-5.0.4.tar.gz" -o rt.tar.gz
&& echo "916d870d22d92027f843798be6f880aaf1517aebc3f6ab25f456f4e772f4834d rt.tar.gz" | sha256sum -c
&& tar -xzf rt.tar.gz
&& cd rt-5.0.4
&& ./configure
--enable-developer
--enable-externalauth
--enable-gd
--enable-gpg
--enable-graphviz
--enable-smime
--with-db-type=mysql
--with-web-handler=standalone
&& make install
&& mkdir --mode=0600 --parents /opt/rt5/var/data/{gpg,smime}
&& make initialize-database
&& cd .. && rm -rf /usr/local/src/*
WORKDIR /opt/rt5
COPY RT_SiteConfig.pm etc/
VOLUME /opt/rt5
COPY docker-entrypoint.sh /usr/local/bin/
ENTRYPOINT ["docker-entrypoint.sh"]
EXPOSE 80
CMD ["/opt/rt5/sbin/rt-server"]

Here come 2 problems:

1. While building the docker image using Dockerfile, it tries to make initialize-database which doesn't go successful as during image building, it tries to connect with DB. Since, the DB isn't found, the image building goes unsuccessful & I need to comment out this step in order to make image building successful. This result giving me errors in docker logs -f <rt_container_name> when container becomes up saying xxxx.tbl table not found. Therefore, my question is how we can manually upload DB schema & table info in our database to connect with RT frond-end. Having DB schema & table data is mandatory because I believe after first successful login, the RT tries to execute first setup wizard which in my case, unable to see.

2. I can see that the installation of RT itself is successful. I can see the login page in Web UI & can see that login is successful in the docker logs but then I receive an error message in Web UI saying Page not found. This involves page redirection. Can you help me how I can make it successful? Below is how my RT_SiteConfig.pm looks like
   RT_SiteConfig.txt

Any help in regards of above two will be appreciated.

Thanks @netsandbox

Hello, netsandbox, I use your image to build RT, but I don't know how to operate the database, can you tell me how to operate the database? Looking forward for your reply, thank you.

Hello

many thanks for your work.
I used the version 4.4 from docker and run perfect.
But with docker-compose has a problem.
If you have a configuration with docker-compose, its possible shared?

Regards

Hi there,
Is there an docker image meant for production use?
Thanks

What are the default login credentials?

Hi!

No really an issue but more of a request:

Could you add more environment variables such as WebDomain, rtname, Organization etc.? I don't know how to do this myself :(.

For setting it up:

Best regards,

knkms

Hi,

I was trying to use your docker to connect to an existing mysql database running on the host machine.

   --with-db-type=mysql \
   --with-db-host=host.docker.internal  \
   --with-db-port=3306 \
   --with-db-rt-host=host.docker.internal  \
   --with-db-dba=debian-sys-maint \
   --with-db-database=rtdb \
   --with-db-rt-user=rtuser \
   --with-db-rt-pass=rtuser \

and then run the docker with option --add-host host.docker.internal:host-gateway \

Is that the right way ?
Should I clone your docker recipe from docker hub ?

The readme says: "This image is intended for development or testing, not for production use."

What makes the image unsuitable for production use?