SOLVED: Why is sharing so hard when it's supposed to work out of the box?

[revhead]

As I said.
I set the router to use the HDA for DNS.
I have also set my client to use the HDA for DNS.
I have rebooted router, HDa and client.
Now if I type in http://hda I can reach the dashboard from client which as I understand it means DNS is working.
BUT the apps don't work. They take me to the web address I mentioned. Probably not related but I have also noticed that some apps are no longer in the available list, although I have not installed them, nor are they in the installed list - for example Caliber? I did install it on a previous Amahi installation attempt. It suggests something is not updating?
I completed the first 8 steps of the interactive troubleshooter successfully, but am reluctant to turn off DHCP on my router for step 9. I have many devices in my LAN all with fixed IPs.

[bigfoot65]

Something is amiss if there are apps installed and they are not reflecting as installed.

Please check /var/log/amahi-app-installer.log for errors.

Did you do any manual changes? I have not heard of anyone having the issues you are experiencing.

Are there any other details you can provide? Seems like I am missing something here.

[revhead]

Log as follows.
No manual changes. Network seems to be working perfectly apart from this?

======= app install begin @ 2016-10-18 10:58:44 +1100 ==========
Installing app id aw1gtsrebh under /var/hda/platform/html/script/.. ENV=production
App: HDA Troubleshooting Tools installed
======= app install end @ 2016-10-18 10:58:50 +1100 ==========
======= app install begin @ 2016-10-18 10:59:15 +1100 ==========
Installing app id ogiaus92x5 under /var/hda/platform/html/script/.. ENV=production
Your HDA services have been restarted.
Your HDA services have been restarted.
Configuring Amahi settings
Reloading systemctl daemon
Enabling minidlna.service
Created symlink from /etc/systemd/system/multi-user.target.wants/minidlna.service to /usr/lib/systemd/system/minidlna.service.
Starting minidlna.service
App: DLNA installed
======= app install end @ 2016-10-18 11:00:54 +1100 ==========
======= app install begin @ 2016-10-18 11:02:44 +1100 ==========
Installing app id 520ut3lo6w under /var/hda/platform/html/script/.. ENV=production
NOTICE: redirected 'https://github.com/amahi/disk-wizard/ar ... 8.0.tar.gz' --> 'https://codeload.github.com/amahi/disk- ... .gz/v0.8.0' ...
file /var/hda/tmp/amahi-download-cache/1d7ec401a683131c7b299686b25dc1bbe26257e4 written in cache
Migrating database of the plugin, if applicable
App: Disk Wizard installed
======= app install end @ 2016-10-18 11:02:57 +1100 ==========
======= app install begin @ 2016-10-18 12:12:40 +1100 ==========
Installing app id 9nkg8qqh62 under /var/hda/platform/html/script/.. ENV=production
NOTICE: redirected 'http://downloads.sourceforge.net/projec ... _2.1.9.zip' --> 'http://internode.dl.sourceforge.net/pro ... _2.1.9.zip' ...
file /var/hda/tmp/amahi-download-cache/ef4dffde9dacae1fbf302d06e6da729f197eebe0 written in cache
WARNING: this application unpacks into more than one file/dir. PLEASE contact the authors and well them to unpack into one dir only as most other apps so!
NOTE: check the unpack/ directory for all the files
Your HDA services have been restarted.
Your HDA services have been restarted.
App: eXtplorer installed
======= app install end @ 2016-10-18 12:13:02 +1100 ==========
======= app install begin @ 2016-10-18 12:13:11 +1100 ==========
Installing app id w47lx2g5d2 under /var/hda/platform/html/script/.. ENV=production
NOTICE: redirected 'http://downloads.sourceforge.net/projec ... hp4.44.zip' --> 'http://internode.dl.sourceforge.net/pro ... hp4.44.zip' ...
file /var/hda/tmp/amahi-download-cache/ffce308352c32cbdd720934e155b2716a77bdeef written in cache
Your HDA services have been restarted.
Your HDA services have been restarted.
App: PHP Navigator installed
======= app install end @ 2016-10-18 12:13:14 +1100 ==========
======= app install begin @ 2016-10-18 12:15:38 +1100 ==========
Installing app id e16rk5omw2 under /var/hda/platform/html/script/.. ENV=production
App: Amahi Sync installed
======= app install end @ 2016-10-18 12:15:51 +1100 ==========
======= app install begin @ 2016-10-18 12:16:19 +1100 ==========
Installing app id 231k7dfrpz under /var/hda/platform/html/script/.. ENV=production
App: Amahi Anywhere installed
======= app install end @ 2016-10-18 12:16:33 +1100 ==========
======= app install begin @ 2016-10-18 12:16:59 +1100 ==========
Installing app id ttgaxb4bsg under /var/hda/platform/html/script/.. ENV=production
NOTICE: redirected 'https://github.com/amahi/pytivo/archive ... ahi.tar.gz' --> 'https://codeload.github.com/amahi/pytiv ... 14.2.amahi' ...
file /var/hda/tmp/amahi-download-cache/e42b5ee5fb72578a97c51dac9ceaac23af1d75b0 written in cache
Your HDA services have been restarted.
Your HDA services have been restarted.
No local packages or download links found for PIL
error: Could not find suitable distribution for Requirement.parse('PIL')
Created symlink from /etc/systemd/system/multi-user.target.wants/pytivo.service to /usr/lib/systemd/system/pytivo.service.
Created symlink from /etc/systemd/system/multi-user.target.wants/pyhme.service to /usr/lib/systemd/system/pyhme.service.
App: pyTivo installed
======= app install end @ 2016-10-18 12:19:00 +1100 ==========
======= app uninstall begin @ 2016-10-19 01:24:00 +1100 ==========
Uninstalling app id w47lx2g5d2 under /var/hda/platform/html/script/.. ENV=production
Your HDA services have been restarted.
App: PHP Navigator uninstalled
======= app uninstall end @ 2016-10-19 01:24:02 +1100 ==========
======= app uninstall begin @ 2016-10-19 01:24:30 +1100 ==========
Uninstalling app id 9nkg8qqh62 under /var/hda/platform/html/script/.. ENV=production
Your HDA services have been restarted.
App: eXtplorer uninstalled
======= app uninstall end @ 2016-10-19 01:24:31 +1100 ==========
======= app install begin @ 2016-10-19 01:25:12 +1100 ==========
Installing app id 9nkg8qqh62 under /var/hda/platform/html/script/.. ENV=production
file /var/hda/tmp/amahi-download-cache/ef4dffde9dacae1fbf302d06e6da729f197eebe0 picked up from cache.
WARNING: this application unpacks into more than one file/dir. PLEASE contact the authors and well them to unpack into one dir only as most other apps so!
NOTE: check the unpack/ directory for all the files
Your HDA services have been restarted.
Your HDA services have been restarted.
App: eXtplorer installed
======= app install end @ 2016-10-19 01:25:32 +1100 ==========
======= app install begin @ 2016-10-19 01:25:43 +1100 ==========
Installing app id w47lx2g5d2 under /var/hda/platform/html/script/.. ENV=production
file /var/hda/tmp/amahi-download-cache/ffce308352c32cbdd720934e155b2716a77bdeef picked up from cache.
Your HDA services have been restarted.
Your HDA services have been restarted.
App: PHP Navigator installed
======= app install end @ 2016-10-19 01:25:45 +1100 ==========
/var/hda/platform/html/lib/downloader.rb:104:in `download': http://mirror.amahi.org/c21ee90f27a0cb1 ... 1b60e0de2d (from original https://dl.amahi.org/server_logs_viewer.tar.gz), '95a7e2e0ccea21868c9cc1f746cf9811c164d5c9' vs. 'c21ee90f27a0cb151170ef1cfefc601b60e0de2d' (Downloader::SHA1VerificationFailed)
from /var/hda/platform/html/lib/downloader.rb:50:in `download_and_check_sha1'
from /var/hda/platform/html/app/models/app.rb:200:in `install_bg'
from /var/hda/platform/html/script/install-app:86:in `install_or_uninstall'
from /var/hda/platform/html/script/install-app:107:in `main'
from /var/hda/platform/html/script/install-app:119:in `<main>'
======= app install begin @ 2016-10-19 09:50:05 +1100 ==========
Installing app id magc31p6jg under /var/hda/platform/html/script/.. ENV=production
WARNING: primary downloaded of https://dl.amahi.org/server_logs_viewer.tar.gz barfed with exception "#<OpenSSL::SSL::SSLError: SSL_connect returned=1 errno=0 state=error: certificate verify failed>"
WARNING: primary downloaded file /var/hda/tmp/amahi-download-cache/c21ee90f27a0cb151170ef1cfefc601b60e0de2d did not pass signature check - got badbadsha1, expected c21ee90f27a0cb151170ef1cfefc601b60e0de2d
new file /var/hda/tmp/amahi-download-cache/c21ee90f27a0cb151170ef1cfefc601b60e0de2d from Amahi's cache written in the cache
/var/hda/platform/html/lib/downloader.rb:104:in `download': http://mirror.amahi.org/c21ee90f27a0cb1 ... 1b60e0de2d (from original https://dl.amahi.org/server_logs_viewer.tar.gz), '95a7e2e0ccea21868c9cc1f746cf9811c164d5c9' vs. 'c21ee90f27a0cb151170ef1cfefc601b60e0de2d' (Downloader::SHA1VerificationFailed)
from /var/hda/platform/html/lib/downloader.rb:50:in `download_and_check_sha1'
from /var/hda/platform/html/app/models/app.rb:200:in `install_bg'
from /var/hda/platform/html/script/install-app:86:in `install_or_uninstall'
from /var/hda/platform/html/script/install-app:107:in `main'
from /var/hda/platform/html/script/install-app:119:in `<main>'
======= app install begin @ 2016-10-19 09:51:01 +1100 ==========
Installing app id magc31p6jg under /var/hda/platform/html/script/.. ENV=production
WARNING: file /var/hda/tmp/amahi-download-cache/c21ee90f27a0cb151170ef1cfefc601b60e0de2d in cache was found to be corrupted! Discarding it.
WARNING: primary downloaded of https://dl.amahi.org/server_logs_viewer.tar.gz barfed with exception "#<OpenSSL::SSL::SSLError: SSL_connect returned=1 errno=0 state=error: certificate verify failed>"
WARNING: primary downloaded file /var/hda/tmp/amahi-download-cache/c21ee90f27a0cb151170ef1cfefc601b60e0de2d did not pass signature check - got badbadsha1, expected c21ee90f27a0cb151170ef1cfefc601b60e0de2d
new file /var/hda/tmp/amahi-download-cache/c21ee90f27a0cb151170ef1cfefc601b60e0de2d from Amahi's cache written in the cache

