[whups] Having configuration problems with Whups Head version.

Edwin Culp eculp@EnContacto.Net
Sun, 16 Sep 2001 11:16:13 -0700


That makes sense.  Thanks.  I'll try to add some and see what happens

Thanks,

ed
Quoting Chuck Hagenbuch <chuck@horde.org>:

| Quoting Edwin Culp <eculp@EnContacto.Net>:
| 
| > Does anyone have Whups head version working?
| 
| Yes, though not under any kind of extensive use. It sounds like you didn't 
| import the sample data - Whups by default doesn't have types or categories 
| built-in; they're all stored in the db, and without an admin interface 
| (currently missing <g>) you need something to start with.
| 
| -chuck
| 
| --
| Charles Hagenbuch, <chuck@horde.org>
| "What was and what may be lie, like children whose faces we cannot see, in
| the 
| arms of silence. All we ever have is here, now." - Ursula K. Le Guin
| 
| -- 
| Whups mailing list: http://horde.org/whups/
| Frequently Asked Questions: http://horde.org/faq/
| To unsubscribe, mail: whups-unsubscribe@lists.horde.org
| 
| 




---


>From admin@networkessence.net Date: Wed,  3 Oct 2001 04:03:11 -0500
Return-Path: <admin@networkessence.net>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 43387 invoked from network); 3 Oct 2001 09:07:51 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (216.40.211.25)
  by clark.horde.org with SMTP; 3 Oct 2001 09:07:51 -0000
Received: (from root@localhost)
	by ns.networkessence.net (8.10.2/8.10.2) id f9393Bv15878
	for whups@lists.horde.org; Wed, 3 Oct 2001 04:03:11 -0500
Received: from 65.112.179.34 ( [65.112.179.34])
	as user admin@127.0.0.1 by www.networkessence.net with HTTP;
	Wed,  3 Oct 2001 04:03:11 -0500
Message-ID: <1002099791.3bbad44f8bca7@www.networkessence.net>
Date: Wed,  3 Oct 2001 04:03:11 -0500
From: Alex L <admin@networkessence.net>
To: whups@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 65.112.179.34
Subject: Bug



Please add single quotes to the user value on line 297 of /lib/Backend/sql.php 
in the WHUPS CVS. It is currently showing:

return $this->_getAssoc("SELECT name, CONCAT(\"$base\", getvars) AS url FROM 
user_searches WHERE user = $user");

This causes errors because $user is not single quoted. The line should be:

return $this->_getAssoc("SELECT name, CONCAT(\"$base\", getvars) AS url FROM 
user_searches WHERE user = '$user'");


Thanks,

Alex Leverington
admin@networkessence.net

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From chuck@horde.org Date: Wed,  3 Oct 2001 10:06:32 -0400
Return-Path: <chuck@horde.org>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 55327 invoked from network); 3 Oct 2001 14:07:32 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by clark.horde.org with SMTP; 3 Oct 2001 14:07:32 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 8517C39DF; Wed,  3 Oct 2001 10:06:32 -0400 (EDT)
Received: from 206.243.191.252 ( [206.243.191.252])
	as user chuck@localhost by marina.horde.org with HTTP;
	Wed,  3 Oct 2001 10:06:32 -0400
Message-ID: <1002117992.3bbb1b684cb10@marina.horde.org>
Date: Wed,  3 Oct 2001 10:06:32 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: whups@lists.horde.org
References: <1002099791.3bbad44f8bca7@www.networkessence.net>
In-Reply-To: <1002099791.3bbad44f8bca7@www.networkessence.net>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [whups] Bug

Quoting Alex L <admin@networkessence.net>:

> Please add single quotes to the user value on line 297 of
> /lib/Backend/sql.php in the WHUPS CVS. It is currently showing:

Fixed in my local copy - I'll commit it when I finish the other changes I'm 
currently working on to the sql driver.

-chuck

--
"There is a river of blood between them." - A member of RAWA 
(http://www.rawa.org) on the difference between the people of Afghanistan and 
the criminal government of Afghanistan.


>From admin@networkessence.net Date: Sat,  6 Oct 2001 14:49:37 -0500
Return-Path: <admin@networkessence.net>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 56509 invoked from network); 6 Oct 2001 19:54:07 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (root@216.40.211.25)
  by clark.horde.org with SMTP; 6 Oct 2001 19:54:07 -0000
Received: (from root@localhost)
	by ns.networkessence.net (8.10.2/8.10.2) id f96JnbE01947
	for whups@lists.horde.org; Sat, 6 Oct 2001 14:49:37 -0500
Received: from 209.196.100.181 ( [209.196.100.181])
	as user admin@127.0.0.1 by www.networkessence.net with HTTP;
	Sat,  6 Oct 2001 14:49:37 -0500
Message-ID: <1002397777.3bbf60516727a@www.networkessence.net>
Date: Sat,  6 Oct 2001 14:49:37 -0500
From: Alex L <admin@networkessence.net>
To: whups@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 209.196.100.181
Subject: bug



There appears to be a problem setting ticket state, assigning a ticket, and 
setting a ticket's priority in the ticket details. It's almost there...

-Alex


(oh how I wish I didn't have work right now)

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From chuck@horde.org Date: Sat,  6 Oct 2001 16:03:33 -0400
Return-Path: <chuck@horde.org>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 56983 invoked from network); 6 Oct 2001 20:04:08 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by clark.horde.org with SMTP; 6 Oct 2001 20:04:08 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id B8C843A05; Sat,  6 Oct 2001 16:03:33 -0400 (EDT)
Received: from 192.168.0.157 ( [192.168.0.157])
	as user chuck@localhost by marina.your.mom with HTTP;
	Sat,  6 Oct 2001 16:03:33 -0400
Message-ID: <1002398613.3bbf63958a81d@marina.your.mom>
Date: Sat,  6 Oct 2001 16:03:33 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: whups@lists.horde.org
References: <1002397777.3bbf60516727a@www.networkessence.net>
In-Reply-To: <1002397777.3bbf60516727a@www.networkessence.net>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [whups] bug

Quoting Alex L <admin@networkessence.net>:

> There appears to be a problem setting ticket state, assigning a ticket, and 
> setting a ticket's priority in the ticket details. It's almost there...

Assigning is definitely broken; the user stuff is half the original whups user 
stuff and half Horde user stuff. This needs to be worked out.

State and priority both work fine for me, though.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be lie, like children whose faces we cannot see, in the 
arms of silence. All we ever have is here, now." - Ursula K. Le Guin


>From admin@networkessence.net Date: Sat,  6 Oct 2001 15:21:18 -0500
Return-Path: <admin@networkessence.net>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 57389 invoked from network); 6 Oct 2001 20:25:49 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (root@216.40.211.25)
  by clark.horde.org with SMTP; 6 Oct 2001 20:25:49 -0000
Received: (from root@localhost)
	by ns.networkessence.net (8.10.2/8.10.2) id f96KLJm03246
	for whups@lists.horde.org; Sat, 6 Oct 2001 15:21:19 -0500
Received: from 209.196.100.181 ( [209.196.100.181])
	as user admin@127.0.0.1 by www.networkessence.net with HTTP;
	Sat,  6 Oct 2001 15:21:18 -0500
Message-ID: <1002399678.3bbf67bee3ae2@www.networkessence.net>
Date: Sat,  6 Oct 2001 15:21:18 -0500
From: Alex L <admin@networkessence.net>
To: whups@lists.horde.org
References: <1002397777.3bbf60516727a@www.networkessence.net> <1002398613.3bbf63958a81d@marina.your.mom>
In-Reply-To: <1002398613.3bbf63958a81d@marina.your.mom>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 209.196.100.181
Subject: Re: [whups] bug


Keeping in mind that whups uses email to communicate assignments, should whups 
use whups users, or should whups use horde users? There are advantages and 
disadvantages of going either way?


Quoting Chuck Hagenbuch <chuck@horde.org>:

> Quoting Alex L <admin@networkessence.net>:
> 
> > There appears to be a problem setting ticket state, assigning a ticket, and
> 
> > setting a ticket's priority in the ticket details. It's almost there...
> 
> Assigning is definitely broken; the user stuff is half the original whups
> user 
> stuff and half Horde user stuff. This needs to be worked out.
> 
> State and priority both work fine for me, though.
> 
> -chuck
> 
> --
> Charles Hagenbuch, <chuck@horde.org>
> "What was and what may be lie, like children whose faces we cannot see, in
> the 
> arms of silence. All we ever have is here, now." - Ursula K. Le Guin
> 
> -- 
> Whups mailing list: http://horde.org/whups/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: whups-unsubscribe@lists.horde.org
> 




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From chuck@horde.org Date: Sat,  6 Oct 2001 16:27:53 -0400
Return-Path: <chuck@horde.org>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 57487 invoked from network); 6 Oct 2001 20:28:28 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by clark.horde.org with SMTP; 6 Oct 2001 20:28:28 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id AE3273CE6; Sat,  6 Oct 2001 16:27:53 -0400 (EDT)
Received: from 192.168.0.157 ( [192.168.0.157])
	as user chuck@localhost by marina.your.mom with HTTP;
	Sat,  6 Oct 2001 16:27:53 -0400
