World: r3wp

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?

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

try wireshark to do a tcp trace to make sure all the packets are 
getting thru

I have no problem inserting much bigger data to text fields using 
Dock's driver, thought I can't suggest anything else then wiresharking 
for debugging

Maarten: is there any news about your Sphinx stuff? Reichart "promised" 
to release it soon, that was some time ago 8)

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.

I check it out thanks, Doc.

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

Graham: no, do you? how is your experience with it?

IIRC previous version had a problem with escaping correctly {'} in 
some circumstances, that may be a cause of truncation.

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

from the changelog, " Fixed parsing bug with \\. Now expression like 
"'\\', 'wo;rd'" will be parsed correctly."

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

to communicate with sphinx.

As for waiting for Qtask to decide on their licensing ... well, enuff 
said.

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

what you work => what would work

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?

Eh??

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.

that makes no sense!!! I wrote all over my own message

I'm using my own server for now until bandwidth becomes an issue.

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?

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.

Sounds like you are not connecting to the server...try pinging it 
first. Check the port.

Shows us the code you aer using.

Is the Mysal server on your local machine? or on a hosted machine? 
Sometimes the host company will not allow you to directly acess the 
server from remote locations. You would need to access it via CGI.

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.

Caelum, instead of 'read' use 'load' when your remote client accesses 
teh cgi script. That will give you your data back in rebol blocks 
intead of text.

ChristianE, I could not find the SKIP-NETWORKING config entry anywhere 
on cpanel, but after reading some tech docs from my ISP I conclude 
they have it set to only allow database access via Unix sockets, 
so I guess I will have to live with that.

amacleod, Progress: After a lot of messing around I got that script 
working. So now I can access my databases using Rebol. NICE!

great!

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+?

I believe its 5.1.30

Ok.

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