I had the same issue and just found the solution for me. Before the upgrade when my Amahi was still on F12 I had converted to using mysql as the storage for greyhole already by running
Code: Select all
/usr/share/greyhole/db_migration-sqlite2mysql.sh
Not sure if the fact that I already had the tables in question screwed up the upgrade script or not but after the upgrade my greyhole database had no tables in it.
I tried running hda-upgrade-amahi5-to-amahi6 again but no luck.
I then reverted back to using the sqlite to mysql migration script and although it complained about the fact that the users for greyhole already existed etc it created the tables and I was good to go.
Code: Select all
[root@localhost ~]# /usr/share/greyhole/db_migration-sqlite2mysql.sh
Stopping Greyhole service watchdog...
Reloading monit: Reinitializing monit daemon
Done.
Stopping Greyhole service...
Shutting down Greyhole: [ OK ]
Done.
Creating MySQL database and user...
hda-create-db-and-user: creating greyhole
ERROR 1396 (HY000) at line 2: Operation CREATE USER failed for 'greyhole'@'localhost'
Done.
Modifying Greyhole configuration to use MySQL...
Done.
Migrating data from SQLite to MySQL...
Error: unknown command or invalid arguments: "dump". Enter ".help" for help
Done.
Starting Greyhole service...
Starting Greyhole ... [ OK ]
Done.
Starting Greyhole service watchdog...
Reloading monit: Reinitializing monit daemon
Done.
[root@localhost ~]# /usr/share/greyhole/db_migration-sqlite2mysql.sh ^C
[root@localhost ~]# fg
mysql -u greyhole -p
show tables;
+--------------------+
| Tables_in_greyhole |
+--------------------+
| settings |
| tasks |
| tasks_completed |
+--------------------+
3 rows in set (0.00 sec)
mysql> quit
Bye
Not sure if the sqlite to mysql migration script is avalibe in Amahi6, otherwise you should probably be able to create the tables manually by logging into mysql, selecting the greyhole database and running the queries
Code: Select all
CREATE TABLE `settings` (
`name` tinytext NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`name`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Code: Select all
CREATE TABLE `tasks` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`action` varchar(10) NOT NULL,
`share` tinytext NOT NULL,
`full_path` tinytext,
`additional_info` tinytext,
`complete` enum('yes','no','frozen','thawed','idle') NOT NULL,
`event_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `find_next_task` (`complete`,`share`(64),`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Code: Select all
CREATE TABLE `tasks_completed` (
`id` bigint(20) unsigned NOT NULL,
`action` varchar(10) NOT NULL,
`share` tinytext NOT NULL,
`full_path` tinytext,
`additional_info` tinytext,
`complete` enum('yes','no') NOT NULL,
`event_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1
My HDA: Q6400, 8GB ram, 2x1TB disk in raid 1 for system drive, 6x2TB drives for storage