[Dspace-tech] Migrating data from Postgres to Oracle in DSpace 1.4.1
Hello, We are about to upgrade our DSpace installation from 1.3.1 to 1.4.1 and also want to move our data from the Postgres database to an Oracle database. What things should we be aware of when doing this data migration? What are the steps involved? Also, should the migration to Oracle take place before or after our DSpace update? Regards, Shaun. Education is only the beginning. Let's get on with it. Swinburne University of Technology CRICOS Provider Code: 00111D NOTICE This e-mail and any attachments are confidential and intended only for the use of the addressee. They may contain information that is privileged or protected by copyright. If you are not the intended recipient, any dissemination, distribution, printing, copying or use is strictly prohibited. The University does not warrant that this e-mail and any attachments are secure and there is also a risk that it may be corrupted in transmission. It is your responsibility to check any attachments for viruses or defects before opening them. If you have received this transmission in error, please contact us on +61 3 9214 8000 and delete it immediately from your system. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. Please consider the environment before printing this email. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] dspace default statistics
In the default dspace installation, what exactly does the error below mean? Passed log directory is not a directory According to the install documentation. All one would have to do is customize the perl scripts stat-general etc., My assumptions here are one is supposed to set the directory in dstat.cfg to point to the location of the file dspace.log -yes? Certainly the original file seems to suggest that. With that done the perl scripts will run. I am running this in dspace 1.3.n thanks in advance. ./fxk - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] [Dspace-devel] DSpace 1.4.2
Just trying to get more scope for those who don't have time to review it or are unfamiliar with ICU4J. (Note Eclipse uses ICU4J in its default platform to allow better UTF-8 support, I have no problem with using it). thanks, Mark On Apr 4, 2007, at 11:25 AM, Graham Triggs wrote: > Hi, > > Unfortunately, the necessary Normalizer classes (java.text.Normalizer) > only formally entered the Java platform API as part of Java 6. See: > > http://java.sun.com/developer/technicalArticles/javase/i18n_enhance/ > > > The unofficial, undocumented sun.text.Normalizer appears to exist > in all > Sun Java2 platforms (I won't predict whether it exists in non-Sun > implementations), and should be usable for our purposes in at least > Java > 1.3. See: > > http://lists.limewire.org/pipermail/codepatch/2003-March/74.html > > > But relying on sun.text.* classes is really bad form. Despite it > appearing to be a rather nominal distinction (according to the above > post), it would be more reliable to depend on ICU4J until such a time > that Java 6 became a requirement. > > I'm not sure why you've mentioned the XMLUI at this point - > although it > produces a visible change, all* the changes exist entirely inside the > Java code, and what is written to the database browse tables. So > whether > you have the XMLUI or JSP, shouldn't make any difference - but if you > are thinking of some other aspect that I haven't considered, please > say > so. > > * In fact, the patch only makes one-line changes to Browse.java in > three > places (where it inserts data into the tables). Everything else is > additional code, except for ONE change to a JSP file, to in the admin > tools to apply the same normalisation to the author name being entered > for lookup, as it uses the sort_author column in the ItemsByAuthor > table. > > Note that the above does mean that it needs to be integrated with > Richard's patch when that is ready, but on the basis of what is > currently available I've already designed this to have as little > impact > as possible. > > G > > On Wed, 2007-04-04 at 10:57 -0400, Mark Diggory wrote: >> Is ICU4J a requirement still if we switch to Java 5? In which case >> I'd push this off to DSpace1.5 (which will require Java 5 or >> greater). And if so, it should probably be the case that we explore >> its implementation in the XMLUI if any at all changes are needed. >> >> -Mark >> >> On Apr 4, 2007, at 4:53 AM, Graham Triggs wrote: > > > -- > --- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to > share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php? > page=join.php&p=sourceforge&CID=DEVDEV > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech ~ Mark R. Diggory - DSpace Systems Manager MIT Libraries, Systems and Technology Services Massachusetts Institute of Technology Office: E25-131 Phone: (617) 253-1096 - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] [Dspace-devel] DSpace 1.4.2
Hi, Unfortunately, the necessary Normalizer classes (java.text.Normalizer) only formally entered the Java platform API as part of Java 6. See: http://java.sun.com/developer/technicalArticles/javase/i18n_enhance/ The unofficial, undocumented sun.text.Normalizer appears to exist in all Sun Java2 platforms (I won't predict whether it exists in non-Sun implementations), and should be usable for our purposes in at least Java 1.3. See: http://lists.limewire.org/pipermail/codepatch/2003-March/74.html But relying on sun.text.* classes is really bad form. Despite it appearing to be a rather nominal distinction (according to the above post), it would be more reliable to depend on ICU4J until such a time that Java 6 became a requirement. I'm not sure why you've mentioned the XMLUI at this point - although it produces a visible change, all* the changes exist entirely inside the Java code, and what is written to the database browse tables. So whether you have the XMLUI or JSP, shouldn't make any difference - but if you are thinking of some other aspect that I haven't considered, please say so. * In fact, the patch only makes one-line changes to Browse.java in three places (where it inserts data into the tables). Everything else is additional code, except for ONE change to a JSP file, to in the admin tools to apply the same normalisation to the author name being entered for lookup, as it uses the sort_author column in the ItemsByAuthor table. Note that the above does mean that it needs to be integrated with Richard's patch when that is ready, but on the basis of what is currently available I've already designed this to have as little impact as possible. G On Wed, 2007-04-04 at 10:57 -0400, Mark Diggory wrote: > Is ICU4J a requirement still if we switch to Java 5? In which case > I'd push this off to DSpace1.5 (which will require Java 5 or > greater). And if so, it should probably be the case that we explore > its implementation in the XMLUI if any at all changes are needed. > > -Mark > > On Apr 4, 2007, at 4:53 AM, Graham Triggs wrote: - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] [Dspace-devel] DSpace 1.4.2
Is ICU4J a requirement still if we switch to Java 5? In which case I'd push this off to DSpace1.5 (which will require Java 5 or greater). And if so, it should probably be the case that we explore its implementation in the XMLUI if any at all changes are needed. -Mark On Apr 4, 2007, at 4:53 AM, Graham Triggs wrote: > I wasn't going to push this patch earlier as it rather evolved into a > feature enhancement - but thinking about it again, for anyone that has > non-English content/authors in their repository, it's actually a > useful > bug fix: > > [ 1672065 ] Configurable sort order generation for browse > http://sourceforge.net/tracker/index.php? > func=detail&aid=1672065&group_id=19984&atid=319984 > > If you look at the example Shawna has (it's either on this page, or > the > next): > https://dspace.ucalgary.ca/browse-author?top=Austad%2C+Michele+L > > The author Žekulin appears in the middle of the list of authors > beginning with 'A'. It may not be possible to define a single correct > ordering, but in this case the existing behaviour just doesn't work > for > anyone. > > Amongst it's other capabilities, the above patch deals with this > scenario, and lets people customise the ordering further if they > choose. > > Whilst it allows for configuration, it does not require any > configuration changes (closely emulating the existing DSpace > behaviour - > except for the addition of the character decomposition for the above > case). It also doesn't change any existing APIs, or the database > schema. > > The single biggest argument against it's inclusion would be that it > adds > an additional dependency: ICU4J. Unfortunate, but required for > compatibility with earlier JDK releases, without resorting to > undocumented Sun classes. > > The choice, as they say, is yours... ;-) > > G > > -- > Graham Triggs > Technical Architect > Open Repository > > Tel: +44 (0)20 7631 9942 > Skype: grahamtriggs > > On Mon, 2007-04-02 at 10:19 +0100, James Rutherford wrote: >> Hi All, >> >> I'm pleased to announce that work has started on putting together >> DSpace >> 1.4.2. We're aiming to get a beta release out around the 23rd, >> with the >> final release available shortly after (hopefully by the end of the >> month). This will be pretty much exclusively a bugfix release; there >> will be no API, configuration, or database schema changes, so >> upgrading >> from 1.4 or 1.4.1 should be relatively painless. If anyone is >> sitting on >> patches that they think would be suitable for inclusion, please >> upload >> them to SourceForge by the end of the week. >> >> See http://wiki.dspace.org/index.php/RoadMap#Version_1.4.2 for more >> information. >> >> cheers, >> >> Jim >> > > > -- > --- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to > share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php? > page=join.php&p=sourceforge&CID=DEVDEV > ___ > Dspace-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/dspace-devel ~ Mark R. Diggory - DSpace Systems Manager MIT Libraries, Systems and Technology Services Massachusetts Institute of Technology Office: E25-131 Phone: (617) 253-1096 - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] inser/delete into the metadatavalue table
I sent this question out a few days ago, and did not hear anything. If some one has some info on it, could you let me know. Thanks! _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jose Blanco Sent: Monday, April 02, 2007 12:53 PM To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] inser/delete into the metadatavalue table I have a big chunk of items I would like to add and delete metadata to. Previously I have updated the metadatavalue table when I have just wanted to do updates to certain metadata values, and then ran index-all, but I have never done inserts and deletes to this table via a script, and I want to make sure this will not cause any problems. Could some one let me know if this is safe to do? Thanks! Jose - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Install help
Hi, The default installation of Tomcat5.5 on Debian has the Java Security Manager enabled - however it won't have any (appropriate) policies defined. As such, it is disallowing the ConfigurationManager from reading the system property "dspace.configuration". You either need to disable the security manager, or specify a policy to allow access. Disable security manager: edit /etc/init.d/tomcat5.5 and set "TOMCAT5_SECURITY" to "NO". Adding a policy should be something like: create /etc/tomcat5.5/policy.d/05dspace.policy with the contents: grant codebase "file:${catalina.home}/webapps/dspace/-" { permission java.security.AllPermission; }; This was taken from: http://forums.pentaho.org/showthread.php?p=157283 Someone will probably shout if it's wrong! G -- Graham Triggs Technical Architect Open Repository Tel: +44 (0)20 7631 9942 Skype: grahamtriggs On Tue, 2007-04-03 at 14:11 -0400, Joel Gwynn wrote: > Hi all. Just dropping in for some quick install/config help. > > I've installed dspace 1.4.1 with Tomcat 5 on Ubuntu Linux. I think > I'm about to be up and running, but when I fire up > http://localhost:8180/dspace (debian runs tomcat on 8180) I get these > errors: > > java.security.AccessControlException: access denied > (java.util.PropertyPermission dspace.configuration read) > > java.security.AccessControlContext.checkPermission(AccessControlContext.java:264) > > java.security.AccessController.checkPermission(AccessController.java:427) > java.lang.SecurityManager.checkPermission(SecurityManager.java:532) > > java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1285) > > etc. I assume that I'm missing something with permissions. In my > tomcat /etc/init.d/tomcat5 I set tomcat to run as the dspace user like > so: > > TOMCAT5_USER=dspace > > Is there something else I need to do? > > TIA > Joel > > - > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech This e-mail is confidential and should not be used by anyone who is not the original intended recipient. BioMed Central Limited does not accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of BioMed Central Limited. No contracts may be concluded on behalf of BioMed Central Limited by means of e-mail communication. BioMed Central Limited Registered in England and Wales with registered number 3680030 Registered Office Middlesex House, 34-42 Cleveland Street, London W1T 4LB - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] [Dspace-devel] DSpace 1.4.2
I wasn't going to push this patch earlier as it rather evolved into a feature enhancement - but thinking about it again, for anyone that has non-English content/authors in their repository, it's actually a useful bug fix: [ 1672065 ] Configurable sort order generation for browse http://sourceforge.net/tracker/index.php?func=detail&aid=1672065&group_id=19984&atid=319984 If you look at the example Shawna has (it's either on this page, or the next): https://dspace.ucalgary.ca/browse-author?top=Austad%2C+Michele+L The author Žekulin appears in the middle of the list of authors beginning with 'A'. It may not be possible to define a single correct ordering, but in this case the existing behaviour just doesn't work for anyone. Amongst it's other capabilities, the above patch deals with this scenario, and lets people customise the ordering further if they choose. Whilst it allows for configuration, it does not require any configuration changes (closely emulating the existing DSpace behaviour - except for the addition of the character decomposition for the above case). It also doesn't change any existing APIs, or the database schema. The single biggest argument against it's inclusion would be that it adds an additional dependency: ICU4J. Unfortunate, but required for compatibility with earlier JDK releases, without resorting to undocumented Sun classes. The choice, as they say, is yours... ;-) G -- Graham Triggs Technical Architect Open Repository Tel: +44 (0)20 7631 9942 Skype: grahamtriggs On Mon, 2007-04-02 at 10:19 +0100, James Rutherford wrote: > Hi All, > > I'm pleased to announce that work has started on putting together DSpace > 1.4.2. We're aiming to get a beta release out around the 23rd, with the > final release available shortly after (hopefully by the end of the > month). This will be pretty much exclusively a bugfix release; there > will be no API, configuration, or database schema changes, so upgrading > from 1.4 or 1.4.1 should be relatively painless. If anyone is sitting on > patches that they think would be suitable for inclusion, please upload > them to SourceForge by the end of the week. > > See http://wiki.dspace.org/index.php/RoadMap#Version_1.4.2 for more > information. > > cheers, > > Jim > - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech