Page 1 of 3
Can't browse to http://hda/
Posted: Fri Jul 03, 2009 9:13 am
by dspratomo
Dear all, I just installed amahi and get following error (check amahi.pastebin.com):
http://amahi.pastebin.com/m6476f457
This error happen when I tried to browse
http://hda from my server. If I tried that from my client, it can never show anything, but "check error log". Folder shares works OK tho.
Re: Can't browse to http://hda/
Posted: Fri Jul 03, 2009 10:58 am
by cpg
did you change the mysql password?
did it ever work before?
it seems like there is some fundamental issue with your install.
can you share the hda-install.log generated (in the directory where you ran hda-install)?
what happens when you do (as root):
Code: Select all
(cd /var/hda/platform/html && rake db:migrate)
also, can you post the output of
Re: Can't browse to http://hda/
Posted: Fri Jul 03, 2009 4:45 pm
by dspratomo
Dear cpg, thanks for the prompt reply.
Yes, it worked before, but for some unknown reason it stopped.
(cd /var/hda/platform/html && rake db:migrate) result:
Code: Select all
== 20090222200731 AddWebappCustomFields: migrating ============================
-- add_column(:webapps, :custom_options, :string, {:default=>""})
rake aborted!
Mysql::Error: Unknown column 'settings.kind' in 'where clause': SELECT * FROM `settings` WHERE (`settings`.`name` = 'domain') AND (`settings`.`kind` = 'general') LIMIT 1
gem list result:
[root@akon-kaguya html]# gem list
Code: Select all
*** LOCAL GEMS ***
actionmailer (2.1.1)
actionpack (2.1.1)
activerecord (2.1.1)
activeresource (2.1.1)
activesupport (2.1.1)
fcgi (0.8.7)
gd2 (1.1.1)
gruff (0.3.4)
hoe (1.12.2)
rails (2.1.1)
rake (0.8.7)
rmagick (2.5.2)
rubyforge (1.0.3)
I've already put some files inside the server, therefore I try to avoid re-install if possible.
Re: Can't browse to http://hda/
Posted: Fri Jul 03, 2009 4:56 pm
by cpg
well, the database for amahi is somehow corrupted. did you fiddle with phpmyadmin or mysql?
this kind of corruption does not just "happen".
you would have to have been extremely unlucky with some disk errors to be hitting at the amahi database or something.
this would take a bit to time to diagnose, with direct access to the machine, let alone via a forum, so i'm not sure what to say.
Re: Can't browse to http://hda/
Posted: Fri Jul 03, 2009 6:05 pm
by dspratomo
Dear cpg,
I see the problem, a couple of weeks ago there's power outage, and after reboot there's fsck-ing. Probably there is a connection with this? However the error didn't happen right away. Is there's a possibility to re-create/repair the database of amahi? TIA
Re: Can't browse to http://hda/
Posted: Fri Jul 03, 2009 7:17 pm
by cpg
well, this is dangerous. you will lose your users, settings, apps (some of them will be duplicated after you come back from this), but here it goes:
Code: Select all
mysqladmin -uroot -p drop amahi_production
mysqladmin -uroot -p create amahi_production
(cd /var/hda/platform/html && rake db:migrate)
i would definitely recommend reinstall. or come by the irc and make your machine accessible for debugging.
Re: Can't browse to http://hda/
Posted: Sun Jul 05, 2009 11:03 am
by moredruid
wowwww first try to fix the database!
Code: Select all
root@localhost # mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
if that doesn't work, yes then I'd advise reinstall.
Re: Can't browse to http://hda/
Posted: Sun Jul 05, 2009 11:34 am
by cpg
now that you provided this little gem to check databases i am kind of glad that i i did not close this thread.
turns out we followed up via irc and we were able to fix the machine.
the amahi db migration in this box was wedged due to a bug that existed during a brief period in which this box was installed. had to fix it by hand.
thanks for the snippet!
Re: Can't browse to http://hda/
Posted: Sun Jul 05, 2009 12:03 pm
by moredruid
yw and glad it helped.
I thought of it because I recently needed to fix a corrupt table at work, otherwise I wouldn't have thought of it as well.
Re: Can't browse to http://hda/
Posted: Mon Aug 10, 2009 9:37 pm
by dambirds
Is this thread dead?... I too seem to be having a problem with reaching
http://hda
any help would be awesome