Search found 1942 matches

by palinka
2020-03-26 03:38
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 28
Views: 7764

Re: MaxMinds GeoIP for local MySQL

For some reason, MaxMind leaves a couple of geoname_id entries blank. Added a routine to retrieve this missing information from ip-api.com in order to make the database complete. The routine looks up json data from ip-api, then cross references the countrycode against the MaxMind country name csv an...
by palinka
2020-03-26 00:52
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 14008

Re: Is HmailServer for the likes of me?

Sorry, but you didn't answer my question and it's kind of important to the topic. Are you retrieving 1&1 emails from a single account and then distributing the messages to individuals according to rules? Or does every user have his own account at 1&1?
by palinka
2020-03-25 13:53
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 14008

Re: Is HmailServer for the likes of me?

I never heard of mailcopa so I just did a quick search. It looks like a mail client that can be used in a shared environment. Hmailserver is a mail server. Hmailserver can certainly do everything you mentioned, but you would still need a client to retrieve mail, like Thunderbird or outlook. If I und...
by palinka
2020-03-25 13:38
Forum: Scripting
Topic: Syntax
Replies: 10
Views: 1716

Re: Syntax

by palinka
2020-03-24 22:32
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 28
Views: 7764

Re: MaxMinds GeoIP for local MySQL

I just committed a big update with bug fixes and a lot of cleanup. * Fixed a regex bug that caused certain networks to be skipped when inserting into database * Added choice of debug verbosity: to console, file, both or none (you still get email report no matter what you choose) * Cleaned up debuggi...
by palinka
2020-03-24 22:25
Forum: User contributed hMailServer 5 scripts
Topic: Rewrite chack Maxming GeoIP
Replies: 6
Views: 1067

Re: Rewrite chack Maxming GeoIP

bagu wrote:
2020-03-22 16:48
Oh, i missed this post...

Another good news ^^
I just did a big update with some bug fixes. If you're using it, you should get the new one.

https://github.com/palinkas-jo-reggelt/GeoLite2SQL
by palinka
2020-03-23 21:25
Forum: General discussions
Topic: ERROR MSG BOUNCES FROM OUTLOOK/HOTMAIL.COM
Replies: 6
Views: 1372

Re: ERROR MSG BOUNCES FROM OUTLOOK/HOTMAIL.COM

Well I am the hosting company as it's my hmailserver. And as you can see it's Microsoft that is rejecting the emails. The configuration is on an AWS windows server and I control the inbound and outbound rules. I haven't knowningly changed anything dealing with these rules in years. So CHECK on cont...
by palinka
2020-03-23 19:16
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

R U Faster Than a Redneck https://www.youtube.com/watch?v=uNJEQ90_wFk You have to give it up for the mustang driver. His car was slightly more powerful, but weighs almost twice as much with a state of the art (circa 1940) suspension. He really held his own, I'd say. :mrgreen: Actually one of the mo...
by palinka
2020-03-23 17:52
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

https://lolle.org/images/facepalm.png 2016 Ford Explorer Sport. Pretty quick. 365 HP twin turbo. :mrgreen: Its fun to drive on the highway. Comfortable on the pothole infested city streets. Nice balance. There's even power windows and moon roof that I can open AND close, and even keep closed when I...
by palinka
2020-03-23 17:21
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

Judging by the news, midtown Manhattan is empty. I'm thinking of driving in just to drag race down Broadway.
by palinka
2020-03-23 14:21
Forum: Scripting
Topic: Corona Quarantine Project #2 - Limit Outgoing Messages
Replies: 2
Views: 1223

Re: Corona Quarantine Project #2 - Limit Outgoing Messages

I just updated the readme to include instructions.
by palinka
2020-03-23 00:05
Forum: Scripting
Topic: Corona Quarantine Project #2 - Limit Outgoing Messages
Replies: 2
Views: 1223

Corona Quarantine Project #2 - Limit Outgoing Messages

I had a look at the other variants for limiting outgoing messages. Then I decided to do a corona-chan project out of it. :mrgreen: Unlike the others, there are no warnings. In reality, if a password is comprimised, 100 messages can go out before the affected user even checks his messages. Instead, I...
by palinka
2020-03-22 16:52
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

The real question here is will overall spam volume increase because spammers are quarantined with nothing else to do except come up with new and novel ways to spam? Or will volume decrease due to companies closing down and shutting off avenues of bot infection? :mrgreen: So far I'm seeing a lull in...
by palinka
2020-03-21 14:06
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

