Application Vault and ASP Catalog error

[Loup Artic]

Dear,

If i click in the menu "Applications", i have fatal error :

: PleskBadURIException



Invalid ID value:

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/UIPointer.php:91
UIPointer->__construct(object of type plesk__server__application_vault__package, string 'id', boolean false)
1: /usr/local/psa/admin/plib/UIPointer.php:151
UIPointer->append(string 'item', string 'id', boolean false)
2: /usr/local/psa/admin/plib/SiteApps/APSApplicationsList.php:336
APSApplicationsList->getSwitchStatusButton(integer '19')
3: /usr/local/psa/admin/plib/SiteApps/APSApplicationsList.php:472
APSApplicationsList->nameGet(integer '19')
4: /usr/local/psa/admin/plib/class.cList.php3:1319
cList->getTableBody_()
5: /usr/local/psa/admin/plib/class.cList.php3:1123
cList->getTable_()
6: /usr/local/psa/admin/plib/class.cList.php3:670
cList->get()
7: /usr/local/psa/admin/plib/ui/server.application-vault.php:177
plesk__server__application_vault->accessMainForm(object of type APSApplicationsList)
8: /usr/local/psa/admin/plib/ui/server.application-vault.php:63
plesk__server__application_vault->accessItem(string 'GET', NULL null)
9: /usr/local/psa/admin/plib/UIPointer.php:594
UIPointer->access(string 'GET')
10: /usr/local/psa/admin/htdocs/plesk.php:37

Any idea ?

 

[BMSLTD]

I have the same fatal problem and don't find solutions

 

[Loup Artic]

Fiou...

Mass bug in Plesk 9 :/.

 

[pbosgraaf]

Yep, seems like that
All our servers Fedora 4 - Fedora 7 and CentOS5 seem to have this problem.

Cheers,
Peter

 

[ckraul]

any update on a fix for this?

 

[mapogora]

Hi,


The table SiteApps from DB psa is the problem, I'm delete all records referring applications or domain that don't exists and now is fixed.


The broken applications shows in any domain Summary report.


My english is very bad.
Sorry.

MPGR

 

[LegolasTheElf]

can you better explicit what you have done to solve the error?

 

[PSCGi]

I think he means this in English...

Hi,

The table SiteApps from DB psa is the problem, I'm delete all records referring applications or domain that don't exists and now is fixed.

The broken applications shows in any domain Summary report.
MPGR

OK, now that I'm stuck on 9.0.0 and have the same error, lemme see if
I get what he's said...

I believe the stupid 'mailer 6.3' thing is the problem because of the
warnings previously in 8.X and now on top of some menus in 9.0.0
So we gotta blow away any Applications that don't exist. Normally
we'd do that in the Applications panel, but the geniasses at Parallels
created this bug instead so we have to do it manually.

Looks like he went into the Database 'psa' via MySQL (or whatever)
and found the table inside called 'SiteApps'. That lists all the Apps
we say we're supposed to have, but one of them is obviously missing
and there could be more problems - he doesn't specify all the way.

So we go in that table and delete all entry lines in SiteApps with
things we don't have - then the errors stop and the page appears
as normal. Apparently if we go to any of the domain's Summary
reports (somewhere, not sure offhand) we'll get a listing of all the
bad programs and URL's in that table that we gotta blow away.

Leave it to Parallels to create it's own mess we gotta clean up!

 

[PSCGi]

And, as I feared... without enough details on what he edited out
to get rid of the bug, I found something in the actual SiteApps
table via MySQL interface via the Control Panel.

But, makes little sense and it's a one-liner that says 'mailer'. When
I dug around, I found in the SiteApps stuff in this database that
everything's there BUT 'mailer 6.3.x' as we've seen since at least
8.6, maybe earlier - that's what's causing this. But the dopes wrote
the new CP so that it's producing errors even in the place we need
to get to take it out! Otherwise you have to hand-edit it like this,
but until someone with more experience states clearly what lines
were safely removed... I ain't touchin that DB, no way. Got enough
hassles with these bugs as it is!

Anyone?

 

[PSCGi]

Warning: Unable to register the web application located in the directory "mailer-6.3-3": The uploaded web application does not conform to the AppPacks specifications: DOMDocument::relaxNGValidate() [<a href='domdocument.relaxngvalidate'>domdocument.relaxngvalidate</a>]: Type nonNegativeInteger doesn't allow value ''. DOMDocument::relaxNGValidate() [<a href='domdocument.relaxngvalidate'>domdocument.relaxngvalidate</a>]: Error validating datatype nonNegativeInteger. DOMDocument::relaxNGValidate() [<a href='domdocument.relaxngvalidate'>domdocument.relaxngvalidate</a>]: Element installed-size failed to validate content.. You should remove the web application from the server because it will not function properly.

This is what's doing us in. Apps are fine at each domain's level, but this
error shows up all over the place. And because of this defective App that
Parallels saddled us with and never cleared up totally - it's back.

What may have happened is those without the Hotfixes or who rolled
them back may have undone whatever was done to clean this mistake
up from the Apps section. Now that it's back, it's preventing us from
loading the main Server Apps page so we can add, delete or otherwise
modify/allocate Apps to our domains!

Somehow he edited this out of the Database section for it as mentioned,
but I can't locate more than one line that even seems close to be trying
to take out. Unless we're missing info that it's another table and not the
specific SiteApps one inside the 'psa' DB?

I tried taking out the visible line mentioned, has no effect so far at all
and can't get into that one page. Each of the errors specifies that we
need to remove this SiteApp specifically as he mentioned - just no clue
how to do so!

 

[Brujo]

seems that a fix is out for this issue: http://kb.odin.com/en/5874

Brujo

 

[PSCGi]

seems that a fix is out for this issue: http://kb.odin.com/en/5874
Brujo

ROFL, notice the date!

But a great find to fix this annyoing problem for sure, thanks
for tracking it down. I was in there all day yesterday finding
nothing so since they're overseas writing this stuff it must've
been on the 17th worklist of '**** to fix', LOL!

Luckily once we got over the major hitches to do the upgrade
it's been a couple minor ones like this that either solutions or
simple fixes are out.

Problem here is trying to do what was suggested, without the
details it's near impossible to completely pull that item out of
the Apps and fix it - hopefully this does that trick completely!

 

[PSCGi]

Geeze anyone else???

I just got the 9.0.0 'update' which specifically seems to address the problem
on the SiteApps but when I run it - squat. Still getting this same annoying
error page and even tried to use the Command Line Editor to rip out the
'mailer' software and try to fix it.

I need to get at the stupid thing, but all I get is this error page. My HSP
has an attitude about Plesk 9 already and won't support squat on it.

Anyone else try this 'patch' from them or find another Hotfix that might
actually work and allow us back into the stupid Applications area yet? I
really don't want to have to go through the hell of using the CLE every
time to add a package to a domain, this is getting outrageous!

 

[PSCGi]

Well, kinda?

seems that a fix is out for this issue: http://kb.odin.com/en/5874

Brujo

Thanks to this competent find, I completely blanked on the fact I hadn't
done it yet! LOL So, after mounds of frustration I gave it a shot...

Well kinda? I had to wade through the hastily made KB file, what it wants
to you do is wget the file down to THAT directory it mentions - nowhere
else! It'll actually be a second file because one already exists. So you
have to chown it to the right perms, copy the other as an emergency
backup somewhere else you decide and then rename what you d/l'ed to
the original filename of the one you moved so that it takes it's place.

Yes, there's shortcuts but don't yell at me if you screw up, this was the
safest way with backups.

Now, having done that, seems to work just fine. Finally lets me inside.
I haven't rebooted the box yet, learned my lesson on the upgrades so
I will ONLY because of the error on that pesky mailer 6.3 idiot thing that
won't go away. I even deleted it from the Vault and allegedly from the
system as well - still popping errors but able to use the Apps - thankfully!

If the reboot doesn't do the trick, then I'm stuck trying to get rid of
this error that it can't properly license the ****** (see earlier in the
thread) and I'd love to kick that to the curb. If that doesn't work then
my only other contemplation is to reinstall both versions of 'mailer' I see
now in the Vault/Apps setup and then erase them both in hopes that it
finally kicks it to the curb! Just don't want to get stuck with recreating
the same problem I started with, even though I can fix it fast now.

Any thoughts, someone start yappin!

 

[PSCGi]

Geeze... anyone know how to completely and accurately rip an application
out of the Apps?? Plesk simply masked over this without removing it at all
and the suckers still sitting there and tying to do the registration that will
fail. I did the Hotfix, it then asked me to redo the patch again in the Control
Panel. Did that. Then right to Apps and still this same annoying as hell error
warning that the Release 3 candidate needs to go. Now there is a Release 4
version installed in the Apps CP we see! Program still expensive and sucks.

Meanwhile, when you go to /usr/local/psa/var/cgitory and look at the SiteApps
guess what's there - RC3 and RC4! No uninstall easily visible, I read the older
Apps Package how-to from Plesk just to find this and it mentions something
running an uninstall script but it's nowhere to be found. Any attempts to take
it out or down at the CP level in 9.0.0 - can't find'em or make it work! Remove
does nothing more than take it from the list but not out of the Licensing set of
commands so each time it's still trying to kosher the license (which fails) and
gets the freakin error!

Anyone with a proper clue how too rip it out, please let me know because
I've tried to use the CLE, manually and more and I can't get it outta there.

 

[PSCGi]

STILL - no solutions to this and it sits there annoyingly...

The original version loader's gone from the APS Catalog,
so you can't put it in, have the system take it out. And
it's in pieces, so you can't simply rip out one without the
rest still reporting it as if it were there - thus the error.

Anyone?

 

[blank_page]

You need to link the appropriate application file with the application itself.
You can find this in :
/usr/local/psa/var/apspkgarc/archive-index.xml

Basically you have to remove a file like this (not necessarely this naming as some have proper naming):

app_dSVkBq.app.zip
from the
/usr/local/psa/var/apspkgarc
folder

and from:

/usr/local/psa/var/cgitory/

the folder with the application name.

 

[Amin Taheri]

You can remove an application from the server like this

/usr/local/psa/bin/siteapp --remove-from-server -sapp-name "NAME" -sapp-version "VERSION";

As an example, here is a small script that removed some of these mailer type apps

it will remove all versions of all these apps that are installed on the server and remove the RPMS as well - it also removes it from the clients application pools by removing from the server.

Maybe this can get you started in the right direction.

#!/bin/bash

echo Removing RPMS
rpm -e `rpm -qa |egrep -i 'formmail|mailer|nmsformmail' | grep 'psa-appvault'` >/dev/null 2>&1;

echo Removing from Plesk DB
mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -Ne "select name, version From SiteAppPackages where name in ('formmail|mailer|nmsformmail' );" > /tmp/applist.tmp
cat /tmp/applist.tmp | while read app; do
NAME=$(echo $app | awk {'print $1'});
VER=$(echo $app | awk {'print $2'});
/usr/local/psa/bin/siteapp --remove-from-server -sapp-name "$NAME" -sapp-version "$VER";
done

rm -Rf /tmp/applist.tmp