1. Re: collectionspace Installation Issue (Megan Forbes)

Hi Mahendra, Actually, the best thing to do may be to check to see IF the database actually exists by logging into the psql shell as cspace_default, I believe, and then solving backwards from there. Something like "psql -U cspace_default -d cspace_default" Can you try this and see what you come up with? -Yousuf On Wed, Jul 6, 2016 at 11:22 AM, Yousuf Nejati < yousuf.nejati@granitehorizon.com> wrote: > Hi Mahendra, > > Are you running the Ant command within the > ~/collectionspace-source/services directory? > > Thanks, > > Y > > > On Wed, Jul 6, 2016 at 11:12 AM, <talk-request@lists.collectionspace.org> > wrote: > >> Send Talk mailing list submissions to >> talk@lists.collectionspace.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> >> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >> >> or, via email, send a message with subject or body 'help' to >> talk-request@lists.collectionspace.org >> >> You can reach the person managing the list at >> talk-owner@lists.collectionspace.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of Talk digest..." >> >> >> Today's Topics: >> >> 1. Re: collectionspace Installation Issue (Megan Forbes) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Wed, 6 Jul 2016 18:11:20 +0000 >> From: Megan Forbes <megan.forbes@lyrasis.org> >> To: "mahendra.pratap@inficaretech.com" >> <mahendra.pratap@inficaretech.com>, "rakesh@InfiCareTech.com" >> <rakesh@InfiCareTech.com>, "CollectionSpace Talk List" >> <talk@lists.collectionspace.org> >> Subject: Re: [Talk] collectionspace Installation Issue >> Message-ID: >> < >> DM5PR08MB2409FD29ED4F98411504DB8380390@DM5PR08MB2409.namprd08.prod.outlook.com >> > >> >> Content-Type: text/plain; charset="iso-8859-1" >> >> Thank you for your email! I'm cc'ing our "talk" list here, where a >> community of developers is available to help you get your installation up >> and running. >> >> >> Best regards, >> >> Megan >> >> >> >> Megan Forbes >> CollectionSpace Program Manager >> megan.forbes@lyrasis.org >> 917.267.9676 Cell >> meganbforbes Skype >> >> >> >> >> ________________________________ >> From: mahendra.pratap@inficaretech.com <mahendra.pratap@inficaretech.com> >> Sent: Monday, July 4, 2016 10:41 AM >> To: info@collectionspace.org >> Cc: rakesh@InfiCareTech.com >> Subject: collectionspace Installation Issue >> >> Hello, >> >> I am trying to install collectionspace using Installation Guide, I done >> the Installation but when I Creating database it generate Error. >> >> ant create_db -Drecreate_db=true >> >> ant undeploy deploy create_db -Drecreate_db=true import >> >> >> database not found. >> >> >> System Requirements for a CollectionSpace Server >> ________________________________________________________- >> Linux distributions : Ubuntu 14.04 LTS >> >> >> Requirement >> >> >> Value >> >> >> Virtual memory / swap space >> >> >> Double the amount of RAM >> >> >> System Architecture >> >> >> Processor: Intel (x86), AMD64, and Intel EM64T >> >> >> Processor >> >> >> 1 GHz minimum >> >> >> Physical memory (RAM) >> >> >> 2 GB RAM (4 GB or higher strongly recommended), 1 GB cache >> >> >> Software Requirements for Installation >> >> Requirement >> >> >> Value Description >> >> >> Database system: PostgreSQL server >> >> >> PostgreSQL 9.1 or later is required and the most current stable >> production version is recommended. (See CollectionSpace-specific PostgreSQL >> installation instructions< >> https://wiki.collectionspace.org/display/DOC/PostgreSQL+Installation+-+Windows%2C+Mac+OS+X%2C+Generic+Linux >> >) >> >> >> Oracle's Java Development Kit (JDK) >> >> >> JDK 7 (Java SE 1.7)< >> http://www.oracle.com/technetwork/java/javase/downloads/index.html> >> (CollectionSpace 3.2.1 or higher.) >> (Also earlier versions of CollectionSpace, when rebuilt under Java 7; see >> Updating existing CollectionSpace systems to use Java 7< >> https://wiki.collectionspace.org/display/DOC/Updating+existing+CollectionSpace+systems+to+use+Java+7>for >> details.) >> JDK 6 (Java SE 1.6)< >> http://www.oracle.com/technetwork/java/javase/downloads/index.html> >> (through CollectionSpace 3.2) >> >> >> Build tools: Ant >> >> >> Ant 1.8.2<http://ant.apache.org/bindownload.cgi> or higher >> >> >> Build tools: Maven >> >> >> Maven 3.0<http://maven.apache.org/download.html> or higher is highly >> recommended; version 2.2 or higher is required. (Note: going forward, >> CollectionSpace will be developed only with Maven 3 and higher versions, >> and thus any issues you may encounter specific to Maven 2 will be best >> resolvable by upgrading to Maven 3 or later.) >> >> >> ImageMagick >> >> >> ImageMagick 6.0<http://www.imagemagick.org/> or higher (See Installing >> ImageMagick< >> https://wiki.collectionspace.org/display/DOC/Installing+ImageMagick>) >> >> >> FTP Client >> >> >> Any FTP client tool (e.g. FileZilla<http://filezilla-project.org/>) >> >> >> Gzip >> >> >> Any tool that handles gzip files (eg. tar (Linux, Mac OS X)< >> http://www.gnu.org/software/tar/>, winzip<http://www.winzip.com/index.htm> >> (Windows), 7-zip<http://www.7-zip.org/download.html> (Windows)) >> >> >> >> Installing CollectionSpace >> Setup Tomcat >> >> Go to the directory where you want to install CollectionSpace: >> >> cd /usr/local/share >> >> >> CollectionSpace runs in the Tomcat 7 application server and a >> pre-configured version of Tomcat 7 is provided. >> >> Start by downloading the Tomcat tarball: >> >> wget >> ftp://nightly.collectionspace.org/pub/collectionspace/releases/4.3/cspace-server-4.3.tar.gz >> >> >> Unpack the tarball: >> >> tar -xzvof cspace-server-4.3.tar.gz >> >> >> This will create an apache-tomcat-7.0.57 directory in /usr/local/share. >> >> Next, make necessary files executable: >> >> chmod u+x apache-tomcat-7.0.57/bin/*.sh >> >> >> You can now remove the tarball: >> >> rm cspace-server-4.3.tar.gz >> >> Setting the CollectionSpace Environment >> >> While CollectionSpace is installing an running,it needs some environment >> variables defined Make sure that the following values correspond to your >> environment: >> >> * CSPACE_JEESERVER_HOME: The full path to the apache-tomcat-7.0.57 >> directory that was created when you unpacked the CollectionSpace tarball. >> * CATALINA_HOME: The full path to the apache-tomcat-7.0.57 directory, >> identical to the value of CSPACE_JEESERVER_HOME. >> * CATALINA_PID: The full path to a file which will hold the Tomcat >> server process number. This is used by the Tomcat shutdown script. >> * CATALINA_OPTS: Environment options for the Tomcat server process. >> The recommended options below are Java Virtual Machine (JVM) memory >> settings which permit allocation of up to 1 GB of RAM to the Java heap and >> up to 384 MB of RAM for Java Permanent Generation (PermGen) space. >> * JAVA_HOME: The full path to your Java directory If you are unsure >> where this variable should point to, you can execute this command: >> >> readlink -f `which java` >> >> >> and take the part that comes before jre. >> >> * DB_CSADMIN_PASSWORD: The password for the administrative database >> user for the CollectionSpace application. This must match the password for >> that user that you specified while setting up PostgreSQL in the >> prerequisites section. (This administrative user by default will be >> namedcsadmin, and will be a superuser. However, this user will have fewer >> privileges than the overall database administrator superuser, by default >> namedpostgres.) >> * DB_NUXEO_PASSWORD: Any database-legal password of your choice for >> the nuxeo database user. This user can work with CollectionSpace data >> stored in Nuxeo, the content management system underlying CollectionSpace. >> * DB_CSPACE_PASSWORD: Any database-legal password of your choice for >> the cspace database user. This user can work with CollectionSpace data for >> users, roles, and access permission. >> * DB_READER_PASSWORD: Any database-legal password of your choice for >> the reader database user. This user will have read-only access to >> CollectionSpace data stored in Nuxeo. >> * ANT_OPTS: Environment options for the Apache Ant build tool. The >> recommended options below are Java Virtual Machine (JVM) memory settings >> which permit allocation of up to 768 MB of RAM to the Java heap and up to >> 512 MB of RAM for Java Permanent Generation (PermGen) space. >> * MAVEN_OPTS: Environment options for the Maven build tool. The >> recommended options below are Java Virtual Machine (JVM) memory settings >> which permit allocation of up to 768 MB of RAM to the Java heap and up to >> 512 MB of RAM for Java Permanent Generation (PermGen) space. >> * CSPACE_INSTANCE_ID: String appended to default CollectionSpace >> database names. >> * DB_HOST: The hotname or IP address of the server running Postgres. >> * DB_PORT: The port for the Postgresql service. Usually 5432 >> * JEE_PORT: The HTTP port for the Services layer. Usually 8180 >> >> The example below is for the Bash shell; edit ~/.bashrc or >> ~/.bash_profile and be sure to substitute the actual values for your >> environment: >> >> 1 >> 2 >> 3 >> 4 >> 5 >> 6 >> 7 >> 8 >> 9 >> 10 >> 11 >> 12 >> 13 >> 14 >> 15 >> >> export CSPACE_JEESERVER_HOME="/usr/local/share/apache-tomcat-7.0.57" >> export CATALINA_HOME=$CSPACE_JEESERVER_HOME >> export CATALINA_PID="$CSPACE_JEESERVER_HOME/bin/tomcat.pid" >> export CATALINA_OPTS="-Xmx1024m -XX:MaxPermSize=384m" >> export JAVA_HOME="/usr/lib/jvm/java-7-openjdk-amd64/" >> export DB_CSADMIN_PASSWORD="your_csadmin_database_user_password_here" >> export DB_NUXEO_PASSWORD="your_nuxeo_database_user_password_here" >> export DB_CSPACE_PASSWORD="your_cspace_database_user_password_here" >> export DB_READER_PASSWORD="your_reader_database_user_password_here" >> export ANT_OPTS="-Xmx768m -XX:MaxPermSize=512m" >> export MAVEN_OPTS="-Xmx768m -XX:MaxPermSize=512m" >> export CSPACE_INSTANCE_ID="_default" >> export DB_HOST="localhost" >> export DB_PORT="5432" >> export JEE_PORT="8180" >> >> >> Afterwards, make sure to source your ~/bashrc so the environment >> variables are available. >> >> source ~/.bashrc >> >> >> >> Now that we have the environment set up, we can grab the code for >> CollectionSpace. CollectionSpace consists of three separate servlets, which >> are that run inside the Tomcat webserver: the services layer, the >> application layer, and the UI layer. >> >> cd $HOME >> mkdir collectionspace-source >> cd collectionspace-source >> git clone https://github.com/collectionspace/application -b v4.3 >> git clone https://github.com/collectionspace/services -b v4.3 >> git clone https://github.com/collectionspace/ui -b v4.3 >> >> >> >> >> Next, we are going to build and deploy each of the layers to the >> CollectionSpace tomcat server. The whole process might take up to 30 >> minutes the first time, but will be significantly faster after that. >> >> >> >> cd application >> mvn clean install -DskipTests >> cd ../ui >> mvn clean install -DskipTests >> cd ../services >> mvn clean install -DskipTests >> >> >> >> >> >> ------ >> Regards, >> >> Mahendra Pratap singh >> >> >> >>

Mahendra, In addition to Yousuf's tips below, if you're simply evaluating CollectionSpace then you could trying using the automated installer on a clean VirtualBox instance of Ubuntu 14.04. Also, if you're just interested in experimenting with the CollectionSpace application and RESTFul API then feel free to visit one our live and fully functional public demo sites: http://demo.collectionspace.org The "core" site is the most generic demo deployment of CollectionSpace: http://core.collectionspace.org/collectionspace/ui/core/html/index.html The username and password credentials for both the UI and the RESTFul API are there on the landing page of the "core" instance. -Richard ________________________________________ From: Talk <talk-bounces@lists.collectionspace.org> on behalf of Yousuf Nejati <yousuf.nejati@granitehorizon.com> Sent: Wednesday, July 6, 2016 12:25 PM To: talk@lists.collectionspace.org Subject: Re: [Talk] collectionspace Installation Issue Hi Mahendra, Actually, the best thing to do may be to check to see IF the database actually exists by logging into the psql shell as cspace_default, I believe, and then solving backwards from there. Something like "psql -U cspace_default -d cspace_default" Can you try this and see what you come up with? -Yousuf On Wed, Jul 6, 2016 at 11:22 AM, Yousuf Nejati <yousuf.nejati@granitehorizon.com<mailto:yousuf.nejati@granitehorizon.com>> wrote: Hi Mahendra, Are you running the Ant command within the ~/collectionspace-source/services directory? Thanks, Y On Wed, Jul 6, 2016 at 11:12 AM, <talk-request@lists.collectionspace.org<mailto:talk-request@lists.collectionspace.org>> wrote: Send Talk mailing list submissions to talk@lists.collectionspace.org<mailto:talk@lists.collectionspace.org> To subscribe or unsubscribe via the World Wide Web, visit http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org or, via email, send a message with subject or body 'help' to talk-request@lists.collectionspace.org<mailto:talk-request@lists.collectionspace.org> You can reach the person managing the list at talk-owner@lists.collectionspace.org<mailto:talk-owner@lists.collectionspace.org> When replying, please edit your Subject line so it is more specific than "Re: Contents of Talk digest..." Today's Topics: 1. Re: collectionspace Installation Issue (Megan Forbes) ---------------------------------------------------------------------- Message: 1 Date: Wed, 6 Jul 2016 18:11:20 +0000 From: Megan Forbes <megan.forbes@lyrasis.org<mailto:megan.forbes@lyrasis.org>> To: "mahendra.pratap@inficaretech.com<mailto:mahendra.pratap@inficaretech.com>" <mahendra.pratap@inficaretech.com<mailto:mahendra.pratap@inficaretech.com>>, "rakesh@InfiCareTech.com" <rakesh@InfiCareTech.com>, "CollectionSpace Talk List" <talk@lists.collectionspace.org<mailto:talk@lists.collectionspace.org>> Subject: Re: [Talk] collectionspace Installation Issue Message-ID: <DM5PR08MB2409FD29ED4F98411504DB8380390@DM5PR08MB2409.namprd08.prod.outlook.com<mailto:DM5PR08MB2409FD29ED4F98411504DB8380390@DM5PR08MB2409.namprd08.prod.outlook.com>> Content-Type: text/plain; charset="iso-8859-1" Thank you for your email! I'm cc'ing our "talk" list here, where a community of developers is available to help you get your installation up and running. Best regards, Megan Megan Forbes CollectionSpace Program Manager megan.forbes@lyrasis.org<mailto:megan.forbes@lyrasis.org> 917.267.9676<tel:917.267.9676> Cell meganbforbes Skype ________________________________ From: mahendra.pratap@inficaretech.com<mailto:mahendra.pratap@inficaretech.com> <mahendra.pratap@inficaretech.com<mailto:mahendra.pratap@inficaretech.com>> Sent: Monday, July 4, 2016 10:41 AM To: info@collectionspace.org<mailto:info@collectionspace.org> Cc: rakesh@InfiCareTech.com Subject: collectionspace Installation Issue Hello, I am trying to install collectionspace using Installation Guide, I done the Installation but when I Creating database it generate Error. ant create_db -Drecreate_db=true ant undeploy deploy create_db -Drecreate_db=true import database not found. System Requirements for a CollectionSpace Server ________________________________________________________- Linux distributions : Ubuntu 14.04 LTS Requirement Value Virtual memory / swap space Double the amount of RAM System Architecture Processor: Intel (x86), AMD64, and Intel EM64T Processor 1 GHz minimum Physical memory (RAM) 2 GB RAM (4 GB or higher strongly recommended), 1 GB cache Software Requirements for Installation Requirement Value Description Database system: PostgreSQL server PostgreSQL 9.1 or later is required and the most current stable production version is recommended. (See CollectionSpace-specific PostgreSQL installation instructions<https://wiki.collectionspace.org/display/DOC/PostgreSQL+Installation+-+Windows%2C+Mac+OS+X%2C+Generic+Linux>) Oracle's Java Development Kit (JDK) JDK 7 (Java SE 1.7)<http://www.oracle.com/technetwork/java/javase/downloads/index.html> (CollectionSpace 3.2.1 or higher.) (Also earlier versions of CollectionSpace, when rebuilt under Java 7; see Updating existing CollectionSpace systems to use Java 7<https://wiki.collectionspace.org/display/DOC/Updating+existing+CollectionSpace+systems+to+use+Java+7>for details.) JDK 6 (Java SE 1.6)<http://www.oracle.com/technetwork/java/javase/downloads/index.html> (through CollectionSpace 3.2) Build tools: Ant Ant 1.8.2<http://ant.apache.org/bindownload.cgi> or higher Build tools: Maven Maven 3.0<http://maven.apache.org/download.html> or higher is highly recommended; version 2.2 or higher is required. (Note: going forward, CollectionSpace will be developed only with Maven 3 and higher versions, and thus any issues you may encounter specific to Maven 2 will be best resolvable by upgrading to Maven 3 or later.) ImageMagick ImageMagick 6.0<http://www.imagemagick.org/> or higher (See Installing ImageMagick<https://wiki.collectionspace.org/display/DOC/Installing+ImageMagick>) FTP Client Any FTP client tool (e.g. FileZilla<http://filezilla-project.org/>) Gzip Any tool that handles gzip files (eg. tar (Linux, Mac OS X)<http://www.gnu.org/software/tar/>, winzip<http://www.winzip.com/index.htm> (Windows), 7-zip<http://www.7-zip.org/download.html> (Windows)) Installing CollectionSpace Setup Tomcat Go to the directory where you want to install CollectionSpace: cd /usr/local/share CollectionSpace runs in the Tomcat 7 application server and a pre-configured version of Tomcat 7 is provided. Start by downloading the Tomcat tarball: wget ftp://nightly.collectionspace.org/pub/collectionspace/releases/4.3/cspace-server-4.3.tar.gz Unpack the tarball: tar -xzvof cspace-server-4.3.tar.gz This will create an apache-tomcat-7.0.57 directory in /usr/local/share. Next, make necessary files executable: chmod u+x apache-tomcat-7.0.57/bin/*.sh You can now remove the tarball: rm cspace-server-4.3.tar.gz Setting the CollectionSpace Environment While CollectionSpace is installing an running,it needs some environment variables defined Make sure that the following values correspond to your environment: * CSPACE_JEESERVER_HOME: The full path to the apache-tomcat-7.0.57 directory that was created when you unpacked the CollectionSpace tarball. * CATALINA_HOME: The full path to the apache-tomcat-7.0.57 directory, identical to the value of CSPACE_JEESERVER_HOME. * CATALINA_PID: The full path to a file which will hold the Tomcat server process number. This is used by the Tomcat shutdown script. * CATALINA_OPTS: Environment options for the Tomcat server process. The recommended options below are Java Virtual Machine (JVM) memory settings which permit allocation of up to 1 GB of RAM to the Java heap and up to 384 MB of RAM for Java Permanent Generation (PermGen) space. * JAVA_HOME: The full path to your Java directory If you are unsure where this variable should point to, you can execute this command: readlink -f `which java` and take the part that comes before jre. * DB_CSADMIN_PASSWORD: The password for the administrative database user for the CollectionSpace application. This must match the password for that user that you specified while setting up PostgreSQL in the prerequisites section. (This administrative user by default will be namedcsadmin, and will be a superuser. However, this user will have fewer privileges than the overall database administrator superuser, by default namedpostgres.) * DB_NUXEO_PASSWORD: Any database-legal password of your choice for the nuxeo database user. This user can work with CollectionSpace data stored in Nuxeo, the content management system underlying CollectionSpace. * DB_CSPACE_PASSWORD: Any database-legal password of your choice for the cspace database user. This user can work with CollectionSpace data for users, roles, and access permission. * DB_READER_PASSWORD: Any database-legal password of your choice for the reader database user. This user will have read-only access to CollectionSpace data stored in Nuxeo. * ANT_OPTS: Environment options for the Apache Ant build tool. The recommended options below are Java Virtual Machine (JVM) memory settings which permit allocation of up to 768 MB of RAM to the Java heap and up to 512 MB of RAM for Java Permanent Generation (PermGen) space. * MAVEN_OPTS: Environment options for the Maven build tool. The recommended options below are Java Virtual Machine (JVM) memory settings which permit allocation of up to 768 MB of RAM to the Java heap and up to 512 MB of RAM for Java Permanent Generation (PermGen) space. * CSPACE_INSTANCE_ID: String appended to default CollectionSpace database names. * DB_HOST: The hotname or IP address of the server running Postgres. * DB_PORT: The port for the Postgresql service. Usually 5432 * JEE_PORT: The HTTP port for the Services layer. Usually 8180 The example below is for the Bash shell; edit ~/.bashrc or ~/.bash_profile and be sure to substitute the actual values for your environment: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 export CSPACE_JEESERVER_HOME="/usr/local/share/apache-tomcat-7.0.57" export CATALINA_HOME=$CSPACE_JEESERVER_HOME export CATALINA_PID="$CSPACE_JEESERVER_HOME/bin/tomcat.pid" export CATALINA_OPTS="-Xmx1024m -XX:MaxPermSize=384m" export JAVA_HOME="/usr/lib/jvm/java-7-openjdk-amd64/" export DB_CSADMIN_PASSWORD="your_csadmin_database_user_password_here" export DB_NUXEO_PASSWORD="your_nuxeo_database_user_password_here" export DB_CSPACE_PASSWORD="your_cspace_database_user_password_here" export DB_READER_PASSWORD="your_reader_database_user_password_here" export ANT_OPTS="-Xmx768m -XX:MaxPermSize=512m" export MAVEN_OPTS="-Xmx768m -XX:MaxPermSize=512m" export CSPACE_INSTANCE_ID="_default" export DB_HOST="localhost" export DB_PORT="5432" export JEE_PORT="8180" Afterwards, make sure to source your ~/bashrc so the environment variables are available. source ~/.bashrc Now that we have the environment set up, we can grab the code for CollectionSpace. CollectionSpace consists of three separate servlets, which are that run inside the Tomcat webserver: the services layer, the application layer, and the UI layer. cd $HOME mkdir collectionspace-source cd collectionspace-source git clone https://github.com/collectionspace/application -b v4.3 git clone https://github.com/collectionspace/services -b v4.3 git clone https://github.com/collectionspace/ui -b v4.3 Next, we are going to build and deploy each of the layers to the CollectionSpace tomcat server. The whole process might take up to 30 minutes the first time, but will be significantly faster after that. cd application mvn clean install -DskipTests cd ../ui mvn clean install -DskipTests cd ../services mvn clean install -DskipTests ------ Regards, Mahendra Pratap singh