Web lists-archives.com

Post-installation config and startup questions




I'm building a mail system with Dovecot, Postfix and Mailman with
MySQL. I have the other three products installed but not yet
configured. I'll do that after I get MySQL running.

The documentation at
http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html
was instrumental in remedying some errors I made along the way by
following an installation procedure for Ubuntu instead of for Fedora.
The installation completed successfully.

The next step in the instructions I originally read said the next
thing to do was run mysql_install_db. It started out well:

Installing MySQL system tables...2015-06-23 11:54:50 0 [Warning]
TIMESTAMP with implicit DEFAULT value is deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation for
more details).
2015-06-23 11:54:50 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25) starting
as process 23737 ...
2015-06-23 11:54:50 23737 [Note] InnoDB: Using atomics to ref count
buffer pool pages
2015-06-23 11:54:50 23737 [Note] InnoDB: The InnoDB memory heap is
disabled
2015-06-23 11:54:50 23737 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
2015-06-23 11:54:50 23737 [Note] InnoDB: Memory barrier is not used
2015-06-23 11:54:50 23737 [Note] InnoDB: Compressed tables use zlib
1.2.3
2015-06-23 11:54:50 23737 [Note] InnoDB: Using Linux native AIO
2015-06-23 11:54:50 23737 [Note] InnoDB: Using CPU crc32 instructions
2015-06-23 11:54:50 23737 [Note] InnoDB: Initializing buffer pool,
size = 128.0M
2015-06-23 11:54:50 23737 [Note] InnoDB: Completed initialization of
buffer pool
2015-06-23 11:54:50 23737 [Note] InnoDB: Highest supported file format
is Barracuda.
2015-06-23 11:54:50 23737 [Warning] InnoDB: Resizing redo log from
2*320 to 2*3072 pages, LSN=1597945
2015-06-23 11:54:50 23737 [Warning] InnoDB: Starting to delete and
rewrite log files.
2015-06-23 11:54:50 23737 [Note] InnoDB: Setting log file
./ib_logfile101 size to 48 MB
2015-06-23 11:54:51 23737 [Note] InnoDB: Setting log file
./ib_logfile1 size to 48 MB
2015-06-23 11:54:52 23737 [Note] InnoDB: Renaming log file
./ib_logfile101 to ./ib_logfile0
2015-06-23 11:54:52 23737 [Warning] InnoDB: New log files created,
LSN=1597945
2015-06-23 11:54:52 23737 [Note] InnoDB: 128 rollback segment(s) are
active.
2015-06-23 11:54:52 23737 [Note] InnoDB: Creating tablespace and
datafile system tables.
2015-06-23 11:54:52 23737 [Note] InnoDB: Tablespace and datafile
system tables created.
2015-06-23 11:54:52 23737 [Note] InnoDB: Waiting for purge to start
2015-06-23 11:54:52 23737 [Note] InnoDB: 5.6.25 started; log sequence
number 1597945

And then things fell apart.

2015-06-23 11:54:52 23737 [ERROR] Incorrect definition of table
mysql.proc: expected column 'sql_mode' at position 14 to have type
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERRO
2015-06-23 11:54:52 23737 [ERROR] Incorrect definition of table
mysql.event: expected column 'sql_mode' at position 14 to have type
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'),
found type
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
ERROR: 1136  Column count doesn't match value count at row 1
2015-06-23 11:54:53 23737 [ERROR] Aborting

2015-06-23 11:54:53 23737 [Note] Binlog end
2015-06-23 11:54:53 23737 [Note] InnoDB: FTS optimize thread exiting.
2015-06-23 11:54:53 23737 [Note] InnoDB: Starting shutdown...
2015-06-23 11:54:54 23737 [Note] InnoDB: Shutdown completed; log
sequence number 1627743
2015-06-23 11:54:54 23737 [Note] /usr/sbin/mysqld: Shutdown complete

OK

Filling help tables...2015-06-23 11:54:54 0 [Warning] TIMESTAMP with
implicit DEFAULT value is deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation for
more details).
2015-06-23 11:54:54 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25) starting
as process 23762 ...
2015-06-23 11:54:54 23762 [Note] InnoDB: Using atomics to ref count
buffer pool pages
2015-06-23 11:54:54 23762 [Note] InnoDB: The InnoDB memory heap is
disabled
2015-06-23 11:54:54 23762 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
2015-06-23 11:54:54 23762 [Note] InnoDB: Memory barrier is not used
2015-06-23 11:54:54 23762 [Note] InnoDB: Compressed tables use zlib
1.2.3
2015-06-23 11:54:54 23762 [Note] InnoDB: Using Linux native AIO
2015-06-23 11:54:54 23762 [Note] InnoDB: Using CPU crc32 instructions
2015-06-23 11:54:54 23762 [Note] InnoDB: Initializing buffer pool,
size = 128.0M
2015-06-23 11:54:54 23762 [Note] InnoDB: Completed initialization of
buffer pool
2015-06-23 11:54:54 23762 [Note] InnoDB: Highest supported file format
is Barracuda.
2015-06-23 11:54:54 23762 [Note] InnoDB: 128 rollback segment(s) are
active.
2015-06-23 11:54:54 23762 [Note] InnoDB: Waiting for purge to start
2015-06-23 11:54:54 23762 [Note] InnoDB: 5.6.25 started; log sequence
number 1627743
2015-06-23 11:54:55 23762 [Note] Binlog end
2015-06-23 11:54:55 23762 [Note] InnoDB: FTS optimize thread exiting.
2015-06-23 11:54:55 23762 [Note] InnoDB: Starting shutdown...
2015-06-23 11:54:56 23762 [Note] InnoDB: Shutdown completed; log
sequence number 1627753
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

; I don't know what those are, or where they are.
; 'find' didn't find them.

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

  /usr/bin/mysqladmin -u root password 'new-password'
  /usr/bin/mysqladmin -u root -h patronus.theglobalvoice.info password
'new-password'

Alternatively you can run:

  /usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

  cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

  cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

Since this is a new installation, I decided to take the advice of the
automated instructions:

# mysqld_safe --defaults-file
150623 11:58:52 mysqld_safe Logging to '/var/log/mysqld.log'.
150623 11:58:52 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
150623 11:58:53 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended

Unless I'm an absolute dolt, this looked successful. Since this was my
first time running MySQL, I tried the next step as if it were a new
install, which it's supposed to be:

# /usr/bin/mysql_secure_installation



NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Enter current password for root (enter for none): ^C
Aborting!

Cleaning up...
Cleaning up...
Warning: Could not unlink .my.cnf.24101: No such file or directory
Warning: Could not unlink .mysql.24101: No such file or directory

And that's where things are.

Any help greatly appreciated.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql