<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I've just built a fresh Ubuntu 14 server from scratch. During the
Ubuntu server install, the only box I ticked for software was
OpenSSH server.<br>
<br>
The installer happily ran to completion, no problems at all.<br>
<br>
The permissions on the /etc/apparmor.d/local/usr.sbin.mysqld file
should be<br>
-rw-r--r-- 1 root root 122 Mar 9 11:44 usr.sbin.mysqld<br>
<br>
Cheers,<br>
Jules.<br>
<br>
<div class="moz-cite-prefix">On 08/03/2017 17:38, Jules wrote:<br>
</div>
<blockquote cite="mid:3f269e06-1674-3972-5081-a38bbf29677a@Zend.To"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
The /etc/apparmor.d/usr.sbin.mysqld file should end with this:<br>
<br>
#include <local/usr.sbin.mysqld><br>
<br>
which means that you just put your local additions in the
/etc/apparmor.d/local/... file, and not everything.<br>
<br>
I'm wondering if it was actually just the permissions on the
/etc/apparmor.d/local/usr.sbin.mysqld file that my installer
wrote.<br>
If AppArmor couldn't read it for some reason, that would certainly
explain what you saw.<br>
<br>
Cheers,<br>
Jules.<br>
<br>
<br>
<div class="moz-cite-prefix">On 08/03/2017 17:17, Greg Marshall
wrote:<br>
</div>
<blockquote
cite="mid:6C47FF46-1BCF-4B7B-9CD0-D6C19D85701E@truman.edu"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
FYI,<br class="">
I figured out my issue and wanted to report back.<br class="">
<br class="">
AppArmor was preventing MySQL from having access. The install
script adds a line into <br class="">
/etc/apparmor.d/local/usr.sbin.mysqld<br class="">
but in my case, that file didn't exist to begin with, so only
the zend.to specific rule was in there, not all the MySQL
defaults.<br class="">
<br class="">
I copied <br class="">
/etc/apparmor.d/usr.sbin.mysqld<br class="">
to<br class="">
/etc/apparmor.d/local/<br class="">
(making it /etc/apparmor.d/local/usr.sbin.mysqld)<br class="">
and then it all worked.<br class="">
<span class=""><br class="">
Greg<br class="">
<br class="">
<div class=""><img moz-do-not-send="true" alt="Truman State
University"
src="http://identity.truman.edu/files/2013/11/2clogo.jpg"
style="box-sizing: border-box; border: none;
vertical-align: middle; margin: 0px; padding: 0px;
font-family: inherit; font-size: inherit; font-style:
inherit; font-variant: inherit; font-stretch: inherit;
line-height: inherit; height: auto; max-width: 100%;"
class=""> <br class="">
<br class="">
Greg Marshall<br class="">
Web Services Manager<br class="">
IT Services<br class="">
Truman State University<br class="">
111C McClain Hall<br class="">
100 E. Normal Avenue<br class="">
Kirksville, MO 63501<br class="">
(660) 785-4254<br class="">
<a moz-do-not-send="true" href="mailto:gmarsh@truman.edu"
class="">gmarsh@truman.edu</a><br class="">
<a moz-do-not-send="true" href="http://www.truman.edu"
class="">www.truman.edu</a><br class="">
Don’t follow. Pursue.<br class="">
<br class="">
</div>
<br class="">
<blockquote type="cite" class="">On Mar 2, 2017, at 2:45 PM,
Greg Marshall <<a moz-do-not-send="true"
href="mailto:gmarsh@truman.edu" class="">gmarsh@truman.edu</a>>
wrote:<br class="">
<br class="">
Hi,<br class="">
I'm trying to do a new install of zend.to on Ubuntu 14.04
(64 bit) using the installer script.<br class="">
<br class="">
It crashes out trying to set up MySQL with PHP. I know MySQL
isn't needed for the system any more, but apparently it gets
installed so the PHP tests pass, and then gets removed
again.<br class="">
<br class="">
The output from this part of the install process is below.
(stdout and stderr are combined, so it's a little weird).
Note that I uninstalled MySQL prior to running the installer
this last time, so there's no other process running. I've
also tried setting the permissions to 777... It doesn't seem
to be a permissions issue.<br class="">
<br class="">
Does anybody know what's going on?<br class="">
<br class="">
Thanks,<br class="">
Greg<br class="">
<br class="">
<br class="">
+ /usr/sbin/mysqld --no-defaults --user=mysql
--bind-address=127.0.0.1 --port=2766
--socket=/root/zendto-build-store/php5-5.5.9+dfsg/mysql_db/mysql.sock
--datadir=/root/zendto-build-store/php5-5.5.9+dfsg/mysql_db
--bootstrap --skip-grant-tables<br class="">
170302 12:44:24 [Note] Ignoring --secure-file-priv value as
server is running with --bootstrap.<br class="">
170302 12:44:24 [Note] /usr/sbin/mysqld (mysqld
5.5.54-0ubuntu0.14.04.1) starting as process 19855 ...<br
class="">
170302 12:44:24 [Note] Plugin 'FEDERATED' is disabled.<br
class="">
170302 12:44:24 InnoDB: The InnoDB memory heap is disabled<br
class="">
170302 12:44:24 InnoDB: Mutexes and rw_locks use GCC atomic
builtins<br class="">
170302 12:44:24 InnoDB: Compressed tables use zlib 1.2.8<br
class="">
170302 12:44:24 InnoDB: Using Linux native AIO<br class="">
170302 12:44:24 InnoDB: Initializing buffer pool, size =
128.0M<br class="">
170302 12:44:24 InnoDB: Completed initialization of buffer
pool<br class="">
InnoDB: Unable to lock ./ibdata1, error: 13<br class="">
InnoDB: Check that you do not already have another mysqld
process<br class="">
InnoDB: using the same InnoDB data or log files.<br class="">
170302 12:44:24 InnoDB: Operating system error number 13 in
a file operation.<br class="">
InnoDB: The error means mysqld does not have the access
rights to<br class="">
InnoDB: the directory.<br class="">
InnoDB: Error in creating or opening ./ibdata1<br class="">
170302 12:44:24 InnoDB: Could not open or create data files.<br
class="">
170302 12:44:24 InnoDB: If you tried to add new data files,
and it failed here,<br class="">
170302 12:44:24 InnoDB: you should now edit
innodb_data_file_path in my.cnf back<br class="">
170302 12:44:24 InnoDB: to what it was, and remove the new
ibdata files InnoDB created<br class="">
170302 12:44:24 InnoDB: in this failed attempt. InnoDB only
wrote those files full of<br class="">
170302 12:44:24 InnoDB: zeros, but did not yet use them in
any way. But be careful: do not<br class="">
170302 12:44:24 InnoDB: remove old data files which contain
your precious data!<br class="">
170302 12:44:24 [ERROR] Plugin 'InnoDB' init function
returned error.<br class="">
170302 12:44:24 [ERROR] Plugin 'InnoDB' registration as a
STORAGE ENGINE failed.<br class="">
170302 12:44:24 [ERROR] Unknown/unsupported storage engine:
InnoDB<br class="">
170302 12:44:24 [ERROR] Aborting<br class="">
<br class="">
170302 12:44:24 [Note] /usr/sbin/mysqld: Shutdown complete<br
class="">
<br class="">
make: *** [test-results.txt] Error 1<br class="">
^[[1m ^[[0m<br class="">
^[[1mOh dear, building PHP failed. I am going to need
help.^[[0m<br class="">
^[[1mPlease try to fix whatever was wrong and re-run this
script.^[[0m<br class="">
^[[1mExiting...^[[0m<br class="">
<br class="">
<br class="">
<br class="">
<br class="">
<img moz-do-not-send="true" alt="Truman State University"
src="http://identity.truman.edu/files/2013/11/2clogo.jpg"
style="box-sizing: border-box; border: none;
vertical-align: middle; margin: 0px; padding: 0px;
font-family: inherit; font-size: inherit; font-style:
inherit; font-variant: inherit; font-stretch: inherit;
line-height: inherit; height: auto; max-width: 100%;"
class=""> <br class="">
<br class="">
Greg Marshall<br class="">
Web Services Manager<br class="">
IT Services<br class="">
Truman State University<br class="">
111C McClain Hall<br class="">
100 E. Normal Avenue<br class="">
Kirksville, MO 63501<br class="">
(660) 785-4254<br class="">
<a moz-do-not-send="true" href="mailto:gmarsh@truman.edu"
class="">gmarsh@truman.edu</a><br class="">
<a moz-do-not-send="true" href="http://www.truman.edu"
class="">www.truman.edu</a><br class="">
Don’t follow. Pursue.<br class="">
<br class="">
<br class="">
</blockquote>
<br class="">
</span> <br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
ZendTo mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">Jules
--
Julian Field MEng MBCS CITP CEng
'Once is happenstance, twice is coincidence, three times is enemy
action.' - Ian Fleming
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="http://www.Zend.To">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
ZendTo mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">Jules
--
Julian Field MEng MBCS CITP CEng
'A committee is a group of the unwilling, chosen from the unfit,
to do the unnecessary.' - Anon
<a class="moz-txt-link-abbreviated" href="http://www.Zend.To">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
</body>
</html>