Mailing List Archive: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports

[The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports

noreply at edgewall

Apr 1, 2006, 6:54 PM

Post #1 of 22 (15879 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Keywords:
---------------------------------+------------------------------------------
With apache2 2.2.0, pysqlite 2.0.7, python 2.4.2, sqlite3 3.3.4, and
trac 0.9.4 (all installed through Darwinports) on OS X 10.4.5, I'm getting
the following error (I've stripped out the date, ip and "{{{PythonHandler
trac.web.modpython_frontend}}}" from the beginning of each line for
readability):

{{{
Traceback (most recent call last):
File "/opt/local/lib/python2.4/site-packages/mod_python/apache.py", line
299, inHandlerDispatch\n result = object(req)
File "/opt/local/lib/python2.4/site-
packages/trac/web/modpython_frontend.py", line 199, in handler\n env =
get_environment(mpr, project_opts)
File "/opt/local/lib/python2.4/site-packages/trac/web/main.py", line
335, in get_environment\n return _open_environment(env_path, threaded)
File "/opt/local/lib/python2.4/site-packages/trac/web/main.py", line 51,
in _open_environment\n env_cache[env_path] = open_environment(env_path)
File "/opt/local/lib/python2.4/site-packages/trac/env.py", line 375, in
open_environment\n if env.needs_upgrade():
File "/opt/local/lib/python2.4/site-packages/trac/env.py", line 279, in
needs_upgrade\n db = self.get_db_cnx()
File "/opt/local/lib/python2.4/site-packages/trac/env.py", line 137, in
get_db_cnx\n return self.__cnx_pool.get_cnx()
File "/opt/local/lib/python2.4/site-packages/trac/db.py", line 157, in
get_cnx\n cnx = self._cnx_class(**self._args)
File "/opt/local/lib/python2.4/site-packages/trac/db.py", line 280, in
__init__\n timeout=timeout)
ProgrammingError: library routine called out of sequence
}}}

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Apr 1, 2006, 7:01 PM

Post #2 of 22 (15630 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by jberry@opendarwin.org):

Note that this bug carries on from #2196.

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Apr 1, 2006, 8:31 PM

Post #3 of 22 (15617 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by anonymous):

* cc: => gk5885@kickstyle.net

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Apr 26, 2006, 1:49 PM

Post #4 of 22 (15631 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by pbur@yahoo.com):

* cc: gk5885@kickstyle.net => gk5885@kickstyle.net, pbur@yahoo.com

Comment:

I'm seeing a similar error on linux with all pieces compiled myself except
for Apache. The of my stack looks like this, same line number in db.py:

{{{SystemError: NULL result without error in PyObject_Call}}}

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

May 10, 2006, 10:03 AM

Post #5 of 22 (15569 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by anonymous):

* cc: tim@twisty.com (added)

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

May 10, 2006, 4:08 PM

Post #6 of 22 (15549 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by anonymous):

* cc: djdavis@gmail.com (added)

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

May 14, 2006, 1:23 AM

Post #7 of 22 (15568 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by anonymous):

* cc: pumpkingod@gmail.com (added)

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

May 23, 2006, 11:01 PM

Post #8 of 22 (15483 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by anonymous):

* cc: bahamut@macstorm.org (added)

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

May 24, 2006, 12:56 AM

Post #9 of 22 (15497 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by cboos):

You should try to upgrade PySqlite to version 2.2.2,
as a lot of error code checking has been added during
the process the integration of that library into Python 2.5.

See also pysqlite:ticket:146.

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 13, 2006, 9:25 AM

Post #10 of 22 (15463 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by edbrannin@gmail.com):

* cc: edbrannin@gmail.com (added)

Comment:

I have the same problem, with PySqlite v2.2.2 (on OS X 10.4.6, with
DarwinPorts):

