LinuxForum.Fans
Тема

Debian и установка mysql

Автор: kakawkin 13 сообщений 7124 просмотров
#238745

В общем установка проходит криво и никак не могу понять в чем дело. Вот что выводит мне:
[console]
root@vps:/var/www# apt-get install mysql-server mysql-client
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
mysql-server-5.1
Suggested packages:
tinyca
The following NEW packages will be installed:
mysql-client mysql-server mysql-server-5.1
0 upgraded, 3 newly installed, 0 to remove and 69 not upgraded.
Need to get 65.2 kB/6659 kB of archives.
After this operation, 14.5 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://ftp.debian.org/debian/ squeeze/main mysql-client all 5.1.49-3 [65.2 kB]
Fetched 65.2 kB in 0s (159 kB/s)
Preconfiguring packages ...
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 41371 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.49-3_i386.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.1.49-3_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.49-3_all.deb) ...
Setting up mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
120318 22:29:28 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: pthread_create returned 11
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up mysql-client (5.1.49-3) ...
configured to not write apport reports
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.1; however:
Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
[/console]

#238747

kakawkin, удали мускл (purge) вместе со всеми конфигами, потом заново поставь, чтобы встал дефолтный его конфиг.
Поиск по форуму рулит (mysql), дефолтный my.cnf от дебиан недавно выкладывал.

#238748

ы. Можно добавить в секцию [mysqld] параметр

text
skip-innodb

Потом:

text
dpkg --configure mysql-server
#238750

удалять как я понял надо apt-get purge mysql-server*. А где конфиги находятся все ?

#238759

/etc/mysql/my.cnf
http://paste.pocoo.org/show/567558/
практически деолтный, добавлено только skip-innodb, потому как не пользуюсь.

#238762

