Plesk 10.4.4 #36: Can't start the Application-Fault

[chevalo1963]

Hi there,

if i choose in the panel 'Application-Fault', i'm getting this error:

Internal error: [MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1-log]Table 'apsc.aps_package' doesn't exist

and it is right: the database 'apsc' exitst, but there are no records.

Please tell me, how can i fix this?

Thank you very much.

P.S. Environment is Linux 2.6.32-5-amd64 with Debian Squeeze and all upgrades.

 

[IgorG]

Looks like post-upgrade issue. Did you try to fix it with bootstrapper repair?

 

[chevalo1963]

Hi Igor,

yes, i did:

root@server1 /opt/psa/bootstrapper/pp10.13.4-bootstrapper # ./bootstrapper.sh repair
===> Preparing upgrade
Stopping psa... done
psa is stopped
Stopping psa... done
===> Cumulative database upgrade has been started
===> Upgrade completed.
Reloading Postfix configuration...done.
update-rc.d: using dependency based boot sequencing
insserv: warning: script 'denyhosts' missing LSB tags and overrides
insserv: warning: script 'denyhosts_unlock_ip' missing LSB tags and overrides
update-rc.d: using dependency based boot sequencing
insserv: warning: script 'denyhosts' missing LSB tags and overrides
insserv: warning: script 'denyhosts_unlock_ip' missing LSB tags and overrides
Module ssl already enabled
ln: creating symbolic link `/var/named/run-root/etc/bind/rndc.conf': File exists
update-rc.d: using dependency based boot sequencing
update-rc.d: error: unable to read /etc/init.d/named
mknod: `/var/www/vhosts/chroot/dev/null': File exists
Module suexec already enabled
Module include already enabled
Module rewrite already enabled
Module userdir already enabled
===> Cumulative upgrade has been started
===> Upgrade completed.
Module dav already enabled
Considering dependency dav for dav_fs:
Module dav already enabled
Module dav_fs already enabled
Module auth_digest already enabled
Module authz_user already enabled
Module dav_lock already enabled
update-rc.d: using dependency based boot sequencing
update-rc.d: warning: psa start runlevel arguments (2 3 4 5) do not match LSB Default-Start values (2 3 5)
insserv: warning: script 'denyhosts' missing LSB tags and overrides
insserv: warning: script 'denyhosts_unlock_ip' missing LSB tags and overrides
Stopping psa... done
Starting psa... done
Starting xinetd service... done
Starting bind9 service... done
Starting mysql service... done
Starting postgresql service... done
Starting psa-spamassassin service... done
Plesk: Starting Mail Server... already started
Starting psa... done

Congratulations!
All stages of the upgrade were successful.
psa is now running on your system.
To complete the system configuration process, please proceed to URL:
https://my-domain.de:8443/ or
https://xxx.xxx.xxx.xxx:8443/
Use 'admin' and '<YOUR ADMIN PASSWORD>' as login name and password.

Further, use the following commands to start and stop the system:
/etc/init.d/psa start and
/etc/init.d/psa stop respectively.

database 'aspc' is still empty and 'Application-Fault' still did'nt work.

Any other ideas?

regards
chris

 

[IgorG]

Do you have file /usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/db/apsc_mysql_db.sql ?
If yes - try to create apsc database with it.

 

[chevalo1963]

Hi Igor,

I try to build the apsc-database with the file usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/db/apsc_mysql_db.sql, but they're happens very crasy things in phpMyAdmin:

1. there ist the message: "no tables found in this database" an i did'nt see any tables in this database 'aspc'
2. if i try to create the table 'aps_package' via SQL-Command, i get the Message "#1050 - Table 'aps_package' already exists"?! (see left attached pic)
3. in plesk 'Application-Fault' the error message is: "[MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1-log]Table 'apsc.aps_package' doesn't exist" (see right attached pic)
3. if i try "SHOW TABLES" in phpMyAdmin it shows all necessary tables (see middle attached pic)

So - i think, there is a problem with user- and databaserights.

What default rights need database 'apsc' and user 'apsc' respectively?

Many thanks in advance and best regards
chris

 

[chevalo1963]

Hi there

nobody have a idea? I'm at my wits' end. :/
Maybee can anyone to cite as an example it's own access settings for database 'aspc' and user 'aspc' as a screenshot? My Plesk-Version = 10.4.4 #36.

Many thanks in advance and best regards
chris

 

[IgorG]

Did you try contact Parallels Support Team?