Fwd: postgresql error in analytics 1.1.6

Hi team,

While running opscode-analytics-ctl reconfigure chef analytics 1.1.6 latest
version on rhel 6, I am getting error chef-pgsql role does not exist.

I create this role manually and struck with another error.
Syntax error at CREATE EXTENSION IF NOT EXISTS “UUID-OSSP”

Is this bug or I am missing something…???

Thanks
Amandeep Singh

Hello Amandeep -

Can you post a gist [0] or similar of all the output from opscode-analytics-ctl reconfigure?

Cheers -
Dave

[0] https://gist.github.com/ https://gist.github.com/

Additionally, can you run:

opscode-analytics-ctl preflight-check

and include that output as well.

Hi Dave,

Thanks for quick response.
opscode-analytics-ctl preflight-check just showing me success preflight
check successful message.

Please refer below the error I am getting with chef analytics 1.1.5 and
1.1.6 both.

Facing same error(as show below) while running opscode-analytics-ctl
reconfigure

Error

STDERR: ERROR: syntax error at or near “EXTENSION”

LINE 1: CREATE EXTENSION IF NOT EXISTS “uuid-ossp”

               ^

Ok, I’ll need to see ALL the output from opscode-analytics-ctl reconfigure, not just a single line.

Can you paste into a gist or pastebin?

Cheers -
Dave

Hi Dave,

I have pasted the complete output in gist. Please refer below the URL.

Thanks
Amandeep Singh

Interesting, are you by any chance installing this on a node that already has Chef Server installed?
Have you installed any custom packages? (I see cfengine mentioned at the top of the gist).

I’ll spin up a EL6 node later and see if I can reproduce this issue.

In the meantime, your best bet would be to ping support@chef.io.

Cheers -
Dave

Thanks dave. Yes CFEngine was earlier installed on this local machine.
But i am surprised because it is throwing syntax error instead of any conflict.

Thanks
Amandeep Singh

Googling for syntax error at or near "EXTENSION" shows failures if the version of Postgres you’re running the statement against is < 9.2. Have you previously installed an older version of Posgres on that box?

Cheers -
Dave

Thanks Dave, i am currently checking with team regarding prior installation of postgres on this server.

Can we install chef analytics on same machine where we have chef-client installed??

Yes, you can install Analytics on a machine with Chef Client.

Cheers -
Dave

Hi Dave,

I tried to configure chef analytics on the server having chef-client installed but opscode-analytics-ctl reconfigure is not working. PFB the error.

STDERR: psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/tmp/.s.PGSQL.5432”?
---- End output of psql --dbname template1 --command “CREATE USER actions WITH ENCRYPTED PASSWORD ‘3b2f0eb5e30194afff0435f5e538d77c19c948e4c9450f2cca77f2867293e76741b2bd20bcae28ef477c530b5697d2b2fc60’ ;” ----
Ran psql --dbname template1 --command “CREATE USER actions WITH ENCRYPTED PASSWORD ‘3b2f0eb5e30194afff0435f5e538d77c19c948e4c9450f2cca77f2867293e76741b2bd20bcae28ef477c530b5697d2b2fc60’ ;” returned 2

For complete error output, please refer to the below gist link-

Hello Amandeep -

I spun up a new RHEL 6 vm and was able to install Analytics without an issue. I have no idea how having cfengine [0] installed would interact with a Chef Analytics install. You’re best bet is to try with a fresh OS image, and if problems persist, please contact support@chef.io.

Cheers -
Dave

[0] https://gist.github.com/anonymous/38742600a9bb98a076dc

Thanks Dave for quick response.

I am waiting from the chef support to revert.
I tried this installation on new rhel where only chef-client is installed and no other version of postgresql is installed.

Thanks
Amandeep Singh

Hello Amandeep -

I’m not sure what it could be. I am unable to duplicate the issue on a RHEL6 vm with chef-client 12.5.1 installed.
Chef support should be able to get things straightened out for you.

Cheers-
Dave