Hello, if you wan't to import data to virtuoso be sure you have allowed virtuoso to read from the dir that contains your data(virtuoso.ini)! I have successfully loaded dbpedia data into virtuoso with a script hugh williams offers around this maillist. Go and find it, you will have less trouble. I have also modified this script, so the right method to import data is chosen for nt(DB.DBA.TTLP_MT) or rdf/xml(DB.DBA.RDF_LOAD_RDFXML) files.
Loading big files takes a while so don't give up buddy. P.S. Some files of dbpedia are corrupt, so if you try to load it directly via isql, you don't have success. The script loads each line seperatly and skips the defect line not the whole file! So long, Armin Am Mittwoch, den 15.04.2009, 03:44 +0700 schrieb Ivan Mikhailov: > Hello Jem, > > file_to_string_output() can flush part of string session to a temporary > file if the session is too long to keep it in memory. On almost all OSes > it makes the file in the working directory of the process, say, in the > current directory of the shell that launched the executable. It's > advisable to start from writable directory. > > In this particular case, it is better to use > DB.DBA.TTLP_MT_LOCAL_FILE > ( '/data/virtuoso/dbpediaLoad/longabstract_en.nt', '', > 'http://*****.newsonline.tc.nca.bbc.co.uk/test', 17) > that will parse the file directly, without wasting time and disk for > temporary copy. > > Best Regards, > > Ivan Mikhailov > OpenLink Software > http://virtuoso.openlinksw.com > > On Tue, 2009-04-14 at 17:21 +0100, Jem Rayfield wrote: > > To clarify. > > > > My question is... > > > > Why is virtuoso trying to use > > > > /home/virtuoso/database//sestmE28h > > > > When my virtuoso.ini is not specifying this? > > > > How can I configure Virtuoso to use a different directory. I gues this > > will fix my problems? > > > > I need all data temp or otherwise to go on a different mount. /data. > > > > Cheers > > Jem > > > > > > > > > > ______________________________________________________________________ > > From: Jem Rayfield > > Sent: 14 April 2009 17:15 > > To: virtuoso-users@lists.sourceforge.net List > > Subject: ttlp_mt problem > > > > > > > > Hi, > > > > I am trying to upload dbpedia N3 triples... using: > > > > isql 1111 dba ****** verbose=on banner=off prompt=off echo=ON > > errors=stdout exec="ttlp_mt (file_to_string_output > > ('/data/virtuoso/dbpediaLoad/longabstract_en.nt'), '', > > 'http://*****.newsonline.tc.nca.bbc.co.uk/test', 17); checkpoint;" > > > > > > However I am getting the following errors (many): > > > > 17:05:14 Can't write to file /home/virtuoso/database//sestmE28h > > > > My virtuoso.ini is as follows and has no references > > to /home/virtuoso/database. > > > > My dir structure is > > > > /data/virtuoso/<db/trx/etc> > > /home/virtuoso/<install> > > > > Any ideas appreciated > > > > Thanks > > Jem > > > > > > > > /home/virtuoso/database/virtuoso.ini --> > > > > ; > > ; virtuoso.ini > > ; > > ; Configuration file for the OpenLink Virtuoso VDBMS Server > > ; > > ; To learn more about this product, or any other product in our > > ; portfolio, please check out our web site at: > > ; > > ; http://www.openlinksw.com > > ; > > ; or contact us at: > > ; > > ; general.informat...@openlinksw.com > > ; > > ; If you have any technical questions, please contact our support > > ; staff at: > > ; > > ; technical.supp...@openlinksw.com > > ; > > ; > > ; Database setup > > ; > > [Database] > > DatabaseFile = /data/virtuoso/virtuoso.db > > ErrorLogFile = /data/virtuoso/virtuoso.log > > LockFile = /data/virtuoso/virtuoso.lck > > TransactionFile = /data/virtuoso/virtuoso.trx > > ErrorLogLevel = 7 > > FileExtend = 200 > > MaxCheckpointRemap = 1000000 > > MaxMemPoolSize = 0 > > StopCompilerWhenXOverRunTime = 1 > > DefaultIsolation = 2 > > Striping = 0 > > xa_persistent_file = /data/virtuoso/virtuoso.pxa > > > > [TempDatabase] > > DatabaseFile = /data/virtuoso/virtuoso-temp.db > > TransactionFile = /data/virtuoso/virtuoso-temp.trx > > MaxCheckpointRemap = 2000 > > > > ; > > ; Server parameters > > ; > > [Parameters] > > ServerPort = 1111 > > DisableUnixSocket = 1 > > ;SSLServerPort = 2111 > > ;SSLCertificate = cert.pem > > ;SSLPrivateKey = pk.pem > > ;X509ClientVerify = 0 > > ;X509ClientVerifyDepth = 0 > > ;X509ClientVerifyCAFile = ca.pem > > ServerThreads = 10 > > CheckpointInterval = 60 > > O_DIRECT = 0 > > NumberOfBuffers = 550000 > > MaxDirtyBuffers = 320000 > > CaseMode = 2 > > MaxStaticCursorRows = 5000 > > CheckpointAuditTrail = 0 > > AllowOSCalls = 0 > > SchedulerInterval = 10 > > DirsAllowed = ., ../vad, /data/virtuoso/dbpediaLoad/ > > ThreadCleanupInterval = 0 > > ThreadThreshold = 10 > > ResourcesCleanupInterval = 0 > > FreeTextBatchSize = 100000 > > SingleCPU = 0 > > VADInstallDir = ../vad/ > > PrefixResultNames = 0 > > MacSpotLight = 0 > > > > [HTTPServer] > > ServerPort = 8890 > > ServerRoot = ../vsp > > DavRoot = DAV > > EnabledDavVSP = 0 > > HTTPProxyEnabled = 0 > > TempASPXDir = 0 > > DefaultMailServer = localhost:25 > > ServerThreads = 5 > > MaxKeepAlives = 10 > > KeepAliveTimeout = 10 > > MaxCachedProxyConnections = 10 > > ProxyConnectionCacheTimeout = 15 > > HTTPThreadSize = 280000 > > HttpPrintWarningsInOutput = 0 > > Charset = UTF-8 > > HttpProxyServer = http://*****.****.bbc.co.uk:80 > > > > [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 = virtuoso-NOLAPPS34 > > 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 (NOLAPPS34) > > ;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 > > ResultSetMaxRows = 100000 > > ;DefaultGraph = http://localhost:8890/dataspace > > ;MaxQueryCostEstimationTime = 120 ; in seconds > > ;MaxQueryExecutionTime = 10 ; in seconds > > > > [Plugins] > > LoadPath = ../hosting > > Load1 = plain, wikiv > > Load2 = plain, mediawiki > > Load3 = plain, creolewiki > > Load4 = plain, im > > Load5 = plain, wbxml2 > > Load6 = attach, libphp5.so > > Load7 = Hosting, hosting_php.so > > ;Load8 = Hosting,hosting_perl.so > > ;Load9 = Hosting,hosting_python.so > > ;Load10 = Hosting,hosting_ruby.so > > ;Load11 = msdtc,msdtc_sample > > > > > > > > > > ------------------------------------------------------------------------------ > > This SF.net email is sponsored by: > > High Quality Requirements in a Collaborative Environment. > > Download a free trial of Rational Requirements Composer Now! > > http://p.sf.net/sfu/www-ibm-com > > _______________________________________________ Virtuoso-users mailing list > > Virtuoso-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > High Quality Requirements in a Collaborative Environment. > Download a free trial of Rational Requirements Composer Now! > http://p.sf.net/sfu/www-ibm-com > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Armin Nagel Softwareentwickler neofonie Technologieentwicklung und Informationsmanagement GmbH Robert-Koch-Platz 4 10115 Berlin fon: +49.30 24627 257 fax: +49.30 24627 120 armin.na...@neofonie.de http://www.neofonie.de Handelsregister Berlin-Charlottenburg: HRB 67460 Geschäftsführung Helmut Hoffer von Ankershoffen (Sprecher der Geschäftsführung) Nurhan Yildirim Uwe-Gernot Fasold ________________________________ Die erste Web 2.0 Suchmaschine jetzt auf http://www.wefind.de . Unterwegs immer bestens informiert mit WeFind Mobile für iPhone und jetzt auch mit WeFind Mobile für Android: kostenloser Download im iTunes AppStore und im Android Market.
