Tim, i think that the DEBUG flag is not helping us much, in the mean
while i've tried also to update ant to 1.8.2 but nothing...
should we enable other debug flags? maybe in org.postgresql.util package ?
thank you,
K
[java] 2011-01-11 17:19:37,432 DEBUG
org.dspace.storage.rdbms.DatabaseManager @ Running query "CREATE INDEX
bi_4_dis_value_idx ON bi_4_dis(value)" with parameters:
[java] 2011-01-11 17:19:37,433 DEBUG
org.dspace.storage.rdbms.DatabaseManager @ Running query "CREATE INDEX
bi_4_dis_uvalue_idx ON bi_4_dis(UPPER(value))" with parameters:
[java] 2011-01-11 17:19:37,435 DEBUG
org.dspace.storage.rdbms.DatabaseManager @ Running query "CREATE INDEX
bi_4_dmap_item_id_idx ON bi_4_dmap(item_id)" with parameters:
[java] 2011-01-11 17:19:37,436 DEBUG
org.dspace.storage.rdbms.DatabaseManager @ Running query "CREATE INDEX
bi_4_dmap_dist_idx ON bi_4_dmap(distinct_id)" with parameters:
[java] Started: 1294784376950
[java] Ended: 1294784377438
[java] Elapsed time: 0 secs (488 msecs)
load_registries:
[java] 2011-01-11 17:19:38,273 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-11 17:19:38,281 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java] 2011-01-11 17:19:39,283 DEBUG
org.dspace.storage.rdbms.DatabaseManager @ Running query "INSERT INTO
bitstreamformatregistry ( ) VALUES ( ) RETURNING null"
[java] 2011-01-11 17:19:39,292 FATAL
org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
[java] org.postgresql.util.PSQLException: ERROR: syntax error at
or near ")"
[java] at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeError:
[java] - ERROR: syntax error at or near ")"
[java] Query(DelegatingPreparedStatement.java:96)
[java] at
org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
[java] at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
[java] at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
[java] at
org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
[java] at
org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
[java] at
org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
BUILD FAILED
/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809:
Java returned: 1
Total time: 13 seconds
On 11 January 2011 16:31, Tim Donohue <tdono...@duraspace.org> wrote:
> Hi Kocisky,
>
> Your Maven build part is working properly. I didn't notice you were using
> the 'dspace-1.7.0-release' version (which has pre-compiled code, and
> therefore responds as having built fewer modules). I had thought you were
> still using the 'dspace-1.7.0-src-release' version.
>
> Here's something else you can try:
>
> (1) From [dspace-src]/dspace/ run this command:
> 'mvn clean package'
> (WARNING: this will first delete the entire /target/dspace-1.7.0-build.dir ,
> before it rebuilds DSpace.)
>
> (2) After DSpace has been rebuilt, edit the following configuration file:
>
> [dspace-src]/dspace/target/dspace-1.7.0-build.dir/config/log4j-console.properties
>
> In that text file, temporarily change the following line:
>
> log4j.rootCategory=INFO, A1
>
> Replace "INFO" with "DEBUG" like this:
>
> log4j.rootCategory=DEBUG, A1
>
> This changes the logging mode to "debug". That means that the DSpace
> installer will now report a lot more information to you about what is going
> on while DSpace is being installed.
>
> (3) Finally, re-run the 'ant fresh_install' command.
>
> This time, you should see a ton of extra information be logged to your
> command line (since you are now in "debug" mode). Once it errors out again,
> please email us the lines just *before* that error message. This time,
> those lines should include extra information on what is happening and what
> exact command the install process is failing on.
>
> Hopefully this extra information can help us figure out what could be going
> wrong in your DSpace installation.
>
> - Tim
>
> On 1/11/2011 2:31 PM, Kocisky wrote:
>>
>> Hi Tim,
>>
>> thank you for your reply, i've followed your suggestions but didn't
>> got many results, see below:
>>
>>> DSpace 1.7 actually comes packaged with the PostgreSQL JDBC driver it
>>> needs
>>> to use. You do not need to install a separate JDBC driver (in fact, you
>>> may
>>> want to remove what you installed, to make sure it doesn't cause any
>>> conflicts).
>>
>> great, i've removed that package
>>
>>>
>>> The full installation prerequisites& instructions are at:
>>>
>>> https://wiki.duraspace.org/display/DSDOC/Installation
>>
>> i was following the doc in the pkg, thanks also for this !
>>
>>>
>>> Also be aware that you will need Maven 2.2.x or above to properly build
>>> DSpace 1.7.0. We've discovered an error in builds with Maven 2.0.x --
>>> see
>>> the above link for more details (look under the "prerequisites software"
>>> section)
>>
>> i'm now using apache-maven 3.0.1 but have the same syntax problem, see
>> below
>>
>>>
>>> Your version of Maven actually may be part of the problem. After the
>>> Maven
>>> build, it seems you don't receive a full summary of all modules being
>>> built
>>> properly. Double check that you are running 'mvn package' from the
>>> [dspace-src]/dspace/ directory. The results of a successful build should
>>> report similar to this (notice how many more modules were built -- you
>>> only
>>> had 8 listed in your logs below):
>>
>> maybe i have less packages because i'm not "compiling" the source but
>> the slim package with pre-compiled modules?
>> here the last build with maven version:
>>
>> [INFO] Copying 1394 files to
>>
>> /home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Reactor Summary:
>> [INFO]
>> [INFO] DSpace Addon Modules .............................. SUCCESS
>> [0.385s]
>> [INFO] DSpace XML-UI (Manakin) :: Web Application ........ SUCCESS
>> [7.276s]
>> [INFO] DSpace LNI :: Web Application ..................... SUCCESS
>> [4.203s]
>> [INFO] DSpace OAI :: Web Application ..................... SUCCESS
>> [4.589s]
>> [INFO] DSpace JSP-UI :: Web Application .................. SUCCESS
>> [5.691s]
>> [INFO] DSpace SWORD :: Web Application ................... SUCCESS
>> [4.986s]
>> [INFO] DSpace SOLR :: Web Application .................... SUCCESS
>> [10.092s]
>> [INFO] DSpace Assembly and Configuration ................. SUCCESS
>> [44.539s]
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] BUILD SUCCESS
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Total time: 1:22.092s
>> [INFO] Finished at: Tue Jan 11 15:12:14 EST 2011
>> [INFO] Final Memory: 10M/26M
>> [INFO]
>> ------------------------------------------------------------------------
>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace# cd
>>
>> /home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir
>>
>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>> ls
>> bin build.xml CHANGES config docs etc KNOWN_BUGS lib LICENSE
>> README solr webapps
>>
>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>> ant fresh_install
>> Buildfile: build.xml
>>
>> init_installation:
>>
>> init_configs:
>> [copy] Copying 1 file to /usr/local/dspace/config
>>
>> test_database:
>> [java] 2011-01-11 15:12:49,705 INFO
>> org.dspace.core.ConfigurationManager @ Loading system provided config
>> property (-Ddspace.configuration): config/dspace.cfg
>> [java] 2011-01-11 15:12:49,724 INFO
>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>> log configuration,if unintended, check your dspace.cfg for
>> (log.init.config)
>> [java]
>> [java] Attempting to connect to database:
>> [java] - URL: jdbc:postgresql://localhost:5432/dspace
>> [java] - Driver: org.postgresql.Driver
>> [java] - Username: postgres
>> [java] - Password: zsx
>> [java] - Schema: dspace
>> [java]
>> [java] Testing connection...
>> [java] Connected successfully!
>> [java]
>>
>> setup_database:
>> [java] 2011-01-11 15:12:51,258 INFO
>> org.dspace.core.ConfigurationManager @ Loading system provided config
>> property (-Ddspace.configuration): config/dspace.cfg
>> [java] 2011-01-11 15:12:51,264 INFO
>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>> log configuration,if unintended, check your dspace.cfg for
>> (log.init.config)
>> [java] 2011-01-11 15:12:51,264 INFO
>> org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
>> [java] 2011-01-11 15:13:01,503 INFO
>> org.dspace.core.ConfigurationManager @ Loading system provided config
>> property (-Ddspace.configuration): config/dspace.cfg
>> [java] 2011-01-11 15:13:01,509 INFO
>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>> log configuration,if unintended, check your dspace.cfg for
>> (log.init.config)
>> [java] Started: 1294776781495
>> [java] Ended: 1294776782197
>> [java] Elapsed time: 0 secs (702 msecs)
>>
>> load_registries:
>> [java] 2011-01-11 15:13:02,426 INFO
>> org.dspace.core.ConfigurationManager @ Loading system provided config
>> property (-Ddspace.configuration): config/dspace.cfg
>> [java] 2011-01-11 15:13:02,432 INFO
>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>> log configuration,if unintended, check your dspace.cfg for
>> (log.init.config)
>> [java] 2011-01-11 15:13:03,640 FATAL
>> org.dspace.administer.RegistryLoader @
>> anonymous::error_loading_registries:
>> [java] org.postgresql.util.PSQLException: ERROR: syntax error at
>> or near ")"
>> [java] at
>>
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
>> [java] at
>>
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
>> [java] at
>>
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> [java] at
>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> [java] at
>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> [java] at
>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> [java] at
>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> [java] at
>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> [java] at
>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>> [java] at
>>
>> org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
>> [java] at
>> org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
>> [java] at
>> org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
>> [java] at
>> org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
>> [java] at
>> org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
>> [java] at
>>
>> org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
>> [java] at
>> org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
>> [java] Error:
>> [java] - ERROR: syntax error at or near ")"
>>
>> BUILD FAILED
>>
>> /home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809:
>> Java returned: 1
>>
>> Total time: 16 seconds
>>
>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>> mvn -version
>> Apache Maven 3.0.1 (r1038046; 2010-11-23 05:58:32-0500)
>> Java version: 1.6.0_22
>> Java home: /usr/lib/jvm/java-6-sun-1.6.0.22/jre
>> Default locale: en_US, platform encoding: UTF-8
>> OS name: "linux" version: "2.6.26-2-686" arch: "i386" Family: "unix"
>>
>> any suggestions?
>> thanks a lot,
>>
>> K
>>
>>>
>>> On 1/10/2011 2:12 PM, Kocisky wrote:
>>>>
>>>> Dear Tim,
>>>>
>>>> i've tried to install the last version of java (directly from the
>>>> oracle site and not the version on the debian repository) but got the
>>>> same problem.
>>>> below the error log you can also verify the versions of the
>>>> applications required by dspace (from the doc).
>>>> I've tried also with another environment (MacOSX 10.6.6) with the
>>>> latest tomcat 6.0.29 and postgreSQL 9.0 but had the same error (check
>>>> the tread: "Syntax error on ant fresh_install with dspace 1.7.0" in
>>>> the same ml).
>>>>
>>>> i didn't really understood where the postgres/JDBC connector resides
>>>> and which version is compatible...
>>>> since i'm not confident with this environment i dont even know how to
>>>> follow the code, should i post it on the dev mailing list ?
>>>>
>>>> thank you!
>>>> K
>>>>
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> java -version
>>>> java version "1.6.0_23"
>>>> Java(TM) SE Runtime Environment (build 1.6.0_23-b05)
>>>> Java HotSpot(TM) Client VM (build 19.0-b09, mixed mode, sharing)
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> ant -version
>>>> Apache Ant version 1.7.0 compiled on April 29 2008
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> mvn -version
>>>> Maven version: 2.0.9
>>>> Java version: 1.6.0_22
>>>> OS name: "linux" version: "2.6.26-2-686" arch: "i386" Family: "unix"
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> psql --version
>>>> psql (PostgreSQL) 8.3.12
>>>> contains support for command-line editing
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> perl -version
>>>>
>>>> This is perl, v5.10.0 built for i486-linux-gnu-thread-multi
>>>>
>>>> Copyright 1987-2007, Larry Wall
>>>>
>>>> Perl may be copied only under the terms of either the Artistic License
>>>> or
>>>> the
>>>> GNU General Public License, which may be found in the Perl 5 source kit.
>>>>
>>>> Complete documentation for Perl, including FAQ lists, should be found on
>>>> this system using "man perl" or "perldoc perl". If you have access to
>>>> the
>>>> Internet, point your browser at http://www.perl.org/, the Perl Home
>>>> Page.
>>>>
>>>> [....]
>>>>
>>>> [INFO] Copying files to
>>>>
>>>>
>>>> /home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir
>>>> [INFO]
>>>> [INFO]
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] Reactor Summary:
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] DSpace Addon Modules .................................. SUCCESS
>>>> [10.229s]
>>>> [INFO] DSpace XML-UI (Manakin) :: Web Application ............ SUCCESS
>>>> [29.401s]
>>>> [INFO] DSpace LNI :: Web Application ......................... SUCCESS
>>>> [9.994s]
>>>> [INFO] DSpace OAI :: Web Application ......................... SUCCESS
>>>> [8.520s]
>>>> [INFO] DSpace JSP-UI :: Web Application ...................... SUCCESS
>>>> [7.514s]
>>>> [INFO] DSpace SWORD :: Web Application ....................... SUCCESS
>>>> [9.485s]
>>>> [INFO] DSpace SOLR :: Web Application ........................ SUCCESS
>>>> [20.712s]
>>>> [INFO] DSpace Assembly and Configuration ..................... SUCCESS
>>>> [59.814s]
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] BUILD SUCCESSFUL
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> [INFO] Total time: 2 minutes 36 seconds
>>>> [INFO] Finished at: Mon Jan 10 14:37:19 EST 2011
>>>> [INFO] Final Memory: 40M/97M
>>>> [INFO]
>>>> ------------------------------------------------------------------------
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace# cd
>>>>
>>>>
>>>> /home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> java -version
>>>> java version "1.6.0_23"
>>>> Java(TM) SE Runtime Environment (build 1.6.0_23-b05)
>>>> Java HotSpot(TM) Client VM (build 19.0-b09, mixed mode, sharing)
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> ls
>>>> bin build.xml CHANGES config docs etc KNOWN_BUGS lib LICENSE
>>>> README solr webapps
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>>
>>>>
>>>> dev:/home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir#
>>>> ant fresh_install
>>>> Buildfile: build.xml
>>>>
>>>> init_installation:
>>>> [mkdir] Created dir: /usr/local/dspace/bin
>>>> [mkdir] Created dir: /usr/local/dspace/config
>>>> [mkdir] Created dir: /usr/local/dspace/lib
>>>> [mkdir] Created dir: /usr/local/dspace/etc
>>>> [mkdir] Created dir: /usr/local/dspace/webapps
>>>> [mkdir] Created dir: /usr/local/dspace/exports
>>>> [mkdir] Created dir: /usr/local/dspace/exports/download
>>>> [mkdir] Created dir: /usr/local/dspace/assetstore
>>>> [mkdir] Created dir: /usr/local/dspace/handle-server
>>>> [mkdir] Created dir: /usr/local/dspace/search
>>>> [mkdir] Created dir: /usr/local/dspace/log
>>>> [mkdir] Created dir: /usr/local/dspace/upload
>>>> [mkdir] Created dir: /usr/local/dspace/reports
>>>> [mkdir] Created dir: /usr/local/dspace/solr
>>>>
>>>> init_configs:
>>>> [copy] Copying 61 files to /usr/local/dspace/config
>>>> [copy] Copying 1 file to /usr/local/dspace/config
>>>>
>>>> test_database:
>>>> [java] 2011-01-10 14:39:36,615 INFO
>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>> [java] 2011-01-10 14:39:36,623 INFO
>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>> log configuration,if unintended, check your dspace.cfg for
>>>> (log.init.config)
>>>> [java]
>>>> [java] Attempting to connect to database:
>>>> [java] - URL: jdbc:postgresql://localhost:5432/dspace
>>>> [java] - Driver: org.postgresql.Driver
>>>> [java] - Username: postgres
>>>> [java] - Password: zsx
>>>> [java] - Schema: dspace
>>>> [java]
>>>> [java] Testing connection...
>>>> [java] Connected successfully!
>>>> [java]
>>>>
>>>> setup_database:
>>>> [java] 2011-01-10 14:39:37,267 INFO
>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>> [java] 2011-01-10 14:39:37,273 INFO
>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>> log configuration,if unintended, check your dspace.cfg for
>>>> (log.init.config)
>>>> [java] 2011-01-10 14:39:37,274 INFO
>>>> org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
>>>> [java] 2011-01-10 14:39:39,503 INFO
>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>> [java] 2011-01-10 14:39:39,510 INFO
>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>> log configuration,if unintended, check your dspace.cfg for
>>>> (log.init.config)
>>>> [java] Started: 1294688379495
>>>> [java] Ended: 1294688379852
>>>> [java] Elapsed time: 0 secs (357 msecs)
>>>>
>>>> load_registries:
>>>> [java] 2011-01-10 14:39:40,063 INFO
>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>> [java] 2011-01-10 14:39:40,071 INFO
>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>> log configuration,if unintended, check your dspace.cfg for
>>>> (log.init.config)
>>>> [java] 2011-01-10 14:39:40,860 FATAL
>>>> org.dspace.administer.RegistryLoader @
>>>> anonymous::error_loading_registries:
>>>> [java] org.postgresql.util.PSQLException: ERROR: syntax error at
>>>> or near ")"
>>>> [java] at
>>>>
>>>>
>>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
>>>> [java] at
>>>>
>>>>
>>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
>>>> [java] at
>>>>
>>>>
>>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>>>> [java] at
>>>>
>>>>
>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>>>> [java] at
>>>>
>>>>
>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>>>> [java] at
>>>>
>>>>
>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>>>> [java] at
>>>>
>>>>
>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>>> [java] at
>>>>
>>>>
>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>>> [java] at
>>>>
>>>>
>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>>> [java] at
>>>>
>>>>
>>>> org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
>>>> [java] at
>>>>
>>>> org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
>>>> [java] at
>>>>
>>>> org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
>>>> [java] at
>>>> org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
>>>> [java] at
>>>> org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
>>>> [java] at
>>>>
>>>>
>>>> org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
>>>> [java] at
>>>> org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
>>>> [java] Error:
>>>> [java] - ERROR: syntax error at or near ")"
>>>>
>>>> BUILD FAILED
>>>>
>>>>
>>>> /home/user/Desktop/dspace-1.7.0-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809:
>>>> Java returned: 1
>>>>
>>>> Total time: 7 seconds
>>>>
>>>>
>>>>
>>>> On 10 January 2011 11:49, Tim Donohue<tdono...@duraspace.org> wrote:
>>>>>
>>>>> Kocisky,
>>>>>
>>>>> I'm actually at a loss for what exactly could be causing this problem
>>>>> (and
>>>>> unfortunately I don't have a Debian server and am not as familiar with
>>>>> Debian).
>>>>>
>>>>> Are you running Oracle's (Sun's) Java? You need to make sure you are
>>>>> running that version of Java, and not the one that comes with Debian.
>>>>>
>>>>> Also, through the power of Google, I found this nice reference for
>>>>> installing DSpace on Debian 5 (Lenny):
>>>>>
>>>>>
>>>>> http://rspproject.wordpress.com/2010/11/10/installing-dspace-on-debian-5/
>>>>>
>>>>> So, that blog post may be helpful to resolve your issues. You may want
>>>>> to
>>>>> double check you've installed all the Prerequisities for DSpace 1.7,
>>>>> similar
>>>>> to how it is detailed in that posting.
>>>>>
>>>>> Hopefully that is of some help, or perhaps someone else on this list is
>>>>> more
>>>>> familiar with Debian than I.
>>>>>
>>>>> Good luck,
>>>>>
>>>>> - Tim
>>>>>
>>>>> On 1/7/2011 9:52 AM, Kocisky wrote:
>>>>>>
>>>>>> below the important part:
>>>>>>
>>>>>>
>>>>>> [INFO]
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------
>>>>>> [INFO] BUILD SUCCESSFUL
>>>>>> [INFO]
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------
>>>>>> [INFO] Total time: 5 minutes 5 seconds
>>>>>> [INFO] Finished at: Fri Jan 07 09:46:00 EST 2011
>>>>>> [INFO] Final Memory: 84M/203M
>>>>>> [INFO]
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------
>>>>>> dev:/home/user/Desktop/dspace-1.7.0-src-release/dspace# cd
>>>>>>
>>>>>>
>>>>>>
>>>>>> /home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir
>>>>>>
>>>>>>
>>>>>>
>>>>>> dev:/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir#
>>>>>> ant fresh_install
>>>>>> Buildfile: build.xml
>>>>>>
>>>>>> init_installation:
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/bin
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/config
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/lib
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/etc
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/webapps
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/exports
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/exports/download
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/assetstore
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/handle-server
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/search
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/log
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/upload
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/reports
>>>>>> [mkdir] Created dir: /usr/local/dspace_src/solr
>>>>>>
>>>>>> init_configs:
>>>>>> [copy] Copying 61 files to /usr/local/dspace_src/config
>>>>>> [copy] Copying 1 file to /usr/local/dspace_src/config
>>>>>>
>>>>>> test_database:
>>>>>> [java] 2011-01-07 09:46:35,471 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>>>> [java] 2011-01-07 09:46:35,477 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>>>> log
>>>>>> configuration,if unintended, check your dspace.cfg for
>>>>>> (log.init.config)
>>>>>> [java]
>>>>>> [java] Attempting to connect to database:
>>>>>> [java] - URL: jdbc:postgresql://localhost:5432/dspace
>>>>>> [java] - Driver: org.postgresql.Driver
>>>>>> [java] - Username: postgres
>>>>>> [java] - Password: zsx
>>>>>> [java] - Schema: dspace
>>>>>> [java]
>>>>>> [java] Testing connection...
>>>>>> [java] Connected successfully!
>>>>>> [java]
>>>>>>
>>>>>> setup_database:
>>>>>> [java] 2011-01-07 09:46:36,156 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>>>> [java] 2011-01-07 09:46:36,162 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>>>> log
>>>>>> configuration,if unintended, check your dspace.cfg for
>>>>>> (log.init.config)
>>>>>> [java] 2011-01-07 09:46:36,162 INFO
>>>>>> org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
>>>>>> [java] 2011-01-07 09:46:43,759 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>>>> [java] 2011-01-07 09:46:43,765 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>>>> log
>>>>>> configuration,if unintended, check your dspace.cfg for
>>>>>> (log.init.config)
>>>>>> [java] Started: 1294411603751
>>>>>> [java] Ended: 1294411604212
>>>>>> [java] Elapsed time: 0 secs (461 msecs)
>>>>>>
>>>>>> load_registries:
>>>>>> [java] 2011-01-07 09:46:44,518 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>>>>> property (-Ddspace.configuration): config/dspace.cfg
>>>>>> [java] 2011-01-07 09:46:44,524 INFO
>>>>>> org.dspace.core.ConfigurationManager @ Using default log4j provided
>>>>>> log
>>>>>> configuration,if unintended, check your dspace.cfg for
>>>>>> (log.init.config)
>>>>>> [java] 2011-01-07 09:46:45,215 FATAL
>>>>>> org.dspace.administer.RegistryLoader @
>>>>>> anonymous::error_loading_registries:
>>>>>> [java] org.postgresql.util.PSQLException: ERROR: syntax error at
>>>>>> or
>>>>>> near ")"
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>> org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>> org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
>>>>>> [java] at
>>>>>> org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>> org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
>>>>>> [java] at
>>>>>>
>>>>>>
>>>>>>
>>>>>> org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
>>>>>> [java] at
>>>>>> org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
>>>>>> [java] Error:
>>>>>> [java] - ERROR: syntax error at or near ")"
>>>>>>
>>>>>> BUILD FAILED
>>>>>>
>>>>>>
>>>>>>
>>>>>> /home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809:
>>>>>> Java returned: 1
>>>>>>
>>>>>> Total time: 11 seconds
>>>>>>
>>>>>>
>>>>>> in
>>>>>>
>>>>>>
>>>>>>
>>>>>> /home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809:
>>>>>>
>>>>>> <!-- Loads bitstream format and Dublin Core type registries -->
>>>>>> <target name="load_registries" description="Load initial contents
>>>>>> of
>>>>>> registries">
>>>>>>
>>>>>> <!-- first import the bitstream registry -->
>>>>>> <java classname="org.dspace.administer.RegistryLoader"
>>>>>> classpathref="class.path" fork="yes" failonerror="yes">
>>>>>> <sysproperty key="log4j.configuration"
>>>>>> value="file:config/log4j-console.properties" />
>>>>>> <sysproperty key="dspace.log.init.disable" value="true" />
>>>>>> <sysproperty key="dspace.configuration" value="${config}"
>>>>>> />
>>>>>> <arg value="-bitstream" />
>>>>>> <arg
>>>>>> value="${dspace.dir}/config/registries/bitstream-formats.xml" />
>>>>>> </java>
>>>>>>
>>>>>> am i missing something? i have installed liblog4j1.2-java (1.2.15-4)
>>>>>> help !!
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> Gaining the trust of online customers is vital for the success of any
>>>>>> company
>>>>>> that requires sensitive data to be transmitted over the Web. Learn
>>>>>> how
>>>>>> to
>>>>>> best implement a security strategy that keeps consumers' information
>>>>>> secure
>>>>>> and instills the confidence they need to proceed with transactions.
>>>>>> http://p.sf.net/sfu/oracle-sfdevnl
>>>>>> _______________________________________________
>>>>>> DSpace-tech mailing list
>>>>>> DSpace-tech@lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>>>>>
>>>
>
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
