#1 2014-11-17 14:23:32

beowulf68
Member
Registered: 2014-11-17
Posts: 4

Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

New to Lazarus/FPC and mORMot.

I am getting the following error when trying to compile TestSQL3.lpr (after I use Lazarus Delphi Project to Lazarus Project tool).

..\SynCommons.pas(8235,26) Error: Identifier not found "TSystemInfo"

Could someone share a successful TestSQL3.lpr file to use to build mORMOT on Windows 7 Pro (64bit), Lazarus V1.2.6, FPC 2.6.4, i386

Thanks!

Offline

#2 2014-11-17 15:45:16

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,240
Website

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

I tested with FPC 2.7.1 from svn.

It was told to work with FPC 2.6.4, but we may ask Alfred for feedback.

Offline

#3 2014-11-17 17:03:10

AOG
Member
Registered: 2014-02-24
Posts: 490

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

Works for me out of the box !!

Just downloaded (30 minutes ago):
1: Lazarus 1.2.6 +FPC 2.6.4
2: Latest mORMot 1.18.532

Open project in Lazarus : TestSQL3.lpi

Click run: off you go !
Everything green !!

@beowulf68: should work for u 2 !!

Offline

#4 2014-11-17 17:14:34

AOG
Member
Registered: 2014-02-24
Posts: 490

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

@beowulf68
Looking at your post more carefully, I saw that you used the Delphi project import-tool.
Do'nt !
It will make unnecessary changes to mORMot.
In your case: make another clean install of mORMot, and open /run  TestSQL3.lpi

Offline

#5 2014-11-18 00:13:10

beowulf68
Member
Registered: 2014-11-17
Posts: 4

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

Thanks! Got it to work. Had to copy the sqlite3.dll c:\windows and also to add {$define NOSQLITE3STATIC}.

Offline

#6 2014-11-18 00:19:57

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,240
Website

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

.. or you create your .o files using Mingw.
.. or you download the pre-build .o files from http://synopse.info/files/sqlite3fpc.7z and copy the two folders into the mORMot root folder (where there is SynCommons.pas)

(I just uploaded the .o files for both Win32 and Linux32)
Enjoy!
smile

Offline

#7 2014-11-18 02:14:28

beowulf68
Member
Registered: 2014-11-17
Posts: 4

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

OK - Got it to compile and run - but ended up with failures below... I will retry with the sqllite3.o you have uploaded and see if that makes a difference.


2.8. Multi thread process:
- Create thread pool: 1 assertion passed  36.05ms
- TSQLRestServerDB: 4,820 assertions passed  548.79ms
    1=9836/s  2=8372/s  5=4778/s  10=4016/s  30=3240/s  50=2992/s
- TSQLRestClientDB: 4,822 assertions passed  378.54ms
    1=8506/s  2=6370/s  5=7449/s  10=6700/s  30=6398/s  50=5352/s
- TSQLRestClientURINamedPipe: 2,412 assertions passed  1.43s
    1=1107/s  2=1290/s  5=728/s
- TSQLRestClientURIMessage: 3,220 assertions passed  294.16ms
    1=4452/s  2=6638/s  5=6470/s  10=6071/s

#### FAILURE HERE ####
  - TSQLHttpClientWinHTTP_HTTPAPI: 111 / 2,639 FAILED  9.02s
    1=399/s  2=617/s  5=1239/s  10=2552/s  30=3652/s  50=2512/s
#### FAILURE HERE ####

- TSQLHttpClientWinSock_WinSock: no assertion  471us
- Locked: 4,821 assertions passed  484.11ms
    1=3329/s  2=6183/s  5=5580/s  10=6088/s  30=5834/s  50=5364/s
- Unlocked: 4,822 assertions passed  462.45ms
    1=3433/s  2=6277/s  5=5015/s  10=5734/s  30=7748/s  50=6286/s
- Background thread: 4,822 assertions passed  879.55ms
    1=2864/s  2=6381/s  5=4899/s  10=4415/s  30=1891/s  50=1456/s
- Main thread: 4,822 assertions passed  444.95ms
    1=3286/s  2=7890/s  5=6574/s  10=6091/s  30=6619/s  50=5919/s
Total failed: 111 / 37,201  - Multi thread process FAILED  13.99s


ynopse framework used: 1.18.528
unning on wSeven_64 with code page 1252
Qlite3 engine used: 3.8.7.1
enerated with: Free Pascal 2.6.4 compiler

ime elapsed for all tests: 252.86s
ests performed at 18/11/2014 8:15:08

otal assertions failed for all test suits:  111 / 9,536,608
Some tests FAILED: please correct the code.

Offline

#8 2014-11-18 03:10:53

beowulf68
Member
Registered: 2014-11-17
Posts: 4

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

Hi guys

No difference. Still same failure as above. Any ideas? Thanks!

I won't be using the above function - so not critical I believe.

Thanks!

Offline

#9 2014-11-18 18:38:04

warleyalex
Member
From: Sete Lagoas-MG, Brasil
Registered: 2013-01-20
Posts: 250

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

Hi, I just downloaded to test on Ubuntu a few minutes and everything is green !!!

Synopse framework used: 1.18.541
Running on Linux 3.5.0-17-generic #28-Ubuntu SMP Tue Oct 9 19:32:08 UTC 2012
SQlite3 engine used: 3.8.7.1
Generated with: Free Pascal 2.7.1 compiler
Tests performed at 11/18/2014 06:23:27 PM

Total assertions failed for all test suits:  0 / 8,393,090
! All tests passed successfully.

Last edited by warleyalex (2014-11-18 18:40:18)

Offline

#10 2014-11-18 19:17:25

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,240
Website

Re: Build failed - TSysteminfo Identifier not found (Win7, Lazarus, FPC)

@AOG @warleyalex
I still can't understand why some process involving virtual tables is much slower with FPC than with Delphi, even under Windows.
Perhaps due do the memory manager used... I do not know exactly.
AFAIR some older version of SQlite3 was faster... weird...

But the new SynDBRemote.pas feature seems to work with no problem with FPC under Windows and Linux.
smile

@beowulf68
For the http.sys web server to work, you need to REGISTER the URI - see the doc at http://synopse.info/files/html/Synopse% … l#TITL_109
So try to compile and run TestSQL3Register.dpr, with administrator rights.
Or run the TestSQL3.exe tests at least once with administrator rights.

Offline

Board footer

Powered by FluxBB