Problem with SQlite (only on windows ?) with 1.15.0

[manne65-hd]

Hi there at MailSlurper,
let me start by letting you know how awesome I find this little tool!

I have been using XAMPPs mailtodisk.exe for a long time while testing my software, and I just recently ran across MailSlurper!
This software makes my local and staging-environments much easier to handle :-)

I am facing an issue using the latest release (1.15.0) on my Windows 10pro-machine.

When starting the mailslurper.exe I get a couple of info-Debug-Messages and then this final FATAL message:

level=fatal msg="Error connecting to storage type '1' with a connection string of ./mailslurper.db" error="Error executing query: \n\t\tCREATE TABLE mailitem (\n\t\t\tid TEXT PRIMARY KEY,\n\t\t\tdateSent TEXT,\n\t\t\tfromAddress TEXT,\n\t\t\ttoAddressList TEXT,\n\t\t\tsubject TEXT,\n\t\t\txmailer TEXT,\n\t\t\tbody TEXT,\n\t\t\tcontentType TEXT,\n\t\t\tboundary TEXT\n\t\t);: Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub" who=MailSlurper

I guess, that "Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work." is the vital part of the error-message, because it sounds like none of the CREATE TABLE commands are "known", because a required library for SQLite is missing ?!

I have tested with versions 1.13.2, 1.14.0 and 1.14.1 ... which all work on my machine!

Looking forward to your answers,
Manfred

[adampresley]

I'll have to take a look. Thanks for the ticket.

[hertg]

I am facing an issue using the latest release (1.15.0) on my Windows 10pro-machine.

I get the same error for 1.15.0 on Linux, using the pre-compiled version from the Github Release assets.

[johnli2210]

Same issue on mac os 1.15.0

[bermudi]

I get the same error for 1.15.0 on Linux, using the pre-compiled version from the Github Release assets.

+1

[albertohirota]

Same error on Windows 11 - 1.15

[hazg]

same on ubuntu 23.10

[andrewgbell]

I'm finding the same with 1.15.0 on windows 2022, and ubuntu 22.04.
1.14 is fine.

[pepinho]

same.
1.15.0 on windows.
first log on startup states:
time="2024-02-12T09:55:19+01:00" level=info msg="Starting MailSlurper Server v1.14.1" who=MailSlurper

notice the v1.14.1 output?
is this a packaging error in the 1.15 ZIP?

[slaveofcode]

Same issue on mac.

INFO[0000] Starting MailSlurper Server v1.14.1           who=MailSlurper
INFO[0000] Using configuration from config.json          who=MailSlurper
INFO[0000] Connecting to database                        who=MailSlurper
INFO[0000] Creating database tables...                   who=MailSlurper
FATA[0000] Error connecting to storage type '1' with a connection string of ./mailslurper.db  error="Error executing query: \n\t\tCREATE TABLE mailitem (\n\t\t\tid TEXT PRIMARY KEY,\n\t\t\tdateSent TEXT,\n\t\t\tfromAddress TEXT,\n\t\t\ttoAddressList TEXT,\n\t\t\tsubject TEXT,\n\t\t\txmailer TEXT,\n\t\t\tbody TEXT,\n\t\t\tcontentType TEXT,\n\t\t\tboundary TEXT\n\t\t);: Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub" who=MailSlurper

[andrewgbell]

I had to clone from source to get it work.

git clone https://github.com/mailslurper/mailslurper.git
cd mailslurper/cmd/mailslurper
go get github.com/mjibson/esc
go get
go build

[MarianMacik]

It seems the 1.15.0 release wasn't built using CGO_ENABLED=1.

@adampresley Can you create a fix release?