From rochkind at jhu.edu Thu Nov 13 21:07:03 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Thu, 13 Nov 2008 21:07:03 -0500
Subject: [Umlaut-general] Umlaut in terms of DLF task force model
Message-ID: <491C96F80200005700064C61@cis27.hosts.jhmi.edu>
I thought both the DLF ILS API task force list and the Umlaut list might
be interested in an analysis of Umlaut access to ILS/OPAC in terms of
the task force model, and some thoughts on how the model is a helpful
guide to improving Umlaut extensibility via refactoring.
See the last paragraph for some possible issues with GetAvailability
function and serials in Horizon, if not other ILSs.
View it on my blog for slightly more readable with html formating, or
plain text below:
**********
http://bibwild.wordpress.com/2008/11/13/umlaut-in-terms-of-dlf-ils-discovery-api-model/
**********
I realized it would be useful to analyze Umlaut in terms of the DLF ILS
Discovery API model.
Umlaut needs to talk to my OPAC/ILS in order to display local holdings,
with availability and location, as well as a button to place a
request/hold with the ILS.
DLF Task Force Model Functions Used
What Umlaut currently does is described very well by the DLF task force
model functions, which I?ll list in the order that Umlaut calls them:
6.3.3 Search (Level 2) (Identify ILS records with certain ISBNs, ISSNs,
LCCNs, OCLCnums, or as a last resort title and author keyword
matches?along with specifications of format limits in some cases,
only serials, etc.).
6.3.1 GetAvailability (Level 1) [Specifically of type 'item'] (Figure
out location and availability for items for the bibs identified
previously, to display).
8.3.1 GoToBibliographicRequestPage (Level 1) (Umlaut puts a ?request?
button on the Umlaut page, and sends user to the ILS/OPAC to actually
make the request, when clicked).
Also, Umlaut doesn?t currently do this, but I would love it to use:
7.2.5 GetServices (Level 3) (To figure out whether the ?request? button
should even be displayed in the first/place, and possibly additionally
tell the user more about what they can with this item possibly not
involving the ?request? button).
I haven?t implemented that mainly because hacking it into Horizon is a
pain (although not impossible with direct-sql access to the underlying
Sybase db, as you have with Horizon. I understand what it would take, it
would just not be fun).
Interesting that one Level 2 service is required for Umlaut to do what
it does.
Suggests Umlaut Implementation Improvements
I hacked all these in before the DLF recommendations even existed, so
they aren?t written in terms of the DLF services. (And it?s to the DLF
reccommendations credit that they properly and accurately describe my
real world use case). But it strikes me that it would be of benefit to
re-write the Umlaut code so it is specifically factored and described in
terms of those services. It would make it very clear what needs to be
done to add support for a new ILS/OPAC too?add classes that can provide
that search(), getAvailability(), and goToBibliographicRequestPage()
functionality for your particular ILS?and already written common Umlaut
code will take care of the rest. If your ILS miraculously already
supported the DLF functionality, that might already be done for you, but
if not, you know exactly what you need to write, hacking into your ILS
somehow.
(Incidentally, I personally suspect that even in a hypothetical future
case where your ILS claims to support those functions, there will be
enough idiosyncracies that you?d still need to write some specific
Umlaut code to rationalize and normalize things a bit. This doesn?t
disturb me greatly though, one step at a time. Realistic expectations.)
Ross was actually already moving the Umlaut code in that direction of
having clearly defined ILS-specific functional modules for an ILS, that
are then used by common Umlaut code?although he too was writing before
the DLF task force, so it wasn?t written in exactly those terms. The DLF
task force spec is actually an aid in architecting such a system,
they?ve already helped you factor out your functionality. But
anyway, I inherited Umlaut from Ross with this aspect being not entirely
finished, and for expediency didn?t finish carrying out that direction.
But I ought to refactor Umlaut in that direction, specifically around
the DLF task force model. If any other institution actually expresses a
real interest in Umlaut, that?ll probably be my motivation to do so.
Kinks
There are a few practical kinks that would keep the code from being a
perfect 1-to-1 mapping of the DLS task force model functions. For
instance, in a single request to HIP for ?6.3.3 Search (Level 2)?, I
actually get back complete bib records from HIP, not just local bib #s.
And HIP is slow enough at all this, that you really wouldn?t want to
make a second request to HIP just for the sake of sticking to the model.
So I imagine an Umlaut adapter for 6.3.3 Search could optionally return
MARC bibs, in which case Umlaut woudln?t need to make a call to etc.)
6.3.1 GetAvailability ? or could just return bibIDs, sticking to the DLF
task force model, in which case Umlaut would proceed to making a
seperate 6.3.1 GetAvailability call after all. No big deal.
Somewhat more troubling...
Also, GetAvailabilty is going to be a little bit tricky for serials.
Horizon identifies not just two levels for serials (Bib and Item), but
three: Bib, which can contain zero to many Copies (which might better
be called 'Runs' or maybe something else, but Horizon calls them
'copies') which can contain 0 to many 'Items'. At the 'Copy' level is
where summary holdings statements are stored, which are very important
for Umlaut to get and display for a useable interface. It's only at the
'Item' level that a request can be placed though. It's generally at the
'Copy' level that 'Location' is associated with--at least the way we use
Horizon. I think it's theoretically possible for Bib or Item to have
possibly different 'locations' too.
I'm not sure the simple DLF schema for availability is actually capable
of supporting this. It's good that the DLF schema is kept simple, but
for getting what I actually need for serials from Horizon, I'm not sure
it would work. I think some other ILSs use a three-level model for
serials (and occasionally multi-volume works) too, no?
From dale.poulter at Vanderbilt.Edu Wed Nov 19 15:28:03 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Wed, 19 Nov 2008 14:28:03 -0600
Subject: [Umlaut-general] Error with initial configuration
Message-ID: <63566160FBD1BE43873B5A100A4222DF0806B53C@mailbe17.email.Vanderbilt.edu>
Good afternoon,
We are just starting to get umlaut configured and running. The
installation went well but when we attempt to access the site we get the
error:
"LoadError in SearchController#index
Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb to
define SearchController
"
Any suggestions as to the cause or resolution to this issue? Thanks.
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
From rochkind at jhu.edu Wed Nov 19 16:03:51 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Wed, 19 Nov 2008 16:03:51 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF0806B53C@mailbe17.email.Vanderbilt.edu>
References: <63566160FBD1BE43873B5A100A4222DF0806B53C@mailbe17.email.Vanderbilt.edu>
Message-ID: <49247F37.4030201@jhu.edu>
Hi Dale. So glad you are checking it out, happy to help.
I'm actually in the middle of migrating Umlaut to use Rails2, and also
improving some of the "getting started" helper scripts, so you might
want to wait a week or two (after thanksgiving) when that should be
done, and start again then. Once I'm done, that will effectively be
"Umlaut 3.0", or a beta version of such. (I haven't been doing much
version control with Umlaut, since I was the only one using it, but I
see I'll have to start).
But I don't want to discourage you from starting now either. I'm not
sure what's going on. But from your path, I see that you have checked
out Umlaut kind of oddly. Can you give me the svn command you used to
checkout? I think you can use a better one that will make this somewhat
clearer and easier to debug.
You are on Unix, not Windows, right? That particular error is what you
get when there's a syntax error in the source file. I may have
accidentally included an error in the svn, which I wasn't worrying too
much about not knowing anyone else was looking at it. You can try "svn
up" to update your working copy to the latest svn, in case I have since
fixed it.
Out of curiousity, what ILS do you guys use? For full ILS integration,
we're going to have to do some custom coding for you, since I am
confident you don't use Horizon like us. It would be great if you'd
share a bit about what your motivation is for experimenting with Umlaut,
what you're interested in, what your plans are (if any beyond 'check it
out for now').
Since nobody but me has been using Umlaut until now, there might be some
kinks in getting it up and running, but I am happy to spend my time
ironing them out and helping you get up and running. I can call you on
the phone at a later point if it looks like we could use some
synchronous communication.
Jonathan
Poulter, Dale wrote:
> Good afternoon,
>
>
>
> We are just starting to get umlaut configured and running. The
> installation went well but when we attempt to access the site we get the
> error:
>
>
>
>
> "LoadError in SearchController#index
>
>
> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb to
> define SearchController
>
> "
>
>
>
> Any suggestions as to the cause or resolution to this issue? Thanks.
>
>
>
> --Dale
>
>
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
>
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Umlaut-general mailing list
> Umlaut-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/umlaut-general
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From mneedlem at ufl.edu Wed Nov 19 16:06:38 2008
From: mneedlem at ufl.edu (Mark Needleman)
Date: Wed, 19 Nov 2008 16:06:38 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <49247F37.4030201@jhu.edu>
References: <63566160FBD1BE43873B5A100A4222DF0806B53C@mailbe17.email.Vanderbilt.edu>
<49247F37.4030201@jhu.edu>
Message-ID: <49247FDE.5080806@ufl.edu>
Jonathan
in the back of my mind ive been thinking of installing umlaut to take a
look at it - should i wait for your new version
also what svn command do you use to get a copy
mark
Jonathan Rochkind wrote:
> Hi Dale. So glad you are checking it out, happy to help.
>
> I'm actually in the middle of migrating Umlaut to use Rails2, and also
> improving some of the "getting started" helper scripts, so you might
> want to wait a week or two (after thanksgiving) when that should be
> done, and start again then. Once I'm done, that will effectively be
> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
> version control with Umlaut, since I was the only one using it, but I
> see I'll have to start).
>
> But I don't want to discourage you from starting now either. I'm not
> sure what's going on. But from your path, I see that you have checked
> out Umlaut kind of oddly. Can you give me the svn command you used to
> checkout? I think you can use a better one that will make this
> somewhat clearer and easier to debug.
>
> You are on Unix, not Windows, right? That particular error is what
> you get when there's a syntax error in the source file. I may have
> accidentally included an error in the svn, which I wasn't worrying too
> much about not knowing anyone else was looking at it. You can try "svn
> up" to update your working copy to the latest svn, in case I have
> since fixed it.
>
> Out of curiousity, what ILS do you guys use? For full ILS
> integration, we're going to have to do some custom coding for you,
> since I am confident you don't use Horizon like us. It would be great
> if you'd share a bit about what your motivation is for experimenting
> with Umlaut, what you're interested in, what your plans are (if any
> beyond 'check it out for now').
>
> Since nobody but me has been using Umlaut until now, there might be
> some kinks in getting it up and running, but I am happy to spend my
> time ironing them out and helping you get up and running. I can call
> you on the phone at a later point if it looks like we could use some
> synchronous communication.
>
> Jonathan
>
> Poulter, Dale wrote:
>> Good afternoon,
>>
>>
>>
>> We are just starting to get umlaut configured and running. The
>> installation went well but when we attempt to access the site we get the
>> error:
>>
>>
>>
>>
>> "LoadError in SearchController#index
>>
>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb to
>> define SearchController
>>
>> "
>>
>>
>>
>> Any suggestions as to the cause or resolution to this issue? Thanks.
>>
>>
>>
>> --Dale
>>
>>
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>>
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Umlaut-general mailing list
>> Umlaut-general at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>
>
From rochkind at jhu.edu Wed Nov 19 16:25:19 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Wed, 19 Nov 2008 16:25:19 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <49247FDE.5080806@ufl.edu>
References: <63566160FBD1BE43873B5A100A4222DF0806B53C@mailbe17.email.Vanderbilt.edu>
<49247F37.4030201@jhu.edu> <49247FDE.5080806@ufl.edu>
Message-ID: <4924843F.60909@jhu.edu>
Yes, it's probably a good idea until I finish the changes to bring it
fully into the Rails2 world, so you don't have to deal with those
changes when you're in the middle of messing with it. My changes are
also slightly improving and changing the setup procedures.
To get a read-only copy of Umlaut from the svn developers "edge" version
(which is the only way to do it right now, since I don't have any
release/version management in place yet):
svn checkout http://umlaut.rubyforge.org/svn/trunk/ ./Umlaut
Or instead of "./Umlaut", whatever local path you want to put the thing
in. I've updated the wiki page on installation with this.
(http://wiki.code4lib.org/index.php/Umlaut_Installation) Looks like
rubyforge changed their path structure a bit since I wrote the original
docs.
This will get you a 'live' svn copy that you can continue to update with
new Umlaut changes, but you can't 'commit' code back to the Umlaut
product. If someone has ruby/rails expertise and wants to commit changes
back to Umlaut, talk to me to discuss setting that up.
Jonathan
Mark Needleman wrote:
> Jonathan
>
> in the back of my mind ive been thinking of installing umlaut to take
> a look at it - should i wait for your new version
>
> also what svn command do you use to get a copy
>
> mark
>
> Jonathan Rochkind wrote:
>> Hi Dale. So glad you are checking it out, happy to help.
>>
>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>> also improving some of the "getting started" helper scripts, so you
>> might want to wait a week or two (after thanksgiving) when that
>> should be done, and start again then. Once I'm done, that will
>> effectively be "Umlaut 3.0", or a beta version of such. (I haven't
>> been doing much version control with Umlaut, since I was the only one
>> using it, but I see I'll have to start).
>>
>> But I don't want to discourage you from starting now either. I'm not
>> sure what's going on. But from your path, I see that you have checked
>> out Umlaut kind of oddly. Can you give me the svn command you used to
>> checkout? I think you can use a better one that will make this
>> somewhat clearer and easier to debug.
>>
>> You are on Unix, not Windows, right? That particular error is what
>> you get when there's a syntax error in the source file. I may have
>> accidentally included an error in the svn, which I wasn't worrying
>> too much about not knowing anyone else was looking at it. You can try
>> "svn up" to update your working copy to the latest svn, in case I
>> have since fixed it.
>>
>> Out of curiousity, what ILS do you guys use? For full ILS
>> integration, we're going to have to do some custom coding for you,
>> since I am confident you don't use Horizon like us. It would be
>> great if you'd share a bit about what your motivation is for
>> experimenting with Umlaut, what you're interested in, what your plans
>> are (if any beyond 'check it out for now').
>>
>> Since nobody but me has been using Umlaut until now, there might be
>> some kinks in getting it up and running, but I am happy to spend my
>> time ironing them out and helping you get up and running. I can call
>> you on the phone at a later point if it looks like we could use some
>> synchronous communication.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>> Good afternoon,
>>>
>>>
>>>
>>> We are just starting to get umlaut configured and running. The
>>> installation went well but when we attempt to access the site we get
>>> the
>>> error:
>>>
>>>
>>>
>>>
>>> "LoadError in SearchController#index
>>>
>>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb to
>>> define SearchController
>>>
>>> "
>>>
>>>
>>>
>>> Any suggestions as to the cause or resolution to this issue? Thanks.
>>>
>>>
>>>
>>> --Dale
>>>
>>>
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>>
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> _______________________________________________
>>> Umlaut-general mailing list
>>> Umlaut-general at rubyforge.org
>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>
>>
> _______________________________________________
> Umlaut-general mailing list
> Umlaut-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/umlaut-general
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Wed Nov 19 20:16:42 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Wed, 19 Nov 2008 19:16:42 -0600
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <49247F37.4030201@jhu.edu>
References: <63566160FBD1BE43873B5A100A4222DF0806B53C@mailbe17.email.Vanderbilt.edu>
<49247F37.4030201@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF080B596E@mailbe17.email.Vanderbilt.edu>
Jonathan,
We have had this on our back burner for a while and I finally decided it
was time to jump in and get started. Our hope is to use umlaut to
initially provide another interface to SFX and the A-Z list but possibly
expand to use as a front end to our database A-Z list generated through
Verde.
To checkout the package I used:
Svn checkout http://umlaut.rubyforge.org/svn/
We are running this on a unix server (solaris 10 ) and our ILS is
SirsiDynix Symphony.
I'll try to re-checkout the package again and continue to work on this
but will be glad to test out anything you have ready. Thanks for your
work.
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Wednesday, November 19, 2008 3:04 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
Hi Dale. So glad you are checking it out, happy to help.
I'm actually in the middle of migrating Umlaut to use Rails2, and also
improving some of the "getting started" helper scripts, so you might
want to wait a week or two (after thanksgiving) when that should be
done, and start again then. Once I'm done, that will effectively be
"Umlaut 3.0", or a beta version of such. (I haven't been doing much
version control with Umlaut, since I was the only one using it, but I
see I'll have to start).
But I don't want to discourage you from starting now either. I'm not
sure what's going on. But from your path, I see that you have checked
out Umlaut kind of oddly. Can you give me the svn command you used to
checkout? I think you can use a better one that will make this somewhat
clearer and easier to debug.
You are on Unix, not Windows, right? That particular error is what you
get when there's a syntax error in the source file. I may have
accidentally included an error in the svn, which I wasn't worrying too
much about not knowing anyone else was looking at it. You can try "svn
up" to update your working copy to the latest svn, in case I have since
fixed it.
Out of curiousity, what ILS do you guys use? For full ILS integration,
we're going to have to do some custom coding for you, since I am
confident you don't use Horizon like us. It would be great if you'd
share a bit about what your motivation is for experimenting with Umlaut,
what you're interested in, what your plans are (if any beyond 'check it
out for now').
Since nobody but me has been using Umlaut until now, there might be some
kinks in getting it up and running, but I am happy to spend my time
ironing them out and helping you get up and running. I can call you on
the phone at a later point if it looks like we could use some
synchronous communication.
Jonathan
Poulter, Dale wrote:
> Good afternoon,
>
>
>
> We are just starting to get umlaut configured and running. The
> installation went well but when we attempt to access the site we get
the
> error:
>
>
>
>
> "LoadError in SearchController#index
>
>
> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
to
> define SearchController
>
> "
>
>
>
> Any suggestions as to the cause or resolution to this issue? Thanks.
>
>
>
> --Dale
>
>
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
>
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
>
>
>
------------------------------------------------------------------------
>
> _______________________________________________
> Umlaut-general mailing list
> Umlaut-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/umlaut-general
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Wed Nov 19 23:47:12 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Wed, 19 Nov 2008 23:47:12 -0500
Subject: [Umlaut-general] Error with initial configuration
Message-ID: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
Sounds good. At a minimum, try 'svn up' on it to get the latest version, and see if that takes care of it. It's possible you happened to check it out before in a state where it contained a bug.
If you wait until next week, I'll have "Umlaut 3.0" out, with a slightly easier setup/install process, and in Rails 2.x.
I'm not sure Umlaut is the right tool for a database A-Z list. It's really focused on the domain of SFX, which includes a journal title A-Z list, but not neccesarily a database A-Z list. Although I suppose it could be expanded in that direction, I'm not sure if it would make sense or not.
Here, we're using Xerxes, the Metalib front-end, as our database A-Z list. See http://jhsearch.library.jhu.edu, and in particular http://jhsearch.library.jhu.edu/databases/alphabetical
We decided it made more sense to base a database A-Z off of Metalib, since Metalib's unit of knowledge base is the database, while SFX's is more the journal title. ("Targets" in SFX can have a non-obvious relationship to what librarians or users think of as a 'database'). But we don't have Verde here, I'm not sure how that fits into it all really. I mean, I know what Verde is, I just don't understand how it fits into anything usefully. :)
But I think Umlaut does very well as an SFX front-end, an A-Z list, and also a service provider that can integrate known-item services in other software, like your OPAC. I am using Umlaut to provide various interesting services right on my OPAC pages (not just a link to Umlaut, but the content right on the OPAC page).
Jonathan
>>> "Poulter, Dale" 11/19/08 8:16 PM >>>
Jonathan,
We have had this on our back burner for a while and I finally decided it
was time to jump in and get started. Our hope is to use umlaut to
initially provide another interface to SFX and the A-Z list but possibly
expand to use as a front end to our database A-Z list generated through
Verde.
To checkout the package I used:
Svn checkout http://umlaut.rubyforge.org/svn/
We are running this on a unix server (solaris 10 ) and our ILS is
SirsiDynix Symphony.
I'll try to re-checkout the package again and continue to work on this
but will be glad to test out anything you have ready. Thanks for your
work.
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Wednesday, November 19, 2008 3:04 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
Hi Dale. So glad you are checking it out, happy to help.
I'm actually in the middle of migrating Umlaut to use Rails2, and also
improving some of the "getting started" helper scripts, so you might
want to wait a week or two (after thanksgiving) when that should be
done, and start again then. Once I'm done, that will effectively be
"Umlaut 3.0", or a beta version of such. (I haven't been doing much
version control with Umlaut, since I was the only one using it, but I
see I'll have to start).
But I don't want to discourage you from starting now either. I'm not
sure what's going on. But from your path, I see that you have checked
out Umlaut kind of oddly. Can you give me the svn command you used to
checkout? I think you can use a better one that will make this somewhat
clearer and easier to debug.
You are on Unix, not Windows, right? That particular error is what you
get when there's a syntax error in the source file. I may have
accidentally included an error in the svn, which I wasn't worrying too
much about not knowing anyone else was looking at it. You can try "svn
up" to update your working copy to the latest svn, in case I have since
fixed it.
Out of curiousity, what ILS do you guys use? For full ILS integration,
we're going to have to do some custom coding for you, since I am
confident you don't use Horizon like us. It would be great if you'd
share a bit about what your motivation is for experimenting with Umlaut,
what you're interested in, what your plans are (if any beyond 'check it
out for now').
Since nobody but me has been using Umlaut until now, there might be some
kinks in getting it up and running, but I am happy to spend my time
ironing them out and helping you get up and running. I can call you on
the phone at a later point if it looks like we could use some
synchronous communication.
Jonathan
Poulter, Dale wrote:
> Good afternoon,
>
>
>
> We are just starting to get umlaut configured and running. The
> installation went well but when we attempt to access the site we get
the
> error:
>
>
>
>
> "LoadError in SearchController#index
>
>
> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
to
> define SearchController
>
> "
>
>
>
> Any suggestions as to the cause or resolution to this issue? Thanks.
>
>
>
> --Dale
>
>
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
>
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
>
>
>
------------------------------------------------------------------------
>
> _______________________________________________
> Umlaut-general mailing list
> Umlaut-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/umlaut-general
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From dale.poulter at Vanderbilt.Edu Sat Nov 22 16:04:56 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Sat, 22 Nov 2008 15:04:56 -0600
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
Jonathan,
I have attempted the svn up and it did update a few files. I
re-execututed the initial setup and received the error below.
rake db:migrate
(in /apps/umlaut/Umlaut)
== AddSomeMissingStuff: migrating
=============================================
-- add_index(:service_types, :service_type_value_id)
rake aborted!
Mysql::Error: Duplicate key name
'index_service_types_on_service_type_value_id': CREATE INDEX
`index_service_types_on_service_type_value_id` ON service_types
(`service_type_value_id`)
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Wednesday, November 19, 2008 10:47 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
Sounds good. At a minimum, try 'svn up' on it to get the latest version,
and see if that takes care of it. It's possible you happened to check it
out before in a state where it contained a bug.
If you wait until next week, I'll have "Umlaut 3.0" out, with a slightly
easier setup/install process, and in Rails 2.x.
I'm not sure Umlaut is the right tool for a database A-Z list. It's
really focused on the domain of SFX, which includes a journal title A-Z
list, but not neccesarily a database A-Z list. Although I suppose it
could be expanded in that direction, I'm not sure if it would make sense
or not.
Here, we're using Xerxes, the Metalib front-end, as our database A-Z
list. See http://jhsearch.library.jhu.edu, and in particular
http://jhsearch.library.jhu.edu/databases/alphabetical
We decided it made more sense to base a database A-Z off of Metalib,
since Metalib's unit of knowledge base is the database, while SFX's is
more the journal title. ("Targets" in SFX can have a non-obvious
relationship to what librarians or users think of as a 'database'). But
we don't have Verde here, I'm not sure how that fits into it all really.
I mean, I know what Verde is, I just don't understand how it fits into
anything usefully. :)
But I think Umlaut does very well as an SFX front-end, an A-Z list, and
also a service provider that can integrate known-item services in other
software, like your OPAC. I am using Umlaut to provide various
interesting services right on my OPAC pages (not just a link to Umlaut,
but the content right on the OPAC page).
Jonathan
>>> "Poulter, Dale" 11/19/08 8:16 PM >>>
Jonathan,
We have had this on our back burner for a while and I finally decided it
was time to jump in and get started. Our hope is to use umlaut to
initially provide another interface to SFX and the A-Z list but possibly
expand to use as a front end to our database A-Z list generated through
Verde.
To checkout the package I used:
Svn checkout http://umlaut.rubyforge.org/svn/
We are running this on a unix server (solaris 10 ) and our ILS is
SirsiDynix Symphony.
I'll try to re-checkout the package again and continue to work on this
but will be glad to test out anything you have ready. Thanks for your
work.
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Wednesday, November 19, 2008 3:04 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
Hi Dale. So glad you are checking it out, happy to help.
I'm actually in the middle of migrating Umlaut to use Rails2, and also
improving some of the "getting started" helper scripts, so you might
want to wait a week or two (after thanksgiving) when that should be
done, and start again then. Once I'm done, that will effectively be
"Umlaut 3.0", or a beta version of such. (I haven't been doing much
version control with Umlaut, since I was the only one using it, but I
see I'll have to start).
But I don't want to discourage you from starting now either. I'm not
sure what's going on. But from your path, I see that you have checked
out Umlaut kind of oddly. Can you give me the svn command you used to
checkout? I think you can use a better one that will make this somewhat
clearer and easier to debug.
You are on Unix, not Windows, right? That particular error is what you
get when there's a syntax error in the source file. I may have
accidentally included an error in the svn, which I wasn't worrying too
much about not knowing anyone else was looking at it. You can try "svn
up" to update your working copy to the latest svn, in case I have since
fixed it.
Out of curiousity, what ILS do you guys use? For full ILS integration,
we're going to have to do some custom coding for you, since I am
confident you don't use Horizon like us. It would be great if you'd
share a bit about what your motivation is for experimenting with Umlaut,
what you're interested in, what your plans are (if any beyond 'check it
out for now').
Since nobody but me has been using Umlaut until now, there might be some
kinks in getting it up and running, but I am happy to spend my time
ironing them out and helping you get up and running. I can call you on
the phone at a later point if it looks like we could use some
synchronous communication.
Jonathan
Poulter, Dale wrote:
> Good afternoon,
>
>
>
> We are just starting to get umlaut configured and running. The
> installation went well but when we attempt to access the site we get
the
> error:
>
>
>
>
> "LoadError in SearchController#index
>
>
> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
to
> define SearchController
>
> "
>
>
>
> Any suggestions as to the cause or resolution to this issue? Thanks.
>
>
>
> --Dale
>
>
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
>
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
>
>
>
------------------------------------------------------------------------
>
> _______________________________________________
> Umlaut-general mailing list
> Umlaut-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/umlaut-general
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Mon Nov 24 11:20:17 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 11:20:17 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
Message-ID: <492AD441.4050005@jhu.edu>
Hmm, apparently something wrong in my migrations that I should fix. I'll
try to duplicate what you are doing and fix it soon. But the migrations
are meant to create everything you need in the database. Sounds like the
index "index_service_types_on_service_type_value_id " was left over from
last time you installed, and the migrations are trying to create it
again, unsuccesfully. The migrations should be fixed to delete it and
re-create it if you run them, but in the meantime you can probably
delete it yourself manually in MySQL and re-run the migrations.
Will try to get that fixed though.
I will also have a new commit to svn soon that uses Rails2 and
simplifies setup/deploy a bit.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> I have attempted the svn up and it did update a few files. I
> re-execututed the initial setup and received the error below.
>
>
> rake db:migrate
> (in /apps/umlaut/Umlaut)
> == AddSomeMissingStuff: migrating
> =============================================
> -- add_index(:service_types, :service_type_value_id)
> rake aborted!
> Mysql::Error: Duplicate key name
> 'index_service_types_on_service_type_value_id': CREATE INDEX
> `index_service_types_on_service_type_value_id` ON service_types
> (`service_type_value_id`)
>
>
>
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Wednesday, November 19, 2008 10:47 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Sounds good. At a minimum, try 'svn up' on it to get the latest version,
> and see if that takes care of it. It's possible you happened to check it
> out before in a state where it contained a bug.
>
> If you wait until next week, I'll have "Umlaut 3.0" out, with a slightly
> easier setup/install process, and in Rails 2.x.
>
> I'm not sure Umlaut is the right tool for a database A-Z list. It's
> really focused on the domain of SFX, which includes a journal title A-Z
> list, but not neccesarily a database A-Z list. Although I suppose it
> could be expanded in that direction, I'm not sure if it would make sense
> or not.
>
> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
> list. See http://jhsearch.library.jhu.edu, and in particular
> http://jhsearch.library.jhu.edu/databases/alphabetical
>
> We decided it made more sense to base a database A-Z off of Metalib,
> since Metalib's unit of knowledge base is the database, while SFX's is
> more the journal title. ("Targets" in SFX can have a non-obvious
> relationship to what librarians or users think of as a 'database'). But
> we don't have Verde here, I'm not sure how that fits into it all really.
> I mean, I know what Verde is, I just don't understand how it fits into
> anything usefully. :)
>
> But I think Umlaut does very well as an SFX front-end, an A-Z list, and
> also a service provider that can integrate known-item services in other
> software, like your OPAC. I am using Umlaut to provide various
> interesting services right on my OPAC pages (not just a link to Umlaut,
> but the content right on the OPAC page).
>
> Jonathan
>
>
>
>>>> "Poulter, Dale" 11/19/08 8:16 PM >>>
>>>>
> Jonathan,
>
> We have had this on our back burner for a while and I finally decided it
> was time to jump in and get started. Our hope is to use umlaut to
> initially provide another interface to SFX and the A-Z list but possibly
> expand to use as a front end to our database A-Z list generated through
> Verde.
>
> To checkout the package I used:
>
> Svn checkout http://umlaut.rubyforge.org/svn/
>
>
> We are running this on a unix server (solaris 10 ) and our ILS is
> SirsiDynix Symphony.
>
> I'll try to re-checkout the package again and continue to work on this
> but will be glad to test out anything you have ready. Thanks for your
> work.
>
>
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Wednesday, November 19, 2008 3:04 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hi Dale. So glad you are checking it out, happy to help.
>
> I'm actually in the middle of migrating Umlaut to use Rails2, and also
> improving some of the "getting started" helper scripts, so you might
> want to wait a week or two (after thanksgiving) when that should be
> done, and start again then. Once I'm done, that will effectively be
> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
> version control with Umlaut, since I was the only one using it, but I
> see I'll have to start).
>
> But I don't want to discourage you from starting now either. I'm not
> sure what's going on. But from your path, I see that you have checked
> out Umlaut kind of oddly. Can you give me the svn command you used to
> checkout? I think you can use a better one that will make this somewhat
>
> clearer and easier to debug.
>
> You are on Unix, not Windows, right? That particular error is what you
> get when there's a syntax error in the source file. I may have
> accidentally included an error in the svn, which I wasn't worrying too
> much about not knowing anyone else was looking at it. You can try "svn
> up" to update your working copy to the latest svn, in case I have since
> fixed it.
>
> Out of curiousity, what ILS do you guys use? For full ILS integration,
> we're going to have to do some custom coding for you, since I am
> confident you don't use Horizon like us. It would be great if you'd
> share a bit about what your motivation is for experimenting with Umlaut,
>
> what you're interested in, what your plans are (if any beyond 'check it
> out for now').
>
> Since nobody but me has been using Umlaut until now, there might be some
>
> kinks in getting it up and running, but I am happy to spend my time
> ironing them out and helping you get up and running. I can call you on
> the phone at a later point if it looks like we could use some
> synchronous communication.
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Good afternoon,
>>
>>
>>
>> We are just starting to get umlaut configured and running. The
>> installation went well but when we attempt to access the site we get
>>
> the
>
>> error:
>>
>>
>>
>>
>> "LoadError in SearchController#index
>>
>>
>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>
> to
>
>> define SearchController
>>
>> "
>>
>>
>>
>> Any suggestions as to the cause or resolution to this issue? Thanks.
>>
>>
>>
>> --Dale
>>
>>
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>>
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>>
>>
>>
>>
> ------------------------------------------------------------------------
>
>> _______________________________________________
>> Umlaut-general mailing list
>> Umlaut-general at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Mon Nov 24 12:00:10 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 12:00:10 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
Message-ID: <492ADD9A.30404@jhu.edu>
Hmm, this is still kind of mysterious to me, Dale. Did you try to go in
and manually remove any tables in your MySQL in between your first
installation attempt and your second? That you removed some things but
not all is the only explanation I can think of for the error you're
seeing, which I can't duplicate. Maybe you removed all tables, but
didn't remove any indexes, or something?
You shouldn't actually need to re-execute ALL initial setup after an
'svn up', but you should in fact run "rake db:migrate" as you did--and
ordinarily it shouldn't give you any error.
I'd recommend dropping the entire database you are using (that you set
in umlaut_config/databases.yml), recreating the entire database from
scratch, and then re-running "rake db:migrate". That should take care
of it, and hopefully it won't re-occur. If it does, I'll have to figure
it out.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> I have attempted the svn up and it did update a few files. I
> re-execututed the initial setup and received the error below.
>
>
> rake db:migrate
> (in /apps/umlaut/Umlaut)
> == AddSomeMissingStuff: migrating
> =============================================
> -- add_index(:service_types, :service_type_value_id)
> rake aborted!
> Mysql::Error: Duplicate key name
> 'index_service_types_on_service_type_value_id': CREATE INDEX
> `index_service_types_on_service_type_value_id` ON service_types
> (`service_type_value_id`)
>
>
>
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Wednesday, November 19, 2008 10:47 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Sounds good. At a minimum, try 'svn up' on it to get the latest version,
> and see if that takes care of it. It's possible you happened to check it
> out before in a state where it contained a bug.
>
> If you wait until next week, I'll have "Umlaut 3.0" out, with a slightly
> easier setup/install process, and in Rails 2.x.
>
> I'm not sure Umlaut is the right tool for a database A-Z list. It's
> really focused on the domain of SFX, which includes a journal title A-Z
> list, but not neccesarily a database A-Z list. Although I suppose it
> could be expanded in that direction, I'm not sure if it would make sense
> or not.
>
> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
> list. See http://jhsearch.library.jhu.edu, and in particular
> http://jhsearch.library.jhu.edu/databases/alphabetical
>
> We decided it made more sense to base a database A-Z off of Metalib,
> since Metalib's unit of knowledge base is the database, while SFX's is
> more the journal title. ("Targets" in SFX can have a non-obvious
> relationship to what librarians or users think of as a 'database'). But
> we don't have Verde here, I'm not sure how that fits into it all really.
> I mean, I know what Verde is, I just don't understand how it fits into
> anything usefully. :)
>
> But I think Umlaut does very well as an SFX front-end, an A-Z list, and
> also a service provider that can integrate known-item services in other
> software, like your OPAC. I am using Umlaut to provide various
> interesting services right on my OPAC pages (not just a link to Umlaut,
> but the content right on the OPAC page).
>
> Jonathan
>
>
>
>>>> "Poulter, Dale" 11/19/08 8:16 PM >>>
>>>>
> Jonathan,
>
> We have had this on our back burner for a while and I finally decided it
> was time to jump in and get started. Our hope is to use umlaut to
> initially provide another interface to SFX and the A-Z list but possibly
> expand to use as a front end to our database A-Z list generated through
> Verde.
>
> To checkout the package I used:
>
> Svn checkout http://umlaut.rubyforge.org/svn/
>
>
> We are running this on a unix server (solaris 10 ) and our ILS is
> SirsiDynix Symphony.
>
> I'll try to re-checkout the package again and continue to work on this
> but will be glad to test out anything you have ready. Thanks for your
> work.
>
>
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Wednesday, November 19, 2008 3:04 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hi Dale. So glad you are checking it out, happy to help.
>
> I'm actually in the middle of migrating Umlaut to use Rails2, and also
> improving some of the "getting started" helper scripts, so you might
> want to wait a week or two (after thanksgiving) when that should be
> done, and start again then. Once I'm done, that will effectively be
> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
> version control with Umlaut, since I was the only one using it, but I
> see I'll have to start).
>
> But I don't want to discourage you from starting now either. I'm not
> sure what's going on. But from your path, I see that you have checked
> out Umlaut kind of oddly. Can you give me the svn command you used to
> checkout? I think you can use a better one that will make this somewhat
>
> clearer and easier to debug.
>
> You are on Unix, not Windows, right? That particular error is what you
> get when there's a syntax error in the source file. I may have
> accidentally included an error in the svn, which I wasn't worrying too
> much about not knowing anyone else was looking at it. You can try "svn
> up" to update your working copy to the latest svn, in case I have since
> fixed it.
>
> Out of curiousity, what ILS do you guys use? For full ILS integration,
> we're going to have to do some custom coding for you, since I am
> confident you don't use Horizon like us. It would be great if you'd
> share a bit about what your motivation is for experimenting with Umlaut,
>
> what you're interested in, what your plans are (if any beyond 'check it
> out for now').
>
> Since nobody but me has been using Umlaut until now, there might be some
>
> kinks in getting it up and running, but I am happy to spend my time
> ironing them out and helping you get up and running. I can call you on
> the phone at a later point if it looks like we could use some
> synchronous communication.
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Good afternoon,
>>
>>
>>
>> We are just starting to get umlaut configured and running. The
>> installation went well but when we attempt to access the site we get
>>
> the
>
>> error:
>>
>>
>>
>>
>> "LoadError in SearchController#index
>>
>>
>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>
> to
>
>> define SearchController
>>
>> "
>>
>>
>>
>> Any suggestions as to the cause or resolution to this issue? Thanks.
>>
>>
>>
>> --Dale
>>
>>
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>>
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>>
>>
>>
>>
> ------------------------------------------------------------------------
>
>> _______________________________________________
>> Umlaut-general mailing list
>> Umlaut-general at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Mon Nov 24 14:05:00 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Mon, 24 Nov 2008 13:05:00 -0600
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492ADD9A.30404@jhu.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu><63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
Jonathan,
Regretfully, the problem persists after dropping and recreating the
databases.
.... == AddSomeMissingStuff: migrating
=============================================
-- add_index(:service_types, :service_type_value_id)
-> 0.0757s
-- change_column(:dispatched_services, :status, :string, {:null=>false})
-> 0.0777s
-- rename_column(:dispatched_services, :exception, :exception_info)
rake aborted!
Mysql::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '' at line 1: ALTER TABLE dispatched_services CHANGE exception
exception_info
(See full trace by running task with --trace)
FYI:
mysql --version
mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
EditLine wrapper
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Monday, November 24, 2008 11:00 AM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
Hmm, this is still kind of mysterious to me, Dale. Did you try to go in
and manually remove any tables in your MySQL in between your first
installation attempt and your second? That you removed some things but
not all is the only explanation I can think of for the error you're
seeing, which I can't duplicate. Maybe you removed all tables, but
didn't remove any indexes, or something?
You shouldn't actually need to re-execute ALL initial setup after an
'svn up', but you should in fact run "rake db:migrate" as you did--and
ordinarily it shouldn't give you any error.
I'd recommend dropping the entire database you are using (that you set
in umlaut_config/databases.yml), recreating the entire database from
scratch, and then re-running "rake db:migrate". That should take care
of it, and hopefully it won't re-occur. If it does, I'll have to figure
it out.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> I have attempted the svn up and it did update a few files. I
> re-execututed the initial setup and received the error below.
>
>
> rake db:migrate
> (in /apps/umlaut/Umlaut)
> == AddSomeMissingStuff: migrating
> =============================================
> -- add_index(:service_types, :service_type_value_id)
> rake aborted!
> Mysql::Error: Duplicate key name
> 'index_service_types_on_service_type_value_id': CREATE INDEX
> `index_service_types_on_service_type_value_id` ON service_types
> (`service_type_value_id`)
>
>
>
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Wednesday, November 19, 2008 10:47 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Sounds good. At a minimum, try 'svn up' on it to get the latest
version,
> and see if that takes care of it. It's possible you happened to check
it
> out before in a state where it contained a bug.
>
> If you wait until next week, I'll have "Umlaut 3.0" out, with a
slightly
> easier setup/install process, and in Rails 2.x.
>
> I'm not sure Umlaut is the right tool for a database A-Z list. It's
> really focused on the domain of SFX, which includes a journal title
A-Z
> list, but not neccesarily a database A-Z list. Although I suppose it
> could be expanded in that direction, I'm not sure if it would make
sense
> or not.
>
> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
> list. See http://jhsearch.library.jhu.edu, and in particular
> http://jhsearch.library.jhu.edu/databases/alphabetical
>
> We decided it made more sense to base a database A-Z off of Metalib,
> since Metalib's unit of knowledge base is the database, while SFX's is
> more the journal title. ("Targets" in SFX can have a non-obvious
> relationship to what librarians or users think of as a 'database').
But
> we don't have Verde here, I'm not sure how that fits into it all
really.
> I mean, I know what Verde is, I just don't understand how it fits into
> anything usefully. :)
>
> But I think Umlaut does very well as an SFX front-end, an A-Z list,
and
> also a service provider that can integrate known-item services in
other
> software, like your OPAC. I am using Umlaut to provide various
> interesting services right on my OPAC pages (not just a link to
Umlaut,
> but the content right on the OPAC page).
>
> Jonathan
>
>
>
>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>
>>>>
> Jonathan,
>
> We have had this on our back burner for a while and I finally decided
it
> was time to jump in and get started. Our hope is to use umlaut to
> initially provide another interface to SFX and the A-Z list but
possibly
> expand to use as a front end to our database A-Z list generated
through
> Verde.
>
> To checkout the package I used:
>
> Svn checkout http://umlaut.rubyforge.org/svn/
>
>
> We are running this on a unix server (solaris 10 ) and our ILS is
> SirsiDynix Symphony.
>
> I'll try to re-checkout the package again and continue to work on this
> but will be glad to test out anything you have ready. Thanks for your
> work.
>
>
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Wednesday, November 19, 2008 3:04 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hi Dale. So glad you are checking it out, happy to help.
>
> I'm actually in the middle of migrating Umlaut to use Rails2, and also
> improving some of the "getting started" helper scripts, so you might
> want to wait a week or two (after thanksgiving) when that should be
> done, and start again then. Once I'm done, that will effectively be
> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
> version control with Umlaut, since I was the only one using it, but I
> see I'll have to start).
>
> But I don't want to discourage you from starting now either. I'm not
> sure what's going on. But from your path, I see that you have checked
> out Umlaut kind of oddly. Can you give me the svn command you used to
> checkout? I think you can use a better one that will make this
somewhat
>
> clearer and easier to debug.
>
> You are on Unix, not Windows, right? That particular error is what
you
> get when there's a syntax error in the source file. I may have
> accidentally included an error in the svn, which I wasn't worrying too
> much about not knowing anyone else was looking at it. You can try "svn
> up" to update your working copy to the latest svn, in case I have
since
> fixed it.
>
> Out of curiousity, what ILS do you guys use? For full ILS
integration,
> we're going to have to do some custom coding for you, since I am
> confident you don't use Horizon like us. It would be great if you'd
> share a bit about what your motivation is for experimenting with
Umlaut,
>
> what you're interested in, what your plans are (if any beyond 'check
it
> out for now').
>
> Since nobody but me has been using Umlaut until now, there might be
some
>
> kinks in getting it up and running, but I am happy to spend my time
> ironing them out and helping you get up and running. I can call you on
> the phone at a later point if it looks like we could use some
> synchronous communication.
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Good afternoon,
>>
>>
>>
>> We are just starting to get umlaut configured and running. The
>> installation went well but when we attempt to access the site we get
>>
> the
>
>> error:
>>
>>
>>
>>
>> "LoadError in SearchController#index
>>
>>
>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>
> to
>
>> define SearchController
>>
>> "
>>
>>
>>
>> Any suggestions as to the cause or resolution to this issue? Thanks.
>>
>>
>>
>> --Dale
>>
>>
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>>
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>>
>>
>>
>>
>
------------------------------------------------------------------------
>
>> _______________________________________________
>> Umlaut-general mailing list
>> Umlaut-general at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Mon Nov 24 14:59:26 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 14:59:26 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
Message-ID: <492B079E.8080005@jhu.edu>
Hmm, very odd. You are using MySQL, right? What version of MySQL? It
may be that 5.x is required, do you have 4.x instead?
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> Regretfully, the problem persists after dropping and recreating the
> databases.
>
>
> .... == AddSomeMissingStuff: migrating
> =============================================
> -- add_index(:service_types, :service_type_value_id)
> -> 0.0757s
> -- change_column(:dispatched_services, :status, :string, {:null=>false})
> -> 0.0777s
> -- rename_column(:dispatched_services, :exception, :exception_info)
> rake aborted!
> Mysql::Error: You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near '' at line 1: ALTER TABLE dispatched_services CHANGE exception
> exception_info
>
> (See full trace by running task with --trace)
>
>
> FYI:
> mysql --version
> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
> EditLine wrapper
>
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 11:00 AM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hmm, this is still kind of mysterious to me, Dale. Did you try to go in
> and manually remove any tables in your MySQL in between your first
> installation attempt and your second? That you removed some things but
> not all is the only explanation I can think of for the error you're
> seeing, which I can't duplicate. Maybe you removed all tables, but
> didn't remove any indexes, or something?
>
> You shouldn't actually need to re-execute ALL initial setup after an
> 'svn up', but you should in fact run "rake db:migrate" as you did--and
> ordinarily it shouldn't give you any error.
>
> I'd recommend dropping the entire database you are using (that you set
> in umlaut_config/databases.yml), recreating the entire database from
> scratch, and then re-running "rake db:migrate". That should take care
> of it, and hopefully it won't re-occur. If it does, I'll have to figure
> it out.
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Jonathan,
>>
>> I have attempted the svn up and it did update a few files. I
>> re-execututed the initial setup and received the error below.
>>
>>
>> rake db:migrate
>> (in /apps/umlaut/Umlaut)
>> == AddSomeMissingStuff: migrating
>> =============================================
>> -- add_index(:service_types, :service_type_value_id)
>> rake aborted!
>> Mysql::Error: Duplicate key name
>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>> `index_service_types_on_service_type_value_id` ON service_types
>> (`service_type_value_id`)
>>
>>
>>
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Wednesday, November 19, 2008 10:47 PM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>
> version,
>
>> and see if that takes care of it. It's possible you happened to check
>>
> it
>
>> out before in a state where it contained a bug.
>>
>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>
> slightly
>
>> easier setup/install process, and in Rails 2.x.
>>
>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>> really focused on the domain of SFX, which includes a journal title
>>
> A-Z
>
>> list, but not neccesarily a database A-Z list. Although I suppose it
>> could be expanded in that direction, I'm not sure if it would make
>>
> sense
>
>> or not.
>>
>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>> list. See http://jhsearch.library.jhu.edu, and in particular
>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>
>> We decided it made more sense to base a database A-Z off of Metalib,
>> since Metalib's unit of knowledge base is the database, while SFX's is
>> more the journal title. ("Targets" in SFX can have a non-obvious
>> relationship to what librarians or users think of as a 'database').
>>
> But
>
>> we don't have Verde here, I'm not sure how that fits into it all
>>
> really.
>
>> I mean, I know what Verde is, I just don't understand how it fits into
>> anything usefully. :)
>>
>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>
> and
>
>> also a service provider that can integrate known-item services in
>>
> other
>
>> software, like your OPAC. I am using Umlaut to provide various
>> interesting services right on my OPAC pages (not just a link to
>>
> Umlaut,
>
>> but the content right on the OPAC page).
>>
>> Jonathan
>>
>>
>>
>>
>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>
>>>>>
>>>>>
>> Jonathan,
>>
>> We have had this on our back burner for a while and I finally decided
>>
> it
>
>> was time to jump in and get started. Our hope is to use umlaut to
>> initially provide another interface to SFX and the A-Z list but
>>
> possibly
>
>> expand to use as a front end to our database A-Z list generated
>>
> through
>
>> Verde.
>>
>> To checkout the package I used:
>>
>> Svn checkout http://umlaut.rubyforge.org/svn/
>>
>>
>> We are running this on a unix server (solaris 10 ) and our ILS is
>> SirsiDynix Symphony.
>>
>> I'll try to re-checkout the package again and continue to work on this
>> but will be glad to test out anything you have ready. Thanks for your
>> work.
>>
>>
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Wednesday, November 19, 2008 3:04 PM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hi Dale. So glad you are checking it out, happy to help.
>>
>> I'm actually in the middle of migrating Umlaut to use Rails2, and also
>>
>
>
>> improving some of the "getting started" helper scripts, so you might
>> want to wait a week or two (after thanksgiving) when that should be
>> done, and start again then. Once I'm done, that will effectively be
>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>> version control with Umlaut, since I was the only one using it, but I
>> see I'll have to start).
>>
>> But I don't want to discourage you from starting now either. I'm not
>> sure what's going on. But from your path, I see that you have checked
>> out Umlaut kind of oddly. Can you give me the svn command you used to
>> checkout? I think you can use a better one that will make this
>>
> somewhat
>
>> clearer and easier to debug.
>>
>> You are on Unix, not Windows, right? That particular error is what
>>
> you
>
>> get when there's a syntax error in the source file. I may have
>> accidentally included an error in the svn, which I wasn't worrying too
>>
>
>
>> much about not knowing anyone else was looking at it. You can try "svn
>>
>
>
>> up" to update your working copy to the latest svn, in case I have
>>
> since
>
>> fixed it.
>>
>> Out of curiousity, what ILS do you guys use? For full ILS
>>
> integration,
>
>> we're going to have to do some custom coding for you, since I am
>> confident you don't use Horizon like us. It would be great if you'd
>> share a bit about what your motivation is for experimenting with
>>
> Umlaut,
>
>> what you're interested in, what your plans are (if any beyond 'check
>>
> it
>
>> out for now').
>>
>> Since nobody but me has been using Umlaut until now, there might be
>>
> some
>
>> kinks in getting it up and running, but I am happy to spend my time
>> ironing them out and helping you get up and running. I can call you on
>>
>
>
>> the phone at a later point if it looks like we could use some
>> synchronous communication.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Good afternoon,
>>>
>>>
>>>
>>> We are just starting to get umlaut configured and running. The
>>> installation went well but when we attempt to access the site we get
>>>
>>>
>> the
>>
>>
>>> error:
>>>
>>>
>>>
>>>
>>> "LoadError in SearchController#index
>>>
>>>
>>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>
>>>
>> to
>>
>>
>>> define SearchController
>>>
>>> "
>>>
>>>
>>>
>>> Any suggestions as to the cause or resolution to this issue? Thanks.
>>>
>>>
>>>
>>> --Dale
>>>
>>>
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>>
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>>
>>>
>>>
>>>
>>>
> ------------------------------------------------------------------------
>
>>
>>
>>> _______________________________________________
>>> Umlaut-general mailing list
>>> Umlaut-general at rubyforge.org
>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Mon Nov 24 15:05:38 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Mon, 24 Nov 2008 14:05:38 -0600
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492B079E.8080005@jhu.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu><63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu><492ADD9A.30404@jhu.edu><63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
<492B079E.8080005@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
We are running mysql version 5.0.51b
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Monday, November 24, 2008 1:59 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
Hmm, very odd. You are using MySQL, right? What version of MySQL? It
may be that 5.x is required, do you have 4.x instead?
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> Regretfully, the problem persists after dropping and recreating the
> databases.
>
>
> .... == AddSomeMissingStuff: migrating
> =============================================
> -- add_index(:service_types, :service_type_value_id)
> -> 0.0757s
> -- change_column(:dispatched_services, :status, :string,
{:null=>false})
> -> 0.0777s
> -- rename_column(:dispatched_services, :exception, :exception_info)
> rake aborted!
> Mysql::Error: You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
exception
> exception_info
>
> (See full trace by running task with --trace)
>
>
> FYI:
> mysql --version
> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
> EditLine wrapper
>
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 11:00 AM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
in
> and manually remove any tables in your MySQL in between your first
> installation attempt and your second? That you removed some things
but
> not all is the only explanation I can think of for the error you're
> seeing, which I can't duplicate. Maybe you removed all tables, but
> didn't remove any indexes, or something?
>
> You shouldn't actually need to re-execute ALL initial setup after an
> 'svn up', but you should in fact run "rake db:migrate" as you did--and
> ordinarily it shouldn't give you any error.
>
> I'd recommend dropping the entire database you are using (that you set
> in umlaut_config/databases.yml), recreating the entire database from
> scratch, and then re-running "rake db:migrate". That should take care
> of it, and hopefully it won't re-occur. If it does, I'll have to
figure
> it out.
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Jonathan,
>>
>> I have attempted the svn up and it did update a few files. I
>> re-execututed the initial setup and received the error below.
>>
>>
>> rake db:migrate
>> (in /apps/umlaut/Umlaut)
>> == AddSomeMissingStuff: migrating
>> =============================================
>> -- add_index(:service_types, :service_type_value_id)
>> rake aborted!
>> Mysql::Error: Duplicate key name
>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>> `index_service_types_on_service_type_value_id` ON service_types
>> (`service_type_value_id`)
>>
>>
>>
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Wednesday, November 19, 2008 10:47 PM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>
> version,
>
>> and see if that takes care of it. It's possible you happened to check
>>
> it
>
>> out before in a state where it contained a bug.
>>
>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>
> slightly
>
>> easier setup/install process, and in Rails 2.x.
>>
>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>> really focused on the domain of SFX, which includes a journal title
>>
> A-Z
>
>> list, but not neccesarily a database A-Z list. Although I suppose it
>> could be expanded in that direction, I'm not sure if it would make
>>
> sense
>
>> or not.
>>
>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>> list. See http://jhsearch.library.jhu.edu, and in particular
>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>
>> We decided it made more sense to base a database A-Z off of Metalib,
>> since Metalib's unit of knowledge base is the database, while SFX's
is
>> more the journal title. ("Targets" in SFX can have a non-obvious
>> relationship to what librarians or users think of as a 'database').
>>
> But
>
>> we don't have Verde here, I'm not sure how that fits into it all
>>
> really.
>
>> I mean, I know what Verde is, I just don't understand how it fits
into
>> anything usefully. :)
>>
>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>
> and
>
>> also a service provider that can integrate known-item services in
>>
> other
>
>> software, like your OPAC. I am using Umlaut to provide various
>> interesting services right on my OPAC pages (not just a link to
>>
> Umlaut,
>
>> but the content right on the OPAC page).
>>
>> Jonathan
>>
>>
>>
>>
>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>
>>>>>
>>>>>
>> Jonathan,
>>
>> We have had this on our back burner for a while and I finally decided
>>
> it
>
>> was time to jump in and get started. Our hope is to use umlaut to
>> initially provide another interface to SFX and the A-Z list but
>>
> possibly
>
>> expand to use as a front end to our database A-Z list generated
>>
> through
>
>> Verde.
>>
>> To checkout the package I used:
>>
>> Svn checkout http://umlaut.rubyforge.org/svn/
>>
>>
>> We are running this on a unix server (solaris 10 ) and our ILS is
>> SirsiDynix Symphony.
>>
>> I'll try to re-checkout the package again and continue to work on
this
>> but will be glad to test out anything you have ready. Thanks for
your
>> work.
>>
>>
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Wednesday, November 19, 2008 3:04 PM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hi Dale. So glad you are checking it out, happy to help.
>>
>> I'm actually in the middle of migrating Umlaut to use Rails2, and
also
>>
>
>
>> improving some of the "getting started" helper scripts, so you might
>> want to wait a week or two (after thanksgiving) when that should be
>> done, and start again then. Once I'm done, that will effectively be
>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>> version control with Umlaut, since I was the only one using it, but I
>> see I'll have to start).
>>
>> But I don't want to discourage you from starting now either. I'm not
>> sure what's going on. But from your path, I see that you have checked
>> out Umlaut kind of oddly. Can you give me the svn command you used to
>> checkout? I think you can use a better one that will make this
>>
> somewhat
>
>> clearer and easier to debug.
>>
>> You are on Unix, not Windows, right? That particular error is what
>>
> you
>
>> get when there's a syntax error in the source file. I may have
>> accidentally included an error in the svn, which I wasn't worrying
too
>>
>
>
>> much about not knowing anyone else was looking at it. You can try
"svn
>>
>
>
>> up" to update your working copy to the latest svn, in case I have
>>
> since
>
>> fixed it.
>>
>> Out of curiousity, what ILS do you guys use? For full ILS
>>
> integration,
>
>> we're going to have to do some custom coding for you, since I am
>> confident you don't use Horizon like us. It would be great if you'd
>> share a bit about what your motivation is for experimenting with
>>
> Umlaut,
>
>> what you're interested in, what your plans are (if any beyond 'check
>>
> it
>
>> out for now').
>>
>> Since nobody but me has been using Umlaut until now, there might be
>>
> some
>
>> kinks in getting it up and running, but I am happy to spend my time
>> ironing them out and helping you get up and running. I can call you
on
>>
>
>
>> the phone at a later point if it looks like we could use some
>> synchronous communication.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Good afternoon,
>>>
>>>
>>>
>>> We are just starting to get umlaut configured and running. The
>>> installation went well but when we attempt to access the site we get
>>>
>>>
>> the
>>
>>
>>> error:
>>>
>>>
>>>
>>>
>>> "LoadError in SearchController#index
>>>
>>>
>>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>
>>>
>> to
>>
>>
>>> define SearchController
>>>
>>> "
>>>
>>>
>>>
>>> Any suggestions as to the cause or resolution to this issue?
Thanks.
>>>
>>>
>>>
>>> --Dale
>>>
>>>
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>>
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>>
>>>
>>>
>>>
>>>
>
------------------------------------------------------------------------
>
>>
>>
>>> _______________________________________________
>>> Umlaut-general mailing list
>>> Umlaut-general at rubyforge.org
>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Mon Nov 24 15:07:19 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 15:07:19 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
<492B079E.8080005@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
Message-ID: <492B0977.8000409@jhu.edu>
That should be fine. How very odd. I'll google around and see if I can
figure out anything. Alternately, if you wanted to/were able to give me
shell access to your server, I'm happy to try debugging it from that end
when I have a chance.
Jonathan
Poulter, Dale wrote:
> We are running mysql version 5.0.51b
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 1:59 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hmm, very odd. You are using MySQL, right? What version of MySQL? It
> may be that 5.x is required, do you have 4.x instead?
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Jonathan,
>>
>> Regretfully, the problem persists after dropping and recreating the
>> databases.
>>
>>
>> .... == AddSomeMissingStuff: migrating
>> =============================================
>> -- add_index(:service_types, :service_type_value_id)
>> -> 0.0757s
>> -- change_column(:dispatched_services, :status, :string,
>>
> {:null=>false})
>
>> -> 0.0777s
>> -- rename_column(:dispatched_services, :exception, :exception_info)
>> rake aborted!
>> Mysql::Error: You have an error in your SQL syntax; check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>
> exception
>
>> exception_info
>>
>> (See full trace by running task with --trace)
>>
>>
>> FYI:
>> mysql --version
>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>> EditLine wrapper
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 11:00 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>
> in
>
>> and manually remove any tables in your MySQL in between your first
>> installation attempt and your second? That you removed some things
>>
> but
>
>> not all is the only explanation I can think of for the error you're
>> seeing, which I can't duplicate. Maybe you removed all tables, but
>> didn't remove any indexes, or something?
>>
>> You shouldn't actually need to re-execute ALL initial setup after an
>> 'svn up', but you should in fact run "rake db:migrate" as you did--and
>>
>
>
>> ordinarily it shouldn't give you any error.
>>
>> I'd recommend dropping the entire database you are using (that you set
>>
>
>
>> in umlaut_config/databases.yml), recreating the entire database from
>> scratch, and then re-running "rake db:migrate". That should take care
>>
>
>
>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>
> figure
>
>> it out.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Jonathan,
>>>
>>> I have attempted the svn up and it did update a few files. I
>>> re-execututed the initial setup and received the error below.
>>>
>>>
>>> rake db:migrate
>>> (in /apps/umlaut/Umlaut)
>>> == AddSomeMissingStuff: migrating
>>> =============================================
>>> -- add_index(:service_types, :service_type_value_id)
>>> rake aborted!
>>> Mysql::Error: Duplicate key name
>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>> `index_service_types_on_service_type_value_id` ON service_types
>>> (`service_type_value_id`)
>>>
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>
>>>
>> version,
>>
>>
>>> and see if that takes care of it. It's possible you happened to check
>>>
>>>
>> it
>>
>>
>>> out before in a state where it contained a bug.
>>>
>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>
>>>
>> slightly
>>
>>
>>> easier setup/install process, and in Rails 2.x.
>>>
>>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>>> really focused on the domain of SFX, which includes a journal title
>>>
>>>
>> A-Z
>>
>>
>>> list, but not neccesarily a database A-Z list. Although I suppose it
>>> could be expanded in that direction, I'm not sure if it would make
>>>
>>>
>> sense
>>
>>
>>> or not.
>>>
>>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>
>>> We decided it made more sense to base a database A-Z off of Metalib,
>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>
> is
>
>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>> relationship to what librarians or users think of as a 'database').
>>>
>>>
>> But
>>
>>
>>> we don't have Verde here, I'm not sure how that fits into it all
>>>
>>>
>> really.
>>
>>
>>> I mean, I know what Verde is, I just don't understand how it fits
>>>
> into
>
>>> anything usefully. :)
>>>
>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>
>>>
>> and
>>
>>
>>> also a service provider that can integrate known-item services in
>>>
>>>
>> other
>>
>>
>>> software, like your OPAC. I am using Umlaut to provide various
>>> interesting services right on my OPAC pages (not just a link to
>>>
>>>
>> Umlaut,
>>
>>
>>> but the content right on the OPAC page).
>>>
>>> Jonathan
>>>
>>>
>>>
>>>
>>>
>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>> Jonathan,
>>>
>>> We have had this on our back burner for a while and I finally decided
>>>
>>>
>> it
>>
>>
>>> was time to jump in and get started. Our hope is to use umlaut to
>>> initially provide another interface to SFX and the A-Z list but
>>>
>>>
>> possibly
>>
>>
>>> expand to use as a front end to our database A-Z list generated
>>>
>>>
>> through
>>
>>
>>> Verde.
>>>
>>> To checkout the package I used:
>>>
>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>
>>>
>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>> SirsiDynix Symphony.
>>>
>>> I'll try to re-checkout the package again and continue to work on
>>>
> this
>
>>> but will be glad to test out anything you have ready. Thanks for
>>>
> your
>
>>> work.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Hi Dale. So glad you are checking it out, happy to help.
>>>
>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>
> also
>
>>>
>>>
>>
>>
>>> improving some of the "getting started" helper scripts, so you might
>>> want to wait a week or two (after thanksgiving) when that should be
>>> done, and start again then. Once I'm done, that will effectively be
>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>>> version control with Umlaut, since I was the only one using it, but I
>>>
>
>
>>> see I'll have to start).
>>>
>>> But I don't want to discourage you from starting now either. I'm not
>>> sure what's going on. But from your path, I see that you have checked
>>>
>
>
>>> out Umlaut kind of oddly. Can you give me the svn command you used to
>>>
>
>
>>> checkout? I think you can use a better one that will make this
>>>
>>>
>> somewhat
>>
>>
>>> clearer and easier to debug.
>>>
>>> You are on Unix, not Windows, right? That particular error is what
>>>
>>>
>> you
>>
>>
>>> get when there's a syntax error in the source file. I may have
>>> accidentally included an error in the svn, which I wasn't worrying
>>>
> too
>
>>>
>>>
>>
>>
>>> much about not knowing anyone else was looking at it. You can try
>>>
> "svn
>
>>>
>>>
>>
>>
>>> up" to update your working copy to the latest svn, in case I have
>>>
>>>
>> since
>>
>>
>>> fixed it.
>>>
>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>
>>>
>> integration,
>>
>>
>>> we're going to have to do some custom coding for you, since I am
>>> confident you don't use Horizon like us. It would be great if you'd
>>> share a bit about what your motivation is for experimenting with
>>>
>>>
>> Umlaut,
>>
>>
>>> what you're interested in, what your plans are (if any beyond 'check
>>>
>>>
>> it
>>
>>
>>> out for now').
>>>
>>> Since nobody but me has been using Umlaut until now, there might be
>>>
>>>
>> some
>>
>>
>>> kinks in getting it up and running, but I am happy to spend my time
>>> ironing them out and helping you get up and running. I can call you
>>>
> on
>
>>>
>>>
>>
>>
>>> the phone at a later point if it looks like we could use some
>>> synchronous communication.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>
>>>
>>>> Good afternoon,
>>>>
>>>>
>>>>
>>>> We are just starting to get umlaut configured and running. The
>>>> installation went well but when we attempt to access the site we get
>>>>
>>>>
>>>>
>>> the
>>>
>>>
>>>
>>>> error:
>>>>
>>>>
>>>>
>>>>
>>>> "LoadError in SearchController#index
>>>>
>>>>
>>>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>>
>>>>
>>>>
>>> to
>>>
>>>
>>>
>>>> define SearchController
>>>>
>>>> "
>>>>
>>>>
>>>>
>>>> Any suggestions as to the cause or resolution to this issue?
>>>>
> Thanks.
>
>>>>
>>>>
>>>> --Dale
>>>>
>>>>
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>>
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
> ------------------------------------------------------------------------
>
>>
>>
>>>
>>>
>>>
>>>> _______________________________________________
>>>> Umlaut-general mailing list
>>>> Umlaut-general at rubyforge.org
>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Mon Nov 24 15:13:17 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 15:13:17 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
<492B079E.8080005@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
Message-ID: <492B0ADD.4040300@jhu.edu>
Aha. A bit of googling suggests you may have run into a bug in a version
of the Rails MySQL adapters:
http://jira.codehaus.org/browse/JRUBY-1543
( You aren't trying to use JRuby are you? I think you've just run into
a bug that the JRuby folks happened to run into also, which isn't
specific to JRuby ).
I have installed the 'mysql' gem for my Umlaut, which I think my
instructions say is 'optional', as theoretically Rails can connect to
MySQL without it. But it may be advisable.
Do you have the MySQL gem installed, and if so, what version? I have
2.7, it looks like.
[jrochki1 at testbox U2]$ gem list mysql
*** LOCAL GEMS ***
mysql (2.7)
It looks to me like 2.7 is indeed the latest version. If you don't have
it, you can do:
sudo gem install mysql
or
sudo gem update mysql
to get the latest version.
Sorry this isn't smoother than it is, that's how it goes sometimes, as
more people adopt Umlaut we can hopefully get it smoothed out.
If you DO have mysql gem 2.7 installed, then it's really going to be a
mystery.
Jonathan
Poulter, Dale wrote:
> We are running mysql version 5.0.51b
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 1:59 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hmm, very odd. You are using MySQL, right? What version of MySQL? It
> may be that 5.x is required, do you have 4.x instead?
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Jonathan,
>>
>> Regretfully, the problem persists after dropping and recreating the
>> databases.
>>
>>
>> .... == AddSomeMissingStuff: migrating
>> =============================================
>> -- add_index(:service_types, :service_type_value_id)
>> -> 0.0757s
>> -- change_column(:dispatched_services, :status, :string,
>>
> {:null=>false})
>
>> -> 0.0777s
>> -- rename_column(:dispatched_services, :exception, :exception_info)
>> rake aborted!
>> Mysql::Error: You have an error in your SQL syntax; check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>
> exception
>
>> exception_info
>>
>> (See full trace by running task with --trace)
>>
>>
>> FYI:
>> mysql --version
>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>> EditLine wrapper
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 11:00 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>
> in
>
>> and manually remove any tables in your MySQL in between your first
>> installation attempt and your second? That you removed some things
>>
> but
>
>> not all is the only explanation I can think of for the error you're
>> seeing, which I can't duplicate. Maybe you removed all tables, but
>> didn't remove any indexes, or something?
>>
>> You shouldn't actually need to re-execute ALL initial setup after an
>> 'svn up', but you should in fact run "rake db:migrate" as you did--and
>>
>
>
>> ordinarily it shouldn't give you any error.
>>
>> I'd recommend dropping the entire database you are using (that you set
>>
>
>
>> in umlaut_config/databases.yml), recreating the entire database from
>> scratch, and then re-running "rake db:migrate". That should take care
>>
>
>
>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>
> figure
>
>> it out.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Jonathan,
>>>
>>> I have attempted the svn up and it did update a few files. I
>>> re-execututed the initial setup and received the error below.
>>>
>>>
>>> rake db:migrate
>>> (in /apps/umlaut/Umlaut)
>>> == AddSomeMissingStuff: migrating
>>> =============================================
>>> -- add_index(:service_types, :service_type_value_id)
>>> rake aborted!
>>> Mysql::Error: Duplicate key name
>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>> `index_service_types_on_service_type_value_id` ON service_types
>>> (`service_type_value_id`)
>>>
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>
>>>
>> version,
>>
>>
>>> and see if that takes care of it. It's possible you happened to check
>>>
>>>
>> it
>>
>>
>>> out before in a state where it contained a bug.
>>>
>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>
>>>
>> slightly
>>
>>
>>> easier setup/install process, and in Rails 2.x.
>>>
>>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>>> really focused on the domain of SFX, which includes a journal title
>>>
>>>
>> A-Z
>>
>>
>>> list, but not neccesarily a database A-Z list. Although I suppose it
>>> could be expanded in that direction, I'm not sure if it would make
>>>
>>>
>> sense
>>
>>
>>> or not.
>>>
>>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>
>>> We decided it made more sense to base a database A-Z off of Metalib,
>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>
> is
>
>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>> relationship to what librarians or users think of as a 'database').
>>>
>>>
>> But
>>
>>
>>> we don't have Verde here, I'm not sure how that fits into it all
>>>
>>>
>> really.
>>
>>
>>> I mean, I know what Verde is, I just don't understand how it fits
>>>
> into
>
>>> anything usefully. :)
>>>
>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>
>>>
>> and
>>
>>
>>> also a service provider that can integrate known-item services in
>>>
>>>
>> other
>>
>>
>>> software, like your OPAC. I am using Umlaut to provide various
>>> interesting services right on my OPAC pages (not just a link to
>>>
>>>
>> Umlaut,
>>
>>
>>> but the content right on the OPAC page).
>>>
>>> Jonathan
>>>
>>>
>>>
>>>
>>>
>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>> Jonathan,
>>>
>>> We have had this on our back burner for a while and I finally decided
>>>
>>>
>> it
>>
>>
>>> was time to jump in and get started. Our hope is to use umlaut to
>>> initially provide another interface to SFX and the A-Z list but
>>>
>>>
>> possibly
>>
>>
>>> expand to use as a front end to our database A-Z list generated
>>>
>>>
>> through
>>
>>
>>> Verde.
>>>
>>> To checkout the package I used:
>>>
>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>
>>>
>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>> SirsiDynix Symphony.
>>>
>>> I'll try to re-checkout the package again and continue to work on
>>>
> this
>
>>> but will be glad to test out anything you have ready. Thanks for
>>>
> your
>
>>> work.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Hi Dale. So glad you are checking it out, happy to help.
>>>
>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>
> also
>
>>>
>>>
>>
>>
>>> improving some of the "getting started" helper scripts, so you might
>>> want to wait a week or two (after thanksgiving) when that should be
>>> done, and start again then. Once I'm done, that will effectively be
>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>>> version control with Umlaut, since I was the only one using it, but I
>>>
>
>
>>> see I'll have to start).
>>>
>>> But I don't want to discourage you from starting now either. I'm not
>>> sure what's going on. But from your path, I see that you have checked
>>>
>
>
>>> out Umlaut kind of oddly. Can you give me the svn command you used to
>>>
>
>
>>> checkout? I think you can use a better one that will make this
>>>
>>>
>> somewhat
>>
>>
>>> clearer and easier to debug.
>>>
>>> You are on Unix, not Windows, right? That particular error is what
>>>
>>>
>> you
>>
>>
>>> get when there's a syntax error in the source file. I may have
>>> accidentally included an error in the svn, which I wasn't worrying
>>>
> too
>
>>>
>>>
>>
>>
>>> much about not knowing anyone else was looking at it. You can try
>>>
> "svn
>
>>>
>>>
>>
>>
>>> up" to update your working copy to the latest svn, in case I have
>>>
>>>
>> since
>>
>>
>>> fixed it.
>>>
>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>
>>>
>> integration,
>>
>>
>>> we're going to have to do some custom coding for you, since I am
>>> confident you don't use Horizon like us. It would be great if you'd
>>> share a bit about what your motivation is for experimenting with
>>>
>>>
>> Umlaut,
>>
>>
>>> what you're interested in, what your plans are (if any beyond 'check
>>>
>>>
>> it
>>
>>
>>> out for now').
>>>
>>> Since nobody but me has been using Umlaut until now, there might be
>>>
>>>
>> some
>>
>>
>>> kinks in getting it up and running, but I am happy to spend my time
>>> ironing them out and helping you get up and running. I can call you
>>>
> on
>
>>>
>>>
>>
>>
>>> the phone at a later point if it looks like we could use some
>>> synchronous communication.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>
>>>
>>>> Good afternoon,
>>>>
>>>>
>>>>
>>>> We are just starting to get umlaut configured and running. The
>>>> installation went well but when we attempt to access the site we get
>>>>
>>>>
>>>>
>>> the
>>>
>>>
>>>
>>>> error:
>>>>
>>>>
>>>>
>>>>
>>>> "LoadError in SearchController#index
>>>>
>>>>
>>>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>>
>>>>
>>>>
>>> to
>>>
>>>
>>>
>>>> define SearchController
>>>>
>>>> "
>>>>
>>>>
>>>>
>>>> Any suggestions as to the cause or resolution to this issue?
>>>>
> Thanks.
>
>>>>
>>>>
>>>> --Dale
>>>>
>>>>
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>>
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
> ------------------------------------------------------------------------
>
>>
>>
>>>
>>>
>>>
>>>> _______________________________________________
>>>> Umlaut-general mailing list
>>>> Umlaut-general at rubyforge.org
>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Mon Nov 24 15:15:25 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 15:15:25 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
<492B079E.8080005@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
Message-ID: <492B0B5D.9080805@jhu.edu>
Incidentally, Dale, I'm -just- about to commit changes to Umlaut to have
it use Rails2 to the main svn trunk. It's also possible this MySQL bug
in the default built-in mysql adapter will be fixed in Rails2.
The local configuration has changed a bit (for the better) in this new
version of Umlaut too.
Jonathan
Poulter, Dale wrote:
> We are running mysql version 5.0.51b
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 1:59 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hmm, very odd. You are using MySQL, right? What version of MySQL? It
> may be that 5.x is required, do you have 4.x instead?
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Jonathan,
>>
>> Regretfully, the problem persists after dropping and recreating the
>> databases.
>>
>>
>> .... == AddSomeMissingStuff: migrating
>> =============================================
>> -- add_index(:service_types, :service_type_value_id)
>> -> 0.0757s
>> -- change_column(:dispatched_services, :status, :string,
>>
> {:null=>false})
>
>> -> 0.0777s
>> -- rename_column(:dispatched_services, :exception, :exception_info)
>> rake aborted!
>> Mysql::Error: You have an error in your SQL syntax; check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>
> exception
>
>> exception_info
>>
>> (See full trace by running task with --trace)
>>
>>
>> FYI:
>> mysql --version
>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>> EditLine wrapper
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 11:00 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>
> in
>
>> and manually remove any tables in your MySQL in between your first
>> installation attempt and your second? That you removed some things
>>
> but
>
>> not all is the only explanation I can think of for the error you're
>> seeing, which I can't duplicate. Maybe you removed all tables, but
>> didn't remove any indexes, or something?
>>
>> You shouldn't actually need to re-execute ALL initial setup after an
>> 'svn up', but you should in fact run "rake db:migrate" as you did--and
>>
>
>
>> ordinarily it shouldn't give you any error.
>>
>> I'd recommend dropping the entire database you are using (that you set
>>
>
>
>> in umlaut_config/databases.yml), recreating the entire database from
>> scratch, and then re-running "rake db:migrate". That should take care
>>
>
>
>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>
> figure
>
>> it out.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Jonathan,
>>>
>>> I have attempted the svn up and it did update a few files. I
>>> re-execututed the initial setup and received the error below.
>>>
>>>
>>> rake db:migrate
>>> (in /apps/umlaut/Umlaut)
>>> == AddSomeMissingStuff: migrating
>>> =============================================
>>> -- add_index(:service_types, :service_type_value_id)
>>> rake aborted!
>>> Mysql::Error: Duplicate key name
>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>> `index_service_types_on_service_type_value_id` ON service_types
>>> (`service_type_value_id`)
>>>
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>
>>>
>> version,
>>
>>
>>> and see if that takes care of it. It's possible you happened to check
>>>
>>>
>> it
>>
>>
>>> out before in a state where it contained a bug.
>>>
>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>
>>>
>> slightly
>>
>>
>>> easier setup/install process, and in Rails 2.x.
>>>
>>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>>> really focused on the domain of SFX, which includes a journal title
>>>
>>>
>> A-Z
>>
>>
>>> list, but not neccesarily a database A-Z list. Although I suppose it
>>> could be expanded in that direction, I'm not sure if it would make
>>>
>>>
>> sense
>>
>>
>>> or not.
>>>
>>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>
>>> We decided it made more sense to base a database A-Z off of Metalib,
>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>
> is
>
>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>> relationship to what librarians or users think of as a 'database').
>>>
>>>
>> But
>>
>>
>>> we don't have Verde here, I'm not sure how that fits into it all
>>>
>>>
>> really.
>>
>>
>>> I mean, I know what Verde is, I just don't understand how it fits
>>>
> into
>
>>> anything usefully. :)
>>>
>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>
>>>
>> and
>>
>>
>>> also a service provider that can integrate known-item services in
>>>
>>>
>> other
>>
>>
>>> software, like your OPAC. I am using Umlaut to provide various
>>> interesting services right on my OPAC pages (not just a link to
>>>
>>>
>> Umlaut,
>>
>>
>>> but the content right on the OPAC page).
>>>
>>> Jonathan
>>>
>>>
>>>
>>>
>>>
>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>> Jonathan,
>>>
>>> We have had this on our back burner for a while and I finally decided
>>>
>>>
>> it
>>
>>
>>> was time to jump in and get started. Our hope is to use umlaut to
>>> initially provide another interface to SFX and the A-Z list but
>>>
>>>
>> possibly
>>
>>
>>> expand to use as a front end to our database A-Z list generated
>>>
>>>
>> through
>>
>>
>>> Verde.
>>>
>>> To checkout the package I used:
>>>
>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>
>>>
>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>> SirsiDynix Symphony.
>>>
>>> I'll try to re-checkout the package again and continue to work on
>>>
> this
>
>>> but will be glad to test out anything you have ready. Thanks for
>>>
> your
>
>>> work.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Hi Dale. So glad you are checking it out, happy to help.
>>>
>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>
> also
>
>>>
>>>
>>
>>
>>> improving some of the "getting started" helper scripts, so you might
>>> want to wait a week or two (after thanksgiving) when that should be
>>> done, and start again then. Once I'm done, that will effectively be
>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>>> version control with Umlaut, since I was the only one using it, but I
>>>
>
>
>>> see I'll have to start).
>>>
>>> But I don't want to discourage you from starting now either. I'm not
>>> sure what's going on. But from your path, I see that you have checked
>>>
>
>
>>> out Umlaut kind of oddly. Can you give me the svn command you used to
>>>
>
>
>>> checkout? I think you can use a better one that will make this
>>>
>>>
>> somewhat
>>
>>
>>> clearer and easier to debug.
>>>
>>> You are on Unix, not Windows, right? That particular error is what
>>>
>>>
>> you
>>
>>
>>> get when there's a syntax error in the source file. I may have
>>> accidentally included an error in the svn, which I wasn't worrying
>>>
> too
>
>>>
>>>
>>
>>
>>> much about not knowing anyone else was looking at it. You can try
>>>
> "svn
>
>>>
>>>
>>
>>
>>> up" to update your working copy to the latest svn, in case I have
>>>
>>>
>> since
>>
>>
>>> fixed it.
>>>
>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>
>>>
>> integration,
>>
>>
>>> we're going to have to do some custom coding for you, since I am
>>> confident you don't use Horizon like us. It would be great if you'd
>>> share a bit about what your motivation is for experimenting with
>>>
>>>
>> Umlaut,
>>
>>
>>> what you're interested in, what your plans are (if any beyond 'check
>>>
>>>
>> it
>>
>>
>>> out for now').
>>>
>>> Since nobody but me has been using Umlaut until now, there might be
>>>
>>>
>> some
>>
>>
>>> kinks in getting it up and running, but I am happy to spend my time
>>> ironing them out and helping you get up and running. I can call you
>>>
> on
>
>>>
>>>
>>
>>
>>> the phone at a later point if it looks like we could use some
>>> synchronous communication.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>
>>>
>>>> Good afternoon,
>>>>
>>>>
>>>>
>>>> We are just starting to get umlaut configured and running. The
>>>> installation went well but when we attempt to access the site we get
>>>>
>>>>
>>>>
>>> the
>>>
>>>
>>>
>>>> error:
>>>>
>>>>
>>>>
>>>>
>>>> "LoadError in SearchController#index
>>>>
>>>>
>>>> Expected /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>>
>>>>
>>>>
>>> to
>>>
>>>
>>>
>>>> define SearchController
>>>>
>>>> "
>>>>
>>>>
>>>>
>>>> Any suggestions as to the cause or resolution to this issue?
>>>>
> Thanks.
>
>>>>
>>>>
>>>> --Dale
>>>>
>>>>
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>>
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
> ------------------------------------------------------------------------
>
>>
>>
>>>
>>>
>>>
>>>> _______________________________________________
>>>> Umlaut-general mailing list
>>>> Umlaut-general at rubyforge.org
>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Mon Nov 24 15:29:27 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Mon, 24 Nov 2008 14:29:27 -0600
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492B0ADD.4040300@jhu.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu><63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu><492ADD9A.30404@jhu.edu><63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu><492B079E.8080005@jhu.edu><63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
<492B0ADD.4040300@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu>
Jonathan,
Bugs always happen. I do have the mysql gem v2.7 installed (see output
below). Since you are almost done with moving to rails2, would it be
better to wait a day or two and try the new version? I would assume
that people will attempt to install the newer version.
bash-3.00# gem list mysql
*** LOCAL GEMS ***
mysql (2.7)
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Monday, November 24, 2008 2:13 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
Aha. A bit of googling suggests you may have run into a bug in a version
of the Rails MySQL adapters:
http://jira.codehaus.org/browse/JRUBY-1543
( You aren't trying to use JRuby are you? I think you've just run into
a bug that the JRuby folks happened to run into also, which isn't
specific to JRuby ).
I have installed the 'mysql' gem for my Umlaut, which I think my
instructions say is 'optional', as theoretically Rails can connect to
MySQL without it. But it may be advisable.
Do you have the MySQL gem installed, and if so, what version? I have
2.7, it looks like.
[jrochki1 at testbox U2]$ gem list mysql
*** LOCAL GEMS ***
mysql (2.7)
It looks to me like 2.7 is indeed the latest version. If you don't have
it, you can do:
sudo gem install mysql
or
sudo gem update mysql
to get the latest version.
Sorry this isn't smoother than it is, that's how it goes sometimes, as
more people adopt Umlaut we can hopefully get it smoothed out.
If you DO have mysql gem 2.7 installed, then it's really going to be a
mystery.
Jonathan
Poulter, Dale wrote:
> We are running mysql version 5.0.51b
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 1:59 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Hmm, very odd. You are using MySQL, right? What version of MySQL? It
> may be that 5.x is required, do you have 4.x instead?
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Jonathan,
>>
>> Regretfully, the problem persists after dropping and recreating the
>> databases.
>>
>>
>> .... == AddSomeMissingStuff: migrating
>> =============================================
>> -- add_index(:service_types, :service_type_value_id)
>> -> 0.0757s
>> -- change_column(:dispatched_services, :status, :string,
>>
> {:null=>false})
>
>> -> 0.0777s
>> -- rename_column(:dispatched_services, :exception, :exception_info)
>> rake aborted!
>> Mysql::Error: You have an error in your SQL syntax; check the manual
>> that corresponds to your MySQL server version for the right syntax to
>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>
> exception
>
>> exception_info
>>
>> (See full trace by running task with --trace)
>>
>>
>> FYI:
>> mysql --version
>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>> EditLine wrapper
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 11:00 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>
> in
>
>> and manually remove any tables in your MySQL in between your first
>> installation attempt and your second? That you removed some things
>>
> but
>
>> not all is the only explanation I can think of for the error you're
>> seeing, which I can't duplicate. Maybe you removed all tables, but
>> didn't remove any indexes, or something?
>>
>> You shouldn't actually need to re-execute ALL initial setup after an
>> 'svn up', but you should in fact run "rake db:migrate" as you
did--and
>>
>
>
>> ordinarily it shouldn't give you any error.
>>
>> I'd recommend dropping the entire database you are using (that you
set
>>
>
>
>> in umlaut_config/databases.yml), recreating the entire database from
>> scratch, and then re-running "rake db:migrate". That should take
care
>>
>
>
>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>
> figure
>
>> it out.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Jonathan,
>>>
>>> I have attempted the svn up and it did update a few files. I
>>> re-execututed the initial setup and received the error below.
>>>
>>>
>>> rake db:migrate
>>> (in /apps/umlaut/Umlaut)
>>> == AddSomeMissingStuff: migrating
>>> =============================================
>>> -- add_index(:service_types, :service_type_value_id)
>>> rake aborted!
>>> Mysql::Error: Duplicate key name
>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>> `index_service_types_on_service_type_value_id` ON service_types
>>> (`service_type_value_id`)
>>>
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>
>>>
>> version,
>>
>>
>>> and see if that takes care of it. It's possible you happened to
check
>>>
>>>
>> it
>>
>>
>>> out before in a state where it contained a bug.
>>>
>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>
>>>
>> slightly
>>
>>
>>> easier setup/install process, and in Rails 2.x.
>>>
>>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>>> really focused on the domain of SFX, which includes a journal title
>>>
>>>
>> A-Z
>>
>>
>>> list, but not neccesarily a database A-Z list. Although I suppose
it
>>> could be expanded in that direction, I'm not sure if it would make
>>>
>>>
>> sense
>>
>>
>>> or not.
>>>
>>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>
>>> We decided it made more sense to base a database A-Z off of Metalib,
>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>
> is
>
>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>> relationship to what librarians or users think of as a 'database').
>>>
>>>
>> But
>>
>>
>>> we don't have Verde here, I'm not sure how that fits into it all
>>>
>>>
>> really.
>>
>>
>>> I mean, I know what Verde is, I just don't understand how it fits
>>>
> into
>
>>> anything usefully. :)
>>>
>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>
>>>
>> and
>>
>>
>>> also a service provider that can integrate known-item services in
>>>
>>>
>> other
>>
>>
>>> software, like your OPAC. I am using Umlaut to provide various
>>> interesting services right on my OPAC pages (not just a link to
>>>
>>>
>> Umlaut,
>>
>>
>>> but the content right on the OPAC page).
>>>
>>> Jonathan
>>>
>>>
>>>
>>>
>>>
>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>> Jonathan,
>>>
>>> We have had this on our back burner for a while and I finally
decided
>>>
>>>
>> it
>>
>>
>>> was time to jump in and get started. Our hope is to use umlaut to
>>> initially provide another interface to SFX and the A-Z list but
>>>
>>>
>> possibly
>>
>>
>>> expand to use as a front end to our database A-Z list generated
>>>
>>>
>> through
>>
>>
>>> Verde.
>>>
>>> To checkout the package I used:
>>>
>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>
>>>
>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>> SirsiDynix Symphony.
>>>
>>> I'll try to re-checkout the package again and continue to work on
>>>
> this
>
>>> but will be glad to test out anything you have ready. Thanks for
>>>
> your
>
>>> work.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Hi Dale. So glad you are checking it out, happy to help.
>>>
>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>
> also
>
>>>
>>>
>>
>>
>>> improving some of the "getting started" helper scripts, so you might
>>> want to wait a week or two (after thanksgiving) when that should be
>>> done, and start again then. Once I'm done, that will effectively be
>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>>> version control with Umlaut, since I was the only one using it, but
I
>>>
>
>
>>> see I'll have to start).
>>>
>>> But I don't want to discourage you from starting now either. I'm not
>>> sure what's going on. But from your path, I see that you have
checked
>>>
>
>
>>> out Umlaut kind of oddly. Can you give me the svn command you used
to
>>>
>
>
>>> checkout? I think you can use a better one that will make this
>>>
>>>
>> somewhat
>>
>>
>>> clearer and easier to debug.
>>>
>>> You are on Unix, not Windows, right? That particular error is what
>>>
>>>
>> you
>>
>>
>>> get when there's a syntax error in the source file. I may have
>>> accidentally included an error in the svn, which I wasn't worrying
>>>
> too
>
>>>
>>>
>>
>>
>>> much about not knowing anyone else was looking at it. You can try
>>>
> "svn
>
>>>
>>>
>>
>>
>>> up" to update your working copy to the latest svn, in case I have
>>>
>>>
>> since
>>
>>
>>> fixed it.
>>>
>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>
>>>
>> integration,
>>
>>
>>> we're going to have to do some custom coding for you, since I am
>>> confident you don't use Horizon like us. It would be great if you'd
>>> share a bit about what your motivation is for experimenting with
>>>
>>>
>> Umlaut,
>>
>>
>>> what you're interested in, what your plans are (if any beyond 'check
>>>
>>>
>> it
>>
>>
>>> out for now').
>>>
>>> Since nobody but me has been using Umlaut until now, there might be
>>>
>>>
>> some
>>
>>
>>> kinks in getting it up and running, but I am happy to spend my time
>>> ironing them out and helping you get up and running. I can call you
>>>
> on
>
>>>
>>>
>>
>>
>>> the phone at a later point if it looks like we could use some
>>> synchronous communication.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>
>>>
>>>> Good afternoon,
>>>>
>>>>
>>>>
>>>> We are just starting to get umlaut configured and running. The
>>>> installation went well but when we attempt to access the site we
get
>>>>
>>>>
>>>>
>>> the
>>>
>>>
>>>
>>>> error:
>>>>
>>>>
>>>>
>>>>
>>>> "LoadError in SearchController#index
>>>>
>>>>
>>>> Expected
/apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>>
>>>>
>>>>
>>> to
>>>
>>>
>>>
>>>> define SearchController
>>>>
>>>> "
>>>>
>>>>
>>>>
>>>> Any suggestions as to the cause or resolution to this issue?
>>>>
> Thanks.
>
>>>>
>>>>
>>>> --Dale
>>>>
>>>>
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>>
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>
------------------------------------------------------------------------
>
>>
>>
>>>
>>>
>>>
>>>> _______________________________________________
>>>> Umlaut-general mailing list
>>>> Umlaut-general at rubyforge.org
>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Mon Nov 24 15:41:56 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 15:41:56 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
<492B079E.8080005@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
<492B0ADD.4040300@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu>
Message-ID: <492B1194.6010108@jhu.edu>
How very very weird. Yes, it would be better to wait until tommorow,
when I should have the new version committed to trunk. Let's cross our
fingers and hope that that fixes it, otherwise it'll be mysterious.
I need to write configuration instructions for the new version too, but
the summary is that instead of adding lots of config in
umlaut_config/environment.rb, you will add it to several files inside of
umlaut_config/initializers/umlaut.
I hestitate to tell you this, since it sounds like you didn't already
realize it, but nobody else has an active installation of Umlaut except
for me at the moment, so far as I am aware. So the only "people" that
will install the newer version are you and me, right now. :) But I will
be upgrading my own live production copy to the newer version today or
tommorow, yeah.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> Bugs always happen. I do have the mysql gem v2.7 installed (see output
> below). Since you are almost done with moving to rails2, would it be
> better to wait a day or two and try the new version? I would assume
> that people will attempt to install the newer version.
>
> bash-3.00# gem list mysql
>
> *** LOCAL GEMS ***
>
> mysql (2.7)
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 2:13 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Aha. A bit of googling suggests you may have run into a bug in a version
>
> of the Rails MySQL adapters:
>
> http://jira.codehaus.org/browse/JRUBY-1543
>
> ( You aren't trying to use JRuby are you? I think you've just run into
> a bug that the JRuby folks happened to run into also, which isn't
> specific to JRuby ).
>
> I have installed the 'mysql' gem for my Umlaut, which I think my
> instructions say is 'optional', as theoretically Rails can connect to
> MySQL without it. But it may be advisable.
>
> Do you have the MySQL gem installed, and if so, what version? I have
> 2.7, it looks like.
>
> [jrochki1 at testbox U2]$ gem list mysql
> *** LOCAL GEMS ***
> mysql (2.7)
>
> It looks to me like 2.7 is indeed the latest version. If you don't have
> it, you can do:
> sudo gem install mysql
> or
> sudo gem update mysql
> to get the latest version.
>
> Sorry this isn't smoother than it is, that's how it goes sometimes, as
> more people adopt Umlaut we can hopefully get it smoothed out.
>
> If you DO have mysql gem 2.7 installed, then it's really going to be a
> mystery.
>
> Jonathan
>
>
> Poulter, Dale wrote:
>
>> We are running mysql version 5.0.51b
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 1:59 PM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hmm, very odd. You are using MySQL, right? What version of MySQL? It
>>
>
>
>> may be that 5.x is required, do you have 4.x instead?
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Jonathan,
>>>
>>> Regretfully, the problem persists after dropping and recreating the
>>> databases.
>>>
>>>
>>> .... == AddSomeMissingStuff: migrating
>>> =============================================
>>> -- add_index(:service_types, :service_type_value_id)
>>> -> 0.0757s
>>> -- change_column(:dispatched_services, :status, :string,
>>>
>>>
>> {:null=>false})
>>
>>
>>> -> 0.0777s
>>> -- rename_column(:dispatched_services, :exception, :exception_info)
>>> rake aborted!
>>> Mysql::Error: You have an error in your SQL syntax; check the manual
>>> that corresponds to your MySQL server version for the right syntax to
>>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>>
>>>
>> exception
>>
>>
>>> exception_info
>>>
>>> (See full trace by running task with --trace)
>>>
>>>
>>> FYI:
>>> mysql --version
>>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>>> EditLine wrapper
>>>
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 11:00 AM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>>
>>>
>> in
>>
>>
>>> and manually remove any tables in your MySQL in between your first
>>> installation attempt and your second? That you removed some things
>>>
>>>
>> but
>>
>>
>>> not all is the only explanation I can think of for the error you're
>>> seeing, which I can't duplicate. Maybe you removed all tables, but
>>> didn't remove any indexes, or something?
>>>
>>> You shouldn't actually need to re-execute ALL initial setup after an
>>> 'svn up', but you should in fact run "rake db:migrate" as you
>>>
> did--and
>
>>>
>>>
>>
>>
>>> ordinarily it shouldn't give you any error.
>>>
>>> I'd recommend dropping the entire database you are using (that you
>>>
> set
>
>>>
>>>
>>
>>
>>> in umlaut_config/databases.yml), recreating the entire database from
>>> scratch, and then re-running "rake db:migrate". That should take
>>>
> care
>
>>>
>>>
>>
>>
>>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>>
>>>
>> figure
>>
>>
>>> it out.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>
>>>
>>>> Jonathan,
>>>>
>>>> I have attempted the svn up and it did update a few files. I
>>>> re-execututed the initial setup and received the error below.
>>>>
>>>>
>>>> rake db:migrate
>>>> (in /apps/umlaut/Umlaut)
>>>> == AddSomeMissingStuff: migrating
>>>> =============================================
>>>> -- add_index(:service_types, :service_type_value_id)
>>>> rake aborted!
>>>> Mysql::Error: Duplicate key name
>>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>>> `index_service_types_on_service_type_value_id` ON service_types
>>>> (`service_type_value_id`)
>>>>
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>
>>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>>
>>>>
>>>>
>>> version,
>>>
>>>
>>>
>>>> and see if that takes care of it. It's possible you happened to
>>>>
> check
>
>>>>
>>>>
>>>>
>>> it
>>>
>>>
>>>
>>>> out before in a state where it contained a bug.
>>>>
>>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>>
>>>>
>>>>
>>> slightly
>>>
>>>
>>>
>>>> easier setup/install process, and in Rails 2.x.
>>>>
>>>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>>>> really focused on the domain of SFX, which includes a journal title
>>>>
>>>>
>>>>
>>> A-Z
>>>
>>>
>>>
>>>> list, but not neccesarily a database A-Z list. Although I suppose
>>>>
> it
>
>>>> could be expanded in that direction, I'm not sure if it would make
>>>>
>>>>
>>>>
>>> sense
>>>
>>>
>>>
>>>> or not.
>>>>
>>>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>>
>>>> We decided it made more sense to base a database A-Z off of Metalib,
>>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>>
>>>>
>> is
>>
>>
>>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>>> relationship to what librarians or users think of as a 'database').
>>>>
>>>>
>>>>
>>> But
>>>
>>>
>>>
>>>> we don't have Verde here, I'm not sure how that fits into it all
>>>>
>>>>
>>>>
>>> really.
>>>
>>>
>>>
>>>> I mean, I know what Verde is, I just don't understand how it fits
>>>>
>>>>
>> into
>>
>>
>>>> anything usefully. :)
>>>>
>>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>>
>>>>
>>>>
>>> and
>>>
>>>
>>>
>>>> also a service provider that can integrate known-item services in
>>>>
>>>>
>>>>
>>> other
>>>
>>>
>>>
>>>> software, like your OPAC. I am using Umlaut to provide various
>>>> interesting services right on my OPAC pages (not just a link to
>>>>
>>>>
>>>>
>>> Umlaut,
>>>
>>>
>>>
>>>> but the content right on the OPAC page).
>>>>
>>>> Jonathan
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>> Jonathan,
>>>>
>>>> We have had this on our back burner for a while and I finally
>>>>
> decided
>
>>>>
>>>>
>>>>
>>> it
>>>
>>>
>>>
>>>> was time to jump in and get started. Our hope is to use umlaut to
>>>> initially provide another interface to SFX and the A-Z list but
>>>>
>>>>
>>>>
>>> possibly
>>>
>>>
>>>
>>>> expand to use as a front end to our database A-Z list generated
>>>>
>>>>
>>>>
>>> through
>>>
>>>
>>>
>>>> Verde.
>>>>
>>>> To checkout the package I used:
>>>>
>>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>>
>>>>
>>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>>> SirsiDynix Symphony.
>>>>
>>>> I'll try to re-checkout the package again and continue to work on
>>>>
>>>>
>> this
>>
>>
>>>> but will be glad to test out anything you have ready. Thanks for
>>>>
>>>>
>> your
>>
>>
>>>> work.
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>
>>>> Hi Dale. So glad you are checking it out, happy to help.
>>>>
>>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>>
>>>>
>> also
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> improving some of the "getting started" helper scripts, so you might
>>>>
>
>
>>>> want to wait a week or two (after thanksgiving) when that should be
>>>> done, and start again then. Once I'm done, that will effectively be
>>>>
>
>
>>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>>>> version control with Umlaut, since I was the only one using it, but
>>>>
> I
>
>>>>
>>>>
>>
>>
>>>> see I'll have to start).
>>>>
>>>> But I don't want to discourage you from starting now either. I'm not
>>>>
>
>
>>>> sure what's going on. But from your path, I see that you have
>>>>
> checked
>
>>>>
>>>>
>>
>>
>>>> out Umlaut kind of oddly. Can you give me the svn command you used
>>>>
> to
>
>>>>
>>>>
>>
>>
>>>> checkout? I think you can use a better one that will make this
>>>>
>>>>
>>>>
>>> somewhat
>>>
>>>
>>>
>>>> clearer and easier to debug.
>>>>
>>>> You are on Unix, not Windows, right? That particular error is what
>>>>
>>>>
>>>>
>>> you
>>>
>>>
>>>
>>>> get when there's a syntax error in the source file. I may have
>>>> accidentally included an error in the svn, which I wasn't worrying
>>>>
>>>>
>> too
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> much about not knowing anyone else was looking at it. You can try
>>>>
>>>>
>> "svn
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> up" to update your working copy to the latest svn, in case I have
>>>>
>>>>
>>>>
>>> since
>>>
>>>
>>>
>>>> fixed it.
>>>>
>>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>>
>>>>
>>>>
>>> integration,
>>>
>>>
>>>
>>>> we're going to have to do some custom coding for you, since I am
>>>> confident you don't use Horizon like us. It would be great if you'd
>>>>
>
>
>>>> share a bit about what your motivation is for experimenting with
>>>>
>>>>
>>>>
>>> Umlaut,
>>>
>>>
>>>
>>>> what you're interested in, what your plans are (if any beyond 'check
>>>>
>>>>
>>>>
>>> it
>>>
>>>
>>>
>>>> out for now').
>>>>
>>>> Since nobody but me has been using Umlaut until now, there might be
>>>>
>>>>
>>>>
>>> some
>>>
>>>
>>>
>>>> kinks in getting it up and running, but I am happy to spend my time
>>>> ironing them out and helping you get up and running. I can call you
>>>>
>>>>
>> on
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> the phone at a later point if it looks like we could use some
>>>> synchronous communication.
>>>>
>>>> Jonathan
>>>>
>>>> Poulter, Dale wrote:
>>>>
>>>>
>>>>
>>>>
>>>>> Good afternoon,
>>>>>
>>>>>
>>>>>
>>>>> We are just starting to get umlaut configured and running. The
>>>>> installation went well but when we attempt to access the site we
>>>>>
> get
>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> the
>>>>
>>>>
>>>>
>>>>
>>>>> error:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "LoadError in SearchController#index
>>>>>
>>>>>
>>>>> Expected
>>>>>
> /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> to
>>>>
>>>>
>>>>
>>>>
>>>>> define SearchController
>>>>>
>>>>> "
>>>>>
>>>>>
>>>>>
>>>>> Any suggestions as to the cause or resolution to this issue?
>>>>>
>>>>>
>> Thanks.
>>
>>
>>>>>
>>>>>
>>>>> --Dale
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------
>>>>> Dale Poulter
>>>>> Automation Coordinator
>>>>>
>>>>> Library Information Technology Services
>>>>> Vanderbilt University
>>>>> Suite 700
>>>>> 110 21st Avenue South
>>>>> Nashville, TN 37240
>>>>> (615)343-5388
>>>>> (615)343-8834 (fax)
>>>>> (615)207-9705 (cell)
>>>>> dale.poulter at vanderbilt.edu
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
> ------------------------------------------------------------------------
>
>>
>>
>>>
>>>
>>>
>>>>
>>>>
>>>>
>>>>
>>>>> _______________________________________________
>>>>> Umlaut-general mailing list
>>>>> Umlaut-general at rubyforge.org
>>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Mon Nov 24 15:45:38 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Mon, 24 Nov 2008 14:45:38 -0600
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492B1194.6010108@jhu.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu><63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu><492ADD9A.30404@jhu.edu><63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu><492B079E.8080005@jhu.edu><63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu><492B0ADD.4040300@jhu.edu><63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu>
<492B1194.6010108@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF08169A21@mailbe17.email.Vanderbilt.edu>
Jonathan,
Sounds great, I'll look forward to doing a fresh install tomorrow.
Thanks for all of your work!
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Monday, November 24, 2008 2:42 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Error with initial configuration
How very very weird. Yes, it would be better to wait until tommorow,
when I should have the new version committed to trunk. Let's cross our
fingers and hope that that fixes it, otherwise it'll be mysterious.
I need to write configuration instructions for the new version too, but
the summary is that instead of adding lots of config in
umlaut_config/environment.rb, you will add it to several files inside of
umlaut_config/initializers/umlaut.
I hestitate to tell you this, since it sounds like you didn't already
realize it, but nobody else has an active installation of Umlaut except
for me at the moment, so far as I am aware. So the only "people" that
will install the newer version are you and me, right now. :) But I will
be upgrading my own live production copy to the newer version today or
tommorow, yeah.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> Bugs always happen. I do have the mysql gem v2.7 installed (see
output
> below). Since you are almost done with moving to rails2, would it be
> better to wait a day or two and try the new version? I would assume
> that people will attempt to install the newer version.
>
> bash-3.00# gem list mysql
>
> *** LOCAL GEMS ***
>
> mysql (2.7)
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 2:13 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Error with initial configuration
>
> Aha. A bit of googling suggests you may have run into a bug in a
version
>
> of the Rails MySQL adapters:
>
> http://jira.codehaus.org/browse/JRUBY-1543
>
> ( You aren't trying to use JRuby are you? I think you've just run
into
> a bug that the JRuby folks happened to run into also, which isn't
> specific to JRuby ).
>
> I have installed the 'mysql' gem for my Umlaut, which I think my
> instructions say is 'optional', as theoretically Rails can connect to
> MySQL without it. But it may be advisable.
>
> Do you have the MySQL gem installed, and if so, what version? I have
> 2.7, it looks like.
>
> [jrochki1 at testbox U2]$ gem list mysql
> *** LOCAL GEMS ***
> mysql (2.7)
>
> It looks to me like 2.7 is indeed the latest version. If you don't
have
> it, you can do:
> sudo gem install mysql
> or
> sudo gem update mysql
> to get the latest version.
>
> Sorry this isn't smoother than it is, that's how it goes sometimes, as
> more people adopt Umlaut we can hopefully get it smoothed out.
>
> If you DO have mysql gem 2.7 installed, then it's really going to be a
> mystery.
>
> Jonathan
>
>
> Poulter, Dale wrote:
>
>> We are running mysql version 5.0.51b
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 1:59 PM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Hmm, very odd. You are using MySQL, right? What version of MySQL?
It
>>
>
>
>> may be that 5.x is required, do you have 4.x instead?
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>
>>> Jonathan,
>>>
>>> Regretfully, the problem persists after dropping and recreating the
>>> databases.
>>>
>>>
>>> .... == AddSomeMissingStuff: migrating
>>> =============================================
>>> -- add_index(:service_types, :service_type_value_id)
>>> -> 0.0757s
>>> -- change_column(:dispatched_services, :status, :string,
>>>
>>>
>> {:null=>false})
>>
>>
>>> -> 0.0777s
>>> -- rename_column(:dispatched_services, :exception, :exception_info)
>>> rake aborted!
>>> Mysql::Error: You have an error in your SQL syntax; check the manual
>>> that corresponds to your MySQL server version for the right syntax
to
>>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>>
>>>
>> exception
>>
>>
>>> exception_info
>>>
>>> (See full trace by running task with --trace)
>>>
>>>
>>> FYI:
>>> mysql --version
>>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>>> EditLine wrapper
>>>
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 11:00 AM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>>
>>>
>> in
>>
>>
>>> and manually remove any tables in your MySQL in between your first
>>> installation attempt and your second? That you removed some things
>>>
>>>
>> but
>>
>>
>>> not all is the only explanation I can think of for the error you're
>>> seeing, which I can't duplicate. Maybe you removed all tables, but
>>> didn't remove any indexes, or something?
>>>
>>> You shouldn't actually need to re-execute ALL initial setup after an
>>> 'svn up', but you should in fact run "rake db:migrate" as you
>>>
> did--and
>
>>>
>>>
>>
>>
>>> ordinarily it shouldn't give you any error.
>>>
>>> I'd recommend dropping the entire database you are using (that you
>>>
> set
>
>>>
>>>
>>
>>
>>> in umlaut_config/databases.yml), recreating the entire database from
>>> scratch, and then re-running "rake db:migrate". That should take
>>>
> care
>
>>>
>>>
>>
>>
>>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>>
>>>
>> figure
>>
>>
>>> it out.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>
>>>
>>>> Jonathan,
>>>>
>>>> I have attempted the svn up and it did update a few files. I
>>>> re-execututed the initial setup and received the error below.
>>>>
>>>>
>>>> rake db:migrate
>>>> (in /apps/umlaut/Umlaut)
>>>> == AddSomeMissingStuff: migrating
>>>> =============================================
>>>> -- add_index(:service_types, :service_type_value_id)
>>>> rake aborted!
>>>> Mysql::Error: Duplicate key name
>>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>>> `index_service_types_on_service_type_value_id` ON service_types
>>>> (`service_type_value_id`)
>>>>
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>
>>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>>
>>>>
>>>>
>>> version,
>>>
>>>
>>>
>>>> and see if that takes care of it. It's possible you happened to
>>>>
> check
>
>>>>
>>>>
>>>>
>>> it
>>>
>>>
>>>
>>>> out before in a state where it contained a bug.
>>>>
>>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>>
>>>>
>>>>
>>> slightly
>>>
>>>
>>>
>>>> easier setup/install process, and in Rails 2.x.
>>>>
>>>> I'm not sure Umlaut is the right tool for a database A-Z list.
It's
>>>> really focused on the domain of SFX, which includes a journal title
>>>>
>>>>
>>>>
>>> A-Z
>>>
>>>
>>>
>>>> list, but not neccesarily a database A-Z list. Although I suppose
>>>>
> it
>
>>>> could be expanded in that direction, I'm not sure if it would make
>>>>
>>>>
>>>>
>>> sense
>>>
>>>
>>>
>>>> or not.
>>>>
>>>> Here, we're using Xerxes, the Metalib front-end, as our database
A-Z
>>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>>
>>>> We decided it made more sense to base a database A-Z off of
Metalib,
>>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>>
>>>>
>> is
>>
>>
>>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>>> relationship to what librarians or users think of as a 'database').
>>>>
>>>>
>>>>
>>> But
>>>
>>>
>>>
>>>> we don't have Verde here, I'm not sure how that fits into it all
>>>>
>>>>
>>>>
>>> really.
>>>
>>>
>>>
>>>> I mean, I know what Verde is, I just don't understand how it fits
>>>>
>>>>
>> into
>>
>>
>>>> anything usefully. :)
>>>>
>>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>>
>>>>
>>>>
>>> and
>>>
>>>
>>>
>>>> also a service provider that can integrate known-item services in
>>>>
>>>>
>>>>
>>> other
>>>
>>>
>>>
>>>> software, like your OPAC. I am using Umlaut to provide various
>>>> interesting services right on my OPAC pages (not just a link to
>>>>
>>>>
>>>>
>>> Umlaut,
>>>
>>>
>>>
>>>> but the content right on the OPAC page).
>>>>
>>>> Jonathan
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>> Jonathan,
>>>>
>>>> We have had this on our back burner for a while and I finally
>>>>
> decided
>
>>>>
>>>>
>>>>
>>> it
>>>
>>>
>>>
>>>> was time to jump in and get started. Our hope is to use umlaut to
>>>> initially provide another interface to SFX and the A-Z list but
>>>>
>>>>
>>>>
>>> possibly
>>>
>>>
>>>
>>>> expand to use as a front end to our database A-Z list generated
>>>>
>>>>
>>>>
>>> through
>>>
>>>
>>>
>>>> Verde.
>>>>
>>>> To checkout the package I used:
>>>>
>>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>>
>>>>
>>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>>> SirsiDynix Symphony.
>>>>
>>>> I'll try to re-checkout the package again and continue to work on
>>>>
>>>>
>> this
>>
>>
>>>> but will be glad to test out anything you have ready. Thanks for
>>>>
>>>>
>> your
>>
>>
>>>> work.
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>
>>>> Hi Dale. So glad you are checking it out, happy to help.
>>>>
>>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>>
>>>>
>> also
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> improving some of the "getting started" helper scripts, so you
might
>>>>
>
>
>>>> want to wait a week or two (after thanksgiving) when that should be
>>>> done, and start again then. Once I'm done, that will effectively
be
>>>>
>
>
>>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing much
>>>> version control with Umlaut, since I was the only one using it, but
>>>>
> I
>
>>>>
>>>>
>>
>>
>>>> see I'll have to start).
>>>>
>>>> But I don't want to discourage you from starting now either. I'm
not
>>>>
>
>
>>>> sure what's going on. But from your path, I see that you have
>>>>
> checked
>
>>>>
>>>>
>>
>>
>>>> out Umlaut kind of oddly. Can you give me the svn command you used
>>>>
> to
>
>>>>
>>>>
>>
>>
>>>> checkout? I think you can use a better one that will make this
>>>>
>>>>
>>>>
>>> somewhat
>>>
>>>
>>>
>>>> clearer and easier to debug.
>>>>
>>>> You are on Unix, not Windows, right? That particular error is what
>>>>
>>>>
>>>>
>>> you
>>>
>>>
>>>
>>>> get when there's a syntax error in the source file. I may have
>>>> accidentally included an error in the svn, which I wasn't worrying
>>>>
>>>>
>> too
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> much about not knowing anyone else was looking at it. You can try
>>>>
>>>>
>> "svn
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> up" to update your working copy to the latest svn, in case I have
>>>>
>>>>
>>>>
>>> since
>>>
>>>
>>>
>>>> fixed it.
>>>>
>>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>>
>>>>
>>>>
>>> integration,
>>>
>>>
>>>
>>>> we're going to have to do some custom coding for you, since I am
>>>> confident you don't use Horizon like us. It would be great if
you'd
>>>>
>
>
>>>> share a bit about what your motivation is for experimenting with
>>>>
>>>>
>>>>
>>> Umlaut,
>>>
>>>
>>>
>>>> what you're interested in, what your plans are (if any beyond
'check
>>>>
>>>>
>>>>
>>> it
>>>
>>>
>>>
>>>> out for now').
>>>>
>>>> Since nobody but me has been using Umlaut until now, there might be
>>>>
>>>>
>>>>
>>> some
>>>
>>>
>>>
>>>> kinks in getting it up and running, but I am happy to spend my time
>>>> ironing them out and helping you get up and running. I can call you
>>>>
>>>>
>> on
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>> the phone at a later point if it looks like we could use some
>>>> synchronous communication.
>>>>
>>>> Jonathan
>>>>
>>>> Poulter, Dale wrote:
>>>>
>>>>
>>>>
>>>>
>>>>> Good afternoon,
>>>>>
>>>>>
>>>>>
>>>>> We are just starting to get umlaut configured and running. The
>>>>> installation went well but when we attempt to access the site we
>>>>>
> get
>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> the
>>>>
>>>>
>>>>
>>>>
>>>>> error:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "LoadError in SearchController#index
>>>>>
>>>>>
>>>>> Expected
>>>>>
> /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> to
>>>>
>>>>
>>>>
>>>>
>>>>> define SearchController
>>>>>
>>>>> "
>>>>>
>>>>>
>>>>>
>>>>> Any suggestions as to the cause or resolution to this issue?
>>>>>
>>>>>
>> Thanks.
>>
>>
>>>>>
>>>>>
>>>>> --Dale
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------
>>>>> Dale Poulter
>>>>> Automation Coordinator
>>>>>
>>>>> Library Information Technology Services
>>>>> Vanderbilt University
>>>>> Suite 700
>>>>> 110 21st Avenue South
>>>>> Nashville, TN 37240
>>>>> (615)343-5388
>>>>> (615)343-8834 (fax)
>>>>> (615)207-9705 (cell)
>>>>> dale.poulter at vanderbilt.edu
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>
------------------------------------------------------------------------
>
>>
>>
>>>
>>>
>>>
>>>>
>>>>
>>>>
>>>>
>>>>> _______________________________________________
>>>>> Umlaut-general mailing list
>>>>> Umlaut-general at rubyforge.org
>>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From mneedlem at ufl.edu Mon Nov 24 16:42:42 2008
From: mneedlem at ufl.edu (Mark Needleman)
Date: Mon, 24 Nov 2008 16:42:42 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492B1194.6010108@jhu.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu> <63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu> <492ADD9A.30404@jhu.edu> <63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu> <492B079E.8080005@jhu.edu> <63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu> <492B0ADD.4040300@jhu.edu> <63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu>
<492B1194.6010108@jhu.edu>
Message-ID: <492B1FD2.1050106@ufl.edu>
dont forget me - im planning on installing the new version
mark
Jonathan Rochkind wrote:
> How very very weird. Yes, it would be better to wait until tommorow,
> when I should have the new version committed to trunk. Let's cross our
> fingers and hope that that fixes it, otherwise it'll be mysterious.
>
> I need to write configuration instructions for the new version too,
> but the summary is that instead of adding lots of config in
> umlaut_config/environment.rb, you will add it to several files inside
> of umlaut_config/initializers/umlaut.
>
> I hestitate to tell you this, since it sounds like you didn't already
> realize it, but nobody else has an active installation of Umlaut
> except for me at the moment, so far as I am aware. So the only
> "people" that will install the newer version are you and me, right
> now. :) But I will be upgrading my own live production copy to the
> newer version today or tommorow, yeah.
>
> Jonathan
>
> Poulter, Dale wrote:
>> Jonathan,
>>
>> Bugs always happen. I do have the mysql gem v2.7 installed (see output
>> below). Since you are almost done with moving to rails2, would it be
>> better to wait a day or two and try the new version? I would assume
>> that people will attempt to install the newer version.
>> bash-3.00# gem list mysql
>>
>> *** LOCAL GEMS ***
>>
>> mysql (2.7)
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 2:13 PM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Error with initial configuration
>>
>> Aha. A bit of googling suggests you may have run into a bug in a version
>>
>> of the Rails MySQL adapters:
>>
>> http://jira.codehaus.org/browse/JRUBY-1543
>>
>> ( You aren't trying to use JRuby are you? I think you've just run
>> into a bug that the JRuby folks happened to run into also, which
>> isn't specific to JRuby ).
>>
>> I have installed the 'mysql' gem for my Umlaut, which I think my
>> instructions say is 'optional', as theoretically Rails can connect to
>> MySQL without it. But it may be advisable.
>>
>> Do you have the MySQL gem installed, and if so, what version? I have
>> 2.7, it looks like.
>>
>> [jrochki1 at testbox U2]$ gem list mysql
>> *** LOCAL GEMS ***
>> mysql (2.7)
>>
>> It looks to me like 2.7 is indeed the latest version. If you don't
>> have it, you can do:
>> sudo gem install mysql
>> or
>> sudo gem update mysql
>> to get the latest version.
>>
>> Sorry this isn't smoother than it is, that's how it goes sometimes,
>> as more people adopt Umlaut we can hopefully get it smoothed out.
>>
>> If you DO have mysql gem 2.7 installed, then it's really going to be
>> a mystery.
>>
>> Jonathan
>>
>>
>> Poulter, Dale wrote:
>>
>>> We are running mysql version 5.0.51b
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 1:59 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Hmm, very odd. You are using MySQL, right? What version of MySQL? It
>>>
>>
>>
>>> may be that 5.x is required, do you have 4.x instead?
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>> Jonathan,
>>>>
>>>> Regretfully, the problem persists after dropping and recreating the
>>>> databases.
>>>>
>>>>
>>>> .... == AddSomeMissingStuff: migrating
>>>> =============================================
>>>> -- add_index(:service_types, :service_type_value_id)
>>>> -> 0.0757s
>>>> -- change_column(:dispatched_services, :status, :string,
>>>>
>>> {:null=>false})
>>>
>>>> -> 0.0777s
>>>> -- rename_column(:dispatched_services, :exception, :exception_info)
>>>> rake aborted!
>>>> Mysql::Error: You have an error in your SQL syntax; check the manual
>>>> that corresponds to your MySQL server version for the right syntax to
>>>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>>>
>>> exception
>>>
>>>> exception_info
>>>> (See full trace by running task with --trace)
>>>>
>>>>
>>>> FYI:
>>>> mysql --version
>>>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>>>> EditLine wrapper
>>>>
>>>>
>>>> --Dale
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Monday, November 24, 2008 11:00 AM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>
>>>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>>>
>>> in
>>>> and manually remove any tables in your MySQL in between your first
>>>> installation attempt and your second? That you removed some things
>>>>
>>> but
>>>> not all is the only explanation I can think of for the error you're
>>>> seeing, which I can't duplicate. Maybe you removed all tables, but
>>>> didn't remove any indexes, or something?
>>>> You shouldn't actually need to re-execute ALL initial setup after
>>>> an 'svn up', but you should in fact run "rake db:migrate" as you
>>>>
>> did--and
>>
>>>>
>>>
>>>> ordinarily it shouldn't give you any error.
>>>>
>>>> I'd recommend dropping the entire database you are using (that you
>>>>
>> set
>>
>>>>
>>>
>>>> in umlaut_config/databases.yml), recreating the entire database
>>>> from scratch, and then re-running "rake db:migrate". That should take
>>>>
>> care
>>
>>>>
>>>
>>>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>>>
>>> figure
>>>> it out.
>>>>
>>>> Jonathan
>>>>
>>>> Poulter, Dale wrote:
>>>>
>>>>> Jonathan,
>>>>>
>>>>> I have attempted the svn up and it did update a few files. I
>>>>> re-execututed the initial setup and received the error below.
>>>>>
>>>>> rake db:migrate (in /apps/umlaut/Umlaut)
>>>>> == AddSomeMissingStuff: migrating
>>>>> =============================================
>>>>> -- add_index(:service_types, :service_type_value_id)
>>>>> rake aborted!
>>>>> Mysql::Error: Duplicate key name
>>>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>>>> `index_service_types_on_service_type_value_id` ON service_types
>>>>> (`service_type_value_id`)
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -----Original Message-----
>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>> Rochkind
>>>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>>>> To: umlaut-general at rubyforge.org
>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>
>>>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>>>
>>>> version,
>>>>
>>>>> and see if that takes care of it. It's possible you happened to
>>>>>
>> check
>>
>>>>>
>>>> it
>>>>
>>>>> out before in a state where it contained a bug.
>>>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>>>
>>>> slightly
>>>>
>>>>> easier setup/install process, and in Rails 2.x.
>>>>> I'm not sure Umlaut is the right tool for a database A-Z list. It's
>>>>> really focused on the domain of SFX, which includes a journal title
>>>>>
>>>> A-Z
>>>>
>>>>> list, but not neccesarily a database A-Z list. Although I suppose
>>>>>
>> it
>>
>>>>> could be expanded in that direction, I'm not sure if it would make
>>>>>
>>>> sense
>>>>
>>>>> or not.
>>>>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>>>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>>>
>>>>> We decided it made more sense to base a database A-Z off of Metalib,
>>>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>>>
>>> is
>>>
>>>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>>>> relationship to what librarians or users think of as a 'database').
>>>>>
>>>> But
>>>>
>>>>> we don't have Verde here, I'm not sure how that fits into it all
>>>>>
>>>> really.
>>>>
>>>>> I mean, I know what Verde is, I just don't understand how it fits
>>>>>
>>> into
>>>
>>>>> anything usefully. :)
>>>>>
>>>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>>>
>>>> and
>>>>
>>>>> also a service provider that can integrate known-item services in
>>>>>
>>>> other
>>>>
>>>>> software, like your OPAC. I am using Umlaut to provide various
>>>>> interesting services right on my OPAC pages (not just a link to
>>>>>
>>>> Umlaut,
>>>>
>>>>> but the content right on the OPAC page).
>>>>> Jonathan
>>>>>
>>>>>
>>>>>
>>>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>>>
>>>>> Jonathan,
>>>>>
>>>>> We have had this on our back burner for a while and I finally
>>>>>
>> decided
>>
>>>>>
>>>> it
>>>>
>>>>> was time to jump in and get started. Our hope is to use umlaut to
>>>>> initially provide another interface to SFX and the A-Z list but
>>>>>
>>>> possibly
>>>>
>>>>> expand to use as a front end to our database A-Z list generated
>>>>>
>>>> through
>>>>
>>>>> Verde.
>>>>>
>>>>> To checkout the package I used:
>>>>>
>>>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>>>
>>>>>
>>>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>>>> SirsiDynix Symphony.
>>>>> I'll try to re-checkout the package again and continue to work on
>>>>>
>>> this
>>>
>>>>> but will be glad to test out anything you have ready. Thanks for
>>>>>
>>> your
>>>
>>>>> work.
>>>>>
>>>>>
>>>>>
>>>>> -----Original Message-----
>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>> Rochkind
>>>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>>>> To: umlaut-general at rubyforge.org
>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>
>>>>> Hi Dale. So glad you are checking it out, happy to help.
>>>>>
>>>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>>>
>>> also
>>>
>>>>>
>>>>
>>>>> improving some of the "getting started" helper scripts, so you might
>>>>>
>>
>>
>>>>> want to wait a week or two (after thanksgiving) when that should
>>>>> be done, and start again then. Once I'm done, that will
>>>>> effectively be
>>>>>
>>
>>
>>>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing
>>>>> much version control with Umlaut, since I was the only one using
>>>>> it, but
>>>>>
>> I
>>
>>>>>
>>>
>>>>> see I'll have to start).
>>>>>
>>>>> But I don't want to discourage you from starting now either. I'm not
>>>>>
>>
>>
>>>>> sure what's going on. But from your path, I see that you have
>>>>>
>> checked
>>
>>>>>
>>>
>>>>> out Umlaut kind of oddly. Can you give me the svn command you used
>>>>>
>> to
>>
>>>>>
>>>
>>>>> checkout? I think you can use a better one that will make this
>>>>>
>>>> somewhat
>>>>
>>>>> clearer and easier to debug.
>>>>>
>>>>> You are on Unix, not Windows, right? That particular error is what
>>>>>
>>>> you
>>>>> get when there's a syntax error in the source file. I may have
>>>>> accidentally included an error in the svn, which I wasn't worrying
>>>>>
>>> too
>>>
>>>>>
>>>>
>>>>> much about not knowing anyone else was looking at it. You can try
>>>>>
>>> "svn
>>>
>>>>>
>>>>
>>>>> up" to update your working copy to the latest svn, in case I have
>>>>>
>>>> since
>>>>> fixed it.
>>>>>
>>>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>>>
>>>> integration,
>>>>> we're going to have to do some custom coding for you, since I am
>>>>> confident you don't use Horizon like us. It would be great if you'd
>>>>>
>>
>>
>>>>> share a bit about what your motivation is for experimenting with
>>>>>
>>>> Umlaut,
>>>>
>>>>> what you're interested in, what your plans are (if any beyond 'check
>>>>>
>>>> it
>>>>> out for now').
>>>>>
>>>>> Since nobody but me has been using Umlaut until now, there might be
>>>>>
>>>> some
>>>>
>>>>> kinks in getting it up and running, but I am happy to spend my
>>>>> time ironing them out and helping you get up and running. I can
>>>>> call you
>>>>>
>>> on
>>>
>>>>>
>>>>
>>>>> the phone at a later point if it looks like we could use some
>>>>> synchronous communication.
>>>>>
>>>>> Jonathan
>>>>>
>>>>> Poulter, Dale wrote:
>>>>>
>>>>>> Good afternoon,
>>>>>>
>>>>>>
>>>>>>
>>>>>> We are just starting to get umlaut configured and running. The
>>>>>> installation went well but when we attempt to access the site we
>>>>>>
>> get
>>
>>>>>>
>>>>> the
>>>>>
>>>>>> error:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> "LoadError in SearchController#index
>>>>>>
>>>>>> Expected
>>>>>>
>> /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>
>>>>>>
>>>>> to
>>>>>
>>>>>> define SearchController
>>>>>>
>>>>>> "
>>>>>>
>>>>>>
>>>>>>
>>>>>> Any suggestions as to the cause or resolution to this issue?
>>>>>>
>>> Thanks.
>>>
>>>>>>
>>>>>>
>>>>>> --Dale
>>>>>>
>>>>>>
>>>>>>
>>>>>> ---------------------------------------
>>>>>> Dale Poulter
>>>>>> Automation Coordinator
>>>>>>
>>>>>> Library Information Technology Services
>>>>>> Vanderbilt University
>>>>>> Suite 700
>>>>>> 110 21st Avenue South
>>>>>> Nashville, TN 37240
>>>>>> (615)343-5388
>>>>>> (615)343-8834 (fax)
>>>>>> (615)207-9705 (cell)
>>>>>> dale.poulter at vanderbilt.edu
>>>>>>
>>>>>>
>>>>>>
>> ------------------------------------------------------------------------
>>
>>>
>>>>
>>>>>
>>>>>> _______________________________________________
>>>>>> Umlaut-general mailing list
>>>>>> Umlaut-general at rubyforge.org
>>>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>>>
>>>>>
>>>>
>>>
>>
>>
>
From rochkind at jhu.edu Mon Nov 24 17:16:56 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 17:16:56 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492B1FD2.1050106@ufl.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
<492B079E.8080005@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
<492B0ADD.4040300@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu>
<492B1194.6010108@jhu.edu> <492B1FD2.1050106@ufl.edu>
Message-ID: <492B27D8.6090701@jhu.edu>
Excellent.
The new release of Umlaut will require rails 2.1.2, so if you're all
looking for something to do while waiting for it, you can go ahead and
install that.
(A future version will use Rails 2.2.2, which should actually be helpful
as we use threads in Umlaut, which Rails 2.2.2 for the first time is
actually _designed_ to support with better performance than the hacks we
are using. But for now, since we do use threads and the threading model
has changed in Rails, I'm staying at 2.1.2 until I can spend more time
with it.)
Jonathan
Mark Needleman wrote:
> dont forget me - im planning on installing the new version
>
> mark
>
> Jonathan Rochkind wrote:
>> How very very weird. Yes, it would be better to wait until tommorow,
>> when I should have the new version committed to trunk. Let's cross
>> our fingers and hope that that fixes it, otherwise it'll be mysterious.
>>
>> I need to write configuration instructions for the new version too,
>> but the summary is that instead of adding lots of config in
>> umlaut_config/environment.rb, you will add it to several files inside
>> of umlaut_config/initializers/umlaut.
>>
>> I hestitate to tell you this, since it sounds like you didn't already
>> realize it, but nobody else has an active installation of Umlaut
>> except for me at the moment, so far as I am aware. So the only
>> "people" that will install the newer version are you and me, right
>> now. :) But I will be upgrading my own live production copy to the
>> newer version today or tommorow, yeah.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>> Jonathan,
>>>
>>> Bugs always happen. I do have the mysql gem v2.7 installed (see output
>>> below). Since you are almost done with moving to rails2, would it be
>>> better to wait a day or two and try the new version? I would assume
>>> that people will attempt to install the newer version. bash-3.00#
>>> gem list mysql
>>>
>>> *** LOCAL GEMS ***
>>>
>>> mysql (2.7)
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 2:13 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>
>>> Aha. A bit of googling suggests you may have run into a bug in a
>>> version
>>>
>>> of the Rails MySQL adapters:
>>>
>>> http://jira.codehaus.org/browse/JRUBY-1543
>>>
>>> ( You aren't trying to use JRuby are you? I think you've just run
>>> into a bug that the JRuby folks happened to run into also, which
>>> isn't specific to JRuby ).
>>>
>>> I have installed the 'mysql' gem for my Umlaut, which I think my
>>> instructions say is 'optional', as theoretically Rails can connect
>>> to MySQL without it. But it may be advisable.
>>>
>>> Do you have the MySQL gem installed, and if so, what version? I have
>>> 2.7, it looks like.
>>>
>>> [jrochki1 at testbox U2]$ gem list mysql
>>> *** LOCAL GEMS ***
>>> mysql (2.7)
>>>
>>> It looks to me like 2.7 is indeed the latest version. If you don't
>>> have it, you can do:
>>> sudo gem install mysql
>>> or
>>> sudo gem update mysql
>>> to get the latest version.
>>>
>>> Sorry this isn't smoother than it is, that's how it goes sometimes,
>>> as more people adopt Umlaut we can hopefully get it smoothed out.
>>>
>>> If you DO have mysql gem 2.7 installed, then it's really going to be
>>> a mystery.
>>>
>>> Jonathan
>>>
>>>
>>> Poulter, Dale wrote:
>>>
>>>> We are running mysql version 5.0.51b
>>>>
>>>> --Dale
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Monday, November 24, 2008 1:59 PM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>
>>>> Hmm, very odd. You are using MySQL, right? What version of MySQL? It
>>>>
>>>
>>>
>>>> may be that 5.x is required, do you have 4.x instead?
>>>> Jonathan
>>>>
>>>> Poulter, Dale wrote:
>>>>
>>>>> Jonathan,
>>>>>
>>>>> Regretfully, the problem persists after dropping and recreating the
>>>>> databases.
>>>>>
>>>>>
>>>>> .... == AddSomeMissingStuff: migrating
>>>>> =============================================
>>>>> -- add_index(:service_types, :service_type_value_id)
>>>>> -> 0.0757s
>>>>> -- change_column(:dispatched_services, :status, :string,
>>>>>
>>>> {:null=>false})
>>>>
>>>>> -> 0.0777s
>>>>> -- rename_column(:dispatched_services, :exception, :exception_info)
>>>>> rake aborted!
>>>>> Mysql::Error: You have an error in your SQL syntax; check the manual
>>>>> that corresponds to your MySQL server version for the right syntax to
>>>>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>>>>
>>>> exception
>>>>
>>>>> exception_info
>>>>> (See full trace by running task with --trace)
>>>>>
>>>>>
>>>>> FYI:
>>>>> mysql --version
>>>>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>>>>> EditLine wrapper
>>>>>
>>>>>
>>>>> --Dale
>>>>>
>>>>> ---------------------------------------
>>>>> Dale Poulter
>>>>> Automation Coordinator
>>>>> Library Information Technology Services
>>>>> Vanderbilt University
>>>>> Suite 700
>>>>> 110 21st Avenue South
>>>>> Nashville, TN 37240
>>>>> (615)343-5388
>>>>> (615)343-8834 (fax)
>>>>> (615)207-9705 (cell)
>>>>> dale.poulter at vanderbilt.edu
>>>>>
>>>>> -----Original Message-----
>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>> Rochkind
>>>>> Sent: Monday, November 24, 2008 11:00 AM
>>>>> To: umlaut-general at rubyforge.org
>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>
>>>>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>>>>
>>>> in
>>>>> and manually remove any tables in your MySQL in between your first
>>>>> installation attempt and your second? That you removed some things
>>>>>
>>>> but
>>>>> not all is the only explanation I can think of for the error
>>>>> you're seeing, which I can't duplicate. Maybe you removed all
>>>>> tables, but didn't remove any indexes, or something?
>>>>> You shouldn't actually need to re-execute ALL initial setup after
>>>>> an 'svn up', but you should in fact run "rake db:migrate" as you
>>>>>
>>> did--and
>>>
>>>>>
>>>>
>>>>> ordinarily it shouldn't give you any error.
>>>>>
>>>>> I'd recommend dropping the entire database you are using (that you
>>>>>
>>> set
>>>
>>>>>
>>>>
>>>>> in umlaut_config/databases.yml), recreating the entire database
>>>>> from scratch, and then re-running "rake db:migrate". That should
>>>>> take
>>>>>
>>> care
>>>
>>>>>
>>>>
>>>>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>>>>
>>>> figure
>>>>> it out.
>>>>>
>>>>> Jonathan
>>>>>
>>>>> Poulter, Dale wrote:
>>>>>
>>>>>> Jonathan,
>>>>>>
>>>>>> I have attempted the svn up and it did update a few files. I
>>>>>> re-execututed the initial setup and received the error below.
>>>>>>
>>>>>> rake db:migrate (in /apps/umlaut/Umlaut)
>>>>>> == AddSomeMissingStuff: migrating
>>>>>> =============================================
>>>>>> -- add_index(:service_types, :service_type_value_id)
>>>>>> rake aborted!
>>>>>> Mysql::Error: Duplicate key name
>>>>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>>>>> `index_service_types_on_service_type_value_id` ON service_types
>>>>>> (`service_type_value_id`)
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>>> Rochkind
>>>>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>>>>> To: umlaut-general at rubyforge.org
>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>
>>>>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>>>>
>>>>> version,
>>>>>
>>>>>> and see if that takes care of it. It's possible you happened to
>>>>>>
>>> check
>>>
>>>>>>
>>>>> it
>>>>>
>>>>>> out before in a state where it contained a bug.
>>>>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>>>>
>>>>> slightly
>>>>>
>>>>>> easier setup/install process, and in Rails 2.x. I'm not sure
>>>>>> Umlaut is the right tool for a database A-Z list. It's
>>>>>> really focused on the domain of SFX, which includes a journal title
>>>>>>
>>>>> A-Z
>>>>>
>>>>>> list, but not neccesarily a database A-Z list. Although I suppose
>>>>>>
>>> it
>>>
>>>>>> could be expanded in that direction, I'm not sure if it would make
>>>>>>
>>>>> sense
>>>>>
>>>>>> or not.
>>>>>> Here, we're using Xerxes, the Metalib front-end, as our database A-Z
>>>>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>>>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>>>>
>>>>>> We decided it made more sense to base a database A-Z off of Metalib,
>>>>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>>>>
>>>> is
>>>>
>>>>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>>>>> relationship to what librarians or users think of as a 'database').
>>>>>>
>>>>> But
>>>>>
>>>>>> we don't have Verde here, I'm not sure how that fits into it all
>>>>>>
>>>>> really.
>>>>>
>>>>>> I mean, I know what Verde is, I just don't understand how it fits
>>>>>>
>>>> into
>>>>
>>>>>> anything usefully. :)
>>>>>>
>>>>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>>>>
>>>>> and
>>>>>
>>>>>> also a service provider that can integrate known-item services in
>>>>>>
>>>>> other
>>>>>
>>>>>> software, like your OPAC. I am using Umlaut to provide various
>>>>>> interesting services right on my OPAC pages (not just a link to
>>>>>>
>>>>> Umlaut,
>>>>>
>>>>>> but the content right on the OPAC page).
>>>>>> Jonathan
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>>>>
>>>>>> Jonathan,
>>>>>>
>>>>>> We have had this on our back burner for a while and I finally
>>>>>>
>>> decided
>>>
>>>>>>
>>>>> it
>>>>>
>>>>>> was time to jump in and get started. Our hope is to use umlaut to
>>>>>> initially provide another interface to SFX and the A-Z list but
>>>>>>
>>>>> possibly
>>>>>
>>>>>> expand to use as a front end to our database A-Z list generated
>>>>>>
>>>>> through
>>>>>
>>>>>> Verde.
>>>>>>
>>>>>> To checkout the package I used:
>>>>>>
>>>>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>>>>
>>>>>>
>>>>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>>>>> SirsiDynix Symphony.
>>>>>> I'll try to re-checkout the package again and continue to work on
>>>>>>
>>>> this
>>>>
>>>>>> but will be glad to test out anything you have ready. Thanks for
>>>>>>
>>>> your
>>>>
>>>>>> work.
>>>>>>
>>>>>>
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>>> Rochkind
>>>>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>>>>> To: umlaut-general at rubyforge.org
>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>
>>>>>> Hi Dale. So glad you are checking it out, happy to help.
>>>>>>
>>>>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>>>>
>>>> also
>>>>
>>>>>>
>>>>>
>>>>>> improving some of the "getting started" helper scripts, so you might
>>>>>>
>>>
>>>
>>>>>> want to wait a week or two (after thanksgiving) when that should
>>>>>> be done, and start again then. Once I'm done, that will
>>>>>> effectively be
>>>>>>
>>>
>>>
>>>>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing
>>>>>> much version control with Umlaut, since I was the only one using
>>>>>> it, but
>>>>>>
>>> I
>>>
>>>>>>
>>>>
>>>>>> see I'll have to start).
>>>>>>
>>>>>> But I don't want to discourage you from starting now either. I'm not
>>>>>>
>>>
>>>
>>>>>> sure what's going on. But from your path, I see that you have
>>>>>>
>>> checked
>>>
>>>>>>
>>>>
>>>>>> out Umlaut kind of oddly. Can you give me the svn command you used
>>>>>>
>>> to
>>>
>>>>>>
>>>>
>>>>>> checkout? I think you can use a better one that will make this
>>>>>>
>>>>> somewhat
>>>>>
>>>>>> clearer and easier to debug.
>>>>>>
>>>>>> You are on Unix, not Windows, right? That particular error is what
>>>>>>
>>>>> you
>>>>>> get when there's a syntax error in the source file. I may have
>>>>>> accidentally included an error in the svn, which I wasn't worrying
>>>>>>
>>>> too
>>>>
>>>>>>
>>>>>
>>>>>> much about not knowing anyone else was looking at it. You can try
>>>>>>
>>>> "svn
>>>>
>>>>>>
>>>>>
>>>>>> up" to update your working copy to the latest svn, in case I have
>>>>>>
>>>>> since
>>>>>> fixed it.
>>>>>>
>>>>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>>>>
>>>>> integration,
>>>>>> we're going to have to do some custom coding for you, since I am
>>>>>> confident you don't use Horizon like us. It would be great if you'd
>>>>>>
>>>
>>>
>>>>>> share a bit about what your motivation is for experimenting with
>>>>>>
>>>>> Umlaut,
>>>>>
>>>>>> what you're interested in, what your plans are (if any beyond 'check
>>>>>>
>>>>> it
>>>>>> out for now').
>>>>>>
>>>>>> Since nobody but me has been using Umlaut until now, there might be
>>>>>>
>>>>> some
>>>>>
>>>>>> kinks in getting it up and running, but I am happy to spend my
>>>>>> time ironing them out and helping you get up and running. I can
>>>>>> call you
>>>>>>
>>>> on
>>>>
>>>>>>
>>>>>
>>>>>> the phone at a later point if it looks like we could use some
>>>>>> synchronous communication.
>>>>>>
>>>>>> Jonathan
>>>>>>
>>>>>> Poulter, Dale wrote:
>>>>>>
>>>>>>> Good afternoon,
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> We are just starting to get umlaut configured and running. The
>>>>>>> installation went well but when we attempt to access the site we
>>>>>>>
>>> get
>>>
>>>>>>>
>>>>>> the
>>>>>>
>>>>>>> error:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> "LoadError in SearchController#index
>>>>>>>
>>>>>>> Expected
>>>>>>>
>>> /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>
>>>>>>>
>>>>>> to
>>>>>>
>>>>>>> define SearchController
>>>>>>>
>>>>>>> "
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Any suggestions as to the cause or resolution to this issue?
>>>>>>>
>>>> Thanks.
>>>>
>>>>>>>
>>>>>>>
>>>>>>> --Dale
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> ---------------------------------------
>>>>>>> Dale Poulter
>>>>>>> Automation Coordinator
>>>>>>>
>>>>>>> Library Information Technology Services
>>>>>>> Vanderbilt University
>>>>>>> Suite 700
>>>>>>> 110 21st Avenue South
>>>>>>> Nashville, TN 37240
>>>>>>> (615)343-5388
>>>>>>> (615)343-8834 (fax)
>>>>>>> (615)207-9705 (cell)
>>>>>>> dale.poulter at vanderbilt.edu
>>>>>>>
>>>>>>>
>>>>>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>>>
>>>>>
>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Umlaut-general mailing list
>>>>>>> Umlaut-general at rubyforge.org
>>>>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
> _______________________________________________
> Umlaut-general mailing list
> Umlaut-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/umlaut-general
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From mneedlem at ufl.edu Mon Nov 24 17:24:09 2008
From: mneedlem at ufl.edu (Mark Needleman)
Date: Mon, 24 Nov 2008 17:24:09 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492B27D8.6090701@jhu.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu> <63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu> <492ADD9A.30404@jhu.edu> <63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu> <492B079E.8080005@jhu.edu> <63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu> <492B0ADD.4040300@jhu.edu> <63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu> <492B1194.6010108@jhu.edu>
<492B1FD2.1050106@ufl.edu> <492B27D8.6090701@jhu.edu>
Message-ID: <492B2989.5010200@ufl.edu>
actually our sysadminds do all of that - i put in a request today for
them to install all of the things on our installation notes
mark
Jonathan Rochkind wrote:
> Excellent.
>
> The new release of Umlaut will require rails 2.1.2, so if you're all
> looking for something to do while waiting for it, you can go ahead and
> install that.
>
> (A future version will use Rails 2.2.2, which should actually be
> helpful as we use threads in Umlaut, which Rails 2.2.2 for the first
> time is actually _designed_ to support with better performance than
> the hacks we are using. But for now, since we do use threads and the
> threading model has changed in Rails, I'm staying at 2.1.2 until I can
> spend more time with it.)
>
> Jonathan
>
> Mark Needleman wrote:
>> dont forget me - im planning on installing the new version
>>
>> mark
>>
>> Jonathan Rochkind wrote:
>>> How very very weird. Yes, it would be better to wait until tommorow,
>>> when I should have the new version committed to trunk. Let's cross
>>> our fingers and hope that that fixes it, otherwise it'll be mysterious.
>>>
>>> I need to write configuration instructions for the new version too,
>>> but the summary is that instead of adding lots of config in
>>> umlaut_config/environment.rb, you will add it to several files
>>> inside of umlaut_config/initializers/umlaut.
>>>
>>> I hestitate to tell you this, since it sounds like you didn't
>>> already realize it, but nobody else has an active installation of
>>> Umlaut except for me at the moment, so far as I am aware. So the
>>> only "people" that will install the newer version are you and me,
>>> right now. :) But I will be upgrading my own live production copy
>>> to the newer version today or tommorow, yeah.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>> Jonathan,
>>>>
>>>> Bugs always happen. I do have the mysql gem v2.7 installed (see
>>>> output
>>>> below). Since you are almost done with moving to rails2, would it be
>>>> better to wait a day or two and try the new version? I would assume
>>>> that people will attempt to install the newer version. bash-3.00#
>>>> gem list mysql
>>>>
>>>> *** LOCAL GEMS ***
>>>>
>>>> mysql (2.7)
>>>>
>>>> --Dale
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Monday, November 24, 2008 2:13 PM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>
>>>> Aha. A bit of googling suggests you may have run into a bug in a
>>>> version
>>>>
>>>> of the Rails MySQL adapters:
>>>>
>>>> http://jira.codehaus.org/browse/JRUBY-1543
>>>>
>>>> ( You aren't trying to use JRuby are you? I think you've just run
>>>> into a bug that the JRuby folks happened to run into also, which
>>>> isn't specific to JRuby ).
>>>>
>>>> I have installed the 'mysql' gem for my Umlaut, which I think my
>>>> instructions say is 'optional', as theoretically Rails can connect
>>>> to MySQL without it. But it may be advisable.
>>>>
>>>> Do you have the MySQL gem installed, and if so, what version? I
>>>> have 2.7, it looks like.
>>>>
>>>> [jrochki1 at testbox U2]$ gem list mysql
>>>> *** LOCAL GEMS ***
>>>> mysql (2.7)
>>>>
>>>> It looks to me like 2.7 is indeed the latest version. If you don't
>>>> have it, you can do:
>>>> sudo gem install mysql
>>>> or
>>>> sudo gem update mysql
>>>> to get the latest version.
>>>>
>>>> Sorry this isn't smoother than it is, that's how it goes sometimes,
>>>> as more people adopt Umlaut we can hopefully get it smoothed out.
>>>>
>>>> If you DO have mysql gem 2.7 installed, then it's really going to
>>>> be a mystery.
>>>>
>>>> Jonathan
>>>>
>>>>
>>>> Poulter, Dale wrote:
>>>>
>>>>> We are running mysql version 5.0.51b
>>>>>
>>>>> --Dale
>>>>>
>>>>> ---------------------------------------
>>>>> Dale Poulter
>>>>> Automation Coordinator
>>>>> Library Information Technology Services
>>>>> Vanderbilt University
>>>>> Suite 700
>>>>> 110 21st Avenue South
>>>>> Nashville, TN 37240
>>>>> (615)343-5388
>>>>> (615)343-8834 (fax)
>>>>> (615)207-9705 (cell)
>>>>> dale.poulter at vanderbilt.edu
>>>>>
>>>>> -----Original Message-----
>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>> Rochkind
>>>>> Sent: Monday, November 24, 2008 1:59 PM
>>>>> To: umlaut-general at rubyforge.org
>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>
>>>>> Hmm, very odd. You are using MySQL, right? What version of
>>>>> MySQL? It
>>>>>
>>>>
>>>>
>>>>> may be that 5.x is required, do you have 4.x instead?
>>>>> Jonathan
>>>>>
>>>>> Poulter, Dale wrote:
>>>>>
>>>>>> Jonathan,
>>>>>>
>>>>>> Regretfully, the problem persists after dropping and recreating the
>>>>>> databases.
>>>>>>
>>>>>>
>>>>>> .... == AddSomeMissingStuff: migrating
>>>>>> =============================================
>>>>>> -- add_index(:service_types, :service_type_value_id)
>>>>>> -> 0.0757s
>>>>>> -- change_column(:dispatched_services, :status, :string,
>>>>>>
>>>>> {:null=>false})
>>>>>
>>>>>> -> 0.0777s
>>>>>> -- rename_column(:dispatched_services, :exception, :exception_info)
>>>>>> rake aborted!
>>>>>> Mysql::Error: You have an error in your SQL syntax; check the manual
>>>>>> that corresponds to your MySQL server version for the right
>>>>>> syntax to
>>>>>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>>>>>
>>>>> exception
>>>>>
>>>>>> exception_info
>>>>>> (See full trace by running task with --trace)
>>>>>>
>>>>>>
>>>>>> FYI:
>>>>>> mysql --version
>>>>>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>>>>>> EditLine wrapper
>>>>>>
>>>>>>
>>>>>> --Dale
>>>>>>
>>>>>> ---------------------------------------
>>>>>> Dale Poulter
>>>>>> Automation Coordinator
>>>>>> Library Information Technology Services
>>>>>> Vanderbilt University
>>>>>> Suite 700
>>>>>> 110 21st Avenue South
>>>>>> Nashville, TN 37240
>>>>>> (615)343-5388
>>>>>> (615)343-8834 (fax)
>>>>>> (615)207-9705 (cell)
>>>>>> dale.poulter at vanderbilt.edu
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>>> Rochkind
>>>>>> Sent: Monday, November 24, 2008 11:00 AM
>>>>>> To: umlaut-general at rubyforge.org
>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>
>>>>>> Hmm, this is still kind of mysterious to me, Dale. Did you try to go
>>>>>>
>>>>> in
>>>>>> and manually remove any tables in your MySQL in between your
>>>>>> first installation attempt and your second? That you removed
>>>>>> some things
>>>>>>
>>>>> but
>>>>>> not all is the only explanation I can think of for the error
>>>>>> you're seeing, which I can't duplicate. Maybe you removed all
>>>>>> tables, but didn't remove any indexes, or something?
>>>>>> You shouldn't actually need to re-execute ALL initial setup after
>>>>>> an 'svn up', but you should in fact run "rake db:migrate" as you
>>>>>>
>>>> did--and
>>>>
>>>>>>
>>>>>
>>>>>> ordinarily it shouldn't give you any error.
>>>>>>
>>>>>> I'd recommend dropping the entire database you are using (that you
>>>>>>
>>>> set
>>>>
>>>>>>
>>>>>
>>>>>> in umlaut_config/databases.yml), recreating the entire database
>>>>>> from scratch, and then re-running "rake db:migrate". That should
>>>>>> take
>>>>>>
>>>> care
>>>>
>>>>>>
>>>>>
>>>>>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>>>>>
>>>>> figure
>>>>>> it out.
>>>>>>
>>>>>> Jonathan
>>>>>>
>>>>>> Poulter, Dale wrote:
>>>>>>
>>>>>>> Jonathan,
>>>>>>>
>>>>>>> I have attempted the svn up and it did update a few files. I
>>>>>>> re-execututed the initial setup and received the error below.
>>>>>>>
>>>>>>> rake db:migrate (in /apps/umlaut/Umlaut)
>>>>>>> == AddSomeMissingStuff: migrating
>>>>>>> =============================================
>>>>>>> -- add_index(:service_types, :service_type_value_id)
>>>>>>> rake aborted!
>>>>>>> Mysql::Error: Duplicate key name
>>>>>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>>>>>> `index_service_types_on_service_type_value_id` ON service_types
>>>>>>> (`service_type_value_id`)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>>>> Rochkind
>>>>>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>>>>>> To: umlaut-general at rubyforge.org
>>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>>
>>>>>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>>>>>
>>>>>> version,
>>>>>>
>>>>>>> and see if that takes care of it. It's possible you happened to
>>>>>>>
>>>> check
>>>>
>>>>>>>
>>>>>> it
>>>>>>
>>>>>>> out before in a state where it contained a bug.
>>>>>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>>>>>
>>>>>> slightly
>>>>>>
>>>>>>> easier setup/install process, and in Rails 2.x. I'm not sure
>>>>>>> Umlaut is the right tool for a database A-Z list. It's
>>>>>>> really focused on the domain of SFX, which includes a journal title
>>>>>>>
>>>>>> A-Z
>>>>>>
>>>>>>> list, but not neccesarily a database A-Z list. Although I suppose
>>>>>>>
>>>> it
>>>>
>>>>>>> could be expanded in that direction, I'm not sure if it would make
>>>>>>>
>>>>>> sense
>>>>>>
>>>>>>> or not.
>>>>>>> Here, we're using Xerxes, the Metalib front-end, as our database
>>>>>>> A-Z
>>>>>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>>>>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>>>>>
>>>>>>> We decided it made more sense to base a database A-Z off of
>>>>>>> Metalib,
>>>>>>> since Metalib's unit of knowledge base is the database, while SFX's
>>>>>>>
>>>>> is
>>>>>
>>>>>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>>>>>> relationship to what librarians or users think of as a 'database').
>>>>>>>
>>>>>> But
>>>>>>
>>>>>>> we don't have Verde here, I'm not sure how that fits into it all
>>>>>>>
>>>>>> really.
>>>>>>
>>>>>>> I mean, I know what Verde is, I just don't understand how it fits
>>>>>>>
>>>>> into
>>>>>
>>>>>>> anything usefully. :)
>>>>>>>
>>>>>>> But I think Umlaut does very well as an SFX front-end, an A-Z list,
>>>>>>>
>>>>>> and
>>>>>>
>>>>>>> also a service provider that can integrate known-item services in
>>>>>>>
>>>>>> other
>>>>>>
>>>>>>> software, like your OPAC. I am using Umlaut to provide various
>>>>>>> interesting services right on my OPAC pages (not just a link to
>>>>>>>
>>>>>> Umlaut,
>>>>>>
>>>>>>> but the content right on the OPAC page).
>>>>>>> Jonathan
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>>> "Poulter, Dale" 11/19/08 8:16 PM
>>>>>>>>>>
>>>>>>> Jonathan,
>>>>>>>
>>>>>>> We have had this on our back burner for a while and I finally
>>>>>>>
>>>> decided
>>>>
>>>>>>>
>>>>>> it
>>>>>>
>>>>>>> was time to jump in and get started. Our hope is to use umlaut to
>>>>>>> initially provide another interface to SFX and the A-Z list but
>>>>>>>
>>>>>> possibly
>>>>>>
>>>>>>> expand to use as a front end to our database A-Z list generated
>>>>>>>
>>>>>> through
>>>>>>
>>>>>>> Verde.
>>>>>>>
>>>>>>> To checkout the package I used:
>>>>>>>
>>>>>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>>>>>
>>>>>>>
>>>>>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>>>>>> SirsiDynix Symphony.
>>>>>>> I'll try to re-checkout the package again and continue to work on
>>>>>>>
>>>>> this
>>>>>
>>>>>>> but will be glad to test out anything you have ready. Thanks for
>>>>>>>
>>>>> your
>>>>>
>>>>>>> work.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>>>> Rochkind
>>>>>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>>>>>> To: umlaut-general at rubyforge.org
>>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>>
>>>>>>> Hi Dale. So glad you are checking it out, happy to help.
>>>>>>>
>>>>>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>>>>>
>>>>> also
>>>>>
>>>>>>>
>>>>>>
>>>>>>> improving some of the "getting started" helper scripts, so you
>>>>>>> might
>>>>>>>
>>>>
>>>>
>>>>>>> want to wait a week or two (after thanksgiving) when that should
>>>>>>> be done, and start again then. Once I'm done, that will
>>>>>>> effectively be
>>>>>>>
>>>>
>>>>
>>>>>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing
>>>>>>> much version control with Umlaut, since I was the only one using
>>>>>>> it, but
>>>>>>>
>>>> I
>>>>
>>>>>>>
>>>>>
>>>>>>> see I'll have to start).
>>>>>>>
>>>>>>> But I don't want to discourage you from starting now either. I'm
>>>>>>> not
>>>>>>>
>>>>
>>>>
>>>>>>> sure what's going on. But from your path, I see that you have
>>>>>>>
>>>> checked
>>>>
>>>>>>>
>>>>>
>>>>>>> out Umlaut kind of oddly. Can you give me the svn command you used
>>>>>>>
>>>> to
>>>>
>>>>>>>
>>>>>
>>>>>>> checkout? I think you can use a better one that will make this
>>>>>>>
>>>>>> somewhat
>>>>>>
>>>>>>> clearer and easier to debug.
>>>>>>>
>>>>>>> You are on Unix, not Windows, right? That particular error is what
>>>>>>>
>>>>>> you
>>>>>>> get when there's a syntax error in the source file. I may have
>>>>>>> accidentally included an error in the svn, which I wasn't worrying
>>>>>>>
>>>>> too
>>>>>
>>>>>>>
>>>>>>
>>>>>>> much about not knowing anyone else was looking at it. You can try
>>>>>>>
>>>>> "svn
>>>>>
>>>>>>>
>>>>>>
>>>>>>> up" to update your working copy to the latest svn, in case I have
>>>>>>>
>>>>>> since
>>>>>>> fixed it.
>>>>>>>
>>>>>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>>>>>
>>>>>> integration,
>>>>>>> we're going to have to do some custom coding for you, since I am
>>>>>>> confident you don't use Horizon like us. It would be great if
>>>>>>> you'd
>>>>>>>
>>>>
>>>>
>>>>>>> share a bit about what your motivation is for experimenting with
>>>>>>>
>>>>>> Umlaut,
>>>>>>
>>>>>>> what you're interested in, what your plans are (if any beyond
>>>>>>> 'check
>>>>>>>
>>>>>> it
>>>>>>> out for now').
>>>>>>>
>>>>>>> Since nobody but me has been using Umlaut until now, there might be
>>>>>>>
>>>>>> some
>>>>>>
>>>>>>> kinks in getting it up and running, but I am happy to spend my
>>>>>>> time ironing them out and helping you get up and running. I can
>>>>>>> call you
>>>>>>>
>>>>> on
>>>>>
>>>>>>>
>>>>>>
>>>>>>> the phone at a later point if it looks like we could use some
>>>>>>> synchronous communication.
>>>>>>>
>>>>>>> Jonathan
>>>>>>>
>>>>>>> Poulter, Dale wrote:
>>>>>>>
>>>>>>>> Good afternoon,
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> We are just starting to get umlaut configured and running. The
>>>>>>>> installation went well but when we attempt to access the site we
>>>>>>>>
>>>> get
>>>>
>>>>>>>>
>>>>>>> the
>>>>>>>
>>>>>>>> error:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> "LoadError in SearchController#index
>>>>>>>>
>>>>>>>> Expected
>>>>>>>>
>>>> /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>>
>>>>>>>>
>>>>>>> to
>>>>>>>
>>>>>>>> define SearchController
>>>>>>>>
>>>>>>>> "
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Any suggestions as to the cause or resolution to this issue?
>>>>>>>>
>>>>> Thanks.
>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --Dale
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> ---------------------------------------
>>>>>>>> Dale Poulter
>>>>>>>> Automation Coordinator
>>>>>>>>
>>>>>>>> Library Information Technology Services
>>>>>>>> Vanderbilt University
>>>>>>>> Suite 700
>>>>>>>> 110 21st Avenue South
>>>>>>>> Nashville, TN 37240
>>>>>>>> (615)343-5388
>>>>>>>> (615)343-8834 (fax)
>>>>>>>> (615)207-9705 (cell)
>>>>>>>> dale.poulter at vanderbilt.edu
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>>>
>>>>>>
>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Umlaut-general mailing list
>>>>>>>> Umlaut-general at rubyforge.org
>>>>>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>> _______________________________________________
>> Umlaut-general mailing list
>> Umlaut-general at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/umlaut-general
>
From rochkind at jhu.edu Mon Nov 24 17:30:32 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 17:30:32 -0500
Subject: [Umlaut-general] Error with initial configuration
In-Reply-To: <492B2989.5010200@ufl.edu>
References: <4924A58002000057000659CA@cis27.hosts.jhmi.edu>
<63566160FBD1BE43873B5A100A4222DF08168CC1@mailbe17.email.Vanderbilt.edu>
<492ADD9A.30404@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816972A@mailbe17.email.Vanderbilt.edu>
<492B079E.8080005@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF0816990C@mailbe17.email.Vanderbilt.edu>
<492B0ADD.4040300@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081699AA@mailbe17.email.Vanderbilt.edu>
<492B1194.6010108@jhu.edu> <492B1FD2.1050106@ufl.edu>
<492B27D8.6090701@jhu.edu> <492B2989.5010200@ufl.edu>
Message-ID: <492B2B08.4040306@jhu.edu>
Hmm, you might run into difficulties seperating all this stuff between
your sysadmins and you, if we run into weirdness with Umlaut, as we
often do.
Do you plan to have your sysadmins install Umlaut itself too? Either
you might have to get involved in that, or you might have to get your
sysadmins on this list. Things aren't quite out-of-the-box guaranteed to
work yet, as Dale discovered, although we're working on it. But we'll
cross that bridge when we come to it.
Jonathan
Mark Needleman wrote:
> actually our sysadminds do all of that - i put in a request today for
> them to install all of the things on our installation notes
>
> mark
>
> Jonathan Rochkind wrote:
>> Excellent.
>>
>> The new release of Umlaut will require rails 2.1.2, so if you're all
>> looking for something to do while waiting for it, you can go ahead
>> and install that.
>>
>> (A future version will use Rails 2.2.2, which should actually be
>> helpful as we use threads in Umlaut, which Rails 2.2.2 for the first
>> time is actually _designed_ to support with better performance than
>> the hacks we are using. But for now, since we do use threads and the
>> threading model has changed in Rails, I'm staying at 2.1.2 until I
>> can spend more time with it.)
>>
>> Jonathan
>>
>> Mark Needleman wrote:
>>> dont forget me - im planning on installing the new version
>>>
>>> mark
>>>
>>> Jonathan Rochkind wrote:
>>>> How very very weird. Yes, it would be better to wait until
>>>> tommorow, when I should have the new version committed to trunk.
>>>> Let's cross our fingers and hope that that fixes it, otherwise
>>>> it'll be mysterious.
>>>>
>>>> I need to write configuration instructions for the new version too,
>>>> but the summary is that instead of adding lots of config in
>>>> umlaut_config/environment.rb, you will add it to several files
>>>> inside of umlaut_config/initializers/umlaut.
>>>>
>>>> I hestitate to tell you this, since it sounds like you didn't
>>>> already realize it, but nobody else has an active installation of
>>>> Umlaut except for me at the moment, so far as I am aware. So the
>>>> only "people" that will install the newer version are you and me,
>>>> right now. :) But I will be upgrading my own live production copy
>>>> to the newer version today or tommorow, yeah.
>>>>
>>>> Jonathan
>>>>
>>>> Poulter, Dale wrote:
>>>>> Jonathan,
>>>>>
>>>>> Bugs always happen. I do have the mysql gem v2.7 installed (see
>>>>> output
>>>>> below). Since you are almost done with moving to rails2, would it be
>>>>> better to wait a day or two and try the new version? I would assume
>>>>> that people will attempt to install the newer version. bash-3.00#
>>>>> gem list mysql
>>>>>
>>>>> *** LOCAL GEMS ***
>>>>>
>>>>> mysql (2.7)
>>>>>
>>>>> --Dale
>>>>>
>>>>> ---------------------------------------
>>>>> Dale Poulter
>>>>> Automation Coordinator
>>>>> Library Information Technology Services
>>>>> Vanderbilt University
>>>>> Suite 700
>>>>> 110 21st Avenue South
>>>>> Nashville, TN 37240
>>>>> (615)343-5388
>>>>> (615)343-8834 (fax)
>>>>> (615)207-9705 (cell)
>>>>> dale.poulter at vanderbilt.edu
>>>>>
>>>>> -----Original Message-----
>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>> Rochkind
>>>>> Sent: Monday, November 24, 2008 2:13 PM
>>>>> To: umlaut-general at rubyforge.org
>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>
>>>>> Aha. A bit of googling suggests you may have run into a bug in a
>>>>> version
>>>>>
>>>>> of the Rails MySQL adapters:
>>>>>
>>>>> http://jira.codehaus.org/browse/JRUBY-1543
>>>>>
>>>>> ( You aren't trying to use JRuby are you? I think you've just run
>>>>> into a bug that the JRuby folks happened to run into also, which
>>>>> isn't specific to JRuby ).
>>>>>
>>>>> I have installed the 'mysql' gem for my Umlaut, which I think my
>>>>> instructions say is 'optional', as theoretically Rails can connect
>>>>> to MySQL without it. But it may be advisable.
>>>>>
>>>>> Do you have the MySQL gem installed, and if so, what version? I
>>>>> have 2.7, it looks like.
>>>>>
>>>>> [jrochki1 at testbox U2]$ gem list mysql
>>>>> *** LOCAL GEMS ***
>>>>> mysql (2.7)
>>>>>
>>>>> It looks to me like 2.7 is indeed the latest version. If you don't
>>>>> have it, you can do:
>>>>> sudo gem install mysql
>>>>> or
>>>>> sudo gem update mysql
>>>>> to get the latest version.
>>>>>
>>>>> Sorry this isn't smoother than it is, that's how it goes
>>>>> sometimes, as more people adopt Umlaut we can hopefully get it
>>>>> smoothed out.
>>>>>
>>>>> If you DO have mysql gem 2.7 installed, then it's really going to
>>>>> be a mystery.
>>>>>
>>>>> Jonathan
>>>>>
>>>>>
>>>>> Poulter, Dale wrote:
>>>>>
>>>>>> We are running mysql version 5.0.51b
>>>>>>
>>>>>> --Dale
>>>>>>
>>>>>> ---------------------------------------
>>>>>> Dale Poulter
>>>>>> Automation Coordinator
>>>>>> Library Information Technology Services
>>>>>> Vanderbilt University
>>>>>> Suite 700
>>>>>> 110 21st Avenue South
>>>>>> Nashville, TN 37240
>>>>>> (615)343-5388
>>>>>> (615)343-8834 (fax)
>>>>>> (615)207-9705 (cell)
>>>>>> dale.poulter at vanderbilt.edu
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>>> Rochkind
>>>>>> Sent: Monday, November 24, 2008 1:59 PM
>>>>>> To: umlaut-general at rubyforge.org
>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>
>>>>>> Hmm, very odd. You are using MySQL, right? What version of
>>>>>> MySQL? It
>>>>>>
>>>>>
>>>>>
>>>>>> may be that 5.x is required, do you have 4.x instead?
>>>>>> Jonathan
>>>>>>
>>>>>> Poulter, Dale wrote:
>>>>>>
>>>>>>> Jonathan,
>>>>>>>
>>>>>>> Regretfully, the problem persists after dropping and recreating the
>>>>>>> databases.
>>>>>>>
>>>>>>>
>>>>>>> .... == AddSomeMissingStuff: migrating
>>>>>>> =============================================
>>>>>>> -- add_index(:service_types, :service_type_value_id)
>>>>>>> -> 0.0757s
>>>>>>> -- change_column(:dispatched_services, :status, :string,
>>>>>>>
>>>>>> {:null=>false})
>>>>>>
>>>>>>> -> 0.0777s
>>>>>>> -- rename_column(:dispatched_services, :exception, :exception_info)
>>>>>>> rake aborted!
>>>>>>> Mysql::Error: You have an error in your SQL syntax; check the
>>>>>>> manual
>>>>>>> that corresponds to your MySQL server version for the right
>>>>>>> syntax to
>>>>>>> use near '' at line 1: ALTER TABLE dispatched_services CHANGE
>>>>>>>
>>>>>> exception
>>>>>>
>>>>>>> exception_info
>>>>>>> (See full trace by running task with --trace)
>>>>>>>
>>>>>>>
>>>>>>> FYI:
>>>>>>> mysql --version
>>>>>>> mysql Ver 14.12 Distrib 5.0.51b, for sun-solaris2.10 (sparc) using
>>>>>>> EditLine wrapper
>>>>>>>
>>>>>>>
>>>>>>> --Dale
>>>>>>>
>>>>>>> ---------------------------------------
>>>>>>> Dale Poulter
>>>>>>> Automation Coordinator
>>>>>>> Library Information Technology Services
>>>>>>> Vanderbilt University
>>>>>>> Suite 700
>>>>>>> 110 21st Avenue South
>>>>>>> Nashville, TN 37240
>>>>>>> (615)343-5388
>>>>>>> (615)343-8834 (fax)
>>>>>>> (615)207-9705 (cell)
>>>>>>> dale.poulter at vanderbilt.edu
>>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>>>>> Rochkind
>>>>>>> Sent: Monday, November 24, 2008 11:00 AM
>>>>>>> To: umlaut-general at rubyforge.org
>>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>>
>>>>>>> Hmm, this is still kind of mysterious to me, Dale. Did you try
>>>>>>> to go
>>>>>>>
>>>>>> in
>>>>>>> and manually remove any tables in your MySQL in between your
>>>>>>> first installation attempt and your second? That you removed
>>>>>>> some things
>>>>>>>
>>>>>> but
>>>>>>> not all is the only explanation I can think of for the error
>>>>>>> you're seeing, which I can't duplicate. Maybe you removed all
>>>>>>> tables, but didn't remove any indexes, or something?
>>>>>>> You shouldn't actually need to re-execute ALL initial setup
>>>>>>> after an 'svn up', but you should in fact run "rake db:migrate"
>>>>>>> as you
>>>>>>>
>>>>> did--and
>>>>>
>>>>>>>
>>>>>>
>>>>>>> ordinarily it shouldn't give you any error.
>>>>>>>
>>>>>>> I'd recommend dropping the entire database you are using (that you
>>>>>>>
>>>>> set
>>>>>
>>>>>>>
>>>>>>
>>>>>>> in umlaut_config/databases.yml), recreating the entire database
>>>>>>> from scratch, and then re-running "rake db:migrate". That
>>>>>>> should take
>>>>>>>
>>>>> care
>>>>>
>>>>>>>
>>>>>>
>>>>>>> of it, and hopefully it won't re-occur. If it does, I'll have to
>>>>>>>
>>>>>> figure
>>>>>>> it out.
>>>>>>>
>>>>>>> Jonathan
>>>>>>>
>>>>>>> Poulter, Dale wrote:
>>>>>>>
>>>>>>>> Jonathan,
>>>>>>>>
>>>>>>>> I have attempted the svn up and it did update a few files. I
>>>>>>>> re-execututed the initial setup and received the error below.
>>>>>>>>
>>>>>>>> rake db:migrate (in /apps/umlaut/Umlaut)
>>>>>>>> == AddSomeMissingStuff: migrating
>>>>>>>> =============================================
>>>>>>>> -- add_index(:service_types, :service_type_value_id)
>>>>>>>> rake aborted!
>>>>>>>> Mysql::Error: Duplicate key name
>>>>>>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>>>>>>> `index_service_types_on_service_type_value_id` ON service_types
>>>>>>>> (`service_type_value_id`)
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of
>>>>>>>> Jonathan
>>>>>>>> Rochkind
>>>>>>>> Sent: Wednesday, November 19, 2008 10:47 PM
>>>>>>>> To: umlaut-general at rubyforge.org
>>>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>>>
>>>>>>>> Sounds good. At a minimum, try 'svn up' on it to get the latest
>>>>>>>>
>>>>>>> version,
>>>>>>>
>>>>>>>> and see if that takes care of it. It's possible you happened to
>>>>>>>>
>>>>> check
>>>>>
>>>>>>>>
>>>>>>> it
>>>>>>>
>>>>>>>> out before in a state where it contained a bug.
>>>>>>>> If you wait until next week, I'll have "Umlaut 3.0" out, with a
>>>>>>>>
>>>>>>> slightly
>>>>>>>
>>>>>>>> easier setup/install process, and in Rails 2.x. I'm not sure
>>>>>>>> Umlaut is the right tool for a database A-Z list. It's
>>>>>>>> really focused on the domain of SFX, which includes a journal
>>>>>>>> title
>>>>>>>>
>>>>>>> A-Z
>>>>>>>
>>>>>>>> list, but not neccesarily a database A-Z list. Although I suppose
>>>>>>>>
>>>>> it
>>>>>
>>>>>>>> could be expanded in that direction, I'm not sure if it would make
>>>>>>>>
>>>>>>> sense
>>>>>>>
>>>>>>>> or not.
>>>>>>>> Here, we're using Xerxes, the Metalib front-end, as our
>>>>>>>> database A-Z
>>>>>>>> list. See http://jhsearch.library.jhu.edu, and in particular
>>>>>>>> http://jhsearch.library.jhu.edu/databases/alphabetical
>>>>>>>>
>>>>>>>> We decided it made more sense to base a database A-Z off of
>>>>>>>> Metalib,
>>>>>>>> since Metalib's unit of knowledge base is the database, while
>>>>>>>> SFX's
>>>>>>>>
>>>>>> is
>>>>>>
>>>>>>>> more the journal title. ("Targets" in SFX can have a non-obvious
>>>>>>>> relationship to what librarians or users think of as a
>>>>>>>> 'database').
>>>>>>>>
>>>>>>> But
>>>>>>>
>>>>>>>> we don't have Verde here, I'm not sure how that fits into it all
>>>>>>>>
>>>>>>> really.
>>>>>>>
>>>>>>>> I mean, I know what Verde is, I just don't understand how it fits
>>>>>>>>
>>>>>> into
>>>>>>
>>>>>>>> anything usefully. :)
>>>>>>>>
>>>>>>>> But I think Umlaut does very well as an SFX front-end, an A-Z
>>>>>>>> list,
>>>>>>>>
>>>>>>> and
>>>>>>>
>>>>>>>> also a service provider that can integrate known-item services in
>>>>>>>>
>>>>>>> other
>>>>>>>
>>>>>>>> software, like your OPAC. I am using Umlaut to provide various
>>>>>>>> interesting services right on my OPAC pages (not just a link to
>>>>>>>>
>>>>>>> Umlaut,
>>>>>>>
>>>>>>>> but the content right on the OPAC page).
>>>>>>>> Jonathan
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>> "Poulter, Dale" 11/19/08
>>>>>>>>>>> 8:16 PM
>>>>>>>>>>>
>>>>>>>> Jonathan,
>>>>>>>>
>>>>>>>> We have had this on our back burner for a while and I finally
>>>>>>>>
>>>>> decided
>>>>>
>>>>>>>>
>>>>>>> it
>>>>>>>
>>>>>>>> was time to jump in and get started. Our hope is to use umlaut to
>>>>>>>> initially provide another interface to SFX and the A-Z list but
>>>>>>>>
>>>>>>> possibly
>>>>>>>
>>>>>>>> expand to use as a front end to our database A-Z list generated
>>>>>>>>
>>>>>>> through
>>>>>>>
>>>>>>>> Verde.
>>>>>>>>
>>>>>>>> To checkout the package I used:
>>>>>>>>
>>>>>>>> Svn checkout http://umlaut.rubyforge.org/svn/
>>>>>>>>
>>>>>>>>
>>>>>>>> We are running this on a unix server (solaris 10 ) and our ILS is
>>>>>>>> SirsiDynix Symphony.
>>>>>>>> I'll try to re-checkout the package again and continue to work on
>>>>>>>>
>>>>>> this
>>>>>>
>>>>>>>> but will be glad to test out anything you have ready. Thanks for
>>>>>>>>
>>>>>> your
>>>>>>
>>>>>>>> work.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From: umlaut-general-bounces at rubyforge.org
>>>>>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of
>>>>>>>> Jonathan
>>>>>>>> Rochkind
>>>>>>>> Sent: Wednesday, November 19, 2008 3:04 PM
>>>>>>>> To: umlaut-general at rubyforge.org
>>>>>>>> Subject: Re: [Umlaut-general] Error with initial configuration
>>>>>>>>
>>>>>>>> Hi Dale. So glad you are checking it out, happy to help.
>>>>>>>>
>>>>>>>> I'm actually in the middle of migrating Umlaut to use Rails2, and
>>>>>>>>
>>>>>> also
>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>> improving some of the "getting started" helper scripts, so you
>>>>>>>> might
>>>>>>>>
>>>>>
>>>>>
>>>>>>>> want to wait a week or two (after thanksgiving) when that
>>>>>>>> should be done, and start again then. Once I'm done, that will
>>>>>>>> effectively be
>>>>>>>>
>>>>>
>>>>>
>>>>>>>> "Umlaut 3.0", or a beta version of such. (I haven't been doing
>>>>>>>> much version control with Umlaut, since I was the only one
>>>>>>>> using it, but
>>>>>>>>
>>>>> I
>>>>>
>>>>>>>>
>>>>>>
>>>>>>>> see I'll have to start).
>>>>>>>>
>>>>>>>> But I don't want to discourage you from starting now either.
>>>>>>>> I'm not
>>>>>>>>
>>>>>
>>>>>
>>>>>>>> sure what's going on. But from your path, I see that you have
>>>>>>>>
>>>>> checked
>>>>>
>>>>>>>>
>>>>>>
>>>>>>>> out Umlaut kind of oddly. Can you give me the svn command you used
>>>>>>>>
>>>>> to
>>>>>
>>>>>>>>
>>>>>>
>>>>>>>> checkout? I think you can use a better one that will make this
>>>>>>>>
>>>>>>> somewhat
>>>>>>>
>>>>>>>> clearer and easier to debug.
>>>>>>>>
>>>>>>>> You are on Unix, not Windows, right? That particular error is
>>>>>>>> what
>>>>>>>>
>>>>>>> you
>>>>>>>> get when there's a syntax error in the source file. I may have
>>>>>>>> accidentally included an error in the svn, which I wasn't worrying
>>>>>>>>
>>>>>> too
>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>> much about not knowing anyone else was looking at it. You can try
>>>>>>>>
>>>>>> "svn
>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>> up" to update your working copy to the latest svn, in case I have
>>>>>>>>
>>>>>>> since
>>>>>>>> fixed it.
>>>>>>>>
>>>>>>>> Out of curiousity, what ILS do you guys use? For full ILS
>>>>>>>>
>>>>>>> integration,
>>>>>>>> we're going to have to do some custom coding for you, since I
>>>>>>>> am confident you don't use Horizon like us. It would be great
>>>>>>>> if you'd
>>>>>>>>
>>>>>
>>>>>
>>>>>>>> share a bit about what your motivation is for experimenting with
>>>>>>>>
>>>>>>> Umlaut,
>>>>>>>
>>>>>>>> what you're interested in, what your plans are (if any beyond
>>>>>>>> 'check
>>>>>>>>
>>>>>>> it
>>>>>>>> out for now').
>>>>>>>>
>>>>>>>> Since nobody but me has been using Umlaut until now, there
>>>>>>>> might be
>>>>>>>>
>>>>>>> some
>>>>>>>
>>>>>>>> kinks in getting it up and running, but I am happy to spend my
>>>>>>>> time ironing them out and helping you get up and running. I can
>>>>>>>> call you
>>>>>>>>
>>>>>> on
>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>> the phone at a later point if it looks like we could use some
>>>>>>>> synchronous communication.
>>>>>>>>
>>>>>>>> Jonathan
>>>>>>>>
>>>>>>>> Poulter, Dale wrote:
>>>>>>>>
>>>>>>>>> Good afternoon,
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> We are just starting to get umlaut configured and running. The
>>>>>>>>> installation went well but when we attempt to access the site we
>>>>>>>>>
>>>>> get
>>>>>
>>>>>>>>>
>>>>>>>> the
>>>>>>>>
>>>>>>>>> error:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> "LoadError in SearchController#index
>>>>>>>>>
>>>>>>>>> Expected
>>>>>>>>>
>>>>> /apps/umlaut/svn/trunk/app/controllers/search_controller.rb
>>>>>
>>>>>>>>>
>>>>>>>> to
>>>>>>>>
>>>>>>>>> define SearchController
>>>>>>>>>
>>>>>>>>> "
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Any suggestions as to the cause or resolution to this issue?
>>>>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --Dale
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ---------------------------------------
>>>>>>>>> Dale Poulter
>>>>>>>>> Automation Coordinator
>>>>>>>>>
>>>>>>>>> Library Information Technology Services
>>>>>>>>> Vanderbilt University
>>>>>>>>> Suite 700
>>>>>>>>> 110 21st Avenue South
>>>>>>>>> Nashville, TN 37240
>>>>>>>>> (615)343-5388
>>>>>>>>> (615)343-8834 (fax)
>>>>>>>>> (615)207-9705 (cell)
>>>>>>>>> dale.poulter at vanderbilt.edu
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>>
>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Umlaut-general mailing list
>>>>>>>>> Umlaut-general at rubyforge.org
>>>>>>>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>> _______________________________________________
>>> Umlaut-general mailing list
>>> Umlaut-general at rubyforge.org
>>> http://rubyforge.org/mailman/listinfo/umlaut-general
>>
> _______________________________________________
> Umlaut-general mailing list
> Umlaut-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/umlaut-general
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Mon Nov 24 18:39:27 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Mon, 24 Nov 2008 18:39:27 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
Message-ID: <492B3B2F.1050402@jhu.edu>
'svn up' on an svn working copy will get you Umlaut code updated to work
with Rails 2. All wiki documentation has been updated appropriately, but
some changes to be aware of:
1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
2. Generate local files with ./script/generate umlaut_local, not the
rake task as previously. This will create somewhat different config
files. If you haven't gotten very far with configging, I reccommend
allowing the ./script/generate to overwrite all existing files, and
start your local configuration from scratch. (./script/generate will
prompt you whether to overwrite, or you can add a "--force" object so it
will do so without prompting you).
3. Local configuration by and large no longer happens in
config/umlaut_config/environment.rb, instead it happens in several files
in config/umlaut_config/initializers/umlaut. See the wiki page for some
settings you want to set:
http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_local_configuration
4. Updated the wiki page to say that a direct connection to the SFX db
is really the _only_ way Umlaut is verified to work for 'search'
functionality (A-Z list, manually entered journal title or citation).
If this isn't available to you, though, talk to me, and other things are
theoretically possible, just not currently verified to work.
5. When you get to deployment, there is now a 'wizard' (actually a Rails
generator) to create some of the neccesary deploy config files for you.
This is good, as this is a confusing and error prone process otherwise.
(I needed it myself!). Documented on wiki under deployment.
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Tue Nov 25 09:35:51 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Tue, 25 Nov 2008 08:35:51 -0600
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <492B3B2F.1050402@jhu.edu>
References: <492B3B2F.1050402@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
Jonathan,
Thanks for getting the new version out so quickly. I have wiped out my
installation and started from scratch. Here is what I have done so far
and the results --sadly an error.
- gem install rails -v 2.1.1 (actually should be 2.1.2)
-cd /apps/umlaut
-svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
- ./script/generate umlaut_local
bash-3.00# ./script/generate umlaut_local
No such file or directory -
/apps/umlaut/config/umlaut_config/initializers/umlaut
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Monday, November 24, 2008 5:39 PM
To: umlaut-general at rubyforge.org
Subject: [Umlaut-general] Rails 2.x code committed.
'svn up' on an svn working copy will get you Umlaut code updated to work
with Rails 2. All wiki documentation has been updated appropriately, but
some changes to be aware of:
1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
2. Generate local files with ./script/generate umlaut_local, not the
rake task as previously. This will create somewhat different config
files. If you haven't gotten very far with configging, I reccommend
allowing the ./script/generate to overwrite all existing files, and
start your local configuration from scratch. (./script/generate will
prompt you whether to overwrite, or you can add a "--force" object so it
will do so without prompting you).
3. Local configuration by and large no longer happens in
config/umlaut_config/environment.rb, instead it happens in several files
in config/umlaut_config/initializers/umlaut. See the wiki page for some
settings you want to set:
http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
al_configuration
4. Updated the wiki page to say that a direct connection to the SFX db
is really the _only_ way Umlaut is verified to work for 'search'
functionality (A-Z list, manually entered journal title or citation).
If this isn't available to you, though, talk to me, and other things are
theoretically possible, just not currently verified to work.
5. When you get to deployment, there is now a 'wizard' (actually a Rails
generator) to create some of the neccesary deploy config files for you.
This is good, as this is a confusing and error prone process otherwise.
(I needed it myself!). Documented on wiki under deployment.
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Tue Nov 25 09:39:09 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 09:39:09 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
References: <492B3B2F.1050402@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
Message-ID: <492C0E0D.9000405@jhu.edu>
Doh! Thanks for troubleshooting this stuff, I'll get it fixed today, my
own silly error.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> Thanks for getting the new version out so quickly. I have wiped out my
> installation and started from scratch. Here is what I have done so far
> and the results --sadly an error.
>
> - gem install rails -v 2.1.1 (actually should be 2.1.2)
> -cd /apps/umlaut
> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
> - ./script/generate umlaut_local
>
>
> bash-3.00# ./script/generate umlaut_local
> No such file or directory -
> /apps/umlaut/config/umlaut_config/initializers/umlaut
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 5:39 PM
> To: umlaut-general at rubyforge.org
> Subject: [Umlaut-general] Rails 2.x code committed.
>
> 'svn up' on an svn working copy will get you Umlaut code updated to work
>
> with Rails 2. All wiki documentation has been updated appropriately, but
>
> some changes to be aware of:
>
> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>
> 2. Generate local files with ./script/generate umlaut_local, not the
> rake task as previously. This will create somewhat different config
> files. If you haven't gotten very far with configging, I reccommend
> allowing the ./script/generate to overwrite all existing files, and
> start your local configuration from scratch. (./script/generate will
> prompt you whether to overwrite, or you can add a "--force" object so it
>
> will do so without prompting you).
>
> 3. Local configuration by and large no longer happens in
> config/umlaut_config/environment.rb, instead it happens in several files
>
> in config/umlaut_config/initializers/umlaut. See the wiki page for some
>
> settings you want to set:
> http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
> al_configuration
>
> 4. Updated the wiki page to say that a direct connection to the SFX db
> is really the _only_ way Umlaut is verified to work for 'search'
> functionality (A-Z list, manually entered journal title or citation).
> If this isn't available to you, though, talk to me, and other things are
>
> theoretically possible, just not currently verified to work.
>
> 5. When you get to deployment, there is now a 'wizard' (actually a Rails
>
> generator) to create some of the neccesary deploy config files for you.
> This is good, as this is a confusing and error prone process otherwise.
> (I needed it myself!). Documented on wiki under deployment.
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Tue Nov 25 11:04:33 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 11:04:33 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
References: <492B3B2F.1050402@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
Message-ID: <492C2211.7030206@jhu.edu>
Should be fixed. Just run "svn up" in your working directory, and try
running "./script/generate umlaut_local" again, and proceed until the
next problem, heh.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> Thanks for getting the new version out so quickly. I have wiped out my
> installation and started from scratch. Here is what I have done so far
> and the results --sadly an error.
>
> - gem install rails -v 2.1.1 (actually should be 2.1.2)
> -cd /apps/umlaut
> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
> - ./script/generate umlaut_local
>
>
> bash-3.00# ./script/generate umlaut_local
> No such file or directory -
> /apps/umlaut/config/umlaut_config/initializers/umlaut
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 5:39 PM
> To: umlaut-general at rubyforge.org
> Subject: [Umlaut-general] Rails 2.x code committed.
>
> 'svn up' on an svn working copy will get you Umlaut code updated to work
>
> with Rails 2. All wiki documentation has been updated appropriately, but
>
> some changes to be aware of:
>
> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>
> 2. Generate local files with ./script/generate umlaut_local, not the
> rake task as previously. This will create somewhat different config
> files. If you haven't gotten very far with configging, I reccommend
> allowing the ./script/generate to overwrite all existing files, and
> start your local configuration from scratch. (./script/generate will
> prompt you whether to overwrite, or you can add a "--force" object so it
>
> will do so without prompting you).
>
> 3. Local configuration by and large no longer happens in
> config/umlaut_config/environment.rb, instead it happens in several files
>
> in config/umlaut_config/initializers/umlaut. See the wiki page for some
>
> settings you want to set:
> http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
> al_configuration
>
> 4. Updated the wiki page to say that a direct connection to the SFX db
> is really the _only_ way Umlaut is verified to work for 'search'
> functionality (A-Z list, manually entered journal title or citation).
> If this isn't available to you, though, talk to me, and other things are
>
> theoretically possible, just not currently verified to work.
>
> 5. When you get to deployment, there is now a 'wizard' (actually a Rails
>
> generator) to create some of the neccesary deploy config files for you.
> This is good, as this is a confusing and error prone process otherwise.
> (I needed it myself!). Documented on wiki under deployment.
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Tue Nov 25 14:25:04 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 14:25:04 -0500
Subject: [Umlaut-general] json gem switch
Message-ID: <492C5110.1040402@jhu.edu>
I had to switch around the 'gem' (ie ruby library package) used in
Umlaut for json parsing, the really old one it was using was causing
problems with Rails2.
So there's a new pure-ruby json library bundled with Umlaut, but you
really ought to install the compiled C one on your server for much
better performance. If the compiled C gem is present, Umlaut will
automatically use it.
sudo gem install json
Will fix instructions on wiki too.
Jonathan
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Tue Nov 25 15:18:47 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Tue, 25 Nov 2008 14:18:47 -0600
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <492C2211.7030206@jhu.edu>
References: <492B3B2F.1050402@jhu.edu><63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
<492C2211.7030206@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu>
I am now getting the same error as before, any suggestions? What
version of mysql are you using?
bash-3.00$ rake db:migrate
(in /apps/umlaut)
== 10 AddSomeMissingStuff: migrating
==========================================
-- add_index(:service_types, :service_type_value_id)
rake aborted!
Mysql::Error: Duplicate key name
'index_service_types_on_service_type_value_id': CREATE INDEX
`index_service_types_on_service_type_value_id` ON `service_types`
(`service_type_value_id`)
(See full trace by running task with --trace)
**************************
Steps taken so far:
- create home directory (/apps/umlaut)
- cd /apps/umlaut
- svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
- ./script/generate umlaut_local
- mysqladmin -u root -p create umlaut_dev and umlaut_test, and umlaut
- modified /config/umlaut_config/database.yml
- rake db:migrate
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Tuesday, November 25, 2008 10:05 AM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Rails 2.x code committed.
Should be fixed. Just run "svn up" in your working directory, and try
running "./script/generate umlaut_local" again, and proceed until the
next problem, heh.
Jonathan
Poulter, Dale wrote:
> Jonathan,
>
> Thanks for getting the new version out so quickly. I have wiped out
my
> installation and started from scratch. Here is what I have done so
far
> and the results --sadly an error.
>
> - gem install rails -v 2.1.1 (actually should be 2.1.2)
> -cd /apps/umlaut
> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
> - ./script/generate umlaut_local
>
>
> bash-3.00# ./script/generate umlaut_local
> No such file or directory -
> /apps/umlaut/config/umlaut_config/initializers/umlaut
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Monday, November 24, 2008 5:39 PM
> To: umlaut-general at rubyforge.org
> Subject: [Umlaut-general] Rails 2.x code committed.
>
> 'svn up' on an svn working copy will get you Umlaut code updated to
work
>
> with Rails 2. All wiki documentation has been updated appropriately,
but
>
> some changes to be aware of:
>
> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>
> 2. Generate local files with ./script/generate umlaut_local, not the
> rake task as previously. This will create somewhat different config
> files. If you haven't gotten very far with configging, I reccommend
> allowing the ./script/generate to overwrite all existing files, and
> start your local configuration from scratch. (./script/generate will
> prompt you whether to overwrite, or you can add a "--force" object so
it
>
> will do so without prompting you).
>
> 3. Local configuration by and large no longer happens in
> config/umlaut_config/environment.rb, instead it happens in several
files
>
> in config/umlaut_config/initializers/umlaut. See the wiki page for
some
>
> settings you want to set:
>
http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
> al_configuration
>
> 4. Updated the wiki page to say that a direct connection to the SFX db
> is really the _only_ way Umlaut is verified to work for 'search'
> functionality (A-Z list, manually entered journal title or citation).
> If this isn't available to you, though, talk to me, and other things
are
>
> theoretically possible, just not currently verified to work.
>
> 5. When you get to deployment, there is now a 'wizard' (actually a
Rails
>
> generator) to create some of the neccesary deploy config files for
you.
> This is good, as this is a confusing and error prone process
otherwise.
> (I needed it myself!). Documented on wiki under deployment.
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Tue Nov 25 15:48:40 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 15:48:40 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu>
References: <492B3B2F.1050402@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
<492C2211.7030206@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu>
Message-ID: <492C64A8.2020109@jhu.edu>
Drat. It looks like I have:
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using
readline 5.0
I will try again to reproduce your problem from a clean-slate database.
And google around to see if anyone else has encountered this.
I don't understand how that index name can already exist when running
the migration on a clean-slate database. Seems like it must be a bug in
my migration code, but I don't understand why I'm not able to duplicate
it on my machine. I'll mess around on my machine and see if I can
reproduce.
Jonathan
Poulter, Dale wrote:
> I am now getting the same error as before, any suggestions? What
> version of mysql are you using?
>
> bash-3.00$ rake db:migrate
> (in /apps/umlaut)
> == 10 AddSomeMissingStuff: migrating
> ==========================================
> -- add_index(:service_types, :service_type_value_id)
> rake aborted!
> Mysql::Error: Duplicate key name
> 'index_service_types_on_service_type_value_id': CREATE INDEX
> `index_service_types_on_service_type_value_id` ON `service_types`
> (`service_type_value_id`)
>
> (See full trace by running task with --trace)
>
>
>
>
> **************************
> Steps taken so far:
>
> - create home directory (/apps/umlaut)
>
> - cd /apps/umlaut
>
> - svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>
> - ./script/generate umlaut_local
>
> - mysqladmin -u root -p create umlaut_dev and umlaut_test, and umlaut
>
> - modified /config/umlaut_config/database.yml
>
> - rake db:migrate
>
>
>
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Tuesday, November 25, 2008 10:05 AM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Rails 2.x code committed.
>
> Should be fixed. Just run "svn up" in your working directory, and try
> running "./script/generate umlaut_local" again, and proceed until the
> next problem, heh.
>
> Jonathan
>
> Poulter, Dale wrote:
>
>> Jonathan,
>>
>> Thanks for getting the new version out so quickly. I have wiped out
>>
> my
>
>> installation and started from scratch. Here is what I have done so
>>
> far
>
>> and the results --sadly an error.
>>
>> - gem install rails -v 2.1.1 (actually should be 2.1.2)
>> -cd /apps/umlaut
>> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>> - ./script/generate umlaut_local
>>
>>
>> bash-3.00# ./script/generate umlaut_local
>> No such file or directory -
>> /apps/umlaut/config/umlaut_config/initializers/umlaut
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Monday, November 24, 2008 5:39 PM
>> To: umlaut-general at rubyforge.org
>> Subject: [Umlaut-general] Rails 2.x code committed.
>>
>> 'svn up' on an svn working copy will get you Umlaut code updated to
>>
> work
>
>> with Rails 2. All wiki documentation has been updated appropriately,
>>
> but
>
>> some changes to be aware of:
>>
>> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>>
>> 2. Generate local files with ./script/generate umlaut_local, not the
>> rake task as previously. This will create somewhat different config
>> files. If you haven't gotten very far with configging, I reccommend
>> allowing the ./script/generate to overwrite all existing files, and
>> start your local configuration from scratch. (./script/generate will
>> prompt you whether to overwrite, or you can add a "--force" object so
>>
> it
>
>> will do so without prompting you).
>>
>> 3. Local configuration by and large no longer happens in
>> config/umlaut_config/environment.rb, instead it happens in several
>>
> files
>
>> in config/umlaut_config/initializers/umlaut. See the wiki page for
>>
> some
>
>> settings you want to set:
>>
>>
> http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
>
>> al_configuration
>>
>> 4. Updated the wiki page to say that a direct connection to the SFX db
>>
>
>
>> is really the _only_ way Umlaut is verified to work for 'search'
>> functionality (A-Z list, manually entered journal title or citation).
>>
>
>
>> If this isn't available to you, though, talk to me, and other things
>>
> are
>
>> theoretically possible, just not currently verified to work.
>>
>> 5. When you get to deployment, there is now a 'wizard' (actually a
>>
> Rails
>
>> generator) to create some of the neccesary deploy config files for
>>
> you.
>
>> This is good, as this is a confusing and error prone process
>>
> otherwise.
>
>> (I needed it myself!). Documented on wiki under deployment.
>>
>>
>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Tue Nov 25 15:59:53 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 15:59:53 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <492C64A8.2020109@jhu.edu>
References: <492B3B2F.1050402@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
<492C2211.7030206@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu>
<492C64A8.2020109@jhu.edu>
Message-ID: <492C6749.9060902@jhu.edu>
Yeah, I still can't reproduce you're issue, but I'll scour the code
anyway looking for something that might have caused it.
As a workaround, and another data point, instead of using 'migrate' to
create your database, you should be able to run (from Umlaut home
directory):
rake db:schema:load
That should get your db loaded too, but won't let you merge in new
changes in future db versions as easily. But try that, and see what that
does, just for comparison. For me, "rake db:schema:load" and "rake
db:migrate" both work fine.
Jonathan
Jonathan Rochkind wrote:
> Drat. It looks like I have:
>
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using
> readline 5.0
>
>
> I will try again to reproduce your problem from a clean-slate
> database. And google around to see if anyone else has encountered this.
> I don't understand how that index name can already exist when running
> the migration on a clean-slate database. Seems like it must be a bug
> in my migration code, but I don't understand why I'm not able to
> duplicate it on my machine. I'll mess around on my machine and see if
> I can reproduce.
>
> Jonathan
>
> Poulter, Dale wrote:
>> I am now getting the same error as before, any suggestions? What
>> version of mysql are you using?
>>
>> bash-3.00$ rake db:migrate (in /apps/umlaut)
>> == 10 AddSomeMissingStuff: migrating
>> ==========================================
>> -- add_index(:service_types, :service_type_value_id)
>> rake aborted!
>> Mysql::Error: Duplicate key name
>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>> `index_service_types_on_service_type_value_id` ON `service_types`
>> (`service_type_value_id`)
>>
>> (See full trace by running task with --trace)
>>
>>
>>
>>
>> **************************
>> Steps taken so far:
>>
>> - create home directory (/apps/umlaut)
>>
>> - cd /apps/umlaut
>>
>> - svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>
>> - ./script/generate umlaut_local
>>
>> - mysqladmin -u root -p create umlaut_dev and umlaut_test, and umlaut
>>
>> - modified /config/umlaut_config/database.yml
>>
>> - rake db:migrate
>>
>>
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Tuesday, November 25, 2008 10:05 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Rails 2.x code committed.
>>
>> Should be fixed. Just run "svn up" in your working directory, and try
>> running "./script/generate umlaut_local" again, and proceed until the
>> next problem, heh.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>> Jonathan,
>>>
>>> Thanks for getting the new version out so quickly. I have wiped out
>>>
>> my
>>
>>> installation and started from scratch. Here is what I have done so
>>>
>> far
>>
>>> and the results --sadly an error.
>>>
>>> - gem install rails -v 2.1.1 (actually should be 2.1.2)
>>> -cd /apps/umlaut
>>> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>> - ./script/generate umlaut_local
>>>
>>>
>>> bash-3.00# ./script/generate umlaut_local
>>> No such file or directory -
>>> /apps/umlaut/config/umlaut_config/initializers/umlaut
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 5:39 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: [Umlaut-general] Rails 2.x code committed.
>>>
>>> 'svn up' on an svn working copy will get you Umlaut code updated to
>>>
>> work
>>
>>> with Rails 2. All wiki documentation has been updated appropriately,
>>>
>> but
>>
>>> some changes to be aware of:
>>>
>>> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>>> 2. Generate local files with ./script/generate umlaut_local, not the
>>> rake task as previously. This will create somewhat different config
>>> files. If you haven't gotten very far with configging, I reccommend
>>> allowing the ./script/generate to overwrite all existing files, and
>>> start your local configuration from scratch. (./script/generate will
>>> prompt you whether to overwrite, or you can add a "--force" object so
>>>
>> it
>>
>>> will do so without prompting you).
>>>
>>> 3. Local configuration by and large no longer happens in
>>> config/umlaut_config/environment.rb, instead it happens in several
>>>
>> files
>>
>>> in config/umlaut_config/initializers/umlaut. See the wiki page for
>>>
>> some
>>
>>> settings you want to set:
>>>
>> http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
>>
>>> al_configuration
>>>
>>> 4. Updated the wiki page to say that a direct connection to the SFX db
>>>
>>
>>
>>> is really the _only_ way Umlaut is verified to work for 'search'
>>> functionality (A-Z list, manually entered journal title or citation).
>>>
>>
>>
>>> If this isn't available to you, though, talk to me, and other things
>>>
>> are
>>
>>> theoretically possible, just not currently verified to work.
>>>
>>> 5. When you get to deployment, there is now a 'wizard' (actually a
>>>
>> Rails
>>
>>> generator) to create some of the neccesary deploy config files for
>>>
>> you.
>>> This is good, as this is a confusing and error prone process
>>>
>> otherwise.
>>> (I needed it myself!). Documented on wiki under deployment.
>>>
>>>
>>
>>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From dale.poulter at Vanderbilt.Edu Tue Nov 25 16:03:26 2008
From: dale.poulter at Vanderbilt.Edu (Poulter, Dale)
Date: Tue, 25 Nov 2008 15:03:26 -0600
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <492C6749.9060902@jhu.edu>
References: <492B3B2F.1050402@jhu.edu><63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu><492C2211.7030206@jhu.edu><63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu><492C64A8.2020109@jhu.edu>
<492C6749.9060902@jhu.edu>
Message-ID: <63566160FBD1BE43873B5A100A4222DF08230961@mailbe17.email.Vanderbilt.edu>
That worked! I'll still send account information since it may help the
next person.
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu
-----Original Message-----
From: umlaut-general-bounces at rubyforge.org
[mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
Rochkind
Sent: Tuesday, November 25, 2008 3:00 PM
To: umlaut-general at rubyforge.org
Subject: Re: [Umlaut-general] Rails 2.x code committed.
Yeah, I still can't reproduce you're issue, but I'll scour the code
anyway looking for something that might have caused it.
As a workaround, and another data point, instead of using 'migrate' to
create your database, you should be able to run (from Umlaut home
directory):
rake db:schema:load
That should get your db loaded too, but won't let you merge in new
changes in future db versions as easily. But try that, and see what that
does, just for comparison. For me, "rake db:schema:load" and "rake
db:migrate" both work fine.
Jonathan
Jonathan Rochkind wrote:
> Drat. It looks like I have:
>
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using
> readline 5.0
>
>
> I will try again to reproduce your problem from a clean-slate
> database. And google around to see if anyone else has encountered
this.
> I don't understand how that index name can already exist when running
> the migration on a clean-slate database. Seems like it must be a bug
> in my migration code, but I don't understand why I'm not able to
> duplicate it on my machine. I'll mess around on my machine and see if
> I can reproduce.
>
> Jonathan
>
> Poulter, Dale wrote:
>> I am now getting the same error as before, any suggestions? What
>> version of mysql are you using?
>>
>> bash-3.00$ rake db:migrate (in /apps/umlaut)
>> == 10 AddSomeMissingStuff: migrating
>> ==========================================
>> -- add_index(:service_types, :service_type_value_id)
>> rake aborted!
>> Mysql::Error: Duplicate key name
>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>> `index_service_types_on_service_type_value_id` ON `service_types`
>> (`service_type_value_id`)
>>
>> (See full trace by running task with --trace)
>>
>>
>>
>>
>> **************************
>> Steps taken so far:
>>
>> - create home directory (/apps/umlaut)
>>
>> - cd /apps/umlaut
>>
>> - svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>
>> - ./script/generate umlaut_local
>>
>> - mysqladmin -u root -p create umlaut_dev and umlaut_test, and umlaut
>>
>> - modified /config/umlaut_config/database.yml
>>
>> - rake db:migrate
>>
>>
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Tuesday, November 25, 2008 10:05 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Rails 2.x code committed.
>>
>> Should be fixed. Just run "svn up" in your working directory, and try
>> running "./script/generate umlaut_local" again, and proceed until the
>> next problem, heh.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>> Jonathan,
>>>
>>> Thanks for getting the new version out so quickly. I have wiped out
>>>
>> my
>>
>>> installation and started from scratch. Here is what I have done so
>>>
>> far
>>
>>> and the results --sadly an error.
>>>
>>> - gem install rails -v 2.1.1 (actually should be 2.1.2)
>>> -cd /apps/umlaut
>>> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>> - ./script/generate umlaut_local
>>>
>>>
>>> bash-3.00# ./script/generate umlaut_local
>>> No such file or directory -
>>> /apps/umlaut/config/umlaut_config/initializers/umlaut
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 5:39 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: [Umlaut-general] Rails 2.x code committed.
>>>
>>> 'svn up' on an svn working copy will get you Umlaut code updated to
>>>
>> work
>>
>>> with Rails 2. All wiki documentation has been updated appropriately,
>>>
>> but
>>
>>> some changes to be aware of:
>>>
>>> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>>> 2. Generate local files with ./script/generate umlaut_local, not the
>>> rake task as previously. This will create somewhat different config
>>> files. If you haven't gotten very far with configging, I reccommend
>>> allowing the ./script/generate to overwrite all existing files, and
>>> start your local configuration from scratch. (./script/generate will
>>> prompt you whether to overwrite, or you can add a "--force" object
so
>>>
>> it
>>
>>> will do so without prompting you).
>>>
>>> 3. Local configuration by and large no longer happens in
>>> config/umlaut_config/environment.rb, instead it happens in several
>>>
>> files
>>
>>> in config/umlaut_config/initializers/umlaut. See the wiki page for
>>>
>> some
>>
>>> settings you want to set:
>>>
>>
http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
>>
>>> al_configuration
>>>
>>> 4. Updated the wiki page to say that a direct connection to the SFX
db
>>>
>>
>>
>>> is really the _only_ way Umlaut is verified to work for 'search'
>>> functionality (A-Z list, manually entered journal title or
citation).
>>>
>>
>>
>>> If this isn't available to you, though, talk to me, and other things
>>>
>> are
>>
>>> theoretically possible, just not currently verified to work.
>>>
>>> 5. When you get to deployment, there is now a 'wizard' (actually a
>>>
>> Rails
>>
>>> generator) to create some of the neccesary deploy config files for
>>>
>> you.
>>> This is good, as this is a confusing and error prone process
>>>
>> otherwise.
>>> (I needed it myself!). Documented on wiki under deployment.
>>>
>>>
>>
>>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
_______________________________________________
Umlaut-general mailing list
Umlaut-general at rubyforge.org
http://rubyforge.org/mailman/listinfo/umlaut-general
From rochkind at jhu.edu Tue Nov 25 16:06:18 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 16:06:18 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <492C64A8.2020109@jhu.edu>
References: <492B3B2F.1050402@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
<492C2211.7030206@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu>
<492C64A8.2020109@jhu.edu>
Message-ID: <492C68CA.3040204@jhu.edu>
Ooh, also you DO need innodb support in your MySQL. If that's not part
of MySQL by default (I'm not sure), that could be it, and I should add
that to the instructions.
Jonathan
Jonathan Rochkind wrote:
> Drat. It looks like I have:
>
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using
> readline 5.0
>
>
> I will try again to reproduce your problem from a clean-slate
> database. And google around to see if anyone else has encountered this.
> I don't understand how that index name can already exist when running
> the migration on a clean-slate database. Seems like it must be a bug
> in my migration code, but I don't understand why I'm not able to
> duplicate it on my machine. I'll mess around on my machine and see if
> I can reproduce.
>
> Jonathan
>
> Poulter, Dale wrote:
>> I am now getting the same error as before, any suggestions? What
>> version of mysql are you using?
>>
>> bash-3.00$ rake db:migrate (in /apps/umlaut)
>> == 10 AddSomeMissingStuff: migrating
>> ==========================================
>> -- add_index(:service_types, :service_type_value_id)
>> rake aborted!
>> Mysql::Error: Duplicate key name
>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>> `index_service_types_on_service_type_value_id` ON `service_types`
>> (`service_type_value_id`)
>>
>> (See full trace by running task with --trace)
>>
>>
>>
>>
>> **************************
>> Steps taken so far:
>>
>> - create home directory (/apps/umlaut)
>>
>> - cd /apps/umlaut
>>
>> - svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>
>> - ./script/generate umlaut_local
>>
>> - mysqladmin -u root -p create umlaut_dev and umlaut_test, and umlaut
>>
>> - modified /config/umlaut_config/database.yml
>>
>> - rake db:migrate
>>
>>
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Tuesday, November 25, 2008 10:05 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Rails 2.x code committed.
>>
>> Should be fixed. Just run "svn up" in your working directory, and try
>> running "./script/generate umlaut_local" again, and proceed until the
>> next problem, heh.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>> Jonathan,
>>>
>>> Thanks for getting the new version out so quickly. I have wiped out
>>>
>> my
>>
>>> installation and started from scratch. Here is what I have done so
>>>
>> far
>>
>>> and the results --sadly an error.
>>>
>>> - gem install rails -v 2.1.1 (actually should be 2.1.2)
>>> -cd /apps/umlaut
>>> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>> - ./script/generate umlaut_local
>>>
>>>
>>> bash-3.00# ./script/generate umlaut_local
>>> No such file or directory -
>>> /apps/umlaut/config/umlaut_config/initializers/umlaut
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 5:39 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: [Umlaut-general] Rails 2.x code committed.
>>>
>>> 'svn up' on an svn working copy will get you Umlaut code updated to
>>>
>> work
>>
>>> with Rails 2. All wiki documentation has been updated appropriately,
>>>
>> but
>>
>>> some changes to be aware of:
>>>
>>> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>>> 2. Generate local files with ./script/generate umlaut_local, not the
>>> rake task as previously. This will create somewhat different config
>>> files. If you haven't gotten very far with configging, I reccommend
>>> allowing the ./script/generate to overwrite all existing files, and
>>> start your local configuration from scratch. (./script/generate will
>>> prompt you whether to overwrite, or you can add a "--force" object so
>>>
>> it
>>
>>> will do so without prompting you).
>>>
>>> 3. Local configuration by and large no longer happens in
>>> config/umlaut_config/environment.rb, instead it happens in several
>>>
>> files
>>
>>> in config/umlaut_config/initializers/umlaut. See the wiki page for
>>>
>> some
>>
>>> settings you want to set:
>>>
>> http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
>>
>>> al_configuration
>>>
>>> 4. Updated the wiki page to say that a direct connection to the SFX db
>>>
>>
>>
>>> is really the _only_ way Umlaut is verified to work for 'search'
>>> functionality (A-Z list, manually entered journal title or citation).
>>>
>>
>>
>>> If this isn't available to you, though, talk to me, and other things
>>>
>> are
>>
>>> theoretically possible, just not currently verified to work.
>>>
>>> 5. When you get to deployment, there is now a 'wizard' (actually a
>>>
>> Rails
>>
>>> generator) to create some of the neccesary deploy config files for
>>>
>> you.
>>> This is good, as this is a confusing and error prone process
>>>
>> otherwise.
>>> (I needed it myself!). Documented on wiki under deployment.
>>>
>>>
>>
>>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Tue Nov 25 16:09:30 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 16:09:30 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <492C64A8.2020109@jhu.edu>
References: <492B3B2F.1050402@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
<492C2211.7030206@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu>
<492C64A8.2020109@jhu.edu>
Message-ID: <492C698A.7040902@jhu.edu>
Oh, and hey, sorry to spam my own list, but it looks like in rails2,
running "rake db:schema:load" should result in _exactly_ the same thing
as running "rake db:migrate", so if it works, you are perfect and ready
to go. Let's see if it does.
Jonathan
Jonathan Rochkind wrote:
> Drat. It looks like I have:
>
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using
> readline 5.0
>
>
> I will try again to reproduce your problem from a clean-slate
> database. And google around to see if anyone else has encountered this.
> I don't understand how that index name can already exist when running
> the migration on a clean-slate database. Seems like it must be a bug
> in my migration code, but I don't understand why I'm not able to
> duplicate it on my machine. I'll mess around on my machine and see if
> I can reproduce.
>
> Jonathan
>
> Poulter, Dale wrote:
>> I am now getting the same error as before, any suggestions? What
>> version of mysql are you using?
>>
>> bash-3.00$ rake db:migrate (in /apps/umlaut)
>> == 10 AddSomeMissingStuff: migrating
>> ==========================================
>> -- add_index(:service_types, :service_type_value_id)
>> rake aborted!
>> Mysql::Error: Duplicate key name
>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>> `index_service_types_on_service_type_value_id` ON `service_types`
>> (`service_type_value_id`)
>>
>> (See full trace by running task with --trace)
>>
>>
>>
>>
>> **************************
>> Steps taken so far:
>>
>> - create home directory (/apps/umlaut)
>>
>> - cd /apps/umlaut
>>
>> - svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>
>> - ./script/generate umlaut_local
>>
>> - mysqladmin -u root -p create umlaut_dev and umlaut_test, and umlaut
>>
>> - modified /config/umlaut_config/database.yml
>>
>> - rake db:migrate
>>
>>
>>
>>
>> --Dale
>>
>> ---------------------------------------
>> Dale Poulter
>> Automation Coordinator
>> Library Information Technology Services
>> Vanderbilt University
>> Suite 700
>> 110 21st Avenue South
>> Nashville, TN 37240
>> (615)343-5388
>> (615)343-8834 (fax)
>> (615)207-9705 (cell)
>> dale.poulter at vanderbilt.edu
>>
>> -----Original Message-----
>> From: umlaut-general-bounces at rubyforge.org
>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>> Rochkind
>> Sent: Tuesday, November 25, 2008 10:05 AM
>> To: umlaut-general at rubyforge.org
>> Subject: Re: [Umlaut-general] Rails 2.x code committed.
>>
>> Should be fixed. Just run "svn up" in your working directory, and try
>> running "./script/generate umlaut_local" again, and proceed until the
>> next problem, heh.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>> Jonathan,
>>>
>>> Thanks for getting the new version out so quickly. I have wiped out
>>>
>> my
>>
>>> installation and started from scratch. Here is what I have done so
>>>
>> far
>>
>>> and the results --sadly an error.
>>>
>>> - gem install rails -v 2.1.1 (actually should be 2.1.2)
>>> -cd /apps/umlaut
>>> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>> - ./script/generate umlaut_local
>>>
>>>
>>> bash-3.00# ./script/generate umlaut_local
>>> No such file or directory -
>>> /apps/umlaut/config/umlaut_config/initializers/umlaut
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Monday, November 24, 2008 5:39 PM
>>> To: umlaut-general at rubyforge.org
>>> Subject: [Umlaut-general] Rails 2.x code committed.
>>>
>>> 'svn up' on an svn working copy will get you Umlaut code updated to
>>>
>> work
>>
>>> with Rails 2. All wiki documentation has been updated appropriately,
>>>
>> but
>>
>>> some changes to be aware of:
>>>
>>> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>>> 2. Generate local files with ./script/generate umlaut_local, not the
>>> rake task as previously. This will create somewhat different config
>>> files. If you haven't gotten very far with configging, I reccommend
>>> allowing the ./script/generate to overwrite all existing files, and
>>> start your local configuration from scratch. (./script/generate will
>>> prompt you whether to overwrite, or you can add a "--force" object so
>>>
>> it
>>
>>> will do so without prompting you).
>>>
>>> 3. Local configuration by and large no longer happens in
>>> config/umlaut_config/environment.rb, instead it happens in several
>>>
>> files
>>
>>> in config/umlaut_config/initializers/umlaut. See the wiki page for
>>>
>> some
>>
>>> settings you want to set:
>>>
>> http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
>>
>>> al_configuration
>>>
>>> 4. Updated the wiki page to say that a direct connection to the SFX db
>>>
>>
>>
>>> is really the _only_ way Umlaut is verified to work for 'search'
>>> functionality (A-Z list, manually entered journal title or citation).
>>>
>>
>>
>>> If this isn't available to you, though, talk to me, and other things
>>>
>> are
>>
>>> theoretically possible, just not currently verified to work.
>>>
>>> 5. When you get to deployment, there is now a 'wizard' (actually a
>>>
>> Rails
>>
>>> generator) to create some of the neccesary deploy config files for
>>>
>> you.
>>> This is good, as this is a confusing and error prone process
>>>
>> otherwise.
>>> (I needed it myself!). Documented on wiki under deployment.
>>>
>>>
>>
>>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu
From rochkind at jhu.edu Tue Nov 25 16:16:26 2008
From: rochkind at jhu.edu (Jonathan Rochkind)
Date: Tue, 25 Nov 2008 16:16:26 -0500
Subject: [Umlaut-general] Rails 2.x code committed.
In-Reply-To: <63566160FBD1BE43873B5A100A4222DF08230961@mailbe17.email.Vanderbilt.edu>
References: <492B3B2F.1050402@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DB067@mailbe17.email.Vanderbilt.edu>
<492C2211.7030206@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF081DBA55@mailbe17.email.Vanderbilt.edu>
<492C64A8.2020109@jhu.edu> <492C6749.9060902@jhu.edu>
<63566160FBD1BE43873B5A100A4222DF08230961@mailbe17.email.Vanderbilt.edu>
Message-ID: <492C6B2A.10703@jhu.edu>
Excellent! It looks like on Rails2, unlike Rails1, "rake
db:schema:load" gets you to exactly the same place as "rake
db:migrate". It does include versioning information in your db, so you
will still be able to easily apply db changes in future versions when
they come out. So I'll probably change my instructions on the wiki to
use db:schema:load instead, since it seems more robust.
Clearly some bug I have in my migrations, but I don't know what, oh
well, good enough for now!
Don't forget to run:
rake db:schema:load RAILS_ENV=production
to load the db schema in your production db too, if you want a seperate
production and dev db.
Jonathan
Poulter, Dale wrote:
> That worked! I'll still send account information since it may help the
> next person.
>
> --Dale
>
> ---------------------------------------
> Dale Poulter
> Automation Coordinator
> Library Information Technology Services
> Vanderbilt University
> Suite 700
> 110 21st Avenue South
> Nashville, TN 37240
> (615)343-5388
> (615)343-8834 (fax)
> (615)207-9705 (cell)
> dale.poulter at vanderbilt.edu
>
> -----Original Message-----
> From: umlaut-general-bounces at rubyforge.org
> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
> Rochkind
> Sent: Tuesday, November 25, 2008 3:00 PM
> To: umlaut-general at rubyforge.org
> Subject: Re: [Umlaut-general] Rails 2.x code committed.
>
> Yeah, I still can't reproduce you're issue, but I'll scour the code
> anyway looking for something that might have caused it.
>
> As a workaround, and another data point, instead of using 'migrate' to
> create your database, you should be able to run (from Umlaut home
> directory):
>
> rake db:schema:load
>
> That should get your db loaded too, but won't let you merge in new
> changes in future db versions as easily. But try that, and see what that
>
> does, just for comparison. For me, "rake db:schema:load" and "rake
> db:migrate" both work fine.
>
> Jonathan
>
>
>
> Jonathan Rochkind wrote:
>
>> Drat. It looks like I have:
>>
>> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using
>> readline 5.0
>>
>>
>> I will try again to reproduce your problem from a clean-slate
>> database. And google around to see if anyone else has encountered
>>
> this.
>
>> I don't understand how that index name can already exist when running
>> the migration on a clean-slate database. Seems like it must be a bug
>> in my migration code, but I don't understand why I'm not able to
>> duplicate it on my machine. I'll mess around on my machine and see if
>> I can reproduce.
>>
>> Jonathan
>>
>> Poulter, Dale wrote:
>>
>>> I am now getting the same error as before, any suggestions? What
>>> version of mysql are you using?
>>>
>>> bash-3.00$ rake db:migrate (in /apps/umlaut)
>>> == 10 AddSomeMissingStuff: migrating
>>> ==========================================
>>> -- add_index(:service_types, :service_type_value_id)
>>> rake aborted!
>>> Mysql::Error: Duplicate key name
>>> 'index_service_types_on_service_type_value_id': CREATE INDEX
>>> `index_service_types_on_service_type_value_id` ON `service_types`
>>> (`service_type_value_id`)
>>>
>>> (See full trace by running task with --trace)
>>>
>>>
>>>
>>>
>>> **************************
>>> Steps taken so far:
>>>
>>> - create home directory (/apps/umlaut)
>>>
>>> - cd /apps/umlaut
>>>
>>> - svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>>
>>> - ./script/generate umlaut_local
>>>
>>> - mysqladmin -u root -p create umlaut_dev and umlaut_test, and umlaut
>>>
>>> - modified /config/umlaut_config/database.yml
>>>
>>> - rake db:migrate
>>>
>>>
>>>
>>>
>>> --Dale
>>>
>>> ---------------------------------------
>>> Dale Poulter
>>> Automation Coordinator
>>> Library Information Technology Services
>>> Vanderbilt University
>>> Suite 700
>>> 110 21st Avenue South
>>> Nashville, TN 37240
>>> (615)343-5388
>>> (615)343-8834 (fax)
>>> (615)207-9705 (cell)
>>> dale.poulter at vanderbilt.edu
>>>
>>> -----Original Message-----
>>> From: umlaut-general-bounces at rubyforge.org
>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>> Rochkind
>>> Sent: Tuesday, November 25, 2008 10:05 AM
>>> To: umlaut-general at rubyforge.org
>>> Subject: Re: [Umlaut-general] Rails 2.x code committed.
>>>
>>> Should be fixed. Just run "svn up" in your working directory, and try
>>>
>
>
>>> running "./script/generate umlaut_local" again, and proceed until the
>>>
>
>
>>> next problem, heh.
>>>
>>> Jonathan
>>>
>>> Poulter, Dale wrote:
>>>
>>>
>>>> Jonathan,
>>>>
>>>> Thanks for getting the new version out so quickly. I have wiped out
>>>>
>>>>
>>> my
>>>
>>>
>>>> installation and started from scratch. Here is what I have done so
>>>>
>>>>
>>> far
>>>
>>>
>>>> and the results --sadly an error.
>>>>
>>>> - gem install rails -v 2.1.1 (actually should be 2.1.2)
>>>> -cd /apps/umlaut
>>>> -svn checkout http://umlaut.rubyforge.org/svn/trunk/ .
>>>> - ./script/generate umlaut_local
>>>>
>>>>
>>>> bash-3.00# ./script/generate umlaut_local
>>>> No such file or directory -
>>>> /apps/umlaut/config/umlaut_config/initializers/umlaut
>>>>
>>>> --Dale
>>>>
>>>> ---------------------------------------
>>>> Dale Poulter
>>>> Automation Coordinator
>>>> Library Information Technology Services
>>>> Vanderbilt University
>>>> Suite 700
>>>> 110 21st Avenue South
>>>> Nashville, TN 37240
>>>> (615)343-5388
>>>> (615)343-8834 (fax)
>>>> (615)207-9705 (cell)
>>>> dale.poulter at vanderbilt.edu
>>>>
>>>> -----Original Message-----
>>>> From: umlaut-general-bounces at rubyforge.org
>>>> [mailto:umlaut-general-bounces at rubyforge.org] On Behalf Of Jonathan
>>>> Rochkind
>>>> Sent: Monday, November 24, 2008 5:39 PM
>>>> To: umlaut-general at rubyforge.org
>>>> Subject: [Umlaut-general] Rails 2.x code committed.
>>>>
>>>> 'svn up' on an svn working copy will get you Umlaut code updated to
>>>>
>>>>
>>> work
>>>
>>>
>>>> with Rails 2. All wiki documentation has been updated appropriately,
>>>>
>>>>
>>> but
>>>
>>>
>>>> some changes to be aware of:
>>>>
>>>> 1. Now requires Rails 2.1.2. "sudo gem install rails -v 2.1.1".
>>>> 2. Generate local files with ./script/generate umlaut_local, not the
>>>>
>
>
>>>> rake task as previously. This will create somewhat different config
>>>> files. If you haven't gotten very far with configging, I reccommend
>>>> allowing the ./script/generate to overwrite all existing files, and
>>>> start your local configuration from scratch. (./script/generate will
>>>>
>
>
>>>> prompt you whether to overwrite, or you can add a "--force" object
>>>>
> so
>
>>>>
>>>>
>>> it
>>>
>>>
>>>> will do so without prompting you).
>>>>
>>>> 3. Local configuration by and large no longer happens in
>>>> config/umlaut_config/environment.rb, instead it happens in several
>>>>
>>>>
>>> files
>>>
>>>
>>>> in config/umlaut_config/initializers/umlaut. See the wiki page for
>>>>
>>>>
>>> some
>>>
>>>
>>>> settings you want to set:
>>>>
>>>>
> http://wiki.code4lib.org/index.php/Umlaut_Setup#6._Review_additional_loc
>
>>>
>>>
>>>> al_configuration
>>>>
>>>> 4. Updated the wiki page to say that a direct connection to the SFX
>>>>
> db
>
>>>>
>>>>
>>>
>>>
>>>> is really the _only_ way Umlaut is verified to work for 'search'
>>>> functionality (A-Z list, manually entered journal title or
>>>>
> citation).
>
>>>>
>>>>
>>>
>>>
>>>> If this isn't available to you, though, talk to me, and other things
>>>>
>>>>
>>> are
>>>
>>>
>>>> theoretically possible, just not currently verified to work.
>>>>
>>>> 5. When you get to deployment, there is now a 'wizard' (actually a
>>>>
>>>>
>>> Rails
>>>
>>>
>>>> generator) to create some of the neccesary deploy config files for
>>>>
>>>>
>>> you.
>>>
>>>> This is good, as this is a confusing and error prone process
>>>>
>>>>
>>> otherwise.
>>>
>>>> (I needed it myself!). Documented on wiki under deployment.
>>>>
>>>>
>>>>
>>>
>>>
>
>
--
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886
rochkind (at) jhu.edu