Re: [WebDNA] Crashing Database

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106181
interpreted = N
texte = 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. We fixed some remaining bugs and added few things. We also changed the = [append] tag to be much much faster. Here a list: ----- 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] so the [thisurl] tag will produce this: /x/y/z/index.dna 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 [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] 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) 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 >>=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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  2. Re: [WebDNA] Crashing Database ("Dan Strong" 2011)
  3. Re: [WebDNA] Crashing Database ("Dan Strong" 2011)
  4. Re: [WebDNA] Crashing Database (Olin Lagon 2011)
  5. Re: [WebDNA] Crashing Database (Kenneth Grome 2011)
  6. Re: [WebDNA] Crashing Database ("Dan Strong" 2011)
  7. Re: [WebDNA] Crashing Database (William DeVaul 2011)
  8. Re: [WebDNA] Crashing Database (Kenneth Grome 2011)
  9. Re: [WebDNA] Crashing Database (Stuart Tremain 2011)
  10. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  11. Re: [WebDNA] Crashing Database (Brian Fries 2011)
  12. Re: [WebDNA] Crashing Database (Stuart Tremain 2011)
  13. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  14. Re: [WebDNA] Crashing Database ("Psi Prime Inc, Matthew A Perosi " 2011)
  15. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  16. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] Crashing Database (Olin Lagon 2011)
  18. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] Crashing Database (Steve Craig 2011)
  20. Re: [WebDNA] Crashing Database (Jeffrey Jones 2011)
  21. Re: [WebDNA] Crashing Database (christophe.billiottet@webdna.us 2011)
  22. Re: [WebDNA] Crashing Database (William DeVaul 2011)
  23. Re: [WebDNA] Crashing Database (Marc Thompson 2011)
  24. Re: [WebDNA] Crashing Database (World Wide Art 2011)
  25. Re: [WebDNA] Crashing Database (Jeffrey Jones 2011)
  26. Re: [WebDNA] Crashing Database (Kenneth Grome 2011)
  27. [WebDNA] Crashing Database (World Wide Art 2011)
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. We fixed some remaining bugs and added few things. We also changed the = [append] tag to be much much faster. Here a list: ----- 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] so the [thisurl] tag will produce this: /x/y/z/index.dna 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 [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] 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) 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 >>=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 christophe.billiottet@webdna.us

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:

Dates! (1998) [UPPERCASE] (1997) creator code (1997) Field name-subcategory (1997) Has anyone used WebCatalog with CGatePro? (2000) WebDNA-Talk Digest mode broken (1997) Need help with search title (1998) Error Log (2000) E-Mail Formatting (2000) Time to opensource? was [SMSI] WebDNA is too good to (2006) Major Security Hole (1998) [WebDNA] VPS Speed Test Result (2009) HomePage Caution (1997) New cart in ShoppingCarts (2003) Ok here is a question? (1997) How to Sort Summ data ? (1997) [WebDNA] 6.2 Sorry WebDNA server not running (2015) Fun with Dates - revisited (1997) FTP Settings (1999) Serving images from databases (1998)