HP-UX Platform Installation Notes Revision: 2010-06-22 ================================= Supported HP-UX releases ------------------------ SQL/R is available for PA-RISC and Itanium architecture: * For PA-RISC based systems, HP-UX 11i version 1 (HP-UX 11.11) or above is required. * For Itanium based systems, HP-UX 11i version 2 (HP-UX 11.23) or above is required. Supported Eloquence releases ---------------------------- This SQL/R release supports Eloquence versions A.07.00 and above and also provides backwards compatibility to Eloquence A.05.20. License keys ------------ SQLR A.03.xx requires a license key version A.03.00 or above. Please request a permanent license key using the form included with the delivery or contact support@marxmeier.com. During installation, you have the option to create a temporary license key which is valid for four weeks. When using Eloquence with the free Personal Edition license option SQL/R provides a free two user license. System Requirements ------------------- SQL/R requires disk space in the /etc, /opt and /var file systems as indicated below: 1. PA-RISC based system: Temporary disk space for unpacking the distribution file: 14 MB File systems: /opt 14 MB /etc 1 MB /var 1 MB 2. Itanium2 based system: Temporary disk space for unpacking the distribution file: 14 MB File systems: /opt 18 MB /etc 1 MB /var 1 MB During runtime SQL/R may use the /var/tmp filesystem for store temporary results. The amount of disk space required depends on the query results. Installation ------------ SQL/R is available as a depot package and is installed with swinstall. If you encounter a problem during installation, please send us a notice at support@marxmeier.com. SQL/R installation files available for download from the marxmeier.com ftp server are compressed with gzip and must be uncompressed before installation. Different versions of the SQL/R software is available. Please choose the appropriate version which corresponds with your hardware: SQLR-A03XX-X.pa11.depot.gz SQL/R depot file for the PA-RISC platform SQLR-A03XX-X.ia64.depot.gz SQL/R depot file for the IA64 platform As "superuser", follow the steps below to install the SQL/R software. 1. Unpack the archive at a temporary location gzip -d SQLR-A03XX-X.pa11.depot.gz This uncompresses the depot file SQLR-A03XX-X.pa11.depot.gz to SQLR-A03XX-X.pa11.depot. The compressed archive file is deleted. 2. Run "swinstall" by typing: /usr/sbin/swinstall -s /tmp/SQLR-A03XX-X.pa11.depot where /tmp/SQLR-A03XX-X.pa11.depot is the absolute path of the SQLR-A03XX-X.pa11.depot file. 3. In the Software Selection Window, select/highlight the product options you would like to install then choose the "Mark for Install" item from the Actions Menu. The "Marked?" column will automatically be set to "Yes". 4. Select the "Install (analysis...)" item from the Actions Menu. When the analysis is finished with no error, i.e. Status:Ready, choose OK. 5. Choose Yes in the Confirmation window to begin the actual installation process. When the installation is completed, a dialog is displayed to notify you that the install task is completed. You may exit then. To update an existing SQL/R installation, please shut down SQL/R using the command below: /sbin/init.d/sqlr2 stop After the update has finished SQL/R can be started with the command below: /sbin/init.d/sqlr2 start Automatic startup of SQL/R servers during boot is only configured in the /etc/rc.config.d/sqlr2 configuration file. SQL/R - Getting started ======================= After the SQL/R server has been installed, the following steps should be taken to configure it. 1. Create an sqlr user and group 2. Verify the system configuration 3. Modify the odbc.cfg configuration file 4. Configure SQL/R automatic startup 5. Configuring data sources Create an sqlr user and group ----------------------------- The SQL/R server is started as root and then switches to a configured user/group (as specified in the odbc.cfg config file). It is recommended to add a dedicated group and user that are used with the SQL/R server components. The user account should be disabled as it is not used for a login. Verify the system configuration ------------------------------- The SQL/R server process (sqlrodbcd) defaults to the use of the sqlrodbc service name. This should have been added to your /etc/services file during installation. A line like below should be present in your /etc/services file: sqlrodbc 8003/tcp # SQL/R ODBC By default, the sqlrodbc service is mapped to the port 8003. Please make sure thatthis port is not used otherwise on the system. The port number is arbitrary but all client/server must use the same port number. Modify the odbc.cfg configuration file -------------------------------------- The SQL/R server process (sqlrodbcd) is configured through the /etc/opt/sqlr2/odbc.cfg confguration file. The following configuration values may need to be changed: User = sqlr Group = sqlr Please uncomment the lines and repleace the user/group that shoud be used by the SQL/R server process. #Service = sqlrodbc This specifies the service name (or port number) that should be used by the SQL/R server. This is typically not changed. #tmpDir = /var/tmp This points to a location that is used by the SQL/R server to store temporary results. This is typically not changed. #LogFile = syslog This configuration item specifies where SQL/R log messages should be written to. By default the system wide syslog is used (/var/adm/syslog/syslog.log). As an option this may specify a different file name. #LogFlags = *0 This configuration item specifies the SQL/R log level. the default is *0 that only outputs critical messages. As an option you may consider to change this to *1 to also output any informational messages. Different values should only be used when requested by the support. Configure SQL/R automatic startup --------------------------------- The SQL/R product may be started automatically when the system is booted. this is configured in the /etc/rc.config.d/sqlr2 configuration file: Set the variable START_SQLR to 1 to enable automatic startup. The SQL/R server may be started/shut down manually with the commands below (requires root privileges): /sbin/init.d/sqlr2 start /sbin/init.d/sqlr2 stop Configuring data sources ------------------------ The /etc/opt/sqlr2/odbc.dsn configuration file is used to specify any data sources that should be accessible through SQL/R. A data source could be a single database or multiple databases that are then presented as a single data source. For example: [Example] Database = localhost:eloqdb/db #Login = #Password = Alias = EX #Repository = /opt/sqlr2/share/db.e/db.rep UserList = public This specifies the data source "Example" that is built from the database db. In case the Eloquence database server requires a login to access the data, the Login and Password configuration items must be specified. Please note that the Login and Password configuration items are specific to a single database and must be specified for each database (or omitted in case the most recent login is cached).