When you start up Virtuoso for the first time, there are 3 user accounts defined:
User Name | Default Password | Usage |
---|---|---|
dba | dba | Default Database Administrator account. |
dav | dav | WebDAV Administrator account. |
vad | vad | WebDAV account for internal usage in VAD (disabled by default). |
demo | demo | Default demo user for the demo database. This user is the owner of the Demo catalogue of the demo database. |
soap | soap | SQL User for demonstrating SOAP services. |
fori | fori | SQL user account for 'Forums' tutorial application demonstration in the Demo database. |
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.
The one database user is the database administrator with username "dba" and password "dba". This can be changed using the Interactive SQL 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:
set password <old password> <new password>
The password is an identifier, so take care to use proper quotation.
You can also use the graphical Virtuoso Administration Interface to administer Virtuoso database users.
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 Administration Interface under WebDAV Administration / WebDAV services / Users Administrator or use the SQL statement:
update WS.WS.SYS_DAV_USER set U_PASSWORD='<new password>' where U_NAME='<username>'
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.
Verify usability of your Virtuoso server by executing the following command from your command line prompt:
isql
From the ISQL prompt enter the following SQL command:
select * from DB.DBA.SYS_USERS;
This should produce a resultset containing one record if everything has been implemented correctly to this point.
![]() |
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/
On a Windows Client there is a shortcut to the OpenLink Virtuoso System Manager in the OpenLink Virtuoso program group.
You will be presented with the OpenLink Virtuoso System Manager screen:
![]() |
Click on the Administration button to enter the Virtuoso Server Administration Interface. You will be presented with a login dialog box, type in the correct details for the database DBA user, by default this is username=dba; password=dba.
![]() |
Expand the menu tree on the left of the screen to select Query Tools/Relational Data Using SQL.
![]() |
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 Execute.
You should see the SQL results, as shown below.
![]() |
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:
http://localhost:8890/
Note that that trailing / is important and may be required for older browsers
![]() |
The Administration button will take you to the Visual Server Administration Interface. Information about Visual Server Administration Interface can be found in the Server Administration chapter, which describes all the Interfaces available for configuring your server.
Previous
Contents of Quick Start & Tours |
Chapter Contents |
Next
Client Connections |