Re: [WebDNA] Crashing Database
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106191
interpreted = N
texte = Is that what [thisport] does for us? return 80 for http and 443 for =https?Brian FriesBrainScan SoftwareOn 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>=20>=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 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>=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:
Is that what [thisport] does for us? return 80 for http and 443 for =https?Brian FriesBrainScan SoftwareOn 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>=20>=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 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>=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
Brian Fries
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:
F2 to F3 rocky transition (1997)
Dummy Credit Card Number for debug? (1997)
Encrypting the URL Query String (2003)
[WebDNA] Webserver does not respond occasionally (2018)
Trigger time setting (2002)
[WebDNA] Some news (2010)
WebCat2b15MacPlugin - [protect] (1997)
Not reading code (1997)
[subtotal] and others (1997)
Re2: Calculating multiple shipping... (1997)
convertwords BUG (2002)
Max Record length (1997)
WebCat2 - Getting to the browser's username/password data (1997)
shipCost not working v2.1b4 (1997)
Fun with [middle] (2002)
.html to .tpl (1998)
problems with 2 tags shakur (1997)
[WebDNA] end of file append (2017)
[WebDNA] lists opinion (2009)
Search (1997)