TranscendLinux.com

Error:

Trying to apply 7.5.4 changes to database... ERROR 1067 (42000) at line 1: Invalid default value for 'srv_bandwidth'

Fix:

USE psa;
ALTER TABLE `module_bf1942_servers` CHANGE `srv_bandwidth` `srv_bandwidth`
ENUM( '0', '8', '16', '32', '64', '128', '256', '512' )
CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0';

Note: The table name may also be module_bf2_servers, depending on Plesk version.

Error:

Trying to stop BIND server... done
 Trying to untar named run-root directory structure... done
 Trying to set up default permissions...
ERROR while trying to set up default permissions

Fix:

umount /var/named/run-root/proc

Edit /etc/init.d/named and comment out the following:

#               if ! egrep -q '^/proc[[:space:]]+'${ROOTDIR}'/proc' /proc/mounts; then
#                   mount --bind /proc ${ROOTDIR}/proc >/dev/null 2>&1
#               fi

chown -R named:named /var/named/run-root/
service named start

Then reinstall the psa-X.Y.Z rpm (you'll probably need to --force it)

Issue:
Drweb doesn't show up in the control panel.

Solution:
The drweb entry in the psa.Components database needs to be updated to reflect the correct version (this can generally be found in the drweb-qmail entry). I'll update this with a query to do so later.

UPDATE Components SET version='[versionstring from drweb-qmail]' WHERE name='drweb';

Error:
Plesk 8.1 upgrade on RHEL3 results in errors regarding the "fastcgi" column

ERROR: PleskMainDBException   Add To FavoritesAdd To Favorites
MySQL query failed: Unknown column 'fastcgi' in 'field list'
------------------------------------------------------------------------
0: /usr/local/psa/admin/plib/common_func.php3:218
  db_query(string 'select
  `dom_id`,`sys_user_id`,`ip_address_id`,`ssl`,`same_ssl`,`fp`,`fp_ssl`,`fp_enable`,
`fp_adm`,`fp_pass`,`ssi`,`php`,`php_safe_mode`,`cgi`,`perl`,`python`,`fastcgi`,`coldfusion`,
`asp`,`asp_dot_net`,`webstat`,`at_domains`
  from hosting where `dom_id`=2')
1: /usr/local/psa/admin/plib/class.Table.php:179
  Table->select()
2: /usr/local/psa/admin/plib/class.cObject.php:447
  cObject->fetchAttrsFromTable_()
3: /usr/local/psa/admin/plib/class.PHosting.php:69
  PHosting->PHosting(string '2')
4: /usr/local/psa/admin/plib/common_func.php3:2828
  objectMaker(string 'PHosting', string '2')
5: /usr/local/psa/admin/plib/class.DomainControlForm.php:146
  DomainControlForm->assign(object of type BsDomain)
6: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:147

Fix:

ALTER TABLE hosting ADD `fastcgi` enum('false','true') NOT NULL default 'false';
ALTER TABLE subdomains ADD `fastcgi` enum('false','true') NOT NULL default 'false';
ALTER TABLE web_users ADD `fastcgi` enum('false','true') NOT NULL default 'false';
/usr/local/psa/admin/sbin/websrvmng -a -v

Issue:
Upgrading to Plesk 8 on RHEL3 results in Spamassassin perl 5.8.0 compatibility issue, e.g.

[12414] error: persistent_udp: no such method at /usr/lib/perl5/site_perl/5.8.0/Mail/SpamAssassin/DnsResolver.pm line 99

Fix:

perl -MCPAN -e shell
install Net::DNS

Script for manually converting the psa database to InnoDB:

for t in $(mysql -uadmin -p`cat /etc/psa/.psa.shadow` --batch --column-names=false -e "show tables" psa)
do
mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "alter table $t type=InnoDB" psa
done

-----

Courtesy of Matt Thompson:

Incase you're not aware, there's a little issue with Plesk 8.2.0
upgrades where it modifies /etc/sysconfig/rhn/sources with custom SWsoft
repositories. This in itself is a concern (automated Plesk updates?)
but the immediate issue is that there's no GPG key file installed for
these packages and up2date then aborts when it runs nightly because it
can't verify the SWsoft packages that it tries to pull down. I've
created a ticket w/ SWsoft and they said a GPG key will most likely be
bundled in 8.2.1, which is slated for October.

So, if you do perform an upgrade to 8.2.0, please do the following when
the update has finished:

echo ALLOW_TO_USE_UP2DATE=no > /root/.autoinstallerrc

You can then remove all those custom repos from
/etc/sysconfig/rhn/sources so that they're no longer queried when
up2date runs.

Further to this, there's a bug with the updater where it continuously
updates /etc/sysconfig/rhn/sources with those custom repos, so don't be
alarmed if you see numerous repeats for the same repos.

---

Upgrade to Plesk 8.2 fails with the following error:

===> Installing psa database
mysqld (pid 2064) is running...
Trying to define valid mysql credentials... Trying to establish test
connection... connected
done
Trying to remove chunks from MySQL database... ERROR 1062 (23000) at line 3:
Duplicate entry 'localhost-admin' for key 1

ERROR while trying to remove chunks from MySQL database

see http://kb.swsoft.com/en/2013