Search found 4350 matches

by SorenR
2021-04-10 20:48
Forum: Development & alpha discussions
Topic: OpenSSL Security Advisory [25 March 2021]
Replies: 24
Views: 499

Re: OpenSSL Security Advisory [25 March 2021]

after a few VM snapshots and returns... how to fall back from x64 build to 32 bit recent beta (with MySQL/MariaDB): run HMS backup in full (incl. messages) uninstall HMS copy 32 bit libmysql.dll to \bin install HMS recent beta run hMailserver Database Setup and create a new database restore HMS bac...
by SorenR
2021-04-09 12:10
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

Is we are in english class? this is characteristic of this forum. while offering excellent support, feeling free to start talking also about total irrelevant things. IMO an indication of fantasy i.e. intelligence. common people may confuse it with "thread hijacking" :lol: I need a "like" button on ...
by SorenR
2021-04-09 07:45
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

mustafaiqbal wrote:
2021-04-09 03:32
Please help about Error:unable to bind address
viewtopic.php?p=228391#p228391
by SorenR
2021-04-09 01:53
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

Usually my spelling in english is better than my (native) danish and I frequently mock journalists for not being able to pass 5.th grade tests. My issue really started a few years ago when my Dell Latitude CPi 650 died. I have been using Dell laptops since 1998 and grown accustomed to their keyboar...
by SorenR
2021-04-09 00:12
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

Why is dyslexia so difficult to spell? Ouch. [Entered by mobile. Excuse my spelling.] A police officer, notorious for bad spelling, is set to interrogate three theives, Tim, Bob, and Joe. When asked who he thinks will give up the location stolen goods, he replys “Only Time will tell” Grey/gray has ...
by SorenR
2021-04-09 00:08
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

I think someone was writing with dyslexia. Nah, all the letters are there only in the wrong order. It happens when I think faster than I type - and forget to proof read my text. 8) Exactly what I was referring to (jokingly of course). You transposed the the letters in Rogue so that it came out as R...
by SorenR
2021-04-08 22:50
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

It doesn't do too bad against yellow, green or blue ones too. :mrgreen: [Entered by mobile. Excuse my spelling.] You never heard of the rouge email clients before? Nasty little suckers them rouge clients ;-) I think someone was writing with dyslexia. Nah, all the letters are there only in the wrong...
by SorenR
2021-04-08 19:55
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

jimimaseye wrote:
2021-04-08 19:13
SorenR wrote:
2021-04-08 17:09
hMailServer doing its job protecting you from rouge email clients.
It doesn't do too bad against yellow, green or blue ones too. :mrgreen:

[Entered by mobile. Excuse my spelling.]
You never heard of the rouge email clients before? Nasty little suckers them rouge clients ;-)
by SorenR
2021-04-08 17:09
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

hMailServer doing its job protecting you from rouge email clients. If you did not create that email address then you probably don't want it in your system prying anyways. Welcome to the world of SPAM/Virus/BOT fighting. Get used to it, it's here to stay! http://multirbl.valli.org/lookup/45.148.10.19...
by SorenR
2021-04-08 15:00
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

Sorry I forgot to tell that IP and domain name was just dummy, IP: 72.255.9.65 domain is: parcelmovers.pk, port-scan... 72.255.9.65 Port Number State Service Name 22 filtered ssh 23 filtered telnet 53 filtered domain 80 filtered http 443 open https Apache httpd 587 filtered submission 646 filtered ...
by SorenR
2021-04-08 14:05
Forum: General discussions
Topic: ERROR: unable to bind to address using cloudflare
Replies: 30
Views: 244

Re: ERROR: unable to bind to address using cloudflare

Sorry I forgot to tell that IP and domain name was just dummy, IP: 72.255.9.65 domain is: parcelmovers.pk, Your "dummy IP addess" belongs to Comcel S.A. in Bogota ... Do you have more than 1 LAN card in your PC? YES: WHY are you using your public address that belongs OUTSIDE your NAT Router and not...
by SorenR
2021-04-07 14:46
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 54
Views: 875

Re: Fix Local Connect Failed Issue

So turns out my router is crap and decides to disable the portforward every now and then That does not have to be the case... TP-Link equipment is usually rock solid - and dirt cheap. I have several TP-Link devices and common to all of them are they are a pain to configure the first time. Nothing a...
by SorenR
2021-04-07 10:15
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 54
Views: 875

