# 2. Installation Guide

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Installation Guide
Virtuoso for Windows 95/98/NT/2000/XP
Virtuoso for Linux
Virtuoso for Unix
Existing Virtuoso 2.7 Users Before You Install Installation Process Post-Installation Sanity Check Starting Virtuoso Automatically on Reboot Default passwords
Virtuoso for Mac OS X

## 2.3. Virtuoso for Unix

### 2.3.1. Existing Virtuoso 2.7 Users

You can migrate your existing Virtuoso servers to 3.0 using the migration utility. The Virtuoso database file structure has been considerably altered between versions. Please consult the Migration of Virtuoso from Version 2.7 to Version 3.0 section for more details.

### 2.3.2. Before You Install

To ensure a smooth installation, please review the following checklist before you start the setup program.

#### 2.3.2.1. Have you downloaded the software?

If you have not already done so, please download your copy of OpenLink Virtuoso from the Virtuoso web site. The URL is http://www.openlinksw.com/virtuoso/. When you visit the site, select "Software Download".

#### 2.3.2.2. Reinstalling Virtuoso?

If you are reinstalling Virtuoso, you must first stop the Database Servers. You can shut these services down with the following command executed from your UNIX shell prompt:

    sh virtuoso-stop.sh

or

    virtuoso-stop.sh

or

    ./virtuoso-stop.sh

#### 2.3.2.3. Are ports 1111, 1112, 8889 and 8890 free?

During the installation you will be prompted for an HTTP port number for use by each Virtuoso System Manager. If you are already running a web server or other listener on that port, you will encounter problems, and should choose another free port when you are prompted.

By default, the Virtuoso DBMS listens on port 1111. If this port is currently in use by another server then after the installation completes you will need to change the port number in the Local Virtuoso ODBC or UDBC DSN that is created during the installation process, and also in the following file:

    $<Installation Directory>/bin/virtuoso.ini

typically

    /usr/home/virtuoso

To check if a port is in use you can use the following command, and review the output:

    netstat -an | more

#### 2.3.2.4. Do you already have a "virtuoso" user account on your UNIX system ?

Please create a UNIX user account called "virtuoso".

#### 2.3.2.5. Do you already have functional iODBC data sources on your system ?

The OpenLink Virtuoso for UNIX installation presumes the following:

- You intend to connect to a Local Virtuoso server using iODBC or OpenLink UDBC
- You intend to connect to one or more Remote Virtuoso servers on your network using iODBC or UDBC
- You intend to Attach tables hosted within non-local or Remote Virtuoso database servers, into a Local or Remote Virtuoso Server
- The existence of functional OpenLink or third-party iODBC drivers for UNIX that connect to the non database servers referred to above.
- In the absence of iODBC drivers for your non Virtuoso database, that a functional OpenLink or third-party UDBC Drivers exists for these database servers.

If you are using OpenLink Multi-Tier ODBC Drivers for your remote database connections then we highly recommend the use of the Web Assistant for creating iODBC Data Source Names.

#### 2.3.2.6. Are your iODBC Data Source Names functional ?

It is a useful sanity-check to ensure that your iODBC or UDBC data sources are functional, OpenLink provides an "odbctest" program for verifying basic usability of iODBC data sources. Both of these programs reside in the "samples" directory situated beneath the directory into which Virtuoso is installed.

### 2.3.3. Installation Process

Once you have downloaded the required tar file from the web or ftp site and have placed the file in a designated installation directory you are ready to commence the Virtuoso installation process.

You may want to specify a new user to own the Virtuoso installation and then you can place the installation tar file into that users home directory.

1. First step is to un-tar the file to obtain the install script and archive file. Use the following command:

       tar xvf <tar file>.tar

   replacing <tar file> with the relevant name of the file you downloaded.

2. run the install script using the following command:

       [virtuoso@myserver virtuoso]$ sh /install.sh

   The installation process will now begin and prompt you for required information.

3. The install script will first try and detect running Virtuoso server instances. In cases where an old Virtuoso server is being upgraded you must ensure that the old Virtuoso is first shutdown. It is advisable that you backup up your systems before continuing.

       Checking requested components
       Checking for existing installations and/or instances of Virtuoso...
        7269 ?        00:06:23 virtuoso
       /proc/net/tcp: Permission denied

       ** Alert: [running processes; ]

       ** Warning: You have Virtuoso previously installed on this machine.
       **
       ** To avoid existing data being overwritten or lost, you may press ^C to
       ** exit this installer, terminate and remove the existing installation,
       ** or proceed taking care to enter non-conflicting data below, by pressing
       ** Enter.

