4D 15.3HF1 OSX 10.12.4 - is 4D v15.4 the best answer.

2017-03-29 Thread David Ringsmuth via 4D_Tech
We’ve had 2 crashes on 4D Server with the HTTP thread.

For us this is a rather higher-volume site.

I’ve seen here 4D v15.4 seems to perform well in this area in particular – it 
survived DOS attack simulation.

We are looking for suggestions and insight.

Are there issues with 4D v15.4 that would caution upgrading to it?

Thanks!

Process:   4D Server [823]
Path:  /Applications/4D v15.3/4D Server.app/Contents/MacOS/4D 
Server
Identifier:com.4D.4DServer
Version:   15.3 build 15.206822 (15.0.3)
Code Type: X86-64 (Native)
Parent Process:??? [1]
Responsible:   4D Server [823]
User ID:   504

Date/Time: 2017-03-29 11:27:42.875 -0400
OS Version:Mac OS X 10.12.4 (16E195)
Report Version:12
Anonymous UUID:88ACC846-88EA-3401-57EF-638EA00A3CAF


Time Awake Since Boot: 10 seconds

System Integrity Protection: enabled

Crashed Thread:55  HTTP connection handler (id = 124123)

Exception Type:EXC_CRASH (SIGABRT)
Exception Codes:   0x, 0x
Exception Note:EXC_CORPSE_NOTIFY

Application Specific Information:
abort() called
*** error for object 0x613e4700: Invalid pointer dequeued from free list

Thread 55 Crashed:: HTTP connection handler (id = 124123)
0   libsystem_kernel.dylib  0x7fffae4b1d42 __pthread_kill + 10
1   libsystem_pthread.dylib 0x7fffae59f5bf pthread_kill + 90
2   libsystem_c.dylib   0x7fffae417420 abort + 129
3   libsystem_malloc.dylib  0x7fffae516d98 nanozone_error + 525
4   libsystem_malloc.dylib  0x7fffae50c588 
_nano_malloc_check_clear + 427
5   libsystem_malloc.dylib  0x7fffae50c3bf nano_malloc + 35
6   libsystem_malloc.dylib  0x7fffae505282 malloc_zone_malloc + 
107
7   libsystem_malloc.dylib  0x7fffae504200 malloc + 24
8   libcrypto.1.0.0.dylib   0x0001050c1d18 CRYPTO_malloc + 104
9   libcrypto.1.0.0.dylib   0x0001050f01f2 bn_expand_internal + 
114
10  libcrypto.1.0.0.dylib   0x0001050f03ef BN_copy + 47
11  libcrypto.1.0.0.dylib   0x0001050f5805 
BN_BLINDING_convert_ex + 133
12  libcrypto.1.0.0.dylib   0x000105113359 
RSA_eay_private_decrypt + 1001
13  libssl.1.0.0.dylib  0x00010505751a 
ssl3_get_client_key_exchange + 666
14  libssl.1.0.0.dylib  0x000105054010 ssl3_accept + 1712
15  libssl.1.0.0.dylib  0x000105064707 ssl3_read_bytes + 375
16  libssl.1.0.0.dylib  0x000105061a4c ssl3_read + 156
17  com.4d.ServerNet0x000104c4e5f5 
xbox::VSslDelegate::Read(void*, unsigned int*) + 89
18  com.4d.ServerNet0x000104c4a627 
xbox::XBsdTCPSocket::DoReadWithTimeout(void*, unsigned int*, int, int*) + 157
19  com.4d.ServerNet0x000104c57e93 
xbox::VTCPEndPoint::DoReadExactly(void*, unsigned int*, int) + 195
20  com.4d.ServerNet0x000104c5a13a 
xbox::VTCPEndPoint::ReadExactly(void*, unsigned int, int) + 996
21  com.4d.component.HTTPServer 0x00010890b89e 0x108903000 + 34974
22  com.4d.component.HTTPServer 0x00010890c0b7 0x108903000 + 37047
23  com.4d.component.HTTPServer 0x000108933469 0x108903000 + 197737
24  com.4d.component.HTTPServer 0x000108944957 0x108903000 + 268631
25  com.4d.component.HTTPServer 0x00010892193b 0x108903000 + 125243
26  com.4d.ServerNet0x000104c484aa 
xbox::VExclusiveWorker::DoRun() + 266
27  com.4d.kernel   0x0001048eefaa xbox::VTask::_Run() 
+ 186
28  com.4d.kernel   0x0001048f37d1 
xbox::XMacTask_preemptive::_ThreadProc(void*) + 145
29  libsystem_pthread.dylib 0x7fffae59c9af _pthread_body + 180
30  libsystem_pthread.dylib 0x7fffae59c8fb _pthread_start + 286
31  libsystem_pthread.dylib 0x7fffae59c101 thread_start + 13

Thread 55 crashed with X86 Thread State (64-bit):
  rax: 0x  rbx: 0x0006  rcx: 0x00016efb3988  
rdx: 0x
  rdi: 0x0001e4db  rsi: 0x0006  rbp: 0x00016efb39b0  
rsp: 0x00016efb3988
   r8: 0x   r9: 0x  r10: 0x0800  
r11: 0x0206
  r12: 0x0001  r13: 0x613e4700  r14: 0x00010a432000  
r15: 0x0001052d
  rip: 0x7fffae4b1d42  rfl: 0x0206  cr2: 0x7fffb72e4128
  
Logical CPU: 0
Error Code:  0x02000148
Trap Number: 133

David Ringsmuth

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: 

RE: 4D 15.3HF1 OSX 10.12.4 - is 4D v15.4 the best answer.

2017-03-29 Thread David Ringsmuth via 4D_Tech
Timothy,

Great answer. 

A little more difficult to implement.

Thanks!

David Ringsmuth

From: Timothy Penner via 4D_Tech
Sent: Wednesday, March 29, 2017 4:32 PM
To: Timothy Penner via 4D_Tech
Cc: Timothy Penner
Subject: RE: 4D 15.3HF1 OSX 10.12.4 - is 4D v15.4 the best answer.

Hi David,

Honestly I focused on the v15.3HF1 vs 15.4 on macOS 10.12.x part of the 
question and completely missed that mention DDOS at all… Sorry.

To be clear though, there is no v15.5 (yet) - there is a v15.4HF2 released a 
few days ago.
The DDOS thread was solved by using v15R5 however this was certainly not (to my 
knowledge) on Sierra.

Strictly speaking about macOS Sierra –
- You should be using either v16.0 or v15.4+ because these are the versions 
that are certified for macOS Sierra.
- V15.3/v15.3HF1 and v15R5 are not certified for macOS Sierra.  Here is the 
v15R5 cert matrix:
ftp://ftp-public.4d.fr/Documents/Products_Documentation/LastVersions/Line_15R5/VIntl/20160830_CertifV15_R5_INTL.pdf

Regarding the DDOS thread –
- I tested v15.4 (with a new db) using LOIC and I did not see an issue.
- Randy tested 15R5 (his db) using LOIC and his crashing went away (while his 
db crashed in v15.4 during the ddos).

My takeway from this is:
Is v15.4 inherently bad at dealing with ddos attacks? No I don’t think so since 
a new db didn’t crash, it seemed to be something specific to the db’s that 
crashed.
Is v15R5 inherently better at dealing with ddos attacks? Yes I think it is 
based on both Randy and Steve reports of their crashing going away with v15R5.
Is v15R5 a good match for macOS Sierra? No absolutely not. Use v16.x if you 
want the features of the v15R release on Sierra.

Kind Regards,

Tim PENNER



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

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

RE: 4D 15.3HF1 OSX 10.12.4 - is 4D v15.4 the best answer.

2017-03-29 Thread David Ringsmuth via 4D_Tech
Tim,

Thanks for responding!

We went to v15.3HF1 as a stop gap, because 15.2 was crashing on OSX 10.12.4.

Why did you not recommend 4D v15.5?

In a DOS attack posted here it performed without crashing, whereas 4D v15.4 
crashed.

David Ringsmuth

From: Timothy Penner via 4D_Tech
Sent: Wednesday, March 29, 2017 3:06 PM
To: 4D iNug Technical
Cc: Timothy Penner
Subject: RE: 4D 15.3HF1 OSX 10.12.4 - is 4D v15.4 the best answer.

Even 15.3 hotfix 1 (released 12/22/2016) is not certified for Sierra (it is 
only compatible):
http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_15/VIntl/PDF_Format/4Dv15_3_HotFix1_Certif__INTL.pdf

You should really be using the "certified" release now that it is available.

-Tim



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

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

osx open url vs osascript FYI

2017-03-09 Thread David Ringsmuth via 4D_Tech
4D v15.2
OSX 10.12+

I tried many different things to launch a .htm on OSX using OPEN URL, and it 
would not automatically open the document.

Included “safari” in the OPEN URL.
Used the “*” parameter in OPEN URL.
Stripped the volume name.
Removed Document Type and Creator, replaced with 4*char(0).
Added the Type in CREATE DOCUMENT.

So I used:

$outputStream_t:=""
$errorStream_t:=""

$LF:=Char(Line feed)

$script_t:="tell application \"Finder\""+$LF
$script_t:=$script_t+"print \""+$Path_Doc_t+"\" as alias"+$LF
$script_t:=$script_t+"end tell"+$LF
LAUNCH EXTERNAL PROCESS("osascript -";$script_t;$outputStream_t;$errorStream_t)

This works great!

David Ringsmuth

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

RE: osx open url vs osascript FYI

2017-03-13 Thread David Ringsmuth via 4D_Tech
Bernd,

Yes, html was what I first tried.

David Ringsmuth

From: Bernd Fröhlich via 4D_Tech
Sent: Saturday, March 11, 2017 4:57 AM
To: 4d_tech@lists.4d.com
Cc: Bernd Fröhlich
Subject: Re: osx open url vs osascript FYI

David Ringsmuth:

> I tried many different things to launch a .htm on OSX using OPEN URL, and it 
> would not automatically open the document.


Have you tried using ".html" instead of ".htm"?
What happens if you doubleclick your .htm-document in the finder?

Greetings from Germany,
Bernd Fröhlich
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

RE: osx open url vs osascript FYI

2017-03-10 Thread David Ringsmuth via 4D_Tech
Tim,

Good catch!

I copied the wrong code example.

It should be “open”.  (SORRY)

