Re: IMP3,horde2, Postgresql from sid
Hi Mark,
Well, I think its working.
However, the only way for me to make it work was to
run
psql -U postgres template1 < horde.schema
Thanks again for that file.
I tried everything you said and I still couldn't get horde
to configure the database for me.
Do you think you could send me your pg_hba.conf file?
It burns me that I couldn't get it to work.
You've been a great help!!!
are whole school district is running imp2 right now, which is great,
but would like to move to imp3 by Sept hopefully. or at least when imp3
goes to "testing" or "stable".
Thanks
Mike
Quoting "Roach, Mark R." <mrroach@uhg.net>:
> On Sat, 2002-06-01 at 12:34, Mike Egglestone wrote:
> > Hi,
> > I'm still having problems.
> > I started completed from scratch on my test-box.
> > Here's my progress.
> > I install potato, dist-upgrade to sid
> > Install postgresql with all defaults.
> > Install apache with all defaults, except (httpd.conf) change
> servername to
> > 10.0.0.82
> > my /etc/hosts looks like this:
> > 127.0.0.1 localhost
> > 10.0.0.82 danin
> >
> > Then edit pg_hba.conf to look like this:
> >
> > local all ident sameuser
> > host all 127.0.0.1 255.0.0.0 ident sameuser
> > host all 0.0.0.0 0.0.0.0 trust
> >
> > I restart postgresql.
> > I install uw-imapd
> > I then install horde2 which brings all the php4 stuff etc.
> > Here are the options for horde2 configer:
> > use apache as webserver
> > use postgresql as database
> > use danin as host
> > use postgres as database user
> > I type in <none> for the password.
> > ... I then get this error " You have to modify the postgres server
> manually
> > to allow network requests!"
> > I install php4-pear and turba
> > I then install php4-pgsql.
> > I then install imp3
> >
> > I goto http://10.0.0.82/horde2/test.php
> > and everything is fine. even the IMP tests works.
> > The only thing I don't have is
> > LDAP support
> > MCAP support
> > Mcrypt support
> > Mysql support
> > :
> > I goto http://10.0.0.82/horde2/imp
> > and try to login, but then this error comes up.
> >
> > DB error: connect failure
> > Line 102 of /usr/share/horde2/lib/Prefs/sql.php
> >
> > So I check, /var/log/horde2/horde.log
> > and sure enough, it says...
> >
> > Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1
> > No pg_hba.conf entry for host 10.0.0.82, user postgres, database
> horde2
>
> alright, on the danin system, verify that the installation process
> created the 'horde2' database properly by running "psql -U postgres
> horde2" and then type "\d" to view tables. I am guessing that it did not
> create the database. I have attached a file horde.schema which you
> should be able to use to run "psql -U postgres template1 < horde.schema"
> from the danin system.
>
>
> >
> > If I run dpkg-reconfigure horde2
> > and set the host to "localhost",
> > I get the same IMP3 error on the web page,
> > but the /var/log/horde2/horde.conf
> > shows a similar error, but says,
> > .... FATAL 1 IDENT authentication failed for user postgres
> >
> > I'm about to give up.
> > Thanks for all you help!!!!
>
> this is a problem with your pg_hba.conf on your local system. you need
> to put
> "host all 127.0.0.1 255.255.255.255 trust"
> instead of the "host all 127.0.0.1 255.255.255.255 ident" line that it
> appears you currently have.
>
> Don't give up, you're almost there :)
>
> -Mark
>
--
To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Reply to: