Hi Ruben,
Ok, so it a BIF (built in function) in the server binary for speed,
which means the change needs to be recompiled into the binary which is
possible for open source users as you have done ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 18 Sep 2009, at 08:00, Ruben Martin wrote:
The code you suggested, the rdfdesc_http_url function of
description.sql. When we change to something like this:
create procedure rdfdesc_http_url (in url varchar)
{
......
-- host := http_request_header(http_request_header(), 'Host',
null, null);
host := 'data.fundacionctic.org';
........
};
But the change doesnt work. It seems those sql procedures are
precompiled and are not editable. How can we 'drop and create
changes made to any procedures changed', as you say?
Then, we changed the source, rebuilt ant it worked; we just hoped
there was some faster way to achieve this.
El vie, 18-09-2009 a las 01:56 +0100, Hugh Williams escribió:
Hi Ruben,
What changes are you making that are not taking effect ? You should
be able to drop and create changes made to any procedures changed,
or worse case rebuild the server should these functions be build
into the Virtuoso binary ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 17 Sep 2009, at 09:18, Ruben Martin wrote:
We are trying now to change code in description.sql but it seems
the changes go unnoticed. Maybe those sql scripts are cached/
compiled somewhere? The modifications made in descrption.vsp are
seen immediately in the page, but not those in description.sql. We
have also restarted the server but the problem persists.
Any idea? Thanks
El mié, 16-09-2009 a las 18:36 +0100, Hugh Williams escribió:
Hi Ruben,
In speaking to development the problem you are encountering it
due to the apache proxy being used uses the internal name of the
server when proxying the request across and hence the "host :=
http_request_header(http_request_header(), 'Host', null, null)"
function picks up the internal name. Our demo server does not use
an apache server and thus does not have this problem. We will
need to make a fix to detect when a proxy request is being made
and obtain the correct external proxy server name for use. It
also turns our that the ^{URIQADefaultHost}^ marco cannot be
called in a VSP page hence the error you are receiving as it is
not meant for this purpose. So best bet in your case is to
probably hard code host in the rdfdesc_http_url function of
description.sql to return the correct hostname until we can
provide a fix.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 16 Sep 2009, at 08:56, Ruben Martin wrote:
Quite strange. We thought we were testing with an 'external'
client but it seems it is taking our internal configuration and
resolving to our internal server (the same way it does when we
access from an internal pc). Its encouraging though, if you get
the correct links. Probably it is just a problem with some
configuration. We will let you know.
With regard to our server version: Version 5.0.11.3039-pthreads
as of Jul 28 2009. Our administrator guy is on vacation and we
still have not been able to upgrade (so the encoding issue is
unresolved yet).
Yes, we know we can use ^{URIQADefaultHost}^, for example when
url-rewriting, but we dont find the way to get it from a vsp
file. Using directly the macro produces a compiler error.
Thank you Hugh.
El mié, 16-09-2009 a las 01:05 +0100, Hugh Williams escribió:
Hi Ruben,
I see the problem you report with the URL provided to your
external service although the hrefs of the URIs generated for
the demo server are correctly referencing the external cname
rather then the internal name of the machine hosting the server.
BTW, what Virtuoso server version are you using, as I gave your
colleague Sergio an updated snapshot release with the latest
description.vsp code (rdf mappers vad) for an issue he
reported, thus are you using this:
ftp://download.openlinksw.com/support/vos/virtuoso-opensource-20090828.tar.gz
You can determine the version form the conductor or running
virtuoso-t -? from command line, the server version should be
5.0.12. If not please try updating to this latest release to be
in sync with what is being run on our demo server.
You can get the value of the DefaultHost using the ^
{URIQADefaultHost}^ macro as detailed at:
http://docs.openlinksw.com/virtuoso/rdfsparqlintegrationmiddleware.html#rdfviewnorthwindexample1
Let us know how you get on ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 15 Sep 2009, at 15:16, Ruben Martin wrote:
Hi Ruben,
Thanks for your time Hugh
I am still unsure as to what your issue is other than the
URI's you are seeing with the internal cname of the machine
where created when the DefaultHost in your virtuoso.ini file
was set to the internal name. Having set your DefaultHost
name to the external cname if new data is inserted into the
triple store do these not have the correct external cname in
the URI's ?
All data have the correct cname. That's right. The problem is
in the the way the href attribute of the links to other
resources are formed in the script.
Look at our resource in http://data.fundacionctic.org/asturias/empleo/oferta-formativa/Accion-Formativa/2009/15
. The url to other resources show the internal hostname of the
virtuoso server (not accessible)
Our demo server for example (demo.openlinksw.com) has an
internal hostname which is not accessible externally, but
when it was setup it was given a DefaultHost name of "demo.openlinksw.com
" and this all generated URIs uses this when accessed iternal
or externally by the outside, see the following URL
describing data stores on the server:
Your servers configuration seems to be exactly the same than
ours. I suposse that when you talk about the server being
setup you mean setting the DefaultHost variable in
virtuosos.ini. We have already done that (DefaultHost = data.fundacionctic.org
) thinking that was the right way bat it did not solve the
problem. When you look at the scripts you see the urls are
formed using "host := http_request_header(http_request_header
(), 'Host', null, null)", got from the http headers.
Is there any way to get the value of DefaultHost from a vsp
script?
http://demo.openlinksw.com/about/html/http/demo.openlinksw.com/sybasepubs2/stores/8042%23this
PS: Note the description.vsp on this machine is newer than
the one you probably have but the changes are mainly in the
layout, its behaviour is the same as what you would be
using ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 11 Sep 2009, at 07:55, Ruben Martin wrote:
El jue, 10-09-2009 a las 14:30 +0100, Hugh Williams escribió:
Hi Ruben,
What scripts are you referring, those for creating RDFViews ?
That's it. description.vsp includes other scripts such as
DAV/VAD/rdf_mappers/description.sql wich retrieves the host
base name this way:
host := http_request_header(http_request_header(), 'Host',
null, null);
What is the incorrect URL you are seeing in the
description.vsp pages
and does this machine what the DefaultHost when set to at
the time
these scripts were run ?
For example, if the external (accesible from the internet)
server is http://data.ourserver.org, an url like http://data.ourserver.org/class/entity
is redirected internally in the proxy to the virtuoso
server http://data.virtuoso.org/class/entity (an intranet
server), an then transformed to http://data.virtuoso.org/html/about/http://data.virtuoso.org/class/entity
. The problem here is that the html view of that rdf
resource rendered by description.vsp constructs the urls to
other resources this way: http://data.virtuoso.org/etc..
which es not accesible for the external browser.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 10 Sep 2009, at 13:04, Ruben Martin wrote:
> Hi,
>
> We have not found in the online documentation an example
to solve
> this issue. We have a virtuoso instance behind an apache
proxy, so
> the virtuoso server is not directly accesible. All the
url are being
> solved-rewrited correctly (rdf -linked data) except the
urls used by
> the /rdfdesc/description.vsp script. This script builds
the urls to
> other resources based on the internal server name.
>
> Setting the DefaultHost variable in virtuoso.ini did not
solve the
> problem. is there any way to get this working ("cleaner"
than
> modifying the scripts) ?
>
> Thank you.
>
>
>
>
------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal
Reports 2008
> 30-Day
> trial. Simplify your report design, integration and
deployment - and
> focus on
> what you do best, core application coding. Discover
what's new with
> Crystal Reports now.
http://p.sf.net/sfu/bobj-july_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference
in SF, CA
is the only developer event you need to attend this year.
Jumpstart your
developing skills, take BlackBerry mobile applications to
market and stay
ahead of the curve. Join us from November 9-12, 2009.
Register now!
http://p.sf.net/sfu/devconf_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in
SF, CA
is the only developer event you need to attend this year.
Jumpstart your
developing skills, take BlackBerry mobile applications to market
and stay
ahead of the curve. Join us from November 9-12, 2009.
Register now!
http://p.sf.net/sfu/devconf_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart
your
developing skills, take BlackBerry mobile applications to market and
stay
ahead of the curve. Join us from November 9-12, 2009. Register
now!
http://p.sf.net/sfu/devconf_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