Message-ID: <1002400073.3bbf69497ff43@marina.your.mom>
Date: Sat,  6 Oct 2001 16:27:53 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: whups@lists.horde.org
References: <1002397777.3bbf60516727a@www.networkessence.net> <1002398613.3bbf63958a81d@marina.your.mom> <1002399678.3bbf67bee3ae2@www.networkessence.net>
In-Reply-To: <1002399678.3bbf67bee3ae2@www.networkessence.net>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [whups] bug

Quoting Alex L <admin@networkessence.net>:

> Keeping in mind that whups uses email to communicate assignments, should whups
> use whups users, or should whups use horde users? There are advantages and 
> disadvantages of going either way?

Well, we need at some point to make it possible to get the email of a horde 
user, and the point of the framework is to provide components - if Horde users 
don't work for whups, well, we should probably fix Horde users.

However, we do need to account for things like public bug systems, where anyone 
can report a bug. Maybe something like php.net's leave your email address and a 
password for editing this bug would work.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be lie, like children whose faces we cannot see, in the 
arms of silence. All we ever have is here, now." - Ursula K. Le Guin


>From admin@networkessence.net Date: Sat,  6 Oct 2001 19:10:19 -0500
Return-Path: <admin@networkessence.net>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 61965 invoked from network); 7 Oct 2001 00:14:50 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (root@216.40.211.25)
  by clark.horde.org with SMTP; 7 Oct 2001 00:14:50 -0000
Received: (from root@localhost)
	by ns.networkessence.net (8.10.2/8.10.2) id f970AKq12602
	for whups@lists.horde.org; Sat, 6 Oct 2001 19:10:20 -0500
Received: from 65.112.179.43 ( [65.112.179.43])
	as user admin@127.0.0.1 by www.networkessence.net with HTTP;
	Sat,  6 Oct 2001 19:10:19 -0500
Message-ID: <1002413419.3bbf9d6b9f4e6@www.networkessence.net>
Date: Sat,  6 Oct 2001 19:10:19 -0500
From: Alex L <admin@networkessence.net>
To: whups@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 65.112.179.43
Subject: SQL Fix



Problem in SQL backend driver for updating ticket state and priority state.

setTicketState:

Line 131 was:
$this->_query("UPDATE ticket SET state = $tostate WHERE id = $ticket_id");

