netreg-users: Access denied messages after upgrade to new server

[B Thompson]

Hi

I originally installed NetReg in August last year using a version I
checked out of CVS on 2006-08-03. I succesfully installed this on the
folowing system (Redhat AS4) :-

NetReg (CVS checked out 2006-08-03)
apache 2.0.52
mod_perl 1.99
perl 5.8.5
mysql 4.1.20

I have now attempted to move my NetReg installation to a new server
running the following (Debian Etch) :-

NetReg (CVS checked out 2006-08-03)
apache 2.2.3
mod_perl 2.0.2
perl 5.8.8
mysql 5.0.32

I used mysqldump to copy the database and I have managed to get the
system mostly up and running but I am getting certain access denied
messages as shown here :-

[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl: /home/netreg/lib/CMU/Netdb/auth.pm:2573 :>get_user_admin_status row: 1, at /home/netreg/lib/CMU/Netdb/auth.pm line 2573., referer:
https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl: /home/netreg/lib/CMU/Netdb/auth.pm:2563 :>CMU::Netdb::get_user_admin_status: SELECT G.id, U.flags, referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl: FROM        credentials AS C, referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl:   LEFT JOIN users AS U ON C.user = U.id, referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl:   LEFT JOIN memberships AS M ON M.uid = U.id, referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl:   LEFT JOIN groups AS G on G.id = M.gid, referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl: WHERE C.authid = 'bt4' AND, referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl:       (G.name like 'netreg:%' OR, referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl:        FIND_IN_SET('suspend', U.flags)), referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg
[Fri Feb 09 10:16:17 2007] [error] [client 144.32.226.84] [Fri Feb  9 10:16:17 2007] netreg.pl: /home/netreg/lib/CMU/Netdb/auth.pm:2573 :>get_user_admin_status row: 1, at /home/netreg/lib/CMU/Netdb/auth.pm line 2573., referer: https://netreg.york.ac.uk/bin/netreg.pl?op=mach_reg

Please could anyone advise what might have gone wrong here?

Thanks

-- 

Ben Thompson
University of York