Hi Hugh, thank you for your patience. The package description I get from aptitude led me to believe this was the full database server install. It is now clear it is not.
Thank you. -- Luís Moreira de Sousa ISRIC - World Soil Information Droevendaalsesteeg 3, Building 101 6708 PB Wageningen The Netherlands t: +31 643 84 40 91 e: luis.deso...@isric.org Ring: luis-de-sousa skype: luis.a.de.sousa ________________________________________ From: Hugh Williams <hwilli...@openlinksw.com> Sent: 30 April 2020 11:47:34 To: Luis de Sousa Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] How to install isql? Hi Luis, The Virtuoso client connectivity kit components are not licensed and can be freely redistributed, as in the commercial product it is the Virtuoso server where licensing is enforce for use. Or why do you not use the open source “isql-vt” program Ubuntu provides as suggested previously ie http://manpages.ubuntu.com/manpages/cosmic/man1/ISQL-VT.1.html , which you can simply run the command "apt install virtuoso-opensource-6.1-bin" on ubuntu to install ie root@ubuntu:/tmp/mozilla_hwilliams0# isql-vt Command 'isql-vt' not found, but can be installed with: apt install virtuoso-opensource-6.1-bin root@ubuntu:/tmp/mozilla_hwilliams0# apt install virtuoso-opensource-6.1-bin Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libatkmm-1.6-1v5 libcairomm-1.0-1v5 libgtkmm-3.0-1v5 libllvm6.0 libnih-dbus1 libpangomm-1.4-1v5 Use 'apt autoremove' to remove them. The following NEW packages will be installed: virtuoso-opensource-6.1-bin 0 upgraded, 1 newly installed, 0 to remove and 86 not upgraded. Need to get 2,831 kB of archives. After this operation, 14.9 MB of additional disk space will be used. Get:1 http://us.archive.ubuntu.com/ubuntu bionic/universe amd64 virtuoso-opensource-6.1-bin amd64 6.1.6+repack-0ubuntu9 [2,831 kB] Fetched 2,831 kB in 3s (1,003 kB/s) Selecting previously unselected package virtuoso-opensource-6.1-bin. (Reading database ... 218615 files and directories currently installed.) Preparing to unpack .../virtuoso-opensource-6.1-bin_6.1.6+repack-0ubuntu9_amd64.deb ... Unpacking virtuoso-opensource-6.1-bin (6.1.6+repack-0ubuntu9) ... Setting up virtuoso-opensource-6.1-bin (6.1.6+repack-0ubuntu9) ... Processing triggers for man-db (2.8.3-2ubuntu0.1) ... root@ubuntu:/tmp/mozilla_hwilliams0# isql-vt -? OpenLink Interactive SQL (Virtuoso), version 0.9849b. Usage : isql <HOST>[:<PORT>] <UID> <PWD> file1 file2 ... isql -H <server_IP> [-S <server_port>] [-U <UID>] [-P <PWD>] [-E] [-X <pkcs12_file>] [-K] [-C <num>] [-b <num>] [-u <name>=<val>]* [-i <param1> <param2>] isql -? Connection options: -? - This help message -U username - Specifies the login user ID -P password - Specifies the login password -H server_addr - Specifies the Server address (IP) -S server port - Specifies the TCP port to connect to -E - Specifies that encryption will be used -C - Specifies that password will be sent in cleartext -X pkcs12_file - Specifies that encryption & X509 certificates will be used -T server_cert - Specifies that CA certificate file to be used -b size - Specifies that large command buffer to be used (in KBytes) -K - Shuts down the virtuoso on connecting to it Parameter passing options: -u name1=val1... - Everything after -u is stored to associative array U, until -i is encountered. If no equal sign then value is NULL -i - Ignore everything after the -i option, after which comes arbitrary input parameter(s) for isql procedure, which can be referenced with $ARGV[$I] by the ISQL-commands. <OPT>=<value> - Sets the ISQL options Note that if none of the above matches then the non-options go as <HOST>[:<PORT>] <UID> <PWD> file1 file2 ... root@ubuntu:/tmp/mozilla_hwilliams0# which isql-vt /usr/bin/isql-vt root@ubuntu:/tmp/mozilla_hwilliams0# Best Regards Hugh Williams Professional Services OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers 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 30 Apr 2020, at 07:16, Luis de Sousa <luis.deso...@isric.org> wrote: > > Hi Hugh, > > I am sorry but I did not refer this before: commercial tools are not an > option in this particular context. > > Thank you in any case. > > -- > Luís > > > ________________________________________ > From: Hugh Williams <hwilli...@openlinksw.com> > Sent: 30 April 2020 00:05:26 > To: Luis de Sousa > Cc: virtuoso-users@lists.sourceforge.net > Subject: Re: [Virtuoso-users] How to install isql? > > Hi Luis, > > I don’t understand what does not make sense to you, having given you two > methods of obtaining prebuilt Virtuoso client component only binaries in my > last email ? > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Home Page: http://www.openlinksw.com > Community Support: https://community.openlinksw.com > Company Blog: https://medium.com/openlink-software-blog > Virtuoso Blog: https://medium.com/virtuoso-blog > Data Access Drivers Blog: > https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers > 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 29 Apr 2020, at 11:26, Luis de Sousa > <luis.deso...@isric.org<mailto:luis.deso...@isric.org>> wrote: > > Hi all, > > thank you for the various replies. I understand what you are saying, but it > makes no sense. I must install the server software on the client node in > order to access the actual server node? This might be feasible in a > development environment, but the goal would be to have Virtuoso in a > micro-services platform. Not sure how this is going to work. > > Please let me know if there are open source alternatives to isql. > > Thank you. > > -- > Luís Moreira de Sousa > ISRIC - World Soil Information > Droevendaalsesteeg 3, Building 101 > 6708 PB Wageningen > The Netherlands > t: +31 643 84 40 91 > e: luis.deso...@isric.org<mailto:luis.deso...@isric.org> > Ring: luis-de-sousa > skype: luis.a.de.sousa > > > ________________________________________ > From: Adam Sanchez <a.sanche...@gmail.com<mailto:a.sanche...@gmail.com>> > Sent: 29 April 2020 12:12:35 > To: Luis de Sousa > Cc: Hugh Williams; > virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net> > Subject: Re: [Virtuoso-users] How to install isql? > > not sure if this is what you need, but if you are using docker you can > connect to the isql-v tool directly by doing > > docker exec -it ID_CONTAINER isql-v 1111 dba 'MYPASSWORD' > > 1 > > Best, > > Le mer. 29 avr. 2020 à 10:05, Luis de Sousa > <luis.deso...@isric.org<mailto:luis.deso...@isric.org>> a écrit : > > Hi Hugh, > > not sure how much this matters, but the server is running in a container > adapted from the tenforce image [0]. > > My question is not really about the server, but the tools needed to access > it. I just need to connect to this server from a client system. The > documentation points to isql, which seems to do all that is necessary client > side. I am not trying to install the server itself. > > Making a parallel with another DMS, if I wish to connect to a Postgres server > I can install the postgresql-client package on Ubuntu to obtain the psql > tool. I am looking for something similar with isql. > > Thank you. > > [0] https://hub.docker.com/r/tenforce/virtuoso > > -- > Luís Moreira de Sousa > ISRIC - World Soil Information > Droevendaalsesteeg 3, Building 101 > 6708 PB Wageningen > The Netherlands > t: +31 643 84 40 91 > e: luis.deso...@isric.org<mailto:luis.deso...@isric.org> > Ring: luis-de-sousa > skype: luis.a.de.sousa > > > ________________________________________ > From: Hugh Williams > <hwilli...@openlinksw.com<mailto:hwilli...@openlinksw.com>> > Sent: 28 April 2020 19:00:55 > To: Luis de Sousa > Cc: > virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net> > Subject: Re: [Virtuoso-users] How to install isql? > > Hi Luis, > > What Virtuoso installation do you have as it you compile from source > (http://vos.openlinksw.com/owiki/wiki/VOS/VOSUbuntuNotes), build and install > the “isql” program is placed in the “bin” directory along with the Virtuoso > binary. Or a probably older version of Virtuoso is available on Ubuntu > systems ,see > https://www.howtoinstall.me/ubuntu/18-04/virtuoso-opensource-6.1/ and that > would include the “isql” program although I think they call it “isql-vt” and > there is already an “isql” program in the system bin directory used for > something else. > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Home Page: http://www.openlinksw.com > Community Support: https://community.openlinksw.com > Company Blog: https://medium.com/openlink-software-blog > Virtuoso Blog: https://medium.com/virtuoso-blog > Data Access Drivers Blog: > https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers > 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 28 Apr 2020, at 09:54, Luis de Sousa > <luis.deso...@isric.org<mailto:luis.deso...@isric.org><mailto:luis.deso...@isric.org>> > wrote: > > Hi everyone, > > I would like to use isql to connect to a remote Virtuoso server. The > documentation presents the usage of this tool in detail, but does not explain > how to install it. Must it be compiled? The client system is Ubuntu. > > Thank you. > > -- > Luís Moreira de Sousa > ISRIC - World Soil Information > Droevendaalsesteeg 3, Building 101 > 6708 PB Wageningen > The Netherlands > t: +31 643 84 40 91 > e: > luis.deso...@isric.org<mailto:luis.deso...@isric.org><mailto:luis.deso...@isric.org> > Ring: luis-de-sousa > skype: luis.a.de.sousa > > > > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net<mailto:Virtuoso-users@lists.sourceforge.net><mailto:Virtuoso-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net<mailto:Virtuoso-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
