<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.6944.0">
<TITLE>Help trying to get postgres working</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">Hi, I am attempting to swap from gdbm to postgresql for holding data.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I configure and compile ipac 1.27 with </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">./configure --enable-classic=no --enable-default-access=postgre --enable-default-storage=postgre</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">And followed all the instructions for creating the postgresql database and users etc, everything went through and passed, including checking the databases through webmin…</FONT></P>
<P><FONT SIZE=2 FACE="Arial">But when I start ipac-ng with fetchipac -S I get the following error</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">[root@redhat sysbackup]# fetchipac -S</FONT>
<BR><FONT SIZE=2 FACE="Arial">Connection to database '(null)' failed.</FONT>
<BR><FONT SIZE=2 FACE="Arial">FATAL: Database "root" does not exist in the system catalog.</FONT>
<BR><FONT SIZE=2 FACE="Arial">fetchipac: error while opening access database</FONT>
<BR><FONT SIZE=2 FACE="Arial">cant operate while database access is absent</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">My ipac.conf is as follows</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">[root@redhat sysbackup]# cat /etc/ipac-ng/ipac.conf</FONT>
<BR><FONT SIZE=2 FACE="Arial"># This is the main ipac-ng configuration file. It contains the</FONT>
<BR><FONT SIZE=2 FACE="Arial"># configuration directives that give the ipac-ng its instructions.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">## mode of operations: operate only like old ipac or not</FONT>
<BR><FONT SIZE=2 FACE="Arial">classic mode = no</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">## specify access agent. supported are: files, postg. files works with classic mode only</FONT>
<BR><FONT SIZE=2 FACE="Arial">access agent = postgre</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">## accouting agent. iptables and ipchains available now. (ipchains is not supported in nonclassic mode)</FONT>
<BR><FONT SIZE=2 FACE="Arial">account agent = iptables</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">## storage. gdbm, postgre and files supported. (files is not recommended)</FONT>
<BR><FONT SIZE=2 FACE="Arial">storage = postgre</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">## rules file for classic mode</FONT>
<BR><FONT SIZE=2 FACE="Arial">rules file = /etc/ipac-ng/rules.conf</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">## login all users at startup (specific only for nonclassic mode) (only those who has enough cash)</FONT>
<BR><FONT SIZE=2 FACE="Arial">login at start = yes</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">## support for traffic passing to\from auth host (specific only for nonclassic mode)</FONT>
<BR><FONT SIZE=2 FACE="Arial">## name or ip of the auth host</FONT>
<BR><FONT SIZE=2 FACE="Arial">## disable support if not specified,</FONT>
<BR><FONT SIZE=2 FACE="Arial">##auth host = sibinet.com</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"># dont store lines contains only zeroes to speedup processing and to save space</FONT>
<BR><FONT SIZE=2 FACE="Arial">drop zero lines = yes</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Any help would be very much appreciated…</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">James</FONT>
</P>
</BODY>
</HTML>