{{{
$ port installed
The following ports are currently installed:
apache2 @2.2.2_1 (active)
apr @1.2.7_0 (active)
apr-util @1.2.7_0 (active)
clearsilver @0.10.3_1 (active)
coreutils @5.92_0 (active)
db4 @4.3.29_0+darwin_8 (active)
expat @2.0.0_1 (active)
flex @2.5.33_0 (active)
gettext @0.14.5_1 (active)
libiconv @1.10_1+darwin_8 (active)
mod_python @3.2.8_1 (active)
neon @0.25.5_0 (active)
openssl @0.9.8b_0+darwin_8 (active)
pcre @6.6_0 (active)
perl5.8 @5.8.8_0+darwin_8 (active)
py-bsddb @2.4.3_0 (active)
py-ipython @0.7.2_0 (active)
py-readline @2.4.3_0 (active)
py-sqlite @2.2.2_0 (active)
python24 @2.4.3_1+darwin_8 (active)
readline @5.1.004_0 (active)
screen @4.0.2_1 (active)
sqlite3 @3.3.5_0+darwin_8 (active)
subversion @1.3.2_0+mod_dav_svn (active)
subversion-pythonbindings @1.3.2_0 (active)
trac @0.9.5_0 (active)
zlib @1.2.3_0 (active)
}}}

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 24, 2006, 5:39 AM

Post #11 of 22 (15456 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by Russell Hind <rhind@mac.com>):

* cc: rhind@mac.com (added)

Comment:

I have the same problem (py-sqlite 2.3.1 and trac-0.9.5). Just done a
fresh install of everything using DarwinPorts on OSX 10.4.6.

{{{
The following ports are currently installed:
apache2 @2.2.2_1 (active)
apr @1.2.7_0 (active)
apr-util @1.2.7_0 (active)
clearsilver @0.10.3_1 (active)
db4 @4.3.29_0+darwin_8 (active)
expat @2.0.0_1 (active)
flex @2.5.33_0 (active)
gettext @0.14.5_1 (active)
libiconv @1.10_1+darwin_8 (active)
mod_python @3.2.8_1 (active)
neon @0.25.5_0 (active)
openssl @0.9.8b_0+darwin_8 (active)
pcre @6.6_0 (active)
perl5.8 @5.8.8_0+darwin_8 (active)
py-bsddb @2.4.3_0 (active)
py-sqlite @2.3.1_0 (active)
python24 @2.4.3_1+darwin_8 (active)
readline @5.1.004_0 (active)
sqlite3 @3.3.5_0+darwin_8 (active)
subversion @1.3.2_0+mod_dav_svn (active)
subversion-pythonbindings @1.3.2_0 (active)
trac @0.9.5_0 (active)
zlib @1.2.3_0 (active)
}}}

Has anyone got anywhere with this yet?

Thanks

Russell

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 26, 2006, 8:45 AM

Post #12 of 22 (15448 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by Russell Hind <rhind@mac.com>):

I have now tried it under CGI and this works, so what is different when
running trac under cgi as opposed to mod_python (apart from the speed). I
will try and get fastcgi working to help solve this.

Thanks

Russell

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 27, 2006, 7:45 AM

Post #13 of 22 (15461 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by slianoglou@gmail.com):

The funny thing is that I have a complete !DarwinPorts version installed
on my !MacBook Pro ... soup to nuts, everything is pulled down from
!DarwinPorts *except* trac. I'm using the latest svn/trunk of trac, and it
works perfectly.

Anyway, it works with no hitch.

Then I've been trying to set it up in the same exact fasion on my
!PowerMac G4 but I'm getting this "out of sequence" error.

I peeked into the apache logs to see if I could uncover anything else, and
found this:
{{{
[Tue Jun 27 10:24:14 2006] [crit] (70023)This function has not been
implemented on this platform: DBD: driver for not available
[Tue Jun 27 10:24:14 2006] [crit] (70023)This function has not been
implemented on this platform: DBD: failed to initialise
}}}

Which I thought might be the problem, but when I looked back into the
apache error_log on my MBP, it was there also!

Somhow an intel vs. !PowerPC issue? I guess I'll try to compile everything
from source on my !PowerMac and see if it's not that threaded issue in
SQLite, but it'z bizzarre.

-steve

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 27, 2006, 7:09 PM

Post #14 of 22 (15442 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by anonymous):

Replying to [comment:12 slianoglou@gmail.com]:

Just as an update, I compiled everything from source pretty much as
outlined here: TracOnOsxNoFink and it all worked out.

The differences from that are that I'm using a version of apache2 (2.0.55)
that I had previously compiled and that in addition to using Python 2.3.5
that comes with Tiger, I'm also using the sqlite3 that came with Tiger.

Aslo I pretty much disregarded notes that said something to the effect of
not using the latest versions of the remainder of the required packages
... so far everything is feng shui.

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 27, 2006, 9:39 PM

Post #15 of 22 (15471 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by Russell Hind <rhind@mac.com>):