Re: Fix Local Connect Failed Issue

Aand it stops working again Try turning your router on. Is it morning where you are yet? Screenshot_20210406-081025_Opera.jpg Nope. Still night time. I guess I'll try again tomorrow. Maybe it will be morning there tomorrow. seems up and running now.. 61.2.140.123 Port Number State Service Name Serv...
by SorenR
2021-04-07 09:50
Forum: Development & alpha discussions
Topic: OpenSSL Security Advisory [25 March 2021]
Replies: 24
Views: 499

Re: OpenSSL Security Advisory [25 March 2021]

Yes, there is a new teamCity version for 5.7, build number #2556 But does it have this fix? I can't see this by just reading the "changes" there. @jimimaseye I really have no intend to run an older version then 5.7, but I did because I couldn't find the OpenSSL Fix for it. Anyhow, I backed up my co...
by SorenR
2021-04-06 22:58
Forum: Development & alpha discussions
Topic: OpenSSL Security Advisory [25 March 2021]
Replies: 24
Views: 499

Re: OpenSSL Security Advisory [25 March 2021]

so you could have stayed with the B2538 from the download page. I was at 5.7 all the time, but it looks like there is no OpenSSL Fix for that. Because of that I downgraded to B2538, which is 5.6.8, to later find out that it was not compatible with my export and so on. These are the (MySQL) database...
by SorenR
2021-04-06 22:17
Forum: Development & alpha discussions
Topic: OpenSSL Security Advisory [25 March 2021]
Replies: 24
Views: 499

Re: OpenSSL Security Advisory [25 March 2021]

Now I noticed that the old version was probably not running correctly with my export, although the built-in test had all green lights. So I installed the newest from "TeamCity", hoping it has the fix and imported my export again, loosing one day. The B2555 is no different from B2538 execpt some cha...
by SorenR
2021-04-06 19:41
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

Re: MaxMinds GeoIP for local MySQL

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...
by SorenR
2021-04-06 19:01
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

Re: MaxMinds GeoIP for local MySQL

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...
by SorenR
2021-04-06 17:51
Forum: Development & alpha discussions
Topic: OpenSSL Security Advisory [25 March 2021]
Replies: 24
Views: 499

Re: OpenSSL Security Advisory [25 March 2021]

So it is fixed for the "beta" but still not for 5.7 "development"? Because of this I downgraded to 5.6.8 but it is only 32 bits and stuff.. If you want a 5.6.8 release with the same features as 5.7 (only 32-bit) you need to use RvdH's version of 5.6.8-B2538. https://www.hmailserver.com/forum/viewto...
by SorenR
2021-04-06 17:42
Forum: General discussions
Topic: Confirm setup: Backup MX Server and Incoming Relay Settings
Replies: 7
Views: 209

Re: Confirm setup: Backup MX Server and Incoming Relay Settings

and select "A local email address" for both "When [sender/recipient] matches route" options. I have a hard time understanding this. I noticed by doing it, that for me: "When recipient matches route treat as local" would be enough. But still, if someone other then Soren :mrgreen: could clarify this ...
by SorenR
2021-04-06 12:56
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 922

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 SorenR
2021-04-05 13:16
Forum: Off-topic discussions
Topic: EventHandlers.vbs CurrentFolder
Replies: 12
Views: 321

Re: EventHandlers.vbs CurrentFolder

assuming service name is hMailServer (why not??) wmic service hmailserver get PathName should return full path to exe could be useful no? Can it really be that simple :mrgreen: Nice catch 8) Confirmed on Windows Server 2003 R2, Windows 10 Home 20H2 and Windows Server 2019 Essential 1809. wmic servi...
by SorenR
2021-04-05 13:11
Forum: Off-topic discussions
Topic: EventHandlers.vbs CurrentFolder
Replies: 12
Views: 321

Re: EventHandlers.vbs CurrentFolder

strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set colItems = objWMIService.ExecQuery("SELECT * FROM Win32_Service WHERE name LIKE '%hmailserver%'",,48) For Each objItem in colItems Wscript.Echo "Name: " & objItem.Name & vbNewLine & "Pathname: " & objIt...
by SorenR
2021-04-05 12:55
Forum: Off-topic discussions
Topic: EventHandlers.vbs CurrentFolder
Replies: 12
Views: 321

