Hi Hilaria,
The labkey.xml file looks fine. The postgres database we're looking at is fine as well, but LabKey would have generated a new database called "labkey" since that's what you called it in the labkey.xml file as:
url="jdbc:postgresql://localhost:5432/labkey"
However, the root cause of the error appears to be:
Caused by: java.io.IOException: Illegal UTF-8 sequence: initial byte is 10xxxxxx: 171
at org.postgresql.core.UTF8Encoding.decode(UTF8Encoding.java:98)
at org.postgresql.core.PGStream.ReceiveString(PGStream.java:329)
at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:686)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
... 27 more
Although your database is using UTF-8 encoding, The LC_COLLATE and the LC_CTYPE appear to be using 'Spanish_Argentina.1252' for a locale rather than just 'C', which doesn't tie itself to any locale.
Can you manually create a database in pgAdmin III for us via the UI and tell us what options you get under the Definition tab for the LC_COLLATE and LC_CTYPE? If you have "C" as an option, I would like for you to create a new database and call it "labkey" and set the LC_COLLATE and LC_CTYPE to "C", then restart Tomcat afterwards and let us know whether LabKey starts up without errors or not.
Regards,
Jon |