corneliusdavid

Lots of good information in this thread but I'll add a blog I wrote a couple of months ago that explains how I use a certificate from K Software (less than $100 year) to sign both Delphi apps and installs built with InnoSetup: What can Code Signing do for you? Perhaps it'll add something useful for someone.

OK, I explicitly, without any conditional compilation, used first just FireDAC.ConsoleUI.Wait then added FireDAC.Comp.UI in separate tests for both Apache for Windows and Apache for Linux. No errors, no data--from either one. I change only the first unit (ConsoleUI) to either FireDAC.VCLUI.Wait or FireDAC.FMXUI.Wait and I get a dataset in Apache for Windows but not Apache for Linux. Here's the section of code from my web action item that tries to get the data set (the database is a list of park names and coordinates): try try Log.Debug('getting park list', LOG_TAG); dmParksDB.OpenParks; Log.Debug('parks table is open', LOG_TAG); Result := dstpMyParks.Content; Log.Debug('returning park content', LOG_TAG); except on e:Exception do Log.Error(e.Message, LOG_TAG); end; finally dmParksDB.CloseParks; end; Log.Debug('parks are closed', LOG_TAG); Here are the log entries: 2021-06-22 01:11:10:777 [TID 139867211564800][DEBUG ] getting park list [web] 2021-06-22 01:11:10:791 [TID 139867211564800][DEBUG ] parks table is open [web] 2021-06-22 01:11:10:791 [TID 139867211564800][DEBUG ] returning park content [web] 2021-06-22 01:11:10:794 [TID 139867211564800][DEBUG ] parks are closed [web] "dstpMyParks" is a TDataSetTableProducer whose DataSet property is hooked to a query in a data module. I'm using a different web action item to make a simple database query of the same "parks" database and table and it works fine on all platforms. If you want to see the code, it's on GitHub (still has the conditional compilation). I am wondering if there is a library file I'm missing. Before I copied libgds.so to the Linux system, the park lookup function did not work--no error, just no data. Thanks for your suggestions.

Before someone catches my mistake, I just want to point out that the {$IFDEF WINDOWS} is incorrect and would never match because "WINDOWS" is not defined--it should've been {$IFDEF MSWINDOWS}. Still, I'd like to know how to return datasets from FireDAC on Apache for Linux.

Should. And I wish but it doesn't in Apache web modules. Without any conditional compilation, if I use FireDAC.ConsoleUI.Wait, no Apache web modules of either platform will show a dataset result. If I change that unit to either FireDAC.FMXUI.Wait or FireDAC.VCLUI.Wait, then I do get a dataset result but only for the Windows version of the Apache module. Another interesting note, I expanded the testing with platform conditional directives: {$IFDEF CONSOLE} APP_NAME = 'My App Console'; {$ELSE} {$IFDEF LINUX} APP_NAME = 'My App Linux'; {$ELSE} {$IFDEF WINDOWS} APP_NAME = 'My App Windows'; {$ELSE} APP_NAME = 'My App [unknown]; {$ENDIF} {$ENDIF} {$ENDIF} and found something interesting: Apache for Linux showed: My App Linux Apache for Windows showed: My App [unknown] So, Apache for Windows modules evidently don't know what platform they're compiling for!

Then neither the Linux nor the Windows versions shows the dataset. At least the way I have it now, the Windows one works. Here's my uses clause: {$IFDEF LINUX} FireDAC.ConsoleUI.Wait, {$ELSE} FireDAC.FMXUI.Wait, FireDAC.Comp.UI, {$ENDIF} Here's a constant defined which shows on the generated web page that indicates which platform it's running under: {$IFDEF CONSOLE} APP_NAME = 'My App Console'; {$ELSE} {$IFDEF LINUX} APP_NAME = 'My App Linux'; {$ELSE} APP_NAME = 'My App Windows'; {$ENDIF} {$ENDIF} The Windows one shows up for Apache for Windows, the Linux one shows up for Apache for Linux. The Console one, as you might guess by now, never shows up. So yes, I'm sure the conditional compilation is working as expected.

I had something very close to that--I tested for Linux instead of Console. And I guess that's the problem--it's not really a console app, even though it doesn't have a GUI.

Thanks very much--that makes sense and I got it installed and configured in Delphi and connected to my Pixel phone. 🙂

This is a two-year old post but I just want to say a big THANK YOU for this answer. I spent the better part of a day in anguish over this very problem where a demo program worked just fine but copying the code to my program did not. After comparing everything between the two projects and hunting around the internet for possible answers, I finally found this and it was solved immediately!

This is awesome! Thank you for posting that. I like it better than my solution.

I just had this exact same problem today, did a search, found your post and answer and joined this forum just to say THANK YOU for posting both the question and the answer. I had updated xcode to try and deploy to an iPhone but the iMac I was using was too old and ran into incompatibility problems. In the course of downloading an older xcode and trying to update libraries, I think it got stuck into the wrong directory and I was unsure what I did. Seeing your post made everything clear and fixed it immediately. Thanks again! David.