Page 2 of 3
Re: Suggestions for next step in next LiveCode project?
Posted: Sun Jul 03, 2011 10:29 pm
by BarrySumpter
Nope. Just ain't gonna happen with LiveCode.
Bummer.
Oh well.
5 out of 5 can't do's with LiveCode.
Re: Suggestions for next step in next LiveCode project?
Posted: Mon Jul 04, 2011 12:52 am
by BarrySumpter
Installing IIS 5.1 for WinXP.
IIS 6 is for platforms other then WinXp - Not for individual download - part of another OS.
IIS 7 is the same as IIS 6. Not for WinXP.
- IIS 7 - vista + longhorn
- IIS 6 - w2k3 + xp pro x64 bit
- IIS 5.1 - xp pro
- IIS 5 - w2k + w2kpro
IIS 5.1 installed but all kinds of rediculous security issues.
Finally setup a password for Administrator accout
- - -log off current user - then ctrl alt del - UserID: Administrator - PassWord: (blank) - Control Panel - Users - Administrator Account - Setup Password
and have to use it each and every time I try to access
http://LocalHost or by IPAddress i.e.
http://192.168.x.x
No matter what browser I use - may be updated security settings require login no matter what - even if allow anonymous access is ticked on everywhere.
---
Will test on android next
Re: Suggestions for next step in next LiveCode project?
Posted: Mon Jul 04, 2011 1:19 am
by BarrySumpter
With Allow Annonymous logon - TICKED ON
I can login on the first try 0 - no prob
Then on the next browse to local host I don't get a login screen and it just errors out.
I then turn off the allow anon (with Integrated windows authentication ALWAYS ticked ON)
and all browser work ok
- asks for UID & PW on first browse
then on second browse to localhost it no longer asks for UID & PW - just displays my local host properly.
whew!
MySQL DB from Summer Academy Week 5?
Posted: Mon Jul 04, 2011 1:40 am
by BarrySumpter
Hi all,
Does anyone have the MySQL DB from Summer Academy Week 5?
I've setup my own IIS server here at home and want to test the Week 5 MySQL Example.livecode against it.
Re: Suggestions for next step in next LiveCode project?
Posted: Mon Jul 04, 2011 3:33 am
by BarrySumpter
Tring to get the IIS LocalHost to show web page on mobile emulator.
Testing emulator would not work.
suggestion to use
http://10.0.2.2 - which is supposed to point to the emulators host computer.
LocalHost is the emulator not the PC the emulator is running on
Ticked the Allow Anonymous Access back on - and it works in the emulator - grrrrr
192.168.x.x works as well in the emulator
----
Back to physical phone - nope
Must not have some sort of access to IIS
Re: Suggestions for next step in next LiveCode project?
Posted: Mon Jul 04, 2011 4:31 am
by BarrySumpter
friggin nighmare!
How to set required NTFS permissions and user rights for an IIS 5.0, IIS 5.1, or IIS 6.0 Web server
http://support.microsoft.com/kb/271071
I really don't feel this helped anyting at all.
Don't spend an hour on trying to sort this out until you've setup IIS following the next post.
Refresh the Defaul Web Site - test - if it still doesn't work then go ahead and try this knowledge base article.
Re: Suggestions for next step in next LiveCode project?
Posted: Mon Jul 04, 2011 9:43 am
by BarrySumpter
I am using OS: XP pro 32bit & IIS V5.1.
Right CLick My Computer | Manage | Computer Management | Internet Info. Serv. | Web Sites | RIght Click Default Web SIte | Properties
Default Web Site Properties
Note: Y= checked on, N= not checked.
Website Identification:
Running
Host header name: blank
IP Address (SELECT All Unassigned) port: 80
WEB SITE
IP Address: (All Unassigned)
TCP Port: 80
HTTP keep alive enabled : Y
Enable logging: Y
ISAPI FILTERS: blank
HOME DIRECTORY:
content should come from: A Directory on this computer :Y
Local path: c:\inetpub\wwwroot (which I have shared through explorer: share folder on network:Y, Allow users to change files: Y)
Watch this Local Path - if you have a windows on a differnet drive, and install IIS, that wwwroot path will be on that different drive.
Script source access: N
Read: Y
Write: N
Dir browsing: N
Log Visits: Y
Index resource: Y
APPLLICATION SETTINGS:
Application name: Default Application
Execute Permissions: Scripts Only
Application protection: Medium(pooled)
DOCUMENTS:
enable default document: Y
Document List Box:
Note: This is the order in which IIS processes these default Documents to display as the web page when using localhost:
I have added my Login.aspx here and all other website files to the inetpub/wwwroot directory)
Enable document folder: N
HTTP HEADERS:
enable content expiration: N
DIRECTORY SECURITY:
ANONYMOUS ACCESS & AUTHENTICATION CONTROL: (EDIT)
anonymous access: Y
User name: computerName\IUSR_cpmputerName (computerName being my computer name)
allow IIS to control password: Y
basic authentication: N
Integrated Windows Authentication : N
ALSO NOTE: with Computer Manager - my updates were NOT taking affect until I execute a Refresh... on default web site
I'm pretty sure a Refresh is to stop IIS then restart IIS. Be patient.
Re: Suggestions for next step in next LiveCode project?
Posted: Mon Jul 04, 2011 10:48 am
by BarrySumpter
What thuh !
OK working now!
From physical phone.
Using defaul browser on Android or FireFox.
192.168.x.xx
Whewh!
freakin 9 hours.
Re: Suggestions for next step in next LiveCode project?
Posted: Tue Jul 05, 2011 8:56 am
by BarrySumpter
SparkOut wrote:Or it's time to make a new database
Ok, taking the flippant hat off, you could use the remote device to post to the intranet server running a server side processor (revCGI, php, etc) and have that do the actual db updates and put data back out to the device for display.
IIS 5.1 installed
Can't get LiveCode to recognize SQLite on IIS localhost
Could have a look at mySQL - don't have the interest any more
Should ask Valentina.
now perhaps:
Install Windows, Apache, MySQL, and PHP on IIS 5.1
http://www.sitepoint.com/php-amp-mysql-1-installation/
Re: Suggestions for next step in next LiveCode project?
Posted: Tue Jul 05, 2011 1:52 pm
by SparkOut
If you want a simple-yet-powerful WAMP environment, without a registry footprint, that "just works" you could do worse than try
http://www.uniformserver.com/
I use it a lot for development. I've never put IIS on any of my development machines, I don't shy from it for work but these days much less work comes from IIS than from clients with an Apache/MySQL/PHP setup/requirement. I expect you will find it a lot easier to configure, and there are lots of resources generally.
SQLite is a "textfile" based db, and you should be able to access it via a filepath, rather than a url. Not a very robust solution though. (I have used SQLite over a network connection in a "proof-of-concept" scenario before clients commit to sourcing a "proper" multiuser relational db, with workable results. There was no need for a "web" server to host the db in this case though, just a shared file location.)
Re: Suggestions for next step in next LiveCode project?
Posted: Tue Jul 05, 2011 4:12 pm
by BarrySumpter
How do yo setup as just a shared file location on Android?
Hoping I can access it with LiveCode.
Re: Suggestions for next step in next LiveCode project?
Posted: Tue Jul 05, 2011 6:18 pm
by SparkOut
Of course! I never tried from an Android client. I wonder if File Expert from xageek (which can navigate SMB shares) can be employed here?
When I get a chance I will have a try (may not be for a while). Mind you, as mentioned, an SQLite db over a network is not ideal anyway.
Re: Suggestions for next step in next LiveCode project?
Posted: Wed Jul 06, 2011 12:05 am
by BarrySumpter
Shared file access doen't work via LiveCode for Android.
Please don't waste your time.
If you find an article which tells us how to set it up step-by-step.
Please feel free to send it to me.
Otherwise don't bother.
As soon as I find a solution I'll post it here.
Re: Suggestions for next step in next LiveCode project?
Posted: Wed Jul 06, 2011 12:57 am
by BarrySumpter
OK. Its a wonder when you have a decent sleep what you can think of:
Code: Select all
put "\\myPCName\wwwroot\Barry888.data" into tDatabaseAddress
put "\\192.168.1.6\wwwroot\Barry888.data" into tDatabaseAddress
Both work on the PC.
But not on Android.
Re: Suggestions for next step in next LiveCode project?
Posted: Sat Jul 09, 2011 7:43 am
by BarrySumpter
Testing RealStudio Web (Trial).
First trial without DB - runs on Android via FireFox for Android Browser.