LDAP Consistency

[Tarawerkz via 4D_Tech]

Hi, 

I recently implemented a feature in a v15 application that allows the users to 
log in to 4D Client via their windows credentials.  A script using the LDAP 
LOGIN command makes a call direct from the client app to the LDAP IP address on 
port 389.  It works well with remote clients as well as 4D client on the set 
station as 4D server.

However, I am having an issue with log in via web browsers.  On login via 
browser connections, the username and password parameters are passed to the 4D 
Server and used to authenticate against the same LDAP address and port.  Using 
the same login script as the client login, authentication fails even with the 
correct credentials. 

Does any one have an idea why this is so?  Why is the LDAP script behaving 
differently when called from the client and from the server ?

Regards 
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

File Transmission to SFTP Server

[Tarawerkz via 4D_Tech]

Hi, 

I would like to ask if there is native support in 4D v17 too send text files 
from 4D Server (on Windows Server 2012) to an sFTP server?

Regards,
Ronnie



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

HL7 over TLS 1.2

[Tarawerkz via 4D_Tech]

Hi All,

I have an application that is currently receiving and sending HL7 messages from 
and to an in-house organisation-wide database.

Can anyone offer advice on how to implement a 2-way client certificate 
authentication over TLS 1.2 for this message exchange?
Thank you

Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: JSON Plugin for 4Dv17

[Tarawerkz via 4D_Tech]

Hi, thanks to all for the replies.  
I will look into the documentation again.

Regards,
Ronnie
Tarawerkz
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

JSON Plugin for 4Dv17

[Tarawerkz via 4D_Tech]

Hi All,

I have a client whose database application currently outputs a series of text 
files in an exchange with an independent web database.
In an effort to further streamline this functionality, it have been proposed to 
convert and integrate the various text file output to a JSON file format 
instead.

Is there currently any 4D plugin for creating JSON files in 4D that is 
compatible with 4Dv17 (Windows)?
Thank you.

Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Attempt to read beyond end of stream

[Tarawerkz via 4D_Tech]

Peter and Chip,

Thank you both for the constructive feedback on the possibilities.

As the cause of the issue and the consequent resolution (if indeed possible) is 
one black-box, I have decided to go back to the most recent stable version and 
re-do the necessary changes.


Regards,
Ronnie
Tarawerkz

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Attempt to read beyond end of stream

[Tarawerkz via 4D_Tech]

Thanks Chip,

I’ll try that, hopefully can find a version from not too far back.

Any idea what could have caused this?

Regards,
Ronnie
Tarawerkz




> On 3 Dec 2020, at 9:27 PM, nug <4d_o...@pghrepository.org> wrote:
> 
> Ronie,
> -Go back to the originally damaged structure and try MSC on it again.
> -go back to a previous version of the structure (backup)
> -contact 4D support
> 
> While I personally do not like it….
> Also there is a new forum, where nearly ever one is now.
> You will get more help/eyeballs on this issue there
> 
> https://discuss.4d.com <https://discuss.4d.com/>
> 
> Chip
> 
>> On Dec 3, 2020, at 5:42 AM, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> Hi All,
>> 
>> I would like seek advice on an issue I encountered with a v15 structure file 
>> which has been in use for a long time.
>> 
>> Recently, when I logged in with the designer password to make some 
>> amendments to the code, I encounter a memory allocation error on a resource 
>> blob.
>> So I did a structure repair and compact using MSC utility.
>> 
>> After the repair, the original error is resolved but a new error appeared in 
>> its place,  
>> This time it is an attempt to read beyond end of stream (error code 200).
>> Subsequent repairs of the structure file does not remove the error.
>> 
>> The issue is data independent as it also appears with an empty data file.
>> If I were to log in as a normal user (not the designer account), the error 
>> is not encountered.
>> 
>> May I ask how I can recover the structure in this instance?
>> 
>> Regards,
>> Ronnie
>> Tarawerkz
>> 
>> 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> New Forum: https://discuss.4D.com <https://discuss.4d.com/>
>> Archive:  http://lists.4d.com/archives.html 
>> <http://lists.4d.com/archives.html>
>> Options: https://lists.4d.com/mailman/options/4d_tech 
>> <https://lists.4d.com/mailman/options/4d_tech>
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
>> <mailto:4d_tech-unsubscr...@lists.4d.com>
>> **
> 

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Attempt to read beyond end of stream

[Tarawerkz via 4D_Tech]

Hi All,

I would like seek advice on an issue I encountered with a v15 structure file 
which has been in use for a long time.

Recently, when I logged in with the designer password to make some amendments 
to the code, I encounter a memory allocation error on a resource blob.
So I did a structure repair and compact using MSC utility.

After the repair, the original error is resolved but a new error appeared in 
its place,  
This time it is an attempt to read beyond end of stream (error code 200).
Subsequent repairs of the structure file does not remove the error.

The issue is data independent as it also appears with an empty data file.
If I were to log in as a normal user (not the designer account), the error is 
not encountered.

May I ask how I can recover the structure in this instance?

Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SFTP & PGP Encryption

[Tarawerkz via 4D_Tech]

Hi All,


In the wake of the prevailing security considerations, my client has enquired 
of the following for an on-site 4D v17 application running on Windows Server 
2012…..

1.  to provide an external facing SFTP through which the enterprise SAP can 
connect to ?

2.  to support this connection via PGP encryption (to pick up files which the 
4D application will generate in CSV format) ?

Is the new version of 4D (or v18) able to support such features?


Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Writing 4D Data into an Excel Template

[Tarawerkz via 4D_Tech]

Hi Pat,

Thanks for the mail.  Yes, I had written to Rob himself for his opinion too.

I’m quite sure his plugin would be of great help in this project and have 
included it as part of the proposal to the client.
Thanks again.

Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Writing 4D Data into an Excel Template

[Tarawerkz via 4D_Tech]

Hi,

I would like to ask if anyone is aware of a plugin or utility that can quickly 
turnaround an export function where data from a 4Dv17.2 database (Windows 
Server)
gets written directly into different worksheets inside ONE Excel document 
template?

The 2nd challenge is to identify the row-ID for each record and store it on 
other worksheets in the Excel template every time the same record is referenced.
Say for example, the first worksheet is titled “General” and contains customer 
records and the starting row for the first customer record is row 5.  
Subsequent worksheets would bear a row-ID column such that reference to the 
same customer record would now be populated with “5” as the row-ID.  How can we 
identify this row-ID whilst populating the spreadsheet with a 4D data export on 
the fly?

Any pointers would be greatly appreciated.  Thanks.
 
Regards,
Ronnie
Tarawerkz


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Application as a 3-tier System

[Tarawerkz via 4D_Tech]

Hi, thanks to all for the input.

Regards,
Ronnie



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D Application as a 3-tier System

[Tarawerkz via 4D_Tech]

Hi All,

I have an application running in a hospital environment for a number of years.
In the light of the increasing awareness of data security, the client’s IT in 
their own words are looking at "redoing the whole 4dcis database onto 2 or 3 
tier system where there is a database separation from application layer”

The current setup is a v15 client-server application, with about 80 concurrent 
client licenses serving users located at 2 separate locations.

As it stands, a 4D application already has a 2-layer architecture being a 
client-server application.  
We could perhaps enhance it a little to make it a 2-tier environment by moving 
the segregating the 4D Server software and the 4D structure files (business 
logic) on to one server and the 4D data files (database) on to a separate 
server.  Doing that however has no effect on the 4D database architecture, it 
still remains a 2-layer database architecture.

Apart from re-developing the application into a complete web-based application, 
how can a 4D application be refreshed into a 3-tier system?

I would like to tap on the collective wisdom of the forum to gather some views 
on the plausibility of the above.
Thank you.

Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4Dv17 as a Windows Service

[Tarawerkz via 4D_Tech]

Hi Pat,

I have managed to find a solution to the 4D Service.

Recap of the problem :  When the data files are sitting on a repository 
different from the 4D Server and structure files, running the database 
application as a Windows service will fail.  The Windows log event will 
indicate an error with Event ID 9 - Can’t open database.  I surmised that the 
issue resulted from the Windows service not being able to locate the data file 
when started.

