Page 1 of 2

VCD-db

Posted: Mon Jun 01, 2009 4:59 am
by spaceman
Cannot get started with this fine looking app as i get an error:

Code: Select all

Oops an exception occurred .. Database Access misconfigured. Cannot procceed without database access Check the connection settings to solve the problem.
Cheers.

Re: VCD-db

Posted: Mon Jun 01, 2009 10:31 am
by gmw
Sounds like the install did not take place correctly.
The easiest thing would be to uninstall and reinstall the app.

As background:
The one-click installer creates a script file that sets up the database (/var/hda/web-apps/vcddb/html/setup/amahi-init.php)
and also sets the config.php file correctly.

:?:

Re: VCD-db

Posted: Mon Jun 01, 2009 11:29 am
by spaceman
Sadly this has not resolved the problem.

Re: VCD-db

Posted: Mon Jun 01, 2009 12:04 pm
by gmw
Sadly this has not resolved the problem.
No-one else has had this issue -- we would like to determine the root cause.
Please drop by the IRC channel for support (freenode #amahi) -- link at the bottom of your http://hda page.

Re: VCD-db

Posted: Thu Jun 11, 2009 5:31 pm
by cpg
spaceman, did you try uninstalling it and reinstalling?

in any case, we'd like to see the contents of this file:

Code: Select all

/var/log/amahi-app-installer.log
well, at least the last few lines of it.

also, the files in

Code: Select all

/var/hda/web-apps/vcddb/logs/
will also help, probably more.

Re: VCD-db

Posted: Sat Aug 08, 2009 6:28 am
by spaceman
Dammit, sorry haven't stopped by for a while. I will post this data when I sort out Ajaxterm, I run the server headless (I only have one USB keyboard LOL), and I really want to avoid digging out another monitor, keyboard and mouse. :mrgreen:

Re: VCD-db

Posted: Sat Aug 08, 2009 9:30 am
by cpg
that's fine, you can use ssh to login to the server (putty is a very good program to do ssh).

Re: VCD-db

Posted: Sat Aug 08, 2009 11:10 am
by spaceman
OK...I'm working on the server today! First things first, begin a GUI lover, I had to refresh my knowledge of using VNC...aha! You need a colon in HDA1 [moron!]. :shock: Now I can connect to the box. It's been working fine really I just haven't been able to remote on. Right just install vcd-db again...then the final lines in the that log file will be relevent...

/var/log/amahi-app-installer.log:

Code: Select all

======= app install begin @ Sat Aug 08 18:42:58 +0100 2009 ========== Installing app id sy8byno6cx under /var/hda/platform/html ENV=production NOTE: file /tmp/amahi-download-cache/0b610d986d41c3978153e1b022f157ada426dfd1 written in cache /tmp/run_script.4405.0: line 87: patch: command not found Your HDA services have been restarted. Your HDA services have been restarted. App: VCD-db installed ======= app install end @ Sat Aug 08 18:43:34 +0100 2009 ==========
/var/hda/web-apps/vcddb/logs/access.log:

Code: Select all

192.168.1.101 - - [08/Aug/2009:19:02:24 +0100] "GET / HTTP/1.1" 302 91 "http://hda/setup?sub=1&tab=apps" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)" 192.168.1.101 - - [08/Aug/2009:19:02:25 +0100] "GET //?page=error&type=db HTTP/1.1" 200 1017 "http://hda/setup?sub=1&tab=apps" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)" 192.168.1.101 - - [08/Aug/2009:19:02:26 +0100] "GET /images/favicon.ico HTTP/1.1" 200 3310 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)" 192.168.1.101 - - [08/Aug/2009:19:02:26 +0100] "GET /images/logotest.gif HTTP/1.1" 200 8005 "http://vcddb.spacestation.com//?page=error&type=db" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)" 192.168.1.101 - - [08/Aug/2009:19:02:26 +0100] "GET /includes/css/global.css HTTP/1.1" 200 1963 "http://vcddb.spacestation.com//?page=error&type=db" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)" 192.168.1.101 - - [08/Aug/2009:19:02:26 +0100] "GET /includes/templates/default/style.css HTTP/1.1" 200 6386 "http://vcddb.spacestation.com//?page=error&type=db" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)" 192.168.1.101 - - [08/Aug/2009:19:02:26 +0100] "GET /includes/templates/default/images/background3.gif HTTP/1.1" 200 5228 "http://vcddb.spacestation.com/includes/templates/default/style.css" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)"
/var/hda/web-apps/vcddb/logs/error.log:

Code: Select all

[Sat Aug 08 19:02:25 2009] [error] [client 192.168.1.101] PHP Warning: Call-time pass-by-reference has been deprecated in /var/hda/web-apps/vcddb/html/classes/VCDSoapProxy.php on line 160, referer: http://hda/setup?sub=1&tab=apps [Sat Aug 08 19:02:26 2009] [error] [client 192.168.1.101] PHP Warning: Call-time pass-by-reference has been deprecated in /var/hda/web-apps/vcddb/html/classes/VCDSoapProxy.php on line 160, referer: http://hda/setup?sub=1&tab=apps
Hmmm...do they help?

Re: VCD-db

Posted: Sat Aug 08, 2009 11:15 am
by cpg
ok

1) how did you install amahi that patch is not available??? this must be a missing dependency. did you install from the full DVD or some other way?

2) to fix this, please use: yum -y install patch

then uninstall and reinstall the app.

Re: VCD-db

Posted: Sat Aug 08, 2009 11:21 am
by spaceman
I think I installed Amahi over an existing Fedora 9 install...I used the instructions...not sure now, that was some time ago.

Anyway that genius bit of troubleshooting has the VCD-DB one click install working out of the box as it should, thank you!