> $script_t:="tell application \"Finder\""+$LF
> $script_t:=$script_t+"open\""+$Path_Doc_t+"\" as alias"+$LF
> $script_t:=$script_t+"end tell"+$LF
> LAUNCH EXTERNAL PROCESS("osascript 
> -";$script_t;$outputStream_t;$errorStream_t)


David Ringsmuth

From: Tim Nevels via 4D_Tech
Sent: Friday, March 10, 2017 5:03 PM
To: 4d_tech@lists.4d.com
Cc: Tim Nevels
Subject: Re: osx open url vs osascript FYI

On Mar 10, 2017, at 9:12 AM, David Ringsmuth wrote:

> 4D v15.2
> OSX 10.12+
> 
> I tried many different things to launch a .htm on OSX using OPEN URL, and it 
> would not automatically open the document.
> 
> Included “safari” in the OPEN URL.
> Used the “*” parameter in OPEN URL.
> Stripped the volume name.
> Removed Document Type and Creator, replaced with 4*char(0).
> Added the Type in CREATE DOCUMENT.
> 
> So I used:
> 
> $outputStream_t:=""
> $errorStream_t:=""
> 
> $LF:=Char(Line feed)
> 
> $script_t:="tell application \"Finder\""+$LF
> $script_t:=$script_t+"print \""+$Path_Doc_t+"\" as alias"+$LF
> $script_t:=$script_t+"end tell"+$LF
> LAUNCH EXTERNAL PROCESS("osascript 
> -";$script_t;$outputStream_t;$errorStream_t)
> 
> This works great!

I am confused by this post. Your first statement is you are trying to OPEN an 
.htm document on macOS. But your AppleScript code will not open the document, 
it PRINTs it. 

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com


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

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

Keep Alive Connections Number of requests by connection

2017-08-14 Thread David Ringsmuth via 4D_Tech
When running 4D Server behind a proxy server (nginx), does 4D Server consider 
all of the requests from the proxy server to be from the same connection? The 
proxy server shows only 1 process ID.

With between 500 and 2000 requests per second from the proxy server, what is 
the recommend setting for “Number of requests by connection”?

In this case both nginx and 4D Server are running on the same machine (windows).

Thanks!

David Ringsmuth

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

RE: Folder separator constant

2017-07-14 Thread David Ringsmuth via 4D_Tech
Tim,



It seems possible to me that there is another option for the “Folder separator” 
character.

On startup the address for this character is populated with the correct value.

Thereafter it is retrieved as any other constant.

I’m guessing it is determined in runtime, most likely at startup.

I’m glad you think about such things.

David Ringsmuth

From: Tim Nevels via 4D_Tech
Sent: Thursday, July 13, 2017 8:24 PM
To: 4d_tech@lists.4d.com
Cc: Tim Nevels
Subject: Re: Folder separator constant

On Jul 13, 2017, at 6:47 PM,Wayne Stewart wrote:

> Mind you it took me a long time to discover the Folder separator constant!!



Now here is a great feature implemented in the wrong way. It confuses a 
programmers logical sensibility. 

“Folder separator” constant. It is a “constant”. Constants have a single value. 
Right? 

“Folder separator” constant has whatever value it correct depending on the 
platform it is running on. If on macOS it is colon “:”. On Windows is it back 
slash “\”. 

Compile your database. Run a method on macOS and you get one value for “Folder 
constant” and a different value on Windows. Client side, server side, it 
doesn’t matter. Runtime determines the value not compiling. 

But I thought constants were evaluated and resolved at compile time. Isn’t that 
the way it works in all other programming languages? A constant is a single 
value hard coded into the program code by the compiler. 

So 4D Compiler must treat this “constant” differently from other constants. The 
4D compiler must code this as a function that gets evaluated at runtime. 4D 
what were you thinking! 

Was it so terrible to make “Folder separator” into a function like “Application 
type”? Or did some engineer have the intense need and desire to see “Folder 
separator” show up in the method editor as a constant. Damn the semantics of it 
all! It may look like a constant, but it’s not. It is secretly a function.

From a programmers point of view it sure seems like an odd decision to me. 


This has always bugged me. I just had to finally get it off my chest. :)

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com


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

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

PHP Execute

2017-07-14 Thread David Ringsmuth via 4D_Tech
Does PHP Execute work in 4D v15.4 (windows) compiled built app?

(please say yes)

David Ringsmuth

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

RE: SMTP error 10113 Error with Authentication

2017-05-10 Thread David Ringsmuth via 4D_Tech
Tim,

Great suggestion. At first I thought it did.

The smtp auth password has only lowercase letters and numbers.

It is using SSL (true) SMTP AUTH (true).

I had that problem on another system. Special characters broke it.

David Ringsmuth

From: Timothy Penner via 4D_Tech
Sent: Wednesday, May 10, 2017 1:34 PM
To: 4D iNug Technical
Cc: Timothy Penner
Subject: RE: SMTP error 10113 Error with Authentication

David,

Just a wild guess - Is there a strange character in the password?
If so, maybe the character is being handled differently on 4D Server?
I don't know why this would be the case, I just thought it might give you 
something to investigate.

-Tim




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

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

RE: SMTP error 10113 Error with Authentication

2017-05-10 Thread David Ringsmuth via 4D_Tech
I tested with plugin 15.0, both with 4D Server and 4D Remote.

4D Remote sends the message correctly.

4D Server does NOT correctly deliver the message, but I am no longer getting 
the error 10113 Error with authentication. The email is NOT delivered.

David Ringsmuth

From: Epperlein, Lutz (agendo)
Sent: Wednesday, May 10, 2017 12:09 PM
To: 4D iNug Technical
Cc: davidi...@gmail.com
Subject: RE: SMTP error 10113 Error with Authentication

Try 4DIC Plugin 15.0

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David
> Ringsmuth via 4D_Tech
> Sent: Wednesday, May 10, 2017 5:41 PM
> To: Timothy Penner via 4D_Tech <4d_tech@lists.4d.com>
> Cc: davidi...@gmail.com
> Subject: SMTP error 10113 Error with Authentication
> 
> OSX 10.12.3
> 4D 15.3HF1
> 4D Server
> Compiled
> 4DIC Plugin 15.3
> 
> Also tested with:
> 15.4 (211153) with 4DIC plugin 15.4, Compiled

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

SMTP error 10113 Error with Authentication

2017-05-10 Thread David Ringsmuth via 4D_Tech
OSX 10.12.3
4D 15.3HF1
4D Server
Compiled
4DIC Plugin 15.3

Also tested with:
15.4 (211153) with 4DIC plugin 15.4, Compiled

When sending emails through 4D Server at this location fail with SMTP error 
10113 Error with authentication.

Same application sending email through 4D Remote or 4D Stand Alone on same 
machine works without error.
Same application sending email through 4D Server, Remote or Stand Alone on 
different machine works without error.

I’m looking for suggestions…

Thanks!

David Ringsmuth

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

https not working

2017-05-26 Thread David Ringsmuth via 4D_Tech
4D Server v15.4
Windows Server 2016
Active4D

We just installed a new cert.pem from QualitySSL.

I’ve evaluated the cert.pem with my openSSL tools and verified its good, and 
the modulus matches the key.pem.

4D Server is showing 443 open, active, but is not responding to any requests.

I’ve given the cert/key.pem to Pascal, and am waiting for a response from him.

I need ideas please!

Thanks!

David Ringsmuth

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

RE: Web serving on OS X Server

2017-06-09 Thread David Ringsmuth via 4D_Tech
Lee,

I’ve done a lot with nginx, very very little with apache.

https://engineering.datica.com/local-web-development-with-nginx-on-el-capitan.html

David Ringsmuth

From: Lee Hinde via 4D_Tech
Sent: Friday, June 9, 2017 1:14 PM
To: 4D iNug Tech
Cc: Lee Hinde
Subject: Web serving on OS X Server

I've setup apache as a front end to 4D on 'regular' macs without issue. But
now I need to do it on a Mac running the Server software and I'm not clear
where/how to configure that and my google fu is failing me.

Has anyone done that and can you point to directions?

I'd settle for having 4D serve directly, but OS X Server is running apache
even with Websites off.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

Http Request error 17 unimplemented control instruction, or error 1

2017-10-16 Thread David Ringsmuth via 4D_Tech
4D v16.2.214903 32bit
Windows 10 64bit
HTTP SET OPTION(HTTP_follow_redirect;1)
HTTP SET OPTION(HTTP_max_redirect;5)
HTTP SET OPTION(HTTP_timeout;15)

$url_t is a sub.domain.com:443 address with a path, and a query value. None of 
the url characters require encoding. 

When testing the same set of data using CURL, the result is correct, there is 
no error.

$http_Status_l:=HTTP Request(HTTP POST 
method;$url_t;$content_ob;$response_ob;$aHeaderNames;$aHeaderValues)

When $content_ob is an object with json, and the headers and values are both 
empty,  HTTP Request is returning an error 17, Unimplemented control 
instruction. The instance errors in about 10 seconds.

When $content_ob is an object, and the headers and values defined with 
“content-type” “application/json”,  HTTP Request is returning an error 1. This 
instance errors in less than 2 seconds.

When $content_ob is type text, and the headers and values are both empty,  HTTP 
Request is returning an error 1. This instance errors in less than 2 seconds.

The $http_status_l is 0 (zero) for every execution instance.

Help please!

David Ringsmuth

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

Http Request error 17 unimplemented control instruction, or error 1 (fixed)

2017-10-16 Thread David Ringsmuth via 4D_Tech
The 4D documentation has examples that do not include the h t t p s : / / 

HTTP Request apparently requires the URL to begin with either http or https : //

FYI: Microsoft mail makes it a link if I don’t add spaces (above)

David Ringsmuth

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

Http Request error 17 unimplemented control instruction, or error 1 (additional info)

2017-10-16 Thread David Ringsmuth via 4D_Tech
The OK variable is always 1 after any of these execution instances.

David Ringsmuth

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

RE: NGINX Config

2017-09-29 Thread David Ringsmuth via 4D_Tech
Doug,

Post this to: https://forum.nginx.org/

David Ringsmuth

From: Doug Hall via 4D_Tech
Sent: Friday, September 29, 2017 12:28 PM
To: 4D iNug Technical
Cc: Doug Hall
Subject: Re: NGINX Config

I am having some problems with my Nginx reverse proxy. I'm running 4Dv15,
and Active4D 6.4r3, using the 4D server shell. I have successfully
configured two web roots in Active4D, which run on the same 4D Web Client,
on port 8010. I have two different host names which are pointed to the same
IP address. I'll call them name1.domain.com:8010 and name2.domain.com:8010.
These successfully resolve to the appropriate web root within Active4D,
when I put those two urls in my web browser.

I set up my proxy in nginx two different ways, and neither of them
consistently resolve to the right website:

1: I setup one upstream server and accessed it through proxy_pass from both
server definitions:

upstream 4d_webclient{
server 127.0.0.1:8010;
}

server {
listen 80;
server_name name1.domain.com;

location / {
   root   /location_1
   proxy_pass http://4d_webclient;
   ...
}
}

server {
listen 80;
server_name name2.domain.com;

location / {
   root /location_2
   proxy_pass http://4d_webclient;
   ...
}
}

Please note that I'm just trying to get the reverse proxy to work. Once I
do that, I'll add SSL requirements, and all the necessary rewrites to make
sure people are redirected to our secured interface.

The second way I did it was to create a different upstream for each
website, using the DNS names for each, and then calling the appropriate
upstream proxy from each server definition:

upstream name1_server{
server name1.domain.com:8010;
}

upstream name2_server{
   server name2.domain.com:8010;
}

... (the same as above, except replacing 4d_webclient with name1/2_server
at proxy_pass)

Both ways gave the same results. After restarting my Web Client and nginx
(just to make sure I start from a clean slate), both name1.domain.com and
name2.domain.com resolve to the name1:domain.com:8010 website. However, if
I go to name2.domain.com:8010, then both name1.domain.com and
name2.domain.com will resolve to that website. Going to
name1.domain.com:8010 then causes both portless addresses to resolve there,
until I visit name2.domain.com:8010 directly again.

Obviously, I don't understand the relationship between how nginx deals with
upstream declarations and how that passes along to Active4D. Any help would
be appreciated.

Doug

On Fri, Oct 24, 2014 at 1:31 PM, Balinder Walia 
wrote:

> and then test by sending 100s of requests at the same time using Apache
> benchmark:
>
> Example type:
>
> $ ab -n 1000 -c 5 http://www.domain.com
>
> from Mac/Linux Terminal
>
> Balinder
>
> On 24 October 2014 19:26, Balinder Walia  wrote:
>
> > Brad,
> >
> > There are many ways to achieve it. Simplest is probably to count no of
> > processes and busyness in 4D and if too busy or near enough to use all
> > memory then get 4D to create 502.html file with appropriate message. Or
> > create if 4D is dead just leave one 502.hm there as a default option.
> >
> >
> > In JSON's script above see
> >
> >  proxy_next_upstream error timeout invalid_header http_500
> > http_502 http_503 http_504;
> >
> > what that means if proxy failed then intercept the error and show default
> > message in 502.htm
> >
> > So you would something like:
> >
> > in the main proxy block then
> >
> > proxy_intercept_errors on;
> > error_page 403 404 502 504 = @fallback;
> > break;
> >
> > and separate block what to do if proxy failed
> >
> > location @ fallback {
> > proxy_set_header X-Real-IP $remote_addr;
> > proxy_set_header Host $host;
> > proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
> >
> > root html;
> > index.hm which can have 502 error message or default message about 4d
> too
> > busy!
> > break;
> > }
> >
> > To be honest in this day and age we should never have a downtime and
> > customer should never see this unavailable error. they won't come back.
> So
> > I appreciate we should have a nice message on fail but setup the system
> so
> > it never fails.
> >
> >
> > On 24 October 2014 18:15, Perkins, Bradley D  wrote:
> >
> >> I'd also like to say thanks for all of these. I still use Apache but
> >> wondered about NGINX.
> >>
> >> >Any suggestions on making the Nginx server a fail-over to a hung 4D
> >> >server?
> >>
> >> Since I'm unfamiliar with NGINX, this may not help at all, but under
> >> Apache I always modify the error files for 502 (or 503?) errors so that
> >> they contain user friendly "site unavailable" messages. Those files get
> >> served when Apache can't reverse proxy to 4D.
> >>
> >> -- Brad
> >>
> >>
> >> **
> >> See how easy it is to extend your 4D solutions to Web and mobile. New
> >> opportunities await you with 4D v14!
> >>
> >> 

RE: NGINX Config

2017-10-03 Thread David Ringsmuth via 4D_Tech
Paul,

I can attest to the speed nginx provides in front of 4D!

But nginx also increases stability. 

Nginx will close stale connections, whereas an extremely busy 4D Server may not 
close stale connections, resulting in eventual crashing with thousands of http 
processes.

David Ringsmuth

From: Paul Dennis via 4D_Tech
Sent: Tuesday, October 3, 2017 2:16 AM
To: 4d_tech@lists.4d.com
Cc: Paul Dennis
Subject: Re: NGINX Config

RE: Note if you enable 443 and ssl for any server you must have a cert for
all servers listening on 443 you cant mix them up. 

To Clarify I use nginx on windows and linux in a hyper v vm to proxy to our
different internal servers for web, testing etc. Each ssl is tied to a
domain however if you enable ssl and 443 on the nginx instance then you 
must have an ssl for each domain listening on port 443. 

It is much faster to have nginx ssl sitting in front of 4d and have proxy to
4d on normal http.
Paul



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

RE: windows-8-1-windows-server-2012-r2-update-kb4034681

2017-08-24 Thread David Ringsmuth via 4D_Tech
Thanks Tim!!!  

David Ringsmuth

From: Timothy Penner via 4D_Tech
Sent: Thursday, August 24, 2017 12:27 PM
To: 4D iNug Technical
Cc: Timothy Penner
Subject: RE: windows-8-1-windows-server-2012-r2-update-kb4034681

Also, there seems to be some known issues with Wireless and KB4034681...

The KB article says:
"NPS authentication may break, and wireless clients may fail to connect."

There is a workaround for the NPS issue on the KB article.

See also:
https://www.reddit.com/r/sysadmin/comments/6u3gi3/careful_with_kb4034681_windows_71817_patch/

-Tim



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

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

windows-8-1-windows-server-2012-r2-update-kb4034681

2017-08-24 Thread David Ringsmuth via 4D_Tech
https://support.microsoft.com/en-us/help/4034681/windows-8-1-windows-server-2012-r2-update-kb4034681

This update on a SurfacePro running Windows 8.1 stopped 4D v15.2 Remote and 4D 
v15.2 Volume desktop from working.

I had to uninstall the update to allow 4D to work again.

David Ringsmuth

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

OSX absolute and relative path

2017-08-30 Thread David Ringsmuth via 4D_Tech
OS X  10.12.6
4D is  15.4
Compiled Built app

On one OSX when creating a file an attempting to launch it the path does not 
contain the Macintosh HD, it begins with file:///userName/...

On another OSX the exact same command to create the file with path begins with 
the hard drive name: file://Macintosh%20HD/userName/...

Could it be how the users are logged onto the computer?

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

RE: Min/Max for Date Fields in 4D

2017-10-11 Thread David Ringsmuth via 4D_Tech
Alan,

Sort the selection by the Date field, take the first Date, and then goto 
selected record (table;records in selection(table)), and get that Date.

This avoids loading much, except the date field sort.

Hth!

David Ringsmuth

From: Alan Tilson via 4D_Tech
Sent: Wednesday, October 11, 2017 4:30 PM
To: 4D iNug Technical
Cc: Alan Tilson
Subject: Min/Max for Date Fields in 4D

Greetings everyone,

Is there a way to get the earliest and latest dates from a selection of
records similar to using Min/Max for numerical data?

I have sorted the data and captured the first and last dates but this seems
rather a lot of work to get this info.

I believe that I have also used Selection To Array to capture the dates in
the array and then sorted the array.

Surely there is something I've overlooked?

Currently using v13.6.

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

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

RE: Connection is broken, cannot receive request reply

2017-11-15 Thread David Ringsmuth via 4D_Tech
Alan,

SET DATABASE PARAMETER(54;4)

This is for testing, wanted to make sure 4D closed the connection, not any 
network resource. But alas something is closing it and 4D Remote is crashing 
because of it. 

The crash occurs both after a long time of idle, and when the users are 
actively interacting in the application.

The SET DATABASE PARAMETER(14;1) AND SET DATABASE PARAMETER(13;1) seem to have 
made the idle error occur after a longer delay on our test network. But the 
error continues to occur both on our network, and on our client’s network.

We have not solved this problem.

We plan to open a tech support case…

Thanks!

David Ringsmuth

From: Alan Chan via 4D_Tech
Sent: Tuesday, November 14, 2017 8:59 PM
To: 4d_tech@lists.4d.com
Cc: Alan Chan
Subject: Re: Connection is broken, cannot receive request reply

Just curious, 4 seconds for idle connections timeout?

Alan Chan

4D iNug Technical <4d_tech@lists.4d.com> writes:
>SET DATABASE PARAMETER(54;4)// Idle connections timeout

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

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

RE: Connection is broken, cannot receive request reply

2017-11-13 Thread David Ringsmuth via 4D_Tech
Lahav,

On our client network we do have a managed switch, but on our test network we 
don’t.

The same error happens on both networks.

David Ringsmuth

From: lists via 4D_Tech
Sent: Monday, November 13, 2017 11:48 PM
To: David Ringsmuth via 4D_Tech
Cc: lists
Subject: RE: Connection is broken, cannot receive request reply

Hi David,

Do you have a managed switch on this network?,  it is possible for a switch to 
close a connection with no traffic, which could also result in this message.

The usual wisdom dictate having the timeout set to less than the switch/router 
timeout to prevent the port closing without the application knowing this.  

Cheers,

Lahav

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David 
Ringsmuth via 4D_Tech
Sent: Monday, November 13, 2017 8:46 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: David Ringsmuth <davidi...@gmail.com>
Subject: Connection is broken, cannot receive request reply

It seems like something is closing the network connection.

I searched 4D Tech on gmane, read the docs on keeping the connection open, but 
after about 15 minutes of idle time, with no user activity, we get this error 
message (above and below).

A network semaphore with a 300 ms timeout is crashing.
When we remove the network semaphore, we crash on a QUERY in a different method.

This exact same error occurs on our client’s network.

I need help fixing this one.

A serious error occurred while a request was being sent to the server. You 
should quit or restart the database as soon as possible.

OSX 10.12.6 Sierra (both remote and server boxes) 4D Remote v15.5 built app 4D 
Server v15.5 built server SET DATABASE PARAMETER(13;1)// 4D Server timeout SET 
DATABASE PARAMETER(54;4)// Idle connections timeout

Prevent App Nap (checked on both 4D Server and 4D Remote Wake on WiFi in energy 
settings

Thanks!

David Ringsmuth

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

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

Connection is broken, cannot receive request reply

2017-11-13 Thread David Ringsmuth via 4D_Tech
It seems like something is closing the network connection.

I searched 4D Tech on gmane, read the docs on keeping the connection open, but 
after about 15 minutes of idle time, with no user activity, we get this error 
message (above and below).

A network semaphore with a 300 ms timeout is crashing.
When we remove the network semaphore, we crash on a QUERY in a different method.

This exact same error occurs on our client’s network.

I need help fixing this one.

A serious error occurred while a request was being sent to the server. You 
should quit or restart the database as soon as possible.

OSX 10.12.6 Sierra (both remote and server boxes)
4D Remote v15.5 built app
4D Server v15.5 built server
SET DATABASE PARAMETER(13;1)// 4D Server timeout
SET DATABASE PARAMETER(54;4)// Idle connections timeout

Prevent App Nap (checked on both 4D Server and 4D Remote
Wake on WiFi in energy settings

Thanks!

David Ringsmuth

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

cannot receive request reply (error)

2017-11-13 Thread David Ringsmuth via 4D_Tech
Timothy Penner,

Is this (PDF link below) completely valid today?

Has anything changed in 4D that would change this document?

http://kb.4d.com/assetid=76200

Thanks!

David Ringsmuth

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

RE: Connection is broken, cannot receive request reply

2017-11-14 Thread David Ringsmuth via 4D_Tech
Tim,

Our current test for the error still going at 3h+, and there is no error.

It was the SET DATABASE PAREMETER(14;1) that kept it going without an error.

I think the problem is solved!

THANKS!

David Ringsmuth

From: Timothy Penner via 4D_Tech
Sent: Tuesday, November 14, 2017 11:18 AM
To: 4D iNug Technical
Cc: Timothy Penner
Subject: RE: Connection is broken, cannot receive request reply

> On our client network we do have a managed switch, but on our test network we 
> don’t.
> The same error happens on both networks.

Have you found a network where the error does NOT occur?

If you have reproducible sample that causes the issue on multiple networks then 
then it sounds like the hard part is already done. I would suggest opening a 
case and submitting the sample for further assistance.

-Tim



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

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

The connection for this process has been disrupted or the connection could not be established

2017-10-24 Thread David Ringsmuth via 4D_Tech
The “Semaphore” function is crashing 4D Remote’s connection to 4D Server.

While(Semaphore("MySemaphore";300)) // ←- this line crashes
// more coding here
 End while

4D Remote v15.4 Built 32bit on OSX 10.9.5
4D Server v15.4 Built 32bit on OSX 10.9.5 8GB Ram Core 2 Duo

The Client-Server connections timeout is set to 5 minutes.
App-Nap is disabled on both Remote and Server.
Use legacy network layer is CHECKED

The Server computer console logs do not seem so show any entries related to 
this crash.
 
Please help!

David Ringsmuth

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

RE: SMTP error 10113 Error with Authentication

2018-01-24 Thread David Ringsmuth via 4D_Tech
Wayne,

I’m trying to remember what the resolution was. I’ve worked through a number of 
SMTP related things….

For one of the systems I support for SMTP relay we’ve begun using AWS SES, 
because it works, it’s fast, it’s cheap. (https://aws.amazon.com/ses/)

Hth, sorry for not remembering this specific incident….

David Ringsmuth

From: Wayne Stewart via 4D_Tech
Sent: Tuesday, January 23, 2018 9:15 PM
To: 4D iNug Technical
Cc: Wayne Stewart
Subject: Re: SMTP error 10113 Error with Authentication

Hi,

Did this sort the problem?


Regards,

Wayne


[image: --]
Wayne Stewart
[image: http://]about.me/waynestewart
<http://about.me/waynestewart>


On 11 May 2017 at 05:08, David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Tim,
>
> Great suggestion. At first I thought it did.
>
> The smtp auth password has only lowercase letters and numbers.
>
> It is using SSL (true) SMTP AUTH (true).
>
> I had that problem on another system. Special characters broke it.
>
> David Ringsmuth
>
> From: Timothy Penner via 4D_Tech
> Sent: Wednesday, May 10, 2017 1:34 PM
> To: 4D iNug Technical
> Cc: Timothy Penner
> Subject: RE: SMTP error 10113 Error with Authentication
>
> David,
>
> Just a wild guess - Is there a strange character in the password?
> If so, maybe the character is being handled differently on 4D Server?
> I don't know why this would be the case, I just thought it might give you
> something to investigate.
>
> -Tim
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

PagePro picture

2018-02-09 Thread David Ringsmuth via 4D_Tech
4D v15.4
PagePro 1.4.2 ©2009-2015
Windows 10
Source code

I’m trying to add a picture to a PagePro report.

Drag-n-drop, Camera tool, neither are working at this moment.

Suggestions please!

Thanks!

David Ringsmuth

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

RE: Off - Apple OS Server

2018-08-02 Thread David Ringsmuth via 4D_Tech
I recommend against using godaddy for email, compared with AWS SES.

David Ringsmuth

From: npdennis via 4D_Tech
Sent: Thursday, August 2, 2018 9:48 AM
To: Chip Scheide via 4D_Tech
Cc: npdennis
Subject: Off - Apple OS Server

With Apple removing many applications from future OS Servers I’m looking for 
some ideas for good replacements for the following:

Email. Web, VPN, DNS

Email - I’m thinking of using gmail but I don’t know if there is something 
better
Web - I’m thinking of using my ISP
DNS - I have my domain registered with GoDaddy, I’m thinking of using them for 
this
VPN - I’m thinking of purchasing a device

Any good ideas? What do you currently use?

Neil


--

**
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
**

RE: Off - Apple OS Server

2018-08-02 Thread David Ringsmuth via 4D_Tech
I recommend using AWS SES for email.

It costs a very little bit, but it’s fast and effective. Best I’ve found.

David Ringsmuth

From: npdennis via 4D_Tech
Sent: Thursday, August 2, 2018 9:48 AM
To: Chip Scheide via 4D_Tech
Cc: npdennis
Subject: Off - Apple OS Server

With Apple removing many applications from future OS Servers I’m looking for 
some ideas for good replacements for the following:

Email. Web, VPN, DNS

Email - I’m thinking of using gmail but I don’t know if there is something 
better
Web - I’m thinking of using my ISP
DNS - I have my domain registered with GoDaddy, I’m thinking of using them for 
this
VPN - I’m thinking of purchasing a device

Any good ideas? What do you currently use?

Neil


--

**
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
**

RE: Sending Text Messages From 4D

2018-08-22 Thread David Ringsmuth via 4D_Tech
Tim,

I’ve integrated https://www.data24-7.com/index.php#pricing into one 4D system.

It’s fairly cheap ($12/mo + $0.005 per lookup), and the lookups are stored 
locally, so they are one-time.

David Ringsmuth

From: Tim Nevels via 4D_Tech
Sent: Wednesday, August 22, 2018 9:04 AM
To: 4d_tech@lists.4d.com
Cc: Tim Nevels
Subject: Sending Text Messages From 4D

I have a client that has asked me to add the option to send text messages to 
cell phones from 4D. I know this is possible via some websites or web services 
for a fee. Has anyone done this and can recommend a web service that you were 
able to use from 4D to do this?

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

**
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: What do you use to monitor your offsite servers?

2018-07-17 Thread David Ringsmuth via 4D_Tech
Robert,

We’ve used IsItUp for many years.

David Ringsmuth

From: Robert ListMail via 4D_Tech
Sent: Tuesday, July 17, 2018 1:10 PM
To: 4D iNug Technical
Cc: Robert ListMail
Subject: Re: What do you use to monitor your offsite servers?

I saw that thread and thought I read it thoroughly, wasn’t that about remote 
access and administration of computers not on your local network? I’m looking 
to be notified that a server is no longer responding... a server that has 
crashed or is down or unreachable for some reason. Isn’t that a different 
subject matter?

Thanks,

Robert 

Sent from my iPhone

> On Jul 16, 2018, at 12:01 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> you might also be interested in:
> 
> Alternative à RDP (http://forums.4d.com/Post/FR/24803223/1/24818538#24818538)
> 
> which mentions
> 
> TSPLUS (https://www.tsplus.net/)
> guacamole (https://guacamole.apache.org/)
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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
**

**
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: What do you use to monitor your offsite servers?

2018-07-16 Thread David Ringsmuth via 4D_Tech
Kirk,

Connectwise (ScreenConnect) is the best replacement for LogMeIn.

Cheaper, more features.

But if you share your account, only 1 user can use it at a time. LogMeIn 
allowed me to share subsets of computer access without paying more.

David Ringsmuth

From: Kirk Brooks via 4D_Tech
Sent: Sunday, July 15, 2018 3:27 PM
To: 4D iNug Technical
Cc: Kirk Brooks
Subject: What do you use to monitor your offsite servers?

I've been using LogMeIn for a few years. It was great at $100/year. It was
OK at $200/year but now it's going up to $350/year and it's time to loo for
something else.

Suggestions?

-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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)
FAQ:  http://lists.4d.com/faqnug.html
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: 4DIC - Hiding the authentication username in outgoing emails

2018-07-18 Thread David Ringsmuth via 4D_Tech
David,

If you don’t have to do it through that account, you map be able to use AWS SES.

David Ringsmuth

From: David Rose via 4D_Tech
Sent: Wednesday, July 18, 2018 2:47 PM
To: 4d_tech@lists.4d.com
Cc: David Rose
Subject: 4DIC - Hiding the authentication username in outgoing emails

I posted a question on this topic a while back but didn't find a solution, so I 
am posting again...

In a 4D v15 application for Windows I want to use just one gmail account for 
authenticating all outgoing emails, but allow a variety of senders to send 
emails that are seen in the recipients' email clients as coming from the 
senders' individual accounts, not from the authentication account. I haven't 
found a way to do that. The following combination of values results in the 
SMTP_Auth username showing up as the sender in the recipient's email client:

SMTP_Auth username: auth-em...@gmail.com
SMTP_From: from-em...@gmail.com
SMTP_Sender: from-em...@gmail.com
SMTP_ReplyTo: from-em...@gmail.com

Is there a way to do this?
David

**
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
**

Storage + New shared object

2018-09-01 Thread David Ringsmuth via 4D_Tech
I’m trying to add an object array to Storage.

The documentation says that Objects can be a share storage value.

I keep getting the message “Not supported value type in a shared object or 
shared collection.”

In the below code I broke apart the assignments for easiest debugging.

ARRAY TEXT($DeleteRecord;Get last table number)
ARRAY LONGINT($DeleteRecord_PN;Get last table number)

C_OBJECT($DeleteRecord_ob)
OB SET ARRAY($DeleteRecord_ob;"DeleteRecord";$DeleteRecord)

C_OBJECT($DeleteRecord_PN_ob)
OB SET ARRAY($DeleteRecord_PN_ob;"DeleteRecord_PN";$DeleteRecord_PN)

C_OBJECT($Delete_ob;$Delete_PN_ob)

Use (Storage)
Storage.t:=New shared 
object("DeleteRecord";$Delete_ob;"DeleteRecord_PN";$Delete_PN_ob)
End use 
Use (Storage.t)
Storage.t.DeleteRecord:=$DeleteRecord_ob // this line generated the 
error message
Storage.t.DeleteRecord_PN:=$DeleteRecord _PN_ob// so does this line 
error with same message
End use

Please help!

David Ringsmuth

**
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: Storage + New shared object

2018-09-04 Thread David Ringsmuth via 4D_Tech
Lahav, (and Christian, and Keisuke Miyako)

THANK YOU!

David Ringsmuth

From: lists via 4D_Tech
Sent: Saturday, September 1, 2018 11:03 PM
To: 4D iNug Technical
Cc: lists
Subject: RE: Storage + New shared object

Hi David,

First Both, $DeleteRecord_ob and $DeleteRecord_PN_ob must be a shared objects.  
Also, it seems that shared objects do not accept arrays.  Convert the arrays to 
shared collections instead.

This should work:

ARRAY TEXT($DeleteRecord;Get last table number)
ARRAY LONGINT($DeleteRecord_PN;Get last table number)

C_COLLECTION($t)
$t:=New shared collection
ARRAY TO 
COLLECTION($t;$DeleteRecord;"DeleteRecord";$DeleteRecord_PN;"DeleteRecord_PN")

Use (Storage)
Storage.t:=$t
End use

Lahav

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of David Ringsmuth via 
4D_Tech
Sent: Saturday, September 1, 2018 9:36 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: David Ringsmuth 
Subject: Storage + New shared object

I’m trying to add an object array to Storage.

The documentation says that Objects can be a share storage value.

I keep getting the message “Not supported value type in a shared object or 
shared collection.”

In the below code I broke apart the assignments for easiest debugging.

ARRAY TEXT($DeleteRecord;Get last table number) ARRAY 
LONGINT($DeleteRecord_PN;Get last table number)

C_OBJECT($DeleteRecord_ob)
OB SET ARRAY($DeleteRecord_ob;"DeleteRecord";$DeleteRecord)

C_OBJECT($DeleteRecord_PN_ob)
OB SET ARRAY($DeleteRecord_PN_ob;"DeleteRecord_PN";$DeleteRecord_PN)

C_OBJECT($Delete_ob;$Delete_PN_ob)

Use (Storage)
Storage.t:=New shared 
object("DeleteRecord";$Delete_ob;"DeleteRecord_PN";$Delete_PN_ob)
End use
Use (Storage.t)
Storage.t.DeleteRecord:=$DeleteRecord_ob // this line generated the 
error message
Storage.t.DeleteRecord_PN:=$DeleteRecord _PN_ob// so does this line 
error with same message End use

Please help!

David Ringsmuth

**
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
**

**
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: Converting pictures on 4D forms (Windows) to get transparency

2018-07-09 Thread David Ringsmuth via 4D_Tech
Bob,

I use Paint.net. It’s shareware.

I have used it many times to create a transparent background.

David Ringsmuth

From: Bob Miller via 4D_Tech
Sent: Monday, July 9, 2018 10:20 AM
To: 4d_tech@lists.4d.com
Cc: Bob Miller
Subject: Converting pictures on 4D forms (Windows) to get transparency

Hi Everyone,

I'm in the process of going through a database to convert all the 
pictures, icons, and such in it so I can use the database with 64-bit 4D 
v16 (and eventually v17).

The documentation is pretty clear that even though any images pasted in 
did not start life as PICTS - and I'm talking about things like arrows, 
some icons, line drawings, navigation tools, etc., that are part of the 
user interface, not actual photo type pictures -  4D would receive and 
store them as PICTS, so you have to find each one and convert it.

To do this, I'm using JPR's Picture Conversion utility that he provided on 
the 2017 4D Road Tour.  It does a fine job as it can scan all the forms, 
find the offending pictures, list them, and then provides a utility where 
you can either convert them and put them into the picture library or 
convert them and put them into an external folder.
 
One thing I'm finding is that the conversion doesn't support transparency, 
so I end up with pictures that have white backgrounds, which doesn't look 
nice.  Here is part of a thread from me to JPR:

Me: When I drag a Static Picture to the converter, then back to the form, 
it seems to lose its transparency, even though the 'Transparent' property 
is turned ON.  How can this be fixed?
JPR> It cannot. The transparency done previously by 4D was just a trick 
replacing the white pixels with the background color dynamically, because 
the concept of transparency didn't exist at this time (like in PICT, JPEG, 
etc.) 
JPR> Now 4D uses the modern toolbox which relies on the picture 
transparency information coming from the alpha channel. So if you want 
transparent pictures, you must convert into a format supporting alpha 
channel (like PNG) and use any software able to add the alpha layer to 
your pictures.  On Mac, the simplest one to add alpha channel is 
PaintBrush (from Soggy Waffles). You add transparency with the paint Fill 
tool


The problem is that I'm on Windows.  Does anyone have a recommendation for 
fast technique that they've used that supports this "alpha channel' so I 
can convert my non-transparent images so that they are transparent again? 
It looks so bad having an arrow on a form with a big white background.

Thank you -


Bob Miller
Chomerics, a division of Parker Hannifin Corporation 


ll
"PLEASE NOTE: The preceding information may be confidential or privileged. It 
only should be used or disseminated for the purpose of conducting business with 
Parker. If you are not an intended recipient, please notify the sender by 
replying to this message and then delete the information from your system. 
Thank you for your cooperation."
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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)
FAQ:  http://lists.4d.com/faqnug.html
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: MailJet

2018-03-07 Thread David Ringsmuth via 4D_Tech
Pat,

That’s why Amazon Web Services, Simple Email Solution works!

It’s fast, reliable, and allows sending 50K emails a day, or more if you need.

And it’s $0.10/1000 emails.

David Ringsmuth

From: Pat Bensky via 4D_Tech
Sent: Wednesday, March 7, 2018 10:12 AM
To: 4D iNug Technical
Cc: Pat Bensky
Subject: Re: MailJet

One reason to use a mailing service instead of 4D is - as I recently
discovered - if you send a large number of emails in a batch (let's say
more than 500) your service provider is likely to block them, as it may
appear that your account has been hijacked by a spammer.

I'm not familiar with MailJet so I can't speak for them, but the service we
use (Aweber) offers lots of useful features such as tracking who clicked on
which links in the emails. It would be a lot of work to do that with a
4D-generated email.

HTH!
Pat

On 7 March 2018 at 02:43, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I’ve inherited a project that’s been setup to send email via MailJet. I’m
> having a problem where a newly defined CC email address will not be
> delivered via MailJet unless another test email address is specified as a
> CC as well. So, I have to ask, why might you use a service like MailJet
> when sending email from 4D? Why might the new CC not stand on it’s own?
>
> Thanks,
>
> Robert
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
*
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)
FAQ:  http://lists.4d.com/faqnug.html
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)
FAQ:  http://lists.4d.com/faqnug.html
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 data on the web - what do you use?

2018-03-14 Thread David Ringsmuth via 4D_Tech
We’ve put Wakanda in front of 4D.

On front end uses Angular, another uses many widgets and nodeJS running in 
Wakanda.

David Ringsmuth

From: Keith Goebel via 4D_Tech
Sent: Wednesday, March 14, 2018 3:08 AM
To: 4D Tech Mailing List Technical
Cc: Keith Goebel
Subject: 4D data on the web - what do you use?

Hi all. 
We have an extensive 4D system to which we want to provide summary overviews 
and drill-downs via the web.
I have a couple of questions I'm hoping somebody will be able to answer...

Are you using 4Dv16 in a client server environment as well as providing a web 
interface to the data?
If so, we would like to know what software and plugins do you use to make the 
web environment happen?
- software and plugins for development?
- software and plugins for deployment?
- are you able to do the web development without getting the 4D programmer(s) 
involved (apart from describing the data structure)?
Thanks in advance, Keith


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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)
FAQ:  http://lists.4d.com/faqnug.html
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: Where can I find 4D Internet Commands (for v16)?

2018-03-23 Thread David Ringsmuth via 4D_Tech
Bob,

They my be in the full installer…. Download from 4d.com

David Ringsmuth

From: Bob Miller via 4D_Tech
Sent: Wednesday, March 21, 2018 3:00 PM
To: 4d_tech@lists.4d.com
Cc: Bob Miller
Subject: Where can I find 4D Internet Commands (for v16)?

Hi Jim,

I feel a bit silly, but I've just killed an hour looking for the v16 
version of "4D Internet Commands".The v16 Conversion manual specifies 
there are differences between v15 and v16, so I presume there is a v16 
version out there, but I don't see it on the FTP site (mostly old stuff at 
ftp://ftp.4d.com/ - and ftp://ftp.4d.com/PRODUCTS/Current/ contains v14.x 
stuff), nor is it listed at http://www.4d.com/products/4dv16.html

Search on the site didn't find anything newer than v

forums.4d.fr has always confused me, but I couldn't find it there, either.

Is there a new 4D Pack for v16, or have all the 4D Pack commands now been 
built in?

thanks -


Bob Miller
Chomerics, a division of Parker Hannifin Corporation


ll
"PLEASE NOTE: The preceding information may be confidential or privileged. It 
only should be used or disseminated for the purpose of conducting business with 
Parker. If you are not an intended recipient, please notify the sender by 
replying to this message and then delete the information from your system. 
Thank you for your cooperation."
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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)
FAQ:  http://lists.4d.com/faqnug.html
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 v16.4 Built database won't open in Mojave

