[Virtuoso-users] make error on freshly installed debian lenny

2011-01-07 Thread Matthew Tedder
This worked fine for me a few months ago but it won't make, now.. Any advice? The versions of dependencies are all at or above recommended versions on the wiki. They are listed below. Follow them are the results of the ./autogen.sh ./configure make sequence.. So the error is at the bottom.. A

[Virtuoso-users] Really Impressed with Virtuoso All Around..

2011-01-07 Thread Matthew Tedder
I just want to say, I am so far just very very impressed with Virtuoso all around--in so many respects. The SQL is easy to work with, the web-based tools are great. The feature set, such as semantic web and xml support are just extraordinary. I haven't tried the Jena interface, but I'd like to l

[Virtuoso-users] Lost Admin Password

2010-10-25 Thread Matthew Tedder
I lost my admin password on a virtuoso database. How can I reset it? It would be ok to wipe out the database on this one but I don't really want to uninstall re-install because for some reason it won't successfully compile on this server anymore. Matthew C. Tedder, Software Engineer Clinic

[Virtuoso-users] Virtuoso SQL, how can I get the last insert ID? (dentity)

2010-08-24 Thread Matthew Tedder
Normally I'd use a PDO function for this but it says it isn't supported for this database.. I am trying to migrate data over from SQL server and other sources but need to adjust table relationships to new identity keys. Matthew C. Tedder Software Engineer Clinical and Translational R

Re: [Virtuoso-users] What would be a SQL TEXT data type?

2010-08-13 Thread Matthew Tedder
rtuoso sql. Matthew From: Matthew Tedder [mailto:mted...@ichp.ufl.edu] Sent: Friday, August 13, 2010 3:34 PM To: virtuoso-users@lists.sourceforge.net Subject: [Virtuoso-users] What would be a SQL TEXT data type? VARCHAR() seems limited at about 4K bytes. I have study titles that g

[Virtuoso-users] What would be a SQL TEXT data type?

