Error: dns: gethostbyname failed: temporary error - try again
I would try to fix the DNS first. Be sure that the following things work:
ping localhost
ping 127.0.0.1
nslookup localhost
nslookup 127.0.0.1
I am not sure, but I think it that not having a correct DNS might mess up contact between AOLServer and postgres.
Furthermore, from the sample above I guess that you named your database 'openacs', if so your ns/db/pool/main section should look like this:
ns_section "ns/db/pool/main"
ns_param Driver postgres
ns_param Connections 5
ns_param DataSource localhost::openacs
ns_param User nsadmin
# ns_param Password "" ;# using internal-auth
ns_param Verbose Off
ns_param LogSQLErrors On
ns_param ExtendedTableInfo On
AFAIK if you haven't chroot'ed the lot then you don't need the password.
Ryan suggested checking if your datamodel was loaded correctly, but this test may be a bit more informative. And yes, please do check your datamodel.txt file.
su - nsadmin
psql openacs -c "dt"
You should see a list like this:
List of relations
Name | Type | Owner
--------------------------------+-------+---------
acs_modules | table | nsadmin
ad_categories | table | nsadmin
ad_domains | table | nsadmin
ad_integrity_checks | table | nsadmin
(...)
--More--
If you didn't generate a datamodel.txt file and the tables aren't there, please just:
su - nsadmin
dropdb openacs
And redo from 'creating the database and loading the datamodel' in the manual, and check for errors in datamodel.txt if it still doesn't work.
Hope this gets you anywhere.
