Re: [dspace-tech] Browse "By Type"
Unbelievable - that worked! I've been fighting this issue for over a month. The cocoon cache is in a completely different directory hierarchy (Tomcat is separate from DSpace) so I don't know if I ever would've thought of that. Thank you. On Tuesday, August 8, 2017 at 4:03:58 PM UTC-8, Terry Brady wrote: > I see that the type facet is available for your whole repository: > http://dspace31b.library.uaf.edu:8080/xmlui/browse?type=type > > I wonder if this is an issue with your Cocoon cache. > > Here is something simple to try. Sign into DSpace as an administrator. > Go to Control Panel->Java Information and then click "Clear Cache > Immediately". > > Terry > > On Tue, Aug 8, 2017 at 3:52 PM, Walter Rutherford > wrote: > >> >> We're moving an existing site and I'll be managing it once we get the >> duplicate site working >> I have the new site *almost* identical to the original but I'm having >> issues adding the By Type >> browsing link. >> >> I modified the dspace.cfg file to add a new webui.browse.index entry: >> webui.browse.index.1 = dateissued:item:dateissued >> webui.browse.index.2 = author:metadata:dc.contributor.*,dc.creator:text >> webui.browse.index.3 = title:item:title >> webui.browse.index.4 = subject:metadata:dc.subject.*:text >> * webui.browse.index.5 = type:metadata:dc.type:text* >> >> And added new entries to the messages.xml file: >> *By >> Type* >> >> >> *> key="xmlui.ArtifactBrowser.ConfigurableBrowse.type.column_heading">Type* >> >> >> *> key="xmlui.ArtifactBrowser.ConfigurableBrowse.title.metadata.type">Browsing >> {0} by Type {1}> key="xmlui.ArtifactBrowser.ConfigurableBrowse.trail.metadata.type">Browsing >> {0} by Type* >> >> >> Then, (following what worked for someone else in this group with the same >> problem): >>> stopped tomcat >>$ dspace index-init >>> restarted tomcat [no change to website] >>$ dspace update-discovery-index - b >>> [Still no change] >> >> Almost identical >> Original: https://scholarworks.alaska.edu/ >> Duplicate: http://dspace31b.library.uaf.edu:8080/xmlui >> >> On the top page the "By Type" link doesn't exist on the duplicate site >> *but*, strangely, >> it DOES show up on lower pages so I'm doing something right. I haven't >> found a >> configuration option that treats the home page any differently than other >> pages on >> the site. >> >> What am I missing? >> >> Thank you. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to dspace-tech...@googlegroups.com . >> To post to this group, send email to dspac...@googlegroups.com >> . >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Terry Brady > Applications Programmer Analyst > Georgetown University Library Information Technology > http://georgetown-university-libraries.github.io/ > 425-298-5498 (Seattle, WA) > -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Browse "By Type"
We're moving an existing site and I'll be managing it once we get the duplicate site working I have the new site *almost* identical to the original but I'm having issues adding the By Type browsing link. I modified the dspace.cfg file to add a new webui.browse.index entry: webui.browse.index.1 = dateissued:item:dateissued webui.browse.index.2 = author:metadata:dc.contributor.*,dc.creator:text webui.browse.index.3 = title:item:title webui.browse.index.4 = subject:metadata:dc.subject.*:text * webui.browse.index.5 = type:metadata:dc.type:text* And added new entries to the messages.xml file: *By Type* *Type* *Browsing {0} by Type {1}Browsing {0} by Type* Then, (following what worked for someone else in this group with the same problem): > stopped tomcat $ dspace index-init > restarted tomcat [no change to website] $ dspace update-discovery-index - b > [Still no change] Almost identical Original: https://scholarworks.alaska.edu/ Duplicate: http://dspace31b.library.uaf.edu:8080/xmlui On the top page the "By Type" link doesn't exist on the duplicate site *but*, strangely, it DOES show up on lower pages so I'm doing something right. I haven't found a configuration option that treats the home page any differently than other pages on the site. What am I missing? Thank you. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
Re: [dspace-tech] Problems ingesting a postgres database dump
Ah. Thank you. I got distracted by the finish line. The dump file looked pretty standard, like it should be readable directly into the database (and it was, mostly) but I forgot to recheck the DSpace6 manual. We're using DSpace6 but the original we're duplicating is DSpace5. And that explains the UUID error messages. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Problems ingesting a postgres database dump
I'm building a replacement DSpace website. I had DSpace6 installed using Tomcat 9.0.0 and it seemed to be fine. But when I loaded postgres with a dump from the original site I got some errors about variables being integers instead of uuids. I scanned the entire dump file but didn't find a single reference to uuid or UUID. I'd interrupted the dump because of the thousands of errors it was spewing. I saw that the dump begins by dropping the databases so I tried again but let it run despite the errors. It built the tables, with double the number of expected rows. Oops! I guess dropping the databases wasn't enough. So I gpt ot to drop the databases AND tables first. There were again some errors the second time but the tables were the right size. The dspace database test and email test worked just fine. I found a dspace password error in the daily log but fixed that before I went home for the day. But today when I navigated to the xmlui home page I got this: ERROR: column metadata1_.dspace_object_id does not exist Position: 345 Normally I just see a vanilla DSpace home page. I haven't seen this error before but that might be good news if it means DSpace is attempting to connect to the postgres database. Note: I first tried this out on a guinea pig system and it read the postgres dump file without any complaints (that I noticed). But that system doesn't have DSpace so it might have the same problem but it just isn't visible without DSpace. Or the issue could be just on the new system between DSpace/(omcat/java and postgres. Now I just want to start from a clean slate before continuing. Did I miss something trying to clean up the first attempt? What's the quickest, cleanest way to removed the entire dump and start over? -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: Tomcat to postgres
Thank you Claudia, that must be it. The database test succeeds but the email test fails. I believe I'm hitting a firewall issue outside of our network. That could also explain why it appeared to work once since I bet I tested the first time from a machine that didn't route beyond our network. I'll get the IT department to open the firewall for ports 8080 and 25 and try again. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Tomcat to postgres
I finally got DSpace installed without too many problems (it wouldn't configure mirage2 for some reason) and I can login via the admin account and create new users. Or so it appears. When I try to "reset password" for the new users I get a "Connection refused" error. Strangely, my first attempt earlier in the week actually sent email to the test account's email address but the link was incorrect (wrong hostname) and didn't work. It hasn't sent email since. I double-checked the pg_hba.conf settings. I'm using what was recommended for security: hostdspace dspace 127.0.0.1 255.255.255.255 md5 Tomcat runs as 'dspace' so I reset the 'dspace' password for both the Linux 'dspace' user and 'dspace' database account to make sure they matched what is configured in tomcat's local.conf file then restarted Postgresql and Tomcat. Still "connection refused" when I try to set passwords. I've convince myself that it's a Tomcat<=>Postgres disconnect, I'm just not sure what or why, especially since they're running on the same host. The fact that I'm able to login as the administrator and (appear to) create new users means Tomcat is actually connecting to the postgres database (right?) but then why does nothing else seem to work? DSpace knows about those new users but Postgres doesn't, so I believe changes are being made via Tomcat/DSpace to DSpace files but not by Tomcat/Postgres to the database. Any ideas what's going on and how to correct it? -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
Re: Re: [dspace-tech] HTTP Status 500 - The absolute uri: http://www.dspace.org/dspace-tags.tld cannot be resolved
Thank you - that was the solution to the last problem I was having, I moved xmlui up one directory level. Well, actually I created symlinks to ROOT/xmlui and ROOT/jspui from the ROOT level. That feels like a kludge but it worked. I'll have to test to see if anything else needs to move or be symlinked. I don't think I did anything wrong during the configuration steps, so why would the DSpace installation software put the necessary directories where they aren't accessible? Your post is from over a year ago and I just installed DSpace6, the current release. But to finally get it to work I had to upgrade Tomcat and openJDK to the newest releases and start fresh. So I suspect the installation documentation hasn't quite caught up with the current version of DSpace. On Saturday, January 2, 2016 at 11:53:55 PM UTC-9, a.bollini wrote: > > Hi Mohamed, > you need to move the jspui folder outside the ROOT directory or, > alternatively, move the content of the jspui folder inside the ROOT folder > i.e. one of the following path need to exists > /apache-tomcat-7.0.42/webapps/jspui/WEB-INF > > Or > /apache-tomcat-7.0.42/webapps/ROOT/WEB-INF > > If you go for the second option (preferred) you will be able to reach the > dspace webapp without using the jspui path in the browser > I.e > Xxx.xxx.xxx.xxx:8080/ > > Andrea > > > Inviato dal mio dispositivo Samsung > > > Messaggio originale > Da: Mohamad CHAITOU > > Data: 02/01/2016 22:27 (GMT+01:00) > A: DSpace Technical Support > > Cc: mohamad...@gmail.com , a.bo...@cineca.it > Oggetto: Re: [dspace-tech] HTTP Status 500 - The absolute uri: > http://www.dspace.org/dspace-tags.tld cannot be resolved > > Dear Andrea, > > The file dspace-tags.tld exists well in the WEB-INF directory: > > net@ubuntu:~/apache-tomcat-7.0.42/webapps/ROOT/jspui/WEB-INF$ *ls | grep > tld* > *dspace-tags.tld* > fmt.tld > researcher.tld > stats.tld > > Even though, the error occurs. > > I had no permission issues (I executed all commands using sudo, even > firefox I started it using gksudo) > > Tomcat runs normally. Below is what I get when I start tomcat: > > Jan 02, 2016 1:14:23 PM org.apache.catalina.startup.Catalina load > INFO: Initialization processed in 759 ms > Jan 02, 2016 1:14:24 PM org.apache.catalina.core.StandardService > startInternal > INFO: Starting service Catalina > Jan 02, 2016 1:14:24 PM org.apache.catalina.core.StandardEngine > startInternal > INFO: Starting Servlet Engine: Apache Tomcat/7.0.42 > Jan 02, 2016 1:14:24 PM org.apache.catalina.startup.HostConfig > deployDirectory > INFO: Deploying web application directory > /home/net/apache-tomcat-7.0.42/webapps/manager > Jan 02, 2016 1:14:41 PM org.apache.catalina.util.SessionIdGenerator > createSecureRandom > INFO: Creation of SecureRandom instance for session ID generation using > [SHA1PRNG] took [17,308] milliseconds. > Jan 02, 2016 1:14:41 PM org.apache.catalina.startup.HostConfig > deployDirectory > INFO: Deploying web application directory > /home/net/apache-tomcat-7.0.42/webapps/ROOT > Jan 02, 2016 1:14:41 PM org.apache.catalina.startup.HostConfig > deployDirectory > INFO: Deploying web application directory > /home/net/apache-tomcat-7.0.42/webapps/host-manager > Jan 02, 2016 1:14:42 PM org.apache.catalina.startup.HostConfig > deployDirectory > INFO: Deploying web application directory > /home/net/apache-tomcat-7.0.42/webapps/examples > Jan 02, 2016 1:14:42 PM org.apache.catalina.startup.HostConfig > deployDirectory > INFO: Deploying web application directory > /home/net/apache-tomcat-7.0.42/webapps/docs > Jan 02, 2016 1:14:42 PM org.apache.coyote.AbstractProtocol start > INFO: Starting ProtocolHandler ["http-bio-8090"] > Jan 02, 2016 1:14:42 PM org.apache.catalina.startup.Catalina start > INFO: Server startup in 18435 ms > > Any clues ? > > Thanks! > > > > On Saturday, January 2, 2016 at 10:25:15 PM UTC+2, a.bollini wrote: >> >> Dear Mohamad, >> the absolute uri that you refer is only for internal reference of the >> application and it doesn't need to exist at all. >> Can you check if additional information are available in the catalina.out >> at the starting of tomcat? A dspace-tags.tld file should be present in the >> unpackaged jspui webapp. >> It could be related to an issue with files permission. >> Hope this help, >> Andrea >> >> >> >> Inviato dal mio dispositivo Samsung >> >> >> Messaggio originale >> Da: Mohamad CHAITOU >> Data: 02/01/2016 19:49 (GMT+01:00) >> A: DSpace Technical Support >> Oggetto: [dspace-tech] HTTP Status 500 - The absolute uri: >> http://www.dspace.org/dspace-tags.tld cannot be resolved >> >> Dear All, >> >> I have been struggling since a week to solve this problem without >> success. >> I installed Dspace CRIS (4.x.x) on ubuntu inside a vmware virtual >> machine. Everything has compiled successfully. However, when I try to >> invoke Dspace from tomact it gives me the following error (plz see below). >> It seems t
[dspace-tech] Re: ant fresh_install vs postgres
*Sorry if this post is a bit chatty, but I wanted it to be helpful to anybody else who runs into the same problems.* I had some initial success and was able to complete the 'ant fresh_install'. Tomcat didn't display the default page but I think that may be because I installed it with yum rather than from source code like the manual expected and it was installed in a different directory than DSpace expected. In the end I copied the directory ant built to where tomcat expects to find its pages (symlinks didn't work) and tomcat started with the default page. But it doesn't connect to the postgres database. That may be because it's running from a new location or there's still and issue with the pg_hba.conf file. I tried connecting again as a different user as Tom suggested above and got a new error: [walter@irtest ~]$ psql -h localhost -p 5432 -d dspace -U dspace psql: FATAL: no pg_hba.conf entry for host "::1", user "dspace", database "dspace", SSL off It looks like it has skipped over the IPv4 host md5 rule and is trying to connect via IPv6. We aren't actively using IPv6 but just as a sanity check I added a new rule to the pg_hba.conf file: host dspace dspace ::1/128 md5 Then logged in as a different user. It worked. So why is it ignoring the nearly identical IPv4 host rule??? host dspace dspace 127.0.0.1 255.255.255.255md5 -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
Thanks for clarifying. Tomcat is the dspace "user" accessing the database on behalf of a person searching our repository online, so everything is local as far as the database is concerned. To clarify my side, I didn't add that 'trust' authorization rule and 6543 was a typing-in-the-dark typo by a partial touch typist who never quite mastered the top row. :-) I still have a ways to go to get Tomcat to talk to the database, but getting past that ant install was I'm sure the biggest hurdle. Thanks again. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
I've previously only interacted with DSpace as a user so please pardon the 'newb' questions. I'm trying to (re)create a repository that anyone can search via a website but only certain authorized local users can modify. Given these authentication rules: host dspace dspace 127.0.0.1 255.255.255.255md5 localall all peer host all all 127.0.0.1/32ident Aren't all the connections local, (explicitly or due to the 127 address)? When I have DSpace setup with Tomcat does the database see that as a local or host connection? Because if it's a host connection then the md5 host rule will kick in and the user will have to supply a password. And even then, given the ADDRESS it's still a local connection, right? So I assumed DSpace web connections would be translated into local (Tomcat => 'dspace') database queries/connections. If my 'dspace' database user had no authority to do anything dangerous and all access attempts are filtered through Tomcat as 'dspace' could I just 'trust' the connection since I (hopefully) can trust Tomcat? Then users wouldn't need a password to search our repository. Something like this: host dspace dspace127.0.0.1 255.255.255.255md5 localdspace dspace trust localallall peer host allall 127.0.0.1/32ident Or would that open my site up to all sorts of mischief? Note: I don't have the Tomcat interface up so I haven't yet tested any of this from a browser. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
Thank you Tom. 1) I have the md5 line in the pg_hba.conf file 3) Changed dspace.hostname to "localhost" then later to localhost (no quotes) since that's the default 4) Postgres complained with I tried to reset dspace's attributes postgres=# alter role dspace NOSUPERUSER CREATEDB NOCREATEROLE NOCREATEUSER; ERROR: conflicting or redundant options Not sure what it didn't like but, since it didn't have any superpowers before, I just added CREATEDB and that passed. 2) Now I can access the database BUT only if I don't specify '-U dspace'. [root@irtest config]# su - walter [walter@irtest ~]$ psql -h localhost -p 5432 -d dspace -U dspace psql: FATAL: Ident authentication failed for user "dspace" [walter@irtest ~]$ psql -d dspace psql (9.5.5) Type "help" for help. dspace=> \du List of roles Role name | Attributes | Member of ---++--- dspace| Create DB | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} walter|| {} dspace=> \q [walter@irtest ~]$ psql -d dspace -U dspace psql: FATAL: Peer authentication failed for user "dspace" [walter@irtest ~]$ [walter@irtest ~]$ psql -d dspace -p 5432 psql (9.5.5) Type "help" for help. dspace=> \c You are now connected to database "dspace" as user "walter". dspace=> \q [walter@irtest ~]$ The mvn command succeeded but, at first, the 'ant fresh_install' failed. :-( But I realized that was because *somebody* had stopped the database server. If failed a second time but AFTER it successfully connected to the database! That is SO much closer - Now it's only complaining about pgcrypto which I was sure I had added weeks ago. Now I wonder if I installed it on a different database. test_database: [java] 2017-01-31 13:06:47,925 WARN org.dspace.services.email.EmailServiceImpl @ Couldn't get an email session from environment: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial [java] [java] Attempting to connect to database [java] Connected successfully! [java] [java] Database Type: postgres [java] Database URL: jdbc:postgresql://localhost:5432/dspace [java] Database Schema: public [java] Database Username: dspace [java] Database Software: PostgreSQL version 9.5.5 [java] Database Driver: PostgreSQL Native Driver version PostgreSQL 9.4.1211.jre7 [java] PostgreSQL 'pgcrypto' extension installed/up-to-date? false (not installed) [java] [java] WARNING: Required PostgreSQL 'pgcrypto' extension is NOT INSTALLED on this database. [java] [java] ** DSpace REQUIRES PostgreSQL >= 9.4 AND pgcrypto extension >= 1.1 ** [java] [java] To install it, please connect to your DSpace database as a 'superuser' and manually run the following command: [java] [java] CREATE EXTENSION pgcrypto; [java] I added the pgcrypto extension and reran the ant command. Holy Smokes! It worked! BUILD SUCCESSFUL Total time: 19 seconds I haven't gotten to the part where it coordinates with Tomcat but they shouldn't conflict because the database is using port 6543 and Tomcat uses 8080. Thanks again. I'll walk through the rest of the installation. Wish me luck! -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
I remember having some difficulty during the database part of the installation. I'm tempted to rip out the database down to reinstalling Postgres and starting over. But before I do, should the dspace user have an special privileges? I didn't see where any should be set in the instructs so it looks pretty bare: > dspace=> \du >List of roles > Role name | Attributes | > Member > of > > ---++--- > > dspace|| > {} > postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | > {} > walter|| > {} > > -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
Thanks Mark and Luiz. Unless I'm misunderstanding how it reads variables I'm using almost the default values in our local.cfg file:: dspace.hostname = "irtest.library.uaf.edu" dspace.baseUrl = http://${dspace.hostname}:5432/ db.url = jdbc:postgresql://${dspace.hostname}:5432/dspace With db.username and db.password defined exactly as in the database. It appears to be choking on the dspace.hostname because I've tried both 'localhost' and the systems IP address. All that changed was the hostname specified in the java.net.UnknownHostExcpetion error message. But there are a LOT of parameters that can be tweaked so it's very possible I missed something. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
Postgres is running as a Linux service if that's what you mean. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
Sorry... Correction: "dspace.hostname" not "domain.hostname". -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
I tried some of the commented rules in pg_hba.conf. They either wouldn't allow the postgres server to restart or there was no obvious change - I continued to get the java.net.UnknownHostException error which implies to me that the authentication method isn't the immediate cause of the ant failure. It's a problem identifying the DSpace server host. I changed domain.hostname in my DSpace local.cfg to the IP address and to "localhost" and reran "mvn clean package". Each time it created the ant installer targets and each time it failed with the same error as before except the host it tried to reach changed to the IP address and "localhost". I did an nslookup for both the IP address and the hostname and they both resolve to the other so it doesn't appear DNS is the problem. It's also obvious the local.cfg file is being consulted. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
I think that all makes sense. If I'm logging in from user 'dspace' to 'dspace' in posgres it uses the peer rule and lets me in without a password. Any other user would have to be accessing their own user/database. So, how should the pg_hba.conf file be configured to allow any user to access the DSpace database via a webpage and Tomcat? -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
Yes and no. If I'm logged into Linux as user 'dspace' (which is also the name of the postgres user and database) then 'psql -U dspace' drops me in without a password. If I force a password with 'psql -U dspace -W' I can get in just fine even with an incorrect password! But if I try from another Linux login the connection fails with: psql: FATAL: Peer authentication failed for user "dspace" .The tail end of the pg_hba.conf file looks about like this: # TYPE DATABASEUSERADDRESS METHOD # Tighten security per instructions in DSpace Manual hostdspace dspace 127.0.0.1 255.255.255.255md5 #hostdspace dspace 127.0.0.1 255.255.255.255peer # "local" is for Unix domain socket connections only local all all peer #local all all trust # IPv4 local connections: hostall all 127.0.0.1/32ident # IPv6 local connections: hostall all ::1/128 ident -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Re: ant fresh_install vs postgres
This is the output from the 'ant fresh-install' command. I believe the first error is just a non-fatal WARNing, the fatal problems come when it tries to access the postgres database. But I can't tell if the problem stems from postgres, java, Maven (that created the ant files), ant, DNS, etc.. I'm new enough to both java and postgres that the error messages don't tell me anything. [dspace@irtest dspace]$ cd target/dspace-installer/ [dspace@irtest dspace-installer]$ ant fresh_install Buildfile: /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/build.xml init_installation: prepare_configs: [mkdir] Created dir: /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp [copy] Copying 157 files to /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp [copy] Copying 1 file to /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp [copy] Copying 16 files to /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp init_configs: [copy] Copying 1 file to /home/dspace/config [delete] Deleting directory /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp test_database: [java] 2017-01-30 12:14:37,830 WARN org.dspace.services.email.EmailServiceImpl @ Couldn't get an email session from environment: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial [java] [java] Error running 'test': 2017-01-30 12:14:38,542 ERROR org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against DSpace database [java] - java.sql.SQLException: Cannot create PoolableConnectionFactory (The connection attempt failed.) [java] [java] [java] Please see the DSpace documentation for assistance. [java] [java] java.sql.SQLException: Cannot create PoolableConnectionFactory (The connection attempt failed.)java.sql.SQLException: Cannot create PoolableConnectionFactory (The connection attempt failed.) [java] [java] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) [java] [java] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) [java] [java] at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) [java] at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:105) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [java] at org.dspace.storage.rdbms.DatabaseUtils.setupFlyway(DatabaseUtils.java:473) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] [java] at java.lang.reflect.Method.invoke(Method.java:606) [java] at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:98) [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) [java] Caused by: org.postgresql.util.PSQLException: The connection attempt failed. [java] [java] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) [java] [java] at org.postgresql.jdbc.PgConnection.(PgConnection.java:218) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] [java] at org.postgresql.Driver.makeConnection(Driver.java:407) [java] at org.postgresql.Driver.connect(Driver.java:275) at java.lang.reflect.Method.invoke(Method.java:606) [java] [java] at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) [java] at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) [java] [java] at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) [java] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(Basi
[dspace-tech] Re: ant fresh_install vs postgres
Thanks Luiz. I didn't recall if I created the user and DB as root so I dropped them both while logged in as 'dspace'. I'm still getting the same errors which seem to stem from this: Caused by: java.net.UnknownHostException: I've verified the hostname resolves in DNS and even added it to the /etc/hosts file and tried using the IP address for dspace.hostname in my local.cfg file. Nothing has worked so far. I'm stumped.. On Friday, January 27, 2017 at 12:58:56 PM UTC-9, Walter Rutherford wrote: > > > I've proceeded through the DSpace installation but have been stuck during > the 'ant fresh_install'. > It doesn't get very far into test_database before it has a cascade of > errors. > > [root@irtest dspace-installer]# ant fresh_install > Buildfile: > /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/build.xml > > init_installation: > > prepare_configs: > [mkdir] Created dir: > /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp > [copy] Copying 157 files to > /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp > [copy] Copying 1 file to > /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp > [copy] Copying 16 files to > /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp > > init_configs: > [copy] Copying 1 file to /home/dspace/config >[delete] Deleting directory > /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp > > test_database: > [java] 2017-01-27 12:25:08,822 WARN > org.dspace.services.email.EmailServiceImpl @ Couldn't get an email session > from environment: Need to specify class name in environment or system > property, or as an applet parameter, or in an application resource file: > java.naming.factory.initial > [java] > [java] Error running 'test': > [java] - java.sql.SQLException: Cannot create > PoolableConnectionFactory (The connection attempt failed.) > [java] > [java] Please see the DSpace documentation for assistance. > [java] > [java] java.sql.SQLException: Cannot create PoolableConnectionFactory > (The connection attempt failed.) > ... > > I suspect there's something wrong with accessing the postgres database. I > can access it from > the command-line (with or without specifying the database) but only if I > don't specify localhost. > [root@irtest dspace-installer]# psql -U dspace -h localhost > psql: FATAL: Ident authentication failed for user "dspace" > > [root@irtest dspace-installer]# psql -U dspace -W -h localhost > Password for user dspace: > psql: FATAL: Ident authentication failed for user "dspace" > > [root@irtest dspace-installer]# psql -U dspace > psql (9.5.5) > Type "help" for help. > dspace=> \q > > [root@irtest dspace-installer]# psql -U dspace -d dspace --list > List of databases >Name| Owner | Encoding | Collate |Ctype| Access > privileges > > ---+--+--+-+-+--- > dspace| dspace | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres > + >| | | | | > postgres=CTc/postgres > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres > + >| | | | | > postgres=CTc/postgres > (4 rows) > > Here are the uncommented lines from pg_hba.conf. If I recall it was > failing as 'peer' so I set local to 'trust' > [root@irtest data]# egrep -v "^#|^$" /var/lib/pgsql/9.5/data/pg_hba.conf > local all all trust > hostall all 127.0.0.1/32ident > hostall all ::1/128 ident > > I had had file ownership issues initially but I *think* I've caught all > those. > > Any assistance is greatly appreciated. Thank you. > > -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] ant fresh_install vs postgres
I've proceeded through the DSpace installation but have been stuck during the 'ant fresh_install'. It doesn't get very far into test_database before it has a cascade of errors. [root@irtest dspace-installer]# ant fresh_install Buildfile: /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/build.xml init_installation: prepare_configs: [mkdir] Created dir: /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp [copy] Copying 157 files to /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp [copy] Copying 1 file to /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp [copy] Copying 16 files to /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp init_configs: [copy] Copying 1 file to /home/dspace/config [delete] Deleting directory /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/config-temp test_database: [java] 2017-01-27 12:25:08,822 WARN org.dspace.services.email.EmailServiceImpl @ Couldn't get an email session from environment: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial [java] [java] Error running 'test': [java] - java.sql.SQLException: Cannot create PoolableConnectionFactory (The connection attempt failed.) [java] [java] Please see the DSpace documentation for assistance. [java] [java] java.sql.SQLException: Cannot create PoolableConnectionFactory (The connection attempt failed.) ... I suspect there's something wrong with accessing the postgres database. I can access it from the command-line (with or without specifying the database) but only if I don't specify localhost. [root@irtest dspace-installer]# psql -U dspace -h localhost psql: FATAL: Ident authentication failed for user "dspace" [root@irtest dspace-installer]# psql -U dspace -W -h localhost Password for user dspace: psql: FATAL: Ident authentication failed for user "dspace" [root@irtest dspace-installer]# psql -U dspace psql (9.5.5) Type "help" for help. dspace=> \q [root@irtest dspace-installer]# psql -U dspace -d dspace --list List of databases Name| Owner | Encoding | Collate |Ctype| Access privileges ---+--+--+-+-+--- dspace| dspace | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (4 rows) Here are the uncommented lines from pg_hba.conf. If I recall it was failing as 'peer' so I set local to 'trust' [root@irtest data]# egrep -v "^#|^$" /var/lib/pgsql/9.5/data/pg_hba.conf local all all trust hostall all 127.0.0.1/32ident hostall all ::1/128 ident I had had file ownership issues initially but I *think* I've caught all those. Any assistance is greatly appreciated. Thank you. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.