aktualizacja PHP z 5.1.x do 5.3.2

[App2Perfect.com 0]

witam,

 

dzisiaj przeprowadzilem aktualizację PHP ( ze wzgledu na wymóg Symfony )

 

przy okazji zainktualizowane zostały inne pakiety, niestety po aktualizacji i restarcie mysql'a, ten nie chce wstac

 

service mysqld restart

MySQL Daemon failed to start.

 

mysql restart

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

 

ostatnie wpisy w pliku log

 

100415 20:12:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

100415 20:12:10 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.

/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist

100415 20:12:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

100415 20:12:10 InnoDB: Started; log sequence number 0 742539

100415 20:12:10 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'

100415 20:12:10 [ERROR] Aborting

 

100415 20:12:10 InnoDB: Starting shutdown...

100415 20:12:16 InnoDB: Shutdown completed; log sequence number 0 742539

100415 20:12:16 [Note] /usr/libexec/mysqld: Shutdown complete

 

100415 20:12:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 

czy ktos spotkał sie z czyms podobnym na CentOS'ie?

[hemi 20]

Prawdopodobnie nadpisał ci się plik php.ini. Musisz podac w pliku php.ini sciezke do socketa mysql w mysql.default_socket. Poza tym odpal mysql_upgrade bo pluje się o brak upgrade'u baz po aktualizacji mysql'a

[App2Perfect.com 0]

Prawdopodobnie nadpisał ci się plik php.ini. Musisz podac w pliku php.ini sciezke do socketa mysql w mysql.default_socket. Poza tym odpal mysql_upgrade bo pluje się o brak upgrade'u baz po aktualizacji mysql'a

 

 

rzeczywiscie mam pusto

 

; Default socket name for local MySQL connects. If empty, uses the built-in

; MySQL defaults.

mysql.default_socket =

If empty, uses the built-in

; MySQL defaults.

 

jednak w plikach z poprzedniej wersji (porobionych podczas aktualizacji kopiach) wpisy te takze sa puste

 

Zauważyłem także ze pliki PHP aktualnie sa "pobierane" zamiast wykonywane przez Apache,

 

http://195.2.254.72/index.html

http://195.2.254.72/index2.php

 

Jak przywrócić poprzednią konfigurację?

 

EDIT: udało mi sie naprawić problem z PHP, proszę o pomoc z MySQL

 

EDIT: tak wyglada natomiast plik konfiguracyjny mysqla

 

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2

 

EDIT: problem rozwiazany wystarczyło przywrócic kopie konfiguracji w obu przypadkach

Edytowano Kwiecień 15, 2010 przez WSHE-Bydgoszcz (zobacz historię edycji)

[MiSi3kK 16]

Przy okazji zwróć uwagę na warningi - niby bzdura, ale lepiej zmienić wszystko wcześniej niż potem mieć jakieś problemy.