Hi Hugh, Thanks for your quick support! The pre-built demo.dav.vad package from your download link worked immediately.
We did not however do anything special to build ours. In fact we just installed the debian package available in the debian directory of the virtuoso-opensource-6.1.2 archive (dated July 9). Demo.vad was part of the result. Can you give us an advice on how to proceed? We are novice users of virtuoso, and now that this 'easy' exercise failed, we're doubting a bit on the quality of our installation from the archive... Martin. -----Original Message----- From: Hugh Williams [mailto:hwilli...@openlinksw.com] Sent: dinsdag 7 september 2010 14:17 To: Martin Vanbrabant Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Issues installing package 'Demo' with virtuoso 06.01.3127 on debian Hi Martin, I presume then you compiled the demo_dav.vad package yourself ? From an empty database can you please try installing the pre-built demo.dav.vad package available from: http://s3.amazonaws.com/opldownload/uda/vad-packages/6.1/virtuoso/demo_dav.vad Your version seems rather old as build I have is 1.107.66/ 2010-07-10 , which should also be the version installed from the above link, and I expect would be the version compiled from the archive you downloaded ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 7 Sep 2010, at 11:19, Martin Vanbrabant wrote: > Hi, > > We have installed the debian package from the virtuoso download > http://sourceforge.net/projects/virtuoso/files/virtuoso/6.1.2/virtuoso-opensource-6.1.2.tar.gz/download > (Version: 06.01.3127) on debian (lenny), on a machine where virtuoso was not > installed earlier. > > We have issues installing package 'Demo' (1.107.34) from > http://localhost:8890, Conductor, tab System Admin / Packages. > After trying to install the package, this page is shown in the end: > ----- > 00000 Errors detected > 00000 Installation of "Demo Database" was unsuccessful. > The installation of this VAD package has failed. > Please delete the transaction file /var/lib/virtuoso/db/virtuoso.trx > and then restart your database server. > Note: Your database will be in its pre VAD installation state after you > restart. > 00000 FATAL > ----- > Looking in virtuoso.log, these lines were added: > --- > 16:44:47 Checkpoint started > 16:44:47 Checkpoint finished, log reused > 16:48:36 PL LOG: No WHENEVER statement provided for SQLCODE 100 > while executing the following statement: > --no_c_escapes- > DB.DBA.LOAD_THALIA_ONTOLOGY_FROM_DAV() > in file: > /DAV/Thalia/thalia_sql_to_rdf_views_generation. > 16:48:37 PL LOG: Errors where detected during installation of "Demo Database". > 16:48:37 PL LOG: The installation of this VAD package has failed. > 16:48:37 PL LOG: Please delete the transaction file > 16:48:37 PL LOG: /var/lib/virtuoso/db/virtuoso.trx > 16:48:37 PL LOG: and then restart your database server. > 16:48:37 PL LOG: Note: Your database will be in its pre VAD installation > 16:48:37 PL LOG: state after you restart. > 16:48:40 Server shutdown complete > ----- > Our installation is really "out of the box". This is our virtuoso.ini file: > ----- > ; > ; Database setup > ; > [Database] > DatabaseFile = virtuoso.db > ErrorLogFile = virtuoso.log > LockFile = virtuoso.lck > TransactionFile = virtuoso.trx > xa_persistent_file = virtuoso.pxa > ErrorLogLevel = 7 > FileExtend = 200 > MaxCheckpointRemap = 2000 > Striping = 0 > TempStorage = TempDatabase > > > [TempDatabase] > DatabaseFile = virtuoso-temp.db > TransactionFile = virtuoso-temp.trx > MaxCheckpointRemap = 2000 > Striping = 0 > > > ; > ; Server parameters > ; > [Parameters] > ServerPort = 1111 > LiteMode = 0 > DisableUnixSocket = 1 > DisableTcpSocket = 0 > ;SSLServerPort = 2111 > ;SSLCertificate = cert.pem > ;SSLPrivateKey = pk.pem > ;X509ClientVerify = 0 > ;X509ClientVerifyDepth = 0 > ;X509ClientVerifyCAFile = ca.pem > ServerThreads = 20 > CheckpointInterval = 60 > O_DIRECT = 0 > NumberOfBuffers = 2000 > MaxDirtyBuffers = 1200 > CaseMode = 2 > MaxStaticCursorRows = 5000 > CheckpointAuditTrail = 0 > AllowOSCalls = 0 > SchedulerInterval = 10 > DirsAllowed = ., /usr/share/virtuoso/vad > ThreadCleanupInterval = 0 > ThreadThreshold = 10 > ResourcesCleanupInterval = 0 > FreeTextBatchSize = 100000 > SingleCPU = 0 > VADInstallDir = /usr/share/virtuoso/vad/ > PrefixResultNames = 0 > RdfFreeTextRulesSize = 100 > IndexTreeMaps = 256 > > > > [HTTPServer] > ServerPort = 8890 > ServerRoot = /var/lib/virtuoso/vsp > ServerThreads = 20 > DavRoot = DAV > EnabledDavVSP = 0 > HTTPProxyEnabled = 0 > TempASPXDir = 0 > DefaultMailServer = localhost:25 > ServerThreads = 10 > MaxKeepAlives = 10 > KeepAliveTimeout = 10 > MaxCachedProxyConnections = 10 > ProxyConnectionCacheTimeout = 15 > HTTPThreadSize = 280000 > HttpPrintWarningsInOutput = 0 > Charset = UTF-8 > > [AutoRepair] > BadParentLinks = 0 > > [Client] > SQL_PREFETCH_ROWS = 100 > SQL_PREFETCH_BYTES = 16000 > SQL_QUERY_TIMEOUT = 0 > SQL_TXN_TIMEOUT = 0 > ;SQL_NO_CHAR_C_ESCAPE = 1 > ;SQL_UTF8_EXECS = 0 > ;SQL_NO_SYSTEM_TABLES = 0 > ;SQL_BINARY_TIMESTAMP = 1 > ;SQL_ENCRYPTION_ON_PASSWORD = -1 > > [VDB] > ArrayOptimization = 0 > NumArrayParameters = 10 > VDBDisconnectTimeout = 1000 > KeepConnectionOnFixedThread = 0 > > [Replication] > ServerName = db-LISA > ServerEnable = 1 > QueueMax = 50000 > > > ; > ; Striping setup > ; > ; These parameters have only effect when Striping is set to 1 in the > ; [Database] section, in which case the DatabaseFile parameter is ignored. > ; > ; With striping, the database is spawned across multiple segments > ; where each segment can have multiple stripes. > ; > ; Format of the lines below: > ; Segment<number> = <size>, <stripe file name> [, <stripe file name> .. ] > ; > ; <number> must be ordered from 1 up. > ; > ; The <size> is the total size of the segment which is equally divided > ; across all stripes forming the segment. Its specification can be in > ; gigabytes (g), megabytes (m), kilobytes (k) or in database blocks > ; (b, the default) > ; > ; Note that the segment size must be a multiple of the database page size > ; which is currently 8k. Also, the segment size must be divisible by the > ; number of stripe files forming the segment. > ; > ; The example below creates a 200 meg database striped on two segments > ; with two stripes of 50 meg and one of 100 meg. > ; > ; You can always add more segments to the configuration, but once > ; added, do not change the setup. > ; > [Striping] > Segment1 = 100M, db-seg1-1.db, db-seg1-2.db > Segment2 = 100M, db-seg2-1.db > ;... > > ;[TempStriping] > ;Segment1 = 100M, db-seg1-1.db, db-seg1-2.db > ;Segment2 = 100M, db-seg2-1.db > ;... > > ;[Ucms] > ;UcmPath = <path> > ;Ucm1 = <file> > ;Ucm2 = <file> > ;... > > > [Zero Config] > ServerName = virtuoso (LISA) > ;ServerDSN = ZDSN > ;SSLServerName = > ;SSLServerDSN = > > > [Mono] > ;MONO_TRACE = Off > ;MONO_PATH = <path_here> > ;MONO_ROOT = <path_here> > ;MONO_CFG_DIR = <path_here> > ;virtclr.dll = > > > [URIQA] > DynamicLocal = 1 > DefaultHost = localhost:8890 > > > [SPARQL] > ;ExternalQuerySource = 1 > ;ExternalXsltSource = 1 > ;DefaultGraph = http://localhost:8890/dataspace > ;ImmutableGraphs = http://localhost:8890/dataspace > ResultSetMaxRows = 10000 > MaxQueryCostEstimationTime = 400 ; in seconds > MaxQueryExecutionTime = 60 ; in seconds > DefaultQuery = select distinct ?Concept where {[] a > ?Concept} > DeferInferenceRulesInit = 0 ; controls inference rules loading > ;PingService = http://rpc.pingthesemanticweb.com/ > > > [Plugins] > LoadPath = /usr/lib/virtuoso/hosting > Load1 = plain, wikiv > Load2 = plain, mediawiki > Load3 = plain, creolewiki > ;Load4 = plain, im > ;Load5 = plain, wbxml2 > ;Load6 = plain, hslookup > ;Load7 = attach, libphp5.so > ;Load8 = Hosting, hosting_php.so > ;Load9 = Hosting,hosting_perl.so > ;Load10 = Hosting,hosting_python.so > ;Load11 = Hosting,hosting_ruby.so > ;Load12 = msdtc,msdtc_sample > ----- > Another (minor) issue occurs for the package 'doc' (1.1.18): after the > packages was installed, the link to "Local Offline" in > http://localhost:8890/doc/html/, pointing to > http://localhost:8890/doc/pdf/virtdocs.pdf is not working (The requested URL > was not found URI = '/doc/pdf/virtdocs.pdf'). > Not a major, but perhaps a symptom that can help solve the issue above. > > > Can anyone help me? > > Kind regards, > MartinV. > > > > > > > > > > ------------------------------------------------------------------------------ > This SF.net Dev2Dev email is sponsored by: > > Show off your parallel programming skills. > Enter the Intel(R) Threading Challenge 2010. > http://p.sf.net/sfu/intel-thread-sfd > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users