I have finished adjusting the ServerClient example code so that it will be able to be used by the simple Query JSP I am building to populate a drop down of available resources. The next step after this would be to use Globus MDS to figure out which nodes have OGSA-DAI installed, and then you basically can pick a node, pick a resource, and run a query... which is very well along the lines of then picking multiple nodes/resources and running a query on them...
Otherwise, after reading through the Ogsa-Dai documentaion more, there are files you can make that simplify the resource creation process, and it would be easy to write scripts and UI's that create/modify such files... so it appears that frustration has created some ideas for more useful applications.
Dan also helped point out that it was very likely a MySQL JDBC issue.
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts
Thursday, May 8, 2008
Wednesday, May 7, 2008
A killer app for OGSA-DAI
I unfortunately spent most of the day today trying to get a simple client to pull a simple query from a newly created MySQL database. I keep checking the logs, seeing that the connection was refused, and I haven't figured out why... What makes it more puzzling is that I can connect to MySQL using the MySQL administrator and the generic MySQL client.
Perhaps I am using the wrong JDBC connector... as the version of MySQL on this machine (4.1.22 installed by VDT for RFT) is older than the more common version 5. Perhaps I am using the wrong version of the JDBC connector or am invoking it improperly. I have checked the resource files and the logons.txt files and haven't found anything out of spec there... I will probably just avoid using it tomorrow and instead focus on enhancing the JSP I've built rather than continue hammering on trying to get it to connect to this new resource.
Either way... a significant portion of my time has been hunting down configuration mishaps. Needless to say Ant build scripts run from command line with lots of variables are very dodgy... and it is very easy to make mistakes which have to be hunted down later. I really think a killer app for OGSA-DAI is going to be a easy-configuration engine with a connection checker... just so that it becomes much easier to make sure the ducks are all in a row for pulling data from a given view in a given database at a given medical center... otherwise we'll probably be sending Centers of Excellence 15-page debugging guides and dedicated a 20-head help-center to correcting the bugs I keep running into.
Perhaps I am using the wrong JDBC connector... as the version of MySQL on this machine (4.1.22 installed by VDT for RFT) is older than the more common version 5. Perhaps I am using the wrong version of the JDBC connector or am invoking it improperly. I have checked the resource files and the logons.txt files and haven't found anything out of spec there... I will probably just avoid using it tomorrow and instead focus on enhancing the JSP I've built rather than continue hammering on trying to get it to connect to this new resource.
Either way... a significant portion of my time has been hunting down configuration mishaps. Needless to say Ant build scripts run from command line with lots of variables are very dodgy... and it is very easy to make mistakes which have to be hunted down later. I really think a killer app for OGSA-DAI is going to be a easy-configuration engine with a connection checker... just so that it becomes much easier to make sure the ducks are all in a row for pulling data from a given view in a given database at a given medical center... otherwise we'll probably be sending Centers of Excellence 15-page debugging guides and dedicated a 20-head help-center to correcting the bugs I keep running into.
Tuesday, May 6, 2008
Variable JSP
Friday was interesting, the internet was upgraded in the lab and unfortunately that meant all the IP addresses needed to be changed.
Ubuntu does not gracefully handle an IP change... at least not one that is rigged to run VDT installed Globus. The main issue seems to be with MySQL and PostgreSQL, which are configured strangely on ubuntu... and are causing all sorts of connection havoc.
But, I moved a bunch of the code I was working on to a Suse server, got the JSP running again, and now have the ability to pass in different queries. My next set of plans is to get the OpenMRS dataset onto the Suse server and then allow for different pulls from different databases... after that I want to implement a resource discovery subroutine that will work to populate the available resources of a given OGSA-DAI instance.
Ubuntu does not gracefully handle an IP change... at least not one that is rigged to run VDT installed Globus. The main issue seems to be with MySQL and PostgreSQL, which are configured strangely on ubuntu... and are causing all sorts of connection havoc.
But, I moved a bunch of the code I was working on to a Suse server, got the JSP running again, and now have the ability to pass in different queries. My next set of plans is to get the OpenMRS dataset onto the Suse server and then allow for different pulls from different databases... after that I want to implement a resource discovery subroutine that will work to populate the available resources of a given OGSA-DAI instance.
Tuesday, April 15, 2008
PHGrid on Ubuntu
Yesterday was spent trying to get the postgresql instance on the second computer running through ogsa-dai, and it failed. Luckily, we found that the original install of OGSA-DAI was working and a few servers just hadn't been restarted since the last time it was shut down.
Thus, today, I went ahead and tried some of the other example clients on that server and actually got the secure communications set up with the help of Dan and Alastair.
The other big news is that we got the Ubuntu box installed yesterday, so today we made headway in getting a VDT install of Globus on Ubuntu, it is almost up and running, now we are just dealing with all of the certificate and authentication stuff, then it will be setting up tomcat, deploying OGSA-DAI, and probably setting up a little mysql database.
As for the "second computer" I am going to try and get MySQL running on it too.. then we can start trying to code OGSA-DAI proofs of concepts that pull from a PostgreSQL database and two MYSQL databases on three different computers.
Cheers,
Thus, today, I went ahead and tried some of the other example clients on that server and actually got the secure communications set up with the help of Dan and Alastair.
The other big news is that we got the Ubuntu box installed yesterday, so today we made headway in getting a VDT install of Globus on Ubuntu, it is almost up and running, now we are just dealing with all of the certificate and authentication stuff, then it will be setting up tomcat, deploying OGSA-DAI, and probably setting up a little mysql database.
As for the "second computer" I am going to try and get MySQL running on it too.. then we can start trying to code OGSA-DAI proofs of concepts that pull from a PostgreSQL database and two MYSQL databases on three different computers.
Cheers,
Subscribe to:
Posts (Atom)
Posts
