I've finally been able to successfully dump the db on my local FF host
and imported it into another host to handle the heavy lifting. I've
updated /etc/gforge/httpd.conf.d/secrets.inc to set the dbhost IP to the
new server and updated pg_hba.conf on the postgres server to allow
connections from the FF host.
I'm not a postgresql expert so what I ended up doing is probably not the
best solution. Here's what I did:
host gforge all <my_ff_host_ip>/32 trust
host gforge all <my_ff_host_ip>/32 ident
host gforge all <my_ff_host_ip>/32 md5
As I understand it, this allows any user on the FF host to connect using
any of these three methods. I'm sure this isn't optimal or even secure.
Can somebody give me a better solution?
I also added hostaddr=<my_ff_host_ip> to the connectionstring in
/etc/nss-pgsql.conf and /etc/nss-pgsql-root.conf.
Right now, the web UI and nss queries seem to be working correctly. Is
there anything else I might be missing to make this db migration
complete? I'm using v. 5.2, installed from debian wheezy packages.
Thanks.
Seth
--
Seth Galitzer
Systems Coordinator
Computing and Information Sciences
Kansas State University
http://www.cis.ksu.edu/~sgsax
sg...@ksu.edu
785-532-7790
_______________________________________________
Fusionforge-general mailing list
Fusionforge-general@lists.fusionforge.org
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-general
