Linux Desktop

OS

Ubuntu Desktop download

Ubuntu 18.04 software status

Software	Supported	Remarks
MS office (2007)	YES (TESTED)	via WINE compatibility tool
MS Teams	YES (TESTED)	Preview edition launched by Microsoft
Chrome	YES (TESTED)
Firefox	YES (TESTED)	Default with OS
Team Viewer	YES (TESTED)
Any Desk	YES (TESTED)
Adobe PDF reader	USE ALTERNATIVE (ALTERNATIVE TESTED)	Can open PDF files with browsers or Evince (default in Ubuntu) or Okular software.
WinZip or Win RAR	USE ALTERNATIVE (ALTERNATIVE TESTED)	Using zip, unzip, unrar & tar packages. (Ubuntu default's was enough to handle zip & extract rar files)
Notepad++	USE ALTERNATIVE (ALTERNATIVE TESTED)	Notepad++ can be installed using snap packages, But gedit (default), VSCODE editors are good alternatives
Java 1.8	YES (TESTED)
Eclipse Code Editor	YES (TESTED)	Installation tested eclipse 2020-06 version, End user feedback pending
Oracle SQL Developer	YES (TESTED)	Tested sample DB connection & query
Oracle client	Not needed	As of now above Oracle SQL Developer can be used
GIT	YES (TESTED)
Forti Client VPN	YES (TESTED)
Jcreator Code Editor	USE ALTERNATIVE (ALTERNATIVE TESTED)	No as per wiki & sites, But Eclipse, netbeans, VS Code or other editors are good alternatives
Tortoise GIT	USE ALTERNATIVE	New tool training must be provided. Dev team can also use CLI/ Eclipse or other git clients
Beyond Compare	YES (TESTED)	It's licensed/ commercial software.
Aqua Studio (Postgres)	YES (Commercial), USE ALTERNATIVE	Instead use open source like pgAdmin. Existing omniDB , browser based tool should work for postgres. Also check 'Oracle SQL Developer' - it can connect to postgres via JDBC drivers setup!
CavaJ decompiler	USE ALTERNATIVE	testing pending, https://marketplace.eclipse.org/content/enhanced-class-decompiler#group-details, https://askubuntu.com/questions/272189/open-source-free-java-decompiler#
Data card (Internet)	USE ALTERNATIVE (ALTERNATIVE TESTED)	WIPOD works as it provides WIFI network. If dongle then drivers must be tested by respective user/ vendor.
DSC token driver	YES	Vendor provided drivers for safenet
Xlite(Support Desk tool)	YES	(Manohar) Will support with some changes, testing pending
JWS support	In progress	(Java Team) Some changes required to test. check for both /usr/lib64, /usr/lib folder. Convert .bat file to .sh (shell) file to kill existing process. Configure JWS variable (use oracle sdk). .jnlp file should be associated with JWS application by default.
CS Mapper Check Tool	NO	(Local Exe) Given by Sonia. Can't we upload some where & get it checked, do we need it in each machine ?
IE 11 browser	NO	Use latest IE edge browser instead (recommended by Microsoft)

MS Office

compatibility table

Wine Database

As on July 2020

MSOFFICE	Last Wine Version Tested	Rating	Supported	OS
2003	3.12	Silver/ Platinum	Excel, Word, PPT, Outlook	Ubuntu 14.04 (Silver), ArchLinux (Platinum)
2007	4.7	Platinum	Excel, Word, PPT, Outlook	Ubuntu 18.04 (Platinum)
2010 (32 bit) Retail release June 15, 2010	3.19	Gold / Platinum	Excel, Word, PPT	Ubuntu 18.04 (Gold), Linux Mint (Platinum)
2013 (64 bit)	5.0	Garbage/ Gold		Ubuntu (Garbage), raw debian GNU (Gold)

Wine (style 1)

ref
If your system is 64 bit, enable 32 bit architecture (if you haven't already)

sudo dpkg --add-architecture i386

Download and add the repository key

sudo wget -O - https://dl.winehq.org/wine-builds/winehq.key | sudo apt-key add -

Add the repository:

//20.04
sudo add-apt-repository 'deb https://dl.winehq.org/wine-builds/ubuntu/ focal main'

//18.04
sudo add-apt-repository 'deb https://dl.winehq.org/wine-builds/ubuntu/ bionic main'

Update packages

sudo apt update

Install wine

sudo apt install --install-recommends winehq-stable

Wine (style 2)

If style1 throws error during wine installation about unmet dependencies, then use following steps
ref
remove repository added earlier

//20.04
sudo add-apt-repository -r 'deb https://dl.winehq.org/wine-builds/ubuntu/ focal main'

//18.04
sudo apt-add-repository -r 'deb https://dl.winehq.org/wine-builds/ubuntu/ bionic main'

referring different repositories

sudo dpkg --add-architecture i386
sudo apt update

wget -nv https://download.opensuse.org/repositories/Emulators:/Wine:/Debian/xUbuntu_18.04/Release.key -O Release.key
sudo apt-key add - < Release.key
sudo apt-add-repository 'deb https://download.opensuse.org/repositories/Emulators:/Wine:/Debian/xUbuntu_18.04/ ./'

Update packages

sudo apt update

Install wine

sudo apt install --install-recommends winehq-stable

Install playonlinux & dependencies

ref -> debian

 sudo wget -q "http://deb.playonlinux.com/public.gpg" -O- | sudo apt-key add -
 sudo wget http://deb.playonlinux.com/playonlinux_stretch.list -O /etc/apt/sources.list.d/playonlinux.list
 sudo apt-get update
 sudo apt-get install playonlinux

//some dependencies
 sudo apt-get install xterm p7zip-full samba winbind

MS Office from PlayOnLinux wizard

Ref Link //even printer, multi excel windows trouble shooting exists
Open play on linux (POL) by search/ launcher
go to Tools > Manage Wine versions
- For Office 2007, Install Wine 4.7
- For Office 2010 (32bit) install Wine 2.13 WIne 3.03 as per link
click on Install at top bar (the one with a plus sign).
In Install window, select "Office" from top bar and make sure "Commercial" checkbox is selected below
Now select - Microsoft Office 2007/ 2010 and click on Install , Next
Please Choose an Installation Method (select DVD or file installation) Then click on Next. Browse the files or the DVD for MSOffice setup.exe.
Now, after click on Next: you'll see a sequence of PlayOnLinux installation windows, configuring the new Windows virtual drive, installing components, etc.
Automatically the MSOffice installer will be displayed. Just follow the steps.
Note: To add gmail in outlook check IMAP/POP is enabled in it's setting.
- Pop
- Imap
MS office 2007 better works on linux

Other references

MS Teams

Download Link,
choose Linux (DEB 64-bit), save the .deb file (say teams_1.3.00.16851_amd64.deb)
Open terminal to download location & run following command

sudo apt install ./teams_1.3.00.16851_amd64.deb

Google Chrome

Google search chrome download (in linux)
choose Linux (DEB 64-bit), save the .deb file (say google-chrome-stable_current_amd64.deb)
Open terminal to download location & run following command

sudo apt install ./google-chrome-stable_current_amd64.deb

Team Viewer

Download Link
choose Linux (DEB 64-bit), save the .deb file (say teamviewer_15.7.6_amd64.deb)
Open terminal to download location & run following command

sudo apt install ./teamviewer_15.7.6_amd64.deb

//disable it's service on start up (optional)
sudo systemctl disable teamviewerd.service

check DNS SERVER settings if team viewer not detecting internet , also enable service back

Beyond compare

Download Link
choose Linux (DEB 64-bit), save the .deb file (say bcompare-4.3.5.24893_amd64.deb)
Open terminal to download location & run following command

sudo apt install ./bcompare-4.3.5.24893_amd64.deb

git clients

No Internet issue

fix DNS resolve conf 'linux-server\ubuntu\install-server.md' -> DNS server

AnyDesk

Download Link
Choose Debian/Ubuntu 64-bit -> Download, save the .deb file (say anydesk_5.5.6-1_amd64.deb)
Open terminal to download location & run following command

sudo apt install ./anydesk_5.5.6-1_amd64.deb

//disable it's service on start up
sudo systemctl disable anydesk.service

VSCode

Download Link
Choose Debian 64-bit -> Download, save the .deb file (say code_1.47.2-1594837870_amd64.deb)
Open terminal to download location & run following command

sudo apt install ./code_1.47.2-1594837870_amd64.deb

Fortinet client VPN

Download Link
Choose Download for Linux (.deb) -> save the .deb file (say FortiClientFullVPNInstaller_6.4.0.0851.deb)
Open terminal to download location & run following command

sudo apt install ./FortiClientFullVPNInstaller_6.4.0.0851.deb

Eclipse

Java must be installed (learning/java/installation-java.md)
Download Link
Download 64 bit compressed file (say eclipse-inst-linux64.tar.gz)
Right click & extract file, click on "eclipse-inst" file & follow up the steps
To launch application click "eclipse" file in final installation folder at /home/eclipse/**/eclipse/
create a symbolic link for "eclipse" file in home-> Desktop folder for easy access

//open terminal at ~/Desktop & run following
ln -s /home/myUser/eclipse/java-2020-06/eclipse/eclipse

Oracle sql developer

Create/ sign in with oracle account link
Download Link
Choose "other platforms", save file (say sqldeveloper-19.2.1.247.2212-no-jre.zip),
(optional step) Extract the file, place it's folder 'sqldeveloper' in '/opt/'
Check '/opt/sqldeveloper/sqldeveloper.sh' has executable permission
Dependency
- Download Oracle JDK
- Choose 'Linux x64 Compressed Archive', save file (say jdk-8u261-linux-x64.tar.gz)
- Extract the file & move folder (say jdk1.8.0_261) to /opt/, it has jre & other lib tools
Configuration
- Open '/opt/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf', add following (to fix oracle time zone issue)
AddVMOption -Doracle.jdbc.timezoneAsRegion=false
- Also check '/etc/default/locale' has proper locales else update-locale (check installation-java.md -> oracle issue)
- Run file '/opt/sqldeveloper/sqldeveloper.sh', it will throw error then do below setting in user home directory
- Open ' ~/.sqldeveloper/{{sql-dev-version}}/product.conf' (say /home/test/.sqldeveloper/19.2.1/product.conf), add following JDK dependency path
SetJavaHome /opt/jdk1.8.0_261/
- Now run the file '/opt/sqldeveloper/sqldeveloper.sh' again

SQL hanging issue (Yogesh/ IT points)

# Edit /etc/sysctl.conf

sudo gedit /etc/sysctl.conf
# Add net.ipv4.tcp_retries2=5 and Save the file
sudo sysctl -p

# Install following packages
sudo apt-get install g++
sudo apt-get install make
sudo apt-get install bison
sudo apt-get install flex
sudo apt-get install libgmp3-dev
sudo apt-get install libmpfr-dev libmpfr-doc libmpfr4 libmpfr4-dbg
sudo apt-get install mpc
sudo apt-get install texinfo
sudo apt-get install libcloog-isl-dev

# Download libkeepalive-0.2.tar.gz from http://libkeepalive.sourceforge.net
tar xvf libkeepalive-0.2.tar.gz
cd libkeepalive-0.2$ make
sudo cp libkeepalive.so /lib/

#which sqldeveloper/usr/local/bin/sqldeveloper Edit the file above and replace line
# like: /opt/sqldeveloper/sqldeveloper.sh to: LD_PRELOAD=/lib/libkeepalive.son KEEPCNT=2 KEEPIDLE=30 KEEPINTVL=30 /opt/sqldeveloper/sqldeveloper.sh

# or can  start file like
LD_PRELOAD=/lib/libkeepalive.so KEEPCNT=2 KEEPIDLE=30 KEEPINTVL=30 /opt/sqldeveloper/sqldeveloper.sh

Oracle Instant Client (10g)

(command line tool)

Download Link
Choose "Instant Client for Linux x86-64" -> "Version 10.2.0.5"
Download packages (zip/ rpm)
- zip
  - basic-10.2.0.5.0-linux-x64.zip
  - jdbc-10.2.0.5.0-linux-x64.zip
  - sqlplus-10.2.0.5.0-linux-x64.zip
  - sdk-10.2.0.5.0-linux-x64.zip
  - odbc-10.2.0.5.0-linux-x64.zip -rpm
  - oracle-instantclient-basic-10.2.0.5-1.x86_64.rpm
  - oracle-instantclient-devel-10.2.0.5-1.x86_64.rpm
  - oracle-instantclient-jdbc-10.2.0.5-1.x86_64.rpm
  - oracle-instantclient-odbc-10.2.0.5-1.x86_64.rpm
  - oracle-instantclient-sqlplus-10.2.0.5-1.x86_64.rpm
Installation Ref
- Ubuntu help by rpm
- By zip

e-token driver set up

Prerequisite

sudo apt update
sudo apt install pcscd

ref

Drivers Download

Download respective drivers from Site Link for epass 2003, emudra watch data, ProxKey, Trust key..etc
For Safenet & aladdin (same) drivers were provided by vendor
Open the terminal at location of driver files (.deb) & install with following command like

safenet or other .deb files

sudo apt install ./safenetauthenticationclient_10.7.77_amd64.deb

epass 2003

earlier device steps (given by IT/ CRM)

Extract the ePass-Linux.zip downloaded file
For 64 bit Operating system select ePass2003-Linux-x64 and
for 32 bit Operating system select ePass2003-Linux-i386
Go to config folder \ePass2003-Linux-x64\config
And run the config.sh file using root user or sudo user
#sh config.sh
Message will be displayed run finished! For successful installation.
redist folder Contain library file and user manager tool
copy the libcastle.so.1.0.0 to /usr/lib64
#cp libcastle.so.1.0.0 /usr/lib64
#cd /usr/lib64/
#cp libeTPkcs11.so libeTPkcs11.sobkp
#mv libcastle.so.1.0.0 libeTPkcs11.so

Visit tender wizard

Visit TW site, Register -> UpdateDSCSerialNo->
Download DocSign.jnlp
Run the jnlp file from JWS

//go to oracle jre/bin from UI (say)
cd /home/test/Downloads/softwares/jdk-8u261-linux-x64/jdk1.8.0_261/jre/bin
open/ click control panel file & do respective settings like
- General tab -> Security link -> Security level from very high to high
  - Add https://www.tenderwizard.com to Exception site list
- Advanced tab, enable logging & other stuff

//go to oracle jre/bin  (say)
cd /home/test/Downloads/softwares/jdk-8u261-linux-x64/jdk1.8.0_261/jre/bin

//run jnlp file using javaws from local user account (not sudo)  (say)
./javaws /home/test/Downloads/DocSign.jnlp

Also in browser, some setting to allow localhost JWS server URL

Email thunderbird

VPN issue

outgoing server smtp port say 587
encryption as TLS/ STARTTLS

Extension

Menu -> Addons -> Extensions -> Monterail //for theming
Menu -> Preferences -> Layout -> Vertical //for vertial view like outlook
Menu -> View -> SortBy -> GroupedBySort

Contacts

export outlook contacts as business card (.vcf)
Import in thunderbird
- Addressbook popup, Tools -> Import -> AddressBook -> Vcard File

Filters

https://support.mozilla.org/en-US/kb/organize-your-messages-using-filters

importing from outlook (style 1)

importing from outlook (style 2)

Download & install mailstore-home in windows
- Archive email -> outlook pst file (browse) -> run
- Export email -> Directory/ file system
In thunder bird, install ImportExportTools extension
- create a local folder in left folder pane
- right click new folder -> ImportExportTools -> Import all messages from directory -> also from it's sub directories(choose the exported earlier folder)

Domain User mapping

adding domain user to ubuntu
add following packages

sudo apt install realmd libnss-sss libpam-sss sssd sssd-tools adcli samba-common-bin oddjob oddjob-mkhomedir packagekit

discover domain

//example
sudo realm discover myCompany.com

Join admin user

//example
sudo realm join -U mySuperA myCompany.com

Permit other admin users

//example
sudo realm permit linuxBaba@myCompany.com

Auto create home dicrectory on login

sudo bash -c "cat > /usr/share/pam-configs/mkhomedir" <<EOF
Name: activate mkhomedir
Default: yes
Priority: 900
Session-Type: Additional
Session:
   required pam_mkhomedir.so umask=0022 skel=/etc/skel
EOF

sudo pam-auth-update

Useful BuiltIn Tools

Disks
System Monitor

Dev Tools

Node Programming (exists)
MongoDB database (exists)
Beyond compare (exists) //use VSCode git diff
Postman (exists)
Adobe XD (Not Available)
- Check Wine (Windows Instructions Emulator) or PlayOnLinux or other Windows Instruction set emulator.
- check popular web based tools like figma
- check open source like https://pencil.evolus.vn/

Communication & Docs

Outlook (Not Available)
- Use office 365 online browser application
- Check other alternatives email clients
Microsoft Office (Not Available)
- Use libre office..etc
- Use office 365
- Check other alternatives
  - https://getmailspring.com/
Dropbox, google drive (exists)
- rclone open source alternative to sync google drive, dropbox data
  - Experimental GUI
  - Docs

dropbox

Download deb file
Manual install file

sudo apt install ./package_file.deb

System

kaspersky (exists)
Remmina //for remote desktop
Ubuntu Remote Desktop link
Ubuntu to Windows Server RD XRDP link
cleaner alternative
LDAP (currently IT team uses windows specific ActiveDirectory)
- https://ubuntu.com/engage/microsoft-active-directory

gedit

preferences -> editor -> Auto save file every _ minutes
quick open : preferences -> plugins -> quick open //menu -> quick open to search by file name
menu -> view -> side panel
gedit-restore-tabs plugin

Others

Typing software
- klavaro
  sudo apt update
  sudo apt install klavaro -y
  Note: -y == --yes (to answer questions of Y/n with Y)

Domain Login

White paper//exists in Ubuntu folder

New LDAP

https://www.freeipa.org/ (Built on 389 & others)
OpenLDAP
389 Directory Serve by RedHat (Open source version of Red Hat Directory Server)

#OS

#Ubuntu 18.04 software status

#MS Office

#compatibility table

#Wine (style 1)

#Wine (style 2)

#Install playonlinux & dependencies

#MS Office from PlayOnLinux wizard

#Other references

#MS Teams

#Google Chrome

#Team Viewer

#Beyond compare

#git clients

#No Internet issue

#AnyDesk

#VSCode

#Fortinet client VPN

#Eclipse

#Oracle sql developer

#SQL hanging issue (Yogesh/ IT points)

#Oracle Instant Client (10g)

#e-token driver set up

#Prerequisite

#Drivers Download

#safenet or other .deb files

#epass 2003

#Visit tender wizard

#Email thunderbird

#VPN issue

#Extension

#Links

#Contacts

#Tags

#Filters

#importing from outlook (style 1)

#importing from outlook (style 2)

#Domain User mapping

#Useful BuiltIn Tools

#Dev Tools

#Communication & Docs

#dropbox

#System

#gedit

#Others

#Domain Login

#New LDAP

OS