US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > Troubleshooting


Reply
 
Thread Tools
Old 08-24-2010, 01:24 PM   #1
Junior Member
 
Join Date: Apr 2010
Posts: 19
MV1980 is on a distinguished road
Default Obtain PostgreSQL password

Hi, we have installed postgreSQL with ispmanager.

Ispmanager can connect to postreSQL and create users.

But we don't remember the 'root' password of postgreSQL.

So my question is where does ispmanager keeps the root password of postgreSQL ?

By reading the documentation:
http://en.ispdoc.com/index.php/ISPma...%29#PostgreSQL

"
The following directives will be added into the control panel [devel.config configuration file]:

DbServer "Postgres" { Type pgsql Hostname localhost User pgsql Password password }

Since the only mode providing Postgres installation is Custom, the installation program will ask you to enter pgsql user password. Once you have done, the password will be set by the command

psql -U pgsql -c "ALTER USER pgsql WITH PASSWORD 'password'" template1

The lines below will be added into Postgres configuration file and then Postgres restart will follow

#TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all pgsql password local template1 all password
"

But we can't find any file named "devel.config"


Thank you

Last edited by MV1980; 08-24-2010 at 01:32 PM.
MV1980 is offline   Reply With Quote
Old 08-24-2010, 05:42 PM   #2
ISPsystem team
 
Join Date: Oct 2009
Posts: 118
vian is on a distinguished road
Default

To obtain the password visit page "database servers" and make double click on "PostrgeSQL" item
vian is offline   Reply With Quote
Old 08-30-2010, 12:38 PM   #3
Junior Member
 
Join Date: Apr 2010
Posts: 19
MV1980 is on a distinguished road
Default

Thank you.

Problem solved
MV1980 is offline   Reply With Quote
Reply

Thread Tools

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 On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 04:30 AM.