Re: EventHandlers.vbs CurrentFolder

Yes, question is how to locate ini file without using API... assuming service name is hMailServer (why not??) wmic service hmailserver get PathName should return full path to exe could be useful no? Can it really be that simple :mrgreen: Nice catch 8) Confirmed on Windows Server 2003 R2, Windows 10...
by SorenR
2021-04-05 08:13
Forum: Off-topic discussions
Topic: EventHandlers.vbs CurrentFolder
Replies: 12
Views: 321

Re: EventHandlers.vbs CurrentFolder

I was trying to make some path(s) in my script dynamic, eg: compatible between x86 and x64 version One of the first things i tried is to include some external files relative to EventHandlers.vbs Doesn't the .ini file [Directories] section do that already? [Directories] ProgramFolder=C:\hMailServer ...
by SorenR
2021-04-04 01:25
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 54
Views: 875

Re: Fix Local Connect Failed Issue

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 spelling.] That's what I said. :D I know you did. [Entered by mobile. Excuse my spelling.] Guys... Easy now... IPv...
by SorenR
2021-04-03 18:19
Forum: Off-topic discussions
Topic: EventHandlers.vbs CurrentFolder
Replies: 12
Views: 321

Re: EventHandlers.vbs CurrentFolder

I guess cscript.exe is installed in %SYSTEMROOT%\System32 :wink:

It's the same issue when using vbs as CGI.

https://support.microsoft.com/da-dk/top ... a5db3cb9ef
by SorenR
2021-04-03 17:18
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 54
Views: 875

Re: Fix Local Connect Failed Issue

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

I ask because IPoE is usually cable networks and PPPoE is usually DSL networks.
by SorenR
2021-04-03 17:10
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 54
Views: 875

Re: Fix Local Connect Failed Issue

Hmm... SIP (nobody is using h323 anymore) usually uses port 5060 for signalling and port 8000+ for voice - nowhere near the ports used for SMTP/POP/IMAP.
by SorenR
2021-04-03 17:04
Forum: Development & alpha discussions
Topic: Sub OnHELO(oClient) progress?
Replies: 244
Views: 229051

Re: Sub OnHELO(oClient) progress?

With CreateObject("DNSLibrary.DNSResolver") strLookup = .PTR(strIP) End With I thought i have seen a post you used the above to verify the HELO/EHLO domain....but i might be mistaken, i can't find it anymore Nope, I only verify that the HELO/EHLO follow the RFC. ' ' Validate HELO/EHLO greeting ' Co...
by SorenR
2021-04-03 14:12
Forum: Development & alpha discussions
Topic: Sub OnHELO(oClient) progress?
Replies: 244
Views: 229051

Re: Sub OnHELO(oClient) progress?

This works with the HELO/EHLO greeting BUT... It COULD be modified to work with the resolved IP Address thus it can be run on servers pre-OnHELO. https://www.hmailserver.com/forum/viewtopic.php?p=205049#p205049 With CreateObject("DNSLibrary.DNSResolver") strLookup = .PTR(strIP) End With
by SorenR
2021-04-01 22:18
Forum: General discussions
Topic: Installation error: "The set-up failed to set the service dependency"
Replies: 8
Views: 168

Re: Installation error: "The set-up failed to set the service dependency"

Did you install as Administrator?

I never installed the MSSQLE... I normally use MySQL or MariaDB. My last install of 5.6.8 on Windows Server 2019 Essential was MariaDB.
by SorenR
2021-04-01 20:56
Forum: General discussions
Topic: Installation error: "The set-up failed to set the service dependency"
Replies: 8
Views: 168

Re: Installation error: "The set-up failed to set the service dependency"

From the Start menu (Windows symbol) open the Control Panel. Select “Administrative Tools” and then “Services”. Alternatively, you can enter “Services” in the search bar. Find “DCOM Server Process Launcher” in the list and double-click to open it. You are now in the configuration menu for the RPC s...
by SorenR
2021-04-01 17:41
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 922

Re: Modifying the Body before Forwarding

