Re: New Notarization Issues

2020-04-25 Thread Paul Ringsmuth via 4D_Tech 
I have successfully notarized my 4D app Using DropDMG. I’m using 4D v18.0 on 
MacOS Catalina. 

Paul Ringsmuth
pringsm...@charter.net



> On Apr 21, 2020, at 11:35 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Peeps,
> I ran into this problem also. I replaced the Internet Commands plugin with
> the v18 version and that more or less fixed it.
> 
> I say "more or less" because after downloading the installer (a .dmg
> created with DropDMG) and installing the app, the user gets the message
> 
> *“CatBase 8.app” can’t be opened because Apple cannot check it for
> malicious software.*
> 
> This software needs to be updated. Contact the developer for more
> information.
> 
> 
> with the options "Show in Finder" and "OK".
> 
> This is an improvement on the previous version (pre-IC update), where the
> options were "Move to trash" and "Cancel".
> 
> So the user has to right-click on the app and choose Open, and then they
> get the dialog with the same alert message, but this time it has an *Open*
> option. Select that and everything works OK.
> 
> 
> So this is not a complete solution, as most users won't know what to do.
> 
> 
> Any suggestions?
> 
> 
> Thanks!
> 
> 
> Pat
> 
> 
> 
> 
> On Thu, 13 Feb 2020 at 03:33, Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> code signature can easily get invalidated if the app or plugin was not
>> packaged and distributed correctly.
>> for example, if you simply sign, zip and upload a file to a public server,
>> a downloaded copy would most probably be thrown to the bin.
>> 
>> the developer should sign, archive (pkg, zip, dmg), notarise, and staple
>> the app or plugin before distribution.
>> also a plugin created for v17 R6 or earlier has manifest.json in a
>> non-conventional location, which may get rejected by Catalina 10.15.3.
>> 
>> On Feb 12, 2020, at 13:18, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com
>> > wrote:
>> Slightly related. Any idea why I have a plug-in that is signed but shows
>> as damaged on Catalina but not in windows. I am not sure of other Mac OS
>> versions.
>> 
>> **
>> 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
>> **
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: Code Signing Certificate issues

2020-02-13 Thread Paul Ringsmuth via 4D_Tech 
With the help of my great brother David Ringsmuth, I was able to get a code 
signing certificate from Apple. (I became an Apple Developer back in Oct 2019.)

We did have a hiccup with building the app with the signing certificate. David 
looked at the build logs and figured out that building was chocking on a 4D 
file 4d.entitlements in the resources folder of the 4D app. We replaced the 4D 
app with one from the installer. Then we had a successful build. 

Paul Ringsmuth
pringsm...@charter.net



> On Feb 13, 2020, at 6:20 PM, Timothy Penner  wrote:
> 
> This:
>>   The certificate was purchased and Issued by: Sectigo RSA Code Signing CA.
>> Does code signing on the Mac require a certificate issued by Apple?
> 
> Yes. The certificate must be issued by Apple and is part of the $99/year 
> Apple Developer program.
> 
> Hope that helps,
> 
> -Tim
> 
> 
> 
> 
> 
> Timothy Penner
> Senior Technical Services Engineer
> 
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose,CA 95113
> United States
> 
> Telephone: +1-408-557-4600
> Fax:   +1-408-271-5080
> Email: tpen...@4d.com
> Web:   www.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
**

Code Signing Certificate issues

2020-02-13 Thread Paul Ringsmuth via 4D_Tech 
I have a code signing certificate by the name of "Disability Representative 
Services LLC” and it is visible in the KeyChain Access app on my mac. The 
certificate works on the windows version of my application although it uses a 
different file which I have named something else like RepTools. 

Now I am attempting to code sign my mac version of RepToolsSSD3 with the the 
certificate named "Disability Representative Services LLC” and the build fails 
with the log showing a ton of errors that basically say" Application NO_ERR 0 
Signing tool return status: 0
Application NO_ERR 0 Signed file: error: The specified item could not be found 
in the keychain.

The certificate was purchased and Issued by: Sectigo RSA Code Signing CA.

Does code signing on the Mac require a certificate issued by Apple? 

I’m on v18.0 of 4D on mac Mohave. 

Paul Ringsmuth
pringsm...@charter.net



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

Code Signing Certificate issues

2020-02-13 Thread Paul Ringsmuth via 4D_Tech 
I have a code signing certificate by the name of "Disability Representative 
Services LLC” and it is visible in the KeyChain Access app on my mac. The 
certificate works on the windows version of my application although it uses a 
different file which I have named something else like RepTools. 

Now I am attempting to code sign my mac version of RepToolsSSD3 with the the 
certificate named "Disability Representative Services LLC” and the build fails 
with the log showing a ton of errors that basically say" Application NO_ERR 0 
Signing tool return status: 0
Application NO_ERR 0 Signed file: error: The specified item could not be found 
in the keychain.

The certificate was purchased and Issued by: Sectigo RSA Code Signing CA.

Does code signing on the Mac require a certificate issued by Apple?  

Paul Ringsmuth
pringsm...@charter.net



**
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: Making a package of a built Mac volume desktop

2019-10-15 Thread Paul Ringsmuth via 4D_Tech 
> What do you want the package to do when you double-click it?
Good question. When I double-click the the app I would like it to launch with 
the data file. 

I created a folder “Data” and put the various 4D data files in it. Then I put 
the “Data” folder into the My4D.app. The first time it is launched it asks me 
to open a data file. I navigate to and select the data file inside of My4D.app. 
The second time it is launched it remembers where the data file was. So this is 
a good solution to have everything in one .app package. 

But sometimes there will be updates and the old data should be used. The 
everything in one package becomes problematic because it is too hard for the 
user to deal with the data files. It may be better to have the Data folder 
outside of the .app to make it easier for my users to swap in new code. It 
might be tougher for them to locate the old data file.

One other thing. I notice that there is a _CodeSignature file in the app. I 
think the app gets signed in the build interface. Does adding a data folder to 
the app affect the code signing? 

Also I signed up to become an Apple Developer. It took me a couple of days to 
read/skim the 80 page agreement. Now I have to figure out what to do to get 
code signing approval. I think they call it a ticket. 

Paul Ringsmuth
pringsm...@charter.net



> On Oct 15, 2019, at 3:46 PM, Keith Culotta  wrote:
> 
> What do you want the package to do when you double-click it?
> 
> You can right-click the built app and show its contents, which will open it 
> as a folder.  There are places in there where you can put data and other 
> files, and it will still open when you double-click it.  
> 
> I think the package you created would need a plist file in a specific place 
> to operate correctly.
> 
> Keith - CDI
> 
>> On Oct 15, 2019, at 2:24 PM, Paul Ringsmuth via 4D_Tech 
>> <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> 4Dv17R5 
>> 
>> I have created a built volume desktop app for Mac. 
>> I put the built volume desktop into a folder along with the data files. 
>> The name on the folder is the app’s name. 
>> Then I added the .4dbase extension to the folder and created a package. 
>> 
>> The problem is that when this package is double clicked, it attempts to 
>> launch and it throws a system error which can be sent to Apple. 
>> 
>> Is it not possible to make a package with a volume desktop app?
>> 
>> Paul Ringsmuth
>> pringsm...@charter.net <mailto:pringsm...@charter.net>
>> 
>> 
>> 
>> **
>> 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
**

Making a package of a built Mac volume desktop

2019-10-15 Thread Paul Ringsmuth via 4D_Tech 
4Dv17R5 

I have created a built volume desktop app for Mac. 
I put the built volume desktop into a folder along with the data files. 
The name on the folder is the app’s name. 
Then I added the .4dbase extension to the folder and created a package. 

The problem is that when this package is double clicked, it attempts to launch 
and it throws a system error which can be sent to Apple. 

Is it not possible to make a package with a volume desktop app?

Paul Ringsmuth
pringsm...@charter.net



**
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: Debug Application Process Window missing toolbar

2019-09-19 Thread Paul Ringsmuth via 4D_Tech 
On Windows 10 I found the 4ddebugger.json file here:

"C:\Users\Paul Ringsmuth\AppData\Roaming\4D\4D Window Bounds 
v17\runtime\[projectForm]\4ddebugger.json”

I deleted it and all is well with the debugger window. Thanks for all your 
help. 

The additional information about holding down the shift key while opening a 
window having the same effect as deleting the window prefs will be valuable in 
the future. 

Paul Ringsmuth
pringsm...@charter.net

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

Debug Application Process Window missing toolbar

2019-09-18 Thread Paul Ringsmuth via 4D_Tech 
4Dv17R5
Windows 10 under VirtualBox

The toolbar is missing in the Debug Application Process Window except for a 
couple of pixels. 

I can’t find a way to get it back. Any suggestions?

Paul Ringsmuth
pringsm...@charter.net



> On Sep 18, 2019, at 6:46 PM, Adam Bevan via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> Because of the SQL gotcha in v12 I always have a case of statement to run
> 4D queries instead.
> For something like what is described, I send the query to another process
> and return the array of record ID's.
> Allows for the query but doesn't change the selection or current record for
> the current process.
> 
> I'm not saying SQL is bad, but it's just nice to have the quick ease of
> flipping a switch to run native 4D.
> 
> 
> Adam Bevan
> Developer & CEO, Argus Productions Inc.
> 
> 
> 
> On Wed, 18 Sep 2019 at 11:05, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Here goes
>> 
>> C_TEXT($INCLUDED_txt)
>> $INCLUDED_txt:=“(“+String(al_Personnel_ID{1})
>> for($LOOPL;2;size of array(al_Personnel_ID))
>> 
>> $INCLUDED_txt:= $INCLUDED_txt+”,”+String(al_Personnel_ID{LOOPL})
>> 
>> end for
>> $INCLUDED_txt:=$INCLUDED_txt+”)"
>> begin sql
>> select [Personnel].[field],...
>> 
>> from [Personnel]
>> where
>> Personnel]Personnel_ID in :$INCLUDED_txt:
>> 
>> end sql
>> 
>> 
>> Chuck Miller Voice: (617) 739-0306
>> Informed Solutions, Inc. Fax: (617) 232-1064
>> mailto:cjmillerinformed-solutions.com
>> Brookline, MA 02446 USA Registered 4D Developer
>>   Providers of 4D and Sybase connectivity
>>  http://www.informed-solutions.com
>> 
>> 
>> This message and any attached documents contain information which may be
>> confidential, subject to privilege or exempt from disclosure under
>> applicable law.  These materials are intended only for the use of the
>> intended recipient. If you are not the intended recipient of this
>> transmission, you are hereby notified that any distribution, disclosure,
>> printing, copying, storage, modification or the taking of any action in
>> reliance upon this transmission is strictly prohibited.  Delivery of this
>> message to any person other than the intended recipient shall not
>> compromise or waive such confidentiality, privilege or exemption from
>> disclosure as to this communication.
>> 
>>> On Sep 18, 2019, at 11:44 AM, Randy Engle via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> Hello SQL Afficionados!
>>> 
>>> I need to get a selection of records, based upon an array of ID numbers.
>>> (What I want is to end up the arrays... not the selection of records)
>>> 
>>> e.g.
>>> QUERY WITH ARRAY([Personnel]Personnel_ID;al_Personnel_ID)
>> 
>> **
>> 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: PHP and 64 bit readyness

2019-09-13 Thread Paul Ringsmuth via 4D_Tech 
How do you remove PHP from 4D? I’m on v17 R5.

Paul Ringsmuth
pringsm...@charter.net



