Search found 1542 matches

by palinka
2020-02-16 15:46
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

eliassal wrote:
2020-02-16 15:42
Also can you please provide a link or info on learning google charts that you are using?
Just go to the Google charts pages. They have examples. That's how I worked it out.

Honestly, I think it would be a lot easier to just fix php/SQL.
by palinka
2020-02-16 15:43
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Oops. I accidentally copied .htaccess there. I just deleted it but give it a minute - I just restarted for windows update.
by palinka
2020-02-16 15:29
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

No a standalone server. Palinka, I am thinking of creating your phpbam in ASP.Net/C#. Can you provide me screenshots of the php ban pages, also if possible the rules to follow in the functions in a bullteted list I have a demo at http://hmsfirewallbandemo.ddns.net/ Everything works except for actua...
by palinka
2020-02-16 15:25
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Can't you just upgrade php?
by palinka
2020-02-16 03:33
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

I'm out of ideas. Are you using the built in sql that comes with hmailserver? Or a standalone sql server?

What happens when you do phpinfo()?
by palinka
2020-02-15 23:26
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

what version of PHP you use, in my environment I have 7.0.30 and 5.3.28 In IIS I can switchbetween anyone of them Apache/2.4.26 (Win32) PHP/5.6.31 I'm reasonably certain there are no non-backward-compatible PHP functions (everything *should* work with PHP 5.3). I'm almost certain there are no depre...
by palinka
2020-02-15 23:24
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

I thought it was because of include in iis, I checked with very simple include files it works except I use quout instead of double quote, I will change your index file to use include_once 'dddd' when I dispaly the source of The blank page, I have only this <!DOCTYPE html> <html> <head> <title>hMail...
by palinka
2020-02-15 21:04
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

eliassal wrote:
2020-02-15 20:41
my hMailsServer is 5.6.6-B2383
I meant what version of PHP?
by palinka
2020-02-15 20:24
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Also, exactly what version of PHP are you running? This definitely seems to be something in your environment.

I'm on 5.6 so I know it works. I haven't tested with PHP 7 yet. That potentially could be an issue, but I think its unlikely.
by palinka
2020-02-15 20:21
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

