hMailServer forum

palinka

I just tried the city data for the first time and ran it on my IP. The supposed accuracy_radius is 1 meter for my IP but the latitude/longitude coordinates were off by several blocks. Still the same town, though. Most online geoip locators put me in the next town over. I tried searching by latitude/...

palinka

I don't think there have been any changes to IMAP at all in 5.7. Also, I'd suggest that its your client that's misbehaving. I use emclient too and once in a blue moon get a situation where an apparently "corrupted" email causes emclient to stop downloading mail, while 9folders mail client on my pho...

palinka

I would like to force hMailServer to automatically delete a message right after it is downloaded by the receiver. I think running a handler script that looks at flags could do what you want. However, right after would mean as soon as the script runs looking for seen messages, run from task scheduler.

palinka

I don't think there have been any changes to IMAP at all in 5.7. Also, I'd suggest that its your client that's misbehaving. I use emclient too and once in a blue moon get a situation where an apparently "corrupted" email causes emclient to stop downloading mail, while 9folders mail client on my phon...

palinka

There are a lot of restrictions to what a .tk domain can be used for and the tld do not have the best reputation on the 'net. SECTION IV 13.A.ii The powering of such transmitting equipment (including but not limited to switches, routers, telephones, 2 cans with a string, smoke signal fires, war dru...

palinka

seems up and running now.. 61.2.140.123 Port Number State Service Name Service Product 25 open smtp 110 open pop3 hMailServer pop3d 143 open imap hMailServer imapd 465 open smtp 587 open smtp 993 open pop3 hMailServer pop3d are you using any other vpn or IP tunneling software that "moves" your comp...

palinka

Here's my fixed up powershell version.

* Added the lightning speed import
* Deleted create scheduled task
* Added colorful email notifications

https://github.com/palinkas-jo-reggelt/GeoLite2SQL

palinka

