Search found 1936 matches

by palinka
2020-05-18 18:05
Forum: General discussions
Topic: Ignoring server rules ?
Replies: 26
Views: 621

Re: Ignoring server rules ?

Double check the route (re-set it) and re-assign and save the rule. It seems your setup has confused itself. At the minute is does not see those routes and is erroring. I think this is a bug. I don't remember which action item it was (could have been a route - not sure), but I do remember having to...
by palinka
2020-05-18 17:22
Forum: User-submitted tutorials
Topic: Step by step LetsEncrypt WinSimple
Replies: 66
Views: 51788

Re: Step by step LetsEncrypt WinSimple

After upgrading to acme v2, I've noticed that when the certificate is renews, win-acme now generates a new filename for each site renewal and it's some random GUID. That is creating an issue with hmailserver since you can only configure a static filename. Does anyone know how to get around this pro...
by palinka
2020-05-18 17:06
Forum: General discussions
Topic: Ignoring server rules ?
Replies: 26
Views: 621

Re: Ignoring server rules ?

"TCPIP" 1376 "2020-05-18 13:08:47.779" "Connecting to 85.115.52.190:25..." "DEBUG" 2128 "2020-05-18 13:09:08.788" "SMTPDeliverer - Message 54639 - Connection failed: Host name: 85.115.52.190, message: A connection attempt failed because the connected party did not properly respond after a period of ...
by palinka
2020-05-18 16:49
Forum: General discussions
Topic: Transfer email from one hmailserver to another
Replies: 14
Views: 607

Re: Transfer email from one hmailserver to another

What's the purpose of the private server? Just a realtime backup?
by palinka
2020-05-18 14:44
Forum: General discussions
Topic: Is there a logfile for antispam results :?:
Replies: 46
Views: 1071

Re: Is there a logfile for antispam results :?:

There is something fundamentally wrong somewhere and I'm wondering if the problem is oMessage not being initialised by hMailServer +1 And if true it's likely that the testing of the headers (as initially required) will not be possible in this section. [Entered by mobile. Excuse my spelling.] What c...
by palinka
2020-05-18 11:28
Forum: General discussions
Topic: Is there a logfile for antispam results :?:
Replies: 46
Views: 1071

Re: Is there a logfile for antispam results :?:

When will this script be activated? The script is called "Sub OnAcceptMessage(oClient, oMessage)" In my opinion it is executed on every received email. Or not? Correct. Actually, all messages. Because I thought the same and added a line at the beginning of the sub, where hmailserver should write a ...
by palinka
2020-05-18 09:35
Forum: General discussions
Topic: Is there a logfile for antispam results :?:
Replies: 46
Views: 1071

Re: Is there a logfile for antispam results :?:

Reload is enough. Hmailserver won't create the log until it has a need to. If hmailserver_events.log doesn't exist yet, that means you haven't received any spam since you enabled the script. Or, more precisely, hmailserver has not scored any messages as spam yet. :D No spam. That's a nice lifestyle....
by palinka
2020-05-18 00:30
Forum: General discussions
Topic: Stop intruder
Replies: 70
Views: 36290

Re: Stop intruder

mattg wrote: ↑
2019-10-10 16:06
I've been running that a while with ZERO hits so far this month

I don't remember seeing one
https://firewallban.dynu.net/search.php ... orExitNode

15 hits in 7 months.
by palinka
2020-05-18 00:18
Forum: General discussions
Topic: Is there a logfile for antispam results :?:
Replies: 46
Views: 1071

Re: Is there a logfile for antispam results :?:

oh, me fool.. should remove the comment marks in front of the sub... Yes. 👍 Now there is no error log on reloading the scripts. But which sort of protocol has to be activated for the events? - Application - SMTP - POP3 - IMAP - TCP/IP - Debug - AWstats None. OnAcceptMessage is a scripting trigger s...
by palinka
2020-05-17 22:44
Forum: General discussions
Topic: Can't get mail from Dynu Store/Forward
Replies: 1
Views: 139

Re: Can't get mail from Dynu Store/Forward

You should probably ask them. If you didn't change anything then it must be something on their end. I use dynu also (not the store/forward - just for dns). They've been pretty good about responding when I had issues. Not so much for help. :lol: But at least if the issue is on their end they can look...
by palinka
2020-05-17 22:41
Forum: General discussions
Topic: Is there a logfile for antispam results :?:
Replies: 46
Views: 1071

