Plesk 6 -> 7 upgrade [MySQL causes errors]

[Verwijderd]

code:

[root@server02 base]# rpm -Uvh psa-7.0.0-rh9.build040205.22.i586.rpm
Preparing...                ########################################### [100%]

 Trying to define super-server internet daemon type... xinetd
 Trying to check if xinetd daemon is running... done
===> Reading /etc/psa/psa.conf ...

 Making some checks before upgrading

 Now BIND server shutting down...

 Trying to stop BIND server... done
 Trying to start BIND server... done

 BIND server starts Ok.

Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
Usage: /etc/init.d/mysqld start|stop|restart
 Cannot start Mysql server

ERROR while trying to  check Plesk Database version
Check the error reason, fix and try again

Aborting...

error: %pre(psa-7.0.0-rh9.build040205.22) scriptlet failed, exit status 1
error:   install: %pre scriptlet failed (2), skipping psa-7.0.0-rh9.build040205.22
[root@server02 base]#

code:

[root@server02 init.d]# ls -al my*
-rwxr-xr-x    1 root     root         5575 Feb 12 18:02 mysql
-rwxr-xr-x    1 root     root         5575 Feb 18 10:25 mysqld
[root@server02 init.d]#

MySQL blijft dit maar geven. Het init-script van MySQL-4 geeft natuurlijk geen output weer bij service mysqld start, maar werkt wel gewoon. Het oude init-script proberen werkt niet. Dit heb ik al geprobeerd.

code:

<sprintserve> why don't youjust reinstall Mysql?
<mr-d> I already reinstalled mySQL
<mr-d> mysql-3.23.x didn't want to start though
<mr-d> I am now on MySQL 4.x
<mr-d> but mysql4 doesn't pass the 'Does MySQL work' Plesk-test :(

Wat kan ik het beste doen?

[ Voor 4% gewijzigd door Verwijderd op 18-02-2004 12:26 ]

[Wilke]

Het lijkt er op dat dat script van Plesk het opstartscript van MySQL niet op de juiste manier aanroept?

Da's vreemd, maar als je MySQL met de hand start kun je zeer zeker in de logfiles van MySQL zien (/var/log/....) of er daarbij iets mis gaat.

[Verwijderd]

code:

[root@server02 log]# /etc/init.d/mysql restart
Killing mysqld with pid 11742
[root@server02 log]# tail mysqld.log
040218 12:50:05  /usr/sbin/mysqld-max: Normal shutdown
040218 12:50:05  /usr/sbin/mysqld-max: Shutdown Complete
040218 12:50:05  mysqld ended
040218 12:50:06  mysqld started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.18-Max-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
[root@server02 log]#

Plesk gaat volgens mij uit van MySQL-3.

Maar downgraden naar MySQL-3 werkte niet. Dan kon MySQL niet starten.

my.cnf

code:

[root@server02 log]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=150M
join_buffer=1M
max_allowed_packet=16M
table_cache=512
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout
[root@server02 log]#

Is het te adviseren om nogmaals MySQL-3 proberen te installeren, omdat deze meer kans heeft om door de Plesk mysql-check heen te komen?

[ Voor 55% gewijzigd door Verwijderd op 18-02-2004 12:55 ]