Obsolete Releases > SME 8.x Contribs
[Announce] Moodle 2.5 for SME 8.0
LANMonkey:
--- Quote from: mmccarn on December 21, 2013, 11:52:25 PM ---Try running the "pre-backup" event manually to see if there are any informative error messages:
--- Code: ---/etc/e-smith/events/actions/mysql-dump-tables
--- End code ---
--- End quote ---
OK. I ran,
--- Code: ---/etc/e-smith/events/actions/mysql-dump-tables
--- End code ---
And got,
--- Quote ---mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
--- End quote ---
I did a quick search on Google for that error and found a discussion at MySQL forums here:
http://forums.mysql.com/read.php?10,108835,108835#msg-108835
They say,
--- Quote ---You must grant "LOCK TABLES" to your user.
GRANT SELECT,LOCK TABLES ON database.* TO 'username'@'localhost';
--- End quote ---
So I tried,
--- Code: ---GRANT SELECT,LOCK TABLES ON information_schema.* TO 'root'@'localhost'
--- End code ---
and got back,
--- Quote ---ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'
--- End quote ---
which seems kind of an odd thing to issue to root who issued the command in MySQL. Searching the forums here for "mysqldump 1044" doesn't pull anything up.
mmccarn:
I think the 'root' account in your mysql is skeewonky.
You should be able to enter the command 'mysql' (with no other arguments) and get a mysql client prompt -- can you?
What is the root password stored in ~/.my.cnf (note the dot)? Do you enter it why you run mysql at the command prompt?
LANMonkey:
--- Quote from: mmccarn on December 23, 2013, 12:08:35 AM ---I think the 'root' account in your mysql is skeewonky.
You should be able to enter the command 'mysql' (with no other arguments) and get a mysql client prompt -- can you?
What is the root password stored in ~/.my.cnf (note the dot)? Do you enter it why you run mysql at the command prompt?
--- End quote ---
Yes, I can just type "mysql" and log into mysql as root. There is a password in ~/.my.cnf that is huge and I have never used it. I might add that I did some things to password functions when I installed MariaDB as linked here:
http://forums.contribs.org/index.php/topic,50433.msg253660.html#msg253660
And here is the link:
http://wiki.contribs.org/User_talk:Mmccarn#Install_mariadb_.27alongside.27_mysql
You might note that I had some confusion about some procedures setting root that I mention in the thread containing the link.
CharlieBrady:
--- Quote from: mmccarn on December 23, 2013, 12:08:35 AM ---What is the root password stored in ~/.my.cnf (note the dot)? Do you enter it why you run mysql at the command prompt?
--- End quote ---
You don't need to use it. It's used implicitly by mysql. The whole point of /root/.my.cnf is to make it possible for root to run the mysql command without supplying the root password.
CharlieBrady:
--- Quote from: LANMonkey on December 23, 2013, 05:09:43 AM ---Yes, I can just type "mysql" and log into mysql as root. There is a password in ~/.my.cnf that is huge and I have never used it. I might add that I did some things to password functions when I installed MariaDB as linked here:
--- End quote ---
Well you shouldn't have done, or you shouldn't have done that without first verifying on a test install.
You will have to reset the mysql root password before backup will start to work again.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version