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 = 108158
interpreted = N
texte = Hi Chris,I have individual copies of WebDNA (the folder and files) on both =websites and even one at root level which is not used./PalleOn 21/01/2012, at 22.49, christophe.billiottet@webdna.us wrote:> About your vhost configuration, it looks fine>=20> Do you have individual copies of WebDNA in your 2 websites and did you =write this in your httpd.conf>=20>
> /Library/WebServer/Documents/www.macnyt.dk/WebDNA/WebDNA.fcgi =-idle-timeout 60 -processes 1> /Library/WebServer/Documents/b.qt.dk/WebDNA/WebDNA.fcgi -idle-timeout =60 -processes 1> Action webdna-fastcgi /WebDNA/WebDNA.fcgi=20> AddHandler webdna-fastcgi .dna> >=20> - chris>=20>=20>=20> On Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote:>=20>> 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 records00:00:02>> Now 40000 searches with [lookup]00:00:02>> 10000 searches with [search]00:00:18>> Delete the records00: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>=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:
Hi Chris,I have individual copies of WebDNA (the folder and files) on both =websites and even one at root level which is not used./PalleOn 21/01/2012, at 22.49, christophe.billiottet@webdna.us wrote:> About your vhost configuration, it looks fine>=20> Do you have individual copies of WebDNA in your 2 websites and did you =write this in your httpd.conf>=20> > /Library/WebServer/Documents/www.macnyt.dk/WebDNA/WebDNA.fcgi =-idle-timeout 60 -processes 1> /Library/WebServer/Documents/b.qt.dk/WebDNA/WebDNA.fcgi -idle-timeout =60 -processes 1> Action webdna-fastcgi /WebDNA/WebDNA.fcgi=20> AddHandler webdna-fastcgi .dna> >=20> - chris>=20>=20>=20> On Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote:>=20>> 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 records00:00:02>> Now 40000 searches with [lookup]00:00:02>> 10000 searches with [search]00:00:18>> Delete the records00: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>=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
Palle Bo Nielsen
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:
sorting question... (2001)
WebCAT has the devil in it! (2003)
[subtotal] and others (1997)
[ListFiles] context & alias (1997)
Threaded Discussion (1998)
Major bug report on rootbeer (1997)
why is this line in GeneralStore? (1998)
Date stamp and purging (1998)
please anybody help (2005)
Am I going senile? (Price recalc based on quantity) (1997)
Using Plug-In while running 1.6.1 (1997)
UPPERCASE (1997)
For those of you not on the WebCatalog Beta... (1997)
Press Release hit the NewsWire!!! (1997)
WebCat with WebTen (1998)
Webcat & MySQL Stored Procedures question -again (2005)
[WebDNA] XML Help please (2009)
Bug alert! (1997)
emailer setup (1997)
Credit Card Number checking (1997)