LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-08-2014, 11:07 PM   #1
weirdaljr
LQ Newbie
 
Registered: Oct 2008
Posts: 10

Rep: Reputation: 0
Ubuntu 14 VPS - mysql install fails after fresh OS install


Hello all, I am hoping you can help me as my VPS is unmanaged and I am not getting any help there.

Ubuntu 14.04 fresh vps load - 3gb ram - 2gb swap - 50gb hdd

After booting new VPS I run:
apt-get update
apt-get install mysql-server
...
...
...
Preparing to unpack .../libaio1_0.3.109-4_amd64.deb ...
Unpacking libaio1:amd64 (0.3.109-4) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../mysql-common_5.5.38-0ubuntu0.14.04.1_all.deb ...
Unpacking mysql-common (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package libmysqlclient18:amd64.
Preparing to unpack .../libmysqlclient18_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking libmysqlclient18:amd64 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package libdbi-perl.
Preparing to unpack .../libdbi-perl_1.630-1_amd64.deb ...
Unpacking libdbi-perl (1.630-1) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.025-1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.025-1) ...
Selecting previously unselected package libterm-readkey-perl.
Preparing to unpack .../libterm-readkey-perl_2.31-1_amd64.deb ...
Unpacking libterm-readkey-perl (2.31-1) ...
Selecting previously unselected package mysql-client-core-5.5.
Preparing to unpack .../mysql-client-core-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb
...
Unpacking mysql-client-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-client-5.5.
Preparing to unpack .../mysql-client-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-client-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-core-5.5.
Preparing to unpack .../mysql-server-core-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb
...
Unpacking mysql-server-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package psmisc.
Preparing to unpack .../psmisc_22.20-1ubuntu2_amd64.deb ...
Unpacking psmisc (22.20-1ubuntu2) ...
Setting up mysql-common (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 18109 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-server-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../libhtml-template-perl_2.95-1_all.deb ...
Unpacking libhtml-template-perl (2.95-1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.5.38-0ubuntu0.14.04.1_all.deb ...
Unpacking mysql-server (5.5.38-0ubuntu0.14.04.1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up libaio1:amd64 (0.3.109-4) ...
Setting up libmysqlclient18:amd64 (5.5.38-0ubuntu0.14.04.1) ...
Setting up libdbi-perl (1.630-1) ...
Setting up libdbd-mysql-perl (4.025-1) ...
Setting up libterm-readkey-perl (2.31-1) ...
Setting up mysql-client-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Setting up mysql-client-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Setting up mysql-server-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Setting up psmisc (22.20-1ubuntu2) ...
Setting up mysql-server-5.5 (5.5.38-0ubuntu0.14.04.1) ...
141009 2:37:51 [Warning] Using unique option prefix key_buffer instead of key_b
uffer_size is deprecated and will be removed in a future release. Please use the full name instead.

Terminal stalls there every time - multiple reimages of the vps including ubuntu 14.04 and debian 7 - same result.

The output above stop there right as a warning message box is shows due to "Unable to set mysql root password..."

Any suggestions or help would be greatly appreciated. I have been googling it for hours and reimaging the vps for days trying different things to make a simple "apt-get install mysql-server" complete on a clean os image.

Thanks!
 
Old 10-09-2014, 09:24 AM   #2
weirdaljr
LQ Newbie
 
Registered: Oct 2008
Posts: 10

Original Poster
Rep: Reputation: 0
Apt\History.log:

Quote:
Start-Date: 2014-10-09 01:56:43
Commandline: apt-get install mysql-server
Install: mysql-server-core-5.5:amd64 (5.5.38-0ubuntu0.14.04.1, automatic), mysql-server-5.5:amd64 (5.5.38-0ubuntu0.14.04.1, automatic), libaio1:amd64 (0.3.109-4, automatic), mysql-client-core-5.5:amd64 (5.5.38-0ubuntu0.14.04.1, automatic), psmisc:amd64 (22.20-1ubuntu2, automatic), mysql-client-5.5:amd64 (5.5.38-0ubuntu0.14.04.1, automatic), libhtml-template-perl:amd64 (2.95-1, automatic), libterm-readkey-perl:amd64 (2.31-1, automatic), mysql-common:amd64 (5.5.38-0ubuntu0.14.04.1, automatic), libmysqlclient18:amd64 (5.5.38-0ubuntu0.14.04.1, automatic), mysql-server:amd64 (5.5.38-0ubuntu0.14.04.1), libdbd-mysql-perl:amd64 (4.025-1, automatic), libdbi-perl:amd64 (1.630-1, automatic)
Apt\Term.log:


Quote:
Log started: 2014-10-09 01:56:43
Selecting previously unselected package libaio1:amd64.
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 17633 files and directories currently installed.)
Preparing to unpack .../libaio1_0.3.109-4_amd64.deb ...
Unpacking libaio1:amd64 (0.3.109-4) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../mysql-common_5.5.38-0ubuntu0.14.04.1_all.deb ...
Unpacking mysql-common (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package libmysqlclient18:amd64.
Preparing to unpack .../libmysqlclient18_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking libmysqlclient18:amd64 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package libdbi-perl.
Preparing to unpack .../libdbi-perl_1.630-1_amd64.deb ...
Unpacking libdbi-perl (1.630-1) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.025-1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.025-1) ...
Selecting previously unselected package libterm-readkey-perl.
Preparing to unpack .../libterm-readkey-perl_2.31-1_amd64.deb ...
Unpacking libterm-readkey-perl (2.31-1) ...
Selecting previously unselected package mysql-client-core-5.5.
Preparing to unpack .../mysql-client-core-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-client-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-client-5.5.
Preparing to unpack .../mysql-client-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-client-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-core-5.5.
Preparing to unpack .../mysql-server-core-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-server-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package psmisc.
Preparing to unpack .../psmisc_22.20-1ubuntu2_amd64.deb ...
Unpacking psmisc (22.20-1ubuntu2) ...
Setting up mysql-common (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 18016 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.5_5.5.38-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-server-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../libhtml-template-perl_2.95-1_all.deb ...
Unpacking libhtml-template-perl (2.95-1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.5.38-0ubuntu0.14.04.1_all.deb ...
Unpacking mysql-server (5.5.38-0ubuntu0.14.04.1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up libaio1:amd64 (0.3.109-4) ...
Setting up libmysqlclient18:amd64 (5.5.38-0ubuntu0.14.04.1) ...
Setting up libdbi-perl (1.630-1) ...
Setting up libdbd-mysql-perl (4.025-1) ...
Setting up libterm-readkey-perl (2.31-1) ...
Setting up mysql-client-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Setting up mysql-client-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Setting up mysql-server-core-5.5 (5.5.38-0ubuntu0.14.04.1) ...
Setting up psmisc (22.20-1ubuntu2) ...
Setting up mysql-server-5.5 (5.5.38-0ubuntu0.14.04.1) ...
141009 1:56:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
[?1049h[?25l(B                           (BPackage configuration(0lqqqqqqqqqqqqqqqqqqqqqu(B(B Configuring mysql-server-5.5 (0tqqqqqqqqqqqqqqqqqqqqqqkx(B(B (0x(B(B (B(0x(B(B Unable to set password for the MySQL "root" user (0x(B(B (B(0x(B(B (0x(B(B (B(0x(B(B An error occurred while setting the password for the MySQL (0x(B(B (B(0x(B(B administrative user. This may have happened because the account already (0x(B(B (B(0x(B(B has a password, or because of a communication problem with the MySQL (0x(B(B (B(0x(B(B server. (0x(B(B (B(0x(B(B (0x(B(B (B(0x(B(B You should check the account's password after the package installation. (0x(B(B (B(0x(B(B (0x(B(B (B(0x(B(B Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for (0x(B(B (B(0x(B(B more information. (0x(B(B (B(0x(B(B (0x(B(B (B(0x(B(B <Ok> (0x(B(B (B(0x(B(B (0x(B(B (B(0mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj(B(B  [?12l[?25h(B(B

[?1049l
Mysql\error.log:
Quote:
141009 1:56:52 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141009 1:56:52 [Note] Plugin 'FEDERATED' is disabled.
141009 1:56:52 InnoDB: The InnoDB memory heap is disabled
141009 1:56:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141009 1:56:52 InnoDB: Compressed tables use zlib 1.2.8
141009 1:56:52 InnoDB: Using Linux native AIO
141009 1:56:52 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
141009 1:56:54 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
141009 1:56:54 InnoDB: Fatal error: cannot initialize AIO sub-system
141009 1:56:54 [ERROR] Plugin 'InnoDB' init function returned error.
141009 1:56:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141009 1:56:54 [ERROR] Unknown/unsupported storage engine: InnoDB
141009 1:56:54 [ERROR] Aborting

141009 1:56:54 [Note] /usr/sbin/mysqld: Shutdown complete

...
****2500 lines of this repeating in the 8 minutes the server has been up ***

141009 2:03:53 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
141009 2:03:53 [Note] Plugin 'FEDERATED' is disabled.
141009 2:03:53 InnoDB: The InnoDB memory heap is disabled
141009 2:03:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141009 2:03:53 InnoDB: Compressed tables use zlib 1.2.8
141009 2:03:53 InnoDB: Using Linux native AIO
141009 2:03:53 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
141009 2:03:55 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
141009 2:03:55 InnoDB: Fatal error: cannot initialize AIO sub-system
141009 2:03:55 [ERROR] Plugin 'InnoDB' init function returned error.
141009 2:03:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141009 2:03:55 [ERROR] Unknown/unsupported storage engine: InnoDB
141009 2:03:55 [ERROR] Aborting

141009 2:03:55 [Note] /usr/sbin/mysqld: Shutdown complete
Can anyone help me trouble shoot this please? This has happened on fresh VPS server rebuilds using Ubuntu 14.04 64-bit, 32-but, and Debian 7.
 
Old 10-09-2014, 11:02 AM   #3
weirdaljr
LQ Newbie
 
Registered: Oct 2008
Posts: 10

Original Poster
Rep: Reputation: 0
Well I got it fixed after a few more hours of googling errors.

The problem seems to be a issue with OpenVZ VPSes.

It was fixed by creating a /etc/my.cnf file prior to installing mysql containing:

[mysqld]
innodb_use_native_aio = 0

Hopefully it saves some people time figuring this out.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Fresh Install / MySQL Issue jwebbb01 Slackware 2 01-26-2011 07:35 PM
Kubuntu v9.1 fails to boot after fresh install and display anomalies at the desktop jqpdev Linux - Desktop 5 03-24-2010 08:58 PM
KDE4 fails to start in fresh -current install chexmix Slackware 18 04-06-2009 11:12 AM
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 08:44 PM
fresh install of mysql but... bshearer *BSD 12 07-20-2005 10:56 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:26 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration