On Tue, 26 Aug 2008, Sam Habiel wrote:
> But why would it hang in the first place?
I couldn't say. Perhaps there's a permission problem. Perhaps you might have
some very-long-running background or forgotten task?
> Would that mean that the
> transaction that is hanging will never get committed?
It should commit, assuming it ever completes. The anydbm backend has no
transaction timeout.
Richard

But why would it hang in the first place? Would that mean that the
transaction that is hanging will never get committed?
In any case, I will try mysql.
Sam
On Mon, Aug 25, 2008 at 7:28 PM, Richard Jones
<richardjones@...> wrote:
> On Tue, 26 Aug 2008, Sam Habiel wrote:
>> Using anydb. Willing to switch to others if that's the cause of the
>> problem.
>
> It most likely is - that's a single-user database. If anything holds up a
> transaction the database will be locked and other accesses will hang.
>
>
> Richard
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Roundup-users mailing list
> Roundup-users@...
> https://lists.sourceforge.net/lists/listinfo/roundup-users
>

On Tue, 26 Aug 2008, Sam Habiel wrote:
> Using anydb. Willing to switch to others if that's the cause of the
> problem.
It most likely is - that's a single-user database. If anything holds up a
transaction the database will be locked and other accesses will hang.
Richard

Using anydb. Willing to switch to others if that's the cause of the problem.
Running Debian (ubuntu); www-data already owns all folders.
Sam
On Mon, Aug 25, 2008 at 6:03 PM, John Lowry <jlowry@...> wrote:
> I had the same issue with it locking up. I had to make apache the owner
> of the db directory.
>
> Richard Jones wrote:
>> On Tue, 26 Aug 2008, Sam Habiel wrote:
>>> Additional information: after a couple of days of usage, it seems that
>>> issue editing (adding or modifying) is what freezes it.
>>>
>>> When it is frozen, the cron job to get email using round-gw cannot run.
>>
>> Hmm, it sounds like there's a deadlock accessing the database. Which backend
>> are you using?
>>
>>
>> Richard
>>
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK & win great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Roundup-users mailing list
>> Roundup-users@...
>> https://lists.sourceforge.net/lists/listinfo/roundup-users
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Roundup-users mailing list
> Roundup-users@...
> https://lists.sourceforge.net/lists/listinfo/roundup-users
>

It was actually a permissions error, at least when I made apache the
owner of the db directory it started to work. I am now a happy user.
-----Original Message-----
From: roundup-users-bounces@...
[mailto:roundup-users-bounces@...] On Behalf Of
Richard Jones
Sent: Monday, August 25, 2008 6:46 PM
To: roundup-users@...
Subject: Re: [Roundup-users] Cannot create a ticket
On Fri, 22 Aug 2008, John Lowry wrote:
> I installed and configured an instance of roundup per the 1.0
> documentation. I have it running on apache-2.2.9 with
mod_python-3.3.1.
> I have python-2.5.2 running. I can create new users, new keywords, etc
> via the web interface. What I cannot do is create a single ticket on
the
> web intereface or the email interface. I recieve the following
traceback
> when it times out on the webserver:
> "
> File
> "/usr/lib64/python2.5/site-packages/roundup/backends/back_mysql.py",
> line 512, in newid
> newid = int(self.cursor.fetchone()[0])
>
> TypeError: 'NoneType' object is unsubscriptable
> "
Are you still getting this problem? That looks like the database setup
is
incomplete - the id generating tables are missing or something? Though
you
say there's a timeout, which is odd. Sorry, but sounds like a MySQL
thing and
I'm not a MySQL user :(
Richard
------------------------------------------------------------------------
-
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Roundup-users mailing list
Roundup-users@...
https://lists.sourceforge.net/lists/listinfo/roundup-users

On Wed, 20 Aug 2008, Thomas Weber wrote:
> I've changed the classic template such that the topic field is a multi
> select:
>
> - <td>
> - <span tal:replace="structure context/topic/field" />
> - <span tal:condition="context/is_edit_ok" tal:replace="structure
> python:db.keyword.classhelp(property='topic')" /> - </td>
> + <td tal:content="structure context/topic/menu">topic</td>
> </tr>
>
> This works fine, except one issue: I can't deselect all items, i.e. if I
> have selected topic 'a', then I can unselect it in the browser with CTRL
> + click; but the change is undone when submitting the form.
That's a tricky one - the browser isn't submitting any data for the field.
Please file a bug, but I'm not sure when it will be fixed as it might be
tricky to fix.
Richard

