File: README.WINDOWS.md

package info (click to toggle)
virtuoso-opensource 7.2.5.1+dfsg-3
  • links: PTS, VCS
  • area: main
  • in suites: bullseye, sid
  • size: 284,776 kB
  • sloc: ansic: 641,220; sql: 490,409; xml: 269,570; java: 83,893; javascript: 79,900; cpp: 36,927; sh: 31,648; cs: 25,702; php: 12,690; yacc: 10,227; lex: 7,601; makefile: 7,125; jsp: 4,523; awk: 1,697; perl: 1,013; ruby: 1,003; python: 326
file content (342 lines) | stat: -rw-r--r-- 10,720 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
Building on Windows
===================

This page gives instructions for building Virtuoso Open-Source Edition on
Windows 32- or 64-bit platforms.

You need the following development tools and software installed:

  * Microsoft Visual Studio 2003
  * Cygwin bash with developer tools (gawk, flex, bison) installed: 

	Package   Version 
	flex      2.5.33
	bison     2.3
	gperf     2.7.2
	gawk      3.1.1

  * Active Perl, available from http://www.activestate.com/ActivePerl
  * OpenSSL version 1.0.2 static libraries for Windows and header files.

Optionally you may want to install:

  * Java Development Kit (JDK) for Windows version 1.4 or above, available from
    java.sun.com
  * PHP library for Windows version 4 and header files.
  * Active Python, available from http://www.activestate.com/ActivePython
  * ImageMagick library, available from http://www.imagemagick.org/


Building the OpenSSL library
============================

The OpenSSL library needs to be built as a static library using Visual Studio.
The detailed instructions for building OpenSSL can be found in the INSTALL.W32
document in the OpenSSL source distribution.

IMPORTANT: by default the OpenSSL library is built using MSVCRT compile flags,
leading to conflicts when linking the Virtuoso Open-Source binaries. To resolve
the conflicts, after unpacking the OpenSSL source tarball, you need to edit the
/util/pl/VC-32.pl and change the "cflags" to use the "/MT" and "/MTd" compiler
switches instead of the "/MD" and "/MDd".

Finally the libeay32.lib and ssleay32.lib from /out32 and files from /inc32/
openssl must be copied to the <Virtuoso Open Source dir>/win32/openssl/

Microsoft Visual Studio (VS) 2003 settings
------------------------------------------

In order to allow VS to find the Cygwin developer tools (gawk, bison, flex),
the path to the Cygwin programs (e.g. c:\cygwin\bin) needs to be added to
standard settings.

To do this, execute the following steps:

  * Open Microsoft VS 2003 IDE
  * Open "Tools", then "Options"
  * In the "Options" menu select "Projects" settings
  * from "Projects" settings select "VC++ Directories"
  * add the Cygwin programs path to the list for "Executable files", before the
    /system32 directory in order that it uses cygwin's "find" command
  * Confirm the changes.

Microsoft Visual Studio (VS) 2005 settings
------------------------------------------
  * The same as for VS 2003
  * As the projects and solution are maintained under VS 2003, they must be
    converted in the VS 2005 format. To do this just open the solution under VS
    2005 and you will be asked to confirm project conversion.
  * When you are asked for conversion follow the instructions on screen.

Windows 64 bit
--------------
  * The pre-requisites are same as for Windows 32-bit except VS 2005 should be
    used.
  * To build the Windows 64-bit targets use the solution (VS 2005 format) from
    /win64.


Known issues
============
  * It's a known issue that bison version 2.1 that came with Cygwin bash
    generates buggy code. To resolve this, please upgrade  bison to 2.3
    or edit the generated files (sql3.c and turtle_p.c in libsrc/Wi)
    and remove the ';' after the 'yyparse' function begin:

...
#else
int
yyparse ()
;                       <-- remove this
#endif
#endif
...

  * The Virtuoso OLEDB provider cannot be built under VS 2005; it should be
    disabled.

