mORMot Open Source

Hi !

On server side,when a particular table is updated, it call a function who send an email using your SendEmail() from SynCrtSock.
Nothing particular here:

function SendMail;
var
  subject, header, text, mailDest: String;
begin
  header := '-Intervention-';
  subject := 'Some Subject';
  text := 'some text' + sLineBreak;
  text := text + 'more text' + sLineBreak;
  mailDest := 'mail@mail.com';

  if SendEmail('serverAdress.fr',           //Server
              'contact@mail.fr',               //From
              SockString(mailDest),         //CSVDest
              SendEmailSubject(subject), //Subject
              SockString(text),              //Text
              SockString(header),          //headers
              'user',                             //User
              'password')                      //Pass
              = true then
      log.Add.Log(sllInfo, 'SUCCESS')
  else
      log.Add.Log(sllInfo, 'FAILURE');
end;

When i'm running the server localy in console mode there is no problem, i'm receiving the email and in the log i can see 'SUCCESS', but if i'm running the application as a Windows service in the log i have "20151014 10320136 EXC   EInOutError ("Erreur E/S -10060")", and no 'FAILURE'.
From what i can understand, its an input output error, but caused by what? I've also found this https://support.microsoft.com/en-us/kb/191143

Is this coming from my server setting ?

thanks for your help.

EDIT: In the same service, I have another procedure who send mail with attachment using another unit using the same email server, and there is no problem

EDIT2: before posting, i was using for the subject of the mail SockString(subject), but because i thought my error could come from this i have put SendEmailSubject(subject). If i send an email with this (in local) the subject of the received mail is "=?UTF-8?B?W0ludGVydmVudGlvbl0gVmFsaWRhdGlvbiBkJ3VuIHRvZG8gcXVlIHZvdXMgYXZleiBhdHRyaWJ1w6k=". If I use SockString() instead i receive the right subject.

Hi!

Maybe I am just stupid or i read badly, but i can't find any example where the SQL MAX() or MIN() are used, even if AB is quickly talking about it in here.

My client is a TSQLHttpClientRequest, and i'd like to know the biggest value from a given column client side. How can I do that the easiest way please?

Thanks in advance, and sorry for my bad english.

Hi,

First of all, i'm working with your library since few month, and everything has been great, congrats for your hard work!

I'm bumping into a little problem though: I'm trying to do a backup of my SQLite databse using your BackupBackground fonction and BackupBackgroundWaitUntilFinished. When i'm running my server application in console mode, everything is doing great and i receive the backup. But if i'm trying the same function from a Windows service, i have a SQLITE_CANTOPEN (14) error on the log file.
Here is a part of my code:

    backupPath := 'DB\backup.s3db';
    if RestServer.DB.BackupBackground(backupPath, 1024, 10, nil) then begin
        RestServer.DB.BackupBackgroundWaitUntilFinished;
        log.Add.Log(sllInfo, 'BACKUP COMPLETE');
        if Self.SendMailBackup() then begin
            log.Add.Log(sllInfo, 'Backup sent');
            SysUtils.DeleteFile(backupPath);
        end;
     end;

Here is the whole error message from the log fle:

20150914 10165325 EXC   ESQLite3Exception ("Error SQLITE_CANTOPEN (14) using 3.8.10.1 with aDB=nil") at 00531991  stack trace API 0048EDE6 00406D0C 77BCD624 77BBAE6F 00531991 00532E70 006B3471 006A239A 006A1A91 006A18B3 00450625 0040778E 77533744 77BAA064 77BAA02F 
20150914 10165325 EXC   ESQLite3Exception ("Error SQLITE_CANTOPEN (14) using 3.8.10.1 with aDB=nil") at 00531991  stack trace API 0048EDE6 00406E94 

thanks in advance for your help !