Re: Is there a logfile for antispam results :?:

You could log stuff to the event log. Put this code in OnAcceptMessage in EventHandlers.vbs: REM - Log spam reasons Dim Reason1, Reason2, Reason3, Reason4, Reason5, Reason6, Reason7 If (oMessage.HeaderValue("X-hMailServer-Spam") = "YES") Then EventLog.Write ("######## SPAM RECEIVED ########") EventL...
by palinka
2020-05-17 20:40
Forum: General discussions
Topic: Is there a logfile for antispam results :?:
Replies: 46
Views: 1071

Re: Is there a logfile for antispam results :?:

What exactly would you like to see?
by palinka
2020-05-17 04:10
Forum: Scripting
Topic: COM Messages.ItemByDBID
Replies: 7
Views: 408

Re: COM Messages.ItemByDBID

Well, the whole thing is up in the air. I need each message to distribution list recipients (members) to have a unique identifier but I don't believe there is a way to access individual messages from the distribution list to the distribution list MEMBERS. I can only access the message going to the d...
by palinka
2020-05-16 23:39
Forum: Scripting
Topic: COM Messages.ItemByDBID
Replies: 7
Views: 408

Re: COM Messages.ItemByDBID

One other thing. Minor but annoying. In order to see if the message recipient is a distribution list, I use this: Set hMSCOM = CreateObject("hMailServer.Application") Call hMSCOM.Authenticate(ADMIN, PASSWORD) Set sDomain = hMSCOM.Domains.ItemByName(vDomainName) Set sDistList = sDomain.DistributionLi...
by palinka
2020-05-16 23:31
Forum: Scripting
Topic: COM Messages.ItemByDBID
Replies: 7
Views: 408

Re: COM Messages.ItemByDBID

The message ID gets inserted into a mailto link in a list-unsubscribe header at OnDeliveryStart. Then if the subscriber unsubscribes, the message id gets parsed from the to address to find the list so the from address can be deleted from the distribution list. Won't the unsubscribe message come FRO...
by palinka
2020-05-16 14:07
Forum: Scripting
Topic: COM Messages.ItemByDBID
Replies: 7
Views: 408

Re: COM Messages.ItemByDBID

Here's what I have for the insert. Sub OnDeliveryStart(oMessage) REM - Add List-Unsubscribe header if sending to distribution list Dim hMSCOM, sDomain, sDistList, sDistListRecip, IsDistList, vDomainName vDomainName = Split(oMessage.Recipients(0).OriginalAddress, "@")(1) Set hMSCOM = CreateObject("hM...
by palinka
2020-05-16 13:27
Forum: Scripting
Topic: COM Messages.ItemByDBID
Replies: 7
Views: 408

Re: COM Messages.ItemByDBID

How are you getting the message? If from From a rule or built in event? Or from a file in the data store? The idea behind it is some kind of bounce/ unsubscribe handling. Right now I'm working on the unsubscribe part. The message ID gets inserted into a mailto link in a list-unsubscribe header at O...
by palinka
2020-05-15 16:38
Forum: General discussions
Topic: hmailserver forwarding
Replies: 19
Views: 734

Re: hmailserver forwarding

Session: 956 "SMTPC" 9080 956 "2020-05-14 21:34:36.834" "96.114.157.81" "RECEIVED: 220 resomta-po-11v.sys.comcast.net resomta-po-11v.sys.comcast.net ESMTP server ready" "SMTPC" 9080 956 "2020-05-14 21:34:36.835" "96.114.157.81" "SENT: EHLO mail.contilegal.net" "SMTPC" 9084 956 "2020-05-14 21:34:36.8...
by palinka
2020-05-15 16:12
Forum: Scripting
Topic: COM Messages.ItemByDBID
Replies: 7
Views: 408

COM Messages.ItemByDBID

Is there a way to get to Messages.ItemByDBID without going through domain>account>imapfolders? I'm working on something where the message ID is known, but the rest is not.
by palinka
2020-05-14 22:25
Forum: General discussions
Topic: hmailserver forwarding
Replies: 19
Views: 734

Re: hmailserver forwarding

Palinka, Not going to spam. Yes, can send directly from kate@contilegal.net but ONLY by using Comcast's SMTP server directly from email client. Will not work if I use the hmailserver service. Here is a log. There was an email sent from gconti3@contilegal.com to kate@contilegal.net at 13:25. Guy The...
by palinka
2020-05-14 20:09
Forum: General discussions
Topic: hmailserver forwarding
Replies: 19
Views: 734

Re: hmailserver forwarding

I have a relay set up with Comcast SMTP server. I have verified the username, login, port (587), etc; all is correct. ... I have set up, under the user kate@contilegal.net, a forwarding of all email to xxxxx@gmail.com. No matter what, I cannot seem to get the email forwarded. IN all other respects,...
by palinka
2020-05-13 22:08
Forum: General discussions
Topic: Bad User/Pass Error Log Question
Replies: 9
Views: 452

Re: Bad User/Pass Error Log Question

Hey thanks. Are those settings within hmail settings? I can only seem to fine the jeff one. (sorry i'm new) Any chance it is one of those usernames is causing the issue and not the other? Anyways here is the diagnostic report requested. PROTOCOLS SMTP GENERAL DELIVERY RFC COMPLIANCE ADVANCED No. Co...
by palinka
2020-05-13 18:33
Forum: General discussions
Topic: Bad User/Pass Error Log Question
Replies: 9
Views: 452

Re: Bad User/Pass Error Log Question

Something wrong with your relay settings. You're trying to log in to sendgrid via users scotty.jones and jeff.loder for authentication. That's where there password / username fails.

Run this and post the results:
viewtopic.php?f=20&t=30914
by palinka
2020-05-13 11:42
Forum: User contributed hMailServer 5 scripts
Topic: Ban spammers based on prior spamming
Replies: 7
Views: 1982

Re: Ban spammers based on prior spamming

This has been working pretty well, but there was a flaw in recording the main domain name. My regex assumed all domains come in 2 parts as "example.com". This led to a few false positives where there were more than 2 parts to a domain, such as "example.co.uk" which got recorded as simply "co.uk". Th...
by palinka
2020-05-13 04:15
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 12268

Re: Is HmailServer for the likes of me?

Close only counts with hand grenades and nuclear bombs. Or do you need to use Floating Point registers for your calculations? Close is a relative term. I've thrown hand grenades, so I have personal experience with "close". Believe me, you don't want to be "close" - you want to be "on target". :D In...
by palinka
2020-05-13 03:44
Forum: Scripting
Topic: Parsing Public Suffix List in VBS
Replies: 2
Views: 262

Re: Parsing Public Suffix List in VBS

Got it working. I knew it was something really stupid. I DIM'd PubSufRegEx, so it was always blank, therefore EVERYTHING MATCHES! YAY! Anyway, this could be useful for a few things. I have a use for it. Option Explicit Function Include(sInstFile) Dim f, s, oFSO Set oFSO = CreateObject("Scripting.Fil...
by palinka
2020-05-13 03:03
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 12268

Re: Is HmailServer for the likes of me?

We are all "experts" in our own cars so may I start with this ... This rebuild by MAT in Finland is right up the category "Hardcore Car Porn" for petrolheads ... 1,500+ pictures ... http://www.mat.fi/gallery/65 Missing a couple of bolts there. :lol: They say you're really happy if you put the thing...
by palinka
2020-05-12 22:27
Forum: General discussions
Topic: Problem with Delivered-To rule..
Replies: 26
Views: 893

Re: Problem with Delivered-To rule..

I don't know the answer to your question, but isn't a spam score of 11 high enough to delete automatically? My delete threshold is much lower than that. That message is bona fide spam and should be deleted. It's not worthy of sending to a spam folder for review.
by palinka
2020-05-12 22:20
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 12268

Re: Is HmailServer for the likes of me?

Can't tell you how many times I forget to turn the headlights on in the day time when it rains (the headlight law is only a few years old and old habits die hard). Sheer stupidity. My car has automatic lights (most/all new cars do). You can set it to the usual manual settings or to automatic. Of co...
by palinka
2020-05-12 22:11
Forum: General discussions
Topic: Bad User/Pass Error Log Question
Replies: 9
Views: 452

Re: Bad User/Pass Error Log Question

Please copy and paste text. Most people are looking on mobile phones and won't even bother looking at a screenshot. I know I won't, anyway.
by palinka
2020-05-12 20:13
Forum: General discussions
Topic: Bad User/Pass Error Log Question
Replies: 9
Views: 452

Re: Bad User/Pass Error Log Question

Please post relevant log entries.
by palinka
2020-05-12 17:07
Forum: General discussions
Topic: hMailserver and IIS SMTP on same server
Replies: 9
Views: 471

Re: hMailserver and IIS SMTP on same server

Yeah i noticed the part the OP said his messages are saved as text file in the dropbox of IIS 6 SMTP server, the question is if he does this manually or that his messages are send thru IIS SMTP (localhost) and end up in the dropbox folder? For the later option i see no issue using hMailserver direc...
by palinka
2020-05-12 16:23
Forum: General discussions
Topic: hMailserver and IIS SMTP on same server
Replies: 9
Views: 471

Re: hMailserver and IIS SMTP on same server

I have a webserver where the website application is sending mail (like Contact forms) by saving a text file in a dropbox of a Microsoft IIS 6 SMTP-server. Or skip IIS SMTP altogether and script the pickup folder. https://hmailserver.com/forum/viewtopic.php?f=9&t=33062 But then again, why would you ...
by palinka
2020-05-12 15:19
Forum: General discussions
Topic: hMailserver and IIS SMTP on same server
Replies: 9
Views: 471

Re: hMailserver and IIS SMTP on same server

hacke23 wrote: ↑
2020-05-12 14:15
I have a webserver where the website application is sending mail (like Contact forms) by saving a text file in a dropbox of a Microsoft IIS 6 SMTP-server.
Or skip IIS SMTP altogether and script the pickup folder.

https://hmailserver.com/forum/viewtopic.php?f=9&t=33062
by palinka
2020-05-12 03:46
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 12268

Re: Is HmailServer for the likes of me?

in fact the Toyota Hilux dual cab is Australia's biggest selling car the last few years. Funny you mention that. My soccer mom neighbor recently traded her soccer mom SUV in for a dual cab ram pickup. I was talking to the husband about it and he said she took one test drive and loved it. The ride q...
by palinka
2020-05-11 21:39
Forum: General discussions
Topic: Need Help with MX/DNS configuration
Replies: 26
Views: 1093

Re: Need Help with MX/DNS configuration

You can automate SSL certificate renewals using WinAcme or one of the other acme clients. Look in the tutorials section for several.
by palinka
2020-05-11 21:05
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 12268

Re: Is HmailServer for the likes of me?

Great for dropping burnouts (leaving tyre marks on the road and rubber smoke in the air) Has the same meaning in the US. Donuts are circular burnouts. :mrgreen: You have coal rollin' ute burnouts over there? https://www.youtube.com/watch?v=7Jpu7bzzkKc I love the sound of the turbo. I used to have a...
by palinka
2020-05-11 20:40
Forum: General discussions
Topic: Another SYN flood attack?
Replies: 6
Views: 525

Re: Another SYN flood attack?

So you did not read the pdf? Nope, but I just read it. Found something interesting and I can concur: Most abused top-level domains, Q1 2020 .com: Throughout 2019, we reported that the vast majority of botnet C&C domains were registered in the generic top-level-domain (gTLD) .com. This trend continu...
by palinka
2020-05-11 16:05
Forum: General discussions
Topic: Another SYN flood attack?
Replies: 6
Views: 525

Re: Another SYN flood attack?

I found an active botnet in my neighborhood. ITS NOT ME - I PROMISE!!! :mrgreen:
by palinka
2020-05-11 15:24
Forum: General discussions
Topic: Another SYN flood attack?
Replies: 6
Views: 525

Re: Another SYN flood attack?

Interesting that Russia is not even on the Spamhaus list and China is a lot further down my list than theirs. Spamhaus Top 10 Bot List by Country 1 India 1,855,386 2 China 1,555,824 3 Egypt 910,737 4 Viet Nam 900,007 5 Iran (Islamic Republic of) 816,115 6 Brazil 750,503 7 Thailand 549,574 8 Algeria ...
by palinka
2020-05-10 18:16
Forum: General discussions
Topic: Is HmailServer for the likes of me?
Replies: 127
Views: 12268

Re: Is HmailServer for the likes of me?

mattg wrote: ↑
2020-05-10 15:55
As in
'My dad gave me a new ute for my birthday, I'm chuffed'
What is a ute?


https://m.youtube.com/watch?v=U7BMCZdXSlk
by palinka
2020-05-10 03:35
Forum: General discussions
Topic: Need Help with MX/DNS configuration
Replies: 26
Views: 1093

Re: Need Help with MX/DNS configuration

lestatve wrote: ↑
2020-05-10 03:31
Thanks palinka. I did so. Is they key to making hmailserver listen on port 26 adding it to TCP/IP Ports in Advanced? If so, which protocol?

Thanks!
Les
SMTP.
by palinka
2020-05-09 23:06
Forum: General discussions
Topic: Need Help with MX/DNS configuration
Replies: 26
Views: 1093

Re: Need Help with MX/DNS configuration

The domain is contilegal.net. Ports 25, 110, 143, 587 are open at firewall and router. Port forwarding is active on same. Using 587 for SMTP. Is 25 necessary for incoming? If so, can I use a different port? Thanks, Les You would need a port 25 redirect service. I know there are a couple of free one...
by palinka
2020-05-09 20:17
Forum: General discussions
Topic: Need Help with MX/DNS configuration
Replies: 26
Views: 1093

Re: Need Help with MX/DNS configuration

It would be easier to troubleshoot if we knew the domain.

Try running your domain through mxtoolbox.com.
by palinka
2020-05-09 20:09
Forum: Scripting
Topic: Parsing Public Suffix List in VBS
Replies: 2
Views: 262

Re: Parsing Public Suffix List in VBS

This works - it returns the correct result. But no function. What I want is to turn this working thing into a function. Its the same as above except not in "function form". ' Function CheckDomain(strDomain) Dim strDomain ' strDomain = "pool-72-76-221-125.nwrknj.fios.verizon.net" ' strDomain = "msnbo...
by palinka
2020-05-09 20:02
Forum: Scripting
Topic: Parsing Public Suffix List in VBS
Replies: 2
Views: 262

Parsing Public Suffix List in VBS

I'm trying to parse the public suffix list here: https://publicsuffix.org/list/public_suffix_list.dat First I created a powershell script to download the list and output it into a regex string like this: PubSufRegEx = "^ac$|^com\.ac$|^edu\.ac$|^gov\.ac$|^net\.ac$|^mil\.ac$|^org\.ac$|...REST OF LIST ...
by palinka
2020-05-09 15:05
Forum: General discussions
Topic: SSL/TLS connection issues
Replies: 13
Views: 652

Re: SSL/TLS connection issues

Can you post error logs?
by palinka
2020-05-08 21:58
Forum: General discussions
Topic: Need Help with MX/DNS configuration
Replies: 26
Views: 1093

Re: Need Help with MX/DNS configuration

lestatve wrote: ↑
2020-05-08 21:23
LOL. Everything started working when I shut off the VPN :-)
BWAHAHAHAHAHA!!!!

