Postgres Pro
Downloads
Home   >   mailing lists

Thread: [NOVICE] beginner help

[NOVICE] beginner help

From
Mark Plimley
Date:

Experts:

 

I’m trying to get PostgreSQL set up to use with JIRA service desk on CentOS 7. I am totally new to PostgreSQL.

 

I installed PostgreSQL 9.6 and apparently got it enabled with ‘systemctl enable postgresql.service’. When I tried ‘systemctl start postgresql.service’, it fails to start. Postgresql-Mon.log reports “FATAL: role “root” does not exist” and  “FATAL: role “jiradbuser” does not exist” because of trying to create those users.

 

I assume that I need to drop those users if I can figure out how to. Can someone provide some pointers on where to start or what I need to do to move forward? I have a postgres user and group and apparently I need to run some commands as that user if I can get the service to start.

 

I looked at the documentation but need to get past the startup errors before I can do anything.

 

Thanks.

 

Mark Plimley

Sr. PLM Architect

Certified in Windchill MCAD Data Management

MarkP@NxRev.com

NxRev Inc.

Product Development Solutions

39500 Stevenson Pl #108

Fremont, CA 94539

 

Please include your NxRev account representative on technical issues or questions.

 

Re: [NOVICE] beginner help

From
armand pirvu
Date:
No mention about root although may need to do the same thing as for jiradbuser



Hope this helps a bit

— Armand

On Jun 6, 2017, at 1:34 PM, Mark Plimley <markp@nxrev.com> wrote:

Experts:
 
I’m trying to get PostgreSQL set up to use with JIRA service desk on CentOS 7. I am totally new to PostgreSQL.
 
I installed PostgreSQL 9.6 and apparently got it enabled with ‘systemctl enable postgresql.service’. When I tried ‘systemctl start postgresql.service’, it fails to start. Postgresql-Mon.log reports “FATAL: role “root” does not exist” and  “FATAL: role “jiradbuser” does not exist” because of trying to create those users.
 
I assume that I need to drop those users if I can figure out how to. Can someone provide some pointers on where to start or what I need to do to move forward? I have a postgres user and group and apparently I need to run some commands as that user if I can get the service to start.
 
I looked at the documentation but need to get past the startup errors before I can do anything.
 
Thanks.
 
Mark Plimley
Sr. PLM Architect
Certified in Windchill MCAD Data Management
NxRev Inc.
Product Development Solutions
39500 Stevenson Pl #108
Fremont, CA 94539
 
Please include your NxRev account representative on technical issues or questions.

Re: [NOVICE] beginner help

From
Mark Plimley
Date:

Thanks for the link, but I have already browsed much of the JIRA documentation.

 

I am not able to “Create a database user (login role)” or “Create a database for JIRA” because of the errors starting the PostgreSQL service. I think need to get past the errors first, and I don’t know how to do that. I don’t know what user I should use to create database users or create the database.

 

Mark Plimley

Sr. PLM Architect

408.708.0916 office

NxRev Inc.

 

From: armand pirvu [mailto:armand.pirvu@gmail.com]
Sent: Tuesday, June 06, 2017 12:32 PM
To: Mark Plimley <markp@nxrev.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] beginner help

 

No mention about root although may need to do the same thing as for jiradbuser

 

 

 

Hope this helps a bit

 

— Armand

 

On Jun 6, 2017, at 1:34 PM, Mark Plimley <markp@nxrev.com> wrote:

 

Experts:

 

I’m trying to get PostgreSQL set up to use with JIRA service desk on CentOS 7. I am totally new to PostgreSQL.

 

I installed PostgreSQL 9.6 and apparently got it enabled with ‘systemctl enable postgresql.service’. When I tried ‘systemctl start postgresql.service’, it fails to start. Postgresql-Mon.log reports “FATAL: role “root” does not exist” and  “FATAL: role “jiradbuser” does not exist” because of trying to create those users.

 

I assume that I need to drop those users if I can figure out how to. Can someone provide some pointers on where to start or what I need to do to move forward? I have a postgres user and group and apparently I need to run some commands as that user if I can get the service to start.

 

I looked at the documentation but need to get past the startup errors before I can do anything.

 

Thanks.

 

Mark Plimley

Sr. PLM Architect

Certified in Windchill MCAD Data Management

NxRev Inc.

Product Development Solutions

39500 Stevenson Pl #108

Fremont, CA 94539

 

Please include your NxRev account representative on technical issues or questions.

 

Re: [NOVICE] beginner help

From
"David G. Johnston"
Date:
On Tue, Jun 6, 2017 at 11:34 AM, Mark Plimley <markp@nxrev.com> wrote:

