Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month at the Massachusetts Institute of Technology, in Building E51.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] mysql problem



john hall writes:
> I'm still figuring this out too.  MariaDB is the
> version/branch included with Fedora 19, 20 and RHEL 7.  I
> believe you will find an additional repository like
> repo.mysql.com  is enabled in the list from: #yum repolist

moylan ~[1025] yum repolist
Loaded plugins: langpacks, refresh-packagekit
repo id                                  repo name                       status
fedora/20/x86_64                         Fedora 20 - x86_64              38,597
!mysql-connectors-community/20/x86_64    MySQL Connectors Community          19
!mysql-tools-community/20/x86_64         MySQL Tools Community               13
!mysql56-community/20/x86_64             MySQL 5.6 Community Server          89
!updates/20/x86_64                       Fedora 20 - x86_64 - Updates    20,178
repolist: 58,896

> I suspect it may be smoother to use MariaDB since that is
> what the rest of the packages in the  distro will be tuned
> for, but it really might not make much difference in the
> long run. Please share differences if you learn about any.

> To find your logs you might type
> # ps aux | egrep mysql
> as root and look at the command line for the main process
> which will might list the log file path as an option.

root ~[404] ps -au root | egrep mysql
27517     0 Ss   12:35 /bin/bash /usr/bin/mysql-systemd-start post
28358     0 S+   12:39 egrep --color=auto mysql

> This works for mariadb - the error logs are by default at:
> /var/log/mariadb/mariadb.log
> and the service name is mariadb.service.  The mysql name is
> used by mariadb in some seemingly random places - I imagine
> for backward compatibility with some tools. ( I think the
> socket file is one example.) It seems at least that the
> database and connections work the same way.

/var/log/mariadb/ does not exist.
this from /var/log/mysqld.log:

141107 10:17:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-11-07 10:17:01 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-11-07 10:17:01 2224 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2014-11-07 10:17:01 2224 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)

2014-11-07 10:17:01 2224 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2014-11-07 10:17:01 2224 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

2014-11-07 10:17:01 2224 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-07 10:17:01 2224 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-07 10:17:01 2224 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-11-07 10:17:01 2224 [Note] InnoDB: Memory barrier is not used
2014-11-07 10:17:01 2224 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-07 10:17:01 2224 [Note] InnoDB: Using Linux native AIO
2014-11-07 10:17:01 2224 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-07 10:17:01 2224 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-11-07 10:17:01 2224 [Note] InnoDB: Completed initialization of buffer pool
2014-11-07 10:17:01 2224 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2014-11-07 10:17:01 2224 [ERROR] InnoDB: The system tablespace must be writable!
2014-11-07 10:17:01 2224 [ERROR] Plugin 'InnoDB' init function returned error.
2014-11-07 10:17:01 2224 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-11-07 10:17:01 2224 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-11-07 10:17:01 2224 [ERROR] Aborting

2014-11-07 10:17:01 2224 [Note] Binlog end
2014-11-07 10:17:01 2224 [Note] Shutting down plugin 'partition'
   .
   .
   .
2014-11-07 10:17:01 2224 [Note] /usr/sbin/mysqld: Shutdown complete

141107 10:17:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

root ~[420] mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed

(both mysql and mysqlcheck exist in /usr/bin)

ugh.

david kramer writes:
> This may be old information, but it at USED TO be the case that:

> - mysql could be configured to listen on a socket or listen
> to a IP address and port.
> - mysql, as shipped, would only respond to localhost
> I would check that in the configuration.

> You might also want to try "mysql -h localhost" to try to connect over
> IP instead of socket.

root ~[422] mysql -h localhost
ERROR 2002 (HY000): Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)

i also tried:

root ~[423] mysql --bind-address=127.0.0.1
ERROR 2002 (HY000): Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)

thanks, still fumbling, struggling.

ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[avoid html waste.]



BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org