[bigfoot65]

I see some errors in the log near the end.

Please post the output of the following:

Code: Select all

echo "select id,name from webapps" | mysql -uroot -phda hda_production

[revhead]

That commands returns the following:
ERROR 1054 (42S22) at line 1: Unknown column 'id.name' in 'field list'

[bigfoot65]

Let's just do it this way then:

Code: Select all

echo "select * from webapps" | mysql -uroot -phda hda_production

That should yield some results.

I don't have access to my HDA to verify the syntax is correct, so hopefully it works.

BTW, did you run hda-install more than once? There seems to be some details missing about your install. Can you provide more clarity on how you performed the install of Fedora and Amahi?

[revhead]

That commands returns the following:
ERROR 1049 (42000): Unknown database 'hda-production'

I've done numerous installs in an attempt to get this working. This is the third install code I've used, followed the install instructions and the only thing I did differently this time was install the LXDE desktop.
By the way I took the plunge and converted to using DHCP on the HDA. All fixed IPs are less than 100.

[bigfoot65]

It's hda_production not hda-production. Underscore and not a dash.

Please try again.

BTW we do not support desktop installs. Recommend you stick with the default install instructions and not deviate.

[revhead]

I tried the default install and it didn't work. Once I (we) work out what is actually causing the problem I may revert to the standard install.
Output as follows:
[revhead@ourserver ~]$ echo "select * from webapps" | mysql -uroot -phda hda_productionid name path kind aliases fname deletable login_required dns_alias_id custom_options created_at updated_at
1 dlna /var/hda/web-apps/dlna generic 1000-dlna.conf 0 0 7 ProxyPass / http://localhost:8200/\nProxyPassReverse / http://localhost:8200/\n 2016-10-18 00:00:51 2016-10-18 00:00:51
4 pytivo /var/hda/web-apps/pytivo Python 1003-pytivo.conf 0 0 10 ProxyPass / http://127.0.0.1:9032/\nProxyPassReverse / http://127.0.0.1:9032/ 2016-10-18 01:18:56 2016-10-18 01:18:56
5 extplorer /var/hda/web-apps/extplorer PHP 1002-extplorer.conf 0 0 11 <Files *.php>\nphp_value upload_max_filesize 32M\nphp_value post_max_size 32M\n</Files> 2016-10-18 14:25:13 2016-10-18 14:25:13
6 navphp /var/hda/web-apps/navphp PHP 1003-navphp.conf 0 0 12 NULL 2016-10-18 14:25:44 2016-10-18 14:25:44
[revhead@ourserver ~]$

[bigfoot65]

Ok I see there are apps installed. You stated they don't show in Available or Installed of the Apps tab? This is uncharacteristic and possibly caused by you using a non-standard Amahi install method.

BTW we do not support desktop installs. Recommend you stick with the default install instructions and not deviate.

Sorry my comment above might not have been clear. We cannot provide support to a desktop install. There are compatibility issues with desktop packages and Amahi which is why we don't provide guidance for those types of installs with Amahi 9 or future releases.

If you want further assistance, you need to follow the install instructions as documented at http://docs.amahi.org

I tried the default install and it didn't work.

What did not work? That's what we can help with. Rather than deviating from guidance, ask for help. We are happy to help with the supported install problems.