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

World: r3wp

[!Cheyenne] Discussions about the Cheyenne Web Server

Will
3-Jun-2007
[1129x5]
for verbose either you start cheyenne with -v -vv -vvv .. or look 
at the end of cheyenne.r for these two lines:
uniserve/verbose: any [all [4 < to-integer verbosity 2] 0]
uniserve/services/httpd/verbose: 
any [verbosity 0]
uniserve/verbose: any [all [4 < to-integer verbosity 2] 0]
uniserve/services/httpd/verbose: any [verbosity 0]
sorry altme still has problem with lineendings..
Graham
3-Jun-2007
[1134x3]
changing verbose in httd.r didn't do anything.
This is Cheyenne/log/default-log ?
Must be logging to screen only
Terry
3-Jun-2007
[1137x2]
yeah, to console
are you on windows?
Will
3-Jun-2007
[1139x2]
dunno but these two lines will bypass verbose set in HTTPd.r or uniserve.r 
so becareful
nope os x
Oldes
3-Jun-2007
[1141x2]
I think there is missing default value for cookie expiration
hmm.. maybe not
Graham
3-Jun-2007
[1143]
Yeah .. windows
Terry
3-Jun-2007
[1144]
Im still not getting any cookies at all  xp FF2 ie7
Graham
3-Jun-2007
[1145]
Can you login to my server?
Terry
3-Jun-2007
[1146]
url?
Graham
3-Jun-2007
[1147x2]
http://www.compkarori.co.nz
user: dockimbel
pass: 1234
Will
3-Jun-2007
[1149]
Graham: no problem here
Graham
3-Jun-2007
[1150x3]
well, I guess you logged in okay
or someone did :)
So, cookies must be working
Terry
3-Jun-2007
[1153x2]
yeah
what I meant is cheyenne running on localhost  (winxp) is not setting 
any cookies
Graham
3-Jun-2007
[1155]
tis for  me
Will
3-Jun-2007
[1156]
may be a browser limitation, experienced same issue here depending 
on browsers, also some do not eat cookies when using ip instead of 
hostname in urls
Graham
3-Jun-2007
[1157x2]
Aren't servers supposed to send cookies with domains ?
Hmm.
Terry
3-Jun-2007
[1159]
Im guessing that using the ip would work.. haven't tried it yet.
Graham
3-Jun-2007
[1160]
Is there a possibility of using the standard sql dialect for 'do-sql 
?


eg [ {insert into table (one, two, three ) values (?,?,?)} a b c 
]
Dockimbel
3-Jun-2007
[1161x3]
it should work if your DB driver supports it, DO-SQL is just a higher 
level wrapper.
Graham: cookies specification says that if domain attribut in cookie, 
is not provided, "The default value of domain is the host name of 
the server which generated the cookie response."
Graham: it seems that I've found a bug the session expiration in 
Cheyenne, that might be the cause of your error. It's now fixed. 
I'm testing it a little more before releasing it, I'd like to fix 
the cookies issues of Brian and Terry too (one way or another, these 
issues must be related to the info Cheyenne is sending back in the 
response).
Graham
3-Jun-2007
[1164x4]
Thanks.
qry: [ {select fnames, surname, uid from users where userid = "?" 
and pass = "?" and activ = 'T'} in-user in-pass ]
			sql: do-sql 'remr qry
gives me this

Error Code :  	329
Description : 	script error !

ODBC error: Dynamic SQL Error SQL error code = -206 Column unknown 
? At line 1, column 59.
Near : 	[insert port data 
copy port
]
Where : 	do-sql

but this works;


   qry: rejoin [ "select fnames, surname, uid from users where userid 
   = '" in-user "' and pass = '" in-pass "' and activ = 'T'" ]
			sql: do-sql 'remr qry
oops  ...
ignore
Dockimbel
3-Jun-2007
[1168]
Seems that I found the guilty for the weird session cookie issues, 
need to dig up a little more to confirm the theory.
Graham
3-Jun-2007
[1169x2]
I'm seeing this after successful inserts 


{make object! [ code: 329 type: 'script id: 'bad-bad arg1: "ODBC" 
arg2: "Invalid cursor state" arg3: none near: [copy port] where: 
'do-sql ]}
where no recordset is being returned
Dockimbel
3-Jun-2007
[1171]
that's coming from the ODBC driver
Graham
3-Jun-2007
[1172x5]
Yes.
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.