and needs to be:
$this->_query("UPDATE whups_tickets SET state_id = $tostate WHERE ticket_id = 
$ticket_id");


setTicketPriority:

Line 144 was:
$this->_query("UPDATE ticket SET priority = $priority WHERE id = $ticket_id");

and needs to be:
$this->_query("UPDATE whups_tickets SET priority_id = $priority WHERE ticket_id 
= $ticket_id");


-Alex

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From admin@networkessence.net Date: Sat,  6 Oct 2001 19:43:00 -0500
Return-Path: <admin@networkessence.net>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 62321 invoked from network); 7 Oct 2001 00:47:31 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (root@216.40.211.25)
  by clark.horde.org with SMTP; 7 Oct 2001 00:47:31 -0000
Received: (from root@localhost)
	by ns.networkessence.net (8.10.2/8.10.2) id f970h0p13907
	for whups@lists.horde.org; Sat, 6 Oct 2001 19:43:00 -0500
Received: from 65.112.179.43 ( [65.112.179.43])
	as user admin@127.0.0.1 by www.networkessence.net with HTTP;
	Sat,  6 Oct 2001 19:43:00 -0500
Message-ID: <1002415380.3bbfa514205a4@www.networkessence.net>
Date: Sat,  6 Oct 2001 19:43:00 -0500
From: Alex L <admin@networkessence.net>
To: whups@lists.horde.org
References: <1002397777.3bbf60516727a@www.networkessence.net> <1002398613.3bbf63958a81d@marina.your.mom> <1002399678.3bbf67bee3ae2@www.networkessence.net> <1002400073.3bbf69497ff43@marina.your.mom>
In-Reply-To: <1002400073.3bbf69497ff43@marina.your.mom>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 65.112.179.43
Subject: Re: [whups] bug

Quoting Chuck Hagenbuch <chuck@horde.org>:

[snip]

> Well, we need at some point to make it possible to get the email of a horde
> 
> user, and the point of the framework is to provide components - if Horde
> users 
> don't work for whups, well, we should probably fix Horde users.
> 

I think that we can make it flexible without too much work. I believe there 
should be a choice between whether whups uses whups-local users for assigning 
tickets, horde-users for whups assigning, or both (via appending 
custom_user_table >> horde-users)? This would be fairly simple to implement and 
can easily be added as a setup in the config file. A little more to think about 
is that yes, while whups is a component of horde, it's also not a calendar or 
task manager, it's a public ticket system shared between users rather than 
privately maintained by an individual. So it may be approriate to use localized 
(or a choice thereof) users for whups.

> However, we do need to account for things like public bug systems, where
> anyone 
> can report a bug. Maybe something like php.net's leave your email address and
> a 
> password for editing this bug would work.

That does sound great. We don't necessary have to blindly copy php :) We could 
use a word like 'Originator' or something like that instead of 'From'. 'From' 
sounds too email-ish imo.

more thoughts:
I think that it would be good to setup a specific framework for the designation 
of 'internal' vs 'public' tickets. eg, a ticket property (sql), whether visible 
to users or not (to save landscape) that specifies whether a ticket was created 
internally or publicly. This would further provide the ability to do some 
reports on tickets and such.

All the above framework would seperate the 'Originator' completely from who the 
assignee. While they still may both be the same, the assignee can change, but 
the originator will still be notified of changes (originator can't change). 
Secondly, the 'assignee' can be added or removed from the system by preference 
if the 'user' shtuff I mentioned above would be implemented.

Thoughts and comments?

-Alex

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From admin@networkessence.net Date: Sat,  6 Oct 2001 20:00:30 -0500
Return-Path: <admin@networkessence.net>
Mailing-List: contact whups-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list whups@lists.horde.org
Received: (qmail 64347 invoked from network); 7 Oct 2001 01:05:01 -0000
Received: from www.networkessence.net (HELO ns.networkessence.net) (root@216.40.211.25)
  by clark.horde.org with SMTP; 7 Oct 2001 01:05:01 -0000
Received: (from root@localhost)
	by ns.networkessence.net (8.10.2/8.10.2) id f9710U514753
	for whups@lists.horde.org; Sat, 6 Oct 2001 20:00:30 -0500
Received: from 65.112.179.43 ( [65.112.179.43])
	as user admin@127.0.0.1 by www.networkessence.net with HTTP;
	Sat,  6 Oct 2001 20:00:30 -0500
Message-ID: <1002416430.3bbfa92e3da9d@www.networkessence.net>
Date: Sat,  6 Oct 2001 20:00:30 -0500
From: Alex L <admin@networkessence.net>
To: whups@lists.horde.org
References: <1002397777.3bbf60516727a@www.networkessence.net> <1002398613.3bbf63958a81d@marina.your.mom> <1002399678.3bbf67bee3ae2@www.networkessence.net> <1002400073.3bbf69497ff43@marina.your.mom> <1002415380.3bbfa514205a4@www.networkessence.net>
In-Reply-To: <1002415380.3bbfa514205a4@www.networkessence.net>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 65.112.179.43
Subject: Re: [whups] bug

Quoting Alex L <admin@networkessence.net>:

> Quoting Chuck Hagenbuch <chuck@horde.org>:
> 
> [snip]
> 
> > Well, we need at some point to make it possible to get the email of a
> horde
> > 
> > user, and the point of the framework is to provide components - if Horde
> > users 
> > don't work for whups, well, we should probably fix Horde users.

[snip] 

> Thoughts and comments?
> 

2 more thoughts:
- User authentication for ticket system *could* just be an email address (or 
password) - maybe that could be configurable too?

- Public users submitting tickets be required to confirm ticket creation via 
email (to filter out just a *little* bit of the lame stuff)

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/