2018-11-06 Thread David Ringsmuth via 4D_Tech
Walt,

The first thing that came to me was that it seems like a permissions problem.

If you can figure out the path the data file writing, try a variety of 
permissions settings for that location, file, user, application….

On this topic, Stackoverflow may help more than this nug.

David Ringsmuth

From: Walt Nelson via 4D_Tech
Sent: Sunday, November 4, 2018 7:30 PM
To: Dani Beaubien via 4D_Tech
Cc: Walt Nelson
Subject: 4D v16.4 Built database won't open in Mojave

Folks,

I have built a stand-alone Application v16.4 database on a Mac OS machine 
running High Sierra (10.13.6).

I successfully create an empty datafile and run it on the same High Sierra 
(10.13.6) machine.

I transfer the entire stand-alone built database to a laptop running Mojave 
(10.14).

When opening that database, I get the following error: ‘You cannot open this 
database because the data file (or one of its segments) is locked.’ with an OK 
button.

Click OK.

Get a runtime error showing:

Error

Can't open database “DatabaseName.4DC".

Error code: -10509
Can't open database "DatabaseName.4DC".
component: '4DRT'
task -1, name: 'Application process’

When I check the permissions on that file, it is read/write.

Anyone getting a built stand-alone Application for v16.4 to run in Mojave?

