+ Reply
Page 2 of 3 FirstFirst 123 LastLast
Results 21 to 40 of 60

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: [Question] Apache/PHP/MySQL and running a webserver on an iDevice (iOS 4.0+)

is a discussion within the

General iPhone Chat

forums, a part of the

iPhone Modding

section;
Originally Posted by therealduckie Yes, very much so, Please. Here it is, on the tech forums I administrate. I had to upload it on another forum, due to server differences.
...
  1. #21
    What's Jailbreak? Kamikengen's Avatar
    Join Date
    Nov 2010
    Posts
    15
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by therealduckie View Post
    Yes, very much so, Please.
    Here it is, on the tech forums I administrate. I had to upload it on another forum, due to server differences. You may/may not have to register on Gobaka, I haven't looked at the permissions yet. It's a 10.7 MB ish file.

    iOS Friendly MySQL

    Viola.

  2. #22
    Green Apple therealduckie's Avatar
    Join Date
    Apr 2008
    Location
    New Jersey
    Posts
    44
    Thanks
    7
    Thanked 8 Times in 5 Posts

    Yes, you have to register to download it. Can I put it on another server like Mediafire?

    Thanks, also.

  3. #23
    What's Jailbreak? Kamikengen's Avatar
    Join Date
    Nov 2010
    Posts
    15
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by therealduckie View Post
    Yes, you have to register to download it. Can I put it on another server like Mediafire?

    Thanks, also.
    Hey, it's not my file; I can't take credit for it.

    Go ahead, the more widely available things like this are, the better for us all.

    If you get it working within PHP, can you post back here saying how you did it?

    I've reached the point where I have MySQL running rock solid, but I have to make it's functions available in PHP.

  4. #24
    Green Apple therealduckie's Avatar
    Join Date
    Apr 2008
    Location
    New Jersey
    Posts
    44
    Thanks
    7
    Thanked 8 Times in 5 Posts

    Kamikengen,

    What terminal commands did you use to install this? I see no documentation within the package that it is ARM specific or that it will run on an iPhone.

    Also, where did you find it?

    Thanks

  5. #25
    What's Jailbreak? Kamikengen's Avatar
    Join Date
    Nov 2010
    Posts
    15
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by therealduckie View Post
    Kamikengen,

    What terminal commands did you use to install this? I see no documentation within the package that it is ARM specific or that it will run on an iPhone.

    Also, where did you find it?

    Thanks
    Okay, install instructions are here as follows:
    1. Open an SSH session to your iDevice
    2. Extract the contents of the tgz archive to your /var/root folder, so that the contents are under the mysql directory.
    3. In your SSH client, navigate to /var/root/mysql/bin
    4. Type (without the apostrophes, obviously) './mysql_install_db'
    5. The installer will set up your basic grant tables, and set up the basic root accounts
      I'm sure you can go from here, as setting up your server.
    6. To start the server, navigate to /var/root/mysql/bin, and run './mysqld --user=root' If you don't add the --user suffix, the MySQL daemon will not start, due to security restrictions on starting the executable with the root account.

    From there on, I'm stuck.

    I got this from an article somewhere; I can't remember where it was, or if it still exists. I do remember that it was a Megaupload link. Meh, all that matters that is that we have it now.

  6. #26
    Green Apple therealduckie's Avatar
    Join Date
    Apr 2008
    Location
    New Jersey
    Posts
    44
    Thanks
    7
    Thanked 8 Times in 5 Posts

    Ok, so that's the normal Linux How-To, so I should be good. I will let you know about my progress. Might be later tonight...but might also be tomorrow. I might get sucked back into Minecraft lol

  7. #27
    What's Jailbreak? Kamikengen's Avatar
    Join Date
    Nov 2010
    Posts
    15
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by therealduckie View Post
    Ok, so that's the normal Linux How-To, so I should be good. I will let you know about my progress. Might be later tonight...but might also be tomorrow. I might get sucked back into Minecraft lol
    Ah, thanks.

    I've tried to modify the existing PHP config files, but either I'm not doing it right (most likely) or there's no changes being applied. I think a new PHP install has to be build, with MySQL support enabled at build time.

    Thanks again.

  8. #28
    Green Apple therealduckie's Avatar
    Join Date
    Apr 2008
    Location
    New Jersey
    Posts
    44
    Thanks
    7
    Thanked 8 Times in 5 Posts

    Ok, so here's my first impressions (and results) after installing it:

    1. There are no extensions installed. Most likely means this package will not be able to tie into PHP. Extensions needs to go directly into the PHPO install in order to work. No luck.

    2. Starting the MySQL server (which, by the way, starts with "mysqld_safe" not "mysqld") kills the PHP server from outside access. I have to reboot the iPhone to get PHP working as a server again. It works internally (I can visit my sites via iPhone's Safari) but I can not serve the pages to my Computer.

    3. I can not SSH into my iPhone after starting the MySQL server because it locks port 22

  9. #29
    What's Jailbreak? Kamikengen's Avatar
    Join Date
    Nov 2010
    Posts
    15
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by therealduckie View Post
    Ok, so here's my first impressions (and results) after installing it:

    1. There are no extensions installed. Most likely means this package will not be able to tie into PHP. Extensions needs to go directly into the PHPO install in order to work. No luck.

    2. Starting the MySQL server (which, by the way, starts with "mysqld_safe" not "mysqld") kills the PHP server from outside access. I have to reboot the iPhone to get PHP working as a server again. It works internally (I can visit my sites via iPhone's Safari) but I can not serve the pages to my Computer.

    3. I can not SSH into my iPhone after starting the MySQL server because it locks port 22
    1. I agree. Although, if you go to (if you have lighttpd installed, like I do) /usr/lib/lighttpd/, the file mod_mysql_vhost.so may help. As you can most likely tell, this far in, I'm out of my depth.

    2. Starting the mysql server can be done with the mysqld file for me, with no consequences to PHP running. I can still serve files.

    3. I can SSH into my iPod Touch fine, even with mysql running.


    EDIT: MySQL starts with mysqld, from a different directory, /var/root/mysql/ibexec
    If you want any details about my iOS environment for comparison, I'll help out the best that I can.
    Last edited by Kamikengen; 11-14-2010 at 08:47 PM.

  10. #30
    What's Jailbreak?
    Join Date
    Nov 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    First. Thanks for the file! Been looking for that for some while now!

    BUT!: when i perform step number 4. (./mysql_install_db), i get the following error message:
    ./mysql_install_db: line 118: my_print_defaults: command not found
    FATAL ERROR Didn't find /var/root/mysql/libexec/mysqld
    You should do a 'make install' before executing this script

    what to do?

  11. #31
    What's Jailbreak? Kamikengen's Avatar
    Join Date
    Nov 2010
    Posts
    15
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by kentora View Post
    First. Thanks for the file! Been looking for that for some while now!

    BUT!: when i perform step number 4. (./mysql_install_db), i get the following error message:
    ./mysql_install_db: line 118: my_print_defaults: command not found
    FATAL ERROR Didn't find /var/root/mysql/libexec/mysqld
    You should do a 'make install' before executing this script

    what to do?
    What directory are you running the installer from? Make sure the account you are using is root.

    I'm not the best person to be asking, but that's what immediately comes to mind.

  12. #32
    What's Jailbreak? Kamikengen's Avatar
    Join Date
    Nov 2010
    Posts
    15
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Shameless bump.

    I'm still surprised NO ONE else other than 3 or 4 people are interested in this project.

    Anyone that can help, please contribute!

  13. #33
    What's Jailbreak?
    Join Date
    Nov 2010
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Allright. I got somewhere now i think!

    you have to open the "mysql_install_db" file and replace:
    • replace "mysql//" with "mysql/"
    • replace "/var/" with /private/var/

    Now you should be able to install mysql. I hope. xD

  14. #34
    What's Jailbreak?
    Join Date
    Feb 2011
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    hi
    are there any progress on this project? id like to use this on my apple tv2

  15. #35
    What's Jailbreak?
    Join Date
    Feb 2011
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Allright, so for some reason my previous profile got deactivated, without me knowing when and why.

    But. The progress is that i have been able to install according to the things i wrote prev, but then i had to restore, and know its not working .

    But please try! Need for restore is worst thing that can happen, and we would really like to hear your results!

    Regards
    Kentora

  16. #36
    What's Jailbreak?
    Join Date
    Feb 2011
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Okay, so searching a little on google i suddenly saw this very interesting artice on awkwardTV's wiki. They state to have an ATV running XAMPP, and yes. There is a download link!

    Pregi, i think you should try it out, and please let us know how it went! I myself do consider buying an ATV to have it running as both media and webserver (for private use only. Might use it for printserver to and maybe even more.. )

    If the download link for some reason ever breaks, please let me know, i have the package, and will try to keep it save.

    Regards,
    Kentora

  17. #37
    What's Jailbreak?
    Join Date
    Feb 2011
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    did u mean that osx xampp build (xampp-macosx-0.7.2.tar.gz) or did i miss something on that site?
    this build would work on apple tv 1 but not on the new one, for this we need an arm based build
    sadly i dont have enough skills to build every binary for arm based cpu
    Last edited by pregi; 02-26-2011 at 02:56 PM.

  18. #38
    What's Jailbreak?
    Join Date
    Feb 2011
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Doing a little more research i saw that ATV2 only have 8 gigs of space. So i'm not quite sure that this is even possible.

    Do you have Apache or anything running at the moment?

  19. #39
    What's Jailbreak?
    Join Date
    Feb 2011
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    not on apple tv
    ive found a build but there are some missing dylibs, so it wouldnt start
    but i try to find out if i can compile xampp for appletv
    i didnt need much space for this, just some mysql dbs and some php stuff

  20. #40
    What's Jailbreak?
    Join Date
    Feb 2011
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    well, what i was thinking was more like that the 8 gigs might be used for caching and the iOS.

    Do you have SSH so you have any detail on free space?

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts