Comments (4)
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.
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.
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.
Ok changed
inet_protocols = ipv4
and now im getting the emails, although to my spam folder :(
from app.
Related Issues (20)
- SL blocks all incoming emails from altmails.com
- Service findthatlead.com indexes your domain HOT 1
- Prospect.io and ninjaoutreach.com and findemails.com and voilanorbert.com and Snov.io and getprospect.com indexing your domains!
- [Self-Hosted] Bounced Emails at Microsoft HOT 2
- Accept only certain senders for a given alias (default status for new sender)
- Can't Receive e-mails from GMail accounts HOT 2
- DKIM verification documentation partially incorrect? HOT 1
- Switch Account
- Serious issues receiving all emails forwarded to Yahoo mailbox HOT 2
- You published private key! HOT 2
- Some “bad” words HOT 4
- Nothing happens when trying to create account HOT 13
- Reverse aliases created not respecting custom domain
- Block promo
- Can not creating more then 5 subdomains even if the MAX_NB_SUBDOMAIN has been set. HOT 1
- Remove two additional sensitive word
- Need an option to use mailbox.email as "To" header instead of the alias, when forwarding an email to the mailbox. HOT 2
- Hide remove button HOT 1
- Add spam report feature
- [Feature Request] Support setting APPLICATION_ROOT Flask config HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from app.