Все сделал но при установке все равно ошибка выводится:
[console]root@home:/etc/mysql# aptitude install mysql-server-5.1
The following NEW packages will be installed:
mysql-client-5.1{a} mysql-server-5.1
0 packages upgraded, 2 newly installed, 0 to remove and 67 not upgraded.
Need to get 0 B/16.1 MB of archives. After unpacking 37.2 MB will be used.
Do you want to continue? [Y/n/?] Y
Preconfiguring packages ...
Selecting previously deselected package mysql-client-5.1.
(Reading database ...
dpkg: warning: files list file for package `mysql-server-core-5.1' missing, assuming package has no files currently installed.
(Reading database ... 10%
dpkg: warning: files list file for package `libmysqlclient16' missing, assuming package has no files currently installed.
(Reading database ... 15%
dpkg: warning: files list file for package `mysql-common' missing, assuming package has no files currently installed.
(Reading database ... 44368 files and directories currently installed.)
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.49-3_i386.deb) ...
Selecting previously deselected package mysql-server-5.1.
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.49-3_i386.deb) ...
Setting up mysql-client-5.1 (5.1.49-3) ...
Setting up mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
120318 23:57:20 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.1
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.1

root@home:/etc/mysql#
[/console]

#238764
text
aptitude purge mysql-server mysql-client mysql-common
text
ls /etc/mysql 
ls /var/lib/mysql 
ls /usr/share/mysql 
ls /usr/share/mysql-common

Выхлоп покажи.

#238769

ls /etc/mysql [console]conf.d debian-start debian.cnf my.cnf[/console]
ls /var/lib/mysql [console]debian-5.1.flag ib_logfile0 ib_logfile1 ibdata1 mysql[/console]
ls /usr/share/mysql [console]
charsets french ndb-config-2-node.ini
config.huge.ini german norwegian
config.medium.ini greek norwegian-ny
config.small.ini hungarian polish
czech italian portuguese
danish japanese romanian
debian-start.inc.sh korean russian
dutch mysql-test serbian
echo_stderr mysql_fix_privilege_tables.sql slovak
english mysql_system_tables.sql spanish
errmsg.txt mysql_system_tables_data.sql swedish
estonian mysql_test_data_timezone.sql ukrainian
fill_help_tables.sql mysqld_multi.server
[/console]
ls /usr/share/mysql-common [console]internal-use-only[/console]

#238814

Я считай купил VPS - 150р не слишком большие деньги, зато за 5 минут могу переустановить дебиан из-за своих косяков. И при установке вот что:
[console]
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = (nil) thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x2d) [0xb7dc65cd]
/usr/sbin/mysqld(handle_segfault+0x494) [0xb7a8dc14]
/lib/libpthread.so.0(+0xde68) [0xb77ece68]
/lib/libc.so.6(abort+0x182) [0xb7523922]
/usr/sbin/mysqld(page_cur_search_with_match+0x9a3) [0xb7ce4843]
/usr/sbin/mysqld(btr_cur_search_to_nth_level+0x5ae) [0xb7c7af0e]
/usr/sbin/mysqld(btr_pcur_open_on_user_rec+0x73) [0xb7d45a03]
/usr/sbin/mysqld(+0x480df5) [0xb7c9adf5]
/usr/sbin/mysqld(dict_load_sys_table+0x75) [0xb7ca1725]
/usr/sbin/mysqld(dict_boot+0xd27) [0xb7d46c57]
/usr/sbin/mysqld(innobase_start_or_create_for_mysql+0x1299) [0xb7d1ce19]
/usr/sbin/mysqld(+0x44f8f6) [0xb7c698f6]
/usr/sbin/mysqld(ha_initialize_handlerton(st_plugin_int*)+0x3f) [0xb7b9c4ef]
/usr/sbin/mysqld(+0x422f7f) [0xb7c3cf7f]
/usr/sbin/mysqld(plugin_init(int*, char**, int)+0x89f) [0xb7c4090f]
/usr/sbin/mysqld(+0x275e72) [0xb7a8fe72]
/usr/sbin/mysqld(main+0x1fa) [0xb7a9360a]
/lib/libc.so.6(__libc_start_main+0xe6) [0xb750cc76]
/usr/sbin/mysqld(+0x18e6d1) [0xb79a86d1]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
Setting up heirloom-mailx (12.4-2) ...
update-alternatives: using /usr/bin/heirloom-mailx to provide /usr/bin/mailx (mailx) in auto mode.
Setting up libhtml-template-perl (2.9-2) ...
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.1; however:
Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@vps:~#
[/console]
Ну кажется мне что VPS кривой. Потому что я с нуля даже ставил mysql-server - все равно ошибки выдает. Ну не может же быть такое что все ставят просто apt-get install mysql-server а мне надо что-то колдовать

#238819

Ни на каких виртуальных машинах там не ставиться.
Пробовал на CentOs 5,6 на Fedora и на Ubuntu - и везде одно и то же, при установке выводятся ошибки вида
[console]/usr/sbin/mysqld(btr_cur_search_to_nth_level+0x5ae) [0xb7c7af0e]
/usr/sbin/mysqld(btr_pcur_open_on_user_rec+0x73) [0xb7d45a03]
/usr/sbin/mysqld(+0x480df5) [0xb7c9adf5]
/usr/sbin/mysqld(dict_load_sys_table+0x75) [0xb7ca1725]
/usr/sbin/mysqld(dict_boot+0xd27) [0xb7d46c57]
/usr/sbin/mysqld(innobase_start_or_create_for_mysql+0x1299) [0xb7d1ce19]
/usr/sbin/mysqld(+0x44f8f6) [0xb7c698f6]
/usr/sbin/mysqld(ha_initialize_handlerton(st_plugin_int*)+0x3f) [0xb7b9c4ef]
/usr/sbin/mysqld(+0x422f7f) [0xb7c3cf7f]
/usr/sbin/mysqld(plugin_init(int*, char**, int)+0x89f) [0xb7c4090f]
/usr/sbin/mysqld(+0x275e72) [0xb7a8fe72]
/usr/sbin/mysqld(main+0x1fa) [0xb7a9360a]
/lib/libc.so.6(__libc_start_main+0xe6) [0xb750cc76][/console]
Т.е. на сколько понимаю это ошибки при работе с памятью VPS'a

#238830

в общем отказался я от VPS одного центра - ничего не ставится, ни лампа, дистрибутив ихний не обновляется вообще ошибки прут по репозиториям хотя пробовал все.
Дома поставил на виртуалку Debian - и все сразу получилось. Буду делать на виртуалке =)

Войдите или зарегистрируйтесь, чтобы ответить.