Can't browse to http://hda/

[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.

[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

Code: Select all

gem list

[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.

[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.

[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

[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.

[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.

[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!

[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.

[dambirds]

Is this thread dead?... I too seem to be having a problem with reaching http://hda

any help would be awesome