Wittenberg

Xheneral/General => Wittenberg => Topic started by: mpf on January 17, 2023, 03:51:55 PM

Title: Why the ballots aren't sent yet.., Report from the Database administrator
Post by: mpf on January 17, 2023, 03:51:55 PM
When the ballots were sent Sunday morning, all of the ballots to Gmail bounced back.

This was a new to me: the previous day, I had emailed gmail just the previous day from the same server.

In short, Gmail decided to block the IP of the server where the database is hosted, but it appears to be a whole block, so it might not even be just the server, it could be someone with similar IPs spamming Gmail.

The SoS and I made multiple attempts, nothing. And Gmail has no blocked email support, so all we can do is switch processor.

What we need, is a transactional email service. I used a few in my years, but here is the kicker: all of them cost money. And it's paid out of my pocket.

The cheapest, by far, is Amazon SeS, and it's the one I use daily.

So, I created an account, and tested it. It worked!

I requested on Sunday access to the production server. In short, to be able to actually send the emails.

It takes up to 24 hours and with the recent cuts, they do take their 24 hours!

So, I got a reply, and they said they needed me to validate which email actually sends the emails, not just the domain, because it's a new account. I never hear of that. So, I complied. But it starts a new 24 hours.

They replies this morning, at 4h00am, explaining that they reviewed the account and need to confirm it is a club, and not an actual secessionist movement. That Talossa was legal. I explained it was, and hopefully, within 24 hours, it will be active and the ballots will be sent.

If not, a solution is to pick a transactional email company, but they charge MONTHLY, only SES as far as I know, it mostly free.

Most of those which used to offer 5000 emails per month for free, now only offer 500 which isn't enough.

170 citizens, ballot confirmations, voting reminders... and after 500 it's often something liek $20 per month. I don't have $240 per month for a temporary gmail problem.

I don't mind paying for Ses, it might cost me something like $5 year long. It's nothing.

But not $240.

So, as soon as Amazon approves the account, ballots will be sent.

This was impossible to predict. My server has been running for years, and so far, wasn't blocked in Gmail.



Title: Re: Why the ballots aren't sent yet.., Report from the Database administrator
Post by: mpf on January 17, 2023, 03:59:02 PM
Just for confirmation, I just checked outgoing email reports, and nothing explains
Title: Re: Why the ballots aren't sent yet.., Report from the Database administrator
Post by: mpf on January 18, 2023, 04:03:44 AM
The ballots are currently being sent!

Sadly, there are UTF8 encoding issues, at least in mine.
Title: Re: Why the ballots aren't sent yet.., Report from the Database administrator
Post by: Baron Alexandreu Davinescu on January 18, 2023, 06:04:59 AM
Quote from: mpf on January 18, 2023, 04:03:44 AMThe ballots are currently being sent!

Sadly, there are UTF8 encoding issues, at least in mine.
That's great news!
Title: Re: Why the ballots aren't sent yet.., Report from the Database administrator
Post by: Carlüs Éovart Vilaçafat on January 18, 2023, 06:40:27 AM
It sounds like you're making some progress! Thanks for your hard work trying to get this resolved!
Title: Re: Why the ballots aren't sent yet.., Report from the Database administrator
Post by: Munditenens Tresplet on January 18, 2023, 02:19:34 PM
Quote from: mpf on January 17, 2023, 03:51:55 PMThey replies this morning, at 4h00am, explaining that they reviewed the account and need to confirm it is a club, and not an actual secessionist movement. That Talossa was legal. I explained it was, and hopefully, within 24 hours, it will be active and the ballots will be sent.

Ah, the old Derivatism vs Peculiarism debate.
Title: Re: Why the ballots aren't sent yet.., Report from the Database administrator
Post by: Glüc da Dhi S.H. on January 18, 2023, 02:20:18 PM
I got my ballot. Many thanks for fixing this!