Problem setting up PostgreSQL

joejoe2010

Hi,

I'm actually trying to set up the development environment with PostgreSQL.

When I do nant recreateDatabase I get the following error:

D:\openPetra.org-Files3\bzr\trunk>

D:\openPetra.org-Files3\bzr\trunk>nant recreateDatabase
El sistema no puede hallar el controlador especificado.
NAnt 0.91 (Build 0.91.3881.0; alpha2; 17.08.2010)
Copyright (C) 2001-2010 Gerry Shaw
http://nant.sourceforge.net

Buildfile: file:///D:/openPetra.org-Files3/bzr/trunk/OpenPetra.build
Target framework: Microsoft .NET Framework 2.0
Target(s) specified: recreateDatabase

 [echo] operating system=Microsoft Windows NT 5.1.2600 Service Pack 3
 [echo] platform=win32
  [include] Including file D:\openPetra.org-Files3\bzr\trunk\OpenPetra.build.con
fig.
     [echo] Running on MS Windows

init:


createSQLStatements:

[ExecDotNet] Reading xml file D:\openPetra.org-Files3\bzr\trunk/db/petra.xml...
[ExecDotNet] Writing file to D:\openPetra.org-Files3\bzr\trunk/setup/petra0300/p
etra.sql...
[ExecDotNet] Success: file written: D:\openPetra.org-Files3\bzr\trunk/setup/petr
a0300/petra.sql
[ExecDotNet] Success: file written: D:\openPetra.org-Files3\bzr\trunk\setup\petr
a0300\petra_withoutConstraints.sql
[ExecDotNet] Success: file written: D:\openPetra.org-Files3\bzr\trunk\setup\petr
a0300\petra_remove.sql
[ExecDotNet] Success: file written: D:\openPetra.org-Files3\bzr\trunk\setup\petr
a0300\loaddata.sh
[ExecDotNet] Success: file written: D:\openPetra.org-Files3\bzr\trunk\setup\petr
a0300\createtables-PostgreSQL.sql
[ExecDotNet] Success: file written: D:\openPetra.org-Files3\bzr\trunk\setup\petr
a0300\createconstraints-PostgreSQL.sql

recreateDatabase:

 [psql] DROP DATABASE IF EXISTS myopenpetradb;
psql: FATAL:  Passwort-Authentifizierung f³r Benutzer ╗Internetkonto½ fehlgeschl
agen


BUILD FAILED

INTERNAL ERROR

System.Exception: Exit Code 2 shows that something went wrong
   at Ict.Tools.NAntTasks.PsqlTask.ExecuteTask() in d:\openPetra.org-Files3\bzr\
trunk\inc\nanttasks\Postgresql.cs:line 193
   at NAnt.Core.Task.Execute()
   at NAnt.Core.TaskContainer.ExecuteChildTasks()
   at NAnt.Core.Tasks.IfTask.ExecuteTask()
   at NAnt.Core.Task.Execute()
   at NAnt.Core.Target.Execute()
   at NAnt.Core.Project.Execute(String targetName, Boolean forceDependencies)
   at NAnt.Core.Project.Execute()
   at NAnt.Core.Project.Run()

Please send bug report to nant-developers@[deleted].sourceforge.net.

Total time: 34.1 seconds.


D:\openPetra.org-Files3\bzr\trunk>

My OpenPetra.build.config is

<?xml version="1.0"?>
<project name="OpenPetra-userconfig">
    <property name="DBMS.Type" value="postgresql"/>
    <property name="PostgreSQL.exe" value="E:/Archivos de programa/PostgreSQL/9.0/bin/psql.exe"/>
    <property name="pgdump.exe" value="E:/Archivos de programa/PostgreSQL/9.0/bin/pg_dump.exe" overwrite="false"/>
    <property name="DBMS.DBName" value="myopenpetradb"/>
    <property name="DBMS.UserName" value="**"/>
    <property name="DBMS.Password" value="**"/>
    <property name="projectfiles.templates-list" value="sharpdevelop3"/>
</project>

What wonders me is that nant wants to access through user Internetkonto to the database and not through postgres.

If I open the SQL Shell I cann login with Internetkonto and postgres.

Any ideas?

Greetings

Joachim

pokorra

I have usually use the Windows username for the database as well, in <property name="DBMS.UserName" value="**"/>
You need to create that user in pgadmin, and give permissions for creating a database and for creating roles.

joejoe2010

Thank you, this solved my problem.

Greetings

Joachim

pokorra

I have fixed this issue now properly, by using the correct username from the OpenPetra.build.config file.
see sourceforge.net/apps/mantisbt/o ... php?id=482