Build targets
=============

Core components
---------------

  * virtuoso_t - the Virtuoso Server
  * isql, isqlo - SQL command line tools
  * virtoledb - Virtuoso OLEDB provider
  * wi, wic, dk1t, dksrv, threads, threadw, xml, zlib, tidy, util - library
    modules

Optional components
-------------------

  * tpcc, blobs, scroll, burstoff, cutter, cursor - test suite programs
  * libvirtuoso_t - the Virtuoso server shared object, needed for hosting
    servers
  * virtodbc - Virtuoso ODBC Driver
  * virtuoso_clr_t - .NET CLR-hosting server (requires .NET Framework SDK v1.1)
  * virtuoso_javavm_t - Java hosting server (requires Java SDK)
  * virtuoso_sample_t - sample of the Virtuoso server with extensions
  * hosting_perl - Perl hosting plugin (requires Active Perl)
  * hosting_python - Python hosting plugin (requires Active Python)
  * wikiv - Virtuoso Wiki plugin
  * im - ImageMagick plugin (requires ImageMagick library)


Building Virtuoso Open Source with Microsoft Visual Studio 2003
===============================================================

  * open the IDE
  * open the solution file from /win32/virtuoso-opensource.sln
  * select desired configuration (Debug or Release)
  * build the solution

Building optional components
----------------------------

PHP5 library notes
------------------

The following directories with the header files from the PHP5 source tree need
to be placed under /win32/php5/ :

  * ext/
  * main/
  * regex/
  * TSRM/
  * win32/
  * Zend/


Building the Virtuoso Open-Source Java hosting binary under Visual Studio 2003
------------------------------------------------------------------------------

  * Make sure that JDK 1.4 or later is installed (a JRE is not sufficient)
  * add environment setting JDK_PATH with value of JDK installation directory
    (e.q. c:\jdk1.5)
  * Start the Visual Studio IDE and enable the virtuoso_javavm_t target in the
    solution.
  * Build the virtuoso_javavm_t target

Building the Virtuoso Open-Source Perl hosting plugin
-----------------------------------------------------

  * Make sure Active Perl is installed
  * from the VS.NET 2003 command prompt, go to the /win32
  * run 'perl mkperlenv.pl'; this should produce output like:

    PERL_CFLAGS=...
    PERL_LDFLAGS=...

  * add the PERL_CFLAGS and PERL_LDFLAGS in the environment with values printed
    from the step above
  * Start the Visual Studio IDE and enable the hosting_perl target in the
    solution.
  * Build the hosting_perl plugin

Building the Virtuoso Open-Source Python hosting plugin
-------------------------------------------------------

  * Make sure Active Python is installed
  * from the VS.NET 2003 command prompt, go to the /win32
  * run 'python mkpythonenv.py'; this should produce output like:

    PYTHON_CFLAGS=...
    PYTHON_LDFLAGS=...

  * add the PYTHON_CFLAGS and PYTHON_LDFLAGS in the environment with values
    printed from the step above
  * Start the Visual Studio IDE and enable the hosting_python target in the
    solution.
  * Build the hosting_python plugin

Building the Virtuoso Open-Source ImageMagick plugin
----------------------------------------------------

  * Install the ImageMagick library, available from http://www.imagemagick.org/
  * add the IM_PATH in the environment with a value of ImageMagick installation
    directory
  * Start the Visual Studio IDE and enable the im target in the solution
  * Build the ImageMagick plugin

Running the tests
=================
Make sure that following binaries exists in /win32/[Release|Debug]

  * virtuoso-t.exe
  * isql.exe
  * blobs.exe
  * ins.exe
  * scroll.exe

  * Open a Cygwin bash shell
  * change directory to /
  * execute following commands

    export HOME=`pwd`
    export PATH=$HOME/win32/Release:$PATH
    export BLOBS=blobs.exe
    export INS=ins.exe
    export ISQL=isql.exe
    export PORT=5555
    export ENABLE_MTS_TEST=0
    export SCROLL=scroll.exe
    export GETDATA=getdata.exe

