Search found 110 matches

by gotspatel
2021-04-07 05:43
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

Second lookup where body is "text/html" you still refer to "oMessage.Body" in "oLookup" and "Replace". I believe that should be "oMessage.HTMLBody" . Also, your rule ... body contains "BALANCE line to redact" ... Again, this is "text/plain" only and does such a text exist in the email body? Perhaps...
by gotspatel
2021-04-06 07:43
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

mails come from alerts@mybank.com to finance@mydomain.com Global Rule: If from contains alerts@mybank.com body contains "BALANCE line to redact" X-hMailServer-LoopCount < 1 Action: 1) Forward unredacted to distribution list No 1 2) Run function to redact 3) Forward to distribution list No 2 Mails o...
by gotspatel
2021-04-01 11:46
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

If oMessage.HeaderValue("X-hMailServer-LoopCount") = "" Then I don't think that header exists wehn it's empty.... oMessage.HeaderValue("X-hMailServer-LoopCount") only is added when loopcount > 0 Got that. Thanks. Already removed them but still figuring out the exact sequencing for achieve what I wa...
by gotspatel
2021-03-30 07:00
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

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...
by gotspatel
2021-03-29 17:03
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

Glad to be of service :mrgreen: I actually found a bug, nothing major and if you only run the script once a week it does not matter... It's the "fc" file compare on one of the datasets that trigger mysqlimport also when downloaded data is not changed by comparing files that will never match. :roll:...
by gotspatel
2021-03-29 17:02
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

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: FOUND THE ISSUE The database table being EMPTY the co...
by gotspatel
2021-03-29 15:35
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

If you are like me where PowerShell is a bit like "Yeah, I'll get into it when I get some spare time" then perhaps try this old school approach. :mrgreen: Ok, I've been working on indexes to optimize stuff and field types to get rid of all the warning during import. This is the "local" version wher...
by gotspatel
2021-03-29 06:08
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

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...
by gotspatel
2021-03-28 14:06
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

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...
by gotspatel
2021-03-28 07:10
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

Sorry to bug you but still problem is here Compare-Object -ReferenceObject $(Get-Content $DBcsv) -DifferenceObject $(Get-Content $MMcsv) | ForEach-Object { THE LOG PS C:\Users\NSP.Admin> C:\Scripts\GeoIP\GeoLite2SQL.ps1 Directory: C:\Scripts\GeoIP Mode LastWriteTime Length Name ---- ------------- --...
by gotspatel
2021-03-27 06:12
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

New-Item -Path $MMcsv -Value '"network","geoname_id"' New-Item -Path $DBcsv -Value '"network","geoname_id"' New-Item -Path $ToAddIPv4 -Value '"network","geoname_id"' New-Item -Path $ToDelIPv4 -Value '"network","geoname_id"' RESULT: PS C:\Users\NSP.Admin> C:\Scripts\GeoIP\GeoLite2SQL.ps1 Directory: ...
by gotspatel
2021-03-26 13:37
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

<# Delete old files if exist #> VerboseOutput "Deleting old files" $Timer = Get-Date If (Test-Path "$PSScriptRoot\GeoLite2-Country-CSV") {Remove-Item -Recurse -Force "$PSScriptRoot\GeoLite2-Country-CSV"} If (Test-Path "$PSScriptRoot\Script-Created-Files\GeoLite2-Country-CSV.zip") {Remove-Item -Forc...
by gotspatel
2021-03-26 12:41
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

No so other error after replacing the block Directory: C:\Scripts\GeoIP Mode LastWriteTime Length Name ---- ------------- ------ ---- d----- 26/03/2021 04:09 PM Script-Created-Files -a---- 26/03/2021 04:09 PM 0 DebugLog.log 16:09:19 : 00:00 : GeoIP Update Start 16:09:19 : 00:00 : Deleting old files ...
by gotspatel
2021-03-26 10:03
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16111

Re: MaxMinds GeoIP for local MySQL

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 13...
by gotspatel
2021-03-24 17:23
Forum: Scripting
Topic: Firewall Ban
Replies: 165
Views: 76990

Re: Firewall Ban

Will check that out tomorrow.

Thanks
by gotspatel
2021-03-22 13:16
Forum: Scripting
Topic: Firewall Ban
Replies: 165
Views: 76990

Re: Firewall Ban

Thanks will check it out.

The error is random as I am already getting ONLOGIN entries in my database.
by gotspatel
2021-03-22 07:45
Forum: Scripting
Topic: Firewall Ban
Replies: 165
Views: 76990

Re: Firewall Ban

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)" ' Credit 99.9% to SorenR Function AccRejDB(xPort, xEvent, xAccRej, xReason, xIPAddress, xHELO...
by gotspatel
2021-03-16 15:30
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

