AltME groups: search

No, not really...

One table would be much easier and I do not think the db would get 
so large that I would see major performance problems. (I always underestimate 
the speed of these db's.)

Thanks for the advice, Sunanda.

I've tried text and varchar

SQL command is a string so IMHO you have to mold it and enquote it 
as normal text and then there should be no problems .. what kind 
of errors does it throw?

I molded it and it inserted into mysql but now I need to see if after 
selecting it that it behaves properly in my app....
thanks for the help

I'm using 'mold/only' saving to mysql and
'to-block'  to re-block it...
is there a cleaner way like an 'unmold'?

Also, i have some datestamp issues.
rebol attaches the zone code to now when getting the date/time

but when using mysql timestamp I do not get a time zone attached 
and its screwing me up.
Is there a way to add time zone to datestamp in mysql?

From what I have been able to read about timestamps and mysql I might 
as well insert the client's time...
But then I would need to issure clietn's clocks are correct....
What is SOP for this situation?

I just did an update to my server time and my other computer..

I used time.nist.gove for the server and time.windows.com for the 
other computer and they were two minutes apart

I tried again and they are now synced...atleast to the minute...

I tried to insert a longer string using phpMyAdmin and it inserted 
fine...no truncation.
I guess its mysqlprotocol.r problem.

Anyone else encounter this? Any work arounds?

I'm sending much larger blobs (image files) and it works just text 
is giving the problem but I'll need to look further. Thanks all.

are you using latest 1.3beta versionof the driver? previus version 
may have a problem and truncate..

I don't use mysql .. but Firebird.  And I'm waiting for the sphinx 
integration into firebird before I try doc's mysql driver.

Understanding and control of MySQL query optimizer http://assets.en.oreilly.com/1/event/21/Understandingand Control of MySQL Query Optimizer_ Traditional and Novel Tools and Techniques Presentation.pdf

At least, the whole networking support needs probably to be fully 
rewritten for R3. Beyond that I'm not sure what you work or not out 
of the box with R3. String encoding and Unicode might require some 
additional code. MD5 support is also required btw, if you want to 
use passwords with 4.1+ MySQL servers (for 3.x support, you would 
need to rewrite the whole current driver encryption code).

A web provider only provides access to mysql from a script ... and 
you will have a static ip for your web host.

amacleod, CGI, yes or use rebservice if you allowed to start a port 
and forward the sql request to doc's mysql sheme as localhost 

or switch to a virtual server with linode or slicehost for full control.

amacleod, CGI, yes or use rebservice if you allowed to start a port 
and forward the sql request to doc's mysql sheme as localhost 

or switch to a virtual server with linode or slicehost for full control.

I'm serving the db from my own p for this host as there is server 
for now as bandwidth is not an issue yet. I signed unlimited bandwidth, 
storage, email accounts, mysql db's etc. for a few bucks a month. 

I was just testing mysql for possible use down the road.


When the time comes i will probably go the "linode" route as iwould 
want to use Cheyenne too and no provider is going to let you run 
that.

I usually build a server script to access the database via procedures 
needed for the app. They then communicate via JSON. Works pretty 
well and eliminates the need for client side SQL, and it works with 
anything that can POST to a webserver.

Hi MySQL Group, I program in C, Fortran, Cobol, Superbase4, PHP, 
MySQL and some other languages but I'm fairly new to Rebol. I am 
attempting to connect to a remote MySQL database by following the 
intstructions here http://reboltutorial.com/blog/mysql/.I have downloaded 
the mysql-protocol.r file and run it in my Rebol program but I keep 
getting this error 'Access Error: Network timeout'. What does that 
mean? How do I fix it? Any help appreciated.

I pinged the server just fine. Here is the code:

REBOL []
#include do %mysql-protocol.r

results: read rejoin [mysql://mysqluser:[mypassword-:-mysite-:-com]:22/mydatabase 
["SELECT * FROM tablename"]


The MySQL server is on a hosted machine. In cpanel I added my IP 
address to the 'Remote MySQL' Remote Database Access Hosts list. 
I think you are right that I will need to access the database from 
the cgi because the hosting company will not allow direct access, 
even though its suppossedly allowed in cpanel.

Thanks for your help.


Are there any examples of accessing a MySQL database via CGI in Rebol? 
I just googled and found nothing.

Here is a simple example but basically you just create a script that 
reads from the DB locally and prints. Your remote app reads the printout 
when it reads from the page:

#!/user/cgi-bin/REBOL -cs
REBOL [Title: "Get Roster"]

do %mysql-protocol.r

db_ip: mysql://user:[password-:-localhost]:3306/bighouse

db: open db_ip
insert db "SELECT * FROM roster"
		dat: copy db
close db

print dat

Place this file in your cgi-bin and have your remote client 'read' 
the url to that file.  


Don't forget to place mysql-protocol.r somewhere on the server an 
'do' it.


you could 'encript' the output with encloak using a simple key if 
some security of the data is needed. Just decloak at the remote client 
with same key.

Thanks amacleod I'll give that a try. ChristianE, I don't see any 
MySQL settings like that on my cpanel, which I am familiar with. 
I don't know if my ISP allows me to access such things. I've never 
seen that kind of information about MySQL in cpanel. How would I 
check? I am also looking for a virtual server where I can set everything 
myself in order to use Rebol to access databases and create HTML. 
If possible I want to eliminate PHP and use Rebol as my standard 
web interface program, but until I can get Rebol reading/writing 
to my databases I am stuck.

In any case, I'd probably just do plain queries and construct the 
JSON from the resultset.

Either you transfer a very large string which you build up within 
MySQL. Or you transfer a very large result set and build up the string 
in REBOL.

If a query gives me a rebol block of blocks and I send it through 
json.r I don't get a json object.

Should I work on converting the query to a rebol object first?

ok, so there is no easy way to do it...I justs need to loop through 
each rebol block and insert the field name before the data and then 
make objeet?

mysql problem what does this error mean?

    Hello,
    I am just looking at REBOL and trying to access mysql
    I got this error??
    ===================================
    connecting to: 127.0.0.1

    ** User Error: ERROR 1251 : Client does not support authentication 
    pro
    tocol requested by server; consider upgrading MySQL client
    ** Near: db: open mysql://[rootass-:-127-:-0-:-0-:-1]:3306/mysql
    ==============================================
    This the code I am using from rebol document
    Rebol[
    title: "Rebol Mini-Text Database with Visual GUI"

    author: "http://reboltutorial.com/blog/rebol-mini-text-database/"
    version: 1.0.0
    ]
    do %mysql-protocol.r
    probe first system/schemes
    db: open mysql://[rootass-:-127-:-0-:-0-:-1]:3306/mysql
    insert db {
    DROP TABLE IF EXISTS products;
    CREATE TABLE products (
    name VARCHAR(100),
    version DECIMAL(2, 2),
    released DATE
    );

    INSERT INTO products VALUES ('cheyenne', '1.0', '2007-05-31');
    INSERT INTO products VALUES ('mysql', '1.1', '2007-05-01');
    }
    insert db read %setup.sql ;-- execute a big SQL file

It looks like the MySQL driver he's using is too old for his MySQL 
server. He should try with the latest version for newer servers: 
http://softinnov.org/tmp/mysql-protocol-41.r


I haven't made it official as it does not work for older servers 
IIRC, and I also never found the time to fully test it with more 
recent ones.  But it should work correctly.

Doc, what a lifesaver! I just spent the last 7 hours trying to figure 
out what was wrong with my remote rebol-based mysql app. It stopped 
working after I upgraded mysql. I spent most of my time messing around 
with mysql until I narrowed it down to the protocol.
 
sql-protocol-41.r Addresses: 

User Error: ERROR 1251 : Client does not support authentication protocol 
requested by server; consider upgrading MySQL client  (When using 
newer long hash passwords) 
and

User Error: ERROR 1043 : Bad handshake  (when using older short hash 
passwords) 

Thank you for posting this. I was getting to the point of panic.

and if I use multiple virtual domain? hmm, that should not matter 
....

You put the "your browser does not support" message in the noframes 
section.

Many elderly browsers don't support them. All modern ones do -- though 
support can be turned off as a user-selected option.

Search engines are still very patchy at indexing frames -- and that 
is unlikley to get better given the inherent problems with frames

If i put short html source with meta tag and redirection, I get endless 
loop of redirects ...

Thanks Gabriele. I should mention why I do need it. The problem is, 
that some big distributors cheat on their sub-distributors. Together 
with few shops we found out, that although they allow to use their 
part of portal, some customers are clever, find out what shop it 
is in reality and they go directly to the parent shop and get the 
same price as from us. That is indeed bad behavior on their part 
as their partly ruin our business, but we can't do nothing about 
it. I will do my own shop, but as a whole system. I will describe 
architecture later ...

yes, and in FF it looks like rubbish.  The text gets truncated.

And, there is also the problem that occurs if any code example is 
too long, pushing out the right margin for the entire doc. I've thought 
about correcting for that in MD. But, not sure how best to do that 
(wrap or clip).

yeah...I have done the scaling, sort of a fishy thing to have to 
do.  More of a rhetorical question I was asking...because if Web 
browsers and Adobe Acrobat were well designed, electronic documentation 
would be a joy to use...just lots of room for improvement to REBOLutionize 
the industry.

Indeed PATH-THRU seems to work on this url, as well as LOAD-THRU 
and EXISTS-THRU? (they all rely on PATH-THRU)

In future, I think a proper mapping function (probably using PARSE) 
should be created, and path-thru would use that instead of REPLACE, 
but until then I think this is a very good and cheap fix.

URLs are not technically very restricted. Can't remember the details 
off hand -- Google for RFC1630.

But many implementations are restricted  in random and petty ways.

But my energy for tonight is just about to expire... Luckily I just 
installed the "SessionSaver" extension for Firefox (keeps documents 
persistent), so I can just close firefox and go offline. Nice plugin.

Chris - today one MS defender on Czech phorum argued following way 
- W3C are morons, who did everything to have the main word in defining 
standards. According to such person, only IE supports properly xsl, 
SMIL and VRML and that PNG can be used with some trick ...

Who uses XSL, SMIL or VRML?  And the PNG trick privides marginally 
better alpha PNG support -- but only 32-bit and not in CSS.  Look, 
there is a standard document format -- XHTML.  There is a standard 
way to make it look nice on multiple mediums -- CSS.  And a standard 
way to add images -- PNG.  As the major web browser, IE limits these 
standards (CSS + PNG) through limited support -- that sucks.

yes, and if you don't want MSN messenger - you have to uninstall 
it at each IE security update

I installed it on WinME and it survived the XP upgrade.

The trick for me is to reconcile the she-bang line, not only for 
different servers and OSs *but* also with different scripting languages. 
 Using one she-bang line on the test machine and a different one 
on a live server is full of potential errors, regardless of the language. 
On apache/windows the following line being enabled: "ScriptInterpreterSource 
registry" tells apache/windows to find an association in the registry. 
Well, there is no rebol/core installation procedure to do it, and 
the registry entry appears to be different from windows 98/IIS, and 
I haven't been able to figure it out. I need to be able to run scripts 
from rebol, python and perl on this machine *and* to be able to upload 
any of them to a unix/linux server. so ..... I installed rebol and 
user.r in c:\usr\bin, installed python at   d:\python23 *and* copied 
python.exe to c:\usr\bin. So far rebol and python are both working 
using #!/usr/bin/rebol and #!/usr/bin/python respectively as the 
she-bang lines (with ScriptInterperterSource turned off). I will 
later try that with perl and see what happens. If that works, then 
I have a solution. However,  it seems to me that the rebol installation 
should provide proper registry entries to by-pass the she-bang line 
as perl and python do.

Using one she-bang line on the test machine and a different one on 
a live server is full of potential errors,
That's true.

But using the *same* shebang in a collaberative development forces 
all developers to have the same setup. 


We sorted that in REBOL.org by having the custom uploader change 
the shebang to be correct for the upload destination.

you can upload a test-script with that shebang and call it from rebol 
as part of the upload.

you need to set some little  options and that's all folks

you have a tool named apache monitor to start apache serv and to 
stop it or restart it :)

There would be no collaboration on this machine between rebol programmers. 
Two programmers, one using rebol and python (me), the other using 
perl. And of course we are using the same setup, because all scripts 
are being uploaded to any of a number of linux or sun system servers, 
all of which use the same convention: #!/usr/bin/[interpreter]. I 
fully understand Sunanda's approach, but in the case of rebol.org, 
there are many programmers working from multiple machines in multiple 
OSs. I think the the c:\usr\bin approach will work fine for our humble 
endeavor.

Having said that, I want to eventually study Sunanda's approach more, 
because I want to eventually set up a rebol-based system for uploading 
that will handle she-bangs *and* dependencies.

BTW: Rebol.org seems to be progressing very well. If progress continues, 
I envision something as sophisticated (and hopefully easier to use) 
as CPAN. Keep up the good work.

Sunanda: I quote you from another forum: Tim: A general purpose uploader 
would be very useful. I'll drop you some notes privately on some 
ideas for what it should/could do.....Looking forward to it! My idea 
is of a cgi upload script that for any cgi script, first checks a 
web site and compares timedate stamps, checking to make sure that 
dependencies are current and if not, makes them also available for 
upload. BTW: Some time ago on the rebol ML,

there was reference to an enhanced FTP module. Does that ring a bell? 
<grin> or was that you?

I think that was probbaly Romano and his FTP patches:

http://www.rebol.org/cgi-bin/cgiwrap/rebol/ml-display-thread.r?m=rmlDKCQ


I'm convinved that an FTP program alone isn't enough.  You need an 
intelligent program at at each of the pipe......Sounds like you are 
thinking the same way.

I suspect you will have to look up the ip address in an ip map and 
guess from there

'http-head should probably parse out the port for the web server 
and if  it is not there, only then default to 80

we're a pretty tame lot here ... good job Terry is around to wake 
us up now and then

OUTLINE OF SCAPEGOATING PSYCHO-DYNAMICS

In scapegoating, feelings of guilt, aggression, blame and suffering 
are transferred away from a person or group so as to fulfill an unconscious 
drive to resolve or avoid such bad feelings. This is done by the 
displacement of responsibility and blame to another who serves as 
a target for blame both for the scapegoater and his supporters. The 
scapegoating process can be understood as an example of the Drama 
Triangle concept [Karpman, 1968].
http://www.scapegoat.demon.co.uk/

I really like the bit in the middle where they discuss the merits 
and flaws of JavaScript versus CSS for site interactivity.

(I hope this is the right group to post this in.)

I have a problem, when reading a file on another computer thru a 
shared drive. I'm sitting on a Windows client, and the file is on 
a UNIX server. First time I read the file, it's ok. Then if the file 
is updated on the UNIX server, I still get the old version on the 
client.

I've tried the read-thru/update command, but it doesn't solve the 
problem. Maybe read-thru/update doesn't work with shared drives? 
My code looks like this:

read-thru/update %/u/adv71-20/data/invoice.txt

Any ideas?

(It's possible to distribute a sync from the server to the client, 
and then I'll get the new version of the file. But I'll like to be 
able to get the new version from the client.)

It seems, my problem is only with Win98. Even a normal read works 
on Win2000 and WinXP.
And then you tell me: DON'T use Win98, right? ;-)

I want a report to give me a good overview about the year, current 
month etc. AWStats looks good in this. I like the visits and sample 
trials reports of wusage. Shows how people browse your site.


Clicks-to-result must be as low as possible. Simple to install, configure 
and use.

So the idea is just look at the ARCHIVED mode, toggle it, then set 
it back to how it was. Hopefully that will wake the outside caching 
mechanism up and you can get your fresh data.

Good suggestions, Anton! Yes, I'm pretty sure, it's outside REBOL's 
control, as I sometimes see strenge behaviour (for example regarding 
file locking) in other programs. The intra-network, I'm doing those 
things in, is a combined Win98-Win2000-WinXP network with a few UNIX 
servers present. The way, we share drives, is the standard Windows 
way using the SMB protocol (using Samba on the UNIX servers). I've 
for a long time suggested, that they do it the UNIX way and install 
NFS clients on the PCs in stead. I tried to install some ProNFS client 
yesterday, but couldn't get it to work (probably because of some 
lame Windows authentification, maybe also encrypted passwords).