How it was solved …
Map the network drive that contains the 4D data files (so that it’s always 
available when the 4D Server is rebooted.
Define the 4D service and specify the log-on user using the same administrator 
account as per the log-in administrator account for the 4D Server.
Start up 4D Server as a direct app and point the to the data file on the 
network drive.  
Register the 4D Service.
Most critically, the path on the 4D Service has to be modified.  On definition, 
the path only points to the 4D Server app on C drive and the the 4D structure 
files, not the data files.  So I ran RegEdit to edit the registry and change 
the path to the Windows Service to the 4D Link link created in step 3.  The 
path on the Windows Service would be as follows :
C:\Program Files\4D\4D v17.2\4D Server\4D Server.exe -s 
"C:\Users\UserName\AppData\Roaming\4D Server\Favorites 
v17\Local\ApplicationDbv17.4Dlink”
With this, the service ran happily (ever after?)

Regards,
Ronnie



> On 16 Oct 2019, at 5:00 PM, Pat Bensky  wrote:
> 
> I wonder if, when it's running as a service, the network drive doesn't get 
> mounted fast enough when the 4D server is rebooted, so it can't find the data 
> file?
> 
> Can the network drive be permanently mounted?
> 
> PB
> 
> On Wed, 16 Oct 2019 at 09:50, Tarawerkz  > wrote:
> Hi Pat,
> 
> On the 1st initial login, we have to select it to tell 4D Server where the 
> data file is.
> The data file sits in a repository which has been mapped as a network drive 
> to automatically mount when the 4D Server is rebooted.
> 
> On subsequent login attempts, 4D Server opens the data file automatically.
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> 
> 
> 
>> On 16 Oct 2019, at 4:33 PM, Pat Bensky > > wrote:
>> 
>> If you start the 4D server manually, does it automatically find the correct 
>> data file (on another repository) or do you have to select it?
>> 
>> On Wed, 16 Oct 2019 at 09:25, Tarawerkz > > wrote:
>> Hi Pat,
>> 
>> I’m already using the Log On as account feature (under the Log In tab).
>> 
>> Actually, I’ve tested the service with the structure and data files residing 
>> in the same directory (as per usual default implementation) and that WORKS !
>> 
>> It’s only when I pull the data files out to another repository that the 
>> service fails.
>> Somehow the Windows service path only traps the path to the 4D Server 
>> application and the structure files, NOT the data file (which it assumes to 
>> be beside it in the same directory?).
>> 
>> Regards,
>> Ronnie
>> Tarawerkz
>> 
>> 
>> 
>> 
>>> On 16 Oct 2019, at 4:07 PM, 4d_tech-requ...@lists.4d.com 
>>>  wrote:
>>> 
>>> Subject: Re: 4Dv17 as a Windows Service
>>> Message-ID:
>>> >> >
>>> Content-Type: text/plain; charset="UTF-8"
>>> 
>>> Ronnie,
>>> Please see the message "SOLVED: Can't run as a service on Windows 2016 (or
>>> later)" - the info might be helpful to you. I realise you're on 2012, not
>>> 2016, but I suspect the same issue may apply.
>>> HTH
>>> 
>>> Pat
>> 
>> 
>> 
>> -- 
>> *
>> CatBase - Top Dog in Data Publishing
>> tel: +44 (0) 207 118 7889
>> w: http://www.catbase.com 
>> skype: pat.bensky
>> *
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com 
> skype: pat.bensky
> *

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4Dv17 as a Windows Service

[Tarawerkz via 4D_Tech]

Hi Ullst,

Thanks for your mail.

The service is run-in under the administrator   account with full privileges.
You are right that the default Windows service path only lays out the path to 
the 4D Server app and the structure files, NOT the data files that is sitting 
on a separate repository.

Is there any way to modify the path in a Windows Service as such?

Regards,
Ronnie
Tarawerkz




