<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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 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
'Once is happenstance, twice is coincidence, three times is enemy
action.' - Ian Fleming
<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>