One problem I found that even the finance@mydomain.com is getting the redacted mail :roll:
by gotspatel
2021-03-16 14:18
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

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 ...
by gotspatel
2021-03-16 14:04
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

Can you elaborate on the intended functionality? Should the message be modified BEFORE forwarding - thus also modifying the original message? (your initial suggestion) My intended use is as We are getting mails from bank on email finance@mydomain.com I want to forward copies to some users with the ...
by gotspatel
2021-03-16 11:09
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

I'm not really sure what else to use the "Groups" for ... :mrgreen: Isn't that for Public folder permissions Yes - but not exclusively :mrgreen: Am I on the right Track?? Option Explicit ' ' COM authentication ' Private Const ADMIN = "administrator" Private Const PASSWORD = "Cosmic Secret Password"...
by gotspatel
2021-03-13 15:06
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

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(s...
by gotspatel
2021-03-12 13:00
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Re: Modifying the Body before Forwarding

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(s...
by gotspatel
2021-03-12 11:15
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 926

Modifying the Body before Forwarding

Hi, Need small help, I want to remove one line from the mail and forward it to a user. Where I am making mistake. Sub Bankmail(oMessage) 'custom event 'uses globals: 'called from: Rules Dim txtMsg, aspMsg If oMessage.HeaderValue("X-hMailServer-LoopCount") = "" Then If oMessage.HasBodyType("text/plai...
by gotspatel
2021-01-25 14:06
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

No I am using the old 1.13 version still now. I haven't change to hmsdir/7za.exe You sure about that? YES and sorry for confusion but I changed the version file manually as I have custom function of archiving the log files. and YES I have compared the codes file by file and line by line the changes...
by gotspatel
2021-01-25 13:55
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Thanks for this. Recently I started uploading system of backup but getting problem, 1. Neither folder is being created 2. Neither the 7z is being created, Previously it was non password zip files being created when not uploading to letsupload.io 3. Nor it is being uploaded to letsupload, the folder...
by gotspatel
2021-01-25 11:51
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Sorry - I thought I had removed the double quotes. I meant: $ArchivePassword = "y(PJ8G2{cn$Ub4f^>" (the double quote just creates and empty string and therefore the remaining characters have no place - hence the error when using them). Yes it works and created the passworded zip but cannot open the...
by gotspatel
2021-01-25 10:22
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Hmmm... And $ArchivePassword = ""y(PJ8G2{cn$Ub4f^>"" Definitely doesn't work? (Escaped with ^) [Entered by mobile. Excuse my spelling.] NOPE. 25/01/2021 01:51 PM : ERROR : Unable to load supporting PowerShell Scripts 25/01/2021 01:51 PM : ERROR : At C:\Scripts\HMSBackup\hMailServerBackupConfig.ps1:...
by gotspatel
2021-01-25 10:10
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

$ArchivePassword = ""y(PJ8G2{cn$Ub4f>"" And $PWSwitch = "-p$ArchivePassword" ? [Entered by mobile. Excuse my spelling.] Still not working. Pserror.log 25/01/2021 01:41 PM : ERROR : Unable to load supporting PowerShell Scripts 25/01/2021 01:41 PM : ERROR : At C:\Scripts\HMSBackup\hMailServerBackupCo...
by gotspatel
2021-01-25 09:13
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

request to mods if inappropriate please remove my both previous posts. 7z command line does not accept passwords with special character unless provided in " " Quotes. as per this https://sourceforge.net/p/sevenzip/discussion/45798/thread/2bbf54b7/ https://stackoverflow.com/questions/21611328/python-...
by gotspatel
2021-01-25 08:36
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

I again tried many different setting combination and conclude as below, using the $PWProtectedArchive = $True created the problem of not creating the archive locally and not uploading it If It is false then archives are created locally as well as are uploaded properly. this is the parameters in hmsb...
by gotspatel
2021-01-25 06:51
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Also, this thread: Spamassassin bootcamp https://hmailserver.com/forum/viewtopic.php?f=20&t=26866&start=60 Read it like its scripture. :mrgreen: Thanks for this. Recently I started uploading system of backup but getting problem, 1. Neither folder is being created 2. Neither the 7z is being created,...
by gotspatel
2021-01-14 14:37
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

palinka wrote:
2021-01-14 13:58
Also, this thread: Spamassassin bootcamp https://hmailserver.com/forum/viewtopic ... 6&start=60

Read it like its scripture. :mrgreen:
Thanks for the head start will check.

And thanks for the config details in previous post, will check and start config.
by gotspatel
2021-01-14 05:04
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

The error is access denied, so it probably has something to do with what user is attempting to access sa-learn (unlikely) -or- what user is attempting to access your bayes backup file -or- your bayes backup file does not exist. Check your config file and verify the bayes backup FILE (the config say...
by gotspatel
2021-01-13 17:00
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Or, instead of Out-Null, use Out-String. One of them is bound to work. You'll have to test it out and let me know which one works. Out of curiosity, what database and what version are you using? Tried all variations but the error stays, BUT the SQL dump is coming successfully. I checked over the we...
by gotspatel
2021-01-12 14:32
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Not to worry, it "just one of those things with Windows". The problem with path names containing one or more spaces has existed since Windows 95. https://www.howtogeek.com/694949/how-to-escape-spaces-in-file-paths-on-the-windows-command-line/ Thanks for the pointer, if it is not a problem I need no...
by gotspatel
2021-01-12 14:17
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

One more error in Bayes processing cmd.exe : Access is denied. At C:\Scripts\HMSBackup\hMailServerBackupFunctions.ps1:729 char:5 + ... & cmd /c "`"$SADir\sa-learn.exe`" --backup > `"$BayesBack ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (Access is ...
by gotspatel
2021-01-12 14:14
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Maybe the help text helps: C:\Program Files (x86)\hMailServer\Bin>7za C:\Program Files (x86)\hMailServer\Bin> (There is a " -v{Size}[b|k|m|g]: Create volumes " option) Wikipedia says "standalone executable 7za.exe, containing built-in modules, but with compression/decompression support limited to 7...
by gotspatel
2021-01-12 13:47
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Implemented the code but getting error in using 7zip for logs, calling the 7zip, I checked your code in hMailServerBackupFunctions.ps1 also it is the same, still it is throwing this error here for logs of PATH. but it is successfully creating zip for the main backup of mails and other data. PS: $Se...
by gotspatel
2021-01-12 10:34
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

One more error in Bayes processing cmd.exe : Access is denied. At C:\Scripts\HMSBackup\hMailServerBackupFunctions.ps1:729 char:5 + ... & cmd /c "`"$SADir\sa-learn.exe`" --backup > `"$BayesBack ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (Access is d...
by gotspatel
2021-01-12 08:51
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Please ignore my Ignorance but I am no programmer but learning from the forum. :D That was me not long ago. :D Sorry, but you caught me at a bad time. I have to go away for the weekend with no computer, so I won't be able to get to much until Monday, but I have a couple of minutes now, so... :D For...
by gotspatel
2021-01-11 15:39
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Winscp can do a synchronize backup (using sftp). It can reference destination by ftp or by unc as per your choice) but using sftp protocol can you can look down to single port and connection authentication therefore secure against unwanted connections and devices. It can also de incorporated in scr...
by gotspatel
2021-01-10 06:31
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Winscp can do a synchronize backup (using sftp). It can reference destination by ftp or by unc as per your choice) but using sftp protocol can you can look down to single port and connection authentication therefore secure against unwanted connections and devices. It can also de incorporated in scr...
by gotspatel
2021-01-09 13:26
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

When I do my weekly "backup-backup" (backing up the built-in hMailServer backups) I use Remote Desktop to my server, log on network resources, sync network drives with DSynchronize v2.30.6 (server is a W2K3R2 Server), log off servers, disconnect Remote Desktop. :lol: As simple as That. But I want t...
by gotspatel
2021-01-09 10:51
Forum: User-submitted tutorials
Topic: Giving back to the team and community: log file database upload
Replies: 36
Views: 6618

Re: Giving back to the team and community: log file database upload

hMailServerLogImporter1004.7z Here is an almost complete re-write. What has changed: * The bug with sharing violation reported by gotspatel is fixed. + PostgreSQL implemented + Now users can create their own reports. 3x sample JSON definitions can be found under .\Reports\ Any JSON file placed ther...
by gotspatel
2021-01-09 06:43
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Thank you Palinka and Soren for pointers. Here is what I found. For Uploading to NAS by NOT USING ROBOCOPY https://github.com/marcosfreccia/Powershell-Scripts/blob/master/SyncFileSystem.ps1 $SourceFolder = "D:\Source" $TargetFolder = "D:\Target\" $SourceFolderItems = Get-ChildItem -Recurse -Path D:\...
by gotspatel
2021-01-08 14:26
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Please ignore my Ignorance but I am no programmer but learning from the forum. :D That was me not long ago. :D Sorry, but you caught me at a bad time. I have to go away for the weekend with no computer, so I won't be able to get to much until Monday, but I have a couple of minutes now, so... :D For...
by gotspatel
2021-01-08 12:27
Forum: Scripting
Topic: hMailServer Offsite Backup
Replies: 72
Views: 17278

Re: hMailServer Offsite Backup

Trying to implement NAS Backup in your Backup Script, need help if it is correct location I am putting the code or Shall I Put it somewhere else. I am trying to copy the Backup zips from ||$BackupLocation = "C:\HMS-BACKUP" || to my NAS, I am putting the code in "HMailserverBackup.ps1" right after th...
by gotspatel
2021-01-06 11:13
Forum: Scripting
Topic: Firewall Ban
Replies: 165
Views: 76990

Re: Firewall Ban

Hello. Newbie here just moved to HMS from Mdaemon, anyway I got your scripts all setup from https://github.com/palinkas-jo-reggelt/hMailServer-Firewall-Ban and been running for 12+ hours now, mysql db seems to fill with IPs, FW rules gets created aso. However when using the webgui I get: Spammers a...
by gotspatel
2021-01-01 11:50
Forum: User-submitted tutorials
Topic: Giving back to the team and community: log file database upload
Replies: 36
Views: 6618

Re: Giving back to the team and community: log file database upload

DrmCa wrote:
2020-12-30 16:21
Great, thanks for testing! It was a bug in MySQL. Here is a fix.
I scrapped my old logs, but tested and here are the results.

Error in open file log processing, Any solution.
error in direct.png

It works fine if dates specified.
Perfect Logging.png
by gotspatel
2020-12-31 07:13
Forum: Scripting
Topic: Parsing Public Suffix List in VBS
Replies: 11
Views: 4691

Re: Parsing Public Suffix List in VBS

palinka wrote:
2020-12-30 22:10
Here's what I have in my eventhandlers.vbs.

Function here:



"GetMainDomain" is just a means of obtaining the highest level FQDN (without subdomains)
Many Thanks and Happy new year there
by gotspatel
2020-12-30 17:19
Forum: Scripting
Topic: Parsing Public Suffix List in VBS
Replies: 11
Views: 4691

Re: Parsing Public Suffix List in VBS

SorenR wrote:
2020-12-30 17:10

You can't do that... EventHandlers.vbs is run in an embedded CScript interpreter. You can only use VBScript commands that do not require a command shell.
Thank you for the pointer. I learnt it now.
by gotspatel
2020-12-30 17:18
Forum: Scripting
Topic: Parsing Public Suffix List in VBS
Replies: 11
Views: 4691

Re: Parsing Public Suffix List in VBS

palinka wrote:
2020-12-30 16:14
How are you running it? Are you running it from cscript?
Yes I tried running it with Eventhandlers.vbs
by gotspatel
2020-12-30 09:07
Forum: Scripting
Topic: Parsing Public Suffix List in VBS
Replies: 11
Views: 4691

Re: Parsing Public Suffix List in VBS

Playing around with this tonight. I changed the vbs to a recursive function so it a) cuts down on the number of lines and b) can test any length of domain. Option Explicit Function Include(sInstFile) Dim f, s, oFSO Set oFSO = CreateObject("Scripting.FileSystemObject") On Error Resume Next If oFSO.F...
by gotspatel
2020-12-29 11:42
Forum: User-submitted tutorials
Topic: Giving back to the team and community: log file database upload
Replies: 36
Views: 6618

Re: Giving back to the team and community: log file database upload

I am not really sure what is happening here. Without seeing those errors I am blind and cannot troubleshoot. This program does not create a database. The database has to exist. It only creates 2x tables in the current version and 1x table in the old version. In MS SQL the old version used Tempdb, b...
by gotspatel
2020-12-27 06:12
Forum: User-submitted tutorials
Topic: Giving back to the team and community: log file database upload
Replies: 36
Views: 6618

Re: Giving back to the team and community: log file database upload

hMailServerLogImporter1002.7z Here is the new version that implements PostgreSQL. It is refactored properly from the quick and dirty prototype, to allow it to be truly extendable for any DB back end. Hi I downloaded it, Deleted the old Database and tried running this version but something is broken...
by gotspatel
2020-12-25 12:19
Forum: General discussions
Topic: Looking for a new Email client.
Replies: 4
Views: 1996

Re: Looking for a new Email client.

Hi,

Welcome and Merry Christmas.

Hmail is an Email Server (Eg: Microsoft Exchange, PostMaster) and NOT an Email Client. (Eg: thunderbird, Outlook, bat, mailbird, Mail etc.)

And surely it is Free and Lovely with very nice people to support you to install and configure it.

HTH
by gotspatel
2020-12-25 06:52
Forum: User-submitted tutorials
Topic: Giving back to the team and community: log file database upload
Replies: 36
Views: 6618

Re: Giving back to the team and community: log file database upload

Here is a portion if you need full i can upload and share link for you to research. I only need to see one line that says "Client connection from X.X.X.X was not accepted. Blocked either by IP range or by connection limit." It was not included in your portion. There is no Line for blocked connectio...
by gotspatel
2020-12-24 10:57
Forum: Development & alpha discussions
Topic: Sub OnHELO(oClient) progress?
Replies: 244
Views: 229090

Re: Sub OnHELO(oClient) progress?

RvdH wrote:
2020-12-24 10:55
For debugging, you do not need that
Thanks for Clarifying.