for the web sit even after setting the driver, I am still getting the same error, here is what i have in my php.config $Database = array ( 'dbtype' => 'mssql', 'host' => 'SQL\SC2K12', 'username' => 'myuserrun', 'password' => 'myuserrun', 'dbname' => 'hmailserver', 'driver' => 'mssql', 'port' => '49...
by palinka
2020-02-14 19:10
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

eliassal wrote:
2020-02-14 18:45
OK I will run then in a powershell terminal the hmsFirewallBan.ps1 script
Run from task scheduler every 5 minutes.

Or any interval you want, but make sure the $Interval user variable matches whatever you put in the task scheduler.
by palinka
2020-02-14 19:09
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

shouldnt I run hmsFirewallBanDBSetup.ps1 before schedueling hmsFirewallBan.ps1? Yes. Otherwise you will have no database into which you place your data. That could also be the root of your vbs error: Error: 800403E9 - Description: You do not have access to this property / method. I was thinking it ...
by palinka
2020-02-14 18:43
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

As I copied all code in EventHandlers.vbs to my one on the server for the time being only to my hmailserver, I started to see the following error in the log "ERROR" 5928 "2020-02-14 16:26:54.558" "Script Error: Source: hMailServer COM library - Error: 800403E9 - Description: You do not have access ...
by palinka
2020-02-14 18:31
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Palinka, I downloaded the files (master), there is no sql creation tables. I sa that there are 2 other branches AddSQL support and FixSqlquery, which one I should use between those 3 branches? IN the setup instructions, you indicate in point 5 "Edit variables in hmsFirewallBan.ps1" There are no var...
by palinka
2020-02-13 21:46
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

fantastic. I went again through Instructions section , are those the most up to date to follow? A lot of things to setup wow :D Yes. That's the latest, except I haven't changed it for the new functions in eventhandlers.vbs (for choice of mysql or mssql queries). Give it a shot and let me know if yo...
by palinka
2020-02-13 20:38
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Screenshot_20200213-133411_Brave.jpg
Here you go. Today's hits. The "FB" column is firewall blocks, counted from the firewall log. None of those ever presented themselves to hmailserver since they were dropped at the firewall. :mrgreen:
by palinka
2020-02-13 13:08
Forum: Off-topic discussions
Topic: Need help optimizing database
Replies: 6
Views: 303

Re: Need help optimizing database

Dravion wrote:
2020-02-13 12:57

You also should avoid Table scan (full search of a table)
That is definitely what I'm doing now. :(

Thanks for the ideas. When I get to my computer I'm going to try a couple of things and report back.
by palinka
2020-02-13 04:09
Forum: Off-topic discussions
Topic: Need help optimizing database
Replies: 6
Views: 303

Re: Need help optimizing database

unique entries and a third column for count I'm trying to visualize this. Table 1: id AUTOINCREMENT PRIMARY UNIQUE ipaddress UNIQUE ipcount INT last-timestamp NOT NULL Trigger = insert into table 2 id, timestamp Table 2: id (matches table 1 id)(not unique or primary - duplicates allowed) timestamp ...
by palinka
2020-02-13 02:46
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Yes, I like to try but you did not answer my 2 questions :D - what is the latest version that I should download for SQL server and the latest instructions as well as the nice web site you created ? - 2nd, I did not figure out how hMailServer will ban email? Based on what info that it will add the i...
by palinka
2020-02-13 00:04
Forum: Off-topic discussions
Topic: Need help optimizing database
Replies: 6
Views: 303

Need help optimizing database

As part of my firewall ban project I have a table for information scraped from the firewall log. It has 2 columns: timestamp and IP. Each of those columns purposefully contain duplicate information. For example, an IP can attempt to connect multiple times and therefore be duplicated the same number ...
by palinka
2020-02-12 23:55
Forum: General discussions
Topic: unknown Spam in logging
Replies: 7
Views: 1658

Re: unknown Spam in logging

"SMTPD" 4004 112341 "2020-02-12 00:00:09.279" "192.168.0.163" "SENT: 220 smtpserver.domain.net ESMTP" "SMTPD" 1428 112341 "2020-02-12 00:00:09.279" "192.168.0.163" "RECEIVED: EHLO SERVERNAME" "SMTPD" 1428 112341 "2020-02-12 00:00:09.279" "192.168.0.163" "SENT: 250-smtpserver.domain.net[nl]250-SIZE ...
by palinka
2020-02-12 23:51
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Hello Palinka, sorry for my late come back I went through the http://hmailserver.com/forum/viewtopic.php?f=9&t=34082 (half-way) it is really what I am looking for, I was disappointed when I initially read that it was only compatible with mysql, then I understood that enhancements were done to be co...
by palinka
2020-02-05 22:24
Forum: Scripting
Topic: Problem with AutoBan
Replies: 18
Views: 724

Re: Problem with AutoBan

SorenR wrote:
2020-02-05 22:14
You are missing this...

Code: Select all

    Function Wait(sec)
        With CreateObject("WScript.Shell")
            .Run "powershell Start-Sleep -Milliseconds " & Int(sec * 1000), 0, True
        End With
    End Function
Eagle eye!
by palinka
2020-02-05 22:18
Forum: Scripting
Topic: Problem with AutoBan
Replies: 18
Views: 724

Re: Problem with AutoBan

Some more insight, there is a problem with Disconnect function. I disabled the disconnect function and the script went to AutoBan and added the ip to IpRanges. My Disconnect function is: ' Function Disconnect - http://hmailserver.com/forum/viewtopic.php?f=7&t=34058 ' Download disconnect.exe from: h...
by palinka
2020-02-03 00:08
Forum: Development & alpha discussions
Topic: RTL In the management software for administrators
Replies: 10
Views: 606

Re: RTL In the management software for administrators

mattg wrote:
2020-02-02 23:16
RTL (Right to Left)
:oops:

Thought it was only related to language choice.
by palinka
2020-02-02 22:38
Forum: Development & alpha discussions
Topic: RTL In the management software for administrators
Replies: 10
Views: 606

Re: RTL In the management software for administrators

From the link: How do I install a new translation? In the future this functionality is likely to be built-in into hMailServer Administrator, but at the moment it's a manual process. Go to the hMailServer Translation Status page and select the translation you want to use. When you see the list of all...
by palinka
2020-02-02 20:10
Forum: Development & alpha discussions
Topic: RTL In the management software for administrators
Replies: 10
Views: 606

Re: RTL In the management software for administrators

Have a look here: https://www.hmailserver.com/documentati ... t_language

Maybe you can finish off the few empty strings for Hebrew.
by palinka
2020-02-02 04:14
Forum: Scripting
Topic: Firewall Ban
Replies: 143
Views: 15300

Re: Firewall Ban

I updated GitHub today. Before, I had a method of manually adding or releasing IP ranges but it was "fake", meaning it only worked for /24 CIDR ranges and ignored any previously added or released IPs. Banned IP ranges were added as firewall rules using x.x.x.0/24 remote IP. That meant that they coul...
by palinka
2020-02-01 20:52
Forum: Off-topic discussions
Topic: best blacklist list
Replies: 26
Views: 24720

Re: best blacklist list

You made a list. You can find them on the list at valli.org which has links to the maintainers' sites. There you will find instructions / return codes.
by palinka
2020-02-01 19:01
Forum: Off-topic discussions
Topic: best blacklist list
Replies: 26
Views: 24720

Re: best blacklist list

Hi, can somebody share the return codes for the list mentioned above bl.spamcop.net psbl.surriel.com b.barracudacentral.org dnsbl.sorbs.net cbl.abuseat.org sbl-xbl.spamhaus.org dsbl.dnsbl.net.au relays.ordb.org blackholes.five-ten-sg.com Go to http://multirbl.valli.org/ and look at the listings. Li...
by palinka
2020-02-01 18:57
Forum: General discussions
Topic: Block IPs
Replies: 190
Views: 5625

Re: Block IPs

Firewall blacklist http://hmailserver.com/forum/viewtopic.php?f=9&t=34082 hMailServer Firewall Ban Ban IPs to windows firewall. Complete with PHP admin/management. If you care to try it out, wait a few hours before downloading it. I have an update in the works that I hope to upload within 3 hours f...
by palinka
2020-02-01 15:25
Forum: Scripting
Topic: Firewall Ban
Replies: 143
Views: 15300

Re: Firewall Ban

Funny helo by script kiddie trying to send spam or guess a password.
Screenshot_20200201-082308_Brave.jpg
And of course there is no PTR....
by palinka
2020-01-31 17:28
Forum: General discussions
Topic: mails going to spam (gmail)
Replies: 2
Views: 1903

Re: mails going to spam (gmail)

See here: https://www.hmailserver.com/forum/viewt ... 81#p185981

And here: https://www.hmailserver.com/forum/viewt ... 21&t=34663

You need to build up your reputation. It is not automatic and it will not happen in a single day.
by palinka
2020-01-31 13:22
Forum: General discussions
Topic: Add warning to emails
Replies: 35
Views: 7371

Re: Add warning to emails

oMessage.Body = ReplaceText(oMessage.Body, "(WARNING)[/s/S]*(EndOfWarning" & vbCrLf & ")","") [/quote] I could be wrong, but I don't think you can mix vb and regex like that. Try getting rid of the vb or changing it to regex. \t I think for tab? oMessage.Body = ReplaceText(oMessage.Body, "(WARNING)...
by palinka
2020-01-30 18:21
Forum: General discussions
Topic: URL send to SURBL
Replies: 23
Views: 3093

Re: URL send to SURBL

RvdH wrote:
2020-01-30 17:02
Can you pm the source to me so i could have a look?

I am a bit surprised to see 16 matches and lookups, especially because a hardcoded limit of 15 is defined in the code

Code: Select all

const int maxURLsToProcess = 15;
:o
0-15 = 16 iterations. :D
by palinka
2020-01-30 18:19
Forum: General discussions
Topic: ADO Cannot generate SSP1 context
Replies: 9
Views: 2212

Re: ADO Cannot generate SSP1 context

So please, can you tell me how can I switch to user authentication instead of windows nt? Thanks You want the opposite - you want a local system account with no password (according to what I searched) to have authority over the service. Win+R > services.msc > select your db server > right click > p...
by palinka
2020-01-30 16:33
Forum: Off-topic discussions
Topic: Gammu SMS frontend
Replies: 0
Views: 210

Gammu SMS frontend

If anyone is interested, I made a very simple PHP frontend for Gammu SMS. https://github.com/palinkas-jo-reggelt/PHP-Gammu-Viewer * Uses unaltered Gammu database (no new tables/columns/etc). * Send short/long messages immediately or at future time - long messages are properly sequenced to arrive as ...
by palinka
2020-01-30 16:10
Forum: General discussions
Topic: Need to get internal app to send via hMail and the gmail
Replies: 1
Views: 1864

Re: Need to get internal app to send via hMail and the gmail

I don't think hmailserver will help you. https://gsuiteupdates.googleblog.com/2019/07/limit-access-LSA.html It looks like your users will have to make the change directly. I've run into this issue myself, but only with myself as the user requiring "less secure apps" settings changes. They make it as...
by palinka
2020-01-30 15:56
Forum: General discussions
Topic: ADO Cannot generate SSP1 context
Replies: 9
Views: 2212

Re: ADO Cannot generate SSP1 context

Palinka, I can agree with you as it is a windows issue. Just to confirm to you that I disabled again IPv6 on the network card, rebooted and hmail admin worked fine again. My question is how to troubleshoot hMailserver what is going wrong/ Just use a MS-SQL-Server DB-User without Windows Authenticat...
by palinka
2020-01-30 13:34
Forum: General discussions
Topic: ADO Cannot generate SSP1 context
Replies: 9
Views: 2212

Re: ADO Cannot generate SSP1 context

https://duckduckgo.com/?q=ADO+%3A+Canno ... P1+context

This seems to be a windows issue. In fact one result in the search links back here and Martin said it is definitely not a hmailserver issue.
by palinka
2020-01-28 21:28
Forum: General discussions
Topic: URL send to SURBL
Replies: 23
Views: 3093

Re: URL send to SURBL

OK, as it seems BOOST needs some weird extra escaping But i would say, using a regex like: (?:https?:\\/\\/)([^\\?&><\\[\\(#\\\\ \\\"'\\/\\)\\]]*) would solve the issues, see example here: https://regexr.com/4t4ap Could the X-Spam-Report (bad) formatting also be caused by a malformed regex? It appe...
by palinka
2020-01-28 18:51
Forum: General discussions
Topic: Cleaning the Data folder and old messages
Replies: 2
Views: 1959

Re: Cleaning the Data folder and old messages

http://hmailserver.com/forum/viewtopic.php?f=21&t=28139

Look here for the Emailcleardown.vbs script. Run it daily or weekly from task scheduler.

I'm sure it could be greatly simplified since you probably don't care about keeping ANY message.
by palinka
2020-01-28 16:56
Forum: General discussions
Topic: WIn Server 2012 R2 Updates causing hMailServer to go 100% CPU
Replies: 99
Views: 9960

Re: WIn Server 2012 R2 Updates causing hMailServer to go 100% CPU

The sub was never intended to identify the criteria. The criteria is the IF statement in the rule, not the subject matter examined. So yes, the criteria was indeed identified by identifying the rule that was triggered. :mrgreen: cri·te·ri·on (krī-tîr′ē-ən) n. pl. cri·te·ri·a (-tîr′ē-ə) or cri·te·ri...
by palinka
2020-01-28 16:46
Forum: General discussions
Topic: WIn Server 2012 R2 Updates causing hMailServer to go 100% CPU
Replies: 99
Views: 9960

Re: WIn Server 2012 R2 Updates causing hMailServer to go 100% CPU

and as far as I know, X-hMailServer-Reason-x is not standard and would not identify the criteria either Of course it will: 20/01/26 10:56.52 173.214.188.35 25 OnAcceptMessage Accepted Spam-Reason United States Tagged as Spam by SpamAssassin - (Score: 24) 20/01/26 10:56.52 173.214.188.35 25 OnAccept...
by palinka
2020-01-28 16:37
Forum: General discussions
Topic: test onbound port
Replies: 36
Views: 3278

Re: test onbound port

but the worse thing is that my chief came and said that I am not allowed to use any relays, it needs to be working from Azure directly. I try to tell him that it's impossible with my type of subscription, he said: search how to open 25 port manually I am very confused right now, to be honest. I am ...
by palinka
2020-01-28 15:10
Forum: General discussions
Topic: test onbound port
Replies: 36
Views: 3278

Re: test onbound port

There are many to choose from. Pick one that works best for your anticipated traffic. well, mate, I have one more question: I created relay using sendgrid for test, all tests in Diagnostics section are fine. but when I check, for example, DNS lookup or smth else, it shows some errors like DNS Recor...
by palinka
2020-01-28 13:08
Forum: General discussions
Topic: Forward mails to a specific mail address to an external account
Replies: 4
Views: 2082

Re: Forward mails to a specific mail address to an external account

How is your hmailserver receiving mail from your ISP mailbox?
by palinka
2020-01-28 12:58
Forum: General discussions
Topic: test onbound port
Replies: 36
Views: 3278

Re: test onbound port

There are many to choose from. Pick one that works best for your anticipated traffic.
by palinka
2020-01-28 12:53
Forum: General discussions
Topic: test onbound port
Replies: 36
Views: 3278

Re: test onbound port

Okay, so the problem is I am not allowed to use this port because of my subscriptions (from university or just testing), I can't even create support request for this. the only thing I can do is to use smtp relay, right? Yes. Try smtp2go. They have a free account option that's pretty generous with t...
by palinka
2020-01-27 18:07
Forum: General discussions
Topic: test onbound port
Replies: 36
Views: 3278

Re: test onbound port

is it OK that I can't pass local connect test with gmail domain? Just use mail.hmailserver.com. The one and only function of this part of the diagnostic is to determine if port 25 outbound is open. If you use servers other than mail.hmailserver.com, you may run into rules implemented on those serve...
by palinka
2020-01-27 16:12
Forum: General discussions
Topic: test onbound port
Replies: 36
Views: 3278

Re: test onbound port

blackjack wrote:
2020-01-27 16:09
ISP - do you mean Azure in my case?
Yes.
by palinka
2020-01-27 16:00
Forum: General discussions
Topic: test onbound port
Replies: 36
Views: 3278

Re: test onbound port

hello, guys so is this test (in Diagnostics) really important? because it's only one (excluding backup test) that I can't pass. what is the problem and how to fix it if necessary? Test: Test outbound port SMTP relayer not in use. Attempting mail.hmailserver.com:25... Trying to connect to host mail....
by palinka
2020-01-27 13:38
Forum: General discussions
Topic: Problem with second server
Replies: 4
Views: 1684

Re: Problem with second server

This is a guess, but give it a try. Create catch-all@domain.com on server 1. Create route on server 1 that points to server 2 - route should have catch-all as the only address for delivery. If that doesn't work, then add a global rule IF to catch-all THEN use route. Obviously this won't work if serv...
by palinka
2020-01-27 13:19
Forum: General discussions
Topic: Is it possible to add a profile picture of a user by sending an email?
Replies: 1
Views: 1301

Re: Is it possible to add a profile picture of a user by sending an email?

No, but there are 3rd party services that can provide a person's image/avatar to some email clients based on email address, such as gravatar.

Some groupware applications will automatically share avatars, but only within the group. Gmail does that.

Hmailserver is not groupware.
by palinka
2020-01-27 00:28
Forum: General discussions
Topic: hmail cant send mails
Replies: 22
Views: 2490

Re: hmail cant send mails

Hi Guys, Please help me on how to whitelist my new server ip using a script because i cant access the 'advanced' tab under setting. What do you mean by "whitelist your new server IP"? Generally speaking, you can't whitelist yourself. Other admins can whitelist you if you've been a good boy just lik...
by palinka
2020-01-25 16:51
Forum: General discussions
Topic: SPAM Attack able conenct and no Spam score
Replies: 3
Views: 1106

Re: SPAM Attack able conenct and no Spam score

"TCPIP" 5340 "2020-01-25 13:24:12.417" "DNS lookup: 113.222.143.45.zen.spamhaus.org, 0 addresses found: (none), Match: False" Successful test. IP not listed on spamhaus zen. "DEBUG" 5340 "2020-01-25 13:24:12.855" "Spam test: SpamTestMXRecords, Score: 0" Successful test. Sending server has valid MX....
by palinka
2020-01-24 00:39
Forum: General discussions
Topic: hmail cant send mails
Replies: 22
Views: 2490

Re: hmail cant send mails

Try this for a full backup. Size doesn't matter.

https://www.hmailserver.com/forum/viewt ... 21&t=28139
by palinka
2020-01-23 18:01
Forum: General discussions
Topic: hmailserver on windows 10
Replies: 11
Views: 2257

Re: hmailserver on windows 10

blackjack wrote:
2020-01-23 16:28
palinka wrote:
2020-01-22 15:12
Relay: !! POINTS TO LOCAL DOMAIN !!

Delete the relay.
It needs to be like "Relay:-
(none entered) "
right?
Correct. Unless port 25 outgoing is blocked. Then you will need an outside relay service.
by palinka
2020-01-22 21:21
Forum: User-submitted tutorials
Topic: Step by step LetsEncrypt WinSimple
Replies: 55
Views: 29599

Re: Step by step LetsEncrypt WinSimple

Of cause, .NET and Java having some fancy new Stuff but it's just candy. You really don't need it to get things done. Ironically, I recently removed all references to NetFirewallRule and replaced them with Netsh in my firewall ban project due to a request from someone running win server 2008. Backw...