AltME groups: search

mostly a spare time, but look at Carl's presentation - he sumes it 
up there too. There are few developers, doing REBOL full time:


- few top developers present here work for RT on contractual basis. 

- there is a company called SafeWorlds (Reichart's company) - he 
employs tens of ppl IIRC. Their new system is http://qtask.com, 
front end is web 2.0, but whole back-end is REBOL based.

- few developers working on their own - Henrik, Ashley, DocKimbel 
(mySQL, postgress cool protocols, Uniserve, Cheyenne)

generally about speed: I rarely worry about REBOL/Core speed. I made 
a database once that was mainly about in memory block manipulation 
in REBOL. On an old 500 Mhz Celeron laptop, I couldn't saturate it, 
when throwing queries at it from 3 fast PCs over a 100 MBit LAN. 
I think it was about 100-1000 times faster than a MySQL database, 
but of course with the price that it's in-memory and that it had 
very few features.

Just installed 5.0.77 community server on Windows, no problem to 
log in using default password mode with mysql protocol v1.2.1.

MySQL config file (my.cnf) can be in one of these places :
- /etc/
- $HOME/ 
- MySQL data folder

I think there is no limit on number of tables. A database in MySQL 
is implemented as a directory containing files that correspond to 
tables in the database.

I've run into situations where MySQL will fail to do DDL without 
throwing an error, at least not one the mysql:// driver notices. 
Haven't tested with the /Command driver or qcmysql:// though.

The DDL in question is create table statements where some obscure 
semantic rule is violated. By obscure, I mean it took me a day to 
track down the error in the MySQL manuals.

You should try with the official command line mysql client. If you 
notice a different behaviour than the mysql:// driver, please report 
it here.

Does the /Command client support MySQL 5.1?

I'm hosting a large number of text docs broken up by sections in 
a mysql db. Once all the material is on line the changes (and thus 
downloads) wil be smal for the most part. But in the mean time large 
amounts of material are still to be uploaded to the db and when a 
client finds this new material it will download it and any changes 
to previous material. The material contains a lot of image data too 
so it could add up. Right now I have about 40 megs of data and I 
have about 10X more to upload.


If its too tuff for me I will just display some animated gif but 
I would prefer something more tangible..

I'll look into your suggestion, Thanks Doc...


BTW I tried the latest mysql-protocol and it broke my app. I have 
not had a chance to look into it but I think you changed some syntax 
for selects??
I'm using Version: 1.1.2 at the moment.

Thanks for the additional info. The main change in 1.2.0 is the new 
READ syntax, and it's documented here : http://softinnov.org/rebol/mysql-usage.html#sect2.2.

I'm just understanding now what you're trying to do. READ-NET is 
not what you want to use, it's for downloading files! You have to 
write your own progress bar function. About the total size of result 
set, AFAIK, MySQL server doesn't send that information, it just marks 
the last record of a result set.

This is interesting http://sphinxsearch.com/news/37.html.. you can 
now connect to the sphinx searchd daemon using the mysql binary protocol 
... so doc's mysql driver can also now connect to sphinx??

is doc's mysql protocol the binary one they talk about?

There's also an alternative approach, the SQL-ESCAPE encoding function 
of MySQL driver is exported in the global context, so you can use 
it when forming SQL queries directly :

send-sql db join "UPDATE table SET field=" sql-escape string


The prepared statement approach is recommended, because the driver 
will care about that for you automatically (so less risks that you 
forget to encode one value, opening a hole for SQL injection attacks).

Is there any reason mysql will not accept a nested block in a text 
field?
I have no problem with sqlite storing the same data...

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?

Any reason why my data in a 'text' column is getting truncated at 
9999 characters? I tried 'longtext' but there was no change..

I thought 'text' holds up to 4 gigs from what I read...


I saw something about longtext being limited by the way a client 
handles packets..could this be a problem with MySQL protocol?

can you use any other formats?  Does mysql have text blobs ?

Will did you not try the mysql driver for sphinx??

Amacleod: There's no internal limit at 10000 bytes in mysql driver 
(single packet default limit is 1MB). Are you using prepared statements? 
If not, are you sure that your data is correctly encoded? Anyway, 
try using TRACE mode : trace/net on. Look at the sent packets size 
to see if there's a truncation in the mysql driver.

here is the latest http://softinnov.org/tmp/mysql-protocol-41.rgive 
it a try

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

Has anyone tried to get Doc's mysql stuff to run with R3 yet?


@Doc: Do you think it can be ported/adapted to work with R3 without 
to much effort?

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).

