1.3.64 & postgres & scrips


#1

Hello rt-users,

I’ve installed rt, and everything seems to be working fine (create
tickets, see them, etc) except that when I use the WebUI (the only
way I’ve tried) to create scrips for a queue, they don’t seem to get
stored in the DB.

If I create a scrip, results show that the scrip was added to the
queue, but the scrips web-page doesn’t display the newly created
scrip (or any others for that matter.) Also, using psql on rt2, and
doing a Select * on scrips; returns 0 records. (Select * from users,
templates, etc. does return records)

I’ve poked around in the log files (rt.log’s, perl-access_log,
perl_error_log, messages, syslog), and I can’t find any indications
of errors.

Are there some other logs that I can enable/view to catch the
problem, or is this a know issue, or perhaps I’m just too new at RT
to understand how scrips are supposed to work.

Thanks for any help…

Best regards,
Chay Wesley mailto:chay@ci.danville.ky.us
MIS Director
City of Danville, Kentucky


#2

Are you doing this as you or as root?
The fact that it’s returning success and still not working concerns me
and I’ll try to have a look at it tonight.

Thanks,
-jesseOn Thu, Mar 29, 2001 at 04:18:15PM -0500, Chay Wesley wrote:

Hello rt-users,

I’ve installed rt, and everything seems to be working fine (create
tickets, see them, etc) except that when I use the WebUI (the only
way I’ve tried) to create scrips for a queue, they don’t seem to get
stored in the DB.

If I create a scrip, results show that the scrip was added to the
queue, but the scrips web-page doesn’t display the newly created
scrip (or any others for that matter.) Also, using psql on rt2, and
doing a Select * on scrips; returns 0 records. (Select * from users,
templates, etc. does return records)

I’ve poked around in the log files (rt.log’s, perl-access_log,
perl_error_log, messages, syslog), and I can’t find any indications
of errors.

Are there some other logs that I can enable/view to catch the
problem, or is this a know issue, or perhaps I’m just too new at RT
to understand how scrips are supposed to work.

Thanks for any help…


Best regards,
Chay Wesley mailto:chay@ci.danville.ky.us
MIS Director
City of Danville, Kentucky


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.


#3

Jesse,

I’ve seen the same error using the latest build on mysql. It appears to
only happen when you don’t select all three pull-down items on the web page.
(In my case, I only chose Condition and Action, omitting Template.)
Selecting all three items works fine.

-Joe Bossalini

on 3/29/01 5:01 PM, Jesse at jesse@fsck.com wrote:


#4

Ah. ok. that makes it much clearer. I’ll try to clean this up
when I get home tonight.On Thu, Mar 29, 2001 at 05:14:09PM -0600, Joe Bossalini wrote:

Jesse,

I’ve seen the same error using the latest build on mysql. It appears to
only happen when you don’t select all three pull-down items on the web page.
(In my case, I only chose Condition and Action, omitting Template.)
Selecting all three items works fine.

-Joe Bossalini

on 3/29/01 5:01 PM, Jesse at jesse@fsck.com wrote:

Are you doing this as you or as root?
The fact that it’s returning success and still not working concerns me
and I’ll try to have a look at it tonight.

Thanks,
-jesse

On Thu, Mar 29, 2001 at 04:18:15PM -0500, Chay Wesley wrote:

Hello rt-users,

I’ve installed rt, and everything seems to be working fine (create
tickets, see them, etc) except that when I use the WebUI (the only
way I’ve tried) to create scrips for a queue, they don’t seem to get
stored in the DB.

If I create a scrip, results show that the scrip was added to the
queue, but the scrips web-page doesn’t display the newly created
scrip (or any others for that matter.) Also, using psql on rt2, and
doing a Select * on scrips; returns 0 records. (Select * from users,
templates, etc. does return records)

I’ve poked around in the log files (rt.log’s, perl-access_log,
perl_error_log, messages, syslog), and I can’t find any indications
of errors.

Are there some other logs that I can enable/view to catch the
problem, or is this a know issue, or perhaps I’m just too new at RT
to understand how scrips are supposed to work.

Thanks for any help…


Best regards,
Chay Wesley mailto:chay@ci.danville.ky.us
MIS Director
City of Danville, Kentucky


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

After all, it’s not every day you meet up with an evil power
-M. Bulgakov


#5

Hello all,

For what it’s worth, I am making a choice in all 3 drop-downs.

I was initially running this as me (not root). I’ve since tried it as
root, and it worked correctly. Then to satisfy my curiosity, I tried
it again as me and it didn’t work correctly.

I’ve had a look at my user rights, and within that queue, I have every
option selected for my user.

-Chay Wesley

Ah. ok. that makes it much clearer. I’ll try to clean this up
when I get home tonight.

Jesse,

I’ve seen the same error using the latest build on mysql. It appears to
only happen when you don’t select all three pull-down items on the web page.
(In my case, I only chose Condition and Action, omitting Template.)
Selecting all three items works fine.

-Joe Bossalini

on 3/29/01 5:01 PM, Jesse at jesse@fsck.com wrote:

Are you doing this as you or as root?
The fact that it’s returning success and still not working concerns me
and I’ll try to have a look at it tonight.

Thanks,
-jesse

Hello rt-users,

I’ve installed rt, and everything seems to be working fine (create
tickets, see them, etc) except that when I use the WebUI (the only
way I’ve tried) to create scrips for a queue, they don’t seem to get
stored in the DB.

If I create a scrip, results show that the scrip was added to the
queue, but the scrips web-page doesn’t display the newly created
scrip (or any others for that matter.) Also, using psql on rt2, and
doing a Select * on scrips; returns 0 records. (Select * from users,
templates, etc. does return records)

I’ve poked around in the log files (rt.log’s, perl-access_log,
perl_error_log, messages, syslog), and I can’t find any indications
of errors.

Are there some other logs that I can enable/view to catch the
problem, or is this a know issue, or perhaps I’m just too new at RT
to understand how scrips are supposed to work.

Thanks for any help…


Best regards,
Chay Wesley mailto:chay@ci.danville.ky.us
MIS Director
City of Danville, Kentucky


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

After all, it’s not every day you meet up with an evil power
-M. Bulgakov

Best regards,
Chay mailto:chay@ci.danville.ky.us