Hi! Thank you!

Yes "afcmd db_drivers" command is obsolete. Later afserver used Qt SQL module to connect to database. And that command listed available (installed or compiled) Qt SQL drivers in your system.
And I've just deleted it from docs.

http://cgru.sourceforge.net/afanasy/doc/install_unix.html

1. Chapter: "Postgre SQL":
   Did the command "CREATE USER afadmin PASSWORD 'AfPassword';" passed ok?
2. Since version 1.5.5 cgru/afanasy/config.xml database section was updated to setup parameters directly for "Postgre" database engine. If you using your own changed config file, you should update it manually too.
3. Do you have libpq installed? It is a native PostgreSQL library to connect to it. But i think if you have not, afserver should not start at all due linking problem.
4. What system (MS Windows, MAC, Linux distribution) are you using?
   How did you installed postgresql and cgru there?
   What are the versions?
   Did you compiled cgru manually?
   What sources you used, where you got them?

from cgru.

Hi, thanks for your quick reply!

Ok, here are my answers:

1.) Yep, database created correctly, and I see it fine when I do a \l command in pgsql

2.) I haven't actually changed anything in the config_default.xml file. It's all correct ther in terms of the database settings, i.e. password is the same as the one entered as users afadmin (AfPassword).

3.) I think so:
/usr/lib64/libpq.so
/usr/lib64/libpq.so.5
/usr/lib64/libpq.so.5.2
And afserver starts fine, if I open up afwatch, I can also see my other nodes on the network.

4.) Centos 6.2
I installed my dependency packages through yum, and used your centos 6 installer for afanasy. Since that didn't work (same problem, can't connect to the db), I also built the latest git repo and basically swapped out the original /opt/cgru directory with the newly built cgru folder.

Cheers!

Peter.

from cgru.

I've just launched clean virtual centos6.2, installed cgru1.6.3 from downloaded packages, native postgresql server with yum.
Initialized database.
Changed all methods to "trust" in "/var/lib/pgsql/data/pg_hba.conf"
cd /opt/cgru/afanasy/bin/
./afcmd db_check
./afcmd db_resetall
Restarted afserver, and it works!

So, i have nothing to advice, except: try it on a fresh system (i tried via virualbox).

ps
If you are building afanasy from sources, ensure that you have postgresql devel packages installed (cmake should find its includes), otherwise you will get afserver without sql support (it was made for developers who are not interested in jobs storing).

pps
Continue writing about the problem progress!

from cgru.

Hi again, when you say changed sll methods, do you mean changing all the below:

TYPE DATABASE USER CIDR-ADDRESS METHOD

"local" is for Unix domain socket connections only

local all all ident

IPv4 local connections:

host all all 127.0.0.1/32 ident

IPv6 local connections:

host all all ::1/128 ident

CGRU Database

local afanasy afadmin password

to:

"local" is for Unix domain socket connections only

local all all truth

IPv4 local connections:

host all all 127.0.0.1/32 truth

IPv6 local connections:

host all all ::1/128 truth

CGRU Database

local afanasy afadmin truth

Or just afanasy's line?

from cgru.

Yikes, sorry about the huge font, can't find away to remove the html tags

from cgru.

If you are going to set all methods to "trust" (and drop any security) you do not need to add afanasy line at all.
Be careful with key word "trust" spelling, in your example you have "truTH".

from cgru.

just changed them all to trust, and db_check works, yay!
I will continue my wider install tomorrow. It's going to be spanning two facilities on two different floor levels in this building with a mixture of win/mac and linux boxes. I'm pretty sure I'll be back bugging you :P

Thanks for all your help so far!

Peter.

from cgru.

ps
you can just place one space character " " before "#"

from cgru.