FB4 Windows XP problem

[Hugo Larson]

Hi,

gsec -user SYSDBA -database security.db

use gsec -? to get help

Error loading plugin Engine13

Module c:\FB4\plugins/Engine13 exists but can not be loaded

The specified procedure could not be found.

unable to open database

firebird.log

WINXPIE-1037 Fri Jun  4 08:43:59 2021

setsockopt: error setting IPV6_V6ONLY to 0

[Frank Schlottmann-Gödde]

Am 04.06.21 um 09:11 schrieb 'Hugo Larson' via firebird-support:

Hi,
gsec -user SYSDBA -database security.db
use gsec -? to get helpError loading plugin Engine13Module c:\FB4\plugins/Engine13 exists but can not be loadedThe specified procedure could not be found.unable to open database
firebird.logWINXPIE-1037 Fri Jun  4 08:43:59 2021 setsockopt: error setting IPV6_V6ONLY to 0

There where an extended network packet for windows xp, that could be activated by
netsh interface ipv6 install


see https://sites.google.com/site/jrey42/Home/ipv6/winxp
maybe that helps, but I would recommend to quit using windows xp as soon as possible.

mit freundlichen Grüßen
Frank Schlottmann-Gödde

-- 
Oldenburger Str. 34, 23743 Grömitz, Tel.: 04562/266984

[Hugo Larson]

Hi,

Thanks but it did not help.

We still have many customers using Windows POSREADY  XP which is still supported.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/77f264a7-841c-d92b-6880-f07fdd99de54%40schlottmann-goedde.de

.

[Rustam]

If FB 2.5 satisfy your existing needs, then migrating to FB 3 i think would be enough for next few years.

Hugo Larson' via firebird-support" <firebird...@googlegroups.com>:

[em...@tot-consult.com]

The message "exists but cannot be loaded" suggest an issue with the bitness - 32-bit process trying to load 64-bit library or vice versa.

[Hugo Larson]

It is the 32 bit version. The service installs fine but when I try connect with isql the error is shown.

The 64 bit version wont install at all.

//Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit

https://groups.google.com/d/msgid/firebird-support/b07dc419-242d-46f6-962d-ff0c66e975c2n%40googlegroups.com

.

[em...@tot-consult.com]

Then there might be some dependencies missing, like the C runtime libraries. There was a tool from sysinternals that could show what dll's are attempted to be loaded, but I've forgotten which one it was.

[Mark Rotteveel]

As far as I'm aware, Firebird 4 is not compiled with Windows XP
compatibility, which means it might use Windows APIs not available on
Windows XP.

Mark

[Hugo Larson]

I successfully installed Visual C++ 2017 Redistributable on XP 32 bit, which should be only dependency but still same error.

What else could it be? 32 bit software should work on XP.

https://groups.google.com/d/msgid/firebird-support/840925c8-9495-44b8-9c5a-82639822beaen%40googlegroups.com

.

[Dimitry Sibiryakov]

05.06.2021 11:16, 'Hugo Larson' via firebird-support wrote:
> What else could it be? 32 bit software should work on XP.

Write a little program that just load Endine13.dll and show you a real error. You also
can try to use rundll32 or instsvc for that.

--
WBR, SD.

[Hugo Larson]

Hi,

Running the command : rundll32 engine13.dll
Does not return any result.

I'm using the debug version of Firebird 4

Not sure what you mean with instsvc but I guess it installs and run the service:

instreg version WI-V4.0.0.2496 Firebird 4.0

Firebird has been successfully installed in the registry.

instsvc version WI-V4.0.0.2496 Firebird 4.0

Service "Firebird Server - DefaultInstance" successfully created.

Service "Firebird Server - DefaultInstance" successfully started.

It start fine.

SQL> connect security.db user SYSDBA; Database: security.db, User: SYSDBA

Statement failed, SQLSTATE = 39000

Error loading plugin Engine13

-Module C:\FB4-deb\Firebird-4.0.0.2496-1-Win32-pdb\plugins/Engine13 exists but can not be loaded

-The specified procedure could not be found.

//Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsub...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/c8621390-6a7d-70f1-a88e-326fb7068a9b%40ibphoenix.com.

[Dimitry Sibiryakov]

05.06.2021 12:48, 'Hugo Larson' via firebird-support wrote:
> Not sure what you mean with *instsvc*