Mysqlimport is NOT very informative. Do your SQL IMPORT in a SQL command windows to debug.. :roll: From phpmyadmin after deleting the first row and inserting same row from csv: INSERT INTO geocountry ( network_start_integer, network_last_integer, geoname_id, registered_country_geoname_id, represent...

palinka

Everywyere I have searched on the Interweb I find DBA's preferring JOIN over complicated queries... Comparing 0.004 seconds to 0.009 seconds will only matter if do millions of queries per minute. Notice how I defined the primary keys. It needs to be this way if you want to import and "replace" and ...

palinka

I found a few bugs last night, still working on getting rid of the warnings but they do not seem to interfere... Did you find the source of the warnings? How to make mysqlimport more verbose? I'm guessing it has something to do with empty fields? 16777216,16777471,2077456,2077456,,0,0 = 16777216,16...

palinka

Untested on your tables: SELECT * FROM ( SELECT * FROM geocountry WHERE INET_ATON('1.2.3.4') <= network_last_integer LIMIT 1 ) INNER JOIN geolocation ON geocountry.geoname_id = geolocation.geoname_id WHERE geocountry.network_start_integer <= INET_ATON('1.2.3.4'); Also, I forgot. Making column netwo...

palinka

PugzPOE wrote: ↑
2021-04-06 11:32
Aand it stops working again

Try turning your router on.

Is it morning where you are yet?

Nope. Still night time.

I guess I'll try again tomorrow. Maybe it will be morning there tomorrow.

palinka

PugzPOE wrote: ↑
2021-04-05 17:22

palinka wrote: ↑
2021-04-05 13:18
Screenshot_20210405-071646_Opera.jpg

Maybe you should check your router for port forwarding.
Internet outage

Still?

: Screenshot 2021-04-05 152353.png (13.86 KiB) Viewed 631 times

palinka

Maybe you should check your router for port forwarding.

palinka

SorenR wrote: ↑
2021-04-04 01:25
Guys... Easy now... IPv5 is difficult to work with.

Maybe but its nothing compared to IPv7. You need a doctorate for that. I only have a masters degree!

palinka

Hmailserver service is not running. He said it was running and posted a screen grab from windows services. I know what he said but the evidence says different. Either it isn't running or he isn't looking at the same box - both contrary to what has been claimed. [Entered by mobile. Excuse my spellin...

palinka

Hmailserver service is not running. He said it was running and posted a screen grab from windows services. I think its a different machine altogether. How? I have no idea. is all i got https://cdn.discordapp.com/attachments/822328745250652221/827964972083838996/unknown.png You have to run the scrip...

palinka

PugzPOE wrote: ↑
2021-04-03 17:11
Well i had to modify the ipoe and pppoe interfaces

Run this and post the results.

https://hmailserver.com/forum/viewtopic ... 20&t=30914

If hmailserver is running, but no ports are listening, then those ports must have been removed from settings > advanced > tcpip ports

palinka

I planning to set up a web interface to my hMailServer at mail.mydomain.com, and access it trough HTTPS. I'll use win-acme to get the SSL certificate (through Let's Encrypt). My hMailServer is also setup for the same domain, mail.mydomain.com. Can I import the same certificate into hMailServer so i...

palinka

PugzPOE wrote: ↑
2021-04-03 05:53
Ok running netstat -a -b -n shows nothing is listening on the ports

Looks like hmailserver is not running at all. Did you check windows services? If its not running, try to start it and look in the event log for errors.

palinka

Untested on your tables: SELECT * FROM ( SELECT * FROM geocountry WHERE INET_ATON('1.2.3.4') <= network_last_integer LIMIT 1 ) INNER JOIN geolocation ON geocountry.geoname_id = geolocation.geoname_id WHERE geocountry.network_start_integer <= INET_ATON('1.2.3.4'); Also, I forgot. Making column netwo...

palinka

All Files are being created with the "network","geoname_id" EXCEPT "CSV-DB.csv" is created without the headers. This is clearly something on your end. Try this powershell. Put the script in some place that's NOT where you're running geolite2sql: $DBcsv = "$PSScriptRoot\Script-Created-Files\CSV-DB.c...

palinka

SELECT * FROM geolocation INNER JOIN geocountry ON geocountry.geoname_id = geolocation.geoname_id WHERE network_start_integer <= INET_ATON('1.2.3.4') AND INET_ATON('1.2.3.4') <= network_last_integer; One thing I did find that could be useful to you was that dividing the query into a subquery with a...

palinka

15 seconds Old school at its best :mrgreen: There's no school like the old school... :mrgreen: I don't know why I didn't think of that before: mysqlimport. I'm still a noob. New School. :oops: I'm going to have to rethink the whole thing now. 1:21:55,55 to 1:25:06,59 Don't you sleep?

palinka

@Palinka ... How different is this from what your code does? Mine only does country I gave up on the PowerShell scripting... :wink: :oops: powershell gets you smiles from all the ladies, and it makes you smell nice. Needs the MaxMind converter: https://github.com/maxmind/geoip2-csv-converter/releas...

palinka

All Files are being created with the "network","geoname_id" EXCEPT "CSV-DB.csv" is created without the headers. This is clearly something on your end. Try this powershell. Put the script in some place that's NOT where you're running geolite2sql: $DBcsv = "$PSScriptRoot\Script-Created-Files\CSV-DB.c...

palinka

Sorry to bug you but still problem is here Can you confirm these files exist with the headers intact? Add-Content -Path $MMcsv -Value '"network","geoname_id"' Add-Content -Path $DBcsv -Value '"network","geoname_id"' Add-Content -Path $ToAddIPv4 -Value '"network","geoname_id"' Add-Content -Path $ToD...

palinka

Try Add-Content. I just tried it (simple add content test) and it worked fine. Creates the file and adds the content. Add-Content -Path $MMcsv -Value '"network","geoname_id"' Add-Content -Path $DBcsv -Value '"network","geoname_id"' Add-Content -Path $ToAddIPv4 -Value '"network","geoname_id"' Add-Con...

palinka

STILL SOME ISSUE in COMPARING AND ADDING TO DB 17:03:39 : 00:00 : Comparing updated MaxMind data to database Compare-Object : Cannot bind argument to parameter 'ReferenceObject' because it is null. At C:\Scripts\GeoIP\GeoLite2SQL.ps1:216 char:35 + Compare-Object -ReferenceObject $(Get-Content $DBcs...

palinka

No. The issue is later the script checks to make sure the files were actually deleted. They were deleted, but then we re- created them so of course the test failed. :oops: Look down a few lines to the next block of code. All the new-item lines should go AFTER that next block ("Check to make sure fil...

palinka

RAN INTO A PROBLEM geo_ip table is created but it is blank with no values Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 26/03/2021 01:05 PM 0 DebugLog.log 13:05:08 : 00:00 : GeoIP Update Start 13:05:08 : 00:00 : Deleting old files 13:05:08 : 00:00 : Downloading MaxMind data 1...

palinka

I have switched to a different GEO site... Requires a KEY but you can get a free one. MaxMind local db. https://hmailserver.com/forum/viewtopic.php?f=9&t=34496 :mrgreen: Ah, yes ... Forgot about that one. :wink: Weekly updates from MaxMind. Yesterday's update: 3,974 Records removed from database 5,...

palinka

SorenR wrote: ↑
2021-03-24 17:18
I have switched to a different GEO site... Requires a KEY but you can get a free one.

MaxMind local db. https://hmailserver.com/forum/viewtopic.php?f=9&t=34496

palinka

You do know that SMS was never intended to be real-time. Actually my old NEC TR5E1000 - 7A phone from 1986 could do DMS ... or NMT-text as it also was called. That was really cool but it could sometimes take up to 10 minutes to come through. Messages were short spaced so we had to move on from 1337...

palinka

Hi all, I have created a rule to create copy forwarding based on the number of retransmissions. After each delivery, the subject of the email changes and then the e-mail is received by the SMS gateway, which sends the SMS to the set number in the subject of the email. There are about 30 such rules....

palinka

Getting an Error "ERROR" 8396 "2021-03-22 09:36:01.591" "Script Error: Source: Microsoft VBScript runtime error - Error: 800A000D - Description: Type mismatch: 'oGeoip' - Line: 138 Column: 3 - Code: (null)" Probably because you are trying to decode an empty or invalid response in oXML.responseText ...

palinka

They look extremely firewall-ban-able to me. Very ripe.

palinka

johang wrote: ↑
2021-03-17 16:51
wait... youre only a mile off from India ?

palinka

RvdH wrote: ↑
2021-03-18 12:49
Maybe might be worth a feature request, limiting "Concurrent connection per IP Address" for (SMTP) connections

May not play well with services like Google gsuite. I guess that would depend a LOT on traffic level. Probably not an issue for 99% of hmailserver instances.

palinka

3. dont just add the 45.142.120.0 - 45.142.120.255 in the IPranges.. ADD them in your firewall ( so you dont even have them in your logs ) you can do it manually if you want it done automagically.. you should look at Palinkas firewall ban in the forum https://www.hmailserver.com/forum/viewtopic.php...

palinka

Hey, I was just trying this out, got this message returned: {"detail":"The APIv1 check endpoint has sunset. Please migrate to the APIv2 version of this endpoint. You will need a new API key.","links":{"related":"https:\/\/docs.abuseipdb.com\/#check-endpoint"},"status":404} Any update to the origina...

palinka

One problem I found that even the finance@mydomain.com is getting the redacted mail :roll: Naturally, since it was edited before delivery. I guess one thing you could is set up an intermediate account. Create finance-temp@mydomain.com. Then: Global Rule If: from contains bankmail@bank.com body cont...

palinka

I think that can all be done by rule. If from finance Action: 1) Forward unredacted to appropriate person 2) Run function to redact 3) Forward to distribution list Is this Possible / OR Viable sorry for little confusion in my previous post. mails come from bankmail@bank.com to finance@mydomain.com ...