4. If you are upgrading a server then the installer will save copies of old configuration data for later use.

       Preserving any existing configurations...
       find: db: No such file or directory
       find: demo: No such file or directory
       find: bin: No such file or directory
       0 blocks

5. You should have received a license file via email. This file should be copied to the server installation directory prior to installation. The installer will ask you for its location if none is found. If you do not have the license file at this time the installer will still continue.

       Checking licensing...

       A license file is required for the Virtuoso Server Instance(s) to
       start. Please enter the full path and name of a valid Virtuoso
       license file [./virtuoso.lic]:

6. Now the installer will continue to install files from the package. Every file installed will be echoed to the screen.

       Unpacking enterprise.tar.Z
       bin/
       bin/v27/
       bin/v27/bin/
       ...
       ...
       vsp/releasenotes.css
       vsp/releasenotes.html
       vsp/vsp_auth.sql
       ...done

7. When the files have been installed from the package the location supplied for the license file will be checked. If one is not found then you will receive the following warning:

       **
       **  WARNING: The license file entered is not valid or does not exist.
       **           You will need to copy a valid license file manually
       **           to the demo and db directories after the Virtuoso installation completes.

8. The Virtuoso server installation has a few variations. The next question from the installer asks which one you want to make default. Even though each variation is installed, a convenient symbolic link will be made to bin/virtuoso from the selected type. Running ls -l in the bin directory after installation will reveal all.

       Checking for installed optional components...
       Please choose which Virtuoso server you wish to install:
         1) Universal Server
         2) Universal Server with iODBC
         3) Universal Server with iODBC and support for Java
         4) Universal Server with iODBC and support for PHP
         5) Universal Server with iODBC and support for Java and PHP
         6) Universal Server with iODBC and support for CLR Hosting via Mono
         7) Universal Server with iODBC and support for CLR and Java
         8) Universal Server with iODBC and support for CLR, Java and PHP4

       [8] :

9. The installer will search for required third-party components depending on which option is selected in the previous step. For example, choosing the Virtuoso with Java support will require a Java runtime. Results of the search are listed as suggestions from which you can confirm or type the actual location.

       Attempting to locate the java runtime library (libjvm.so)...

       Suggested file locations:
       /usr/local/lib
       /usr/local/jdk1.3/jre/lib/i386/classic
       /usr/local/jdk1.3/jre/lib/i386/server
       /usr/local/jdk1.3/jre/lib/i386/client
       /usr/opt/blackdown-jdk-1.3.1/jre/lib/i386/classic
       /usr/opt/blackdown-jdk-1.3.1/jre/lib/i386/server
       /usr/opt/blackdown-jdk-1.3.1/jre/lib/i386/client
       /usr/local/jdk1.3/jre/lib/i386/classic
       /usr/local/jdk1.3/jre/lib/i386/server
       /usr/local/jdk1.3/jre/lib/i386/client

       Please select one of the above locations or press Enter to use
       the default (/usr/local/jdk1.3/jre/lib/i386/client):

10. The Virtuoso installer includes a Mono runtime distribution, since Mono is a developing platform you may have your own installation that you can supply the path to here.

        Please enter the full path to the Mono installation directory or
        Enter to use the default (/home/openlink/virtuoso/mono)

11. Virtuoso now has enough information to configure its environment and startup scripts.

        Setting up initial values in scripts and config files
        Setting up file bin/odbc.ini
        Setting up file bin/odbcinst.ini
        Setting up file bin/demo-start.sh
        Setting up file bin/demo-stop.sh
        Setting up file bin/virtuoso-start.sh
        Setting up file bin/virtuoso-stop.sh
        Setting up file db/virtuoso.ini
        Setting up file demo/demo.ini
        Setting up file mono/bin/mcs
        Setting up file virtuoso-enterprise.csh
        Setting up file virtuoso-enterprise.sh
        Setting up file initd_startup.template
        Setting up file initd_startup_demo.template

12. The installer will now ask a series of questions for configuring the Virtuoso .INI files. First confirm or alter the default database SQL listener port number. This is the port number that this database will be available for ODBC connections and iSQL sessions.

        Configuring port numbers for default and demo databases

        Please enter a port on which to run the default database
        SQL listener (default 1111):

