[prev in list] [next in list] [prev in thread] [next in thread]
List: trac
Subject: Re: [Trac] [solved] running trac in docker containers
From: Markus Rosjat <markus.rosjat () gmail ! com>
Date: 2023-05-05 7:49:38
Message-ID: CAJ4osOnfpRPcnJAmj+vd_K7e3+GK-oxu-NzhxUe2e7YYdqJ1JQ () mail ! gmail ! com
[Download RAW message or body]
Hi all,
i guess i solved the mystery around the problem. I took a look at scoots
yml file and saw something that got me thinking and i changed it
accordingly in my file. I had the property container-name set and i removed
it. Then i changed my uri to use the service name and rebuild my images.
After that the connection started working as expected.
Conclusion:
Dont set a container-name in the docker-compose file.
Cheers
Markus
Am Do., 4. Mai 2023 um 07:55 Uhr schrieb Markus Rosjat <
markus.rosjat@gmail.com>:
> hey jun,
>
> my yml file:
>
> version: '3'
> services:
> trac:
> build:
> context: .
> dockerfile: trac.Dockerfile
> container_name: trac
> command: tracd --auth="*,/var/trac/auth/tracauth,testtrac" -p8000
> --base-path=/testtrac -s /var/trac/projects/testtrac
> ports:
> - 8000:8000
> volumes:
> - .:/var/trac
> depends_on:
> - postgresql
> networks:
> - trac-network
>
> postgresql:
> build:
> context: .
> dockerfile: postgresql.Dockerfile
> container_name: trac-postgresql
> ports:
> - 5432:5432
> restart: always
> environment:
> POSTGRES_PASSWORD: secret
> networks:
> - trac-network
> networks:
> trac-network:
>
> my test script again that can query the db in the postgresql container
>
> import psycopg2
>
> conn = psycopg2.connect("postgres://dbuser:dbpassword@trac-postresql
> > 5432/trac_db")
> cur = conn.cursor()
> cur.execute("SELECT * FROM ticket;")
> rows = cur.fetchall()
> for row in rows:
> print(row)
> using localhost, well i dont see how this will work even docker handles 2
> containers as 2 different machines but for the sake of argument i changed
> my trac.ini back an got the expected result. With localhost in the uri
> I am back at the point that trac cant reach the db container.
>
> cheers
>
> MArkus
>
> Am Do., 4. Mai 2023 um 03:20 Uhr schrieb Jun Omae <jun66j5@gmail.com>:
>
> > On Wed, May 3, 2023 at 9:44 PM Markus Rosjat <markus.rosjat@gmail.com>
> > wrote:
> > >
> > > hi all,
> > >
> > > i try to play around a little and hit a bump in the road with using 2
> > containers formy setup. I got one container for trac and one container for
> > postgresql.
> >
> > You should share your docker-compose.yml if you want advice and supports.
> >
> > > So far so good, if i try to connect with python from trac container to
> > the postgresql one i can query data as expected
> >
> > How did you execute query to verify it? Please provide commands which you
> > tried.
> >
> > > but if i try to run tracd it tells me it can connect to the db ... here
> > is my pseudo connection string in my trac.ini
> > >
> > > database = postgres://dbuser:dbpassword@dockercontainer:5432/tracdb
> >
> > Try to use "localhost" instead of "dockercontainer".
> >
> >
> > --
> > Jun Omae <jun66j5@gmail.com> (大前 潤)
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Trac Users" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to trac-users+unsubscribe@googlegroups.com.
> > To view this discussion on the web visit
> > https://groups.google.com/d/msgid/trac-users/CAEVLMagL3AQJVvFov6dUPwCsRgBmi1WCg-ysqxL3SFoE%3Dj5ieg%40mail.gmail.com
> >
> > .
> >
>
--
You received this message because you are subscribed to the Google Groups "Trac \
Users" group. To unsubscribe from this group and stop receiving emails from it, send \
an email to trac-users+unsubscribe@googlegroups.com. To view this discussion on the \
web visit https://groups.google.com/d/msgid/trac-users/CAJ4osOnfpRPcnJAmj%2Bvd_K7e3%2BGK-oxu-NzhxUe2e7YYdqJ1JQ%40mail.gmail.com.
[Attachment #3 (text/html)]
<div dir="ltr"><div>Hi all,</div><div><br></div><div>i guess i solved the mystery \
around the problem. I took a look at scoots yml file and saw something that got me \
thinking and i changed it accordingly in my file. I had the property container-name \
set and i removed it. Then i changed my uri to use the service name and rebuild my \
images. After that the connection started working as expected. \
</div><div><br></div><div>Conclusion: </div><div><br></div><div>Dont set a \
container-name in the docker-compose \
file.</div><div><br></div><div><br></div><div>Cheers</div><div><br></div><div>Markus</div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">Am Do., 4. Mai 2023 um 07:55 \
Uhr schrieb Markus Rosjat <<a \
href="mailto:markus.rosjat@gmail.com">markus.rosjat@gmail.com</a>>:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">hey jun,<div><br></div><div>my yml \
file:</div><div><br></div><div><div \
style="color:rgb(218,218,218);background-color:rgb(30,30,30);font-family:"MesloLGM \
NF",Consolas,"Courier \
New",monospace;font-size:14px;line-height:19px;white-space:pre-wrap"><div><span \
style="color:rgb(86,156,214)">version</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(232,201,187)">'</span><span \
style="color:rgb(206,145,120)">3</span><span \
style="color:rgb(232,201,187)">'</span></div><div><span \
style="color:rgb(86,156,214)">services</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(86,156,214)">trac</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(86,156,214)">build</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(86,156,214)">context</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(181,206,168)">.</span></div><div> <span \
style="color:rgb(86,156,214)">dockerfile</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(206,145,120)">trac.Dockerfile</span></div><div> <span \
style="color:rgb(86,156,214)">container_name</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(206,145,120)">trac</span></div><div> <span \
style="color:rgb(86,156,214)">command</span><span \
style="color:rgb(180,180,180)">:</span> <span style="color:rgb(206,145,120)">tracd \
--auth="*,/var/trac/auth/tracauth,testtrac" -p8000 --base-path=/testtrac -s \
/var/trac/projects/testtrac</span></div><div> <span \
style="color:rgb(86,156,214)">ports</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(180,180,180)">-</span> <span \
style="color:rgb(206,145,120)">8000:8000</span></div><div> <span \
style="color:rgb(86,156,214)">volumes</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(180,180,180)">-</span> <span \
style="color:rgb(206,145,120)">.:/var/trac</span></div><div> <span \
style="color:rgb(86,156,214)">depends_on</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(180,180,180)">-</span> <span \
style="color:rgb(206,145,120)">postgresql</span></div><div> <span \
style="color:rgb(86,156,214)">networks</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(180,180,180)">-</span> <span \
style="color:rgb(206,145,120)">trac-network</span></div><br><div> <span \
style="color:rgb(86,156,214)">postgresql</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(86,156,214)">build</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(86,156,214)">context</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(181,206,168)">.</span></div><div> <span \
style="color:rgb(86,156,214)">dockerfile</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(206,145,120)">postgresql.Dockerfile</span></div><div> <span \
style="color:rgb(86,156,214)">container_name</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(206,145,120)">trac-postgresql</span></div><div> <span \
style="color:rgb(86,156,214)">ports</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(180,180,180)">-</span> <span \
style="color:rgb(206,145,120)">5432:5432</span></div><div> <span \
style="color:rgb(86,156,214)">restart</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(206,145,120)">always</span></div><div> <span \
style="color:rgb(86,156,214)">environment</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(86,156,214)">POSTGRES_PASSWORD</span><span \
style="color:rgb(180,180,180)">:</span> <span \
style="color:rgb(206,145,120)">secret</span></div><div> <span \
style="color:rgb(86,156,214)">networks</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(180,180,180)">-</span> <span \
style="color:rgb(206,145,120)">trac-network</span></div><div><span \
style="color:rgb(86,156,214)">networks</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(86,156,214)">trac-network</span><span \
style="color:rgb(180,180,180)">:</span></div></div></div><div><br></div><div>my test \
script again that can query the db in the postgresql \
container</div><div><br></div><div><div \
style="color:rgb(218,218,218);font-family:"MesloLGM \
NF",Consolas,"Courier \
New",monospace;font-size:14px;white-space:pre-wrap"><div \
style="background-color:rgb(30,30,30);line-height:19px;white-space:pre-wrap"><div><span \
style="color:rgb(216,160,223)">import</span> <span \
style="color:rgb(200,200,200)">psycopg2</span></div><br><div><span \
style="color:rgb(156,220,254)">conn</span> <span \
style="color:rgb(180,180,180)">=</span> <span \
style="color:rgb(200,200,200)">psycopg2</span><span \
style="color:rgb(180,180,180)">.</span><span \
style="color:rgb(220,220,170)">connect</span><span \
style="color:rgb(180,180,180)">(</span><span \
style="color:rgb(232,201,187)">"</span><span \
style="color:rgb(206,145,120)">postgres://dbuser:dbpassword@trac-postresql:5432/trac_db</span><span \
style="color:rgb(232,201,187)">"</span><span \
style="color:rgb(180,180,180)">)</span></div><div><span \
style="color:rgb(156,220,254)">cur</span> <span \
style="color:rgb(180,180,180)">=</span> <span \
style="color:rgb(156,220,254)">conn</span><span \
style="color:rgb(180,180,180)">.</span><span \
style="color:rgb(220,220,170)">cursor</span><span \
style="color:rgb(180,180,180)">()</span></div><div><span \
style="color:rgb(156,220,254)">cur</span><span \
style="color:rgb(180,180,180)">.</span><span \
style="color:rgb(220,220,170)">execute</span><span \
style="color:rgb(180,180,180)">(</span><span \
style="color:rgb(232,201,187)">"</span><span \
style="color:rgb(206,145,120)">SELECT * FROM ticket;</span><span \
style="color:rgb(232,201,187)">"</span><span \
style="color:rgb(180,180,180)">)</span></div><div><span \
style="color:rgb(156,220,254)">rows</span> <span \
style="color:rgb(180,180,180)">=</span> <span \
style="color:rgb(156,220,254)">cur</span><span \
style="color:rgb(180,180,180)">.</span><span \
style="color:rgb(220,220,170)">fetchall</span><span \
style="color:rgb(180,180,180)">()</span></div><div><span \
style="color:rgb(216,160,223)">for</span> <span \
style="color:rgb(156,220,254)">row</span> <span \
style="color:rgb(216,160,223)">in</span> <span \
style="color:rgb(156,220,254)">rows</span><span \
style="color:rgb(180,180,180)">:</span></div><div> <span \
style="color:rgb(220,220,170)">print</span><span \
style="color:rgb(180,180,180)">(</span><span \
style="color:rgb(156,220,254)">row</span><span \
style="color:rgb(180,180,180)">)</span></div></div> </div></div><div>using localhost, \
well i dont see how this will work even docker handles 2 containers as 2 different \
machines but for the sake of argument i changed my trac.ini back an got the expected \
result. With localhost in the uri </div><div>I am back at the point that trac cant \
reach the db container.</div><div><br></div><div>cheers</div><div><br></div><div>MArkus \
</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Am Do., 4. \
Mai 2023 um 03:20 Uhr schrieb Jun Omae <<a href="mailto:jun66j5@gmail.com" \
target="_blank">jun66j5@gmail.com</a>>:<br></div><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">On Wed, May 3, 2023 at 9:44 PM Markus Rosjat \
<<a href="mailto:markus.rosjat@gmail.com" \
target="_blank">markus.rosjat@gmail.com</a>> wrote:<br> ><br>
> hi all,<br>
><br>
> i try to play around a little and hit a bump in the road with using 2 \
containers formy setup. I got one container for trac and one container for \
postgresql.<br> <br>
You should share your docker-compose.yml if you want advice and supports.<br>
<br>
> So far so good, if i try to connect with python from trac container to the \
postgresql one i can query data as expected<br> <br>
How did you execute query to verify it? Please provide commands which you tried.<br>
<br>
> but if i try to run tracd it tells me it can connect to the db ... here is my \
pseudo connection string in my trac.ini<br> ><br>
> database = postgres://dbuser:dbpassword@dockercontainer:5432/tracdb<br>
<br>
Try to use "localhost" instead of "dockercontainer".<br>
<br>
<br>
-- <br>
Jun Omae <<a href="mailto:jun66j5@gmail.com" \
target="_blank">jun66j5@gmail.com</a>> (大前 潤)<br> <br>
-- <br>
You received this message because you are subscribed to the Google Groups "Trac \
Users" group.<br> To unsubscribe from this group and stop receiving emails from \
it, send an email to <a href="mailto:trac-users%2Bunsubscribe@googlegroups.com" \
target="_blank">trac-users+unsubscribe@googlegroups.com</a>.<br> To view this \
discussion on the web visit <a \
href="https://groups.google.com/d/msgid/trac-users/CAEVLMagL3AQJVvFov6dUPwCsRgBmi1WCg-ysqxL3SFoE%3Dj5ieg%40mail.gmail.com" \
rel="noreferrer" target="_blank">https://groups.google.com/d/msgid/trac-users/CAEVLMagL3AQJVvFov6dUPwCsRgBmi1WCg-ysqxL3SFoE%3Dj5ieg%40mail.gmail.com</a>.<br>
</blockquote></div>
</blockquote></div></div>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "Trac \
Users" group.<br /> To unsubscribe from this group and stop receiving emails \
from it, send an email to <a \
href="mailto:trac-users+unsubscribe@googlegroups.com">trac-users+unsubscribe@googlegroups.com</a>.<br \
/> To view this discussion on the web visit <a \
href="https://groups.google.com/d/msgid/trac-users/CAJ4osOnfpRPcnJAmj%2Bvd_K7e3%2BGK-o \
xu-NzhxUe2e7YYdqJ1JQ%40mail.gmail.com?utm_medium=email&utm_source=footer">https://grou \
ps.google.com/d/msgid/trac-users/CAJ4osOnfpRPcnJAmj%2Bvd_K7e3%2BGK-oxu-NzhxUe2e7YYdqJ1JQ%40mail.gmail.com</a>.<br \
/>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic