Re: [WebDNA] Crashing Database
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106190
interpreted = N
texte = Chris There have been many attempts to create an easy way to determine if a = page is being served HTTP or HTTPS Any closer with this ?? Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 26/01/2011, at 6:04 AM, christophe.billiottet@webdna.us wrote: > There is no real new feature in 7.0. It is more a transition version = toward the WebDNA i had in mind when we bought it to SmithMicro. >=20 > We fixed some remaining bugs and added few things. We also changed the = [append] tag to be much much faster. Here a list: >=20 >=20 > ----- > Fixed: The serial number validation routine fails out with a wrong = number, and causes the page not reloading. > ----- > The libmysqlclient.so.15/libmysqlclient.so.16 problem for the glibcv3 = version: > Ubuntu 10.xx comes with libmysqlclient.so.16, and webdna.fcgi requests = libmysqlclient.so.15 > The two versions of libmysqlclient aren't binary compatible, which is = why the soname was changed from 15 to 16. There is no way to build a = single binary that works with both libraries. We built two binaries. > ----- > Changed: The 6.2 code always reloaded the db after 100 lines. We = changed this for 1,000 lines on 7.0 code. > ----- > Fixed: the [append] tag was writing to DISK instead or writing to RAM. = It now depends on the AutoCommit value in prefs. > If true, it will append each line as before. > If false, it will buffer in memory. > ----- > Fixed: the [formvariables] context bug when using = ENCTYPE=3D"multipart/form-data": issue with the processing of multipart = post. > ----- > Fixed: [sendmail] problem with the FreeBSD version beacuse of a = threading problem. Fixed by forcing it to use libpthread instead of = libc_r > ----- > Fixed: bug when the [math] variable name includes a number like in = [math]thetest3=3D43[/math] > --- > New: added the new tag [thirurlplusget] >=20 > so the [thisurl] tag will produce this: > /x/y/z/index.dna >=20 > and the [thirurlplusget] tag will produce this: > /x/y/z/index.dna?a=3Db&c=3Dd > --- > New: /WebCatalog folder eliminated > --- > New: config file is now webdna.ini > --- > New: [isaccelerated] tag returns "T" or "F" > --- > Fixed: a local copy runs as "licensed" when called through 127.0.0.1 = or "localhost" > --- > Fixed: triggers now work with unlicensed version > --- > Fixed: the triggers are not properly working > --- > New: added a solid blowfish code to [encrypt] > --- > Fixed: [returnraw] - http status codes was not working on all = platforms due of Apache 2.0 changes in the API and also the WebDNA = module was not accommodating all status codes. > --- > Fixed: [createdate] and [moddate] were being confused on unix machines = in both the [listfiles] context and [fileinfo] context. > --- > Fixed: [date format=3D] was not working on all platforms > --- > Fixed: mysql Windows bug > --- > New: xalan and xerces are now integrated into the binary > --- > New: [thishost] shows the server name WebDNA is running on > --- > New: [listallcontexts] shows a list of all reserved context names > --- > New: [thisport] shows the port number of the server WebDNA is running = on. > --- > Bug: xerces has some flaws under OSX. See below >=20 > [xmlparse = var=3Dxml_var1&source=3D[url]http://gdata.youtube.com/feeds/api/videos/-/v= olleyball[/url]][/xmlparse] > [xmlnode ref=3Dxml_var1&path=3Dnamed:feed] > [name]=3D[value]
> [xmlnodes] > - [name]=3D[value]
> [xmlnodes] > - [name]=3D[value]
> [/xmlnodes] > [/xmlnodes] > [/xmlnode] >=20 > A workaround is to write the WEBDNA to download the XML file, and then = include it in the XMLParse > Pseudo code: > [DOWNLOAD FILE source=3Dhttp://.....] > [XMLParse vars=3Dblah][include target file.xml][/XMLParse] > --- > Fixed: [setmimeheader] is now working as expected > example: [setmimeheader name=3DContent-Type&value=3Dtext/xml] > --- > Fixed: [shownext] was not properly working under OSX with apache > --- > Fixed: PATH_TRANSLATED under OSX and Solaris > --- > New: [islicensed] with two values: "T" or "F". If the License number = matches the domain, we will get a "T", otherwise, we get a "F" and = WebDNA will run as freeware. > --- > Fixed: was not working > --- > Fixed: [decrypt] could not decrypt the seed "TEMPLATE", for use with = encrypted templates=20 > --- > New: SMTP auth enable with [sendmail].. both a global setting and a = over-riding local setting option (ie. within the [sendmail] context) > --- > Fixed: [setcookie] was not writing anymore to the browser. > --- > Fixed: [redirect] was not working anymore. > --- > Fixed: Passing a value to a page using GET like = test.dna?thetest=3Dthisisasmalltest was just passing "[thetest]" in the = browser: it was not interpreted and showed up. > --- > Fixed: Introducing an URL variable name using a context name was = producing strange results. The ?text=3D bug is now checking for known = contexts, and if it is not a known context, it does the appropriate = thing. For example, the variable setting via GET is working, but the = ?text=3D is blocked > --- > Fixed: [appendfile file=3Dtest.html]More text[/appendfile] was = creating an empty file when it should have written "More text" in it. = File permission of index.html was 644 > --- > Fixed: [writefile file=3Dtest.html]Some text[/writefile] was creating = an empty file when it should have written "Some text" in it. File = permission of index.html was 660 > --- > Fixed: [ipaddress] was not working anymore under OSX > --- > Fixed: [referrer] was showing "FastCGI" instead of the real refering = page under OSX. > --- > Fixed: the delete command could delete items in a database, even when = it is not allowed as a (URL) command. > --- > Deprecated: XML-like syntax > Deprecated: [applescript] > Deprecated: phone home system > Deprecated: the URL command system > Deprecated: sandboxes and "global" > Deprecated: old licensing system (domain limits, versions=85) >=20 >=20 >=20 >=20 >=20 > On Jan 25, 2011, at 16:22, Olin Lagon wrote: >=20 >> Is there a list of just new features in 7, if any? Will this work on = OSX using multiple local domains (via httpd-vhosts)? I'd love to give = the OSX version a spin. >>=20 >> Also, is there a set of instructions for CentOS? >>=20 >> Thanks! Olin >>=20 >> christophe.billiottet@webdna.us wrote: >>> Sure! i mail it privately. >>>=20 >>> - chris >>>=20 >>>=20 >>> On Jan 25, 2011, at 14:35, Steve Craig wrote: >>>=20 >>>=20 >>>> Hi Chris >>>>=20 >>>> I'm just about to set up a new in-house server for our internal = accounts and stuff. Could I try the version 7 please on OSX? >>>>=20 >>>> Cheers >>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>> Steve Craig - Asylum Interactive Ltd >>>> Tel +44 1330 860550 Fax +44 1330 860880 >>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>>=20 >>>> http://www.asylumweb.com >>>>=20 >>>> Email:=20 >>>> steve@asylumweb.com >>>>=20 >>>> Skype: s.craig - iChat: steve.craig >>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>> On 25 Jan 2011, at 09:37,=20 >>>> christophe.billiottet@webdna.us >>>> wrote: >>>>=20 >>>>=20 >>>>> Version 7.0 is not officially released yet: we are still working = on the Windows version and we are in the process of raising funds to = launch a successful marketing campaign. I will be glad to provide a 7.0 = version to whoever is asking for it but you will be on your own to = install it. Ken already wrote a "manual" on how to install WebDNA 7.0 = with lighttpd (highly recommended if you don't need apache) and the OSX = install process with apache is also documented. >>>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list=20 >>>>
>>>> . >>>> To unsubscribe, E-mail to:=20 >>>> >>>>=20 >>>> archives:=20 >>>> http://mail.webdna.us/list/talk@webdna.us >>>>=20 >>>> Bug Reporting:=20 >>>> support@webdna.us >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list=20 >>> >>> . >>> To unsubscribe, E-mail to:=20 >>> >>>=20 >>> archives:=20 >>> http://mail.webdna.us/list/talk@webdna.us >>>=20 >>> Bug Reporting:=20 >>> support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
Chris There have been many attempts to create an easy way to determine if a = page is being served HTTP or HTTPS Any closer with this ?? Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 26/01/2011, at 6:04 AM, christophe.billiottet@webdna.us wrote: > There is no real new feature in 7.0. It is more a transition version = toward the WebDNA i had in mind when we bought it to SmithMicro. >=20 > We fixed some remaining bugs and added few things. We also changed the = [append] tag to be much much faster. Here a list: >=20 >=20 > ----- > Fixed: The serial number validation routine fails out with a wrong = number, and causes the page not reloading. > ----- > The libmysqlclient.so.15/libmysqlclient.so.16 problem for the glibcv3 = version: > Ubuntu 10.xx comes with libmysqlclient.so.16, and webdna.fcgi requests = libmysqlclient.so.15 > The two versions of libmysqlclient aren't binary compatible, which is = why the soname was changed from 15 to 16. There is no way to build a = single binary that works with both libraries. We built two binaries. > ----- > Changed: The 6.2 code always reloaded the db after 100 lines. We = changed this for 1,000 lines on 7.0 code. > ----- > Fixed: the [append] tag was writing to DISK instead or writing to RAM. = It now depends on the AutoCommit value in prefs. > If true, it will append each line as before. > If false, it will buffer in memory. > ----- > Fixed: the [formvariables] context bug when using = ENCTYPE=3D"multipart/form-data": issue with the processing of multipart = post. > ----- > Fixed: [sendmail] problem with the FreeBSD version beacuse of a = threading problem. Fixed by forcing it to use libpthread instead of = libc_r > ----- > Fixed: bug when the [math] variable name includes a number like in = [math]thetest3=3D43[/math] > --- > New: added the new tag [thirurlplusget] >=20 > so the [thisurl] tag will produce this: > /x/y/z/index.dna >=20 > and the [thirurlplusget] tag will produce this: > /x/y/z/index.dna?a=3Db&c=3Dd > --- > New: /WebCatalog folder eliminated > --- > New: config file is now webdna.ini > --- > New: [isaccelerated] tag returns "T" or "F" > --- > Fixed: a local copy runs as "licensed" when called through 127.0.0.1 = or "localhost" > --- > Fixed: triggers now work with unlicensed version > --- > Fixed: the triggers are not properly working > --- > New: added a solid blowfish code to [encrypt] > --- > Fixed: [returnraw] - http status codes was not working on all = platforms due of Apache 2.0 changes in the API and also the WebDNA = module was not accommodating all status codes. > --- > Fixed: [createdate] and [moddate] were being confused on unix machines = in both the [listfiles] context and [fileinfo] context. > --- > Fixed: [date format=3D] was not working on all platforms > --- > Fixed: mysql Windows bug > --- > New: xalan and xerces are now integrated into the binary > --- > New: [thishost] shows the server name WebDNA is running on > --- > New: [listallcontexts] shows a list of all reserved context names > --- > New: [thisport] shows the port number of the server WebDNA is running = on. > --- > Bug: xerces has some flaws under OSX. See below >=20 > [xmlparse = var=3Dxml_var1&source=3D[url]http://gdata.youtube.com/feeds/api/videos/-/v= olleyball[/url]][/xmlparse] > [xmlnode ref=3Dxml_var1&path=3Dnamed:feed] > [name]=3D[value]
> [xmlnodes] > - [name]=3D[value]
> [xmlnodes] > - [name]=3D[value]
> [/xmlnodes] > [/xmlnodes] > [/xmlnode] >=20 > A workaround is to write the WEBDNA to download the XML file, and then = include it in the XMLParse > Pseudo code: > [DOWNLOAD FILE source=3Dhttp://.....] > [XMLParse vars=3Dblah][include target file.xml][/XMLParse] > --- > Fixed: [setmimeheader] is now working as expected > example: [setmimeheader name=3DContent-Type&value=3Dtext/xml] > --- > Fixed: [shownext] was not properly working under OSX with apache > --- > Fixed: PATH_TRANSLATED under OSX and Solaris > --- > New: [islicensed] with two values: "T" or "F". If the License number = matches the domain, we will get a "T", otherwise, we get a "F" and = WebDNA will run as freeware. > --- > Fixed: was not working > --- > Fixed: [decrypt] could not decrypt the seed "TEMPLATE", for use with = encrypted templates=20 > --- > New: SMTP auth enable with [sendmail].. both a global setting and a = over-riding local setting option (ie. within the [sendmail] context) > --- > Fixed: [setcookie] was not writing anymore to the browser. > --- > Fixed: [redirect] was not working anymore. > --- > Fixed: Passing a value to a page using GET like = test.dna?thetest=3Dthisisasmalltest was just passing "[thetest]" in the = browser: it was not interpreted and showed up. > --- > Fixed: Introducing an URL variable name using a context name was = producing strange results. The ?text=3D bug is now checking for known = contexts, and if it is not a known context, it does the appropriate = thing. For example, the variable setting via GET is working, but the = ?text=3D is blocked > --- > Fixed: [appendfile file=3Dtest.html]More text[/appendfile] was = creating an empty file when it should have written "More text" in it. = File permission of index.html was 644 > --- > Fixed: [writefile file=3Dtest.html]Some text[/writefile] was creating = an empty file when it should have written "Some text" in it. File = permission of index.html was 660 > --- > Fixed: [ipaddress] was not working anymore under OSX > --- > Fixed: [referrer] was showing "FastCGI" instead of the real refering = page under OSX. > --- > Fixed: the delete command could delete items in a database, even when = it is not allowed as a (URL) command. > --- > Deprecated: XML-like syntax > Deprecated: [applescript] > Deprecated: phone home system > Deprecated: the URL command system > Deprecated: sandboxes and "global" > Deprecated: old licensing system (domain limits, versions=85) >=20 >=20 >=20 >=20 >=20 > On Jan 25, 2011, at 16:22, Olin Lagon wrote: >=20 >> Is there a list of just new features in 7, if any? Will this work on = OSX using multiple local domains (via httpd-vhosts)? I'd love to give = the OSX version a spin. >>=20 >> Also, is there a set of instructions for CentOS? >>=20 >> Thanks! Olin >>=20 >> christophe.billiottet@webdna.us wrote: >>> Sure! i mail it privately. >>>=20 >>> - chris >>>=20 >>>=20 >>> On Jan 25, 2011, at 14:35, Steve Craig wrote: >>>=20 >>>=20 >>>> Hi Chris >>>>=20 >>>> I'm just about to set up a new in-house server for our internal = accounts and stuff. Could I try the version 7 please on OSX? >>>>=20 >>>> Cheers >>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>> Steve Craig - Asylum Interactive Ltd >>>> Tel +44 1330 860550 Fax +44 1330 860880 >>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>>=20 >>>> http://www.asylumweb.com >>>>=20 >>>> Email:=20 >>>> steve@asylumweb.com >>>>=20 >>>> Skype: s.craig - iChat: steve.craig >>>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>> On 25 Jan 2011, at 09:37,=20 >>>> christophe.billiottet@webdna.us >>>> wrote: >>>>=20 >>>>=20 >>>>> Version 7.0 is not officially released yet: we are still working = on the Windows version and we are in the process of raising funds to = launch a successful marketing campaign. I will be glad to provide a 7.0 = version to whoever is asking for it but you will be on your own to = install it. Ken already wrote a "manual" on how to install WebDNA 7.0 = with lighttpd (highly recommended if you don't need apache) and the OSX = install process with apache is also documented. >>>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list=20 >>>> >>>> . >>>> To unsubscribe, E-mail to:=20 >>>> >>>>=20 >>>> archives:=20 >>>> http://mail.webdna.us/list/talk@webdna.us >>>>=20 >>>> Bug Reporting:=20 >>>> support@webdna.us >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list=20 >>> >>> . >>> To unsubscribe, E-mail to:=20 >>> >>>=20 >>> archives:=20 >>> http://mail.webdna.us/list/talk@webdna.us >>>=20 >>> Bug Reporting:=20 >>> support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Stuart Tremain
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
psst (1997)
Math (1997)
Using [random] (1999)
WebCatalog 2.0 b 15 mac (1997)
Modtime bug? (2002)
taxTotal, grandTotal (1997)
MacWEEK article help needed (1996)
HomePage Caution (1997)
LDAP queries in Webcat (1999)
RE: WebCat and image maps (1997)
WebCommerce: Folder organization ? (1997)
40,000+ items = mutiple dbs? (1999)
re: date search problem (1999)
Re[2]: Price Not Appearing (2000)
[WebDNA] Record click-thrus (2008)
Emailer port change (1997)
Re1000001: Setting up shop (1997)
Protect vs Authenicate (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)
WebCat2b12--[searchstring] bug (1997)