Starting mysql

Sun Dec 11 20:52:55 UTC 2011

Did you initialize databases as suggested (mysql_install_db) ?

On Sun, 2011-12-11 at 20:50 +0000, Paul F. Johnson wrote: 
> Hi Tom,
> 
> > Ummm ... do you have mysql-server RPM installed? 
> 
> Yep.
> 
> >  But in any case,
> > Fedora's mysql package was converted to systemd some time ago, so you
> > might have better luck using the native systemd service management
> > commands:
> > 
> > 	systemctl enable mysqld.service
> > 	systemctl start mysqld.service
> > 	systemctl status mysqld.service
> > 
> > If "start" fails, there might be relevant info in either or both of
> > /var/log/messages and /var/log/mysqld.log.
> 
> start fails - it's telling me...
> 
> [root at PB3 paul]# systemctl status mysqld.service
> mysqld.service - MySQL database server
> 	  Loaded: loaded (/lib/systemd/system/mysqld.service; enabled)
> 	  Active: activating (start-post) since Sun, 11 Dec 2011 20:40:36
> +0000; 801ms ago
> 	 Process: 5077 ExecStart=/usr/bin/mysqld_safe --nowatch --basedir=/usr
> (code=exited, status=0/SUCCESS)
> 	 Process: 5060 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir
> (code=exited, status=0/SUCCESS)
> 	Main PID: 5213 (mysqld); Control: 5214 (mysqld-wait-rea)
> 	  CGroup: name=systemd:/system/mysqld.service
> 		  ├ 5213 /usr/libexec/mysqld --basedir=/usr --datadir=/var/...
> 		  ├ 5214 /bin/sh /usr/libexec/mysqld-wait-ready 5213
> 		  └ 5243 sleep 1
> 
> with this in var/log/messages
> 
> Dec 11 20:47:17 PB3 mysqld_safe[2417]: 111211 20:47:17 mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> Dec 11 20:47:18 PB3 systemd[1]: mysqld.service: main process exited,
> code=exited, status=1
> Dec 11 20:47:19 PB3 systemd[1]: mysqld.service: control process exited,
> code=exited status=1
> Dec 11 20:47:19 PB3 systemd[1]: mysqld.service holdoff time over,
> scheduling restart.
> Dec 11 20:47:19 PB3 systemd[1]: Job pending for unit, delaying automatic
> restart.
> Dec 11 20:47:19 PB3 systemd[1]: Unit mysqld.service entered failed
> state.
> Dec 11 20:47:19 PB3 mysqld_safe[2657]: 111211 20:47:19 mysqld_safe
> Logging to '/var/log/mysqld.log'.
> Dec 11 20:47:19 PB3 mysqld_safe[2657]: 111211 20:47:19 mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> Dec 11 20:47:21 PB3 systemd[1]: mysqld.service: main process exited,
> code=exited, status=1
> Dec 11 20:47:22 PB3 systemd[1]: mysqld.service: control process exited,
> code=exited status=1
> Dec 11 20:47:22 PB3 systemd[1]: mysqld.service holdoff time over,
> scheduling restart.
> Dec 11 20:47:22 PB3 systemd[1]: Job pending for unit, delaying automatic
> restart.
> Dec 11 20:47:22 PB3 systemd[1]: Unit mysqld.service entered failed
> state.
> Dec 11 20:47:22 PB3 mysqld_safe[2872]: 111211 20:47:22 mysqld_safe
> Logging to '/var/log/mysqld.log'.
> Dec 11 20:47:22 PB3 mysqld_safe[2872]: 111211 20:47:22 mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> Dec 11 20:47:23 PB3 systemd[1]: mysqld.service: main process exited,
> code=exited, status=1
> Dec 11 20:47:24 PB3 systemd[1]: mysqld.service: control process exited,
> code=exited status=1
> Dec 11 20:47:25 PB3 systemd[1]: mysqld.service holdoff time over,
> scheduling restart.
> Dec 11 20:47:25 PB3 systemd[1]: Job pending for unit, delaying automatic
> restart.
> Dec 11 20:47:25 PB3 systemd[1]: Unit mysqld.service entered failed
> state.
> Dec 11 20:47:25 PB3 mysqld_safe[3079]: 111211 20:47:25 mysqld_safe
> Logging to '/var/log/mysqld.log'.
> Dec 11 20:47:25 PB3 mysqld_safe[3079]: 111211 20:47:25 mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> Dec 11 20:47:26 PB3 systemd[1]: mysqld.service: main process exited,
> code=exited, status=1
> Dec 11 20:47:27 PB3 systemd[1]: mysqld.service: control process exited,
> code=exited status=1
> Dec 11 20:47:27 PB3 systemd[1]: mysqld.service holdoff time over,
> scheduling restart.
> Dec 11 20:47:27 PB3 systemd[1]: Job pending for unit, delaying automatic
> restart.
> Dec 11 20:47:27 PB3 systemd[1]: Unit mysqld.service entered failed
> state.
> Dec 11 20:47:28 PB3 mysqld_safe[3287]: 111211 20:47:28 mysqld_safe
> Logging to '/var/log/mysqld.log'.
> Dec 11 20:47:28 PB3 mysqld_safe[3287]: 111211 20:47:28 mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> Dec 11 20:47:29 PB3 systemd[1]: mysqld.service: main process exited,
> code=exited, status=1
> Dec 11 20:47:30 PB3 systemd[1]: mysqld.service: control process exited,
> code=exited status=1
> Dec 11 20:47:30 PB3 systemd[1]: mysqld.service holdoff time over,
> scheduling restart.
> Dec 11 20:47:30 PB3 systemd[1]: Job pending for unit, delaying automatic
> restart.
> Dec 11 20:47:30 PB3 systemd[1]: Unit mysqld.service entered failed
> state.
> Dec 11 20:47:31 PB3 mysqld_safe[3498]: 111211 20:47:31 mysqld_safe
> Logging to '/var/log/mysqld.log'.
> Dec 11 20:47:31 PB3 mysqld_safe[3498]: 111211 20:47:31 mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> Dec 11 20:47:32 PB3 systemd[1]: mysqld.service: main process exited,
> code=exited, status=1
> 
> /var/log/mysqld.log shows this
> 
> 111211 20:48:32 [ERROR] /usr/libexec/mysqld: Can't find file:
> './mysql/proxies_priv.frm' (errno: 13)
> 111211 20:48:32 [ERROR] Fatal error: Can't open and lock privilege
> tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13)
> 111211 20:48:33 mysqld_safe Starting mysqld daemon with databases
> from /var/lib/mysql
> 111211 20:48:33 [Note] Plugin 'FEDERATED' is disabled.
> 111211 20:48:33 InnoDB: The InnoDB memory heap is disabled
> 111211 20:48:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 111211 20:48:33 InnoDB: Compressed tables use zlib 1.2.5
> 111211 20:48:33 InnoDB: Using Linux native AIO
> 111211 20:48:33 InnoDB: Initializing buffer pool, size = 128.0M
> 111211 20:48:33 InnoDB: Completed initialization of buffer pool
> 111211 20:48:33 InnoDB: highest supported file format is Barracuda.
> 111211 20:48:33  InnoDB: Waiting for the background threads to start
> 111211 20:48:34 InnoDB: 1.1.8 started; log sequence number 1589339
> 111211 20:48:34 [ERROR] /usr/libexec/mysqld: Can't find file:
> './mysql/proxies_priv.frm' (errno: 13)
> 111211 20:48:34 [ERROR] Fatal error: Can't open and lock privilege
> tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13)
> 111211 20:48:36 mysqld_safe Starting mysqld daemon with databases
> from /var/lib/mysql
> 
> Any ideas?
> 
> Paul
> -- 
> Vertraue mir, ich weiss, was ich mache...
> 

-- 
Pierre Jaury <pierre at jaury.eu> +33(0)1.83.64.80.90
Réalisateur, hébergeur et infogéreur indépendant
Internet hosting, outsourcing and development as a freelancer
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part
Url : http://lists.fedoraproject.org/pipermail/devel/attachments/20111211/c7122318/attachment.bin 