[Dspace-general] I can't see any item

[Bram Luyten]

Hi Hector,

I'm not the most technical person in our team, but after googling I found
following topic that might be of help.

here's the link:
http://www.forosdelweb.com/f99/postgresql-8-3-0-no-deja-crear-bd-con-encoding-latin1-559822/

Here's what you do (according to the discussion):

*1) Te "logeas" como root.

2) Deten el postgres según tu distribución (si está activo).
rcpostgresql stop
/etc/init.d/postgresql stop

3) Elimina el directorio data (puedes crear otro cluster en lugar de
eliminar este directorio, en mi caso se trataba de portar una BD antigua a
la version 8.3 del postgres, por eso quise eliminar este directorio).
rm -rf /var/lib/pgsql/data

4) Actúa como usuario postgres
su - postgres

5) Crea un nuevo cluster indicandole el locale que necesites (en mi caso,
es_CO.LATIN1) pero puedes usar el de tu país, es_ES.LATIN1, es_AR.ut8, etc.
Nota: La codificacion (opcion -E) no es necesaria puesto que se deriva de
locale.

initdb --locale=es_CO.LATIN1 -D /var/lib/pgsql/data

6) Listo, ahora seguramente querrás que el postgres te inicie
automáticamente en los niveles 3 y 5.

exit (para salir de la sesión del usuario postgres y volver a root)
chkconfig --level 35 postgresql on

7) Prueba a reiniciar el servicio... si tienes algun problema comentalo
aquí.

rcpostgresql restart

8) Si todo te sale bien, ya puedes crear tu base de datos.
createdb -U postgres -E LATIN1 nombrebd
*
I hope this helps

Bram

@mire - http://www.atmire.com

Technologielaan 9 - 3001 Heverlee - Belgium
533 2nd Street - Encinitas, CA 92024 - USA

http://www.togather.eu - Before getting together, get Tog at ther


2009/9/10 Héctor Garcia Peris <hector.garcia at ivie.es>

> The problem is when I try to create the database using UNICODE I get
> this error:
>
> dspace at dspace:~$ /usr/lib/postgresql/8.3/bin/createdb -U dspace -E
> UNICODE dspace2
> createdb: falló la creación de la base de datos:
> ERROR:  la codificación UTF8 no coincide con la configuración regional
> del servidor es_ES
> DETAIL:  La configuración regional LC_CTYPE del servidor requiere la
> codificación LATIN1.
>
> Sorry, but the message is in Spanish. I try to translate it:
>
> createdb: failed in the database creation
> ERROR: UTF8 codification doesn't coincide with the regional
> configutation of the server es_ES
> DETAIL: Regional codification LC_CTYPE of the server requires LATIN1
> codification.
>
> This is the reason because my database is created with LATIN1. Any help
> to create it with UNICODE is welcome.
>
> Thanks.
>
> Hilton Gibson escribió:
> > On Wednesday 09 September 2009 15:00:33 Héctor Garcia Peris wrote:
> >
> >> I think the problem is related with the codification. If I create an
> >> item with special characters like "Título 1", when I run this:
> >>
> >> dspace at dspace:~$ /home/dspace/dspace/bin/index-update
> >> Creating browse index
> >> Exception in thread "main" org.dspace.browse.BrowseException:
> >> org.postgresql.util.PSQLException: ERROR: carácter 0xcc81 de
> >> codificación «UTF8» no tiene equivalente en «LATIN1»
> >> <lines suppressed>
> >>
> >> without special characters I have no problem.
> >>
> >> The problem is that I couldn't create the database if I don't use LATIN1
> >> codification. How can I create the database with the UNICODE
> codification?
> >>
> > See:
> >
> http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Enable_Tomcat_with_UTF-8_multi-
> > byte_encoding
> >
> >
> http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Create_the_PostgreSQL_.27dspace.27_database
> >
> > Cheers
> >
> > hg.
> >
> >
> >> Thanks.
> >>
> >> Claudia Jürgen escribió:
> >>
> >>> Hola Héctor,
> >>>
> >>> did you ran
> >>> [dspace]/bin/index-init after the fresh installation?
> >>>
> >>> Saludos
> >>>
> >>> Claudia Jürgen
> >>>
> >>> Héctor Garcia Peris schrieb:
> >>>
> >>>> Hello,
> >>>>
> >>>> I have installed dspace 1.5.2 in a debian linux stable version.
> >>>>
> >>>> The installation uses postgres as database and is a new installation.
> >>>> I have created a testing community and a testing collection without
> >>>> problems. But when I have created a new item, although it was created
> >>>> without problems I can't see it in the collection
> >>>> (http://dspace:8080/jspui/handle/123456789/2) or when I try to find
> >>>> it using the search engine
> >>>> (http://dspace:8080/jspui/simple-search?query=&submit=Ir+).
> >>>> Nevertheless I can access to the item data using the URI associated
> >>>> to it (http://dspace:8080/jspui/handle/123456789/3).
> >>>>
> >>>> It seems that there is something missing between the collection and
> >>>> the item. Can anybody help me?
> >>>>
> >>>> Thanks.
> >>>>
> >
> > _______________________________________________
> > Dspace-general mailing list
> > Dspace-general at mit.edu
> > http://mailman.mit.edu/mailman/listinfo/dspace-general
> >
>
> --
>
> ---------------------------------------------------------------------
> Héctor Garcia Peris
> Dpto. Informática
> Instituto Valenciano de Investigaciones Económicas S.A. (Ivie)
> C/ Guardia Civil, 22 esc-2 1º 46020 - Valencia (Spain)
> Tfno.: +34 - 963190050 / +34 - 963930816
> Fax.: +34 - 963190055 / +34 - 963930856
> e-mail: hector.garcia at ivie.es
> Web: http://www.ivie.es
> ----------------------------------------------------------------------
>
> _______________________________________________
> Dspace-general mailing list
> Dspace-general at mit.edu
> http://mailman.mit.edu/mailman/listinfo/dspace-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/dspace-general/attachments/20090916/680cd218/attachment.htm