Sorry, man. I've had my share of those so I can laugh with you. :lol:
by palinka
2020-05-07 20:06
Forum: General discussions
Topic: Maybe Antispam DNS Blacklist not working
Replies: 10
Views: 614

Re: Maybe Antispam DNS Blacklist not working

HMailLover2015 wrote: ↑
2020-05-07 17:21
What exactly does the incoming relay section do - what is it used for?
Trusted relay, so no spam checking. Would be used for example for another relay that accepts messages from an automated machine incapable of authentication. Or any other trusted source like a backup mx.
by palinka
2020-05-07 15:35
Forum: User contributed hMailServer 5 scripts
Topic: Dynamic Black/Whitelists in your script.
Replies: 104
Views: 16490

Re: Dynamic Black/Whitelists in your script.

SorenR wrote: ↑
2020-05-07 15:30
Extortion I am nowhere near finished with yet. The filtering of charactersets and look-a-like lettering I am still working on.
Feels like Christmas getting near! :mrgreen:
by palinka
2020-05-07 14:36
Forum: General discussions
Topic: DNS problems???
Replies: 14
Views: 772

Re: DNS problems???

First of all, there is a HELP button on every page of the admin gui. Pressing it will take you to the relevant documentation. Secondly, mail.hmailserver.com is not any internal software component. It's a public domain. If you can't resolve it, something is critically wrong with your DNS. You need to...
by palinka
2020-05-07 14:16
Forum: User contributed hMailServer 5 scripts
Topic: Dynamic Black/Whitelists in your script.
Replies: 104
Views: 16490

