Search found 2563 matches

by palinka
2021-04-19 14:07
Forum: General discussions
Topic: Relay all outbound email at domain level
Replies: 20
Views: 183

Re: Relay all outbound email at domain level

SorenR wrote:
2021-04-19 13:05

When you look at it, you need a 3-4 mm needle to implant the chip and there is no chance in hell you will NOT notice that
That's truly confidence inspiring. :lol: :lol: :lol:
by palinka
2021-04-19 12:38
Forum: General discussions
Topic: Mass Deleting 45,000 emails but keeping the mailbox!
Replies: 3
Views: 25

Re: Mass Deleting 45,000 emails but keeping the mailbox!

Hi, I can easily identify the emails by subject and my scripting is ok! :-) https://hmailserver.com/forum/viewtopic.php?f=9&t=35463 If you change a couple of -lt to -gt so it looks for internaldate NEWER than N days instead of older and -notmatch to -match so it looks for matching accounts instead ...
by palinka
2021-04-19 12:33
Forum: General discussions
Topic: Relay all outbound email at domain level
Replies: 20
Views: 183

Re: Relay all outbound email at domain level

Our solutions are safe, banks have anti-fraud procedures that some people feel are too invasive. If your actions deviate from your normal pattern you will be asked to verify transaction. That's because banks have something to lose. Gubbemints are unaccountable. Who went to jail over the housing cra...
by palinka
2021-04-19 12:25
Forum: General discussions
Topic: Relay all outbound email at domain level
Replies: 20
Views: 183

Re: Relay all outbound email at domain level

SorenR wrote:
2021-04-19 06:40
World is going digital ... No way to stop it. I have read about people having chips implanted in their hand to make access security simpler - doing away with access cards. :roll:
And you actually beat me to it!! :lol: :lol: :lol: :lol: :lol:
by palinka
2021-04-19 12:24
Forum: General discussions
Topic: Relay all outbound email at domain level
Replies: 20
Views: 183

Re: Relay all outbound email at domain level

SorenR wrote:
2021-04-19 06:18
@mattg
NemID will be replaced with an upgraded solution this summer.
Yeah... Luciferin infused microchips under your skin. :lol: :lol:
by palinka
2021-04-18 13:30
Forum: General discussions
Topic: Cannot resolve MX
Replies: 76
Views: 1717

Re: Cannot resolve MX

Correct, bohemia-znak.cz is not my domain. I care about my costumers and I have everything fully funcional. As mentioned before, is it possible to downgrade? I can tedit table with hmailserver version ny mssql, but I dont know if it will work. anyway I will do snapshot before any operation :-) Guys...
by palinka
2021-04-18 13:27
Forum: General discussions
Topic: Cannot resolve MX
Replies: 76
Views: 1717

Re: Cannot resolve MX

Can you help me to downgrade to 5.6.8-B2494 because If I just re-install it I got error about DB version which is on my SQL Standard server. My DB version is 5700 but version of 5.6.8 uses 5601. This question came up recently. I can't find the post. Anyway, the solution was to "manually downgrade" ...
by palinka
2021-04-18 13:17
Forum: General discussions
Topic: Relay all outbound email at domain level
Replies: 20
Views: 183

Re: Relay all outbound email at domain level

What percentage of your customers pay by cheque? All but one or 2. But we don't have many clients, and we don't bill frequently (its basically consulting). I keep saying the USA is backward. Especially NY. Corruption retards innovation. One byproduct of that is the use of checks. However, the hoax ...
by palinka
2021-04-17 23:52
Forum: General discussions
Topic: Relay all outbound email at domain level
Replies: 20
Views: 183

Re: Relay all outbound email at domain level

Actually hMailServer allow SMTP to be configured to ONLY send mail to Santa via IP over Avian Carriers as defined by Bergen Linux user group using their gateway. https://en.wikipedia.org/wiki/IP_over_Avian_Carriers Actually, I believe Aivan Carriers are more reliable than our USPS Mail Carrier. USP...
by palinka
2021-04-17 00:52
Forum: General discussions
Topic: How to configure hMailServer to delete a message after it is retrived?
Replies: 8
Views: 185

