Hi Matteo,
The +pwdold +pwddba +pwddav options can be passed to the Virtuoso server binary
to change the “dba” and “dav” user password, see:
$ ./virtuoso-t -?
Virtuoso Open Source Edition (Column Store) (multi threaded)
Version 7.2.6-dev.3229-pthreads as of Aug 15 2018 (7f57cb6fe)
Compiled for Darwin (x86_64-apple-darwin17.6.0)
Copyright (C) 1998-2018 OpenLink Software
Usage:
virtuoso-t [-fcnCbDARwMKrBd] [+foreground] [+configfile arg] [+no-checkpoint]
[+checkpoint-only] [+backup-dump] [+crash-dump]
[+crash-dump-data-ini arg] [+restore-crash-dump] [+wait]
[+mode arg] [+dumpkeys arg] [+restore-backup arg]
[+backup-dirs arg] [+debug] [+pwdold arg] [+pwddba arg]
[+pwddav arg]
+foreground run in the foreground
+configfile use alternate configuration file
+no-checkpoint do not checkpoint on startup
+checkpoint-only exit as soon as checkpoint on startup is complete
+backup-dump dump database into the transaction log, then exit
+crash-dump dump inconsistent database into the transaction log,
then exit
+crash-dump-data-ini specify the DB ini to use for reading the data to dump
+restore-crash-dump restore from a crash-dump
+wait wait for background initialization to complete
+mode specify mode options for server startup (onbalr)
+dumpkeys specify key id(s) to dump on crash dump (default : all)
+restore-backup restore from online backup
+backup-dirs default backup directories
+debug Show additional debugging info
+pwdold Old DBA password
+pwddba New DBA password
+pwddav New DAV password
You could also use an “autoexe.isql” file to change the pwd as follows :
1. Go the the Virtuoso database directory where the configuration files for the
database instance reside ie virtuoso.ini, virtuoso.log etc ; and create a file
called "autoexec.isql" with the following contents:
user_set_password ('dba', ‘your-pwd’)
user_set_password ('dav', ‘your-pwd')
;
2. Then start the database as normal and the pwd will be changed.
3. Finally remember to remove the auotexec.isql script to prevent it being
reset again when next started …
Note the “i” in the name of the “autoexec.isql” file, which many miss ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 31 Aug 2018, at 03:29, Matteo Olivi <matteooli...@gmail.com> wrote:
>
> Hello everyone.
>
> Normally, when you install virtuoso-opensource you're interactively asked a
> password for DAV and DBA users. Is there a way to provide this password as a
> command line parameter when running the install command, or to provide it
> through a file which is read automatically at installation time? In a
> nutshell, I'm looking for a way to provide the required password in a
> non-interactive way. Ideally, I'd like to do something like:
> "sudo apt-get install virtuoso-opensource --dav-dba-password <password>".
>
> The reason I want this is that I'm trying to build a docker image with
> virtuoso-opensource installed and with Ubuntu 12.04 as the base image.
> One way to do this is to create a blank Ubuntu 12.04 container, log into it,
> install virtuoso on it manually, and then use "docker commit" to create an
> image with virtuoso installed. I'd prefer to do everything using only a
> Dockerfile (no docker commit) though, but to do that I need to put in the
> Dockerfile a single command that installs Virtuoso and provides the password
> for the DAV and DBA users, which is usually asked interactively during the
> installation. Is there a way to do what I want, or an alternative that allows
> me to build a docker image with virtuoso installed using only a Dockerfile?
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org!
> http://sdm.link/slashdot_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
