Hi Bryan,
The separate VAD installation package is available for the Demo
database and has to be installed after starting your database
instance. Thus from the Virtuoso Conductor (http://localhost:8890/
conductor or whatever port you set for the HTTP server if you changed
it from the default in virtuoso.ini) in the System Admin -> Packages
tab you will see a list of available VAD packages one of which is
called "Demo" that you can install.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 26 Oct 2008, at 13:06, bryan rasmussen wrote:
Hi,
When I "Take a tour of the online programming tutorials. Having the
demo database running, point the browser to
http://localhost:8890/tutorial ." I get a 404.
I'm using the Windows binaries.
My server port is set to 1112
So exactly what do I have to do to get the demo database running. I
looked around for a bit and realized that the demo db is in the src,
so I got the src, went to samples/demo and took the mkdemo.bat
I put it in the bin directory and made the following changes to it
based on where I had the demo folder:
@echo off
del C:\projects\tests\proto-community\testsite\virtuoso-opensource
\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.db
del C:\projects\tests\proto-community\testsite\virtuoso-opensource
\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.trx
del C:\projects\tests\proto-community\testsite\virtuoso-opensource
\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.log
virtuoso-t -I demo -S create -c
C:\projects\tests\proto-community\testsite\virtuoso-opensource
\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\mkdemo
virtuoso-t -I demo -S start
isql localhost:1112 PROMPT=OFF VERBOSE=OFF
<C:\projects\tests\proto-community\testsite\virtuoso-opensource
\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\mkdemo.sql
NUL
isql localhost:1112 PROMPT=OFF VERBOSE=OFF EXEC=checkpoint >NUL
isql localhost:1112 PROMPT=OFF VERBOSE=OFF EXEC=shutdown >NUL
virtuoso-t -I demo -S delete
del C:\projects\tests\proto-community\testsite\virtuoso-opensource
\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.trx
del C:\projects\tests\proto-community\testsite\virtuoso-opensource
\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.log
Probably that is totally wrong.
But anyway when I ran it, it came with a number of errors - for
example
INSERT INTO Order_Details
(OrderID,ProductID,UnitPrice,Quantity,Discount) VALUES(
11070,2,19.000000,20,0.150000)
*** Error S1000: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]
SR306: INSERT
statement conflicted with FOREIGN KEY constraint referencing table
"Demo.demo.Or
ders"
at line 3451 of Top-Level:
INSERT INTO Order_Details
(OrderID,ProductID,UnitPrice,Quantity,Discount) VALUES(
11070,16,17.450000,30,0.150000)
which anyway the end result is that I am still getting a 404 on the
database. What is the best way to load the demos database?
Note I have also tried the same loaded on port 1111.
Best Regards,
Bryan Rasmussen
----------------------------------------------------------------------
---
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
