Code Monkey home page Code Monkey logo

Comments (4)

havedill avatar havedill commented on May 16, 2024

So i deleted my postgres db and ran teh following (in my attempt to open port 5432)

root@ip-172-31-59-45:~# docker run -d \
>     --name sl-db \
>     -e POSTGRES_PASSWORD=XXXXXXXXXXXXXXXXXXXXX\
>     -e POSTGRES_USER=XXXXXXXXXXXXXX\
>     -e POSTGRES_DB=simplelogin \
>     -p 5432:5432 \
>     --network="sl-network" \
>     postgres

And heres the logs now. Seems like it connects but the queries are wrong?

root@ip-172-31-59-45:~# echo "test" | mailx -s "test" [email protected]
root@ip-172-31-59-45:~# Jan 24 00:07:15 ip-172-31-59-45 postfix/pickup[6861]: 8549141C97: uid=0 from=<[email protected]>
Jan 24 00:07:15 ip-172-31-59-45 postfix/trivial-rewrite[8912]: warning: pgsql query failed: fatal error from host localhost: ERROR:  relation "custom_domain" does not exist?LINE 1: SELECT 'smtp:127.0.0.1:20381' FROM custom_domain WHERE domai...?                                           ^?
Jan 24 00:07:15 ip-172-31-59-45 postfix/trivial-rewrite[8912]: warning: pgsql:/etc/postfix/pgsql-transport-maps.cf lookup error for "*"
Jan 24 00:07:15 ip-172-31-59-45 postfix/trivial-rewrite[8912]: warning: pgsql:/etc/postfix/pgsql-transport-maps.cf lookup error for "*"
Jan 24 00:07:15 ip-172-31-59-45 postfix/cleanup[8911]: 8549141C97: message-id=<[email protected]>
Jan 24 00:07:15 ip-172-31-59-45 postfix/qmgr[6862]: 8549141C97: from=<[email protected]>, size=349, nrcpt=1 (queue active)
Jan 24 00:07:15 ip-172-31-59-45 postfix/trivial-rewrite[8912]: warning: pgsql query failed: fatal error from host localhost: ERROR:  relation "custom_domain" does not exist?LINE 1: SELECT domain FROM custom_domain WHERE domain='gmail.com' AN...?                           ^?
Jan 24 00:07:15 ip-172-31-59-45 postfix/trivial-rewrite[8912]: warning: relay_domains: pgsql:/etc/postfix/pgsql-relay-domains.cf: table lookup problem
Jan 24 00:07:15 ip-172-31-59-45 postfix/trivial-rewrite[8912]: warning: relay_domains lookup failure
Jan 24 00:07:15 ip-172-31-59-45 postfix/error[8915]: 8549141C97: to=<[email protected]>, relay=none, delay=0.08, delays=0.05/0.02/0/0.01, dsn=4.3.0, status=deferred (address resolver failure)
Jan 24 00:07:15 ip-172-31-59-45 postfix/error[8915]: warning: pgsql query failed: fatal error from host localhost: ERROR:  relation "custom_domain" does not exist?LINE 1: SELECT domain FROM custom_domain WHERE domain='gmail.com' AN...?                           ^?
Jan 24 00:07:15 ip-172-31-59-45 postfix/error[8915]: warning: fast_flush_domains: pgsql:/etc/postfix/pgsql-relay-domains.cf: table lookup problem
Jan 24 00:07:15 ip-172-31-59-45 postfix/error[8915]: warning: 8549141C97: flush service failure

from app.

havedill avatar havedill commented on May 16, 2024

OK so it seems either i forgot, or needed to rerun the following

docker run --rm \
    --name sl-migration \
    -v $(pwd)/dkim.key:/dkim.key \
    -v $(pwd)/dkim.pub.key:/dkim.pub.key \
    -v $(pwd)/simplelogin.env:/code/.env \
    --network="sl-network" \
    simplelogin/app:1.0.0 flask db upgrade

Now my issue is im just having issues hitting gmails smtp servers..

Jan 24 00:30:17 ip-172-31-59-45 postfix/smtpd[9959]: connect from unknown[1.1.1.4]
Jan 24 00:30:17 ip-172-31-59-45 postfix/smtpd[9959]: 4DAC647D8C: client=unknown[1.1.1.4]
Jan 24 00:30:17 ip-172-31-59-45 postfix/cleanup[9944]: 4DAC647D8C: message-id=<157982581730.9.14289193416466083985@58869fcb6dfd>
Jan 24 00:30:17 ip-172-31-59-45 postfix/qmgr[6862]: 4DAC647D8C: from=<support@#XXXXXXXX.info>, size=14498, nrcpt=1 (queue active)
Jan 24 00:30:17 ip-172-31-59-45 postfix/smtpd[9959]: disconnect from unknown[1.1.1.4] ehlo=1 mail=1 rcpt=1 data=1 commands=4
Jan 24 00:30:47 ip-172-31-59-45 postfix/smtp[9946]: connect to gmail-smtp-in.l.google.com[173.194.66.26]:25: Connection timed out
Jan 24 00:30:47 ip-172-31-59-45 postfix/smtp[9946]: connect to gmail-smtp-in.l.google.com[2607:f8b0:400d:c03::1b]:25: Network is unreachable
Jan 24 00:30:47 ip-172-31-59-45 postfix/smtp[9946]: connect to alt1.gmail-smtp-in.l.google.com[2800:3f0:4003:c00::1b]:25: Network is unreachable
Jan 24 00:31:17 ip-172-31-59-45 postfix/smtp[9946]: connect to alt1.gmail-smtp-in.l.google.com[64.233.186.27]:25: Connection timed out

root@ip-172-31-59-45:~# ping google.com
PING google.com (172.217.5.238) 56(84) bytes of data.
64 bytes from iad30s07-in-f238.1e100.net (172.217.5.238): icmp_seq=1 ttl=48 time=0.738 ms

from app.

havedill avatar havedill commented on May 16, 2024

root@ip-172-31-59-45:~# ping alt1.gmail-smtp-in.l.google.com PING alt1.gmail-smtp-in.l.google.com (64.233.186.27) 56(84) bytes of data. 64 bytes from cb-in-f27.1e100.net (64.233.186.27): icmp_seq=1 ttl=37 time=122 ms

from app.

havedill avatar havedill commented on May 16, 2024

Ok changed

inet_protocols = ipv4

and now im getting the emails, although to my spam folder :(

from app.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.