In Germany, some Regions are on Lockdown. If you dare to go out (except, going to work or to a food or a drugstore or a Doctor) you risk getting a fine up to 25.000 EUR or multiple years in jail. Now, more and more young people getting the Virus as well. Its showdown time. That is outrageous and un...
by palinka
2020-03-21 14:03
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

Traffic update: getting much lighter. NY's King George (mob boss Andrew (figlio di Mario) Cuomo, capo di tutti di capo) has declared we stay at home starting tomorrow night. I expect traffic to drop to normal Sunday morning levels. In other news, they've robbed me of my spring striper fishing spots ...
by palinka
2020-03-21 00:51
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

mattg wrote:
2020-03-21 00:35
palinka wrote:
2020-03-20 14:56
The way Google works it is by device.
Actually not quite

If you open two different browsers on one computer you will need to AUTH both of them
It seems to be per program / per device
That's what I meant. They look at some kind of browser identification, among other things.
by palinka
2020-03-20 15:14
Forum: General discussions
Topic: Send mail from Security Camera to gmail via hMailServer
Replies: 11
Views: 3295

Re: Send mail from Security Camera to gmail via hMailServer

Matt - I figured out the issues. Something to do with gmail port 587 vs 465. If I change port to 465.. the program works. But the debug screen gives coredump with port 465. with 587 I can get proper debug information. Is this a known issue? Yes, this is a known issue - only on port 465. You'll have...
by palinka
2020-03-20 15:06
Forum: General discussions
Topic: Suddenly slow sending of mail
Replies: 1
Views: 824

Re: Suddenly slow sending of mail

How many NDRs did you receive? 107,000?


See this post: https://www.hmailserver.com/forum/viewt ... 21&t=34663
by palinka
2020-03-20 14:56
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

One last question. Maybe the most important one. What is an appropriate no-logon interval that trips the 2 factor switch? 2 days? 7 days? 30 days? Actually, one more question. The way Google works it is by device. If it sees you're on a new device, it asks for pre- authentication. Is there any way o...
by palinka
2020-03-20 04:43
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

I think its working. The only quirk has to do with fetching the account to be unlocked. I have a table with mobile numbers for each account. At first, I set it up so every account that didn't belong to a real person used my mobile phone. But when the gammu script looks for the account based on the m...
by palinka
2020-03-20 02:39
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

SUCCESS!! Disconnect.exe works! Now I have to create a switch to turn it on and off. Earlier you mentioned that everyone is using 127.0.0.1... If you disconnect 127.0.0.1 how many users do you interrupt? I don't know. I only turned it on for all users to see if it would work, then turned it off rig...
by palinka
2020-03-20 00:32
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

SUCCESS!! Disconnect.exe works! Now I have to create a switch to turn it on and off.
by palinka
2020-03-20 00:17
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Is there any other way to disable access to the account without actually disabling the account? Disabling the account causes 550 rejections (I think).

What about RvdH's disconnect.exe? I'm going to try it.
by palinka
2020-03-19 22:54
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

LOL misunderstood.

Don't do this for me. I'm not going back to 32 bit. :(
by palinka
2020-03-19 22:09
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

:cry: didn't work..

There must be some other way of intercepting logon.
by palinka
2020-03-19 19:27
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

I set up test scripts for both the hmailserver and the gammu side of things. Got everything working. Creating & deleting autobans, no sweat. Then I put it into actual use (limited to test domains). Whooooopsss… big problem on my setup because 99.9% of traffic is on localhost. Therefore autobans don...
by palinka
2020-03-19 19:14
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

I set up test scripts for both the hmailserver and the gammu side of things. Got everything working. Creating & deleting autobans, no sweat. Then I put it into actual use (limited to test domains). Whooooopsss… big problem on my setup because 99.9% of traffic is on localhost. Therefore autobans don'...
by palinka
2020-03-18 23:39
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Anyways... OnClientConnect is executed before OnClientLogon so you can capture it there... 8) Nope. "DEBUG" 3836 "2020-03-18 17:35:45.652" "Pre-creating session 7107" "TCPIP" 3836 "2020-03-18 17:35:45.652" "TCP - 127.0.0.1 connected to 127.0.0.1:143." "DEBUG" 3836 "2020-03-18 17:35:45.652" "Executi...
by palinka
2020-03-18 20:55
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Now we're on the same page. That's definitely a good sign. :mrgreen:

Why one IP limitation? Logon goes to user.

Also, Return.Value = 1 works for imap? I just assumed it only works for smtp. Will it work within OnClientLogon?
by palinka
2020-03-18 20:22
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