On Fri, 22 Aug 2008, John Lowry wrote:
> I installed and configured an instance of roundup per the 1.0
> documentation. I have it running on apache-2.2.9 with mod_python-3.3.1.
> I have python-2.5.2 running. I can create new users, new keywords, etc
> via the web interface. What I cannot do is create a single ticket on the
> web intereface or the email interface. I recieve the following traceback
> when it times out on the webserver:
> "
> File
> "/usr/lib64/python2.5/site-packages/roundup/backends/back_mysql.py",
> line 512, in newid
> newid = int(self.cursor.fetchone()[0])
>
> TypeError: 'NoneType' object is unsubscriptable
> "
Are you still getting this problem? That looks like the database setup is
incomplete - the id generating tables are missing or something? Though you
say there's a timeout, which is odd. Sorry, but sounds like a MySQL thing and
I'm not a MySQL user :(
Richard

I had the same issue with it locking up. I had to make apache the owner
of the db directory.
Richard Jones wrote:
> On Tue, 26 Aug 2008, Sam Habiel wrote:
>> Additional information: after a couple of days of usage, it seems that
>> issue editing (adding or modifying) is what freezes it.
>>
>> When it is frozen, the cron job to get email using round-gw cannot run.
>
> Hmm, it sounds like there's a deadlock accessing the database. Which backend
> are you using?
>
>
> Richard
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Roundup-users mailing list
> Roundup-users@...
> https://lists.sourceforge.net/lists/listinfo/roundup-users

On Tue, 26 Aug 2008, Sam Habiel wrote:
> Additional information: after a couple of days of usage, it seems that
> issue editing (adding or modifying) is what freezes it.
>
> When it is frozen, the cron job to get email using round-gw cannot run.
Hmm, it sounds like there's a deadlock accessing the database. Which backend
are you using?
Richard

Additional information: after a couple of days of usage, it seems that
issue editing (adding or modifying) is what freezes it.
When it is frozen, the cron job to get email using round-gw cannot run.
Sam
On Sun, Aug 24, 2008 at 12:18 AM, Sam Habiel <sam.habiel@...> wrote:
> Essentially, all the you get is waiting for [hostname] in the status
> bar and nothing happens.
>
> I have no idea how to troubleshoot this. A look at the apache error
> and access logs was unenlightening.
>
> The only way to make it work again is to restart apache. Whatever I
> was trying to add as a new issue never got added.
>
> Sam
>

Essentially, all the you get is waiting for [hostname] in the status
bar and nothing happens.
I have no idea how to troubleshoot this. A look at the apache error
and access logs was unenlightening.
The only way to make it work again is to restart apache. Whatever I
was trying to add as a new issue never got added.
Sam

