[Ubuntu 7.10] Plesk fails to change PostgreSQL user/password

[dsmarty]

I tried to install Plesk 8.3.0 on a fresh Ubuntu 7.10 system.
After installing I have to manually set a user/password for postgresql.
(Via Server > Database Servers > PostgreSQL)

When setting user/password I get the following error:

Unsupported version of PostgreSQL is installed.
3

0: /opt/psa/admin/plib/DatabaseManagerPostgreSQL.php:263
    DatabaseManagerPostgreSQL->createLocalAdminLoginImpl(string 'admin', string '**********', NULL null)
1: /opt/psa/admin/plib/DatabaseManager.php:513
    DatabaseManager->updateLocalAdmin()
2: /opt/psa/admin/plib/DatabaseServerManager.php:229
    DatabaseServerManager->updateServer(object of type DatabaseServer)
3: /opt/psa/admin/htdocs/server/db_server_edit.php:52

The installed PostgreSQL version is 8.3.0. (This version is automatically installed via Plesk installscript).

Has anyone a suggestion how to fix this ?
SWSoft never responds to messages send to bugreport [at] swsoft.com...

 

[DaDomainMasta]

hello.
could be helpful to dig a bit in psa database. what is in table Components and what is in CP Server->Component Management v/s what is in dpkg -l |grep postgr?
It could come that postgresql was actually updated and became incompatible with Plesk

 

[danielgines]

Try:

apt-get --purge remove postgresql-client-8.3 postgresql-8.3 postgresql

apt-get install postgresql-8.2

passwd postgresql

Go to your web interface

Daniel Gines.