LastLogonTime is updated during logon so an external check script can do the banning when the "window" closes. If I just leave my Outlook open it will re-login when checking for new mail. External script... So: IF lastlogon + n days < now THEN -> Autoban? Autoban what? You can't predict the IP used...
by palinka
2020-03-18 19:13
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Sub OnClientLogon(oClient) ' ' Find Account ' Dim oApp : Set oApp = CreateObject("hMailServer.Application") Call oApp.Authenticate(ADMIN, PASSWORD) Dim a, LastLogonTime a = Split(oClient.UserName, "@") If (UBound(a) > 0) Then LastLogonTime = oApp.Domains.ItemByName(a(1)).Accounts.ItemByAddress(oCli...
by palinka
2020-03-18 18:19
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Another question: Where do I put the script? Here is sequence of events: 1) check last logon time 2) if last logon + n days < now, then account is deemed inactive 3) autoban IP 4) send SMS unlock msg 5) receive SMS unlock response and remove autoban entry If I put the script in OnClientLogon, hasn't...
by palinka
2020-03-18 17:41
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

hm_accounts already has column accountlastlogontime. Good! I don't need to set up any new tables. What do you think is an appropriate amount of time since last logon before locking the account and forcing 2 factor renewal? A week? A month? How often do your client check for new mail and do you have...
by palinka
2020-03-18 17:38
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Also, should any action be taken on failed logon? I'm not really sure how to handle that. There could be many via password guessers.
by palinka
2020-03-18 17:32
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

hm_accounts already has column accountlastlogontime. Good! I don't need to set up any new tables.

What do you think is an appropriate amount of time since last logon before locking the account and forcing 2 factor renewal? A week? A month?
by palinka
2020-03-18 16:43
Forum: General discussions
Topic: Send mail from Security Camera to gmail via hMailServer
Replies: 11
Views: 3295

Re: Send mail from Security Camera to gmail via hMailServer

