World: r3wp
[!Cheyenne] Discussions about the Cheyenne Web Server
older newer | first last |
Graham 3-Jun-2007 [1173x4] | The insert is occuring okay. |
but I get this error | |
so, is cheyenne querying the database after the query expecting a response ? | |
I can bypass the error by wrapping an attempt around the sql insert | |
Dockimbel 3-Jun-2007 [1177x2] | do-sql is doing an INSERT on the database port, then a COPY on the port. Does your query only require an INSERT on the port and no COPY ? |
let me check RT's doc about that. | |
Graham 3-Jun-2007 [1179x3] | Yes, only an insert |
/remote-ip is picking up the router address .. anyway to get the actual remote ip address? | |
must be because the remote-ip appears in the logs | |
Dockimbel 3-Jun-2007 [1182x2] | if the client is behind a router and has a local IP NAT-ed by the router, no way. |
RT's documentation about databases drivers doesn't say what 'insert is supposed to return ? Could you tell me that ? | |
Graham 3-Jun-2007 [1184x2] | it returns nothing |
I never do a copy on a db-port after an insert | |
Dockimbel 3-Jun-2007 [1186] | you mean after an SQL INSERT or the REBOL 'insert ? |
Graham 3-Jun-2007 [1187] | >> insert p [ {insert into weblog (remoteip) values (?)} "127.0.0.1" ] >> copy p ** Script Error: ODBC error: Invalid cursor state ** Near: copy p |
Dockimbel 3-Jun-2007 [1188x2] | ok, I see now. |
There's a workaround until I publish the next release (later tonight), use : insert databases/remr query | |
Graham 3-Jun-2007 [1190] | Ok. |
Dockimbel 3-Jun-2007 [1191] | databases/remr is pointing to the opened port to the DB server. |
Graham 3-Jun-2007 [1192] | Cheyenne has again crashed on me .. leaving one process running. |
Dockimbel 3-Jun-2007 [1193] | same error as before ? |
Graham 3-Jun-2007 [1194x3] | No error seen. |
the other two processes just died. | |
can we log this to a local log file ? | |
Dockimbel 3-Jun-2007 [1197x3] | you should try with changing the Cheyenne.r encap header to this one : |
Encap: [no-window quiet secure none title "Cheyenne"] | |
it will work even if not encapped | |
Graham 3-Jun-2007 [1200x3] | but I'm not running encap |
oh ?? really? | |
Ok, try | |
Dockimbel 3-Jun-2007 [1203] | the 'no-window option will trigger file logging mode |
Graham 3-Jun-2007 [1204] | ahh. |
Dockimbel 3-Jun-2007 [1205] | it is tested in cheyenne.r startup code and if defined, it will try to catch all errors in a local %crash.log file |
Graham 3-Jun-2007 [1206] | Hope we aren't giving u too much work! |
Dockimbel 3-Jun-2007 [1207] | Not at all Graham, I should thank you for making a big leap forward to Cheyenne's stability and reliability. :-) |
Graham 3-Jun-2007 [1208] | :) |
Dockimbel 3-Jun-2007 [1209x3] | The session cookie problem is related to incorrect timezone calculation in cookies expire time. I'm making a fix for Cheyenne, but due to a REBOL bug on Windows (http://www.rebol.net/cgi-bin/upnews.r?view=0005), I can't find an easy solution for that platform... |
So I guess that I'll add a config option for setting the correct timezone for Windows users manually and for /Pro users, I'll support the GetTimeZoneInformation() win32 function for automatic setting. | |
Cheyenne release v0.9.12 beta. Download at http://softinnov.org/tmp/cheyenne-r0912.zip Changelog : o do-sql function improved to support RT's DB drivers. /flat refinement is supported now too. ODBC insert error fixed too. o RConsole prompt changed to "Server>" o CGI's 'path-info now returns the request URL. o Fixed a bug in RSP session destruction potentially corrupting the internal session list and giving weird results or behaviour. o Fixed a timezone computation bug that was setting incorrect expire times for session cookies, resulting in unstable behaviour. All platforms except Windows. o Small patch to parse-request-line func in HTTPd.r to be more 'mod-rewrite friendly. | |
Graham 3-Jun-2007 [1212] | Great .. and we can get to test while you sleep :) |
Will 3-Jun-2007 [1213] | global and per domain rewrite rules, http://reboot.ch/mod-rewrite.r or http://reboot.ch/mod-rewrite.r.zipalpha quality, whatch out ;-) |
btiffin 3-Jun-2007 [1214] | Doc! You da Man! Thanks muchly. |
amacleod 4-Jun-2007 [1215x2] | I'm still not having any luck runing php scripts. test.php does not produce a result...jst a blank page. |
never mind...it appears the test script is missing the "php" after the <? | |
Terry 4-Jun-2007 [1217x3] | doesnt need it |
There's some tips I posted earlier in this group | |
Nenad, proably not necessary to have a method to restart modules after modifying... simplly dumped the code into an external file, and 'do that instead. | |
Dockimbel 4-Jun-2007 [1220] | do you 'do them at each request ? |
Terry 4-Jun-2007 [1221x2] | um.. i 'do a script to handle my url-to-filename phase |
Im intercepting 404s.. and processing them through a main script that handles the DB, generates responses etc. | |
older newer | first last |