Re: Dynamic Black/Whitelists in your script.

Do you see any difference between "Ransomware" and "Extortion"?

I guess the question is: is it worth the extra dozen or so lines of script to create a Function Extortion? I see them as being more or less the same.

Great idea, by the way, to pick up the SA headers for the extortion tags.
by palinka
2020-05-06 18:45
Forum: General discussions
Topic: Mails sind nur im DATA Ordner / Mails are only in the DATA folder
Replies: 22
Views: 1193

Re: Mails sind nur im DATA Ordner / Mails are only in the DATA folder

RvdH wrote: ↑
2020-05-06 16:26
You should know, you opened that issue...
I'd only know on the version I had issue with, which was the only version I have installed.
(hint for future issue reports include url to forum topic/post)
👍
by palinka
2020-05-06 14:44
Forum: General discussions
Topic: Mails sind nur im DATA Ordner / Mails are only in the DATA folder
Replies: 22
Views: 1193

Re: Mails sind nur im DATA Ordner / Mails are only in the DATA folder

RvdH wrote: ↑
2020-05-06 13:46
5.7.x ALPHA bug and fix only, should be no issue on 5.6.x
Have you tried it on 5.6? Easy enough to test. I would but I don't have a test platform.
by palinka
2020-05-06 13:05
Forum: General discussions
Topic: Mails sind nur im DATA Ordner / Mails are only in the DATA folder
Replies: 22
Views: 1193