palinka

SorenR wrote: ↑
2021-03-16 14:58
It is about as useful as pineapple on pizza

I had pineapple pizza in Napoli in 1989. At first I was skeptical, but its a perfect compliment to bacon. Pizza is serious business in Napoli.

palinka

I think that can all be done by rule.

If from finance

Action:
1) Forward unredacted to appropriate person
2) Run function to redact
3) Forward to distribution list

palinka

Why are you using MS SQL Express? Would you be open to using MySQL Database which is a commonly used Database Server for hMailServer. There are freeware versions of MySQL Database Server. With it you can install MySQL either while installing hMailServer 5.6.7-B2425 or install it before installing h...

palinka

That works fine but in my "onacceptmessage" script, where I check some words in the subject of the messages for rejection , this one seems not to appear in my script but nevertheless it is delivered to the receipiant. Surprisingly, however, it is rejected form the script, if I forward it to the sam...

palinka

The error message that I get, when I attempt to have the new database created, is: "CREATE DATABASE permission denied in database 'master'" .......... I'm not sure if I took a wrong turn here: https://dba.stackexchange.com/q/78388 Answer from your link: The user must be a member of dbcreator server...

palinka

You can use an account rule.

Or if it's a long list of users you could put their addresses in an array and check against the array.

palinka

