ODS is now delivered as part of the Virtuoso Open Source 5.0 edition. This page provides instructions on installation of the ODS suite of Data Space applications.
Please note that ODS is preinstalled into the Virtuoso Demo Database. Thus, you do not need to perform the installation steps below if working with a Virtuoso 5.0 (or higher) demonstration database.
ODS depends on certain parameters in the Virtuoso Database Initialization File (INI file) e.g. "demo.ini" for the demonstration database. The settings in this file are appropriate for most installations. Thus, prior to starting the Virtuoso server you need to verify that the following parameters in the INI file are set:
For example:
[URIQA] DefaultHost = demo.mydomain.com:1112
See the URIQA section in the documentation for more details.
[Plugins] ... other plugins.. LoadPath = /usr/local/lib Load1 = plain,im Load2 = plain,wikiv Load3 = plain,mediawiki Load5 = plain,creolewiki ... other plugins ...
Once you have verified the server settings, the next step is to install the VAD packages.
For binary distributions and the tree made by make install, they are located in the share/virtuoso/vad directory under the installation root. If you are using the demo database, the packages are preinstalled.
The ODS VAD packages for this release include:
The next step is to install the VAD packages. With isql, run the following command:
SQL> VAD_INSTALL('<path of the VAD file>',0);
Install the files in the order of the above listing. The web pages of the packages will go into the server's WebDAV repository.
If you wish to offer virtual host names for applications, as in myblog.example.com, then the DNS has to be set up to direct *.example.com to the host where Virtuoso is running. If users will not choose virtual host names for their applications, this step can be skipped.
The larger part of configuration is performed through the browser:
You can skip these steps but then the map-related features will be disabled.
ODS is now ready for use.
Note: if you disable the default site registration, then in addition to the above the ODS admin will need to create user accounts for the site members.
In order to allow ODS users to create their own sub-domains (e.g. user.sample.domain, where ODS domain is sample.domain) the ODS should be configured via Conductor UI.
The following describes how to enable an ODS domain :
After performing the above steps, when creating a new application instance, the new domain will be selectable when choosing a virtual host name for the application.
The ODS pages can be modified by editing the .vspx and.css files in <Virtuoso OpenSource?>/appsrc/ODS-Framework/ and then re-build the ods_dav.vad and re-install it. Alternately, you can install the ods_filesystem.vad package which will put the dynamic web pages in the filesystem and you can edit them as the server is running, as you would edit any dynamic web pages under PHP or similar.
The users in ODS may wish to change the look and feel of their own home pages in the ODS. To do so, the user should go in 'Settings' page and enter the 'Home Page Template Selection'. In the presented text area he/she can edit the home page without any special permissions by ODS administrator.
Note: The current ODS version of the ODS contains one 'default' home page template, which can serve as a basis for customization.
IMPORTANT: Below are instructions for adding new user accounts if registrations are disabled.
This can be performed in the Conductor (pre-installed on the Demo Database):
Virtuoso provides a local mail delivery program (virt_mail) for SMTP servers. This program is used to store the received mail into the Virtuoso database.
The following instructions are applicable to UNIX systems using sendmail as a mail server.
[Options]
DSN = DSN=Virtuoso; HOST=localhost:1111;UID=dba;PWD=dba
;MaxMessageSize = 2097152
Verify = DB.DBA.WA_MAIL_VALIDATE ('$local')
Deliver = DB.DBA.WA_NEW_MAIL('$1', $message)
(You can probably leave the rest of the odbc_mail.ini alone.)
Note that DSN contains reference to the VOS server SQL port, so this should be replaced if non-default SQL port (1111) is used.
Replace the default local mailer in your sendmail.cf
...
#Mlocal, P=/usr/bin/procmail, F=lsDFMAw5:/|@qSPfhn9, S=EnvFromL/HdrFromL, R=EnvToL/HdrToL,
# T=DNS/RFC822/X-Unix,
# A=procmail -t -Y -a $h -d $u
Mlocal, P=/usr/bin/virt_mail, F=lsDFMA5:/|@qSPhn9, S=10/30, R=20/40,
T=DNS/RFC822/X-Unix,
A=virt_mail -c /etc/odbc_mail.ini -l $u -h $h -s $g
...
IMPORTANT: make sure that ODS packages are installed prior to making the changes above.
Send an e-mail to the 'dav' user account:
bash$ mail dav@<domain> Subject: virt-mail-test . Cc:
Using the ISQL tool check the mailbox of the 'dav' user account:
SQL> select mm_subj from mail_message where mm_own = 'dav'; MM_SUBJ VARCHAR _______________________________________________________________________________ virt-mail-test
If you see the subject of the mail which was sent in previous step, then the handler works correctly. Otherwise you should check the log of the sendmail program.
For the other mail server programs please consult INSTALL document in the <Virtuoso Open Source>/binsrc/maildrop/ directory.
Before to start you make sure that STMP services for Internet Information Services (IIS) are installed on your windows box.
To check that open Control Panel, Add or Remove Programs, Add/Remove Windows Components. In the "Internet Information Services" see Details there you must have "SMTP Service" installed, if not check and proceed with windows installation update. Please note that windows installation disk may be asked.
If SMTP Service is installed then proceed with following steps:
register.bat /register "domain-name"
assigning priority (0 of 32767) registered OpenLink MailDrop set priority Command to c:\vos\bin\virt_mail.exe
DSN = DSN=Virtuoso; HOST=localhost:1112;UID=dba;PWD=dba
SQL> smtp_send ('localhost:25', 'dba@testdomain', 'dba@testdomain', 'Subject: test\r\n\r\ntest');
Done. -- 26 msec.
SQL> select MM_SUBJ from mail_message;
MM_SUBJ
VARCHAR
_______________________________________________________________________________
test
1 Rows. -- 0 msec.
SQL>
You should see a row with text "test" in the result. Please note that "testdomain" should be replaced by your domain (see above).
Verify = DB.DBA.WA_MAIL_VALIDATE ('$local')
Deliver = DB.DBA.WA_NEW_MAIL('$1', $message)