LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-25-2019, 07:54 PM   #1
yelirt5
LQ Newbie
 
Registered: Jan 2019
Posts: 4

Rep: Reputation: Disabled
Postgresql password protection in a diskless environment


Community,

we're running Postgres 9.2 on a system that is diskless. The diskless system PXE boots and reeceives its image from a management blade.

My problem seems to be that I can't seem to password protect the database in this environment. While I can easily use the ALTER ROLE command and modify the pg_hba.conf file on the diskless server while it's running and it does work. When I reboot the management server scripts run that re-create the diskless image. When I reboot the diskless server, the pga_hba.conf still has my entry for md5 (instead of trust) but the password I've set doesn't work and I can't login to the db.


From reading about this I think that passwords are stored in a catalog called pg_authid. This doesn't seem to be a file I can copy to my scripts directory to put in place on the management server when the diskless image is rebuilt.

Just wondering if anyone has any ideas as to how to handle this problem.

Thank you.
 
Old 07-25-2019, 09:00 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 15,567
Blog Entries: 25

Rep: Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514Reputation: 4514
According to this article, in a PXE connection, other forms of authentication may be in use: https://chartio.com/resources/tutori...in-postgresql/
 
1 members found this post helpful.
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to reverse proxy and password protect an application, but having issues with rewriting URLs and password protection not working d745fba1cb70ab9dc02a80ee Linux - Server 12 06-20-2019 01:30 AM
How to boot and using ramdisk in a diskless environment? wdli Linux - Kernel 23 12-17-2011 10:37 PM
diskless environment vishnuvijayan Linux - Newbie 3 06-19-2009 08:09 AM
Diskless Environment bharatlalgupta Linux - Software 0 02-09-2009 07:22 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 03:50 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:52 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration