<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="3. Quick Start & Tours" />
<meta name="dc.subject" content="3. Quick Start & Tours" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="quicktours.html" title="Chapter Contents" />
<link rel="prev" href=".html" title="" />
<link rel="next" href="qsclientcon.html" title="Client Connections" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>3. Quick Start & Tours</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="newadminui" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>3. Quick Start & Tours</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="quicktours.html">Chapter Contents</a> | <a class="link" href="quicktours.html" title="Quick Start & Tours">Prev</a> | <a class="link" href="qsclientcon.html" title="Client Connections">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div class="selected">
<a href="quicktours.html">Quick Start & Tours</a>
</div>
<br />
<div class="selected">
<a href="newadminui.html">Where to Start</a>
<div>
<a href="#defpasschange" title="Default Passwords">Default Passwords</a>
<a href="#postinstsanity" title="Post-Installation Sanity Check">Post-Installation Sanity Check</a>
<a href="#administeringtheserver" title="Administering Your Virtuoso Installation">Administering Your Virtuoso Installation</a>
</div>
</div>
<div>
<a href="qsclientcon.html">Client Connections</a>
</div>
<div>
<a href="qsvdbsrv.html">Virtual Database Server</a>
</div>
<div>
<a href="qswebserver.html">Web Server</a>
</div>
<div>
<a href="qswebdav.html">WebDAV</a>
</div>
<div>
<a href="qswebservices.html">Web Services</a>
</div>
<div>
<a href="qstexpwsmodules.html">Exposing Persistent Stored Modules as Web Services</a>
</div>
<div>
<a href="qsvsmx.html">VSMX - Virtuoso Service Module for XML</a>
</div>
<div>
<a href="qssqltoxml.html">SQL to XML</a>
</div>
<div>
<a href="qsnntp.html">NNTP</a>
</div>
<div>
<a href="vspquickstart.html">Dynamic Web Pages</a>
</div>
<div>
<a href="qsvspexamples.html">VSP Examples</a>
</div>
<div>
<a href="qshostingplugs.html">Third-Party Runtime Typing, Hosting & User Defined Types</a>
</div>
<div>
<a href="troutips.html">Troubleshooting Tips</a>
</div>
<br />
</div>
<div id="text">
<a name="newadminui" />
<h2>3.1. Where to Start</h2>
<a name="defpasschange" />
<h3>3.1.1. Default Passwords</h3>
<p>When you start up Virtuoso for the first time, there are 3 user accounts defined:</p>
<table class="data">
<caption>Table: 3.1.1.1. Default users of Virtuoso</caption>
<tr>
<th class="data">User Name</th>
<th class="data">Default Password</th>
<th class="data">Usage</th>
</tr>
<tr>
<td class="data">dba</td>
<td class="data">dba</td>
<td class="data">Default Database Administrator account.</td>
</tr>
<tr>
<td class="data">dav</td>
<td class="data">dav</td>
<td class="data">WebDAV Administrator account.</td>
</tr>
<tr>
<td class="data">vad</td>
<td class="data">vad</td>
<td class="data">WebDAV account for internal usage in VAD (disabled by default).</td>
</tr>
<tr>
<td class="data">demo</td>
<td class="data">demo</td>
<td class="data">Default demo user for the demo database. This user is the owner of the Demo catalogue of the demo database.</td>
</tr>
<tr>
<td class="data">soap</td>
<td class="data">soap</td>
<td class="data">SQL User for demonstrating SOAP services.</td>
</tr>
<tr>
<td class="data">fori</td>
<td class="data">fori</td>
<td class="data">SQL user account for 'Forums' tutorial application demonstration in the Demo database.</td>
</tr>
</table>
<br />
<p>One database user and 2 WebDAV users. These users have their passwords set to default values.
It is therefore important to change them immediately after the installation.
</p>
<p>The one database user is the database administrator with username "dba" and
password "dba". This can be changed using the <a href="isql.html">Interactive SQL</a>
utility. When started without parameters, the ISQL tries to log on as dba with the default
password. The SQL statement to change a user's password is:
</p>
<div>
<pre class="programlisting">set password <old password> <new password></pre>
</div>
<p>The password is an identifier, so take care to use proper quotation.</p>
<p>You can also use the graphical <a href="htmlconductorbar.html#dbusersandgroups">Virtuoso Administration Interface</a>
to administer Virtuoso database users.
</p>
<p>The 2 WebDAV user accounts, dav and davuser also have their password set to their username. There
are 2 easy ways to change them. Either use the GUI in <a href="">Administration Interface</a>
under WebDAV Administration / WebDAV services / Users Administrator or use the SQL statement:
</p>
<div>
<pre class="programlisting">
update WS.WS.SYS_DAV_USER set U_PASSWORD='<new password>'
where U_NAME='<username>'
</pre>
</div>
<p>Note quotation around varchar values. Please remember to perform these operations for
all Virtuoso server instances installed. By default these are the Virtuoso with an empty
database and Virtuoso [demo] with the demo database.
</p>
<br />
<a name="postinstsanity" />
<h3>3.1.2. Post-Installation Sanity Check</h3>
<a name="posttestisql" />
<h4>3.1.2.1. Verify by ISQL</h4>
<p>Verify usability of your Virtuoso server by executing the following command from
your command line prompt:
</p>
<div>
<pre class="programlisting">isql</pre>
</div>
<p>From the ISQL prompt enter the following SQL command:
</p>
<div>
<pre class="programlisting">select * from DB.DBA.SYS_USERS;</pre>
</div>
<p> This should produce a resultset containing one record if everything has been implemented
correctly to this point.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="ISQL in Telnet" src="../images/ln-inst3.gif" />
</td>
</tr>
<tr>
<td>Figure: 3.1.2.1.1. ISQL in Telnet</td>
</tr>
</table>
<br />
<a name="posttesthttp" />
<h4>3.1.2.2. Verify by HTTP</h4>
<p>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:
</p>
<div>
<pre class="programlisting">
http://localhost:8889/
http://localhost:8890/
http://a_virtuoso_server.org:8890/
</pre>
</div>
<p>On a Windows Client there is a shortcut to the <strong>OpenLink Virtuoso Conductor</strong>
in the OpenLink Virtuoso program group.
</p>
<p>You will be presented with the OpenLink Virtuoso Conductor screen:</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Virtuoso Conductor" src="../images/ln-inst4.png" />
</td>
</tr>
<tr>
<td>Figure: 3.1.2.2.1. Virtuoso Conductor</td>
</tr>
</table>
<br />
<a name="posttestqry" />
<h4>3.1.2.3. Verify by web based SQL query</h4>
<p>Click on the <strong>Conductor</strong> link to enter the Virtuoso Server Administration
Conductor Interface. You will be presented with a login form, type in the correct details for the
database DBA user, by default this is username=dba; password=dba.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Virtuoso Conductor - Login Form" src="../images/ln-inst-login.png" />
</td>
</tr>
<tr>
<td>Figure: 3.1.2.3.1. Virtuoso Conductor - Login Form</td>
</tr>
</table>
<p>Got to tab "Database" and then go to tab "Interactive SQL".</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Virtuoso Conductor - Interactive SQL" src="../images/ln-inst-isql.png" />
</td>
</tr>
<tr>
<td>Figure: 3.1.2.3.2. Virtuoso Conductor - Interactive SQL</td>
</tr>
</table>
<p>Enter the SQL Statement command "SELECT * FROM SYS_USERS" in the SQL Statement text area. Note that
only valid SQL can be supplied, so you cannot type a database command such as "tables;". Also, note that
the ";" is not valid in this context. Press <strong>Execute</strong>.
</p>
<p>You should see the SQL results, as shown below.</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Virtuoso Conductor - SQL Results" src="../images/ln-inst-isql2.png" />
</td>
</tr>
<tr>
<td>Figure: 3.1.2.3.3. Virtuoso Conductor - SQL Results</td>
</tr>
</table>
<br />
<br />
<a name="administeringtheserver" />
<h3>3.1.3. Administering Your Virtuoso Installation</h3>
<p>Virtuoso has been designed for Web based Administration. With your Virtuoso server running you
will be able to point a Web browser at the servers listening address and port. The installation will
include the default server and optionally the demo database server. The default server listens on port 8890
whilst the demo server listens on port 8889. If you are using the machine where Virtuoso was installed then
the server address can be localhost or the hostname otherwise you will need to know the hostname or
IP address of the machine where Virtuoso was installed. The URL that you will want to point your browser
may be:
</p>
<div>
<pre class="programlisting">
http://localhost:8890/
</pre>
</div>
<p>Note that that trailing / is important and may be required for older browsers</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Visual Server Administration Interface" src="../images/ln-inst4.png" />
</td>
</tr>
<tr>
<td>Figure: 3.1.3.1. Visual Server Administration Interface</td>
</tr>
</table>
<p>The "Conductor" link will take you to the Visual Server Administration Interface.
Information about <a href="">Visual Server Administration Interface can be found
in the Server Administration chapter</a>, which describes all the Interfaces available for
configuring your server.
</p>
<br />
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="quicktours.html" title="Quick Start & Tours">Previous</a>
<br />Contents of Quick Start & Tours</td>
<td align="center" width="34%">
<a href="quicktours.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="qsclientcon.html" title="Client Connections">Next</a>
<br />Client Connections</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
817