Try this instead. You can reuse the function for other things. Function oLookup(strRegEx, strMatch, bGlobal) If strRegEx = "" Then strRegEx = StrReverse(strMatch) With CreateObject("VBScript.RegExp") .Pattern = strRegEx .Global = bGlobal .MultiLine = True .IgnoreCase = True Set oLookup = .Execute(st...

palinka

SorenR wrote: ↑
2021-03-08 16:26
Enjoying the quiet ...

Me too.

palinka

katip wrote: ↑
2021-03-06 08:35
sure it is possible to cope with all this. but not worth it IMO. all in all we're talking about minor cosmetic tweaks.

I agree. Put a fork in it.

Before: indecipherable.
After: readable.

I'm good with keeping it simple.

palinka

LBPO wrote: ↑
2021-03-02 13:52
Code: Select all
   !!  Warning:  DEFAULT DOMAIN is SET  !! - "Domain1.com"

This could be it. I'm not 100% certain but it can't hurt to try. Default domain allows login with "user" instead of "user@domain.tld". You should turn that off.

Settings > Advanced > delete entry from "Default Domain".

palinka

Run this and post the results: https://hmailserver.com/forum/viewtopic ... 20&t=30914

palinka

If only we knew a few people that were knowledgeable in fighting spam...

palinka

When I say 'not every building has a cellar' - I mean MOST buildings do not have cellars. (I guess this is going to lead to a straw poll for those that dont agree). I would disagree, but it seems once again to be a language barrier. From wackypedia: In British English, the word basement is used for...

palinka

Not every building has a cellar. Only in Floriduh... When I say 'not every building has a cellar' - I mean MOST buildings do not have cellars. (I guess this is going to lead to a straw poll for those that dont agree). I would disagree, but it seems once again to be a language barrier. From wackyped...

palinka

Not every building has a cellar. Only in Floriduh... The usual 'ground' floor is usually at ground level (as in an opening from outside) - every building has one of these. Windows are openings from outside as well. 8) The next building I build (hopefully a medical building in Queens - still waiting...

palinka

This issue dates back to the early settlers... Apparently the lexicographer Noah Webster was a dyslexic. ;-) https://www.boredpanda.com/british-american-english-differences-language/?utm_source=google&utm_medium=organic&utm_campaign=organic Is the ground floor/first floor thing a european thing? I'...

palinka

You got the same extra linebreaks i have....i don't like that :) I think it must have something to do with the way hmailserver wraps the lines. Hmailserver seems to remove the original line breaks from spamassassin, which wrecks the formatting. Really? :mrgreen: You are a freaking genius :lol: My m...

Search found 2526 matches