[Nufw-users] Segmentation fault using postgresql logs

[Vincent Schultz]

Bonjour la liste,

I have a problem with postgresql log. I have the following message on
the server running nuauth when I try to surf on the web from a
authentificated client (user/imauser) :

# /opt/nufw/sbin/nuauth -vvvvvvvvvv
** Message: debug_level is 9
** Message: Starting nuauth
** Message: Auth (user) module: plaintext
** Message: ACL module: libplaintext
** Message: User logs module: pgsql
** Message: creating acl cache thread
** Message: Creating search_and_fill thread
** Message: Creating 10 acl checkers
** Message: Creating 3 user checkers
** Message: Creating 10 user loggers
** Message: Creating 10 decision workers
** Message: Creating tls authentication server thread
** Message: Creating tls nufw server thread
** Message: Threads system started
** Message: [plaintext] read_user_list: reading [/etc/nufw/users.nufw]
** Message: Going to init pgsql connection
** Message: [plaintext] read_acl_list: reading [/etc/nufw/acls.nufw]
** Message: [plaintext] Checking for OS sysname=[Linux]
** Message: [plaintext] OS match (Linux)
** Message: [plaintext] Checking for App=
[/usr/lib/firefox-1.0.4/firefox-bin]
** Message: Going to init pgsql connection
** Message: ...
** Message: done
** Message: ...
** Message: done
Erreur de segmentation

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

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

# 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.

Where is my problem ?

Thanks,

Vincent