Sage 100

 View Only
Expand all | Collapse all

Credit Card Processing in an RDS Environment

  • 1.  Credit Card Processing in an RDS Environment

    Posted 08-23-2021 13:21
    How does one setup Sage Credit Card processing through Paya in an RDS environment with Sage setup as a Published App?

    I have installed Paya Desktop Connect on the RDS server and everything works fine when logged in with a desktop, but it does not work when running the Sage 100 published app. Attempting to do anything that normally launches the Paya Desktop interface pops up the message that Sage Exchange is not installed.

    Does the Paya App also need to be published on the RDS server? Does it need to be installed a special way?
    Can anyone share their experience or documentation on how to accomplish this?

    So far I have not been able to locate any helpful information, appreciate your help.

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------


  • 2.  RE: Credit Card Processing in an RDS Environment

    Posted 08-24-2021 08:57
    Publishing Paya Desktop Connect and having the user launch it should work fine for now.  With Citrix, we have some registry options to allow other applications to run but I'm not sure if pure RDS has similar functionality.  Another possible workaround could be to use a batch file to launch both applications and then publish the batch file.

    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 3.  RE: Credit Card Processing in an RDS Environment

    Posted 08-24-2021 09:54

    We have it running for all our clients in an RDS environment using a published app. We don't publish the Paya app, just Sage 100. 

    We also don't use anything unusual for the installation process's we simply run the bootstrapper and update to the latest. 

    If your users are not admins on the server, you want to make sure to correctly ACL the appropriate folders. 



    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 4.  RE: Credit Card Processing in an RDS Environment

    Posted 08-24-2021 10:29
    @George Khairallah can you point me in the right direction as to what folders and what permissions are required?​

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



  • 5.  RE: Credit Card Processing in an RDS Environment

    Posted 08-24-2021 12:32
    This is the full list that we use to allow non-admin users to correctly access all Sage functions.
    I believe the "Sage Payment Solutions" folders only exist on systems with PED installed.

    Permission on all are MODIFY.

    File System:
    D:\Sage (path may vary)
    C:\Sage (path may vary)
    C:\Program Files (x86)\Sage
    C:\Program Files (x86)\SAP BusinessObjects
    C:\Program Files (x86)\Sage Payment Solutions
    C:\Program Files (x86)\Common Files\Sage
    C:\Program Files (x86)\Common Files\BIComponents
    C:\Program Files (x86)\Common Files\BIComponentsDotNet
    C:\Program Files (x86)\Common Files\BIExcelFunctions1.1
    C:\Program Files (x86)\Common Files\BIGenerator
    C:\Program Files (x86)\Common Files\DESIGNER
    C:\ProgramData\Sage
    C:\ProgramData\Sage Payment Solutions
    C:\ProgramData\Sage Software

    On Registry, we usually do a "Replace all child object permission entries with inheritable permission entries from this object."

    Registry:
    HKLM:\SOFTWARE\Sage Software
    HKLM:\SOFTWARE\WOW6432Node\Sage
    HKLM:\SOFTWARE\WOW6432Node\Sage Software
    HKLM:\SOFTWARE\WOW6432Node\SAP BusinessObjects
    HKLM:\SOFTWARE\Wow6432Node\Alchemex (Pty) Ltd
    HKCC:\Software

    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 6.  RE: Credit Card Processing in an RDS Environment

    Posted 08-25-2021 10:38
    Fantastic @George Khairallah thank you so much. I'll be testing this out today.

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



  • 7.  RE: Credit Card Processing in an RDS Environment

    Posted 08-25-2021 11:12
    @George Khairallah - Does this replace the "full control on MAS90 folder" requirement?​

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 8.  RE: Credit Card Processing in an RDS Environment

    Posted 08-25-2021 11:53
    ​We've never set MAS90 with Full Control. In fact there are no folders on the file system that require full control (except in the registry).

    The only File System ACL that require full control are in Sage 50, but nothing in Sage 100.

    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 9.  RE: Credit Card Processing in an RDS Environment

    Posted 08-25-2021 12:55
    @George Khairallah do you disable inheritance on folders if found or just add modify rights?  I noticed permission for ProgramData\Sage Payment Solutions is being inherited.
    In the registry, do you grant full access and then "replace child permission objects...​

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



  • 10.  RE: Credit Card Processing in an RDS Environment

    Posted 08-25-2021 14:57

    ​For your purposes, you don't need to disable inheritance on anything.
    We disable it for certain folders as it is directly connected to user's subscription rights to certain parts of Sage (within our hosting service)

    If you have any doubts on whether there are any issues with sub folder/file ACLs, I would in fact enable inheritance, "Apply" , then follow it by "Replace all child object permission entries with inheritable permission entries from this object".

    This is usually not a problem, but I have seen some instance where an ACL gets broken (inexplicably) and that option resolves weird behavior sometimes.

    As it relates to the Sage Payment Solutions folder specifically, the inherited ACLs won't matter and leaving them as is is ok, as long as the ACL you are adding applies to the target user group.



    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 11.  RE: Credit Card Processing in an RDS Environment

    Posted 08-26-2021 07:52
    @George Khairallah - that list does not allow end users to update Aatrix changes, though, does it?​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 12.  RE: Credit Card Processing in an RDS Environment

    Posted 08-26-2021 10:02

    That's a good question Beth. 

    I can't say with 100% certainty, as we've had hit or miss success with updating Aatrix. We usually assist clients if they aren't able to update it themselves.

    I will take this to our engineering team and we'll test it out, and if we find consistent success with a change of ACL related to Aatrix, I will update this thread. 



    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 13.  RE: Credit Card Processing in an RDS Environment

    Posted 08-26-2021 11:37
    Thanks, @George Khairallah.  It's a PIA Jan-Apr with changes from Aatrix every day, it seems.​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 14.  RE: Credit Card Processing in an RDS Environment

    Posted 08-26-2021 11:49
    @George Khairallah, I made all the changes, gave domain users and local users Modify rights to folders and Full Control to Reg Keys, applied to all child objects (both folders and reg keys) rebooted the RDS server and still no luck. I can see that the Paya Desktop is not running ​while users are in Sage 100. It only runs when a users logs in with a full desktop, not from the published app.

    Maybe I need to take the approach that @Steve Iwanowski suggested and publish Paya as well, or use a batch file to start Paya Desktop, then launch Sage?​

    Is 'change user /install' still required (I did not do this before installing either Sage or Paya) before installing apps on and RDS server? I didn't think that applied anymore, am I wrong on that?

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



  • 15.  RE: Credit Card Processing in an RDS Environment

    Posted 08-27-2021 02:07

    Sorry @Greg Stiles, I had missed your reply. 

    A couple additional questions, recommendations:
    1- just so that you're not spinning your wheels on the wrong solutions, can you try to make the user local admin temporarily and try again? My guess is that it won't work either, because I'm not convinced your issue is permissions related. But this will give you a definite answer regarding that.


    2- I'm not sure you mentioned the method of connection to the RemoteApp. Are you using the traditional connection (via Internet Explorer or the Control Panel), or are you using the HTML5 WebClient?

    the WebClient only works with Sage 100 Standard, but it can't even launch the Sage client for Advanced or Premium, so just in case you are using it, I wouldn't be surprised if you see weird behavior in it, so perhaps switch to the more mature control panel connection instead and try again.

    As far as the installation; we normally still do the change user /install for good measure. I'm not 100% certain whether it's still required​. 

    Another couple notes: 
    - Though we don't have any clients with Paya Published, you can try this suggestion: Launch it first, then Launch the Sage client. 

    Some applications don't show their icon in the task tray, even though they are running, can you check the task manager and see if the process is running for that user? (In RemoteApp, In HTML5 and in full desktop) 

    - Have you tried clearing the user's Windows Profile (and possibly their Sage 100 folder?) 

    Hope some of the above suggestions shed some more light on the situation. 




    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 16.  RE: Credit Card Processing in an RDS Environment

    Posted 08-27-2021 11:35
    @George Khairallah answers below.

    ...I'm not convinced your issue is permissions related...   -  I agree, I don't think it is permissions related either because Paya does launch when a non-admin user RDP's in with a full desktop, but does not launch when we use the RemoteApp.

    ...I'm not sure you mentioned the method of connection to the RemoteApp...  -   I am not sure, as their IT setup the RDS Server. They sent us a certificate to install, and an RDP icon to copy to the desktop. Not sure if this matters but, Sage is on a remote server on our sister company's LAN, not on our own LAN, and we connect via the internet without a VPN.

    ...we normally still do the change user /install for good measure...  -   Good to know, I'll go back to doing that as well.

    ...Launch it first, then Launch the Sage client...   -   I am going to have them publish the Paya app and try that.

    ...can you check the task manager and see if the process is running...   -   As per task manager, the Paya process is not running when using the RemoteApp, bit it is when on a full desktop.

    - Have you tried clearing the user's Windows Profile (and possibly their Sage 100 folder?)  -  I have not, I will try that.



    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



  • 17.  RE: Credit Card Processing in an RDS Environment

    Posted 08-27-2021 11:46
    From the description, it sounds like they are connecting via normal RDP RemoteApp, and sounds like they might not have an RDWeb, and are individually sending the RDP file to the user. a bit unconventional, but should still work.

    The 2 variables I don't know about, though I don't think they should play a role in the behavior:
    1- They seem to be using a self-signed certificate. (Otherwise they wouldn't have to send the certificate to the users.
    2- They are connecting via an RDGateway.

    Since the behavior is specific to RemoteApp, I also tend to take a look at the launching path of Sage, and its parameters.
    The parameters shouldn't be a problem. but, I have seen strange behavior if the path to pvxwin32.exe in the RemoteApp path is set to something that the user might not have full access to.
    i.e:
    \\server\d$\sage\mas90\ will cause problems for users, depending on permissions

    I would check that path, and make sure that the path to pvxwin32.exe in the published app is set to the Sage share
    i.e: \\server\sage$\mas90\....

    and ensure that both the ACLs, and the Share permissions are both appropriately set.


    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 18.  RE: Credit Card Processing in an RDS Environment

    Posted 08-27-2021 14:48
    @George Khairallah I believe they are using a self signed certificate and I think you are also correct in that they are connecting through an RDGateway.
    The RemoteApp seems to have been created correctly with an accessible path and correct parameters.

    I am meeting with their IT Monday to troubleshoot and will recommend all your suggestions.



    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



  • 19.  RE: Credit Card Processing in an RDS Environment

    Posted 08-26-2021 11:51
    @Beth Bowers Agreed! Royal-PIA​ for sure. I too would like to know that @George Khairallah.​

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



  • 20.  RE: Credit Card Processing in an RDS Environment

    Posted 08-26-2021 11:59
    We got you! 

    When the next update comes up (for gotomyerp clients), please open a ticket with support, and we'll make some changes to see if we can get consistent results as it relates to Aatrix updates, and will update the ACL requirements here once we find out for sure.

    ------------------------------
    George Khairallah
    CTO | gotomyerp, LLC
    george.k@gotomyerp.com | 877-888-5525
    http://gotomyerp.com/
    ------------------------------



  • 21.  RE: Credit Card Processing in an RDS Environment

    Posted 08-26-2021 12:52
    @George Khairallah - will do!​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------