It could be interesting to see, if the cache problem dissappear when 
using NFS.

Oh! It uses exists-thru? and read-net !!  I will post the sources 
for these dependencies to you privately.

Q for javascript/CSS guru.


How to change the font weigth of an <input type="text"> field with 
Javascript ?


I have a function called on OnChange() event that check the value 
and I want to display the field in Bold if value > 0, or normal if 
value = 0

I can open it with my editor, and it looks fine to me (but that just 
means that I don't know what to look for).

Correct.  I used the same script to download some rebol docs, however, 
and they display.

If I try to open the downloaded file from my harddrive with Foxfire, 
I get an error message saying the file cannot be found!  But it is 
there and can be opened with my text editor.

That is because you saved the frameSET page.  It is going to attempt 
to load the frames but it also has support for no frames.  You could 
parse out the Frameset tags and it should display just fine...

Any recommendations for a freeware website log analysis program?

I want it to run on a windows desktop, analyse logs downloaded from 
a website, and be *really* easy to use because I'll be setting it 
up for a non-programmer - and I don't want support calls ;-)

Hm... I'm trying to parse a webpage and strip all HTML tags from 
it but my approach isn't work.  Grr!

I have a problem with HTTPS over a proxy. I'm using REBOL/Command 
2.5.6.3.1, that came with our SDK. This version first need the HTTPS 
protocol to be activated using this code:


net-utils/net-install HTTPS make system/schemes/http/handler [] 443

system/schemes/https: make system/schemes/https [user-agent: reform 
["REBOL" system/product system/version]]

I activated trace by typing: trace/net on

Our proxy is set up ok, as I can read the internet with a browser 
using it (both HTTP and HTTPS).
Now if I in REBOL do this:

>> s: read https://webservices.rki.dk

I get:

URL Parse: none none webservices.rki.dk none none none
Net-log: ["Opening" "ssl" "for" "HTTPS"]
connecting to: webservices.rki.dk
Net-log: {CONNECT webservices.rki.dk:443 HTTP/1.1
Host: webservices.rki.dk:443

}
Net-log: "HTTP/1.0 200 Connection established"
Net-log: {GET https://webservices.rki.dk:443/ HTTP/1.0
Accept: */*
Connection: close
User-Agent: REBOL Command 2.5.6.3.1
Host: webservices.rki.dk:443
}
Net-log: none

** User Error: Error.  Target url: https://webservices.rki.dk:443/ 
could not be
retrieved.  Server response: none
** Near: s: read https://webservices.rki.dk

And I'm sure, I'm going through the proxy with the browser, as I 
tried a wrong TCP/IP port and got a proxy error. With the rigth port, 
it works ok.

and can you read non ssl pages thru the proxy with rebol?

And if I try with a wrong TCP/IP port configuration (like I did with 
the browser test), I get this:

>> s: read http://www.rebol.com
URL Parse: none none www.rebol.com none none none
Net-log: ["Opening" "tcp" "for" "HTTP"]
connecting to: www.rebol.com
** Access Error: Cannot connect to 193.3.239.91
** Where: open-proto
** Near: s: read http://www.rebol.com

So I am going through the proxy with REBOL.

it's a library and also command line utlity for doing web stuff.

curl is a command line tool for transferring files with URL syntax, 
supporting FTP, FTPS, HTTP, HTTPS, GOPHER, TELNET, DICT, FILE and 
LDAP. Curl supports HTTPS certificates, HTTP POST, HTTP PUT, FTP 
uploading, HTTP form based upload, proxies, cookies, user+password 
authentication (Basic, Digest, NTLM, Negotiate, kerberos...), file 
transfer resume, proxy tunneling and a busload of other useful tricks.

wrote results out to data files, and then parsed the results out 
with rebol.

Carl: I have to check that at work tomorrow (I didn't set it up). 
We're testing on a proxy, and another one is at a customer, where 
it doesn't work either. The customer is the norwegian oil company 
Statoil, and we have their words, that it supports "tunnelling", 
but I'm sceptical as usual. ;-)

There was discussion way back in 1991 http://www.rebol.org/cgi-bin/cgiwrap/rebol/ml-display-thread.r?m=rmlXQTK
about Curl, and the 30Mb download required.

I also tried reading a https page using command and squid, and couldn't 
get it to work.

Out customer Statoil use a hardware proxy from NetApp called NetCache, 
and they have the same problem.
http://www.netapp.com/products/netcache/netcache_family.html

Tunnelling is supported according to their specs: http://www.netapp.com/products/software/software_specs.html

I see the spelling "tunelling" with one 'n' now and then, in case 
you're searching the documentation.

Seems like SSL Tunnelling with squid is on by default on certain 
ports using the CONNECT method:

http://www.squid-cache.org/mail-archive/squid-users/200210/0295.html

Our customer was monitoring the trafik and could see, that nothing 
happened after the CONNECT, so maybe the problem is, that REBOL doesn't 
continue after the CONNECT!? As I understand it, the CONNECT method 
is used to establish a connection between the two computers (client 
and server), and then the proxy simple let the communication continue 
without touching it (allowing SSL encryption and the like). REBOL 
can make the connection, but fail to communicate afterwards. (My 
guess.)

Geomol - there is nothing like "connect". If you have a free bit 
of a free time, I suggest you to download Winpcap and Ethereal - 
they are both free and you get cool network monitoring tool. You 
can learn a lot ...

ah, proxies ... in our company, although we use Squid IIRC, we have 
following problem - we found out, our admins use kind of load balancing, 
but they are not able to solve session afinity right now, so eg. 
ICQ disconnects after some time, as it can get packed routed using 
different machine and it imo causes communication to break ...

Graham: I've done Ethereal monitoring with our test proxy, and after 
the "HTTP/1.0 200 Connection established" reply from the proxy, there's 
a line from my computer (running REBOL) to the proxy with the text 
"Continuation or non-HTTP traffic". After that, the proxy reply with 
a [FIN, ACK]. If that "continuation" holds the information from my 
REBOL application to go to the server in the other end, it may be 
a proxy problem!?

I'm having some problems with the rebol example webserv.r   I've 
installed it on a computer at home and a computer here at work. It 
works fine at home, but here there appears to be problems with the 
path of the script. The log file is places several places (where 
the webserv.r script is located and severel places inside the www 
path), and there are problems accessing rebol scripts inside :[  
]: - apparently also because of problems with the path. Very wierd 
behaviour. Any help appriciated.

Flemming, are you using the same version of rebol and are they on 
the same platform at home as at work ?

Graham: I'm not sure, if the copyright on prot-http.r prevent me 
from posting it, but I can tell you, what I added to it. My work-around 
consists of 2 extra lines after line 46, which in my version is:

append http-packet "^/"

My extra lines are:

replace/all http-packet "^/" "^M^/"
remove back tail http-packet	; Because a newline will be added.


It's not a nice solution, but it works. A better way would be to 
open the port with a /with refinement and CRLF. See RAMBO #3532.

Does anyone know away to automate the checking of a website that 
requires https, authentication and probably cookies. I basically 
want an application to log into my ebank account and extract some 
information.

jaime you probably need to dig into what protocol your ebank uses...the 
most common ones are HBCI and OFX  ( i think =D  )

When I try the samples.  they all fire off the download, etc.  install 
seems to work, except that I always end up with red x, and nothing 
ever runs.  Just wondered whether anyone ever figured out what was 
up with that, or whether there was any momentum at all with rebol 
plug-in.  I'd probably rather have an active-x/progid sort of affair, 
but talk about a can of worms.  I've never done it, but looked into 
it.  seems like it may not be such a big step, though, if there's 
been success with browser plugin.  This is all sort of an aside. 
 I didn't really have anything particular in mind, except as maybe 
an Ajax alternative.

I'm not expecting any new plug-in releases until LNS is out and other 
builds are done. Don't know about momentum, but I'm using it for 
a project and it's pretty darn handy if you ask me.

I've been in awe of it since I got it working.  IE has been my primary 
platform for a long time now.  Spent quite a bit of time building 
a working asynchronous http client with IE's xmlhttp, but now am 
wondering why I bothered.  Rebol makes me nervous and excited about 
the implications.

Net is going to need restricted, I think, and cache probably needs 
some restriction as well.  I wonder if there's been any discussions 
on how to keep rebol from being the target for some very malicious 
code.  I know more about IE's security model and what I can do at 
IE defaults, and would like to code such that I am not relying on 
features that can/should/will be restricted by default.

It seems, a call to net-log failed, and that was the cause of the 
problem. It's because NetCache has extra header-lines, that e.g. 
Squid doesn't have. See RAMBO 3638.