ifmng: Unable to query parameter default_certificate_id

[fr-k.de]

I get this message when I try to enter plesk (8.2.1):

ERROR: PleskException
Unable to fetch IP addresses list: ifmng failed: ifmng: Unable to query parameter default_certificate_id

0: /usr/local/psa/admin/htdocs/server/configure.php3:39

Can anybody help me to fix this?

Enviroment: SuSE Linux 10.1

Thanx
TOM

 

[Ronny]

Have the same problem.

 

[fr-k.de]

This is what it shows now!

... could be one step ahead?

---
ERROR: PleskFatalException
Unable to get default language.

0: /usr/local/psa/admin/plib/common_func.php3:156
psaerror(string 'Unable to get default language.')
1: /usr/local/psa/admin/plib/countries.php3:293
locale_list()
2: /usr/local/psa/admin/plib/common_func.php3:1604
locale_exists(string 'de-DE')
3: /usr/local/psa/admin/plib/class.Session.php:162
Session->Session()
4: /usr/local/psa/admin/auto_prepend/auth.php3:157
---
I don't how I fixed the certificate problem, but there is still no solution to get into plesk. Any idea with this psa error message?

Thanx
tom

 

[fr-k.de]

Next step..

After reinstall of psa_local_de..rpm I was able to login!

Now I get following error:

---
ERROR: PleskFatalException
Dashboard preset used by user failed: DashboardPreset: unable to select: no such row in the table

0: /usr/local/psa/admin/plib/user/UserAdmin.php:253
UserAdmin->getDashboardCustomPreset()
1: /usr/local/psa/admin/plib/dashboard/DashboardLocation.php:39
DashboardLocation->accessItem(string 'GET', NULL null)
2: /usr/local/psa/admin/plib/UIPointer.php:520
UIPointer->access(string 'GET')
3: /usr/local/psa/admin/htdocs/plesk.php:19

---

Any idea?

Thanx
TOM

 

[dirty@]

all looks like incomplete/failed update when plesk binaries are already new but database is from previous version and does not contain records that binaries refer to..

 

[anb_t]

Originally posted by fr-k.de
I get this message when I try to enter plesk (8.2.1):

ERROR: PleskException
Unable to fetch IP addresses list: ifmng failed: ifmng: Unable to query parameter default_certificate_id

0: /usr/local/psa/admin/htdocs/server/configure.php3:39

Can anybody help me to fix this?

Enviroment: SuSE Linux 10.1

Thanx
TOM

You should fix Plesk database manually to resolve this problem.
Get the list of all certificates exist in Plesk:

mysql> select id from certificates;

Configure Plesk to use an existent SSL certificate, one of psa.certificates.id:

mysql> replace into misc values ('default_certificate_id',<ID>);

./anb

 

[anb_t]

Re: This is what it shows now!

Originally posted by fr-k.de
... could be one step ahead?

---
ERROR: PleskFatalException
Unable to get default language.

0: /usr/local/psa/admin/plib/common_func.php3:156
psaerror(string 'Unable to get default language.')
1: /usr/local/psa/admin/plib/countries.php3:293
locale_list()
2: /usr/local/psa/admin/plib/common_func.php3:1604
locale_exists(string 'de-DE')
3: /usr/local/psa/admin/plib/class.Session.php:162
Session->Session()
4: /usr/local/psa/admin/auto_prepend/auth.php3:157
---
I don't how I fixed the certificate problem, but there is still no solution to get into plesk. Any idea with this psa error message?

Thanx
tom

Try this:

mysql> select * from locales;
+-------+--------+
| id | active |
+-------+--------+
| de-DE | true |
| en-US | true |
| es-ES | true |
| fr-FR | true |
| it-IT | true |
| ja-JP | true |
| ru-RU | true |
| zh-CN | true |
| zh-TW | true |
+-------+--------+
9 rows in set (0.00 sec)

mysql> replace into misc values ('def_locale','en-US');
Query OK, 2 rows affected (0.01 sec)

mysql>

./anb

 

[fr-k.de]

That's it

thanx a lot!

Ciao
TOM