Re: How to configure hMailServer to delete a message after it is retrived?

What Jimi means is that there is no bug where hmailserver/the documentation shows there is a limit of 1.5gb. Or 15gb or whatever it says. You must have an older version. To get around that limitation, upgrade hmailserver -or- use a backup script. My backup script (based on Jimi's): https://hmailserv...
by palinka
2021-04-16 15:03
Forum: General discussions
Topic: Connectivity with Outlook
Replies: 1
Views: 47

Re: Connectivity with Outlook

Employees in our company are asking for shared contacts solution. Obvious solution is exchange online or exchange server. My question is if hMail server can do that too. By that I mean if it can share contacts via Outlook interface like exchange does. No. hmailerserver is email only. You will need ...
by palinka
2021-04-15 22:24
Forum: General discussions
Topic: HMail and roundcube
Replies: 2
Views: 47

Re: HMail and roundcube

That has to be a roundcube configuration error on your end. hMS/RC are lightning fast for me.

Your best bet is to ask in the roundcube forum.

However, if you post your config file (*** out any passwords), maybe someone will spot what's wrong.
by palinka
2021-04-15 19:30
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

I have great faith in Darvinism. Eventually all the anti-vaxxers and anti-covid cults will go quiet :mrgreen: The world will go quiet for plenty that took the DNA altering "vaccine" with no manufacturer legal liability developed in conjunction with people that are vocal about human overpopulation. ...
by palinka
2021-04-15 19:23
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Yea, it sucks to be one of the 0.0002% of the population under age 75 that caught the wu flu and didn't stock up on HCQ or ivermectin, zinc and vitamins C&D. The chance of dying by lightning strike is approximately the same. So almost 3 million dead world wide from not eating their vitamins and min...
by palinka
2021-04-15 15:34
Forum: SpamAssassin implementation discussions
Topic: Avoid Backscatter and Improve Spam Defense
Replies: 11
Views: 166

Re: Avoid Backscatter and Improve Spam Defense

Would have loved if hMailServer would have supported that out of the box and send an immediate "554 Reject because of policy". What is "out of the box"? Running a well functioning email server of any flavor is never "out of the box". "Because of policy" - what policy? Whatever policy needs to be cr...
by palinka
2021-04-15 15:01
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

mattg wrote:
2021-04-15 13:54
I'm only 6'3", both of my sons are better than 6'6". I look tiny beside them.
Damn. They play sports?
by palinka
2021-04-15 14:57
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Well, that sucks .. https://www.standard.co.uk/news/uk/covid-denier-gary-matthews-dies-b908310.html Yea, it sucks to be one of the 0.0002% of the population under age 75 that caught the wu flu and didn't stock up on HCQ or ivermectin, zinc and vitamins C&D. The chance of dying by lightning strike i...
by palinka
2021-04-15 13:14
Forum: General discussions
Topic: Computer not Able to send Mails
Replies: 6
Views: 87

Re: Computer not Able to send Mails

The vpn clients are certainly capable of auth.

Looks like there's one device that possibly doesn't auth - 192.168.57.22. Could be a scanner or something.

Enable auth on everything possible or you will be sending spam (if you're not already) and will be blacklisted within a day or 2.
by palinka
2021-04-15 13:06
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

I am old fashioned and still call some people, because you know voice is easier and much more personal than a SMS or other message. When you need to get something done, the best way to motivate people is through a call. Even better is a personal visit, although that became difficult after 9/11 and ...
by palinka
2021-04-14 16:53
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Its 'was' ubitquitous... i really can't say SMS nowadays plays a significant role...i even can't remember when i received my last SMS (except the one send earlier using telerivet gateway app), all my 2fa methods (where is used SMS mostly for) are replaced with authenticators My 2FA uses SMS because...
by palinka
2021-04-14 16:17
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Its ubitquitous. Even more so than email. Its 'was' ubitquitous... i really can't say SMS nowadays plays a significant role...i even can't remember when i received my last SMS (except the one send earlier using telerivet gateway app), all my 2fa methods (where is used SMS mostly for) are replaced w...
by palinka
2021-04-14 16:05
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Don't think i have an actual use for this...SMS ancient technology :mrgreen: Its ubitquitous. Even more so than email. I use it mainly for the same purpose as the OP - to deliver small, important, disposable notifications. I installed the Gateway app on my phone. I have free SMS with my plan 8) Why...
by palinka
2021-04-14 15:20
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Don't think i have an actual use for this...SMS ancient technology :mrgreen: Its ubitquitous. Even more so than email. I use it mainly for the same purpose as the OP - to deliver small, important, disposable notifications. I installed the Gateway app on my phone. I have free SMS with my plan 8) Why...
by palinka
2021-04-14 12:59
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

What happens when you put this into a browser? https://api.telerivet.com/v1/projects/PROJECT_ID/messages?api_key=APIKEY&to_number=1234567890&content=Your message, but its better to urlencode this before placing it in the url Same but url encoded message: https://api.telerivet.com/v1/projects/PROJECT...
by palinka
2021-04-14 02:28
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

mickymac wrote:
2021-04-14 02:22
That could be the answer, any ideas on how to achieve it? I know in postman if I turn off the content then it just errors out stating missing content, so it's possible I guess.
https://duckduckgo.com/?q=vbs+urlencode

Several functions here. I haven't tried any of them.
by palinka
2021-04-14 02:17
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Just a shot in the dark, but i recall from the api docs that the "content" must be url encoded (i think).
by palinka
2021-04-14 00:41
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

If you set up your server for single recipients and receive multiple recipients, that's your issue. If you want multiple recipients, create an array of FROM addresses and parse them individually. ¯\_(ツ)_/¯ Nem problema. hMailServer cannot force the sending server to act in a certain way. Some serve...
by palinka
2021-04-14 00:24
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

If you set up your server for single recipients and receive multiple recipients, that's your issue.

If you want multiple recipients, create an array of FROM addresses and parse them individually.

¯\_(ツ)_/¯ Nem problema.
by palinka
2021-04-13 18:10
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

RvdH wrote:
2021-04-13 17:40
SorenR wrote:
2021-04-13 16:59
RvdH wrote:
2021-04-13 15:46


lol :lol:
Perhaps move the functionality of the while loop of RecipientParser::AddRecipient_() to the end of SMTPDeliverer::PreprocessMessage_() somehow ... :?:
Knock yourself out (if you think it is worth it) :mrgreen:
The pursuit of perfection is always a worthy goal.
by palinka
2021-04-13 15:43
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

You would only be able to address the first recipient Is that a bug or a feature? :lol: In any case, that's the intended behavior. The OP didn't ask for multiple recipients. I don't use it that way either. There's more than one way to skin a cat. If he wants these server messages to go out to multi...
by palinka
2021-04-13 15:19
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

You would only be able to address the first recipient Is that a bug or a feature? :lol: In any case, that's the intended behavior. The OP didn't ask for multiple recipients. I don't use it that way either. There's more than one way to skin a cat. If he wants these server messages to go out to multi...
by palinka
2021-04-13 14:54
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Unfortunately there is a logic problem, some may call it a BUG, in hMailServer (hms) as hms tries to consolidate recipients to avoid sending too many emails. I always ran it (still do with different function) with oMessage.Recipients(0).OriginalAddress under the assumption that an sms recipient is ...
by palinka
2021-04-13 12:43
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

I didn't notice Mike's example came from the api documentation. Mine didn't since it was based on a different project. Mixing the 2 (Mike's correct implemetation) with my other methods to call and clean up the message yields this: Function oLookup(strRegEx, strMatch, bGlobal) If strRegEx = "" Then s...
by palinka
2021-04-13 03:26
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Here's the one Soren helped me with. It does a couple of things. It massages the message so its more appropriately formatted for sms. It removes linebreaks, removes double/multiple spaces and removes html. It also takes the sms recipient number from the email recipient address like I showed above. I...
by palinka
2021-04-13 03:12
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Hi palinka, It's mainly for server room notifications etc (i.e. temperature is too high, etc) so these are just fairly generic type plain text emails. Assuming that we can't add the mobile number to each individual message we just modify the API destination for each recipient currently. SorenR on t...
by palinka
2021-04-13 02:53
Forum: Scripting
Topic: Email to HTTP
Replies: 98
Views: 498

Re: Email to HTTP

Hi, I'm hoping someone can help, we have an API for our SMS platform which can accept SMS messages at a URL here: https://api.telerivet.com/v1/projects/projectname/messages/send, however all our notifications/messages arrive via email. I'm just wondering whether can hmailserver accept an email from...
by palinka
2021-04-12 04:26
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

Re: MaxMinds GeoIP for local MySQL

I just tried the city data for the first time and ran it on my IP. The supposed accuracy_radius is 1 meter for my IP but the latitude/longitude coordinates were off by several blocks. Still the same town, though. Most online geoip locators put me in the next town over. I tried searching by latitude/...
by palinka
2021-04-08 04:12
Forum: Development & alpha discussions
Topic: IMAP changes in 5.7?
Replies: 3
Views: 129

Re: IMAP changes in 5.7?

I don't think there have been any changes to IMAP at all in 5.7. Also, I'd suggest that its your client that's misbehaving. I use emclient too and once in a blue moon get a situation where an apparently "corrupted" email causes emclient to stop downloading mail, while 9folders mail client on my pho...
by palinka
2021-04-08 04:07
Forum: General discussions
Topic: How to configure hMailServer to delete a message after it is retrived?
Replies: 8
Views: 185

Re: How to configure hMailServer to delete a message after it is retrived?

I would like to force hMailServer to automatically delete a message right after it is downloaded by the receiver. I think running a handler script that looks at flags could do what you want. However, right after would mean as soon as the script runs looking for seen messages, run from task scheduler.
by palinka
2021-04-08 03:30
Forum: Development & alpha discussions
Topic: IMAP changes in 5.7?
Replies: 3
Views: 129

Re: IMAP changes in 5.7?

I don't think there have been any changes to IMAP at all in 5.7. Also, I'd suggest that its your client that's misbehaving. I use emclient too and once in a blue moon get a situation where an apparently "corrupted" email causes emclient to stop downloading mail, while 9folders mail client on my phon...
by palinka
2021-04-07 13:19
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

There are a lot of restrictions to what a .tk domain can be used for and the tld do not have the best reputation on the 'net. SECTION IV 13.A.ii The powering of such transmitting equipment (including but not limited to switches, routers, telephones, 2 cans with a string, smoke signal fires, war dru...
by palinka
2021-04-07 13:09
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

seems up and running now.. 61.2.140.123 Port Number State Service Name Service Product 25 open smtp 110 open pop3 hMailServer pop3d 143 open imap hMailServer imapd 465 open smtp 587 open smtp 993 open pop3 hMailServer pop3d are you using any other vpn or IP tunneling software that "moves" your comp...
by palinka
2021-04-07 02:51
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

Re: MaxMinds GeoIP for local MySQL

Here's my fixed up powershell version.

* Added the lightning speed import
* Deleted create scheduled task
* Added colorful email notifications

https://github.com/palinkas-jo-reggelt/GeoLite2SQL
by palinka
2021-04-06 19:34
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

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 palinka
2021-04-06 19:15
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

Re: MaxMinds GeoIP for local MySQL

Everywyere I have searched on the Interweb I find DBA's preferring JOIN over complicated queries... Comparing 0.004 seconds to 0.009 seconds will only matter if do millions of queries per minute. Notice how I defined the primary keys. It needs to be this way if you want to import and "replace" and ...
by palinka
2021-04-06 18:24
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

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 palinka
2021-04-06 18:17
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

Re: MaxMinds GeoIP for local MySQL

Untested on your tables: SELECT * FROM ( SELECT * FROM geocountry WHERE INET_ATON('1.2.3.4') <= network_last_integer LIMIT 1 ) INNER JOIN geolocation ON geocountry.geoname_id = geolocation.geoname_id WHERE geocountry.network_start_integer <= INET_ATON('1.2.3.4'); Also, I forgot. Making column netwo...
by palinka
2021-04-06 14:12
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

PugzPOE wrote:
2021-04-06 11:32
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.
by palinka
2021-04-05 21:06
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

PugzPOE wrote:
2021-04-05 17:22
palinka wrote:
2021-04-05 13:18
Screenshot_20210405-071646_Opera.jpg

Maybe you should check your router for port forwarding.
Internet outage
Still?

Screenshot 2021-04-05 150601.png

Screenshot 2021-04-05 152217.png

Screenshot 2021-04-05 152353.png
Screenshot 2021-04-05 152353.png (13.86 KiB) Viewed 936 times
by palinka
2021-04-05 13:18
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

Screenshot_20210405-071646_Opera.jpg
Maybe you should check your router for port forwarding.
by palinka
2021-04-04 02:07
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

SorenR wrote:
2021-04-04 01:25
Guys... Easy now... IPv5 is difficult to work with.
:lol:

Maybe but its nothing compared to IPv7. You need a doctorate for that. I only have a masters degree!
by palinka
2021-04-03 23:43
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

Hmailserver service is not running. He said it was running and posted a screen grab from windows services. 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 spellin...
by palinka
2021-04-03 23:31
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

Hmailserver service is not running. He said it was running and posted a screen grab from windows services. I think its a different machine altogether. How? I have no idea. is all i got https://cdn.discordapp.com/attachments/822328745250652221/827964972083838996/unknown.png You have to run the scrip...
by palinka
2021-04-03 18:30
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

PugzPOE wrote:
2021-04-03 17:11
Well i had to modify the ipoe and pppoe interfaces
Run this and post the results.

https://hmailserver.com/forum/viewtopic ... 20&t=30914

If hmailserver is running, but no ports are listening, then those ports must have been removed from settings > advanced > tcpip ports
by palinka
2021-04-03 14:47
Forum: General discussions
Topic: Can I use the same certificate for HTTPS and TLS?
Replies: 2
Views: 149

Re: Can I use the same certificate for HTTPS and TLS?

I planning to set up a web interface to my hMailServer at mail.mydomain.com, and access it trough HTTPS. I'll use win-acme to get the SSL certificate (through Let's Encrypt). My hMailServer is also setup for the same domain, mail.mydomain.com. Can I import the same certificate into hMailServer so i...
by palinka
2021-04-03 14:37
Forum: General discussions
Topic: Fix Local Connect Failed Issue
Replies: 56
Views: 1266