That solved it. Setting debug to true showed me that the first line
said "Permission denied"---all I had to do is fix permissions and it
worked.
I haven't set-up round-up email yet (have sendmail here; don't
remember how to set it up as stmp).
Sam
On Sat, Aug 23, 2008 at 1:10 AM, Thomas Weber
<thomas.weber.mail@...> wrote:
> On Fri, Aug 22, 2008 at 06:05:48PM -0700, Sam Habiel wrote:
>> Tracker::Web is at "web = http://localhost:8080/yakama/";
>>
>> roundup-admin initialise completed
>> sudo roundup-admin initialise
>> Enter tracker home: /opt/roundup/trackers/yakama
>> Admin Password:
>> Confirm:
>>
>> Server started:
>> roundup-server name=/opt/roundup/trackers/yakama
>> Roundup server started on :8080
>>
>> When I take my browser to http://localhost:8080/yakama/ I get the following:
>>
>> An error has occurred
>>
>> A problem was encountered processing your request. The tracker
>> maintainers have been notified of the problem.
>
> Depending on how you configured roundup (ie, what's in config.ini), you
> should have receivd a mail and the roundup-server process has probably
> written something to its stderr.
>
> For the beginning, showing tracebacks in the browser window might be
> helpful, see optin "debug" in config.ini.
>
> Thomas
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Roundup-users mailing list
> Roundup-users@...
> https://lists.sourceforge.net/lists/listinfo/roundup-users
>

On Fri, Aug 22, 2008 at 06:05:48PM -0700, Sam Habiel wrote:
> Tracker::Web is at "web = http://localhost:8080/yakama/";
>
> roundup-admin initialise completed
> sudo roundup-admin initialise
> Enter tracker home: /opt/roundup/trackers/yakama
> Admin Password:
> Confirm:
>
> Server started:
> roundup-server name=/opt/roundup/trackers/yakama
> Roundup server started on :8080
>
> When I take my browser to http://localhost:8080/yakama/ I get the following:
>
> An error has occurred
>
> A problem was encountered processing your request. The tracker
> maintainers have been notified of the problem.
Depending on how you configured roundup (ie, what's in config.ini), you
should have receivd a mail and the roundup-server process has probably
written something to its stderr.
For the beginning, showing tracebacks in the browser window might be
helpful, see optin "debug" in config.ini.
Thomas

I am following the installation instructions on Ubuntu. I am having a
little trouble running the web-interface from apache. I am back
tracking to use the integrated server (I will try apache once that
works), so my question is about that.
python --version: Python 2.5.2
Roundup version: 1.4.4
round-up demo works.
tracker is at /opt/roundup/trackers/yakama/
Output of sudo roundup-admin install:
Enter tracker home: /opt/roundup/trackers/yakama
WARNING: There appears to be a tracker in "/opt/roundup/trackers/yakama"!
If you re-install it, you will lose all the data!
Erase it? Y/N: Y
Templates: minimal, classic
Select template [classic]:
Back ends: anydbm, sqlite
Select backend [anydbm]:
Tracker::Web is at "web = http://localhost:8080/yakama/";
roundup-admin initialise completed
sudo roundup-admin initialise
Enter tracker home: /opt/roundup/trackers/yakama
Admin Password:
Confirm:
Server started:
roundup-server name=/opt/roundup/trackers/yakama
Roundup server started on :8080
When I take my browser to http://localhost:8080/yakama/ I get the following:
An error has occurred
A problem was encountered processing your request. The tracker
maintainers have been notified of the problem.
Any ideas?
Sam

Hi Ralf,
Thanks for the explanations. Looks like I needed to do a little more
research before calling Roundup's CSV broken :)
The issue with OpenOffice, while nothing to do with this list, is
interesting as it does look like I have tickled a bug. I will follow
that up with the OpenOffice people.
Cheers,
Craig
Ralf Schlatterbeck wrote:
> On Thu, Aug 21, 2008 at 03:30:20PM +1000, Craig Findlay wrote:
>> Hi List,
>>
>> I am trying to convert a tracker database created with an old version of
>> Roundup, into a database that works with the latest version of Roundup.
>>
>> I do not have access to the original instance of roundup that created
>> the tracker database, and there does not seem to be any way to tell what
>> version of Roundup was used by analysing the tracker files.
>
> What sort of "tracker files" do you have, just the export-files or also
> a database of some sort with one of the roundup-supported backends?
>
>> I found that the format used by export/import does not seem to bear any
>> relation to standard csv as defined in standards such as RFC 4180.
>>
>> For example, I created a test issue with the following subject:
>>
>> My ""'" test's
>>
>> and this resulted in the following csv when exported:
>>
>> "'My """"\'"" test\'s'"
> This is not the whole CSV-Line, is it?
> If it's only the encoded issue title, this is perfectly fine CSV format
> as used by Microsoft Excel. Double-Quotes are encoded by duplicating
> them. Note that Roundup stores the Python "repr" representation of the
> string when exporting (i.e., what you would write in python for
> obtaining the same string again). That's why you have the single quotes
> and the backslash-escapes for the single quotes.
>
>> I am not an expert on CSV but this seems very non standard :) This makes
>> it very difficult if not impossible to use the export/import feature of
>> Roundup for anything other than a low level backup, because presumably
>> Roundup knows how to import its own exported format correctly.
>
> Each version of roundup knows how to import its own export format. The
> format may change from one version of roundup to another, that's why
> it's not recommended to import from a version different from the one
> used for export.
>
> That said: The CSV generation in roundup is done with pythons csv
> module and the result is fairly standard csv.
>
> It's not recommended to do low-level backup with roundup export -- one
> reason is that the format may change. The main purpose of the export
> format is to export with one database backend and import into another
> thus changing the database backend.
>
>> I also found that the standard exported csv files caused OpenOffice Calc
>> to barf if I tried to open them. It gave up with a "maximum number of
>> rows has been exceeded..." error on a file with only 183 rows in it. But
>> that's another story, and very probably a bug in OpenOffice. It just
>> added to my frustration.
> Interesting. Maybe you can give us some more hints on what your CSV
> looks like?
> How did you export the files? Exporting requires that you have a version
> of roundup installed that can read the database. So is this an old
> export? Or are you doing the experiments with a new install of roundup?
>
>> Finally to my real question: Is the non-standard csv format used in
>> Roundup documented anywhere? If it is, it would help me to be able to
>> manually edit my exported tracker database, and then to be able to
>> successfully import it back into the new version of Roundup.
>
> See pythons csv module: http://docs.python.org/lib/module-csv.html
>
> Syntax of Python string literals (the result of a repr("some string") in
> python): http://docs.python.org/ref/strings.html
>
> Ralf

On Thu, Aug 21, 2008 at 2:08 PM, Ralf Schlatterbeck <rsc@...> wrote:
>
> Don't know if the standard roundup search mask supports the activity
> field -- in such a field you can enter date ranges, e.g.
>
> .-2d;. (now minus 2 days until now) etc. Full spec:
> http://roundup.sourceforge.net/doc-1.0/user_guide.html#date-properties
> Past 24 hours would be .-1d;. but you can also add absolute dates/times.
>
> So even over the web-interface you can specify date ranges to search.
Yes, yes.. that's basically what I'm doing now, I was just hoping to
write a little script that could run as a cronjob, and gather the
numbers for me everyday, and then email them to me, or something..
it's not really a big a deal.. it's just time consuming. Thanks again.
Sorry Ralph, I know you got two copies of this, I accidentally hit
Reply, instead of Reply-All
--
Joey

On Thu, Aug 21, 2008 at 01:38:45PM -0400, Joseph Kinsella wrote:
> Hello all,
>
> I am currently using roundup at my work here, and every morning I
> have to go through all of the topics, and grab numbers. (ie: how many
> issues there are, how many issues are closed, how many critical)
> Within the past 24 hours. Anyway, I came across roundup-admin in my
> searches, and I see that it can do issue searching, my question is..
> if I try to do a search by activity/date, it doesn't seem to support
> that.. Any help would be much appreciated.
Don't know if the standard roundup search mask supports the activity
field -- in such a field you can enter date ranges, e.g.
.-2d;. (now minus 2 days until now) etc. Full spec:
http://roundup.sourceforge.net/doc-1.0/user_guide.html#date-properties
Past 24 hours would be .-1d;. but you can also add absolute dates/times.
So even over the web-interface you can specify date ranges to search.
Ralf
--
Dr. Ralf Schlatterbeck Tel: +43/2243/26465-16
Open Source Consulting Fax: +43/2243/26465-23
Reichergasse 131 www: http://www.runtux.com
A-3411 Weidling email: office@...
osAlliance member email: rsc@...

I installed and configured an instance of roundup per the 1.0
documentation. I have it running on apache-2.2.9 with mod_python-3.3.1.
I have python-2.5.2 running. I can create new users, new keywords, etc
via the web interface. What I cannot do is create a single ticket on the
web intereface or the email interface. I recieve the following traceback
when it times out on the webserver:
"
Traceback (most recent call last):
File "/usr/lib64/python2.5/site-packages/roundup/cgi/client.py", line
409, in inner_main
html = self.handle_action()
File "/usr/lib64/python2.5/site-packages/roundup/cgi/client.py", line
975, in handle_action
return action_klass(self).execute()
File "/usr/lib64/python2.5/site-packages/roundup/cgi/actions.py",
line 39, in execute
return self.handle()
File "/usr/lib64/python2.5/site-packages/roundup/cgi/actions.py",
line 615, in handle
messages = self._editnodes(props, links)
File "/usr/lib64/python2.5/site-packages/roundup/cgi/actions.py",
line 425, in _editnodes
newid = self._createnode(cn, props)
File "/usr/lib64/python2.5/site-packages/roundup/cgi/actions.py",
line 480, in _createnode
return cl.create(**props)
File
"/usr/lib64/python2.5/site-packages/roundup/backends/rdbms_common.py",
line 1350, in create
newid = self.create_inner(**propvalues)
File
"/usr/lib64/python2.5/site-packages/roundup/backends/rdbms_common.py",
line 1369, in create_inner
newid = self.db.newid(self.classname)
File
"/usr/lib64/python2.5/site-packages/roundup/backends/back_mysql.py",
line 512, in newid
newid = int(self.cursor.fetchone()[0])
TypeError: 'NoneType' object is unsubscriptable
"

Community

Help

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

CountryState

JavaScript is required for this form.

I agree to receive quotes, newsletters and other information from sourceforge.net and its partners regarding IT services and products. I understand that I can withdraw my consent at any time. Please refer to our Privacy Policy or Contact Us for more details