[Tikiwiki-users] Tiki running on Android now

[Torsten F. <to...@fa...>]

Hi,

the last few days I did play around with my new Asus Memopad 7" and 
thought it would be the right time, to get my personal Wiki (kind of my 
Tiki-PIM) from my Linux laptop onto my Android device.

Though I am not carrying around the laptop all day, phone is too small 
and I missmatch to many information and sometimes appointments ...

There are a few Apps around, which allow to setup a PHP/Lighttpd server 
and a MySQL server on an Android device and even as my device just got 
rooted this afternoon, it is possible to run PHP/MySQL based 
webapplications on a non-rooted standart Android phone or tablet.

Via the LAN it seems quite slow (need more testing), but inside the 
Android it is running smooth and fast enough.

Please note: Never delete all MySQL users (specifically the 'root') on 
an Android, even not by accident ;-) - you will be fu****.

Due to this, at the moment I cannot use the great app "Servers Ultimate" 
/ "Servers Ultimate Pro" (icecoldapps.com) for the webapplications ... 
until I find a way to recreate the MySQL "root" in the icecoldapps area 
of my Android ... uninstalling does not work.

Anyway "Servers Ultimate" provides me with a handy FTP Server, to which 
I simply connect from my Linux PC / Laptop and share easily!! files 
between the devices - wireless!!

So right now I use a much more simple basic, but sametime smooth and 
cool app "AndroPHP" (ayansoft) which has not the extreme amount of 
features like "SU", but exactly what is needed here:
switch on/off PHP/MySQL.

Both apps are working with the Lighttpd server instead of Apache, which 
means, that there is no SEFURL or MEMORY_LIMIT-Extention etc. out of the 
box.

Lighttpd offers rewriterules and such aswell, but uses NOT htaccess, but 
instead a serverside config file, as far as I could find out.

So now I will create some basic documentation on doc.t.o, adding 
Installation on Android and Lighttpd.

If there is anybody willing to contribute or if there is somebody with 
some decent MySQL/Android knowledge, please feel free to contact me.

---

If there is any question, for what that should be a use:

* use of Tiki as mobile personal information manager (PIM) and 
notekeeping wiki (mind that using the Android Server, you can still work 
on it from your (any) PC, respectively from any client that connects to 
the Tiki website via LAN/WLAN.

* development of websites whereever you go, without the need of laptop 
and stuff --- just throw the 7" or 10" tablet in a small bag and work 
wherever you like - at the pool, in the city, mountains etc. (very handy 
for me, whilst I am on a cycling tour).

* take the device and show your Tiki-made presentations at any lecture 
at any place, from any computer just using the WLAN (or your phones 
hotspot) and the Tab (or phone)

* use it for ad hoc training

* ...


Some data, if anybody want to do an ad hoc test:

Get "AndroPHP" or "Servers Ultimate" for free or "Servers Ultimate pro" 
for 6,99€ from the Google Playstore - both "Servers Ultimate" and 
"S..U..pro" need additionally the "Servers Pack C" which is for free 
aswell. AndroPHP is much smaller and does not need anything additional.

For a quick trial I recommend "AndroPHP".
For more productive work "Servers Ultimate" provides more features ... 
about 39 types of servers ...

**********************************************************************

Default settings for "AndroPHP":

 From another PC use the LAN-IP, which is shown on the default page of 
the installed running app - for *example 192.168.2.109* (in case of 
problems just mind if you have set static or dynamic DNS in your local 
Router).

Webport of AndroPHP is 8080
MySQLport of AnroPHP is 3306

Unpack Tiki somewhere on the external or internal Sdcard and alter the 
path in the AndroPHP settings (mainly selfexplaining, but I will provide 
a few screenshots anyway).

Reach the installer from your Android:
127.0.0.1:8080/path_to_the_tiki_root_from_the_set_webroot

Reach the installer via LAN:
192.168.2.109:8080/path_to_the_tiki_root_from_the_set_webroot

Setup a database:
same:
127.0.0.1:8080/phpmyadmin
or:
192.168.2.109:8080/phpmyadmin

Host/Socket for the local.php to mention in the installation process:
Host: 127.0.0.1:3306
(typing "localhost" will mostlikely not work, so use "127.0.0.1")

databasename, database_username and password as usual

and all the rest of the installation process is like on any Linux Server

**********************************************************************

I hope the above information is any use to one or another,

greetz and cheers,
Torsten