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:
WebCatalog [FoundItems] Problem - AGAIN - (1997)
WebCat2: Items xx to xx shown, etc. (1997)
[WebDNA] sem_open solved (2012)
PIXO support (1997)
[getchars] questions (1997)
Searching multiple Databases (1997)
RE: OK, here goes... (1997)
Anybody running directory indexer? (1998)
RE: New WebCatalog Version !!! (1997)
Correlating the record found with the fieldname (2000)
Tab Charactor (1997)
Dubble Sku's in a Database (1999)
Emailer Set Up (1997)
searchable list archive (1997)
[ot] Webserver monitoring (2001)
Re2: frames & carts (1997)
Rhapsody? (1997)
Possible Bug in 2.0b15.acgi (1997)
Cancel Subscription (1996)
LOOP and IF statements (1997)