> On 16 Oct 2019, at 3:07 PM, Uist Macdonald  wrote:
> 
> 
> The user that the service is running under must have network access 
> privileges. It is unlikely the default will have these privileges, so cannot 
> see your data files.
> 
> Uist
> 
> 
> -- 
> 
> Ceres Computer Consultants Ltd
> 
> Registered Office:
> South Scotstarvit
> Chance Inn
> Cupar
> Fife KY15 5QJ
> 
> +44 (0) 1334 828002
> 
> Registered in Scotland : SC107838
> 
> An ISO 9001 registered company.
> 
>> On 16 Oct 2019, at 06:24, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> wrote:
>> 
>> Hi All,
>> 
>> I have a 4Dv17 application that the client’s IT decided has to run on 
>> Windows Service (under Windows Server 2012r2).
>> That is fine till a new requirement surfaced.
>> 
>> They wanted the 4D data files to be stored on separate repository, away from 
>> the 4D Server application and the 4D structure files, ie. the .4DD, .4DR and 
>> the log file will be stored on a drive (with a different IP address) away 
>> from the .4DB and .RSR files and the 4D Server application.
>> 
>> This works fine when the 4Dv17 Server is run directly as an application.
>> However the service fails because apparently the service is unable to locate 
>> the data files on the separate server when the service starts.
>> The service will start and quit.  Windows Event Log indicated an error to 
>> the effect that the database cannot be opened.
>> 
>> Is there any solution for this?
>> 
>> Regards,
>> Ronnie
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4Dv17 as a Windows Service

[Tarawerkz via 4D_Tech]

Hi All,

I have a 4Dv17 application that the client’s IT decided has to run on Windows 
Service (under Windows Server 2012r2).
That is fine till a new requirement surfaced.

They wanted the 4D data files to be stored on separate repository, away from 
the 4D Server application and the 4D structure files, ie. the .4DD, .4DR and 
the log file will be stored on a drive (with a different IP address) away from 
the .4DB and .RSR files and the 4D Server application.

This works fine when the 4Dv17 Server is run directly as an application.
However the service fails because apparently the service is unable to locate 
the data files on the separate server when the service starts.
The service will start and quit.  Windows Event Log indicated an error to the 
effect that the database cannot be opened.

Is there any solution for this?

Regards,
Ronnie

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SQL Connection to External SQL DB

[Tarawerkz via 4D_Tech]

Hi Tom, 

….and a word of thanks too for your reply and the tip !

Regards,
Ronnie
Tarawerkz




