<html><head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
</head><body wsmode="compose" text="#000000" bgcolor="#FFFFFF">Found it.
More side effects from the user permission change. The
/home/mysql/mysql didn't get changed back to mysql:mysql permissions.<br>
<div class="moz-signature">-- <br>-- <br>
Don Teague<br>
donteague.com<br>
<br>
<br>
</div>
<br>
<span>
</span><br>
<blockquote style="border: 0px none;"
cite="mid:593F6AD5.7010800@donteague.com" type="cite">
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="width:100%;border-top:2px solid #EDF1F4;padding-top:10px;"> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:49%;">
<a moz-do-not-send="true" href="mailto:blueonyx@donteague.com"
style="color:#485664
!important;padding-right:6px;font-weight:500;text-decoration:none
!important;">Don Teague</a></div> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:48%;text-align:
right;"> <font color="#909AA4"><span style="padding-left:6px">Monday,
June 12, 2017 23:32</span></font></div> </div></div>
<div style="color:#909AA4;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
I've done
1, 2, and 3, but I can't get MySQL to start now.<br>
<br>
Any ideas? Here's the data I've collected so far.<br>
<br>
<br>
[root@bo-x1 log]# tail -f mysqld.log<br>
170612 23:15:11 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended<br>
170612 23:23:00 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql<br>
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)<br>
170612 23:23:00 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.<br>
170612 23:23:00 InnoDB: Initializing buffer pool, size = 8.0M<br>
170612 23:23:00 InnoDB: Completed initialization of buffer pool<br>
170612 23:23:01 InnoDB: Started; log sequence number 1 2117275339<br>
170612 23:23:01 [ERROR] /usr/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)<br>
170612 23:23:01 [ERROR] Fatal error: Can't open and lock privilege
tables: Can't find file: './mysql/host.frm' (errno: 13)<br>
170612 23:23:01 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended<br>
<br>
[root@bo-x1 log]# mysql_upgrade<br>
Looking for 'mysql' as: mysql<br>
Looking for 'mysqlcheck' as: mysqlcheck<br>
Running 'mysqlcheck with default connection arguments<br>
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2) when trying to connect<br>
FATAL ERROR: Upgrade failed<br>
<br>
<br>
[root@bo-x1 log]# grep mysql messages<br>
...<br>
Jun 12 23:22:54 bo-x1 logger: ***** cce_construct:
/usr/sausalito/constructor/base/mysql/setup_mysql_data.pl<br>
Jun 12 23:22:56 bo-x1 logger: ***** cce_construct:
/usr/sausalito/constructor/base/netdata/update_mysqlPass.pl<br>
Jun 12 23:22:56 bo-x1 logger: *** cce_construct:
/usr/sausalito/constructor/Compass/webapps/webapp_mysql_defaults.pl<br>
<br>
[root@bo-x1 log]# /etc/init.d/mysqld restart<br>
Stopping mysqld: [ OK ]<br>
MySQL Daemon failed to start.<br>
Starting mysqld: [FAILED]<br>
<br>
[root@bo-x1 log]# /usr/libexec/mysqld start<br>
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)<br>
170612 23:30:26 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.<br>
170612 23:30:26 InnoDB: Initializing buffer pool, size = 8.0M<br>
170612 23:30:26 InnoDB: Completed initialization of buffer pool<br>
170612 23:30:26 InnoDB: Started; log sequence number 1 2117275339<br>
/usr/libexec/mysqld: Too many arguments (first extra is 'start').<br>
Use --verbose --help to get a list of available options<br>
170612 23:30:26 [ERROR] Aborting<br>
<br>
170612 23:30:26 InnoDB: Starting shutdown...<br>
<br>
170612 23:30:31 InnoDB: Shutdown completed; log sequence number 1
2117275339<br>
170612 23:30:31 [Note] /usr/libexec/mysqld: Shutdown complete<br>
<br>
<br>
<br>
<span>
</span><br>
<br>
<div>_______________________________________________<br>Blueonyx mailing
list<br><a class="moz-txt-link-abbreviated" href="mailto:Blueonyx@mail.blueonyx.it">Blueonyx@mail.blueonyx.it</a><br><a class="moz-txt-link-freetext" href="http://mail.blueonyx.it/mailman/listinfo/blueonyx">http://mail.blueonyx.it/mailman/listinfo/blueonyx</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="width:100%;border-top:2px solid #EDF1F4;padding-top:10px;"> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:49%;">
<a moz-do-not-send="true" href="mailto:mstauber@blueonyx.it"
style="color:#485664
!important;padding-right:6px;font-weight:500;text-decoration:none
!important;">Michael Stauber</a></div> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:48%;text-align:
right;"> <font color="#909AA4"><span style="padding-left:6px">Monday,
May 15, 2017 1:50</span></font></div> </div></div>
<div style="color:#909AA4;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div>Hi Don,<br><br></div><div><!----><br>Yikes.
That's indeed pretty bad. :-/<br><br>The RPM database is your best bet
for a recovery of most things that<br>were installed via RPM's. Sadly
that won't fix permissions/ownerships<br>for things that were then
modified (or created) via the RPM's<br>post-install scripts. But there
is also a cure for that.<br><br>Give this a try:<br><br>1) To reset uids
and gids on files and directories :<br><br>for u in $(rpm -qa); do rpm
--setugids $u; done<br><br>2) To permissions on files and directories<br><br>for
p in $(rpm -qa); do rpm --setperms $p; done<br><br>Lastly: You might
want to reinstall all RPMs to *really* make sure<br>everything is back
in proper order. So here is a one-liner for that purpose:<br><br>3.)
Reinstall of all RPMs via polling RPM database and then using YUM:<br><br>rpm
-qa --qf '%{name} ' | xargs yum reinstall -y<br><br>The first part
polls the RPM database for *all* installed RPMs and<br>formats the
output into a single line that contains just the RPM names<br>and has
each name followed by an intentional space.<br><br>We then use xargs to
pass this long list of RPMs to reinstall directly<br>to "yum reinstall
-y " (yes, there is a space at the end!) and it will<br>reinstall every
RPM via YUM that can be fetched via YUM. This might not<br>cover things
that came with PKGs, though. Or things which no longer are<br>available
via YUM for one reason or another.<br><br>If there are problems with
software that came via PKGs: Just uninstall<br>and reinstall them via
the GUI to solve these issues.<br><br>All in all: This should get you
back onto your feet and this is as good<br>as it'll get.<br><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="width:100%;border-top:2px solid #EDF1F4;padding-top:10px;"> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:49%;">
<a moz-do-not-send="true" href="mailto:blueonyx@donteague.com"
style="color:#485664
!important;padding-right:6px;font-weight:500;text-decoration:none
!important;">Don Teague</a></div> <div
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:48%;text-align:
right;"> <font color="#909AA4"><span style="padding-left:6px">Monday,
May 15, 2017 0:39</span></font></div> </div></div>
<div style="color:#909AA4;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div>Full disclosure, it was a
fat-finger/ID10T error...<br><br>But I managed to royally foul up
permissions server wide. Is there any<br>sort of script out there that
will get /etc/ /usr/, and so forth back to<br>normal. I think I'm
getting close.<br><br>Still can't su to root, but can get to root if I
change the SSH<br>permissions to allow root via the GUI. (Yes, I disable
right away.)<br><br></div></div>
</blockquote>
<br>
<div class="moz-signature">-- <br>-- <br>
Don Teague<br>
donteague.com<br>
<br>
<br>
</div>
</body></html>