Fwd: postgresql error in analytics 1.1.6

Chef Infra (archive)
1

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

2

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/

3

Additionally, can you run:

opscode-analytics-ctl preflight-check

and include that output as well.

4

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”

               ^
5

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

6

Hi Dave,

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

Thanks
Amandeep Singh

7

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

8

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

9

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

10

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??

11

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

Cheers -
Dave

12

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-

13

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

14

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

15

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