Just to say I have now set up trac to use FastCGI rather than CGI and
still all works fine, and appears to be as quick as mod_python (if not
faster) so maybe this is an option for other everyone else (easier than
re-compiling everything yourself!)

The differences I know about between the fink build that I got working and
the DarwinPorts build I could were that fink uses Apache 2.0.55 vs DP's
2.2.2, python 2.3 in fink vs 2.4 in DP, and sqlite2 in fink vs sqlite3 in
DP. Not sure about the mod_python program.

But FastCGi seems fine anyway so not worried about this now, will stick
using that. FYI: My installed ports now are:

{{{
The following ports are currently installed:
apache2 @2.2.2_1 (active)
apr @1.2.7_0 (active)
apr-util @1.2.7_0 (active)
boehmgc @6.7_0+darwin_8 (active)
clearsilver @0.10.3_1 (active)
db4 @4.3.29_0+darwin_8 (active)
expat @2.0.0_1 (active)
flex @2.5.33_0 (active)
gettext @0.14.5_1 (active)
glib2 @2.10.3_0 (active)
icu @3.4_0+darwin_8 (active)
libiconv @1.10_1+darwin_8 (active)
mod_fastcgi @2.4.2_1 (active)
mod_python @3.2.8_1 (active)
mono @1.1.15_0+darwin_8 (active)
neon @0.25.5_0 (active)
openssl @0.9.8b_0+darwin_8 (active)
pcre @6.6_0 (active)
perl5.8 @5.8.8_0+darwin_8 (active)
pkgconfig @0.20_0 (active)
py-bsddb @2.4.3_0 (active)
py-sqlite @2.3.1_0 (active)
python24 @2.4.3_1+darwin_8 (active)
readline @5.1.004_0 (active)
sqlite3 @3.3.5_0+darwin_8 (active)
subversion @1.3.2_0+mod_dav_svn (active)
subversion-pythonbindings @1.3.2_0 (active)
trac @0.9.5_0 (active)
zlib @1.2.3_0 (active)
}}}

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 28, 2006, 10:03 AM

Post #16 of 22 (15466 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by bahamut@macstorm.org):

Russell, what's your FCGI configuration, I tried this solution and it is
utterly slow compared to mod_python, and even prone to errors (like source
code appearing on Trac pages above the pages themselves, sometimes).

In any case, going around the problem isn't a good strategy in my opinion.
There is a cause to it and simply shrugging it off will just make it come
bite us later.

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jun 28, 2006, 12:44 PM

Post #17 of 22 (15460 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by Russell Hind <rhind@mac.com>):

Replying to [comment:15 bahamut@macstorm.org]:
> Russell, what's your FCGI configuration, I tried this solution and it is
utterly slow compared to mod_python, and even prone to errors (like source
code appearing on Trac pages above the pages themselves, sometimes).

I copied trac.fcgi to /opt/local/apache2/cgi-bin and added the following
lines to tell it where the environment is:

{{{
import os
os.environ['TRAC_ENV'] = "/Users/Shared/trac"
}}}

This is the relevant section from my apache config. Hope this helps.

Russell

{{{
<IfModule mod_fastcgi.c>
FastCgiIpcDir /opt/local/apache2/fastcgi
AddHandler fastcgi-script .fcgi
</IfModule>

Alias /trac_htdocs/ "/opt/local/share/trac/htdocs/"

<Directory /opt/local/share/trac/htdocs>
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>

ScriptAlias /trac /opt/local/apache2/cgi-bin/trac.fcgi

<Location /trac/login>
AuthType Basic
AuthName "Trac Wiki and Bug Tracking System"
AuthUserFile /Users/Shared/.htpasswd
Require valid-user
</Location>
}}}

--
Ticket URL: <http://projects.edgewall.com/trac/ticket/2969>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Jul 30, 2006, 4:20 AM

Post #18 of 22 (15324 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by simon-code@bvnetwork.no):

I installed using DarwinPorts on OSX 10.4.7, and have pretty much the same
installed ports as mentioned in [comment:14] - and received the same error
-- {{{ProgrammingError: library routine called out of sequence}}}.

