hMailServer forum

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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:...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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 ---- ------------- --...

gotspatel

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: ...

gotspatel

<# 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...

gotspatel

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 ...

gotspatel

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...

gotspatel

Will check that out tomorrow.

Thanks

gotspatel

Thanks will check it out.

The error is random as I am already getting ONLOGIN entries in my database.

gotspatel

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...

gotspatel

One problem I found that even the finance@mydomain.com is getting the redacted mail

gotspatel

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 ...

gotspatel

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 ...

gotspatel

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"...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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:...

gotspatel

$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...

gotspatel

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-...

gotspatel

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...

gotspatel

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,...

gotspatel

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.

Thanks for the head start will check.

And thanks for the config details in previous post, will check and start config.

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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 ...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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:\...

gotspatel

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...

gotspatel

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...

gotspatel

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...

gotspatel

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.

It works fine if dates specified.

gotspatel

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

gotspatel

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.

gotspatel

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

gotspatel

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...

gotspatel

Try no 2 still no success.

gotspatel

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...

gotspatel

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...

gotspatel

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

gotspatel

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...

gotspatel

RvdH wrote: ↑
2020-12-24 10:55
For debugging, you do not need that

Thanks for Clarifying.

Search found 110 matches