Virtuoso Enterprise - default password

I created a fresh instance, and repeated the installation steps. When I visit the conductor, a 404 error is returned.

I verify that the security group exists for port 8890 (I do get the default homepage)

I checked conductor on port 80 also, but browser says “Connection refused”

-sherman

Ah, this is a different issue.

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 –

vad_install ('file/system/path/package-name.vad', 0);

– so the default would be –

vad_install ('/opt/virtuoso/vad/conductor_dav.vad', 0);

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.

Thank you, that worked! The Conductor login is now showing, and using the AMI ID as the password, I am able to login to the dba account.

-sherman

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:

The FCT service seems to be working okay.

I have the same problem but with local instance on linux, what i can do.
the message is ‘Invalid Credentials’ virtuoso 8.3

Hi

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 :slight_smile:

Hi @kidehen,
Thanks for you, but i install Virtuoso from the site Free Evaluation License Generator and this link:
http://download3.openlinksw.com/uda/virtuoso/8.3/x86_64-generic-linux-glibc25-64/lovpz2zz.tar

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.

any suggestions for solution,
Thanks

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 404 not 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:

$ cat database/.initial-password 
9CscZ2Hr
$

Thanks @hwilliams,
but when i run $ cat database/.initial-password
this result is printed,

and when i try login http://server-ip:8890/conductor/main_tabs.vspx using dba/dba, it gives me this message, “Invalid credentials”
Thanks

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 …

You appear to be mixing two installation options.

  1. On-premise installation which is via https://shop.openlinksw.com/license_generator/virtuoso-download/.

  2. PAGO AMI installation which is via https://aws.amazon.com/marketplace/pp/B011VMCZ8K/ – which is where /latest/meta-data/ami-id become relevant via curl interactions with the AWS metadata server

Im using option 1 only, I installed tar file from http://download3.openlinksw.com/uda/virtuoso/8.3/x86_64-generic-linux-glibc25-64/lovpz2zz.tar.

When start database, .initial-password contains error text, not password.

Thanks

An on-premise installation is simply as follows:

  1. Run the installer

  2. Connect to the default DB in ~virtuoso/database

At this juncture, your default pwd is dba until you change it.

You can also install various Demo Databases as a post-installation act:

  1. Northwind Database

  2. Schools Database

I did that,

  1. wget http://download3.openlinksw.com/uda/virtuoso/8.3/x86_64-generic-linux-glibc25-64/lovpz2zz.tar
  2. tar -xvf lovpz2zz.tar
  3. sh ./install.sh
  4. bin/virtuoso-start.sh
  5. cat database/.initial-password

but there is no password appear, it show as image below

Thanks

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:

  1. Kill the currently running Virtuoso instance with the commands:
    ps -ef | grep virt   ;;; to determine the PID
    kill -9 <PID>
    
  2. From the Virtuoso installation directory, run the following command to set up the Virtuoso environment :
    . ./virtuoso-environment.sh
    
  3. Go to to the database directory and run the following commands to remove the current database:
    rm .initial-password virtuoso.lck virtuoso.trx virtuoso.db
    
  4. From the database directory, run the command –
    virtuoso
    
    – 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

Hi @hwilliams
I applied them, now it works,
Thanks a lot.

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?