Hey,
i integrated the script in EventHandler.vbs, but where do i have to put in my signatur text and so on?
Greetings
Search found 41 matches
- 2024-02-01 16:08
- Forum: User contributed hMailServer 5 scripts
- Topic: Email Signature Placement Script
- Replies: 14
- Views: 14565
- 2023-06-29 09:20
- Forum: General discussions
- Topic: Encrypt Passwords
- Replies: 6
- Views: 2022
Re: Encrypt Passwords
Why do you need to encrypt passwords that are already Encrypted? I am assuming you mean hMailServer Account Password. hMailSerer Encrypts all the Account Passwords. These already Encrypted Account Passwords are stored in the hMailServer Database. I've never used the VBS script myself but I would be...
- 2023-06-29 08:23
- Forum: General discussions
- Topic: Encrypt Passwords
- Replies: 6
- Views: 2022
Encrypt Passwords
Hey,
i need to encrypt one of my mailpasswords.
I tried to use the "EncryptAllPasswords.vbs" the result message is "15 password(s) encryptet".
But where can i see the passwords now?
Thanks in advance.
Greetings
i need to encrypt one of my mailpasswords.
I tried to use the "EncryptAllPasswords.vbs" the result message is "15 password(s) encryptet".
But where can i see the passwords now?
Thanks in advance.
Greetings
- 2022-12-06 17:07
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
It only logs failures as said before, if you like to log successful lookups change the function like: Function GeoLookup(strIP) : GeoLookup = "zz" Dim a, element, group, strLookup a = Split(strIP, ".") With CreateObject("DNSLibrary.DNSResolver") strLookup = .TXT(a(3) & "." & a(2) & "." & a(1) & "."...
- 2022-12-06 15:55
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
That sounds weird, did you reload scripts? Yeah, I reload Scripts and restart hmailserver, but still result "zz" :( Ah, i see... EventLog.Write is only called when none or multiple entries are returned.... not for successful lookups Not even sure if multiple is possible here, the lookup against ner...
- 2022-12-06 14:18
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
With CreateObject("DNSLibrary.DNSResolver") strLookup = .TXT(a(3) & "." & a(2) & "." & a(1) & "." & a(0) & ".country.junkemailfilter.com") End With OMG, now it works, i can connect to my hMailServer :idea: :idea: :!: :!: Thank you very very much for for help and your patience. In hmailserver_events...
- 2022-12-06 14:04
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
- 2022-12-06 13:44
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
it is "de" Thank you! I tried this EventHandlers.vbs Config, but the result is still "zz" :( Function GetDatabaseObject() Dim oApp : Set oApp = CreateObject("hMailServer.Application") Call oApp.Authenticate(ADMIN, PASSWORD) Set GetDatabaseObject = oApp.Database End Function Function GeoLookup(strIP...
- 2022-12-06 13:32
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
I think there is a slight difference between them for England, if i remember right is discovered by countries.nerd.dk as "uk" whereas country.junkemailfilter.com returns "gb" (might be more irregularities) Okay, but i would only allow connections from germany anyway, so i would only need the return...
- 2022-12-06 13:18
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Looks like countries.nerd.dk has some issue, might be temporary or maybe it is permanently gone (don't think it was maintained actively anyway) ; <<>> DiG 9.16.34 <<>> 100.232.204.81.zz.countries.nerd.dk TXT ;; global options: +cmd ;; Got answer: ;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL , id...
- 2022-12-06 13:00
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Hey, since two days i can't connect to my hMailServer via Outlook, Android Mail or so. I think one reason could be my geoblocking. I only allowed ip addresses from germany. But in my "hmailserver_events.log" i only get these results: 12260 "2022-12-06 11:14:24.036" "- GeoLookup(60.217.75.70) = zz...
- 2022-04-30 20:37
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
It goes in eventhandlers.vbs. YOU don't define anything. These are public RBLs doing the checking for you. They define their own whitelists. Okay, but i one IP i want to exclude from checking. And where can i define the whitelisted IPs, for example 94.105.266.80? Is this what i have to do? Sub OnCl...
- 2022-04-30 16:11
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Secondly, I made a whitelisting function to check IPs against WL-RBLs. This requires RvdH's DNS Resolver: https://d-fault.nl/files Function IsWhitelisted(strIP) : IsWhitelisted = False Dim a : a = Split(strIP, ".") Dim strLookup, strRegEx Dim IsWLMailSpike, IsWLHostKarma, IsWLNSZones, IsWLSPFBL, Is...
- 2022-04-29 17:32
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Hey palinka,
perhaps you can help me by another question.
Can i exclude IPs from beeing checked from the script? Like whitelisting or so?
If it's possible, how can i do this?
Thank you!
perhaps you can help me by another question.
Can i exclude IPs from beeing checked from the script? Like whitelisting or so?
If it's possible, how can i do this?
Thank you!
- 2022-04-21 22:28
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Okay palinka, thank you anyway
Please can someone tell me how I can do this with a MSSQL-Database-Server
I would be very grateful
Thanks in advance <3
Please can someone tell me how I can do this with a MSSQL-Database-Server
I would be very grateful
Thanks in advance <3
- 2022-04-21 10:15
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Hey, me again :mrgreen: i think the script runs good and many ip's got banned :mrgreen: Now for a second instance i used MSSQL for Database Server and MSSQL is running on another server as hmailserver, how do i to change the settings in Eventhandler.vbs and Handler.vbs from MySQL to MSSQL? And for O...
- 2022-04-13 07:57
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Hey hey, after a few days, my table hm_ids looks like this: https://i.ibb.co/Db6QLQP/Unbenannt.png In hMailServer it looks like this: https://i.ibb.co/Gnp6yd7/Unbenannt.png And the handler.log is looking like this: 347 "2022-04-12 20:50:28.734" "AutoBan(185.239.242.59, IDS, 7, d)" 351 "2022-04-12 21...
- 2022-04-09 13:47
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
- 2022-04-09 12:20
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
I think now we can go forward :mrgreen: I create the table manually: mysql> CREATE TABLE hm_ids (timestamp DATETIME, ipaddress VARCHAR (192) PRIMARY KEY, port INTEGER, hits INTEGER); Query OK, 0 rows affected (0.19 sec) And then i tried to run the Handler.vbs with this command ... C:\Users\Administr...
- 2022-04-08 22:03
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
It says 'port' is an unknown column, but I'll go out on a limb and guess that you haven't created a table structure yet. CREATE TABLE hm_ids ( timestamp DATETIME, ipaddress VARCHAR (192) PRIMARY KEY, port INTEGER, hits INTEGER ); No, i didn't create a table called hm_ids manually. Do i have to crea...
- 2022-04-08 21:38
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Lastly, you didn't bother to read the link I provided above. Sorry, i read it again. I type this, and got following Error: C:\Users\Administrator>C:\Windows\SysWOW64\cscript.exe "C:\Program Files (x86)\hMailServer\Events\Handler.vbs" Microsoft (R) Windows Script Host, Version 5.812 Copyright (C) Mi...
- 2022-04-08 16:26
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
palinka wrote: ↑2022-04-08 16:17Open cmd window. TypeCode: Select all
cscript "C:\path\to\script.vbs"
- 2022-04-08 16:04
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
How are you calling the script? https://stackoverflow.com/questions/20227569/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-drive I double-click the "Handler.vbs" to test it, then the Error will pop-u, i hope this is what you mean? :( I'm complete new in hMailServer-Scripts,...
- 2022-04-08 15:11
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
This is not the same driver as shown in your screenshot. They must be an exact match! DRIVER={MySQL ODBC 5.3 Unicode Driver};Server=localhost;Port=3306;Database=%idsdb%;Uid=%idsuid%;Pwd=%idspwd%;Option=3; Now i installed the same driver like SorenR, but still the sam Error :( https://i.ibb.co/dgR1g...
- 2022-04-08 13:27
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
I looked at your script above. move line 21 ("Dim idsDBDrv : idsDBDrv = ...") to line 175, meaning right before this line: "oConn.Open idsDBDrv". For what its worth, I prefer to do all this in event handlers, I don't even expire them. I just let them sit and reject connections after 3 tries. They s...
- 2022-04-06 23:35
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
- 2022-04-06 22:28
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
You need to set up the database. Under tab "System DSN" click add and follow the instructions to add hmailserver database. Also - I'm not sure about this - you may need 32 bit instead of 64 bit. It depends on the connector and I'm not an expert. I use the MariaDB and the odbc connector is 32/64 com...
- 2022-04-06 21:22
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Open ODBC in Windows and the driver tab. In that list you should have the name of the driver. ex "MySQL ODBC 8.0 Driver" That is what you use in the script Dim idsDBDrv : idsDBDrv = "DRIVER={MySQL ODBC 8.0 Driver};Database="&DBNAME&";Uid="&DBUID&";Pwd="&DBPW&";Option=3;" This is what my Driver Tab ...
- 2022-04-06 14:06
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Hey tunis,tunis wrote: ↑2022-04-05 09:55You can install mysqls odbc driver for free.
https://dev.mysql.com/downloads/connector/odbc/
i installed this, but i get the same Error from Windows Script Host.
Do i have to do some settings in the installed ODBC-Connector?
Greetings
- 2022-04-05 06:52
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
- 2022-04-04 23:54
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
I don't think so
Is this what I have to do?
https://blog.devart.com/installing-odbc ... ndows.html
Thanks!
- 2022-04-04 22:05
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Maybe If (InStr("de" etc. ??? Ok, i tried this :idea: Here is my Eventhandlers.vbs: Option Explicit '****************************************************************************************************************************** '********** Settings ********** '**************************************...
- 2022-04-04 14:48
- Forum: Scripting
- Topic: Firewall Ban
- Replies: 173
- Views: 394615
Re: Firewall Ban
Okay, thank you palinka, i will take a look at these rules and hope i understand and can use them
Greetings
- 2022-04-04 14:44
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
'****************************************************************************************************************************** '********** hMailServer Triggers ********** '******************************************************************************************************************************...
- 2022-04-04 08:46
- Forum: Scripting
- Topic: Firewall Ban
- Replies: 173
- Views: 394615
Re: Firewall Ban
Hey palinka, thanks for your fast reply :D Try changing the query to: CREATE TABLE IF NOT EXISTS hm_fwban_blocks_ip ( id INT(22) NOT NULL AUTO_INCREMENT, ipaddress varchar(15) NOT NULL, hits INT(8), lasttimestamp datetime NOT NULL, PRIMARY KEY (id) UNIQUE KEY ipaddress (ipaddress) ) ENGINE=InnoDB DE...
- 2022-04-03 17:57
- Forum: Scripting
- Topic: Firewall Ban
- Replies: 173
- Views: 394615
Re: Firewall Ban
Heyho, i want to use your Firewall Ban-Method, but it will always give out Errors when i want to run hmsFirewallBanDBSetup.ps1 to setup database tables: 22.04.03 17:46:33.85 : ERROR : Unable to run query : CREATE TABLE IF NOT EXISTS hm_fwban_blocks_ip ( id INT(22) NOT NULL AUTO_INCREMENT, ipaddress ...
- 2021-10-18 10:09
- Forum: General discussions
- Topic: No "Microsoft SQL"-Service in Database Setup
- Replies: 4
- Views: 1381
- 2021-10-18 04:31
- Forum: General discussions
- Topic: No "Microsoft SQL"-Service in Database Setup
- Replies: 4
- Views: 1381
No "Microsoft SQL"-Service in Database Setup
Hey, i have a Database on my Microsoft SQL-Express 2017 Server. Now I want to connect to this Database, but in the Database Setup, Step 5 of 7 I can't choose Microsoft SQL in the "Service"-Drop down-Field. Now I need to know, what I have to choose in Step 5 of 7? I hope someone can help me? :oops: T...
- 2021-04-07 13:23
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
- 2021-04-06 21:11
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Thanks for your reply! So if i want to implement this Script "#2 How to only allow client access from specific GEO locations." my "EventHandlers.vbs" should look like this? Option Explicit '**************************************************************************************************************...
- 2021-04-05 19:40
- Forum: User-submitted tutorials
- Topic: Hardening hMailServer - The ongoing saga!
- Replies: 158
- Views: 189776
Re: Hardening hMailServer - The ongoing saga!
Heyho, i'm running a hMailServer on a Window-Server and i want to use this scripts: #2 How to only allow client access from specific GEO locations. --> viewtopic.php?p=209543#p209543 #3 How to stop the annoying half-connections from BOT's and misconfigured spammers. --> viewtopic.php?p=209545#p20954...