Empty string ("") converted to a value will be Zero. Well... Actually... No! VBScript only have one data type: Variant Dim var1, var2 var1 = "1" var2 = 2 Wscript.Echo var1 + var2 When run it should say 3 If you replace "1" with "" you get a runtime error. It only becomes 0 if you CLng(var1) or CInt...
by SorenR
2021-04-01 17:24
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

Hi guys, I just want to tell you that pentaservis.cz fix their DNS and now everything works like a charm. Should I fix my hMailServer version? If you are using Dravions version then it is currently unsupported. You have the option to switch to the official (ALPHA) version of 5.7 currently in develo...
by SorenR
2021-04-01 12:45
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 922

Re: Modifying the Body before Forwarding

Nope.... X-hMailServer-LoopCount=0 is not a valid header, is it? So in that case you have to check if the X-hMailServer-LoopCount header exists at all EDIT....you might be right If it exists the test results will have a value of 1 or more depending on what the header value is. If the header doesn't...
by SorenR
2021-04-01 12:08
Forum: Scripting
Topic: Modifying the Body before Forwarding
Replies: 30
Views: 922

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 +1 Better to say: if oMessage.HeaderValue("X-hMailServer-LoopCount") < 1 then..... as that would trigger...
by SorenR
2021-03-31 21:21
Forum: SpamAssassin implementation discussions
Topic: Max. size to send to Spamassassin
Replies: 48
Views: 1621

Re: Max. size to send to Spamassassin

I'm just wondering why SPAMC is limited at 256 MB ... http://byteconvert.org/ 5MB has been sufficient in hmailserver for most of us (for so long)... with spamc 256 MB is huge, but most likely they have been thinking the same...if it's that big it simply can't be spam Maybe we should forget about th...
by SorenR
2021-03-31 20:58
Forum: SpamAssassin implementation discussions
Topic: Max. size to send to Spamassassin
Replies: 48
Views: 1621

Re: Max. size to send to Spamassassin

I'm just wondering why SPAMC is limited at 256 MB ...

http://byteconvert.org/
by SorenR
2021-03-31 20:02
Forum: SpamAssassin implementation discussions
Topic: Max. size to send to Spamassassin
Replies: 48
Views: 1621

Re: Max. size to send to Spamassassin

Hmm... It seems the maximum message size spamc can send is 256 MB

Check "--max-size="
https://spamassassin.apache.org/full/3. ... spamc.html

256 MB = 262144 KB ~ 13422 iterations ...

No ?
by SorenR
2021-03-31 19:04
Forum: SpamAssassin implementation discussions
Topic: Max. size to send to Spamassassin
Replies: 48
Views: 1621

Re: Max. size to send to Spamassassin

Hate quoting myself but I was editing and you responded before I finished.. // If the user has configured a maximum message size to scan, use that size. // If not, limit scanning to messages smaller than 5 MB. Messages larger than // this is very unlikely to be spam. // Maximum allowed size to scan ...
by SorenR
2021-03-31 18:46
Forum: SpamAssassin implementation discussions
Topic: Max. size to send to Spamassassin
Replies: 48
Views: 1621

Re: Max. size to send to Spamassassin

if (config.GetAntiSpamMaxSizeKB() > 0) defaultSizeToScanKB = config.GetAntiSpamMaxSizeKB(); This still doesn't take in account the 100000 (maxIterations) x 20000 (chunk) that potential causes an exception and can crash the server, better catch that here You missed this config.SetAntiSpamMaxSizeKB(m...
by SorenR
2021-03-31 13:48
Forum: SpamAssassin implementation discussions
Topic: Max. size to send to Spamassassin
Replies: 48
Views: 1621

Re: Max. size to send to Spamassassin

Hmm... 50 MB becomes 51200 KB in the GUI :roll:
by SorenR
2021-03-31 13:25
Forum: SpamAssassin implementation discussions
Topic: Max. size to send to Spamassassin
Replies: 48
Views: 1621

Re: Max. size to send to Spamassassin

Now i think of it, if specified max filesize is too big spamd is guaranteed to timeout anyway.... maybe not the best/useful change How about this? // If the user has configured a maximum message size to scan, use that size. // If not, limit scanning to messages smaller than 5 MB. Messages larger th...
by SorenR
2021-03-30 16:53
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