Re: Mails sind nur im DATA Ordner / Mails are only in the DATA folder

I cannot see the similarity to your problem from that thread you have linked too- there was nothing in your logs about a 550 rejection. However if you are saying that turning off plus addressing has solved the problem I works bee concerned that there is a fault or imperfection that needs addressing...
by palinka
2020-05-05 21:45
Forum: User contributed hMailServer 5 scripts
Topic: Dynamic Black/Whitelists in your script.
Replies: 104
Views: 16490

Re: Dynamic Black/Whitelists in your script.

I went back to my original php thing. I wasn't happy with how the js one jumps around. Edit something and it immediately goes back to the full list, so you have to search again, etc... I made some changes. First of all, its really for mobile, so that's why the columns look the way they do. I also fi...
by palinka
2020-05-05 14:07
Forum: User contributed hMailServer 5 scripts
Topic: Dynamic Black/Whitelists in your script.
Replies: 104
Views: 16490

Re: Dynamic Black/Whitelists in your script.

There are probably more of the same if I remember correctly. I did a manual conversion - changed the XML file in NP++ to become a CSV file and imported it into MySQL. Ended up with two "windows" comparing the XML version and the DB version. I used this when logging the XML data to my database to ma...
by palinka
2020-05-05 03:08
Forum: User contributed hMailServer 5 scripts
Topic: Dynamic Black/Whitelists in your script.
Replies: 104
Views: 16490

Re: Dynamic Black/Whitelists in your script.

SorenR wrote: ↑
2020-05-04 23:04

Code: Select all

(iPhone\s?(?:3G|4|5|6|SE|7|8|9|X|11)?(?:C|S|R)?\s?(?:Plus)?(?:Pro)?\s?(?:Max)?) - Confirmed.
Did you convert the database from XML ???
OK, plugged this (above) in and manually escaped the "\" and now its working. :oops:
by palinka
2020-05-05 02:56
Forum: User contributed hMailServer 5 scripts
Topic: Dynamic Black/Whitelists in your script.
Replies: 104
Views: 16490

Re: Dynamic Black/Whitelists in your script.

Did you convert the database from XML ??? Convert? What is this strange concept you speak of? :mrgreen: Actually, I used the regex replace in notepad++ to change the xml entries to csv, then imported to MySQL using a powershell script. I assumed MySQL added any necessary escaping during the insert ...