subject:"Re\: \[Virtuoso\-users\] How to install isql\?"

Re: [Virtuoso-users] How to install isql?

2020-05-08 Thread q


Hi Luís,

When I had this problem several years ago, I didn't find a better 
solution than to compile Virtuoso from source (being careful to use the 
same version as your server), install it onto a clean image, extract the 
necessary library and config files used in local connections by the isql 
client and then transplant them to the client instance.
Once the source package is installed on the temporary instance, you'll 
find most of what you need referenced in the ODBC config files located 
under /etc/ I think, check for variations on the name, iodbc, unixodbc 
etc.  You're going to want those config files and the libraries 
mentioned in them, possibly the whole /lib/virtuoso directory or 
wherever virtodbc.so is found.  The config files will do double duty of 
defining the connections and the libraries they use.
It's been a few years since I did this so I'm a bit hazy and you'll need 
to hunt around for the right config files, it's probably going to be a 
process of trial and error.


If your server was installed with the right options, you could also grab 
them from there but it's arguably easier, if slower, to install onto a 
clean instance with the right client options.  It makes it easier to 
know what the package added and changed under /etc and /lib, so as to 
replicate those changes on your client instance, this also matters if 
the server and client have different OSs.


An easier solution is to install Virtuoso on the client instance and 
just disable the Virtuoso service, then edit the config files above with 
the remote server details, that would probably work too but you'll have 
an empty Virtuoso DB taking up a little disk space I guess.  It's still 
necessary to get the Virtuoso version right of course.


Good luck,
Quentin
Guiding Hand Solutions


___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] How to install isql?

2020-05-01 Thread Luis de Sousa

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 
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 [:]   file1 file2 ...

isql -H  [-S ] [-U ] [-P ]
 [-E] [-X ] [-K] [-C ] [-b ]
 [-u =]* [-i  ]
 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.
  =   - Sets the ISQL options

  Note that if none of the above matches then the non-options go as
  [:]   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  wrote:
>
> Hi Hugh,
>
> I am sorry but I did not refer this before: commercial tools are not an 
> option in this particul

Re: [Virtuoso-users] How to install isql?

2020-04-30 Thread Hugh Williams via Virtuoso-users

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 [:]   file1 file2 ...

isql -H  [-S ] [-U ] [-P ]
 [-E] [-X ] [-K] [-C ] [-b ]
 [-u =]* [-i  ]
 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.
  =   - Sets the ISQL options

  Note that if none of the above matches then the non-options go as 
  [:]   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  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 
> 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
> Profes

Re: [Virtuoso-users] How to install isql?

2020-04-30 Thread Luis de Sousa

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 
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 
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 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  dba 'MYPASSWORD'

1

Best,

Le mer. 29 avr. 2020 à 10:05, Luis de Sousa 
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 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

Re: [Virtuoso-users] How to install isql?

2020-04-29 Thread Hugh Williams via Virtuoso-users

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 <http://www.openlinksw.com/>
Community Support: https://community.openlinksw.com 
<https://community.openlinksw.com/>
Company Blog: https://medium.com/openlink-software-blog 
<https://medium.com/openlink-software-blog>
Virtuoso Blog: https://medium.com/virtuoso-blog 
<https://medium.com/virtuoso-blog>
Data Access Drivers Blog: 
https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers 
<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  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
> Ring: luis-de-sousa
> skype: luis.a.de.sousa
> 
> 
> 
> From: Adam Sanchez 
> Sent: 29 April 2020 12:12:35
> To: Luis de Sousa
> Cc: Hugh Williams; 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  dba 'MYPASSWORD'
> 
> 1
> 
> Best,
> 
> Le mer. 29 avr. 2020 à 10:05, Luis de Sousa  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
>> Ring: luis-de-sousa
>> skype: luis.a.de.sousa
>> 
>> 
>> 
>> From: Hugh Williams 
>> Sent: 28 April 2020 19:00:55
>> To: Luis de Sousa
>> Cc: 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-

Re: [Virtuoso-users] How to install isql?

2020-04-29 Thread Luis de Sousa

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
Ring: luis-de-sousa
skype: luis.a.de.sousa



From: Adam Sanchez 
Sent: 29 April 2020 12:12:35
To: Luis de Sousa
Cc: Hugh Williams; 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  dba 'MYPASSWORD'

 1

Best,

Le mer. 29 avr. 2020 à 10:05, Luis de Sousa  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
> Ring: luis-de-sousa
> skype: luis.a.de.sousa
>
>
> 
> From: Hugh Williams 
> Sent: 28 April 2020 19:00:55
> To: Luis de Sousa
> Cc: 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 
> 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>
> Ring: luis-de-sousa
> skype: luis.a.de.sousa
>
>
>
> ___
> 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


___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] How to install isql?

2020-04-29 Thread Adam Sanchez

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  dba 'MYPASSWORD'

 1

Best,

Le mer. 29 avr. 2020 à 10:05, Luis de Sousa  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
> Ring: luis-de-sousa
> skype: luis.a.de.sousa
>
>
> 
> From: Hugh Williams 
> Sent: 28 April 2020 19:00:55
> To: Luis de Sousa
> Cc: 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 
> 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>
> Ring: luis-de-sousa
> skype: luis.a.de.sousa
>
>
>
> ___
> 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


___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] How to install isql?

2020-04-28 Thread Hugh Williams via Virtuoso-users

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  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
> Ring: luis-de-sousa
> skype: luis.a.de.sousa
> 
> 
> 
> ___
> 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
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] How to install isql?

Re: [Virtuoso-users] How to install isql?

Re: [Virtuoso-users] How to install isql?

Re: [Virtuoso-users] How to install isql?

Re: [Virtuoso-users] How to install isql?

Re: [Virtuoso-users] How to install isql?

Re: [Virtuoso-users] How to install isql?

Re: [Virtuoso-users] How to install isql?

8 matches

Site Navigation

Mail list logo

Footer information