> On 16 Sep 2019, at 4:34 PM, Tarawerkz  wrote:
> 
> Hi Tom,
> 
> The current 4D version at the client’s site is v15.
> Through the various versions of upgrade from v11 to 13 to 15, there has not 
> been an issue with the SQL connection.
> 
> I suspect it could be some GPOs that were pushed down….so the subsequent 
> investigation are narrowing down to that.
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> 
> 
> 
>> On 16 Sep 2019, at 2:13 PM, Tom Benedict > <mailto:benedic...@comcast.net>> wrote:
>> 
>> Hi Ronnie,
>> 
>> My suspicion is that something around SSL on the external DB has changed. 
>> Perhaps your app uses a version of 4D which supports TLS 1.0 and the 
>> external DB was changed to use TLS 1.2? Or maybe the other way around? Just 
>> a guess.
>> 
>> Here’s 4D Tech Tip which can help determine what version of TLS your app 
>> uses:  http://kb.4d.com/assetid=76175 <http://kb.4d.com/assetid=76175>
>> 
>> Tom Benedict
>> 
>>> On Sep 15, 2019, at 22:04, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com 
>>> <mailto:4d_tech@lists.4d.com>> wrote:
>>> 
>>> Hi All,
>>> 
>>> Need some help on a SQL connection issue….
>>> 
>>> A script that has been to access an SQL database (been deployed for years) 
>>> has suddenly stopped working and threw up the following error :
>>> 
>>> Error - [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL 
>>> Security error
>>> 
>>> 
>>> In the cause of debugging, I tried a simple one-line SQL login command as 
>>> follows :
>>> 
>>> SQL Login(“IP:10.240.99.99”;$username;$password”;*)
>>> 
>>> SQL Login(“IP:10.240.99.99:1433”;$username;$password”;*)
>>> SQL Login(“IP:10.240.99.99:1433:ssl”;$username;$password”;*)
>>> 
>>> They all resulted in 4D Syntax error that indicates a failure to connect to 
>>> remote server, with a SQL error 9918, Generic SQL error
>>> 
>>> Where has it gone wrong?  Thank you for any advise.  
>>> 
>>> 
>>> Regards,
>>> Ronnie
>>> Tarawerkz
>>> 
>> 
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SQL Connection to External SQL DB

[Tarawerkz via 4D_Tech]

Hi Tom,

The current 4D version at the client’s site is v15.
Through the various versions of upgrade from v11 to 13 to 15, there has not 
been an issue with the SQL connection.

I suspect it could be some GPOs that were pushed down….so the subsequent 
investigation are narrowing down to that.

Regards,
Ronnie
Tarawerkz




> On 16 Sep 2019, at 2:13 PM, Tom Benedict  wrote:
> 
> Hi Ronnie,
> 
> My suspicion is that something around SSL on the external DB has changed. 
> Perhaps your app uses a version of 4D which supports TLS 1.0 and the external 
> DB was changed to use TLS 1.2? Or maybe the other way around? Just a guess.
> 
> Here’s 4D Tech Tip which can help determine what version of TLS your app 
> uses:  http://kb.4d.com/assetid=76175 <http://kb.4d.com/assetid=76175>
> 
> Tom Benedict
> 
>> On Sep 15, 2019, at 22:04, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> Hi All,
>> 
>> Need some help on a SQL connection issue….
>> 
>> A script that has been to access an SQL database (been deployed for years) 
>> has suddenly stopped working and threw up the following error :
>> 
>>  Error - [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL 
>> Security error
>> 
>> 
>> In the cause of debugging, I tried a simple one-line SQL login command as 
>> follows :
>> 
>>  SQL Login(“IP:10.240.99.99”;$username;$password”;*)
>> 
>>  SQL Login(“IP:10.240.99.99:1433”;$username;$password”;*)
>>  SQL Login(“IP:10.240.99.99:1433:ssl”;$username;$password”;*)
>> 
>> They all resulted in 4D Syntax error that indicates a failure to connect to 
>> remote server, with a SQL error 9918, Generic SQL error
>> 
>> Where has it gone wrong?  Thank you for any advise.  
>> 
>> 
>> Regards,
>> Ronnie
>> Tarawerkz
>> 
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SQL Connection to External SQL DB

[Tarawerkz via 4D_Tech]

Hi All,

Need some help on a SQL connection issue….

A script that has been to access an SQL database (been deployed for years) has 
suddenly stopped working and threw up the following error :

Error - [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL 
Security error


In the cause of debugging, I tried a simple one-line SQL login command as 
follows :

SQL Login(“IP:10.240.99.99”;$username;$password”;*)

SQL Login(“IP:10.240.99.99:1433”;$username;$password”;*)
SQL Login(“IP:10.240.99.99:1433:ssl”;$username;$password”;*)

They all resulted in 4D Syntax error that indicates a failure to connect to 
remote server, with a SQL error 9918, Generic SQL error

Where has it gone wrong?  Thank you for any advise.  


Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Windows shutdown with 4D Server running as a service

[Tarawerkz via 4D_Tech]

Hi,

Even when initiated from the 4D-end, it might not always be a graceful exit 
because the service times out when trying to stop.
Had encountered this on more than a few occasions with a client, end up we had 
to rebuild the “damaged” data file and indices.
The error message at end of repair is something to the effect that data 
flushing did not complete (the database application has a 24/7 listener that 
receives incoming messages from other systems).



Sent: Thursday, August 8, 2019 1:20 PM
To: s.o...@the-aquila-group.com ; 4D iNug 
Technical <4d_tech@lists.4d.com >
Subject: Re: Windows shutdown with 4D Server running as a service

I am assuming that your Administrative function runs on a client? Sounds like a 
good idea, but wondering if it might be a bit over kill for me. 

Bottom line is that at some point the server is quit without regard to who is 
logged in at the time whether done with a quit command or issued by the Windows 
service. The admin can see who is logged by firing up a client on the server 
and opening the Administration window before shutting down the computer or 
shutting down the service. If after hours the admin may have no choice but to 
let 4D server boot the clients off.

> From what I gather from the responses, it really does not matter as for as 4D 
> is concerned, it will “gracefully" quit any 4D client hanger ons before 
> quitting no matter how it is told to quit. There should never be any damage 
> to the data. 

Thanks to those who responded.

John

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4Dv15 app on Windows Service

[Tarawerkz via 4D_Tech]

Hi,

So it is sufficient to run the 4D service under a Service account as long as it 
has full administrator rights?
There has been instances when the service starts, then it crashes when trying 
to generate a PDF (generation executed on server).
But once it’s successfully generated (without crashing the service) then the 
service will be ok for some days until the next occurrence.

Yes, in some cases when trying to stop the service (for example for monthly 
maintenance), it takes too long and will time-out.
In which case, the IT support has no choice but to do a force-quit which at 
times lead to damage of data file.

Regards,
Ronnie




> On 3 Aug 2019, at 12:19 AM, 4d_tech-requ...@lists.4d.com wrote:
> 
> From: "Epperlein, Lutz (agendo)"  >
> To: 4D iNug Technical <4d_tech@lists.4d.com >
> Subject: AW: 4Dv15 app on Windows Service
> Message-ID: <890ec0923d2041178462b271736ab...@agendo.de 
> >
> Content-Type: text/plain; charset="utf-8"
> 
> That should be sufficient regarding rights. The question is which resource 
> the server should access. If you run the service under the default system 
> account, you could get problems accessing certain network resources, printer 
> ...
> But I think this a known circumstance.
> 
> Did you check the Windows event log? Are there some crashreport and /or dmp 
> files?
> 
> We only experienced such crashes if the server machine wanted to shut down 
> (because of a nightly system update) and the 4D service needed to much time 
> to come down. That lead in some cases to corrupted data files so the restart 
> of the service after the successful system update failed too.
> 
> Regards
> Lutz

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4Dv15 app on Windows Service

[Tarawerkz via 4D_Tech]

Hi David,

For reasons of security concerns raised by the client’s IT, we could only run 
the service with a service account with administrator permissions, not quite 
the full admin user.

Regards,
Ronnie


> On 1 Aug 2019, at 8:52 PM, David Samson  wrote:
> 
> 
> hello Ronnie,
> 
> Is the user account one with administrator permissions? We had a server 
> crashing periodically until we ran it as the full admin user.
> 
> David Samson
> Manchester
> UK
> 
> 
> Message: 14
> Date: Thu, 1 Aug 2019 09:46:33 +0800
> From: Tarawerkz mailto:ron...@tarawerkz.com>>
> To: 4d_tech@lists.4d.com 
> Subject: 4Dv15 app on Windows Service
> Message-ID: <472c433c-9374-4d4a-ba63-be5bdc777...@tarawerkz.com 
> >
> Content-Type: text/plain;   charset=gb2312
> 
> Hi,
> 
> I have a Windows question to ask …..
> 
> I have a v15 application running on a Windows service on a Windows Server 
> 2012 r2 (VM).
> Problem is the service would crash randomly, sometimes every 10-14 days, 
> sometimes on consecutive days.
> 
> Upon restart, sometimes the service would crash again almost immediately.  
> A second attempt is usually sufficient to keep the service running for the 
> next fortnight or so.
> 
> What can be done to improve the stability of the 4D service?
> FWIW, the Application Server role has not been turned on in the Server 
> Manager.
> Would turning it on actually make the running of windows service more stable?
> 
> Does anyone have any encounters like this before?
> 
> 
> Regards,
> Ronnie
> Tarawerkz 
> 
> -- 
> D Samson

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4Dv15 app on Windows Service

[Tarawerkz via 4D_Tech]

Hi,

I have a Windows question to ask …..

I have a v15 application running on a Windows service on a Windows Server 2012 
r2 (VM).
Problem is the service would crash randomly, sometimes every 10-14 days, 
sometimes on consecutive days.

Upon restart, sometimes the service would crash again almost immediately.  
A second attempt is usually sufficient to keep the service running for the next 
fortnight or so.

What can be done to improve the stability of the 4D service?
FWIW, the Application Server role has not been turned on in the Server Manager.
Would turning it on actually make the running of windows service more stable?

Does anyone have any encounters like this before?


Regards,
Ronnie
Tarawerkz


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**