> On Sep 13, 2019, at 4:15 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> At this point, as I said below, I only use php for conversion of Dec to 
> Hex
> so...
> 
> 
> But thanks for the information
> Chip
> 
> On Fri, 13 Sep 2019 14:01:15 -0700, Sam Burnell via 4D_Tech wrote:
>> Not sure if this is germane to your issue, Chip, but I’ll offer this 
>> - 4D’s v17 php interpreter is not as comprehensive as one would 
>> expect or hope for. It doesn’t handle cURL and other critical (to me) 
>> functions...
>> 
>>> On Sep 13, 2019, at 1:56 PM, Chip Scheide via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> from my report:
>>> 4D’s PHP interpreter contains 32-bit libraries in v17.x and below. If 
>>> the PHP interpreter is not used, it can be removed. If PHP is used with 
>>> 4D’s default PHP interpreter it can cause warnings to occur, especially 
>>> on Mac OS where a warning may occur or cause an application to fail 
>>> notarization.
>>> 
>>> I do use 2 php libraries
>>> hexdec, and dechex for converting to/from hex
>>> 
>>> how do I resolve the use of PHP when I get to v17?
>>> 
>>> 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
>> **
> ---
> 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
**

Re: [OFF] PCI/DSS compliance

2017-09-08 Thread Paul Ringsmuth via 4D_Tech 
Consumer Reports says,

"A massive data breach at Equifax compromised sensitive data for nearly half of 
all U.S. consumers — including names, social security numbers, birth dates, 
addresses, and the numbers of some driver's licenses. Hundreds of thousands of 
credit card numbers were also compromised. Now millions of Americans could be 
at risk for identity theft.

To make matters worse, Equifax responded by sending consumers to a website 
where, by signing up for credit monitoring services, they could waive their 
legal rights to ever take Equifax to court, for any problem.”

Paul Ringsmuth

> On Sep 8, 2017, at 7:51 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> On Sep 8, 2017, at 4:23 PM,Chip Scheide wrote:
> 
>> I find the idea that it is necessary to implement PCI ironic, when 
>> Equifax just lost the SS numbers, and other personal data of over 
>> 140,000,000 people.
> 
> I checked the website they published and it says my information was stolen. 
> So now I have to wait until 9/12/17 and then go back to the website and 
> enroll in their free identity theft coverage. 
> 
> The company that reports how good your credit is will now be the one that 
> destroys your credit rating. And there’s nothing you can do about it. Isn’t 
> this nice. 
> 
> 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
**

Re: Menu key shortcuts execute the wrong item in 4D 16

2017-02-13 Thread Paul Ringsmuth via 4D_Tech 
> I filed a bug report for this (version 16.0). It now appears to be fixed in 
> version 16 nightly builds.
Thanks John, 
I tried Build 208697 of v16 R2 Beta. It still has the problem for me. I’ll keep 
checking as new builds come out. 

Paul Ringsmuth


> On Feb 13, 2017, at 1:50 PM, John DeSoi  wrote:
> 
> Paul,
> 
> I filed a bug report for this (version 16.0). It now appears to be fixed in 
> version 16 nightly builds.
> 
> It appears to be caused by the Preferences menu item being moved to the Apple 
> menu. Any menu item with a shortcut after this item executes the menu item 
> after it. For example, I had two menu item shortcuts, E followed by P. 
> Command-E executes the Command-P menu item. Command-P at the end of the menu 
> does nothing.
> 
> John DeSoi, Ph.D.
> 
> 
>> On Feb 13, 2017, at 1:36 PM, Paul Ringsmuth  wrote:
>> 
>> Configuration:
>> 4D v15.4 and 16 R2 build 16R2.208523
>> MacBookPro OSX Sierra 10.12.3 
>> 
>> Problem:
>> The shortcut for the Print command is CMD-P. 
>> The CMD-P shortcut works in 4D v15.4 but not in 16 R2.
>> Using the actual menu (selecting File, then Print) works on both versions of 
>> 4D.
>> 
>> The result is the same for both input and output layouts throughout my 
>> entire database. 
>> 
>> I have checked the print settings attached to the forms to be printed and 
>> they seem okay. 
>> 
>> My print commands usually have a method assigned to them. 
>> 
>> Anyone else seeing this? I’m considering filing a bug.
> 
> **
> 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
**