Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

  1.  # 1

    Has anyone gotten Silo to work?
    http://forums.secondlife.com/showthread.php?t=119570&highlight=silo

    I am not new to scripting, but I am completely new to llHTTPRequest. I am *very* interested in hosting my own data server off-grid, but had a nightmare of a time trying to get Silo working.

    Any thoughts? Or suggestions for another solution? :)

  2.  # 2

    I have not used that particular script, I write all functions dealing with off-world data storage myself, but it is in PHP and I might be able to help. What sort of errors are occurring?

  3.  # 3

    Well, I am using GoDaddy for my webhost... so it is probably an issue with Apache or PHP configuration, but I would get either a 405 or a 301 error returned... I can't find anything anywhere about what the 301 error would be caused by... the 405 seems like it is probably a matter of not having the correct PHP settings... but I am not really that well versed in PHP (shame on me!!)

  4.  # 4

    Hm. Off-hand I really cannot say an awful lot at the moment, I would have to try to install myself. Perhaps somebody else has experience.

  5.  # 5

    Would you have any pointers about off-world data storage that might be beneficial for a newbie to the concept? I am familiar with HTML, and I am an absolute novice with PHP (but I grasp code well, so am a quick study), so any suggestions or snippets would be welcome.

    I have 2 different needs for off-world data storage. I would like to be able to have a quick & dirty (reasonably secure) method to store little pieces of information (like a UUID) for some of my projects, and for a couple of other things I am considering, I would need to work with a MySQL database. Any suggestions of a good resource to check out would be most appreciated :)

    • CommentAuthored44
    • CommentTimeOct 24th 2007
     # 6

    To start with you could download a wamp (windows apache mysql php) and install it on your own pc to start with.

    Then use lots of echo commands to tell your user sw what is going on.

  6.  # 7

    Mr Bedlam: actually I was thinking of writing a simple example of storing and retrieving information in a MySQL table via PHP and an inworld script, as having a lookup table of sorts and storing data in it is frequently extremely handy.

    I was forced to teach myself PHP-MySQL at quite short notice to write both some of the web-based apps that you might see on my site, and also for a commercial project, and I have to say that it is pretty simple to do, but is a bit opaque at first. I mostly worked using the php.net documentation - all of the functions required are in one section, all beginning with "mysql_".

    PHP is also a good language for the self-taught I think, though one can produce some spectacularly ugly and unmaintainable code if one isn't careful.

  7.  # 8

    I suppose it's about time I taught myself some PHP anyway. Ordinal, if you do write that example, I would absolutely love to see it. Thanks for the suggestions! :)

    •  
      CommentAuthornand Nerd
    • CommentTimeOct 25th 2007
     # 9

    Resolving 405 errors - general
    405 errors often arise with the POST method. You may be trying to introduce some kind of input form on your Web site, but not all ISPs allow the POST method necessary to process the form.
    All 405 errors can be traced to configuration of the Web server and security governing access to the content of the Web site, so should easily be explained by your ISP.

    From http://www.checkupdown.com/status/E405.html

    Resolving 301 errors - general
    The 301 response from your Web server should always include an alternative URL to which redirection should occur. If it does, a Web browser will immediately retry the alternative URL. So you never actually see a 301 error in a Web browser, unless perhaps you have a corrupt redirection chain e.g. URL A redirects to URL B which in turn redirects back to URL A. If your client is not a Web browser, it should behave in the same way as a Web browser i.e. immediately retry the alternative URL.
    If the Web server does not return an alternative URL with the 301 response, then either the Web server sofware itself is defective or your Webmaster has not set up the URL redirection correctly.

    From http://www.checkupdown.com/status/E301.html

    Both of these seem to point to your host as opposed to a problem which you yourself have caused or an issue with Silo. I would recommend contacting your host's technical support. Whenever I run into an issue which looks like it's my host I drop them a support ticket and they're pretty good about resolving it (though sometimes you need to drop some hints as to what the solution is).
    As for learning PHP it's not too bad if you're used to HTML and LSL scripting it should come with a bit of practice. Main difference is just the syntax and quirks (such as using . instead of + to concatenate strings). Finally if you do go down the route of MySQL (which I'd recommend) see that your host provides phpmyadmin (or ask very politely if they would for you). This has been a life-saver for me while learning MySQL as it allows you to access your database(s) from webpage interface. Incidentally, if you're in the UK and looking for a host I could recommend one (if that's kosher on this forum) which has served me well for almost a year now.

  8.  # 10

    Thanks for the information! The explaination of the 301 was helpful. I was getting that echo'd back to me in SL through my test object. The 405 sounds about right too... I think I would have to get my hosting company to change a couple of settings in PHP for it to run properly. That's ok though... because I managed to learn enough PHP last night to create directories, create files, write to them, read from them, and delete them all from within SL. :D

    Tonight I plan on reading up about security and usage of this "flat file database" thing, an then I will begin working with MySQL. I was originally using w-hat's service to store server keys and such, but I was worried that they may eventually discontinue the service or change it. I don't want to sell things that rely on such variables beyond my control.

  9.  # 11

    Just an update...

    I finally got down to it, and managed to craft myself both a flat file database system, as well as a MySQL database system! I am now able to move forward with about 6 different projects I have been wanting to work on for some time now.

    Thanks for the assist everyone! :D

    [note] - I gave up on Silo, as I would have had to change the php.ini and lighten security a bit to use it, so I wrote the php interface myself. THAT was a learning experience... lol

  10.  # 12

    I'm nearing the completion of a rather complicated SL->PHP->MySQL->back again project, and I wanted to point out some canned PHP that is very helpful:
    Justin Vincent's EzSQL classes encapsulate the DB stuff. Get it here: http://www.woyano.com/jv/ezsql
    Docs/tutorial/justification here: http://www.woyano.com/view/410/PHP-and-Working-with-Databases-for-the-Lazy-Sod
    Free and open source (of course). Subclass it with a new constructor for your server info and you're modular, baby.