Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108152
interpreted = N
texte = If the test works, it means you can write files inside your directory, = so, no permission problems (at least for this directory) I understand you use full path from your server root to link your = databases. This is most probably the problem. You should link your = databases from the file that requests access to them. About the test, your total is 33 seconds. A Mac Mini core i7 takes 20s = with "Only commit databases to disk when instructed" and 25s with = "Automatically commit databases to disk after modification" - chris On Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote: > Hi Chris, >=20 > No error messages from WebDNA and I am quite sure my paths are = correct. The only place where I could be a bit unsure is my virtual = config... anyone care to validate (code below form my = httpd-vhosts.conf)... >=20 >=20 > ---- >=20 >=20 > And the results... >=20 > Variables > Text Variables - Set an increasing # into a text variable 10000 times > 00:00:05 > Let's do some math: sin(x), 0
00:00:00 > =20 > Database Manipulation > Open a database (2 fields), append 10000 records 00:00:02 > Now 40000 searches with [lookup] 00:00:02 > 10000 searches with [search] 00:00:18 > Delete the records 00:00:06 >=20 > ------ >=20 >=20 >=20 >=20 > NameVirtualHost *:80 >=20 > > ServerAdmin xxx@xxx.dk > DocumentRoot /Library/WebServer/Documents/www.macnyt.dk > ServerName macnyt.dk > ServerAlias www.macnyt.dk > DirectoryIndex index.html index.dna index.tpl default.tpl > ErrorLog /private/var/log/apache2/a.macnyt-error_log > CustomLog /private/var/log/apache2/a.macnyt-access_log common >=20 > #----------------------- > > RewriteEngine on > RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] > > #----------------------- >=20 > >=20 > > ServerAdmin xxx@xxx.dk > DocumentRoot /Library/WebServer/Documents/b.qt.dk > ServerName qt.dk > ServerAlias b.qt.dk > DirectoryIndex index.html index.dna index.tpl > ErrorLog /private/var/log/apache2/b.qt.dk-error_log > CustomLog /private/var/log/apache2/b.qt-access_log common >=20 > #----------------------- > > RewriteEngine on > RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] > > #----------------------- >=20 > >=20 >=20 >=20 >=20 > On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote: >=20 >> Hi Palle! does WebDNA returns an error message? are your paths = correct? is the folder that contains your database has proper = permissions? >>=20 >> Try to run this small speed test >>=20 >> >>=20 >> It writes a new database, appends 10,000 records and search it via = lookup and search, then deletes the records. Play with the preferences = "Only commit databases to disk when instructed" and "Automatically = commit databases to disk after modification" to see the differences. >>=20 >> - chris >>=20 >> On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote: >>=20 >>> Ho all, >>>=20 >>> I have just migrated a site from a v6.2 server to a v7 server. Until = now everything seems to work just fine and that positive. >>>=20 >>> When I use ...webdna/Admin/AdminPrefs.dna and change setting within = WebDNA, the DB's are changes accordingly. But when I change any of my = own DB's with my site code nothing happens; at all !!! >>>=20 >>> Could this be a misconfiguration of some kind like within the = http-vhost.conf or any where else? I am a bit puzzled and a bit tired = (read: confused). >>>=20 >>> Any help or push in a right direction would be sooooo nice right = now... >>>=20 >>> By the way. WebDNA databases and my own databases has the same = rights... >>>=20 >>> /Palle--------------------------------------------------------- >>> 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 >=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:
If the test works, it means you can write files inside your directory, = so, no permission problems (at least for this directory) I understand you use full path from your server root to link your = databases. This is most probably the problem. You should link your = databases from the file that requests access to them. About the test, your total is 33 seconds. A Mac Mini core i7 takes 20s = with "Only commit databases to disk when instructed" and 25s with = "Automatically commit databases to disk after modification" - chris On Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote: > Hi Chris, >=20 > No error messages from WebDNA and I am quite sure my paths are = correct. The only place where I could be a bit unsure is my virtual = config... anyone care to validate (code below form my = httpd-vhosts.conf)... >=20 >=20 > ---- >=20 >=20 > And the results... >=20 > Variables > Text Variables - Set an increasing # into a text variable 10000 times > 00:00:05 > Let's do some math: sin(x), 0 00:00:00 > =20 > Database Manipulation > Open a database (2 fields), append 10000 records 00:00:02 > Now 40000 searches with [lookup] 00:00:02 > 10000 searches with [search] 00:00:18 > Delete the records 00:00:06 >=20 > ------ >=20 >=20 >=20 >=20 > NameVirtualHost *:80 >=20 > > ServerAdmin xxx@xxx.dk > DocumentRoot /Library/WebServer/Documents/www.macnyt.dk > ServerName macnyt.dk > ServerAlias www.macnyt.dk > DirectoryIndex index.html index.dna index.tpl default.tpl > ErrorLog /private/var/log/apache2/a.macnyt-error_log > CustomLog /private/var/log/apache2/a.macnyt-access_log common >=20 > #----------------------- > > RewriteEngine on > RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] > > #----------------------- >=20 > >=20 > > ServerAdmin xxx@xxx.dk > DocumentRoot /Library/WebServer/Documents/b.qt.dk > ServerName qt.dk > ServerAlias b.qt.dk > DirectoryIndex index.html index.dna index.tpl > ErrorLog /private/var/log/apache2/b.qt.dk-error_log > CustomLog /private/var/log/apache2/b.qt-access_log common >=20 > #----------------------- > > RewriteEngine on > RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] > > #----------------------- >=20 > >=20 >=20 >=20 >=20 > On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote: >=20 >> Hi Palle! does WebDNA returns an error message? are your paths = correct? is the folder that contains your database has proper = permissions? >>=20 >> Try to run this small speed test >>=20 >> >>=20 >> It writes a new database, appends 10,000 records and search it via = lookup and search, then deletes the records. Play with the preferences = "Only commit databases to disk when instructed" and "Automatically = commit databases to disk after modification" to see the differences. >>=20 >> - chris >>=20 >> On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote: >>=20 >>> Ho all, >>>=20 >>> I have just migrated a site from a v6.2 server to a v7 server. Until = now everything seems to work just fine and that positive. >>>=20 >>> When I use ...webdna/Admin/AdminPrefs.dna and change setting within = WebDNA, the DB's are changes accordingly. But when I change any of my = own DB's with my site code nothing happens; at all !!! >>>=20 >>> Could this be a misconfiguration of some kind like within the = http-vhost.conf or any where else? I am a bit puzzled and a bit tired = (read: confused). >>>=20 >>> Any help or push in a right direction would be sooooo nice right = now... >>>=20 >>> By the way. WebDNA databases and my own databases has the same = rights... >>>=20 >>> /Palle--------------------------------------------------------- >>> 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 >=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
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:
Not really WebCat (1997)
Zip Code Lookups (1999)
Quit revisited (1997)
[OT] Mom's gift (2006)
Date or time comparisons have bugs ... (1998)
alternatives for WebDNA (2004)
WebCat Emailer & Liststar (1997)
RE: IIS4b2 and WebCatalog b19 (1997)
creator code (1997)
Uh...can someone help me out with the b10? (1997)
&fieldsdir=ra truely random?? (2000)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Search in 2 or more catalogs (1997)
PayFlow Pro - Changing the Amount that was Authorized (2003)
Multiple Passwords (1997)
Associative lookup style? (1997)
WebDNA on Intel Mac? (2006)
validatin on NT (sorry for the dups and etc) (1998)
Formulas.db (2003)
Project 2 (1998)