Greyhole wouldn't start after Amahi 6 upgrade

speeker
Posts: 3
Joined: Fri Mar 25, 2011 6:43 am

Re: Greyhole wouldn't start after Amahi 6 upgrade

Postby speeker » Sat Mar 26, 2011 7:30 pm

you can try:

Code: Select all

hda-create-db-and-user greyhole mysql -u greyhole -pgreyhole greyhole < /usr/share/greyhole/schema-mysql.sql
Just a quick update ... I tried the hda-create-db-and-user greyhole command and it returned an error: "ERROR 1396 (HY000) at line 2: Operation CREATE USER failed for 'greyhole'@'localhost'"

But when I ran mysql -u greyhole -pgreyhole greyhole < /usr/share/greyhole/schema-mysql.sql it seemed to fix the issue with greyhole not starting ... I also rebooted the server to see if the service would come back up and it seems to be working fine now.

Thanks for the help !

inquam
Posts: 78
Joined: Sat Dec 11, 2010 12:22 pm

Re: Greyhole wouldn't start after Amahi 6 upgrade

Postby inquam » Mon Mar 28, 2011 4:37 am

This is quite puzzling. How would the mysqld service stopped from starting?

Is it possible that it was accidentally turned off from the Setup > Settings > Servers?

Seems puzzling ... perhaps something in the upgrade process caused this to go haywire?
Perhaps retrieving the upgrade log?
(Not sure where it is, actually)
Not sure, but I think I remember seeing the upgrade log under /var or /var/logs
My HDA: Q6400, 8GB ram, 2x1TB disk in raid 1 for system drive, 6x2TB drives for storage

azouts
Posts: 1
Joined: Tue Aug 02, 2011 1:51 am

Re: Greyhole wouldn't start after Amahi 6 upgrade

Postby azouts » Tue Aug 02, 2011 1:53 am

I had the same problem after the upgrade to amahi 6 and I was using mysql for greyhole in amahi 5.

The problem solved by recreating the schema with: mysql -u greyhole -pgreyhole greyhole < /usr/share/greyhole/schema-mysql.sql

theyoungsdotca
Posts: 33
Joined: Fri Nov 11, 2011 1:32 pm

Re: Greyhole wouldn't start after Amahi 6 upgrade

Postby theyoungsdotca » Thu Apr 19, 2012 6:26 pm

Just did, in response to Guillaume's post on the greyhole forum. That worked. Thanks again

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: Greyhole wouldn't start after Amahi 6 upgrade

Postby bigfoot65 » Fri Apr 20, 2012 4:48 am

This would be a good thing to add to the wiki. Would someone please include it under the Greyhole Troubleshooting area. We would greatly appreciate it.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

Who is online

Users browsing this forum: No registered users and 12 guests