r3wp [groups: 83 posts: 189283]
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r3wp

[MySQL]

Henrik
6-Jun-2006
[704]
then I tried to turn them off again through the GUI and it didn't 
change.
Dockimbel
6-Jun-2006
[705]
Could you activate : trace/net on before using mysql:// and show 
me here the server information retrieved by the driver.
Henrik
6-Jun-2006
[706]
that'll take a short while, the PC that the mysql server is on has 
been taken down. :-)
Dockimbel
6-Jun-2006
[707]
Ok, I see...no problem, just post it here when you'll have the log.
Henrik
6-Jun-2006
[708]
setting it up now (need to do it anyway)
Pekr
6-Jun-2006
[709x2]
imo it is like this - when you have db created with old scheme, db 
will not automatically rebuild it for you using new method ...
it is stated somewhere in docs iirc, you have to rebuild it .... 
the thing is, that length of old-password field is limited or something 
like that ...
Henrik
6-Jun-2006
[711]
pekr, would it work the other way around as well? I thought it was 
only initial authentication that was different.
Pekr
6-Jun-2006
[712]
install from scratch
Henrik
6-Jun-2006
[713]
I didn't do that, so it must have been done with new passwords. I 
could immediately overwrite the old style password with the new style 
and it worked immediately
Pekr
6-Jun-2006
[714x2]
not sure, not having enough experience, just stating what I remember 
about it ...
ok then ...
Henrik
6-Jun-2006
[716]
another thing I experienced: The server was moved to a new location. 
For some reason, everything went FUBAR, because DNS had not been 
set up. This caused connecting to the server to take about 60 seconds 
to get through. When I looked in the list of connections, it just 
says "logging in" for that long time. I connect to the server with 
an IP address, not a host name, so what's going on?
Pekr
6-Jun-2006
[717x2]
not sure what is causing the lag. You would need to look at low level 
communication - inspecting packets in something as ethereal ...
or looking at mysql logs, if there is not something suspicious ...
Henrik
6-Jun-2006
[719]
when the server is connected, everything runs at full speed
Dockimbel
6-Jun-2006
[720]
The server may try a reverse dns request on your IP when you connect 
and ends with a timeout after 60secs.
Henrik
6-Jun-2006
[721x2]
could be that, it connects just fine now here at home
could be that <period> :-)
Dockimbel
10-Jun-2006
[723]
Good news : I've finally reached a very stable version of the mysql 
driver with v5+ servers ! The stability garanted only if using a 
database created with a v5+ server, copying old 3.x files in v5 server 
works but results in a big mess and unstable behaviour. Exporting/Importing 
v3.x data in v5 server using SQL flat files works very well (except 
for user with passwords, better recreate them in v5 directly).
Henrik
10-Jun-2006
[724]
copying old 3.x files in v5 server works but results in a big mess 
and unstable behaviour
 <--- is that because of MySQL or mysql-protocol.r?
Dockimbel
10-Jun-2006
[725x2]
MySQL, even MySQL Admin tool get lost when acting like that.
I mean running a v5 server with v3.x tables.
Henrik
10-Jun-2006
[727]
I've found numerous bugs in mysql-admin. I think this tool is not 
particularly trustworthy
Dockimbel
10-Jun-2006
[728]
I've just run a big stress test with 40'000+ requests generating 
around 2Gb of traffic without any trouble ! No bad handshakes anymore 
if you're using v5+ tables and new passwords.
Henrik
10-Jun-2006
[729]
I'm testing it over an ADSL connection now against a V5 server with 
multiple users. no trouble at all.
Dockimbel
10-Jun-2006
[730x2]
I've just uploaded v1.06 which adds support for a few missing new 
datatypes.
http://softinnov.org/tmp/mysql-protocol.r
Will
10-Jun-2006
[732]
downloading.., thank you!
james_nak
10-Jun-2006
[733x2]
Thanks!
BTW, an old question I continue to ask but how do you all handle 
checking whether a port is open or not?
Dockimbel
10-Jun-2006
[735x2]
This should work: either insert db-port [ping] [print "port opened"][print 
"port closed"]
If it is at reading data : try [copy db-port] should work too.
Henrik
10-Jun-2006
[737]
there are times when the connection to the database won't wake up 
after hours of sleep and the application locks. this also happens 
with mysql-admin, but I wonder if it really is server or a client 
side problem.
Dockimbel
10-Jun-2006
[738]
My driver should reconnect automatically is the connection is closed 
by the server when you send a new request even after hours of sleeping. 
I need to test that with a v5 server to see if it behaves as expected.
james_nak
10-Jun-2006
[739]
Thank you. With the old protocol I would sometimes get  an error 
 (and exit from the program) when I inserted into a closed port. 
I will give these a shot.
Henrik
11-Jun-2006
[740]
I can see that mysql console has no problem in reconnecting where 
rebol and mysql-admin fail
Dockimbel
11-Jun-2006
[741x4]
Doing the following test works for me (v5 server) :
1) Load the REBOL mysql console : do %mysql.r
2) Connect to the server
3) Command: show tables
4) result ok
5) Stop/Start the server
6) Command: show tables
7) result ok (the driver has reconnected transparently)
Erratum: replace the step : do %mysql.r by :
do %mysql-protocol.r
do %mysql-client.r
mysql
JaimeVargas
12-Jun-2006
[745]
Doc, any news on when will you go v1.0 with the postgress driver?
Ingo
12-Jun-2006
[746]
Great Doc!
I didn't believe you'd ever call a version worthy of 1.0 ;-)
Dockimbel
12-Jun-2006
[747]
It takes, at least, 4 for years of beta-testing to become 1.0 ;-))
Henrik
12-Jun-2006
[748]
and intense bugfixing sessions 4 days before releasing 1.0 :-)
Dockimbel
12-Jun-2006
[749]
Postgresql: Don't know, I may work on it this summer for a customer, 
so I may release new versions. I didn't had much feedback on this 
product, maybe too few users in the REBOL community...?
Graham
12-Jun-2006
[750]
was it oldes who made some fixes for the postgres driver?
Dockimbel
12-Jun-2006
[751]
If anyone got useful patches to postgres driver, please publish them 
here.
Graham
13-Jun-2006
[752x2]
posted by oldes 24 November
I like async internally, and anyway I remember I had problems with 
the non-asyns async - I think sometimes it was not able detect if 
the client closed connection or something like that, and i have my 
async version of postgres I'm using. I want new build of Core with 
async and rebocodes so much:(