Possible MySQL Solutions for iOS Apache/HTTPD Server
Great news, we have possibly found a solution for a iOS/iPhone device Web server’s MySQL component.
Throughout the internet, this seems to be the mission link for making any iOS device a web server. Right now the biggest issue we have now is making sure that it is of a legal origin.
Right now we are waiting to hear from a visitor who mentioned he had a solution for this aspect of a IOS Web server.
Categorised as: Legal iOS, MySQL
I’m glad to supply a link to the iOS ARM processor compatible install of MySQL: http://www.megaupload.com/?d=JG0YMGZ7
The install procedure is a standard Linux do; extract the files to /var/root/mysql to that the directory of the files is mysql.
Open a Terminal connection to your iDevice, and navigate to the /var/root/mysql/bin and then run ./mysql_install_db which will then install everything and set up your basic grant tables.
After this, however, I’m stuck. I have no idea how to get MySQL’s functions available in PHP, working with the iOS lighttpd software.
Thanks Kamikengen! I will try this for myself, then I will relase it as a beta guide. Following that, after a few people approving, I will add it to the guide.
Thanks again!
PS. Regarding you other reply, it was approved, but you commented on a different post…
Sounds like a plan.
No probelms.
I checked all three, but I didn’t see it. Must’ve missed it.
It would be great news indeed, if it would be possible to get php and mysql working together. I installed mysql, but php does not talk to it, so its quite useless at this point.
So if there is a solution for php to work with mysql, please post it here.
Thanks for your work!
Yes, that’s what we’re now trying to accomplish. I’ve had some edits with PHP’s configuration’s ‘h’ files, but no mysql module seems to be installed, can be installed nor activated. If this crucial link can be established, we can have ourselves a portable webserver.
Anybody get it working yet:?)
Its working here!
http://www.karlkraft.com/index.php/2010/09/17/mysql-for-iphone-and-osx/
I love reading these aritcles because they’re short but informative.
I saw some old articles said they run php programs with mysql with there iphone. I already run mysql on my iphone. Just need mysql part for php now.
I think we should try to compile php on iphone.
I totally agree, the trouble is getting a compiler on an iOS device. If we could compile on iOS, this site would be distributing HTTPD and Apache for iOS, not talking about how to get there.
If you know how to compile/have a compiler for iOS, then we are talking, if not then we are back where we started.
I’m still trying on compile php on ios. If I got any news I will leave a message on this site.
http://www.ifans.com/forums/showthread.php?t=113035
see this
php-5.2.8/main -I/var/root/php-5.2.8 -I/var/root/php-5.2.8/ext/date/lib -I/var/root/php-5.2.8/TSRM -I/var/root/php-5.2.8/Zend -no-cpp-precomp -O2 -c /var/root/php-5.2.8/Zend/zend_extensions.c -o Zend/zend_extensions.lo
/var/root/php-5.2.8/Zend/zend_extensions.c: In function ‘zend_mh_bundle_load’:
/var/root/php-5.2.8/Zend/zend_extensions.c:242: error: ‘NSCreateObjectFileImageFromFile’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:145)
/var/root/php-5.2.8/Zend/zend_extensions.c:246: error: ‘NSLinkModule’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:161)
/var/root/php-5.2.8/Zend/zend_extensions.c:247: error: ‘NSDestroyObjectFileImage’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:147)
/var/root/php-5.2.8/Zend/zend_extensions.c:250: error: ‘NSLookupSymbolInModule’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:181)
/var/root/php-5.2.8/Zend/zend_extensions.c:252: error: ‘NSAddressOfSymbol’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:188)
/var/root/php-5.2.8/Zend/zend_extensions.c: In function ‘zend_mh_bundle_unload’:
/var/root/php-5.2.8/Zend/zend_extensions.c:265: error: ‘NSLookupSymbolInModule’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:181)
/var/root/php-5.2.8/Zend/zend_extensions.c:267: error: ‘NSAddressOfSymbol’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:188)
/var/root/php-5.2.8/Zend/zend_extensions.c:271: error: ‘NSUnLinkModule’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:169)
/var/root/php-5.2.8/Zend/zend_extensions.c:271: warning: passing argument 2 of ‘NSUnLinkModule’ makes integer from pointer without a cast
/var/root/php-5.2.8/Zend/zend_extensions.c: In function ‘zend_mh_bundle_symbol’:
/var/root/php-5.2.8/Zend/zend_extensions.c:277: error: ‘NSLookupSymbolInModule’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:181)
/var/root/php-5.2.8/Zend/zend_extensions.c:278: error: ‘NSAddressOfSymbol’ is unavailable (declared at /var/toolchain/sys30/usr/include/mach-o/dyld.h:188)
make: *** [Zend/zend_extensions.lo] Error 1
when I compile php on my iphone, it comes these Errors. Any idea?
What are you using to compile this? If we can get gcc on these things, we can compile everything ourselves
I installed toolchain and gcc on my iphone. I compile php source code on iphone. But the headers and lib got some problem.
I hadn’t seen this article, and have just installed LightTPD with PHP, and SQLite3 on an iPod Touch. PHP seems to work ok, but tried to add ASP.NET support using Mono, and couldn’t get it to work. Would Apache be able to do it? Or is there another way?
Apache can support mono, but need cross compile for iphone. I think your php does not support MySql, does it?
PHP 5.2.8 (cli) (built: Oct 3 2011 16:42:19)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
I did it. But I disable-all.