2010-08-13 Thread Matthew Tedder
VARCHAR() seems limited at about 4K bytes. I have study titles that go a little over 700 characters long. (Yes. People who give studies 700+ character titles should be shot. But we can't do that to them, in a civil society.) The page http://docs.openlinksw.com/virtuoso/sqlrefDATATYPES.html

Re: [Virtuoso-users] Where to change the DBA password?

2010-08-09 Thread Matthew Tedder
2010 2:08 PM To: Matthew Tedder; virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Where to change the DBA password? Hi Matthew, Do you have the conductor package installed (http://s3.amazonaws.com/opldownload/uda/vad-packages/6.1/virtuoso/conductor_ dav.vad)? You can use i

[Virtuoso-users] Where to change the DBA password?

2010-08-09 Thread Matthew Tedder
I've been looking through everything over port 8890 but haven't been able to find the place to change the dba password from its default to something secure. Can someone enlighten me on where this is supposed to be? (I presume it must be just under my nose but I'm not seeing it). Matthew C.

Re: [Virtuoso-users] In SQL how can I reference my tables?

2010-08-06 Thread Matthew Tedder
will definitely write a nice beginner's how-to for others, once I get to a point that time allows for it. Matthew -Original Message- From: Patrick van Kleef [mailto:pkl...@openlinksw.com] Sent: Friday, August 06, 2010 3:55 PM To: Matthew Tedder Cc: Ted Thibodeau Jr; virtuoso-users@l

Re: [Virtuoso-users] In SQL how can I reference my tables?

2010-08-06 Thread Matthew Tedder
sandwich and come back to my desk. Matthew -Original Message- From: Kingsley Idehen [mailto:kide...@openlinksw.com] Sent: Friday, August 06, 2010 11:41 AM To: Matthew Tedder Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] In SQL how can I reference my tables? Matthew

Re: [Virtuoso-users] In SQL how can I reference my tables?

2010-08-06 Thread Matthew Tedder
es..studies;" works fine.. So, does this mean Virtuoso is somehow seeing it differently from my php script: mailto:tthibod...@openlinksw.com] Sent: Friday, August 06, 2010 10:11 AM To: Matthew Tedder Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] In SQL how can I ref

Re: [Virtuoso-users] In SQL how can I reference my tables?

2010-08-06 Thread Matthew Tedder
/www/studies/test.php on line 9 See anything else wrong? Matthew -Original Message- From: Kingsley Idehen [mailto:kide...@openlinksw.com] Sent: Friday, August 06, 2010 9:04 AM To: Matthew Tedder Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] In SQL how can

[Virtuoso-users] In SQL how can I reference my tables?

2010-08-06 Thread Matthew Tedder
So the PHP odbc_connect() method seems to connect, because I get SQL errors. Can anyone tell me how to at least select from these tables.. I created them using isql like this: USE studies; CREATE TABLE studies ( ...); But the following variations give SQL errors: USE studies; SELE

Re: [Virtuoso-users] Non-PDO Failed Query Attempt

2010-08-05 Thread Matthew Tedder
/studies/test.php on line 9 That's even without the "USE studies;" line ever being executed... See anything else that might be wrong? Matthew -Original Message- From: Ted Thibodeau Jr [mailto:tthibod...@openlinksw.com] Sent: Thursday, August 05, 2010 11:16 AM To: Ma

[Virtuoso-users] ODBC seems very complicated..

2010-08-05 Thread Matthew Tedder
Ok, So I've been reading up on unixODBC. I cannot use the GUI tools since the server is headless.. So I referred to: http://www.unixodbc.org/odbcinst.html It seems to say I need /etc/odbc.ini but also /etc/odbcinst.ini and a "template" file somewhere that looks almost just like /etc/o

[Virtuoso-users] Failed Query Attempts Using PHP PDO & Non-PDO

2010-08-05 Thread Matthew Tedder
Previous help on this list got me almost going (I think). But here's where I am. My PDO Attempts: I am getting a PDO object returned but attempts at using it to make queries seem to fail without any error. That is, the $rs object print_r's nothing.. not even null.

[Virtuoso-users] Non-PDO Failed Query Attempt

2010-08-05 Thread Matthew Tedder
Here's my PHP code:

[Virtuoso-users] Failed Attempts at Using PHP PDO

2010-08-05 Thread Matthew Tedder
Previous help on this list got me almost going (I think). But here's where I am. I am getting a PDO object returned but attempts at using it to make queries seem to fail without any error. That is, the $rs object print_r's nothing.. not even null. So I don't understand this. Here's the SQL

Re: [Virtuoso-users] Examples of how to connect SQL from PHP (under apache)?

2010-08-02 Thread Matthew Tedder
nded a bit negative. I didn't mean it to.. Thank you for responding. I really do appreciate it. I will try what you wrote below... Matthew -Original Message- From: Patrick van Kleef [mailto:pkl...@openlinksw.com] Sent: Monday, August 02, 2010 4:30 AM To: Matthew Tedder Cc:

Re: [Virtuoso-users] Examples of how to connect SQL from PHP (under apache)?

2010-08-01 Thread Matthew Tedder
Kleef [mailto:pkl...@openlinksw.com] Sent: Thu 7/29/2010 4:08 PM To: Matthew Tedder Cc: virtuoso-users@lists.sourceforge.net Subject: Re: [Virtuoso-users] Examples of how to connect SQL from PHP (under apache)? HI Matthew, > I need to run my php app under apache for Shibboleth > authentic

[Virtuoso-users] Examples of how to connect SQL from PHP (under apache)?

2010-07-29 Thread Matthew Tedder
I need to run my php app under apache for Shibboleth authentication. (If shibboleth can be done under virtuoso is something I need to ask later, as I need to just get some things done right now). Is there an example anywhere on how to connect to a Virtuoso relational store? I presume to u

[Virtuoso-users] Issues with Getting Started..

2010-07-26 Thread Matthew Tedder
Ok, My installations are on Debian Lenny w/ latest updates. I downloaded the tarball version, did ./configure make and sudo make install. That's all very standard. I didn't see any errors. Issue (1): But I don't see any startup/shutdown scripts in or to put in /etc/init