Not the first 'issue' with the changed DNS lookup routine in 5.7.x builds, eg: https://github.com/hmailserver/hmailserver/pull/319 Well guess that's exactly why it is still ALPHA...i assume he currently is using an dravion 64-bit build that he has been posting publicly on the forums, to bad we can ...
by SorenR
2021-03-30 16:38
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

MX records pointing to an IP address are illegal ... Sort of :wink: hmailserver-master (5.7 ??) DNSResolver.cpp line 216 to 221 ... { // Okay, this is an invalid MX record. The MX record should always contain // a host name but in this case it appears an IP address. We'll be kind to // the domain ow...
by SorenR
2021-03-30 16:07
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

FYI I identified 2 or 3 years ago that Mx records entered as CNAMEs were causing lookup problems in 5.7 (where they did not have a problem in 5.6 production). This was reported on Github that martin has acknowledged with view to fix on 5.7. It is acknowledged that mx records SHOULDNT be entered as ...
by SorenR
2021-03-30 09:30
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

That's what I get too... I was reading this https://exchangepedia.com/2006/12/should-mx-record-point-to-cname-records-aliases.html and that could be the problem... Domain -> MX (CNAME) -> A record. It should be Domain -> MX (A record). Since 5.6.8 is able to resolve pentaservis.cz (did you try it o...
by SorenR
2021-03-30 09:12
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

Could you make pentaservis.cz add a MX 20 pointing to locator.cpsnet.cz ???

DNS Resolver in 5.7 is totally rewritten compared to 5.6.8.
by SorenR
2021-03-30 09:01
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

That's what I get too... I was reading this https://exchangepedia.com/2006/12/should-mx-record-point-to-cname-records-aliases.html and that could be the problem... Domain -> MX (CNAME) -> A record. It should be Domain -> MX (A record). Since 5.6.8 is able to resolve pentaservis.cz (did you try it on...
by SorenR
2021-03-30 08:24
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

According to this https://docs.microsoft.com/en-us/windows-server/networking/dns/troubleshoot/troubleshoot-dns-client "NSLOOKUP doesn't use the client's DNS cache, name resolution will use the client's configured DNS server." And since NSLOOKUP is able to resolve the MX record, it tells me this most...
by SorenR
2021-03-30 00:05
Forum: General discussions
Topic: Cannot resolve MX
Replies: 58
Views: 1105

Re: Cannot resolve MX

Hmm ... mxtoolbox says MX for pentaservis.cz is 193.104.7.35 and it's preference 10. https://mxtoolbox.com/SuperTool.aspx?action=mx%3apentaservis.cz&run=toolpage Also... pentaservis.cz.jpg On your hmailserver press the windows button and type services.msc - see if you can stop the DNS Client (dnscac...
by SorenR
2021-03-29 16:03
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

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 SorenR
2021-03-29 14:57
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

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 where...
by SorenR
2021-03-29 10:02
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

Re: MaxMinds GeoIP for local MySQL

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.csv" <# Create folder for temporary script files if it doesn't exist #> If (-not(Test-Path "$PSScriptRoot\Script-...
by SorenR
2021-03-29 01:29
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

Re: MaxMinds GeoIP for local MySQL

Oh WOW... Altered table from int(11) to bigint(20) on the network_start and network_end columns...

Reduced warnings to 324153 ... I kid you not - there is NO WAY to list the warnings using mysqlimport :roll:

This time a bit longer

1:21:55,55 to 1:25:06,59
by SorenR
2021-03-29 00:59
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

Re: MaxMinds GeoIP for local MySQL

What is that old fashioned stuff anyway? :lol: But seriously, my script updates the database weekly - which is the frequency of maxmind updates. Instead of deleting and re-inserting 330k rows, which takes hours, my script does it in a few minutes because it looks only for changes between the db and...
by SorenR
2021-03-28 16:15
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 65
Views: 16109

Re: MaxMinds GeoIP for local MySQL

@Palinka ... How different is this from what your code does? I gave up on the PowerShell scripting... :wink: :oops: Needs the MaxMind converter: https://github.com/maxmind/geoip2-csv-converter/releases File: import.cmd echo %DATE% %TIME% >> import.log echo. >> import.log curl -G https://download.max...