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 <[email protected]>:
> On Wed, May 3, 2023 at 9:44 PM Markus Rosjat <[email protected]>
> 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 <[email protected]> (大前 潤)
>
> --
> 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 [email protected].
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/trac-users/CAJ4osO%3DtrqpPYEEG1SpR1xYYhqYQ%3Ddn7RsZPXNtMQop%2BW18eYw%40mail.gmail.com.