[GeoNetwork-users] Beta4 release and postgres

Hi,
I've tried to install geonetwork 2.1.0 beta4 using postgres as backend. First
of all I installed geonetwork with the database embedded and it worked fine.
Secondly I ran gast to change the database but several errors (messages)
occured:
1. Cyclic reference found: [Metadata, Relations, ...]
2. ERROR: the value is too long for the type character varying(32)

The web application works fine despite these errors, but I couldn't log in. I
saw the table called "Users" was empty and I tried to insert a record into
it but I haven't be able to login yet.

Any clue?
I'm using postgres 8.1 in kubuntu feisty, with a database with encoding UTF-8.

Thanks in advance.

--
José Vicente Higón Valero
Grupo desarrollo gvSIG.
IVER TI S.A.
C/Salamanca, 50-52 46005-Valencia
Tlf.+34963163400
http://www.iver.es
http://www.gvsig.com
http://www.gvsig.gva.es

Hi José,

the first error is strange. I cannot say why it is there.
The second one is a bug in the sql schema. To fix it, you have to
increase the Users.password field to varchar(40) into the script
located in gast/setup/sql/create-db-postgres.sql

Cheers,
Andrea

Hi,
I've tried to install geonetwork 2.1.0 beta4 using postgres as backend. First
of all I installed geonetwork with the database embedded and it worked fine.
Secondly I ran gast to change the database but several errors (messages)
occured:
1. Cyclic reference found: [Metadata, Relations, ...]
2. ERROR: the value is too long for the type character varying(32)

The web application works fine despite these errors, but I couldn't log in. I
saw the table called "Users" was empty and I tried to insert a record into
it but I haven't be able to login yet.

Any clue?
I'm using postgres 8.1 in kubuntu feisty, with a database with encoding UTF-8.

Thanks in advance.

I have had both those problems as well. So far, no luck with geonetwork and postgres backend.

Postgres 8.1.4 + PostGIS
Sun Java 6
RHEL 4

--
Amos Hayes
Geomatics and Cartographic Research Centre
Carleton University
ahayes@anonymised.com
+1.613.520.2600x8179

On 17-Jul-07, at 8:42 AM, Andrea Carboni wrote:

Hi José,

the first error is strange. I cannot say why it is there.
The second one is a bug in the sql schema. To fix it, you have to
increase the Users.password field to varchar(40) into the script
located in gast/setup/sql/create-db-postgres.sql

Cheers,
Andrea

Hi,
I've tried to install geonetwork 2.1.0 beta4 using postgres as backend. First
of all I installed geonetwork with the database embedded and it worked fine.
Secondly I ran gast to change the database but several errors (messages)
occured:
1. Cyclic reference found: [Metadata, Relations, ...]
2. ERROR: the value is too long for the type character varying(32)

The web application works fine despite these errors, but I couldn't log in. I
saw the table called "Users" was empty and I tried to insert a record into
it but I haven't be able to login yet.

Any clue?
I'm using postgres 8.1 in kubuntu feisty, with a database with encoding UTF-8.

Thanks in advance.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork