rupertthebear

Hi, I have just installed an source installation of Apache2.2.3 on a fresh net install CD image Debian 3.1 distro on my PC (no web server, file server or mail server intalled at that time). I downloaded to my {desktop}[b]/rupert/local/ [/b] folder, unzipped, untarred and ran [tt][size=12pt]./configure --enable-mods-shared-all[/size][/tt] and changed to my [b]/rupert/local/httpd-2.2.3/[/b] folder. I ran [tt][size=12pt]make[/size][/tt] and then tried to run [tt][size=12pt]make install[/size][/tt] I got permission denied messages. Just for a laugh, I logged in as root and tried it again: Apache was installed to [b]/usr/local/apache2/[/b] Not to be silly, I logged in as a civillian again and [thru impatience and ignorance] I ignored [b]httpd.conf[/b] and tried [tt][size=12pt]/usr/local/bin/apachectl start[/size][/tt] I got permission denied messages again. Logging in as root again, I found that running [tt][size=12pt]/usr/local/bin/apachectl start[/size][/tt] showed no error message - neither did [tt][size=12pt]/usr/local/bin/apachectl stop[/size][/tt] Please help.  While I could strip everything naked with a bit of chmod-ery, still I'm wondering: what would be the best permissions setup for [b]/usr/local/apache2/[/b] downwards? Would it be better to delete everything and install Apache somewhere else?

I am having trouble storing a "string" of charaters (encoded from a whole number value) in a blob field. I can produce the character sequence with php functions. However, the database seems to add a few characters to the string value I supply between quotes in an UPDATE query . Does any php function predict what is happening in the UPDATE statement here so that I can retrieve to same sequence I intended to store? I am building a web application that saves and retrieves data from mySQL - often as a series of numeric values (of specific data type and size) laid down in blob fields. Retieval from blob fields is straight-forward using SELECT SQL in a mysql_query() - I can divide up the field result as though it was a string. Laying down a predictable series of numeric values in a bolb field is difficult but possible using LOAD DATA INFILE. The numeric value can be encoded into bytes - values ranging 0 - 255, each byte is understood to require multiplication by 256 to the power of its position - 1 in the sequence. The value of each byte can be converted to a character - sometimes escaped with slashes: Using LOAD DATA INFILE is clearly inelegant for single assignments but an UPDATE query just seems to add bytes to the blob which I don't understand. As I said, is there any php functions that can predictably reproduce what happened to the blob field or even decode it back?

I am a wamp newbie hoping to be able to build some inter-related mysql tables using LOAD DATA INFILE statements that refer to text files built and temporarily saved by PHP code on a web server. All works fine on my wamp - but the files are not picked up by the LOAD DATA INFILE statements in a similar experiment on my web domain. I assume I cannot access the MySQL folders (to save my text files there) and I am told I need File permissions to my public_html folder (in order to save the text files there so that the LOAD DATA INFILE statement can pick it up). And File permissions on the public_html folder has serious security implications. What are these implications - can my PHP script be read to see the MySQL username and password in a mysql_connect() statement? Can nasty files be saved by others on my public_html folder? Hope this is the right forum to ask about this.