Re: [WebDNA] Crashing Database
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106196
interpreted = N
texte = This is a multi-part message in MIME format. ------=_NextPart_000_002B_01CBBDA8.45647D00 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable [thisport] is a new feature of 7.0. Docs are not live just yet. -Dan From: Kenneth Grome=20 Sent: Wednesday, January 26, 2011 6:15 PM To: talk@webdna.us=20 Subject: Re: [WebDNA] Crashing Database [thisport] is not in the docs. What other tags/contexts are = undocumented? Sincerely, Kenneth Grome > Is that what [thisport] does for us? return 80 for http > and 443 for https? >=20 > Brian Fries > BrainScan Software >=20 > On Jan 26, 2011, at 4:34 PM, Stuart Tremain wrote: > > Chris > >=20 > > There have been many attempts to create an easy way to > > determine if a page is being served HTTP or HTTPS > >=20 > > Any closer with this ?? > >=20 > >=20 > > Regards > >=20 > > Stuart Tremain > > IDFK Web Developments > > AUSTRALIA > > webdna@idfk.com.au > >=20 > > 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/fee > >> ds/api/videos/-/volleyball[/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 --- > >> 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 > >> On Jan 25, 2011, at 16:22, Olin Lagon wrote: > >>> 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 > >>>> On Jan 25, 2011, at 14:35, Steve Craig wrote: > >>>>> 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: > >>>>> 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, > >>>>> christophe.billiottet@webdna.us > >>>>>=20 > >>>>> wrote: > >>>>>> 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 > >>>>>
> >>>>> . > >>>>> To unsubscribe, E-mail to: > >>>>> > >>>>>=20 > >>>>> archives: > >>>>> http://mail.webdna.us/list/talk@webdna.us > >>>>>=20 > >>>>> 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: > >>>> > >>>>=20 > >>>> archives: > >>>> http://mail.webdna.us/list/talk@webdna.us > >>>>=20 > >>>> 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 > >>=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 > >=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 >=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 --------------------------------------------------------- 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 ------=_NextPart_000_002B_01CBBDA8.45647D00 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable [thisport] is a new feature of 7.0. = Docs are not=20 live just yet.
-Dan
Sent: Wednesday, January 26, 2011 6:15 PM
Subject: Re: [WebDNA] Crashing Database
[thisport]=20 is not in the docs. What other tags/contexts are undocumented? Sincerely, Kenneth=20 Grome >=20 Is that what [thisport] does for us? return 80 for http >=20 and 443 for https? >=20 >=20 Brian Fries >=20 BrainScan Software >=20 >=20 On Jan 26, 2011, at 4:34 PM, Stuart Tremain wrote: >=20 > Chris >=20 > >=20 > There have been many attempts to create an easy way to >=20 > determine if a page is being served HTTP or HTTPS >=20 > >=20 > Any closer with this ?? >=20 > >=20 > >=20 > Regards >=20 > >=20 > Stuart Tremain >=20 > IDFK Web Developments >=20 > AUSTRALIA >=20 > webdna@idfk.com.au >=20 > >=20 > On 26/01/2011, at 6:04 AM, christophe.billiottet@webdna.us = wrote: >=20 >> There is no real new feature in 7.0. It is more a >=20 >> transition version toward the WebDNA i had in mind >=20 >> when we bought it to SmithMicro. >=20 >> >=20 >> We fixed some remaining bugs and added few things. We >=20 >> also changed the [append] tag to be much much faster. >=20 >> Here a list: >=20 >> >=20 >> >=20 >> ----- >=20 >> Fixed: The serial number validation routine fails out >=20 >> with a wrong number, and causes the page not >=20 >> reloading. ----- >=20 >> The libmysqlclient.so.15/libmysqlclient.so.16 problem >=20 >> for the glibcv3 version: Ubuntu 10.xx comes with >=20 >> libmysqlclient.so.16, and webdna.fcgi requests >=20 >> libmysqlclient.so.15 The two versions of >=20 >> libmysqlclient aren't binary compatible, which is why >=20 >> the soname was changed from 15 to 16. There is no way >=20 >> to build a single binary that works with both >=20 >> libraries. We built two binaries. ----- >=20 >> Changed: The 6.2 code always reloaded the db after 100 >=20 >> lines. We changed this for 1,000 lines on 7.0 code. >=20 >> ----- >=20 >> Fixed: the [append] tag was writing to DISK instead or >=20 >> writing to RAM. It now depends on the AutoCommit >=20 >> value in prefs. If true, it will append each line as >=20 >> before. >=20 >> If false, it will buffer in memory. >=20 >> ----- >=20 >> Fixed: the [formvariables] context bug when using >=20 >> ENCTYPE=3D"multipart/form-data": issue with the >=20 >> processing of multipart post. ----- >=20 >> Fixed: [sendmail] problem with the FreeBSD version >=20 >> beacuse of a threading problem. Fixed by forcing it >=20 >> to use libpthread instead of libc_r ----- >=20 >> Fixed: bug when the [math] variable name includes a >=20 >> number like in [math]thetest3=3D43[/math] --- >=20 >> New: added the new tag [thirurlplusget] >=20 >> >=20 >> so the [thisurl] tag will produce this: >=20 >> /x/y/z/index.dna >=20 >> >=20 >> and the [thirurlplusget] tag will produce this: >=20 >> /x/y/z/index.dna?a=3Db&c=3Dd >=20 >> --- >=20 >> New: /WebCatalog folder eliminated >=20 >> --- >=20 >> New: config file is now webdna.ini >=20 >> --- >=20 >> New: [isaccelerated] tag returns "T" or "F" >=20 >> --- >=20 >> Fixed: a local copy runs as "licensed" when called >=20 >> through 127.0.0.1 or "localhost" --- >=20 >> Fixed: triggers now work with unlicensed version >=20 >> --- >=20 >> Fixed: the triggers are not properly working >=20 >> --- >=20 >> New: added a solid blowfish code to [encrypt] >=20 >> --- >=20 >> Fixed: [returnraw] - http status codes was not working >=20 >> on all platforms due of Apache 2.0 changes in the API >=20 >> and also the WebDNA module was not accommodating all >=20 >> status codes. --- >=20 >> Fixed: [createdate] and [moddate] were being confused >=20 >> on unix machines in both the [listfiles] context and >=20 >> [fileinfo] context. --- >=20 >> Fixed: [date format=3D] was not working on all platforms >=20 >> --- >=20 >> Fixed: mysql Windows bug >=20 >> --- >=20 >> New: xalan and xerces are now integrated into the >=20 >> binary --- >=20 >> New: [thishost] shows the server name WebDNA is >=20 >> running on --- >=20 >> New: [listallcontexts] shows a list of all reserved >=20 >> context names --- >=20 >> New: [thisport] shows the port number of the server >=20 >> WebDNA is running on. --- >=20 >> Bug: xerces has some flaws under OSX. See below >=20 >> >=20 >> [xmlparse >=20 >> = var=3Dxml_var1&source=3D[url]http://gdata.youtube.com/fee >=20 >> ds/api/videos/-/volleyball[/url]][/xmlparse] [xmlnode >=20 >> ref=3Dxml_var1&path=3Dnamed:feed] >=20 >> [name]=3D[value]<br> >=20 >> [xmlnodes] >=20 >> - [name]=3D[value]<br> >=20 >> [xmlnodes] >=20 >> - [name]=3D[value]<br> >=20 >> [/xmlnodes] >=20 >> [/xmlnodes] >=20 >> [/xmlnode] >=20 >> >=20 >> A workaround is to write the WEBDNA to download the >=20 >> XML file, and then include it in the XMLParse Pseudo >=20 >> code: >=20 >> [DOWNLOAD FILE source=3Dhttp://.....] >=20 >> [XMLParse vars=3Dblah][include target >=20 >> file.xml][/XMLParse] --- >=20 >> Fixed: [setmimeheader] is now working as expected >=20 >> example: [setmimeheader >=20 >> name=3DContent-Type&value=3Dtext/xml] --- >=20 >> Fixed: [shownext] was not properly working under OSX >=20 >> with apache --- >=20 >> Fixed: PATH_TRANSLATED under OSX and Solaris >=20 >> --- >=20 >> New: [islicensed] with two values: "T" or "F". If the >=20 >> License number matches the domain, we will get a "T", >=20 >> otherwise, we get a "F" and WebDNA will run as >=20 >> freeware. --- >=20 >> Fixed: <!--HAS_WEBDNA_TAGS_ENCRYPTED_2--> was not >=20 >> working --- >=20 >> Fixed: [decrypt] could not decrypt the seed >=20 >> "TEMPLATE", for use with encrypted templates --- >=20 >> New: SMTP auth enable with [sendmail].. both a global >=20 >> setting and a over-riding local setting option (ie. >=20 >> within the [sendmail] context) --- >=20 >> Fixed: [setcookie] was not writing anymore to the >=20 >> browser. --- >=20 >> Fixed: [redirect] was not working anymore. >=20 >> --- >=20 >> Fixed: Passing a value to a page using GET like >=20 >> test.dna?thetest=3Dthisisasmalltest was just passing >=20 >> "[thetest]" in the browser: it was not interpreted >=20 >> and showed up. --- >=20 >> Fixed: Introducing an URL variable name using a >=20 >> context name was producing strange results. The >=20 >> ?text=3D bug is now checking for known contexts, and if >=20 >> it is not a known context, it does the appropriate >=20 >> thing. For example, the variable setting via GET is >=20 >> working, but the ?text=3D is blocked --- >=20 >> Fixed: [appendfile file=3Dtest.html]More >=20 >> text[/appendfile] was creating an empty file when it >=20 >> should have written "More text" in it. File >=20 >> permission of index.html was 644 --- >=20 >> Fixed: [writefile file=3Dtest.html]Some text[/writefile] >=20 >> was creating an empty file when it should have >=20 >> written "Some text" in it. File permission of >=20 >> index.html was 660 --- >=20 >> Fixed: [ipaddress] was not working anymore under OSX >=20 >> --- >=20 >> Fixed: [referrer] was showing "FastCGI" instead of the >=20 >> real refering page under OSX. --- >=20 >> Fixed: the delete command could delete items in a >=20 >> database, even when it is not allowed as a (URL) >=20 >> command. --- >=20 >> Deprecated: XML-like syntax >=20 >> Deprecated: [applescript] >=20 >> Deprecated: phone home system >=20 >> Deprecated: the URL command system >=20 >> Deprecated: sandboxes and "global" >=20 >> Deprecated: old licensing system (domain limits, >=20 >> versions=85) >=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? >=20 >>> Will this work on OSX using multiple local domains >=20 >>> (via httpd-vhosts)? I'd love to give the OSX version >=20 >>> a spin. >=20 >>> >=20 >>> Also, is there a set of instructions for CentOS? >=20 >>> >=20 >>> Thanks! Olin >=20 >>> >=20 >>> christophe.billiottet@webdna.us wrote: >=20 >>>> Sure! i mail it privately. >=20 >>>> >=20 >>>> - chris >=20 >>>> >=20 >>>> On Jan 25, 2011, at 14:35, Steve Craig wrote: >=20 >>>>> Hi Chris >=20 >>>>> >=20 >>>>> I'm just about to set up a new in-house server = for >=20 >>>>> our internal accounts and stuff. Could I try = the >=20 >>>>> version 7 please on OSX? >=20 >>>>> >=20 >>>>> Cheers >=20 >>>>> = =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 >>>>> Steve Craig - Asylum Interactive Ltd >=20 >>>>> Tel +44 1330 860550 Fax +44 1330 860880 >=20 >>>>> = =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 >>>>> http://www.asylumweb.com >=20 >>>>> >=20 >>>>> Email: >=20 >>>>> steve@asylumweb.com >=20 >>>>> >=20 >>>>> Skype: s.craig - iChat: steve.craig >=20 >>>>> = =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 >>>>> >=20 >>>>> On 25 Jan 2011, at 09:37, >=20 >>>>> christophe.billiottet@webdna.us >=20 >>>>> >=20 >>>>> wrote: >=20 >>>>>> Version 7.0 is not officially released yet: we = are >=20 >>>>>> still working on the Windows version and we = are >=20 >>>>>> in the process of raising funds to launch a >=20 >>>>>> successful marketing campaign. I will be glad = to >=20 >>>>>> provide a 7.0 version to whoever is asking for = it >=20 >>>>>> but you will be on your own to install it. = Ken >=20 >>>>>> already wrote a "manual" on how to install = WebDNA >=20 >>>>>> 7.0 with lighttpd (highly recommended if = you >=20 >>>>>> don't need apache) and the OSX install = process >=20 >>>>>> with apache is also documented. >=20 >>>>> >=20 >>>>> = --------------------------------------------------- >=20 >>>>> ------ This message is sent to you because you = are