I signed up with a web provider but they do not seem to allow remote 
direct access to the mysql db unless you specify the ip that first...which 
is no good if you have an app used by many people in any number of 
locations....


Is this standard procedure? I had the same problem with another provider.

What is the way around this? CGI?

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 think I will need to convert my app over to a cgi based access 
for mysql as I may want to access them from non-rebol based clients 
(smart phones).


Does anyone know what is the standard method for say iphones to access 
data from servers? CGI? or is there other prefered method?

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.

Have you checked whether MySQL is configured properly to accept tcp-requests 
instead of only socket-based connections?

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.

If the SKIP-NETWORKING config entry is enabled, MySQL won’t listen 
for TCP/IP connections at all. That's a security setting. All interaction 
with MySQL must then be made via Unix sockets. Whereas the mysql-driver 
only supports TCP connections. I don't no about CPanel, but look 
out for some CPanel setting like "skip networking" or alike.

What is the SOP for building json objects from MySQL queries? 

I saw this but I could not get it to work:

SELECT 
     CONCAT("[",
          GROUP_CONCAT(
               CONCAT("{username:'",username,"'"),
               CONCAT(",email:'",email),"'}")
          )
     ,"]") 
AS json FROM users;

Anyone know if  that is supported with mysql-protocol?

You are using MySQL 4.1+?

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.

Thanks, I thought there might be some Mysql command to insert column 
names with the data...

THanks for your help.

amacleod: NAME-FIELDS function might help : http://softinnov.org/rebol/mysql-usage.html#sect11.
(it works on a single record only, so you'll need to loop through 
the recordset anyway)

mysql:// question at http://synapse-ehr.com/forums/showthread.php?454-mysql-problem-what-does-this-error-mean

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

Maybe he's using an older version of the mysql driver?

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.

when you upgrade your mysql server from 4.x to 5.x the passwords 
in your "mysql" table for users stays old, which hashed a different 
algorithm.. so you cannot connect it using username/password anymore.

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.

but - I just tried that with mySQL driver and it does not work :-( 
.... it works that way with /Command though ... it is a pity there 
is not multiple command ports available in Doc's driver?

zzazouminiwebserver is definitely overkill ... php and mysql support

I'm using dyndns as I have a dynamic ip. 

If i type my url into the browser from a macine outside my local 
network I get my web page. If I do it from within my local network 
(even on a different machine) I can't not get through to the page 
"Cannot display webpage" error.

It's not just http. I'm accessing a mysql server too with the same 
problem resulting. 

I know I can use "localhost but I would need to change my code everytime 
I'm using it locally.

I'm experimenting again with mediawiki .. previously this site wouldn't 
work as the host only had an early version of mysql.  Now, that they 
have updated it, it is live!

http://compkarori.com/rebolwiki

New MySQL driver version 1.0.0 supporting servers v4.1.1+ : http://softinnov.org/tmp/mysql-protocol.r
. This is a beta release, please report in MySQL channel any bugs. 
This release has not been tested with servers v3.x (but should work).

New version of SQL-PROTOCOL is published on http://www.rebol.org/cgi-bin/cgiwrap/rebol/view-script.r?script=sql-protocol.r


This new version is a first attempt of standard SQL string parsing. 
It's limited yet to SELECT clause. INSERT, UPDATE and DELETE will 
be done soon. Previously, sql-protocol was only able to process SQL 
like dialect, the road to a better compatibility with SQL is now 
a reality. I will make it compatible with MySQL as much as possible.

New version of SQL-PROTOCOL is on www.rebol.org


This new version handle now standard SQL string for SELECT, INSERT, 
UPDATE and DELETE so you have a better compatibility with other database 
like MySQL, Oracle or ODCB protocol.

MySQL driver 1.0 released today. See http://www.softinnov.org/rebol/mysql.shtml

from DocKimbel :


MySQL driver 1.0 released today. See http://www.softinnov.org/rebol/mysql.shtml
June 12, 2006

Fix for MySQL driver released today (v1.0.7):


 o Fixes a comptability issue in handshaking with new servers using 
 old passwords format.

See http://www.softinnov.org/rebol/mysql.shtml

MySQL Driver for REBOL version 1.1.0 released.


    Changes : http://softinnov.org/rebol/mysql-usage.html#sect2.1.
    Download: http://rebol.softinnov.org/mysql/

MySQL Driver for REBOL version 1.1.0 released.


    Changes : http://softinnov.org/rebol/mysql-usage.html#sect2.1.
    Download: http://rebol.softinnov.org/mysql/

After much consideration, we've decided provide a dual license for 
Redwerks technologies similar to MySQL's licensing policy..  

If you are developing and distributing open source applications under 
the GPL License, then you are free to use Redwerks Inc. software 
under the GPL License


For OEMs, ISVs, and VARs who distribute Redwerks with their products, 
and do not license and distribute their source code under the GPL, 
Redwerks Inc. provides a flexible OEM Commercial License.


The dual - license will apply to the following Redwerks Inc.  technologies

Eco  - Our Semantic Network DBMS
Framewerks- our website creation middleware built on Eco
LFReD - our natual language intelligent agent


For more information on this, and how it relates to Rebol, check 
out the Redwerks group.

It syncs directories, and apparently also MySQL and SQLite databases 
- or it needs them for functioning

geomol,

interesting concept. It will also be interesting to see the performance 
and behavior with
different filesystems like: ZFS,REISER, NFS XFS, CFS, GFS etc.

in mysql you can choose the database engine, with nicomDB you choose 
the filesystem 

for different features. (e.g. REISER for speed, NFS for distributed 
networking, CFS/EncFS 
for crypto, GFS for cluster etc. :-) 
any aprox. date when it will be available?

The pre-release of Rebol for pros, Chapter 5 of Rebol - A programmer's 
guide is now available at http://www.lulu.com/content/2845102


It covers calling other programs and shared libraries, using MySQL 
from Rebol CGI scripts and how to manage source code with the free 
version of the Rebol pre-processor. All of these can be used from 
the latest free versions of Rebol.

MySQL driver v1.2.1 released. See more at http://softinnov.org

The preview of translation of the final chapter of Olivier Auverlot's 
Rebol - Guide du Programmeur is now available atÊhttp://www.lulu.com/content/4564589


 This final chapter consists of a number of workshops that bring together 
 much that has been covered in the book. These case studies focus 
 on the foundations to build a video game, on developing a chat program, 
 on writing a MySQL administration console, and finally on creating 
 a reblet for Rebol/IOS.


  There is still a little work left before the book can be published. 
  I hope that it won't take too long. Once the full book is published, 
  the individual preview chapters will be withdrawn from Lulu.com.


  One of the things still to be done is toÊangliciseÊthe sample scripts 
  which will then be made available for downloading.

The R3 ODBC Extension allows easy access to databases and data sources 
supporting ODBC. 


The extension supports SQL statements SELECT and INSERT, UPDATE and 
DELETE as well as catalog functions for tables, columns and types. 
It supports statement parameters and is Unicode aware. It supports 
direct and prepared execution of statements.


If you're used to the commercial REBOL/Command (or the nowadays freely 
available REBOL/View) ODBC database access methods, you should have 
no problems using the ODBC API presented here. There's next to no 
differences in functionality, it differs mostly in that the extension 
isn't used with ports, but with "ordinary" functions OPEN-DB, OPEN-SQL, 
DO-SQL, CLOSE-SQL and CLOSE-DB. This may change when it's possible 
to provide the extension as an asynchronous R3 device, since the 
ODBC functions may be blocking.  


For now, the API is implemented as an embedded host-kit extension 
(it should easily be possible to provide it as an external dll) and 
is available for the Windows platform. So far it has been tested 
with MySQL, PostgreSQL and Intersystems Caché as well as the Microsoft 
Text Driver. Of course it's supposed to work with any ODBC data source.

I was able to catch the top of the output:

I think there is an error in mysql-protocol.r
MZ has no value....

Anyone else have a problem encaping mysql-protocol.r?

Can't find a refernec to MZ in mysql-protocol or my program

#INCLUDE %"/C/Program Files/rebol/rebol-sdk/source/mezz.r"
#INCLUDE %"/C/Program Files/rebol/rebol-sdk/source/prot.r"
#INCLUDE %"/C/Program Files/rebol/rebol-sdk/source/view.r"

#INCLUDE %sqlite.r
#INCLUDE %mysql-protocol.r
;#INCLUDE %updater.r


;#INCLUDE %include.r
;#INCLUDE %window.r

;#INCLUDE %scroll-panel.r
;#INCLUDE %scroll-wheel-handler.r
#INCLUDE-binary %fd_shield.jpg
#INCLUDE-files %data [guest.db demo_template.db]
;#INCLUDE %sqlite3.dll

Having the same problem with scripts...mysql-protocol.r

** Access Error: Cannot open /C/Documents and Settings/Alan/Desktop/mysql-protocol.r
** Near: do %mysql-protocol.r
db_IP: mysql://Alan:[Stynki4-:-onfire-:-selfip-:-com]:3306/onfire
do

Its included....#INCLUDE %mysql-protocol.r

if you #INCLUDE %mysql-protocol.r than it does not mean that you 
can: do %mysql-protocol.r in your script.

sql_protocol: do #INCLUDE %mysql-protocol.r

sql_protocol: #include-block %mysql-protocol.r
...
do sql_protocol

ah, it doesn't show every time you load it: Sun has acquired MySQL.

http://www.sun.com/aboutsun/media/presskits/2008-0116/index.jsp?intcmp=hp2008jan16_mysql_learn

I could probably read a lot to get this info, but maybe someone here 
knows:

How do a company like MySQL make money? The database is open source 
and completely free, right? So do they earn by doing support? Selling 
books or what?

I pay for MySQL...

Do you know, if MySQL holds any patents?

Why pay for mysql when postgresql is better and free?

one way mysql makes money is to get Sun to fork over a billion dollars 
:)

Hmm, I wonder what happens to Open Office and MySQL then ....

Hm.. I imagine they have hard time selling Oracle if MySQL is free.. 
I wouldn't like to be mysql right now :)

I didn't know Oracle even exists in last years, and surelly not that 
they have so much $$ to buy Sun (+ MySQL )... I am not sure if they 
are very present in web-scene

They might close mySQL, but I think that the licence forbids them 
doing so. They might close further mySQL developments, but in such 
a case, I think that some ppl would fork it anyway ...

Oracle already owns the company thaat makes the InnoDB engine for 
MySQL, and that didn't kill MySQL.

the use of the external tables can probably be replaced by some SQL, 
but for some reason I find it simpler to let mysql handle autoincrementing 
and retreiving last insert id, it seems easier to support when many 
threads are inserting at the same time on the same table.

using install.r, I get the following error:

CureCode Installation...
...loading MySQL protocol
Script: "MySQL Protocol" (12-Jul-2008)
MySQL protocol loaded
...creating database
...database root Password: *******
connecting to: localhost
...access ok to database
...creating tables

** User Error: ERROR 1136 : Column count doesn't match value count 
at row 1
** Near: make error! info

or whatever mysql uses for boolean

not sure they are needed. now onto how to make curecode log into 
mysql

I'll try it out ... now where to download mysql ..

http://dev.mysql.com/downloads/mysql/5.1.html#win32

oh well, I can't help ... mysql fails to install under windows 7