Thursday 13 October 2016

How to setup Citrix Receiver on Ubuntu

1. (64-bit only) Alternative install procedure that can be added to a deployment bash script


2. (64-bit only) Enable i386 Multiarch


Even the Citrix Receiver for 64-bit systems has a lot of dependencies on packages from the i386 architecture. If you are using 64-bit Ubuntu and have not already configured i386 multiarch, you must configure it by running:
sudo dpkg --add-architecture i386  sudo apt-get update

N.B. The download link currently directs you to receiver 13.2 rather than 13.1 and the 64-bit deb no longer has i386 architecture dependencies.

3. Download the Citrix Receiver for Linux .deb package


  • Near the bottom of the page, select either "For 64-bit Systems" or "For 32-bit Systems" as appropriate, and goto the "Receiver for Linux" package.
  • Look for "File Type: .deb" under the Download buttons.
  • Click this .deb file, and have it open in Ubuntu Software Center for installation (so you can skip step 4), Or download the .deb file and install it as described in step 4..
  • Optionally download the "USB Support Package". This package provides support for passing USB devices from your local Ubuntu machine into the remote Windows session (if your Citrix server is configured to allow that).

4. Install the downloaded package(s) and dependencies


In case your Ubuntu Software Center didn't install the Citrix receiver, so you had to download it, now install it as follows:
sudo dpkg -i ~/Downloads/icaclient_*.deb ctxusb_*.deb   
sudo apt-get -f install  # Install dependencies and finish configuring the package(s)

5. Add more SSL certificates


By default, Citrix Receiver only trusts a few root CA certificates, which causes connections to many Citrix servers to fail with an SSL error. The 'ca-certificates' package (already installed on most Ubuntu systems) provides additional CA certificates in /usr/share/ca-certificates/mozilla/ that can be conveniently added to Citrix Receiver to avoid these errors:
sudo ln -s /usr/share/ca-certificates/mozilla/* /opt/Citrix/ICAClient/keystore/cacerts/ 
sudo c_rehash /opt/Citrix/ICAClient/keystore/cacerts/

6. Configure Citrix Receiver


Run:
/opt/Citrix/ICAClient/util/configmgr &

To map drives (to allow access to files on your local Ubuntu machine via a share drive in the remote Windows session), see the "File Access" tab.

7. (64-bit only) Fix Firefox plugin installation


Run:
sudo rm -f /usr/lib/mozilla/plugins/npwrapper.npica.so /usr/lib/firefox/plugins/npwrapper.npica.so 
sudo rm -f /usr/lib/mozilla/plugins/npica.so 
sudo ln -s /opt/Citrix/ICAClient/npica.so /usr/lib/mozilla/plugins/npica.so
sudo ln -s /opt/Citrix/ICAClient/npica.so /usr/lib/firefox-addons/plugins/npica.so

Starting with Citrix Receiver 13.1, the 64-bit version of Citrix Receiver switched from a 32-bit plugin (using nspluginwrapper to allow it to run within a 64-bit browser) to a native 64-bit plugin. However, the install script still configures the plugin to run within nspluginwrapper, which doesn't work with a 64-bit plugin. The above will reconfigure the plugin to run without nspluginwrapper.

8. Configure Firefox


In Firefox, go to Tools -> Add-ons -> Plugins, and make sure the "Citrix Receiver for Linux" plugin is set to "Always Activate".
Starting in Firefox 32, plugins are set to "Ask to Activate" by default, but for some reason the activation prompt is never displayed for the Citrix Receiver plugin, so the plugin will not work unless it is set to "Always Activate".

Grant Select privilege on all tables in schema to user in DB2

Query:

1) Generate grant statement to grant select privilege to user on all tables in schema
select 'grant insert, update, delete on table ' || trim(tabschema) || '.' || 
trim(tabname) || ' to user test;' from syscat.tables where type = 'T'
The above query generate grant statements
2) Run the Grant Statement to grant select and update access for all tables to user in schema
 
grant select,update on "tabschema"."tabname" to user "username"

where "tabschema" = Schema name of DB2 Instance
            "tabname"= name of table

Replace original values in the double quotes