The empty DB doesn’t have the Conductor VAD installed.
If the VAD(s) are already in the filesystem (as I believe to be the case), you can use iSQL to install the Conductor (or any other VAD) with a command like –
If the VADs aren’t in your AMI’s filesystem, you can download the latest Conductor VAD here. That and all other prebuilt VADs for Virtuoso 8.2 are in this repository.
Generally speaking, we suggest putting these into /opt/virtuoso/vad/, which should already be in the DirsAllowed setting in the virtuoso.ini, for installation as and when you wish.
After this, you should have the normal Conductor interface.
Now I get the following error when I attempt to install FCT service. I followed the instructions there, then attempted it again, and get the same error:
When I try fct_dav.vad install through isql, I get the following:
SQL> vad_install ('/opt/virtuoso/vad/fct_dav.vad', 0);
SQL_STATE SQL_MESSAGE
LONG VARCHAR VARCHAR
_______________________________________________________________________________
Warning 01004: VD CL077: Data truncated in column 2 of the result-se(SQL_MESSAGE, type 182)
at line 2 of Top-Level:
vad_install ('/opt/virtuoso/vad/fct_dav.vad', 0)
S0002 SQ200: No table DB.DBA.SYS_HTTP_SPONGE
while executing the following statement:
--no_c_escapes-
#pragma line 1 "/DAV/VAD/fct/cl_prx.sql"
--
-- $Id$
--
-- This file is part of the OpenLink Software Virtuoso Open-Source (VOS)
-- project.
--
-- Copyright (C) 1998-2016 OpenLink Software
--
-- This project is free software; you can redistribute it and/or modify it
-- under the terms of the GNU General Public License as published by the
-- Free Software Foundation; only version 2 of the License, dated June 1991.
--
-- This program is distributed in the hope that it will be useful, but
-- WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
-- General Public License for more details.
--
-- You should have received a copy of the GNU General Public License along
-- with this program; if not, write to the Free Software Foundation, Inc.,
-- 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
--
--DB.DBA.VHOST_REMOVE (lpath=>'/proxy');
--DB.DBA.VHOST_DEFINE (lpath=>'/proxy', ppath=>'/SOAP/Http/EXT_HTTP_PROXY_1', soap_user=>'PROXY',
-- opts=>vector('url_rewrite', 'ext_http_proxy_rule_list1'));
create procedure
ext_http_proxy_1 (in "url" varchar := null,
in exec varchar := null,
in header varchar := null,
in "force" varchar := null,
in "output-format" varchar := null,
in get varchar := 'soft',
in login varchar := '') __SOAP_HTTP 'text/html'
{
--pl_debug+
declare hdr, content, req_hdr any;
declare ct any;
declare stat, msg, metas, accept, rset, triples, ses, arr any;
declare local_qry integer;
local_qry := 1;
declare params any;
params := http_param ();
if (0 and exec is not null)
{
ext_http_proxy_exec_qry (exec, params);
return '';
}
req_hdr := null;
if (header is not null)
req_hdr := header;
arr := rfc1808_parse_uri ("url");
arr[5] :=
00000 GUI is accesible via http://host:port/fct
00000 Post-installation guide is available from http://host:port/fct/post_install.html
42S02 SR136: Bad table name in GRANT / REVOKE DB.DBA.SYS_HTTP_SPONGE.
while executing the following statement:
--no_c_escapes-
grant select on DB.DBA.SYS_HTTP_SPONGE to "SPARQL_SELECT"
in file:
/DAV/VAD/fct/grants.sql
00000 Errors detected
00000 Installation of "Faceted Browser" was unsuccessful.
BLOB 0 chars The installation of this VAD package has failed.
BLOB 0 chars Please delete the transaction file /opt/virtuoso/database/virtuoso.trx
BLOB 0 chars and then restart your database server.
BLOB 0 chars Note: Your database will be in its pre VAD installation state after you restart.
00000 FATAL
BLOB 0 chars
*** Error 08S01: VD CL065: Lost connection to server
at line 2 of Top-Level:
vad_install ('/opt/virtuoso/vad/fct_dav.vad', 0)
I have the FCT UI, however. Is there a test I can perform to know it’s ok and stable, other than loading some data and attempting a query:
I assume installed a Virtuoso PAGO edition instance from the AWS Cloud and post installation you couldn’t login, even after presenting the ami-id as the default password for the ‘dba’ account?
A simple workaround, in the very worst case is to simply delete the default database and just restart the server.
We had to institute this ami-id default password mechanism as a requirement of getting the PAGO AMI released on the Amazon Cloud, that’s all
I installed the tar file directly : tar -xvf lovpz2zz.tar then sh ./install.sh and start database (bin/virtuoso-start.sh) but this message show for me after start.
The password has been saved to .initial-password
and the file contains: 404. That’s an error.
The requested URL /latest/meta-data/ami-id was not found on this server. That’s all we know.
I don’t know what you mean … sounds as if you are trying to load the .initial-password file in your browser and getting a 404not found error which would be expected.
The .initial-password file is on the Linux file system in the database directory the Virtuoso instance is running from. Thus from the root for your Virtuoso installation on the Linux system, you can run the command cat database/.initial-password to see what the dba password has been set to for your installation ie something like:
I assume this is a new Virtuoso 8.3 database installation, in which case I would suggest deleting the current installation completely and reinstall in the same or other location, start the database and after you are informed of the .initial-password creation to run the cat database/.initial-password, which should give a valid password for the instance. If not provide the TEXT of what the file contains rather then a screenshot …
Can you confirm what Linux distribution and version is being used?
Also provide the version of curl on your system (curl --version).
It seems there is something strange going on with your system that is causing this behaviour which running the virtuoso-start.sh script, which we need to look into but need the information requested above.
In the meantime, with your current installation, you can start an empty database with default dba pwd as follows:
Kill the currently running Virtuoso instance with the commands:
ps -ef | grep virt ;;; to determine the PID
kill -9 <PID>
From the Virtuoso installation directory, run the following command to set up the Virtuoso environment :
. ./virtuoso-environment.sh
Go to to the database directory and run the following commands to remove the current database:
– which will start a new empty database with the default dba password. You can check the virtuoso.log file to confirm the database started successfully
Good to hear this is working for you, but would still like to have the details of your Linux distro and curl version as requested previously, so we can look into possible cause of the issue with the virtuoso-start.sh script you encountered?