Obsolete Releases > SME 8.x Contribs

[Announce] Moodle 2.5 for SME 8.0

<< < (4/5) > >>

LANMonkey:
I have reset the password according to instructions here:

http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password


--- Code: ---cd /var/service/mysqld
sv d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
sv u .
--- End code ---

But when I run,


--- Code: ---/etc/e-smith/events/actions/mysql-dump-tables
--- End code ---

I am still getting the same errors:


--- Quote ---mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

--- End quote ---

LANMonkey:
From that same MySQL manual page, I disable the InnoDB engine,


--- Code: ---db configuration setprop mysqld InnoDB disabled
expand-template /etc/my.cnf
sv t /service/mysqld
--- End code ---

And now the error returned when I manually run mysql-dump-tables is,


--- Quote ---ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
--- End quote ---

From the manual page again, I restore the InnoDB tables,


--- Code: ---db configuration setprop mysqld InnoDB enabled
expand-template /etc/my.cnf
sv t /service/mysqld
--- End code ---

 and once again I get error 1044.


--- Quote ---mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
--- End quote ---

I tried scheduling a backup through the server-manager after disabling InnoDB and I am getting reports again about successful backups.  But, the user preferences in the email are not available.  I get a little report at the top of the mail display,


--- Quote ---The preferences backend is currently unavailable and your preferences have not been loaded. You may continue to use the system with default settings.
--- End quote ---

So disabling InnoDB appears to disable the default settings in Horde.  Horde is still otherwise working OK.

It looks as though InnoDB might play a role.  How to fix the user preferences in Horde?  What else in SME uses the InnoDB tables that might be effected?

mmccarn:
Try adding the "-x" option to mysqldump:
--- Code: ---for db in $(mysql -BNre "show databases;"); do mysqldump -x --add-drop-table -QB "$db" -r /home/e-smith/db/mysql/"$db".dump || exit 1; done

--- End code ---

I had to do this when adapting /etc/e-smith/events/actions/mysql-dump-tables to backup mariadb:
http://wiki.contribs.org/User_talk:Mmccarn#.2Fetc.2Fe-smith.2Fevents.2Factions.2Fmariadb-dump-tables

LANMonkey:
OK.  I copied and pasted that code into my PuTTY command line and entered it and PuTTY promptly exited.  I logged back in and looked in the directory that was the target for the dump and found "information_schema.dump.  That was the only .dump file there.

LANMonkey:
I have also installed this database on SME 9.0 Beta 2.  Logged on to this server, I run,


--- Code: ---/etc/e-smith/events/actions/mysql-dump-tables
--- End code ---

and get an entirely different error,


--- Quote ---mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `PARAMETERS`': Cannot load from mysql.proc. The table is probably corrupted (1548)

--- End quote ---

But if I schedule a backup through the server-manager, I get the same errors that I get in SME 8.0,


--- Quote ---Backup terminated: pre-backup failed - status: 256
--- End quote ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page