[Kexi] kexi

[Eildert Groeneveld]

On Friday 24 February 2006 15:04, Jaroslaw Staniek wrote:
> Eildert Groeneveld wrote:
> > perhaps there is a better platform to find answers, but this route was
> > the one I found.
>
> Hello
> Yes, I am forwarding this to kexi at kde.org mailing list. Please use it.
>
> > As of Postgresql-8.1 I am haing problems to connect kexi 1.4.90.1-1
> >
> > to postgres. The complaint I am getting on the console is
> >
> > "Closing connection while nontransaction still open"
> >
> > As regards my setup: I have a .9 kexi database on the postgresql server,
> > but when startet as
> > kexi --local-socket /var/run/postgresql/.s.PGSQL.5432
> >
> > (the lock file seem sto have moved) and I chose from the kexi opening
> > window the "open existing projects" tab I do get postgresql
> > eg at localhost:5432
>
> No need to use --local-socket arg if you're using 'select conenction'
> startup window anyway. Just run kexi, and define the connection up to
> specific local socket setting if needed.
>
> > all looking fine.
> > But when I hit the ok, I get on the starting console the message:
> > Closing connection while nontransaction still open
> >
> > and in the following an empty window.
> >
> > any idea of how to connect?
>
> I'll look at the problem; could you try to connect via tcp/ip, instead
> of the socket? And send me your .kexic file for your connection (before
> remove your password= line), located in
> ~/.kde/share/apps/kexi/connections/ ?


[Connection1]
caption=
engine=postgresql
password=xxxxx
type=connection
useLocalSocketFile=false
user=eg

[File Information]
version=1

This would be it.

Using socket or TCP does not seem to make a difference.



>
> This could be a good start for me to try to locate a problem.

good luck, 


Eildert

-- 
Eildert Groeneveld
===================================================
Institute for Animal Breeding
Mariensee 31535 Neustadt Germany
Tel : (+49)(0)5034 871155 Fax : (+49)(0)5034 871239
e-mail: eildert.groeneveld at fal.de http://vce.tzv.fal.de/index.pl
http://www.tzv.fal.de/~eg/ http://apiis.tzv.fal.de/index.pl
===================================================