Do routes use SMTPD or C? I think the obvious thing to do is check your spam folder on gmail. IF your message was actually sent (and its not yet clear that's the case, although the log appears to have sent it), then gmail is doing something with it. Likely they're marking it spam. Also, its possible...
by palinka
2020-03-18 16:04
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Not looked for it yet ... :oops: Here you go. Everything ever written about hMailServer SASL: https://www.google.com/search?q=sasl&sa=Search&cof=S%3Ahttps%3A%2F%2Fwww.hmailserver.com%3BAH%3Acenter%3BLH%3A100%3BL%3Ahttps%3A%2F%2Fwww.hmailserver.com%2Fimages%2Ftoppic4.gif%3BLW%3A222%3BAWFID%3Aa1d4d0d...
by palinka
2020-03-18 15:59
Forum: General discussions
Topic: Weird Error - Permission Denied?
Replies: 2
Views: 1173

Re: Weird Error - Permission Denied?

I do have some code at OnDeliveryStart related to the "enhanced distribution list" project. Much clearer it won't get....I would start debugging there :? You're right, of course. Only trouble is this was the first and only time its happened and I have absolutely no idea how to reproduce it. :cry:
by palinka
2020-03-18 14:34
Forum: General discussions
Topic: Weird Error - Permission Denied?
Replies: 2
Views: 1173

Weird Error - Permission Denied?

I have this strange error I've never seen before. "ERROR" 12072 "2020-03-18 07:02:20.282" "Script Error: Source: Microsoft VBScript runtime error - Error: 800A0046 - Description: Permission denied - Line: 1 Column: 0 - Code: (null)" There's only one occurrance of it in the error log. Any idea what t...
by palinka
2020-03-18 14:18
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

By the way, have you found the hMailServer documentation for SASL yet? :lol:
by palinka
2020-03-18 13:41
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

https://developers.google.com/identity/sign-in/web/sign-in You may notice this page mention "OAuth 2.0" ... https://www.hmailserver.com/forum/viewtopic.php?p=196592#p196592 Eh... I'm still doing it with SMS. I think the benefits are clear. Plus I'm already paying for it. Plus I know I can do it. :m...
by palinka
2020-03-18 02:03
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

SorenR wrote:
2020-03-18 01:17
Google TFA is free, it only uses data so it will work on WiFi if no service is available.
Use going outside for service as an excuse to go smoke. :mrgreen:
by palinka
2020-03-18 01:09
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

How do you plan on changing password in the client software? How does anyone change the password? Most people don't have problems with that. Only 2 of my users are seasoned citizens. I can walk them through it over the phone. Anyway, password change is only going to be enforced on suspicion of comp...
by palinka
2020-03-17 23:15
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

No need to mess with password changes - it's going to FU IMAP :!: I don't understand this. Why would IMAP be any different than SMTP with regard to password changes? They share logon credentials. The token idea is great but seems a little invasive (expiring the token requires renewed validation con...
by palinka
2020-03-17 20:35
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

Also, I was just thinking. Maybe I use one the "limit outgoing messages" scripts floating around here in combination with account deactivation and force password change. Which is more logical/safe/useful? The one that tries to catch password guessers before they guess or the one that deactivates/for...
by palinka
2020-03-17 20:26
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Re: Corona Project: Day 1: Two-Factor Authentication

https://github.com/duosecurity/duo_classicasp So... Perhaps use it to authenticate your IP address combined with Username ? ^^^^ THIS ^^^^ Brilliant! As usual. Thank you again, very much. This is going to take a little thinking (but not too much, thankfully :mrgreen: ) 1) record IP at logon 2) chec...
by palinka
2020-03-17 17:44
Forum: General discussions
Topic: my mail get rejected by yahoo
Replies: 2
Views: 1467

Re: my mail get rejected by yahoo

You'd have to ask yahoo.

You're doing something that causes yahoo to believe you're a spammer. Have you previously sent spam to yahoo?

Check your blacklist rating here: http://multirbl.valli.org/
by palinka
2020-03-17 16:36
Forum: Scripting
Topic: Corona Project: Day 1: Two-Factor Authentication
Replies: 46
Views: 10193

Corona Project: Day 1: Two-Factor Authentication

I have an idea to create a 2 factor authentication using SMS. I have a working SMS gateway (Gammu). I think I can script whatever I need, but I'm having trouble coming up with a solid sequence of events. Scenario 1: 1) User fails logon 2) disable account 3) send SMS to user (user's mobile number & e...
by palinka
2020-03-17 13:54
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

It's mainly leisure, hospitality and event businesses that are suffering big time. And airlines. Worse than 9/11, supposedly. My brother is worried about getting laid off. He works for some kind of airline maintenance support company. He said they already laid off 45 executives. They're not firing ...
by palinka
2020-03-16 23:29
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

Holy crap, there's no immunity. You can get it over and over until it finally kills you. https://jamanetwork.com/journals/jama/fullarticle/2762452 Hold your horses... They don't know that for sure, experts say it is unlikely to become re-infected once the virus is pathologically gone. Problem is th...
by palinka
2020-03-16 22:20
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

Holy crap, there's no immunity. You can get it over and over until it finally kills you.

https://jamanetwork.com/journals/jama/f ... le/2762452
by palinka
2020-03-16 13:39
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

The real question here is will overall spam volume increase because spammers are quarantined with nothing else to do except come up with new and novel ways to spam? Or will volume decrease due to companies closing down and shutting off avenues of bot infection? :mrgreen:
by palinka
2020-03-16 13:24
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

We have a saying in Australia It goes along the lines of 'Only in America...' I can see how you think that this is OK, but that's not how we would do it. Whatever I think about the situation has absolutely no impact on what happens in reality. That's why you plan for the worst and hope for the best...
by palinka
2020-03-16 02:40
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

mattg wrote:
2020-03-16 01:40
(Meals-on-wheels is a system where the elderly and disaabled get a hot lunch delivered to their door every day for free if they register)
My grandfather used to volunteer to deliver. He was in his 80s and older than every last one of his delivery recipients. :mrgreen:
by palinka
2020-03-16 02:37
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

were cleaned out of bread, pasta, rice, water and most cheese In the U.K. it's toilet rolls. For some reason the (idiotic) public think an apocalypse is coming and started panic buying and emptied the shelf of toilet rolls!! Ffs! The world has gone mad. What do they think is going to happen? The go...
by palinka
2020-03-16 00:46
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

SorenR wrote:
2020-03-16 00:04
You're late in the game bro...
I know, right? That's why the shelves are bare. I got a late start.
by palinka
2020-03-15 23:33
Forum: Off-topic discussions
Topic: Corona Virus
Replies: 158
Views: 33545

Re: Corona Virus

Shit is getting real. Went shopping at 4 different stores today. All of them except one (a specialty food store - not a supermarket) were cleaned out of bread, pasta, rice, water and most cheese. I managed to get what I needed, but it was an effort. I'm good to hunker down for an entire month if nec...
by palinka
2020-03-14 14:52
Forum: General discussions
Topic: startbackup.vbs via task scheduler
Replies: 14
Views: 3287

Re: startbackup.vbs via task scheduler

RvdH wrote:
2020-03-14 13:22
In that case i wouldn't allow any other ('normal') users on the server at all...
Yeah, that's like when I leave my computer unlocked around my 5 year old.

HELPING DADDY!!!!

Not a great idea.