I'm sorry, I meant regsvr32.

--
WBR, SD.

[Hugo Larson]

We have some 100 computers running Window Posready XP and we would  really like to use FB4 with all it's nice new features.

Thanks,
Hugo

--
  WBR, SD.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsub...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/bc02153e-ae65-9672-80ca-2bd340e2068d%40ibphoenix.com.

[Dimitry Sibiryakov]

05.06.2021 13:06, 'Hugo Larson' via firebird-support wrote:
> We have some 100 computers running Window Posready XP and we would  really like to use FB4
> with all it's nice new features.

Firebird client should work on WinXP. For server you can use Linux.

--
WBR, SD.

[Hugo Larson]

FB is part of a software running independently on XP computers.

--
  WBR, SD.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsub...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/75b74f67-b79f-902d-35af-74d86ab06b15%40ibphoenix.com.

[Tomasz Tyrakowski]

On 05.06.2021 at 11:16, 'Hugo Larson' via firebird-support wrote:
> I successfully installed Visual C++ 2017 Redistributable on XP 32 bit, which should be only dependency but still same error.
>
> What else could it be? 32 bit software should work on XP.

Being 32-bit is not sufficient to guarantee it can run on XP. Much
depends on which libraries an exe or a dll is linked against.
Looking at engine13.dll in PEInfo
(http://www.pazera-software.pl/products/peinfo/ [disclaimer: I don't
have anything to do with pazera-software.pl, I just happen to use this
free tool from time to time]), the imports section lists the following
dlls: kernel32.dll, advapi32.dll, shell32.dll, ws2_32.dll, fbclient.dll,
msvcp140.dll, vcruntime140.dll, mpr.dll, user32.dll, ole32.dll.
Either some of them are missing in XP, or they are incompatible (i.e.
don't contain a function, wchich engine13.dll tries to resolve and execute).
I don't think you can do much about it - except VC runtime they're all
system libraries.

cheers
Tomasz

________________________________


Ta wiadomość zawiera poufne informacje przeznaczone tylko dla adresata. Jeżeli nie jesteście Państwo jej adresatem, bądź otrzymaliście ją przez pomyłkę, prosimy o powiadomienie o tym nadawcy oraz trwałe jej usunięcie.

[Hugo Larson]

Tomasz,
I checked and all these DLL exists in my  Windows XP  installation.

BR, Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsub...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/b6412f20-635d-a103-9443-5746b280c0ba%40sol-system.pl.

[Tomasz Tyrakowski]

On 06.06.2021 at 07:06, 'Hugo Larson' via firebird-support wrote:
> Tomasz,
> I checked and all these DLL exists in my Windows XP installation.
>

Fortunately, I dug out one of my old XP VM images and was able to do
some sniffing around with ProcMon from sysinternals (version 3.10, which
works on XP, is still available from webarchive).
It turns out vcruntime140.dll is to blame. It tries do load a DLL named
api-ms-win-crt-runtime-l1-1-0.dll (from a couple of default locations).
This dll is not present in XP by default. I've got this DLL in my Win10
machine, but this is my dev machine, with full Visual Studio and Win10
SDK installation, so that's no proof, it is still possible this DLL
would be missing in a fresh install of Win10, so in fact the same
problem actually may occur in other versions of Windows as well. I've
checked a few Win10 machines at my disposal and they all contain this
DLL, but none of them is a "fresh install" - it might have been
installed with other software.
Since vcruntime140.dll is a part of Visual C++ Runtime for Visual Studio
2015, I downloaded and installed VC redist 2015 package
(https://www.microsoft.com/en-us/download/details.aspx?id=48145) in my
XP VM and it seemed it solved the problem. I was able to run FB instance
via firebird -a (the tray icon appeared and I was able to check the
server version). However, I was not able to create a new database from
isql, nor to use gbak to restore the db from a backup (in both cases
getting an error message saying "this function is not supported by this
version of the operating system"). However, that might have been caused
by some FB4 misconfiguration on my side (or, to be honest, a total lack
of such - I just unpacked the FB4 32-bit zip archive and started to play
with it).
So, my advice is: install VC++ 2015 runtime, install and configure FB4
according to the manual, and test if it works. It kind of partially
worked for me ;), but this error message about system version doesn't
look good.
Or maybe just stick with your current version of FB on XP (it won't stop
working, will it?) and migrate after your legacy XP users finally upgrade.
If someone could verify if api-ms-win-crt-runtime-l1-1-0.dll is present
in Win10 by default, it would be nice to know. If it doesn't, it might
be necessary to install VC2015 redist package together with FB4 to run
the server (regardless of the Windows version).
Sorry my letter ended up so long, I was kind of "writing while doing" :)

regards
Tomasz

p.s. Apart from api-ms-win-crt-runtime-l1-1-0.dll, vcruntime140.dll has
a bunch of other api-ms-win-crt-xxx-l1-1-0.dll dependencies (xxx =
string, heap, stdio, convert, math, time, utility, filesystem, environment).

[Hugo Larson]

Hi,

Please tell me if you could connect to EMPLOYEE.FDB  with isql  or other software, such as flamerobin on your XP machine.

Thanks, Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsub...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/d750eb69-09a3-a1df-710b-209e9ef11c70%40sol-system.pl.

[Tomasz Tyrakowski]

On 07.06.2021 at 08:07, 'Hugo Larson' via firebird-support wrote:
> Please tell me if you could connect to EMPLOYEE.FDB with isql or other software, such as flamerobin on your XP machine.

No I could not. I was able to start the server (in application mode, via
firebird -a) and check the server version / properties via the tray icon.
All attempts to connect to a database or to restore a backup ended in an
error message I mentioned before (about a function not available in this
version of the OS). But, like I said, I just unzipped the installation
archive and run the server without doing any configuration. I can try to
tune some params in firebird.conf, e.g. turn off wire encryption, use
legacy_auth by default etc. and see what happens.
Have you tried installing the full VC2015 redist package? What stage are
you currently at? Have you been able at least to start the FB server?

cheers
Tomasz

[Hugo Larson]

AuthServer = Srp256, Srp, Legacy_Auth

UserManager = Srp, Legacy_UserManager

WireCrypt = Disabled

isql

connect security.db user SYSDBA; Database: security.db, User: SYSDBA

Statement failed, SQLSTATE = 39000

Error loading plugin Engine13

-Module c:\FB4\plugins/Engine13 exists but can not be loaded

-The specified procedure could not be found.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsub...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/5c56ac61-d0dc-7bc9-b2d9-facad3c36c30%40sol-system.pl.

[Tomasz Tyrakowski]

On 07.06.2021 at 10:00, 'Hugo Larson' via firebird-support wrote:
> AuthServer = Srp256, Srp, Legacy_AuthUserManager = Srp, Legacy_UserManagerWireCrypt = Disabled

> isql
> connect security.db user SYSDBA; Database: security.db, User: SYSDBA
>

> Statement failed, SQLSTATE = 39000Error loading plugin Engine13-Module c:\FB4\plugins/Engine13 exists but can not be loaded-The specified procedure could not be found.

Tough luck. I've tried different settings in firebird.conf, but it seems
that while the server process itself can be started and is listening on
a socket, any operation requiring actual access to a database (which in
turn makes the server process load engine13.dll) fails. Neither of isql,
gbak, gsec works. isql and gbak show an error saying "this function is
not supported in this system" (I get the message in Polish, so it's
probably a Windows localized error message, not FB's), while gsec shows
the same message as yours: error loading plugin ..., the specified
procedure could not be found. But again, the part "the specified
procedure could not be found" is displayed in Polish (the rest in
English), so I assume it comes from the OS, not from FB.
I think it's time to give up. The only possibility I can think of is
trying to compile FB4 from sources on XP, but I've got neither tools,
nor motivation to do that (if you can somehow get and install VS2015 -
maybe there's a free community edition) and you really need FB4 on XP
that badly, you can give it a shot.

[Vlad Khorsun]

 Hugo, Mark and All

  Firebird uses XP-compatible toolset when build for Win32 with MSVC. While I can't promise it

will be kept at next release (we need to use new Win API), it is still actual for both fb3 and fb4.

  I've restored broken compatibility of 32-bit builds FB4 with WinXP, try next snapshot build, please.

Note,  you'll need replace ICU 63 that included into FB4 as it is not supported WinXP. Latest ICU

version that supports WinXP is ICU 58.

Regards,

Vlad

[Hugo Larson]

Great news. Thanks!

//Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/81d28103-287b-4b0b-959c-a350e4655438n%40googlegroups.com.