В общем установка проходит криво и никак не могу понять в чем дело. Вот что выводит мне:
[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]
Debian и установка mysql
kakawkin, удали мускл (purge) вместе со всеми конфигами, потом заново поставь, чтобы встал дефолтный его конфиг.
Поиск по форуму рулит (mysql), дефолтный my.cnf от дебиан недавно выкладывал.
ы. Можно добавить в секцию [mysqld] параметр
skip-innodbПотом:
dpkg --configure mysql-serverудалять как я понял надо apt-get purge mysql-server*. А где конфиги находятся все ?
/etc/mysql/my.cnf...
/etc/mysql
/var/lib/mysql
/usr/share/mysql
/usr/share/mysql-commonhttp://linuxforum.ru/viewtopic.php?pid=256711#p256711
http://linuxforum.ru/viewtopic.php?pid=256773#p256773
/etc/mysql/my.cnf
http://paste.pocoo.org/show/567558/
практически деолтный, добавлено только skip-innodb, потому как не пользуюсь.
Все сделал но при установке все равно ошибка выводится:
[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]
aptitude purge mysql-server mysql-client mysql-commonls /etc/mysql
ls /var/lib/mysql
ls /usr/share/mysql
ls /usr/share/mysql-commonВыхлоп покажи.
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]
kakawkin, я попросил выхлоп по-очереди всех команд http://linuxforum.ru/viewtopic.php?pid=260907#p260907
Потом на основании что в выхлопе дальнейшие рекомендации.
Я считай купил 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 а мне надо что-то колдовать
Ни на каких виртуальных машинах там не ставиться.
Пробовал на 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
в общем отказался я от VPS одного центра - ничего не ставится, ни лампа, дистрибутив ихний не обновляется вообще ошибки прут по репозиториям хотя пробовал все.
Дома поставил на виртуалку Debian - и все сразу получилось. Буду делать на виртуалке =)