Hi all … I’ve been attempting to get something happening from the
NetBSD pkgsrc tree (/usr/pkgsrc/devel/rt-pgsql for those on NetBSD) and
am having some problems …
The installation doesn’t seem to be particularly coherent at this point
- all I managed to get were the binaries and that was about it. No
database backend prep at all, so most of this I’ve done manually by
hunting through the Makefile and trying it out as I go along … gets me
better experienced with rt anyway … 
right now I’m stuck trying to get rtadmin to function - I’ve managed
to create the PostgreSQL schema and created the rt user and given it
all the appropriate rights, however when I run rtadmin all I get is the
following:
|tethys[~] 13v>: rtadmin
|No RT user found. Please consult your RT administrator.
… presumably this means I can’t create queues or anything like that
until I get this sorted …
Unfortunately because I’m doing things manually the FAQ doesn’t really
help since most of this stuff is already handled with ‘make install’
… where should I be looking for the cause of this problem?
/var/pkg/rt/log only contains blank files …
Malcolm Herbert This brain intentionally
mjch@mjch.net left blank
Malcolm Herbert wrote:
|tethys[~] 13v>: rtadmin
|No RT user found. Please consult your RT administrator.
Sounds like the package installer didn’t run the “insertdata” script.
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances
|Malcolm Herbert wrote:
|> |tethys[~] 13v>: rtadmin
|> |No RT user found. Please consult your RT administrator.
|
|Sounds like the package installer didn’t run the “insertdata” script.
cool - I’ll look into that … thanks
Malcolm Herbert This brain intentionally
mjch@mjch.net left blank
|Malcolm Herbert wrote:
|> |tethys[~] 13v>: rtadmin
|> |No RT user found. Please consult your RT administrator.
|
|Sounds like the package installer didn’t run the “insertdata” script.
hmmm … I tried it and got the following:
|tethys[…rt-pgsql/work.i386/rt-2-0-13] 64v#: /usr/pkg/bin/perl /usr/pkg/rt/etc/insertdata
|Checking for existing system user…not found. This appears to be a new installationCreating system user…done.
|Database handle destroyed without explicit disconnect at /usr/pkg/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 222.
|Creating ACL…16.17.18.done.
|Couldn’t load from the users database.
|Can’t call method “fetchrow” on an undefined value at /usr/pkg/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 355.
Malcolm Herbert This brain intentionally
mjch@mjch.net left blank
|Malcolm Herbert wrote:
|> |tethys[~] 13v>: rtadmin
|> |No RT user found. Please consult your RT administrator.
|
|Sounds like the package installer didn’t run the “insertdata” script.
hmmm … I tried it and got the following:
| Creating system user…done.
Looks like it partially completed, so then you have oddities your perl
libraries in.
|Database handle destroyed without explicit disconnect at /usr/pkg/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 222.
You might want to confirm that you have the latest and greatest
SearchBuilder installed (and perl mysql libs), but also whether the Users
rows for SystemUser and Nobody have been created in SQL as per the
suggested data in the etc directory. (or you could insert them yourself).
|Can’t call method “fetchrow” on an undefined value at /usr/pkg/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 355.
Bruce Campbell RIPE
Systems/Network Engineer NCC
www.ripe.net - PGP562C8B1B Operations/Security
|On Tue, 29 Oct 2002, Malcolm Herbert wrote:
|> hmmm … I tried it and got the following:
|>
|> | Creating system user…done.
|
|Looks like it partially completed, so then you have oddities your perl
|libraries in.
|
|> |Database handle destroyed without explicit disconnect at /usr/pkg/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 222.
|
|You might want to confirm that you have the latest and greatest
|SearchBuilder installed (and perl mysql libs), but also whether the Users
|rows for SystemUser and Nobody have been created in SQL as per the
|suggested data in the etc directory. (or you could insert them yourself).
OK, I seem to have gotten insertdata running and the web interface is
up too. I had difficulty in creating a new user for myself, but managed
to hack that from the SQL backend (I like being able to do that) however
I don’t seem to be able to see any queues in the web interface - I can
see the general queue using rtadmin --list-queues, however it doesn’t
appear in the queue drop-down for some reason … any ideas?
Malcolm Herbert This brain intentionally
mjch@mjch.net left blank
|OK, I seem to have gotten insertdata running and the web interface is
|up too. I had difficulty in creating a new user for myself, but managed
|to hack that from the SQL backend (I like being able to do that) however
|I don’t seem to be able to see any queues in the web interface - I can
|see the general queue using rtadmin --list-queues, however it doesn’t
|appear in the queue drop-down for some reason … any ideas?
with a bit of tweaking I answered my own question … thanks anyway …
Malcolm Herbert This brain intentionally
mjch@mjch.net left blank