The simple workaround is to install the source distribution instead:
1. Uninstall the py-sqlite package only without dependencies
{{{
sudo port -f uninstall py-sqlite
}}}
1. Find the source for your version from local DP distfiles
{{{/opt/local/var/db/dports/distfiles/...}}}, and uncompress it -
alternatively just grab the latest source distribution from pyslite.org.
1. Follow the simple build and install instructions at
http://initd.org/pub/software/pysqlite/doc/install-source.html
{{{
> cd ~/Desktop/pysqlite-2.3.1 (# or other relevant location)
> /opt/local/bin/python setup.py build
> sudo /opt/local/bin/python setup.py install
}}}

It is now installed as a regular Python package outside DarwinPorts, and
the error message does not appear - and mod_python works flawlessly.

Also, I use a simple wxPython-based Python shell application for much of
my interactive testing, and using that shell the same db error appeared
when I instantiated any db connection interactively (through trac or
directly). Same problem using the shell inside the SPE IDE. With source
install of py-sqlite, the GUI apps works fine as well.

The problem didn't appear earlier using plain 'Terminal Python', or when
testing with fast_cgi (as indicated from others).

Seems to indicate a DarwinPorts packaging/build/install issue as I managed
to get the same DP distribution source to work just by using simple
{{{python setup.py}}}... Likely threading is the common denominator
between apache/mod_python and a wxPython GUI app?

--
Ticket URL: <http://trac.edgewall.org/ticket/2969#comment:17>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Aug 10, 2006, 4:23 PM

Post #19 of 22 (15218 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Changes (by anonymous):

* cc: jashugan@gmail.com (added)

--
Ticket URL: <http://trac.edgewall.org/ticket/2969#comment:18>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
Trac-Tickets@lists.edgewall.com
http://lists.edgewall.com/mailman/listinfo/trac-tickets

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Sep 8, 2006, 11:57 PM

Post #20 of 22 (15153 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
--
Ticket URL: <http://trac.edgewall.org/ticket/2969>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Oct 1, 2006, 1:43 PM

Post #21 of 22 (15032 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by Russell Hind <rhind@mac.com>):

I've now upgraded through darwinports to 0.10 and can now use mod_python
again. Here is my list of installed ports and versions

Russell

{{{
apache2 @2.2.3_0 (active)
apr @1.2.7_0 (active)
apr-util @1.2.7_0 (active)
clearsilver @0.10.3_1 (active)
db4 @4.3.29_0+darwin_8 (active)
expat @2.0.0_1 (active)
flex @2.5.33_0 (active)
gettext @0.15_0 (active)
glib2 @2.12.3_0 (active)
icu @3.4.1_0+darwin_8 (active)
libiconv @1.11_0+darwin_8 (active)
lynx @2.8.5rel.2_0 (active)
mod_fastcgi @2.4.2_1 (active)
mod_python @3.2.8_1 (active)
neon @0.25.5_0 (active)
openssl @0.9.8c_0+darwin_8 (active)
pcre @6.6_0 (active)
perl5.8 @5.8.8_0+darwin_8 (active)
pkgconfig @0.21_0 (active)
py-bsddb @2.4.3_0 (active)
py-sqlite @2.3.1_0 (active)
python24 @2.4.3_1+darwin_8 (active)
readline @5.1.004_0 (active)
sqlite3 @3.3.7_0+darwin_8 (active)
subversion @1.4.0_0+mod_dav_svn (active)
subversion-pythonbindings @1.4.0_0 (active)
trac @0.10_0 (active)
zlib @1.2.3_0 (active)
}}}

--
Ticket URL: <http://trac.edgewall.org/ticket/2969#comment:19>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

Re: [The Trac Project] #2969: SQLite library routine called out of sequence, with mod_python, apache, trac, and sqlite all installed by darwinports [ In reply to ]

noreply at edgewall

Oct 3, 2006, 11:01 AM

Post #22 of 22 (14996 views)

#2969: SQLite library routine called out of sequence, with mod_python, apache,
trac, and sqlite all installed by darwinports
---------------------------------+------------------------------------------
Reporter: careo@fastmail.fm | Owner: cmlenz
Type: defect | Status: new
Priority: normal | Milestone:
Component: mod_python frontend | Version: 0.9.4
Severity: normal | Resolution:
Keywords: |
---------------------------------+------------------------------------------
Comment (by jashugan@gmail.com):

Based on Russell's comment, I have also got version 0.10 working with
mod_python through darwin ports. There was one hiccup , but other than
that everything runs fine.

--
Ticket URL: <http://trac.edgewall.org/ticket/2969#comment:20>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---