Re: [AOLSERVER] AOL + SQLite+nsproxy question
Hello! On Sunday 01 March 2009 04:37:44 Don Baccus wrote: nspostgres works fine with both aolserver 4.0.10 and 4.5. It's used in production at education sites with tens of thousands of users running aolserver/postgres-based e-learning software. AOL Server 4.5 doesn't work with PostgreSQL 8.1 on my debian etch and lenny boxes. May be it works with PostgreSQL 8.3, I don't know. I think this is problem of debian AOL Server build or PostgreSQL build. So Jeff's suggestion of rebuilding against 4.5 is a good one. What kind of datatype errors are you getting in PG 8.3 in debian lenny? I use PG 8.3 w/o problems, but must admit I've built mine from source. offline1=# select '1'=1; ?column? -- t (1 row) offline1=# select avalue('a 1','a'); avalue 1 (1 row) offline1=# select avalue('a 1','a')=1; ERROR: operator does not exist: text = integer As I did find in google the problem is resolved in PostgreSQL trunk but debian lenny build doesn't fixed now. Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
Hello! On Saturday 28 February 2009 21:35:21 Tom Jackson wrote: There is an nsdb module nssqlite3. Here is the readme: http://junom.com/gitweb/gitweb.perl?p=aolserver.git;a=blob;f=nssqlite3/READ ME;hb=HEAD There are a lot of modules in the repository but some ot these are old and may be not-supported. Are these tested with AOL 4.0/4.5/4.6? Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
On Sun, 2009-03-01 at 13:02 +0300, Alexey Pechnikov wrote: Hello! On Sunday 01 March 2009 04:37:44 Don Baccus wrote: nspostgres works fine with both aolserver 4.0.10 and 4.5. It's used in production at education sites with tens of thousands of users running aolserver/postgres-based e-learning software. AOL Server 4.5 doesn't work with PostgreSQL 8.1 on my debian etch and lenny boxes. May be it works with PostgreSQL 8.3, I don't know. I think this is problem of debian AOL Server build or PostgreSQL build. Talk to debian if you didn't build both. This list is for helping you roll your own, once debian rolls their own, how it works, or doesn't is their issue. As far are I know every version of postgreSQL works with every version of AOLserver. On your datatype problem below, what is the problem? Why would you care about such a failure? And why not ask on a postgreSQL list, or a debian list when you have problems with their software? You'll get a lot more help from the people who actually produced the software you think doesn't work. So Jeff's suggestion of rebuilding against 4.5 is a good one. What kind of datatype errors are you getting in PG 8.3 in debian lenny? I use PG 8.3 w/o problems, but must admit I've built mine from source. offline1=# select '1'=1; ?column? -- t (1 row) offline1=# select avalue('a 1','a'); avalue 1 (1 row) offline1=# select avalue('a 1','a')=1; ERROR: operator does not exist: text = integer As I did find in google the problem is resolved in PostgreSQL trunk but debian lenny build doesn't fixed now. Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
On Sun, 2009-03-01 at 14:06 +0300, Alexey Pechnikov wrote: Hello! On Saturday 28 February 2009 21:35:21 Tom Jackson wrote: There is an nsdb module nssqlite3. Here is the readme: http://junom.com/gitweb/gitweb.perl?p=aolserver.git;a=blob;f=nssqlite3/README There are a lot of modules in the repository but some ot these are old and may be not-supported. Are these tested with AOL 4.0/4.5/4.6? No reason to believe the available modules don't work. AOLserver has a very stable API, things usually continue to work. tom jackson -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
Hello! On Sunday 01 March 2009 04:37:44 Don Baccus wrote: nspostgres works fine with both aolserver 4.0.10 and 4.5. It's used in production at education sites with tens of thousands of users running aolserver/postgres-based e-learning software. Please see http://groups.google.com/group/aolserver/browse_thread/thread/5d0b1d740b2e064b and http://www.google.com/search?hl=enq=nspostgres+received+fatal+signal+11btnG=Search nspostgres doesn't work as you can see. Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
On Mar 1, 2009, at 9:21 AM, Tom Jackson wrote: On your datatype problem below, what is the problem? Why would you care about such a failure? And why not ask on a postgreSQL list, or a debian list when you have problems with their software? Tom ... chill. He just mentioned a datatype problem in passing, to explain his use of PG 8.1 not 8.3. I asked what datatype problem? out of curiousity, and he answered. Chill. Don Baccus http://donb.photo.net http://birdnotes.net http://openacs.org -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
On Mar 1, 2009, at 9:45 AM, Alexey Pechnikov wrote: nspostgres doesn't work as you can see Huh. Tell that to those of us using it w/o problems. Don Baccus http://donb.photo.net http://birdnotes.net http://openacs.org -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
On Mar 1, 2009, at 9:45 AM, Alexey Pechnikov wrote: http://www.google.com/search?hl=enq=nspostgres+received+fatal +signal+11btnG=Search nspostgres doesn't work as you can see. I know for a fact that Iuri, the last person who shows up for that search, got it working and in fact has used it in a development project in which I was mentoring him. Don Baccus http://donb.photo.net http://birdnotes.net http://openacs.org -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
On 3/1/09 6:06 AM, Alexey Pechnikov wrote: There are a lot of modules in the repository but some ot these are old and may be not-supported. Are these tested with AOL 4.0/4.5/4.6? I suspect that individual sites are using and testing various configurations, but there's no official QA team for AOLserver (we're always looking for volunteers!) ... if folks who have tested particular configurations would like to share their experiences with everyone, please feel free to post details and information on the wiki and/or send information to this mailing list! -- Dossy Shiobara | do...@panoptic.com | http://dossy.org/ Panoptic Computer Network | http://panoptic.com/ He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on. (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
Hello! On Sunday 01 March 2009 21:05:30 Don Baccus wrote: http://www.google.com/search?hl=enq=nspostgres+received+fatal +signal+11btnG=Search nspostgres doesn't work as you can see. I know for a fact that Iuri, the last person who shows up for that search, got it working and in fact has used it in a development project in which I was mentoring him. I did find advise to set pgbin variable in config but this didn't help. ns_section ns/db/driver/postgres ns_parampgbin /usr/lib/postgresql/8.1/bin/psql AOL 4.0.10 + nspostgres work fine. But AOL 4.5 + nspostgres (I did try to use versions nspostgres compiled for AOL 4.0 and 4.5) doesn't work. There is AOL log: [01/Mar/2009:20:49:09][746.3057605520][-conn:1-] Notice: dbinit: sql(127.0.0.1:5000:offline1): 'select count(*) as count fromnotice.messages where not is_send and user_id=2954 and type='user'' [01/Mar/2009:20:49:09][746.3057744784][-conn:0-] Notice: Querying 'select count(*) as count from notice.messages where not is_send and user_id=2955 and type='user';' [01/Mar/2009:20:49:09][746.3057744784][-conn:0-] Notice: dbinit: sql(127.0.0.1:5000:offline1): 'select count(*) as count fromnotice.messages where not is_send and user_id=2955 and type='user'' [01/Mar/2009:20:49:11][746.3057605520][-conn:1-] Fatal: received fatal signal 11 Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
Alexey, don't use binaries of drivers compiled for 4.0.* with 4.5.* and vice versa; this can easily lead to crashes. Make as well sure, that all involved binaries are compiled against the same version of tcl. nspostgres does work with 4.0.10 and 4.5.0 and 4.5.1 with all recent versions of postgres. We use it in 20+ installations without any problems. -gustaf neumann Alexey Pechnikov schrieb: Hello! On Sunday 01 March 2009 21:05:30 Don Baccus wrote: http://www.google.com/search?hl=enq=nspostgres+received+fatal +signal+11btnG=Search nspostgres doesn't work as you can see. I know for a fact that Iuri, the last person who shows up for that search, got it working and in fact has used it in a development project in which I was mentoring him. I did find advise to set pgbin variable in config but this didn't help. ns_section ns/db/driver/postgres ns_parampgbin /usr/lib/postgresql/8.1/bin/psql AOL 4.0.10 + nspostgres work fine. But AOL 4.5 + nspostgres (I did try to use versions nspostgres compiled for AOL 4.0 and 4.5) doesn't work. There is AOL log: [01/Mar/2009:20:49:09][746.3057605520][-conn:1-] Notice: dbinit: sql(127.0.0.1:5000:offline1): 'select count(*) as count fromnotice.messages where not is_send and user_id=2954 and type='user'' [01/Mar/2009:20:49:09][746.3057744784][-conn:0-] Notice: Querying 'select count(*) as count from notice.messages where not is_send and user_id=2955 and type='user';' [01/Mar/2009:20:49:09][746.3057744784][-conn:0-] Notice: dbinit: sql(127.0.0.1:5000:offline1): 'select count(*) as count fromnotice.messages where not is_send and user_id=2955 and type='user'' [01/Mar/2009:20:49:11][746.3057605520][-conn:1-] Fatal: received fatal signal 11 Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
Hello! On Monday 02 March 2009 01:24:08 Gustaf Neumann wrote: don't use binaries of drivers compiled for 4.0.* with 4.5.* and vice versa; this can easily lead to crashes. Make as well sure, that all involved binaries are compiled against the same version of tcl. nspostgres does work with 4.0.10 and 4.5.0 and 4.5.1 with all recent versions of postgres. We use it in 20+ installations without any problems. Driver compiled for same AOL version. May be this problem is continues exec problem. There is exec command above in same ADP page but AOL doesn't creashed on exec command exactly. I did comment exec and page is generated. On refresh nsd is crashed again but there are a few dozen active users and nsd may be crashed by exec in other script. Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
There is an nsdb module nssqlite3. Here is the readme: http://junom.com/gitweb/gitweb.perl?p=aolserver.git;a=blob;f=nssqlite3/README;hb=HEAD You can get the module code out of sourceforge, or from the git repo above. tom jackson On Sat, 2009-02-28 at 19:12 +0300, Alexey Pechnikov wrote: Hello! Is sqlite-tcl in an nsproxy pool the best solution? I’m use SQLite in all my projects and AOL Server in all web projects and it’s important for me to optimize this. P.S. Is there how-to for nsproxy newbies? And nsrpc is very interesting especially for send requests from external applications to AOL Server clusters. I didn’t find manuals and how-to for these. Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
Hello! On Saturday 28 February 2009 21:35:21 Tom Jackson wrote: There is an nsdb module nssqlite3. Here is the readme: http://junom.com/gitweb/gitweb.perl?p=aolserver.git;a=blob;f=nssqlite3/READ ME;hb=HEAD Link doesn't work. You can get the module code out of sourceforge, or from the git repo above. I did try to use nssqlite module but get segmentation fault errors. In AOL server 4.0.10 # tail -f /var/log/aolserver4/offline.sid.mobigroup.ru.log “db_foreach “select value from session” { alloc: invalid block: 0xb4cf5378: 78 b4 20 AOL server 4.5 doesn't work with PostgreSQL (nspostgres module produce segmentation faults of AOL) and I can't use this. I did read code nspostgres and didn't find any problems... but this code doesn't work. I'm work with PostgreSQL 8.1 because PostgreSQL 8.3 in debian lenny has datatype errors. And now I'm use native sqlite module and it's work fine with both AOL 4.0.10 and 4.5. Dossy did advise me to try nsproxy module but I can't find examples of usage and manuals. Best regards. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
Alexey Pechnikov wrote: I did try to use nssqlite module but get segmentation fault errors. In AOL server 4.0.10 # tail -f /var/log/aolserver4/offline.sid.mobigroup.ru.log “db_foreach “select value from session” { alloc: invalid block: 0xb4cf5378: 78 b4 20 AOL server 4.5 doesn't work with PostgreSQL (nspostgres module produce segmentation faults of AOL) and I can't use this. I did read code nspostgres and didn't find any problems... but this code doesn't work. I'm work with PostgreSQL 8.1 because PostgreSQL 8.3 in debian lenny has datatype errors. Did you rebuild nspostgres against 4.5 (or better yet, cvs HEAD)? I'm fairly certain that I've used nspostgres with 4.5. I also recall fixing at least one segfault in nssqlite3, although that had to do with releasing a handle that had never been selected on. Or in other words, make sure you're using the cvs HEAD version on that too. -J -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] AOL + SQLite+nsproxy question
On Feb 28, 2009, at 3:59 PM, Jeff Rogers wrote: Alexey Pechnikov wrote: I did try to use nssqlite module but get segmentation fault errors. In AOL server 4.0.10 # tail -f /var/log/aolserver4/offline.sid.mobigroup.ru.log “db_foreach “select value from session” { alloc: invalid block: 0xb4cf5378: 78 b4 20 AOL server 4.5 doesn't work with PostgreSQL (nspostgres module produce segmentation faults of AOL) and I can't use this. I did read code nspostgres and didn't find any problems... but this code doesn't work. I'm work with PostgreSQL 8.1 because PostgreSQL 8.3 in debian lenny has datatype errors. Did you rebuild nspostgres against 4.5 (or better yet, cvs HEAD)? I'm fairly certain that I've used nspostgres with 4.5. nspostgres works fine with both aolserver 4.0.10 and 4.5. It's used in production at education sites with tens of thousands of users running aolserver/postgres-based e-learning software. So Jeff's suggestion of rebuilding against 4.5 is a good one. What kind of datatype errors are you getting in PG 8.3 in debian lenny? I use PG 8.3 w/o problems, but must admit I've built mine from source. Don Baccus http://donb.photo.net http://birdnotes.net http://openacs.org -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.