I installed PostgreSQL 9.6 and apparently got it enabled with ‘systemctl enable postgresql.service’. When I tried ‘systemctl start postgresql.service’, it fails to start. Postgresql-Mon.log reports “FATAL: role “root” does not exist” and  “FATAL: role “jiradbuser” does not exist” because of trying to create those users.


​Those log message imply that you have a functioning PostgreSQL instance since that instance is what is writing those log messages.

The default install, however you may have done it, generally creates a "postgres" DB superuser and sets up access permissions so that only the​ "postgres" O/S user can connect.  Most people do something like:   "sudo -u postgres psql" to get into the default "postgres" database.  At that point you can start creating other users.

The O/S user "root" user is apparently trying to connect for some reason.  You should try and figure out if you can avoid that.

The "jiradbuser" is expected given your usage and you will need to add that name as a DB user with whatever permissions JIRA says.

David J.

Re: [NOVICE] beginner help

From
armand pirvu
Date:
Not sure why postgres service would complain about root/jiradbuser at startup
I wonder if it does not try to start other things as well (doubtfull though)

May want to make sure postgres is down and try to start manually using pg_ctl command as postgres , create root and jiradbuser roles , stop and start using systemctl and go from there

Sent from my iPhone

On Jun 6, 2017, at 3:10 PM, Mark Plimley <markp@nxrev.com> wrote:

Thanks for the link, but I have already browsed much of the JIRA documentation.

 

I am not able to “Create a database user (login role)” or “Create a database for JIRA” because of the errors starting the PostgreSQL service. I think need to get past the errors first, and I don’t know how to do that. I don’t know what user I should use to create database users or create the database.

 

Mark Plimley

Sr. PLM Architect

408.708.0916 office

NxRev Inc.

 

From: armand pirvu [mailto:armand.pirvu@gmail.com]
Sent: Tuesday, June 06, 2017 12:32 PM
To: Mark Plimley <markp@nxrev.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] beginner help

 

No mention about root although may need to do the same thing as for jiradbuser

 

 

 

Hope this helps a bit

 

— Armand

 

On Jun 6, 2017, at 1:34 PM, Mark Plimley <markp@nxrev.com> wrote:

 

Experts:

 

I’m trying to get PostgreSQL set up to use with JIRA service desk on CentOS 7. I am totally new to PostgreSQL.

 

I installed PostgreSQL 9.6 and apparently got it enabled with ‘systemctl enable postgresql.service’. When I tried ‘systemctl start postgresql.service’, it fails to start. Postgresql-Mon.log reports “FATAL: role “root” does not exist” and  “FATAL: role “jiradbuser” does not exist” because of trying to create those users.

 

I assume that I need to drop those users if I can figure out how to. Can someone provide some pointers on where to start or what I need to do to move forward? I have a postgres user and group and apparently I need to run some commands as that user if I can get the service to start.

 

I looked at the documentation but need to get past the startup errors before I can do anything.

 

Thanks.

 

Mark Plimley

Sr. PLM Architect

Certified in Windchill MCAD Data Management

NxRev Inc.

Product Development Solutions

39500 Stevenson Pl #108

Fremont, CA 94539

 

Please include your NxRev account representative on technical issues or questions.

Re: [NOVICE] beginner help

From
Mark Plimley
Date:

In my ignorance, I think I ran a db command as root, which is why that shows up.

 

How do I add the jiradbuser that I attempted to create as a db user?

 

Mark Plimley

Sr. PLM Architect

408.708.0916 office

NxRev Inc.

 

From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Tuesday, June 06, 2017 1:13 PM
To: Mark Plimley <markp@nxrev.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] beginner help

 

On Tue, Jun 6, 2017 at 11:34 AM, Mark Plimley <markp@nxrev.com> wrote:

I installed PostgreSQL 9.6 and apparently got it enabled with ‘systemctl enable postgresql.service’. When I tried ‘systemctl start postgresql.service’, it fails to start. Postgresql-Mon.log reports “FATAL: role “root” does not exist” and  “FATAL: role “jiradbuser” does not exist” because of trying to create those users.

 

​Those log message imply that you have a functioning PostgreSQL instance since that instance is what is writing those log messages.

 

The default install, however you may have done it, generally creates a "postgres" DB superuser and sets up access permissions so that only the​ "postgres" O/S user can connect.  Most people do something like:   "sudo -u postgres psql" to get into the default "postgres" database.  At that point you can start creating other users.

 

The O/S user "root" user is apparently trying to connect for some reason.  You should try and figure out if you can avoid that.

 

The "jiradbuser" is expected given your usage and you will need to add that name as a DB user with whatever permissions JIRA says.

 

David J.

 

Re: [NOVICE] beginner help

From
"David G. Johnston"
Date:
On Tue, Jun 6, 2017 at 1:52 PM, Mark Plimley <markp@nxrev.com> wrote:

How do I add the jiradbuser that I attempted to create as a db user?



David J.
​