Thanks,
Walt

**
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
**

SSL Internal error

2018-11-13 Thread David Ringsmuth via 4D_Tech
It was the public.pem.

It should not be named .pem in the structure folder.



David Ringsmuth

**
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 Server Web Start Server SSL Error 49: srvr: SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line

2018-11-13 Thread David Ringsmuth via 4D_Tech
OSX 10.13.6, 16GB RAM
4D Server 15.6.222813

On launch gives this error:
Undefined Database Event.  [-1] in the method 'A4D_Init', on line 77, Err 
Stack: [49] Method: A4D_Init
Line: 77
49: srvr: SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no 
start line
49: srvr: SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no 
start line
46: srvr: Failed to set SSL certificate

But the SSL Server works, so the certs are valid and working, the line endings 
are all char(10), the begin/end certificate lines all appear correct. I did not 
verify the chained cert sequence (user/intermediate/ca root).

Same cert/key documents work on Windows 10, 4D v15.6 without any error.

Please help!

David Ringsmuth

**
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 Write Pro (WP) Area and ST INSERT EXPRESSION

2018-10-09 Thread David Ringsmuth via 4D_Tech
Insert expression and Get expression seem to not be pre-implemented in the 4D 
v17 Write Pro area.

The documentation indicates this should be managed by the developer, along with 
“Allowed Methods”.

