Converting Greyhole to MySQL

[brendanrichman]

I would like to convert my Greyhole from SQLite to MySQL, as per the 'Holiday Present' email I received earlier today.

I ran (under root): /usr/share/greyhole/db_migration-sqlite2mysql.sh

It returned with 'No such file or directory'

I looked into the Greyhole directory, and sure enough, nothing matching that filename was there - only schema-mysql.sql and schema sqlite.sql

Anyone help on this? Thanks in advance!

[gboudreau]

You need version 0.7.5 or more of Greyhole to have that file.
I'm guessing you didn't get the update yet.
To check what version you have:

Code: Select all

rpm -q hda-greyhole

To force an update:

Code: Select all

yum clean all; yum -y update hda-greyhole

[brendanrichman]

You need version 0.7.5 or more of Greyhole to have that file.
I'm guessing you didn't get the update yet.
To check what version you have:

Code: Select all

rpm -q hda-greyhole

To force an update:

Code: Select all

yum clean all; yum -y update hda-greyhole

Yeah that was it! Thanks so much for your help! I'm still pretty new to this...

Strange how out of date it was though. I only downloaded Fedora installed Amahi from scratch a few days ago, but Greyhole reported that it was on 6.8 or something.

Anyway, seems to have worked flawlessly now. Thanks again!

[gboudreau]

0.6.8 was the last version. 0.7.5 was released yesterday, and can take about a day to reach everyone, thus why you didn't have it yet.

[brendanrichman]

0.6.8 was the last version. 0.7.5 was released yesterday, and can take about a day to reach everyone, thus why you didn't have it yet.

Ah ok I see now! Well thanks for your help, much appreciated!

[santa]

I just ran the script and I show some errors for monit. Any ideas?


Stopping Greyhole service watchdog...
Reloading monit: /etc/monit.d/mt-daapd.conf:1: Error: syntax error ':'

Done.

Stopping Greyhole service...
Shutting down Greyhole: [ OK ]
Done.

Creating MySQL database and user...
hda-create-db-and-user: creating greyhole
Done.

Modifying Greyhole configuration to use MySQL...
Done.

Migrating data from SQLite to MySQL...
Done.

Starting Greyhole service...
Starting Greyhole ... [ OK ]
Done.

Starting Greyhole service watchdog...
Reloading monit: /etc/monit.d/mt-daapd.conf:1: Error: syntax error ':'

Done.

[gboudreau]

That error is unrelated to Greyhole; it's about your monit.d config file having a typo. This is a know Amahi bug: http://bugs.amahi.org/issues/show/689
Nothing for you do to. The MySQL migration worked, and a future Amahi update will fix the monit error.