05/09/2014

[TIBCO Spotfire] Link to a specific Web Player analysis page

Linking to a specific page from a Tibco Spotfire Web Player-served analysis is pretty easy.

You first need to enable the JavaScript API from the Web Player Web.config file under WEB_PLAYER_INSTALL_DIR\VERSION\webroot:

find the section and change the value to true, then restart the Web Player site from IIS.

You can now create direct links to the report pages using URLs in the format:

http(s)://web_player_url:web_player_port/SpotfireWeb/ViewAnalysis.aspx?file=/path_to_analysis&configurationBlock=SetPage(pageTitle="page_name");

where page_name is NOT case sensitive, or:

http(s)://web_player_url:web_player_port/SpotfireWeb/ViewAnalysis.aspx?file=/path_to_analysis&configurationBlock=SetPage(pageIndex="page_number");


where page_number starts from 0

Note the mandatory semicolon (;) at the end of the URL

[Suse] Configure LDAP server error "is ldapi enabled" from YaST

Suppose you configured your LDAP server (openLDAP) in Suse (which is STILL free after the trial period, you just don't receive updates) via YaST, but unticked the "use ldapi" checkbox.

You'll find out that you can no longer configure it via YaST due to an error "[...] is ldapi enabled?". Unfortunately, you cannot re-enable it via YaST now, but you can still do so via configuration file.

Edit /etc/sysconfig/openldap with a text editor of your choice and set:

OPENLDAP_START_LDAPI = "yes"

then restart the server

sudo /etc/init.d/ldap restart

[Apache Tomcat] Find server version from command line

A quick way to find Tomcat's server version from command line is to run:

java -cp catalina.jar org.apache.catalina.util.ServerInfo

from the TOMCAT_INSTALL_DIR/tomcat/lib folder

[VirtualBox] Resize virtual hard disk

Resizing a virtual HD on VirtualBox is a fairly simple process but may involve using a third party tool too.

Changing the virtual disk size can be achieved using the modifyhd command from command line:

VBoxManage modifyhd .vdi --resize NEW_SIZE

Note that this will just resize the HD, the guest OS will NOT automatically adapt to these changes, meaning that you'll have to manually shrink/expand the virtual HD partitions before starting the OS again.

You can do that with, for example, GParted, which comes with as a handy live cd (iso) too; just download the image and link it as virtual CD then start the machine and boot from CD drive.

[Oracle] Stop/start database and listener from command line

You can start or stop an Oracle database instance (you can dbca to configure one) from command line via the SQLPlus tool by connecting to it as SYSDBA user:

sqlplus
CONNECT SYS as SYSDBA

then to stop:

SHUTDOWN NORMAL

and to start:

STARTUP

To manage listeners on Linux (use netca to configure one) you can run instead:

$ORACLE_HOME/bin/lsnrctl stop|start

Where is the name of the listener as configured via netca or found as the output of:

ps -ef | grep tnslsnr

[VirtualBox] Linux guest additions installation fails due to missing kernel sources

If the installation of VirtualBox's guest additions packages fails on Linux due to missing kernel sources, just install them (google install kernel sources to find many detailed guides for your particular OS) as well as make and gcc.

Then, from a console do a:

export KERN_DIR=path_to_the_sources

before running the install script