I think the UI for this provide access to allowed tables, fields, methods and 
commands.

If you have already implemented this for a 4D WP area, would you be willing to 
share how you did it?

Thanks!

David Ringsmuth

**
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 v17 R2 Object Library Write Pro Toolbar

2018-10-10 Thread David Ringsmuth via 4D_Tech
We received the update notice and downloaded 4D v17 R2. (build 17.225365)

The Write Pro tool bar shown in the video, which is positioned above the 
WriteProArea, does not appear in the object library.

There is a Write Pro Widget that appears to the right of the Write Pro area.

Where may we find the tool bar that fits above the WritePro area?

David Ringsmuth
**
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: 4D v17 R2 Object Library Write Pro Toolbar

2018-10-10 Thread David Ringsmuth via 4D_Tech
The link that says, “Download 4D v17R2” at the bottom of the v17 R2 form 
(https://us.4d.com/new-4d-v17-r2) does not point to v17 R2. It points to v17.

Perhaps that’s why I downloaded the wrong build.

I should have looked closer.

Thanks Keisuke!!

David Ringsmuth

From: Keisuke Miyako via 4D_Tech
Sent: Wednesday, October 10, 2018 10:30 PM
To: 4D iNug Technical
Cc: Keisuke Miyako
Subject: Re: 4D v17 R2 Object Library Write Pro Toolbar

the release version of 17R2 has the build number: 227919
could that be the issue?

> 2018/10/11 12:08、David Ringsmuth  のメール:
> 4D v17 R2. (build 17.225365)




**
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
**

RE: 4D v17 R2 Object Library Write Pro Toolbar

2018-10-10 Thread David Ringsmuth via 4D_Tech
Keisuke,

There is no subform object named “WP_Toolbar” 4D v17 R2. (build 17.225365)

There are many “4D_Palette” subform objects. None of them are the horizontal 
tool bar.

Please help!

David Ringsmuth

From: Keisuke Miyako via 4D_Tech
Sent: Wednesday, October 10, 2018 7:23 PM
To: 4D iNug Technical
Cc: Keisuke Miyako
Subject: Re: 4D v17 R2 Object Library Write Pro Toolbar

you create a non list subform object and set the "detail form" property to 
"WP_Toolbar" (Write Pro Interface)

default size is 90h x 880w.

https://blog.4d.com/4d-write-pro-a-new-bar-is-born/

2018/10/11 3:48、David Ringsmuth via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
We received the update notice and downloaded 4D v17 R2. (build 17.225365)
The Write Pro tool bar shown in the video, which is positioned above the 
WriteProArea, does not appear in the object library.
There is a Write Pro Widget that appears to the right of the Write Pro area.
Where may we find the tool bar that fits above the WritePro area?
David Ringsmuth


**
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
**

Write Pro print preview

2018-12-31 Thread David Ringsmuth via 4D_Tech
4D v17 R2 32bit and 64bit
Windows 10 (current)

At first and sometimes while using different features, I get a print preview.

But now I mostly get a Save File dialog when executing WP Print.

$pdfprintername:="Microsoft Print to PDF"
…
SET CURRENT PRINTER($pdfprintername)
SET PRINT OPTION(Destination option;3;$pdfpath)// pdfpath is a valid path to 
the temporary folder and a unique new file name.
SET PRINT PREVIEW(True)
WP USE PAGE SETUP($WP_Area_ob)
WP PRINT($WP_Area_ob;wk html wysiwyg)

Amazingly when using the library toolbar for WP, there is a “Print Preview” 
button with a “Standard Action” of “Print” that does a print preview. So the 
form’s sub-form standard action of “print” does a print preview? Yup.

I need it to always work correctly.

Please help!

Thanks!

David Ringsmuth

**
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: Write Pro print preview

2018-12-31 Thread David Ringsmuth via 4D_Tech
SET PRINT OPTION(Destination option;2;$pdfpath)

“2” seems to do a print preview.



David Ringsmuth

From: David Ringsmuth
Sent: Monday, December 31, 2018 9:32 AM
To: 4D iNug Technical
Subject: Write Pro print preview

4D v17 R2 32bit and 64bit
Windows 10 (current)

At first and sometimes while using different features, I get a print preview.

But now I mostly get a Save File dialog when executing WP Print.

$pdfprintername:="Microsoft Print to PDF"
…
SET CURRENT PRINTER($pdfprintername)
SET PRINT OPTION(Destination option;3;$pdfpath)// pdfpath is a valid path to 
the temporary folder and a unique new file name.
SET PRINT PREVIEW(True)
WP USE PAGE SETUP($WP_Area_ob)
WP PRINT($WP_Area_ob;wk html wysiwyg)

Amazingly when using the library toolbar for WP, there is a “Print Preview” 
button with a “Standard Action” of “Print” that does a print preview. So the 
form’s sub-form standard action of “print” does a print preview? Yup.

I need it to always work correctly.

Please help!

Thanks!

David Ringsmuth


**
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: WritePro expression undefined

2018-12-27 Thread David Ringsmuth via 4D_Tech
Add,

Your timing is perfect!

I missed that until you emailed.

Life is justly humbling.

Thanks!

David Ringsmuth

**
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
**

method call chain and collection.indexOf

2019-01-14 Thread David Ringsmuth via 4D_Tech
For debugging I like method call chains.

Now in v17 with collections, they are easy.

Collection.push(current method name)
// method here!
$TrashThis_t:=Collection.pop()

I found while using the call chain collection that the 
collection.indexof(“Value”) does compile, but it does not work, because 
.indexOf must have a capital “O”.

This is like emca script!

Beware!



David Ringsmuth

**
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 WritePro Toolbar xliff

2018-12-17 Thread David Ringsmuth via 4D_Tech
4D v17 32bit 17.2.0.0 227919
WP_Toolbar

The tab titles show:

:xliff:Home
:xliff:insertAndView
:xliff:margins
:xliff:borders
:xliff:images
:xliff:printing
:xliff:spell

I dragged the WP_Toolbar into this database from another v17 structure that 
correctly shows the WP_Toolbar tab titles.

I compared the to form properties and they appear to be the same.

Please help!

Thanks!

David Ringsmuth

**
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
**

WritePro expression undefined

2018-12-20 Thread David Ringsmuth via 4D_Tech
4D v17.2.0.0 227919 R2 32bit or 64bit
Windows 10 Home 1803

WP PRINT(Rpt_ob;wk 4D Write Pro layout)
SET ALLOWED METHODS included “QUERY”

4D Query command expressions appear as “Undefined” in the printed document. The 
command appears successful.

Please help!

Thanks!

David Ringsmuth

**
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: WritePro expression undefined

2018-12-20 Thread David Ringsmuth via 4D_Tech
John,

WritePro documents may contain references to [Table]Field, which requires that 
the record be present during printing, which may require QUERY commands.

The embedded QUERY commands work, execute properly in WritePro.

But in place of the embedded expression is the value “Undefined”.

We have hundreds of converted documents with queries in them that worked 
correctly in 4D Write. There they executed and did not display “Undefined” in 
the 4D Write document. These should not have to be wrapped commands to work 
without an “Undefined” appearing in the WritePro document.

This in new and apparently wrong behavior in WritePro.

If this is not an error in WritePro, and if it is the intended operation of 
WritePro, then it is a warning to everyone converting from 4D Write documents.

David Ringsmuth

From: John DeSoi via 4D_Tech
Sent: Thursday, December 20, 2018 10:38 AM
To: 4D iNug Technical
Cc: John DeSoi
Subject: Re: WritePro expression undefined

SET ALLOWED METHODS specifies project methods allowed, not 4D commands. So 
unless you named a project method the same as the 4D command QUERY, you are 
using it wrong. And the 4D command QUERY does not return a result, so I'm not 
sure how you would use that in an expression. Of course, you can write a 4D 
project method that uses QUERY and returns a result in $0 as the result of the 
4D Write expression.

John DeSoi, Ph.D.


> On Dec 20, 2018, at 9:30 AM, David Ringsmuth via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> WP PRINT(Rpt_ob;wk 4D Write Pro layout)
> SET ALLOWED METHODS included “QUERY”
> 
> 4D Query command expressions appear as “Undefined” in the printed document. 
> The command appears successful.
> 
> Please help!

**
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
**

RE: WritePro expression undefined

2018-12-20 Thread David Ringsmuth via 4D_Tech
John,

We can manually limit the entry of commands and methods, since we control the 
UI that inserts expressions. It would be easier is the command SET ALLOWED 
METHODS did this for us automatically.

Thanks for your help John!

David Ringsmuth

**
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: WritePro expression undefined

2018-12-20 Thread David Ringsmuth via 4D_Tech
John,

We opened a case with 4D.

WritePro optionally displays expressions, or their calculated values.

We may have to parse the converted WritePro objects to replace queryies with a 
call formatted like:

Query_ (->[Student];->[Student]AccountNo;"=";->[Account]AccountNo)
…which does…
QUERY($Table_p->;$Field_p->;$Operator_t;$Value_p->)

It’s a bug. WritePro should not show “Undefined” as the result of a embedded 
query expression.

SET ALLOWED COMMANDS should also work for 4D commands, since if a user is 
allowed to enter expressions, than those expressions should be restrictable.

David Ringsmuth

From: John DeSoi via 4D_Tech
Sent: Thursday, December 20, 2018 11:43 AM
To: 4D iNug Technical
Cc: John DeSoi
Subject: Re: WritePro expression undefined

I see two options:

1. Submit a bug/feature request to 4D and hope they change it to return nothing 
instead of "Undefined".

2. Replace all of your QUERY commands with a method that returns an empty 
string.

I don't use 4D Write Pro, but I think automating the replacement in 4D Write 
before conversion should not be too difficult. I also think it would be a win 
over the way you are doing it because having the project method shows the 
queries, tables, and fields in the design environment referencing. You lose 
that visibility by embedding queries directly in 4D Write documents.

Maybe that does not work if you have end users writing their own queries for 4D 
Write. That seems dangerous to me.

John DeSoi, Ph.D.


> On Dec 20, 2018, at 11:01 AM, David Ringsmuth  wrote:
> 
> We have hundreds of converted documents with queries in them that worked 
> correctly in 4D Write. There they executed and did not display “Undefined” in 
> the 4D Write document. These should not have to be wrapped commands to work 
> without an “Undefined” appearing in the WritePro document.
>  
> This in new and apparently wrong behavior in WritePro.
>  
> If this is not an error in WritePro, and if it is the intended operation of 
> WritePro, then it is a warning to everyone converting from 4D Write documents.
> 

**
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
**

RE: WritePro expression undefined

2018-12-23 Thread David Ringsmuth via 4D_Tech
Tim!

We have great support from 4D! (Erick)

This is an effective 4D tech support work-around to the problem of “Undefined”.

Here “WParea” is a 4D Write Pro object.

After running this method on our converted 4D Write to 4D Write Pro documents, 
none of the embedded statements return “Undefined”.

It wraps all embedded expressions in an ‘eval(“….”)’. I did not find “eval” as 
a 4D command, but it works!

Off-Topic: Lastly, I must conceive a way to convert the embedded picts…
//-
C_OBJECT($range)
C_LONGINT($start;$end;$i;$type)
C_TEXT($text;$Newtext)

WP SELECT(WParea;wk start text;wk end text)
$range:=WP Get selection(WParea)
$start:=OB Get($range;"start")
$end:=OB Get($range;"end")

ARRAY TEXT($methodArray;0)
APPEND TO ARRAY($methodArray;"eval")
SET ALLOWED METHODS($methodArray)

For ($i;$start;$end)

$type:=ST Get content type(*;"WParea";$i;$i)

If ($type=2)  // found expression
$text:=ST Get expression($range;$i;$i)
$text:=Replace string($text;"\"";"\\\"")
$Newtext:="eval ("+"\""+$text+"\""+")"
ST INSERT EXPRESSION(*;"WParea";$Newtext;$i;$i+1)
End if 

End for

//---

If you observe it, MERRY CHRISTMAS



David Ringsmuth

**
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: WritePro expression undefined

2018-12-22 Thread David Ringsmuth via 4D_Tech
Tim!

Thanks!!!

I’m about to evaluate a work-around from the faithful tech support team…



David Ringsmuth

**
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: Active4D/ObjectTools with 4D 32-bit

2018-12-10 Thread David Ringsmuth via 4D_Tech
Aparajita,

About Active4D, to answer your question well requires researching the reasons 
for it.

I support sites using OSX 4D Server running Active4D, some of which are 
probably running 32bit, but I’m not sure they must run 32 bit. (would you mind 
describing the barriers/issures here?)

We are in the processing of upgrading to v17, which in our case requires 64 bit 
on the Client.

I have preferred to run 64 bit where every possible on our 4D Servers.

I wish this was a better answer for you.

David Ringsmuth

From: Aparajita Fishman via 4D_Tech
Sent: Monday, December 10, 2018 12:56 PM
To: 4d_tech@lists.4d.com
Cc: Aparajita Fishman
Subject: Active4D/ObjectTools with 4D 32-bit

Hi,

Just wondering how many Active4D or ObjectTools users out there *must* use 
32-bit 4D on macOS for the foreseeable future.

I need to know how much longer I need to support 32-bit versions of my plugins 
on macOS.

Many thanks,

- Aparajita


**
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
**

How to process all WritePro area expressions for replacement / update?

2018-12-21 Thread David Ringsmuth via 4D_Tech
I need some code that will process a 4D WritePro area, updating existing 
embedded expressions, replacing them with a different expression.

The command to get an expression, ST Get expression, works on only some 
expressions - data structure only like: [Table]Field.

Editing a WritePro area using the WP Get text returns stylized text, and all 
expressions have a “-d4-ref:’expression_here’”, but these are html and 4D 
command number added expressions.





Even if I replaced the expressions using the WP Get text and updated with WP 
Set Text, we loose embedded pictures. So this wont work for me.

David Ringsmuth

**
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: WritePro expression undefined

2018-12-21 Thread David Ringsmuth via 4D_Tech
Add,

4D Write expressions did not require a value to be returned, so it was 
acceptable to have embedded Query, Create Set, Intersection, Union, Use Set, 
Selection to Array, etc…, commands in the 4D Write document.

Converted to WritePro, the same expressions return “Undefined”.

It is a change in behavior that requires editing 1000’s of documents.

And WritePro does not provide an easy way to replace those expressions with a 
method call that will not return “Undefined”.

David Ringsmuth

From: Add Komoncharoensiri via 4D_Tech
Sent: Friday, December 21, 2018 11:56 AM
To: 4D iNug Technical
Cc: Add Komoncharoensiri
Subject: Re: WritePro expression undefined

Hi David,

If you are insert an expression into a 4D Write Pro document, the expression 
should return a value.

For example:
100+90
Current date
projectMethodThatReturnAValue

For QUERY command, the execution will produce a selection of record in memory. 
It does not return a value that can be inserted to the document.

Regards,
Add




On 12/20/18, 2:05 PM, "4D_Tech on behalf of David Ringsmuth via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

John,

We can manually limit the entry of commands and methods, since we control 
the UI that inserts expressions. It would be easier is the command SET ALLOWED 
METHODS did this for us automatically.

Thanks for your help John!

David Ringsmuth

**
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
**

**
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
**

Menubar 1

2019-02-20 Thread David Ringsmuth via 4D_Tech
4D v17R4 2323298 64bit Remote
OSX 10.16+

At the end of my startup method Menubar 1 is displayed. 

On some client machines the menu items are not “active”. When selected they do 
not run the assigned method.

On other client machines running the same application at the same time, all 
items on Menubar 1 are active. When selected they run the assigned method.

Suggestions?

Thanks!!

David Ringsmuth

**
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: user-agent html formatting on android outlook

2019-02-26 Thread David Ringsmuth via 4D_Tech
Keisuke,

Prior to my post I read that the tags may have been removed by the 
device/user-agent.

I was looking for either support for my suspicion or a possible fix.

You are providing support!

If I can’t fix it, then your support helps me make that case.

Thanks!

David Ringsmuth

From: Keisuke Miyako via 4D_Tech
Sent: Tuesday, February 26, 2019 10:16 PM
To: 4D iNug Technical
Cc: Keisuke Miyako
Subject: Re: user-agent html formatting on android outlook

are you sure this is actually an issue specific to Active4D?

it is not uncommon for mail servers or even clients to automatically create 
plain text versions of an HTML message.

it sounds like your tags have been removed that way.

you might want to widen your scope of investigation to search for information 
on android / outlook in general.

> 2019/02/27 5:12、David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com>のメール:
>
> My 4Dv17/Active4D application has a web form with some minimal attribute.
>
> Bold, Sized text with  at the line endings.
>
> The text displays correctly on most user-agents.
>
> On the android using the outlook application as a web user-agent. the text is 
> displayed with no formatting, a large single paragraph with no line endings 
> 
>
> I need suggestions to fix this for the android outlook app user-agent.




**
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
**

user-agent html formatting on android outlook

2019-02-26 Thread David Ringsmuth via 4D_Tech
My 4Dv17/Active4D application has a web form with some minimal attribute.

Bold, Sized text with  at the line endings.

The text displays correctly on most user-agents.

On the android using the outlook application as a web user-agent. the text is 
displayed with no formatting, a large single paragraph with no line endings 

I need suggestions to fix this for the android outlook app user-agent.

Thanks!

David Ringsmuth

**
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: Apple Notary Service

2019-03-15 Thread David Ringsmuth via 4D_Tech
Cannon,

I helped my client do this.

Get the basic Apple developer program ID ($99/year)

Follow their instructions to generate a certificate for your application.

We provided the CSR to the process. They provided the certificate after a few 
days.

hth

David Ringsmuth

From: Cannon Smith via 4D_Tech
Sent: Friday, March 15, 2019 11:24 AM
To: 4D iNug Technical
Cc: Cannon Smith
Subject: Apple Notary Service

Has anyone tried to notarize a built 4D application with Apple yet? Is it 
possible with 4D?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Aetna, AB Canada




**
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
**

RE: Named Selections

2019-02-08 Thread David Ringsmuth via 4D_Tech
Chip,

We did this same things with sets by using an On Err 
Call(“Error_SetDoesNotExist”).

Write an On Err Call for Named Selections, and then use it, and test the result 
of your call error handler.

Hth!

David Ringsmuth

From: Chip Scheide via 4D_Tech
Sent: Friday, February 8, 2019 11:52 AM
To: 4D iNug Technical
Cc: Chip Scheide
Subject: Named Selections

Is there a way to determine if a named selection exists?

something like this:

if (Not(Named Selection Exists("Selection_Name")))
  Copy Named Selection([table];"Selection_Name")
end if

Thanks
Chip

---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

[off] Project Request

2019-02-11 Thread David Ringsmuth via 4D_Tech
A customer of mine asked me to post this.

He has a project request using 4D’s REST API or Wakanda in front of 4D, 
creating a web-site that can replace an existing web site that is partially 
generated from Active4D.

If you are interested, and familiar with these tools, please contact me.

Thanks!
David Ringsmuth

**
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
**

use (storage)

2019-02-01 Thread David Ringsmuth via 4D_Tech
My test show that

Use(Storage)
….

Does not lock Storage.pref, and does not prevent Storage.pref from being 
updated in a separate process.

By lock, I mean that during use(Storage) in process A, use(Storage.pref) in 
process B will execute without waiting.

By update I mean that Storage.pref.test can be updated in process B when 
Storage is locked in process A.

I just want to make sure that Storage and it’s shared objects are intended to 
be used this way.

The documentation does not show examples of this.

The point is that locking should occur at the parent of the property being 
updated, not unnecessarily at the top level.

Is that correct?

Thanks!

David Ringsmuth

**
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: v17 Print Settings in a form's Property List

2019-04-15 Thread David Ringsmuth via 4D_Tech
David,

4Dv17R4 has:

Print Settings to Blob
Blob to Print Settings
https://doc.4d.com/4Dv17R4/4D/17-R4/Print-settings-to-BLOB.301-4055206.en.html
https://doc.4d.com/4Dv17R4/4D/17-R4/BLOB-to-print-settings.301-4055236.en.html

These combined with the name of the report being printed, the printer name, and 
the current user name, should work to make saving and restoring settings for 
repeatedly printed reports.

David Ringsmuth

From: David Rose via 4D_Tech
Sent: Wednesday, April 10, 2019 10:16 AM
To: 4d_tech@lists.4d.com
Cc: David Rose
Subject: Re: v17 Print Settings in a form's Property List

So in a 64-bit environment, how do you save paper size, orientation etc. with a 
form, so that PAGE SETUP ([MyTable];"MyForm") will load those settings?

Message: 1
Date: Wed, 10 Apr 2019 05:11:01 +
From: Keisuke Miyako 
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: v17 Print Settings in a form's Property List
Message-ID: 
Content-Type: text/plain; charset="utf-8"

I think this is the new (64-bit) behaviour for dialType:0

https://doc.4d.com/4Dv17/4D/17.1/PRINT-SETTINGS.301-4179613.en.html

that said, the Design Reference is a bit vague on this point

https://doc.4d.com/4Dv17/4D/17.1/Printing-a-form.300-4201214.en.html

"A Print Setup dialog box appears, which lets you modify the specific print 
settings of the form: paper format, orientation, etc. The options available in 
this standard dialog box depend on your system configuration. "

2019/04/10 11:31、David Rose via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

I'm running v17.1 in a Windows 10 client/server environment. In the Design 
environment, when I click on the Print Settings button in a form's Property 
List, I get a Print dialog, not the usual Print Settings (Page Setup) dialog.
Is that a bug or a feature?



**
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
**

RE: Benchmark Speed Test Method

2019-04-11 Thread David Ringsmuth via 4D_Tech
Steve,

In both v15.6 and v17.4 I had to put nginx in front of 4D Web Server to handle 
heavy loads.

Nginx did SSL termination, and it allows 4D to handle only the http processing.

So both 15.6 and 17.4 failed for me under very heavy loads, without a 
reverse-proxy (nginx) in front of them doing SSL termination.

David Ringsmuth

From: steve simpson via 4D_Tech
Sent: Friday, April 5, 2019 2:32 PM
To: 4d_tech@lists.4d.com
Cc: steve simpson
Subject: Re: Benchmark Speed Test Method

On Fri, Apr 5, 2019 at 3:00 PM  Neal Schaefer wrote:

> [snip]
>
> * We're getting a new Windows 2016 server for our 4DServer, and before I
> migrate, I'd like to write a benchmark speed test to run before and after.
> I'd like to measure create, edit, delete records, processing, IO, file
> copying, and other relevant functions. We're also migrating from v16.6 to
> v17 later in the year, and I'd like to run it again before and after the
> upgrade. I'm wondering if anyone has a method they've written for this
> purpose that they might be willing to share?*
>
We'd be very interested in that too. And Neal, I hope you share your
results when finished.

Also, has anyone moved up to v17 web server yet application? (Not "web
area", but rather the full "web server application") Can you tell how it
compares to v15 please? Any issues one should be aware of?
-
Stephen Simpson
Cimarron Software
**
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
**

RE: Formatter that only shows decimals

2019-04-11 Thread David Ringsmuth via 4D_Tech
Peter,

You may have to string it, and replace the decimal with nothing…

Hth.

David Ringsmuth

From: Peter Jakobsson via 4D_Tech
Sent: Saturday, April 6, 2019 6:01 PM
To: 4D iNug Technical
Cc: Peter Jakobsson
Subject: Formatter that only shows decimals

Hi

Does anyone know how to do a formatter that only shows (currency) decimals but 
that hides the decimal point ?

I have used ".00;-.00;00” which works ok except that the decimal point itself 
displays. I’d like to only display the numerics without the point if poss.

Thanks in advance for any tips.

Peter

**
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
**

-1 undefined database event

2019-04-24 Thread David Ringsmuth via 4D_Tech
The message says the record is locked, but 4D’s Locked($pTable->) returns 
false, and so does 4D’s Read only state($pTable->).

Under what circumstances would this happen?

Undefined Database Event.[-1] in the method 'Save_Record', on line 50.
Method: Save_Record
Line: 50
1066: dbmg: Record  is locked in table Student of database CMv10
1046: dbmg: Cannot save record 132171 in table Student of database CMv10

If (Not(Locked($pTable->)) & Not(Read only state($pTable->)))
If (ModifiedRecord ($pTable;1+2;->$tModified))
Error:=0
C_TEXT($WindowTitle_t)
SAVE RECORD($pTable->)  // this is line # 50
End if
else
...
end if

David Ringsmuth

**
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: -1 undefined database event

2019-04-24 Thread David Ringsmuth via 4D_Tech
Kirk,

This seems like it may be the cause!

I’ll check this out!!

THANKS!!!

David Ringsmuth

From: Kirk Brooks via 4D_Tech
Sent: Wednesday, April 24, 2019 4:38 PM
To: 4D iNug Technical
Cc: Kirk Brooks
Subject: Re: -1 undefined database event

David,

On Wed, Apr 24, 2019 at 2:23 PM David Ringsmuth via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> The message says the record is locked, but 4D’s Locked($pTable->) returns
> false, and so does 4D’s Read only state($pTable->).
>
> Under what circumstances would this happen?
>
If you are using 4D server this can happen when the record has been
loaded/modified on the server. Triggers run on the server. This is one way
you get this sort of situation. The other, which has bitten me before, is
when an EXECUTE ON SERVER method has loaded, but not unloaded, a record.

-- 
Kirk Brooks
San Francisco, CA
===

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**
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
**

RE: -1 undefined database event

2019-04-24 Thread David Ringsmuth via 4D_Tech
Chip,

The data file is in use by 20+ people who are updating it. It can’t be in 
read-only.

The system automatically runs a full validate data file every night, and also 
verifies every index value is correct. I don’t think the record is damaged, but 
I had not thought of that!

Thanks!

David Ringsmuth

From: Chip Scheide
Sent: Wednesday, April 24, 2019 4:32 PM
To: 4D iNug Technical
Cc: David Ringsmuth
Subject: Re: -1 undefined database event

immediate thoughts:
- the data file it self is read only.
 -- due to file access permissions (from the OS)
 -- the data file is open by another copy of the structure
 -- the record (or more) are damaged in some manner (run MSC)

Chip


On Wed, 24 Apr 2019 16:23:09 -0500, David Ringsmuth via 4D_Tech wrote:
> The message says the record is locked, but 4Dʼs Locked($pTable->) 
> returns false, and so does 4Dʼs Read only state($pTable->).
> 
> Under what circumstances would this happen?
> 
> Undefined Database Event.[-1] in the method 'Save_Record', on line 50.
> Method: Save_Record
> Line: 50
> 1066: dbmg: Record  is locked in table Student of database CMv10
> 1046: dbmg: Cannot save record 132171 in table Student of database CMv10
> 
> If (Not(Locked($pTable->)) & Not(Read only state($pTable->)))
> If (ModifiedRecord ($pTable;1+2;->$tModified))
>   Error:=0
>   C_TEXT($WindowTitle_t)
>   SAVE RECORD($pTable->)  // this is line # 50
> End if
> else
> ...
> end if
> 
> David Ringsmuth
> 
> **
> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 

**
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: -1 undefined database event

2019-04-25 Thread David Ringsmuth via 4D_Tech
Kirk,

I believe you solved this for me!

I had a process launched from within table’s trigger that momentarily locked 
the record I was trying to save.

THANK YOU!

David Ringsmuth

From: Kirk Brooks via 4D_Tech
Sent: Wednesday, April 24, 2019 4:38 PM
To: 4D iNug Technical
Cc: Kirk Brooks
Subject: Re: -1 undefined database event

David,

On Wed, Apr 24, 2019 at 2:23 PM David Ringsmuth via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> The message says the record is locked, but 4D’s Locked($pTable->) returns
> false, and so does 4D’s Read only state($pTable->).
>
> Under what circumstances would this happen?
>
If you are using 4D server this can happen when the record has been
loaded/modified on the server. Triggers run on the server. This is one way
you get this sort of situation. The other, which has bitten me before, is
when an EXECUTE ON SERVER method has loaded, but not unloaded, a record.

-- 
Kirk Brooks
San Francisco, CA
===

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**
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
**

What is the Listbox command to "get" a formula data type?

2019-04-17 Thread David Ringsmuth via 4D_Tech
This is the command that sets the data type:

LISTBOX INSERT COLUMN FORMULA ( {* ;} object ; colPosition ; colName ; formula 
; dataType ; headerName ; headerVar {; footerName ; footerVar} )   

I have not found the Listbox command to "get" a formula data type.

Please help!

David Ringsmuth

**
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: Anyone using zipcodeapi

2019-06-08 Thread David Ringsmuth via 4D_Tech
John,

I’m using the Google Geocode API. It returns XML with street address info, 
which can be complicated….

It’s not free, but it is very in-expensive.

David Ringsmuth

From: JOHN BAUGHMAN via 4D_Tech
Sent: Saturday, June 1, 2019 8:07 PM
To: Ed Hammond via 4D_Tech
Cc: JOHN BAUGHMAN
Subject: Anyone using zipcodeapi

Is anyone using zipcodeapi.com  to fill in city and 
state fields in a 4D database? Would you be willing to share your code?

Thanks,

John


John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.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
**

**
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
**

v17.4 source Stand-alone and Remote: picture drop onto a picture field in an input form

2019-06-13 Thread David Ringsmuth via 4D_Tech
I know some things have changed with v17.4 drag and drop.

When I enable a form picture object to accept drop, and I trace the “on drop” 
database method, nothing happens in the form, object method or on-drop database 
method.

Suggestions please!

David Ringsmuth

**
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: 400 Bad Request

2019-06-14 Thread David Ringsmuth via 4D_Tech
Michael,

If possible, look at the HTTP server for more descriptive information with that 
error.

My first thought was that a downgrade was occurring, from HTTPS to HTTP, and 
the HTTP server required something to correctly do the downgrade.

David Ringsmuth

From: Michael McCall via 4D_Tech
Sent: Friday, June 14, 2019 3:34 PM
To: 4D iNug Technical
Cc: Michael McCall
Subject: RE: 400 Bad Request

We have had one client who primarily uses iPads who has reported a similar 
issue from time to time over the past few years. 

We've never been able to reproduce it since they have around 200 iPads at times 
- which we don't - and they also have done some customizations which make it 
hard to isolate the problem.

If anyone does have suggestions as to possible things to check, I'd also be 
curious. 


**
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
**

signature capture in 4D

2019-06-17 Thread David Ringsmuth via 4D_Tech
I bought a Topaz T-S460 signature capture device to capture signatures with 4D.

https://sigpluspro.com

Do you have successful experience with such a device and 4D?

Thanks!
David Ringsmuth

**
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: signature capture in 4D

2019-06-17 Thread David Ringsmuth via 4D_Tech
Jim,

Please tell me more about this….

David Ringsmuth

From: Jim Crate via 4D_Tech
Sent: Monday, June 17, 2019 4:07 PM
To: 4D iNug Technical
Cc: Jim Crate
Subject: Re: signature capture in 4D

On Jun 17, 2019, at 12:50 PM, David Ringsmuth via 4D_Tech 
<4d_tech@lists.4d.com> wrote:
> 
> I bought a Topaz T-S460 signature capture device to capture signatures with 
> 4D.
> 
> https://sigpluspro.com
> 
> Do you have successful experience with such a device and 4D?

No experience with that model or manufacturer, but I previously integrated a 
signature capture device with 4D by using LEP to launch the signature app for 
the device with options that saved the signature to a png. Maybe that concept 
will work with this device and software?

Jim Crate

**
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
**