13. Now you must specify the port number of the default database HTTP listener. This is the HTTP port that Virtuoso will listen on by default, you web-based administration interface for Virtuoso will be found here. If you confirm the default of 8889, then your Virtuoso will be available from: http://server:8889/, changing server to the name of your machine appropriately.

        Please enter a port on which to run the default database
        HTTP listener (default 8889):

14. Now you must supply a friendly name that you wish to identify your Virtuoso server by on the network using Zero Configuration.

    See Also:

    The Zero Configuration section.

        Please enter a name for default database Zero Configuration
        (default "Virtuoso Universal Server at myserver:1111"):

15. The Zero Configuration details need a default username to make the connection with.

        Please enter a user name for default database Zero Configuration
        (default "dba"):

16. Now we have all of the above details to supply again for the Demo Virtuoso database. The port number supplied here must be different to those supplied previously.

        Please enter a port on which to run the demo database
        SQL listener (default 1112):

        Please enter a port on which to run the demo database
        HTTP listener (default 8890):

        Please enter a name for demonstration database Zero Configuration
        (default Virtuoso Universal Server (demonstration) at myserver:1112):

        Please enter a user name for demonstration database Zero Configuration
        (default demo):

17. The Virtuoso servers have default administrator usernames of "dba". The "dba" accounts have the default password of "dba". It is recommended that you alter this as soon as possibly for security. The installer now provides the opportunity to do this the first time the server is started.

        Changing passwords for the Database Universal Server

        Please enter a replacement for the Default Database Server's
        SQL Administrative (dba) account password (twice) :
        Confirm Password :

18. The Virtuoso servers have default WebDAV administrator usernames of "dav". The "dav" accounts have the default password of "dav". It is recommended that you alter this as soon as possibly for security. The installer now provides the opertunity to do this the first time the server is started.

        Please enter a replacement for the Default Database's
        WebDAV administrative (dav) account password (twice) :
        Confirm Password :

        Please wait while the passwords are changed:

        Changing passwords for the Demo Universal Server

19. Likewise for the Demo server, you can change the default passwords:

        Please enter a replacement for the Demonstration Database Server's
        SQL Administrative (dba) account password (twice) :
        Confirm Password :

        Please enter a replacement for the Demonstration Database Server's
        WebDAV Administrative (dav) account password (twice) :
        Confirm Password :

        Please wait while the passwords are changed:
        done.

20. The file owner and group is changed at the end of the installation. You can choose what these shall be set to. By default the current user is selected.

        Please enter the username:group for the user and group who should own
        files in this installation (default: openlink:openlink) :
        Setting owners:

21. Finally the installer can start Virtuoso servers installed for you, but only if a valid license key has been supplied.

        The Virtuoso Installer has not offered to start a database as
        no license key was found. Evaluation users should receive
        one via e-mail; in case of difficulties please contact
        <Technical.Support@openlinksw.com>.

### 2.3.4. Post-Installation Sanity Check

A quick way to check that the database is running, is to point a browser to the http port. The following example URLs will show the System Manager for the default, and the demo Virtuoso databases:

    http://localhost:8889
    http://localhost:8890
    http://a_virtuoso_server.org:8890

See the following Quick Start chapter for further ways to verify the database.

### 2.3.5. Starting Virtuoso Automatically on Reboot

Two files, named initd_startup.template and initd_startup_demo.template, are placed in the top level of the Virtuoso installation directory. On systems using SysVinit (most Linux distributions, Solaris) the appropriate one should be copied into /etc/init.d/ and symlinks created in the rcN.d/ directories, e.g.:

    bash# cp initd_startup.template /etc/init.d/virtuoso

Perform some sanity checks here, that the directory it uses exists, etc:

    bash# vi /etc/init.d/virtuoso

Test that it works correctly:

    bash# /etc/init.d/virtuoso stop
    bash# /etc/init.d/virtuoso start

Finally, create symbolic links in the regular runlevel directories pointing to that script:

    bash# cd /etc/rc2.d ; ln -s ../init.d/virtuoso S99virtuoso
    bash# cd /etc/rc3.d ; ln -s ../init.d/virtuoso S99virtuoso
    bash# cd /etc/rc5.d ; ln -s ../init.d/virtuoso S99virtuoso

Virtuoso should now start when the service is restarted.

### 2.3.6. Default passwords

See the following Quick Start chapter for very important information about changing the default passwords.

Previous Virtuoso for Linux | Chapter Contents | Next Virtuoso for Mac OS X