SQLite and GNV

wg_webpage
The major work at the moment is getting a program running that takes input from a file and dunps it into a webpage. The basics behind it: the forementioned routines, did work already and the testprogram has been modified to show at least a hardcoded content. But coding the whole lot from there proved more troublesome than anticipated so I deciced to redo the program from scratch – but use what’s already working.

One thing I encounterd is a serverless SQL engine, used in the anti-spam gateway to store statistics: SQLite. I downloaded the sources and was trying to get it to compile, to begin with, but that didn’t work. next I tried using the GNV package – I still had 1.6 on the box. the configure script ran up to checking the header files and stalled there. In a brain flash I downloaded and installed the latest (2.1) version and ran into some problems: The directory was accessable only for displaying the contents. CD to it fails, as well as running a script. Put a message on ITRC and got the answer to get to the directory – but running the script fails in a number of places and doesn’t get as far as running under GNV 1.6. It appears the scripts needs to be updated in one place, and some adaptions are to be made to circumvent some other problems. There may be some bits missing, so I’ll have to get these as well.
One thing I noted: the modules need to be built /NOANSI, and /FLOAT=IEEE. But that’s a minor issue. With this knowledge, it may be possible to circumvent GNV.

06-Jan-2008

Rejected Webaccess
Last weblog shows an attempt to do simething werid:

210.51.23.7 - - [06/Jan/2008:02:06:34 +0100] "GET http://clickingagent.com/proxycheck.php?ip=217.149.210.164&port=80&loc= HTTP/1.0" 403 864
...
210.51.23.7 - - [06/Jan/2008:05:27:00 +0100] "GET http://clickingagent.com/proxycheck.php?ip=217.149.210.164&port=80&loc= HTTP/1.0" 403 864

In other words – this person (?) tries something and appearently fails to reckognize autentication errors – for 2 1/2 hours. There are 159 entries all together, the intervals differ – from minutes to tenths of seconds. In vain, of course, because proxies are not enabled.
Plus the ever recurring types of attempts, but less than normal.

One thin g to add to be allowed: the count program. It’s in the home page and valid – but shows up, as well as the webpage itself.

SSL
This weekend I tried to get a server certificate from CA-cert, and had (I think) to use the HP-supplied scripts ($ @SSL$COM:SSL$_CERT_TOOLS), because the WASD SSL kit isn’t complete in that respect (according Mark’s documentation), I got one from CA-cert and after some playing around following documentation, I thought I got one to use as server certificate. But the server failes on handling it:
%HTTPD-I-SSL, ssssssss.grootersnet.nl:443
-SSL-I-CERT, DDDDDD:SSSSSSSS.PEM
-SSL-W-ERROR, "error:0906D06C:PEM routines:PEM_read_bio:no start line" (HT_ROOT:[SRC.OPENSSL-0_9_8.CRYPTO.PEM]PEM_LIB.C;1 644)"Expecting: CERTIFICATE"
-SSL-W-ERROR, "error:140DC009:SSL routines:SSL_CTX_use_certificate_chain_file:PEM lib" (HT_ROOT:[SRC.OPENSSL-0_9_8.SSL]SSL_RSA.C;1 727)
-SERVICE-W-SSL, service not configured

leaving each of the SSL’d sites inaccesable. So I reversed to the original, and first check how to create such a certificate…