Re: Fix Local Connect Failed Issue

PugzPOE wrote:
2021-04-03 05:53
Ok running netstat -a -b -n shows nothing is listening on the ports
Looks like hmailserver is not running at all. Did you check windows services? If its not running, try to start it and look in the event log for errors.
by palinka
2021-03-29 12:14
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

Re: MaxMinds GeoIP for local MySQL

Untested on your tables: SELECT * FROM ( SELECT * FROM geocountry WHERE INET_ATON('1.2.3.4') <= network_last_integer LIMIT 1 ) INNER JOIN geolocation ON geocountry.geoname_id = geolocation.geoname_id WHERE geocountry.network_start_integer <= INET_ATON('1.2.3.4'); Also, I forgot. Making column netwo...
by palinka
2021-03-29 07:31
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

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 palinka
2021-03-29 02:43
Forum: Scripting
Topic: MaxMinds GeoIP for local MySQL
Replies: 66
Views: 16598

Re: MaxMinds GeoIP for local MySQL

SELECT * FROM geolocation INNER JOIN geocountry ON geocountry.geoname_id = geolocation.geoname_id WHERE network_start_integer <= INET_ATON('1.2.3.4') AND INET_ATON('1.2.3.4') <= network_last_integer; One thing I did find that could be useful to you was that dividing the query into a subquery with a...