Note: replace in $PATH the 'Release' with 'Debug' if you are going to run the
tests using debug binaries.

  * change directory to /binsrc/tests/suite
  * run the tests :

    ./test_server virtuoso-t

Installation
============

ODBC Driver registration
------------------------

In order to register the Virtuoso Open-Source ODBC driver, perform the
following steps:

  * open a Command prompt
  * cd to the directory where the virtodbc.dll (Virtuoso Open Source ODBC
    Driver) is built.
  * execute:

    regsvr32 virtodbc.dll

  * A confirmation dialog stating that the driver was registered should be
    displayed.

Running the Demo Database
=========================
  * Make a folder e.g. c:\dbs\virtuoso
  * copy the Demo database and default demo.ini file to it

    cd c:
    cd \dbs\virtuoso
    copy <Virtuoso Open Source dir>\binsrc\samples\demo\demo.db
    copy <Virtuoso Open Source dir>\binsrc\samples\demo\demo.ini

  * create a Windows service to run the Virtuoso Open-Source server:

    SET PATH=<Virtuoso Open Source dir>\win32\Release
    virtuoso-t -c demo -I Demo -S create
    virtuoso-t -c demo -I Demo -S start

To connect with the command line SQL tool,

    isql 1112 dba dba

gives a SQL> prompt.

Type:

    SQL> use Demo;

to switch to the demo database, containing the Microsoft Northwind sample
tables. The help command of isql gives further instructions.

To use a web admin interface, point the browser to http://localhost:8890/
conductor .

To read the online documentation: http://localhost:8890/doc/html

To experiment with online tutorials http://localhost:8890/tutorial

For VAD Packages read the README file for Linux.

.NET CLR hosting server
=======================

In order to run the .NET CLR hosting server (virtuoso-clr-t),

  * Make a folder e.g. c:\dbs\virtuoso
  * copy the Demo database and default demo.ini file to it

    cd c:
    cd \dbs\virtuoso
    copy <Virtuoso Open Source dir>\binsrc\samples\demo\demo.db
    copy <Virtuoso Open Source dir>\binsrc\samples\demo\demo.ini

  * Register the virt_http.dll in the GAC:

   gacutil /i <Virtuoso Open Source dir>\win32\Release\virt_http.dll

  * Make sure virtclr.dll and virtuoso-clr-t are in the search path
  * To try the tutorial examples the Point.dll and tax.dll from \binsrc\
    tutorial\hosting\ho_s_2 directory must be copied in \win32\Release
    directory.

    SET PATH=<Virtuoso Open Source dir>\win32\Release
    virtuoso-clr-t -c demo -I Demo -S create
    virtuoso-clr-t -c demo -I Demo -S start

IMPORTANT: The current version of the .NET CLR hosting server is supported in
.NET Framework v1.1 environment

Java hosting server
===================

In order to run the Java hosting server (virtuoso-javavm-t),

  * Make a folder e.g. c:\dbs\virtuoso
  * copy the Demo database and default demo.ini file to it

    cd c:
    cd \dbs\virtuoso
    copy <Virtuoso Open Source dir>\binsrc\samples\demo\demo.db
    copy <Virtuoso Open Source dir>\binsrc\samples\demo\demo.ini

  * set the CLASSPATH to the place where Java classes are.
  * Make sure virtuoso-javavm-t is in the search path


    set CLASSPATH<Virtuoso Open Source dir>\binsrc\tutorial\hosting\ho_s_1;%CLASSPATH%
    SET PATHPATH<Virtuoso Open Source dir>\win32\Release
    virtuoso-javavm-t -c demo -I Demo -S create
    virtuoso-javavm-t -c demo -I Demo -S start