Re: [Nufw-users] Segmentation fault using postgresql logs

[Eric Leblond]

Le mercredi 01 juin 2005 à 23:09 +0200, Vincent Schultz a écrit :
> Bonjour la liste,

boonsoir ;-)


> ** Message: Going to init pgsql connection
> ** Message: ...
> ** Message: done
> ** Message: ...
> ** Message: done
> Erreur de segmentation

That's really strange, the "done" message is only written. Can you try
to apply the provided patch which will ease debugging ? 

> 
> Postgresql's logs :
> 
> ERREUR:  Droit refusé pour la relation ulog
> ERREUR:  syntax error sur ou près de «Jun» au caractère 35
> TRACE:  Fin de fichier (EOF) inattendue de la connexion du client
> TRACE:  Fin de fichier (EOF) inattendue de la connexion du client

Could you increase verbosity level to be able to have the PGSQL complete
request.

> 
> I think I made a mistake with the rights. This is how I created the
> database and the user :

But it should not crash anyway.

> 
> # su – postgres
> $ createuser -D -A -P nufwuser
> $ createdb nufwdb
> $ psql nufwdb
> nufwdb=# \i /tmp/nufw-20050530/conf/nulog.pgsql.dump
> nufwdb=# GRANT ALL ON DATABASE nufwdb TO nufwuser;
> 
> If nuauth_user_logs_module is set on "syslog" instead of "pgsql"
> everything is fine.

Is the password empty ? it may be a problem in credential generation.
Could you try with a non empty one ?

BR,

-- 
Eric Leblond <address@hidden>

pgsqlc.diff
Description: Text Data